[10/14/2020 06:17:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '11000' , weekend_rate= '11000'  WHERE 1  AND hotel_id= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-14' AND date_to= '2020-10-14' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/14/2020 06:17: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-14',weekday_rate = '11000',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_06_17_01_1602656221_53771.xml',create_date = '2020-10-14 06:17:01';
[10/14/2020 06:17:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '11000' , weekend_rate= '11000'  WHERE 1  AND hotel_id= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-15' AND date_to= '2020-10-15' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/14/2020 06:17: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-15',weekday_rate = '11000',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_06_17_01_1602656221_53771.xml',create_date = '2020-10-14 06:17:01';
[10/14/2020 06:17:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '11000' , weekend_rate= '11000'  WHERE 1  AND hotel_id= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-16' AND date_to= '2020-10-16' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/14/2020 06:17: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-16',weekday_rate = '11000',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_06_17_01_1602656221_53771.xml',create_date = '2020-10-14 06:17:01';
[10/14/2020 06:17:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '11000' , weekend_rate= '11000'  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 06:17: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-17',weekday_rate = '11000',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_06_17_01_1602656221_53771.xml',create_date = '2020-10-14 06:17:01';
[10/14/2020 06:17: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 06:17:01',channel_manager_name= 'rategain',hotel_id= '53771',room_id= '1',room_class_id= '1039',rate_id= '132',start_date= '2020-10-14';
[10/14/2020 06:17: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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTQgMDY6MTc6MDE8YnI+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 06:17:01';
[10/14/2020 06:17: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 06:17:01<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 06:17:01', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/14/2020 06:33:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],DELETE FROM hotel_room_class_mapping WHERE hotel_id='53771' AND supplier_id='S000000241';
[10/14/2020 06:33:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53771', supplier_id='S000000241', class_id='1039', is_channel_manager_mapped = '1';
[10/14/2020 06:42:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '1000.8' , weekend_rate= '1000.8'  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 06:42:50], [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 = '1000.8',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_06_42_50_1602657770_53771.xml',create_date = '2020-10-14 06:42:50';
[10/14/2020 06:42:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '1000.6' , weekend_rate= '1000.6'  WHERE 1  AND hotel_id= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-19' AND date_to= '2020-10-19' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/14/2020 06:42:50], [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-19',weekday_rate = '1000.6',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_06_42_50_1602657770_53771.xml',create_date = '2020-10-14 06:42:50';
[10/14/2020 06:42:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '1000.7' , weekend_rate= '1000.7'  WHERE 1  AND hotel_id= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-20' AND date_to= '2020-10-20' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/14/2020 06:42:50], [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-20',weekday_rate = '1000.7',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_06_42_50_1602657770_53771.xml',create_date = '2020-10-14 06:42:50';
[10/14/2020 06:42:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '1000.9' , weekend_rate= '1000.9'  WHERE 1  AND hotel_id= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-21' AND date_to= '2020-10-21' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/14/2020 06:42:50], [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-21',weekday_rate = '1000.9',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_06_42_50_1602657770_53771.xml',create_date = '2020-10-14 06:42:50';
[10/14/2020 06:42:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '1000.4' , weekend_rate= '1000.4'  WHERE 1  AND hotel_id= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-22' AND date_to= '2020-10-22' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/14/2020 06:42:50], [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-22',weekday_rate = '1000.4',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_06_42_50_1602657770_53771.xml',create_date = '2020-10-14 06:42:50';
[10/14/2020 06:42:50], [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 06:42:50',channel_manager_name= 'rategain',hotel_id= '53771',room_id= '1',room_class_id= '1039',rate_id= '132',start_date= '2020-10-22';
[10/14/2020 06:42:50], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTQgMDY6NDI6NTA8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbjxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3MTxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEwLTE4ICwgMjAyMC0xMC0xOSAsIDIwMjAtMTAtMjAgLCAyMDIwLTEwLTIxICwgMjAyMC0xMC0yMjxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-14 06:42:50';
[10/14/2020 06:42:50], [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 06:42:50<br> <b>Hotel </b> : RateGain<br> <b>Hotel Code</b> : 53771<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-10-18 , 2020-10-19 , 2020-10-20 , 2020-10-21 , 2020-10-22<br>',  email_sent ='yes', create_date ='2020-10-14 06:42:50', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/14/2020 06:46:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '1000.8' , weekend_rate= '1000.8'  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 06:46:51], [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 = '1000.8',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_06_46_51_1602658011_53771.xml',create_date = '2020-10-14 06:46:51';
[10/14/2020 06:46:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '1000.6' , weekend_rate= '1000.6'  WHERE 1  AND hotel_id= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-19' AND date_to= '2020-10-19' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/14/2020 06:46:51], [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-19',weekday_rate = '1000.6',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_06_46_51_1602658011_53771.xml',create_date = '2020-10-14 06:46:51';
[10/14/2020 06:46:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '1000.7' , weekend_rate= '1000.7'  WHERE 1  AND hotel_id= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-20' AND date_to= '2020-10-20' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/14/2020 06:46:52], [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-20',weekday_rate = '1000.7',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_06_46_51_1602658011_53771.xml',create_date = '2020-10-14 06:46:52';
[10/14/2020 06:46:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '1000.9' , weekend_rate= '1000.9'  WHERE 1  AND hotel_id= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-21' AND date_to= '2020-10-21' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/14/2020 06:46:52], [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-21',weekday_rate = '1000.9',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_06_46_51_1602658011_53771.xml',create_date = '2020-10-14 06:46:52';
[10/14/2020 06:46:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '1000.4' , weekend_rate= '1000.4'  WHERE 1  AND hotel_id= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-22' AND date_to= '2020-10-22' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/14/2020 06:46:52], [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-22',weekday_rate = '1000.4',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_06_46_51_1602658011_53771.xml',create_date = '2020-10-14 06:46:52';
[10/14/2020 06:46:52], [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 06:46:51',channel_manager_name= 'rategain',hotel_id= '53771',room_id= '1',room_class_id= '1039',rate_id= '132',start_date= '2020-10-22';
[10/14/2020 06:46:52], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTQgMDY6NDY6NTE8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbjxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3MTxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEwLTE4ICwgMjAyMC0xMC0xOSAsIDIwMjAtMTAtMjAgLCAyMDIwLTEwLTIxICwgMjAyMC0xMC0yMjxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-14 06:46:52';
[10/14/2020 06:46:52], [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 06:46:51<br> <b>Hotel </b> : RateGain<br> <b>Hotel Code</b> : 53771<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-10-18 , 2020-10-19 , 2020-10-20 , 2020-10-21 , 2020-10-22<br>',  email_sent ='yes', create_date ='2020-10-14 06:46:52', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/14/2020 06:48:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '1000.8' , weekend_rate= '1000.8'  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 06:48:23], [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 = '1000.8',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_06_48_23_1602658103_53771.xml',create_date = '2020-10-14 06:48:23';
[10/14/2020 06:48:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '1000.6' , weekend_rate= '1000.6'  WHERE 1  AND hotel_id= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-19' AND date_to= '2020-10-19' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/14/2020 06:48:23], [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-19',weekday_rate = '1000.6',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_06_48_23_1602658103_53771.xml',create_date = '2020-10-14 06:48:23';
[10/14/2020 06:48:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '1000.7' , weekend_rate= '1000.7'  WHERE 1  AND hotel_id= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-20' AND date_to= '2020-10-20' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/14/2020 06:48:23], [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-20',weekday_rate = '1000.7',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_06_48_23_1602658103_53771.xml',create_date = '2020-10-14 06:48:23';
[10/14/2020 06:48:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '1000.9' , weekend_rate= '1000.9'  WHERE 1  AND hotel_id= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-21' AND date_to= '2020-10-21' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/14/2020 06:48:23], [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-21',weekday_rate = '1000.9',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_06_48_23_1602658103_53771.xml',create_date = '2020-10-14 06:48:23';
[10/14/2020 06:48:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '1000.4' , weekend_rate= '1000.4'  WHERE 1  AND hotel_id= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-22' AND date_to= '2020-10-22' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/14/2020 06:48:23], [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-22',weekday_rate = '1000.4',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_06_48_23_1602658103_53771.xml',create_date = '2020-10-14 06:48:23';
[10/14/2020 06:48:23], [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 06:48:23',channel_manager_name= 'rategain',hotel_id= '53771',room_id= '1',room_class_id= '1039',rate_id= '132',start_date= '2020-10-22';
[10/14/2020 06:48:23], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTQgMDY6NDg6MjM8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbjxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3MTxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEwLTE4ICwgMjAyMC0xMC0xOSAsIDIwMjAtMTAtMjAgLCAyMDIwLTEwLTIxICwgMjAyMC0xMC0yMjxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-14 06:48:23';
[10/14/2020 06:48:23], [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 06:48:23<br> <b>Hotel </b> : RateGain<br> <b>Hotel Code</b> : 53771<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-10-18 , 2020-10-19 , 2020-10-20 , 2020-10-21 , 2020-10-22<br>',  email_sent ='yes', create_date ='2020-10-14 06:48:23', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/14/2020 06:58:06], [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= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-15' AND inventory_class_id= '132';
[10/14/2020 06:58:06], [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 = '1',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_06_58_06_1602658686_53771.xml',create_date = '2020-10-14 06:58:06';
[10/14/2020 06:58:06], [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= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-17' AND inventory_class_id= '132';
[10/14/2020 06:58:06], [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 = '1',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_06_58_06_1602658686_53771.xml',create_date = '2020-10-14 06:58:06';
[10/14/2020 06:58:06], [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= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-19' AND inventory_class_id= '132';
[10/14/2020 06:58:06], [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 = '1',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_06_58_06_1602658686_53771.xml',create_date = '2020-10-14 06:58:06';
[10/14/2020 06:58:06], [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= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-21' AND inventory_class_id= '132';
[10/14/2020 06:58:06], [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 = '1',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_06_58_06_1602658686_53771.xml',create_date = '2020-10-14 06:58:06';
[10/14/2020 06:58:06], [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= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-23' AND inventory_class_id= '132';
[10/14/2020 06:58:06], [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 = '1',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_06_58_06_1602658686_53771.xml',create_date = '2020-10-14 06:58:06';
[10/14/2020 06:58:06], [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= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-25' AND inventory_class_id= '132';
[10/14/2020 06:58:06], [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 = '1',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_06_58_06_1602658686_53771.xml',create_date = '2020-10-14 06:58:06';
[10/14/2020 06:58:06], [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= '53771' AND supplier_id= 'S000000241' AND date_from= '2020-10-27' AND inventory_class_id= '132';
[10/14/2020 06:58:06], [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 = '1',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_06_58_06_1602658686_53771.xml',create_date = '2020-10-14 06:58:06';
[10/14/2020 06:58:06], [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 06:58:06',channel_manager_name= 'rategain',hotel_id= '53771',room_id= '1',rate_id= '132',start_date= '2020-10-27';
[10/14/2020 06:58:06], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTQgMDY6NTg6MDY8YnI+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 06:58:06';
[10/14/2020 06:58:06], [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 06:58:06<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 06:58:06', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
