[08/27/2020 05:33:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],INSERT INTO accounts_webservcie SET project = 'The Fabulous Getaway', public_key = '1598506431', api_key = 'MTU5ODUwNjQzMUIzMjM1N0VBMzI=', log_path = 'http://uat.tfg.otrams.net/project_folder/tfg_project/protected/account_logs/27_08_2020';
[08/27/2020 05:33:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.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( '0025','2020-08-27 00:00:00','Agent is paying for TFG102824', '', '1000.0000', '1000.0000', 'CSH', '', '', '', '2020-08-27 05:33:51', 'A', 'Accounts Webservice', '0', 'USD', 'receipt', 'CR', '1000', '1.0000000','','','','1.0000000');
[08/27/2020 05:33:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],update receipts set docNo= 'BR-5-08-2020' ,ledger_multiplier = '1.00000' where id = '8';
[08/27/2020 05:33:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],update agents set ledger_balance =ledger_balance + '1'0025''0025''0025''  where id = ?;
[08/27/2020 05:33:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],insert into `user_logs` set `username`= 'Accounts Webservice',`create_date`= '2020-08-27 05:33:52',`log_type`= 'Agent Receipt added',`sql_query`= '',`log_description`= 'Reciept NO. 8 added for Agent 0025',`ip`= '209.236.114.174';
[08/27/2020 05:33:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],insert into user_log_link Set `user_logs_id`='3564', `entity`='Agents', `value`='0025' ;
[08/27/2020 05:35:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],INSERT INTO accounts_webservcie SET project = 'The Fabulous Getaway', public_key = '1598506518', api_key = 'MTU5ODUwNjUxOEIzMjM1N0VBMzI=', log_path = 'http://uat.tfg.otrams.net/project_folder/tfg_project/protected/account_logs/27_08_2020';
[08/27/2020 05:35:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],UPDATE receipts SET amount_received = '4.0500', particulars = 'Agent is paying for TFG102820',remarks = '',payment_mode = '',payment_date = '2020-08-27 05:35:19', instrument_date = '2020-08-27 05:35:19',system_bank_id = '',system_bank_ref = '',system_bank_charge = '',bank_name = 'HDFC',instrument_no = 'TFG102820',unadjusted_amount = '4.05',DocNo = 'BR-5-08-2020' WHERE id ='8' ;
[08/27/2020 05:35:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],UPDATE agents SET ledger_balance =ledger_balance + '-995.95'  WHERE id = '0025';
[08/27/2020 05:35:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],insert into `user_logs` set `username`= '',`create_date`= '2020-08-27 05:35:19',`log_type`= 'Receipt  Updated',`sql_query`= 'UPDATE receipts SET amount_received = :amount_received, particulars = :particulars,remarks = :remarks,payment_mode = :payment_mode,payment_date = :date_of_payment, instrument_date = :instrument_date,system_bank_id = :system_bank_id,system_bank_ref = :system_bank_ref,system_bank_charge = :system_bank_charge,bank_name = :bank_name,instrument_no = :instrument_no,unadjusted_amount = :unadjusted_amount,DocNo = :DocNo WHERE id =:id ',`log_description`= 'Receipt  Updated( 4.0500 USD ) for Agent: 0025,System Bank Id:,System_bank_charge:,system_bank_ref:,bank_name:HDFC,instrument_no:TFG102820,instrument_date:2020-08-27 05:35:19',`ip`= '209.236.114.174';
[08/27/2020 05:35:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],insert into user_log_link Set `user_logs_id`='3565', `entity`='Receipt Ids', `value`='BR-5-08-2020' ;
[08/27/2020 05:35:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],insert into user_log_link Set `user_logs_id`='3565', `entity`='Agents', `value`='0025' ;
[08/27/2020 05:38:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],INSERT INTO accounts_webservcie SET project = 'The Fabulous Getaway', public_key = '1598506729', api_key = 'MTU5ODUwNjcyOUIzMjM1N0VBMzI=', log_path = 'http://uat.tfg.otrams.net/project_folder/tfg_project/protected/account_logs/27_08_2020';
[08/27/2020 05:38:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],UPDATE receipts SET amount_received = '1000.0000', particulars = 'Agent is paying for TFG102824',remarks = '',payment_mode = '',payment_date = '2020-08-26 05:38:50', instrument_date = '2020-08-26 05:38:50',system_bank_id = '',system_bank_ref = '',system_bank_charge = '',bank_name = 'HDFC',instrument_no = 'TFG102824',unadjusted_amount = '996.93',DocNo = 'BR-4-08-2020' WHERE id ='7' ;
[08/27/2020 05:38:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],UPDATE agents SET ledger_balance =ledger_balance + '0'  WHERE id = '0025';
[08/27/2020 05:38:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],insert into `user_logs` set `username`= '',`create_date`= '2020-08-27 05:38:50',`log_type`= 'Receipt  Updated',`sql_query`= 'UPDATE receipts SET amount_received = :amount_received, particulars = :particulars,remarks = :remarks,payment_mode = :payment_mode,payment_date = :date_of_payment, instrument_date = :instrument_date,system_bank_id = :system_bank_id,system_bank_ref = :system_bank_ref,system_bank_charge = :system_bank_charge,bank_name = :bank_name,instrument_no = :instrument_no,unadjusted_amount = :unadjusted_amount,DocNo = :DocNo WHERE id =:id ',`log_description`= 'Receipt  Updated( 1000.0000 USD ) for Agent: 0025,System Bank Id:,System_bank_charge:,system_bank_ref:,bank_name:HDFC,instrument_no:TFG102824,instrument_date:2020-08-26 05:38:50',`ip`= '209.236.114.174';
[08/27/2020 05:38:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],insert into user_log_link Set `user_logs_id`='3566', `entity`='Receipt Ids', `value`='BR-4-08-2020' ;
[08/27/2020 05:38:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],insert into user_log_link Set `user_logs_id`='3566', `entity`='Agents', `value`='0025' ;
[08/27/2020 05:38:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],INSERT INTO accounts_webservcie SET project = 'The Fabulous Getaway', public_key = '1598506730', api_key = 'MTU5ODUwNjczMEIzMjM1N0VBMzI=', log_path = 'http://uat.tfg.otrams.net/project_folder/tfg_project/protected/account_logs/27_08_2020';
[08/27/2020 05:38:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],INSERT INTO receipts_bookings set booking_id= '2824' ,agent_id= '0025' ,booking_rate_id= '1320' ,receipt_id= '7' ,source_type= 'localsystem' ,amount_received= '975.2400' ,payment_status= '' ,service_type= 'hOTEL' ,create_date= '2020-08-27 05:38:45' ,site_id = '';
[08/27/2020 05:38:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],UPDATE agents SET credit_usage=credit_usage+('-975.24'),   credit_value= credit_value-('-975.24') ,  cd_credit_usage=cd_credit_usage+('-975.24') , cd_credit_value=cd_credit_value-('-975.24')  WHERE id = '25';
[08/27/2020 05:38:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '2421.810',credit_usage= '11578.190',credit_limit= '14000',receipt_id= '7',amount= '-975.24',booking_id='2824',booking_cost= '1000',receipt_allocation= '975.24',balance= '24.76',ip='209.236.114.174',user_type='Cron',admin_id='',temp_credit_limit='',log_type='Receipt Allocated To Booking',note='Receipt Allocated To Booking',create_date='2020-08-27 05:08:52';
[08/27/2020 05:38:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],UPDATE receipts set unadjusted_amount=unadjusted_amount- '975.2400' Where id= '7';
[08/27/2020 05:38:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],UPDATE booking_rate_info set  receipt_amount = receipt_amount+(975.2400) Where bid= '1320' ;
[08/27/2020 05:38:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],update agents set ledger_balance = ledger_balance-'975.24'  where id = ? ;
[08/27/2020 05:38:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],update booking_rate_info set tax_invoice='1' where acc_type='sale' and bid = '1320';
[08/27/2020 05:38:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','2824','vouchered','2020-08-27 05:38:52','Booking Receipt Allocated by id -Booking Receipt Allocated by id - By Auto Cron','','209.236.114.174','','','yes');
[08/27/2020 05:41:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],INSERT INTO accounts_webservcie SET project = 'The Fabulous Getaway', public_key = '1598506886', api_key = 'MTU5ODUwNjg4NkIzMjM1N0VBMzI=', log_path = 'http://uat.tfg.otrams.net/project_folder/tfg_project/protected/account_logs/27_08_2020';
[08/27/2020 05:41:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],UPDATE receipts SET amount_received = '1000.0000', particulars = 'Agent is paying for TFG102824',remarks = '',payment_mode = '',payment_date = '2020-08-26 05:41:27', instrument_date = '2020-08-26 05:41:27',system_bank_id = '',system_bank_ref = '',system_bank_charge = '',bank_name = 'HDFC',instrument_no = 'TFG102824',unadjusted_amount = '21.69',DocNo = 'BR-4-08-2020' WHERE id ='7' ;
[08/27/2020 05:41:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],UPDATE agents SET ledger_balance =ledger_balance + '5.3290705182008E-14'  WHERE id = '0025';
[08/27/2020 05:41:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],insert into `user_logs` set `username`= '',`create_date`= '2020-08-27 05:41:27',`log_type`= 'Receipt  Updated',`sql_query`= 'UPDATE receipts SET amount_received = :amount_received, particulars = :particulars,remarks = :remarks,payment_mode = :payment_mode,payment_date = :date_of_payment, instrument_date = :instrument_date,system_bank_id = :system_bank_id,system_bank_ref = :system_bank_ref,system_bank_charge = :system_bank_charge,bank_name = :bank_name,instrument_no = :instrument_no,unadjusted_amount = :unadjusted_amount,DocNo = :DocNo WHERE id =:id ',`log_description`= 'Receipt  Updated( 1000.0000 USD ) for Agent: 0025,System Bank Id:,System_bank_charge:,system_bank_ref:,bank_name:HDFC,instrument_no:TFG102824,instrument_date:2020-08-26 05:41:27',`ip`= '209.236.114.174';
[08/27/2020 05:41:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],insert into user_log_link Set `user_logs_id`='3567', `entity`='Receipt Ids', `value`='BR-4-08-2020' ;
[08/27/2020 05:41:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],insert into user_log_link Set `user_logs_id`='3567', `entity`='Agents', `value`='0025' ;
[08/27/2020 05:44:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],update bookings set voucher_id='2811',status_date='2020-08-27 05:44:15',current_status='vouchered',voucher_hashcode='b1e90288493196568f80ce1bc278f43c780442811',vouchered_by ='tfg' where id='2811';
[08/27/2020 05:44:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],Insert into booking_configuration set booking_id='2811',config_key='VOUCHER_DATE', config_value='2020-08-27 05:44:15',create_date='2020-08-27 05:44:15';
[08/27/2020 05:44:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],INSERT INTO autogenerator_invoice_number (id, number) VALUES ('','1598507055');
[08/27/2020 05:44:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],update bookings set is_invoiced='yes',invoice_number= '2020/376' where id='2811' and is_invoiced!='yes';
[08/27/2020 05:44:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],UPDATE agents SET credit_usage=credit_usage+('9.66'),   credit_value= credit_value-('9.66') ,  cd_credit_usage=cd_credit_usage+('9.66') , cd_credit_value=cd_credit_value-('9.66')  WHERE id = '25';
[08/27/2020 05:44:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '2412.150',credit_usage= '11587.850',credit_limit= '14000',receipt_id= '',amount= '9.66',booking_id='2811',booking_cost= '9.66',receipt_allocation= '',balance= '9.66',ip='60.254.44.168',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-08-27 05:08:15';
[08/27/2020 05:44:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],insert into booking_rate_info set agent_price='0',sub_agent_price='0',supplier_currency='INR',supplier_price='500',supplier_type='offline',supplier_id='S000000068',acc_type='purchase',accounting_multiplier='0.01533',booking_id='2811',booking_log='Transfer Booking Invoiced',type='Sale',create_date='2020-08-27 05:44:15',account_invoice='2020/376',particulars='';
[08/27/2020 05:44:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],update booking_rate_info set account_invoice_number='2020/376',acc_export='1' where bid='1349';
[08/27/2020 05:44:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],insert into booking_rate_info set agent_price='9.66',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='1.00000',booking_id='2811',booking_log='Transfer Booking Invoiced',type='Sale',create_date='2020-08-27 05:44:15',account_invoice='2020/376',particulars='';
[08/27/2020 05:44:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1350;
[08/27/2020 05:44:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],INSERT INTO accounts_invoice_transaction SET bid= '1350',booking_id= '2811',invoice_number= '2020/376',service_type= 'transfer',booking_type= 'online',service_name= 'Mumbai Darshan',type= 'sale',from_date= '2020-08-27',to_date= '2020-08-27',price= '9.660',total_price= '9.660';
[08/27/2020 05:44:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],insert into email_logs SET `subject`= 'The Fabulous Getaway Tax Dispute(TaxInvoice)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'Rm9yIEZvbGxvd2luZyBib29raW5nIFRheCBpcyBub3QgaW5zZXJ0ZWQ8YnI+Qm9va2luZ0lkOi0yODExPGJyPkludm9pY2Ugbm86LTIwMjAvMzc2PGJyPmJyYW5jaF9pZDotMTxicj5UeXBlOi1hZ2VudDxicj5BY2NvdW50IHR5cGU6LXNhbGU8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/force_confirm_booking.php',create_date= '2020-08-27 05:44:15';
[08/27/2020 05:44:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.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:-sale<br>',  email_sent ='yes', create_date ='2020-08-27 05:44:15', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='TaxInvoice';
[08/27/2020 05:44:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],update booking_rate_info set account_invoice_number='2020/376',acc_export='1' where bid='1350';
[08/27/2020 05:44:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_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
        ('','','2811','vouchered-invoiced','2020-08-27 05:44:16',' by tfg','tfg','60.254.44.168','tfg','','');
[08/27/2020 05:44:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],INSERT INTO agent_commission SET booking_id ='2811',booking_detail_id ='2811',agent_id ='25',is_sub_agent ='N',parent_id ='',display_commission ='1.9929',display_currency ='USD',paid ='N',type ='transfer',description ='Agent Mark Up Percentage is 26 %',create_date ='2020-08-27 05:44:16';
[08/27/2020 05:44:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],insert into accounting_status set booking_id ='2811',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[08/27/2020 05:44:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_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
        ('','','2811','vouchered','2020-08-27 05:44:16','Force confirm : Auto Vouchered Within cancellation policy by tfg','tfg','60.254.44.168','tfg','','');
[08/27/2020 05:44:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],insert into email_logs SET `subject`= ' TFG302811/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 35900 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,nitin@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/force_confirm_booking.php',create_date= '2020-08-27 05:44:18';
[08/27/2020 05:44:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],insert into email_logs SET `subject`= ' TFG302811/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 35900 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/force_confirm_booking.php',create_date= '2020-08-27 05:44:20';
[08/27/2020 05:44:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],UPDATE bookings SET confirmation_number='12345678' where id='2811';
[08/27/2020 05:45:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],INSERT INTO accounts_webservcie SET project = 'The Fabulous Getaway', public_key = '1598507132', api_key = 'MTU5ODUwNzEzMkIzMjM1N0VBMzI=', log_path = 'http://uat.tfg.otrams.net/project_folder/tfg_project/protected/account_logs/27_08_2020';
[08/27/2020 05:45:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.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( '0025','2020-08-27 00:00:00','Agent is paying for TFG302811', '', '9.6600', '9.6600', 'CSH', '', '', '', '2020-08-27 05:45:32', 'A', 'Accounts Webservice', '0', 'USD', 'receipt', 'CR', '9.66', '1.0000000','','','','1.0000000');
[08/27/2020 05:45:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],update receipts set docNo= 'BR-6-08-2020' ,ledger_multiplier = '1.00000' where id = '9';
[08/27/2020 05:45:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],update agents set ledger_balance =ledger_balance + '9.66'  where id = ?;
[08/27/2020 05:45:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],insert into `user_logs` set `username`= 'Accounts Webservice',`create_date`= '2020-08-27 05:45:33',`log_type`= 'Agent Receipt added',`sql_query`= '',`log_description`= 'Reciept NO. 9 added for Agent 0025',`ip`= '209.236.114.174';
[08/27/2020 05:45:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],insert into user_log_link Set `user_logs_id`='3568', `entity`='Agents', `value`='0025' ;
[08/27/2020 05:46:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],INSERT INTO accounts_webservcie SET project = 'The Fabulous Getaway', public_key = '1598507173', api_key = 'MTU5ODUwNzE3M0IzMjM1N0VBMzI=', log_path = 'http://uat.tfg.otrams.net/project_folder/tfg_project/protected/account_logs/27_08_2020';
[08/27/2020 05:46:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],UPDATE receipts SET amount_received = '9.6600', particulars = 'Agent is paying for TFG302811',remarks = '',payment_mode = '',payment_date = '2020-08-27 05:46:14', instrument_date = '2020-08-27 05:46:14',system_bank_id = '',system_bank_ref = '',system_bank_charge = '',bank_name = 'HDFC',instrument_no = 'TFG302811',unadjusted_amount = '9.66',DocNo = 'BR-6-08-2020' WHERE id ='9' ;
[08/27/2020 05:46:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],UPDATE agents SET ledger_balance =ledger_balance + '0'  WHERE id = '0025';
[08/27/2020 05:46:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],insert into `user_logs` set `username`= '',`create_date`= '2020-08-27 05:46:14',`log_type`= 'Receipt  Updated',`sql_query`= 'UPDATE receipts SET amount_received = :amount_received, particulars = :particulars,remarks = :remarks,payment_mode = :payment_mode,payment_date = :date_of_payment, instrument_date = :instrument_date,system_bank_id = :system_bank_id,system_bank_ref = :system_bank_ref,system_bank_charge = :system_bank_charge,bank_name = :bank_name,instrument_no = :instrument_no,unadjusted_amount = :unadjusted_amount,DocNo = :DocNo WHERE id =:id ',`log_description`= 'Receipt  Updated( 9.6600 USD ) for Agent: 0025,System Bank Id:,System_bank_charge:,system_bank_ref:,bank_name:HDFC,instrument_no:TFG302811,instrument_date:2020-08-27 05:46:14',`ip`= '209.236.114.174';
[08/27/2020 05:46:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],insert into user_log_link Set `user_logs_id`='3569', `entity`='Receipt Ids', `value`='BR-6-08-2020' ;
[08/27/2020 05:46:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],insert into user_log_link Set `user_logs_id`='3569', `entity`='Agents', `value`='0025' ;
[08/27/2020 05:46:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],INSERT INTO accounts_webservcie SET project = 'The Fabulous Getaway', public_key = '1598507174', api_key = 'MTU5ODUwNzE3NEIzMjM1N0VBMzI=', log_path = 'http://uat.tfg.otrams.net/project_folder/tfg_project/protected/account_logs/27_08_2020';
[08/27/2020 05:46:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],INSERT INTO receipts_bookings set booking_id= '2811' ,agent_id= '0025' ,booking_rate_id= '1350' ,receipt_id= '9' ,source_type= 'localtransfer' ,amount_received= '9.6600' ,payment_status= '' ,service_type= 'tRANSFER' ,create_date= '2020-08-27 05:46:11' ,site_id = '';
[08/27/2020 05:46:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],UPDATE agents SET credit_usage=credit_usage+('-9.66'),   credit_value= credit_value-('-9.66') ,  cd_credit_usage=cd_credit_usage+('-9.66') , cd_credit_value=cd_credit_value-('-9.66')  WHERE id = '25';
[08/27/2020 05:46:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '2421.810',credit_usage= '11578.190',credit_limit= '14000',receipt_id= '9',amount= '-9.66',booking_id='2811',booking_cost= '9.66',receipt_allocation= '9.66',balance= '',ip='209.236.114.174',user_type='Cron',admin_id='',temp_credit_limit='',log_type='Receipt Allocated To Booking',note='Receipt Allocated To Booking',create_date='2020-08-27 05:08:15';
[08/27/2020 05:46:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],UPDATE receipts set unadjusted_amount=unadjusted_amount- '9.6600' Where id= '9';
[08/27/2020 05:46:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],UPDATE booking_rate_info set  receipt_amount = receipt_amount+(9.6600) Where bid= '1350' ;
[08/27/2020 05:46:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],update agents set ledger_balance = ledger_balance-'9.66'  where id = ? ;
[08/27/2020 05:46:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],update booking_rate_info set tax_invoice='1' where acc_type='sale' and bid = '1350';
[08/27/2020 05:46:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.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 05:46:15','Booking Receipt Allocated by id -Booking Receipt Allocated by id - By Auto Cron','','209.236.114.174','','','yes');
[08/27/2020 05:50:04], [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 = '', leader_first_name = 'Mr Sanket Desai', leader_last_name = '', city_id = 'Mumbai', country_id = '', nationality = '', display_room_rate = '9.660', native_room_rate = '500.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:44:15', 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 = '', native_rate = '0', display_rate = '0', applicable_service_tax = '0.000', special_comment = '', special_remark = '', sms_status = '', is_xml = '0', consultant_id = 'nitinalpha', admin_booked = '0', emailed_status = '0', applied_multiplier = '0.01533', applied_markup = '26', original_voucher = '', subagent_markup = '', agent_markup = '26', agent_rate = '9.660', sub_agent_rate = '0.000', supplier_rate = '500.000', basecurrency_multiplier = '1.00000', basecurrency_multiplier_native = '0.01533', agent_currency_multiplier = '1.00000', created_datetime = '', created_by = '', modified_datetime = '', modified_by = '', ip_addr = '45.120.147.56';
[08/27/2020 05:50:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],insert into history_transfer_bookings  set  old_reff_id  = '514', 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= '',parking_fee = '' ,guide_cost = '' ,driver_tips = '' ,representative_cost = '' ,touristic_entrance = '' ,adult_charge = '' ,child_charge = '' ,tariff_code= '9703087f6e88bc8943496f87eb83b5ba';
[08/27/2020 05:50:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],insert into history_transfer_vehicles set  old_reff_id  = '514',  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  = '' , parking_fee  = '' , driver_tips  = '' , representative_cost  = '' , guide_cost  = '' , touristic_fee  = '' , vehicle_native_price  = '500' , native_price  = '500' , display_price  = '9.66' , native_surcharge  = '' , display_surcharge  = '' ;
[08/27/2020 05:50:05], [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 05:50:04',display_room_rate= '19.32',check_out_date= '2020-08-27',service_date= '2020-08-27',native_room_rate= '1000.00',display_rate= '0.00',applicable_service_tax= '0.000',native_rate= '0.00',native_discount= '',display_discount= '',modified_datetime= '2020-08-27 05:50:05',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 05:50:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],UPDATE bookings SET  sub_agent_rate='0', agent_rate='19.32', applicable_service_tax='0.000', supplier_rate='1000', leader_title='Ms', leader_first_name='Mr Sanket ', leader_last_name='Desai', leader_phone='' where id='2811';
[08/27/2020 05:50:05], [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 05:50:05], [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 05:50:05], [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 05:50:05], [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 = '1000.00', native_price = '1000', display_price = '19.32', native_surcharge = '0', display_surcharge = '0.00', wh_display_price = '', wh_surcharge = '';
[08/27/2020 05:50:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],update booking_rate_info set  supplier_price = supplier_price+('500'), acc_export='0', accounting_multiplier='0.01533' where booking_id='2811' and acc_type='purchase' order by bid asc limit 1;
[08/27/2020 05:50:05], [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 05:50:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],insert into booking_rate_info set agent_price='9.66',sub_agent_price='0',supplier_price='0',acc_type='debitnote',accounting_multiplier='1.00000',booking_id='2811',booking_log='Transfer Booking Modified',type='Ammended',create_date='2020-08-27 05:50:05',account_invoice='2020/376',particulars='Debit Note for :- TFG302811 Test';
[08/27/2020 05:50:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],INSERT INTO accounts_invoice_transaction SET bid= '1351',booking_id= '2811',invoice_number= '2020/376',service_type= 'transfer',booking_type= 'online',description= 'Test',type= 'debitnote',price= '9.660',total_price= '9.660',service_name= 'Mumbai Darshan';
[08/27/2020 05:50:05], [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+Qm9va2luZ0lkOi0yODExPGJyPkludm9pY2Ugbm86LTIwMjAvMzc2PGJyPmJyYW5jaF9pZDotMTxicj5UeXBlOi1hZ2VudDxicj5BY2NvdW50IHR5cGU6LWRlYml0bm90ZTxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/view_booking_transfer.php',create_date= '2020-08-27 05:50:05';
[08/27/2020 05:50:05], [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:-debitnote<br>',  email_sent ='yes', create_date ='2020-08-27 05:50:05', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='TaxInvoice';
[08/27/2020 05:50:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/ws/accounts/accounts_controller.php],INSERT INTO accounts_webservcie SET project = 'The Fabulous Getaway', public_key = '1598507406', api_key = 'MTU5ODUwNzQwNkIzMjM1N0VBMzI=', log_path = 'http://uat.tfg.otrams.net/project_folder/tfg_project/protected/account_logs/27_08_2020';
[08/27/2020 05:50:07], [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='1351';
[08/27/2020 05:50:07], [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 05:50:07', agent_price = '0.000', sub_agent_price = '0.000', supplier_price = '19.320' where booking_id = '2811'  and type = "Sale";
[08/27/2020 05:50:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],UPDATE agents SET credit_usage=credit_usage+('9.66'),   credit_value= credit_value-('9.66') ,  cd_credit_usage=cd_credit_usage+('9.66') , cd_credit_value=cd_credit_value-('9.66')  WHERE id = '25';
[08/27/2020 05:50:07], [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= '2412.150',credit_usage= '11587.850',credit_limit= '14000',receipt_id= '',amount= '9.66',booking_id='2811',booking_cost= '19.32',receipt_allocation= '9.66',balance= '9.66',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 05:08:07';
[08/27/2020 05:50:07], [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 05:50:07], [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 ='3.9858',display_currency ='USD',paid ='N',type ='transfer',description ='Agent Mark Up Percentage is 26.00 %',create_date ='2020-08-27 05:50:07';
[08/27/2020 05:50:07], [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 05:50:07','Transfer Booking TFG302811 Modified by tfg','tfg','60.254.44.168','tfg','','');
[08/27/2020 05:50:07], [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 05:50:07',`log_type`= 'Transfer Booking Modified',`sql_query`= 'UPDATE bookings SET  sub_agent_rate=\&#039;0\&#039;, agent_rate=\&#039;19.32\&#039;, applicable_service_tax=\&#039;0.000\&#039;, supplier_rate=\&#039;1000\&#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';
[08/27/2020 05:50:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],insert into email_logs SET `subject`= ' TFG302811/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 35996 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/view_booking_transfer.php',create_date= '2020-08-27 05:50:09';
[08/27/2020 05:50:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],insert into email_logs SET `subject`= ' TFG302811/  Booking Confirmed ',from_email_id= '',body= '[encoded data, 28456 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/view_booking_transfer.php',create_date= '2020-08-27 05:50:09';
