<?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();