[10/12/2020 09:00:07], [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 09:00:07',channel_manager_name= 'rategain',hotel_id= '51817';
[10/12/2020 09:00:07], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTIgMDk6MDA6MDc8YnI+IDxiPkhvdGVsIDwvYj4gOiBCYWFuIEJvcmFuPGJyPiA8Yj5Ib3RlbCBDb2RlPC9iPiA6IDUxODE3PGJyPiA8Yj5TdXBwbGllciBJRCA8L2I+IDogUzAwMDAwMDIzMDxicj4gPGI+RGF0ZXMgPC9iPiA6IDxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-12 09:00:07';
[10/12/2020 09:00:08], [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 09:00:07<br> <b>Hotel </b> : Baan Boran<br> <b>Hotel Code</b> : 51817<br> <b>Supplier ID </b> : S000000230<br> <b>Dates </b> : <br>',  email_sent ='yes', create_date ='2020-10-12 09:00:08', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/12/2020 09:01:20], [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 09:01:20',channel_manager_name= 'rategain',hotel_id= '51817';
[10/12/2020 09:01:20], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTIgMDk6MDE6MjA8YnI+IDxiPkhvdGVsIDwvYj4gOiBCYWFuIEJvcmFuPGJyPiA8Yj5Ib3RlbCBDb2RlPC9iPiA6IDUxODE3PGJyPiA8Yj5TdXBwbGllciBJRCA8L2I+IDogUzAwMDAwMDIzMDxicj4gPGI+RGF0ZXMgPC9iPiA6IDxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-12 09:01:20';
[10/12/2020 09:01:20], [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 09:01:20<br> <b>Hotel </b> : Baan Boran<br> <b>Hotel Code</b> : 51817<br> <b>Supplier ID </b> : S000000230<br> <b>Dates </b> : <br>',  email_sent ='yes', create_date ='2020-10-12 09:01:20', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/12/2020 09:01:49], [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 09:01:49',channel_manager_name= 'rategain',hotel_id= '51817';
[10/12/2020 09:01:49], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTIgMDk6MDE6NDk8YnI+IDxiPkhvdGVsIDwvYj4gOiBCYWFuIEJvcmFuPGJyPiA8Yj5Ib3RlbCBDb2RlPC9iPiA6IDUxODE3PGJyPiA8Yj5TdXBwbGllciBJRCA8L2I+IDogUzAwMDAwMDIzMDxicj4gPGI+RGF0ZXMgPC9iPiA6IDxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-12 09:01:49';
[10/12/2020 09:01:49], [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 09:01:49<br> <b>Hotel </b> : Baan Boran<br> <b>Hotel Code</b> : 51817<br> <b>Supplier ID </b> : S000000230<br> <b>Dates </b> : <br>',  email_sent ='yes', create_date ='2020-10-12 09:01:49', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/12/2020 09:02: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-12 09:02:50',channel_manager_name= 'rategain',hotel_id= '51817';
[10/12/2020 09:02:50], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTIgMDk6MDI6NTA8YnI+IDxiPkhvdGVsIDwvYj4gOiBCYWFuIEJvcmFuPGJyPiA8Yj5Ib3RlbCBDb2RlPC9iPiA6IDUxODE3PGJyPiA8Yj5TdXBwbGllciBJRCA8L2I+IDogUzAwMDAwMDIzMDxicj4gPGI+RGF0ZXMgPC9iPiA6IDxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-12 09:02:50';
[10/12/2020 09:02:50], [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 09:02:50<br> <b>Hotel </b> : Baan Boran<br> <b>Hotel Code</b> : 51817<br> <b>Supplier ID </b> : S000000230<br> <b>Dates </b> : <br>',  email_sent ='yes', create_date ='2020-10-12 09:02:50', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/12/2020 09:04:55], [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 09:04:55',channel_manager_name= 'rategain',hotel_id= '51817';
[10/12/2020 09:04:55], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTIgMDk6MDQ6NTU8YnI+IDxiPkhvdGVsIDwvYj4gOiBCYWFuIEJvcmFuPGJyPiA8Yj5Ib3RlbCBDb2RlPC9iPiA6IDUxODE3PGJyPiA8Yj5TdXBwbGllciBJRCA8L2I+IDogUzAwMDAwMDIzMDxicj4gPGI+RGF0ZXMgPC9iPiA6IDxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-12 09:04:55';
[10/12/2020 09:04:55], [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 09:04:55<br> <b>Hotel </b> : Baan Boran<br> <b>Hotel Code</b> : 51817<br> <b>Supplier ID </b> : S000000230<br> <b>Dates </b> : <br>',  email_sent ='yes', create_date ='2020-10-12 09:04:55', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/12/2020 09:05:21], [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 09:05:21',channel_manager_name= 'rategain',hotel_id= '51817';
[10/12/2020 09:05:21], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTIgMDk6MDU6MjE8YnI+IDxiPkhvdGVsIDwvYj4gOiBCYWFuIEJvcmFuPGJyPiA8Yj5Ib3RlbCBDb2RlPC9iPiA6IDUxODE3PGJyPiA8Yj5TdXBwbGllciBJRCA8L2I+IDogUzAwMDAwMDIzMDxicj4gPGI+RGF0ZXMgPC9iPiA6IDxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-12 09:05:21';
[10/12/2020 09:05:21], [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 09:05:21<br> <b>Hotel </b> : Baan Boran<br> <b>Hotel Code</b> : 51817<br> <b>Supplier ID </b> : S000000230<br> <b>Dates </b> : <br>',  email_sent ='yes', create_date ='2020-10-12 09:05:21', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/12/2020 09:05:41], [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 09:05:41',channel_manager_name= 'rategain',hotel_id= '51817';
[10/12/2020 09:05:42], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTIgMDk6MDU6NDE8YnI+IDxiPkhvdGVsIDwvYj4gOiBCYWFuIEJvcmFuPGJyPiA8Yj5Ib3RlbCBDb2RlPC9iPiA6IDUxODE3PGJyPiA8Yj5TdXBwbGllciBJRCA8L2I+IDogUzAwMDAwMDIzMDxicj4gPGI+RGF0ZXMgPC9iPiA6IDxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-12 09:05:42';
[10/12/2020 09:05:42], [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 09:05:41<br> <b>Hotel </b> : Baan Boran<br> <b>Hotel Code</b> : 51817<br> <b>Supplier ID </b> : S000000230<br> <b>Dates </b> : <br>',  email_sent ='yes', create_date ='2020-10-12 09:05:42', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/12/2020 09:10: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 09:10:24',channel_manager_name= 'rategain',hotel_id= '51817';
[10/12/2020 09:10: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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTIgMDk6MTA6MjQ8YnI+IDxiPkhvdGVsIDwvYj4gOiBCYWFuIEJvcmFuPGJyPiA8Yj5Ib3RlbCBDb2RlPC9iPiA6IDUxODE3PGJyPiA8Yj5TdXBwbGllciBJRCA8L2I+IDogUzAwMDAwMDIzMDxicj4gPGI+RGF0ZXMgPC9iPiA6IDxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-12 09:10:24';
[10/12/2020 09:10: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 09:10:24<br> <b>Hotel </b> : Baan Boran<br> <b>Hotel Code</b> : 51817<br> <b>Supplier ID </b> : S000000230<br> <b>Dates </b> : <br>',  email_sent ='yes', create_date ='2020-10-12 09:10:24', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/12/2020 09:19: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 09:19:17',channel_manager_name= 'rategain',hotel_id= '51817',room_id= '1',rate_id= '99',start_date= '2020-10-12';
[10/12/2020 09:19:18], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTIgMDk6MTk6MTc8YnI+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 09:19:18';
[10/12/2020 09:19:18], [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 09:19:17<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 09:19:18', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/12/2020 09:22:09], [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 09:22:09',channel_manager_name= 'rategain',hotel_id= '51817',room_id= '1',rate_id= '99',start_date= '2020-10-12';
[10/12/2020 09:22:09], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTIgMDk6MjI6MDk8YnI+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 09:22:09';
[10/12/2020 09:22:09], [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 09:22:09<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 09:22:09', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/12/2020 09:23:22], [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 09:23:22',channel_manager_name= 'rategain',hotel_id= '51817',room_id= '1',rate_id= '99',start_date= '2020-10-12';
[10/12/2020 09:23:22], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTIgMDk6MjM6MjI8YnI+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 09:23:22';
[10/12/2020 09:23:22], [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 09:23:22<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 09:23:22', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/12/2020 09:25:22], [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 09:25:22',channel_manager_name= 'rategain',hotel_id= '51817',room_id= '1',rate_id= '99',start_date= '2020-10-12';
[10/12/2020 09:25:22], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTIgMDk6MjU6MjI8YnI+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 09:25:22';
[10/12/2020 09:25:22], [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 09:25:22<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 09:25:22', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/12/2020 09:30:58], [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 09:30:58], [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_09_30_58_1602495058_51817.xml',create_date = '2020-10-12 09:30:58';
[10/12/2020 09:30:58], [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 09:30:58',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 09:30:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Query Failed please check alpha.otrams.thefabulousgetaway.com',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'PGJyPi0tLS0tLS0tLSAKCjxicj5FcnJvcjoKU1FMU1RBVEVbNDJTMjJdOiBDb2x1bW4gbm90IGZvdW5kOiAxMDU0IFVua25vd24gY29sdW1uICdyb29tX2NsYXNzX2lkJyBpbiAnZmllbGQgbGlzdCcgZnJvbSBPdHJhbXNEQi5waHAgb24gMTItMTAtMjAyMCAwOTozMDo1OAogUXVlcnk6aW5zZXJ0IGludG8gY2hhbm5lbF9tYW5hZ2VyX2xvZ3MgU0VUIGNyZWF0ZV9kYXRlPSAnMjAyMC0xMC0xMiAwOTozMDo1OCcsY2hhbm5lbF9tYW5hZ2VyX25hbWU9ICdyYXRlZ2FpbicsaG90ZWxfaWQ9ICc1MTgxNycscm9vbV9pZD0gJzEnLHJvb21fY2xhc3NfaWQ9ICc5NjgnLHJhdGVfaWQ9ICc5OScsc3RhcnRfZGF0ZT0gJzIwMjAtMTAtMTInCgovYXBpL3JhdGVfZ2Fpbl9yZXNwb25zZS5waHAKCjxwcmU+Ckhvc3RuYW1lOiBxdGVjaC5vdHJhbXMuY29tCiA8YnI+CgpDb25uZWN0aW9uOiBvdHJhbXNfdGhlZmFiQDIwOS4yMzYuMTE0LjE3NAoKQmFja3RyYWNlOgphcnJheSAoCiAgMCA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9PdHJhbXNEQi5waHAnLAogICAgJ2xpbmUnID0+IDI0NiwKICAgICdmdW5jdGlvbicgPT4gJ3dyaXRlRXJyb3InLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAxID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL0NoYW5uZWxNYW5hZ2VyLnBocCcsCiAgICAnbGluZScgPT4gMTg4LAogICAgJ2Z1bmN0aW9uJyA9PiAncXVlcnknLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAyID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL3N1cHBsaWVyL1JhdGVHYWluLnBocCcsCiAgICAnbGluZScgPT4gODkzLAogICAgJ2Z1bmN0aW9uJyA9PiAnaW5zZXJ0Q2hhbm5lbE1hbmFnZXJMb2dzJywKICAgICdjbGFzcycgPT4gJ0NoYW5uZWxNYW5hZ2VyJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMyA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy9hcGkvcmF0ZV9nYWluX3Jlc3BvbnNlLnBocCcsCiAgICAnbGluZScgPT4gODQsCiAgICAnZnVuY3Rpb24nID0+ICdnZXRfaG90ZWxhcmlVcGRhdGVfUmVzcG9uc2UnLAogICAgJ2NsYXNzJyA9PiAnUmF0ZUdhaW4nLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKKQoKL2FwaS9yYXRlX2dhaW5fcmVzcG9uc2UucGhwCmFscGhhLm90cmFtcy50aGVmYWJ1bG91c2dldGF3YXkuY29tLCBDbGllbnQgSVA6IDEwMy41OC4xNTMuMjQzPC9wcmU+PGJyPgphcnJheSAoCiAgMCA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9PdHJhbXNEQi5waHAnLAogICAgJ2xpbmUnID0+IDI0NiwKICAgICdmdW5jdGlvbicgPT4gJ3dyaXRlRXJyb3InLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAxID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL0NoYW5uZWxNYW5hZ2VyLnBocCcsCiAgICAnbGluZScgPT4gMTg4LAogICAgJ2Z1bmN0aW9uJyA9PiAncXVlcnknLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAyID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL3N1cHBsaWVyL1JhdGVHYWluLnBocCcsCiAgICAnbGluZScgPT4gODkzLAogICAgJ2Z1bmN0aW9uJyA9PiAnaW5zZXJ0Q2hhbm5lbE1hbmFnZXJMb2dzJywKICAgICdjbGFzcycgPT4gJ0NoYW5uZWxNYW5hZ2VyJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMyA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy9hcGkvcmF0ZV9nYWluX3Jlc3BvbnNlLnBocCcsCiAgICAnbGluZScgPT4gODQsCiAgICAnZnVuY3Rpb24nID0+ICdnZXRfaG90ZWxhcmlVcGRhdGVfUmVzcG9uc2UnLAogICAgJ2NsYXNzJyA9PiAnUmF0ZUdhaW4nLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKKQ==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-12 09:30:58';
[10/12/2020 09:30:58], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTIgMDk6MzA6NTg8YnI+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 09:30:58';
[10/12/2020 09:30:58], [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 09:30:58<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 09:30:58', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
