[09/18/2020 08:25:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1600417510','203.192.213.85');
[09/18/2020 08:28:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],insert into bookings SET reservation_id = '1795' ,agent_id = '22' ,confirmation_number = '' ,leader_title = 'Mr' ,leader_first_name = 'Sanket' ,leader_last_name = 'Desai' ,city_id = 'Mumbai' ,country_id = '106' ,nationality= 'Indian',display_room_rate = '' ,display_currency_code = 'USD' ,native_currency_code = 'INR' ,additional_charge = '0' ,cancellation_policy = 'Cancellations or changes made 3 day/s prior to check in ( Noon local hotel time ) will be subject to 1 night/s fee. No- Show/Early Departure is subjected to 1 night/s fee' ,supplier_cancellation_policy = '' ,applied_multiplier = '0' ,applied_markup = '0' ,consultant_id = 'tfg' ,sales_manager_id = '' ,agent_markup = '0' ,subagent_markup = '' ,basecurrency_multiplier = '1' ,basecurrency_multiplier_native = '0.01533' ,agent_currency_multiplier = '1' ,current_status = 'confirmed' ,source_type = 'localsightseeing' ,status_date = '2020-09-18 08:28:10' ,expiration_date = '2020-09-15 00:00:00' ,native_discount = '0',display_discount = '0',service_type = 'sightseeing' ,service_type_detail = 'Essel world' ,service_date = '2020-09-18' ,native_rate = '' ,display_rate = '' ,native_room_rate = '600' ,supplier_rate = '600' ,agent_rate = '' ,sub_agent_rate = '' ,booking_status = '1' ,parent_agent_id = '22' ,supplier_profile_id = '2' ,create_date = '2020-09-18 08:28:10' ,created_datetime = '2020-09-18 08:28:10' ,created_by = 'tfg' ,modified_datetime = '2020-09-18 08:28:10' ,modified_by = 'tfg' ,comment_contract = '' ,booking_type = 'offline'  ,applicable_service_tax = '0', booking_branch_id='1';
[09/18/2020 08:28:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='2949'
        ;
[09/18/2020 08:28:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],insert into sight_bookings(booking_id,sight_id,sight_name,tour_time,tour_dep_point,tour_language,tour_details,tour_inclusive,tour_exclusive,terms_n_condition,meeting_point,emergency_cont_no,comment_contract,arrival_date,total_adults,total_children,display_currency_code,native_currency_code,supplier_id,pick_up_point,drop_off_point,vehicle_type,charge_applied_type,from_slot,to_slot,tour_pickup_type,tour_dropoff_type ,service_tax_id,sub_cat_id,cat_id,no_of_vehicle,adult_rate,child_rate,total_adult_rate,total_child_rate,display_adult_rate,display_child_rate,display_total_adult_rate,display_total_child_rate) values ('2949','20', 'Essel world', '', '', '','','','','','','','', '2020/09/18', '5', '0', 'USD', 'INR', 'S000000202', '28471', '28468', '2', 'private','','','hotels','hotels' ,'2','0','2','3','200','0','1000','','0','0','','');
[09/18/2020 08:28:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],insert into sight_passangers (booking_id,salutations,first_name,last_name,passenger_type) values ('2949', 'Mr', 'Sanket', 'Desai', 'adult');
[09/18/2020 08:28:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],insert into sight_passangers (booking_id,salutations,first_name,last_name,passenger_type) values ('2949', 'Mr', 'ToBeAdvisedAAA', 'Desai', 'adult');
[09/18/2020 08:28:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],insert into sight_passangers (booking_id,salutations,first_name,last_name,passenger_type) values ('2949', 'Mr', 'ToBeAdvisedAAB', 'Desai', 'adult');
[09/18/2020 08:28:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],insert into sight_passangers (booking_id,salutations,first_name,last_name,passenger_type) values ('2949', 'Mr', 'ToBeAdvisedAAC', 'Desai', 'adult');
[09/18/2020 08:28:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],insert into sight_passangers (booking_id,salutations,first_name,last_name,passenger_type) values ('2949', 'Mr', 'ToBeAdvisedAAD', 'Desai', 'adult');
[09/18/2020 08:28:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_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
        ('','','2949','confirmed','2020-09-18 08:28:11','Offline Sightseeing Booking by tfg','tfg','45.120.147.56','tfg','','');
[09/18/2020 08:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logout.php],INSERT INTO psa_login_log set username = 'tfg' , user_type = 'tfg'_type , branch_id = '' , login_datetime = '2020-09-18 08:28:24' , ip = '45.120.147.56' , action = 'Logout'  ;
