[07/10/2020 11:00:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594378844','150.129.30.138');
[07/10/2020 11:06:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594379194','150.129.30.138');
[07/10/2020 11:06:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelstopbooking', '2020-07-10 :11:06:34','');
[07/10/2020 11:06:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],insert into email_logs SET `subject`= 'Stop Booking in otrams.thefabulousgetaway.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VGhlIGJlbG93IGFnZW50IHdhcyByZXN0cmljdGVkIGZyb20gZG9pbmcgdGhlIGJvb2tpbmcgYXMgdGhlIHJhdGUgbWlnaHQgaGF2ZSBjaGFuZ2VkIG9yIHRoZSByb29tIGlzIG5vdCBhdmFpbGFibGUuIFlvdSBhcmUgYWR2aWNlZCB0byBjYWxsIHRoZSBhZ2VudCBhbmQgZm9sbG93IHVwIG9mZmxpbmUgYnkgc3VnZ2VzdGluZyBhbHRlcm5hdGl2ZXMuPGJyPjxicj5BZ2VudDpRdGVjaF9BbmtpdGEgKFVzZXJuYW1lOiBhbmtpdGEpPGJyPjxicj5DaXR5Om11bWJhaTxicj48YnI+QXJyaXZhbCBEYXRlOjIwMjAvMDcvMjM8YnI+PGJyPkRlcGFydHVyZSBEYXRlOjIwMjAvMDcvMjQ8YnI+PGJyPlN1cHBsaWVyOmxvY2Fsc3lzdGVtPGJyPjxicj5Ib3RlbDpIWUFUVCBNVU1CQUkgUFJJTUU8YnI+PGJyPlJvb20gVHlwZToxIFByaW1lIFJvb20KUm9vbTpQcmltZSAgLUJlZCAmIEJyZWFrZmFzdCA6IDIgUGF4IAo8YnI+PGJyPkFnZW50IFByaWNlIDo1NTY1LjUzIElOUjxicj48YnI+PGJyPjxicj4gTG9nZ2VkIEZpbGUgLTxhIGhyZWY9JyBodHRwOi8vdWF0LnRmZy5vdHJhbXMubmV0L3Byb2plY3RfZm9sZGVyL3RmZ19wcm9qZWN0L3Byb3RlY3RlZC9zdXBwbGllcl9sb2dzLy9yZXNwb25zZV9wbGFjZWhvbGRlci54bWwnPmh0dHA6Ly91YXQudGZnLm90cmFtcy5uZXQvcHJvamVjdF9mb2xkZXIvdGZnX3Byb2plY3QvcHJvdGVjdGVkL3N1cHBsaWVyX2xvZ3MvL3Jlc3BvbnNlX3BsYWNlaG9sZGVyLnhtbDwvYT48YnI+PGJyPjxhIGhyZWY9JyAnPjwvYT48YnI+PGJyPg==',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/book_now.php',create_date= '2020-07-10 11:06:34';
[07/10/2020 11:06:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],insert into email_logs SET `subject`= 'Stop Booking in otrams.thefabulousgetaway.otrams.net For supplier localsystem(STOP_BOOKING_EMAIL)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VGhlIGJlbG93IGFnZW50IHdhcyByZXN0cmljdGVkIGZyb20gZG9pbmcgdGhlIGJvb2tpbmcgYXMgdGhlIHJhdGUgbWlnaHQgaGF2ZSBjaGFuZ2VkIG9yIHRoZSByb29tIGlzIG5vdCBhdmFpbGFibGUuIFlvdSBhcmUgYWR2aWNlZCB0byBjYWxsIHRoZSBhZ2VudCBhbmQgZm9sbG93IHVwIG9mZmxpbmUgYnkgc3VnZ2VzdGluZyBhbHRlcm5hdGl2ZXMuPGJyPjxicj5BZ2VudDpRdGVjaF9BbmtpdGEgKFVzZXJuYW1lOiBhbmtpdGEpPGJyPjxicj5DaXR5Om11bWJhaTxicj48YnI+QXJyaXZhbCBEYXRlOjIwMjAvMDcvMjM8YnI+PGJyPkRlcGFydHVyZSBEYXRlOjIwMjAvMDcvMjQ8YnI+PGJyPlN1cHBsaWVyOmxvY2Fsc3lzdGVtPGJyPjxicj5Ib3RlbDpIWUFUVCBNVU1CQUkgUFJJTUU8YnI+PGJyPlJvb20gVHlwZToxIFByaW1lIFJvb20KUm9vbTpQcmltZSAgLUJlZCAmIEJyZWFrZmFzdCA6IDIgUGF4IAo8YnI+PGJyPkFnZW50IFByaWNlIDo1NTY1LjUzIElOUjxicj48YnI+PGJyPjxicj4gTG9nZ2VkIEZpbGUgLTxhIGhyZWY9JyBodHRwOi8vdWF0LnRmZy5vdHJhbXMubmV0L3Byb2plY3RfZm9sZGVyL3RmZ19wcm9qZWN0L3Byb3RlY3RlZC9zdXBwbGllcl9sb2dzLy9yZXNwb25zZV9wbGFjZWhvbGRlci54bWwnPmh0dHA6Ly91YXQudGZnLm90cmFtcy5uZXQvcHJvamVjdF9mb2xkZXIvdGZnX3Byb2plY3QvcHJvdGVjdGVkL3N1cHBsaWVyX2xvZ3MvL3Jlc3BvbnNlX3BsYWNlaG9sZGVyLnhtbDwvYT48YnI+PGJyPjxhIGhyZWY9JyAnPjwvYT48YnI+PGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/book_now.php',create_date= '2020-07-10 11:06:34';
[07/10/2020 11:06:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php], insert into email_trigger set  subject ='Stop Booking in otrams.thefabulousgetaway.otrams.net For supplier localsystem',  message='The below agent was restricted from doing the booking as the rate might have changed or the room is not available. You are adviced to call the agent and follow up offline by suggesting alternatives.<br><br>Agent:Qtech_Ankita (Username: ankita)<br><br>City:mumbai<br><br>Arrival Date:2020/07/23<br><br>Departure Date:2020/07/24<br><br>Supplier:localsystem<br><br>Hotel:HYATT MUMBAI PRIME<br><br>Room Type:1 Prime Room
Room:Prime  -Bed & Breakfast : 2 Pax 
<br><br>Agent Price :5565.53 INR<br><br><br><br> Logged File -<a href=\' http://uat.tfg.otrams.net/project_folder/tfg_project/protected/supplier_logs//response_placeholder.xml\'>http://uat.tfg.otrams.net/project_folder/tfg_project/protected/supplier_logs//response_placeholder.xml</a><br><br><a href=\' \'></a><br><br>',  email_sent ='yes', create_date ='2020-07-10 11:06:34', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='STOP_BOOKING_EMAIL';
[07/10/2020 11:12:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594379559','150.129.30.138');
[07/10/2020 11:12:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelstopbooking', '2020-07-10 :11:12:39','');
[07/10/2020 11:12:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],insert into email_logs SET `subject`= 'Stop Booking in otrams.thefabulousgetaway.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VGhlIGJlbG93IGFnZW50IHdhcyByZXN0cmljdGVkIGZyb20gZG9pbmcgdGhlIGJvb2tpbmcgYXMgdGhlIHJhdGUgbWlnaHQgaGF2ZSBjaGFuZ2VkIG9yIHRoZSByb29tIGlzIG5vdCBhdmFpbGFibGUuIFlvdSBhcmUgYWR2aWNlZCB0byBjYWxsIHRoZSBhZ2VudCBhbmQgZm9sbG93IHVwIG9mZmxpbmUgYnkgc3VnZ2VzdGluZyBhbHRlcm5hdGl2ZXMuPGJyPjxicj5BZ2VudDpRdGVjaF9BbmtpdGEgKFVzZXJuYW1lOiBhbmtpdGEpPGJyPjxicj5DaXR5Om11bWJhaTxicj48YnI+QXJyaXZhbCBEYXRlOjIwMjAvMDcvMjM8YnI+PGJyPkRlcGFydHVyZSBEYXRlOjIwMjAvMDcvMjQ8YnI+PGJyPlN1cHBsaWVyOmxvY2Fsc3lzdGVtPGJyPjxicj5Ib3RlbDpIWUFUVCBNVU1CQUkgUFJJTUU8YnI+PGJyPlJvb20gVHlwZToxIFByaW1lIFJvb20KUm9vbTpQcmltZSAgLUJlZCAmIEJyZWFrZmFzdCA6IDIgUGF4IAo8YnI+PGJyPkFnZW50IFByaWNlIDo1NTY1LjUzIElOUjxicj48YnI+PGJyPjxicj4gTG9nZ2VkIEZpbGUgLTxhIGhyZWY9JyBodHRwOi8vdWF0LnRmZy5vdHJhbXMubmV0L3Byb2plY3RfZm9sZGVyL3RmZ19wcm9qZWN0L3Byb3RlY3RlZC9zdXBwbGllcl9sb2dzLy9yZXNwb25zZV9wbGFjZWhvbGRlci54bWwnPmh0dHA6Ly91YXQudGZnLm90cmFtcy5uZXQvcHJvamVjdF9mb2xkZXIvdGZnX3Byb2plY3QvcHJvdGVjdGVkL3N1cHBsaWVyX2xvZ3MvL3Jlc3BvbnNlX3BsYWNlaG9sZGVyLnhtbDwvYT48YnI+PGJyPjxhIGhyZWY9JyAnPjwvYT48YnI+PGJyPg==',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/book_now.php',create_date= '2020-07-10 11:12:39';
[07/10/2020 11:16:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594379799','150.129.30.138');
[07/10/2020 11:16:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelstopbooking', '2020-07-10 :11:16:39','');
[07/10/2020 11:16:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],insert into email_logs SET `subject`= 'Stop Booking in otrams.thefabulousgetaway.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VGhlIGJlbG93IGFnZW50IHdhcyByZXN0cmljdGVkIGZyb20gZG9pbmcgdGhlIGJvb2tpbmcgYXMgdGhlIHJhdGUgbWlnaHQgaGF2ZSBjaGFuZ2VkIG9yIHRoZSByb29tIGlzIG5vdCBhdmFpbGFibGUuIFlvdSBhcmUgYWR2aWNlZCB0byBjYWxsIHRoZSBhZ2VudCBhbmQgZm9sbG93IHVwIG9mZmxpbmUgYnkgc3VnZ2VzdGluZyBhbHRlcm5hdGl2ZXMuPGJyPjxicj5BZ2VudDpRdGVjaF9BbmtpdGEgKFVzZXJuYW1lOiBhbmtpdGEpPGJyPjxicj5DaXR5Om11bWJhaTxicj48YnI+QXJyaXZhbCBEYXRlOjIwMjAvMDcvMjM8YnI+PGJyPkRlcGFydHVyZSBEYXRlOjIwMjAvMDcvMjQ8YnI+PGJyPlN1cHBsaWVyOmxvY2Fsc3lzdGVtPGJyPjxicj5Ib3RlbDpIWUFUVCBNVU1CQUkgUFJJTUU8YnI+PGJyPlJvb20gVHlwZToxIFByaW1lIFJvb20KUm9vbTpQcmltZSAgLUJlZCAmIEJyZWFrZmFzdCA6IDIgUGF4IAo8YnI+PGJyPkFnZW50IFByaWNlIDo1NTY1LjUzIElOUjxicj48YnI+PGJyPjxicj4gTG9nZ2VkIEZpbGUgLTxhIGhyZWY9JyBodHRwOi8vdWF0LnRmZy5vdHJhbXMubmV0L3Byb2plY3RfZm9sZGVyL3RmZ19wcm9qZWN0L3Byb3RlY3RlZC9zdXBwbGllcl9sb2dzLy9yZXNwb25zZV9wbGFjZWhvbGRlci54bWwnPmh0dHA6Ly91YXQudGZnLm90cmFtcy5uZXQvcHJvamVjdF9mb2xkZXIvdGZnX3Byb2plY3QvcHJvdGVjdGVkL3N1cHBsaWVyX2xvZ3MvL3Jlc3BvbnNlX3BsYWNlaG9sZGVyLnhtbDwvYT48YnI+PGJyPjxhIGhyZWY9JyAnPjwvYT48YnI+PGJyPg==',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/book_now.php',create_date= '2020-07-10 11:16:39';
[07/10/2020 11:22:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594380138','150.129.30.138');
[07/10/2020 11:22:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelstopbooking', '2020-07-10 :11:22:18','');
[07/10/2020 11:22:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],insert into email_logs SET `subject`= 'Stop Booking in otrams.thefabulousgetaway.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VGhlIGJlbG93IGFnZW50IHdhcyByZXN0cmljdGVkIGZyb20gZG9pbmcgdGhlIGJvb2tpbmcgYXMgdGhlIHJhdGUgbWlnaHQgaGF2ZSBjaGFuZ2VkIG9yIHRoZSByb29tIGlzIG5vdCBhdmFpbGFibGUuIFlvdSBhcmUgYWR2aWNlZCB0byBjYWxsIHRoZSBhZ2VudCBhbmQgZm9sbG93IHVwIG9mZmxpbmUgYnkgc3VnZ2VzdGluZyBhbHRlcm5hdGl2ZXMuPGJyPjxicj5BZ2VudDpRdGVjaF9BbmtpdGEgKFVzZXJuYW1lOiBhbmtpdGEpPGJyPjxicj5DaXR5Om11bWJhaTxicj48YnI+QXJyaXZhbCBEYXRlOjIwMjAvMDcvMjM8YnI+PGJyPkRlcGFydHVyZSBEYXRlOjIwMjAvMDcvMjQ8YnI+PGJyPlN1cHBsaWVyOmxvY2Fsc3lzdGVtPGJyPjxicj5Ib3RlbDpIWUFUVCBNVU1CQUkgUFJJTUU8YnI+PGJyPlJvb20gVHlwZToxIFByaW1lIFJvb20KUm9vbTpQcmltZSAgLUJlZCAmIEJyZWFrZmFzdCA6IDIgUGF4IAo8YnI+PGJyPkFnZW50IFByaWNlIDo1NTY1LjUzIElOUjxicj48YnI+PGJyPjxicj4gTG9nZ2VkIEZpbGUgLTxhIGhyZWY9JyBodHRwOi8vdWF0LnRmZy5vdHJhbXMubmV0L3Byb2plY3RfZm9sZGVyL3RmZ19wcm9qZWN0L3Byb3RlY3RlZC9zdXBwbGllcl9sb2dzLy9yZXNwb25zZV9wbGFjZWhvbGRlci54bWwnPmh0dHA6Ly91YXQudGZnLm90cmFtcy5uZXQvcHJvamVjdF9mb2xkZXIvdGZnX3Byb2plY3QvcHJvdGVjdGVkL3N1cHBsaWVyX2xvZ3MvL3Jlc3BvbnNlX3BsYWNlaG9sZGVyLnhtbDwvYT48YnI+PGJyPjxhIGhyZWY9JyAnPjwvYT48YnI+PGJyPg==',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/book_now.php',create_date= '2020-07-10 11:22:18';
[07/10/2020 11:26:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594380406','150.129.30.138');
[07/10/2020 11:27:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594380440','150.129.30.138');
[07/10/2020 11:33:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594380791','150.129.30.138');
[07/10/2020 11:33:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelstopbooking', '2020-07-10 :11:33:11','');
[07/10/2020 11:33:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],insert into email_logs SET `subject`= 'Stop Booking in otrams.thefabulousgetaway.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VGhlIGJlbG93IGFnZW50IHdhcyByZXN0cmljdGVkIGZyb20gZG9pbmcgdGhlIGJvb2tpbmcgYXMgdGhlIHJhdGUgbWlnaHQgaGF2ZSBjaGFuZ2VkIG9yIHRoZSByb29tIGlzIG5vdCBhdmFpbGFibGUuIFlvdSBhcmUgYWR2aWNlZCB0byBjYWxsIHRoZSBhZ2VudCBhbmQgZm9sbG93IHVwIG9mZmxpbmUgYnkgc3VnZ2VzdGluZyBhbHRlcm5hdGl2ZXMuPGJyPjxicj5BZ2VudDpRdGVjaF9BbmtpdGEgKFVzZXJuYW1lOiBhbmtpdGEpPGJyPjxicj5DaXR5Om11bWJhaTxicj48YnI+QXJyaXZhbCBEYXRlOjIwMjAvMDcvMjM8YnI+PGJyPkRlcGFydHVyZSBEYXRlOjIwMjAvMDcvMjQ8YnI+PGJyPlN1cHBsaWVyOmxvY2Fsc3lzdGVtPGJyPjxicj5Ib3RlbDpIWUFUVCBNVU1CQUkgUFJJTUU8YnI+PGJyPlJvb20gVHlwZToxIFByaW1lIFJvb20KUm9vbTpQcmltZSAgLUJlZCAmIEJyZWFrZmFzdCA6IDIgUGF4IAo8YnI+PGJyPkFnZW50IFByaWNlIDo1NTY1LjUzIElOUjxicj48YnI+PGJyPjxicj4gTG9nZ2VkIEZpbGUgLTxhIGhyZWY9JyBodHRwOi8vdWF0LnRmZy5vdHJhbXMubmV0L3Byb2plY3RfZm9sZGVyL3RmZ19wcm9qZWN0L3Byb3RlY3RlZC9zdXBwbGllcl9sb2dzLy9yZXNwb25zZV9wbGFjZWhvbGRlci54bWwnPmh0dHA6Ly91YXQudGZnLm90cmFtcy5uZXQvcHJvamVjdF9mb2xkZXIvdGZnX3Byb2plY3QvcHJvdGVjdGVkL3N1cHBsaWVyX2xvZ3MvL3Jlc3BvbnNlX3BsYWNlaG9sZGVyLnhtbDwvYT48YnI+PGJyPjxhIGhyZWY9JyAnPjwvYT48YnI+PGJyPg==',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/book_now.php',create_date= '2020-07-10 11:33:11';
[07/10/2020 11:39:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594381141','150.129.30.138');
[07/10/2020 11:39:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelstopbooking', '2020-07-10 :11:39:01','');
[07/10/2020 11:39:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],insert into email_logs SET `subject`= 'Stop Booking in otrams.thefabulousgetaway.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VGhlIGJlbG93IGFnZW50IHdhcyByZXN0cmljdGVkIGZyb20gZG9pbmcgdGhlIGJvb2tpbmcgYXMgdGhlIHJhdGUgbWlnaHQgaGF2ZSBjaGFuZ2VkIG9yIHRoZSByb29tIGlzIG5vdCBhdmFpbGFibGUuIFlvdSBhcmUgYWR2aWNlZCB0byBjYWxsIHRoZSBhZ2VudCBhbmQgZm9sbG93IHVwIG9mZmxpbmUgYnkgc3VnZ2VzdGluZyBhbHRlcm5hdGl2ZXMuPGJyPjxicj5BZ2VudDpRdGVjaF9BbmtpdGEgKFVzZXJuYW1lOiBhbmtpdGEpPGJyPjxicj5DaXR5Om11bWJhaTxicj48YnI+QXJyaXZhbCBEYXRlOjIwMjAvMDcvMjM8YnI+PGJyPkRlcGFydHVyZSBEYXRlOjIwMjAvMDcvMjQ8YnI+PGJyPlN1cHBsaWVyOmxvY2Fsc3lzdGVtPGJyPjxicj5Ib3RlbDpIWUFUVCBNVU1CQUkgUFJJTUU8YnI+PGJyPlJvb20gVHlwZToxIFByaW1lIFJvb20KUm9vbTpQcmltZSAgLUJlZCAmIEJyZWFrZmFzdCA6IDIgUGF4IAo8YnI+PGJyPkFnZW50IFByaWNlIDo1NTY1LjUzIElOUjxicj48YnI+PGJyPjxicj4gTG9nZ2VkIEZpbGUgLTxhIGhyZWY9JyBodHRwOi8vdWF0LnRmZy5vdHJhbXMubmV0L3Byb2plY3RfZm9sZGVyL3RmZ19wcm9qZWN0L3Byb3RlY3RlZC9zdXBwbGllcl9sb2dzLy9yZXNwb25zZV9wbGFjZWhvbGRlci54bWwnPmh0dHA6Ly91YXQudGZnLm90cmFtcy5uZXQvcHJvamVjdF9mb2xkZXIvdGZnX3Byb2plY3QvcHJvdGVjdGVkL3N1cHBsaWVyX2xvZ3MvL3Jlc3BvbnNlX3BsYWNlaG9sZGVyLnhtbDwvYT48YnI+PGJyPjxhIGhyZWY9JyAnPjwvYT48YnI+PGJyPg==',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/book_now.php',create_date= '2020-07-10 11:39:01';
[07/10/2020 11:43:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594381408','150.129.30.138');
[07/10/2020 11:43:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelstopbooking', '2020-07-10 :11:43:28','');
[07/10/2020 11:43:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],insert into email_logs SET `subject`= 'Stop Booking in otrams.thefabulousgetaway.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VGhlIGJlbG93IGFnZW50IHdhcyByZXN0cmljdGVkIGZyb20gZG9pbmcgdGhlIGJvb2tpbmcgYXMgdGhlIHJhdGUgbWlnaHQgaGF2ZSBjaGFuZ2VkIG9yIHRoZSByb29tIGlzIG5vdCBhdmFpbGFibGUuIFlvdSBhcmUgYWR2aWNlZCB0byBjYWxsIHRoZSBhZ2VudCBhbmQgZm9sbG93IHVwIG9mZmxpbmUgYnkgc3VnZ2VzdGluZyBhbHRlcm5hdGl2ZXMuPGJyPjxicj5BZ2VudDpRdGVjaF9BbmtpdGEgKFVzZXJuYW1lOiBhbmtpdGEpPGJyPjxicj5DaXR5Om11bWJhaTxicj48YnI+QXJyaXZhbCBEYXRlOjIwMjAvMDcvMjM8YnI+PGJyPkRlcGFydHVyZSBEYXRlOjIwMjAvMDcvMjQ8YnI+PGJyPlN1cHBsaWVyOmxvY2Fsc3lzdGVtPGJyPjxicj5Ib3RlbDpIWUFUVCBNVU1CQUkgUFJJTUU8YnI+PGJyPlJvb20gVHlwZToxIFByaW1lIFJvb20KUm9vbTpQcmltZSAgLUJlZCAmIEJyZWFrZmFzdCA6IDIgUGF4IAo8YnI+PGJyPkFnZW50IFByaWNlIDo1NTY1LjUzIElOUjxicj48YnI+PGJyPjxicj4gTG9nZ2VkIEZpbGUgLTxhIGhyZWY9JyBodHRwOi8vdWF0LnRmZy5vdHJhbXMubmV0L3Byb2plY3RfZm9sZGVyL3RmZ19wcm9qZWN0L3Byb3RlY3RlZC9zdXBwbGllcl9sb2dzLy9yZXNwb25zZV9wbGFjZWhvbGRlci54bWwnPmh0dHA6Ly91YXQudGZnLm90cmFtcy5uZXQvcHJvamVjdF9mb2xkZXIvdGZnX3Byb2plY3QvcHJvdGVjdGVkL3N1cHBsaWVyX2xvZ3MvL3Jlc3BvbnNlX3BsYWNlaG9sZGVyLnhtbDwvYT48YnI+PGJyPjxhIGhyZWY9JyAnPjwvYT48YnI+PGJyPg==',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/book_now.php',create_date= '2020-07-10 11:43:28';
[07/10/2020 11:46:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594381582','150.129.30.138');
[07/10/2020 11:46:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelstopbooking', '2020-07-10 :11:46:22','');
[07/10/2020 11:46:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],insert into email_logs SET `subject`= 'Stop Booking in otrams.thefabulousgetaway.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VGhlIGJlbG93IGFnZW50IHdhcyByZXN0cmljdGVkIGZyb20gZG9pbmcgdGhlIGJvb2tpbmcgYXMgdGhlIHJhdGUgbWlnaHQgaGF2ZSBjaGFuZ2VkIG9yIHRoZSByb29tIGlzIG5vdCBhdmFpbGFibGUuIFlvdSBhcmUgYWR2aWNlZCB0byBjYWxsIHRoZSBhZ2VudCBhbmQgZm9sbG93IHVwIG9mZmxpbmUgYnkgc3VnZ2VzdGluZyBhbHRlcm5hdGl2ZXMuPGJyPjxicj5BZ2VudDpRdGVjaF9BbmtpdGEgKFVzZXJuYW1lOiBhbmtpdGEpPGJyPjxicj5DaXR5Om11bWJhaTxicj48YnI+QXJyaXZhbCBEYXRlOjIwMjAvMDcvMjM8YnI+PGJyPkRlcGFydHVyZSBEYXRlOjIwMjAvMDcvMjQ8YnI+PGJyPlN1cHBsaWVyOmxvY2Fsc3lzdGVtPGJyPjxicj5Ib3RlbDpIWUFUVCBNVU1CQUkgUFJJTUU8YnI+PGJyPlJvb20gVHlwZToxIFByaW1lIFJvb20KUm9vbTpQcmltZSAgLUJlZCAmIEJyZWFrZmFzdCA6IDIgUGF4IAo8YnI+PGJyPkFnZW50IFByaWNlIDo1NTY1LjUzIElOUjxicj48YnI+PGJyPjxicj4gTG9nZ2VkIEZpbGUgLTxhIGhyZWY9JyBodHRwOi8vdWF0LnRmZy5vdHJhbXMubmV0L3Byb2plY3RfZm9sZGVyL3RmZ19wcm9qZWN0L3Byb3RlY3RlZC9zdXBwbGllcl9sb2dzLy9yZXNwb25zZV9wbGFjZWhvbGRlci54bWwnPmh0dHA6Ly91YXQudGZnLm90cmFtcy5uZXQvcHJvamVjdF9mb2xkZXIvdGZnX3Byb2plY3QvcHJvdGVjdGVkL3N1cHBsaWVyX2xvZ3MvL3Jlc3BvbnNlX3BsYWNlaG9sZGVyLnhtbDwvYT48YnI+PGJyPjxhIGhyZWY9JyAnPjwvYT48YnI+PGJyPg==',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/book_now.php',create_date= '2020-07-10 11:46:22';
[07/10/2020 11:46:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '21' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '3' , ip = '150.129.30.138' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/07/23' , departure_date = '2020/07/24' , nationality = '3' , nights = '1' , room_types = '2' , create_date = '2020-07-10 11:46:59' , site_id = '' , country_code = '106' , web_service = '' ;
[07/10/2020 11:47:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-07-10 11:47:02', '', 'b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7', '334');
[07/10/2020 11:47:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7&xml_user_id=21&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&web_service=no&site_id='
, http_hit_time = '2020-07-10 11:47:02.14'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.446'
, error_description = ''
, memory_used = '8021096'
WHERE id = '2871';
[07/10/2020 11:47:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=21&sessionid=b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7',
  duration = '1.854',
  merge_duration = '0.137',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '2.53',
  system_load_5_min = '2.90',
  system_load_15_min = '2.43',
  system_memory_usage = '92.39',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '334') + '8149400',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '334';
[07/10/2020 11:47:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594381640','150.129.30.138');
[07/10/2020 11:47:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Creamcentre', 'mumbai', '106', '21', '', '3', '', 'hotelstopbooking', '2020-07-10 :11:47:20','');
[07/10/2020 11:47:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],insert into email_logs SET `subject`= 'Stop Booking in otrams.thefabulousgetaway.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VGhlIGJlbG93IGFnZW50IHdhcyByZXN0cmljdGVkIGZyb20gZG9pbmcgdGhlIGJvb2tpbmcgYXMgdGhlIHJhdGUgbWlnaHQgaGF2ZSBjaGFuZ2VkIG9yIHRoZSByb29tIGlzIG5vdCBhdmFpbGFibGUuIFlvdSBhcmUgYWR2aWNlZCB0byBjYWxsIHRoZSBhZ2VudCBhbmQgZm9sbG93IHVwIG9mZmxpbmUgYnkgc3VnZ2VzdGluZyBhbHRlcm5hdGl2ZXMuPGJyPjxicj5BZ2VudDpRdGVjaF9BbmtpdGEgKFVzZXJuYW1lOiBhbmtpdGEpPGJyPjxicj5DaXR5Om11bWJhaTxicj48YnI+QXJyaXZhbCBEYXRlOjIwMjAvMDcvMjM8YnI+PGJyPkRlcGFydHVyZSBEYXRlOjIwMjAvMDcvMjQ8YnI+PGJyPlN1cHBsaWVyOmxvY2Fsc3lzdGVtPGJyPjxicj5Ib3RlbDpDUkVBTUNFTlRSRTxicj48YnI+Um9vbSBUeXBlOjEgUk9IIChTdGFuZGFyZC9TdXBlcmlvcikgUm9vbQpSb29tOlJPSCAoU3RhbmRhcmQvU3VwZXJpb3IpICAtQmVkICYgQnJlYWtmYXN0IDogMiBQYXggPGJyPiggUHJvbW90aW9uKTxicj4oT2ZmZXIgTm90ZTogfiBGUkVFIFdJRkkpIChOb24tUmVmdW5kYWJsZSkKPGJyPjxicj5BZ2VudCBQcmljZSA6MjQwIElOUjxicj48YnI+PGJyPjxicj4gTG9nZ2VkIEZpbGUgLTxhIGhyZWY9JyBodHRwOi8vdWF0LnRmZy5vdHJhbXMubmV0L3Byb2plY3RfZm9sZGVyL3RmZ19wcm9qZWN0L3Byb3RlY3RlZC9zdXBwbGllcl9sb2dzLy9yZXNwb25zZV9wbGFjZWhvbGRlci54bWwnPmh0dHA6Ly91YXQudGZnLm90cmFtcy5uZXQvcHJvamVjdF9mb2xkZXIvdGZnX3Byb2plY3QvcHJvdGVjdGVkL3N1cHBsaWVyX2xvZ3MvL3Jlc3BvbnNlX3BsYWNlaG9sZGVyLnhtbDwvYT48YnI+PGJyPjxhIGhyZWY9JyAnPjwvYT48YnI+PGJyPg==',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/book_now.php',create_date= '2020-07-10 11:47:20';
[07/10/2020 11:47:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],insert into email_logs SET `subject`= 'Stop Booking in otrams.thefabulousgetaway.otrams.net For supplier localsystem(STOP_BOOKING_EMAIL)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VGhlIGJlbG93IGFnZW50IHdhcyByZXN0cmljdGVkIGZyb20gZG9pbmcgdGhlIGJvb2tpbmcgYXMgdGhlIHJhdGUgbWlnaHQgaGF2ZSBjaGFuZ2VkIG9yIHRoZSByb29tIGlzIG5vdCBhdmFpbGFibGUuIFlvdSBhcmUgYWR2aWNlZCB0byBjYWxsIHRoZSBhZ2VudCBhbmQgZm9sbG93IHVwIG9mZmxpbmUgYnkgc3VnZ2VzdGluZyBhbHRlcm5hdGl2ZXMuPGJyPjxicj5BZ2VudDpRdGVjaF9BbmtpdGEgKFVzZXJuYW1lOiBhbmtpdGEpPGJyPjxicj5DaXR5Om11bWJhaTxicj48YnI+QXJyaXZhbCBEYXRlOjIwMjAvMDcvMjM8YnI+PGJyPkRlcGFydHVyZSBEYXRlOjIwMjAvMDcvMjQ8YnI+PGJyPlN1cHBsaWVyOmxvY2Fsc3lzdGVtPGJyPjxicj5Ib3RlbDpDUkVBTUNFTlRSRTxicj48YnI+Um9vbSBUeXBlOjEgUk9IIChTdGFuZGFyZC9TdXBlcmlvcikgUm9vbQpSb29tOlJPSCAoU3RhbmRhcmQvU3VwZXJpb3IpICAtQmVkICYgQnJlYWtmYXN0IDogMiBQYXggPGJyPiggUHJvbW90aW9uKTxicj4oT2ZmZXIgTm90ZTogfiBGUkVFIFdJRkkpIChOb24tUmVmdW5kYWJsZSkKPGJyPjxicj5BZ2VudCBQcmljZSA6MjQwIElOUjxicj48YnI+PGJyPjxicj4gTG9nZ2VkIEZpbGUgLTxhIGhyZWY9JyBodHRwOi8vdWF0LnRmZy5vdHJhbXMubmV0L3Byb2plY3RfZm9sZGVyL3RmZ19wcm9qZWN0L3Byb3RlY3RlZC9zdXBwbGllcl9sb2dzLy9yZXNwb25zZV9wbGFjZWhvbGRlci54bWwnPmh0dHA6Ly91YXQudGZnLm90cmFtcy5uZXQvcHJvamVjdF9mb2xkZXIvdGZnX3Byb2plY3QvcHJvdGVjdGVkL3N1cHBsaWVyX2xvZ3MvL3Jlc3BvbnNlX3BsYWNlaG9sZGVyLnhtbDwvYT48YnI+PGJyPjxhIGhyZWY9JyAnPjwvYT48YnI+PGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/book_now.php',create_date= '2020-07-10 11:47:21';
[07/10/2020 11:47:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php], insert into email_trigger set  subject ='Stop Booking in otrams.thefabulousgetaway.otrams.net For supplier localsystem',  message='The below agent was restricted from doing the booking as the rate might have changed or the room is not available. You are adviced to call the agent and follow up offline by suggesting alternatives.<br><br>Agent:Qtech_Ankita (Username: ankita)<br><br>City:mumbai<br><br>Arrival Date:2020/07/23<br><br>Departure Date:2020/07/24<br><br>Supplier:localsystem<br><br>Hotel:CREAMCENTRE<br><br>Room Type:1 ROH (Standard/Superior) Room
Room:ROH (Standard/Superior)  -Bed & Breakfast : 2 Pax <br>( Promotion)<br>(Offer Note: ~ FREE WIFI) (Non-Refundable)
<br><br>Agent Price :240 INR<br><br><br><br> Logged File -<a href=\' http://uat.tfg.otrams.net/project_folder/tfg_project/protected/supplier_logs//response_placeholder.xml\'>http://uat.tfg.otrams.net/project_folder/tfg_project/protected/supplier_logs//response_placeholder.xml</a><br><br><a href=\' \'></a><br><br>',  email_sent ='yes', create_date ='2020-07-10 11:47:21', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='STOP_BOOKING_EMAIL';
[07/10/2020 11:48:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '21' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '3' , ip = '150.129.30.138' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/07/23' , departure_date = '2020/07/24' , nationality = '3' , nights = '1' , room_types = '2' , create_date = '2020-07-10 11:48:40' , site_id = '' , country_code = '106' , web_service = '' ;
[07/10/2020 11:48:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-07-10 11:48:43', '', 'b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7', '335');
[07/10/2020 11:48:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7&xml_user_id=21&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&web_service=no&site_id='
, http_hit_time = '2020-07-10 11:48:42.464'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.716'
, error_description = ''
, memory_used = '8021096'
WHERE id = '2872';
[07/10/2020 11:48:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=21&sessionid=b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7',
  duration = '2.257',
  merge_duration = '0.126',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.90',
  system_load_5_min = '2.24',
  system_load_15_min = '2.24',
  system_memory_usage = '92.35',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '335') + '8149400',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '335';
[07/10/2020 11:49:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '21' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '3' , ip = '150.129.30.138' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/07/23' , departure_date = '2020/07/24' , nationality = '3' , nights = '1' , room_types = '2' , create_date = '2020-07-10 11:49:03' , site_id = '' , country_code = '106' , web_service = '' ;
[07/10/2020 11:49:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-07-10 11:49:06', '', 'b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7', '336');
[07/10/2020 11:49:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7&xml_user_id=21&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&web_service=no&site_id='
, http_hit_time = '2020-07-10 11:49:05.579'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.325'
, error_description = ''
, memory_used = '8021096'
WHERE id = '2873';
[07/10/2020 11:49:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=21&sessionid=b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7',
  duration = '1.739',
  merge_duration = '0.126',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '1.06',
  system_load_5_min = '2.17',
  system_load_15_min = '2.22',
  system_memory_usage = '92.33',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '336') + '8149400',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '336';
[07/10/2020 11:49:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594381763','150.129.30.138');
[07/10/2020 11:49:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelstopbooking', '2020-07-10 :11:49:23','');
[07/10/2020 11:49:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],insert into email_logs SET `subject`= 'Stop Booking in otrams.thefabulousgetaway.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VGhlIGJlbG93IGFnZW50IHdhcyByZXN0cmljdGVkIGZyb20gZG9pbmcgdGhlIGJvb2tpbmcgYXMgdGhlIHJhdGUgbWlnaHQgaGF2ZSBjaGFuZ2VkIG9yIHRoZSByb29tIGlzIG5vdCBhdmFpbGFibGUuIFlvdSBhcmUgYWR2aWNlZCB0byBjYWxsIHRoZSBhZ2VudCBhbmQgZm9sbG93IHVwIG9mZmxpbmUgYnkgc3VnZ2VzdGluZyBhbHRlcm5hdGl2ZXMuPGJyPjxicj5BZ2VudDpRdGVjaF9BbmtpdGEgKFVzZXJuYW1lOiBhbmtpdGEpPGJyPjxicj5DaXR5Om11bWJhaTxicj48YnI+QXJyaXZhbCBEYXRlOjIwMjAvMDcvMjM8YnI+PGJyPkRlcGFydHVyZSBEYXRlOjIwMjAvMDcvMjQ8YnI+PGJyPlN1cHBsaWVyOmxvY2Fsc3lzdGVtPGJyPjxicj5Ib3RlbDpIWUFUVCBNVU1CQUkgUFJJTUU8YnI+PGJyPlJvb20gVHlwZToxIFByaW1lIFJvb20KUm9vbTpQcmltZSAgLUJlZCAmIEJyZWFrZmFzdCA6IDIgUGF4IAo8YnI+PGJyPkFnZW50IFByaWNlIDo1NTY1LjUzIElOUjxicj48YnI+PGJyPjxicj4gTG9nZ2VkIEZpbGUgLTxhIGhyZWY9JyBodHRwOi8vdWF0LnRmZy5vdHJhbXMubmV0L3Byb2plY3RfZm9sZGVyL3RmZ19wcm9qZWN0L3Byb3RlY3RlZC9zdXBwbGllcl9sb2dzLy9yZXNwb25zZV9wbGFjZWhvbGRlci54bWwnPmh0dHA6Ly91YXQudGZnLm90cmFtcy5uZXQvcHJvamVjdF9mb2xkZXIvdGZnX3Byb2plY3QvcHJvdGVjdGVkL3N1cHBsaWVyX2xvZ3MvL3Jlc3BvbnNlX3BsYWNlaG9sZGVyLnhtbDwvYT48YnI+PGJyPjxhIGhyZWY9JyAnPjwvYT48YnI+PGJyPg==',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/book_now.php',create_date= '2020-07-10 11:49:23';
[07/10/2020 11:51:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '21' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '3' , ip = '150.129.30.138' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/07/23' , departure_date = '2020/07/24' , nationality = '3' , nights = '1' , room_types = '2' , create_date = '2020-07-10 11:51:43' , site_id = '' , country_code = '106' , web_service = '' ;
[07/10/2020 11:51:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-07-10 11:51:47', '', 'b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7', '337');
[07/10/2020 11:51:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7&xml_user_id=21&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&web_service=no&site_id='
, http_hit_time = '2020-07-10 11:51:46.349'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.640'
, error_description = ''
, memory_used = '8021096'
WHERE id = '2874';
[07/10/2020 11:51:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=21&sessionid=b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7',
  duration = '2.246',
  merge_duration = '0.165',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '1.87',
  system_load_5_min = '2.28',
  system_load_15_min = '2.26',
  system_memory_usage = '92.32',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '337') + '8149400',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '337';
[07/10/2020 11:53:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594382025','150.129.30.138');
[07/10/2020 11:53:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelstopbooking', '2020-07-10 :11:53:45','');
[07/10/2020 11:53:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],insert into email_logs SET `subject`= 'Stop Booking in otrams.thefabulousgetaway.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VGhlIGJlbG93IGFnZW50IHdhcyByZXN0cmljdGVkIGZyb20gZG9pbmcgdGhlIGJvb2tpbmcgYXMgdGhlIHJhdGUgbWlnaHQgaGF2ZSBjaGFuZ2VkIG9yIHRoZSByb29tIGlzIG5vdCBhdmFpbGFibGUuIFlvdSBhcmUgYWR2aWNlZCB0byBjYWxsIHRoZSBhZ2VudCBhbmQgZm9sbG93IHVwIG9mZmxpbmUgYnkgc3VnZ2VzdGluZyBhbHRlcm5hdGl2ZXMuPGJyPjxicj5BZ2VudDpRdGVjaF9BbmtpdGEgKFVzZXJuYW1lOiBhbmtpdGEpPGJyPjxicj5DaXR5Om11bWJhaTxicj48YnI+QXJyaXZhbCBEYXRlOjIwMjAvMDcvMjM8YnI+PGJyPkRlcGFydHVyZSBEYXRlOjIwMjAvMDcvMjQ8YnI+PGJyPlN1cHBsaWVyOmxvY2Fsc3lzdGVtPGJyPjxicj5Ib3RlbDpIWUFUVCBNVU1CQUkgUFJJTUU8YnI+PGJyPlJvb20gVHlwZToxIFByaW1lIFJvb20KUm9vbTpQcmltZSAgLUJlZCAmIEJyZWFrZmFzdCA6IDIgUGF4IAo8YnI+PGJyPkFnZW50IFByaWNlIDo1NTY1LjUzIElOUjxicj48YnI+PGJyPjxicj4gTG9nZ2VkIEZpbGUgLTxhIGhyZWY9JyBodHRwOi8vdWF0LnRmZy5vdHJhbXMubmV0L3Byb2plY3RfZm9sZGVyL3RmZ19wcm9qZWN0L3Byb3RlY3RlZC9zdXBwbGllcl9sb2dzLy9yZXNwb25zZV9wbGFjZWhvbGRlci54bWwnPmh0dHA6Ly91YXQudGZnLm90cmFtcy5uZXQvcHJvamVjdF9mb2xkZXIvdGZnX3Byb2plY3QvcHJvdGVjdGVkL3N1cHBsaWVyX2xvZ3MvL3Jlc3BvbnNlX3BsYWNlaG9sZGVyLnhtbDwvYT48YnI+PGJyPjxhIGhyZWY9JyAnPjwvYT48YnI+PGJyPg==',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/book_now.php?selected_city=mumbai&selected_country=106&hotel_id=&source_hotel_id=&room_category=&room_loop_key=&sourceType=&roomtype_code=&valuation_file=&contract_number=&incoming_contract=&destination_code=&boardtype_code=&price=&display_curr=&selected_rooms=&arrival_date=23%2F07%2F2020&departure_date=24%2F07%2F2020&keyIndex=&isValidSelection=&localHotelId=&cancellation_policy=true',create_date= '2020-07-10 11:53:45';
[07/10/2020 11:53:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelcancellationpolicy', '2020-07-10 :11:53:45','');
[07/10/2020 11:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594382249','150.129.30.138');
[07/10/2020 11:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelstopbooking', '2020-07-10 :11:57:29','');
[07/10/2020 11:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],insert into email_logs SET `subject`= 'Stop Booking in otrams.thefabulousgetaway.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VGhlIGJlbG93IGFnZW50IHdhcyByZXN0cmljdGVkIGZyb20gZG9pbmcgdGhlIGJvb2tpbmcgYXMgdGhlIHJhdGUgbWlnaHQgaGF2ZSBjaGFuZ2VkIG9yIHRoZSByb29tIGlzIG5vdCBhdmFpbGFibGUuIFlvdSBhcmUgYWR2aWNlZCB0byBjYWxsIHRoZSBhZ2VudCBhbmQgZm9sbG93IHVwIG9mZmxpbmUgYnkgc3VnZ2VzdGluZyBhbHRlcm5hdGl2ZXMuPGJyPjxicj5BZ2VudDpRdGVjaF9BbmtpdGEgKFVzZXJuYW1lOiBhbmtpdGEpPGJyPjxicj5DaXR5Om11bWJhaTxicj48YnI+QXJyaXZhbCBEYXRlOjIwMjAvMDcvMjM8YnI+PGJyPkRlcGFydHVyZSBEYXRlOjIwMjAvMDcvMjQ8YnI+PGJyPlN1cHBsaWVyOmxvY2Fsc3lzdGVtPGJyPjxicj5Ib3RlbDpIWUFUVCBNVU1CQUkgUFJJTUU8YnI+PGJyPlJvb20gVHlwZToxIFByaW1lIFJvb20KUm9vbTpQcmltZSAgLUJlZCAmIEJyZWFrZmFzdCA6IDIgUGF4IAo8YnI+PGJyPkFnZW50IFByaWNlIDo1NTY1LjUzIElOUjxicj48YnI+PGJyPjxicj4gTG9nZ2VkIEZpbGUgLTxhIGhyZWY9JyBodHRwOi8vdWF0LnRmZy5vdHJhbXMubmV0L3Byb2plY3RfZm9sZGVyL3RmZ19wcm9qZWN0L3Byb3RlY3RlZC9zdXBwbGllcl9sb2dzLy9yZXNwb25zZV9wbGFjZWhvbGRlci54bWwnPmh0dHA6Ly91YXQudGZnLm90cmFtcy5uZXQvcHJvamVjdF9mb2xkZXIvdGZnX3Byb2plY3QvcHJvdGVjdGVkL3N1cHBsaWVyX2xvZ3MvL3Jlc3BvbnNlX3BsYWNlaG9sZGVyLnhtbDwvYT48YnI+PGJyPjxhIGhyZWY9JyAnPjwvYT48YnI+PGJyPg==',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/book_now.php?selected_city=mumbai&selected_country=106&hotel_id=&source_hotel_id=&room_category=&room_loop_key=&sourceType=&roomtype_code=&valuation_file=&contract_number=&incoming_contract=&destination_code=&boardtype_code=&price=&display_curr=&selected_rooms=&arrival_date=23%2F07%2F2020&departure_date=24%2F07%2F2020&keyIndex=&isValidSelection=&localHotelId=&cancellation_policy=true',create_date= '2020-07-10 11:57:29';
[07/10/2020 11:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelcancellationpolicy', '2020-07-10 :11:57:29','');
[07/10/2020 11:57:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594382274','150.129.30.138');
[07/10/2020 11:57:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelstopbooking', '2020-07-10 :11:57:54','');
[07/10/2020 11:57:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],insert into email_logs SET `subject`= 'Stop Booking in otrams.thefabulousgetaway.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VGhlIGJlbG93IGFnZW50IHdhcyByZXN0cmljdGVkIGZyb20gZG9pbmcgdGhlIGJvb2tpbmcgYXMgdGhlIHJhdGUgbWlnaHQgaGF2ZSBjaGFuZ2VkIG9yIHRoZSByb29tIGlzIG5vdCBhdmFpbGFibGUuIFlvdSBhcmUgYWR2aWNlZCB0byBjYWxsIHRoZSBhZ2VudCBhbmQgZm9sbG93IHVwIG9mZmxpbmUgYnkgc3VnZ2VzdGluZyBhbHRlcm5hdGl2ZXMuPGJyPjxicj5BZ2VudDpRdGVjaF9BbmtpdGEgKFVzZXJuYW1lOiBhbmtpdGEpPGJyPjxicj5DaXR5Om11bWJhaTxicj48YnI+QXJyaXZhbCBEYXRlOjIwMjAvMDcvMjM8YnI+PGJyPkRlcGFydHVyZSBEYXRlOjIwMjAvMDcvMjQ8YnI+PGJyPlN1cHBsaWVyOmxvY2Fsc3lzdGVtPGJyPjxicj5Ib3RlbDpIWUFUVCBNVU1CQUkgUFJJTUU8YnI+PGJyPlJvb20gVHlwZToxIFByaW1lIFJvb20KUm9vbTpQcmltZSAgLUJlZCAmIEJyZWFrZmFzdCA6IDIgUGF4IAo8YnI+PGJyPkFnZW50IFByaWNlIDo1NTY1LjUzIElOUjxicj48YnI+PGJyPjxicj4gTG9nZ2VkIEZpbGUgLTxhIGhyZWY9JyBodHRwOi8vdWF0LnRmZy5vdHJhbXMubmV0L3Byb2plY3RfZm9sZGVyL3RmZ19wcm9qZWN0L3Byb3RlY3RlZC9zdXBwbGllcl9sb2dzLy9yZXNwb25zZV9wbGFjZWhvbGRlci54bWwnPmh0dHA6Ly91YXQudGZnLm90cmFtcy5uZXQvcHJvamVjdF9mb2xkZXIvdGZnX3Byb2plY3QvcHJvdGVjdGVkL3N1cHBsaWVyX2xvZ3MvL3Jlc3BvbnNlX3BsYWNlaG9sZGVyLnhtbDwvYT48YnI+PGJyPjxhIGhyZWY9JyAnPjwvYT48YnI+PGJyPg==',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/book_now.php?selected_city=mumbai&selected_country=106&hotel_id=&source_hotel_id=&room_category=&room_loop_key=&sourceType=&roomtype_code=&valuation_file=&contract_number=&incoming_contract=&destination_code=&boardtype_code=&price=&display_curr=&selected_rooms=&arrival_date=23%2F07%2F2020&departure_date=24%2F07%2F2020&keyIndex=&isValidSelection=&localHotelId=&cancellation_policy=true',create_date= '2020-07-10 11:57:55';
[07/10/2020 11:57:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelcancellationpolicy', '2020-07-10 :11:57:55','');
[07/10/2020 11:58:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594382312','150.129.30.138');
[07/10/2020 11:58:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelstopbooking', '2020-07-10 :11:58:32','');
[07/10/2020 11:58:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],insert into email_logs SET `subject`= 'Stop Booking in otrams.thefabulousgetaway.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VGhlIGJlbG93IGFnZW50IHdhcyByZXN0cmljdGVkIGZyb20gZG9pbmcgdGhlIGJvb2tpbmcgYXMgdGhlIHJhdGUgbWlnaHQgaGF2ZSBjaGFuZ2VkIG9yIHRoZSByb29tIGlzIG5vdCBhdmFpbGFibGUuIFlvdSBhcmUgYWR2aWNlZCB0byBjYWxsIHRoZSBhZ2VudCBhbmQgZm9sbG93IHVwIG9mZmxpbmUgYnkgc3VnZ2VzdGluZyBhbHRlcm5hdGl2ZXMuPGJyPjxicj5BZ2VudDpRdGVjaF9BbmtpdGEgKFVzZXJuYW1lOiBhbmtpdGEpPGJyPjxicj5DaXR5Om11bWJhaTxicj48YnI+QXJyaXZhbCBEYXRlOjIwMjAvMDcvMjM8YnI+PGJyPkRlcGFydHVyZSBEYXRlOjIwMjAvMDcvMjQ8YnI+PGJyPlN1cHBsaWVyOmxvY2Fsc3lzdGVtPGJyPjxicj5Ib3RlbDpIWUFUVCBNVU1CQUkgUFJJTUU8YnI+PGJyPlJvb20gVHlwZToxIFByaW1lIFJvb20KUm9vbTpQcmltZSAgLUJlZCAmIEJyZWFrZmFzdCA6IDIgUGF4IAo8YnI+PGJyPkFnZW50IFByaWNlIDo1NTY1LjUzIElOUjxicj48YnI+PGJyPjxicj4gTG9nZ2VkIEZpbGUgLTxhIGhyZWY9JyBodHRwOi8vdWF0LnRmZy5vdHJhbXMubmV0L3Byb2plY3RfZm9sZGVyL3RmZ19wcm9qZWN0L3Byb3RlY3RlZC9zdXBwbGllcl9sb2dzLy9yZXNwb25zZV9wbGFjZWhvbGRlci54bWwnPmh0dHA6Ly91YXQudGZnLm90cmFtcy5uZXQvcHJvamVjdF9mb2xkZXIvdGZnX3Byb2plY3QvcHJvdGVjdGVkL3N1cHBsaWVyX2xvZ3MvL3Jlc3BvbnNlX3BsYWNlaG9sZGVyLnhtbDwvYT48YnI+PGJyPjxhIGhyZWY9JyAnPjwvYT48YnI+PGJyPg==',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/book_now.php?selected_city=mumbai&selected_country=106&hotel_id=&source_hotel_id=&room_category=&room_loop_key=&sourceType=&roomtype_code=&valuation_file=&contract_number=&incoming_contract=&destination_code=&boardtype_code=&price=&display_curr=&selected_rooms=&arrival_date=23%2F07%2F2020&departure_date=24%2F07%2F2020&keyIndex=&isValidSelection=&localHotelId=&cancellation_policy=true',create_date= '2020-07-10 11:58:32';
[07/10/2020 11:58:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelcancellationpolicy', '2020-07-10 :11:58:32','');
[07/10/2020 11:58:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594382318','150.129.30.138');
[07/10/2020 11:58:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelstopbooking', '2020-07-10 :11:58:38','');
[07/10/2020 11:58:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],insert into email_logs SET `subject`= 'Stop Booking in otrams.thefabulousgetaway.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VGhlIGJlbG93IGFnZW50IHdhcyByZXN0cmljdGVkIGZyb20gZG9pbmcgdGhlIGJvb2tpbmcgYXMgdGhlIHJhdGUgbWlnaHQgaGF2ZSBjaGFuZ2VkIG9yIHRoZSByb29tIGlzIG5vdCBhdmFpbGFibGUuIFlvdSBhcmUgYWR2aWNlZCB0byBjYWxsIHRoZSBhZ2VudCBhbmQgZm9sbG93IHVwIG9mZmxpbmUgYnkgc3VnZ2VzdGluZyBhbHRlcm5hdGl2ZXMuPGJyPjxicj5BZ2VudDpRdGVjaF9BbmtpdGEgKFVzZXJuYW1lOiBhbmtpdGEpPGJyPjxicj5DaXR5Om11bWJhaTxicj48YnI+QXJyaXZhbCBEYXRlOjIwMjAvMDcvMjM8YnI+PGJyPkRlcGFydHVyZSBEYXRlOjIwMjAvMDcvMjQ8YnI+PGJyPlN1cHBsaWVyOmxvY2Fsc3lzdGVtPGJyPjxicj5Ib3RlbDpIWUFUVCBNVU1CQUkgUFJJTUU8YnI+PGJyPlJvb20gVHlwZToxIFByaW1lIFJvb20KUm9vbTpQcmltZSAgLUJlZCAmIEJyZWFrZmFzdCA6IDIgUGF4IAo8YnI+PGJyPkFnZW50IFByaWNlIDo1NTY1LjUzIElOUjxicj48YnI+PGJyPjxicj4gTG9nZ2VkIEZpbGUgLTxhIGhyZWY9JyBodHRwOi8vdWF0LnRmZy5vdHJhbXMubmV0L3Byb2plY3RfZm9sZGVyL3RmZ19wcm9qZWN0L3Byb3RlY3RlZC9zdXBwbGllcl9sb2dzLy9yZXNwb25zZV9wbGFjZWhvbGRlci54bWwnPmh0dHA6Ly91YXQudGZnLm90cmFtcy5uZXQvcHJvamVjdF9mb2xkZXIvdGZnX3Byb2plY3QvcHJvdGVjdGVkL3N1cHBsaWVyX2xvZ3MvL3Jlc3BvbnNlX3BsYWNlaG9sZGVyLnhtbDwvYT48YnI+PGJyPjxhIGhyZWY9JyAnPjwvYT48YnI+PGJyPg==',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/book_now.php?selected_city=mumbai&selected_country=106&hotel_id=&source_hotel_id=&room_category=&room_loop_key=&sourceType=&roomtype_code=&valuation_file=&contract_number=&incoming_contract=&destination_code=&boardtype_code=&price=&display_curr=&selected_rooms=&arrival_date=23%2F07%2F2020&departure_date=24%2F07%2F2020&keyIndex=&isValidSelection=&localHotelId=&cancellation_policy=true',create_date= '2020-07-10 11:58:38';
[07/10/2020 11:58:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelcancellationpolicy', '2020-07-10 :11:58:38','');
[07/10/2020 11:58:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594382328','150.129.30.138');
[07/10/2020 11:58:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelstopbooking', '2020-07-10 :11:58:48','');
[07/10/2020 11:58:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],insert into email_logs SET `subject`= 'Stop Booking in otrams.thefabulousgetaway.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VGhlIGJlbG93IGFnZW50IHdhcyByZXN0cmljdGVkIGZyb20gZG9pbmcgdGhlIGJvb2tpbmcgYXMgdGhlIHJhdGUgbWlnaHQgaGF2ZSBjaGFuZ2VkIG9yIHRoZSByb29tIGlzIG5vdCBhdmFpbGFibGUuIFlvdSBhcmUgYWR2aWNlZCB0byBjYWxsIHRoZSBhZ2VudCBhbmQgZm9sbG93IHVwIG9mZmxpbmUgYnkgc3VnZ2VzdGluZyBhbHRlcm5hdGl2ZXMuPGJyPjxicj5BZ2VudDpRdGVjaF9BbmtpdGEgKFVzZXJuYW1lOiBhbmtpdGEpPGJyPjxicj5DaXR5Om11bWJhaTxicj48YnI+QXJyaXZhbCBEYXRlOjIwMjAvMDcvMjM8YnI+PGJyPkRlcGFydHVyZSBEYXRlOjIwMjAvMDcvMjQ8YnI+PGJyPlN1cHBsaWVyOmxvY2Fsc3lzdGVtPGJyPjxicj5Ib3RlbDpIWUFUVCBNVU1CQUkgUFJJTUU8YnI+PGJyPlJvb20gVHlwZToxIFByaW1lIFJvb20KUm9vbTpQcmltZSAgLUJlZCAmIEJyZWFrZmFzdCA6IDIgUGF4IAo8YnI+PGJyPkFnZW50IFByaWNlIDo1NTY1LjUzIElOUjxicj48YnI+PGJyPjxicj4gTG9nZ2VkIEZpbGUgLTxhIGhyZWY9JyBodHRwOi8vdWF0LnRmZy5vdHJhbXMubmV0L3Byb2plY3RfZm9sZGVyL3RmZ19wcm9qZWN0L3Byb3RlY3RlZC9zdXBwbGllcl9sb2dzLy9yZXNwb25zZV9wbGFjZWhvbGRlci54bWwnPmh0dHA6Ly91YXQudGZnLm90cmFtcy5uZXQvcHJvamVjdF9mb2xkZXIvdGZnX3Byb2plY3QvcHJvdGVjdGVkL3N1cHBsaWVyX2xvZ3MvL3Jlc3BvbnNlX3BsYWNlaG9sZGVyLnhtbDwvYT48YnI+PGJyPjxhIGhyZWY9JyAnPjwvYT48YnI+PGJyPg==',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/book_now.php?selected_city=mumbai&selected_country=106&hotel_id=&source_hotel_id=&room_category=&room_loop_key=&sourceType=&roomtype_code=&valuation_file=&contract_number=&incoming_contract=&destination_code=&boardtype_code=&price=&display_curr=&selected_rooms=&arrival_date=23%2F07%2F2020&departure_date=24%2F07%2F2020&keyIndex=&isValidSelection=&localHotelId=&cancellation_policy=true',create_date= '2020-07-10 11:58:48';
[07/10/2020 11:58:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelcancellationpolicy', '2020-07-10 :11:58:48','');
[07/10/2020 11:59:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594382382','150.129.30.138');
[07/10/2020 11:59:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelstopbooking', '2020-07-10 :11:59:42','');
[07/10/2020 11:59:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],insert into email_logs SET `subject`= 'Stop Booking in otrams.thefabulousgetaway.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VGhlIGJlbG93IGFnZW50IHdhcyByZXN0cmljdGVkIGZyb20gZG9pbmcgdGhlIGJvb2tpbmcgYXMgdGhlIHJhdGUgbWlnaHQgaGF2ZSBjaGFuZ2VkIG9yIHRoZSByb29tIGlzIG5vdCBhdmFpbGFibGUuIFlvdSBhcmUgYWR2aWNlZCB0byBjYWxsIHRoZSBhZ2VudCBhbmQgZm9sbG93IHVwIG9mZmxpbmUgYnkgc3VnZ2VzdGluZyBhbHRlcm5hdGl2ZXMuPGJyPjxicj5BZ2VudDpRdGVjaF9BbmtpdGEgKFVzZXJuYW1lOiBhbmtpdGEpPGJyPjxicj5DaXR5Om11bWJhaTxicj48YnI+QXJyaXZhbCBEYXRlOjIwMjAvMDcvMjM8YnI+PGJyPkRlcGFydHVyZSBEYXRlOjIwMjAvMDcvMjQ8YnI+PGJyPlN1cHBsaWVyOmxvY2Fsc3lzdGVtPGJyPjxicj5Ib3RlbDpIWUFUVCBNVU1CQUkgUFJJTUU8YnI+PGJyPlJvb20gVHlwZToxIFByaW1lIFJvb20KUm9vbTpQcmltZSAgLUJlZCAmIEJyZWFrZmFzdCA6IDIgUGF4IAo8YnI+PGJyPkFnZW50IFByaWNlIDo1NTY1LjUzIElOUjxicj48YnI+PGJyPjxicj4gTG9nZ2VkIEZpbGUgLTxhIGhyZWY9JyBodHRwOi8vdWF0LnRmZy5vdHJhbXMubmV0L3Byb2plY3RfZm9sZGVyL3RmZ19wcm9qZWN0L3Byb3RlY3RlZC9zdXBwbGllcl9sb2dzLy9yZXNwb25zZV9wbGFjZWhvbGRlci54bWwnPmh0dHA6Ly91YXQudGZnLm90cmFtcy5uZXQvcHJvamVjdF9mb2xkZXIvdGZnX3Byb2plY3QvcHJvdGVjdGVkL3N1cHBsaWVyX2xvZ3MvL3Jlc3BvbnNlX3BsYWNlaG9sZGVyLnhtbDwvYT48YnI+PGJyPjxhIGhyZWY9JyAnPjwvYT48YnI+PGJyPg==',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/book_now.php?selected_city=mumbai&selected_country=106&ez_queries=1&arrival_date=23/07/2020&departure_date=24/07/2020&cancellation_policy=true',create_date= '2020-07-10 11:59:43';
[07/10/2020 11:59:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelcancellationpolicy', '2020-07-10 :11:59:43','');
[07/10/2020 11:59:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594382387','150.129.30.138');
[07/10/2020 11:59:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelstopbooking', '2020-07-10 :11:59:47','');
[07/10/2020 11:59:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],insert into email_logs SET `subject`= 'Stop Booking in otrams.thefabulousgetaway.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VGhlIGJlbG93IGFnZW50IHdhcyByZXN0cmljdGVkIGZyb20gZG9pbmcgdGhlIGJvb2tpbmcgYXMgdGhlIHJhdGUgbWlnaHQgaGF2ZSBjaGFuZ2VkIG9yIHRoZSByb29tIGlzIG5vdCBhdmFpbGFibGUuIFlvdSBhcmUgYWR2aWNlZCB0byBjYWxsIHRoZSBhZ2VudCBhbmQgZm9sbG93IHVwIG9mZmxpbmUgYnkgc3VnZ2VzdGluZyBhbHRlcm5hdGl2ZXMuPGJyPjxicj5BZ2VudDpRdGVjaF9BbmtpdGEgKFVzZXJuYW1lOiBhbmtpdGEpPGJyPjxicj5DaXR5Om11bWJhaTxicj48YnI+QXJyaXZhbCBEYXRlOjIwMjAvMDcvMjM8YnI+PGJyPkRlcGFydHVyZSBEYXRlOjIwMjAvMDcvMjQ8YnI+PGJyPlN1cHBsaWVyOmxvY2Fsc3lzdGVtPGJyPjxicj5Ib3RlbDpIWUFUVCBNVU1CQUkgUFJJTUU8YnI+PGJyPlJvb20gVHlwZToxIFByaW1lIFJvb20KUm9vbTpQcmltZSAgLUJlZCAmIEJyZWFrZmFzdCA6IDIgUGF4IAo8YnI+PGJyPkFnZW50IFByaWNlIDo1NTY1LjUzIElOUjxicj48YnI+PGJyPjxicj4gTG9nZ2VkIEZpbGUgLTxhIGhyZWY9JyBodHRwOi8vdWF0LnRmZy5vdHJhbXMubmV0L3Byb2plY3RfZm9sZGVyL3RmZ19wcm9qZWN0L3Byb3RlY3RlZC9zdXBwbGllcl9sb2dzLy9yZXNwb25zZV9wbGFjZWhvbGRlci54bWwnPmh0dHA6Ly91YXQudGZnLm90cmFtcy5uZXQvcHJvamVjdF9mb2xkZXIvdGZnX3Byb2plY3QvcHJvdGVjdGVkL3N1cHBsaWVyX2xvZ3MvL3Jlc3BvbnNlX3BsYWNlaG9sZGVyLnhtbDwvYT48YnI+PGJyPjxhIGhyZWY9JyAnPjwvYT48YnI+PGJyPg==',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/book_now.php?selected_city=mumbai&selected_country=106&ez_queries=1&arrival_date=23/07/2020&departure_date=24/07/2020&cancellation_policy=true',create_date= '2020-07-10 11:59:47';
[07/10/2020 11:59:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelcancellationpolicy', '2020-07-10 :11:59:48','');
