[08/27/2020 06:26:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],INSERT INTO history_bookings set history_booking_id = '2811', agent_id = '25', parent_agent_id = '25', wh_parent_agent_id = '0', itenirary_id = '', sequence = '', confirmation_number = '12345678', payment_confirmation_no = '', voucher_id = '2811', voucher_hashcode = 'b1e90288493196568f80ce1bc278f43c780442811', email_id = '', leader_title = 'Ms', leader_first_name = 'Mr Sanket ', leader_last_name = 'Desai', city_id = 'Mumbai', country_id = '106', nationality = 'Indian', display_room_rate = '19.320', native_room_rate = '1000.000', native_currency_code = 'INR', display_currency_code = 'USD', additional_charge = '0.000', cancellation_policy = 'Cancellation Charges will be applicable if cancelled after 11-Aug-2020 14:00 hrs.&lt;BR&gt;Late Amendment Charges may apply.&lt;Br&gt;&lt;Br&gt;&lt;B&gt;&lt;U&gt;Detailed Cancellation Policy:&lt;/U&gt;&lt;/B&gt;  Cancellation Charges of 2.41 USD applicable if cancelled after 27-Jul-2020 14:00 hrs.&lt;br&gt; Cancellation Charges of 0.1 USD applicable if cancelled after 11-Aug-2020 14:00 hrs.&lt;br&gt; Cancellation Charges of 3.86 USD applicable if cancelled after 16-Aug-2020 14:00 hrs.&lt;br&gt; Cancellation Charges of 4.83 USD applicable if cancelled after 21-Aug-2020 14:00 hrs.&lt;br&gt; Cancellation Charges of 7.73 USD applicable if cancelled after 24-Aug-2020 14:00 hrs.&lt;br&gt;', supplier_cancellation_policy = '', current_status = 'vouchered', booking_status = '1', status_date = '2020-08-27 05:50:04', create_date = '2020-08-10 06:45:27', source_type = 'localtransfer', expiration_date = '2020-08-11 14:00:00', service_date = '2020-08-27', comment_contract = 'Bhandardara Lake is one of the most amazing and highly favorite camping and picnic spots for the lovers of nature. Located near Igatpuri in the Western Ghats of India, it is a hotspot of tourism for its natural beauty and the attractions nearby like the many hills, waterfalls, Wilson dam, and Arthur Lake. This camp by the lake is a great place to stay and enjoy a getaway in the lap of nature. Compl.', admin_note = '', is_payment_gateway = '0', service_type = 'transfer', service_type_detail = 'Mumbai Darshan', native_rate = '0.00', display_rate = '0.00', 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.01533', applied_markup = '26.00', original_voucher = '', subagent_markup = '', agent_markup = '26.00', agent_rate = '19.320', sub_agent_rate = '0.000', supplier_rate = '1000.000', basecurrency_multiplier = '1.00000', basecurrency_multiplier_native = '0.01533', agent_currency_multiplier = '1.00000', created_datetime = '', created_by = '', modified_datetime = '2020-08-27 05:50:05', modified_by = 'tfg', ip_addr = '45.120.147.56';
[08/27/2020 06:26:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],insert into history_transfer_bookings  set  old_reff_id  = '515', booking_id = '2811' ,transfer_date = '2020-08-27' ,country_code = '106' ,city_code = '64440' ,pickup = 'H' ,pickup_code = '' ,dropoff = 'A' ,dropoff_code = '' ,no_of_pass = '1' ,pick_up_time = '.' ,dropoff_time = '' ,item_content = 'Mumbai Darshan' ,sel_arr_from = '' ,flight_number = '' ,dropoff_to_hotel = 'A' ,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 = '' ,dropoff_other_address2 = '' ,dropoff_other_country = '' ,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 = '' ,pickup_other_address2 = '' ,pickup_other_country = '' ,pickup_other_postcode = '' ,pickup_other_phone = '' ,travel_duration = '4 hr 0 mins ' ,supplier_id = 'S000000068' ,supplier_profile= '6',parking_fee = '' ,guide_cost = '' ,driver_tips = '' ,representative_cost = '' ,touristic_entrance = '' ,adult_charge = '' ,child_charge = '' ,tariff_code= '9703087f6e88bc8943496f87eb83b5ba';
[08/27/2020 06:26:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],insert into history_transfer_vehicles set  old_reff_id  = '515',  booking_id  = '2811' , vehicle_code  = '2' , vehicle_name  = 'CAR' , max_luggage  = '3' , max_passenger  = '2' , sel_passenger  = '1' , no_of_adult  = '1' , no_of_child  = '0' , lead_name  = 'Mr Sanket Desai' , 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  = '1000.00' , native_price  = '1000' , display_price  = '19.32' , native_surcharge  = '0' , display_surcharge  = '0.00' ;
[08/27/2020 06:26:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],UPDATE bookings SET confirmation_number= '12345678',cancellation_policy= 'Cancellation Charges will be applicable if cancelled after 11-Aug-2020 14:00 hrs.&lt;BR&gt;Late Amendment Charges may apply.&lt;Br&gt;&lt;Br&gt;&lt;B&gt;&lt;U&gt;Detailed Cancellation Policy:&lt;/U&gt;&lt;/B&gt;  Cancellation Charges of 2.41 USD applicable if cancelled after 27-Jul-2020 14:00 hrs.&lt;br&gt; Cancellation Charges of 0.1 USD applicable if cancelled after 11-Aug-2020 14:00 hrs.&lt;br&gt; Cancellation Charges of 3.86 USD applicable if cancelled after 16-Aug-2020 14:00 hrs.&lt;br&gt; Cancellation Charges of 4.83 USD applicable if cancelled after 21-Aug-2020 14:00 hrs.&lt;br&gt; Cancellation Charges of 7.73 USD applicable if cancelled after 24-Aug-2020 14:00 hrs.&lt;br&gt;',supplier_cancellation_policy= '',applied_multiplier= '0.01533',applied_markup= '26.00',agent_markup= '26.00',consultant_id= 'tfg',city_id= 'Mumbai',country_id= '106',nationality= 'Indian',service_type_detail= 'Mumbai Darshan',basecurrency_multiplier='1.00000',basecurrency_multiplier_native= '1.00000'_native,agent_currency_multiplier= '1.00000',current_status= 'vouchered',status_date= '2020-08-27 06:26:07',display_room_rate= '13.52',check_out_date= '2020-08-27',service_date= '2020-08-27',native_room_rate= '700.00',display_rate= '0.00',applicable_service_tax= '0.000',native_rate= '0.00',native_discount= '',display_discount= '',modified_datetime= '2020-08-27 06:26:07',modified_by= 'tfg',comment_contract= 'Bhandardara Lake is one of the most amazing and highly favorite camping and picnic spots for the lovers of nature. Located near Igatpuri in the Western Ghats of India, it is a hotspot of tourism for its natural beauty and the attractions nearby like the many hills, waterfalls, Wilson dam, and Arthur Lake. This camp by the lake is a great place to stay and enjoy a getaway in the lap of nature. Compl.',booking_type ='online',expiration_date= '2020-08-11 14:00:00',source_type= 'localtransfer',supplier_profile_id= '6' WHERE id= '2811';
[08/27/2020 06:26:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],UPDATE bookings SET  sub_agent_rate='0', agent_rate='13.52', applicable_service_tax='0.000', supplier_rate='700', leader_title='Ms', leader_first_name='Mr Sanket ', leader_last_name='Desai', leader_phone='' where id='2811';
[08/27/2020 06:26:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],DELETE FROM bookings_tax WHERE booking_id =2811;
[08/27/2020 06:26:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],UPDATE transfer_bookings SET transfer_date = '2020-08-27',supplier_id = 'S000000068',supplier_profile = '6',charge_applied_type = 'private',country_code = '106',city_code = '64440',item_code = '203',item_content = 'Mumbai Darshan',vehicle_type = '2' ,no_of_pass = '1' where booking_id= '2811';
[08/27/2020 06:26:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],DELETE FROM transfer_vehicles WHERE booking_id ='2811';
[08/27/2020 06:26:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],insert into transfer_vehicles set  booking_id = '2811',vehicle_code = '2' ,vehicle_name = 'CAR' ,max_passenger = '2' ,max_luggage = '3' , sel_passenger = '1', no_of_adult = '1', no_of_child = '0', lead_name = 'Mr Sanket Desai', 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 = '700.00', native_price = '700', display_price = '13.52', native_surcharge = '0', display_surcharge = '0.00', wh_display_price = '', wh_surcharge = '';
[08/27/2020 06:26:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],update booking_rate_info set  supplier_price = supplier_price+('-300'), acc_export='0', accounting_multiplier='0.01533' where booking_id='2811' and acc_type='purchase' order by bid asc limit 1;
[08/27/2020 06:26:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],update booking_rate_info set account_invoice_number='2020/376',acc_export='1' where bid='1349';
[08/27/2020 06:26:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],UPDATE agents SET credit_usage=credit_usage+('5.8'),   credit_value= credit_value-('5.8') ,  cd_credit_usage=cd_credit_usage+('5.8') , cd_credit_value=cd_credit_value-('5.8')  WHERE id = '25';
[08/27/2020 06:26:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '2406.350',credit_usage= '11593.650',credit_limit= '14000',receipt_id= '',amount= '5.8',booking_id='2811',booking_cost= '13.52',receipt_allocation= '9.66',balance= '3.86',ip='60.254.44.168',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Booking Modified',note='Booking Modified',create_date='2020-08-27 06:08:08';
[08/27/2020 06:26:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],INSERT INTO receipts( agent_id,payment_date,particulars,balance_before,amount_received,unadjusted_amount,payment_mode,bank_name,instrument_no,instrument_date,create_date,status,received_by,site_id,currency_code,receipt_type,transaction_type,system_currency_value,roe_multiplier,system_bank_id,system_bank_ref,system_bank_charge,accounting_multiplier)
		VALUES( '25','2020-08-27 00:00:00','Credit Note for :- TFG302811 Transfer Booking Modified&lt;br&gt;sdfghjkl', '8576.13', '5.8', '5.8', '', '', '', '', '2020-08-27 06:26:08', 'A', 'tfg', '0', 'USD', 'credit_note', 'CR', '5.8', '1.00000','','','','1.00000');
[08/27/2020 06:26:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],update receipts set docNo= 'CN00000002' ,ledger_multiplier = '1.00000' where id = '10';
[08/27/2020 06:26:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],update agents set ledger_balance =ledger_balance + '5.8'  where id = ?;
[08/27/2020 06:26:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-27 06:26:08',`log_type`= 'Agent Receipt added',`sql_query`= '',`log_description`= 'Reciept NO. 10 added for Agent 25',`ip`= '60.254.44.168';
[08/27/2020 06:26:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],insert into user_log_link Set `user_logs_id`='3571', `entity`='Agents', `value`='25' ;
[08/27/2020 06:26:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],Update receipts Set booking_ref= '2811',invoice_ref='2020/376',accounting_multiplier='1.00000'  where id='10';
[08/27/2020 06:26:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],insert into email_logs SET `subject`= 'The Fabulous Getaway Tax Dispute(TaxInvoice)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'Rm9yIEZvbGxvd2luZyBib29raW5nIFRheCBpcyBub3QgaW5zZXJ0ZWQ8YnI+Qm9va2luZ0lkOi0yODExPGJyPkludm9pY2Ugbm86LTIwMjAvMzc2PGJyPmJyYW5jaF9pZDotMTxicj5UeXBlOi1hZ2VudDxicj5BY2NvdW50IHR5cGU6LWNyZWRpdG5vdGU8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/view_booking_transfer.php',create_date= '2020-08-27 06:26:08';
[08/27/2020 06:26:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php], insert into email_trigger set  subject ='The Fabulous Getaway Tax Dispute',  message='For Following booking Tax is not inserted<br>BookingId:-2811<br>Invoice no:-2020/376<br>branch_id:-1<br>Type:-agent<br>Account type:-creditnote<br>',  email_sent ='yes', create_date ='2020-08-27 06:26:08', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='TaxInvoice';
[08/27/2020 06:26:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],update receipts set DocNo='2020/376',acc_export='1' where id='10';
[08/27/2020 06:26:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php], update wh_booking_rate_info set  booking_id = '2811', booking_log = 'Booking Modified', create_date = '2020-08-27 06:26:09', agent_price = '0.000', sub_agent_price = '0.000', supplier_price = '13.520' where booking_id = '2811'  and type = "Sale";
[08/27/2020 06:26:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],delete from  agent_commission   WHERE booking_id='2811';
[08/27/2020 06:26:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],INSERT INTO agent_commission SET booking_id ='2811',booking_detail_id ='2811',agent_id ='25',is_sub_agent ='N',parent_id ='',display_commission ='2.79006',display_currency ='USD',paid ='N',type ='transfer',description ='Agent Mark Up Percentage is 26.00 %',create_date ='2020-08-27 06:26:09';
[08/27/2020 06:26:09], [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
        ('','','2811','vouchered','2020-08-27 06:26:09','Transfer Booking TFG302811 Modified by tfg','tfg','60.254.44.168','tfg','','');
[08/27/2020 06:26:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-27 06:26:09',`log_type`= 'Transfer Booking Modified',`sql_query`= 'UPDATE bookings SET  sub_agent_rate=\&#039;0\&#039;, agent_rate=\&#039;13.52\&#039;, applicable_service_tax=\&#039;0.000\&#039;, supplier_rate=\&#039;700\&#039;, leader_title=\&#039;Ms\&#039;, leader_first_name=\&#039;Mr Sanket \&#039;, leader_last_name=\&#039;Desai\&#039;, leader_phone=\&#039;\&#039; where id=\&#039;2811\&#039;',`log_description`= 'Tranfer Booking Modified Booking_id = TFG302811',`ip`= '60.254.44.168';
