[10/14/2020 07:05:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '0'  WHERE 1  AND hotel_id= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-14' AND inventory_class_id= '132';
[10/14/2020 07:05: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 = '0',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_07_05_13_1602659113_53771.xml',create_date = '2020-10-14 07:05:13';
[10/14/2020 07:05:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '0'  WHERE 1  AND hotel_id= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-15' AND inventory_class_id= '132';
[10/14/2020 07:05:14], [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 = '0',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_07_05_13_1602659113_53771.xml',create_date = '2020-10-14 07:05:14';
[10/14/2020 07:05:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '0'  WHERE 1  AND hotel_id= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-16' AND inventory_class_id= '132';
[10/14/2020 07:05:14], [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 = '0',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_07_05_13_1602659113_53771.xml',create_date = '2020-10-14 07:05:14';
[10/14/2020 07:05:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '0'  WHERE 1  AND hotel_id= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-17' AND inventory_class_id= '132';
[10/14/2020 07:05:14], [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 = '0',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_07_05_13_1602659113_53771.xml',create_date = '2020-10-14 07:05:14';
[10/14/2020 07:05:14], [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 07:05:13',channel_manager_name= 'rategain',hotel_id= '53771',rate_id= '132',start_date= '2020-10-14';
[10/14/2020 07:05:14], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTQgMDc6MDU6MTM8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbjxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3MTxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEwLTE0ICwgMjAyMC0xMC0xNSAsIDIwMjAtMTAtMTYgLCAyMDIwLTEwLTE3ICwgMjAyMC0xMC0xOCAsIDIwMjAtMTAtMTkgLCAyMDIwLTEwLTIwICwgMjAyMC0xMC0yMSAsIDIwMjAtMTAtMjIgLCAyMDIwLTEwLTIzICwgMjAyMC0xMC0yNCAsIDIwMjAtMTAtMjUgLCAyMDIwLTEwLTI2ICwgMjAyMC0xMC0yNzxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-14 07:05:14';
[10/14/2020 07:05:14], [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 07:05: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 , 2020-10-18 , 2020-10-19 , 2020-10-20 , 2020-10-21 , 2020-10-22 , 2020-10-23 , 2020-10-24 , 2020-10-25 , 2020-10-26 , 2020-10-27<br>',  email_sent ='yes', create_date ='2020-10-14 07:05:14', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/14/2020 07:11:19], [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= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-15' AND inventory_class_id= '132';
[10/14/2020 07:11:19], [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 = '1',date_from = '2020-10-15',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/53771/14_10_2020/request_getHotelARIUpdate_07_11_19_1602659479_53771.xml',create_date = '2020-10-14 07:11:19';
[10/14/2020 07:11:19], [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= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-17' AND inventory_class_id= '132';
[10/14/2020 07:11:19], [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 = '1',date_from = '2020-10-17',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/53771/14_10_2020/request_getHotelARIUpdate_07_11_19_1602659479_53771.xml',create_date = '2020-10-14 07:11:19';
[10/14/2020 07:11:19], [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= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-19' AND inventory_class_id= '132';
[10/14/2020 07:11:19], [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 = '1',date_from = '2020-10-19',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/53771/14_10_2020/request_getHotelARIUpdate_07_11_19_1602659479_53771.xml',create_date = '2020-10-14 07:11:19';
[10/14/2020 07:11:19], [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= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-21' AND inventory_class_id= '132';
[10/14/2020 07:11:19], [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 = '1',date_from = '2020-10-21',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/53771/14_10_2020/request_getHotelARIUpdate_07_11_19_1602659479_53771.xml',create_date = '2020-10-14 07:11:19';
[10/14/2020 07:11:19], [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= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-23' AND inventory_class_id= '132';
[10/14/2020 07:11:19], [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 = '1',date_from = '2020-10-23',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/53771/14_10_2020/request_getHotelARIUpdate_07_11_19_1602659479_53771.xml',create_date = '2020-10-14 07:11:19';
[10/14/2020 07:11:19], [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= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-25' AND inventory_class_id= '132';
[10/14/2020 07:11:19], [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 = '1',date_from = '2020-10-25',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/53771/14_10_2020/request_getHotelARIUpdate_07_11_19_1602659479_53771.xml',create_date = '2020-10-14 07:11:19';
[10/14/2020 07:11:19], [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= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-27' AND inventory_class_id= '132';
[10/14/2020 07:11:19], [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 = '1',date_from = '2020-10-27',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/53771/14_10_2020/request_getHotelARIUpdate_07_11_19_1602659479_53771.xml',create_date = '2020-10-14 07:11:19';
[10/14/2020 07:11:19], [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 07:11:19',channel_manager_name= 'rategain',hotel_id= '53771',room_id= '1',rate_id= '132',start_date= '2020-10-14';
[10/14/2020 07:11:20], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTQgMDc6MTE6MTk8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbjxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3MTxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEwLTE0ICwgMjAyMC0xMC0xNSAsIDIwMjAtMTAtMTYgLCAyMDIwLTEwLTE3ICwgMjAyMC0xMC0xOCAsIDIwMjAtMTAtMTkgLCAyMDIwLTEwLTIwICwgMjAyMC0xMC0yMSAsIDIwMjAtMTAtMjIgLCAyMDIwLTEwLTIzICwgMjAyMC0xMC0yNCAsIDIwMjAtMTAtMjUgLCAyMDIwLTEwLTI2ICwgMjAyMC0xMC0yNzxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-14 07:11:20';
[10/14/2020 07:11:20], [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 07:11:19<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 , 2020-10-18 , 2020-10-19 , 2020-10-20 , 2020-10-21 , 2020-10-22 , 2020-10-23 , 2020-10-24 , 2020-10-25 , 2020-10-26 , 2020-10-27<br>',  email_sent ='yes', create_date ='2020-10-14 07:11:20', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/14/2020 07:19:45], [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 07:19:45], [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_07_19_45_1602659985_53771.xml',create_date = '2020-10-14 07:19:45';
[10/14/2020 07:19:45], [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 07:19:45], [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_07_19_45_1602659985_53771.xml',create_date = '2020-10-14 07:19:45';
[10/14/2020 07:19:45], [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-18' AND inventory_class_id= '132';
[10/14/2020 07:19:45], [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-18',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_07_19_45_1602659985_53771.xml',create_date = '2020-10-14 07:19:45';
[10/14/2020 07:19:45], [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-20' AND inventory_class_id= '132';
[10/14/2020 07:19:45], [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-20',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_07_19_45_1602659985_53771.xml',create_date = '2020-10-14 07:19:45';
[10/14/2020 07:19:46], [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-22' AND inventory_class_id= '132';
[10/14/2020 07:19:46], [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-22',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_07_19_45_1602659985_53771.xml',create_date = '2020-10-14 07:19:46';
[10/14/2020 07:19:46], [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-24' AND inventory_class_id= '132';
[10/14/2020 07:19:46], [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-24',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_07_19_45_1602659985_53771.xml',create_date = '2020-10-14 07:19:46';
[10/14/2020 07:19:46], [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-26' AND inventory_class_id= '132';
[10/14/2020 07:19:46], [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-26',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_07_19_45_1602659985_53771.xml',create_date = '2020-10-14 07:19:46';
[10/14/2020 07:19:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-10-14 07:19:45',channel_manager_name= 'rategain',hotel_id= '53771',rate_id= '132',start_date= '2020-10-26';
[10/14/2020 07:19:46], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTQgMDc6MTk6NDU8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbjxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3MTxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEwLTE0ICwgMjAyMC0xMC0xNiAsIDIwMjAtMTAtMTggLCAyMDIwLTEwLTIwICwgMjAyMC0xMC0yMiAsIDIwMjAtMTAtMjQgLCAyMDIwLTEwLTI2PGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-14 07:19:46';
[10/14/2020 07:19:46], [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 07:19:45<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-16 , 2020-10-18 , 2020-10-20 , 2020-10-22 , 2020-10-24 , 2020-10-26<br>',  email_sent ='yes', create_date ='2020-10-14 07:19:46', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/14/2020 07:33:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '20000' , weekend_rate= '20000'  WHERE 1  AND hotel_id= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-17' AND date_to= '2020-10-17' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/14/2020 07:33:00], [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_class = '1039',room_basis = '1',date_from = '2020-10-17',weekday_rate = '20000',type = 'rates',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_07_33_00_1602660780_53771.xml',create_date = '2020-10-14 07:33:00';
[10/14/2020 07:33:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '20000' , weekend_rate= '20000'  WHERE 1  AND hotel_id= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-18' AND date_to= '2020-10-18' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/14/2020 07:33:00], [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_class = '1039',room_basis = '1',date_from = '2020-10-18',weekday_rate = '20000',type = 'rates',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_07_33_00_1602660780_53771.xml',create_date = '2020-10-14 07:33:00';
[10/14/2020 07:33:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '20000' , weekend_rate= '20000'  WHERE 1  AND hotel_id= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-24' AND date_to= '2020-10-24' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/14/2020 07:33:00], [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_class = '1039',room_basis = '1',date_from = '2020-10-24',weekday_rate = '20000',type = 'rates',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_07_33_00_1602660780_53771.xml',create_date = '2020-10-14 07:33:00';
[10/14/2020 07:33:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '20000' , weekend_rate= '20000'  WHERE 1  AND hotel_id= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-25' AND date_to= '2020-10-25' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/14/2020 07:33:01], [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_class = '1039',room_basis = '1',date_from = '2020-10-25',weekday_rate = '20000',type = 'rates',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_07_33_00_1602660780_53771.xml',create_date = '2020-10-14 07:33:01';
[10/14/2020 07:33:01], [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 07:33:00',channel_manager_name= 'rategain',hotel_id= '53771',room_id= '1',room_class_id= '1039',rate_id= '132',start_date= '2020-10-24';
[10/14/2020 07:33:01], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTQgMDc6MzM6MDA8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbjxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3MTxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEwLTE3ICwgMjAyMC0xMC0xOCAsIDIwMjAtMTAtMjQgLCAyMDIwLTEwLTI1PGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-14 07:33:01';
[10/14/2020 07:33:01], [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 07:33:00<br> <b>Hotel </b> : RateGain<br> <b>Hotel Code</b> : 53771<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-10-17 , 2020-10-18 , 2020-10-24 , 2020-10-25<br>',  email_sent ='yes', create_date ='2020-10-14 07:33:01', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/14/2020 07:46:42], [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= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-14' AND inventory_class_id= '132';
[10/14/2020 07:46:42], [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 = '1',date_from = '2020-10-14',minstay = '3',type = 'minstay',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_07_46_42_1602661602_53771.xml',create_date = '2020-10-14 07:46:42';
[10/14/2020 07:46:42], [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= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-15' AND inventory_class_id= '132';
[10/14/2020 07:46:42], [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 = '1',date_from = '2020-10-15',minstay = '3',type = 'minstay',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_07_46_42_1602661602_53771.xml',create_date = '2020-10-14 07:46:42';
[10/14/2020 07:46:42], [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= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-16' AND inventory_class_id= '132';
[10/14/2020 07:46:42], [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 = '1',date_from = '2020-10-16',minstay = '3',type = 'minstay',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_07_46_42_1602661602_53771.xml',create_date = '2020-10-14 07:46:42';
[10/14/2020 07:46:42], [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= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-17' AND inventory_class_id= '132';
[10/14/2020 07:46:42], [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 = '1',date_from = '2020-10-17',minstay = '3',type = 'minstay',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_07_46_42_1602661602_53771.xml',create_date = '2020-10-14 07:46:42';
[10/14/2020 07:46:42], [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= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-18' AND inventory_class_id= '132';
[10/14/2020 07:46:42], [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 = '1',date_from = '2020-10-18',minstay = '3',type = 'minstay',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_07_46_42_1602661602_53771.xml',create_date = '2020-10-14 07:46:42';
[10/14/2020 07:46:42], [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 07:46:42',channel_manager_name= 'rategain',hotel_id= '53771',room_id= '1',rate_id= '132',start_date= '2020-10-14';
[10/14/2020 07:46:42], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTQgMDc6NDY6NDI8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbjxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3MTxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEwLTE0ICwgMjAyMC0xMC0xNSAsIDIwMjAtMTAtMTYgLCAyMDIwLTEwLTE3ICwgMjAyMC0xMC0xODxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-14 07:46:42';
[10/14/2020 07:46:42], [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 07:46:42<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 , 2020-10-18<br>',  email_sent ='yes', create_date ='2020-10-14 07:46:42', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
