[11/28/2020 01:30:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '13'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-11-30' AND inventory_class_id= '132';
[11/28/2020 01:30:47], [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 = '13',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_30_47_1606570247_53773.xml',create_date = '2020-11-28 13:30:47';
[11/28/2020 01:30:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '13'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-31' AND inventory_class_id= '132';
[11/28/2020 01:30:47], [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-31',availability = '13',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_30_47_1606570247_53773.xml',create_date = '2020-11-28 13:30:47';
[11/28/2020 01:30:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '13'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-31' AND inventory_class_id= '132';
[11/28/2020 01:30:47], [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 = '2021-01-31',availability = '13',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_30_47_1606570247_53773.xml',create_date = '2020-11-28 13:30:47';
[11/28/2020 01:30:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '13'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-28' AND inventory_class_id= '132';
[11/28/2020 01:30:47], [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 = '2021-02-28',availability = '13',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_30_47_1606570247_53773.xml',create_date = '2020-11-28 13:30:47';
[11/28/2020 01:30:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '13'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-03-31' AND inventory_class_id= '132';
[11/28/2020 01:30:48], [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 = '2021-03-31',availability = '13',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_30_47_1606570247_53773.xml',create_date = '2020-11-28 13:30:48';
[11/28/2020 01:30:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '13'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-04-30' AND inventory_class_id= '132';
[11/28/2020 01:30:48], [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 = '2021-04-30',availability = '13',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_30_47_1606570247_53773.xml',create_date = '2020-11-28 13:30:48';
[11/28/2020 01:30:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '13'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-05-31' AND inventory_class_id= '132';
[11/28/2020 01:30:48], [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 = '2021-05-31',availability = '13',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_30_47_1606570247_53773.xml',create_date = '2020-11-28 13:30:48';
[11/28/2020 01:30:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '13'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-06-30' AND inventory_class_id= '132';
[11/28/2020 01:30:48], [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 = '2021-06-30',availability = '13',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_30_47_1606570247_53773.xml',create_date = '2020-11-28 13:30:48';
[11/28/2020 01:30:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '13'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-07-31' AND inventory_class_id= '132';
[11/28/2020 01:30:48], [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 = '2021-07-31',availability = '13',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_30_47_1606570247_53773.xml',create_date = '2020-11-28 13:30:48';
[11/28/2020 01:30:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '13'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-08-31' AND inventory_class_id= '132';
[11/28/2020 01:30:48], [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 = '2021-08-31',availability = '13',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_30_47_1606570247_53773.xml',create_date = '2020-11-28 13:30:48';
[11/28/2020 01:30:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '13'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-09-30' AND inventory_class_id= '132';
[11/28/2020 01:30:48], [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 = '2021-09-30',availability = '13',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_30_47_1606570247_53773.xml',create_date = '2020-11-28 13:30:48';
[11/28/2020 01:30:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '13'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-10-31' AND inventory_class_id= '132';
[11/28/2020 01:30:48], [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 = '2021-10-31',availability = '13',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_30_47_1606570247_53773.xml',create_date = '2020-11-28 13:30:48';
[11/28/2020 01:30:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '13'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-11-30' AND inventory_class_id= '132';
[11/28/2020 01:30:48], [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 = '2021-11-30',availability = '13',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_30_47_1606570247_53773.xml',create_date = '2020-11-28 13:30:48';
[11/28/2020 01:30:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-11-28 13:30:47',channel_manager_name= 'rategain',hotel_id= '53773',rate_id= '132',start_date= '2021-11-30';
[11/28/2020 01:30:48], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTEtMjggMTM6MzA6NDc8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTExLTMwICwgMjAyMC0xMi0zMSAsIDIwMjEtMDEtMzEgLCAyMDIxLTAyLTI4ICwgMjAyMS0wMy0zMSAsIDIwMjEtMDQtMzAgLCAyMDIxLTA1LTMxICwgMjAyMS0wNi0zMCAsIDIwMjEtMDctMzEgLCAyMDIxLTA4LTMxICwgMjAyMS0wOS0zMCAsIDIwMjEtMTAtMzEgLCAyMDIxLTExLTMwPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-11-28 13:30:48';
[11/28/2020 01:30:48], [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-11-28 13:30:47<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-11-30 , 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<br>',  email_sent ='yes', create_date ='2020-11-28 13:30:48', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[11/28/2020 01:32:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-11-28 13:32:39',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2020-11-28';
[11/28/2020 01:32:39], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTEtMjggMTM6MzI6Mzk8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTExLTI4PGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-11-28 13:32:39';
[11/28/2020 01:32:39], [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-11-28 13:32:39<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-11-28<br>',  email_sent ='yes', create_date ='2020-11-28 13:32:39', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[11/28/2020 01:32:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-11-28' AND inventory_class_id= '132';
[11/28/2020 01:32:43], [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 = '1',date_from = '2020-11-28',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_43_1606570363_53773.xml',create_date = '2020-11-28 13:32:43';
[11/28/2020 01:32:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-11-28 13:32:43',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2020-11-28';
[11/28/2020 01:32:44], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTEtMjggMTM6MzI6NDM8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTExLTI4PGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-11-28 13:32:44';
[11/28/2020 01:32:44], [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-11-28 13:32:43<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-11-28<br>',  email_sent ='yes', create_date ='2020-11-28 13:32:44', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[11/28/2020 01:32:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '0'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-11-28' AND inventory_class_id= '132';
[11/28/2020 01:32:47], [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 = '1',date_from = '2020-11-28',stop_sale = '0',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_47_1606570367_53773.xml',create_date = '2020-11-28 13:32:47';
[11/28/2020 01:32:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-11-28 13:32:47',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2020-11-28';
[11/28/2020 01:32:48], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTEtMjggMTM6MzI6NDc8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTExLTI4ICwgMjAyMC0xMS0yOSAsIDIwMjAtMTEtMzAgLCAyMDIwLTEyLTAxICwgMjAyMC0xMi0wMiAsIDIwMjAtMTItMDMgLCAyMDIwLTEyLTA0PGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-11-28 13:32:48';
[11/28/2020 01:32:48], [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-11-28 13:32:47<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-11-28 , 2020-11-29 , 2020-11-30 , 2020-12-01 , 2020-12-02 , 2020-12-03 , 2020-12-04<br>',  email_sent ='yes', create_date ='2020-11-28 13:32:48', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[11/28/2020 01:32:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-28' AND inventory_class_id= '132';
[11/28/2020 01:32:52], [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 = '1',date_from = '2020-12-28',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:52';
[11/28/2020 01:32:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-29' AND inventory_class_id= '132';
[11/28/2020 01:32:52], [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 = '1',date_from = '2020-12-29',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:52';
[11/28/2020 01:32:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-30' AND inventory_class_id= '132';
[11/28/2020 01:32:52], [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 = '1',date_from = '2020-12-30',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:52';
[11/28/2020 01:32:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-31' AND inventory_class_id= '132';
[11/28/2020 01:32:52], [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 = '1',date_from = '2020-12-31',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:52';
[11/28/2020 01:32:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-01' AND inventory_class_id= '132';
[11/28/2020 01:32:52], [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 = '1',date_from = '2021-01-01',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:52';
[11/28/2020 01:32:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-02' AND inventory_class_id= '132';
[11/28/2020 01:32:52], [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 = '1',date_from = '2021-01-02',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:52';
[11/28/2020 01:32:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-03' AND inventory_class_id= '132';
[11/28/2020 01:32:52], [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 = '1',date_from = '2021-01-03',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:52';
[11/28/2020 01:32:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-04' AND inventory_class_id= '132';
[11/28/2020 01:32:52], [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 = '1',date_from = '2021-01-04',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:52';
[11/28/2020 01:32:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-05' AND inventory_class_id= '132';
[11/28/2020 01:32:52], [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 = '1',date_from = '2021-01-05',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:52';
[11/28/2020 01:32:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-06' AND inventory_class_id= '132';
[11/28/2020 01:32:52], [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 = '1',date_from = '2021-01-06',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:52';
[11/28/2020 01:32:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-07' AND inventory_class_id= '132';
[11/28/2020 01:32:52], [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 = '1',date_from = '2021-01-07',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:52';
[11/28/2020 01:32:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-08' AND inventory_class_id= '132';
[11/28/2020 01:32:52], [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 = '1',date_from = '2021-01-08',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:52';
[11/28/2020 01:32:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-09' AND inventory_class_id= '132';
[11/28/2020 01:32:52], [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 = '1',date_from = '2021-01-09',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:52';
[11/28/2020 01:32:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-10' AND inventory_class_id= '132';
[11/28/2020 01:32:53], [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 = '1',date_from = '2021-01-10',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:53';
[11/28/2020 01:32:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-11' AND inventory_class_id= '132';
[11/28/2020 01:32:53], [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 = '1',date_from = '2021-01-11',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:53';
[11/28/2020 01:32:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-12' AND inventory_class_id= '132';
[11/28/2020 01:32:53], [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 = '1',date_from = '2021-01-12',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:53';
[11/28/2020 01:32:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-13' AND inventory_class_id= '132';
[11/28/2020 01:32:53], [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 = '1',date_from = '2021-01-13',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:53';
[11/28/2020 01:32:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-14' AND inventory_class_id= '132';
[11/28/2020 01:32:53], [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 = '1',date_from = '2021-01-14',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:53';
[11/28/2020 01:32:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-15' AND inventory_class_id= '132';
[11/28/2020 01:32:53], [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 = '1',date_from = '2021-01-15',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:53';
[11/28/2020 01:32:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-16' AND inventory_class_id= '132';
[11/28/2020 01:32:53], [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 = '1',date_from = '2021-01-16',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:53';
[11/28/2020 01:32:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-17' AND inventory_class_id= '132';
[11/28/2020 01:32:53], [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 = '1',date_from = '2021-01-17',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:53';
[11/28/2020 01:32:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-18' AND inventory_class_id= '132';
[11/28/2020 01:32:53], [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 = '1',date_from = '2021-01-18',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:53';
[11/28/2020 01:32:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-19' AND inventory_class_id= '132';
[11/28/2020 01:32:53], [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 = '1',date_from = '2021-01-19',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:53';
[11/28/2020 01:32:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-20' AND inventory_class_id= '132';
[11/28/2020 01:32:53], [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 = '1',date_from = '2021-01-20',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:53';
[11/28/2020 01:32:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-21' AND inventory_class_id= '132';
[11/28/2020 01:32:53], [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 = '1',date_from = '2021-01-21',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:53';
[11/28/2020 01:32:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-22' AND inventory_class_id= '132';
[11/28/2020 01:32:53], [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 = '1',date_from = '2021-01-22',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:53';
[11/28/2020 01:32:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-23' AND inventory_class_id= '132';
[11/28/2020 01:32:53], [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 = '1',date_from = '2021-01-23',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:53';
[11/28/2020 01:32:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-24' AND inventory_class_id= '132';
[11/28/2020 01:32:53], [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 = '1',date_from = '2021-01-24',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:53';
[11/28/2020 01:32:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-25' AND inventory_class_id= '132';
[11/28/2020 01:32:53], [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 = '1',date_from = '2021-01-25',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:53';
[11/28/2020 01:32:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-26' AND inventory_class_id= '132';
[11/28/2020 01:32:53], [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 = '1',date_from = '2021-01-26',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:53';
[11/28/2020 01:32:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-27' AND inventory_class_id= '132';
[11/28/2020 01:32:53], [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 = '1',date_from = '2021-01-27',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:53';
[11/28/2020 01:32:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-28' AND inventory_class_id= '132';
[11/28/2020 01:32:53], [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 = '1',date_from = '2021-01-28',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:53';
[11/28/2020 01:32:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-29' AND inventory_class_id= '132';
[11/28/2020 01:32:53], [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 = '1',date_from = '2021-01-29',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:53';
[11/28/2020 01:32:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-30' AND inventory_class_id= '132';
[11/28/2020 01:32:53], [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 = '1',date_from = '2021-01-30',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:53';
[11/28/2020 01:32:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-31' AND inventory_class_id= '132';
[11/28/2020 01:32:53], [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 = '1',date_from = '2021-01-31',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_32_52_1606570372_53773.xml',create_date = '2020-11-28 13:32:53';
[11/28/2020 01:32:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-11-28 13:32:52',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2020-12-28';
[11/28/2020 01:32:53], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTEtMjggMTM6MzI6NTI8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTI4ICwgMjAyMC0xMi0yOSAsIDIwMjAtMTItMzAgLCAyMDIwLTEyLTMxICwgMjAyMS0wMS0wMSAsIDIwMjEtMDEtMDIgLCAyMDIxLTAxLTAzICwgMjAyMS0wMS0wNCAsIDIwMjEtMDEtMDUgLCAyMDIxLTAxLTA2ICwgMjAyMS0wMS0wNyAsIDIwMjEtMDEtMDggLCAyMDIxLTAxLTA5ICwgMjAyMS0wMS0xMCAsIDIwMjEtMDEtMTEgLCAyMDIxLTAxLTEyICwgMjAyMS0wMS0xMyAsIDIwMjEtMDEtMTQgLCAyMDIxLTAxLTE1ICwgMjAyMS0wMS0xNiAsIDIwMjEtMDEtMTcgLCAyMDIxLTAxLTE4ICwgMjAyMS0wMS0xOSAsIDIwMjEtMDEtMjAgLCAyMDIxLTAxLTIxICwgMjAyMS0wMS0yMiAsIDIwMjEtMDEtMjMgLCAyMDIxLTAxLTI0ICwgMjAyMS0wMS0yNSAsIDIwMjEtMDEtMjYgLCAyMDIxLTAxLTI3ICwgMjAyMS0wMS0yOCAsIDIwMjEtMDEtMjkgLCAyMDIxLTAxLTMwICwgMjAyMS0wMS0zMTxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-11-28 13:32:53';
[11/28/2020 01:32:53], [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-11-28 13:32:52<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 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 , 2021-01-06 , 2021-01-07 , 2021-01-08 , 2021-01-09 , 2021-01-10 , 2021-01-11 , 2021-01-12 , 2021-01-13 , 2021-01-14 , 2021-01-15 , 2021-01-16 , 2021-01-17 , 2021-01-18 , 2021-01-19 , 2021-01-20 , 2021-01-21 , 2021-01-22 , 2021-01-23 , 2021-01-24 , 2021-01-25 , 2021-01-26 , 2021-01-27 , 2021-01-28 , 2021-01-29 , 2021-01-30 , 2021-01-31<br>',  email_sent ='yes', create_date ='2020-11-28 13:32:53', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[11/28/2020 01:33:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '0'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-31' AND inventory_class_id= '132';
[11/28/2020 01:33: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_basis = '1',date_from = '2020-12-31',stop_sale = '0',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_33_02_1606570382_53773.xml',create_date = '2020-11-28 13:33:02';
[11/28/2020 01:33:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '0'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-31' AND inventory_class_id= '132';
[11/28/2020 01:33: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_basis = '1',date_from = '2021-01-31',stop_sale = '0',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_33_02_1606570382_53773.xml',create_date = '2020-11-28 13:33:02';
[11/28/2020 01:33:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-11-28 13:33:02',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2021-11-30';
[11/28/2020 01:33:03], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTEtMjggMTM6MzM6MDI8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTExLTMwICwgMjAyMC0xMi0zMSAsIDIwMjEtMDEtMzEgLCAyMDIxLTAyLTI4ICwgMjAyMS0wMy0zMSAsIDIwMjEtMDQtMzAgLCAyMDIxLTA1LTMxICwgMjAyMS0wNi0zMCAsIDIwMjEtMDctMzEgLCAyMDIxLTA4LTMxICwgMjAyMS0wOS0zMCAsIDIwMjEtMTAtMzEgLCAyMDIxLTExLTMwPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-11-28 13:33:03';
[11/28/2020 01:33:03], [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-11-28 13:33:02<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-11-30 , 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<br>',  email_sent ='yes', create_date ='2020-11-28 13:33:03', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[11/28/2020 01:33:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-11-28' AND inventory_class_id= '132';
[11/28/2020 01:33:51], [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 = '1',date_from = '2020-11-28',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_33_51_1606570431_53773.xml',create_date = '2020-11-28 13:33:51';
[11/28/2020 01:33:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-11-30' AND inventory_class_id= '132';
[11/28/2020 01:33:51], [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 = '1',date_from = '2020-11-30',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_33_51_1606570431_53773.xml',create_date = '2020-11-28 13:33:51';
[11/28/2020 01:33:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-02' AND inventory_class_id= '132';
[11/28/2020 01:33:51], [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 = '1',date_from = '2020-12-02',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_33_51_1606570431_53773.xml',create_date = '2020-11-28 13:33:51';
[11/28/2020 01:33:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-04' AND inventory_class_id= '132';
[11/28/2020 01:33:51], [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 = '1',date_from = '2020-12-04',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_33_51_1606570431_53773.xml',create_date = '2020-11-28 13:33:51';
[11/28/2020 01:33:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-06' AND inventory_class_id= '132';
[11/28/2020 01:33:51], [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 = '1',date_from = '2020-12-06',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_33_51_1606570431_53773.xml',create_date = '2020-11-28 13:33:51';
[11/28/2020 01:33:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-08' AND inventory_class_id= '132';
[11/28/2020 01:33:51], [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 = '1',date_from = '2020-12-08',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_33_51_1606570431_53773.xml',create_date = '2020-11-28 13:33:51';
[11/28/2020 01:33:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-10' AND inventory_class_id= '132';
[11/28/2020 01:33:51], [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 = '1',date_from = '2020-12-10',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_33_51_1606570431_53773.xml',create_date = '2020-11-28 13:33:51';
[11/28/2020 01:33:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-12' AND inventory_class_id= '132';
[11/28/2020 01:33:51], [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 = '1',date_from = '2020-12-12',stop_sale = '1',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_33_51_1606570431_53773.xml',create_date = '2020-11-28 13:33:51';
[11/28/2020 01:33:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-11-28 13:33:51',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2020-12-12';
[11/28/2020 01:33:51], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTEtMjggMTM6MzM6NTE8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTExLTI4ICwgMjAyMC0xMS0zMCAsIDIwMjAtMTItMDIgLCAyMDIwLTEyLTA0ICwgMjAyMC0xMi0wNiAsIDIwMjAtMTItMDggLCAyMDIwLTEyLTEwICwgMjAyMC0xMi0xMjxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-11-28 13:33:51';
[11/28/2020 01:33:51], [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-11-28 13:33:51<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-11-28 , 2020-11-30 , 2020-12-02 , 2020-12-04 , 2020-12-06 , 2020-12-08 , 2020-12-10 , 2020-12-12<br>',  email_sent ='yes', create_date ='2020-11-28 13:33:51', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[11/28/2020 01:37:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '3'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-11-28' AND inventory_class_id= '132';
[11/28/2020 01:37:11], [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 = '1',date_from = '2020-11-28',stop_sale = '3',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_37_11_1606570631_53773.xml',create_date = '2020-11-28 13:37:11';
[11/28/2020 01:37:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-11-28 13:37:11',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2020-11-28';
[11/28/2020 01:37:11], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTEtMjggMTM6Mzc6MTE8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTExLTI4PGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-11-28 13:37:11';
[11/28/2020 01:37:12], [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-11-28 13:37:11<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-11-28<br>',  email_sent ='yes', create_date ='2020-11-28 13:37:12', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[11/28/2020 01:37:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-11-28 13:37:15',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2020-11-28';
[11/28/2020 01:37:16], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTEtMjggMTM6Mzc6MTU8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTExLTI4PGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-11-28 13:37:16';
[11/28/2020 01:37:16], [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-11-28 13:37:15<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-11-28<br>',  email_sent ='yes', create_date ='2020-11-28 13:37:16', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[11/28/2020 01:37:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '3'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-11-29' AND inventory_class_id= '132';
[11/28/2020 01:37:19], [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 = '1',date_from = '2020-11-29',stop_sale = '3',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_37_19_1606570639_53773.xml',create_date = '2020-11-28 13:37:19';
[11/28/2020 01:37:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '3'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-11-30' AND inventory_class_id= '132';
[11/28/2020 01:37:19], [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 = '1',date_from = '2020-11-30',stop_sale = '3',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_37_19_1606570639_53773.xml',create_date = '2020-11-28 13:37:19';
[11/28/2020 01:37:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '3'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-01' AND inventory_class_id= '132';
[11/28/2020 01:37:20], [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 = '1',date_from = '2020-12-01',stop_sale = '3',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_37_19_1606570639_53773.xml',create_date = '2020-11-28 13:37:20';
[11/28/2020 01:37:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '3'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-02' AND inventory_class_id= '132';
[11/28/2020 01:37:20], [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 = '1',date_from = '2020-12-02',stop_sale = '3',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_37_19_1606570639_53773.xml',create_date = '2020-11-28 13:37:20';
[11/28/2020 01:37:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '3'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-03' AND inventory_class_id= '132';
[11/28/2020 01:37:20], [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 = '1',date_from = '2020-12-03',stop_sale = '3',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_37_19_1606570639_53773.xml',create_date = '2020-11-28 13:37:20';
[11/28/2020 01:37:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '3'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-04' AND inventory_class_id= '132';
[11/28/2020 01:37:20], [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 = '1',date_from = '2020-12-04',stop_sale = '3',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/28_11_2020/request_getHotelARIUpdate_13_37_19_1606570639_53773.xml',create_date = '2020-11-28 13:37:20';
[11/28/2020 01:37:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-11-28 13:37:19',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2020-11-28';
[11/28/2020 01:37:20], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTEtMjggMTM6Mzc6MTk8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTExLTI4ICwgMjAyMC0xMS0yOSAsIDIwMjAtMTEtMzAgLCAyMDIwLTEyLTAxICwgMjAyMC0xMi0wMiAsIDIwMjAtMTItMDMgLCAyMDIwLTEyLTA0PGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-11-28 13:37:20';
[11/28/2020 01:37:20], [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-11-28 13:37:19<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-11-28 , 2020-11-29 , 2020-11-30 , 2020-12-01 , 2020-12-02 , 2020-12-03 , 2020-12-04<br>',  email_sent ='yes', create_date ='2020-11-28 13:37:20', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[11/28/2020 01:37:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-11-28 13:37:24',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2020-12-28';
[11/28/2020 01:37:25], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTEtMjggMTM6Mzc6MjQ8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTI4ICwgMjAyMC0xMi0yOSAsIDIwMjAtMTItMzAgLCAyMDIwLTEyLTMxICwgMjAyMS0wMS0wMSAsIDIwMjEtMDEtMDIgLCAyMDIxLTAxLTAzICwgMjAyMS0wMS0wNCAsIDIwMjEtMDEtMDUgLCAyMDIxLTAxLTA2ICwgMjAyMS0wMS0wNyAsIDIwMjEtMDEtMDggLCAyMDIxLTAxLTA5ICwgMjAyMS0wMS0xMCAsIDIwMjEtMDEtMTEgLCAyMDIxLTAxLTEyICwgMjAyMS0wMS0xMyAsIDIwMjEtMDEtMTQgLCAyMDIxLTAxLTE1ICwgMjAyMS0wMS0xNiAsIDIwMjEtMDEtMTcgLCAyMDIxLTAxLTE4ICwgMjAyMS0wMS0xOSAsIDIwMjEtMDEtMjAgLCAyMDIxLTAxLTIxICwgMjAyMS0wMS0yMiAsIDIwMjEtMDEtMjMgLCAyMDIxLTAxLTI0ICwgMjAyMS0wMS0yNSAsIDIwMjEtMDEtMjYgLCAyMDIxLTAxLTI3ICwgMjAyMS0wMS0yOCAsIDIwMjEtMDEtMjkgLCAyMDIxLTAxLTMwICwgMjAyMS0wMS0zMTxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-11-28 13:37:25';
[11/28/2020 01:37:25], [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-11-28 13:37:24<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 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 , 2021-01-06 , 2021-01-07 , 2021-01-08 , 2021-01-09 , 2021-01-10 , 2021-01-11 , 2021-01-12 , 2021-01-13 , 2021-01-14 , 2021-01-15 , 2021-01-16 , 2021-01-17 , 2021-01-18 , 2021-01-19 , 2021-01-20 , 2021-01-21 , 2021-01-22 , 2021-01-23 , 2021-01-24 , 2021-01-25 , 2021-01-26 , 2021-01-27 , 2021-01-28 , 2021-01-29 , 2021-01-30 , 2021-01-31<br>',  email_sent ='yes', create_date ='2020-11-28 13:37:25', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[11/28/2020 01:37:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-11-28 13:37:33',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2021-11-30';
[11/28/2020 01:37:34], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTEtMjggMTM6Mzc6MzM8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTExLTMwICwgMjAyMC0xMi0zMSAsIDIwMjEtMDEtMzEgLCAyMDIxLTAyLTI4ICwgMjAyMS0wMy0zMSAsIDIwMjEtMDQtMzAgLCAyMDIxLTA1LTMxICwgMjAyMS0wNi0zMCAsIDIwMjEtMDctMzEgLCAyMDIxLTA4LTMxICwgMjAyMS0wOS0zMCAsIDIwMjEtMTAtMzEgLCAyMDIxLTExLTMwPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-11-28 13:37:34';
[11/28/2020 01:37:34], [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-11-28 13:37:33<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-11-30 , 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<br>',  email_sent ='yes', create_date ='2020-11-28 13:37:34', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[11/28/2020 01:38:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-11-28 13:38:23',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2020-12-12';
[11/28/2020 01:38:23], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTEtMjggMTM6Mzg6MjM8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTExLTI4ICwgMjAyMC0xMS0zMCAsIDIwMjAtMTItMDIgLCAyMDIwLTEyLTA0ICwgMjAyMC0xMi0wNiAsIDIwMjAtMTItMDggLCAyMDIwLTEyLTEwICwgMjAyMC0xMi0xMjxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-11-28 13:38:23';
[11/28/2020 01:38:23], [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-11-28 13:38:23<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-11-28 , 2020-11-30 , 2020-12-02 , 2020-12-04 , 2020-12-06 , 2020-12-08 , 2020-12-10 , 2020-12-12<br>',  email_sent ='yes', create_date ='2020-11-28 13:38:23', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
