[10/12/2020 11:16:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '5.44' , weekend_rate= '5.44'  WHERE 1  AND hotel_id= '51817' AND supplier_id= 'S000000230' AND date_from= '2020-10-12' AND date_to= '2020-10-12' AND room_class= '968' AND room_basis= '1' AND inventory_class_id= '99';
[10/12/2020 11:16:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '51817',supplier_id = 'S000000230',inventory_class_id = '99',room_class = '968',room_basis = '1',date_from = '2020-10-12',weekday_rate = '5.44',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/51817/12_10_2020/request_getHotelARIUpdate_11_16_54_1602501414_51817.xml',create_date = '2020-10-12 11:16:54';
[10/12/2020 11:16:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-10-12 11:16:54',channel_manager_name= 'rategain',hotel_id= '51817',room_id= '1',room_class_id= '968',rate_id= '99',start_date= '2020-10-12';
[10/12/2020 11:16:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for Baan Boran by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBCYWFuIEJvcmFuIDxicj48YnI+QmVsb3cgYXJlIHRoZSBkZXRhaWxzPGJyPjxicj4gPGI+U3VwcGxpZXI8L2I+IDogQmx1ZSBNYWdwaWUgTG9kZ2U8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTIgMTE6MTY6NTQ8YnI+IDxiPkhvdGVsIDwvYj4gOiBCYWFuIEJvcmFuPGJyPiA8Yj5Ib3RlbCBDb2RlPC9iPiA6IDUxODE3PGJyPiA8Yj5TdXBwbGllciBJRCA8L2I+IDogUzAwMDAwMDIzMDxicj4gPGI+RGF0ZXMgPC9iPiA6IDIwMjAtMTAtMTI8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-12 11:16:54';
[10/12/2020 11:16:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for Baan Boran by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for Baan Boran <br><br>Below are the details<br><br> <b>Supplier</b> : Blue Magpie Lodge<br> <b>Date </b> : 2020-10-12 11:16:54<br> <b>Hotel </b> : Baan Boran<br> <b>Hotel Code</b> : 51817<br> <b>Supplier ID </b> : S000000230<br> <b>Dates </b> : 2020-10-12<br>',  email_sent ='yes', create_date ='2020-10-12 11:16:54', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/12/2020 11:27:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '5.44' , weekend_rate= '5.44'  WHERE 1  AND hotel_id= '51817' AND supplier_id= 'S000000230' AND date_from= '2020-10-12' AND date_to= '2020-10-12' AND room_class= '968' AND room_basis= '1' AND inventory_class_id= '99';
[10/12/2020 11:27:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '51817',supplier_id = 'S000000230',inventory_class_id = '99',room_class = '968',room_basis = '1',date_from = '2020-10-12',weekday_rate = '5.44',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/51817/12_10_2020/request_getHotelARIUpdate_11_27_16_1602502036_51817.xml',create_date = '2020-10-12 11:27:16';
[10/12/2020 11:27:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-10-12 11:27:16',channel_manager_name= 'rategain',hotel_id= '51817',room_id= '1',room_class_id= '968',rate_id= '99',start_date= '2020-10-12';
[10/12/2020 11:27:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for Baan Boran by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBCYWFuIEJvcmFuIDxicj48YnI+QmVsb3cgYXJlIHRoZSBkZXRhaWxzPGJyPjxicj4gPGI+U3VwcGxpZXI8L2I+IDogQmx1ZSBNYWdwaWUgTG9kZ2U8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTIgMTE6Mjc6MTY8YnI+IDxiPkhvdGVsIDwvYj4gOiBCYWFuIEJvcmFuPGJyPiA8Yj5Ib3RlbCBDb2RlPC9iPiA6IDUxODE3PGJyPiA8Yj5TdXBwbGllciBJRCA8L2I+IDogUzAwMDAwMDIzMDxicj4gPGI+RGF0ZXMgPC9iPiA6IDIwMjAtMTAtMTI8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-12 11:27:17';
[10/12/2020 11:27:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for Baan Boran by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for Baan Boran <br><br>Below are the details<br><br> <b>Supplier</b> : Blue Magpie Lodge<br> <b>Date </b> : 2020-10-12 11:27:16<br> <b>Hotel </b> : Baan Boran<br> <b>Hotel Code</b> : 51817<br> <b>Supplier ID </b> : S000000230<br> <b>Dates </b> : 2020-10-12<br>',  email_sent ='yes', create_date ='2020-10-12 11:27:17', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/12/2020 11:30:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '5.44' , weekend_rate= '5.44'  WHERE 1  AND hotel_id= '51817' AND supplier_id= 'S000000230' AND date_from= '2020-10-12' AND date_to= '2020-10-12' AND room_class= '968' AND room_basis= '1' AND inventory_class_id= '99';
[10/12/2020 11:30:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '51817',supplier_id = 'S000000230',inventory_class_id = '99',room_class = '968',room_basis = '1',date_from = '2020-10-12',weekday_rate = '5.44',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/51817/12_10_2020/request_getHotelARIUpdate_11_30_16_1602502216_51817.xml',create_date = '2020-10-12 11:30:16';
[10/12/2020 11:30:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-10-12 11:30:16',channel_manager_name= 'rategain',hotel_id= '51817',room_id= '1',room_class_id= '968',rate_id= '99',start_date= '2020-10-12';
[10/12/2020 11:30:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for Baan Boran by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBCYWFuIEJvcmFuIDxicj48YnI+QmVsb3cgYXJlIHRoZSBkZXRhaWxzPGJyPjxicj4gPGI+U3VwcGxpZXI8L2I+IDogQmx1ZSBNYWdwaWUgTG9kZ2U8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTIgMTE6MzA6MTY8YnI+IDxiPkhvdGVsIDwvYj4gOiBCYWFuIEJvcmFuPGJyPiA8Yj5Ib3RlbCBDb2RlPC9iPiA6IDUxODE3PGJyPiA8Yj5TdXBwbGllciBJRCA8L2I+IDogUzAwMDAwMDIzMDxicj4gPGI+RGF0ZXMgPC9iPiA6IDIwMjAtMTAtMTI8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-12 11:30:16';
[10/12/2020 11:30:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for Baan Boran by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for Baan Boran <br><br>Below are the details<br><br> <b>Supplier</b> : Blue Magpie Lodge<br> <b>Date </b> : 2020-10-12 11:30:16<br> <b>Hotel </b> : Baan Boran<br> <b>Hotel Code</b> : 51817<br> <b>Supplier ID </b> : S000000230<br> <b>Dates </b> : 2020-10-12<br>',  email_sent ='yes', create_date ='2020-10-12 11:30:16', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/12/2020 11:32:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '5.44' , weekend_rate= '5.44'  WHERE 1  AND hotel_id= '51817' AND supplier_id= 'S000000230' AND date_from= '2020-10-12' AND date_to= '2020-10-12' AND room_class= '968' AND room_basis= '1' AND inventory_class_id= '99';
[10/12/2020 11:32:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '51817',supplier_id = 'S000000230',inventory_class_id = '99',room_class = '968',room_basis = '1',date_from = '2020-10-12',weekday_rate = '5.44',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/51817/12_10_2020/request_getHotelARIUpdate_11_32_14_1602502334_51817.xml',create_date = '2020-10-12 11:32:14';
[10/12/2020 11:32: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-12 11:32:14',channel_manager_name= 'rategain',hotel_id= '51817',room_id= '1',room_class_id= '968',rate_id= '99',start_date= '2020-10-12';
[10/12/2020 11:32:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for Baan Boran by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBCYWFuIEJvcmFuIDxicj48YnI+QmVsb3cgYXJlIHRoZSBkZXRhaWxzPGJyPjxicj4gPGI+U3VwcGxpZXI8L2I+IDogQmx1ZSBNYWdwaWUgTG9kZ2U8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTIgMTE6MzI6MTQ8YnI+IDxiPkhvdGVsIDwvYj4gOiBCYWFuIEJvcmFuPGJyPiA8Yj5Ib3RlbCBDb2RlPC9iPiA6IDUxODE3PGJyPiA8Yj5TdXBwbGllciBJRCA8L2I+IDogUzAwMDAwMDIzMDxicj4gPGI+RGF0ZXMgPC9iPiA6IDIwMjAtMTAtMTI8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-12 11:32:14';
[10/12/2020 11:32:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for Baan Boran by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for Baan Boran <br><br>Below are the details<br><br> <b>Supplier</b> : Blue Magpie Lodge<br> <b>Date </b> : 2020-10-12 11:32:14<br> <b>Hotel </b> : Baan Boran<br> <b>Hotel Code</b> : 51817<br> <b>Supplier ID </b> : S000000230<br> <b>Dates </b> : 2020-10-12<br>',  email_sent ='yes', create_date ='2020-10-12 11:32:14', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/12/2020 11:34:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '5.44' , weekend_rate= '5.44'  WHERE 1  AND hotel_id= '51817' AND supplier_id= 'S000000230' AND date_from= '2020-10-12' AND date_to= '2020-10-12' AND room_class= '968' AND room_basis= '1' AND inventory_class_id= '99';
[10/12/2020 11:34:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '51817',supplier_id = 'S000000230',inventory_class_id = '99',room_class = '968',room_basis = '1',date_from = '2020-10-12',weekday_rate = '5.44',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/51817/12_10_2020/request_getHotelARIUpdate_11_34_24_1602502464_51817.xml',create_date = '2020-10-12 11:34:24';
[10/12/2020 11:34:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-10-12 11:34:24',channel_manager_name= 'rategain',hotel_id= '51817',room_id= '1',room_class_id= '968',rate_id= '99',start_date= '2020-10-12';
[10/12/2020 11:34:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for Baan Boran by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBCYWFuIEJvcmFuIDxicj48YnI+QmVsb3cgYXJlIHRoZSBkZXRhaWxzPGJyPjxicj4gPGI+U3VwcGxpZXI8L2I+IDogQmx1ZSBNYWdwaWUgTG9kZ2U8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTIgMTE6MzQ6MjQ8YnI+IDxiPkhvdGVsIDwvYj4gOiBCYWFuIEJvcmFuPGJyPiA8Yj5Ib3RlbCBDb2RlPC9iPiA6IDUxODE3PGJyPiA8Yj5TdXBwbGllciBJRCA8L2I+IDogUzAwMDAwMDIzMDxicj4gPGI+RGF0ZXMgPC9iPiA6IDIwMjAtMTAtMTI8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-12 11:34:24';
[10/12/2020 11:34:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for Baan Boran by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for Baan Boran <br><br>Below are the details<br><br> <b>Supplier</b> : Blue Magpie Lodge<br> <b>Date </b> : 2020-10-12 11:34:24<br> <b>Hotel </b> : Baan Boran<br> <b>Hotel Code</b> : 51817<br> <b>Supplier ID </b> : S000000230<br> <b>Dates </b> : 2020-10-12<br>',  email_sent ='yes', create_date ='2020-10-12 11:34:24', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/12/2020 11:36:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '108.89' , weekend_rate= '108.89'  WHERE 1  AND hotel_id= '51817' AND supplier_id= 'S000000230' AND date_from= '2020-10-12' AND date_to= '2020-10-12' AND room_class= '968' AND room_basis= '1' AND inventory_class_id= '99';
[10/12/2020 11:36:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '51817',supplier_id = 'S000000230',inventory_class_id = '99',room_class = '968',room_basis = '1',date_from = '2020-10-12',weekday_rate = '108.89',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/51817/12_10_2020/request_getHotelARIUpdate_11_36_15_1602502575_51817.xml',create_date = '2020-10-12 11:36:15';
[10/12/2020 11:36:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-10-12 11:36:15',channel_manager_name= 'rategain',hotel_id= '51817',room_id= '1',room_class_id= '968',rate_id= '99',start_date= '2020-10-12';
[10/12/2020 11:36:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for Baan Boran by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBCYWFuIEJvcmFuIDxicj48YnI+QmVsb3cgYXJlIHRoZSBkZXRhaWxzPGJyPjxicj4gPGI+U3VwcGxpZXI8L2I+IDogQmx1ZSBNYWdwaWUgTG9kZ2U8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTIgMTE6MzY6MTU8YnI+IDxiPkhvdGVsIDwvYj4gOiBCYWFuIEJvcmFuPGJyPiA8Yj5Ib3RlbCBDb2RlPC9iPiA6IDUxODE3PGJyPiA8Yj5TdXBwbGllciBJRCA8L2I+IDogUzAwMDAwMDIzMDxicj4gPGI+RGF0ZXMgPC9iPiA6IDIwMjAtMTAtMTI8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-12 11:36:15';
[10/12/2020 11:36:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for Baan Boran by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for Baan Boran <br><br>Below are the details<br><br> <b>Supplier</b> : Blue Magpie Lodge<br> <b>Date </b> : 2020-10-12 11:36:15<br> <b>Hotel </b> : Baan Boran<br> <b>Hotel Code</b> : 51817<br> <b>Supplier ID </b> : S000000230<br> <b>Dates </b> : 2020-10-12<br>',  email_sent ='yes', create_date ='2020-10-12 11:36:15', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/12/2020 11:36:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '108.89' , weekend_rate= '108.89'  WHERE 1  AND hotel_id= '51817' AND supplier_id= 'S000000230' AND date_from= '2020-10-12' AND date_to= '2020-10-12' AND room_class= '968' AND room_basis= '1' AND inventory_class_id= '99';
[10/12/2020 11:36:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '51817',supplier_id = 'S000000230',inventory_class_id = '99',room_class = '968',room_basis = '1',date_from = '2020-10-12',weekday_rate = '108.89',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/51817/12_10_2020/request_getHotelARIUpdate_11_36_57_1602502617_51817.xml',create_date = '2020-10-12 11:36:57';
[10/12/2020 11:36:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-10-12 11:36:57',channel_manager_name= 'rategain',hotel_id= '51817',room_id= '1',room_class_id= '968',rate_id= '99',start_date= '2020-10-12';
[10/12/2020 11:36:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for Baan Boran by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBCYWFuIEJvcmFuIDxicj48YnI+QmVsb3cgYXJlIHRoZSBkZXRhaWxzPGJyPjxicj4gPGI+U3VwcGxpZXI8L2I+IDogQmx1ZSBNYWdwaWUgTG9kZ2U8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTIgMTE6MzY6NTc8YnI+IDxiPkhvdGVsIDwvYj4gOiBCYWFuIEJvcmFuPGJyPiA8Yj5Ib3RlbCBDb2RlPC9iPiA6IDUxODE3PGJyPiA8Yj5TdXBwbGllciBJRCA8L2I+IDogUzAwMDAwMDIzMDxicj4gPGI+RGF0ZXMgPC9iPiA6IDIwMjAtMTAtMTI8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-12 11:36:57';
[10/12/2020 11:36:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for Baan Boran by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for Baan Boran <br><br>Below are the details<br><br> <b>Supplier</b> : Blue Magpie Lodge<br> <b>Date </b> : 2020-10-12 11:36:57<br> <b>Hotel </b> : Baan Boran<br> <b>Hotel Code</b> : 51817<br> <b>Supplier ID </b> : S000000230<br> <b>Dates </b> : 2020-10-12<br>',  email_sent ='yes', create_date ='2020-10-12 11:36:57', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/12/2020 11:39:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '54.44' , weekend_rate= '54.44'  WHERE 1  AND hotel_id= '51817' AND supplier_id= 'S000000230' AND date_from= '2020-10-12' AND date_to= '2020-10-12' AND room_class= '968' AND room_basis= '1' AND inventory_class_id= '99';
[10/12/2020 11:39:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '51817',supplier_id = 'S000000230',inventory_class_id = '99',room_class = '968',room_basis = '1',date_from = '2020-10-12',weekday_rate = '54.44',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/51817/12_10_2020/request_getHotelARIUpdate_11_39_43_1602502783_51817.xml',create_date = '2020-10-12 11:39:43';
[10/12/2020 11:39:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-10-12 11:39:43',channel_manager_name= 'rategain',hotel_id= '51817',room_id= '1',room_class_id= '968',rate_id= '99',start_date= '2020-10-12';
[10/12/2020 11:39:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for Baan Boran by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBCYWFuIEJvcmFuIDxicj48YnI+QmVsb3cgYXJlIHRoZSBkZXRhaWxzPGJyPjxicj4gPGI+U3VwcGxpZXI8L2I+IDogQmx1ZSBNYWdwaWUgTG9kZ2U8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTIgMTE6Mzk6NDM8YnI+IDxiPkhvdGVsIDwvYj4gOiBCYWFuIEJvcmFuPGJyPiA8Yj5Ib3RlbCBDb2RlPC9iPiA6IDUxODE3PGJyPiA8Yj5TdXBwbGllciBJRCA8L2I+IDogUzAwMDAwMDIzMDxicj4gPGI+RGF0ZXMgPC9iPiA6IDIwMjAtMTAtMTI8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-12 11:39:44';
[10/12/2020 11:39:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for Baan Boran by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for Baan Boran <br><br>Below are the details<br><br> <b>Supplier</b> : Blue Magpie Lodge<br> <b>Date </b> : 2020-10-12 11:39:43<br> <b>Hotel </b> : Baan Boran<br> <b>Hotel Code</b> : 51817<br> <b>Supplier ID </b> : S000000230<br> <b>Dates </b> : 2020-10-12<br>',  email_sent ='yes', create_date ='2020-10-12 11:39:44', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/12/2020 11:40:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '54.44' , weekend_rate= '54.44'  WHERE 1  AND hotel_id= '51817' AND supplier_id= 'S000000230' AND date_from= '2020-10-12' AND date_to= '2020-10-12' AND room_class= '968' AND room_basis= '1' AND inventory_class_id= '99';
[10/12/2020 11:40:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '51817',supplier_id = 'S000000230',inventory_class_id = '99',room_class = '968',room_basis = '1',date_from = '2020-10-12',weekday_rate = '54.44',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/51817/12_10_2020/request_getHotelARIUpdate_11_40_12_1602502812_51817.xml',create_date = '2020-10-12 11:40:12';
[10/12/2020 11:40:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '81.67' , weekend_rate= '81.67'  WHERE 1  AND hotel_id= '51817' AND supplier_id= 'S000000230' AND date_from= '2020-10-13' AND date_to= '2020-10-13' AND room_class= '968' AND room_basis= '1' AND inventory_class_id= '99';
[10/12/2020 11:40:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '51817',supplier_id = 'S000000230',inventory_class_id = '99',room_class = '968',room_basis = '1',date_from = '2020-10-13',weekday_rate = '81.67',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/51817/12_10_2020/request_getHotelARIUpdate_11_40_12_1602502812_51817.xml',create_date = '2020-10-12 11:40:12';
[10/12/2020 11:40:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-10-12 11:40:12',channel_manager_name= 'rategain',hotel_id= '51817',room_id= '1',room_class_id= '968',rate_id= '99',start_date= '2020-10-13';
[10/12/2020 11:40:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for Baan Boran by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBCYWFuIEJvcmFuIDxicj48YnI+QmVsb3cgYXJlIHRoZSBkZXRhaWxzPGJyPjxicj4gPGI+U3VwcGxpZXI8L2I+IDogQmx1ZSBNYWdwaWUgTG9kZ2U8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTIgMTE6NDA6MTI8YnI+IDxiPkhvdGVsIDwvYj4gOiBCYWFuIEJvcmFuPGJyPiA8Yj5Ib3RlbCBDb2RlPC9iPiA6IDUxODE3PGJyPiA8Yj5TdXBwbGllciBJRCA8L2I+IDogUzAwMDAwMDIzMDxicj4gPGI+RGF0ZXMgPC9iPiA6IDIwMjAtMTAtMTIgLCAyMDIwLTEwLTEzPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-12 11:40:13';
[10/12/2020 11:40:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for Baan Boran by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for Baan Boran <br><br>Below are the details<br><br> <b>Supplier</b> : Blue Magpie Lodge<br> <b>Date </b> : 2020-10-12 11:40:12<br> <b>Hotel </b> : Baan Boran<br> <b>Hotel Code</b> : 51817<br> <b>Supplier ID </b> : S000000230<br> <b>Dates </b> : 2020-10-12 , 2020-10-13<br>',  email_sent ='yes', create_date ='2020-10-12 11:40:13', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/12/2020 11:40:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '10'  WHERE 1  AND hotel_id= '51817' AND supplier_id= 'S000000230' AND date_from= '2020-10-12' AND inventory_class_id= '99';
[10/12/2020 11:40:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '51817',supplier_id = 'S000000230',inventory_class_id = '99',room_basis = '',date_from = '2020-10-12',availability = '10',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/51817/12_10_2020/request_getHotelARIUpdate_11_40_42_1602502842_51817.xml',create_date = '2020-10-12 11:40:43';
[10/12/2020 11:40:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '30'  WHERE 1  AND hotel_id= '51817' AND supplier_id= 'S000000230' AND date_from= '2020-10-13' AND inventory_class_id= '99';
[10/12/2020 11:40:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '51817',supplier_id = 'S000000230',inventory_class_id = '99',room_basis = '',date_from = '2020-10-13',availability = '30',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/51817/12_10_2020/request_getHotelARIUpdate_11_40_42_1602502842_51817.xml',create_date = '2020-10-12 11:40:43';
[10/12/2020 11:40:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-10-12 11:40:42',channel_manager_name= 'rategain',hotel_id= '51817',rate_id= '99',start_date= '2020-10-13';
[10/12/2020 11:40:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for Baan Boran by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBCYWFuIEJvcmFuIDxicj48YnI+QmVsb3cgYXJlIHRoZSBkZXRhaWxzPGJyPjxicj4gPGI+U3VwcGxpZXI8L2I+IDogQmx1ZSBNYWdwaWUgTG9kZ2U8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTIgMTE6NDA6NDI8YnI+IDxiPkhvdGVsIDwvYj4gOiBCYWFuIEJvcmFuPGJyPiA8Yj5Ib3RlbCBDb2RlPC9iPiA6IDUxODE3PGJyPiA8Yj5TdXBwbGllciBJRCA8L2I+IDogUzAwMDAwMDIzMDxicj4gPGI+RGF0ZXMgPC9iPiA6IDIwMjAtMTAtMTIgLCAyMDIwLTEwLTEzPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-12 11:40:43';
[10/12/2020 11:40:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for Baan Boran by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for Baan Boran <br><br>Below are the details<br><br> <b>Supplier</b> : Blue Magpie Lodge<br> <b>Date </b> : 2020-10-12 11:40:42<br> <b>Hotel </b> : Baan Boran<br> <b>Hotel Code</b> : 51817<br> <b>Supplier ID </b> : S000000230<br> <b>Dates </b> : 2020-10-12 , 2020-10-13<br>',  email_sent ='yes', create_date ='2020-10-12 11:40:43', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/12/2020 11:42:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '27.22' , weekend_rate= '27.22'  WHERE 1  AND hotel_id= '51817' AND supplier_id= 'S000000230' AND date_from= '2020-10-12' AND date_to= '2020-10-12' AND room_class= '968' AND room_basis= '1' AND inventory_class_id= '99';
[10/12/2020 11:42:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '51817',supplier_id = 'S000000230',inventory_class_id = '99',room_class = '968',room_basis = '1',date_from = '2020-10-12',weekday_rate = '27.22',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/51817/12_10_2020/request_getHotelARIUpdate_11_42_16_1602502936_51817.xml',create_date = '2020-10-12 11:42:17';
[10/12/2020 11:42:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '27.22' , weekend_rate= '27.22'  WHERE 1  AND hotel_id= '51817' AND supplier_id= 'S000000230' AND date_from= '2020-10-13' AND date_to= '2020-10-13' AND room_class= '968' AND room_basis= '1' AND inventory_class_id= '99';
[10/12/2020 11:42:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '51817',supplier_id = 'S000000230',inventory_class_id = '99',room_class = '968',room_basis = '1',date_from = '2020-10-13',weekday_rate = '27.22',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/51817/12_10_2020/request_getHotelARIUpdate_11_42_16_1602502936_51817.xml',create_date = '2020-10-12 11:42:17';
[10/12/2020 11:42:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '27.22' , weekend_rate= '27.22'  WHERE 1  AND hotel_id= '51817' AND supplier_id= 'S000000230' AND date_from= '2020-10-14' AND date_to= '2020-10-14' AND room_class= '968' AND room_basis= '1' AND inventory_class_id= '99';
[10/12/2020 11:42:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '51817',supplier_id = 'S000000230',inventory_class_id = '99',room_class = '968',room_basis = '1',date_from = '2020-10-14',weekday_rate = '27.22',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/51817/12_10_2020/request_getHotelARIUpdate_11_42_16_1602502936_51817.xml',create_date = '2020-10-12 11:42:17';
[10/12/2020 11:42:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '27.22' , weekend_rate= '27.22'  WHERE 1  AND hotel_id= '51817' AND supplier_id= 'S000000230' AND date_from= '2020-10-15' AND date_to= '2020-10-15' AND room_class= '968' AND room_basis= '1' AND inventory_class_id= '99';
[10/12/2020 11:42:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '51817',supplier_id = 'S000000230',inventory_class_id = '99',room_class = '968',room_basis = '1',date_from = '2020-10-15',weekday_rate = '27.22',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/51817/12_10_2020/request_getHotelARIUpdate_11_42_16_1602502936_51817.xml',create_date = '2020-10-12 11:42:17';
[10/12/2020 11:42:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-10-12 11:42:16',channel_manager_name= 'rategain',hotel_id= '51817',room_id= '1',rate_id= '99',start_date= '2020-10-12';
[10/12/2020 11:42:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for Baan Boran by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBCYWFuIEJvcmFuIDxicj48YnI+QmVsb3cgYXJlIHRoZSBkZXRhaWxzPGJyPjxicj4gPGI+U3VwcGxpZXI8L2I+IDogQmx1ZSBNYWdwaWUgTG9kZ2U8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTIgMTE6NDI6MTY8YnI+IDxiPkhvdGVsIDwvYj4gOiBCYWFuIEJvcmFuPGJyPiA8Yj5Ib3RlbCBDb2RlPC9iPiA6IDUxODE3PGJyPiA8Yj5TdXBwbGllciBJRCA8L2I+IDogUzAwMDAwMDIzMDxicj4gPGI+RGF0ZXMgPC9iPiA6IDIwMjAtMTAtMTIgLCAyMDIwLTEwLTEzICwgMjAyMC0xMC0xNCAsIDIwMjAtMTAtMTU8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-12 11:42:17';
[10/12/2020 11:42:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for Baan Boran by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for Baan Boran <br><br>Below are the details<br><br> <b>Supplier</b> : Blue Magpie Lodge<br> <b>Date </b> : 2020-10-12 11:42:16<br> <b>Hotel </b> : Baan Boran<br> <b>Hotel Code</b> : 51817<br> <b>Supplier ID </b> : S000000230<br> <b>Dates </b> : 2020-10-12 , 2020-10-13 , 2020-10-14 , 2020-10-15<br>',  email_sent ='yes', create_date ='2020-10-12 11:42:17', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/12/2020 11:43:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '10'  WHERE 1  AND hotel_id= '51817' AND supplier_id= 'S000000230' AND date_from= '2020-10-13' AND inventory_class_id= '99';
[10/12/2020 11:43:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '51817',supplier_id = 'S000000230',inventory_class_id = '99',room_basis = '',date_from = '2020-10-13',availability = '10',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/51817/12_10_2020/request_getHotelARIUpdate_11_42_59_1602502979_51817.xml',create_date = '2020-10-12 11:43:00';
[10/12/2020 11:43:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '10'  WHERE 1  AND hotel_id= '51817' AND supplier_id= 'S000000230' AND date_from= '2020-10-14' AND inventory_class_id= '99';
[10/12/2020 11:43:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '51817',supplier_id = 'S000000230',inventory_class_id = '99',room_basis = '',date_from = '2020-10-14',availability = '10',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/51817/12_10_2020/request_getHotelARIUpdate_11_42_59_1602502979_51817.xml',create_date = '2020-10-12 11:43:00';
[10/12/2020 11:43:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '10'  WHERE 1  AND hotel_id= '51817' AND supplier_id= 'S000000230' AND date_from= '2020-10-15' AND inventory_class_id= '99';
[10/12/2020 11:43:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '51817',supplier_id = 'S000000230',inventory_class_id = '99',room_basis = '',date_from = '2020-10-15',availability = '10',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/51817/12_10_2020/request_getHotelARIUpdate_11_42_59_1602502979_51817.xml',create_date = '2020-10-12 11:43:00';
[10/12/2020 11:43:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-10-12 11:42:59',channel_manager_name= 'rategain',hotel_id= '51817',rate_id= '99',start_date= '2020-10-12';
[10/12/2020 11:43:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for Baan Boran by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBCYWFuIEJvcmFuIDxicj48YnI+QmVsb3cgYXJlIHRoZSBkZXRhaWxzPGJyPjxicj4gPGI+U3VwcGxpZXI8L2I+IDogQmx1ZSBNYWdwaWUgTG9kZ2U8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTIgMTE6NDI6NTk8YnI+IDxiPkhvdGVsIDwvYj4gOiBCYWFuIEJvcmFuPGJyPiA8Yj5Ib3RlbCBDb2RlPC9iPiA6IDUxODE3PGJyPiA8Yj5TdXBwbGllciBJRCA8L2I+IDogUzAwMDAwMDIzMDxicj4gPGI+RGF0ZXMgPC9iPiA6IDIwMjAtMTAtMTIgLCAyMDIwLTEwLTEzICwgMjAyMC0xMC0xNCAsIDIwMjAtMTAtMTU8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-12 11:43:00';
[10/12/2020 11:43:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for Baan Boran by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for Baan Boran <br><br>Below are the details<br><br> <b>Supplier</b> : Blue Magpie Lodge<br> <b>Date </b> : 2020-10-12 11:42:59<br> <b>Hotel </b> : Baan Boran<br> <b>Hotel Code</b> : 51817<br> <b>Supplier ID </b> : S000000230<br> <b>Dates </b> : 2020-10-12 , 2020-10-13 , 2020-10-14 , 2020-10-15<br>',  email_sent ='yes', create_date ='2020-10-12 11:43:00', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
