[12/02/2020 05:56:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-02' AND date_to= '2020-12-02' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:56:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2020-12-02',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_56_02_1606888562_53773.xml',create_date = '2020-12-02 05:56:02';
[12/02/2020 05:56:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-02 05:56:02',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',room_class_id= '1044',rate_id= '132',start_date= '2020-12-02';
[12/02/2020 05:56:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDIgMDU6NTY6MDI8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTAyPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-02 05:56:02';
[12/02/2020 05:56:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-02 05:56:02<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-02<br>',  email_sent ='yes', create_date ='2020-12-02 05:56:02', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/02/2020 05:56:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-02' AND date_to= '2020-12-02' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:56:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2020-12-02',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_56_07_1606888567_53773.xml',create_date = '2020-12-02 05:56:07';
[12/02/2020 05:56:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-03' AND date_to= '2020-12-03' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:56:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2020-12-03',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_56_07_1606888567_53773.xml',create_date = '2020-12-02 05:56:07';
[12/02/2020 05:56:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-04' AND date_to= '2020-12-04' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:56:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2020-12-04',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_56_07_1606888567_53773.xml',create_date = '2020-12-02 05:56:07';
[12/02/2020 05:56:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-05' AND date_to= '2020-12-05' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:56:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2020-12-05',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_56_07_1606888567_53773.xml',create_date = '2020-12-02 05:56:07';
[12/02/2020 05:56:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-06' AND date_to= '2020-12-06' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:56:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2020-12-06',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_56_07_1606888567_53773.xml',create_date = '2020-12-02 05:56:07';
[12/02/2020 05:56:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-07' AND date_to= '2020-12-07' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:56:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2020-12-07',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_56_07_1606888567_53773.xml',create_date = '2020-12-02 05:56:07';
[12/02/2020 05:56:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-08' AND date_to= '2020-12-08' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:56:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2020-12-08',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_56_07_1606888567_53773.xml',create_date = '2020-12-02 05:56:07';
[12/02/2020 05:56:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-02 05:56:07',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',room_class_id= '1044',rate_id= '132',start_date= '2020-12-02';
[12/02/2020 05:56:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDIgMDU6NTY6MDc8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTAyICwgMjAyMC0xMi0wMyAsIDIwMjAtMTItMDQgLCAyMDIwLTEyLTA1ICwgMjAyMC0xMi0wNiAsIDIwMjAtMTItMDcgLCAyMDIwLTEyLTA4PGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-02 05:56:07';
[12/02/2020 05:56:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-02 05:56:07<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-02 , 2020-12-03 , 2020-12-04 , 2020-12-05 , 2020-12-06 , 2020-12-07 , 2020-12-08<br>',  email_sent ='yes', create_date ='2020-12-02 05:56:07', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/02/2020 05:56:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-31' AND date_to= '2020-12-31' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:56:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2020-12-31',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_56_12_1606888572_53773.xml',create_date = '2020-12-02 05:56:12';
[12/02/2020 05:56:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-31' AND date_to= '2021-01-31' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:56:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-01-31',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_56_12_1606888572_53773.xml',create_date = '2020-12-02 05:56:12';
[12/02/2020 05:56:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-28' AND date_to= '2021-02-28' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:56:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-28',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_56_12_1606888572_53773.xml',create_date = '2020-12-02 05:56:12';
[12/02/2020 05:56:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-03-31' AND date_to= '2021-03-31' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:56:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-03-31',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_56_12_1606888572_53773.xml',create_date = '2020-12-02 05:56:12';
[12/02/2020 05:56:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-04-30' AND date_to= '2021-04-30' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:56:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-04-30',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_56_12_1606888572_53773.xml',create_date = '2020-12-02 05:56:12';
[12/02/2020 05:56:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-05-31' AND date_to= '2021-05-31' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:56:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-05-31',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_56_12_1606888572_53773.xml',create_date = '2020-12-02 05:56:12';
[12/02/2020 05:56:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-06-30' AND date_to= '2021-06-30' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:56:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-06-30',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_56_12_1606888572_53773.xml',create_date = '2020-12-02 05:56:12';
[12/02/2020 05:56:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-07-31' AND date_to= '2021-07-31' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:56:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-07-31',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_56_12_1606888572_53773.xml',create_date = '2020-12-02 05:56:12';
[12/02/2020 05:56:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-08-31' AND date_to= '2021-08-31' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:56:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-08-31',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_56_12_1606888572_53773.xml',create_date = '2020-12-02 05:56:12';
[12/02/2020 05:56:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-09-30' AND date_to= '2021-09-30' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:56:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-09-30',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_56_12_1606888572_53773.xml',create_date = '2020-12-02 05:56:12';
[12/02/2020 05:56:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-10-31' AND date_to= '2021-10-31' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:56:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-10-31',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_56_12_1606888572_53773.xml',create_date = '2020-12-02 05:56:12';
[12/02/2020 05:56:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-11-30' AND date_to= '2021-11-30' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:56:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-11-30',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_56_12_1606888572_53773.xml',create_date = '2020-12-02 05:56:13';
[12/02/2020 05:56:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-12-31' AND date_to= '2021-12-31' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:56:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-12-31',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_56_12_1606888572_53773.xml',create_date = '2020-12-02 05:56:13';
[12/02/2020 05:56:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-02 05:56:12',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',room_class_id= '1044',rate_id= '132',start_date= '2021-12-31';
[12/02/2020 05:56:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDIgMDU6NTY6MTI8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTMxICwgMjAyMS0wMS0zMSAsIDIwMjEtMDItMjggLCAyMDIxLTAzLTMxICwgMjAyMS0wNC0zMCAsIDIwMjEtMDUtMzEgLCAyMDIxLTA2LTMwICwgMjAyMS0wNy0zMSAsIDIwMjEtMDgtMzEgLCAyMDIxLTA5LTMwICwgMjAyMS0xMC0zMSAsIDIwMjEtMTEtMzAgLCAyMDIxLTEyLTMxPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-02 05:56:13';
[12/02/2020 05:56:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-02 05:56:12<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-31 , 2021-01-31 , 2021-02-28 , 2021-03-31 , 2021-04-30 , 2021-05-31 , 2021-06-30 , 2021-07-31 , 2021-08-31 , 2021-09-30 , 2021-10-31 , 2021-11-30 , 2021-12-31<br>',  email_sent ='yes', create_date ='2020-12-02 05:56:13', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/02/2020 05:57:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-02' AND date_to= '2020-12-02' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2020-12-02',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_00_1606888620_53773.xml',create_date = '2020-12-02 05:57:00';
[12/02/2020 05:57:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-04' AND date_to= '2020-12-04' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2020-12-04',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_00_1606888620_53773.xml',create_date = '2020-12-02 05:57:00';
[12/02/2020 05:57:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-06' AND date_to= '2020-12-06' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2020-12-06',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_00_1606888620_53773.xml',create_date = '2020-12-02 05:57:00';
[12/02/2020 05:57:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-08' AND date_to= '2020-12-08' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2020-12-08',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_00_1606888620_53773.xml',create_date = '2020-12-02 05:57:00';
[12/02/2020 05:57:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-10' AND date_to= '2020-12-10' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2020-12-10',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_00_1606888620_53773.xml',create_date = '2020-12-02 05:57:00';
[12/02/2020 05:57:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-12' AND date_to= '2020-12-12' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2020-12-12',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_00_1606888620_53773.xml',create_date = '2020-12-02 05:57:00';
[12/02/2020 05:57:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-14' AND date_to= '2020-12-14' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2020-12-14',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_00_1606888620_53773.xml',create_date = '2020-12-02 05:57:00';
[12/02/2020 05:57:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-16' AND date_to= '2020-12-16' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2020-12-16',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_00_1606888620_53773.xml',create_date = '2020-12-02 05:57:00';
[12/02/2020 05:57:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-02 05:57:00',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',room_class_id= '1044',rate_id= '132',start_date= '2020-12-16';
[12/02/2020 05:57:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDIgMDU6NTc6MDA8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTAyICwgMjAyMC0xMi0wNCAsIDIwMjAtMTItMDYgLCAyMDIwLTEyLTA4ICwgMjAyMC0xMi0xMCAsIDIwMjAtMTItMTIgLCAyMDIwLTEyLTE0ICwgMjAyMC0xMi0xNjxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-02 05:57:00';
[12/02/2020 05:57:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-02 05:57:00<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-02 , 2020-12-04 , 2020-12-06 , 2020-12-08 , 2020-12-10 , 2020-12-12 , 2020-12-14 , 2020-12-16<br>',  email_sent ='yes', create_date ='2020-12-02 05:57:00', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/02/2020 05:57:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-28' AND date_to= '2021-01-28' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-01-28',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:28';
[12/02/2020 05:57:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-29' AND date_to= '2021-01-29' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-01-29',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:28';
[12/02/2020 05:57:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-30' AND date_to= '2021-01-30' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-01-30',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:28';
[12/02/2020 05:57:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-31' AND date_to= '2021-01-31' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-01-31',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:28';
[12/02/2020 05:57:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-01' AND date_to= '2021-02-01' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-01',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:28';
[12/02/2020 05:57:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-02' AND date_to= '2021-02-02' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-02',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:28';
[12/02/2020 05:57:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-03' AND date_to= '2021-02-03' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-03',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:28';
[12/02/2020 05:57:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-04' AND date_to= '2021-02-04' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-04',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:28';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-05' AND date_to= '2021-02-05' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-05',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-06' AND date_to= '2021-02-06' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-06',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-07' AND date_to= '2021-02-07' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-07',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-08' AND date_to= '2021-02-08' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-08',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-09' AND date_to= '2021-02-09' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-09',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-10' AND date_to= '2021-02-10' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-10',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-11' AND date_to= '2021-02-11' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-11',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-12' AND date_to= '2021-02-12' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-12',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-13' AND date_to= '2021-02-13' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-13',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-14' AND date_to= '2021-02-14' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-14',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-15' AND date_to= '2021-02-15' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-15',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-16' AND date_to= '2021-02-16' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-16',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-17' AND date_to= '2021-02-17' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-17',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-18' AND date_to= '2021-02-18' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-18',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-19' AND date_to= '2021-02-19' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-19',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-20' AND date_to= '2021-02-20' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-20',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-21' AND date_to= '2021-02-21' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-21',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-22' AND date_to= '2021-02-22' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-22',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-23' AND date_to= '2021-02-23' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-23',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-24' AND date_to= '2021-02-24' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-24',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-25' AND date_to= '2021-02-25' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-25',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-26' AND date_to= '2021-02-26' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-26',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-27' AND date_to= '2021-02-27' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-27',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-28' AND date_to= '2021-02-28' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-28',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-03-01' AND date_to= '2021-03-01' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-03-01',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-03-02' AND date_to= '2021-03-02' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-03-02',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-03-03' AND date_to= '2021-03-03' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-03-03',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_28_1606888648_53773.xml',create_date = '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-02 05:57:28',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',room_class_id= '1044',rate_id= '132',start_date= '2021-01-28';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDIgMDU6NTc6Mjg8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIxLTAxLTI4ICwgMjAyMS0wMS0yOSAsIDIwMjEtMDEtMzAgLCAyMDIxLTAxLTMxICwgMjAyMS0wMi0wMSAsIDIwMjEtMDItMDIgLCAyMDIxLTAyLTAzICwgMjAyMS0wMi0wNCAsIDIwMjEtMDItMDUgLCAyMDIxLTAyLTA2ICwgMjAyMS0wMi0wNyAsIDIwMjEtMDItMDggLCAyMDIxLTAyLTA5ICwgMjAyMS0wMi0xMCAsIDIwMjEtMDItMTEgLCAyMDIxLTAyLTEyICwgMjAyMS0wMi0xMyAsIDIwMjEtMDItMTQgLCAyMDIxLTAyLTE1ICwgMjAyMS0wMi0xNiAsIDIwMjEtMDItMTcgLCAyMDIxLTAyLTE4ICwgMjAyMS0wMi0xOSAsIDIwMjEtMDItMjAgLCAyMDIxLTAyLTIxICwgMjAyMS0wMi0yMiAsIDIwMjEtMDItMjMgLCAyMDIxLTAyLTI0ICwgMjAyMS0wMi0yNSAsIDIwMjEtMDItMjYgLCAyMDIxLTAyLTI3ICwgMjAyMS0wMi0yOCAsIDIwMjEtMDMtMDEgLCAyMDIxLTAzLTAyICwgMjAyMS0wMy0wMzxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-02 05:57:29';
[12/02/2020 05:57:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-02 05:57:28<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2021-01-28 , 2021-01-29 , 2021-01-30 , 2021-01-31 , 2021-02-01 , 2021-02-02 , 2021-02-03 , 2021-02-04 , 2021-02-05 , 2021-02-06 , 2021-02-07 , 2021-02-08 , 2021-02-09 , 2021-02-10 , 2021-02-11 , 2021-02-12 , 2021-02-13 , 2021-02-14 , 2021-02-15 , 2021-02-16 , 2021-02-17 , 2021-02-18 , 2021-02-19 , 2021-02-20 , 2021-02-21 , 2021-02-22 , 2021-02-23 , 2021-02-24 , 2021-02-25 , 2021-02-26 , 2021-02-27 , 2021-02-28 , 2021-03-01 , 2021-03-02 , 2021-03-03<br>',  email_sent ='yes', create_date ='2020-12-02 05:57:29', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/02/2020 05:57:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-02' AND date_to= '2020-12-02' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:57:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2020-12-02',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_57_56_1606888676_53773.xml',create_date = '2020-12-02 05:57:57';
[12/02/2020 05:57:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-02 05:57:56',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',room_class_id= '1058',rate_id= '132',start_date= '2020-12-02';
[12/02/2020 05:57:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDIgMDU6NTc6NTY8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTAyPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-02 05:57:57';
[12/02/2020 05:57:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-02 05:57:56<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-02<br>',  email_sent ='yes', create_date ='2020-12-02 05:57:57', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/02/2020 05:58:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-02' AND date_to= '2020-12-02' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2020-12-02',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_01_1606888681_53773.xml',create_date = '2020-12-02 05:58:01';
[12/02/2020 05:58:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-03' AND date_to= '2020-12-03' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2020-12-03',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_01_1606888681_53773.xml',create_date = '2020-12-02 05:58:01';
[12/02/2020 05:58:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-04' AND date_to= '2020-12-04' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2020-12-04',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_01_1606888681_53773.xml',create_date = '2020-12-02 05:58:01';
[12/02/2020 05:58:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-05' AND date_to= '2020-12-05' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2020-12-05',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_01_1606888681_53773.xml',create_date = '2020-12-02 05:58:01';
[12/02/2020 05:58:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-06' AND date_to= '2020-12-06' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2020-12-06',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_01_1606888681_53773.xml',create_date = '2020-12-02 05:58:01';
[12/02/2020 05:58:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-07' AND date_to= '2020-12-07' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2020-12-07',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_01_1606888681_53773.xml',create_date = '2020-12-02 05:58:01';
[12/02/2020 05:58:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-08' AND date_to= '2020-12-08' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2020-12-08',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_01_1606888681_53773.xml',create_date = '2020-12-02 05:58:01';
[12/02/2020 05:58:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-02 05:58:01',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',room_class_id= '1058',rate_id= '132',start_date= '2020-12-02';
[12/02/2020 05:58:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDIgMDU6NTg6MDE8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTAyICwgMjAyMC0xMi0wMyAsIDIwMjAtMTItMDQgLCAyMDIwLTEyLTA1ICwgMjAyMC0xMi0wNiAsIDIwMjAtMTItMDcgLCAyMDIwLTEyLTA4PGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-02 05:58:01';
[12/02/2020 05:58:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-02 05:58:01<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-02 , 2020-12-03 , 2020-12-04 , 2020-12-05 , 2020-12-06 , 2020-12-07 , 2020-12-08<br>',  email_sent ='yes', create_date ='2020-12-02 05:58:01', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-28' AND date_to= '2021-01-28' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-01-28',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-29' AND date_to= '2021-01-29' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-01-29',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-30' AND date_to= '2021-01-30' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-01-30',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-31' AND date_to= '2021-01-31' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-01-31',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-01' AND date_to= '2021-02-01' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-01',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-02' AND date_to= '2021-02-02' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-02',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-03' AND date_to= '2021-02-03' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-03',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-04' AND date_to= '2021-02-04' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-04',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-05' AND date_to= '2021-02-05' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-05',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-06' AND date_to= '2021-02-06' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-06',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-07' AND date_to= '2021-02-07' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-07',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-08' AND date_to= '2021-02-08' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-08',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-09' AND date_to= '2021-02-09' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-09',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-10' AND date_to= '2021-02-10' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-10',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-11' AND date_to= '2021-02-11' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-11',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-12' AND date_to= '2021-02-12' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-12',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-13' AND date_to= '2021-02-13' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-13',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-14' AND date_to= '2021-02-14' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-14',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-15' AND date_to= '2021-02-15' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-15',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-16' AND date_to= '2021-02-16' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-16',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-17' AND date_to= '2021-02-17' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-17',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-18' AND date_to= '2021-02-18' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-18',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-19' AND date_to= '2021-02-19' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-19',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-20' AND date_to= '2021-02-20' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-20',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-21' AND date_to= '2021-02-21' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-21',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-22' AND date_to= '2021-02-22' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-22',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-23' AND date_to= '2021-02-23' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-23',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-24' AND date_to= '2021-02-24' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-24',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-25' AND date_to= '2021-02-25' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-25',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-26' AND date_to= '2021-02-26' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-26',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-27' AND date_to= '2021-02-27' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-27',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-28' AND date_to= '2021-02-28' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-28',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-03-01' AND date_to= '2021-03-01' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-03-01',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-03-02' AND date_to= '2021-03-02' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-03-02',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-03-03' AND date_to= '2021-03-03' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-03-03',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_06_1606888686_53773.xml',create_date = '2020-12-02 05:58:06';
[12/02/2020 05:58:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-02 05:58:06',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',room_class_id= '1058',rate_id= '132',start_date= '2021-01-28';
[12/02/2020 05:58:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDIgMDU6NTg6MDY8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIxLTAxLTI4ICwgMjAyMS0wMS0yOSAsIDIwMjEtMDEtMzAgLCAyMDIxLTAxLTMxICwgMjAyMS0wMi0wMSAsIDIwMjEtMDItMDIgLCAyMDIxLTAyLTAzICwgMjAyMS0wMi0wNCAsIDIwMjEtMDItMDUgLCAyMDIxLTAyLTA2ICwgMjAyMS0wMi0wNyAsIDIwMjEtMDItMDggLCAyMDIxLTAyLTA5ICwgMjAyMS0wMi0xMCAsIDIwMjEtMDItMTEgLCAyMDIxLTAyLTEyICwgMjAyMS0wMi0xMyAsIDIwMjEtMDItMTQgLCAyMDIxLTAyLTE1ICwgMjAyMS0wMi0xNiAsIDIwMjEtMDItMTcgLCAyMDIxLTAyLTE4ICwgMjAyMS0wMi0xOSAsIDIwMjEtMDItMjAgLCAyMDIxLTAyLTIxICwgMjAyMS0wMi0yMiAsIDIwMjEtMDItMjMgLCAyMDIxLTAyLTI0ICwgMjAyMS0wMi0yNSAsIDIwMjEtMDItMjYgLCAyMDIxLTAyLTI3ICwgMjAyMS0wMi0yOCAsIDIwMjEtMDMtMDEgLCAyMDIxLTAzLTAyICwgMjAyMS0wMy0wMzxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-02 05:58:07';
[12/02/2020 05:58:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-02 05:58:06<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2021-01-28 , 2021-01-29 , 2021-01-30 , 2021-01-31 , 2021-02-01 , 2021-02-02 , 2021-02-03 , 2021-02-04 , 2021-02-05 , 2021-02-06 , 2021-02-07 , 2021-02-08 , 2021-02-09 , 2021-02-10 , 2021-02-11 , 2021-02-12 , 2021-02-13 , 2021-02-14 , 2021-02-15 , 2021-02-16 , 2021-02-17 , 2021-02-18 , 2021-02-19 , 2021-02-20 , 2021-02-21 , 2021-02-22 , 2021-02-23 , 2021-02-24 , 2021-02-25 , 2021-02-26 , 2021-02-27 , 2021-02-28 , 2021-03-01 , 2021-03-02 , 2021-03-03<br>',  email_sent ='yes', create_date ='2020-12-02 05:58:07', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-31' AND date_to= '2020-12-31' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2020-12-31',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_15_1606888695_53773.xml',create_date = '2020-12-02 05:58:15';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-31' AND date_to= '2021-01-31' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-01-31',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_15_1606888695_53773.xml',create_date = '2020-12-02 05:58:15';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-28' AND date_to= '2021-02-28' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-02-28',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_15_1606888695_53773.xml',create_date = '2020-12-02 05:58:15';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-03-31' AND date_to= '2021-03-31' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-03-31',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_15_1606888695_53773.xml',create_date = '2020-12-02 05:58:15';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-04-30' AND date_to= '2021-04-30' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-04-30',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_15_1606888695_53773.xml',create_date = '2020-12-02 05:58:15';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-05-31' AND date_to= '2021-05-31' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-05-31',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_15_1606888695_53773.xml',create_date = '2020-12-02 05:58:15';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-06-30' AND date_to= '2021-06-30' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-06-30',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_15_1606888695_53773.xml',create_date = '2020-12-02 05:58:15';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-07-31' AND date_to= '2021-07-31' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-07-31',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_15_1606888695_53773.xml',create_date = '2020-12-02 05:58:15';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-08-31' AND date_to= '2021-08-31' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-08-31',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_15_1606888695_53773.xml',create_date = '2020-12-02 05:58:15';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-09-30' AND date_to= '2021-09-30' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-09-30',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_15_1606888695_53773.xml',create_date = '2020-12-02 05:58:15';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-10-31' AND date_to= '2021-10-31' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-10-31',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_15_1606888695_53773.xml',create_date = '2020-12-02 05:58:15';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-11-30' AND date_to= '2021-11-30' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-11-30',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_15_1606888695_53773.xml',create_date = '2020-12-02 05:58:15';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-12-31' AND date_to= '2021-12-31' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2021-12-31',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_58_15_1606888695_53773.xml',create_date = '2020-12-02 05:58:15';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-02 05:58:15',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',room_class_id= '1058',rate_id= '132',start_date= '2021-12-31';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDIgMDU6NTg6MTU8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTMxICwgMjAyMS0wMS0zMSAsIDIwMjEtMDItMjggLCAyMDIxLTAzLTMxICwgMjAyMS0wNC0zMCAsIDIwMjEtMDUtMzEgLCAyMDIxLTA2LTMwICwgMjAyMS0wNy0zMSAsIDIwMjEtMDgtMzEgLCAyMDIxLTA5LTMwICwgMjAyMS0xMC0zMSAsIDIwMjEtMTEtMzAgLCAyMDIxLTEyLTMxPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-02 05:58:15';
[12/02/2020 05:58:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-02 05:58:15<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-31 , 2021-01-31 , 2021-02-28 , 2021-03-31 , 2021-04-30 , 2021-05-31 , 2021-06-30 , 2021-07-31 , 2021-08-31 , 2021-09-30 , 2021-10-31 , 2021-11-30 , 2021-12-31<br>',  email_sent ='yes', create_date ='2020-12-02 05:58:15', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/02/2020 05:59:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-02' AND date_to= '2020-12-02' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:59:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2020-12-02',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_59_07_1606888747_53773.xml',create_date = '2020-12-02 05:59:07';
[12/02/2020 05:59:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-04' AND date_to= '2020-12-04' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:59:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2020-12-04',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_59_07_1606888747_53773.xml',create_date = '2020-12-02 05:59:07';
[12/02/2020 05:59:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-06' AND date_to= '2020-12-06' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:59:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2020-12-06',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_59_07_1606888747_53773.xml',create_date = '2020-12-02 05:59:07';
[12/02/2020 05:59:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-08' AND date_to= '2020-12-08' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:59:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2020-12-08',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_59_07_1606888747_53773.xml',create_date = '2020-12-02 05:59:07';
[12/02/2020 05:59:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-10' AND date_to= '2020-12-10' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:59:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2020-12-10',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_59_07_1606888747_53773.xml',create_date = '2020-12-02 05:59:07';
[12/02/2020 05:59:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-12' AND date_to= '2020-12-12' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:59:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2020-12-12',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_59_07_1606888747_53773.xml',create_date = '2020-12-02 05:59:07';
[12/02/2020 05:59:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-14' AND date_to= '2020-12-14' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:59:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2020-12-14',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_59_07_1606888747_53773.xml',create_date = '2020-12-02 05:59:07';
[12/02/2020 05:59:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-16' AND date_to= '2020-12-16' AND room_class= '1058' AND room_basis= '1' AND inventory_class_id= '132';
[12/02/2020 05:59:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1058',room_basis = '1',date_from = '2020-12-16',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_05_59_07_1606888747_53773.xml',create_date = '2020-12-02 05:59:07';
[12/02/2020 05:59:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-02 05:59:07',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',room_class_id= '1058',rate_id= '132',start_date= '2020-12-16';
[12/02/2020 05:59:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDIgMDU6NTk6MDc8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTAyICwgMjAyMC0xMi0wNCAsIDIwMjAtMTItMDYgLCAyMDIwLTEyLTA4ICwgMjAyMC0xMi0xMCAsIDIwMjAtMTItMTIgLCAyMDIwLTEyLTE0ICwgMjAyMC0xMi0xNjxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-02 05:59:07';
[12/02/2020 05:59:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-02 05:59:07<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-02 , 2020-12-04 , 2020-12-06 , 2020-12-08 , 2020-12-10 , 2020-12-12 , 2020-12-14 , 2020-12-16<br>',  email_sent ='yes', create_date ='2020-12-02 05:59:07', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
