[07/30/2020 01:05:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],INSERT INTO history_bookings set history_booking_id ='2792', reservation_id ='QTECH2020071675', agent_id ='25', itenirary_id ='4', confirmation_number ='', payment_confirmation_no ='', voucher_id ='', voucher_hashcode ='', email_id ='', leader_title ='Ms', leader_first_name ='Snehal', leader_last_name ='Test1', city_id ='Mumbai', country_id ='106', display_room_rate ='1.760', native_room_rate ='100.000', display_discount ='0.000', native_discount ='0.000', native_currency_code ='INR', additional_charge ='0.000', cancellation_policy ='', supplier_cancellation_policy ='', current_status ='confirmed', booking_status ='0', status_date ='2020-07-30 10:54:10', create_date ='2020-07-30 10:54:10', source_type ='misc', expiration_date ='2020-08-07 00:00:00', comment_contract ='', admin_note ='', is_payment_gateway ='0', service_type ='misc', service_type_detail ='Breakfast', native_rate ='', display_rate ='', agent_rate ='1.760', wh_sub_agent_rate ='0.000', wh_agent_rate ='0.000', supplier_rate ='100.000', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='nitinalpha', admin_booked ='0', emailed_status ='0', applied_multiplier ='0.01533', applied_markup ='15', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='15', wh_agent_markup ='0.000', basecurrency_multiplier ='1', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='0.01533', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.000', modified_datetime ='2020-07-30 :13:05:10', modified_by ='tfg', service_date ='2020-08-08', display_currency_code ='USD', created_datetime ='2020-07-30 13:05:10', sub_agent_rate ='0.000', 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.44.39';
[07/30/2020 01:05:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],INSERT INTO history_misc_bookings SET  old_ref_id ='505', history_booking_id='2792', service_name='Breakfast', title='Ms', first_name='Snehal', last_name='Test1', email_id='', internal_reference='', no_of_adults='0', no_of_child='', country='106', city='Mumbai', book_for='Misc', no_of_services='1', from_date='2020-08-08', to_date='2020-08-08', preferred_time='Full Day', instructions='', supplier_id='S000000068';
[07/30/2020 01:05:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],UPDATE bookings SET reservation_id = 'QTECH2020071675' ,agent_id = '25' ,backoffice_user = 'tfg' ,city_id = 'Mumbai' ,country_id = '106' ,leader_title = 'Ms' ,leader_first_name = 'Snehal' ,leader_last_name = 'Test1' ,nationality = 'Indian' ,display_room_rate = '0' ,native_discount = '0' ,display_discount = '0' ,display_currency_code = 'USD' ,native_room_rate = '0' ,native_currency_code = 'INR' ,current_status = 'confirmed' ,status_date = '2020-07-30 13:05:10' ,create_date = '2020-07-30 13:05:10' ,source_type = 'misc' ,service_type = 'misc' ,consultant_id = 'tfg' ,sales_manager_id = '' ,applied_multiplier = '0.01533' ,basecurrency_multiplier = '1' ,basecurrency_multiplier_native = '0.01533' ,agent_currency_multiplier = '1' ,created_datetime = '2020-07-30 13:05:10' ,created_by = 'tfg' ,ip_addr = '60.254.44.39' ,booking_type= 'offline', applied_markup = '0' ,agent_markup = '0' ,supplier_rate = '0' ,agent_rate = '0' ,parent_agent_id = '25' ,booking_branch_id = '1' ,service_type_detail = 'Breakfast' ,unit_type = 'Per Room/Per Night' ,unit = '1' ,unit_rate = '150/0' ,check_out_date = '2020-08-08' ,service_date = '2020-08-08' WHERE id= '2792' ;
[07/30/2020 01:05:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],UPDATE misc_bookings SET booking_id = '2792' ,service_name = 'Breakfast' ,country = '106' ,title = 'Ms' ,first_name = 'Snehal' ,last_name = 'Test1' ,city = 'Mumbai' ,book_for = 'Misc' ,no_of_services = '1' ,from_date = '2020-08-08' ,to_date = '2020-08-08' ,service_tax_id = '4' ,sub_service_id = '3' ,hotel_id = '' ,no_of_adults = '' ,no_of_child = '' ,no_of_infant = '' ,supplier_adult_rate = '0' ,supplier_child_rate = '' ,supplier_infant_rate = '' ,agent_adult_rate = '0' ,agent_child_rate = '' ,agent_infant_rate = '' ,supplier_id  = 'S000000068' WHERE mid= '439' ;
[07/30/2020 01:05:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],DELETE FROM passangers WHERE booking_id='2792';
[07/30/2020 01:05:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','2792','confirmed','2020-07-30 13:05:10','Offline Addtional Service Booking by tfg','tfg','60.254.44.39','tfg','','');
[07/30/2020 01:05:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/booking_detail.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 15516 characters]',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/booking_detail.php?booking_id=2792&print_sum=1&reservation_id=QTECH2020071675&print_sum=1&service=misc',create_date= '2020-07-30 13:05:13';
[07/30/2020 01:05:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/booking_detail.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 15516 characters]',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/booking_detail.php?booking_id=2792&print_sum=1&reservation_id=QTECH2020071675&print_sum=1&service=misc',create_date= '2020-07-30 13:05:45';
[07/30/2020 01:16:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_note.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'PGJyPi0tLS0tLS0tLSAKCjxicj5FcnJvcjoKU1FMU1RBVEVbNDJTMjJdOiBDb2x1bW4gbm90IGZvdW5kOiAxMDU0IFVua25vd24gY29sdW1uICdhc3NpZ25lZF90bycgaW4gJ2ZpZWxkIGxpc3QnIGZyb20gT3RyYW1zREIucGhwIG9uIDMwLTA3LTIwMjAgMDE6MTY6MDUKIFF1ZXJ5OklOU0VSVCBJTlRPIG1zZ19ub3RlIHNldCBtZXNzYWdlPSAnVGVzdCcsYm9va2luZ19pZD0gJzI3OTInLHVzZXJfaWQ9ICd0ZmcnLGFzc2lnbmVkX3RvPSAnU2FsZXNDb25zdWx0YW50Jyxub3RlX2RlbGV0ZT0gJ04nLHJlbWluZF9kYXRldGltZT0gJzIwMjAtMDctMzAgMDE6MTU6MDAnICxub3RlX2RhdGV0aW1lPSAnMjAyMC0wNy0zMCAxMzoxNjowNycsc2l0ZV9pZCA9ICcnCgovdG1zL2FkZF9ub3RlLnBocAoKPHByZT4KSG9zdG5hbWU6IHF0ZWNoLm90cmFtcy5jb20KIDxicj4KCkNvbm5lY3Rpb246IG90cmFtc190aGVmYWJAMjA5LjIzNi4xMTQuMTc0CgpCYWNrdHJhY2U6CmFycmF5ICgKICAwID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL090cmFtc0RCLnBocCcsCiAgICAnbGluZScgPT4gMjQ0LAogICAgJ2Z1bmN0aW9uJyA9PiAnd3JpdGVFcnJvcicsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDEgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvY29tbW9uL2Z1bmN0aW9ucy9tZXNzYWdlLmZ1bmMucGhwJywKICAgICdsaW5lJyA9PiA0NjIsCiAgICAnZnVuY3Rpb24nID0+ICdxdWVyeScsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDIgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2FkZF9ub3RlLnBocCcsCiAgICAnbGluZScgPT4gMTExLAogICAgJ2Z1bmN0aW9uJyA9PiAnYWRkTm90ZScsCiAgKSwKICAzID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9hZGRfbm90ZS5waHAnLAogICAgJ2xpbmUnID0+IDc3LAogICAgJ2Z1bmN0aW9uJyA9PiAnYWRkX25vdGUnLAogICksCikKCi90bXMvYWRkX25vdGUucGhwCnVhdC50Zmcub3RyYW1zLm5ldCwgQ2xpZW50IElQOiA2MC4yNTQuNDQuMzk8L3ByZT48YnI+CmFycmF5ICgKICAwID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL090cmFtc0RCLnBocCcsCiAgICAnbGluZScgPT4gMjQ0LAogICAgJ2Z1bmN0aW9uJyA9PiAnd3JpdGVFcnJvcicsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDEgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvY29tbW9uL2Z1bmN0aW9ucy9tZXNzYWdlLmZ1bmMucGhwJywKICAgICdsaW5lJyA9PiA0NjIsCiAgICAnZnVuY3Rpb24nID0+ICdxdWVyeScsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDIgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2FkZF9ub3RlLnBocCcsCiAgICAnbGluZScgPT4gMTExLAogICAgJ2Z1bmN0aW9uJyA9PiAnYWRkTm90ZScsCiAgKSwKICAzID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9hZGRfbm90ZS5waHAnLAogICAgJ2xpbmUnID0+IDc3LAogICAgJ2Z1bmN0aW9uJyA9PiAnYWRkX25vdGUnLAogICksCik=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_note.php',create_date= '2020-07-30 13:16:05';
[07/30/2020 01:19:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_note.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'PGJyPi0tLS0tLS0tLSAKCjxicj5FcnJvcjoKU1FMU1RBVEVbNDJTMjJdOiBDb2x1bW4gbm90IGZvdW5kOiAxMDU0IFVua25vd24gY29sdW1uICdhc3NpZ25lZF90bycgaW4gJ2ZpZWxkIGxpc3QnIGZyb20gT3RyYW1zREIucGhwIG9uIDMwLTA3LTIwMjAgMDE6MTk6MDMKIFF1ZXJ5OklOU0VSVCBJTlRPIG1zZ19ub3RlIHNldCBtZXNzYWdlPSAnVGVzdCcsYm9va2luZ19pZD0gJzI3OTInLHVzZXJfaWQ9ICd0ZmcnLGFzc2lnbmVkX3RvPSAnbml0aW5hbHBoYScsbm90ZV9kZWxldGU9ICdOJyxyZW1pbmRfZGF0ZXRpbWU9ICcyMDIwLTA3LTMwIDAxOjI1OjAwJyAsbm90ZV9kYXRldGltZT0gJzIwMjAtMDctMzAgMTM6MTk6MDcnLHNpdGVfaWQgPSAnJwoKL3Rtcy9hZGRfbm90ZS5waHAKCjxwcmU+Ckhvc3RuYW1lOiBxdGVjaC5vdHJhbXMuY29tCiA8YnI+CgpDb25uZWN0aW9uOiBvdHJhbXNfdGhlZmFiQDIwOS4yMzYuMTE0LjE3NAoKQmFja3RyYWNlOgphcnJheSAoCiAgMCA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9PdHJhbXNEQi5waHAnLAogICAgJ2xpbmUnID0+IDI0NCwKICAgICdmdW5jdGlvbicgPT4gJ3dyaXRlRXJyb3InLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAxID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL2NvbW1vbi9mdW5jdGlvbnMvbWVzc2FnZS5mdW5jLnBocCcsCiAgICAnbGluZScgPT4gNDYyLAogICAgJ2Z1bmN0aW9uJyA9PiAncXVlcnknLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAyID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9hZGRfbm90ZS5waHAnLAogICAgJ2xpbmUnID0+IDExMSwKICAgICdmdW5jdGlvbicgPT4gJ2FkZE5vdGUnLAogICksCiAgMyA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvYWRkX25vdGUucGhwJywKICAgICdsaW5lJyA9PiA3NywKICAgICdmdW5jdGlvbicgPT4gJ2FkZF9ub3RlJywKICApLAopCgovdG1zL2FkZF9ub3RlLnBocAp1YXQudGZnLm90cmFtcy5uZXQsIENsaWVudCBJUDogNjAuMjU0LjQ0LjM5PC9wcmU+PGJyPgphcnJheSAoCiAgMCA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9PdHJhbXNEQi5waHAnLAogICAgJ2xpbmUnID0+IDI0NCwKICAgICdmdW5jdGlvbicgPT4gJ3dyaXRlRXJyb3InLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAxID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL2NvbW1vbi9mdW5jdGlvbnMvbWVzc2FnZS5mdW5jLnBocCcsCiAgICAnbGluZScgPT4gNDYyLAogICAgJ2Z1bmN0aW9uJyA9PiAncXVlcnknLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAyID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9hZGRfbm90ZS5waHAnLAogICAgJ2xpbmUnID0+IDExMSwKICAgICdmdW5jdGlvbicgPT4gJ2FkZE5vdGUnLAogICksCiAgMyA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvYWRkX25vdGUucGhwJywKICAgICdsaW5lJyA9PiA3NywKICAgICdmdW5jdGlvbicgPT4gJ2FkZF9ub3RlJywKICApLAop',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_note.php',create_date= '2020-07-30 13:19:03';
[07/30/2020 01:20:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/search_note.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'PGJyPi0tLS0tLS0tLSAKCjxicj5FcnJvcjoKU1FMU1RBVEVbNDJTMjJdOiBDb2x1bW4gbm90IGZvdW5kOiAxMDU0IFVua25vd24gY29sdW1uICdhc3NpZ25lZF90bycgaW4gJ3doZXJlIGNsYXVzZScgZnJvbSBPdHJhbXNEQi5waHAgb24gMzAtMDctMjAyMCAwMToyMDoyMQogUXVlcnk6U0VMRUNUIG1uLiosIGIuc291cmNlX3R5cGUgIEZST00gbXNnX25vdGUgbW4sIGJvb2tpbmdzIGIgIFdIRVJFIG1uLm5vdGVfZGVsZXRlIT0nWScgQU5EIGIuaWQ9bW4uYm9va2luZ19pZCBBTkQgbW4uc2l0ZV9pZCA9IDAgQU5EIChiLmJvb2tpbmdfY29kZSA9ICdURkc0MDI3OTInIG9yIGIuaWQgPSAnVEZHNDAyNzkyJykgQU5EIGFzc2lnbmVkX3RvIGxpa2UgJyVuaXRpbmFscGhhJScgIE9SREVSIEJZIG1uLm5vdGVfZGF0ZXRpbWUgREVTQwoKL3Rtcy9zZWFyY2hfbm90ZS5waHAKCjxwcmU+Ckhvc3RuYW1lOiBxdGVjaC5vdHJhbXMuY29tCiA8YnI+CgpDb25uZWN0aW9uOiBvdHJhbXNfdGhlZmFiQDIwOS4yMzYuMTE0LjE3NAoKQmFja3RyYWNlOgphcnJheSAoCiAgMCA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9PdHJhbXNEQi5waHAnLAogICAgJ2xpbmUnID0+IDg0LAogICAgJ2Z1bmN0aW9uJyA9PiAnd3JpdGVFcnJvcicsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDEgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvY29tbW9uL2Z1bmN0aW9ucy9tZXNzYWdlLmZ1bmMucGhwJywKICAgICdsaW5lJyA9PiA2MDcsCiAgICAnZnVuY3Rpb24nID0+ICdnZXRSb3dzJywKICAgICdjbGFzcycgPT4gJ090cmFtc0RCJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMiA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvc2VhcmNoX25vdGUucGhwJywKICAgICdsaW5lJyA9PiAxMzMsCiAgICAnZnVuY3Rpb24nID0+ICdnZXROb3RlTGlzdCcsCiAgKSwKKQoKL3Rtcy9zZWFyY2hfbm90ZS5waHAKdWF0LnRmZy5vdHJhbXMubmV0LCBDbGllbnQgSVA6IDYwLjI1NC40NC4zOTwvcHJlPjxicj4KYXJyYXkgKAogIDAgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvT3RyYW1zREIucGhwJywKICAgICdsaW5lJyA9PiA4NCwKICAgICdmdW5jdGlvbicgPT4gJ3dyaXRlRXJyb3InLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAxID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL2NvbW1vbi9mdW5jdGlvbnMvbWVzc2FnZS5mdW5jLnBocCcsCiAgICAnbGluZScgPT4gNjA3LAogICAgJ2Z1bmN0aW9uJyA9PiAnZ2V0Um93cycsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDIgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL3NlYXJjaF9ub3RlLnBocCcsCiAgICAnbGluZScgPT4gMTMzLAogICAgJ2Z1bmN0aW9uJyA9PiAnZ2V0Tm90ZUxpc3QnLAogICksCik=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/search_note.php',create_date= '2020-07-30 13:20:21';
[07/30/2020 01:21:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_note.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'PGJyPi0tLS0tLS0tLSAKCjxicj5FcnJvcjoKU1FMU1RBVEVbNDJTMjJdOiBDb2x1bW4gbm90IGZvdW5kOiAxMDU0IFVua25vd24gY29sdW1uICdhc3NpZ25lZF90bycgaW4gJ2ZpZWxkIGxpc3QnIGZyb20gT3RyYW1zREIucGhwIG9uIDMwLTA3LTIwMjAgMDE6MjE6MDMKIFF1ZXJ5OklOU0VSVCBJTlRPIG1zZ19ub3RlIHNldCBtZXNzYWdlPSAnVGVzdGluZyB0byBiZSBkb25lJyxib29raW5nX2lkPSAnMjc5MicsdXNlcl9pZD0gJ3RmZycsYXNzaWduZWRfdG89ICduaXRpbmFscGhhJyxub3RlX2RlbGV0ZT0gJ04nLHJlbWluZF9kYXRldGltZT0gJzIwMjAtMDctMzAgMDE6MzA6MDAnICxub3RlX2RhdGV0aW1lPSAnMjAyMC0wNy0zMCAxMzoyMTowNycsc2l0ZV9pZCA9ICcnCgovdG1zL2FkZF9ub3RlLnBocAoKPHByZT4KSG9zdG5hbWU6IHF0ZWNoLm90cmFtcy5jb20KIDxicj4KCkNvbm5lY3Rpb246IG90cmFtc190aGVmYWJAMjA5LjIzNi4xMTQuMTc0CgpCYWNrdHJhY2U6CmFycmF5ICgKICAwID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL090cmFtc0RCLnBocCcsCiAgICAnbGluZScgPT4gMjQ0LAogICAgJ2Z1bmN0aW9uJyA9PiAnd3JpdGVFcnJvcicsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDEgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvY29tbW9uL2Z1bmN0aW9ucy9tZXNzYWdlLmZ1bmMucGhwJywKICAgICdsaW5lJyA9PiA0NjIsCiAgICAnZnVuY3Rpb24nID0+ICdxdWVyeScsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDIgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2FkZF9ub3RlLnBocCcsCiAgICAnbGluZScgPT4gMTExLAogICAgJ2Z1bmN0aW9uJyA9PiAnYWRkTm90ZScsCiAgKSwKICAzID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9hZGRfbm90ZS5waHAnLAogICAgJ2xpbmUnID0+IDc3LAogICAgJ2Z1bmN0aW9uJyA9PiAnYWRkX25vdGUnLAogICksCikKCi90bXMvYWRkX25vdGUucGhwCnVhdC50Zmcub3RyYW1zLm5ldCwgQ2xpZW50IElQOiA2MC4yNTQuNDQuMzk8L3ByZT48YnI+CmFycmF5ICgKICAwID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL090cmFtc0RCLnBocCcsCiAgICAnbGluZScgPT4gMjQ0LAogICAgJ2Z1bmN0aW9uJyA9PiAnd3JpdGVFcnJvcicsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDEgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvY29tbW9uL2Z1bmN0aW9ucy9tZXNzYWdlLmZ1bmMucGhwJywKICAgICdsaW5lJyA9PiA0NjIsCiAgICAnZnVuY3Rpb24nID0+ICdxdWVyeScsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDIgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2FkZF9ub3RlLnBocCcsCiAgICAnbGluZScgPT4gMTExLAogICAgJ2Z1bmN0aW9uJyA9PiAnYWRkTm90ZScsCiAgKSwKICAzID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9hZGRfbm90ZS5waHAnLAogICAgJ2xpbmUnID0+IDc3LAogICAgJ2Z1bmN0aW9uJyA9PiAnYWRkX25vdGUnLAogICksCik=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_note.php',create_date= '2020-07-30 13:21:04';
[07/30/2020 01:24:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-07-30 01:24:03',login_attempt=0 where id = '25';
[07/30/2020 01:24:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'PhpTest', user_type = 'A', branch_id = '1', login_datetime = '2020-07-30 13:24:03', ip = '60.254.44.39', action = 'Login' ;
[07/30/2020 01:24:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '60.254.44.39' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/08/05' , departure_date = '2020/08/06' , nationality = '106' , nights = '1' , room_types = '2' , create_date = '2020-07-30 13:24:30' , site_id = '' , country_code = '106' , web_service = '' ;
[07/30/2020 01:24:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-07-30 01:24:34', '', '9e373ed0b0b4ce2ac4d3005d95327a55c81a21d6ea4af980685d78793e01ed84', '356');
[07/30/2020 01:24:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e373ed0b0b4ce2ac4d3005d95327a55c81a21d6ea4af980685d78793e01ed84&xml_user_id=25&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&web_service=no&site_id='
, http_hit_time = '2020-07-30 13:24:33.465'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.375'
, error_description = ''
, memory_used = '7943472'
WHERE id = '2934';
[07/30/2020 01:24:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=9e373ed0b0b4ce2ac4d3005d95327a55c81a21d6ea4af980685d78793e01ed84',
  duration = '1.699',
  merge_duration = '0.003',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.88',
  system_load_5_min = '1.51',
  system_load_15_min = '2.02',
  system_memory_usage = '88.34',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '356') + '8148040',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '356';
[07/30/2020 01:26:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596115576','60.254.44.39');
[07/30/2020 01:26:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Copper Chimney &ndash; Imp Upload', 'mumbai', '106', '25', '', '1', '', 'hotelcancellationpolicy', '2020-07-30 :13:26:17','');
[07/30/2020 01:26:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596115595','60.254.44.39');
[07/30/2020 01:27:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '60.254.44.39' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/08/28' , departure_date = '2020/08/29' , nationality = '106' , nights = '1' , room_types = '2' , create_date = '2020-07-30 13:27:19' , site_id = '' , country_code = '106' , web_service = '' ;
[07/30/2020 01:27:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-07-30 01:27:22', '', '9e373ed0b0b4ce2ac4d3005d95327a55c81a21d6ea4af980685d78793e01ed84', '357');
[07/30/2020 01:27:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e373ed0b0b4ce2ac4d3005d95327a55c81a21d6ea4af980685d78793e01ed84&xml_user_id=25&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&web_service=no&site_id='
, http_hit_time = '2020-07-30 13:27:21.132'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.663'
, error_description = ''
, memory_used = '7943848'
WHERE id = '2935';
[07/30/2020 01:27:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=9e373ed0b0b4ce2ac4d3005d95327a55c81a21d6ea4af980685d78793e01ed84',
  duration = '2.073',
  merge_duration = '0.003',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.85',
  system_load_5_min = '1.45',
  system_load_15_min = '1.93',
  system_memory_usage = '88.39',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '357') + '8148456',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '357';
[07/30/2020 01:27:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596115654','60.254.44.39');
[07/30/2020 01:27:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Copperchimney', 'mumbai', '106', '25', '', '1', '', 'hotelcancellationpolicy', '2020-07-30 :13:27:34','');
[07/30/2020 01:27:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596115669','60.254.44.39');
[07/30/2020 01:27:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Tamasha', 'mumbai', '106', '25', '', '1', '', 'hotelcancellationpolicy', '2020-07-30 :13:27:49','');
[07/30/2020 01:28:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596115688','60.254.44.39');
[07/30/2020 01:28:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Shamiyan', 'mumbai', '106', '25', '', '1', '', 'hotelcancellationpolicy', '2020-07-30 :13:28:08','');
[07/30/2020 01:28:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET agency_name= 'QtechPvt',other_language_agency_name= '',accounting_id= '123',auto_voucher_bookings = '0',outstanding_limit = '0',accounting_name= '',first_name= 'Snehal',middle_name= '',last_name= 'Valanju',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '1000',credit_limit= '1000',credit_distribution= '0',temp_credit_limit= '',address= 'MUmbai',other_language_address= '',city= '64440',pincode= '',country= '106',time_zone_offset= '-10',enable_dst= '',branch_id='1',phone= '12-123456789',mobile= '12-22333134345345',fax= '',currency= '6',email= 'snehal.valanju@qtechsoftwrae.com',website= '',lead_time= '',search_by_multicurrency= '1',debug= '1',profile= '',designation= '',iata_status= '0',iata_number= '',nature_of_business= '0',can_book= '1',sales_manager_id= '',comp_reg_no= '',allow_quotation= '1',can_voucher= '',allow_book_under_cancellation='1',modify_date='2020-07-30 13:28:35',consultant_id= 'SalesConsultant',agency_email= '',acc_name= 'A',acc_email= 'snehal.valanju@qtechsoftware.com',acc_phone= '',man_name= 'B',man_email= '',man_phone= '',res_name= 'C',res_email= '',res_phone= '',remarks= '',apply_service_tax= 'no',allow_ticketing= '',agent_category= '5',can_show_hotels= '' WHERE id= '25';
[07/30/2020 01:28:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-30 13:28:35',`log_type`= 'Agent Updated',`sql_query`= 'UPDATE agents SET agency_name= \&#039;QtechPvt\&#039;,other_language_agency_name= \&#039;\&#039;,accounting_id= \&#039;123\&#039;,auto_voucher_bookings = \&#039;0\&#039;,outstanding_limit = \&#039;0\&#039;,accounting_name= \&#039;\&#039;,first_name= \&#039;Snehal\&#039;,middle_name= \&#039;\&#039;,last_name= \&#039;Valanju\&#039;,agent_type= \&#039;CC\&#039;,sort_type= \&#039;price\&#039;,credit_limit_assigned= \&#039;1000\&#039;,credit_limit= \&#039;1000\&#039;,credit_distribution= \&#039;0\&#039;,temp_credit_limit= \&#039;\&#039;,address= \&#039;MUmbai\&#039;,other_language_address= \&#039;\&#039;,city= \&#039;64440\&#039;,pincode= \&#039;\&#039;,country= \&#039;106\&#039;,time_zone_offset= \&#039;-10\&#039;,enable_dst= 0,branch_id=\&#039;1\&#039;,phone= \&#039;12-123456789\&#039;,mobile= \&#039;12-22333134345345\&#039;,fax= \&#039;\&#039;,currency= \&#039;6\&#039;,email= \&#039;snehal.valanju@qtechsoftwrae.com\&#039;,website= \&#039;\&#039;,lead_time= 0,search_by_multicurrency= 1,debug= \&#039;1\&#039;,profile= \&#039;\&#039;,designation= \&#039;\&#039;,iata_status= \&#039;0\&#039;,iata_number= \&#039;\&#039;,nature_of_business= \&#039;0\&#039;,can_book= \&#039;1\&#039;,sales_manager_id= \&#039;\&#039;,comp_reg_no= \&#039;\&#039;,allow_quotation= \&#039;1\&#039;,can_voucher= ,allow_book_under_cancellation=\&#039;1\&#039;,modify_date=\&#039;2020-07-30 13:28:35\&#039;,consultant_id= \&#039;SalesConsultant\&#039;,agency_email= \&#039;\&#039;,acc_name= \&#039;A\&#039;,acc_email= \&#039;snehal.valanju@qtechsoftware.com\&#039;,acc_phone= \&#039;\&#039;,man_name= \&#039;B\&#039;,man_email= \&#039;\&#039;,man_phone= \&#039;\&#039;,res_name= \&#039;C\&#039;,res_email= \&#039;\&#039;,res_phone= \&#039;\&#039;,remarks= \&#039;\&#039;,apply_service_tax= \&#039;no\&#039;,allow_ticketing= 0,agent_category= \&#039;5\&#039;,can_show_hotels= 0 WHERE id= \&#039;25\&#039;',`log_description`= 'Agent 25 updated For  - modify_date=2020-07-25+11%3A24%3A56&debug=&allow_book_under_cancellation=0 changed to - modify_date=2020-07-30+13%3A28%3A35&debug=1&allow_book_under_cancellation=1',`ip`= '60.254.44.39';
[07/30/2020 01:28:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='3450', `entity`='Agents', `value`='25' ;
[07/30/2020 01:28:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'25' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?;
[07/30/2020 01:28:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '1000.000',credit_usage= '0.000',credit_limit= '1000',receipt_id= '',amount= '',ip='60.254.44.39',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Edit_Agent',note='Agent Edited by tfg',create_date='2020-07-30 13:07:35';
[07/30/2020 01:28:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET currency= '6',branch_id= '1',consultant_id= 'SalesConsultant',sales_manager_id= '',profile= '', auto_voucher_bookings = '0', outstanding_limit = '0', agent_type= 'CC' WHERE parent_agent= '25';
[07/30/2020 01:28:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '60.254.44.39' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/08/28' , departure_date = '2020/08/29' , nationality = '106' , nights = '1' , room_types = '2' , create_date = '2020-07-30 13:28:59' , site_id = '' , country_code = '106' , web_service = '' ;
[07/30/2020 01:29:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-07-30 01:29:02', '', '9e373ed0b0b4ce2ac4d3005d95327a55c81a21d6ea4af980685d78793e01ed84', '358');
[07/30/2020 01:29:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e373ed0b0b4ce2ac4d3005d95327a55c81a21d6ea4af980685d78793e01ed84&xml_user_id=25&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&web_service=no&site_id='
, http_hit_time = '2020-07-30 13:29:01.531'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '2.306'
, error_description = ''
, memory_used = '8021056'
WHERE id = '2936';
[07/30/2020 01:29:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=9e373ed0b0b4ce2ac4d3005d95327a55c81a21d6ea4af980685d78793e01ed84',
  duration = '2.698',
  merge_duration = '0.005',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.58',
  system_load_5_min = '1.20',
  system_load_15_min = '1.78',
  system_memory_usage = '88.40',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '358') + '8148328',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '358';
[07/30/2020 01:29:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596115755','60.254.44.39');
[07/30/2020 01:29:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Sharda', 'mumbai', '106', '25', '', '1', '', 'hotelcancellationpolicy', '2020-07-30 :13:29:15','');
[07/30/2020 01:29:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596115762','60.254.44.39');
[07/30/2020 01:30:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596115807','60.254.44.39');
[07/30/2020 01:33:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/edit_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596115989','60.254.44.39');
[07/30/2020 01:33:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596116008','60.254.44.39');
[07/30/2020 01:34:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-07-30 01:34:22', '', '', '');
[07/30/2020 01:34:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-07-30 01:34:40', '', '', '');
[07/30/2020 01:35:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-07-30 01:35:45', '', '', '');
[07/30/2020 01:36:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO bookings SET agent_id = '25' , service_type = 'hotel' , reservation_id = '1685' , display_currency_code = 'USD' , created_datetime='2020-07-30 13:36:23' , create_date='2020-07-30 13:36:23' , created_by ='tfg' , sales_manager_id ='' , consultant_id = 'tfg' , backoffice_user = 'tfg', city_id='Mumbai', country_id='106', leader_title='Mrs', leader_first_name='Snehal', leader_last_name='BE', nationality='Indian', site_id='0', supplier_profile_id='1', comment_contract='', supplier_cancellation_policy='', special_remark='', source_type='localsystem', booking_type='offline', booking_branch_id='1', service_type_detail='TangyIndia';
[07/30/2020 01:36:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='2793'
        ;
[07/30/2020 01:36:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into bookings_details set booking_id ='2793' , hotel_id='53759' , hotel_name='TangyIndia' , hotel_address1='Test Address' , hotel_phone='+605 - 1234 5677' , hotel_rating='4.0';
[07/30/2020 01:36:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '2793', booking_detail_id = '1095', room_type_code = '', room_name = 'single', meal_basis = 'Bed & Breakfast', room_category = 'Single', room_type_description = 'Single (Bed & Breakfast)', display_nightly_rates = 'a:1:{i:0;a:1:{s:18:"displayNightlyRate";s:4:"1000";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:4:"1000";}}' ,native_room_rate_total = '1000' ,display_room_rate_total = '1000' ,number_of_rooms = '1';
[07/30/2020 01:36:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '2793', booking_detail_id = '1095', salutations = 'Ms', room = '', rid = '1665', first_name = 'Snehal', last_name = 'BE' ,age = '';
[07/30/2020 01:36:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='123',voucher_id='',voucher_hashcode='',native_currency_code='USD',cancellation_policy='Cancellation or charges made on/after 27-07-2020 will be subject to FULL CHARGE.',supplier_cancellation_policy='',applied_multiplier='1',applied_markup='0',consultant_id='tfg',basecurrency_multiplier='1',basecurrency_multiplier_native='1'_native,agent_currency_multiplier='1',current_status='confirmed',status_date='2020-07-30 13:36:23',service_date='2020-07-30',check_out_date='2020-07-31',display_room_rate= '1000',display_discount='0',native_room_rate= '1000',native_discount='0',additional_charge='',expiration_date= '2020-07-27 05:30:00',source_type='localsystem',free_sale='yes',special_comment='',admin_note='' WHERE id='2793';
[07/30/2020 01:36:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings set  parent_agent_id='25', sub_agent_rate='', agent_rate='1000', applicable_service_tax='', agent_markup='0', supplier_rate='1000' where id='2793';
[07/30/2020 01:36:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings_details set total_nights='1', supplier_id= 'S000000228',arrival_date='2020/07/30',departure_date='2020/07/31',rate_code='~', total_rooms= '1', total_adults= '1', total_children= '0', total_infants= '0' where booking_id ='2793';
[07/30/2020 01:36:23], [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
        ('','','2793','confirmed','2020-07-30 13:36:23','confirmed by tfg','tfg','60.254.44.39','tfg','','');
[07/30/2020 01:36:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/booking_detail.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 15492 characters]',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/booking_detail.php?booking_id=2793&reservation_id=QTECH2020071685&onload=1&service=hotel',create_date= '2020-07-30 13:36:25';
[07/30/2020 01:37:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='123456',status_date='2020-07-30 13:37:37',current_status='vouchered',voucher_hashcode='32a1dc327804b5ccf8b3aef036100447942972793',vouchered_by ='tfg' where id='2793';
[07/30/2020 01:37:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2793',config_key='VOUCHER_DATE', config_value='2020-07-30 13:37:37',create_date='2020-07-30 13:37:37';
[07/30/2020 01:37:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO autogenerator_invoice_number (id, number) VALUES ('','1596116257');
[07/30/2020 01:37:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/364' where id='2793' and is_invoiced!='yes';
[07/30/2020 01:37:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('1000'),   credit_value= credit_value-('1000') ,  cd_credit_usage=cd_credit_usage+('1000') , cd_credit_value=cd_credit_value-('1000')  WHERE id = '25';
[07/30/2020 01:37:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '0.000',credit_usage= '1000.000',credit_limit= '1000',receipt_id= '',amount= '1000',booking_id='2793',booking_cost= '1000',receipt_allocation= '',balance= '1000',ip='60.254.44.39',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-07-30 13:07:37';
[07/30/2020 01:37:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='0',sub_agent_price='0',supplier_currency='USD',supplier_price='1000',supplier_type='offline',supplier_id='S000000228',acc_type='purchase',accounting_multiplier='1.00000',booking_id='2793',booking_log='Booking Invoiced',type='Sale',create_date='2020-07-30 13:37:37',account_invoice='2020/364',particulars='';
[07/30/2020 01:37:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='1000',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='1.00000',booking_id='2793',booking_log='Booking Invoiced',type='Sale',create_date='2020-07-30 13:37:37',account_invoice='2020/364',particulars='';
[07/30/2020 01:37:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1296;
[07/30/2020 01:37:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1296',booking_id= '2793',invoice_number= '2020/364',service_type= 'hotel',booking_type= 'offline',service_name= 'TangyIndia',type= 'sale',room_type= 'single',quantity_room= '1',from_date= '2020/07/30',to_date= '2020/07/31',quantity= '1',price= '1000',total_price= '1000';
[07/30/2020 01:37:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'The Fabulous Getaway Tax Dispute(TaxInvoice)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'Rm9yIEZvbGxvd2luZyBib29raW5nIFRheCBpcyBub3QgaW5zZXJ0ZWQ8YnI+Qm9va2luZ0lkOi0yNzkzPGJyPkludm9pY2Ugbm86LTIwMjAvMzY0PGJyPmJyYW5jaF9pZDotMTxicj5UeXBlOi1hZ2VudDxicj5BY2NvdW50IHR5cGU6LXNhbGU8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-07-30 13:37:38';
[07/30/2020 01:37:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php], insert into email_trigger set  subject ='The Fabulous Getaway Tax Dispute',  message='For Following booking Tax is not inserted<br>BookingId:-2793<br>Invoice no:-2020/364<br>branch_id:-1<br>Type:-agent<br>Account type:-sale<br>',  email_sent ='yes', create_date ='2020-07-30 13:37:38', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='TaxInvoice';
[07/30/2020 01:37:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/364',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 26312 characters]',to_email_id= 'ankita.rao@qtechsoftware.com,snehal.valanju@qtechsoftwrae.com,snehal.valanju@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-07-30 13:37:39';
[07/30/2020 01:37:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','2793','vouchered-invoiced','2020-07-30 13:37:39',' by tfg','tfg','60.254.44.39','tfg','','');
[07/30/2020 01:37:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2793',booking_detail_id ='2793',agent_id ='25',is_sub_agent ='N',parent_id ='',display_commission ='0',display_currency ='USD',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 0 %',create_date ='2020-07-30 13:37:39';
[07/30/2020 01:37:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2793',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[07/30/2020 01:37:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','2793','vouchered','2020-07-30 13:37:39','Vouchered By tfg by tfg','tfg','60.254.44.39','tfg','','');
[07/30/2020 01:37:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG102793 /  Booking Vouchered ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 27460 characters]',to_email_id= 'snehal.valanju@qtechsoftwrae.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-07-30 13:37:40';
[07/30/2020 01:37:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('2793','snehal.valanju@qtechsoftwrae.com');
[07/30/2020 01:37:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('2793','ankita.rao@qtechsoftware.com');
[07/30/2020 01:37:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/booking_detail.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 15492 characters]',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/booking_detail.php?booking_id=2793&reservation_id=QTECH2020071685&onload=1&service=hotel',create_date= '2020-07-30 13:37:43';
[07/30/2020 01:40:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('2793','example1@test.com');
[07/30/2020 01:40:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('2793','example2@test.com');
[07/30/2020 01:40:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('2793','example3@test.com');
[07/30/2020 01:40:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('2793','example1@test.com');
[07/30/2020 01:40:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('2793','example2@test.com');
[07/30/2020 01:40:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('2793','example3@test.com');
[07/30/2020 01:40:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('2793','example@test.com');
[07/30/2020 01:40:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into email_logs SET `subject`= ' TFG102793 / Booking Confirmed ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 37424 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/resend_email.php?action=send_custom_booking_email',create_date= '2020-07-30 13:40:52';
[07/30/2020 01:41:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/booking_detail.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 15492 characters]',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/booking_detail.php?booking_id=2793&reservation_id=QTECH2020071685&service=hotel&onload=1',create_date= '2020-07-30 13:41:14';
[07/30/2020 01:41:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='2793', agent_id ='25', itenirary_id ='', sequence = '', confirmation_number ='123', payment_confirmation_no ='', voucher_id ='123456', voucher_hashcode ='32a1dc327804b5ccf8b3aef036100447942972793', email_id ='', leader_title ='Mrs', leader_first_name ='Snehal', leader_last_name ='BE', city_id ='Mumbai', country_id ='106', display_room_rate ='1000.000', native_room_rate ='1000.000', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='Cancellation or charges made on/after 27-07-2020 will be subject to FULL CHARGE.', supplier_cancellation_policy ='', current_status ='vouchered', booking_status ='0', status_date ='2020-07-30 13:37:37', create_date ='2020-07-30 13:36:23', source_type ='localsystem', expiration_date ='2020-07-27 05:30:00', comment_contract ='', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='TangyIndia', native_rate ='', display_rate ='', agent_rate ='1000.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='0.000', supplier_rate ='1000.000', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='tfg', admin_booked ='0', emailed_status ='0', applied_multiplier ='1', applied_markup ='0', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='0', wh_agent_markup ='0.000', basecurrency_multiplier ='1', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='1', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='1', wh_agent_currency_multiplier ='1.000', modified_datetime ='2020-07-30 13:41:58', modified_by ='tfg', display_currency_code ='USD', created_datetime ='2020-07-30 13:41:58', sub_agent_rate ='0.000', discount_to_sub ='0', created_by ='tfg', site_id ='0', applicable_service_tax ='0.000', wh_parent_agent_id ='0', wh_agent_id ='0', nationality ='Indian', ip_addr ='';
[07/30/2020 01:41:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='1095', old_reff_id ='506', booking_id ='2793', supplier_id ='S000000228', total_nights ='1', arrival_date ='2020/07/30', departure_date ='2020/07/31', hotel_id ='53759', hotel_name ='TangyIndia', hotel_address1 ='Test Address', hotel_phone ='+605 - 1234 5677', hotel_rating ='4.0', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[07/30/2020 01:41:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '5901', old_reff_id = '506', booking_id = '2793', booking_detail_id = '1095', salutations = 'Ms', room = '0', rid = '1665', first_name = 'Snehal', last_name = 'BE' ,passenger_type = 'adult' ,age = '';
[07/30/2020 01:41:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[07/30/2020 01:41:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '1665', old_reff_id = '506', booking_id = '2793', booking_detail_id = '1095', room_type_code = '', room_name = 'single', room_type_description = 'Single (Bed & Breakfast)', display_nightly_rates = 'a:1:{i:0;a:1:{s:18:"displayNightlyRate";s:4:"1000";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:4:"1000";}}' ,native_room_rate_total = '1000' ,display_room_rate_total = '1000' ,wh_room_rate_total = '' ,number_of_rooms = '1';
[07/30/2020 01:41:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[07/30/2020 01:41:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[07/30/2020 01:43:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='2793', agent_id ='25', itenirary_id ='', sequence = '', confirmation_number ='123', payment_confirmation_no ='', voucher_id ='123456', voucher_hashcode ='32a1dc327804b5ccf8b3aef036100447942972793', email_id ='', leader_title ='Mrs', leader_first_name ='Snehal', leader_last_name ='BE', city_id ='Mumbai', country_id ='106', display_room_rate ='1000.000', native_room_rate ='1000.000', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='Cancellation or charges made on/after 27-07-2020 will be subject to FULL CHARGE.', supplier_cancellation_policy ='', current_status ='vouchered', booking_status ='0', status_date ='2020-07-30 13:37:37', create_date ='2020-07-30 13:36:23', source_type ='localsystem', expiration_date ='2020-07-27 05:30:00', comment_contract ='', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='TangyIndia', native_rate ='', display_rate ='', agent_rate ='1000.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='0.000', supplier_rate ='1000.000', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='tfg', admin_booked ='0', emailed_status ='0', applied_multiplier ='1', applied_markup ='0', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='0', wh_agent_markup ='0.000', basecurrency_multiplier ='1', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='1', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='1', wh_agent_currency_multiplier ='1.000', modified_datetime ='2020-07-30 13:43:04', modified_by ='tfg', display_currency_code ='USD', created_datetime ='2020-07-30 13:43:04', sub_agent_rate ='0.000', discount_to_sub ='0', created_by ='tfg', site_id ='0', applicable_service_tax ='0.000', wh_parent_agent_id ='0', wh_agent_id ='0', nationality ='Indian', ip_addr ='';
[07/30/2020 01:43:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='1095', old_reff_id ='507', booking_id ='2793', supplier_id ='S000000228', total_nights ='1', arrival_date ='2020/07/30', departure_date ='2020/07/31', hotel_id ='53759', hotel_name ='TangyIndia', hotel_address1 ='Test Address', hotel_phone ='+605 - 1234 5677', hotel_rating ='4.0', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[07/30/2020 01:43:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[07/30/2020 01:43:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[07/30/2020 01:43:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[07/30/2020 01:45:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/booking_detail.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 15500 characters]',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/booking_detail.php?booking_id=2793&reservation_id=QTECH2020071685&print_sum=1&service=hotel',create_date= '2020-07-30 13:45:22';
[07/30/2020 01:47:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/manage_documents.php],INSERT INTO business_documents SET entity_id = '2793',document_type = 'sasa',entity_type = 'booking',display_filename = 'index.jpg',disk_filename  = '3d21bb76b03b71a8b9605a119fb31e67dafbc4405c843b9d48116788d1dccafa.jpg',create_date_time  = '2020/07/30',mime_type  = 'image/jpeg',backoffice_user  = 'tfg';
[07/30/2020 01:48:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='2793', agent_id ='25', itenirary_id ='', sequence = '', confirmation_number ='123', payment_confirmation_no ='', voucher_id ='123456', voucher_hashcode ='32a1dc327804b5ccf8b3aef036100447942972793', email_id ='', leader_title ='Mrs', leader_first_name ='Snehal', leader_last_name ='BE', city_id ='Mumbai', country_id ='106', display_room_rate ='1000.000', native_room_rate ='1000.000', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='Cancellation or charges made on/after 27-07-2020 will be subject to FULL CHARGE.', supplier_cancellation_policy ='', current_status ='vouchered', booking_status ='0', status_date ='2020-07-30 13:37:37', create_date ='2020-07-30 13:36:23', source_type ='localsystem', expiration_date ='2020-07-27 05:30:00', comment_contract ='', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='TangyIndia', native_rate ='', display_rate ='', agent_rate ='1000.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='0.000', supplier_rate ='1000.000', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='tfg', admin_booked ='0', emailed_status ='0', applied_multiplier ='1', applied_markup ='0', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='0', wh_agent_markup ='0.000', basecurrency_multiplier ='1', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='1', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='1', wh_agent_currency_multiplier ='1.000', modified_datetime ='2020-07-30 13:48:06', modified_by ='tfg', display_currency_code ='USD', created_datetime ='2020-07-30 13:48:06', sub_agent_rate ='0.000', discount_to_sub ='0', created_by ='tfg', site_id ='0', applicable_service_tax ='0.000', wh_parent_agent_id ='0', wh_agent_id ='0', nationality ='Indian', ip_addr ='';
[07/30/2020 01:48:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='1095', old_reff_id ='508', booking_id ='2793', supplier_id ='S000000228', total_nights ='1', arrival_date ='2020/07/30', departure_date ='2020/07/31', hotel_id ='53759', hotel_name ='TangyIndia', hotel_address1 ='Test Address', hotel_phone ='+605 - 1234 5677', hotel_rating ='4.0', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[07/30/2020 01:48:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[07/30/2020 01:48:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[07/30/2020 01:48:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
