From e2f3715b6a2fe71654ff0856b2cbd95880d07304 Mon Sep 17 00:00:00 2001 From: Ludovic Pouzenc Date: Sat, 17 Dec 2016 22:42:26 +0100 Subject: api : implement eCampaign webservices : automatic mobile number export --- api/export_ecampaign_genxml.php | 80 +++++++++++++++++++++++++++++++++++++++++ 1 file changed, 80 insertions(+) create mode 100644 api/export_ecampaign_genxml.php (limited to 'api/export_ecampaign_genxml.php') diff --git a/api/export_ecampaign_genxml.php b/api/export_ecampaign_genxml.php new file mode 100644 index 0000000..6d0d137 --- /dev/null +++ b/api/export_ecampaign_genxml.php @@ -0,0 +1,80 @@ + + * Copyright 2016 Cyril Gousse + * + * 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 . +**/ + +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(''); + +$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(); -- cgit v1.1