[10/17/2020 08:37:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','2998','vouchered-invoiced','2020-10-17 08:37:43',' by tfg','tfg','43.250.210.121','tfg','','');
[10/17/2020 08:37:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2998',booking_detail_id ='2998',agent_id ='22',is_sub_agent ='N',parent_id ='',display_commission ='12.936',display_currency ='MYR',paid ='N',type ='transfer',description ='Agent Mark Up Percentage is 10 %',create_date ='2020-10-17 08:37:43';
[10/17/2020 08:37:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2998',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/17/2020 08:37:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','2998','vouchered','2020-10-17 08:37:43','Vouchered By tfg by tfg','tfg','43.250.210.121','tfg','','');
[10/17/2020 08:37:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302998/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 44200 characters]',to_email_id= 'ankita.rao@qtechsofware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-17 08:37:45';
[10/17/2020 08:37:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302998/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 44200 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-17 08:37:47';
[10/17/2020 08:37:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='testbooking',status_date='2020-10-17 08:37:48',current_status='vouchered',voucher_hashcode='6d49e268ad721759d8d1747cbc5c78e1149542999',vouchered_by ='tfg' where id='2999';
[10/17/2020 08:37:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2999',config_key='VOUCHER_DATE', config_value='2020-10-17 08:37:48',create_date='2020-10-17 08:37:48';
[10/17/2020 08:37:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/383' where id='2999' and is_invoiced!='yes';
[10/17/2020 08:37:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('18.0382422'),   credit_value= credit_value-('18.0382422') ,  cd_credit_usage=cd_credit_usage+('18.0382422') , cd_credit_value=cd_credit_value-('18.0382422')  WHERE id = '22';
[10/17/2020 08:37:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '22',credit_value= '49516241.069',credit_usage= '483758.931',credit_limit= '50000000',receipt_id= '',amount= '18.0382422',booking_id='2999',booking_cost= '76.13',receipt_allocation= '',balance= '76.13',ip='43.250.210.121',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-10-17 08:10:48';
[10/17/2020 08:37:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='0',sub_agent_price='0',supplier_currency='INR',supplier_price='1000',supplier_type='offline',supplier_id='S000000003',acc_type='purchase',accounting_multiplier='0.01533',booking_id='2999',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-17 08:37:48',account_invoice='2020/383',particulars='';
[10/17/2020 08:37:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO `bookings_tax` (`booking_id`, `tax_id`, `tax_value`, `tax_amount`, `tax_type` ,`tax_percent`, `branch_id`, `acc_type` , `transaction`, `transaction_id`, `entity` )
                VALUES ('2999','0','1000.000','0','IP','0','1','purchase','booking_rate_info','1440','supplier');
[10/17/2020 08:37:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/383',acc_export='1' where bid='1440';
[10/17/2020 08:37:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='76.13',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='0.23694',booking_id='2999',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-17 08:37:48',account_invoice='2020/383',particulars='';
[10/17/2020 08:37:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1441;
[10/17/2020 08:37:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1441',booking_id= '2999',invoice_number= '2020/383',service_type= 'transfer',booking_type= 'offline',service_name= 'Leisure Day',type= 'sale',from_date= '2020-10-14',to_date= '2020-10-14',price= '76.130',total_price= '76.130';
[10/17/2020 08:37:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO `bookings_tax` (`booking_id`, `tax_id`, `tax_value`, `tax_amount`, `tax_type` ,`tax_percent`, `branch_id`, `acc_type` , `transaction`, `transaction_id`, `entity` )
                VALUES ('2999','4','76.130','9.93','OP','15','1','sale','booking_rate_info','1441','agent');
[10/17/2020 08:37:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/383',acc_export='1' where bid='1441';
[10/17/2020 08:37:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/383',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 49016 characters]',to_email_id= 'ankita.rao@qtechsoftware.com,ankita.rao@qtechsofware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-17 08:37:51';
[10/17/2020 08:37:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','2999','vouchered-invoiced','2020-10-17 08:37:51',' by tfg','tfg','43.250.210.121','tfg','','');
[10/17/2020 08:37:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2999',booking_detail_id ='2999',agent_id ='22',is_sub_agent ='N',parent_id ='',display_commission ='11.44836',display_currency ='MYR',paid ='N',type ='transfer',description ='Agent Mark Up Percentage is 17.7 %',create_date ='2020-10-17 08:37:51';
[10/17/2020 08:37:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2999',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/17/2020 08:37:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','2999','vouchered','2020-10-17 08:37:51','Vouchered By tfg by tfg','tfg','43.250.210.121','tfg','','');
[10/17/2020 08:37:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302999/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 41620 characters]',to_email_id= 'ankita.rao@qtechsofware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-17 08:37:54';
[10/17/2020 08:37:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302999/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 41620 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-17 08:37:56';
[10/17/2020 08:37:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='testbooking',status_date='2020-10-17 08:37:57',current_status='vouchered',voucher_hashcode='dccecc95db3a12e340e68b805f512b17380763000',vouchered_by ='tfg' where id='3000';
[10/17/2020 08:37:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='3000',config_key='VOUCHER_DATE', config_value='2020-10-17 08:37:57',create_date='2020-10-17 08:37:57';
[10/17/2020 08:37:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/383' where id='3000' and is_invoiced!='yes';
[10/17/2020 08:37:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('16.858281'),   credit_value= credit_value-('16.858281') ,  cd_credit_usage=cd_credit_usage+('16.858281') , cd_credit_value=cd_credit_value-('16.858281')  WHERE id = '22';
[10/17/2020 08:37:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '22',credit_value= '49516224.211',credit_usage= '483775.789',credit_limit= '50000000',receipt_id= '',amount= '16.858281',booking_id='3000',booking_cost= '71.15',receipt_allocation= '',balance= '71.15',ip='43.250.210.121',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-10-17 08:10:57';
[10/17/2020 08:37:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='0',sub_agent_price='0',supplier_currency='INR',supplier_price='1000',supplier_type='offline',supplier_id='S000000066',acc_type='purchase',accounting_multiplier='0.01533',booking_id='3000',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-17 08:37:57',account_invoice='2020/383',particulars='';
[10/17/2020 08:37:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO `bookings_tax` (`booking_id`, `tax_id`, `tax_value`, `tax_amount`, `tax_type` ,`tax_percent`, `branch_id`, `acc_type` , `transaction`, `transaction_id`, `entity` )
                VALUES ('3000','0','1000.000','0','IP','0','1','purchase','booking_rate_info','1442','supplier');
[10/17/2020 08:37:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/383',acc_export='1' where bid='1442';
[10/17/2020 08:37:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='71.15',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='0.23694',booking_id='3000',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-17 08:37:57',account_invoice='2020/383',particulars='';
[10/17/2020 08:37:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1443;
[10/17/2020 08:37:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1443',booking_id= '3000',invoice_number= '2020/383',service_type= 'transfer',booking_type= 'offline',service_name= 'Srilanka Transfer Test',type= 'sale',from_date= '2020-10-16',to_date= '2020-10-16',price= '71.150',total_price= '71.150';
[10/17/2020 08:37:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO `bookings_tax` (`booking_id`, `tax_id`, `tax_value`, `tax_amount`, `tax_type` ,`tax_percent`, `branch_id`, `acc_type` , `transaction`, `transaction_id`, `entity` )
                VALUES ('3000','4','71.150','9.2804347826087','OP','15','1','sale','booking_rate_info','1443','agent');
[10/17/2020 08:37:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/383',acc_export='1' where bid='1443';
[10/17/2020 08:38:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/383',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 50640 characters]',to_email_id= 'ankita.rao@qtechsoftware.com,ankita.rao@qtechsofware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-17 08:38:00';
[10/17/2020 08:38:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3000','vouchered-invoiced','2020-10-17 08:38:01',' by tfg','tfg','43.250.210.121','tfg','','');
[10/17/2020 08:38:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='3000',booking_detail_id ='3000',agent_id ='22',is_sub_agent ='N',parent_id ='',display_commission ='6.468',display_currency ='MYR',paid ='N',type ='transfer',description ='Agent Mark Up Percentage is 10 %',create_date ='2020-10-17 08:38:01';
[10/17/2020 08:38:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='3000',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/17/2020 08:38:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3000','vouchered','2020-10-17 08:38:01','Vouchered By tfg by tfg','tfg','43.250.210.121','tfg','','');
[10/17/2020 08:38:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG303000/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 33460 characters]',to_email_id= 'ankita.rao@qtechsofware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-17 08:38:02';
[10/17/2020 08:38:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG303000/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 33460 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-17 08:38:04';
[10/17/2020 08:38:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='testbooking',status_date='2020-10-17 08:38:06',current_status='vouchered',voucher_hashcode='30dd22e418a931cd20ac3731b0ed8dcb938883001',vouchered_by ='tfg' where id='3001';
[10/17/2020 08:38:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='3001',config_key='VOUCHER_DATE', config_value='2020-10-17 08:38:06',create_date='2020-10-17 08:38:06';
[10/17/2020 08:38:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/383' where id='3001' and is_invoiced!='yes';
[10/17/2020 08:38:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('18.0382422'),   credit_value= credit_value-('18.0382422') ,  cd_credit_usage=cd_credit_usage+('18.0382422') , cd_credit_value=cd_credit_value-('18.0382422')  WHERE id = '22';
[10/17/2020 08:38:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '22',credit_value= '49516206.173',credit_usage= '483793.827',credit_limit= '50000000',receipt_id= '',amount= '18.0382422',booking_id='3001',booking_cost= '76.13',receipt_allocation= '',balance= '76.13',ip='43.250.210.121',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-10-17 08:10:06';
[10/17/2020 08:38:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='0',sub_agent_price='0',supplier_currency='INR',supplier_price='1000',supplier_type='offline',supplier_id='S000000003',acc_type='purchase',accounting_multiplier='0.01533',booking_id='3001',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-17 08:38:06',account_invoice='2020/383',particulars='';
[10/17/2020 08:38:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO `bookings_tax` (`booking_id`, `tax_id`, `tax_value`, `tax_amount`, `tax_type` ,`tax_percent`, `branch_id`, `acc_type` , `transaction`, `transaction_id`, `entity` )
                VALUES ('3001','0','1000.000','0','IP','0','1','purchase','booking_rate_info','1444','supplier');
[10/17/2020 08:38:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/383',acc_export='1' where bid='1444';
[10/17/2020 08:38:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='76.13',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='0.23694',booking_id='3001',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-17 08:38:06',account_invoice='2020/383',particulars='';
[10/17/2020 08:38:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1445;
[10/17/2020 08:38:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1445',booking_id= '3001',invoice_number= '2020/383',service_type= 'transfer',booking_type= 'offline',service_name= 'Leisure Day',type= 'sale',from_date= '2020-10-15',to_date= '2020-10-15',price= '76.130',total_price= '76.130';
[10/17/2020 08:38:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO `bookings_tax` (`booking_id`, `tax_id`, `tax_value`, `tax_amount`, `tax_type` ,`tax_percent`, `branch_id`, `acc_type` , `transaction`, `transaction_id`, `entity` )
                VALUES ('3001','4','76.130','9.93','OP','15','1','sale','booking_rate_info','1445','agent');
[10/17/2020 08:38:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/383',acc_export='1' where bid='1445';
[10/17/2020 08:38:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/383',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 52248 characters]',to_email_id= 'ankita.rao@qtechsoftware.com,ankita.rao@qtechsofware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-17 08:38:09';
[10/17/2020 08:38:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3001','vouchered-invoiced','2020-10-17 08:38:09',' by tfg','tfg','43.250.210.121','tfg','','');
[10/17/2020 08:38:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='3001',booking_detail_id ='3001',agent_id ='22',is_sub_agent ='N',parent_id ='',display_commission ='11.44836',display_currency ='MYR',paid ='N',type ='transfer',description ='Agent Mark Up Percentage is 17.7 %',create_date ='2020-10-17 08:38:09';
[10/17/2020 08:38:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='3001',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/17/2020 08:38:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3001','vouchered','2020-10-17 08:38:09','Vouchered By tfg by tfg','tfg','43.250.210.121','tfg','','');
[10/17/2020 08:38:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG303001/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 41620 characters]',to_email_id= 'ankita.rao@qtechsofware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-17 08:38:11';
[10/17/2020 08:38:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG303001/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 41620 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-17 08:38:13';
