[09/13/2021 05:17:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],INSERT INTO history_bookings set history_booking_id = '3144', agent_id = '22', parent_agent_id = '22', wh_parent_agent_id = '0', itenirary_id = '3', sequence = '3', confirmation_number = '', payment_confirmation_no = '', voucher_id = '', voucher_hashcode = '', email_id = 'ankita.rao@qtechsoftware.com', leader_title = 'Ms', leader_first_name = 'Shiba', leader_last_name = 'Test', city_id = 'Colombo', country_id = '132', nationality = 'Indian', display_room_rate = '8.730', native_room_rate = '67.500', native_currency_code = 'INR', display_currency_code = 'MYR', additional_charge = '0.000', cancellation_policy = '', supplier_cancellation_policy = '', current_status = 'confirmed', booking_status = '1', status_date = '2021-08-26 18:15:06', create_date = '2021-08-26 18:15:06', source_type = 'localtransfer', expiration_date = '2021-08-25 18:30:00', service_date = '2020-11-11', comment_contract = '', admin_note = '', is_payment_gateway = '0', service_type = 'transfer', service_type_detail = 'Srilanka Transfer Test', native_rate = '', display_rate = '', applicable_service_tax = '0.000', special_comment = '', special_remark = '', sms_status = '', is_xml = '0', consultant_id = 'tfg', admin_booked = '0', emailed_status = '0', applied_multiplier = '0.06468', applied_markup = '100', original_voucher = '', subagent_markup = '', agent_markup = '100', agent_rate = '8.730', sub_agent_rate = '0.000', supplier_rate = '67.500', basecurrency_multiplier = '0.23694', basecurrency_multiplier_native = '0.01533', agent_currency_multiplier = '0.23694', created_datetime = '', created_by = 'tfg', modified_datetime = '', modified_by = '', ip_addr = '';
[09/13/2021 05:17:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],insert into history_transfer_bookings  set  old_reff_id  = '558', booking_id = '3144' ,transfer_date = '2020-11-11' ,country_code = '132' ,city_code = '71100' ,pickup = 'O' ,pickup_code = '' ,dropoff = 'O' ,dropoff_code = '' ,no_of_pass = '4' ,pick_up_time = '09.00' ,dropoff_time = '15.30' ,item_content = 'Srilanka Transfer Test' ,sel_arr_from = 'Colombo' ,flight_number = '' ,dropoff_to_hotel = '' ,dropoff_station = '' ,dropoff_station_train = '' ,dropoff_station_destination = '' ,dest_flight_no = '' ,flight_destination = '' ,dropoff_port_shipname = '' ,dropoff_port_shipcompany = '' ,dropoff_port_shipdestination = '' ,pickup_acc_address1 = '' ,pickup_acc_address2 = '' ,pickup_acc_country = '' ,pickup_acc_postcode = '' ,pickup_acc_phone = '' ,dropoff_acc_address1 = '' ,dropoff_acc_address2 = '' ,dropoff_acc_country = '' ,dropoff_acc_postcode = '' ,dropoff_acc_phone = '' ,dropoff_other_address1 = 'Steuarts Tea Shop, Navam Mawatha, Colombo, Sri Lanka' ,dropoff_other_address2 = '' ,dropoff_other_country = 'Sri Lanka' ,dropoff_other_postcode = '' ,dropoff_other_phone = '' ,Error= '',Item_Confirm_Ref='',airport_arriving_from = '' ,arriving_flight_number = '' ,pickup_from_hotel = '' ,pickup_station_arriving_from = '' ,pickup_station_train_name = '' ,pickup_station_arriving_station = '' ,pickup_port_arriving_from = '' ,pickup_port_ship_name = '' ,pickup_port_shipping_company = '' ,pickup_other_address1 = 'Airport Expressway, Colombo - Katunayake Expressway, Katunayake, Sri Lanka' ,pickup_other_address2 = '' ,pickup_other_country = 'Sri Lanka' ,pickup_other_postcode = '' ,pickup_other_phone = '' ,travel_duration = '3 hr 0 min ' ,supplier_id = 'S000000066' ,supplier_profile= '6',parking_fee = '' ,guide_cost = '' ,driver_tips = '' ,representative_cost = '' ,touristic_entrance = '' ,adult_charge = '' ,child_charge = '' ,tariff_code= '';
[09/13/2021 05:17:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],insert into history_transfer_vehicles set  old_reff_id  = '558',  booking_id  = '3144' , vehicle_code  = '4' , vehicle_name  = 'VAN 4 SEATER' , max_luggage  = '2' , max_passenger  = '4' , sel_passenger  = '4' , no_of_adult  = '2' , no_of_child  = '2' , lead_name  = 'Ms Shiba Test' , lead_phone  = '' , adult_rate  = '0' , child_rate  = '0' , parking_fee  = '' , driver_tips  = '' , representative_cost  = '' , guide_cost  = '' , touristic_fee  = '' , vehicle_native_price  = '67.50' , native_price  = '67.5' , display_price  = '8.73' , native_surcharge  = '' , display_surcharge  = '' ;
[09/13/2021 05:17:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],UPDATE bookings SET confirmation_number= '',voucher_id='',voucher_hashcode='',native_currency_code= 'INR',cancellation_policy= '',supplier_cancellation_policy= '',applied_multiplier= '0.06468',applied_markup= 'nan',agent_markup= 'nan',consultant_id= 'tfg',city_id= 'Colombo',country_id= '132',nationality= 'Indian',service_type_detail= 'Srilanka Transfer Test',basecurrency_multiplier='0.23694',basecurrency_multiplier_native= '0.23694'_native,agent_currency_multiplier= '0.23694',current_status= 'confirmed',status_date= '2021-09-13 17:17:58',display_room_rate= '0.00',check_out_date= '2021-03-25',service_date= '2021-03-25',native_room_rate= '0.00',display_rate= '0.00',applicable_service_tax= '0.000',native_rate= '0.00',native_discount= '',display_discount= '',modified_datetime= '2021-09-13 17:17:58',modified_by= 'tfg',comment_contract= '',booking_type ='offline',expiration_date= '2021-08-25 18:30:00',source_type= 'localtransfer',supplier_profile_id= '6' WHERE id= '3144';
[09/13/2021 05:17:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],UPDATE bookings SET  sub_agent_rate='0', agent_rate='0', applicable_service_tax='0.000', supplier_rate='0', leader_title='Ms', leader_first_name='Shiba', leader_last_name='Test', leader_phone='' where id='3144';
[09/13/2021 05:17:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],DELETE FROM bookings_tax WHERE booking_id =3144;
[09/13/2021 05:17:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],UPDATE transfer_bookings SET transfer_date = '2021-03-25',supplier_id = 'S000000066',supplier_profile = '6',charge_applied_type = 'private_per_km',country_code = '132',city_code = '71100',item_code = '183',item_content = 'Srilanka Transfer Test',vehicle_type = '4' ,calculated_distance = '135' ,no_of_pass = '4' where booking_id= '3144';
[09/13/2021 05:17:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],DELETE FROM transfer_vehicles WHERE booking_id ='3144';
[09/13/2021 05:17:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],insert into transfer_vehicles set  booking_id = '3144',vehicle_code = '4' ,vehicle_name = 'VAN 4 SEATER' ,max_passenger = '4' ,max_luggage = '2' , sel_passenger = '4', no_of_adult = '2', no_of_child = '2', lead_name = 'Ms Shiba Test', lead_phone = '', adult_rate = '0', child_rate = '0', parking_fee = '0', driver_tips = '0', representative_cost = '0', guide_cost = '0', touristic_fee = '0', vehicle_native_price = '0.00', native_price = '0', display_price = '0.00', native_surcharge = '0', display_surcharge = '0.00', wh_display_price = '', wh_surcharge = '';
[09/13/2021 05:17:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3144','confirmed','2021-09-13 17:17:59','Transfer Booking TFG303144 Modified by tfg','tfg','43.239.53.130','tfg','','');
[09/13/2021 05:17:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2021-09-13 17:17:59',`log_type`= 'Transfer Booking Modified',`sql_query`= 'UPDATE bookings SET  sub_agent_rate=\&#039;0\&#039;, agent_rate=\&#039;0\&#039;, applicable_service_tax=\&#039;0.000\&#039;, supplier_rate=\&#039;0\&#039;, leader_title=\&#039;Ms\&#039;, leader_first_name=\&#039;Shiba\&#039;, leader_last_name=\&#039;Test\&#039;, leader_phone=\&#039;\&#039; where id=\&#039;3144\&#039;',`log_description`= 'Tranfer Booking Modified Booking_id = TFG303144',`ip`= '43.239.53.130';
