[02/06/2023 11:53:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],INSERT INTO history_bookings set history_booking_id ='3178', reservation_id ='RDT2022072003', agent_id ='21', itenirary_id ='4', confirmation_number ='', payment_confirmation_no ='', voucher_id ='', voucher_hashcode ='', email_id ='', leader_title ='Mr', leader_first_name =' sanjay', leader_last_name ='soni', city_id ='Mumbai', country_id ='106', display_room_rate ='3000.000', native_room_rate ='50.000', display_discount ='0.000', native_discount ='0.000', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='', supplier_cancellation_policy ='', current_status ='confirmed', booking_status ='0', status_date ='2023-02-03 10:33:34', create_date ='2023-02-03 10:33:34', source_type ='misc', expiration_date ='2023-02-03 00:00:00', comment_contract ='', admin_note ='', is_payment_gateway ='0', service_type ='misc', service_type_detail ='Misc', native_rate ='', display_rate ='', agent_rate ='3000.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='0.000', supplier_rate ='50.000', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='tfg', admin_booked ='0', emailed_status ='0', applied_multiplier ='60', applied_markup ='0', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='0', wh_agent_markup ='0.000', basecurrency_multiplier ='0.01533', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='1', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.000', modified_datetime ='2023-02-06 :11:53:01', modified_by ='tfg', service_date ='2023-02-27', display_currency_code ='INR', created_datetime ='2023-02-06 11:53:01', 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 ='59.88.84.145';
[02/06/2023 11:53:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],INSERT INTO history_misc_bookings SET  old_ref_id ='563', history_booking_id='3178', service_name='Misc', title='Mr', first_name=' sanjay', last_name='soni', email_id='', internal_reference='', no_of_adults='0', no_of_child='', country='106', city='Mumbai', book_for='Misc', no_of_services='1', from_date='2023-02-27', to_date='2023-02-27', preferred_time='Full Day', instructions='', supplier_id='S000000003';
[02/06/2023 11:53:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],UPDATE bookings SET reservation_id = 'RDT2022072003' ,agent_id = '21' ,backoffice_user = 'tfg' ,city_id = 'Mumbai' ,country_id = '106' ,leader_title = 'Mr' ,leader_first_name = ' sanjay' ,leader_last_name = 'soni' ,nationality = 'Indian' ,display_room_rate = '3000.00' ,native_discount = '0' ,display_discount = '0' ,display_currency_code = 'INR' ,native_room_rate = '50.00' ,native_currency_code = 'USD' ,current_status = 'confirmed' ,status_date = '2023-02-06 11:53:01' ,create_date = '2023-02-06 11:53:01' ,source_type = 'localsystem' ,service_type = 'misc' ,consultant_id = 'tfg' ,sales_manager_id = '' ,itenirary_id = '' ,confirmation_number = '' ,applied_multiplier = '60' ,basecurrency_multiplier = '0.01533' ,basecurrency_multiplier_native = '1' ,agent_currency_multiplier = '1' ,created_datetime = '2023-02-06 11:53:01' ,created_by = 'tfg' ,ip_addr = '59.88.90.251' ,booking_type= 'offline', applied_markup = '0' ,agent_markup = '0' ,supplier_rate = '50.00' ,agent_rate = '3000.00' ,parent_agent_id = '21' ,booking_branch_id = '3' ,service_type_detail = 'Misc' ,unit_type = 'Per Room/Per Night' ,unit = '1' ,unit_rate = '50/0' ,check_out_date = '2023-02-27' ,service_date = '2023-02-27' WHERE id= '3178' ;
[02/06/2023 11:53:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],UPDATE misc_bookings SET booking_id = '3178' ,service_name = 'Misc' ,country = '106' ,title = 'Mr' ,first_name = ' sanjay' ,last_name = 'soni' ,city = 'Mumbai' ,book_for = 'Misc' ,no_of_services = '1' ,from_date = '2023-02-27' ,to_date = '2023-02-27' ,service_tax_id = '4' ,sub_service_id = '' ,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 = '' ,per_supplier_child_rate = '' ,per_supplier_infant_rate = '' ,per_agent_child_rate = '' ,per_agent_infant_rate = '' ,supplier_id  = 'localsystem' WHERE mid= '477' ;
[02/06/2023 11:53:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],DELETE FROM passangers WHERE booking_id='3178';
[02/06/2023 11:53:01], [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
        ('','','3178','confirmed','2023-02-06 11:53:01','Offline Addtional Service Booking by tfg','tfg','59.88.90.251','tfg','','');
