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;
}
}
}
} |
[SimpleXML] Mise à jour de la base de données
Répondre avec citation
Partager