[10/14/2020 04:43:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '5'  WHERE 1  AND hotel_id= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-14' AND inventory_class_id= '132';
[10/14/2020 04:43:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53771',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2020-10-14',availability = '5',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53771/14_10_2020/request_getHotelARIUpdate_04_43_13_1602650593_53771.xml',create_date = '2020-10-14 04:43:13';
[10/14/2020 04:43:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '5'  WHERE 1  AND hotel_id= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-15' AND inventory_class_id= '132';
[10/14/2020 04:43:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53771',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2020-10-15',availability = '5',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53771/14_10_2020/request_getHotelARIUpdate_04_43_13_1602650593_53771.xml',create_date = '2020-10-14 04:43:13';
[10/14/2020 04:43:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '5'  WHERE 1  AND hotel_id= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-16' AND inventory_class_id= '132';
[10/14/2020 04:43:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53771',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2020-10-16',availability = '5',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53771/14_10_2020/request_getHotelARIUpdate_04_43_13_1602650593_53771.xml',create_date = '2020-10-14 04:43:13';
[10/14/2020 04:43:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '5'  WHERE 1  AND hotel_id= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-17' AND inventory_class_id= '132';
[10/14/2020 04:43:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53771',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2020-10-17',availability = '5',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53771/14_10_2020/request_getHotelARIUpdate_04_43_13_1602650593_53771.xml',create_date = '2020-10-14 04:43:13';
[10/14/2020 04:43:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-10-14 04:43:13',channel_manager_name= 'rategain',hotel_id= '53771',rate_id= '132',start_date= '2020-10-14';
[10/14/2020 04:43:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGain by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2FpbiA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTQgMDQ6NDM6MTM8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbjxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3MTxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEwLTE0ICwgMjAyMC0xMC0xNSAsIDIwMjAtMTAtMTYgLCAyMDIwLTEwLTE3PGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-14 04:43:13';
[10/14/2020 04:43:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGain by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGain <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-10-14 04:43:13<br> <b>Hotel </b> : RateGain<br> <b>Hotel Code</b> : 53771<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-10-14 , 2020-10-15 , 2020-10-16 , 2020-10-17<br>',  email_sent ='yes', create_date ='2020-10-14 04:43:13', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
