[10/16/2020 08:11:39], [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:39',current_status='vouchered',voucher_hashcode='b54f6410f8d13eccc8e586281e659523346762982',vouchered_by ='tfg' where id='2982';
[10/16/2020 08:11:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2982',config_key='VOUCHER_DATE', config_value='2020-10-16 08:11:39',create_date='2020-10-16 08:11:39';
[10/16/2020 08:11:39], [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='2982' and is_invoiced!='yes';
[10/16/2020 08:11:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('301607.2884672'),   credit_value= credit_value-('301607.2884672') ,  cd_credit_usage=cd_credit_usage+('301607.2884672') , cd_credit_value=cd_credit_value-('301607.2884672')  WHERE id = '21';
[10/16/2020 08:11:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '21',credit_value= '-868078.862',credit_usage= '3696796.382',credit_limit= '2828717.52',receipt_id= '',amount= '301607.2884672',booking_id='2982',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:39';
[10/16/2020 08:11:39], [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='4000',supplier_type='offline',supplier_id='S000000003',acc_type='purchase',accounting_multiplier='1.00000',booking_id='2982',booking_log='Sightseeing Booking Vouchered',type='Sale',create_date='2020-10-16 08:11:39',account_invoice='2020/380',particulars='';
[10/16/2020 08:11:39], [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 ('2982','0','4000.000','0','IP','0','3','purchase','booking_rate_info','1410','supplier');
[10/16/2020 08:11:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='19509.12',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='0.23694',booking_id='2982',booking_log='Sightseeing Booking Vouchered',type='Sale',create_date='2020-10-16 08:11:39',account_invoice='2020/380',particulars='';
[10/16/2020 08:11:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1411;
[10/16/2020 08:11:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1411',booking_id= '2982',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= '19509.120',total_price= '19509.120';
[10/16/2020 08:11:39], [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 ('2982','4','19509.120','2544.667826087','OP','15','3','sale','booking_rate_info','1411','agent');
[10/16/2020 08:11:41], [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, 57212 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:41';
[10/16/2020 08:11:41], [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
        ('','','2982','vouchered-invoiced','2020-10-16 08:11:41',' by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 08:11:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2982',booking_detail_id ='2982',agent_id ='21',is_sub_agent ='N',parent_id ='',display_commission ='2626.876544',display_currency ='MYR',paid ='N',type ='sightseeing',description ='Agent Mark Up Percentage is 15.56 %',create_date ='2020-10-16 08:11:41';
[10/16/2020 08:11:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2982',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/16/2020 08:11:41], [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
        ('','','2982','vouchered','2020-10-16 08:11:41','Vouchered By tfg by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 08:11:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG202982/   Booking Vouchered ',from_email_id= '',body= '[encoded data, 19224 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:43';
[10/16/2020 08:11:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG202982/   Booking Vouchered ',from_email_id= '',body= '[encoded data, 19224 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:45';
