[10/16/2020 08:10:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302974/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 41836 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-16 08:10:39';
[10/16/2020 08:10:41], [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:10:41',current_status='vouchered',voucher_hashcode='87fb750fa0b736f9560455035a197508702212975',vouchered_by ='tfg' where id='2975';
[10/16/2020 08:10:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2975',config_key='VOUCHER_DATE', config_value='2020-10-16 08:10:41',create_date='2020-10-16 08:10:41';
[10/16/2020 08:10:41], [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='2975' and is_invoiced!='yes';
[10/16/2020 08:10:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('134.9641413'),   credit_value= credit_value-('134.9641413') ,  cd_credit_usage=cd_credit_usage+('134.9641413') , cd_credit_value=cd_credit_value-('134.9641413')  WHERE id = '21';
[10/16/2020 08:10: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= '-24303.305',credit_usage= '2853020.825',credit_limit= '2828717.52',receipt_id= '',amount= '134.9641413',booking_id='2975',booking_cost= '8.73',receipt_allocation= '',balance= '8.73',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:41';
[10/16/2020 08:10: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='67.5',supplier_type='offline',supplier_id='S000000066',acc_type='purchase',accounting_multiplier='0.01533',booking_id='2975',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-16 08:10:41',account_invoice='2020/380',particulars='';
[10/16/2020 08:10: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 ('2975','0','67.500','0','IP','0','3','purchase','booking_rate_info','1396','supplier');
[10/16/2020 08:10:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='8.73',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='0.23694',booking_id='2975',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-16 08:10:41',account_invoice='2020/380',particulars='';
[10/16/2020 08:10:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1397;
[10/16/2020 08:10:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1397',booking_id= '2975',invoice_number= '2020/380',service_type= 'transfer',booking_type= 'offline',service_name= 'Srilanka Transfer Test',type= 'sale',from_date= '2020-11-11',to_date= '2020-11-11',price= '8.730',total_price= '8.730';
[10/16/2020 08:10: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 ('2975','4','8.730','1.1386956521739','OP','15','3','sale','booking_rate_info','1397','agent');
[10/16/2020 08:10:44], [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, 45848 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:10:44';
[10/16/2020 08:10: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
        ('','','2975','vouchered-invoiced','2020-10-16 08:10:44',' by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 08:10:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2975',booking_detail_id ='2975',agent_id ='21',is_sub_agent ='N',parent_id ='',display_commission ='4.3659',display_currency ='MYR',paid ='N',type ='transfer',description ='Agent Mark Up Percentage is 100 %',create_date ='2020-10-16 08:10:44';
[10/16/2020 08:10:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2975',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/16/2020 08:10: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
        ('','','2975','vouchered','2020-10-16 08:10:44','Vouchered By tfg by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 08:10:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302975/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 41820 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:10:46';
[10/16/2020 08:10:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302975/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 41820 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-16 08:10:48';
[10/16/2020 08:10:49], [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:10:49',current_status='vouchered',voucher_hashcode='7077d60fae608ff578d8e0fd70ad3274166802976',vouchered_by ='tfg' where id='2976';
[10/16/2020 08:10:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2976',config_key='VOUCHER_DATE', config_value='2020-10-16 08:10:49',create_date='2020-10-16 08:10:49';
[10/16/2020 08:10:49], [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='2976' and is_invoiced!='yes';
[10/16/2020 08:10:49], [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';
[10/16/2020 08:10:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '21',credit_value= '-26503.236',credit_usage= '2855220.756',credit_limit= '2828717.52',receipt_id= '',amount= '2199.930963',booking_id='2976',booking_cost= '142.3',receipt_allocation= '',balance= '142.3',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:49';
[10/16/2020 08:10:49], [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='2976',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-16 08:10:49',account_invoice='2020/380',particulars='';
[10/16/2020 08:10:49], [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 ('2976','0','2000.000','0','IP','0','3','purchase','booking_rate_info','1398','supplier');
[10/16/2020 08:10:50], [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='2976',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-16 08:10:49',account_invoice='2020/380',particulars='';
[10/16/2020 08:10:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1399;
[10/16/2020 08:10:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1399',booking_id= '2976',invoice_number= '2020/380',service_type= 'transfer',booking_type= 'offline',service_name= 'Srilanka Transfer Test',type= 'sale',from_date= '2020-11-12',to_date= '2020-11-12',price= '142.300',total_price= '142.300';
[10/16/2020 08:10: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 ('2976','4','142.300','18.560869565217','OP','15','3','sale','booking_rate_info','1399','agent');
[10/16/2020 08:10:52], [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, 47476 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:10:52';
[10/16/2020 08:10: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
        ('','','2976','vouchered-invoiced','2020-10-16 08:10:52',' by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 08:10:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2976',booking_detail_id ='2976',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-10-16 08:10:52';
[10/16/2020 08:10:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2976',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/16/2020 08:10: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
        ('','','2976','vouchered','2020-10-16 08:10:52','Vouchered By tfg by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 08:10:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302976/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 44196 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:10:54';
[10/16/2020 08:10:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302976/  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 08:10:56';
[10/16/2020 08:10:58], [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:10:58',current_status='vouchered',voucher_hashcode='7a22cd8ad759aaae950494a508a47850476422977',vouchered_by ='tfg' where id='2977';
[10/16/2020 08:10:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2977',config_key='VOUCHER_DATE', config_value='2020-10-16 08:10:58',create_date='2020-10-16 08:10:58';
[10/16/2020 08:10:58], [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='2977' and is_invoiced!='yes';
[10/16/2020 08:10: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';
[10/16/2020 08:10: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= '-27680.191',credit_usage= '2856397.711',credit_limit= '2828717.52',receipt_id= '',amount= '1176.9553353',booking_id='2977',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:58';
[10/16/2020 08:10: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='2977',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-16 08:10:58',account_invoice='2020/380',particulars='';
[10/16/2020 08:10: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 ('2977','0','1000.000','0','IP','0','3','purchase','booking_rate_info','1400','supplier');
[10/16/2020 08:10:58], [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='2977',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-16 08:10:58',account_invoice='2020/380',particulars='';
[10/16/2020 08:10:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1401;
[10/16/2020 08:10:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1401',booking_id= '2977',invoice_number= '2020/380',service_type= 'transfer',booking_type= 'offline',service_name= 'Leisure Day',type= 'sale',from_date= '2020-11-12',to_date= '2020-11-12',price= '76.130',total_price= '76.130';
[10/16/2020 08:10: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 ('2977','4','76.130','9.93','OP','15','3','sale','booking_rate_info','1401','agent');
[10/16/2020 08:11:01], [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, 49088 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:00';
[10/16/2020 08:11:01], [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
        ('','','2977','vouchered-invoiced','2020-10-16 08:11:01',' by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 08:11:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2977',booking_detail_id ='2977',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:01';
[10/16/2020 08:11:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2977',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/16/2020 08:11:01], [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
        ('','','2977','vouchered','2020-10-16 08:11:01','Vouchered By tfg by tfg','tfg','103.104.226.130','tfg','','');
[10/16/2020 08:11:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302977/  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:03';
[10/16/2020 08:11:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302977/  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:04';
[10/16/2020 08:11:06], [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:06',current_status='vouchered',voucher_hashcode='02d4d9b3bcc5294eaa16d8e1d37739ae351032978',vouchered_by ='tfg' where id='2978';
