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 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105
| $message = new SimpleXMLElement($fluxXml);
//------------------- EXEMPLE EXTRAIRE login&pass--------------------------------------
echo '<strong>availability</strong><br>';
foreach ($message->authentication as $character) {
echo '- login: '.$character['login'].' - Pass: '.$character['password'].'<br>';
}
include_once 'connect.php';
mysql_select_db($dbname, $conn);
$sqlp ="SELECT jo_jomres_partenaire.login, jo_jomres_partenaire.pass
FROM jo_jomres_partenaire ";
$req = mysql_query($sqlp)or die(mysql_error());
$datalog = mysql_fetch_assoc($req);
if($datalog['login']=$character['login'] and ($datalog['pass']=$character['password'])) {
echo '<strong>Bon test login & pass</strong><br>';
}
//------------------- EXEMPLE EXTRAIRE hotelID -----------------------------------------------
echo '<strong>hotelID</strong><br>';
foreach ($message->inventoryUpdate as $character) {
$hotelid=$character['hotelId'];
echo '- hotel Id: '.$character['hotelId'].' <br>';
}
//------------------- EXEMPLE EXTRAIRE room ID -----------------------------------------------
echo '<strong>room ID</strong><br>';
foreach ($message->inventoryUpdate->room as $rooms) {
$chid=$rooms['id'];
echo '- room Id: '.$rooms['id'].' <br>';
//------------------- EXEMPLE EXTRAIRE availability -----------------------------------------------
echo '<strong>availability</strong><br>';
foreach($rooms->inventory->availability as $character) {
echo '- From: '.$character['from'].' - To: '.$character['to'].' - Quantity: '.$character['quantity'].'<br>';
$qte=$character['quantity'];
$from=$character['from'];
$to=$character['to'];
list($y,$m,$d)=explode('-',$from);
list($yt,$mt,$dt)=explode('-',$to);
$timefrom=mktime(0,0,0,$m,$d,$y);
$timeto=mktime(0,0,0,$mt,$dt,$yt);
$xtable='jo_jomres_schedule_'.$hotelid;
echo 'xtable';
for($ii=$timefrom;$ii<=$timeto;$ii+=86400){
$dateam=date('Y-m-d',$ii);
//Condition Si Existe dans la base de donnees
$res=mysql_query("select * from ".$xtable." WHERE room_uid = ".$chid." and jour = '".$dateam."'") or die("<br/><br/>".mysql_error());
if(mysql_num_rows($res) == 1){
//SI Resultat OUI : METTRE UPDATE
//mysql_query("UPDATE ".$xtable." SET jour = '".$dateam."', nbr_dispo= ".$qte." WHERE room_uid = ".$chid." and jour = '".$dateam."'");
}
//SI Resultat NON : INSERTION
//if(mysql_num_rows($res) == 0){
// mysql_query("Insert ...");
//}
}
//------------------- EXEMPLE EXTRAIRE RATE -----------------------------------------------
foreach ($rooms->rate as $rates) {
switch((string) $rates['rateName']) {
case 'Best Available Rate':
echo '- currency '.$rates['currency'].' - rateCode: '.$rates['rateCode'].' - rateName: '.$rates['rateName'].'<br>';
echo $rates, '<br> <strong>Best Available Rate</strong>';
foreach ($rates->planning as $character) {
echo '<br>- From: '.$character['from'].' - To: '.$character['to'].' - minimumStay: '.$character['minimumStay'].'- unitPrice: '.$character['unitPrice'].'- noArrival: '.$character['noArrival'].'<br>';
}
break;
case 'Package Offer':
echo '- currency '.$rates['currency'].' - rateCode: '.$rates['rateCode'].' - rateName: '.$rates['rateName'].'<br>';
echo $rates, '<br> <strong>Package Offer</strong>';
foreach ($rates->planning as $character) {
echo '<br>- From: '.$character['from'].' - To: '.$character['to'].' - minimumStay: '.$character['minimumStay'].'- unitPrice: '.$character['unitPrice'].'- noArrival: '.$character['noArrival'].'<br>';
}
break;
case 'Public Price':
echo '- currency '.$rates['currency'].' - rateCode: '.$rates['rateCode'].' - rateName: '.$rates['rateName'].'<br>';
echo $rates, '<br> <strong>Public Price</strong>';
foreach ($rates->planning as $character) {
echo '<br>- From: '.$character['from'].' - To: '.$character['to'].' - minimumStay: '.$character['minimumStay'].'- unitPrice: '.$character['unitPrice'].'- noArrival: '.$character['noArrival'].'<br>';
}
break;
}
}
}
} |
Partager