[08/04/2020 12:18:35], [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 ('42@S000000022@2020-08-04@2020-08-04@@226@1@1@@@0','04-08-2020~04-08-2020','42','S000000022','2020-08-04','2020-08-04','226','1','45.120.147.56','0','0','6d7cc20b664117a9eaaffe888f9e241b','Sa,Su','1','Supplier','59','A','300','300','USD','0','0','0','0','','','0','6d7cc20b664117a9eaaffe888f9e241b','2020-08-04 12:18:35','2020-08-04','Supplier','','','','','0','');
[08/04/2020 12:18:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],DELETE  FROM room_rates WHERE id IN ('');
[08/04/2020 12:18:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-08-04 12:18:35',`log_type`= 'Rates',`sql_query`= '',`log_description`= 'Inserted Rates For Aarau-West Swiss Quality Hotel Rate:- 300 Room Category :- Arica - Double (Bed & Breakfast) Market :- All Market From:- 04-08-2020 To:- 05-08-2020',`ip`= '45.120.147.56',`username`= 'tfg',`user_id`= 'S000000022';
[08/04/2020 12:18:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3486', `entity`='Hotels', `value`='42' ;
[08/04/2020 12:18:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3486', `entity`='Suppliers', `value`='S000000022' ;
[08/04/2020 12:18:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3486', `entity`='Inventory', `value`='59' ;
[08/04/2020 12:18:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3486', `entity`='Room', `value`='226' ;
[08/04/2020 12:18:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3486', `entity`='Market', `value`='1' ;
[08/04/2020 12:18:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-08-04 12:18:35',`log_type`= 'Rates',`sql_query`= '',`log_description`= 'Inserted Rates For Aarau-West Swiss Quality Hotel Rate:- 200 Room Category :- Arica - Single (Bed & Breakfast) Market :- All Market From:- 04-08-2020 To:- 05-08-2020',`ip`= '45.120.147.56',`username`= 'tfg',`user_id`= 'S000000022';
[08/04/2020 12:18:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3487', `entity`='Hotels', `value`='42' ;
[08/04/2020 12:18:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3487', `entity`='Suppliers', `value`='S000000022' ;
[08/04/2020 12:18:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3487', `entity`='Inventory', `value`='59' ;
[08/04/2020 12:18:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3487', `entity`='Room', `value`='225' ;
[08/04/2020 12:18:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3487', `entity`='Market', `value`='1' ;
[08/04/2020 12:18:35], [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 ('42@S000000022@2020-08-05@2020-08-05@@226@1@1@@@0','05-08-2020~05-08-2020','42','S000000022','2020-08-05','2020-08-05','226','1','45.120.147.56','0','0','ec90dd4bad794489873816cc3176e4bb','Sa,Su','1','Supplier','59','A','300','300','USD','0','0','0','0','','','0','ec90dd4bad794489873816cc3176e4bb','2020-08-04 12:18:35','2020-08-04','Supplier','','','','','0',''),('42@S000000022@2020-08-04@2020-08-04@@225@1@1@@@0','04-08-2020~04-08-2020','42','S000000022','2020-08-04','2020-08-04','225','1','45.120.147.56','0','0','01b8dbec6762c03579cd990cdcac6ca7','Sa,Su','1','Supplier','59','A','200','200','USD','0','0','0','0','','','0','01b8dbec6762c03579cd990cdcac6ca7','2020-08-04 12:18:35','2020-08-04','Supplier','','','','','0',''),('42@S000000022@2020-08-05@2020-08-05@@225@1@1@@@0','05-08-2020~05-08-2020','42','S000000022','2020-08-05','2020-08-05','225','1','45.120.147.56','0','0','73b7c99cfea69fd5a93d749fa251f364','Sa,Su','1','Supplier','59','A','200','200','USD','0','0','0','0','','','0','73b7c99cfea69fd5a93d749fa251f364','2020-08-04 12:18:35','2020-08-04','Supplier','','','','','0','');
[08/04/2020 12:18:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],DELETE  FROM room_rates WHERE id IN ('');
[08/04/2020 12:36:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],update hotels SET weekend='6,7' ,infant_lower_limit='0' ,infant_upper_limit='2' ,tiny_child_lower_limit='3' ,tiny_child_upper_limit='6' ,child_lower_limit='7' ,child_upper_limit='11' ,teen_child_lower_limit='12' ,teen_child_upper_limit='16',booking_closing_time=null,timezone=null where id='42';
[08/04/2020 12:36:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-08-04 12:36:13',`log_type`= 'Hotel',`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;6\&#039; ,child_lower_limit=\&#039;7\&#039; ,child_upper_limit=\&#039;11\&#039; ,teen_child_lower_limit=\&#039;12\&#039; ,teen_child_upper_limit=\&#039;16\&#039;,booking_closing_time=null,timezone=null where id=\&#039;42\&#039;',`log_description`= ' Hotel Setting of Aarau-West Swiss Quality Hotel Updated By Coco Tangalla',`ip`= '45.120.147.56',`username`= 'tfg',`user_id`= 'S000000022';
[08/04/2020 12:36:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3488', `entity`='Hotels', `value`='42' ;
[08/04/2020 12:36:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3488', `entity`='Suppliers', `value`='S000000022' ;
[08/04/2020 12:36:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],update hotels SET weekend='6,7' ,infant_lower_limit='0' ,infant_upper_limit='2' ,tiny_child_lower_limit='3' ,tiny_child_upper_limit='6' ,child_lower_limit='7' ,child_upper_limit='11' ,teen_child_lower_limit='12' ,teen_child_upper_limit='16' ,booking_closing_time='14:30',timezone='5' where id='42';
[08/04/2020 12:36:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-08-04 12:36:37',`log_type`= 'Hotel',`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;6\&#039; ,child_lower_limit=\&#039;7\&#039; ,child_upper_limit=\&#039;11\&#039; ,teen_child_lower_limit=\&#039;12\&#039; ,teen_child_upper_limit=\&#039;16\&#039; ,booking_closing_time=\&#039;14:30\&#039;,timezone=\&#039;5\&#039; where id=\&#039;42\&#039;',`log_description`= ' Hotel Setting of Aarau-West Swiss Quality Hotel Updated By Coco Tangalla',`ip`= '45.120.147.56',`username`= 'tfg',`user_id`= 'S000000022';
[08/04/2020 12:36:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3489', `entity`='Hotels', `value`='42' ;
[08/04/2020 12:36:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3489', `entity`='Suppliers', `value`='S000000022' ;
[08/04/2020 12:37:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-04',to_date='2020-08-04',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-05',to_date='2020-08-05',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-06',to_date='2020-08-06',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-07',to_date='2020-08-07',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-08',to_date='2020-08-08',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-09',to_date='2020-08-09',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-10',to_date='2020-08-10',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-11',to_date='2020-08-11',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-12',to_date='2020-08-12',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-13',to_date='2020-08-13',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-14',to_date='2020-08-14',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-15',to_date='2020-08-15',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-16',to_date='2020-08-16',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-17',to_date='2020-08-17',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-18',to_date='2020-08-18',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-19',to_date='2020-08-19',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-20',to_date='2020-08-20',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-21',to_date='2020-08-21',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-22',to_date='2020-08-22',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-23',to_date='2020-08-23',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-24',to_date='2020-08-24',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-25',to_date='2020-08-25',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-26',to_date='2020-08-26',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-27',to_date='2020-08-27',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-28',to_date='2020-08-28',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-29',to_date='2020-08-29',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-30',to_date='2020-08-30',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-31',to_date='2020-08-31',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-09-01',to_date='2020-09-01',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-09-02',to_date='2020-09-02',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-09-03',to_date='2020-09-03',supplier_id='S000000022',hotel_id='42',room_basis_id='1',room_class_id='220',child_no='',infant_wtc_rate='20',infant_wtc_weekend_rate='20',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='20',child_wtb_weekend_rate='20',child_display= 'yes',teen_child_wtb_rate='20',teen_child_wtb_weekend_rate='20',teen_display= 'yes',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[08/04/2020 12:37:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-08-04 12:37:05',`log_type`= 'ExtraBed Rates',`sql_query`= '',`log_description`= 'Extrabed Rates For Aarau-West Swiss Quality Hotel added successfully for Room Category :- King Coco - Double, Extrabed - 1(Bed & Breakfast) From :- 04-08-2020 To :- 03-09-2020',`ip`= '103.104.226.130',`username`= 'tfg',`user_id`= 'S000000022';
[08/04/2020 12:37:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3490', `entity`='Hotels', `value`='42' ;
[08/04/2020 12:37:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3490', `entity`='Suppliers', `value`='S000000022' ;
[08/04/2020 12:37:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3490', `entity`='Inventory', `value`='56' ;
[08/04/2020 12:37:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3490', `entity`='Room', `value`='220' ;
[08/04/2020 12:50:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO applicable_offer_rates SET offer_type_code= 'EBD',is_compulsory= 'yes',nationality= '106',rate_profile= '',room_type= '59,56',room_basis= '1,2',offer_room_class= '',hotel_id= '42',country_id= '92',city_id= '61478',star_rating='',display_oid= 'EBD3006',is_min_offer= '',is_max_offer= '',min_stay= '0',max_stay= '0',sf_date='2020-08-04',st_date='2020-08-04',bf_date='2020-08-03',bt_date='2020-08-03',create_date = '2020-08-04 12:50:51',supplier_id= 'S000000022',supplier_type= 'Offline',is_refundable_offer= 'yes',offer_note= '',agent_id= '7,4',offer_apply_on= 'total_rate',offer_options= 'all',ratetype_per_night= 'Amount',currency= 'USD',ratevalue_per_night= '10',offer_only_for= 'all';
[08/04/2020 12:50:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],UPDATE applicable_offer_rates SET oid='0022-11567' WHERE aoid='11567' AND STATUS <> 'D';
[08/04/2020 12:50:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-08-04 12:50:51',`log_type`= 'Manage Offer/Discount',`sql_query`= 'INSERT INTO applicable_offer_rates SET offer_type_code= \&#039;EBD\&#039;,is_compulsory= \&#039;yes\&#039;,nationality= \&#039;106\&#039;,rate_profile= \&#039;\&#039;,room_type= \&#039;59,56\&#039;,room_basis= \&#039;1,2\&#039;,offer_room_class= \&#039;\&#039;,hotel_id= \&#039;42\&#039;,country_id= \&#039;92\&#039;,city_id= \&#039;61478\&#039;,star_rating=\&#039;\&#039;,display_oid= \&#039;EBD3006\&#039;,is_min_offer= \&#039;\&#039;,is_max_offer= \&#039;\&#039;,min_stay= \&#039;0\&#039;,max_stay= \&#039;0\&#039;,sf_date=\&#039;2020-08-04\&#039;,st_date=\&#039;2020-08-04\&#039;,bf_date=\&#039;2020-08-03\&#039;,bt_date=\&#039;2020-08-03\&#039;,create_date = \&#039;2020-08-04 12:50:51\&#039;,supplier_id= \&#039;S000000022\&#039;,supplier_type= \&#039;Offline\&#039;,is_refundable_offer= \&#039;yes\&#039;,offer_note= \&#039;\&#039;,agent_id= \&#039;7,4\&#039;,offer_apply_on= \&#039;total_rate\&#039;,offer_options= \&#039;all\&#039;,ratetype_per_night= \&#039;Amount\&#039;,currency= \&#039;USD\&#039;,ratevalue_per_night= \&#039;10\&#039;,offer_only_for= \&#039;all\&#039;',`log_description`= 'New Offer -Early Bird 0022-11567 Added By Supplier ',`ip`= '45.120.147.56',`username`= 'tfg',`user_id`= 'S000000022';
[08/04/2020 12:50:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3491', `entity`='Suppliers', `value`='S000000022' ;
[08/04/2020 12:50:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3491', `entity`='Hotels', `value`='42' ;
[08/04/2020 12:54:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO applicable_offer_rates SET offer_type_code= 'EBD',is_compulsory= 'yes',nationality= '106',rate_profile= '',room_type= '59,56',room_basis= '1,2',offer_room_class= '',hotel_id= '42',country_id= '92',city_id= '61478',star_rating='',display_oid= 'EBD3006',is_min_offer= '',is_max_offer= '',min_stay= '0',max_stay= '0',sf_date='2020-08-26',st_date='2020-08-26',bf_date='2020-08-03',bt_date='2020-08-03',create_date = '2020-08-04 12:54:40',supplier_id= 'S000000022',supplier_type= 'Offline',is_refundable_offer= 'yes',offer_note= '',agent_id= '7,4',offer_apply_on= 'total_rate',offer_options= 'all',ratetype_per_night= 'Amount',currency= 'USD',ratevalue_per_night= '10',offer_only_for= 'all';
[08/04/2020 12:54:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],UPDATE applicable_offer_rates SET oid='0022-11568' WHERE aoid='11568' AND STATUS <> 'D';
[08/04/2020 12:54:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-08-04 12:54:40',`log_type`= 'Manage Offer/Discount',`sql_query`= 'INSERT INTO applicable_offer_rates SET offer_type_code= \&#039;EBD\&#039;,is_compulsory= \&#039;yes\&#039;,nationality= \&#039;106\&#039;,rate_profile= \&#039;\&#039;,room_type= \&#039;59,56\&#039;,room_basis= \&#039;1,2\&#039;,offer_room_class= \&#039;\&#039;,hotel_id= \&#039;42\&#039;,country_id= \&#039;92\&#039;,city_id= \&#039;61478\&#039;,star_rating=\&#039;\&#039;,display_oid= \&#039;EBD3006\&#039;,is_min_offer= \&#039;\&#039;,is_max_offer= \&#039;\&#039;,min_stay= \&#039;0\&#039;,max_stay= \&#039;0\&#039;,sf_date=\&#039;2020-08-26\&#039;,st_date=\&#039;2020-08-26\&#039;,bf_date=\&#039;2020-08-03\&#039;,bt_date=\&#039;2020-08-03\&#039;,create_date = \&#039;2020-08-04 12:54:40\&#039;,supplier_id= \&#039;S000000022\&#039;,supplier_type= \&#039;Offline\&#039;,is_refundable_offer= \&#039;yes\&#039;,offer_note= \&#039;\&#039;,agent_id= \&#039;7,4\&#039;,offer_apply_on= \&#039;total_rate\&#039;,offer_options= \&#039;all\&#039;,ratetype_per_night= \&#039;Amount\&#039;,currency= \&#039;USD\&#039;,ratevalue_per_night= \&#039;10\&#039;,offer_only_for= \&#039;all\&#039;',`log_description`= 'New Offer -Early Bird 0022-11568 Added By Supplier ',`ip`= '45.120.147.56',`username`= 'tfg',`user_id`= 'S000000022';
[08/04/2020 12:54:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3492', `entity`='Suppliers', `value`='S000000022' ;
[08/04/2020 12:54:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3492', `entity`='Hotels', `value`='42' ;
[08/04/2020 12:57:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],update room_rates set  availability='30' where supplier_id='S000000022' AND hotel_id='42' AND inventory_class_id='59'  AND date_from >='2020-08-04' AND date_from <='2020-09-03' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),'Sa,Su')='0';
[08/04/2020 12:57:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],update room_rates set  availability='36' where supplier_id='S000000022' AND hotel_id='42' AND inventory_class_id='59'  AND date_from >='2020-08-04' AND date_from <='2020-09-03' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),'Sa,Su')>'0';
[08/04/2020 12:57:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-08-04 12:57:07',`log_type`= 'Inventory Allocation',`sql_query`= 'update room_rates set  availability=\&#039;30\&#039; where supplier_id=\&#039;S000000022\&#039; AND hotel_id=\&#039;42\&#039; AND inventory_class_id=\&#039;59\&#039;  AND date_from &gt;=\&#039;2020-08-04\&#039; AND date_from &lt;=\&#039;2020-09-03\&#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;36\&#039; where supplier_id=\&#039;S000000022\&#039; AND hotel_id=\&#039;42\&#039; AND inventory_class_id=\&#039;59\&#039;  AND date_from &gt;=\&#039;2020-08-04\&#039; AND date_from &lt;=\&#039;2020-09-03\&#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 Aarau-West Swiss Quality Hotel- Inventory:-Arica From:-04-08-2020 To:-03-09-2020 Weekday Inventory Allocation:-30 Weekend Inventory Allocation:-36',`ip`= '103.104.226.130',`username`= 'tfg',`user_id`= 'S000000022';
[08/04/2020 12:57:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3493', `entity`='Hotels', `value`='42' ;
[08/04/2020 12:57:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3493', `entity`='Suppliers', `value`='S000000022' ;
[08/04/2020 12:57:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3493', `entity`='Inventory', `value`='59' ;
[08/04/2020 12:57:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],update room_rates set stop_sale='1' where supplier_id='S000000022' and hotel_id=42  and inventory_class_id in ('59') and date_from >='2020-08-04' AND date_from <='2020-08-04' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),'Sa,Su')='0' ;
[08/04/2020 12:57:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],update room_rates set stop_sale='0' where supplier_id='S000000022' and hotel_id=42  and inventory_class_id in ('59') and date_from >='2020-08-04' AND date_from <='2020-08-04' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),'Sa,Su')>'0' ;
[08/04/2020 12:57:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-08-04 12:57:59',`log_type`= 'Sell Policy',`sql_query`= 'update room_rates set stop_sale=\&#039;1\&#039; where supplier_id=\&#039;S000000022\&#039; and hotel_id=42  and inventory_class_id in (\&#039;59\&#039;) and date_from &gt;=\&#039;2020-08-04\&#039; AND date_from &lt;=\&#039;2020-08-04\&#039; AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),\&#039;Sa,Su\&#039;)=\&#039;0\&#039; &lt;br&gt;update room_rates set stop_sale=\&#039;0\&#039; where supplier_id=\&#039;S000000022\&#039; and hotel_id=42  and inventory_class_id in (\&#039;59\&#039;) and date_from &gt;=\&#039;2020-08-04\&#039; AND date_from &lt;=\&#039;2020-08-04\&#039; AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),\&#039;Sa,Su\&#039;)&gt;\&#039;0\&#039; ',`log_description`= 'Updated Sell Policy For hotel Aarau-West Swiss Quality Hotel- Inventory Room Class:-Arica From:-04-08-2020 To:-04-08-2020 Weekday Policy:-Full Stop Sell Weekend Policy:-Withdraw Stop/Free Sell',`ip`= '45.120.147.56',`username`= 'tfg',`user_id`= 'S000000022';
[08/04/2020 12:57:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3494', `entity`='Hotels', `value`='42' ;
[08/04/2020 12:57:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3494', `entity`='Suppliers', `value`='S000000022' ;
[08/04/2020 12:57:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3494', `entity`='Inventory', `value`='' ;
[08/04/2020 12:57:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3494', `entity`='Roomclass', `value`='' ;
