[10/16/2020 08:11:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2978',config_key='VOUCHER_DATE', config_value='2020-10-16 08:11:06',create_date='2020-10-16 08:11:06';
[10/16/2020 08:11:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/380' where id='2978' and is_invoiced!='yes';
[10/16/2020 08:11:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('1099.9654815'),   credit_value= credit_value-('1099.9654815') ,  cd_credit_usage=cd_credit_usage+('1099.9654815') , cd_credit_value=cd_credit_value-('1099.9654815')  WHERE id = '21';
[10/16/2020 08:11:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '21',credit_value= '-28780.156',credit_usage= '2857497.676',credit_limit= '2828717.52',receipt_id= '',amount= '1099.9654815',booking_id='2978',booking_cost= '71.15',receipt_allocation= '',balance= '71.15',ip='103.104.226.130',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-10-16 08:10:06';
[10/16/2020 08:11: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='S000000066',acc_type='purchase',accounting_multiplier='0.01533',booking_id='2978',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-16 08:11:06',account_invoice='2020/380',particulars='';
[10/16/2020 08:11: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 ('2978','0','1000.000','0','IP','0','3','purchase','booking_rate_info','1402','supplier');
[10/16/2020 08:11:06], [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='2978',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-16 08:11:06',account_invoice='2020/380',particulars='';
[10/16/2020 08:11:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1403;
[10/16/2020 08:11:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1403',booking_id= '2978',invoice_number= '2020/380',service_type= 'transfer',booking_type= 'offline',service_name= 'Srilanka Transfer Test',type= 'sale',from_date= '2020-11-14',to_date= '2020-11-14',price= '71.150',total_price= '71.150';
[10/16/2020 08:11: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 ('2978','4','71.150','9.2804347826087','OP','15','3','sale','booking_rate_info','1403','agent');
[10/16/2020 08:11:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/380',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 50712 characters]',to_email_id= 'ankita.rao@qtechsoftware.com,snehal.valanju@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-16 08:11:09';
[10/16/2020 08:11: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
        ('','','2978','vouchered-invoiced','2020-10-16 08:11:09',' by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 08:11:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2978',booking_detail_id ='2978',agent_id ='21',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-16 08:11:09';
[10/16/2020 08:11:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2978',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/16/2020 08:11: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
        ('','','2978','vouchered','2020-10-16 08:11:09','Vouchered By tfg by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 08:11:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302978/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 33456 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-16 08:11:11';
[10/16/2020 08:11:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302978/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 33456 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-16 08:11:13';
[10/16/2020 08:11:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='testbooking',status_date='2020-10-16 08:11:14',current_status='vouchered',voucher_hashcode='cf23cd17058f3f42659801ce6aa93e3e328532979',vouchered_by ='tfg' where id='2979';
[10/16/2020 08:11:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2979',config_key='VOUCHER_DATE', config_value='2020-10-16 08:11:14',create_date='2020-10-16 08:11:14';
[10/16/2020 08:11:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/380' where id='2979' and is_invoiced!='yes';
[10/16/2020 08:11:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('1176.9553353'),   credit_value= credit_value-('1176.9553353') ,  cd_credit_usage=cd_credit_usage+('1176.9553353') , cd_credit_value=cd_credit_value-('1176.9553353')  WHERE id = '21';
[10/16/2020 08:11:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '21',credit_value= '-29957.111',credit_usage= '2858674.631',credit_limit= '2828717.52',receipt_id= '',amount= '1176.9553353',booking_id='2979',booking_cost= '76.13',receipt_allocation= '',balance= '76.13',ip='103.104.226.130',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-10-16 08:10:14';
[10/16/2020 08:11:14], [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='2979',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-16 08:11:14',account_invoice='2020/380',particulars='';
[10/16/2020 08:11:14], [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 ('2979','0','1000.000','0','IP','0','3','purchase','booking_rate_info','1404','supplier');
[10/16/2020 08:11:15], [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='2979',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-16 08:11:14',account_invoice='2020/380',particulars='';
[10/16/2020 08:11:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1405;
[10/16/2020 08:11:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1405',booking_id= '2979',invoice_number= '2020/380',service_type= 'transfer',booking_type= 'offline',service_name= 'Leisure Day',type= 'sale',from_date= '2020-11-13',to_date= '2020-11-13',price= '76.130',total_price= '76.130';
[10/16/2020 08:11:15], [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 ('2979','4','76.130','9.93','OP','15','3','sale','booking_rate_info','1405','agent');
[10/16/2020 08:11:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/380',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 52320 characters]',to_email_id= 'ankita.rao@qtechsoftware.com,snehal.valanju@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-16 08:11:17';
[10/16/2020 08:11:17], [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
        ('','','2979','vouchered-invoiced','2020-10-16 08:11:17',' by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 08:11:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2979',booking_detail_id ='2979',agent_id ='21',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-16 08:11:17';
[10/16/2020 08:11:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2979',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/16/2020 08:11:17], [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
        ('','','2979','vouchered','2020-10-16 08:11:17','Vouchered By tfg by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 08:11:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302979/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 41616 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-16 08:11:19';
[10/16/2020 08:11:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302979/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 41616 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-16 08:11:21';
[10/16/2020 08:11:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='testbooking',status_date='2020-10-16 08:11:22',current_status='vouchered',voucher_hashcode='a0c102f5ee4262abc8eb097c1cc3117c767092980',vouchered_by ='tfg' where id='2980';
[10/16/2020 08:11:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2980',config_key='VOUCHER_DATE', config_value='2020-10-16 08:11:22',create_date='2020-10-16 08:11:22';
[10/16/2020 08:11:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/380' where id='2980' and is_invoiced!='yes';
[10/16/2020 08:11:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('263710.6562142'),   credit_value= credit_value-('263710.6562142') ,  cd_credit_usage=cd_credit_usage+('263710.6562142') , cd_credit_value=cd_credit_value-('263710.6562142')  WHERE id = '21';
[10/16/2020 08:11:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '21',credit_value= '-293667.767',credit_usage= '3122385.287',credit_limit= '2828717.52',receipt_id= '',amount= '263710.6562142',booking_id='2980',booking_cost= '',receipt_allocation= '',balance= '',ip='103.104.226.130',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-10-16 08:10:22';
[10/16/2020 08:11:22], [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='USD',supplier_price='3497.4',supplier_type='offline',supplier_id='S000000003',acc_type='purchase',accounting_multiplier='1.00000',booking_id='2980',booking_log='Sightseeing Booking Vouchered',type='Sale',create_date='2020-10-16 08:11:22',account_invoice='2020/380',particulars='';
[10/16/2020 08:11:22], [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 ('2980','0','3497.400','0','IP','0','3','purchase','booking_rate_info','1406','supplier');
[10/16/2020 08:11:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='17057.82',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='0.23694',booking_id='2980',booking_log='Sightseeing Booking Vouchered',type='Sale',create_date='2020-10-16 08:11:22',account_invoice='2020/380',particulars='';
[10/16/2020 08:11:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1407;
[10/16/2020 08:11:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1407',booking_id= '2980',invoice_number= '2020/380',service_type= 'sightseeing',booking_type= 'offline',service_name= 'Colombo by tuk tuk',type= 'sale',from_date= '2020-11-24',to_date= '',price= '17057.820',total_price= '17057.820';
[10/16/2020 08:11:23], [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 ('2980','4','17057.820','2224.9330434783','OP','15','3','sale','booking_rate_info','1407','agent');
[10/16/2020 08:11:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/380',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 53952 characters]',to_email_id= 'ankita.rao@qtechsoftware.com,snehal.valanju@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-16 08:11:25';
[10/16/2020 08:11:25], [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
        ('','','2980','vouchered-invoiced','2020-10-16 08:11:25',' by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 08:11:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2980',booking_detail_id ='2980',agent_id ='21',is_sub_agent ='N',parent_id ='',display_commission ='2296.8095062464',display_currency ='MYR',paid ='N',type ='sightseeing',description ='Agent Mark Up Percentage is 15.56 %',create_date ='2020-10-16 08:11:25';
[10/16/2020 08:11:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2980',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/16/2020 08:11:25], [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
        ('','','2980','vouchered','2020-10-16 08:11:25','Vouchered By tfg by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 08:11:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG202980/   Booking Vouchered ',from_email_id= '',body= '[encoded data, 19228 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-16 08:11:27';
[10/16/2020 08:11:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG202980/   Booking Vouchered ',from_email_id= '',body= '[encoded data, 19228 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-16 08:11:29';
[10/16/2020 08:11:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='testbooking',status_date='2020-10-16 08:11:31',current_status='vouchered',voucher_hashcode='1942325b48098c419e896acd7fe4b4d6927072981',vouchered_by ='tfg' where id='2981';
[10/16/2020 08:11:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2981',config_key='VOUCHER_DATE', config_value='2020-10-16 08:11:31',create_date='2020-10-16 08:11:31';
[10/16/2020 08:11:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/380' where id='2981' and is_invoiced!='yes';
[10/16/2020 08:11:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('272803.80726'),   credit_value= credit_value-('272803.80726') ,  cd_credit_usage=cd_credit_usage+('272803.80726') , cd_credit_value=cd_credit_value-('272803.80726')  WHERE id = '21';
[10/16/2020 08:11:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '21',credit_value= '-566471.574',credit_usage= '3395189.094',credit_limit= '2828717.52',receipt_id= '',amount= '272803.80726',booking_id='2981',booking_cost= '',receipt_allocation= '',balance= '',ip='103.104.226.130',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-10-16 08:10:31';
[10/16/2020 08:11:31], [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='USD',supplier_price='3618',supplier_type='offline',supplier_id='S000000003',acc_type='purchase',accounting_multiplier='1.00000',booking_id='2981',booking_log='Sightseeing Booking Vouchered',type='Sale',create_date='2020-10-16 08:11:31',account_invoice='2020/380',particulars='';
[10/16/2020 08:11:31], [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 ('2981','0','3618.000','0','IP','0','3','purchase','booking_rate_info','1408','supplier');
[10/16/2020 08:11:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='17646',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='0.23694',booking_id='2981',booking_log='Sightseeing Booking Vouchered',type='Sale',create_date='2020-10-16 08:11:31',account_invoice='2020/380',particulars='';
[10/16/2020 08:11:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1409;
[10/16/2020 08:11:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1409',booking_id= '2981',invoice_number= '2020/380',service_type= 'sightseeing',booking_type= 'offline',service_name= 'Colombo by tuk tuk',type= 'sale',from_date= '2020-11-24',to_date= '',price= '17646.000',total_price= '17646.000';
[10/16/2020 08:11:31], [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 ('2981','4','17646.000','2301.652173913','OP','15','3','sale','booking_rate_info','1409','agent');
[10/16/2020 08:11:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/380',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 55580 characters]',to_email_id= 'ankita.rao@qtechsoftware.com,snehal.valanju@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-16 08:11:33';
[10/16/2020 08:11:33], [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
        ('','','2981','vouchered-invoiced','2020-10-16 08:11:33',' by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 08:11:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2981',booking_detail_id ='2981',agent_id ='21',is_sub_agent ='N',parent_id ='',display_commission ='2376.009834048',display_currency ='MYR',paid ='N',type ='sightseeing',description ='Agent Mark Up Percentage is 15.56 %',create_date ='2020-10-16 08:11:33';
[10/16/2020 08:11:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2981',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/16/2020 08:11:34], [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
        ('','','2981','vouchered','2020-10-16 08:11:34','Vouchered By tfg by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 08:11:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG202981/   Booking Vouchered ',from_email_id= '',body= '[encoded data, 19220 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-16 08:11:35';
[10/16/2020 08:11:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG202981/   Booking Vouchered ',from_email_id= '',body= '[encoded data, 19220 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-16 08:11:37';
