[11/07/2020 09:41:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],UPDATE hotel_supplier_mapping SET channel_manager = 'rategain',ip_addr='103.232.9.182' WHERE SupplierId = 'S000000230' AND hotel_id = '51817' AND status = 'A';
[11/07/2020 09:41:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-11-07 09:41:14',`log_type`= 'Channel Manager updated',`sql_query`= 'UPDATE hotel_supplier_mapping SET channel_manager = \&#039;rategain\&#039;,ip_addr=\&#039;103.232.9.182\&#039; WHERE SupplierId = \&#039;S000000230\&#039; AND hotel_id = \&#039;51817\&#039; AND status = \&#039;A\&#039;',`log_description`= 'Channel Manager updated by User tfg',`ip`= '103.232.9.182';
[11/07/2020 09:41:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-11-07 09:41:14',`log_type`= 'Channel Manager updated',`sql_query`= 'UPDATE hotel_supplier_mapping SET channel_manager = \&#039;rategain\&#039;,ip_addr=\&#039;103.232.9.182\&#039; WHERE SupplierId = \&#039;S000000230\&#039; AND hotel_id = \&#039;51817\&#039; AND status = \&#039;A\&#039;',`log_description`= 'Channel Manager updated by User tfg',`ip`= '103.232.9.182';
[11/07/2020 09:41:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='3884', `entity`='Hotels', `value`='51817' ;
[11/07/2020 09:41:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='3884', `entity`='Suppliers', `value`='S000000230' ;
[11/07/2020 09:41:14], [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='2',tiny_child_lower_limit='3',tiny_child_upper_limit='7',child_lower_limit='8',child_upper_limit='10',teen_child_lower_limit='11',teen_child_upper_limit='12',booking_closing_time='',timezone='5.5' where id= '51817';
[11/07/2020 09:41:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-11-07 09:41:14',`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;2\&#039;,tiny_child_lower_limit=\&#039;3\&#039;,tiny_child_upper_limit=\&#039;7\&#039;,child_lower_limit=\&#039;8\&#039;,child_upper_limit=\&#039;10\&#039;,teen_child_lower_limit=\&#039;11\&#039;,teen_child_upper_limit=\&#039;12\&#039;,booking_closing_time=\&#039;\&#039;,timezone=\&#039;5.5\&#039; where id= \&#039;51817\&#039;',`log_description`= 'Hotel Details updated by User tfg',`ip`= '103.232.9.182';
[11/07/2020 09:41:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-11-07 09:41:14',`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;2\&#039;,tiny_child_lower_limit=\&#039;3\&#039;,tiny_child_upper_limit=\&#039;7\&#039;,child_lower_limit=\&#039;8\&#039;,child_upper_limit=\&#039;10\&#039;,teen_child_lower_limit=\&#039;11\&#039;,teen_child_upper_limit=\&#039;12\&#039;,booking_closing_time=\&#039;\&#039;,timezone=\&#039;5.5\&#039; where id= \&#039;51817\&#039;',`log_description`= 'Hotel Details updated by User tfg',`ip`= '103.232.9.182';
[11/07/2020 09:41:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='3886', `entity`='Hotels', `value`='51817' ;
[11/07/2020 09:41:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='3886', `entity`='Suppliers', `value`='S000000230' ;
[11/07/2020 09:48:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-11-07 09:48:12',`log_type`= 'Excel Update',`sql_query`= 'File Path=alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/csv_roomrates/bf7c07b88e0f3765429f364cedee798b.xls',`log_description`= 'Update Content for Hotel:- Baan Boran(51817) and Supplier:-Baan Boran(S000000230) From Excel',`ip`= '103.232.9.182';
[11/07/2020 09:48:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],insert into user_log_link Set `user_logs_id`='3887', `entity`='Hotels', `value`='51817' ;
[11/07/2020 09:48:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],insert into user_log_link Set `user_logs_id`='3887', `entity`='Suppliers', `value`='S000000230' ;
[11/07/2020 09:48:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],UPDATE inventory_room_class SET inventory_room_class='Junior Suite' WHERE id='28';
[11/07/2020 09:48:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO room_class SET room_class='Single' ,min_adult='1' ,max_adult='1' ,max_capacity='1' ,supplier_id='S000000230' ,inventory_class_id='28' ,is_adult_extrabed='no' ,is_child_extrabed='no' ,deny_both_extrabed='0',non_refundable='0';
[11/07/2020 09:48:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO room_class SET room_class='Single' ,min_adult='1' ,max_adult='1' ,max_capacity='1' ,supplier_id='S000000230' ,inventory_class_id='28' ,is_adult_extrabed='no' ,is_child_extrabed='no' ,deny_both_extrabed='0',non_refundable='1';
[11/07/2020 09:48:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],Insert into hotel_room_class_mapping SET class_id='1050' , hotel_id='51817' , supplier_id='S000000230';
[11/07/2020 09:48:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],Insert into hotel_room_class_mapping SET class_id='1051' , hotel_id='51817' , supplier_id='S000000230';
[11/07/2020 09:48:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.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,stop_sale,time_stamp,created_datetime,create_date,created_by,changed_by,modify_date,modified_datetime,modified_by,consumed_inventory) values ('51817@S000000230@2021-11-07@2021-11-07@@1050@4@1@@@0','07-11-2021~07-11-2021','51817','S000000230','2021-11-07','2021-11-07','1050','4','103.232.9.182','0','0','a7b9f40a235ba81437cbfad595ec705d','Sa,Su','1','tfg','28','A','1000','1000','USD','0','0','0','0','','0','a7b9f40a235ba81437cbfad595ec705d','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0'),('51817@S000000230@2021-11-08@2021-11-08@@1050@4@1@@@0','08-11-2021~08-11-2021','51817','S000000230','2021-11-08','2021-11-08','1050','4','103.232.9.182','0','0','f29476b509b0d0c7797df4731f190aaa','Sa,Su','1','tfg','28','A','1000','1000','USD','0','0','0','0','','0','f29476b509b0d0c7797df4731f190aaa','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0'),('51817@S000000230@2021-11-09@2021-11-09@@1050@4@1@@@0','09-11-2021~09-11-2021','51817','S000000230','2021-11-09','2021-11-09','1050','4','103.232.9.182','0','0','fb67b9c9138e6f23479ebe4ac3789fa4','Sa,Su','1','tfg','28','A','1000','1000','USD','0','0','0','0','','0','fb67b9c9138e6f23479ebe4ac3789fa4','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0'),('51817@S000000230@2021-11-10@2021-11-10@@1050@4@1@@@0','10-11-2021~10-11-2021','51817','S000000230','2021-11-10','2021-11-10','1050','4','103.232.9.182','0','0','f4a59f2547a42a4647caebea1d836f29','Sa,Su','1','tfg','28','A','1000','1000','USD','0','0','0','0','','0','f4a59f2547a42a4647caebea1d836f29','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0'),('51817@S000000230@2021-11-11@2021-11-11@@1050@4@1@@@0','11-11-2021~11-11-2021','51817','S000000230','2021-11-11','2021-11-11','1050','4','103.232.9.182','0','0','9e442b14985454eb9767defb5e717591','Sa,Su','1','tfg','28','A','1000','1000','USD','0','0','0','0','','0','9e442b14985454eb9767defb5e717591','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0'),('51817@S000000230@2021-11-12@2021-11-12@@1050@4@1@@@0','12-11-2021~12-11-2021','51817','S000000230','2021-11-12','2021-11-12','1050','4','103.232.9.182','0','0','766f133a769daa75ec3d23c264906f65','Sa,Su','1','tfg','28','A','1000','1000','USD','0','0','0','0','','0','766f133a769daa75ec3d23c264906f65','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0'),('51817@S000000230@2021-11-13@2021-11-13@@1050@4@1@@@0','13-11-2021~13-11-2021','51817','S000000230','2021-11-13','2021-11-13','1050','4','103.232.9.182','0','0','249580fd2fb5830d451328cb60f07cd4','Sa,Su','1','tfg','28','A','1000','1000','USD','0','0','0','0','','0','249580fd2fb5830d451328cb60f07cd4','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0'),('51817@S000000230@2021-11-14@2021-11-14@@1050@4@1@@@0','14-11-2021~14-11-2021','51817','S000000230','2021-11-14','2021-11-14','1050','4','103.232.9.182','0','0','9881b02aa2b8feecad12b1d0ea361c7c','Sa,Su','1','tfg','28','A','1000','1000','USD','0','0','0','0','','0','9881b02aa2b8feecad12b1d0ea361c7c','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0'),('51817@S000000230@2021-11-15@2021-11-15@@1050@4@1@@@0','15-11-2021~15-11-2021','51817','S000000230','2021-11-15','2021-11-15','1050','4','103.232.9.182','0','0','71da94d440fc2ca7dced744ff0815f5f','Sa,Su','1','tfg','28','A','1000','1000','USD','0','0','0','0','','0','71da94d440fc2ca7dced744ff0815f5f','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0'),('51817@S000000230@2021-11-16@2021-11-16@@1050@4@1@@@0','16-11-2021~16-11-2021','51817','S000000230','2021-11-16','2021-11-16','1050','4','103.232.9.182','0','0','c3979b13fc516185b4a5686c8e826fa4','Sa,Su','1','tfg','28','A','1000','1000','USD','0','0','0','0','','0','c3979b13fc516185b4a5686c8e826fa4','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0'),('51817@S000000230@2021-11-17@2021-11-17@@1050@4@1@@@0','17-11-2021~17-11-2021','51817','S000000230','2021-11-17','2021-11-17','1050','4','103.232.9.182','0','0','5edba50a2a0e374e9abedc7598613a5c','Sa,Su','1','tfg','28','A','1000','1000','USD','0','0','0','0','','0','5edba50a2a0e374e9abedc7598613a5c','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0'),('51817@S000000230@2021-11-18@2021-11-18@@1050@4@1@@@0','18-11-2021~18-11-2021','51817','S000000230','2021-11-18','2021-11-18','1050','4','103.232.9.182','0','0','21e59f7b16584f176919a7d3e00e9f97','Sa,Su','1','tfg','28','A','1000','1000','USD','0','0','0','0','','0','21e59f7b16584f176919a7d3e00e9f97','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0'),('51817@S000000230@2021-11-19@2021-11-19@@1050@4@1@@@0','19-11-2021~19-11-2021','51817','S000000230','2021-11-19','2021-11-19','1050','4','103.232.9.182','0','0','bb0011196b743db49b5d15f2e2271485','Sa,Su','1','tfg','28','A','1000','1000','USD','0','0','0','0','','0','bb0011196b743db49b5d15f2e2271485','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0'),('51817@S000000230@2021-11-20@2021-11-20@@1050@4@1@@@0','20-11-2021~20-11-2021','51817','S000000230','2021-11-20','2021-11-20','1050','4','103.232.9.182','0','0','d0e33ce151a1274ac6dc173fdad0f137','Sa,Su','1','tfg','28','A','1000','1000','USD','0','0','0','0','','0','d0e33ce151a1274ac6dc173fdad0f137','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0'),('51817@S000000230@2021-11-07@2021-11-07@@1050@4@1@@@0','07-11-2021~07-11-2021','51817','S000000230','2021-11-07','2021-11-07','1050','4','103.232.9.182','0','0','678007d4703efe5b6b5d2392f1a9f822','Sa,Su','1','tfg','28','A','2000','2000','USD','0','0','0','0','','0','678007d4703efe5b6b5d2392f1a9f822','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0'),('51817@S000000230@2021-11-08@2021-11-08@@1050@4@1@@@0','08-11-2021~08-11-2021','51817','S000000230','2021-11-08','2021-11-08','1050','4','103.232.9.182','0','0','93464c4131b7bc8b10a4adcbc4daf6db','Sa,Su','1','tfg','28','A','2000','2000','USD','0','0','0','0','','0','93464c4131b7bc8b10a4adcbc4daf6db','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0'),('51817@S000000230@2021-11-09@2021-11-09@@1050@4@1@@@0','09-11-2021~09-11-2021','51817','S000000230','2021-11-09','2021-11-09','1050','4','103.232.9.182','0','0','6bbd581a16f58d043def6af6df6afb23','Sa,Su','1','tfg','28','A','2000','2000','USD','0','0','0','0','','0','6bbd581a16f58d043def6af6df6afb23','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0'),('51817@S000000230@2021-11-10@2021-11-10@@1050@4@1@@@0','10-11-2021~10-11-2021','51817','S000000230','2021-11-10','2021-11-10','1050','4','103.232.9.182','0','0','9f8a83ff426769622546fa24376ca7d5','Sa,Su','1','tfg','28','A','2000','2000','USD','0','0','0','0','','0','9f8a83ff426769622546fa24376ca7d5','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0'),('51817@S000000230@2021-11-11@2021-11-11@@1050@4@1@@@0','11-11-2021~11-11-2021','51817','S000000230','2021-11-11','2021-11-11','1050','4','103.232.9.182','0','0','7c5df528971eb7c29862c7ef3e84aa68','Sa,Su','1','tfg','28','A','2000','2000','USD','0','0','0','0','','0','7c5df528971eb7c29862c7ef3e84aa68','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0'),('51817@S000000230@2021-11-12@2021-11-12@@1050@4@1@@@0','12-11-2021~12-11-2021','51817','S000000230','2021-11-12','2021-11-12','1050','4','103.232.9.182','0','0','5ba88d73b7163f4b68dcda79f5df9aff','Sa,Su','1','tfg','28','A','2000','2000','USD','0','0','0','0','','0','5ba88d73b7163f4b68dcda79f5df9aff','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0'),('51817@S000000230@2021-11-13@2021-11-13@@1050@4@1@@@0','13-11-2021~13-11-2021','51817','S000000230','2021-11-13','2021-11-13','1050','4','103.232.9.182','0','0','7c7d2c873925521bcac1c3bf66e4dc0d','Sa,Su','1','tfg','28','A','2000','2000','USD','0','0','0','0','','0','7c7d2c873925521bcac1c3bf66e4dc0d','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0'),('51817@S000000230@2021-11-14@2021-11-14@@1050@4@1@@@0','14-11-2021~14-11-2021','51817','S000000230','2021-11-14','2021-11-14','1050','4','103.232.9.182','0','0','276af40fc2aae94160eeb48b302cf12c','Sa,Su','1','tfg','28','A','2000','2000','USD','0','0','0','0','','0','276af40fc2aae94160eeb48b302cf12c','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0'),('51817@S000000230@2021-11-15@2021-11-15@@1050@4@1@@@0','15-11-2021~15-11-2021','51817','S000000230','2021-11-15','2021-11-15','1050','4','103.232.9.182','0','0','e0a28994fee03c41e846ece5cbbda550','Sa,Su','1','tfg','28','A','2000','2000','USD','0','0','0','0','','0','e0a28994fee03c41e846ece5cbbda550','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0'),('51817@S000000230@2021-11-16@2021-11-16@@1050@4@1@@@0','16-11-2021~16-11-2021','51817','S000000230','2021-11-16','2021-11-16','1050','4','103.232.9.182','0','0','4ae65c567db7ac43428844df14501ecc','Sa,Su','1','tfg','28','A','2000','2000','USD','0','0','0','0','','0','4ae65c567db7ac43428844df14501ecc','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0'),('51817@S000000230@2021-11-17@2021-11-17@@1050@4@1@@@0','17-11-2021~17-11-2021','51817','S000000230','2021-11-17','2021-11-17','1050','4','103.232.9.182','0','0','ad630a54c6d8a898fcba7a7fbd5bfe97','Sa,Su','1','tfg','28','A','2000','2000','USD','0','0','0','0','','0','ad630a54c6d8a898fcba7a7fbd5bfe97','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0'),('51817@S000000230@2021-11-18@2021-11-18@@1050@4@1@@@0','18-11-2021~18-11-2021','51817','S000000230','2021-11-18','2021-11-18','1050','4','103.232.9.182','0','0','8d84825562ae1ac8dc410afa2a183b6d','Sa,Su','1','tfg','28','A','2000','2000','USD','0','0','0','0','','0','8d84825562ae1ac8dc410afa2a183b6d','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0'),('51817@S000000230@2021-11-19@2021-11-19@@1050@4@1@@@0','19-11-2021~19-11-2021','51817','S000000230','2021-11-19','2021-11-19','1050','4','103.232.9.182','0','0','a472ccc6b1d1fe1b992926ac20acb4b7','Sa,Su','1','tfg','28','A','2000','2000','USD','0','0','0','0','','0','a472ccc6b1d1fe1b992926ac20acb4b7','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0'),('51817@S000000230@2021-11-20@2021-11-20@@1050@4@1@@@0','20-11-2021~20-11-2021','51817','S000000230','2021-11-20','2021-11-20','1050','4','103.232.9.182','0','0','d1b61d34987721a3773a1df490b49588','Sa,Su','1','tfg','28','A','2000','2000','USD','0','0','0','0','','0','d1b61d34987721a3773a1df490b49588','2020-11-07 09:48:12','2020-11-07','admin#tfg#tfgEXCEL','','','','','0');
[11/07/2020 09:48:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],insert into supplements set supplement_name='Sup11' , status='A' , supplier_id='S000000230' , type='admin';
[11/07/2020 09:48:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO supplement_rate SET  hotel_id='51817', supplier_id='S000000230', supplement_id='110', class_id='1050', from_date='2021-11-07', to_date='2021-11-20', week_day_rate='', week_end_rate='', added_by='admin', supplement_per_pax='';
[11/07/2020 09:48:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO supplement_rate SET  hotel_id='51817', supplier_id='S000000230', supplement_id='110', class_id='1051', from_date='2021-11-07', to_date='2021-11-20', week_day_rate='', week_end_rate='', added_by='admin', supplement_per_pax='';
[11/07/2020 09:53:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.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-11-07 09:53:30', '', '', '');
