[12/03/2020 02:00:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],update room_rates set stop_sale='3' where supplier_id='S000000241' and hotel_id=53773  and inventory_class_id in ('132') and date_from >='2021-01-28' AND date_from <='2021-03-03' ;
[12/03/2020 02:00:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-12-03 14:00:37',`log_type`= 'Sell Policy',`sql_query`= 'update room_rates set stop_sale=\&#039;3\&#039; where supplier_id=\&#039;S000000241\&#039; and hotel_id=53773  and inventory_class_id in (\&#039;132\&#039;) and date_from &gt;=\&#039;2021-01-28\&#039; AND date_from &lt;=\&#039;2021-03-03\&#039; &lt;br&gt;',`log_description`= 'Updated Sell Policy For hotel RateGainOne- Inventory Room Class:-Standard From:-28-01-2021 To:-03-03-2021 Weekday Policy:-Free Sell Weekend Policy:-Free Sell',`ip`= '60.254.11.202',`username`= 'tfg',`user_id`= 'S000000241';
[12/03/2020 02:00:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4059', `entity`='Hotels', `value`='53773' ;
[12/03/2020 02:00:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4059', `entity`='Suppliers', `value`='S000000241' ;
[12/03/2020 02:00:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4059', `entity`='Inventory', `value`='' ;
[12/03/2020 02:00:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4059', `entity`='Roomclass', `value`='' ;
[12/03/2020 02:00:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 14:00:43',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2021-12-31';
[12/03/2020 02:00:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTQ6MDA6NDM8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTMxICwgMjAyMS0wMS0zMSAsIDIwMjEtMDItMjggLCAyMDIxLTAzLTMxICwgMjAyMS0wNC0zMCAsIDIwMjEtMDUtMzEgLCAyMDIxLTA2LTMwICwgMjAyMS0wNy0zMSAsIDIwMjEtMDgtMzEgLCAyMDIxLTA5LTMwICwgMjAyMS0xMC0zMSAsIDIwMjEtMTEtMzAgLCAyMDIxLTEyLTMxPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 14:00:44';
[12/03/2020 02:00:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 14:00:43<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-31 , 2021-01-31 , 2021-02-28 , 2021-03-31 , 2021-04-30 , 2021-05-31 , 2021-06-30 , 2021-07-31 , 2021-08-31 , 2021-09-30 , 2021-10-31 , 2021-11-30 , 2021-12-31<br>',  email_sent ='yes', create_date ='2020-12-03 14:00:44', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 02:01:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],update room_rates set stop_sale='3' where supplier_id='S000000241' and hotel_id=53773  and inventory_class_id in ('132') and date_from >='2020-12-31' AND date_from <='2021-12-31' ;
[12/03/2020 02:01:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-12-03 14:01:38',`log_type`= 'Sell Policy',`sql_query`= 'update room_rates set stop_sale=\&#039;3\&#039; where supplier_id=\&#039;S000000241\&#039; and hotel_id=53773  and inventory_class_id in (\&#039;132\&#039;) and date_from &gt;=\&#039;2020-12-31\&#039; AND date_from &lt;=\&#039;2021-12-31\&#039; &lt;br&gt;',`log_description`= 'Updated Sell Policy For hotel RateGainOne- Inventory Room Class:-Standard From:-31-12-2020 To:-31-12-2021 Weekday Policy:-Free Sell Weekend Policy:-Free Sell',`ip`= '60.254.11.202',`username`= 'tfg',`user_id`= 'S000000241';
[12/03/2020 02:01:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4060', `entity`='Hotels', `value`='53773' ;
[12/03/2020 02:01:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4060', `entity`='Suppliers', `value`='S000000241' ;
[12/03/2020 02:01:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4060', `entity`='Inventory', `value`='' ;
[12/03/2020 02:01:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4060', `entity`='Roomclass', `value`='' ;
[12/03/2020 02:01:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 14:01:47',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2021-12-31';
[12/03/2020 02:01:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTQ6MDE6NDc8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTMxICwgMjAyMS0wMS0zMSAsIDIwMjEtMDItMjggLCAyMDIxLTAzLTMxICwgMjAyMS0wNC0zMCAsIDIwMjEtMDUtMzEgLCAyMDIxLTA2LTMwICwgMjAyMS0wNy0zMSAsIDIwMjEtMDgtMzEgLCAyMDIxLTA5LTMwICwgMjAyMS0xMC0zMSAsIDIwMjEtMTEtMzAgLCAyMDIxLTEyLTMxPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 14:01:47';
[12/03/2020 02:01:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 14:01:47<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-31 , 2021-01-31 , 2021-02-28 , 2021-03-31 , 2021-04-30 , 2021-05-31 , 2021-06-30 , 2021-07-31 , 2021-08-31 , 2021-09-30 , 2021-10-31 , 2021-11-30 , 2021-12-31<br>',  email_sent ='yes', create_date ='2020-12-03 14:01:47', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 02:03:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 14:03:11',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2021-12-31';
[12/03/2020 02:03:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTQ6MDM6MTE8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTMxICwgMjAyMS0wMS0zMSAsIDIwMjEtMDItMjggLCAyMDIxLTAzLTMxICwgMjAyMS0wNC0zMCAsIDIwMjEtMDUtMzEgLCAyMDIxLTA2LTMwICwgMjAyMS0wNy0zMSAsIDIwMjEtMDgtMzEgLCAyMDIxLTA5LTMwICwgMjAyMS0xMC0zMSAsIDIwMjEtMTEtMzAgLCAyMDIxLTEyLTMxPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 14:03:11';
[12/03/2020 02:03:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 14:03:11<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-31 , 2021-01-31 , 2021-02-28 , 2021-03-31 , 2021-04-30 , 2021-05-31 , 2021-06-30 , 2021-07-31 , 2021-08-31 , 2021-09-30 , 2021-10-31 , 2021-11-30 , 2021-12-31<br>',  email_sent ='yes', create_date ='2020-12-03 14:03:11', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 02:04:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 14:04:04',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2020-12-17';
[12/03/2020 02:04:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTQ6MDQ6MDQ8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTAzICwgMjAyMC0xMi0wNSAsIDIwMjAtMTItMDcgLCAyMDIwLTEyLTA5ICwgMjAyMC0xMi0xMSAsIDIwMjAtMTItMTMgLCAyMDIwLTEyLTE1ICwgMjAyMC0xMi0xNzxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 14:04:04';
[12/03/2020 02:04:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 14:04:04<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-03 , 2020-12-05 , 2020-12-07 , 2020-12-09 , 2020-12-11 , 2020-12-13 , 2020-12-15 , 2020-12-17<br>',  email_sent ='yes', create_date ='2020-12-03 14:04:04', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 02:05:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],update room_rates set stop_sale='3' where supplier_id='S000000241' and hotel_id=53773  and inventory_class_id in ('132') and date_from >='2020-12-31' AND date_from <='2021-12-31' ;
[12/03/2020 02:05:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-12-03 14:05:28',`log_type`= 'Sell Policy',`sql_query`= 'update room_rates set stop_sale=\&#039;3\&#039; where supplier_id=\&#039;S000000241\&#039; and hotel_id=53773  and inventory_class_id in (\&#039;132\&#039;) and date_from &gt;=\&#039;2020-12-31\&#039; AND date_from &lt;=\&#039;2021-12-31\&#039; &lt;br&gt;',`log_description`= 'Updated Sell Policy For hotel RateGainOne- Inventory Room Class:-Standard From:-31-12-2020 To:-31-12-2021 Weekday Policy:-Free Sell Weekend Policy:-Free Sell',`ip`= '60.254.11.202',`username`= 'tfg',`user_id`= 'S000000241';
[12/03/2020 02:05:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4061', `entity`='Hotels', `value`='53773' ;
[12/03/2020 02:05:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4061', `entity`='Suppliers', `value`='S000000241' ;
[12/03/2020 02:05:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4061', `entity`='Inventory', `value`='' ;
[12/03/2020 02:05:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4061', `entity`='Roomclass', `value`='' ;
[12/03/2020 02:05:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 14:05:35',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2021-12-31';
[12/03/2020 02:05:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTQ6MDU6MzU8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTMxICwgMjAyMS0wMS0zMSAsIDIwMjEtMDItMjggLCAyMDIxLTAzLTMxICwgMjAyMS0wNC0zMCAsIDIwMjEtMDUtMzEgLCAyMDIxLTA2LTMwICwgMjAyMS0wNy0zMSAsIDIwMjEtMDgtMzEgLCAyMDIxLTA5LTMwICwgMjAyMS0xMC0zMSAsIDIwMjEtMTEtMzAgLCAyMDIxLTEyLTMxPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 14:05:35';
[12/03/2020 02:05:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 14:05:35<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-31 , 2021-01-31 , 2021-02-28 , 2021-03-31 , 2021-04-30 , 2021-05-31 , 2021-06-30 , 2021-07-31 , 2021-08-31 , 2021-09-30 , 2021-10-31 , 2021-11-30 , 2021-12-31<br>',  email_sent ='yes', create_date ='2020-12-03 14:05:35', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 02:07:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-03' AND date_to= '2020-12-03' AND room_class= '1059' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:07:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1059',room_basis = '1',date_from = '2020-12-03',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_07_36_1607004456_53773.xml',create_date = '2020-12-03 14:07:36';
[12/03/2020 02:07:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 14:07:36',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',room_class_id= '1059',rate_id= '132',start_date= '2020-12-03';
[12/03/2020 02:07:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTQ6MDc6MzY8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTAzPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 14:07:36';
[12/03/2020 02:07:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 14:07:36<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-03<br>',  email_sent ='yes', create_date ='2020-12-03 14:07:36', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 02:07:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-03' AND date_to= '2020-12-03' AND room_class= '1059' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:07:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1059',room_basis = '1',date_from = '2020-12-03',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_07_46_1607004466_53773.xml',create_date = '2020-12-03 14:07:46';
[12/03/2020 02:07:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-04' AND date_to= '2020-12-04' AND room_class= '1059' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:07:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1059',room_basis = '1',date_from = '2020-12-04',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_07_46_1607004466_53773.xml',create_date = '2020-12-03 14:07:46';
[12/03/2020 02:07:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-05' AND date_to= '2020-12-05' AND room_class= '1059' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:07:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1059',room_basis = '1',date_from = '2020-12-05',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_07_46_1607004466_53773.xml',create_date = '2020-12-03 14:07:46';
[12/03/2020 02:07:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-06' AND date_to= '2020-12-06' AND room_class= '1059' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:07:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1059',room_basis = '1',date_from = '2020-12-06',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_07_46_1607004466_53773.xml',create_date = '2020-12-03 14:07:46';
[12/03/2020 02:07:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-07' AND date_to= '2020-12-07' AND room_class= '1059' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:07:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1059',room_basis = '1',date_from = '2020-12-07',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_07_46_1607004466_53773.xml',create_date = '2020-12-03 14:07:46';
[12/03/2020 02:07:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-08' AND date_to= '2020-12-08' AND room_class= '1059' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:07:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1059',room_basis = '1',date_from = '2020-12-08',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_07_46_1607004466_53773.xml',create_date = '2020-12-03 14:07:46';
[12/03/2020 02:07:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-09' AND date_to= '2020-12-09' AND room_class= '1059' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:07:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1059',room_basis = '1',date_from = '2020-12-09',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_07_46_1607004466_53773.xml',create_date = '2020-12-03 14:07:46';
[12/03/2020 02:07:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 14:07:46',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',room_class_id= '1059',rate_id= '132',start_date= '2020-12-03';
[12/03/2020 02:07:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTQ6MDc6NDY8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTAzICwgMjAyMC0xMi0wNCAsIDIwMjAtMTItMDUgLCAyMDIwLTEyLTA2ICwgMjAyMC0xMi0wNyAsIDIwMjAtMTItMDggLCAyMDIwLTEyLTA5PGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 14:07:46';
[12/03/2020 02:07:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 14:07:46<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-03 , 2020-12-04 , 2020-12-05 , 2020-12-06 , 2020-12-07 , 2020-12-08 , 2020-12-09<br>',  email_sent ='yes', create_date ='2020-12-03 14:07:46', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 02:07:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-03' AND date_to= '2020-12-03' AND room_class= '1059' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:07:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1059',room_basis = '1',date_from = '2020-12-03',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_07_54_1607004474_53773.xml',create_date = '2020-12-03 14:07:54';
[12/03/2020 02:07:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-05' AND date_to= '2020-12-05' AND room_class= '1059' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:07:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1059',room_basis = '1',date_from = '2020-12-05',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_07_54_1607004474_53773.xml',create_date = '2020-12-03 14:07:54';
[12/03/2020 02:07:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-07' AND date_to= '2020-12-07' AND room_class= '1059' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:07:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1059',room_basis = '1',date_from = '2020-12-07',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_07_54_1607004474_53773.xml',create_date = '2020-12-03 14:07:54';
[12/03/2020 02:07:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-09' AND date_to= '2020-12-09' AND room_class= '1059' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:07:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1059',room_basis = '1',date_from = '2020-12-09',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_07_54_1607004474_53773.xml',create_date = '2020-12-03 14:07:54';
[12/03/2020 02:07:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-11' AND date_to= '2020-12-11' AND room_class= '1059' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:07:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1059',room_basis = '1',date_from = '2020-12-11',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_07_54_1607004474_53773.xml',create_date = '2020-12-03 14:07:54';
[12/03/2020 02:07:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-13' AND date_to= '2020-12-13' AND room_class= '1059' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:07:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1059',room_basis = '1',date_from = '2020-12-13',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_07_54_1607004474_53773.xml',create_date = '2020-12-03 14:07:54';
[12/03/2020 02:07:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-15' AND date_to= '2020-12-15' AND room_class= '1059' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:07:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1059',room_basis = '1',date_from = '2020-12-15',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_07_54_1607004474_53773.xml',create_date = '2020-12-03 14:07:54';
[12/03/2020 02:07:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-17' AND date_to= '2020-12-17' AND room_class= '1059' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:07:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1059',room_basis = '1',date_from = '2020-12-17',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_07_54_1607004474_53773.xml',create_date = '2020-12-03 14:07:54';
[12/03/2020 02:07:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 14:07:54',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',room_class_id= '1059',rate_id= '132',start_date= '2020-12-17';
[12/03/2020 02:07:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTQ6MDc6NTQ8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTAzICwgMjAyMC0xMi0wNSAsIDIwMjAtMTItMDcgLCAyMDIwLTEyLTA5ICwgMjAyMC0xMi0xMSAsIDIwMjAtMTItMTMgLCAyMDIwLTEyLTE1ICwgMjAyMC0xMi0xNzxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 14:07:55';
[12/03/2020 02:07:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 14:07:54<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-03 , 2020-12-05 , 2020-12-07 , 2020-12-09 , 2020-12-11 , 2020-12-13 , 2020-12-15 , 2020-12-17<br>',  email_sent ='yes', create_date ='2020-12-03 14:07:55', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 02:11:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],update room_rates set stop_sale='0' where supplier_id='S000000241' and hotel_id=53773  and inventory_class_id in ('132') and date_from >='2020-12-31' AND date_from <='2021-12-31' ;
[12/03/2020 02:11:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-12-03 14:11:59',`log_type`= 'Sell Policy',`sql_query`= 'update room_rates set stop_sale=\&#039;0\&#039; where supplier_id=\&#039;S000000241\&#039; and hotel_id=53773  and inventory_class_id in (\&#039;132\&#039;) and date_from &gt;=\&#039;2020-12-31\&#039; AND date_from &lt;=\&#039;2021-12-31\&#039; &lt;br&gt;',`log_description`= 'Updated Sell Policy For hotel RateGainOne- Inventory Room Class:-Standard From:-31-12-2020 To:-31-12-2021 Weekday Policy:-Withdraw Stop/Free Sell Weekend Policy:-Withdraw Stop/Free Sell',`ip`= '60.254.11.202',`username`= 'tfg',`user_id`= 'S000000241';
[12/03/2020 02:11:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4062', `entity`='Hotels', `value`='53773' ;
[12/03/2020 02:11:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4062', `entity`='Suppliers', `value`='S000000241' ;
[12/03/2020 02:11:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4062', `entity`='Inventory', `value`='' ;
[12/03/2020 02:11:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4062', `entity`='Roomclass', `value`='' ;
[12/03/2020 02:12:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 14:12:10',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2021-12-31';
[12/03/2020 02:12:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTQ6MTI6MTA8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTMxICwgMjAyMS0wMS0zMSAsIDIwMjEtMDItMjggLCAyMDIxLTAzLTMxICwgMjAyMS0wNC0zMCAsIDIwMjEtMDUtMzEgLCAyMDIxLTA2LTMwICwgMjAyMS0wNy0zMSAsIDIwMjEtMDgtMzEgLCAyMDIxLTA5LTMwICwgMjAyMS0xMC0zMSAsIDIwMjEtMTEtMzAgLCAyMDIxLTEyLTMxPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 14:12:10';
[12/03/2020 02:12:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 14:12:10<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-31 , 2021-01-31 , 2021-02-28 , 2021-03-31 , 2021-04-30 , 2021-05-31 , 2021-06-30 , 2021-07-31 , 2021-08-31 , 2021-09-30 , 2021-10-31 , 2021-11-30 , 2021-12-31<br>',  email_sent ='yes', create_date ='2020-12-03 14:12:10', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 02:28:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-28' AND date_to= '2021-01-28' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-01-28',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:22';
[12/03/2020 02:28:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-29' AND date_to= '2021-01-29' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-01-29',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:22';
[12/03/2020 02:28:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-30' AND date_to= '2021-01-30' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-01-30',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:22';
[12/03/2020 02:28:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-31' AND date_to= '2021-01-31' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-01-31',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:22';
[12/03/2020 02:28:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-01' AND date_to= '2021-02-01' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-01',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:22';
[12/03/2020 02:28:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-02' AND date_to= '2021-02-02' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-02',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:22';
[12/03/2020 02:28:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-03' AND date_to= '2021-02-03' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-03',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:22';
[12/03/2020 02:28:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-04' AND date_to= '2021-02-04' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-04',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-05' AND date_to= '2021-02-05' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-05',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-06' AND date_to= '2021-02-06' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-06',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-07' AND date_to= '2021-02-07' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-07',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-08' AND date_to= '2021-02-08' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-08',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-09' AND date_to= '2021-02-09' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-09',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-10' AND date_to= '2021-02-10' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-10',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-11' AND date_to= '2021-02-11' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-11',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-12' AND date_to= '2021-02-12' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-12',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-13' AND date_to= '2021-02-13' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-13',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-14' AND date_to= '2021-02-14' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-14',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-15' AND date_to= '2021-02-15' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-15',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-16' AND date_to= '2021-02-16' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-16',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-17' AND date_to= '2021-02-17' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-17',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-18' AND date_to= '2021-02-18' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-18',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-19' AND date_to= '2021-02-19' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-19',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-20' AND date_to= '2021-02-20' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-20',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-21' AND date_to= '2021-02-21' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-21',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-22' AND date_to= '2021-02-22' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-22',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-23' AND date_to= '2021-02-23' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-23',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-24' AND date_to= '2021-02-24' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-24',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-25' AND date_to= '2021-02-25' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-25',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-26' AND date_to= '2021-02-26' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-26',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-27' AND date_to= '2021-02-27' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-27',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-28' AND date_to= '2021-02-28' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-02-28',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-03-01' AND date_to= '2021-03-01' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-03-01',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-03-02' AND date_to= '2021-03-02' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-03-02',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '500000' , weekend_rate= '500000'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-03-03' AND date_to= '2021-03-03' AND room_class= '1044' AND room_basis= '1' AND inventory_class_id= '132';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1044',room_basis = '1',date_from = '2021-03-03',weekday_rate = '500000',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_14_28_22_1607005702_53773.xml',create_date = '2020-12-03 14:28:23';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 14:28:22',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',room_class_id= '1044',rate_id= '132',start_date= '2021-01-28';
[12/03/2020 02:28:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTQ6Mjg6MjI8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIxLTAxLTI4ICwgMjAyMS0wMS0yOSAsIDIwMjEtMDEtMzAgLCAyMDIxLTAxLTMxICwgMjAyMS0wMi0wMSAsIDIwMjEtMDItMDIgLCAyMDIxLTAyLTAzICwgMjAyMS0wMi0wNCAsIDIwMjEtMDItMDUgLCAyMDIxLTAyLTA2ICwgMjAyMS0wMi0wNyAsIDIwMjEtMDItMDggLCAyMDIxLTAyLTA5ICwgMjAyMS0wMi0xMCAsIDIwMjEtMDItMTEgLCAyMDIxLTAyLTEyICwgMjAyMS0wMi0xMyAsIDIwMjEtMDItMTQgLCAyMDIxLTAyLTE1ICwgMjAyMS0wMi0xNiAsIDIwMjEtMDItMTcgLCAyMDIxLTAyLTE4ICwgMjAyMS0wMi0xOSAsIDIwMjEtMDItMjAgLCAyMDIxLTAyLTIxICwgMjAyMS0wMi0yMiAsIDIwMjEtMDItMjMgLCAyMDIxLTAyLTI0ICwgMjAyMS0wMi0yNSAsIDIwMjEtMDItMjYgLCAyMDIxLTAyLTI3ICwgMjAyMS0wMi0yOCAsIDIwMjEtMDMtMDEgLCAyMDIxLTAzLTAyICwgMjAyMS0wMy0wMzxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 14:28:23';
[12/03/2020 02:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 14:28:22<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2021-01-28 , 2021-01-29 , 2021-01-30 , 2021-01-31 , 2021-02-01 , 2021-02-02 , 2021-02-03 , 2021-02-04 , 2021-02-05 , 2021-02-06 , 2021-02-07 , 2021-02-08 , 2021-02-09 , 2021-02-10 , 2021-02-11 , 2021-02-12 , 2021-02-13 , 2021-02-14 , 2021-02-15 , 2021-02-16 , 2021-02-17 , 2021-02-18 , 2021-02-19 , 2021-02-20 , 2021-02-21 , 2021-02-22 , 2021-02-23 , 2021-02-24 , 2021-02-25 , 2021-02-26 , 2021-02-27 , 2021-02-28 , 2021-03-01 , 2021-03-02 , 2021-03-03<br>',  email_sent ='yes', create_date ='2020-12-03 14:28:24', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
