1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
|
<?php
/**
* Copyright 2016 Ludovic Pouzenc <ludovic@pouzenc.fr>
* Copyright 2016 Cyril Gousse <contact@cyril.fr>
*
* This file is part of CHD Gestion.
*
* CHD Gestion is free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* CHD Gestion is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with CHD Gestion. If not, see <http://www.gnu.org/licenses/>.
**/
include_once('inc/config.php');
$mysqli = new mysqli($db_config['host'], $db_config['username'], $db_config['password'], $db_config['database']);
if (mysqli_connect_errno()) {
die(mysqli_connect_error());
}
unset($db_config);
$mysqli->set_charset("utf8") or die($mysqli->error);
function parse_phone($number){
$number = str_replace(
array(' ', '-', '.', '+'),
'', $number);
if( substr($number, 0, 2) == '33' && strlen($number) == 11 ){
return substr($number, 2);
}
elseif( substr($number, 0, 1) == '0' && strlen($number) == 10 ){
return substr($number, 1);
}
else return '';
}
$xml = new SimpleXMLElement('<?xml version="1.0" encoding="UTF-8"?><groupMembers/>');
$sql = "SELECT * FROM v_adt_sms;";
$res = $mysqli->query($sql);
$i=0;
while ( $row = $res->fetch_assoc() ) {
$member = $xml->addChild('member');
$infos = $member->addChild('adh');
$infos->addChild('value', $row['id']);
$infos = $member->addChild('mobile1');
$mob1 = parse_phone($row['tel_mobile1']);
if( $mob1 != '' ){
$infos->addChild('indicatif', '33');
$infos->addChild('value', $mob1);
}
$infos = $member->addChild('mobile2');
$mob2 = parse_phone($row['tel_mobile2']);
if( $mob2 != '' ){
$infos->addChild('indicatif', '33');
$infos->addChild('value', $mob2);
}
$infos = $member->addChild('mail_contact');
$infos->addChild('value', $row['mail_contact']);
$infos = $member->addChild('relais');
$infos->addChild('value', $row['relais']);
$i++;
}
header('Content-Type: text/xml');
echo $xml->asXML();
|
