[08/04/2020 07:21:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/branch.php],update  `psa_branches` set logo='' where id=1;
[08/04/2020 07:24:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/branch.php],update  `psa_branches` set  `branch_name`= 'Qtech', `email_address`= 'ankita.rao@qtechsoftware.com', `accountant_email_address`= 'ankita.rao@qtechsoftware.com', `location_phone`= '2111111111', `location_addr`= '', `bank_address`= '', `location_country`= '106', `location_city`= '64440', `branch_location`= 'Mumbai', `modify_by`= 'tfg', `modify_date`= '2020-08-04 07:24:06', `updated`= '2020-08-04 07:24:06', `site_id`= '', `logo`= '55b95e760e910c7c7ed2aa7d1b8432df_branch_logo.jpeg', `txt_tax_no`= '123456', `branch_markup`= '', `is_booking_email_received`= '', `active`='Y'  where `id` = '1' ;
[08/04/2020 07:24:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/branch.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-04 07:24:06',`log_type`= 'Branch',`sql_query`= 'update  `psa_branches` set  `branch_name`= :branch_name, `email_address`= :email_address, `accountant_email_address`= :accountant_email_address, `location_phone`= :location_phone, `location_addr`= :location_addr, `bank_address`= :bank_address, `location_country`= :location_country, `location_city`= :location_city, `branch_location`= :branch_location, `modify_by`= :modify_by, `modify_date`= :modify_date, `updated`= :updated, `site_id`= :site_id, `logo`= :logo, `txt_tax_no`= :tax_no, `branch_markup`= :branch_markup, `is_booking_email_received`= :is_booking_email_received, `active`=:active  where `id` = :branch_id ',`log_description`= 'Branch Qtech updated For  - updated=2019-06-17+05%3A06%3A23&modify_by=otrams&modify_date=2019-06-17+05%3A06%3A23&logo= changed to - updated=2020-08-04+07%3A24%3A06&modify_by=tfg&modify_date=2020-08-04+07%3A24%3A06&logo=55b95e760e910c7c7ed2aa7d1b8432df_branch_logo.jpeg',`ip`= '150.129.30.134';
[08/04/2020 07:25:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_sight.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'PGJyPi0tLS0tLS0tLSAKCjxicj5FcnJvcjoKU1FMU1RBVEVbNDJTMjJdOiBDb2x1bW4gbm90IGZvdW5kOiAxMDU0IFVua25vd24gY29sdW1uICd2ZWhpY2xlX2lkJyBpbiAnZmllbGQgbGlzdCcgZnJvbSBPdHJhbXNEQi5waHAgb24gMDQtMDgtMjAyMCAwNzoyNToyMQogUXVlcnk6U0VMRUNUIHZlaGljbGVfaWQgRlJPTSBib29raW5nc19wYWNrYWdlcyBXSEVSRSBib29raW5nX2lkPScwJyBBTkQgc2VydmljZV9pZD0nMjcnIEFORCBzdXBwbGllcl9pZD0nUzAwMDAwMDA2OCcKCi90bXMvdmlld19ib29raW5nX3NpZ2h0LnBocD9hY3Rpb25fbmFtZT12aWV3X3NpZ2h0X2Jvb2tpbmdfbW9kaWZpY2F0aW9uJmJvb2tpbmdfaWQ9Mjc5NgoKPHByZT4KSG9zdG5hbWU6IHF0ZWNoLm90cmFtcy5jb20KIDxicj4KCkNvbm5lY3Rpb246IG90cmFtc190aGVmYWJAMjA5LjIzNi4xMTQuMTc0CgpCYWNrdHJhY2U6CmFycmF5ICgKICAwID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL090cmFtc0RCLnBocCcsCiAgICAnbGluZScgPT4gMTI2LAogICAgJ2Z1bmN0aW9uJyA9PiAnd3JpdGVFcnJvcicsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDEgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvU2lnaHRfQm9va2luZy5waHAnLAogICAgJ2xpbmUnID0+IDEwOTksCiAgICAnZnVuY3Rpb24nID0+ICdnZXRWYXInLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAyID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy92aWV3X2Jvb2tpbmdfc2lnaHQucGhwJywKICAgICdsaW5lJyA9PiAxMSwKICAgICdmdW5jdGlvbicgPT4gJ3ZpZXdfc2lnaHRfYm9va2luZ19tb2RpZmljYXRpb24nLAogICAgJ2NsYXNzJyA9PiAnU2lnaHRfQm9va2luZycsCiAgICAndHlwZScgPT4gJy0+JywKICApLAopCgovdG1zL3ZpZXdfYm9va2luZ19zaWdodC5waHA/YWN0aW9uX25hbWU9dmlld19zaWdodF9ib29raW5nX21vZGlmaWNhdGlvbiZib29raW5nX2lkPTI3OTYKdWF0LnRmZy5vdHJhbXMubmV0LCBDbGllbnQgSVA6IDE1MC4xMjkuMzAuMTM0PC9wcmU+PGJyPgphcnJheSAoCiAgMCA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9PdHJhbXNEQi5waHAnLAogICAgJ2xpbmUnID0+IDEyNiwKICAgICdmdW5jdGlvbicgPT4gJ3dyaXRlRXJyb3InLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAxID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL1NpZ2h0X0Jvb2tpbmcucGhwJywKICAgICdsaW5lJyA9PiAxMDk5LAogICAgJ2Z1bmN0aW9uJyA9PiAnZ2V0VmFyJywKICAgICdjbGFzcycgPT4gJ090cmFtc0RCJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMiA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvdmlld19ib29raW5nX3NpZ2h0LnBocCcsCiAgICAnbGluZScgPT4gMTEsCiAgICAnZnVuY3Rpb24nID0+ICd2aWV3X3NpZ2h0X2Jvb2tpbmdfbW9kaWZpY2F0aW9uJywKICAgICdjbGFzcycgPT4gJ1NpZ2h0X0Jvb2tpbmcnLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKKQ==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/view_booking_sight.php?action_name=view_sight_booking_modification&booking_id=2796',create_date= '2020-08-04 07:25:21';
[08/04/2020 07:32:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_sight.php],INSERT INTO history_bookings set history_booking_id = '2796', agent_id = '25', itenirary_id = '3', sequence = '3', confirmation_number = '', payment_confirmation_no = '', voucher_id = '', voucher_hashcode = '', email_id = '', leader_title = 'Ms', leader_first_name = 'Snehal', leader_last_name = 'Valanju', city_id = 'Mumbai', country_id = '106', display_room_rate = '575.000', native_room_rate = '400.000', native_currency_code = 'USD', additional_charge = '0.000', cancellation_policy = '', supplier_cancellation_policy = '', current_status = 'confirmed', booking_status = '1', status_date = '2020-08-04 06:04:15', create_date = '2020-08-04 06:04:15', source_type = 'localsightseeing', expiration_date = '0000-00-00 00:00:00', service_date = '2020-08-10', comment_contract = '', admin_note = '', is_payment_gateway = '0', service_type = 'sightseeing', service_type_detail = 'sightseeing'_detail, native_rate = '', display_rate = '', agent_rate = '575.000', wh_sub_agent_rate = '0.000'  , wh_agent_rate = '0.000'  , supplier_rate = '400.000'  , special_comment = '', special_remark = '', sms_status = '', is_xml = '0', consultant_id = 'tfg', admin_booked = '0', emailed_status = '0', applied_multiplier = '1.00000', wh_applied_markup = '0.000'  , applied_markup = '43.75', original_voucher = '', subagent_markup = '', agent_markup = '43.75', wh_agent_markup = '0.000'  , basecurrency_multiplier = '1', wh_basecurrency_multiplier = '1'  , basecurrency_multiplier_native = '1'_native, wh_basecurrency_multiplier_native = '1'_native  , agent_currency_multiplier = '1.00000', wh_agent_currency_multiplier = '1.000'  , created_datetime = '2020-08-04 06:04:15', created_by = 'tfg', modified_datetime = '2020-08-04 06:04:15', modified_by = 'tfg', display_currency_code = 'USD'  , sub_agent_rate = '0.000'  , site_id = '0'  , wh_parent_agent_id = '0'  , wh_agent_id = '0'  , nationality = 'Indian'  , ip_addr = '' , applicable_service_tax = '0.000';
[08/04/2020 07:32:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_sight.php],INSERT INTO history_sight_bookings set booking_id = '2796', old_reff_id  = '509',  gtaToken = '', sight_id = '27', sight_name = 'RidetoGatewayOfIndia', tour_time = '', tour_dep_point = '', tour_language = '', tour_duration = '', arrival_date = '2020/08/10', total_adults = '2', total_children = '0', total_infants = '', booking_remark = '', additional_tour_dep_point = '', rate_description = '', display_nightly_rates = '', display_currency_code = 'USD', native_nightly_rates = '', native_currency_code = 'USD', admin_note = '', payment_received = '0', is_payment_gateway = '0', gta_item_confirm_ref = '', tour_supplier_phone = '', tour_supplier = '', supplier_id = 'S000000068', pick_up_point = '', drop_off_point = '', from_slot = '4:00', to_slot = '8:00', adult_rate = '200.000', child_rate = '0.000', total_adult_rate = '400.000', total_child_rate = '0.000', display_adult_rate = '287.500', display_child_rate = '0.000', display_total_adult_rate = '575.000', display_total_child_rate = '0.000';
[08/04/2020 07:32:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_sight.php],INSERT INTO history_sight_passengers set history_passenger_id = '1274', old_reff_id = '509', booking_id = '2796', salutations = 'Ms', tour = '', first_name = 'Snehal', last_name = 'Valanju' ,passenger_type = 'adult' ,age = '';
[08/04/2020 07:32:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_sight.php],INSERT INTO history_sight_passengers set history_passenger_id = '1275', old_reff_id = '509', booking_id = '2796', salutations = 'Mr', tour = '', first_name = 'ToBeAdvisedA', last_name = 'ToBeAdvisedA' ,passenger_type = 'adult' ,age = '';
[08/04/2020 07:32:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_sight.php],UPDATE bookings SET confirmation_number = '' ,voucher_id='',voucher_hashcode='',city_id= 'Mumbai',country_id= '106',nationality= 'Indian',service_type_detail= 'RidetoGatewayOfIndia',native_currency_code = 'USD' ,cancellation_policy = '' ,leader_title  = 'Ms' ,leader_first_name  = 'Snehal' ,leader_last_name  = 'Valanju',supplier_cancellation_policy = '' ,applied_multiplier = '1.00000' ,applied_markup = '43.75' ,agent_markup = '43.75' ,consultant_id = 'tfg' ,basecurrency_multiplier = '1' ,basecurrency_multiplier_native = '1' ,agent_currency_multiplier = '1.00000' ,current_status = 'confirmed' ,status_date = '2020-08-04 07:32:48' ,display_room_rate = '1150' ,native_room_rate = '800' ,native_rate = '',display_rate = '',agent_rate = '1150' ,sub_agent_rate = '' ,additional_charge = '0.000' ,service_date = '2020-08-10' ,check_out_date = '2020-08-10' ,supplier_profile_id = '2' ,expiration_date=  '2020-08-04 18:32:20',booking_type ='offline',source_type = 'localsightseeing' ,applicable_service_tax = '0.000' ,comment_contract = '' WHERE id = '2796';
[08/04/2020 07:32:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_sight.php],update bookings set parent_agent_id='25',supplier_rate='800' where id='2796';
[08/04/2020 07:32:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_sight.php],UPDATE sight_bookings SET sight_id='27' ,sight_name='RidetoGatewayOfIndia' ,arrival_date='2020-08-10' ,supplier_id='S000000068' ,from_slot='04:00' ,to_slot='08:00' ,total_adults='2' ,total_children='0' ,tour_details='' ,meeting_point='' ,tour_inclusive='' ,tour_exclusive='' ,comment_contract=' ' ,adult_rate='400',child_rate='0',total_adult_rate='800',total_child_rate='',display_adult_rate='575',display_child_rate='0',display_total_adult_rate='1150',display_total_child_rate='',tour_dep_point='',pick_up_point='',drop_off_point='',vehicle_type='',charge_applied_type='',tour_pickup_type='hotels',tour_dropoff_type='hotels' where booking_id = '2796' ;
[08/04/2020 07:32:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_sight.php],delete from sight_passangers where booking_id ='2796';
[08/04/2020 07:32:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_sight.php],insert into sight_passangers set  booking_id = '2796' , salutations = 'Ms' , first_name = 'Snehal' , last_name = 'Valanju' , age = '' ;
[08/04/2020 07:32:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_sight.php],insert into sight_passangers set  booking_id = '2796' , salutations = 'Mr' , first_name = 'ToBeAdvisedA' , last_name = 'ToBeAdvisedA' , age = '' ;
[08/04/2020 07:32:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_sight.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','2796','confirmed','2020-08-04 07:32:49','Booking Modified  by tfg','tfg','45.120.147.56','tfg','','');
[08/04/2020 07:38:52], [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 ='0.000', native_room_rate ='0.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 13:05:10', create_date ='2020-07-30 13:05: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 ='0.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='0.000', supplier_rate ='0.000', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='tfg', admin_booked ='0', emailed_status ='0', applied_multiplier ='0.01533', 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 ='0.01533', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='1', wh_agent_currency_multiplier ='1.000', modified_datetime ='2020-08-04 :07:38:52', modified_by ='tfg', service_date ='2020-08-08', display_currency_code ='USD', created_datetime ='2020-08-04 07:38:52', 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';
[08/04/2020 07:38:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],INSERT INTO history_misc_bookings SET  old_ref_id ='510', 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='0', 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';
[08/04/2020 07:38:52], [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 = '3.07' ,native_discount = '0' ,display_discount = '0' ,display_currency_code = 'USD' ,native_room_rate = '200' ,native_currency_code = 'INR' ,current_status = 'confirmed' ,status_date = '2020-08-04 07:38:52' ,create_date = '2020-08-04 07:38:52' ,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-08-04 07:38:52' ,created_by = 'tfg' ,ip_addr = '150.129.30.134' ,booking_type= 'offline', applied_markup = '0' ,agent_markup = '0' ,supplier_rate = '200' ,agent_rate = '3.07' ,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' ;
[08/04/2020 07:38:52], [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 = '200' ,supplier_child_rate = '' ,supplier_infant_rate = '' ,agent_adult_rate = '3.07' ,agent_child_rate = '' ,agent_infant_rate = '' ,supplier_id  = 'S000000068' WHERE mid= '439' ;
[08/04/2020 07:38:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],DELETE FROM passangers WHERE booking_id='2792';
[08/04/2020 07:38:52], [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-08-04 07:38:52','Offline Addtional Service Booking by tfg','tfg','150.129.30.134','tfg','','');
[08/04/2020 07:58:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_note.php],INSERT INTO msg_reminder set message_id= '7',remind_to= 'tfg',remind_datetime= '2020-08-04 07:57:00';
[08/04/2020 07:58:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_note.php],UPDATE msg_note set remind_datetime= '2020-08-04 07:57:00' where id= '7';
[08/04/2020 07:59:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_note.php],UPDATE msg_note set remind_datetime= '2020-08-13 02:27:00' where id= '7';
[08/04/2020 07:59:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_note.php],UPDATE msg_reminder set remind_datetime= '2020-08-13 02:27:00' where message_id= '7';
[08/04/2020 07:59:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_note.php],UPDATE msg_note set remind_datetime= '2020-08-09 20:57:00' where id= '7';
[08/04/2020 07:59:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_note.php],UPDATE msg_reminder set remind_datetime= '2020-08-09 20:57:00' where message_id= '7';
