[10/20/2020 06:58:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  minstay= '3'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-10-21' AND inventory_class_id= '132';
[10/20/2020 06:58:30], [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-10-21',minstay = '3',type = 'minstay',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/20_10_2020/request_getHotelARIUpdate_06_58_30_1603177110_53773.xml',create_date = '2020-10-20 06:58:30';
[10/20/2020 06:58:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  minstay= '3'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-10-22' AND inventory_class_id= '132';
[10/20/2020 06:58:30], [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-10-22',minstay = '3',type = 'minstay',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/20_10_2020/request_getHotelARIUpdate_06_58_30_1603177110_53773.xml',create_date = '2020-10-20 06:58:30';
[10/20/2020 06:58:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  minstay= '3'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-10-23' AND inventory_class_id= '132';
[10/20/2020 06:58:30], [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-10-23',minstay = '3',type = 'minstay',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/20_10_2020/request_getHotelARIUpdate_06_58_30_1603177110_53773.xml',create_date = '2020-10-20 06:58:30';
[10/20/2020 06:58:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  minstay= '3'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-10-24' AND inventory_class_id= '132';
[10/20/2020 06:58:30], [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-10-24',minstay = '3',type = 'minstay',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/20_10_2020/request_getHotelARIUpdate_06_58_30_1603177110_53773.xml',create_date = '2020-10-20 06:58:30';
[10/20/2020 06:58:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  minstay= '3'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-10-25' AND inventory_class_id= '132';
[10/20/2020 06:58:30], [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-10-25',minstay = '3',type = 'minstay',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/20_10_2020/request_getHotelARIUpdate_06_58_30_1603177110_53773.xml',create_date = '2020-10-20 06:58:30';
[10/20/2020 06:58:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-10-20 06:58:30',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2020-10-21';
[10/20/2020 06:58:31], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMjAgMDY6NTg6MzA8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEwLTIxICwgMjAyMC0xMC0yMiAsIDIwMjAtMTAtMjMgLCAyMDIwLTEwLTI0ICwgMjAyMC0xMC0yNTxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-20 06:58:31';
[10/20/2020 06:58:31], [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-20 06:58:30<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-10-21 , 2020-10-22 , 2020-10-23 , 2020-10-24 , 2020-10-25<br>',  email_sent ='yes', create_date ='2020-10-20 06:58:31', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
