[10/19/2020 01:00:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-11-25' AND inventory_class_id= '132';
[10/19/2020 01:00: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_basis = '',date_from = '2020-11-25',availability = '1',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_13_00_57_1603112457_53773.xml',create_date = '2020-10-19 13:00:57';
[10/19/2020 01:00:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-11-26' AND inventory_class_id= '132';
[10/19/2020 01:00: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_basis = '',date_from = '2020-11-26',availability = '1',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_13_00_57_1603112457_53773.xml',create_date = '2020-10-19 13:00:57';
[10/19/2020 01:00:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-11-27' AND inventory_class_id= '132';
[10/19/2020 01:00: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_basis = '',date_from = '2020-11-27',availability = '1',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_13_00_57_1603112457_53773.xml',create_date = '2020-10-19 13:00:57';
[10/19/2020 01:00:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-11-28' AND inventory_class_id= '132';
[10/19/2020 01:00: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_basis = '',date_from = '2020-11-28',availability = '1',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_13_00_57_1603112457_53773.xml',create_date = '2020-10-19 13:00:57';
[10/19/2020 01:00:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-11-29' AND inventory_class_id= '132';
[10/19/2020 01:00: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_basis = '',date_from = '2020-11-29',availability = '1',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_13_00_57_1603112457_53773.xml',create_date = '2020-10-19 13:00:57';
[10/19/2020 01:00:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-11-30' AND inventory_class_id= '132';
[10/19/2020 01:00:58], [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_basis = '',date_from = '2020-11-30',availability = '1',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_13_00_57_1603112457_53773.xml',create_date = '2020-10-19 13:00:58';
[10/19/2020 01:00:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-02' AND inventory_class_id= '132';
[10/19/2020 01:00:58], [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_basis = '',date_from = '2020-12-02',availability = '1',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_13_00_57_1603112457_53773.xml',create_date = '2020-10-19 13:00:58';
[10/19/2020 01:00:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-03' AND inventory_class_id= '132';
[10/19/2020 01:00:58], [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_basis = '',date_from = '2020-12-03',availability = '1',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_13_00_57_1603112457_53773.xml',create_date = '2020-10-19 13:00:58';
[10/19/2020 01:00:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-04' AND inventory_class_id= '132';
[10/19/2020 01:00:58], [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_basis = '',date_from = '2020-12-04',availability = '1',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_13_00_57_1603112457_53773.xml',create_date = '2020-10-19 13:00:58';
[10/19/2020 01:00:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-05' AND inventory_class_id= '132';
[10/19/2020 01:00:58], [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_basis = '',date_from = '2020-12-05',availability = '1',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_13_00_57_1603112457_53773.xml',create_date = '2020-10-19 13:00:58';
[10/19/2020 01:00:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-10-19 13:00:57',channel_manager_name= 'rategain',hotel_id= '53773',rate_id= '132',start_date= '2020-11-25';
[10/19/2020 01:00:58], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTkgMTM6MDA6NTc8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTExLTI1ICwgMjAyMC0xMS0yNiAsIDIwMjAtMTEtMjcgLCAyMDIwLTExLTI4ICwgMjAyMC0xMS0yOSAsIDIwMjAtMTEtMzAgLCAyMDIwLTEyLTAxICwgMjAyMC0xMi0wMiAsIDIwMjAtMTItMDMgLCAyMDIwLTEyLTA0ICwgMjAyMC0xMi0wNTxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-19 13:00:58';
[10/19/2020 01:00:58], [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-10-19 13:00:57<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-11-25 , 2020-11-26 , 2020-11-27 , 2020-11-28 , 2020-11-29 , 2020-11-30 , 2020-12-01 , 2020-12-02 , 2020-12-03 , 2020-12-04 , 2020-12-05<br>',  email_sent ='yes', create_date ='2020-10-19 13:00:58', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/19/2020 01:07:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '50' , weekend_rate= '50'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-25' AND date_to= '2020-12-25' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/19/2020 01:07:45], [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 = '1039',room_basis = '1',date_from = '2020-12-25',weekday_rate = '50',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_13_07_45_1603112865_53773.xml',create_date = '2020-10-19 13:07:45';
[10/19/2020 01:07:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '50' , weekend_rate= '50'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-26' AND date_to= '2020-12-26' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/19/2020 01:07:45], [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 = '1039',room_basis = '1',date_from = '2020-12-26',weekday_rate = '50',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_13_07_45_1603112865_53773.xml',create_date = '2020-10-19 13:07:45';
[10/19/2020 01:07:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '50' , weekend_rate= '50'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-27' AND date_to= '2020-12-27' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/19/2020 01:07:45], [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 = '1039',room_basis = '1',date_from = '2020-12-27',weekday_rate = '50',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_13_07_45_1603112865_53773.xml',create_date = '2020-10-19 13:07:45';
[10/19/2020 01:07:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '50' , weekend_rate= '50'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-28' AND date_to= '2020-12-28' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/19/2020 01:07:45], [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 = '1039',room_basis = '1',date_from = '2020-12-28',weekday_rate = '50',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_13_07_45_1603112865_53773.xml',create_date = '2020-10-19 13:07:45';
[10/19/2020 01:07:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '50' , weekend_rate= '50'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-29' AND date_to= '2020-12-29' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/19/2020 01:07:45], [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 = '1039',room_basis = '1',date_from = '2020-12-29',weekday_rate = '50',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_13_07_45_1603112865_53773.xml',create_date = '2020-10-19 13:07:45';
[10/19/2020 01:07:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '50' , weekend_rate= '50'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-30' AND date_to= '2020-12-30' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/19/2020 01:07:45], [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 = '1039',room_basis = '1',date_from = '2020-12-30',weekday_rate = '50',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_13_07_45_1603112865_53773.xml',create_date = '2020-10-19 13:07:45';
[10/19/2020 01:07:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '50' , weekend_rate= '50'  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= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/19/2020 01:07:45], [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 = '1039',room_basis = '1',date_from = '2020-12-31',weekday_rate = '50',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_13_07_45_1603112865_53773.xml',create_date = '2020-10-19 13:07:45';
[10/19/2020 01:07:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '50' , weekend_rate= '50'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-01' AND date_to= '2021-01-01' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/19/2020 01:07:45], [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 = '1039',room_basis = '1',date_from = '2021-01-01',weekday_rate = '50',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_13_07_45_1603112865_53773.xml',create_date = '2020-10-19 13:07:45';
[10/19/2020 01:07:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '50' , weekend_rate= '50'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-02' AND date_to= '2021-01-02' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/19/2020 01:07:45], [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 = '1039',room_basis = '1',date_from = '2021-01-02',weekday_rate = '50',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_13_07_45_1603112865_53773.xml',create_date = '2020-10-19 13:07:45';
[10/19/2020 01:07:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '50' , weekend_rate= '50'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-03' AND date_to= '2021-01-03' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/19/2020 01:07:45], [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 = '1039',room_basis = '1',date_from = '2021-01-03',weekday_rate = '50',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_13_07_45_1603112865_53773.xml',create_date = '2020-10-19 13:07:45';
[10/19/2020 01:07:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '50' , weekend_rate= '50'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-04' AND date_to= '2021-01-04' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/19/2020 01:07:46], [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 = '1039',room_basis = '1',date_from = '2021-01-04',weekday_rate = '50',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_13_07_45_1603112865_53773.xml',create_date = '2020-10-19 13:07:46';
[10/19/2020 01:07:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '50' , weekend_rate= '50'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-05' AND date_to= '2021-01-05' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/19/2020 01:07:46], [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 = '1039',room_basis = '1',date_from = '2021-01-05',weekday_rate = '50',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_13_07_45_1603112865_53773.xml',create_date = '2020-10-19 13:07:46';
[10/19/2020 01:07:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-10-19 13:07:45',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',room_class_id= '1039',rate_id= '132',start_date= '2020-12-25';
[10/19/2020 01:07:46], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTkgMTM6MDc6NDU8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTI1ICwgMjAyMC0xMi0yNiAsIDIwMjAtMTItMjcgLCAyMDIwLTEyLTI4ICwgMjAyMC0xMi0yOSAsIDIwMjAtMTItMzAgLCAyMDIwLTEyLTMxICwgMjAyMS0wMS0wMSAsIDIwMjEtMDEtMDIgLCAyMDIxLTAxLTAzICwgMjAyMS0wMS0wNCAsIDIwMjEtMDEtMDU8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-19 13:07:46';
[10/19/2020 01:07:46], [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-10-19 13:07:45<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-25 , 2020-12-26 , 2020-12-27 , 2020-12-28 , 2020-12-29 , 2020-12-30 , 2020-12-31 , 2021-01-01 , 2021-01-02 , 2021-01-03 , 2021-01-04 , 2021-01-05<br>',  email_sent ='yes', create_date ='2020-10-19 13:07:46', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/19/2020 01:22:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '20'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-11-07' AND inventory_class_id= '132';
[10/19/2020 01:22:49], [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_basis = '',date_from = '2020-11-07',availability = '20',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_13_22_49_1603113769_53773.xml',create_date = '2020-10-19 13:22:49';
[10/19/2020 01:22:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '20'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-11-08' AND inventory_class_id= '132';
[10/19/2020 01:22:49], [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_basis = '',date_from = '2020-11-08',availability = '20',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_13_22_49_1603113769_53773.xml',create_date = '2020-10-19 13:22:49';
[10/19/2020 01:22:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '20'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-11-14' AND inventory_class_id= '132';
[10/19/2020 01:22:49], [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_basis = '',date_from = '2020-11-14',availability = '20',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_13_22_49_1603113769_53773.xml',create_date = '2020-10-19 13:22:49';
[10/19/2020 01:22:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '20'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-11-15' AND inventory_class_id= '132';
[10/19/2020 01:22:49], [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_basis = '',date_from = '2020-11-15',availability = '20',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_13_22_49_1603113769_53773.xml',create_date = '2020-10-19 13:22:49';
[10/19/2020 01:22:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-10-19 13:22:49',channel_manager_name= 'rategain',hotel_id= '53773',rate_id= '132',start_date= '2020-11-14';
[10/19/2020 01:22:49], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTkgMTM6MjI6NDk8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTExLTA3ICwgMjAyMC0xMS0wOCAsIDIwMjAtMTEtMTQgLCAyMDIwLTExLTE1PGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-19 13:22:49';
[10/19/2020 01:22:49], [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-10-19 13:22:49<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-11-07 , 2020-11-08 , 2020-11-14 , 2020-11-15<br>',  email_sent ='yes', create_date ='2020-10-19 13:22:49', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
