1 files changed, 80 insertions, 0 deletions
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 @@
+<?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();