[10/24/2020 11:00:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO hotel_supplier_currency_mapping SET SupplierId ='S000000212',hotel_id ='53776',currency_code ='AED',city_code ='64440',country_code ='106',created_datetime ='2020-10-24 11:00:15',created_by ='#supplier#',ip_addr ='60.254.11.53';
[10/24/2020 11:00:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO room_rates (room_rate_code,rate_group,hotel_id,supplier_id,date_from,date_to,room_class,room_basis,ip_addr,room_type,view_basis,edit_time_stamp,weekend,rate_profile,entered_by,inventory_class_id,status,weekday_rate,weekend_rate,currency,minstay,availability,time_limit,checkin_block_for,exclude_countries,exclude_residence,stop_sale,time_stamp,created_datetime,create_date,created_by,changed_by,modify_date,modified_datetime,modified_by,consumed_inventory,stay_note) values ('53776@S000000212@2020-10-24@2020-10-24@@893@1@1@@@0','24-10-2020~24-10-2020','53776','S000000212','2020-10-24','2020-10-24','893','1','60.254.11.53','0','0','1764cf56c7127ff218a2a5176d27ea41','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','1764cf56c7127ff218a2a5176d27ea41','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0','');
[10/24/2020 11:00:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],DELETE  FROM room_rates WHERE id IN ('');
[10/24/2020 11:00:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-10-24 11:00:15',`log_type`= 'Rates',`sql_query`= '',`log_description`= 'Inserted Rates For IndigoDeli Rate:- 200 Room Category :- ROH (Standard/Superior) - Double (Bed & Breakfast) Market :- All Market From:- 24-10-2020 To:- 30-11-2020',`ip`= '60.254.11.53',`username`= 'tfg',`user_id`= 'S000000212';
[10/24/2020 11:00:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3836', `entity`='Hotels', `value`='53776' ;
[10/24/2020 11:00:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3836', `entity`='Suppliers', `value`='S000000212' ;
[10/24/2020 11:00:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3836', `entity`='Inventory', `value`='140' ;
[10/24/2020 11:00:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3836', `entity`='Room', `value`='893' ;
[10/24/2020 11:00:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3836', `entity`='Market', `value`='1' ;
[10/24/2020 11:00:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-10-24 11:00:15',`log_type`= 'Rates',`sql_query`= '',`log_description`= 'Inserted Rates For IndigoDeli Rate:- 100 Room Category :- ROH (Standard/Superior) - Single - NR (Bed & Breakfast) Market :- All Market From:- 24-10-2020 To:- 30-11-2020',`ip`= '60.254.11.53',`username`= 'tfg',`user_id`= 'S000000212';
[10/24/2020 11:00:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3837', `entity`='Hotels', `value`='53776' ;
[10/24/2020 11:00:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3837', `entity`='Suppliers', `value`='S000000212' ;
[10/24/2020 11:00:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3837', `entity`='Inventory', `value`='140' ;
[10/24/2020 11:00:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3837', `entity`='Room', `value`='892' ;
[10/24/2020 11:00:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3837', `entity`='Market', `value`='1' ;
[10/24/2020 11:00:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO room_rates (room_rate_code,rate_group,hotel_id,supplier_id,date_from,date_to,room_class,room_basis,ip_addr,room_type,view_basis,edit_time_stamp,weekend,rate_profile,entered_by,inventory_class_id,status,weekday_rate,weekend_rate,currency,minstay,availability,time_limit,checkin_block_for,exclude_countries,exclude_residence,stop_sale,time_stamp,created_datetime,create_date,created_by,changed_by,modify_date,modified_datetime,modified_by,consumed_inventory,stay_note) values ('53776@S000000212@2020-10-25@2020-10-25@@893@1@1@@@0','25-10-2020~25-10-2020','53776','S000000212','2020-10-25','2020-10-25','893','1','60.254.11.53','0','0','86508f74ec3b0ebd1383a4373baffdf8','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','86508f74ec3b0ebd1383a4373baffdf8','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-10-26@2020-10-26@@893@1@1@@@0','26-10-2020~26-10-2020','53776','S000000212','2020-10-26','2020-10-26','893','1','60.254.11.53','0','0','8e840812ab4dca9c02ab0455d4c50fc7','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','8e840812ab4dca9c02ab0455d4c50fc7','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-10-27@2020-10-27@@893@1@1@@@0','27-10-2020~27-10-2020','53776','S000000212','2020-10-27','2020-10-27','893','1','60.254.11.53','0','0','905f00e9bcdf68d25b7f668e6a0acd86','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','905f00e9bcdf68d25b7f668e6a0acd86','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-10-28@2020-10-28@@893@1@1@@@0','28-10-2020~28-10-2020','53776','S000000212','2020-10-28','2020-10-28','893','1','60.254.11.53','0','0','7a4bf1d6cfb9d643935c0fd915cd82bc','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','7a4bf1d6cfb9d643935c0fd915cd82bc','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-10-29@2020-10-29@@893@1@1@@@0','29-10-2020~29-10-2020','53776','S000000212','2020-10-29','2020-10-29','893','1','60.254.11.53','0','0','09ab730b7fb9802e49f3f3794ee283d0','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','09ab730b7fb9802e49f3f3794ee283d0','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-10-30@2020-10-30@@893@1@1@@@0','30-10-2020~30-10-2020','53776','S000000212','2020-10-30','2020-10-30','893','1','60.254.11.53','0','0','2fa8d1c5834a1ae3cb0c3c510c25c5b5','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','2fa8d1c5834a1ae3cb0c3c510c25c5b5','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-10-31@2020-10-31@@893@1@1@@@0','31-10-2020~31-10-2020','53776','S000000212','2020-10-31','2020-10-31','893','1','60.254.11.53','0','0','5299d434d36042cddb0f9372b13c2339','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','5299d434d36042cddb0f9372b13c2339','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-01@2020-11-01@@893@1@1@@@0','01-11-2020~01-11-2020','53776','S000000212','2020-11-01','2020-11-01','893','1','60.254.11.53','0','0','227cdea3e8131ac64d50ea1187ffcbff','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','227cdea3e8131ac64d50ea1187ffcbff','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-02@2020-11-02@@893@1@1@@@0','02-11-2020~02-11-2020','53776','S000000212','2020-11-02','2020-11-02','893','1','60.254.11.53','0','0','ffb8963c3fce3a27c5510d4334c8b508','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','ffb8963c3fce3a27c5510d4334c8b508','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-03@2020-11-03@@893@1@1@@@0','03-11-2020~03-11-2020','53776','S000000212','2020-11-03','2020-11-03','893','1','60.254.11.53','0','0','dbf12974b48779ac7bfaf258990e0b56','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','dbf12974b48779ac7bfaf258990e0b56','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-04@2020-11-04@@893@1@1@@@0','04-11-2020~04-11-2020','53776','S000000212','2020-11-04','2020-11-04','893','1','60.254.11.53','0','0','d3923c7252a2d1c53e6ca847bbe7e57a','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','d3923c7252a2d1c53e6ca847bbe7e57a','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-05@2020-11-05@@893@1@1@@@0','05-11-2020~05-11-2020','53776','S000000212','2020-11-05','2020-11-05','893','1','60.254.11.53','0','0','16ca1c36932e3a443c76a06f4491d95a','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','16ca1c36932e3a443c76a06f4491d95a','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-06@2020-11-06@@893@1@1@@@0','06-11-2020~06-11-2020','53776','S000000212','2020-11-06','2020-11-06','893','1','60.254.11.53','0','0','a50f8ea68e4c2604b5719ecd2108891e','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','a50f8ea68e4c2604b5719ecd2108891e','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-07@2020-11-07@@893@1@1@@@0','07-11-2020~07-11-2020','53776','S000000212','2020-11-07','2020-11-07','893','1','60.254.11.53','0','0','c84fe9464fb74f0ed5d495614932735d','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','c84fe9464fb74f0ed5d495614932735d','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-08@2020-11-08@@893@1@1@@@0','08-11-2020~08-11-2020','53776','S000000212','2020-11-08','2020-11-08','893','1','60.254.11.53','0','0','3095f33aa762bf7205ff52c659d4523a','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','3095f33aa762bf7205ff52c659d4523a','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-09@2020-11-09@@893@1@1@@@0','09-11-2020~09-11-2020','53776','S000000212','2020-11-09','2020-11-09','893','1','60.254.11.53','0','0','7af6c19f8276d1aba8b1d6da30bc2c74','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','7af6c19f8276d1aba8b1d6da30bc2c74','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-10@2020-11-10@@893@1@1@@@0','10-11-2020~10-11-2020','53776','S000000212','2020-11-10','2020-11-10','893','1','60.254.11.53','0','0','a15c4a3b00540f16f0aef9a8495a9c46','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','a15c4a3b00540f16f0aef9a8495a9c46','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-11@2020-11-11@@893@1@1@@@0','11-11-2020~11-11-2020','53776','S000000212','2020-11-11','2020-11-11','893','1','60.254.11.53','0','0','eba61ae325ed0cbece426365e96bdedd','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','eba61ae325ed0cbece426365e96bdedd','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-12@2020-11-12@@893@1@1@@@0','12-11-2020~12-11-2020','53776','S000000212','2020-11-12','2020-11-12','893','1','60.254.11.53','0','0','f237ef69814f958e1f939169807b1a15','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','f237ef69814f958e1f939169807b1a15','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-13@2020-11-13@@893@1@1@@@0','13-11-2020~13-11-2020','53776','S000000212','2020-11-13','2020-11-13','893','1','60.254.11.53','0','0','f2241e2c64304fbeee4d0b4b5b47ab04','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','f2241e2c64304fbeee4d0b4b5b47ab04','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-14@2020-11-14@@893@1@1@@@0','14-11-2020~14-11-2020','53776','S000000212','2020-11-14','2020-11-14','893','1','60.254.11.53','0','0','35213805e5b1ee7b25d515012caa49cd','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','35213805e5b1ee7b25d515012caa49cd','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-15@2020-11-15@@893@1@1@@@0','15-11-2020~15-11-2020','53776','S000000212','2020-11-15','2020-11-15','893','1','60.254.11.53','0','0','726500d3f0414debf9f4baaf74de9919','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','726500d3f0414debf9f4baaf74de9919','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-16@2020-11-16@@893@1@1@@@0','16-11-2020~16-11-2020','53776','S000000212','2020-11-16','2020-11-16','893','1','60.254.11.53','0','0','480542adf8a032cb365113770098ab77','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','480542adf8a032cb365113770098ab77','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-17@2020-11-17@@893@1@1@@@0','17-11-2020~17-11-2020','53776','S000000212','2020-11-17','2020-11-17','893','1','60.254.11.53','0','0','832a77b9c079e8945de9c864fc717599','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','832a77b9c079e8945de9c864fc717599','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-18@2020-11-18@@893@1@1@@@0','18-11-2020~18-11-2020','53776','S000000212','2020-11-18','2020-11-18','893','1','60.254.11.53','0','0','fb233b9daad75324fb78c12f5a6dbba5','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','fb233b9daad75324fb78c12f5a6dbba5','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-19@2020-11-19@@893@1@1@@@0','19-11-2020~19-11-2020','53776','S000000212','2020-11-19','2020-11-19','893','1','60.254.11.53','0','0','6d29bdb8b576da8ff17cda2a4b4cd284','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','6d29bdb8b576da8ff17cda2a4b4cd284','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-20@2020-11-20@@893@1@1@@@0','20-11-2020~20-11-2020','53776','S000000212','2020-11-20','2020-11-20','893','1','60.254.11.53','0','0','9e762d69543dc876339f457ecda79ffb','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','9e762d69543dc876339f457ecda79ffb','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-21@2020-11-21@@893@1@1@@@0','21-11-2020~21-11-2020','53776','S000000212','2020-11-21','2020-11-21','893','1','60.254.11.53','0','0','cc75b9b3c1775af0806d1ec3d9a63407','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','cc75b9b3c1775af0806d1ec3d9a63407','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-22@2020-11-22@@893@1@1@@@0','22-11-2020~22-11-2020','53776','S000000212','2020-11-22','2020-11-22','893','1','60.254.11.53','0','0','15f00a3e5cade60872ed6db799415e17','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','15f00a3e5cade60872ed6db799415e17','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-23@2020-11-23@@893@1@1@@@0','23-11-2020~23-11-2020','53776','S000000212','2020-11-23','2020-11-23','893','1','60.254.11.53','0','0','64e2ddf8f381e03c8bf8f5d3e2b85583','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','64e2ddf8f381e03c8bf8f5d3e2b85583','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-24@2020-11-24@@893@1@1@@@0','24-11-2020~24-11-2020','53776','S000000212','2020-11-24','2020-11-24','893','1','60.254.11.53','0','0','035e52c7e98753b1e3ecb6292c1d951e','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','035e52c7e98753b1e3ecb6292c1d951e','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-25@2020-11-25@@893@1@1@@@0','25-11-2020~25-11-2020','53776','S000000212','2020-11-25','2020-11-25','893','1','60.254.11.53','0','0','b28c53d9534eeef4d85276b8f273e3aa','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','b28c53d9534eeef4d85276b8f273e3aa','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-26@2020-11-26@@893@1@1@@@0','26-11-2020~26-11-2020','53776','S000000212','2020-11-26','2020-11-26','893','1','60.254.11.53','0','0','8d2c9560b5e2421f8b991dc55fb0486d','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','8d2c9560b5e2421f8b991dc55fb0486d','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-27@2020-11-27@@893@1@1@@@0','27-11-2020~27-11-2020','53776','S000000212','2020-11-27','2020-11-27','893','1','60.254.11.53','0','0','0d4d33fc1518a9097cf60a8772d516ac','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','0d4d33fc1518a9097cf60a8772d516ac','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-28@2020-11-28@@893@1@1@@@0','28-11-2020~28-11-2020','53776','S000000212','2020-11-28','2020-11-28','893','1','60.254.11.53','0','0','0bf36cf5bbc4bf8f37d91e35dc75c71d','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','0bf36cf5bbc4bf8f37d91e35dc75c71d','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-29@2020-11-29@@893@1@1@@@0','29-11-2020~29-11-2020','53776','S000000212','2020-11-29','2020-11-29','893','1','60.254.11.53','0','0','26bed74e07c0a11f91e96260575f92b6','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','26bed74e07c0a11f91e96260575f92b6','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-30@2020-11-30@@893@1@1@@@0','30-11-2020~30-11-2020','53776','S000000212','2020-11-30','2020-11-30','893','1','60.254.11.53','0','0','b59df4e14cdc298399e07ca31c0c5913','Sa,Su','1','Supplier','140','A','200','200','AED','0','0','0','0','','','0','b59df4e14cdc298399e07ca31c0c5913','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-10-24@2020-10-24@@892@1@1@@@0','24-10-2020~24-10-2020','53776','S000000212','2020-10-24','2020-10-24','892','1','60.254.11.53','0','0','54303bcf82afd4239d9c176144f7fddf','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','54303bcf82afd4239d9c176144f7fddf','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-10-25@2020-10-25@@892@1@1@@@0','25-10-2020~25-10-2020','53776','S000000212','2020-10-25','2020-10-25','892','1','60.254.11.53','0','0','0c833301f04ac901461d3df3d110837d','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','0c833301f04ac901461d3df3d110837d','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-10-26@2020-10-26@@892@1@1@@@0','26-10-2020~26-10-2020','53776','S000000212','2020-10-26','2020-10-26','892','1','60.254.11.53','0','0','0b03a1cf35474ace8cdf18a36425da6b','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','0b03a1cf35474ace8cdf18a36425da6b','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-10-27@2020-10-27@@892@1@1@@@0','27-10-2020~27-10-2020','53776','S000000212','2020-10-27','2020-10-27','892','1','60.254.11.53','0','0','3499e0d56279b2857d4d2a6173df4d03','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','3499e0d56279b2857d4d2a6173df4d03','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-10-28@2020-10-28@@892@1@1@@@0','28-10-2020~28-10-2020','53776','S000000212','2020-10-28','2020-10-28','892','1','60.254.11.53','0','0','48bd7d6b407aaf5604057e881e8faa92','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','48bd7d6b407aaf5604057e881e8faa92','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-10-29@2020-10-29@@892@1@1@@@0','29-10-2020~29-10-2020','53776','S000000212','2020-10-29','2020-10-29','892','1','60.254.11.53','0','0','07155df525b8b8028e6c7b30d7caf046','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','07155df525b8b8028e6c7b30d7caf046','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-10-30@2020-10-30@@892@1@1@@@0','30-10-2020~30-10-2020','53776','S000000212','2020-10-30','2020-10-30','892','1','60.254.11.53','0','0','5bb30e8ead8f41a6af28bcd222c80484','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','5bb30e8ead8f41a6af28bcd222c80484','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-10-31@2020-10-31@@892@1@1@@@0','31-10-2020~31-10-2020','53776','S000000212','2020-10-31','2020-10-31','892','1','60.254.11.53','0','0','86b7b28d75475ecb434c995e55252413','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','86b7b28d75475ecb434c995e55252413','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-01@2020-11-01@@892@1@1@@@0','01-11-2020~01-11-2020','53776','S000000212','2020-11-01','2020-11-01','892','1','60.254.11.53','0','0','00f50e74dc6267e8effcec95078472ba','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','00f50e74dc6267e8effcec95078472ba','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-02@2020-11-02@@892@1@1@@@0','02-11-2020~02-11-2020','53776','S000000212','2020-11-02','2020-11-02','892','1','60.254.11.53','0','0','d2c20c1d25353ddfd18fd4072159b9fb','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','d2c20c1d25353ddfd18fd4072159b9fb','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-03@2020-11-03@@892@1@1@@@0','03-11-2020~03-11-2020','53776','S000000212','2020-11-03','2020-11-03','892','1','60.254.11.53','0','0','8c72e3516fe9917d0b00a74f52cb3c68','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','8c72e3516fe9917d0b00a74f52cb3c68','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-04@2020-11-04@@892@1@1@@@0','04-11-2020~04-11-2020','53776','S000000212','2020-11-04','2020-11-04','892','1','60.254.11.53','0','0','404cba75028a67a3b6f527c2a9f92afe','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','404cba75028a67a3b6f527c2a9f92afe','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-05@2020-11-05@@892@1@1@@@0','05-11-2020~05-11-2020','53776','S000000212','2020-11-05','2020-11-05','892','1','60.254.11.53','0','0','2f1f1350245d4737b2cdb3963abab11c','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','2f1f1350245d4737b2cdb3963abab11c','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-06@2020-11-06@@892@1@1@@@0','06-11-2020~06-11-2020','53776','S000000212','2020-11-06','2020-11-06','892','1','60.254.11.53','0','0','781c98c58b1d5abd7ea83516e91d58c7','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','781c98c58b1d5abd7ea83516e91d58c7','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-07@2020-11-07@@892@1@1@@@0','07-11-2020~07-11-2020','53776','S000000212','2020-11-07','2020-11-07','892','1','60.254.11.53','0','0','f410d09900afb30204be53f3052c03d9','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','f410d09900afb30204be53f3052c03d9','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-08@2020-11-08@@892@1@1@@@0','08-11-2020~08-11-2020','53776','S000000212','2020-11-08','2020-11-08','892','1','60.254.11.53','0','0','fd0fc8fea754c783806c2643432e5a7b','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','fd0fc8fea754c783806c2643432e5a7b','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-09@2020-11-09@@892@1@1@@@0','09-11-2020~09-11-2020','53776','S000000212','2020-11-09','2020-11-09','892','1','60.254.11.53','0','0','1e01b0d963d50ee7b9edcabad9309d77','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','1e01b0d963d50ee7b9edcabad9309d77','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-10@2020-11-10@@892@1@1@@@0','10-11-2020~10-11-2020','53776','S000000212','2020-11-10','2020-11-10','892','1','60.254.11.53','0','0','1e82d12a2abfc697d134dfcef3fcd574','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','1e82d12a2abfc697d134dfcef3fcd574','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-11@2020-11-11@@892@1@1@@@0','11-11-2020~11-11-2020','53776','S000000212','2020-11-11','2020-11-11','892','1','60.254.11.53','0','0','e6bb92a42428e60043363a8b1768157f','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','e6bb92a42428e60043363a8b1768157f','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-12@2020-11-12@@892@1@1@@@0','12-11-2020~12-11-2020','53776','S000000212','2020-11-12','2020-11-12','892','1','60.254.11.53','0','0','e158e52280c86dee1329127d6ad0cc95','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','e158e52280c86dee1329127d6ad0cc95','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-13@2020-11-13@@892@1@1@@@0','13-11-2020~13-11-2020','53776','S000000212','2020-11-13','2020-11-13','892','1','60.254.11.53','0','0','ff1655f248396f693937dfa907da7eb6','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','ff1655f248396f693937dfa907da7eb6','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-14@2020-11-14@@892@1@1@@@0','14-11-2020~14-11-2020','53776','S000000212','2020-11-14','2020-11-14','892','1','60.254.11.53','0','0','25051cadd70b80a016e3a0dd3dd36a6d','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','25051cadd70b80a016e3a0dd3dd36a6d','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-15@2020-11-15@@892@1@1@@@0','15-11-2020~15-11-2020','53776','S000000212','2020-11-15','2020-11-15','892','1','60.254.11.53','0','0','566bc4b45ee918a2eac6cf44254708ac','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','566bc4b45ee918a2eac6cf44254708ac','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-16@2020-11-16@@892@1@1@@@0','16-11-2020~16-11-2020','53776','S000000212','2020-11-16','2020-11-16','892','1','60.254.11.53','0','0','632fbc3f09889467e7007f7d0990ae94','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','632fbc3f09889467e7007f7d0990ae94','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-17@2020-11-17@@892@1@1@@@0','17-11-2020~17-11-2020','53776','S000000212','2020-11-17','2020-11-17','892','1','60.254.11.53','0','0','32bd541bf9906732af1f611e92fbc0a3','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','32bd541bf9906732af1f611e92fbc0a3','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-18@2020-11-18@@892@1@1@@@0','18-11-2020~18-11-2020','53776','S000000212','2020-11-18','2020-11-18','892','1','60.254.11.53','0','0','b7285dd5f600d2f3bd91f6f3417c7ca6','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','b7285dd5f600d2f3bd91f6f3417c7ca6','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-19@2020-11-19@@892@1@1@@@0','19-11-2020~19-11-2020','53776','S000000212','2020-11-19','2020-11-19','892','1','60.254.11.53','0','0','8e90daa8716a0454d795891fe3fc7151','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','8e90daa8716a0454d795891fe3fc7151','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-20@2020-11-20@@892@1@1@@@0','20-11-2020~20-11-2020','53776','S000000212','2020-11-20','2020-11-20','892','1','60.254.11.53','0','0','eeb64b3959b8ebdf8837263cd699121b','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','eeb64b3959b8ebdf8837263cd699121b','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-21@2020-11-21@@892@1@1@@@0','21-11-2020~21-11-2020','53776','S000000212','2020-11-21','2020-11-21','892','1','60.254.11.53','0','0','543429cd89489de6c34d283745c47cb4','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','543429cd89489de6c34d283745c47cb4','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-22@2020-11-22@@892@1@1@@@0','22-11-2020~22-11-2020','53776','S000000212','2020-11-22','2020-11-22','892','1','60.254.11.53','0','0','4b32645c322a1c8d55aafee55473a028','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','4b32645c322a1c8d55aafee55473a028','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-23@2020-11-23@@892@1@1@@@0','23-11-2020~23-11-2020','53776','S000000212','2020-11-23','2020-11-23','892','1','60.254.11.53','0','0','e8edaa28294386d035d8831cea6a41b6','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','e8edaa28294386d035d8831cea6a41b6','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-24@2020-11-24@@892@1@1@@@0','24-11-2020~24-11-2020','53776','S000000212','2020-11-24','2020-11-24','892','1','60.254.11.53','0','0','fcd6ea8277499093689c46b0aaf534fc','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','fcd6ea8277499093689c46b0aaf534fc','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-25@2020-11-25@@892@1@1@@@0','25-11-2020~25-11-2020','53776','S000000212','2020-11-25','2020-11-25','892','1','60.254.11.53','0','0','4910616c8415eec34b12a11bc22930c4','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','4910616c8415eec34b12a11bc22930c4','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-26@2020-11-26@@892@1@1@@@0','26-11-2020~26-11-2020','53776','S000000212','2020-11-26','2020-11-26','892','1','60.254.11.53','0','0','f0d77977b846b32afb48fa1124438828','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','f0d77977b846b32afb48fa1124438828','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-27@2020-11-27@@892@1@1@@@0','27-11-2020~27-11-2020','53776','S000000212','2020-11-27','2020-11-27','892','1','60.254.11.53','0','0','2df250a36ad732297515e0f375eae486','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','2df250a36ad732297515e0f375eae486','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-28@2020-11-28@@892@1@1@@@0','28-11-2020~28-11-2020','53776','S000000212','2020-11-28','2020-11-28','892','1','60.254.11.53','0','0','6727b24130f0466f4c9f2786d000109a','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','6727b24130f0466f4c9f2786d000109a','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-29@2020-11-29@@892@1@1@@@0','29-11-2020~29-11-2020','53776','S000000212','2020-11-29','2020-11-29','892','1','60.254.11.53','0','0','f97fc1bed73a6cbf3388e0a241d2a66c','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','f97fc1bed73a6cbf3388e0a241d2a66c','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0',''),('53776@S000000212@2020-11-30@2020-11-30@@892@1@1@@@0','30-11-2020~30-11-2020','53776','S000000212','2020-11-30','2020-11-30','892','1','60.254.11.53','0','0','01667d8f49fa306013027290711c417f','Sa,Su','1','Supplier','140','A','100','100','AED','0','0','0','0','','','0','01667d8f49fa306013027290711c417f','2020-10-24 11:00:15','2020-10-24','Supplier','','','','','0','');
[10/24/2020 11:00:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],DELETE  FROM room_rates WHERE id IN ('');
[10/24/2020 11:00:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],update room_rates set  availability='10' where supplier_id='S000000212' AND hotel_id='53776' AND inventory_class_id='140'  AND date_from >='2020-10-24' AND date_from <='2020-11-30' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),'Sa,Su')='0';
[10/24/2020 11:00:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],update room_rates set  availability='10' where supplier_id='S000000212' AND hotel_id='53776' AND inventory_class_id='140'  AND date_from >='2020-10-24' AND date_from <='2020-11-30' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),'Sa,Su')>'0';
[10/24/2020 11:00:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-10-24 11:00:39',`log_type`= 'Inventory Allocation',`sql_query`= 'update room_rates set  availability=\&#039;10\&#039; where supplier_id=\&#039;S000000212\&#039; AND hotel_id=\&#039;53776\&#039; AND inventory_class_id=\&#039;140\&#039;  AND date_from &gt;=\&#039;2020-10-24\&#039; AND date_from &lt;=\&#039;2020-11-30\&#039; AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),\&#039;Sa,Su\&#039;)=\&#039;0\&#039;&lt;br&gt;update room_rates set  availability=\&#039;10\&#039; where supplier_id=\&#039;S000000212\&#039; AND hotel_id=\&#039;53776\&#039; AND inventory_class_id=\&#039;140\&#039;  AND date_from &gt;=\&#039;2020-10-24\&#039; AND date_from &lt;=\&#039;2020-11-30\&#039; AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),\&#039;Sa,Su\&#039;)&gt;\&#039;0\&#039;',`log_description`= 'Upadated Inventory Allocation For hotel IndigoDeli- Inventory:-ROH (Standard/Superior) From:-24-10-2020 To:-30-11-2020 Weekday Inventory Allocation:-10 Weekend Inventory Allocation:-10',`ip`= '60.254.11.53',`username`= 'tfg',`user_id`= 'S000000212';
[10/24/2020 11:00:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3838', `entity`='Hotels', `value`='53776' ;
[10/24/2020 11:00:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3838', `entity`='Suppliers', `value`='S000000212' ;
[10/24/2020 11:00:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3838', `entity`='Inventory', `value`='140' ;
[10/24/2020 11:00:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '60.254.11.53' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/10/24' , departure_date = '2020/10/25' , nationality = '106' , nights = '1' , room_types = '2, 1' , create_date = '2020-10-24 11:00:59' , site_id = '' , country_code = '106' , web_service = '' ;
[10/24/2020 11:01:03], [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-10-24 11:01:03', '', '2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd', '455');
[10/24/2020 11:01:03], [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-10-24 11:01:03', '', '2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd', '455');
[10/24/2020 11:01:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd&xml_user_id=25&request_no=1&local_hotel_code=53769&#039;,&#039;53771&#039;,&#039;53773&#039;,&#039;53775&#039;,&#039;53742&#039;,&#039;53776&web_service=no&site_id='
, http_hit_time = '2020-10-24 11:01:02.344'
, 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.189'
, error_description = ''
, memory_used = '7912312'
WHERE id = '3205';
[10/24/2020 11:01:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd&xml_user_id=25&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;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&#039;,&#039;53766&#039;,&#039;53767&#039;,&#039;53768&web_service=no&site_id='
, http_hit_time = '2020-10-24 11:01:02.343'
, 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.298'
, error_description = ''
, memory_used = '7913752'
WHERE id = '3204';
[10/24/2020 11:01: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=25&sessionid=2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd',
  duration = '1.826',
  merge_duration = '0.074',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '8.12',
  system_load_5_min = '3.98',
  system_load_15_min = '2.47',
  system_memory_usage = '93.44',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '455') + '8046904',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '455';
[10/24/2020 11:03:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '60.254.11.53' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/10/24' , departure_date = '2020/10/28' , nationality = '106' , nights = '4' , room_types = '2, 1' , create_date = '2020-10-24 11:03:10' , site_id = '' , country_code = '106' , web_service = '' ;
[10/24/2020 11:03:14], [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-10-24 11:03:14', '', '2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd', '456');
[10/24/2020 11:03:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd&xml_user_id=25&request_no=1&local_hotel_code=53769&#039;,&#039;53771&#039;,&#039;53773&#039;,&#039;53775&#039;,&#039;53742&#039;,&#039;53776&web_service=no&site_id='
, http_hit_time = '2020-10-24 11:03:13.267'
, 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 = '0.948'
, error_description = ''
, memory_used = '7912312'
WHERE id = '3206';
[10/24/2020 11:03:14], [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-10-24 11:03:14', '', '2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd', '456');
[10/24/2020 11:03:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd&xml_user_id=25&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;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&#039;,&#039;53766&#039;,&#039;53767&#039;,&#039;53768&web_service=no&site_id='
, http_hit_time = '2020-10-24 11:03:13.310'
, 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 = '2.067'
, error_description = ''
, memory_used = '7913752'
WHERE id = '3207';
[10/24/2020 11:03:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd',
  duration = '2.647',
  merge_duration = '0.082',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '1.41',
  system_load_5_min = '2.79',
  system_load_15_min = '2.23',
  system_memory_usage = '93.18',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '456') + '8046904',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '456';
[10/24/2020 11:04:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_supplier_mapping.php],DELETE from hotel_supplier_mapping WHERE SupplierId= 'S000000241' AND city_code= '64440' AND country_code= '106';
[10/24/2020 11:04:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_supplier_mapping.php],INSERT INTO hotel_supplier_mapping SET SupplierId = 'S000000241',hotel_id = '53771',city_code = '64440',country_code = '106';
[10/24/2020 11:04:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_supplier_mapping.php],INSERT INTO hotel_supplier_mapping SET SupplierId = 'S000000241',hotel_id = '53773',city_code = '64440',country_code = '106';
[10/24/2020 11:04:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_supplier_mapping.php],INSERT INTO hotel_supplier_mapping SET SupplierId = 'S000000241',hotel_id = '53775',city_code = '64440',country_code = '106';
[10/24/2020 11:04:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_supplier_mapping.php],INSERT INTO hotel_supplier_mapping SET SupplierId = 'S000000241',hotel_id = '53776',city_code = '64440',country_code = '106';
[10/24/2020 11:04:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_supplier_mapping.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-24 11:04:40',`log_type`= 'Hotel Supplier Mapping Updated',`sql_query`= ' ------ INSERT INTO hotel_supplier_mapping SET SupplierId = \&#039;S000000241\&#039;,hotel_id = \&#039;53771\&#039;,city_code = \&#039;64440\&#039;,country_code = \&#039;106\&#039; ------ INSERT INTO hotel_supplier_mapping SET SupplierId = \&#039;S000000241\&#039;,hotel_id = \&#039;53773\&#039;,city_code = \&#039;64440\&#039;,country_code = \&#039;106\&#039; ------ INSERT INTO hotel_supplier_mapping SET SupplierId = \&#039;S000000241\&#039;,hotel_id = \&#039;53775\&#039;,city_code = \&#039;64440\&#039;,country_code = \&#039;106\&#039; ------ INSERT INTO hotel_supplier_mapping SET SupplierId = \&#039;S000000241\&#039;,hotel_id = \&#039;53776\&#039;,city_code = \&#039;64440\&#039;,country_code = \&#039;106\&#039;',`log_description`= 'Hotel Supplier Mapping Updated for Supplier  : S000000241, City : 64440, Country : 106, Hotels are : 53771,53773,53775,53776',`ip`= '60.254.11.53';
[10/24/2020 11:04:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_supplier_mapping.php],insert into user_log_link Set `user_logs_id`='3839', `entity`='Suppliers', `value`='S000000241' ;
[10/24/2020 11:05:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_supplier_mapping.php],DELETE from hotel_supplier_mapping WHERE SupplierId= 'S000000212' AND city_code= '64440' AND country_code= '106';
[10/24/2020 11:05:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_supplier_mapping.php],INSERT INTO hotel_supplier_mapping SET SupplierId = 'S000000212',hotel_id = '53742',city_code = '64440',country_code = '106';
[10/24/2020 11:05:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_supplier_mapping.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-24 11:05:07',`log_type`= 'Hotel Supplier Mapping Updated',`sql_query`= ' ------ INSERT INTO hotel_supplier_mapping SET SupplierId = \&#039;S000000212\&#039;,hotel_id = \&#039;53742\&#039;,city_code = \&#039;64440\&#039;,country_code = \&#039;106\&#039;',`log_description`= 'Hotel Supplier Mapping Updated for Supplier  : S000000212, City : 64440, Country : 106, Hotels are : 53742',`ip`= '60.254.11.53';
[10/24/2020 11:05:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_supplier_mapping.php],insert into user_log_link Set `user_logs_id`='3840', `entity`='Suppliers', `value`='S000000212' ;
[10/24/2020 11:05:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],DELETE FROM hotel_room_class_mapping WHERE hotel_id='53776' AND supplier_id='S000000241';
[10/24/2020 11:05:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53776', supplier_id='S000000241', class_id='1044', is_channel_manager_mapped = '0';
[10/24/2020 11:05:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53776', supplier_id='S000000241', class_id='1039', is_channel_manager_mapped = '0';
[10/24/2020 11:05:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],DELETE FROM hotel_room_class_mapping WHERE hotel_id='53776' AND supplier_id='S000000241';
[10/24/2020 11:05:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53776', supplier_id='S000000241', class_id='1044', is_channel_manager_mapped = '0';
[10/24/2020 11:05:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53776', supplier_id='S000000241', class_id='1039', is_channel_manager_mapped = '0';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-10-24',to_date='2020-10-24',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-10-25',to_date='2020-10-25',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-10-26',to_date='2020-10-26',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-10-27',to_date='2020-10-27',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-10-28',to_date='2020-10-28',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-10-29',to_date='2020-10-29',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-10-30',to_date='2020-10-30',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-10-31',to_date='2020-10-31',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-01',to_date='2020-11-01',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-02',to_date='2020-11-02',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-03',to_date='2020-11-03',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-04',to_date='2020-11-04',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-05',to_date='2020-11-05',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-06',to_date='2020-11-06',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-07',to_date='2020-11-07',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-08',to_date='2020-11-08',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-09',to_date='2020-11-09',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-10',to_date='2020-11-10',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-11',to_date='2020-11-11',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-12',to_date='2020-11-12',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-13',to_date='2020-11-13',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-14',to_date='2020-11-14',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-15',to_date='2020-11-15',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-16',to_date='2020-11-16',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-17',to_date='2020-11-17',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-18',to_date='2020-11-18',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-19',to_date='2020-11-19',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-20',to_date='2020-11-20',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-21',to_date='2020-11-21',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-22',to_date='2020-11-22',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-23',to_date='2020-11-23',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-24',to_date='2020-11-24',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-25',to_date='2020-11-25',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-26',to_date='2020-11-26',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-27',to_date='2020-11-27',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-28',to_date='2020-11-28',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-29',to_date='2020-11-29',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-30',to_date='2020-11-30',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1044',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-10-24 11:06:50',`log_type`= 'ExtraBed Rates',`sql_query`= '',`log_description`= 'Extrabed Rates For IndigoDeli added successfully. Room Category :- Standard - Double, Extrabed - 1(Bed & Breakfast) From :- 24-10-2020 To :- 30-11-2020',`ip`= '60.254.11.53',`username`= 'tfg',`user_id`= 'S000000241';
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3841', `entity`='Hotels', `value`='53776' ;
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3841', `entity`='Suppliers', `value`='S000000241' ;
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3841', `entity`='Inventory', `value`='132' ;
[10/24/2020 11:06:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3841', `entity`='Room', `value`='1044' ;
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-10-24',to_date='2020-10-24',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-10-25',to_date='2020-10-25',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-10-26',to_date='2020-10-26',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-10-27',to_date='2020-10-27',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-10-28',to_date='2020-10-28',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-10-29',to_date='2020-10-29',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-10-30',to_date='2020-10-30',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-10-31',to_date='2020-10-31',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-01',to_date='2020-11-01',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-02',to_date='2020-11-02',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-03',to_date='2020-11-03',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-04',to_date='2020-11-04',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-05',to_date='2020-11-05',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-06',to_date='2020-11-06',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-07',to_date='2020-11-07',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-08',to_date='2020-11-08',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-09',to_date='2020-11-09',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-10',to_date='2020-11-10',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-11',to_date='2020-11-11',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-12',to_date='2020-11-12',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-13',to_date='2020-11-13',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-14',to_date='2020-11-14',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-15',to_date='2020-11-15',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-16',to_date='2020-11-16',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-17',to_date='2020-11-17',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-18',to_date='2020-11-18',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-19',to_date='2020-11-19',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-20',to_date='2020-11-20',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-21',to_date='2020-11-21',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-22',to_date='2020-11-22',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-23',to_date='2020-11-23',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-24',to_date='2020-11-24',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-25',to_date='2020-11-25',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-26',to_date='2020-11-26',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-27',to_date='2020-11-27',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-28',to_date='2020-11-28',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-29',to_date='2020-11-29',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-30',to_date='2020-11-30',supplier_id='S000000241',hotel_id='53776',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '10',adult_wb_weekend_rate= '10',adult_display= 'yes';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-10-24 11:06:51',`log_type`= 'ExtraBed Rates',`sql_query`= '',`log_description`= 'Extrabed Rates For IndigoDeli added successfully. Room Category :- Standard - Single, Extrabed - 1(Bed & Breakfast) From :- 24-10-2020 To :- 30-11-2020',`ip`= '60.254.11.53',`username`= 'tfg',`user_id`= 'S000000241';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3842', `entity`='Hotels', `value`='53776' ;
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3842', `entity`='Suppliers', `value`='S000000241' ;
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3842', `entity`='Inventory', `value`='132' ;
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3842', `entity`='Room', `value`='1039' ;
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO hotel_supplier_currency_mapping SET SupplierId ='S000000241',hotel_id ='53776',currency_code ='AED',city_code ='64440',country_code ='106',created_datetime ='2020-10-24 11:06:51',created_by ='#supplier#',ip_addr ='60.254.11.53';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO room_rates (room_rate_code,rate_group,hotel_id,supplier_id,date_from,date_to,room_class,room_basis,ip_addr,room_type,view_basis,edit_time_stamp,weekend,rate_profile,entered_by,inventory_class_id,status,weekday_rate,weekend_rate,currency,minstay,availability,time_limit,checkin_block_for,exclude_countries,exclude_residence,stop_sale,time_stamp,created_datetime,create_date,created_by,changed_by,modify_date,modified_datetime,modified_by,consumed_inventory,stay_note) values ('53776@S000000241@2020-10-24@2020-10-24@@1044@1@1@@@0','24-10-2020~24-10-2020','53776','S000000241','2020-10-24','2020-10-24','1044','1','60.254.11.53','0','0','4b744d9452f0734ae6edb19add187b2d','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','4b744d9452f0734ae6edb19add187b2d','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0','');
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],DELETE  FROM room_rates WHERE id IN ('');
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-10-24 11:06:51',`log_type`= 'Rates',`sql_query`= '',`log_description`= 'Inserted Rates For IndigoDeli Rate:- 200 Room Category :- Standard - Double, Extrabed - 1 (Bed & Breakfast) Market :- All Market From:- 24-10-2020 To:- 30-11-2020',`ip`= '60.254.11.53',`username`= 'tfg',`user_id`= 'S000000241';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3843', `entity`='Hotels', `value`='53776' ;
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3843', `entity`='Suppliers', `value`='S000000241' ;
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3843', `entity`='Inventory', `value`='132' ;
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3843', `entity`='Room', `value`='1044' ;
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3843', `entity`='Market', `value`='1' ;
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-10-24 11:06:51',`log_type`= 'Rates',`sql_query`= '',`log_description`= 'Inserted Rates For IndigoDeli Rate:- 100 Room Category :- Standard - Single, Extrabed - 1 (Bed & Breakfast) Market :- All Market From:- 24-10-2020 To:- 30-11-2020',`ip`= '60.254.11.53',`username`= 'tfg',`user_id`= 'S000000241';
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3844', `entity`='Hotels', `value`='53776' ;
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3844', `entity`='Suppliers', `value`='S000000241' ;
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3844', `entity`='Inventory', `value`='132' ;
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3844', `entity`='Room', `value`='1039' ;
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3844', `entity`='Market', `value`='1' ;
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO room_rates (room_rate_code,rate_group,hotel_id,supplier_id,date_from,date_to,room_class,room_basis,ip_addr,room_type,view_basis,edit_time_stamp,weekend,rate_profile,entered_by,inventory_class_id,status,weekday_rate,weekend_rate,currency,minstay,availability,time_limit,checkin_block_for,exclude_countries,exclude_residence,stop_sale,time_stamp,created_datetime,create_date,created_by,changed_by,modify_date,modified_datetime,modified_by,consumed_inventory,stay_note) values ('53776@S000000241@2020-10-25@2020-10-25@@1044@1@1@@@0','25-10-2020~25-10-2020','53776','S000000241','2020-10-25','2020-10-25','1044','1','60.254.11.53','0','0','1357ab66db1b7d7f9ba10ce6e22dd356','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','1357ab66db1b7d7f9ba10ce6e22dd356','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-10-26@2020-10-26@@1044@1@1@@@0','26-10-2020~26-10-2020','53776','S000000241','2020-10-26','2020-10-26','1044','1','60.254.11.53','0','0','5d1207cab1104be64ee3d97075e98850','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','5d1207cab1104be64ee3d97075e98850','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-10-27@2020-10-27@@1044@1@1@@@0','27-10-2020~27-10-2020','53776','S000000241','2020-10-27','2020-10-27','1044','1','60.254.11.53','0','0','0b9813106dab43cf9b794fc9b0a2b6b6','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','0b9813106dab43cf9b794fc9b0a2b6b6','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-10-28@2020-10-28@@1044@1@1@@@0','28-10-2020~28-10-2020','53776','S000000241','2020-10-28','2020-10-28','1044','1','60.254.11.53','0','0','2cb528a747a2b3aacc94ac4d9cfb1911','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','2cb528a747a2b3aacc94ac4d9cfb1911','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-10-29@2020-10-29@@1044@1@1@@@0','29-10-2020~29-10-2020','53776','S000000241','2020-10-29','2020-10-29','1044','1','60.254.11.53','0','0','0c364164416013d092019dcfd7fb59a6','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','0c364164416013d092019dcfd7fb59a6','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-10-30@2020-10-30@@1044@1@1@@@0','30-10-2020~30-10-2020','53776','S000000241','2020-10-30','2020-10-30','1044','1','60.254.11.53','0','0','3e45b5ecf7793a212ffc5e8cec5c7be4','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','3e45b5ecf7793a212ffc5e8cec5c7be4','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-10-31@2020-10-31@@1044@1@1@@@0','31-10-2020~31-10-2020','53776','S000000241','2020-10-31','2020-10-31','1044','1','60.254.11.53','0','0','6b781c9ad60111f618ce20a6cc880715','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','6b781c9ad60111f618ce20a6cc880715','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-01@2020-11-01@@1044@1@1@@@0','01-11-2020~01-11-2020','53776','S000000241','2020-11-01','2020-11-01','1044','1','60.254.11.53','0','0','1b3b2c1dc488570713b9e9df115a00d2','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','1b3b2c1dc488570713b9e9df115a00d2','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-02@2020-11-02@@1044@1@1@@@0','02-11-2020~02-11-2020','53776','S000000241','2020-11-02','2020-11-02','1044','1','60.254.11.53','0','0','d38762e352ad173252fd187bb98547e9','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','d38762e352ad173252fd187bb98547e9','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-03@2020-11-03@@1044@1@1@@@0','03-11-2020~03-11-2020','53776','S000000241','2020-11-03','2020-11-03','1044','1','60.254.11.53','0','0','94d125cb057162fe23c7b312451cbbc1','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','94d125cb057162fe23c7b312451cbbc1','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-04@2020-11-04@@1044@1@1@@@0','04-11-2020~04-11-2020','53776','S000000241','2020-11-04','2020-11-04','1044','1','60.254.11.53','0','0','daeeb80794663174147145a912b20413','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','daeeb80794663174147145a912b20413','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-05@2020-11-05@@1044@1@1@@@0','05-11-2020~05-11-2020','53776','S000000241','2020-11-05','2020-11-05','1044','1','60.254.11.53','0','0','0d525f371fb5a0f76de845bfd1501869','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','0d525f371fb5a0f76de845bfd1501869','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-06@2020-11-06@@1044@1@1@@@0','06-11-2020~06-11-2020','53776','S000000241','2020-11-06','2020-11-06','1044','1','60.254.11.53','0','0','35dd8296b85a77d9cc6463ade5ae3e9e','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','35dd8296b85a77d9cc6463ade5ae3e9e','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-07@2020-11-07@@1044@1@1@@@0','07-11-2020~07-11-2020','53776','S000000241','2020-11-07','2020-11-07','1044','1','60.254.11.53','0','0','ab6524d1ec1f1feaa68a36e332d83f1a','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','ab6524d1ec1f1feaa68a36e332d83f1a','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-08@2020-11-08@@1044@1@1@@@0','08-11-2020~08-11-2020','53776','S000000241','2020-11-08','2020-11-08','1044','1','60.254.11.53','0','0','982e26191c38eb00f22a056ec067fc48','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','982e26191c38eb00f22a056ec067fc48','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-09@2020-11-09@@1044@1@1@@@0','09-11-2020~09-11-2020','53776','S000000241','2020-11-09','2020-11-09','1044','1','60.254.11.53','0','0','ad9c2172873774e10d66ba5472c4fa85','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','ad9c2172873774e10d66ba5472c4fa85','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-10@2020-11-10@@1044@1@1@@@0','10-11-2020~10-11-2020','53776','S000000241','2020-11-10','2020-11-10','1044','1','60.254.11.53','0','0','da35b7ee3e20d20d11c10cd32230e620','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','da35b7ee3e20d20d11c10cd32230e620','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-11@2020-11-11@@1044@1@1@@@0','11-11-2020~11-11-2020','53776','S000000241','2020-11-11','2020-11-11','1044','1','60.254.11.53','0','0','8565e0a569fa0aa35964efdc92ad537e','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','8565e0a569fa0aa35964efdc92ad537e','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-12@2020-11-12@@1044@1@1@@@0','12-11-2020~12-11-2020','53776','S000000241','2020-11-12','2020-11-12','1044','1','60.254.11.53','0','0','7b43fe330da9e136746f77187cd556bf','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','7b43fe330da9e136746f77187cd556bf','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-13@2020-11-13@@1044@1@1@@@0','13-11-2020~13-11-2020','53776','S000000241','2020-11-13','2020-11-13','1044','1','60.254.11.53','0','0','643eb0471316ae16fda2c7d64e564cc4','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','643eb0471316ae16fda2c7d64e564cc4','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-14@2020-11-14@@1044@1@1@@@0','14-11-2020~14-11-2020','53776','S000000241','2020-11-14','2020-11-14','1044','1','60.254.11.53','0','0','dce46ad60d538412056fb0e6fbd838f1','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','dce46ad60d538412056fb0e6fbd838f1','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-15@2020-11-15@@1044@1@1@@@0','15-11-2020~15-11-2020','53776','S000000241','2020-11-15','2020-11-15','1044','1','60.254.11.53','0','0','d79aaf74df96de8535f2d51cbebefa23','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','d79aaf74df96de8535f2d51cbebefa23','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-16@2020-11-16@@1044@1@1@@@0','16-11-2020~16-11-2020','53776','S000000241','2020-11-16','2020-11-16','1044','1','60.254.11.53','0','0','d807129f51475ff99bec7dcc563e5f53','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','d807129f51475ff99bec7dcc563e5f53','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-17@2020-11-17@@1044@1@1@@@0','17-11-2020~17-11-2020','53776','S000000241','2020-11-17','2020-11-17','1044','1','60.254.11.53','0','0','c7c0873d227a4287e32fa7205de90ce7','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','c7c0873d227a4287e32fa7205de90ce7','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-18@2020-11-18@@1044@1@1@@@0','18-11-2020~18-11-2020','53776','S000000241','2020-11-18','2020-11-18','1044','1','60.254.11.53','0','0','399434fe0cd7d6ffdfdb410173272f42','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','399434fe0cd7d6ffdfdb410173272f42','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-19@2020-11-19@@1044@1@1@@@0','19-11-2020~19-11-2020','53776','S000000241','2020-11-19','2020-11-19','1044','1','60.254.11.53','0','0','e9c3e3dbe673ec6ab4b3ce69906512af','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','e9c3e3dbe673ec6ab4b3ce69906512af','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-20@2020-11-20@@1044@1@1@@@0','20-11-2020~20-11-2020','53776','S000000241','2020-11-20','2020-11-20','1044','1','60.254.11.53','0','0','003bc8c3524297ac9cbaf8b7ce732750','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','003bc8c3524297ac9cbaf8b7ce732750','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-21@2020-11-21@@1044@1@1@@@0','21-11-2020~21-11-2020','53776','S000000241','2020-11-21','2020-11-21','1044','1','60.254.11.53','0','0','ee8c3d12aebb8a210e945a6b0947a5c1','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','ee8c3d12aebb8a210e945a6b0947a5c1','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-22@2020-11-22@@1044@1@1@@@0','22-11-2020~22-11-2020','53776','S000000241','2020-11-22','2020-11-22','1044','1','60.254.11.53','0','0','84dc35e7b1e7d82fd3cfd6f54ce2f0d7','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','84dc35e7b1e7d82fd3cfd6f54ce2f0d7','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-23@2020-11-23@@1044@1@1@@@0','23-11-2020~23-11-2020','53776','S000000241','2020-11-23','2020-11-23','1044','1','60.254.11.53','0','0','a438aa68194f521a763c8c73a00de41c','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','a438aa68194f521a763c8c73a00de41c','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-24@2020-11-24@@1044@1@1@@@0','24-11-2020~24-11-2020','53776','S000000241','2020-11-24','2020-11-24','1044','1','60.254.11.53','0','0','456689c30cee8dcf5b8430321c4b5f69','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','456689c30cee8dcf5b8430321c4b5f69','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-25@2020-11-25@@1044@1@1@@@0','25-11-2020~25-11-2020','53776','S000000241','2020-11-25','2020-11-25','1044','1','60.254.11.53','0','0','92f47330e5d9bdce5fd3fba9e86656b7','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','92f47330e5d9bdce5fd3fba9e86656b7','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-26@2020-11-26@@1044@1@1@@@0','26-11-2020~26-11-2020','53776','S000000241','2020-11-26','2020-11-26','1044','1','60.254.11.53','0','0','959b50ce3c56a4778c005d7ef7f27c5f','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','959b50ce3c56a4778c005d7ef7f27c5f','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-27@2020-11-27@@1044@1@1@@@0','27-11-2020~27-11-2020','53776','S000000241','2020-11-27','2020-11-27','1044','1','60.254.11.53','0','0','ea65d17f5c17342fdcdd228dbc319bb0','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','ea65d17f5c17342fdcdd228dbc319bb0','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-28@2020-11-28@@1044@1@1@@@0','28-11-2020~28-11-2020','53776','S000000241','2020-11-28','2020-11-28','1044','1','60.254.11.53','0','0','4d3775b818d07ef8924b67c5ebc6b274','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','4d3775b818d07ef8924b67c5ebc6b274','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-29@2020-11-29@@1044@1@1@@@0','29-11-2020~29-11-2020','53776','S000000241','2020-11-29','2020-11-29','1044','1','60.254.11.53','0','0','d8edc9384a16f708cc4f5629b7db0b18','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','d8edc9384a16f708cc4f5629b7db0b18','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-30@2020-11-30@@1044@1@1@@@0','30-11-2020~30-11-2020','53776','S000000241','2020-11-30','2020-11-30','1044','1','60.254.11.53','0','0','4f9e708ae2e7d6917549188c068fd05d','Sa,Su','1','Supplier','132','A','200','200','AED','1','0','0','0','','','0','4f9e708ae2e7d6917549188c068fd05d','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-10-24@2020-10-24@@1039@1@1@@@0','24-10-2020~24-10-2020','53776','S000000241','2020-10-24','2020-10-24','1039','1','60.254.11.53','0','0','0a4ac35f73c921dab255895734bd8ee8','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','0a4ac35f73c921dab255895734bd8ee8','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-10-25@2020-10-25@@1039@1@1@@@0','25-10-2020~25-10-2020','53776','S000000241','2020-10-25','2020-10-25','1039','1','60.254.11.53','0','0','4b4d88014280589929f9b52df042d2f7','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','4b4d88014280589929f9b52df042d2f7','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-10-26@2020-10-26@@1039@1@1@@@0','26-10-2020~26-10-2020','53776','S000000241','2020-10-26','2020-10-26','1039','1','60.254.11.53','0','0','5a6357a039771e39a17da7bc29438852','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','5a6357a039771e39a17da7bc29438852','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-10-27@2020-10-27@@1039@1@1@@@0','27-10-2020~27-10-2020','53776','S000000241','2020-10-27','2020-10-27','1039','1','60.254.11.53','0','0','d4abd2ba9defaeabc2e77ccde536a382','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','d4abd2ba9defaeabc2e77ccde536a382','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-10-28@2020-10-28@@1039@1@1@@@0','28-10-2020~28-10-2020','53776','S000000241','2020-10-28','2020-10-28','1039','1','60.254.11.53','0','0','9567e768b4804f15f2aa4550c42a9fbb','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','9567e768b4804f15f2aa4550c42a9fbb','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-10-29@2020-10-29@@1039@1@1@@@0','29-10-2020~29-10-2020','53776','S000000241','2020-10-29','2020-10-29','1039','1','60.254.11.53','0','0','e430219f29750824e2bebca3b21642e2','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','e430219f29750824e2bebca3b21642e2','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-10-30@2020-10-30@@1039@1@1@@@0','30-10-2020~30-10-2020','53776','S000000241','2020-10-30','2020-10-30','1039','1','60.254.11.53','0','0','c01b6c64aa6c42f791757b88e87e69b6','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','c01b6c64aa6c42f791757b88e87e69b6','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-10-31@2020-10-31@@1039@1@1@@@0','31-10-2020~31-10-2020','53776','S000000241','2020-10-31','2020-10-31','1039','1','60.254.11.53','0','0','e8492b67be2bcd292e8a43f702657721','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','e8492b67be2bcd292e8a43f702657721','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-01@2020-11-01@@1039@1@1@@@0','01-11-2020~01-11-2020','53776','S000000241','2020-11-01','2020-11-01','1039','1','60.254.11.53','0','0','1be97c3c1086fef30c405cad8f90f9c3','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','1be97c3c1086fef30c405cad8f90f9c3','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-02@2020-11-02@@1039@1@1@@@0','02-11-2020~02-11-2020','53776','S000000241','2020-11-02','2020-11-02','1039','1','60.254.11.53','0','0','26af0d2062c0f6eb07fcd9da077e8031','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','26af0d2062c0f6eb07fcd9da077e8031','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-03@2020-11-03@@1039@1@1@@@0','03-11-2020~03-11-2020','53776','S000000241','2020-11-03','2020-11-03','1039','1','60.254.11.53','0','0','49500166c33f247c1e41e53010d04c76','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','49500166c33f247c1e41e53010d04c76','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-04@2020-11-04@@1039@1@1@@@0','04-11-2020~04-11-2020','53776','S000000241','2020-11-04','2020-11-04','1039','1','60.254.11.53','0','0','fda58b49754aaf651ebfd47ab0bc9a34','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','fda58b49754aaf651ebfd47ab0bc9a34','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-05@2020-11-05@@1039@1@1@@@0','05-11-2020~05-11-2020','53776','S000000241','2020-11-05','2020-11-05','1039','1','60.254.11.53','0','0','9cdf9392edc625811acb1f832a07c7e5','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','9cdf9392edc625811acb1f832a07c7e5','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-06@2020-11-06@@1039@1@1@@@0','06-11-2020~06-11-2020','53776','S000000241','2020-11-06','2020-11-06','1039','1','60.254.11.53','0','0','cdc070e46d00f73be7673519be6670e5','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','cdc070e46d00f73be7673519be6670e5','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-07@2020-11-07@@1039@1@1@@@0','07-11-2020~07-11-2020','53776','S000000241','2020-11-07','2020-11-07','1039','1','60.254.11.53','0','0','b0fb9a7ff908b319124042c30c646d88','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','b0fb9a7ff908b319124042c30c646d88','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-08@2020-11-08@@1039@1@1@@@0','08-11-2020~08-11-2020','53776','S000000241','2020-11-08','2020-11-08','1039','1','60.254.11.53','0','0','fa87b7a56fdd17686e94d5bb8c0434cf','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','fa87b7a56fdd17686e94d5bb8c0434cf','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-09@2020-11-09@@1039@1@1@@@0','09-11-2020~09-11-2020','53776','S000000241','2020-11-09','2020-11-09','1039','1','60.254.11.53','0','0','dcfc8b6c0c3d529606691a8de1b28af8','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','dcfc8b6c0c3d529606691a8de1b28af8','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-10@2020-11-10@@1039@1@1@@@0','10-11-2020~10-11-2020','53776','S000000241','2020-11-10','2020-11-10','1039','1','60.254.11.53','0','0','3d7da221ea01660e8cda2763bd4ea637','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','3d7da221ea01660e8cda2763bd4ea637','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-11@2020-11-11@@1039@1@1@@@0','11-11-2020~11-11-2020','53776','S000000241','2020-11-11','2020-11-11','1039','1','60.254.11.53','0','0','0c75d4ab3b42074ebbc5319b12b7f647','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','0c75d4ab3b42074ebbc5319b12b7f647','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-12@2020-11-12@@1039@1@1@@@0','12-11-2020~12-11-2020','53776','S000000241','2020-11-12','2020-11-12','1039','1','60.254.11.53','0','0','2c1076b5ddede60526fe596ef6822d0d','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','2c1076b5ddede60526fe596ef6822d0d','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-13@2020-11-13@@1039@1@1@@@0','13-11-2020~13-11-2020','53776','S000000241','2020-11-13','2020-11-13','1039','1','60.254.11.53','0','0','97d7aba6e9af9e13a603f1c763ee6216','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','97d7aba6e9af9e13a603f1c763ee6216','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-14@2020-11-14@@1039@1@1@@@0','14-11-2020~14-11-2020','53776','S000000241','2020-11-14','2020-11-14','1039','1','60.254.11.53','0','0','b6ba8c700d2e7122fbd14b5e93b28d08','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','b6ba8c700d2e7122fbd14b5e93b28d08','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-15@2020-11-15@@1039@1@1@@@0','15-11-2020~15-11-2020','53776','S000000241','2020-11-15','2020-11-15','1039','1','60.254.11.53','0','0','45a11a1dca08e829b9e950e8e55a2923','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','45a11a1dca08e829b9e950e8e55a2923','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-16@2020-11-16@@1039@1@1@@@0','16-11-2020~16-11-2020','53776','S000000241','2020-11-16','2020-11-16','1039','1','60.254.11.53','0','0','6e39c8b456d1df468d530ed94c01c7ae','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','6e39c8b456d1df468d530ed94c01c7ae','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-17@2020-11-17@@1039@1@1@@@0','17-11-2020~17-11-2020','53776','S000000241','2020-11-17','2020-11-17','1039','1','60.254.11.53','0','0','d19d8673064dfb1f8444c579d4e2db11','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','d19d8673064dfb1f8444c579d4e2db11','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-18@2020-11-18@@1039@1@1@@@0','18-11-2020~18-11-2020','53776','S000000241','2020-11-18','2020-11-18','1039','1','60.254.11.53','0','0','fea1d7e5b4c9920a4b0ca3a9480febd8','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','fea1d7e5b4c9920a4b0ca3a9480febd8','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-19@2020-11-19@@1039@1@1@@@0','19-11-2020~19-11-2020','53776','S000000241','2020-11-19','2020-11-19','1039','1','60.254.11.53','0','0','f4b2fd60ce89220bbfb6b95f4b08f29d','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','f4b2fd60ce89220bbfb6b95f4b08f29d','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-20@2020-11-20@@1039@1@1@@@0','20-11-2020~20-11-2020','53776','S000000241','2020-11-20','2020-11-20','1039','1','60.254.11.53','0','0','b06b7879e80611d2b21f80c3227eb2e3','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','b06b7879e80611d2b21f80c3227eb2e3','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-21@2020-11-21@@1039@1@1@@@0','21-11-2020~21-11-2020','53776','S000000241','2020-11-21','2020-11-21','1039','1','60.254.11.53','0','0','95e05368afc256058df65a1ca575f916','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','95e05368afc256058df65a1ca575f916','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-22@2020-11-22@@1039@1@1@@@0','22-11-2020~22-11-2020','53776','S000000241','2020-11-22','2020-11-22','1039','1','60.254.11.53','0','0','a877e3a6b7c41bf8133d624212deea0f','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','a877e3a6b7c41bf8133d624212deea0f','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-23@2020-11-23@@1039@1@1@@@0','23-11-2020~23-11-2020','53776','S000000241','2020-11-23','2020-11-23','1039','1','60.254.11.53','0','0','124f5731e9a3495166500b923735096b','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','124f5731e9a3495166500b923735096b','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-24@2020-11-24@@1039@1@1@@@0','24-11-2020~24-11-2020','53776','S000000241','2020-11-24','2020-11-24','1039','1','60.254.11.53','0','0','f12fab12b5fae1cb86845cca7f82c53e','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','f12fab12b5fae1cb86845cca7f82c53e','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-25@2020-11-25@@1039@1@1@@@0','25-11-2020~25-11-2020','53776','S000000241','2020-11-25','2020-11-25','1039','1','60.254.11.53','0','0','cc77a5f64ec3e544db154736f1303d74','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','cc77a5f64ec3e544db154736f1303d74','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-26@2020-11-26@@1039@1@1@@@0','26-11-2020~26-11-2020','53776','S000000241','2020-11-26','2020-11-26','1039','1','60.254.11.53','0','0','7898773576082fc6a2271eee471b534b','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','7898773576082fc6a2271eee471b534b','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-27@2020-11-27@@1039@1@1@@@0','27-11-2020~27-11-2020','53776','S000000241','2020-11-27','2020-11-27','1039','1','60.254.11.53','0','0','2195e2ed9e01ba3eaaac161ee585c8ca','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','2195e2ed9e01ba3eaaac161ee585c8ca','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-28@2020-11-28@@1039@1@1@@@0','28-11-2020~28-11-2020','53776','S000000241','2020-11-28','2020-11-28','1039','1','60.254.11.53','0','0','50cc7151ab428533502d9e9eb270e707','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','50cc7151ab428533502d9e9eb270e707','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-29@2020-11-29@@1039@1@1@@@0','29-11-2020~29-11-2020','53776','S000000241','2020-11-29','2020-11-29','1039','1','60.254.11.53','0','0','50e03975e3bdcfce83688ba080eea6df','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','50e03975e3bdcfce83688ba080eea6df','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0',''),('53776@S000000241@2020-11-30@2020-11-30@@1039@1@1@@@0','30-11-2020~30-11-2020','53776','S000000241','2020-11-30','2020-11-30','1039','1','60.254.11.53','0','0','bf41db963ef7910c703a2a2cf9ef3e49','Sa,Su','1','Supplier','132','A','100','100','AED','1','0','0','0','','','0','bf41db963ef7910c703a2a2cf9ef3e49','2020-10-24 11:06:51','2020-10-24','Supplier','','','','','0','');
[10/24/2020 11:06:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],DELETE  FROM room_rates WHERE id IN ('');
[10/24/2020 11:09:38], [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-10-24 11:09:38', '', '23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5', '453');
[10/24/2020 11:09:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5&xml_user_id=21&request_no=1&local_hotel_code=53773&web_service=no&site_id='
, http_hit_time = '2020-10-24 11:09:38.101'
, 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 = '0.938'
, error_description = ''
, memory_used = '7952032'
WHERE id = '3208';
[10/24/2020 11:12:58], [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-10-24 11:12:58', '', '23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5', '453');
[10/24/2020 11:12:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5&xml_user_id=21&request_no=1&local_hotel_code=53773&web_service=no&site_id=&ez_queries=1'
, http_hit_time = '2020-10-24 11:12:56.989'
, 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.219'
, error_description = ''
, memory_used = '7954544'
WHERE id = '3209';
[10/24/2020 11:19:27], [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 = '45.120.147.56' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/10/29' , departure_date = '2020/10/30' , nationality = '106' , nights = '1' , room_types = '2, 1' , create_date = '2020-10-24 11:19:27' , site_id = '' , country_code = '106' , web_service = '' ;
[10/24/2020 11:19:30], [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-10-24 11:19:30', '', '23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5', '457');
[10/24/2020 11:19:30], [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-10-24 11:19:30', '', '23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5', '457');
[10/24/2020 11:19:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5&xml_user_id=21&request_no=1&local_hotel_code=53769&#039;,&#039;53771&#039;,&#039;53773&#039;,&#039;53775&#039;,&#039;53776&#039;,&#039;53742&web_service=no&site_id='
, http_hit_time = '2020-10-24 11:19:29.855'
, 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.327'
, error_description = ''
, memory_used = '7912312'
WHERE id = '3210';
[10/24/2020 11:19:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5&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;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&#039;,&#039;53766&#039;,&#039;53767&#039;,&#039;53768&web_service=no&site_id='
, http_hit_time = '2020-10-24 11:19:29.855'
, 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 = '2.174'
, error_description = ''
, memory_used = '7913752'
WHERE id = '3211';
[10/24/2020 11:19:32], [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=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5',
  duration = '2.760',
  merge_duration = '0.074',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.47',
  system_load_5_min = '1.43',
  system_load_15_min = '1.69',
  system_memory_usage = '93.28',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '457') + '8046608',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '457';
[10/24/2020 11:23:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1603538618','203.192.206.17');
[10/24/2020 11:24:23], [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 = '203.192.206.17' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/10/29' , departure_date = '2020/10/30' , nationality = '106' , nights = '1' , room_types = '2, 1' , create_date = '2020-10-24 11:24:23' , site_id = '' , country_code = '106' , web_service = '' ;
[10/24/2020 11:24:26], [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-10-24 11:24:26', '', '23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5', '458');
[10/24/2020 11:24:26], [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-10-24 11:24:26', '', '23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5', '458');
[10/24/2020 11:24:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5&xml_user_id=21&request_no=1&local_hotel_code=53769&#039;,&#039;53771&#039;,&#039;53773&#039;,&#039;53775&#039;,&#039;53776&#039;,&#039;53742&web_service=no&site_id='
, http_hit_time = '2020-10-24 11:24:25.997'
, 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.048'
, error_description = ''
, memory_used = '7912312'
WHERE id = '3213';
[10/24/2020 11:24:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5&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;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&#039;,&#039;53766&#039;,&#039;53767&#039;,&#039;53768&web_service=no&site_id='
, http_hit_time = '2020-10-24 11:24:25.994'
, 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.274'
, error_description = ''
, memory_used = '7913752'
WHERE id = '3212';
[10/24/2020 11:24:27], [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=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5',
  duration = '1.931',
  merge_duration = '0.111',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.61',
  system_load_5_min = '1.15',
  system_load_15_min = '1.54',
  system_memory_usage = '93.43',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '458') + '8046736',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '458';
[10/24/2020 11:30:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/edit_room_class.php],UPDATE room_class SET room_class ='Single, Extrabed - 0',min_adult ='1',max_adult ='1',max_capacity ='1',is_child_extrabed ='no',is_adult_extrabed ='no',non_refundable ='0',status ='A',modify_date ='2020-10-24' where id ='1039';
[10/24/2020 11:30:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/edit_room_class.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-24 11:30:33',`log_type`= 'Room Category',`sql_query`= 'UPDATE room_class SET room_class =\&#039;Single, Extrabed - 0\&#039;,min_adult =\&#039;1\&#039;,max_adult =\&#039;1\&#039;,max_capacity =1,is_child_extrabed =\&#039;no\&#039;,is_adult_extrabed =\&#039;no\&#039;,non_refundable =\&#039;0\&#039;,status =\&#039;A\&#039;,modify_date =\&#039;2020-10-24\&#039; where id =\&#039;1039\&#039;',`log_description`= 'Room Category Single, Extrabed - 1  Updated ',`ip`= '60.254.11.53';
[10/24/2020 11:30:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/edit_room_class.php],insert into user_log_link Set `user_logs_id`='3845', `entity`='Suppliers', `value`='S000000241' ;
[10/24/2020 11:30:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/edit_room_class.php],insert into user_log_link Set `user_logs_id`='3845', `entity`='Inventory', `value`='132' ;
[10/24/2020 11:30:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/edit_room_class.php],insert into user_log_link Set `user_logs_id`='3845', `entity`='Room', `value`='1039' ;
[10/24/2020 11:35:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-10-24 11:35:12',login_attempt=0 where id = '25';
[10/24/2020 11:35:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'PhpTest', user_type = 'A', branch_id = '1', login_datetime = '2020-10-24 11:35:12', ip = '60.254.11.53', action = 'Login' ;
[10/24/2020 11:35:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '60.254.11.53' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/10/26' , departure_date = '2020/10/28' , nationality = '106' , nights = '2' , room_types = '2' , create_date = '2020-10-24 11:35:43' , site_id = '' , country_code = '106' , web_service = '' ;
[10/24/2020 11:35:46], [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-10-24 11:35:46', '', '2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd', '459');
[10/24/2020 11:35:46], [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-10-24 11:35:46', '', '2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd', '459');
[10/24/2020 11:35:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd&xml_user_id=25&request_no=1&local_hotel_code=53769&#039;,&#039;53771&#039;,&#039;53773&#039;,&#039;53775&#039;,&#039;53776&#039;,&#039;53742&web_service=no&site_id='
, http_hit_time = '2020-10-24 11:35:45.813'
, 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 = '0.991'
, error_description = ''
, memory_used = '7908976'
WHERE id = '3214';
[10/24/2020 11:35:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd&xml_user_id=25&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;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&#039;,&#039;53766&#039;,&#039;53767&#039;,&#039;53768&web_service=no&site_id='
, http_hit_time = '2020-10-24 11:35:45.784'
, 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.659'
, error_description = ''
, memory_used = '7910416'
WHERE id = '3215';
[10/24/2020 11:35:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd',
  duration = '2.187',
  merge_duration = '0.084',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '1.14',
  system_load_5_min = '1.45',
  system_load_15_min = '1.56',
  system_memory_usage = '93.43',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '459') + '8043720',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '459';
[10/24/2020 11:36:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '60.254.11.53' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/10/26' , departure_date = '2020/10/28' , nationality = '106' , nights = '2' , room_types = '2, 1' , create_date = '2020-10-24 11:36:17' , site_id = '' , country_code = '106' , web_service = '' ;
[10/24/2020 11:36:20], [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-10-24 11:36:20', '', '2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd', '460');
[10/24/2020 11:36:20], [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-10-24 11:36:20', '', '2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd', '460');
[10/24/2020 11:36:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd&xml_user_id=25&request_no=1&local_hotel_code=53769&#039;,&#039;53771&#039;,&#039;53773&#039;,&#039;53775&#039;,&#039;53776&#039;,&#039;53742&web_service=no&site_id='
, http_hit_time = '2020-10-24 11:36:19.491'
, 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.019'
, error_description = ''
, memory_used = '7912312'
WHERE id = '3216';
[10/24/2020 11:36:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd&xml_user_id=25&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;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&#039;,&#039;53766&#039;,&#039;53767&#039;,&#039;53768&web_service=no&site_id='
, http_hit_time = '2020-10-24 11:36:19.480'
, 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 = '2.459'
, error_description = ''
, memory_used = '7913752'
WHERE id = '3217';
[10/24/2020 11:36:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd',
  duration = '2.940',
  merge_duration = '0.061',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.97',
  system_load_5_min = '1.36',
  system_load_15_min = '1.53',
  system_memory_usage = '93.48',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '460') + '8046904',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '460';
[10/24/2020 11:36:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1603539406','60.254.11.53');
[10/24/2020 11:44:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '60.254.11.53' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/10/29' , departure_date = '2020/10/31' , nationality = '106' , nights = '2' , room_types = '2, 1' , create_date = '2020-10-24 11:44:20' , site_id = '' , country_code = '106' , web_service = '' ;
[10/24/2020 11:44:23], [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-10-24 11:44:23', '', '2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd', '461');
[10/24/2020 11:44:23], [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-10-24 11:44:23', '', '2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd', '461');
[10/24/2020 11:44:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd&xml_user_id=25&request_no=1&local_hotel_code=53769&#039;,&#039;53771&#039;,&#039;53773&#039;,&#039;53775&#039;,&#039;53776&#039;,&#039;53742&web_service=no&site_id='
, http_hit_time = '2020-10-24 11:44:22.661'
, 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 = '0.944'
, error_description = ''
, memory_used = '7912312'
WHERE id = '3218';
[10/24/2020 11:44:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd&xml_user_id=25&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;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&#039;,&#039;53766&#039;,&#039;53767&#039;,&#039;53768&web_service=no&site_id='
, http_hit_time = '2020-10-24 11:44:22.632'
, 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.949'
, error_description = ''
, memory_used = '7913752'
WHERE id = '3219';
[10/24/2020 11:44:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd',
  duration = '2.335',
  merge_duration = '0.081',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.64',
  system_load_5_min = '1.03',
  system_load_15_min = '1.30',
  system_memory_usage = '93.50',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '461') + '8047096',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '461';
[10/24/2020 11:44:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1603539880','60.254.11.53');
[10/24/2020 11:46:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO localsystem_cancellation_policy SET hotel_id='53775',duration_type='days',from_duration='0',to_duration='2',amount_type='amount',amount_value='10',from_date='2020-10-24',to_date='2020-12-31',supplier_id='S000000241',added_by='supplier',inventory_room_class_id='132';
[10/24/2020 11:46:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-10-24 11:46:16',`log_type`= 'Cancellation Policy',`sql_query`= 'INSERT INTO localsystem_cancellation_policy SET hotel_id=\&#039;53775\&#039;,duration_type=\&#039;days\&#039;,from_duration=\&#039;0\&#039;,to_duration=\&#039;2\&#039;,amount_type=\&#039;amount\&#039;,amount_value=\&#039;10\&#039;,from_date=\&#039;2020-10-24\&#039;,to_date=\&#039;2020-12-31\&#039;,supplier_id=\&#039;S000000241\&#039;,added_by=\&#039;supplier\&#039;,inventory_room_class_id=\&#039;132\&#039;',`log_description`= 'New cancellation policy added for SassySpoon by- RateGainSupplier',`ip`= '60.254.11.53',`username`= 'tfg',`user_id`= 'S000000241';
[10/24/2020 11:46:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3846', `entity`='Hotels', `value`='53775' ;
[10/24/2020 11:46:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3846', `entity`='Suppliers', `value`='S000000241' ;
[10/24/2020 11:49:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1603540150','60.254.11.53');
[10/24/2020 11:49:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1603540175','60.254.11.53');
[10/24/2020 11:49:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO bookings SET  source_type = 'localsystem', reservation_id = '1849', create_date = '2020-10-24 11:49:40', agent_id = '25', parent_agent_id = '25', agent_ref_no = '', nationality = 'Indian', city_id = 'mumbai', country_id = '106', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '163.32', display_currency_code = 'USD', native_room_rate = '600', native_currency_code = 'AED', supplier_profile_id = '1', service_type = 'hotel', service_date = '2020/10/29', check_out_date = '2020/10/31', sub_user_id = '', booking_status = '1', leader_title = '', leader_first_name = '', leader_last_name = '', booking_branch_id = '1', expiration_date = '2020-10-27 00:00:00', cancellation_policy = 'Amendment of Dates, Room Category, Passenger Names are considered as Cancel and Rebook by most of the Hotels.
        Any Changes in initial booking may be denied by the supplier or may result in extra charges.
        Confirmation of amendment requests is subject to availablity and rates at the time of amendment.<Br><Br><B><U>Detailed Cancellation Policy:</U></B> <br/> Cancellation Charges of 5.44 USD applicable if cancelled after 26-Oct-2020 14:00 hrs.', supplier_cancellation_policy = '', status_date = '2020-10-24 11:49:40',  site_url = 'https://alpha.otrams.thefabulousgetaway.com/';
[10/24/2020 11:49:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO external_mapping_data_tracking (booking_id,search_hotel_name,booked_hotel_name_supplier,hotel_id,master_id,city_id,supplier,date) VALUES ('3046','SASSYSPOON','SASSYSPOON','53775','53775','mumbai','LOCAL_SUPPLIER',NOW());
[10/24/2020 11:49:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='3046'
        ;
[10/24/2020 11:49:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into bookings_details(booking_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,hotel_id,local_hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('3046','S000000241','2','3','0','-','','','53775','53775','SASSYSPOON','Test','123456789','5.0','2','2020/10/29','2020/10/31','','https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/images/imagenotavailable.jpg');
[10/24/2020 11:49:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into booking_room_detail set  booking_id = '3046', booking_detail_id = '1184', room_type_code = '1~~~132~~~1039~~~1~~~~~~~~~64440~~~0~~~S000000241', room_name = 'single', room_type_description = 'Standard  -Bed & Breakfast : 1 Pax ', display_nightly_rates = 'a:2:{i:0;a:3:{s:18:\"displayNightlyRate\";d:27.22;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:152:\"Supplier Name - localsupplier(RateGainSupplier - S000000241), Rate - 100 AED, Currency Multiplier (AED-USD) - 0.27222 Supplier Commission-0 #localsystem\";}i:1;a:3:{s:18:\"displayNightlyRate\";d:27.22;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:152:\"Supplier Name - localsupplier(RateGainSupplier - S000000241), Rate - 100 AED, Currency Multiplier (AED-USD) - 0.27222 Supplier Commission-0 #localsystem\";}}', native_nightly_rates = 'a:2:{i:0;a:4:{s:19:\"O_nativeNightlyRate\";i:100;s:17:\"nativeNightlyRate\";i:100;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";s:0:\"\";s:4:\"Name\";s:0:\"\";s:7:\"S_Value\";s:0:\"\";s:5:\"Value\";i:0;s:12:\"Display_Name\";s:0:\"\";s:10:\"Offer_Note\";N;s:10:\"Offer_Type\";N;}}i:1;a:4:{s:19:\"O_nativeNightlyRate\";i:100;s:17:\"nativeNightlyRate\";i:100;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";s:0:\"\";s:4:\"Name\";s:0:\"\";s:7:\"S_Value\";s:0:\"\";s:5:\"Value\";i:0;s:12:\"Display_Name\";s:0:\"\";s:10:\"Offer_Note\";N;s:10:\"Offer_Type\";N;}}}', markup = '0', commission = '0', native_room_rate_total = '200', display_room_rate_total = '54.44', number_of_rooms = '1';
[10/24/2020 11:49:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into booking_room_detail set  booking_id = '3046', booking_detail_id = '1184', room_type_code = '2~~~132~~~1044~~~1~~~~~~~~~64440~~~0~~~S000000241', room_name = 'double', room_type_description = 'Standard  -Bed & Breakfast : 2 Pax ', display_nightly_rates = 'a:2:{i:0;a:3:{s:18:\"displayNightlyRate\";d:54.44;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:152:\"Supplier Name - localsupplier(RateGainSupplier - S000000241), Rate - 200 AED, Currency Multiplier (AED-USD) - 0.27222 Supplier Commission-0 #localsystem\";}i:1;a:3:{s:18:\"displayNightlyRate\";d:54.44;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:152:\"Supplier Name - localsupplier(RateGainSupplier - S000000241), Rate - 200 AED, Currency Multiplier (AED-USD) - 0.27222 Supplier Commission-0 #localsystem\";}}', native_nightly_rates = 'a:2:{i:0;a:4:{s:19:\"O_nativeNightlyRate\";i:200;s:17:\"nativeNightlyRate\";i:200;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";s:0:\"\";s:4:\"Name\";s:0:\"\";s:7:\"S_Value\";s:0:\"\";s:5:\"Value\";i:0;s:12:\"Display_Name\";s:0:\"\";s:10:\"Offer_Note\";N;s:10:\"Offer_Type\";N;}}i:1;a:4:{s:19:\"O_nativeNightlyRate\";i:200;s:17:\"nativeNightlyRate\";i:200;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";s:0:\"\";s:4:\"Name\";s:0:\"\";s:7:\"S_Value\";s:0:\"\";s:5:\"Value\";i:0;s:12:\"Display_Name\";s:0:\"\";s:10:\"Offer_Note\";N;s:10:\"Offer_Type\";N;}}}', markup = '0', commission = '0', native_room_rate_total = '400', display_room_rate_total = '108.88', number_of_rooms = '1';
[10/24/2020 11:49:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '', confirmation_number = '', display_discount = '0', current_status = 'confirmed', comment_contract = '', consultant_id = 'nitinalpha', sales_manager_id = 'otrams', admin_booked = '0', email_id = '', leader_phone = '', agent_currency_multiplier = '1.00000', ip_addr = '60.254.11.53', backoffice_user = 'tfg', customer_id = '', applied_multiplier='0.27222', free_sale='',  applied_markup='0',  agent_markup='0',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='0.27222',  parent_agent_id='25',  sub_agent_rate='0', agent_rate='163.32',  applicable_service_tax='0',  supplier_rate='600',  original_source='',  uid='a07fff32ceb19188a47dfff616ded918'  where id='3046';
[10/24/2020 11:49:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' ,gtaToken = '' , special_request='' where booking_id ='3046';
[10/24/2020 11:49:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,supplier_charge,agent_charge,lead_time,create_date)  VALUES('3046','2020-10-26 14:00:00','2020-10-26 14:00:00','30','5.44','0','2020-10-24 11:49:41');
[10/24/2020 11:49:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('3046','','');
[10/24/2020 11:49:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_status (booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by) VALUES ('3046','confirmed','2020-10-24 11:49:41','Booking confirmed . Booked by Back Office tfg on behalf of Agent - Snehal  Valanju(CD0025)','25','60.254.11.53','0','25');
[10/24/2020 11:49:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_search_log(booking_id, details)
        VALUES(3046, 'a:30:{s:3:\"_id\";a:1:{s:4:\"$oid\";s:24:\"5f9413973b5a6b7ce2228aa5\";}s:7:\"hotelId\";s:25:\"53775----------S000000241\";s:4:\"name\";s:10:\"SASSYSPOON\";s:14:\"local_hotel_id\";s:5:\"53775\";s:8:\"address1\";s:4:\"Test\";s:8:\"latitude\";s:0:\"\";s:9:\"longitude\";s:0:\"\";s:4:\"city\";s:5:\"64440\";s:8:\"location\";s:0:\"\";s:14:\"prefered_hotel\";s:1:\"0\";s:10:\"mlosSlogan\";s:0:\"\";s:16:\"isMlosApplicable\";s:2:\"no\";s:7:\"country\";s:3:\"106\";s:16:\"rateCurrencyCode\";s:3:\"USD\";s:5:\"phone\";s:9:\"123456789\";s:16:\"shortDescription\";s:24:\"No Description Available\";s:11:\"website_url\";s:0:\"\";s:12:\"thumbNailUrl\";s:99:\"https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/images/imagenotavailable.jpg\";s:10:\"sourceType\";s:11:\"localsystem\";s:10:\"supplierid\";s:10:\"S000000241\";s:12:\"suppliername\";s:16:\"RateGainSupplier\";s:14:\"propertyRating\";s:3:\"5.0\";s:15:\"specialCategory\";a:1:{i:0;s:1:\"1\";}s:13:\"HotelProperty\";a:1:{s:11:\"localsystem\";a:1:{i:0;a:1:{s:8:\"RateInfo\";a:13:{s:9:\"available\";i:1;s:15:\"displayRoomRate\";d:163.32;s:14:\"nativeRoomRate\";i:600;s:10:\"supplierId\";s:10:\"S000000241\";s:9:\"unique_id\";s:36:\"1_2_0_53775----------S000000241_1853\";s:19:\"displayCurrencyCode\";s:3:\"USD\";s:18:\"nativeCurrencyCode\";s:3:\"AED\";s:18:\"applied_markup_per\";i:0;s:18:\"applied_multiplier\";d:0.27222;s:19:\"supplier_profile_id\";s:1:\"1\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53775----------S000000241\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:10:\"SASSYSPOON\";s:18:\"supp_hotel_address\";s:4:\"Test\";s:10:\"supplierId\";s:10:\"S000000241\";}s:8:\"no_class\";s:1:\"0\";s:10:\"room_rates\";a:2:{i:0;a:34:{s:11:\"ratebreakup\";a:4:{s:6:\"markup\";i:0;s:10:\"commission\";i:0;s:18:\"NativeNightlyRates\";a:2:{i:0;a:4:{s:19:\"O_nativeNightlyRate\";i:100;s:17:\"nativeNightlyRate\";i:100;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";s:0:\"\";s:4:\"Name\";s:0:\"\";s:7:\"S_Value\";s:0:\"\";s:5:\"Value\";i:0;s:12:\"Display_Name\";s:0:\"\";s:10:\"Offer_Note\";N;s:10:\"Offer_Type\";N;}}i:1;a:4:{s:19:\"O_nativeNightlyRate\";i:100;s:17:\"nativeNightlyRate\";i:100;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";s:0:\"\";s:4:\"Name\";s:0:\"\";s:7:\"S_Value\";s:0:\"\";s:5:\"Value\";i:0;s:12:\"Display_Name\";s:0:\"\";s:10:\"Offer_Note\";N;s:10:\"Offer_Type\";N;}}}s:19:\"DisplayNightlyRates\";a:2:{i:0;a:3:{s:18:\"displayNightlyRate\";d:27.22;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:152:\"Supplier Name - localsupplier(RateGainSupplier - S000000241), Rate - 100 AED, Currency Multiplier (AED-USD) - 0.27222 Supplier Commission-0 #localsystem\";}i:1;a:3:{s:18:\"displayNightlyRate\";d:27.22;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:152:\"Supplier Name - localsupplier(RateGainSupplier - S000000241), Rate - 100 AED, Currency Multiplier (AED-USD) - 0.27222 Supplier Commission-0 #localsystem\";}}}s:20:\"offer_promotion_note\";s:0:\"\";s:19:\"offer_discount_type\";s:0:\"\";s:27:\"offer_discount_note_details\";N;s:9:\"room_name\";s:6:\"single\";s:9:\"stay_note\";N;s:10:\"time_stamp\";s:32:\"24982dc98372af2ea5bad2ad8724bf99\";s:16:\"number_of_adults\";s:1:\"1\";s:10:\"view_basis\";s:0:\"\";s:13:\"view_basis_id\";s:1:\"0\";s:9:\"available\";i:1;s:9:\"free_sale\";N;s:7:\"minStay\";s:1:\"1\";s:19:\"displayCurrencyCode\";s:3:\"USD\";s:18:\"nativeCurrencyCode\";s:3:\"AED\";s:20:\"displayRoomTypeRates\";d:54.44;s:20:\"sortingRoomTypeRates\";d:54.44;s:19:\"nativeRoomTypeRates\";i:200;s:12:\"offerApplied\";N;s:7:\"room_id\";s:49:\"1~~~132~~~1039~~~1~~~~~~~~~64440~~~0~~~S000000241\";s:14:\"room_type_code\";s:1:\"1\";s:14:\"boardtype_code\";s:1:\"1\";s:16:\"valuation_number\";s:49:\"1~~~132~~~1039~~~1~~~~~~~~~64440~~~0~~~S000000241\";s:15:\"number_of_child\";i:0;s:13:\"NumberOfRooms\";i:1;s:10:\"supplierId\";s:10:\"S000000241\";s:12:\"supplierName\";s:16:\"RateGainSupplier\";s:10:\"meal_basis\";s:15:\"Bed & Breakfast\";s:4:\"note\";s:0:\"\";s:13:\"room_category\";s:13:\"Standard Room\";s:9:\"room_type\";s:35:\"Standard  -Bed & Breakfast : 1 Pax \";s:14:\"non_refundable\";s:1:\"0\";s:15:\"class_unique_id\";s:17:\"0_0_53775_7872441\";s:7:\"checked\";i:1;}i:1;a:34:{s:11:\"ratebreakup\";a:4:{s:6:\"markup\";i:0;s:10:\"commission\";i:0;s:18:\"NativeNightlyRates\";a:2:{i:0;a:4:{s:19:\"O_nativeNightlyRate\";i:200;s:17:\"nativeNightlyRate\";i:200;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";s:0:\"\";s:4:\"Name\";s:0:\"\";s:7:\"S_Value\";s:0:\"\";s:5:\"Value\";i:0;s:12:\"Display_Name\";s:0:\"\";s:10:\"Offer_Note\";N;s:10:\"Offer_Type\";N;}}i:1;a:4:{s:19:\"O_nativeNightlyRate\";i:200;s:17:\"nativeNightlyRate\";i:200;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";s:0:\"\";s:4:\"Name\";s:0:\"\";s:7:\"S_Value\";s:0:\"\";s:5:\"Value\";i:0;s:12:\"Display_Name\";s:0:\"\";s:10:\"Offer_Note\";N;s:10:\"Offer_Type\";N;}}}s:19:\"DisplayNightlyRates\";a:2:{i:0;a:3:{s:18:\"displayNightlyRate\";d:54.44;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:152:\"Supplier Name - localsupplier(RateGainSupplier - S000000241), Rate - 200 AED, Currency Multiplier (AED-USD) - 0.27222 Supplier Commission-0 #localsystem\";}i:1;a:3:{s:18:\"displayNightlyRate\";d:54.44;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:152:\"Supplier Name - localsupplier(RateGainSupplier - S000000241), Rate - 200 AED, Currency Multiplier (AED-USD) - 0.27222 Supplier Commission-0 #localsystem\";}}}s:20:\"offer_promotion_note\";s:0:\"\";s:19:\"offer_discount_type\";s:0:\"\";s:27:\"offer_discount_note_details\";N;s:9:\"room_name\";s:6:\"double\";s:9:\"stay_note\";N;s:10:\"time_stamp\";s:32:\"28cc18be1e999d276b002b813513e4a2\";s:16:\"number_of_adults\";s:1:\"2\";s:10:\"view_basis\";s:0:\"\";s:13:\"view_basis_id\";s:1:\"0\";s:9:\"available\";i:1;s:9:\"free_sale\";N;s:7:\"minStay\";s:1:\"1\";s:19:\"displayCurrencyCode\";s:3:\"USD\";s:18:\"nativeCurrencyCode\";s:3:\"AED\";s:20:\"displayRoomTypeRates\";d:108.88;s:20:\"sortingRoomTypeRates\";d:108.88;s:19:\"nativeRoomTypeRates\";i:400;s:12:\"offerApplied\";N;s:7:\"room_id\";s:49:\"2~~~132~~~1044~~~1~~~~~~~~~64440~~~0~~~S000000241\";s:14:\"room_type_code\";s:1:\"2\";s:14:\"boardtype_code\";s:1:\"1\";s:16:\"valuation_number\";s:49:\"2~~~132~~~1044~~~1~~~~~~~~~64440~~~0~~~S000000241\";s:15:\"number_of_child\";i:0;s:13:\"NumberOfRooms\";i:1;s:10:\"supplierId\";s:10:\"S000000241\";s:12:\"supplierName\";s:16:\"RateGainSupplier\";s:10:\"meal_basis\";s:15:\"Bed & Breakfast\";s:4:\"note\";s:0:\"\";s:13:\"room_category\";s:13:\"Standard Room\";s:9:\"room_type\";s:35:\"Standard  -Bed & Breakfast : 2 Pax \";s:14:\"non_refundable\";s:1:\"0\";s:15:\"class_unique_id\";s:16:\"0_0_53775_184655\";s:7:\"checked\";i:1;}}}}}}s:13:\"total_charges\";d:163.32;s:17:\"propertyAvailable\";i:1;s:8:\"no_class\";i:1;s:18:\"sort_total_charges\";d:163.32;s:16:\"hotel_name_ascii\";s:10:\"sassyspoon\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53775----------S000000241\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:10:\"SASSYSPOON\";s:18:\"supp_hotel_address\";s:4:\"Test\";s:10:\"supplierId\";s:10:\"S000000241\";}}');
[10/24/2020 11:49:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,to_date,supplier_to_date,supplier_charge,agent_charge,lead_time,create_date,applied_agent_charges)  VALUES('3046','2020-10-26 14:00:00','2020-10-26 14:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','30','5.44','0','2020-10-24 11:49:41','');
[10/24/2020 11:49:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO bookings_applicable_offer set  oid= '',  offer_type_code= '',  booking_id= '3046',  room_id= '1~~~132~~~1039~~~1~~~~~~~~~64440~~~0~~~S000000241',  room_name= 'single',  supplier_id= 'S000000241',  agent_id= '',  applied_native_discount= '0',  original_native_rate= '200',  native_rate= '200',  promotion_text= '',  offer_disc_type= '',  offer_disc_value= '',  offer_disc_currency= '',  create_date= '2020-10-24 11:49:41' ;
[10/24/2020 11:49:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO bookings_applicable_offer set  oid= '',  offer_type_code= '',  booking_id= '3046',  room_id= '2~~~132~~~1044~~~1~~~~~~~~~64440~~~0~~~S000000241',  room_name= 'double',  supplier_id= 'S000000241',  agent_id= '',  applied_native_discount= '0',  original_native_rate= '400',  native_rate= '400',  promotion_text= '',  offer_disc_type= '',  offer_disc_value= '',  offer_disc_currency= '',  create_date= '2020-10-24 11:49:41' ;
[10/24/2020 11:49:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set confirmation_number='',itenirary_id='3046' where  id ='3046';
[10/24/2020 11:49:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],UPDATE room_rates SET availability = availability-1,consumed_inventory = consumed_inventory+1 WHERE hotel_id = '53775' and inventory_class_id = '132' and supplier_id = 'S000000241' and date_from = '2020-10-29';
[10/24/2020 11:49:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],UPDATE room_rates SET availability = availability-1,consumed_inventory = consumed_inventory+1 WHERE hotel_id = '53775' and inventory_class_id = '132' and supplier_id = 'S000000241' and date_from = '2020-10-30';
[10/24/2020 11:49:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update supplement_rate set inventory = '0' where supplement_rate_id = '1';
[10/24/2020 11:49:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],UPDATE room_rates SET availability = availability-1,consumed_inventory = consumed_inventory+1 WHERE hotel_id = '53775' and inventory_class_id = '132' and supplier_id = 'S000000241' and date_from = '2020-10-29';
[10/24/2020 11:49:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],UPDATE room_rates SET availability = availability-1,consumed_inventory = consumed_inventory+1 WHERE hotel_id = '53775' and inventory_class_id = '132' and supplier_id = 'S000000241' and date_from = '2020-10-30';
[10/24/2020 11:49:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into booking_configuration set  booking_id = '3046', config_key = 'BOOKING OTP', config_value = 'ymvqnA4h';;
[10/24/2020 11:49:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= ' TFG103046 /  Booking Confirmed ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 52676 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking.php',create_date= '2020-10-24 11:49:42';
[10/24/2020 11:49:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3046','snehal.valanju@qtechsoftware.com');
[10/24/2020 11:49:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3046','snehal.valanju@qtechsoftware.com');
[10/24/2020 11:49:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update posted_bookings set booking_id='3046',status='1' where reservation_id='1849' and booking_id ='0';
[10/24/2020 11:49:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update xmllogs set reservation_id='3046' where agent_logs_id='461' and source_type='localsystem';
[10/24/2020 11:49:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='',  profit_percent='',  gross_profit='',  commission_tax='',  booking_id ='3046',  create_date ='2020-10-24 11:49:42', supplier_tax='';
[10/24/2020 11:49:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= ' TFG103046 /  Booking Confirmed ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 35788 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,nitin@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking.php',create_date= '2020-10-24 11:49:43';
[10/24/2020 11:49:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3046','snehal.valanju@qtechsoftware.com');
[10/24/2020 11:49:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3046','nitin@qtechsoftware.com');
[10/24/2020 11:54:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],UPDATE hotel_supplier_mapping SET channel_manager = 'rategain',ip_addr='60.254.11.53' WHERE SupplierId = 'S000000241' AND hotel_id = '53775' AND status = 'A';
[10/24/2020 11:54:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-24 11:54:41',`log_type`= 'Channel Manager updated',`sql_query`= 'UPDATE hotel_supplier_mapping SET channel_manager = \&#039;rategain\&#039;,ip_addr=\&#039;60.254.11.53\&#039; WHERE SupplierId = \&#039;S000000241\&#039; AND hotel_id = \&#039;53775\&#039; AND status = \&#039;A\&#039;',`log_description`= 'Channel Manager updated by User tfg',`ip`= '60.254.11.53';
[10/24/2020 11:54:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-24 11:54:41',`log_type`= 'Channel Manager updated',`sql_query`= 'UPDATE hotel_supplier_mapping SET channel_manager = \&#039;rategain\&#039;,ip_addr=\&#039;60.254.11.53\&#039; WHERE SupplierId = \&#039;S000000241\&#039; AND hotel_id = \&#039;53775\&#039; AND status = \&#039;A\&#039;',`log_description`= 'Channel Manager updated by User tfg',`ip`= '60.254.11.53';
[10/24/2020 11:54:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='3848', `entity`='Hotels', `value`='53775' ;
[10/24/2020 11:54:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='3848', `entity`='Suppliers', `value`='S000000241' ;
[10/24/2020 11:54:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],UPDATE hotels SET weekend='6,7',infant_lower_limit='0',infant_upper_limit='3',tiny_child_lower_limit='4',tiny_child_upper_limit='6',child_lower_limit='7',child_upper_limit='9',teen_child_lower_limit=NULL,teen_child_upper_limit=NULL,booking_closing_time='',timezone='5.5' where id= '53775';
[10/24/2020 11:54:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-24 11:54:41',`log_type`= 'Hotel Details updated',`sql_query`= 'UPDATE hotels SET weekend=\&#039;6,7\&#039;,infant_lower_limit=\&#039;0\&#039;,infant_upper_limit=\&#039;3\&#039;,tiny_child_lower_limit=\&#039;4\&#039;,tiny_child_upper_limit=\&#039;6\&#039;,child_lower_limit=\&#039;7\&#039;,child_upper_limit=\&#039;9\&#039;,teen_child_lower_limit=NULL,teen_child_upper_limit=NULL,booking_closing_time=\&#039;\&#039;,timezone=\&#039;5.5\&#039; where id= \&#039;53775\&#039;',`log_description`= 'Hotel Details updated by User tfg',`ip`= '60.254.11.53';
[10/24/2020 11:54:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-24 11:54:41',`log_type`= 'Hotel Details updated',`sql_query`= 'UPDATE hotels SET weekend=\&#039;6,7\&#039;,infant_lower_limit=\&#039;0\&#039;,infant_upper_limit=\&#039;3\&#039;,tiny_child_lower_limit=\&#039;4\&#039;,tiny_child_upper_limit=\&#039;6\&#039;,child_lower_limit=\&#039;7\&#039;,child_upper_limit=\&#039;9\&#039;,teen_child_lower_limit=NULL,teen_child_upper_limit=NULL,booking_closing_time=\&#039;\&#039;,timezone=\&#039;5.5\&#039; where id= \&#039;53775\&#039;',`log_description`= 'Hotel Details updated by User tfg',`ip`= '60.254.11.53';
[10/24/2020 11:54:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='3850', `entity`='Hotels', `value`='53775' ;
[10/24/2020 11:54:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='3850', `entity`='Suppliers', `value`='S000000241' ;
[10/24/2020 11:54:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],DELETE FROM hotel_room_class_mapping WHERE hotel_id='53775' AND supplier_id='S000000241';
[10/24/2020 11:54:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53775', supplier_id='S000000241', class_id='1044', is_channel_manager_mapped = '1';
[10/24/2020 11:54:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53775', supplier_id='S000000241', class_id='1039', is_channel_manager_mapped = '1';
[10/24/2020 11:55:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '60.254.11.53' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/10/29' , departure_date = '2020/10/31' , nationality = '106' , nights = '2' , room_types = '2, 1' , create_date = '2020-10-24 11:55:30' , site_id = '' , country_code = '106' , web_service = '' ;
[10/24/2020 11:55:34], [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-10-24 11:55:34', '', '2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd', '462');
[10/24/2020 11:55:34], [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-10-24 11:55:34', '', '2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd', '462');
[10/24/2020 11:55:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd&xml_user_id=25&request_no=1&local_hotel_code=53769&#039;,&#039;53771&#039;,&#039;53773&#039;,&#039;53775&#039;,&#039;53776&#039;,&#039;53742&web_service=no&site_id='
, http_hit_time = '2020-10-24 11:55:32.389'
, 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.853'
, error_description = ''
, memory_used = '7912312'
WHERE id = '3220';
[10/24/2020 11:55:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd&xml_user_id=25&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;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&#039;,&#039;53766&#039;,&#039;53767&#039;,&#039;53768&web_service=no&site_id='
, http_hit_time = '2020-10-24 11:55:32.421'
, 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 = '2.888'
, error_description = ''
, memory_used = '7913752'
WHERE id = '3221';
[10/24/2020 11:55:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=2370a4ac8d3b59e785187207af694983729f0e599714fa79dd8f8bb6ee1347bd',
  duration = '3.983',
  merge_duration = '0.488',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.69',
  system_load_5_min = '1.02',
  system_load_15_min = '1.29',
  system_memory_usage = '93.54',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '462') + '8047096',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '462';
[10/24/2020 11:55:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1603540552','60.254.11.53');
[10/24/2020 11:56:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1603540564','60.254.11.53');
[10/24/2020 11:56:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO bookings SET  source_type = 'localsystem', reservation_id = '1851', create_date = '2020-10-24 11:56:09', agent_id = '25', parent_agent_id = '25', agent_ref_no = '', nationality = 'Indian', city_id = 'mumbai', country_id = '106', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '163.32', display_currency_code = 'USD', native_room_rate = '600', native_currency_code = 'AED', supplier_profile_id = '1', service_type = 'hotel', service_date = '2020/10/29', check_out_date = '2020/10/31', sub_user_id = '', booking_status = '1', leader_title = '', leader_first_name = '', leader_last_name = '', booking_branch_id = '1', expiration_date = '2020-10-27 00:00:00', cancellation_policy = 'Amendment of Dates, Room Category, Passenger Names are considered as Cancel and Rebook by most of the Hotels.
        Any Changes in initial booking may be denied by the supplier or may result in extra charges.
        Confirmation of amendment requests is subject to availablity and rates at the time of amendment.<Br><Br><B><U>Detailed Cancellation Policy:</U></B> <br/> Cancellation Charges of 5.44 USD applicable if cancelled after 26-Oct-2020 14:00 hrs.', supplier_cancellation_policy = '', status_date = '2020-10-24 11:56:09',  site_url = 'https://alpha.otrams.thefabulousgetaway.com/';
[10/24/2020 11:56:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO external_mapping_data_tracking (booking_id,search_hotel_name,booked_hotel_name_supplier,hotel_id,master_id,city_id,supplier,date) VALUES ('3047','SASSYSPOON','SASSYSPOON','53775','53775','mumbai','LOCAL_SUPPLIER',NOW());
[10/24/2020 11:56:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='3047'
        ;
[10/24/2020 11:56:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into bookings_details(booking_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,hotel_id,local_hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('3047','S000000241','2','3','0','-','','','53775','53775','SASSYSPOON','Test','123456789','5.0','2','2020/10/29','2020/10/31','','https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/images/imagenotavailable.jpg');
[10/24/2020 11:56:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into booking_room_detail set  booking_id = '3047', booking_detail_id = '1185', room_type_code = '1~~~132~~~1039~~~1~~~~~~~~~64440~~~0~~~S000000241', room_name = 'single', room_type_description = 'Standard  -Bed & Breakfast : 1 Pax <font color=\'red\'>-D</font>', display_nightly_rates = 'a:2:{i:0;a:3:{s:18:\"displayNightlyRate\";d:27.22;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:152:\"Supplier Name - localsupplier(RateGainSupplier - S000000241), Rate - 100 AED, Currency Multiplier (AED-USD) - 0.27222 Supplier Commission-0 #localsystem\";}i:1;a:3:{s:18:\"displayNightlyRate\";d:27.22;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:152:\"Supplier Name - localsupplier(RateGainSupplier - S000000241), Rate - 100 AED, Currency Multiplier (AED-USD) - 0.27222 Supplier Commission-0 #localsystem\";}}', native_nightly_rates = 'a:2:{i:0;a:4:{s:19:\"O_nativeNightlyRate\";i:100;s:17:\"nativeNightlyRate\";i:100;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";s:0:\"\";s:4:\"Name\";s:0:\"\";s:7:\"S_Value\";s:0:\"\";s:5:\"Value\";i:0;s:12:\"Display_Name\";s:0:\"\";s:10:\"Offer_Note\";N;s:10:\"Offer_Type\";N;}}i:1;a:4:{s:19:\"O_nativeNightlyRate\";i:100;s:17:\"nativeNightlyRate\";i:100;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";s:0:\"\";s:4:\"Name\";s:0:\"\";s:7:\"S_Value\";s:0:\"\";s:5:\"Value\";i:0;s:12:\"Display_Name\";s:0:\"\";s:10:\"Offer_Note\";N;s:10:\"Offer_Type\";N;}}}', markup = '0', commission = '0', native_room_rate_total = '200', display_room_rate_total = '54.44', number_of_rooms = '1';
[10/24/2020 11:56:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into booking_room_detail set  booking_id = '3047', booking_detail_id = '1185', room_type_code = '2~~~132~~~1044~~~1~~~~~~~~~64440~~~0~~~S000000241', room_name = 'double', room_type_description = 'Standard  -Bed & Breakfast : 2 Pax <font color=\'red\'>-D</font>', display_nightly_rates = 'a:2:{i:0;a:3:{s:18:\"displayNightlyRate\";d:54.44;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:152:\"Supplier Name - localsupplier(RateGainSupplier - S000000241), Rate - 200 AED, Currency Multiplier (AED-USD) - 0.27222 Supplier Commission-0 #localsystem\";}i:1;a:3:{s:18:\"displayNightlyRate\";d:54.44;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:152:\"Supplier Name - localsupplier(RateGainSupplier - S000000241), Rate - 200 AED, Currency Multiplier (AED-USD) - 0.27222 Supplier Commission-0 #localsystem\";}}', native_nightly_rates = 'a:2:{i:0;a:4:{s:19:\"O_nativeNightlyRate\";i:200;s:17:\"nativeNightlyRate\";i:200;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";s:0:\"\";s:4:\"Name\";s:0:\"\";s:7:\"S_Value\";s:0:\"\";s:5:\"Value\";i:0;s:12:\"Display_Name\";s:0:\"\";s:10:\"Offer_Note\";N;s:10:\"Offer_Type\";N;}}i:1;a:4:{s:19:\"O_nativeNightlyRate\";i:200;s:17:\"nativeNightlyRate\";i:200;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";s:0:\"\";s:4:\"Name\";s:0:\"\";s:7:\"S_Value\";s:0:\"\";s:5:\"Value\";i:0;s:12:\"Display_Name\";s:0:\"\";s:10:\"Offer_Note\";N;s:10:\"Offer_Type\";N;}}}', markup = '0', commission = '0', native_room_rate_total = '400', display_room_rate_total = '108.88', number_of_rooms = '1';
[10/24/2020 11:56:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '', confirmation_number = '', display_discount = '0', current_status = 'confirmed', comment_contract = '', consultant_id = 'nitinalpha', sales_manager_id = 'otrams', admin_booked = '0', email_id = '', leader_phone = '', agent_currency_multiplier = '1.00000', ip_addr = '60.254.11.53', backoffice_user = 'tfg', customer_id = '', applied_multiplier='0.27222', free_sale='',  applied_markup='0',  agent_markup='0',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='0.27222',  parent_agent_id='25',  sub_agent_rate='0', agent_rate='163.32',  applicable_service_tax='0',  supplier_rate='600',  original_source='',  uid='f0a300d3eca89d469e139d37bbea06b8'  where id='3047';
[10/24/2020 11:56:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' ,gtaToken = '' , special_request='' where booking_id ='3047';
[10/24/2020 11:56:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings_details set reservation_pushed = '1', channel_manager = 'rategain',room_type_description='' where booking_id = '3047';
[10/24/2020 11:56:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,supplier_charge,agent_charge,lead_time,create_date)  VALUES('3047','2020-10-26 14:00:00','2020-10-26 14:00:00','30','5.44','0','2020-10-24 11:56:09');
[10/24/2020 11:56:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('3047','','');
[10/24/2020 11:56:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_status (booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by) VALUES ('3047','confirmed','2020-10-24 11:56:09','Booking confirmed . Booked by Back Office tfg on behalf of Agent - Snehal  Valanju(CD0025)','25','60.254.11.53','0','25');
[10/24/2020 11:56:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_search_log(booking_id, details)
        VALUES(3047, 'a:30:{s:3:\"_id\";a:1:{s:4:\"$oid\";s:24:\"5f941636b9478a2fbb45a805\";}s:7:\"hotelId\";s:25:\"53775----------S000000241\";s:4:\"name\";s:10:\"SASSYSPOON\";s:14:\"local_hotel_id\";s:5:\"53775\";s:8:\"address1\";s:4:\"Test\";s:8:\"latitude\";s:0:\"\";s:9:\"longitude\";s:0:\"\";s:4:\"city\";s:5:\"64440\";s:8:\"location\";s:0:\"\";s:14:\"prefered_hotel\";s:1:\"0\";s:10:\"mlosSlogan\";s:0:\"\";s:16:\"isMlosApplicable\";s:2:\"no\";s:7:\"country\";s:3:\"106\";s:16:\"rateCurrencyCode\";s:3:\"USD\";s:5:\"phone\";s:9:\"123456789\";s:16:\"shortDescription\";s:24:\"No Description Available\";s:11:\"website_url\";s:0:\"\";s:12:\"thumbNailUrl\";s:99:\"https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/images/imagenotavailable.jpg\";s:10:\"sourceType\";s:11:\"localsystem\";s:10:\"supplierid\";s:10:\"S000000241\";s:12:\"suppliername\";s:16:\"RateGainSupplier\";s:14:\"propertyRating\";s:3:\"5.0\";s:15:\"specialCategory\";a:1:{i:0;s:1:\"1\";}s:13:\"HotelProperty\";a:1:{s:11:\"localsystem\";a:1:{i:0;a:1:{s:8:\"RateInfo\";a:13:{s:9:\"available\";i:1;s:15:\"displayRoomRate\";d:163.32;s:14:\"nativeRoomRate\";i:600;s:10:\"supplierId\";s:10:\"S000000241\";s:9:\"unique_id\";s:36:\"1_2_0_53775----------S000000241_9841\";s:19:\"displayCurrencyCode\";s:3:\"USD\";s:18:\"nativeCurrencyCode\";s:3:\"AED\";s:18:\"applied_markup_per\";i:0;s:18:\"applied_multiplier\";d:0.27222;s:19:\"supplier_profile_id\";s:1:\"1\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53775----------S000000241\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:10:\"SASSYSPOON\";s:18:\"supp_hotel_address\";s:4:\"Test\";s:10:\"supplierId\";s:10:\"S000000241\";}s:8:\"no_class\";s:1:\"0\";s:10:\"room_rates\";a:2:{i:0;a:34:{s:11:\"ratebreakup\";a:4:{s:6:\"markup\";i:0;s:10:\"commission\";i:0;s:18:\"NativeNightlyRates\";a:2:{i:0;a:4:{s:19:\"O_nativeNightlyRate\";i:100;s:17:\"nativeNightlyRate\";i:100;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";s:0:\"\";s:4:\"Name\";s:0:\"\";s:7:\"S_Value\";s:0:\"\";s:5:\"Value\";i:0;s:12:\"Display_Name\";s:0:\"\";s:10:\"Offer_Note\";N;s:10:\"Offer_Type\";N;}}i:1;a:4:{s:19:\"O_nativeNightlyRate\";i:100;s:17:\"nativeNightlyRate\";i:100;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";s:0:\"\";s:4:\"Name\";s:0:\"\";s:7:\"S_Value\";s:0:\"\";s:5:\"Value\";i:0;s:12:\"Display_Name\";s:0:\"\";s:10:\"Offer_Note\";N;s:10:\"Offer_Type\";N;}}}s:19:\"DisplayNightlyRates\";a:2:{i:0;a:3:{s:18:\"displayNightlyRate\";d:27.22;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:152:\"Supplier Name - localsupplier(RateGainSupplier - S000000241), Rate - 100 AED, Currency Multiplier (AED-USD) - 0.27222 Supplier Commission-0 #localsystem\";}i:1;a:3:{s:18:\"displayNightlyRate\";d:27.22;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:152:\"Supplier Name - localsupplier(RateGainSupplier - S000000241), Rate - 100 AED, Currency Multiplier (AED-USD) - 0.27222 Supplier Commission-0 #localsystem\";}}}s:20:\"offer_promotion_note\";s:0:\"\";s:19:\"offer_discount_type\";s:0:\"\";s:27:\"offer_discount_note_details\";N;s:9:\"room_name\";s:6:\"single\";s:9:\"stay_note\";N;s:10:\"time_stamp\";s:32:\"24982dc98372af2ea5bad2ad8724bf99\";s:16:\"number_of_adults\";s:1:\"1\";s:10:\"view_basis\";s:0:\"\";s:13:\"view_basis_id\";s:1:\"0\";s:9:\"available\";i:1;s:9:\"free_sale\";N;s:7:\"minStay\";s:1:\"1\";s:19:\"displayCurrencyCode\";s:3:\"USD\";s:18:\"nativeCurrencyCode\";s:3:\"AED\";s:20:\"displayRoomTypeRates\";d:54.44;s:20:\"sortingRoomTypeRates\";d:54.44;s:19:\"nativeRoomTypeRates\";i:200;s:12:\"offerApplied\";N;s:7:\"room_id\";s:49:\"1~~~132~~~1039~~~1~~~~~~~~~64440~~~0~~~S000000241\";s:14:\"room_type_code\";s:1:\"1\";s:14:\"boardtype_code\";s:1:\"1\";s:16:\"valuation_number\";s:49:\"1~~~132~~~1039~~~1~~~~~~~~~64440~~~0~~~S000000241\";s:15:\"number_of_child\";i:0;s:13:\"NumberOfRooms\";i:1;s:10:\"supplierId\";s:10:\"S000000241\";s:12:\"supplierName\";s:16:\"RateGainSupplier\";s:10:\"meal_basis\";s:15:\"Bed & Breakfast\";s:4:\"note\";s:0:\"\";s:13:\"room_category\";s:13:\"Standard Room\";s:9:\"room_type\";s:62:\"Standard  -Bed & Breakfast : 1 Pax <font color=\'red\'>-D</font>\";s:14:\"non_refundable\";s:1:\"0\";s:15:\"class_unique_id\";s:17:\"0_0_53775_9467776\";s:7:\"checked\";i:1;}i:1;a:34:{s:11:\"ratebreakup\";a:4:{s:6:\"markup\";i:0;s:10:\"commission\";i:0;s:18:\"NativeNightlyRates\";a:2:{i:0;a:4:{s:19:\"O_nativeNightlyRate\";i:200;s:17:\"nativeNightlyRate\";i:200;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";s:0:\"\";s:4:\"Name\";s:0:\"\";s:7:\"S_Value\";s:0:\"\";s:5:\"Value\";i:0;s:12:\"Display_Name\";s:0:\"\";s:10:\"Offer_Note\";N;s:10:\"Offer_Type\";N;}}i:1;a:4:{s:19:\"O_nativeNightlyRate\";i:200;s:17:\"nativeNightlyRate\";i:200;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";s:0:\"\";s:4:\"Name\";s:0:\"\";s:7:\"S_Value\";s:0:\"\";s:5:\"Value\";i:0;s:12:\"Display_Name\";s:0:\"\";s:10:\"Offer_Note\";N;s:10:\"Offer_Type\";N;}}}s:19:\"DisplayNightlyRates\";a:2:{i:0;a:3:{s:18:\"displayNightlyRate\";d:54.44;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:152:\"Supplier Name - localsupplier(RateGainSupplier - S000000241), Rate - 200 AED, Currency Multiplier (AED-USD) - 0.27222 Supplier Commission-0 #localsystem\";}i:1;a:3:{s:18:\"displayNightlyRate\";d:54.44;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:152:\"Supplier Name - localsupplier(RateGainSupplier - S000000241), Rate - 200 AED, Currency Multiplier (AED-USD) - 0.27222 Supplier Commission-0 #localsystem\";}}}s:20:\"offer_promotion_note\";s:0:\"\";s:19:\"offer_discount_type\";s:0:\"\";s:27:\"offer_discount_note_details\";N;s:9:\"room_name\";s:6:\"double\";s:9:\"stay_note\";N;s:10:\"time_stamp\";s:32:\"28cc18be1e999d276b002b813513e4a2\";s:16:\"number_of_adults\";s:1:\"2\";s:10:\"view_basis\";s:0:\"\";s:13:\"view_basis_id\";s:1:\"0\";s:9:\"available\";i:1;s:9:\"free_sale\";N;s:7:\"minStay\";s:1:\"1\";s:19:\"displayCurrencyCode\";s:3:\"USD\";s:18:\"nativeCurrencyCode\";s:3:\"AED\";s:20:\"displayRoomTypeRates\";d:108.88;s:20:\"sortingRoomTypeRates\";d:108.88;s:19:\"nativeRoomTypeRates\";i:400;s:12:\"offerApplied\";N;s:7:\"room_id\";s:49:\"2~~~132~~~1044~~~1~~~~~~~~~64440~~~0~~~S000000241\";s:14:\"room_type_code\";s:1:\"2\";s:14:\"boardtype_code\";s:1:\"1\";s:16:\"valuation_number\";s:49:\"2~~~132~~~1044~~~1~~~~~~~~~64440~~~0~~~S000000241\";s:15:\"number_of_child\";i:0;s:13:\"NumberOfRooms\";i:1;s:10:\"supplierId\";s:10:\"S000000241\";s:12:\"supplierName\";s:16:\"RateGainSupplier\";s:10:\"meal_basis\";s:15:\"Bed & Breakfast\";s:4:\"note\";s:0:\"\";s:13:\"room_category\";s:13:\"Standard Room\";s:9:\"room_type\";s:62:\"Standard  -Bed & Breakfast : 2 Pax <font color=\'red\'>-D</font>\";s:14:\"non_refundable\";s:1:\"0\";s:15:\"class_unique_id\";s:17:\"0_0_53775_1835051\";s:7:\"checked\";i:1;}}}}}}s:13:\"total_charges\";d:163.32;s:17:\"propertyAvailable\";i:1;s:8:\"no_class\";i:1;s:18:\"sort_total_charges\";d:163.32;s:16:\"hotel_name_ascii\";s:10:\"sassyspoon\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53775----------S000000241\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:10:\"SASSYSPOON\";s:18:\"supp_hotel_address\";s:4:\"Test\";s:10:\"supplierId\";s:10:\"S000000241\";}}');
[10/24/2020 11:56:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,to_date,supplier_to_date,supplier_charge,agent_charge,lead_time,create_date,applied_agent_charges)  VALUES('3047','2020-10-26 14:00:00','2020-10-26 14:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','30','5.44','0','2020-10-24 11:56:09','');
[10/24/2020 11:56:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings_details set reservation_pushed = '1', channel_manager = 'rategain',room_type_description='' where booking_id = '3047';
[10/24/2020 11:56:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO bookings_applicable_offer set  oid= '',  offer_type_code= '',  booking_id= '3047',  room_id= '1~~~132~~~1039~~~1~~~~~~~~~64440~~~0~~~S000000241',  room_name= 'single',  supplier_id= 'S000000241',  agent_id= '',  applied_native_discount= '0',  original_native_rate= '200',  native_rate= '200',  promotion_text= '',  offer_disc_type= '',  offer_disc_value= '',  offer_disc_currency= '',  create_date= '2020-10-24 11:56:09' ;
[10/24/2020 11:56:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO bookings_applicable_offer set  oid= '',  offer_type_code= '',  booking_id= '3047',  room_id= '2~~~132~~~1044~~~1~~~~~~~~~64440~~~0~~~S000000241',  room_name= 'double',  supplier_id= 'S000000241',  agent_id= '',  applied_native_discount= '0',  original_native_rate= '400',  native_rate= '400',  promotion_text= '',  offer_disc_type= '',  offer_disc_value= '',  offer_disc_currency= '',  create_date= '2020-10-24 11:56:09' ;
[10/24/2020 11:56:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set confirmation_number='',itenirary_id='3047' where  id ='3047';
[10/24/2020 11:56:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],UPDATE room_rates SET availability = availability-1,consumed_inventory = consumed_inventory+1 WHERE hotel_id = '53775' and inventory_class_id = '132' and supplier_id = 'S000000241' and date_from = '2020-10-29';
[10/24/2020 11:56:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],UPDATE room_rates SET availability = availability-1,consumed_inventory = consumed_inventory+1 WHERE hotel_id = '53775' and inventory_class_id = '132' and supplier_id = 'S000000241' and date_from = '2020-10-30';
[10/24/2020 11:56:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update supplement_rate set inventory = '0' where supplement_rate_id = '1';
[10/24/2020 11:56:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],UPDATE room_rates SET availability = availability-1,consumed_inventory = consumed_inventory+1 WHERE hotel_id = '53775' and inventory_class_id = '132' and supplier_id = 'S000000241' and date_from = '2020-10-29';
[10/24/2020 11:56:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],UPDATE room_rates SET availability = availability-1,consumed_inventory = consumed_inventory+1 WHERE hotel_id = '53775' and inventory_class_id = '132' and supplier_id = 'S000000241' and date_from = '2020-10-30';
[10/24/2020 11:56:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into booking_configuration set  booking_id = '3047', config_key = 'BOOKING OTP', config_value = '75I3EtFQ';;
[10/24/2020 11:56:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= ' TFG103047 /  Booking Confirmed ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 52748 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking.php',create_date= '2020-10-24 11:56:10';
[10/24/2020 11:56:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3047','snehal.valanju@qtechsoftware.com');
[10/24/2020 11:56:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3047','snehal.valanju@qtechsoftware.com');
[10/24/2020 11:56:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update posted_bookings set booking_id='3047',status='1' where reservation_id='1851' and booking_id ='0';
[10/24/2020 11:56:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update xmllogs set reservation_id='3047' where agent_logs_id='462' and source_type='localsystem';
[10/24/2020 11:56:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='',  profit_percent='',  gross_profit='',  commission_tax='',  booking_id ='3047',  create_date ='2020-10-24 11:56:10', supplier_tax='';
[10/24/2020 11:56:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= ' TFG103047 /  Booking Confirmed ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 35860 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,nitin@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking.php',create_date= '2020-10-24 11:56:11';
[10/24/2020 11:56:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3047','snehal.valanju@qtechsoftware.com');
[10/24/2020 11:56:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3047','nitin@qtechsoftware.com');
[10/24/2020 11:56:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/channel_manager_push_reservation.php],update bookings_details set reservation_pushed = '0', channel_manager = 'rategain',room_type_description='' where booking_id = '3047';
[10/24/2020 11:56:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/channel_manager_push_reservation.php],update bookings_details set reservation_pushed = '0', channel_manager = 'rategain',room_type_description='' where booking_id = '3047';
