[12/03/2020 07:00:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='3072', agent_id ='24', itenirary_id ='3072', sequence = '', confirmation_number ='', payment_confirmation_no ='', voucher_id ='Test123', voucher_hashcode ='5f8d3e5fcc7d4307823e56fed4e4a8ba682843072', email_id ='deep.mishra@rategain.com', leader_title ='Mr', leader_first_name ='DeepModify', leader_last_name ='MishraModify', city_id ='mumbai', country_id ='106', display_room_rate ='120.450', native_room_rate ='120.450', native_currency_code ='AED', additional_charge ='0.000', cancellation_policy ='Amendment of Dates, Room Category, Passenger Names are considered as Cancel and Rebook by most of the Hotels.
        Any Changes in initial booking may be denied by the supplier or may result in extra charges.
        Confirmation of amendment requests is subject to availablity and rates at the time of amendment.&lt;Br&gt;&lt;Br&gt;&lt;B&gt;&lt;U&gt;Detailed Cancellation Policy:&lt;/U&gt;&lt;/B&gt; &lt;br/&gt; Cancellation Charges of 440 AED applicable if cancelled after 03 Dec 2020 12:14 hrs.                                ', supplier_cancellation_policy ='', current_status ='vouchered', booking_status ='1', status_date ='2020-12-03 06:50:17', create_date ='2020-12-03 06:45:15', source_type ='localsystem', expiration_date ='2020-12-03 06:45:00', comment_contract ='', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='RATEGAINONE', native_rate ='', display_rate ='', agent_rate ='120.450', wh_sub_agent_rate ='0.000', wh_agent_rate ='120.450', supplier_rate ='120.450', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='tfg', admin_booked ='1', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='0', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='0', wh_agent_markup ='0.000', basecurrency_multiplier ='0.27222', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='0.27222', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='0.27222', wh_agent_currency_multiplier ='1.000', modified_datetime ='2020-12-03 07:00:29', modified_by ='tfg', display_currency_code ='AED', created_datetime ='2020-12-03 07:00:29', sub_agent_rate ='0.000', discount_to_sub ='', created_by ='tfg', site_id ='0', applicable_service_tax ='0.000', wh_parent_agent_id ='0', wh_agent_id ='0', nationality ='Indian', ip_addr ='60.254.11.202';
[12/03/2020 07:00:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='1210', old_reff_id ='544', booking_id ='3072', supplier_id ='S000000241', total_nights ='1', arrival_date ='2021/06/03', departure_date ='2021/06/04', hotel_id ='53773', hotel_name ='RATEGAINONE', hotel_address1 ='Mumbai', hotel_phone ='123456789', hotel_rating ='5.0', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='rategain', reservation_pushed ='0', gtaToken ='';
[12/03/2020 07:00:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '6412', old_reff_id = '544', booking_id = '3072', booking_detail_id = '1210', salutations = 'Mr', room = '0', rid = '1809', first_name = 'DeepModify', last_name = 'MishraModify' ,passenger_type = 'adult' ,age = '';
[12/03/2020 07:00:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[12/03/2020 07:00:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '1809', old_reff_id = '544', booking_id = '3072', booking_detail_id = '1210', room_type_code = '1~~~132~~~1039~~~1~~~~~~~~~64440~~~0~~~S000000241', room_name = 'single', room_type_description = 'Standard -Bed & Breakfast : 1 Pax -D', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:6:"120.45";s:13:"whNightlyRate";s:6:"120.45";}}' ,native_nightly_rates = 'a:1:{i:0;a:3:{s:17:"nativeNightlyRate";s:6:"120.45";s:19:"O_nativeNightlyRate";i:440;s:14:"Discount/Offer";a:7:{s:4:"code";s:0:"";s:4:"Name";s:0:"";s:7:"S_Value";s:0:"";s:5:"Value";i:0;s:12:"Display_Name";s:0:"";s:10:"Offer_Note";N;s:10:"Offer_Type";N;}}}' ,native_room_rate_total = '120.45' ,display_room_rate_total = '120.45' ,wh_room_rate_total = '' ,number_of_rooms = '1';
[12/03/2020 07:00:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[12/03/2020 07:00:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[12/03/2020 07:00:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '3072', booking_detail_id = '1210', room_type_code = '1~~~132~~~1039~~~1~~~~~~~~~64440~~~0~~~S000000241', room_name = 'single', meal_basis = '', room_type_description = 'Standard -Bed & Breakfast : 1 Pax -D', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:6:"120.45";s:13:"whNightlyRate";s:6:"120.45";}}' ,native_nightly_rates = 'a:1:{i:0;a:3:{s:17:"nativeNightlyRate";s:6:"120.45";s:19:"O_nativeNightlyRate";i:440;s:14:"Discount/Offer";a:7:{s:4:"code";s:0:"";s:4:"Name";s:0:"";s:7:"S_Value";s:0:"";s:5:"Value";i:0;s:12:"Display_Name";s:0:"";s:10:"Offer_Note";N;s:10:"Offer_Type";N;}}}' ,native_room_rate_total = '120.45' ,display_room_rate_total = '120.45' ,number_of_rooms = '1';
[12/03/2020 07:00:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '3072', booking_detail_id = '1210', salutations = 'Mr', room = '', rid = '1810', first_name = 'DeepModify', last_name = 'MishraModify' ,age = '';
[12/03/2020 07:00:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='',native_currency_code='AED',display_currency_code='AED',cancellation_policy='Amendment of Dates, Room Category, Passenger Names are considered as Cancel and Rebook by most of the Hotels.
        Any Changes in initial booking may be denied by the supplier or may result in extra charges.
        Confirmation of amendment requests is subject to availablity and rates at the time of amendment.&lt;Br&gt;&lt;Br&gt;&lt;B&gt;&lt;U&gt;Detailed Cancellation Policy:&lt;/U&gt;&lt;/B&gt; &lt;br/&gt; Cancellation Charges of 440 AED applicable if cancelled after 03 Dec 2020 12:14 hrs.                                                                ',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',consultant_id='tfg',basecurrency_multiplier='0.27222',basecurrency_multiplier_native='0.27222'_native,agent_currency_multiplier='0.27222',service_type_detail='RATEGAINONE',current_status='vouchered',status_date='2020-12-03 07:00:29',service_date='2021-06-03',check_out_date='2021-06-04',display_room_rate= '120.45',display_discount='0.000',modified_datetime='2020-12-03 07:00:29',modified_by ='tfg',native_room_rate='120.45',native_discount='0.000',additional_charge='0.000',applicable_service_tax='',leader_title='Mr',leader_first_name='DeepModify',leader_last_name='MishraModify',nationality ='Indian',accounts_processed ='0',booking_type ='online',agent_ref_no ='',supplier_profile_id ='1',expiration_date= '2020-12-03 06:45:00',source_type='localsystem',leader_phone='+123451914108628',admin_note='',comment_contract='' WHERE id='3072';
[12/03/2020 07:00:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-12-03 07:00:29',`log_type`= 'Accounts Data Added',`sql_query`= '',`log_description`= 'Accounts Only : Data Added by \&#039;tfg\&#039; From IP \&#039;60.254.11.202\&#039; for booking \&#039;3072\&#039;',`ip`= '60.254.11.202';
[12/03/2020 07:00:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings set  parent_agent_id='24', sub_agent_rate='', agent_rate='120.45', agent_markup='0', supplier_rate='120.45', wh_sub_agent_rate='', discount_to_sub='', wh_agent_rate='120.45' where id='3072';
[12/03/2020 07:00:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings_details set total_nights='1' , supplier_id= 'S000000241' , total_rooms= '1', arrival_date='2021/06/03', departure_date='2021/06/04', rate_code='~', hotel_address1='Mumbai', hotel_name='RATEGAINONE', hotel_phone='123456789', reservation_pushed='2' where booking_id ='3072';
[12/03/2020 07:00:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3072','vouchered','2020-12-03 07:00:29','Booking Modified by tfg','tfg','60.254.11.202','tfg','','');
[12/03/2020 07:00:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1520;
[12/03/2020 07:00:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO accounts_invoice_transaction SET bid= '1520',booking_id= '3072',invoice_number= '2020/399',service_type= 'hotel',booking_type= 'online',service_name= 'RATEGAINONE',type= 'sale',room_type= 'single',quantity_room= '1',from_date= '2021/06/03',to_date= '2021/06/04',quantity= '1',price= '120.45',total_price= '120.45';
[12/03/2020 07:00:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update booking_rate_info set acc_export='0' WHERE booking_id='3072' AND (acc_type='purchase' OR  acc_type='sale');
[12/03/2020 07:00:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update booking_currency_multiplier set multiplier='1.00000' where booking_id='3072' and from_currency='AED' and to_currency='AED';
[12/03/2020 07:00:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/channel_manager_push_reservation.php],update bookings_details set reservation_pushed = '0', channel_manager = 'rategain',room_type_description='' where booking_id = '3072';
[12/03/2020 07:52:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '20'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-03' AND inventory_class_id= '132123';
[12/03/2020 07:52:27], [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 = '132123',room_basis = '',date_from = '2020-12-03',availability = '20',type = 'availability',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_07_52_27_1606981947_53773.xml',create_date = '2020-12-03 07:52:27';
[12/03/2020 07:52:27], [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 07:52:27',channel_manager_name= 'rategain',hotel_id= '53773',rate_id= '132123',start_date= '2020-12-03';
[12/03/2020 07:52:27], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMDc6NTI6Mjc8YnI+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 07:52:27';
[12/03/2020 07:52:27], [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 07:52:27<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 07:52:27', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 07:54:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '20'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-03' AND inventory_class_id= '132123';
[12/03/2020 07:54:06], [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 = '132123',room_basis = '',date_from = '2020-12-03',availability = '20',type = 'availability',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_07_54_06_1606982046_53773.xml',create_date = '2020-12-03 07:54:06';
[12/03/2020 07:54:06], [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 07:54:06',channel_manager_name= 'rategain',hotel_id= '53773',rate_id= '132123',start_date= '2020-12-03';
[12/03/2020 07:54:06], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMDc6NTQ6MDY8YnI+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 07:54:06';
[12/03/2020 07:54:06], [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 07:54:06<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 07:54:06', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 07:58:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '20'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-03' AND inventory_class_id= '132123';
[12/03/2020 07:58:29], [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 = '132123',room_basis = '',date_from = '2020-12-03',availability = '20',type = 'availability',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_07_58_29_1606982309_53773.xml',create_date = '2020-12-03 07:58:29';
[12/03/2020 07:58:29], [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 07:58:29',channel_manager_name= 'rategain',hotel_id= '53773',rate_id= '132123',start_date= '2020-12-03';
[12/03/2020 07:58:29], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMDc6NTg6Mjk8YnI+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 07:58:29';
[12/03/2020 07:58:29], [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 07:58:29<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 07:58:29', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
