[09/29/2020 11:45:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302960/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 41828 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-09-29 11:45:31';
[09/29/2020 11:45:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='test',status_date='2020-09-29 11:45:32',current_status='vouchered',voucher_hashcode='886b226bf58d2f6ae07071b7567667c0961862961',vouchered_by ='tfg' where id='2961';
[09/29/2020 11:45:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2961',config_key='VOUCHER_DATE', config_value='2020-09-29 11:45:32',create_date='2020-09-29 11:45:32';
[09/29/2020 11:45:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/379' where id='2961' and is_invoiced!='yes';
[09/29/2020 11:45:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('2199.930963'),   credit_value= credit_value-('2199.930963') ,  cd_credit_usage=cd_credit_usage+('2199.930963') , cd_credit_value=cd_credit_value-('2199.930963')  WHERE id = '21';
[09/29/2020 11:45:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '21',credit_value= '-20066.545',credit_usage= '2848784.065',credit_limit= '2828717.52',receipt_id= '',amount= '2199.930963',booking_id='2961',booking_cost= '142.3',receipt_allocation= '',balance= '142.3',ip='43.250.210.87',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-09-29 11:09:33';
[09/29/2020 11:45:33], [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='2000',supplier_type='offline',supplier_id='S000000066',acc_type='purchase',accounting_multiplier='0.01533',booking_id='2961',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-09-29 11:45:33',account_invoice='2020/379',particulars='';
[09/29/2020 11:45:33], [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 ('2961','0','2000.000','0','IP','0','3','purchase','booking_rate_info','1386','supplier');
[09/29/2020 11:45:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='142.3',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='0.23694',booking_id='2961',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-09-29 11:45:33',account_invoice='2020/379',particulars='';
[09/29/2020 11:45:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1387;
[09/29/2020 11:45:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1387',booking_id= '2961',invoice_number= '2020/379',service_type= 'transfer',booking_type= 'offline',service_name= 'Srilanka Transfer Test',type= 'sale',from_date= '2020-10-02',to_date= '2020-10-02',price= '142.300',total_price= '142.300';
[09/29/2020 11:45:33], [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 ('2961','4','142.300','18.560869565217','OP','15','3','sale','booking_rate_info','1387','agent');
[09/29/2020 11:45:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/379',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 47484 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-09-29 11:45:35';
[09/29/2020 11:45:35], [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
        ('','','2961','vouchered-invoiced','2020-09-29 11:45:35',' by tfg','tfg','43.250.210.87','tfg','','');
[09/29/2020 11:45:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2961',booking_detail_id ='2961',agent_id ='21',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-09-29 11:45:35';
[09/29/2020 11:45:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2961',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[09/29/2020 11:45:35], [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
        ('','','2961','vouchered','2020-09-29 11:45:35','Vouchered By tfg by tfg','tfg','43.250.210.87','tfg','','');
[09/29/2020 11:45:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302961/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 44212 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-09-29 11:45:37';
[09/29/2020 11:45:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302961/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 44212 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-09-29 11:45:39';
[09/29/2020 11:45:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='test',status_date='2020-09-29 11:45:41',current_status='vouchered',voucher_hashcode='e49e67a0db0a3bf44500260de13bac23984472962',vouchered_by ='tfg' where id='2962';
[09/29/2020 11:45:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2962',config_key='VOUCHER_DATE', config_value='2020-09-29 11:45:41',create_date='2020-09-29 11:45:41';
[09/29/2020 11:45:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/379' where id='2962' and is_invoiced!='yes';
[09/29/2020 11:45:41], [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';
[09/29/2020 11:45:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '21',credit_value= '-21243.500',credit_usage= '2849961.020',credit_limit= '2828717.52',receipt_id= '',amount= '1176.9553353',booking_id='2962',booking_cost= '76.13',receipt_allocation= '',balance= '76.13',ip='43.250.210.87',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-09-29 11:09:41';
[09/29/2020 11:45:41], [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='2962',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-09-29 11:45:41',account_invoice='2020/379',particulars='';
[09/29/2020 11:45:41], [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 ('2962','0','1000.000','0','IP','0','3','purchase','booking_rate_info','1388','supplier');
[09/29/2020 11:45:42], [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='2962',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-09-29 11:45:41',account_invoice='2020/379',particulars='';
[09/29/2020 11:45:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1389;
[09/29/2020 11:45:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1389',booking_id= '2962',invoice_number= '2020/379',service_type= 'transfer',booking_type= 'offline',service_name= 'Leisure Day',type= 'sale',from_date= '2020-10-02',to_date= '2020-10-02',price= '76.130',total_price= '76.130';
[09/29/2020 11:45:42], [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 ('2962','4','76.130','9.93','OP','15','3','sale','booking_rate_info','1389','agent');
[09/29/2020 11:45:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/379',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 49092 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-09-29 11:45:44';
[09/29/2020 11:45:44], [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
        ('','','2962','vouchered-invoiced','2020-09-29 11:45:44',' by tfg','tfg','43.250.210.87','tfg','','');
[09/29/2020 11:45:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2962',booking_detail_id ='2962',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-09-29 11:45:44';
[09/29/2020 11:45:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2962',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[09/29/2020 11:45:44], [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
        ('','','2962','vouchered','2020-09-29 11:45:44','Vouchered By tfg by tfg','tfg','43.250.210.87','tfg','','');
[09/29/2020 11:45:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302962/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 41620 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-09-29 11:45:46';
[09/29/2020 11:45:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302962/  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-09-29 11:45:48';
[09/29/2020 11:45:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='test',status_date='2020-09-29 11:45:50',current_status='vouchered',voucher_hashcode='1920c310623260544e509acf23997845572892963',vouchered_by ='tfg' where id='2963';
[09/29/2020 11:45:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2963',config_key='VOUCHER_DATE', config_value='2020-09-29 11:45:50',create_date='2020-09-29 11:45:50';
[09/29/2020 11:45:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/379' where id='2963' and is_invoiced!='yes';
[09/29/2020 11:45:50], [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';
[09/29/2020 11:45:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '21',credit_value= '-22343.465',credit_usage= '2851060.985',credit_limit= '2828717.52',receipt_id= '',amount= '1099.9654815',booking_id='2963',booking_cost= '71.15',receipt_allocation= '',balance= '71.15',ip='43.250.210.87',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-09-29 11:09:50';
[09/29/2020 11:45:50], [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='2963',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-09-29 11:45:50',account_invoice='2020/379',particulars='';
[09/29/2020 11:45:50], [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 ('2963','0','1000.000','0','IP','0','3','purchase','booking_rate_info','1390','supplier');
[09/29/2020 11:45:50], [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='2963',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-09-29 11:45:50',account_invoice='2020/379',particulars='';
[09/29/2020 11:45:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1391;
[09/29/2020 11:45:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1391',booking_id= '2963',invoice_number= '2020/379',service_type= 'transfer',booking_type= 'offline',service_name= 'Srilanka Transfer Test',type= 'sale',from_date= '2020-10-04',to_date= '2020-10-04',price= '71.150',total_price= '71.150';
[09/29/2020 11:45:50], [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 ('2963','4','71.150','9.2804347826087','OP','15','3','sale','booking_rate_info','1391','agent');
[09/29/2020 11:45:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/379',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 50716 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-09-29 11:45:52';
[09/29/2020 11:45:52], [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
        ('','','2963','vouchered-invoiced','2020-09-29 11:45:52',' by tfg','tfg','43.250.210.87','tfg','','');
[09/29/2020 11:45:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2963',booking_detail_id ='2963',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-09-29 11:45:52';
[09/29/2020 11:45:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2963',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[09/29/2020 11:45:52], [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
        ('','','2963','vouchered','2020-09-29 11:45:52','Vouchered By tfg by tfg','tfg','43.250.210.87','tfg','','');
[09/29/2020 11:45:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302963/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 33464 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-09-29 11:45:54';
[09/29/2020 11:45:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302963/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 33464 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-09-29 11:45:56';
[09/29/2020 11:45:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='test',status_date='2020-09-29 11:45:58',current_status='vouchered',voucher_hashcode='8ec6eeef456428a4d6cb73943641883a939682964',vouchered_by ='tfg' where id='2964';
[09/29/2020 11:45:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2964',config_key='VOUCHER_DATE', config_value='2020-09-29 11:45:58',create_date='2020-09-29 11:45:58';
[09/29/2020 11:45:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/379' where id='2964' and is_invoiced!='yes';
[09/29/2020 11:45:58], [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';
[09/29/2020 11:45:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '21',credit_value= '-23520.420',credit_usage= '2852237.940',credit_limit= '2828717.52',receipt_id= '',amount= '1176.9553353',booking_id='2964',booking_cost= '76.13',receipt_allocation= '',balance= '76.13',ip='43.250.210.87',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-09-29 11:09:58';
[09/29/2020 11:45:58], [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='2964',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-09-29 11:45:58',account_invoice='2020/379',particulars='';
[09/29/2020 11:45: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 ('2964','0','1000.000','0','IP','0','3','purchase','booking_rate_info','1392','supplier');
[09/29/2020 11:45:59], [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='2964',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-09-29 11:45:58',account_invoice='2020/379',particulars='';
[09/29/2020 11:45:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1393;
[09/29/2020 11:45:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1393',booking_id= '2964',invoice_number= '2020/379',service_type= 'transfer',booking_type= 'offline',service_name= 'Leisure Day',type= 'sale',from_date= '2020-10-03',to_date= '2020-10-03',price= '76.130',total_price= '76.130';
[09/29/2020 11:45:59], [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 ('2964','4','76.130','9.93','OP','15','3','sale','booking_rate_info','1393','agent');
[09/29/2020 11:46:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/379',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 52324 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-09-29 11:46:01';
