[10/16/2020 09:38:29], [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
        ('','','2989','vouchered-invoiced','2020-10-16 09:38:29',' by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 09:38:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2989',booking_detail_id ='2989',agent_id ='22',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 09:38:29';
[10/16/2020 09:38:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2989',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/16/2020 09:38:29], [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
        ('','','2989','vouchered','2020-10-16 09:38:29','Vouchered By tfg by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 09:38:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG202989/   Booking Vouchered ',from_email_id= '',body= '[encoded data, 19228 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:31';
[10/16/2020 09:38:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG202989/   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 09:38:33';
[10/16/2020 09:38:34], [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:34',current_status='vouchered',voucher_hashcode='3f8522a516d9b30ac229b65a067ca02a281082990',vouchered_by ='tfg' where id='2990';
[10/16/2020 09:38:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2990',config_key='VOUCHER_DATE', config_value='2020-10-16 09:38:34',create_date='2020-10-16 09:38:34';
[10/16/2020 09:38:34], [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='2990' and is_invoiced!='yes';
[10/16/2020 09:38:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('4181.04324'),   credit_value= credit_value-('4181.04324') ,  cd_credit_usage=cd_credit_usage+('4181.04324') , cd_credit_value=cd_credit_value-('4181.04324')  WHERE id = '22';
[10/16/2020 09:38:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '22',credit_value= '49520927.313',credit_usage= '479072.687',credit_limit= '50000000',receipt_id= '',amount= '4181.04324',booking_id='2990',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:34';
[10/16/2020 09:38:34], [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='2990',booking_log='Sightseeing Booking Vouchered',type='Sale',create_date='2020-10-16 09:38:34',account_invoice='2020/381',particulars='';
[10/16/2020 09:38:34], [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 ('2990','0','3618.000','0','IP','0','1','purchase','booking_rate_info','1426','supplier');
[10/16/2020 09:38:35], [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='1426';
[10/16/2020 09:38:35], [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='2990',booking_log='Sightseeing Booking Vouchered',type='Sale',create_date='2020-10-16 09:38:34',account_invoice='2020/381',particulars='';
[10/16/2020 09:38:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1427;
[10/16/2020 09:38:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1427',booking_id= '2990',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= '17646.000',total_price= '17646.000';
[10/16/2020 09:38:35], [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 ('2990','4','17646.000','2301.652173913','OP','15','1','sale','booking_rate_info','1427','agent');
[10/16/2020 09:38:36], [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='1427';
[10/16/2020 09:38:37], [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, 55508 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:37';
[10/16/2020 09:38:37], [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
        ('','','2990','vouchered-invoiced','2020-10-16 09:38:37',' by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 09:38:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2990',booking_detail_id ='2990',agent_id ='22',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 09:38:37';
[10/16/2020 09:38:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2990',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/16/2020 09:38:38], [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
        ('','','2990','vouchered','2020-10-16 09:38:38','Vouchered By tfg by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 09:38:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG202990/   Booking Vouchered ',from_email_id= '',body= '[encoded data, 19220 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:39';
[10/16/2020 09:38:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG202990/   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 09:38:41';
[10/16/2020 09:38:43], [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:43',current_status='vouchered',voucher_hashcode='842a7fc8e9e5b0df6e0f29d3b22dcde8136612991',vouchered_by ='tfg' where id='2991';
[10/16/2020 09:38:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2991',config_key='VOUCHER_DATE', config_value='2020-10-16 09:38:43',create_date='2020-10-16 09:38:43';
[10/16/2020 09:38:43], [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='2991' and is_invoiced!='yes';
[10/16/2020 09:38:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('4622.4908928'),   credit_value= credit_value-('4622.4908928') ,  cd_credit_usage=cd_credit_usage+('4622.4908928') , cd_credit_value=cd_credit_value-('4622.4908928')  WHERE id = '22';
[10/16/2020 09:38:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '22',credit_value= '49516304.822',credit_usage= '483695.178',credit_limit= '50000000',receipt_id= '',amount= '4622.4908928',booking_id='2991',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:43';
[10/16/2020 09:38:43], [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='2991',booking_log='Sightseeing Booking Vouchered',type='Sale',create_date='2020-10-16 09:38:43',account_invoice='2020/381',particulars='';
[10/16/2020 09:38:43], [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 ('2991','0','4000.000','0','IP','0','1','purchase','booking_rate_info','1428','supplier');
[10/16/2020 09:38:43], [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='1428';
[10/16/2020 09:38:43], [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='2991',booking_log='Sightseeing Booking Vouchered',type='Sale',create_date='2020-10-16 09:38:43',account_invoice='2020/381',particulars='';
[10/16/2020 09:38:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1429;
[10/16/2020 09:38:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1429',booking_id= '2991',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= '19509.120',total_price= '19509.120';
[10/16/2020 09:38:43], [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 ('2991','4','19509.120','2544.667826087','OP','15','1','sale','booking_rate_info','1429','agent');
[10/16/2020 09:38:44], [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='1429';
[10/16/2020 09:38:46], [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, 57140 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:46';
[10/16/2020 09:38:46], [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
        ('','','2991','vouchered-invoiced','2020-10-16 09:38:46',' by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 09:38:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2991',booking_detail_id ='2991',agent_id ='22',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 09:38:46';
[10/16/2020 09:38:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2991',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/16/2020 09:38:46], [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
        ('','','2991','vouchered','2020-10-16 09:38:46','Vouchered By tfg by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 09:38:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG202991/   Booking Vouchered ',from_email_id= '',body= '[encoded data, 19224 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:48';
[10/16/2020 09:38:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG202991/   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 09:38:49';
