[10/17/2020 08:42:40], [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
        ('','','3007','vouchered-invoiced','2020-10-17 08:42:40',' by tfg','tfg','43.250.210.121','tfg','','');
[10/17/2020 08:42:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='3007',booking_detail_id ='3007',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:42:40';
[10/17/2020 08:42:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='3007',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/17/2020 08:42:40], [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
        ('','','3007','vouchered','2020-10-17 08:42:40','Vouchered By tfg by tfg','tfg','43.250.210.121','tfg','','');
[10/17/2020 08:42:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG303007/  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:42:42';
[10/17/2020 08:42:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG303007/  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:42:44';
[10/17/2020 08:42:45], [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:42:45',current_status='vouchered',voucher_hashcode='fd774fe584394970579b9882fd5dc569637863008',vouchered_by ='tfg' where id='3008';
[10/17/2020 08:42:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='3008',config_key='VOUCHER_DATE', config_value='2020-10-17 08:42:45',create_date='2020-10-17 08:42:45';
[10/17/2020 08:42:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/384' where id='3008' and is_invoiced!='yes';
[10/17/2020 08:42:45], [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:42:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '22',credit_value= '49503297.206',credit_usage= '496702.794',credit_limit= '50000000',receipt_id= '',amount= '18.0382422',booking_id='3008',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:45';
[10/17/2020 08:42:46], [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='3008',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-17 08:42:45',account_invoice='2020/384',particulars='';
[10/17/2020 08:42:46], [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 ('3008','0','1000.000','0','IP','0','1','purchase','booking_rate_info','1458','supplier');
[10/17/2020 08:42:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/384',acc_export='1' where bid='1458';
[10/17/2020 08:42:46], [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='3008',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-17 08:42:45',account_invoice='2020/384',particulars='';
[10/17/2020 08:42:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1459;
[10/17/2020 08:42:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1459',booking_id= '3008',invoice_number= '2020/384',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:42:46], [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 ('3008','4','76.130','9.93','OP','15','1','sale','booking_rate_info','1459','agent');
[10/17/2020 08:42:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/384',acc_export='1' where bid='1459';
[10/17/2020 08:42:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/384',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:42:48';
[10/17/2020 08:42:48], [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
        ('','','3008','vouchered-invoiced','2020-10-17 08:42:48',' by tfg','tfg','43.250.210.121','tfg','','');
[10/17/2020 08:42:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='3008',booking_detail_id ='3008',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:42:49';
[10/17/2020 08:42:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='3008',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/17/2020 08:42:49], [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
        ('','','3008','vouchered','2020-10-17 08:42:49','Vouchered By tfg by tfg','tfg','43.250.210.121','tfg','','');
[10/17/2020 08:42:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG303008/  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:42:50';
[10/17/2020 08:42:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG303008/  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:42:52';
[10/17/2020 08:42:54], [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:42:54',current_status='vouchered',voucher_hashcode='5bd5734d25f3875c01460b6134ee7405244173009',vouchered_by ='tfg' where id='3009';
[10/17/2020 08:42:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='3009',config_key='VOUCHER_DATE', config_value='2020-10-17 08:42:54',create_date='2020-10-17 08:42:54';
[10/17/2020 08:42:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/384' where id='3009' and is_invoiced!='yes';
[10/17/2020 08:42:54], [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:42:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '22',credit_value= '49503280.348',credit_usage= '496719.652',credit_limit= '50000000',receipt_id= '',amount= '16.858281',booking_id='3009',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:54';
[10/17/2020 08:42:54], [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='3009',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-17 08:42:54',account_invoice='2020/384',particulars='';
[10/17/2020 08:42:54], [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 ('3009','0','1000.000','0','IP','0','1','purchase','booking_rate_info','1460','supplier');
[10/17/2020 08:42:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/384',acc_export='1' where bid='1460';
[10/17/2020 08:42:55], [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='3009',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-17 08:42:54',account_invoice='2020/384',particulars='';
[10/17/2020 08:42:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1461;
[10/17/2020 08:42:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1461',booking_id= '3009',invoice_number= '2020/384',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:42:55], [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 ('3009','4','71.150','9.2804347826087','OP','15','1','sale','booking_rate_info','1461','agent');
[10/17/2020 08:42:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/384',acc_export='1' where bid='1461';
[10/17/2020 08:42:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/384',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:42:57';
[10/17/2020 08:42:57], [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
        ('','','3009','vouchered-invoiced','2020-10-17 08:42:57',' by tfg','tfg','43.250.210.121','tfg','','');
[10/17/2020 08:42:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='3009',booking_detail_id ='3009',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:42:57';
[10/17/2020 08:42:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='3009',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/17/2020 08:42:57], [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
        ('','','3009','vouchered','2020-10-17 08:42:57','Vouchered By tfg by tfg','tfg','43.250.210.121','tfg','','');
[10/17/2020 08:42:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG303009/  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:42:59';
[10/17/2020 08:43:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG303009/  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:43:01';
[10/17/2020 08:43:02], [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:43:02',current_status='vouchered',voucher_hashcode='e8ef9df3086b7aaf2982f27d7e2bec64961853010',vouchered_by ='tfg' where id='3010';
[10/17/2020 08:43:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='3010',config_key='VOUCHER_DATE', config_value='2020-10-17 08:43:02',create_date='2020-10-17 08:43:02';
[10/17/2020 08:43:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/384' where id='3010' and is_invoiced!='yes';
[10/17/2020 08:43:02], [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:43:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '22',credit_value= '49503262.310',credit_usage= '496737.690',credit_limit= '50000000',receipt_id= '',amount= '18.0382422',booking_id='3010',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:02';
[10/17/2020 08:43:02], [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='3010',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-17 08:43:02',account_invoice='2020/384',particulars='';
[10/17/2020 08:43:03], [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 ('3010','0','1000.000','0','IP','0','1','purchase','booking_rate_info','1462','supplier');
[10/17/2020 08:43:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/384',acc_export='1' where bid='1462';
[10/17/2020 08:43:03], [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='3010',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-17 08:43:02',account_invoice='2020/384',particulars='';
[10/17/2020 08:43:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1463;
[10/17/2020 08:43:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1463',booking_id= '3010',invoice_number= '2020/384',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:43:03], [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 ('3010','4','76.130','9.93','OP','15','1','sale','booking_rate_info','1463','agent');
[10/17/2020 08:43:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/384',acc_export='1' where bid='1463';
[10/17/2020 08:43:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/384',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:43:05';
[10/17/2020 08:43:05], [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
        ('','','3010','vouchered-invoiced','2020-10-17 08:43:05',' by tfg','tfg','43.250.210.121','tfg','','');
[10/17/2020 08:43:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='3010',booking_detail_id ='3010',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:43:05';
[10/17/2020 08:43:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='3010',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/17/2020 08:43:05], [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
        ('','','3010','vouchered','2020-10-17 08:43:05','Vouchered By tfg by tfg','tfg','43.250.210.121','tfg','','');
[10/17/2020 08:43:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG303010/  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:43:07';
[10/17/2020 08:43:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG303010/  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:43:09';
[10/17/2020 08:58:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],UPDATE tax_master SET `tax_name`= 'UAT',`tax_value`= '10',`tax_type`= 'OP',`updated_by`= 'tfg',`updated_on`= '2020-10-17 08:58:36',`reverse`= '0'   WHERE id='5' ;
[10/17/2020 08:58:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-17 08:58:36',`log_type`= 'Tax Master',`sql_query`= 'UPDATE tax_master SET `tax_name`= \&#039;UAT\&#039;,`tax_value`= \&#039;10\&#039;,`tax_type`= \&#039;OP\&#039;,`updated_by`= \&#039;tfg\&#039;,`updated_on`= \&#039;2020-10-17 08:58:36\&#039;,`reverse`= \&#039;0\&#039;   WHERE id=\&#039;5\&#039; ',`log_description`= 'Tax Master updated for UAT value 10 and type OP',`ip`= '43.250.210.121';
