[10/16/2020 09:37:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302985/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 44196 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-16 09:37:59';
[10/16/2020 09:38:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='testbooking',status_date='2020-10-16 09:38:00',current_status='vouchered',voucher_hashcode='225d4c68cf20925a0a3d22b3b18294f3864012986',vouchered_by ='tfg' where id='2986';
[10/16/2020 09:38:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2986',config_key='VOUCHER_DATE', config_value='2020-10-16 09:38:00',create_date='2020-10-16 09:38:00';
[10/16/2020 09:38:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/381' where id='2986' and is_invoiced!='yes';
[10/16/2020 09:38:00], [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/16/2020 09:38:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '22',credit_value= '49529184.932',credit_usage= '470815.068',credit_limit= '50000000',receipt_id= '',amount= '18.0382422',booking_id='2986',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 09:10:00';
[10/16/2020 09:38:00], [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='2986',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-16 09:38:00',account_invoice='2020/381',particulars='';
[10/16/2020 09:38:00], [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 ('2986','0','1000.000','0','IP','0','1','purchase','booking_rate_info','1418','supplier');
[10/16/2020 09:38:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/381',acc_export='1' where bid='1418';
[10/16/2020 09:38:01], [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='2986',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-16 09:38:00',account_invoice='2020/381',particulars='';
[10/16/2020 09:38:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1419;
[10/16/2020 09:38:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1419',booking_id= '2986',invoice_number= '2020/381',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/16/2020 09:38:01], [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 ('2986','4','76.130','9.93','OP','15','1','sale','booking_rate_info','1419','agent');
[10/16/2020 09:38:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/381',acc_export='1' where bid='1419';
[10/16/2020 09:38:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/381',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-16 09:38:03';
[10/16/2020 09:38:03], [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
        ('','','2986','vouchered-invoiced','2020-10-16 09:38:03',' by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 09:38:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2986',booking_detail_id ='2986',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-16 09:38:03';
[10/16/2020 09:38:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2986',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/16/2020 09:38:03], [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
        ('','','2986','vouchered','2020-10-16 09:38:03','Vouchered By tfg by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 09:38:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302986/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 41616 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-16 09:38:05';
[10/16/2020 09:38:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302986/  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 09:38:07';
[10/16/2020 09:38:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='testbooking',status_date='2020-10-16 09:38:09',current_status='vouchered',voucher_hashcode='e6e7f48e84815bd139bf0384566dbb6c956022987',vouchered_by ='tfg' where id='2987';
[10/16/2020 09:38:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2987',config_key='VOUCHER_DATE', config_value='2020-10-16 09:38:09',create_date='2020-10-16 09:38:09';
[10/16/2020 09:38:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/381' where id='2987' and is_invoiced!='yes';
[10/16/2020 09:38:09], [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/16/2020 09:38:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '22',credit_value= '49529168.074',credit_usage= '470831.926',credit_limit= '50000000',receipt_id= '',amount= '16.858281',booking_id='2987',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 09:10:09';
[10/16/2020 09:38:09], [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='2987',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-16 09:38:09',account_invoice='2020/381',particulars='';
[10/16/2020 09:38:09], [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 ('2987','0','1000.000','0','IP','0','1','purchase','booking_rate_info','1420','supplier');
[10/16/2020 09:38:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/381',acc_export='1' where bid='1420';
[10/16/2020 09:38:09], [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='2987',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-16 09:38:09',account_invoice='2020/381',particulars='';
[10/16/2020 09:38:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1421;
[10/16/2020 09:38:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1421',booking_id= '2987',invoice_number= '2020/381',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/16/2020 09:38:10], [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 ('2987','4','71.150','9.2804347826087','OP','15','1','sale','booking_rate_info','1421','agent');
[10/16/2020 09:38:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/381',acc_export='1' where bid='1421';
[10/16/2020 09:38:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/381',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-16 09:38:12';
[10/16/2020 09:38:12], [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
        ('','','2987','vouchered-invoiced','2020-10-16 09:38:12',' by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 09:38:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2987',booking_detail_id ='2987',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-16 09:38:12';
[10/16/2020 09:38:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2987',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/16/2020 09:38:12], [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
        ('','','2987','vouchered','2020-10-16 09:38:12','Vouchered By tfg by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 09:38:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302987/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 33456 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-16 09:38:14';
[10/16/2020 09:38:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302987/  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 09:38:16';
[10/16/2020 09:38:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='testbooking',status_date='2020-10-16 09:38:17',current_status='vouchered',voucher_hashcode='bf5c9cf5d8b0b93f1c32ad284a8d233a782932988',vouchered_by ='tfg' where id='2988';
[10/16/2020 09:38:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2988',config_key='VOUCHER_DATE', config_value='2020-10-16 09:38:17',create_date='2020-10-16 09:38:17';
[10/16/2020 09:38:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/381' where id='2988' and is_invoiced!='yes';
[10/16/2020 09:38:17], [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/16/2020 09:38:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '22',credit_value= '49529150.036',credit_usage= '470849.964',credit_limit= '50000000',receipt_id= '',amount= '18.0382422',booking_id='2988',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 09:10:17';
[10/16/2020 09:38:17], [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='2988',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-16 09:38:17',account_invoice='2020/381',particulars='';
[10/16/2020 09:38:17], [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 ('2988','0','1000.000','0','IP','0','1','purchase','booking_rate_info','1422','supplier');
[10/16/2020 09:38:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/381',acc_export='1' where bid='1422';
[10/16/2020 09:38:18], [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='2988',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-16 09:38:17',account_invoice='2020/381',particulars='';
[10/16/2020 09:38:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1423;
[10/16/2020 09:38:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1423',booking_id= '2988',invoice_number= '2020/381',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/16/2020 09:38:18], [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 ('2988','4','76.130','9.93','OP','15','1','sale','booking_rate_info','1423','agent');
[10/16/2020 09:38:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/381',acc_export='1' where bid='1423';
[10/16/2020 09:38:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/381',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-16 09:38:20';
[10/16/2020 09:38:20], [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
        ('','','2988','vouchered-invoiced','2020-10-16 09:38:20',' by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 09:38:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2988',booking_detail_id ='2988',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-16 09:38:21';
[10/16/2020 09:38:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2988',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/16/2020 09:38:21], [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
        ('','','2988','vouchered','2020-10-16 09:38:21','Vouchered By tfg by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 09:38:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302988/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 41616 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-16 09:38:23';
[10/16/2020 09:38:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302988/  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 09:38:24';
[10/16/2020 09:38:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='testbooking',status_date='2020-10-16 09:38:26',current_status='vouchered',voucher_hashcode='6858a1bb2a9beb5102170e2869ac8d24128562989',vouchered_by ='tfg' where id='2989';
[10/16/2020 09:38:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2989',config_key='VOUCHER_DATE', config_value='2020-10-16 09:38:26',create_date='2020-10-16 09:38:26';
[10/16/2020 09:38:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/381' where id='2989' and is_invoiced!='yes';
[10/16/2020 09:38:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('4041.6798708'),   credit_value= credit_value-('4041.6798708') ,  cd_credit_usage=cd_credit_usage+('4041.6798708') , cd_credit_value=cd_credit_value-('4041.6798708')  WHERE id = '22';
[10/16/2020 09:38:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '22',credit_value= '49525108.356',credit_usage= '474891.644',credit_limit= '50000000',receipt_id= '',amount= '4041.6798708',booking_id='2989',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 09:10:26';
[10/16/2020 09:38:26], [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='2989',booking_log='Sightseeing Booking Vouchered',type='Sale',create_date='2020-10-16 09:38:26',account_invoice='2020/381',particulars='';
[10/16/2020 09:38:26], [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 ('2989','0','3497.400','0','IP','0','1','purchase','booking_rate_info','1424','supplier');
[10/16/2020 09:38:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/381',acc_export='1' where bid='1424';
[10/16/2020 09:38:27], [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='2989',booking_log='Sightseeing Booking Vouchered',type='Sale',create_date='2020-10-16 09:38:26',account_invoice='2020/381',particulars='';
[10/16/2020 09:38:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1425;
[10/16/2020 09:38:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1425',booking_id= '2989',invoice_number= '2020/381',service_type= 'sightseeing',booking_type= 'offline',service_name= 'Colombo by tuk tuk',type= 'sale',from_date= '2020-10-26',to_date= '',price= '17057.820',total_price= '17057.820';
[10/16/2020 09:38:27], [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 ('2989','4','17057.820','2224.9330434783','OP','15','1','sale','booking_rate_info','1425','agent');
[10/16/2020 09:38:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/381',acc_export='1' where bid='1425';
[10/16/2020 09:38:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/381',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 53880 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-16 09:38:29';
