01.
....
02.
03.
function
get_all_pay_booking_historyXML(){
04.
if
(!is_login())
exit
;
05.
06.
$customer_id
=
$_SESSION
[
'customer'
][
'customer_id'
];
07.
08.
09.
$query
= mysql_query(
"SELECT commission FROM setting WHERE setting_id= 1"
);
10.
$commission
= mysql_result(
$query
, 0);
11.
$commission_multiply
= (100 -
$commission
) / 100;
12.
13.
14.
$dom
=
new
DOMDocument(
"1.0"
,
"utf-8"
);
15.
$pay_booking
=
$dom
->createElement(
'pay_booking'
);
16.
17.
$query
= mysql_query(
"SELECT * FROM booking LEFT JOIN customerpayment USING(booking_id) WHERE customer_id= $customer_id AND !ISNULL(payment_datetime)"
);
18.
while
(
$row
= mysql_fetch_array(
$query
) ){
19.
20.
$query3
= mysql_query(
"SELECT * FROM bookingroom LEFT JOIN room USING(room_id) LEFT JOIN roomtype USING(roomtype_id) WHERE booking_id= "
.
$row
[
'booking_id'
]);
21.
$room_count
= mysql_num_rows(
$query3
);
22.
23.
$booking_id
=
$dom
->createElement(
'booking_id'
,
$row
[
'booking_id'
]);
24.
$booking_code
=
$dom
->createElement(
'booking_code'
,
'B'
.
substr
(
'000'
.
$row
[
'booking_id'
], -4));
25.
$checkin_date
=
$dom
->createElement(
'checkin_date'
,
$row
[
'book_start_date'
]);
26.
$checkout_date
=
$dom
->createElement(
'checkout_date'
,
$row
[
'book_end_date'
]);
27.
$rooms
=
$dom
->createElement(
'rooms'
);
28.
29.
30.
$query2
= mysql_query(
"SELECT * FROM bookingroom LEFT JOIN room USING(room_id) LEFT JOIN roomtype USING(roomtype_id) WHERE booking_id= "
.
$row
[
'booking_id'
]);
31.
while
(
$row2
= mysql_fetch_array(
$query2
) ){
32.
$room_id
=
$dom
->createElement(
'room_id'
,
$row2
[
'room_id'
]);
33.
$room_name
=
$dom
->createElement(
'room_name'
,
$row2
[
'roomtype_name'
]);
34.
$room_person_number
=
$dom
->createElement(
'room_person_number'
,
$row2
[
'person_number'
]);
35.
$room_floor
=
$dom
->createElement(
'room_floor'
,
$row2
[
'floor'
]);
36.
$room_description
=
$dom
->createElement(
'room_description'
,
$row2
[
'room_description'
]);
37.
38.
$room
=
$dom
->createElement(
'room'
);
39.
$room
->appendChild(
$room_id
);
40.
$room
->appendChild(
$room_name
);
41.
$room
->appendChild(
$room_person_number
);
42.
$room
->appendChild(
$room_floor
);
43.
$room
->appendChild(
$room_description
);
44.
45.
$rooms
->appendChild(
$room
);
46.
}
47.
48.
$booking
=
$dom
->createElement(
'booking'
);
49.
$booking
->appendChild(
$booking_id
);
50.
$booking
->appendChild(
$booking_code
);
51.
$booking
->appendChild(
$checkin_date
);
52.
$booking
->appendChild(
$checkout_date
);
53.
$booking
->appendChild(
$rooms
);
54.
55.
$pay_booking
->appendChild(
$booking
);
56.
}
57.
$dom
->appendChild(
$pay_booking
);
58.
59.
return
$dom
->saveXML();
60.
61.
62.
return
''
;
63.
}
64.
65.
66.
$server
=
new
SoapServer(
'webservice.wsdl'
);
67.
68.
69.
$server
->addFunction(
'login'
);
70.
$server
->addFunction(
'is_login'
);
71.
$server
->addFunction(
'logout'
);
72.
$server
->addFunction(
'get_roompriceXML'
);
73.
$server
->addFunction(
'set_roompriceXML'
);
74.
$server
->addFunction(
'get_pay_remain'
);
75.
$server
->addFunction(
'get_pay_historyXML'
);
76.
$server
->addFunction(
'get_unset_detail_bookingXML'
);
77.
$server
->addFunction(
'set_detail_bookingXML'
);
78.
$server
->addFunction(
'get_all_booking_historyXML'
);
79.
$server
->addFunction(
'get_all_pay_booking_historyXML'
);
80.
81.
82.
$server
->handle();