[09/03/2020 10:30:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302933/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 41824 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-09-03 10:30:51';
[09/03/2020 10:30:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='test',status_date='2020-09-03 10:30:52',current_status='vouchered',voucher_hashcode='132bbe8032c38b6c57ff3971712bc4be622552934',vouchered_by ='tfg' where id='2934';
[09/03/2020 10:30:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2934',config_key='VOUCHER_DATE', config_value='2020-09-03 10:30:52',create_date='2020-09-03 10:30:52';
[09/03/2020 10:30:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/378' where id='2934' and is_invoiced!='yes';
[09/03/2020 10:30:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('11'),   credit_value= credit_value-('11') ,  cd_credit_usage=cd_credit_usage+('11') , cd_credit_value=cd_credit_value-('11')  WHERE id = '21';
[09/03/2020 10:30:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '21',credit_value= '6248.271',credit_usage= '2822469.249',credit_limit= '2828717.52',receipt_id= '',amount= '11',booking_id='2934',booking_cost= '11',receipt_allocation= '',balance= '11',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-03 10:09:52';
[09/03/2020 10:30:53], [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='10',supplier_type='offline',supplier_id='S000000066',acc_type='purchase',accounting_multiplier='0.01533',booking_id='2934',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-09-03 10:30:53',account_invoice='2020/378',particulars='';
[09/03/2020 10:30:53], [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 ('2934','0','10.000','0','IP','0','3','purchase','booking_rate_info','1369','supplier');
[09/03/2020 10:30:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='11',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='0.01533',booking_id='2934',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-09-03 10:30:53',account_invoice='2020/378',particulars='';
[09/03/2020 10:30:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1370;
[09/03/2020 10:30:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1370',booking_id= '2934',invoice_number= '2020/378',service_type= 'transfer',booking_type= 'offline',service_name= 'Srilanka Transfer Test',type= 'sale',from_date= '2020-10-01',to_date= '2020-10-01',price= '11.000',total_price= '11.000';
[09/03/2020 10:30:53], [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 ('2934','4','11.000','1.4347826086957','OP','15','3','sale','booking_rate_info','1370','agent');
[09/03/2020 10:30:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/378',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 31468 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-03 10:30:55';
[09/03/2020 10:30:55], [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
        ('','','2934','vouchered-invoiced','2020-09-03 10:30:55',' by tfg','tfg','43.250.210.87','tfg','','');
[09/03/2020 10:30:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2934',booking_detail_id ='2934',agent_id ='21',is_sub_agent ='N',parent_id ='',display_commission ='1',display_currency ='INR',paid ='N',type ='transfer',description ='Agent Mark Up Percentage is 10 %',create_date ='2020-09-03 10:30:55';
[09/03/2020 10:30:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2934',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[09/03/2020 10:30:55], [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
        ('','','2934','vouchered','2020-09-03 10:30:55','Vouchered By tfg by tfg','tfg','43.250.210.87','tfg','','');
[09/03/2020 10:30:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302934/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 41788 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-03 10:30:57';
[09/03/2020 10:30:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302934/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 41788 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-09-03 10:30:59';
[09/03/2020 10:31:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='test',status_date='2020-09-03 10:31:00',current_status='vouchered',voucher_hashcode='e3a19f37bd630741d4c99d8757242983759632935',vouchered_by ='tfg' where id='2935';
[09/03/2020 10:31:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2935',config_key='VOUCHER_DATE', config_value='2020-09-03 10:31:00',create_date='2020-09-03 10:31:00';
[09/03/2020 10:31:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/378' where id='2935' and is_invoiced!='yes';
[09/03/2020 10:31:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('6933.6'),   credit_value= credit_value-('6933.6') ,  cd_credit_usage=cd_credit_usage+('6933.6') , cd_credit_value=cd_credit_value-('6933.6')  WHERE id = '21';
[09/03/2020 10:31:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '21',credit_value= '-685.329',credit_usage= '2829402.849',credit_limit= '2828717.52',receipt_id= '',amount= '6933.6',booking_id='2935',booking_cost= '',receipt_allocation= '',balance= '',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-03 10:09:00';
[09/03/2020 10:31: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='USD',supplier_price='100',supplier_type='offline',supplier_id='S000000003',acc_type='purchase',accounting_multiplier='1.00000',booking_id='2935',booking_log='Sightseeing Booking Vouchered',type='Sale',create_date='2020-09-03 10:31:00',account_invoice='2020/378',particulars='';
[09/03/2020 10:31: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 ('2935','0','100.000','0','IP','0','3','purchase','booking_rate_info','1371','supplier');
[09/03/2020 10:31:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='6933.6',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='0.01533',booking_id='2935',booking_log='Sightseeing Booking Vouchered',type='Sale',create_date='2020-09-03 10:31:00',account_invoice='2020/378',particulars='';
[09/03/2020 10:31:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1372;
[09/03/2020 10:31:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1372',booking_id= '2935',invoice_number= '2020/378',service_type= 'sightseeing',booking_type= 'offline',service_name= 'Colombo by tuk tuk',type= 'sale',from_date= '2020-09-30',to_date= '',price= '6933.600',total_price= '6933.600';
[09/03/2020 10:31: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 ('2935','4','6933.600','904.38260869565','OP','15','3','sale','booking_rate_info','1372','agent');
[09/03/2020 10:31:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/378',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 33096 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-03 10:31:02';
[09/03/2020 10:31:02], [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
        ('','','2935','vouchered-invoiced','2020-09-03 10:31:02',' by tfg','tfg','43.250.210.87','tfg','','');
[09/03/2020 10:31:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2935',booking_detail_id ='2935',agent_id ='21',is_sub_agent ='N',parent_id ='',display_commission ='933.6',display_currency ='INR',paid ='N',type ='sightseeing',description ='Agent Mark Up Percentage is 15.56 %',create_date ='2020-09-03 10:31:02';
[09/03/2020 10:31:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2935',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[09/03/2020 10:31:02], [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
        ('','','2935','vouchered','2020-09-03 10:31:02','Vouchered By tfg by tfg','tfg','43.250.210.87','tfg','','');
[09/03/2020 10:31:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG202935/   Booking Vouchered ',from_email_id= '',body= '[encoded data, 19048 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-03 10:31:04';
[09/03/2020 10:31:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG202935/   Booking Vouchered ',from_email_id= '',body= '[encoded data, 19048 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-09-03 10:31:06';
[09/03/2020 10:31:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='test',status_date='2020-09-03 10:31:07',current_status='vouchered',voucher_hashcode='7f2a647af10eed07ce93c2191c3dc04c828282936',vouchered_by ='tfg' where id='2936';
[09/03/2020 10:31:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2936',config_key='VOUCHER_DATE', config_value='2020-09-03 10:31:07',create_date='2020-09-03 10:31:07';
[09/03/2020 10:31:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/378' where id='2936' and is_invoiced!='yes';
[09/03/2020 10:31:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('250'),   credit_value= credit_value-('250') ,  cd_credit_usage=cd_credit_usage+('250') , cd_credit_value=cd_credit_value-('250')  WHERE id = '21';
[09/03/2020 10:31:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '21',credit_value= '-935.329',credit_usage= '2829652.849',credit_limit= '2828717.52',receipt_id= '',amount= '250',booking_id='2936',booking_cost= '',receipt_allocation= '',balance= '',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-03 10:09:07';
[09/03/2020 10:31:07], [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='200',supplier_type='offline',supplier_id='S000000070',acc_type='purchase',accounting_multiplier='0.01533',booking_id='2936',booking_log='Sightseeing Booking Vouchered',type='Sale',create_date='2020-09-03 10:31:07',account_invoice='2020/378',particulars='';
[09/03/2020 10:31:07], [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 ('2936','0','200.000','0','IP','0','3','purchase','booking_rate_info','1373','supplier');
[09/03/2020 10:31:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='250',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='0.01533',booking_id='2936',booking_log='Sightseeing Booking Vouchered',type='Sale',create_date='2020-09-03 10:31:07',account_invoice='2020/378',particulars='';
[09/03/2020 10:31:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1374;
[09/03/2020 10:31:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1374',booking_id= '2936',invoice_number= '2020/378',service_type= 'sightseeing',booking_type= 'offline',service_name= 'QuotationActivity',type= 'sale',from_date= '2020-09-30',to_date= '',price= '250.000',total_price= '250.000';
[09/03/2020 10:31:08], [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 ('2936','4','250.000','32.608695652174','OP','15','3','sale','booking_rate_info','1374','agent');
[09/03/2020 10:31:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/378',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 34716 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-03 10:31:09';
[09/03/2020 10:31:09], [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
        ('','','2936','vouchered-invoiced','2020-09-03 10:31:09',' by tfg','tfg','43.250.210.87','tfg','','');
[09/03/2020 10:31:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2936',booking_detail_id ='2936',agent_id ='21',is_sub_agent ='N',parent_id ='',display_commission ='50',display_currency ='INR',paid ='N',type ='sightseeing',description ='Agent Mark Up Percentage is 25 %',create_date ='2020-09-03 10:31:09';
[09/03/2020 10:31:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2936',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[09/03/2020 10:31:09], [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
        ('','','2936','vouchered','2020-09-03 10:31:09','Vouchered By tfg by tfg','tfg','43.250.210.87','tfg','','');
[09/03/2020 10:31:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG202936/   Booking Vouchered ',from_email_id= '',body= '[encoded data, 20284 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-03 10:31:11';
[09/03/2020 10:31:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG202936/   Booking Vouchered ',from_email_id= '',body= '[encoded data, 20284 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-09-03 10:31:13';
[09/03/2020 10:31:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='test',status_date='2020-09-03 10:31:15',current_status='vouchered',voucher_hashcode='11f7d57d4e58e25bc26df446324bcade641412937',vouchered_by ='tfg' where id='2937';
[09/03/2020 10:31:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2937',config_key='VOUCHER_DATE', config_value='2020-09-03 10:31:15',create_date='2020-09-03 10:31:15';
[09/03/2020 10:31:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/378' where id='2937' and is_invoiced!='yes';
[09/03/2020 10:31:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('3308.4'),   credit_value= credit_value-('3308.4') ,  cd_credit_usage=cd_credit_usage+('3308.4') , cd_credit_value=cd_credit_value-('3308.4')  WHERE id = '21';
[09/03/2020 10:31:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '21',credit_value= '-4243.729',credit_usage= '2832961.249',credit_limit= '2828717.52',receipt_id= '',amount= '3308.4',booking_id='2937',booking_cost= '',receipt_allocation= '',balance= '',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-03 10:09:15';
[09/03/2020 10:31:15], [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='MYR',supplier_price='200',supplier_type='offline',supplier_id='S000000088',acc_type='purchase',accounting_multiplier='0.23694',booking_id='2937',booking_log='Misc Booking Vouchered',type='Sale',create_date='2020-09-03 10:31:15',account_invoice='2020/378',particulars='';
[09/03/2020 10:31:15], [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 ('2937','0','200.000','0','IP','0','3','purchase','booking_rate_info','1375','supplier');
[09/03/2020 10:31:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='3308.4',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='0.01533',booking_id='2937',booking_log='Misc Booking Vouchered',type='Sale',create_date='2020-09-03 10:31:15',account_invoice='2020/378',particulars='';
[09/03/2020 10:31:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1376;
[09/03/2020 10:31:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1376',booking_id= '2937',invoice_number= '2020/378',service_type= 'misc',booking_type= 'offline',service_name= 'Train Ticket (Public)',type= 'sale',from_date= '2020-09-30',to_date= '2020-09-30',price= '3308.400',total_price= '3308.400';
[09/03/2020 10:31:15], [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 ('2937','6','3308.400','96.361165048544','OP','3','3','sale','booking_rate_info','1376','agent');
[09/03/2020 10:31:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/378',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 36484 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-03 10:31:17';
[09/03/2020 10:31:17], [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
        ('','','2937','vouchered-invoiced','2020-09-03 10:31:17',' by tfg','tfg','43.250.210.87','tfg','','');
[09/03/2020 10:31:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2937',booking_detail_id ='2937',agent_id ='21',is_sub_agent ='N',parent_id ='',display_commission ='216.43734',display_currency ='INR',paid ='N',type ='misc',description ='Agent Mark Up Percentage is 7 %',create_date ='2020-09-03 10:31:17';
[09/03/2020 10:31:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2937',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[09/03/2020 10:31:17], [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
        ('','','2937','vouchered','2020-09-03 10:31:17','Vouchered By tfg by tfg','tfg','43.250.210.87','tfg','','');
[09/03/2020 10:31:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG402937 / Booking Vouchered ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 24472 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-03 10:31:17';
[09/03/2020 10:31:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='test',status_date='2020-09-03 10:31:17',current_status='vouchered',voucher_hashcode='eb3283074f918c16860558b4bd19f5c6572812938',vouchered_by ='tfg' where id='2938';
[09/03/2020 10:31:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2938',config_key='VOUCHER_DATE', config_value='2020-09-03 10:31:17',create_date='2020-09-03 10:31:17';
[09/03/2020 10:31:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/378' where id='2938' and is_invoiced!='yes';
[09/03/2020 10:31:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('12840'),   credit_value= credit_value-('12840') ,  cd_credit_usage=cd_credit_usage+('12840') , cd_credit_value=cd_credit_value-('12840')  WHERE id = '21';
[09/03/2020 10:31:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '21',credit_value= '-17083.729',credit_usage= '2845801.249',credit_limit= '2828717.52',receipt_id= '',amount= '12840',booking_id='2938',booking_cost= '',receipt_allocation= '',balance= '',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-03 10:09:18';
[09/03/2020 10:31:18], [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='200',supplier_type='offline',supplier_id='S000000003',acc_type='purchase',accounting_multiplier='1.00000',booking_id='2938',booking_log='Misc Booking Vouchered',type='Sale',create_date='2020-09-03 10:31:18',account_invoice='2020/378',particulars='';
[09/03/2020 10:31: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 ('2938','0','200.000','0','IP','0','3','purchase','booking_rate_info','1377','supplier');
[09/03/2020 10:31:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='12840',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='0.01533',booking_id='2938',booking_log='Misc Booking Vouchered',type='Sale',create_date='2020-09-03 10:31:18',account_invoice='2020/378',particulars='';
[09/03/2020 10:31:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1378;
[09/03/2020 10:31:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1378',booking_id= '2938',invoice_number= '2020/378',service_type= 'misc',booking_type= 'offline',service_name= 'Train Ticket (Public)',type= 'sale',from_date= '2020-09-30',to_date= '2020-09-30',price= '12840.000',total_price= '12840.000';
[09/03/2020 10:31: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 ('2938','6','12840.000','373.98058252427','OP','3','3','sale','booking_rate_info','1378','agent');
[09/03/2020 10:31:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/378',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 38236 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-03 10:31:20';
[09/03/2020 10:31: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
        ('','','2938','vouchered-invoiced','2020-09-03 10:31:20',' by tfg','tfg','43.250.210.87','tfg','','');
[09/03/2020 10:31:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2938',booking_detail_id ='2938',agent_id ='21',is_sub_agent ='N',parent_id ='',display_commission ='840',display_currency ='INR',paid ='N',type ='misc',description ='Agent Mark Up Percentage is 7 %',create_date ='2020-09-03 10:31:20';
[09/03/2020 10:31:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2938',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[09/03/2020 10:31: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
        ('','','2938','vouchered','2020-09-03 10:31:20','Vouchered By tfg by tfg','tfg','43.250.210.87','tfg','','');
[09/03/2020 10:31:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG402938 / Booking Vouchered ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 24472 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-03 10:31:20';
[09/03/2020 10:38:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],INSERT INTO history_bookings set history_booking_id = '2932', agent_id = '21', parent_agent_id = '21', wh_parent_agent_id = '0', itenirary_id = '2', sequence = '2', confirmation_number = '', payment_confirmation_no = '', voucher_id = 'test', voucher_hashcode = 'b3ae8f5e615593fcf48a9ffe8c9f7b20676752932', email_id = '', leader_title = 'Ms', leader_first_name = 'Ankita', leader_last_name = 'Test', city_id = 'Katunayake', country_id = '132', nationality = 'Indian', display_room_rate = '23.540', native_room_rate = '20.000', native_currency_code = 'INR', display_currency_code = 'INR', additional_charge = '0.000', cancellation_policy = '', supplier_cancellation_policy = '', current_status = 'vouchered', booking_status = '1', status_date = '2020-09-03 10:30:36', create_date = '2020-09-03 10:21:27', source_type = 'localtransfer', expiration_date = '2020-09-02 18:30:00', service_date = '2020-09-30', comment_contract = '', admin_note = '', is_payment_gateway = '0', service_type = 'transfer', service_type_detail = 'BIA-Ella Air Transfer', native_rate = '', display_rate = '', applicable_service_tax = '0.000', special_comment = '', special_remark = '', sms_status = '', is_xml = '0', consultant_id = 'tfg', admin_booked = '0', emailed_status = '0', applied_multiplier = '1.00000', applied_markup = '17.699999999999', original_voucher = '', subagent_markup = '', agent_markup = '17.699999999999', agent_rate = '23.540', sub_agent_rate = '0.000', supplier_rate = '20.000', basecurrency_multiplier = '0.01533', basecurrency_multiplier_native = '0.01533', agent_currency_multiplier = '1.00000', created_datetime = '', created_by = 'tfg', modified_datetime = '', modified_by = '', ip_addr = '';
[09/03/2020 10:38:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],insert into history_transfer_bookings  set  old_reff_id  = '519', booking_id = '2932' ,transfer_date = '2020-09-30' ,country_code = '132' ,city_code = '82246' ,pickup = 'O' ,pickup_code = '' ,dropoff = 'O' ,dropoff_code = '' ,no_of_pass = '2' ,pick_up_time = '10.00' ,dropoff_time = '' ,item_content = 'BIA-Ella Air Transfer' ,sel_arr_from = 'Katunayake' ,flight_number = '' ,dropoff_to_hotel = '' ,dropoff_station = '' ,dropoff_station_train = '' ,dropoff_station_destination = '' ,dest_flight_no = '' ,flight_destination = '' ,dropoff_port_shipname = '' ,dropoff_port_shipcompany = '' ,dropoff_port_shipdestination = '' ,pickup_acc_address1 = '' ,pickup_acc_address2 = '' ,pickup_acc_country = '' ,pickup_acc_postcode = '' ,pickup_acc_phone = '' ,dropoff_acc_address1 = '' ,dropoff_acc_address2 = '' ,dropoff_acc_country = '' ,dropoff_acc_postcode = '' ,dropoff_acc_phone = '' ,dropoff_other_address1 = 'The Steuart by Citrus, Hospital Lane, Colombo, Sri Lanka' ,dropoff_other_address2 = '' ,dropoff_other_country = 'Sri Lanka' ,dropoff_other_postcode = '' ,dropoff_other_phone = '' ,Error= '',Item_Confirm_Ref='',airport_arriving_from = '' ,arriving_flight_number = '' ,pickup_from_hotel = '' ,pickup_station_arriving_from = '' ,pickup_station_train_name = '' ,pickup_station_arriving_station = '' ,pickup_port_arriving_from = '' ,pickup_port_ship_name = '' ,pickup_port_shipping_company = '' ,pickup_other_address1 = 'Airport Expressway, Colombo - Katunayake Expressway, Katunayake, Sri Lanka' ,pickup_other_address2 = '' ,pickup_other_country = 'Sri Lanka' ,pickup_other_postcode = '' ,pickup_other_phone = '' ,travel_duration = '3 hr 0 min ' ,supplier_id = 'S000000003' ,supplier_profile= '6',parking_fee = '' ,guide_cost = '' ,driver_tips = '' ,representative_cost = '' ,touristic_entrance = '' ,adult_charge = '' ,child_charge = '' ,tariff_code= '';
[09/03/2020 10:38:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],insert into history_transfer_vehicles set  old_reff_id  = '519',  booking_id  = '2932' , vehicle_code  = '2' , vehicle_name  = 'CAR' , max_luggage  = '3' , max_passenger  = '2' , sel_passenger  = '2' , no_of_adult  = '2' , no_of_child  = '0' , lead_name  = 'Ms Ankita Test' , lead_phone  = '' , adult_rate  = '0' , child_rate  = '0' , parking_fee  = '' , driver_tips  = '' , representative_cost  = '' , guide_cost  = '' , touristic_fee  = '' , vehicle_native_price  = '20.00' , native_price  = '20' , display_price  = '23.54' , native_surcharge  = '' , display_surcharge  = '' ;
[09/03/2020 10:38:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php], UPDATE transfer_bookings SET pickup= 'O' ,pickup_code= '' ,dropoff= 'O' ,dropoff_code= '' ,pick_up_time= '10.00' ,dropoff_time= '10.38' ,sel_arr_from= '' ,flight_number= '' ,dropoff_to_hotel= '' ,dropoff_station= '' ,dropoff_station_train= '' ,dropoff_station_destination= '' ,dest_flight_no= '' ,flight_destination= '' ,dropoff_port_shipname= '' ,dropoff_port_shipcompany= '' ,dropoff_port_shipdestination= '' ,pickup_acc_address1= '' ,pickup_acc_address2= '' ,pickup_acc_city= '' ,pickup_acc_country= '' ,pickup_acc_postcode= '' ,pickup_acc_phone= '' ,dropoff_acc_address1= '' ,dropoff_acc_address2= '' ,dropoff_acc_city= '' ,dropoff_acc_country= '' ,dropoff_acc_postcode= '' ,dropoff_acc_phone= '' ,dropoff_other_address1= 'The Steuart by Citrus, Hospital Lane, Colombo, Sri Lanka' ,dropoff_other_address2= '' ,dropoff_other_country= 'Sri Lanka' ,dropoff_other_postcode= '' ,dropoff_other_phone= '' ,airport_arriving_from= '' ,arriving_flight_number= '' ,pickup_from_hotel= '' ,pickup_station_arriving_from= '' ,pickup_station_train_name= '' ,pickup_station_arriving_station= '' ,pickup_port_arriving_from= '' ,pickup_port_ship_name= '' ,pickup_port_shipping_company= '' ,pickup_other_address1= 'Airport Expressway, Colombo - Katunayake Expressway, Katunayake, Sri Lanka' ,pickup_other_address2= '' ,pickup_other_country= 'Sri Lanka' ,pickup_other_postcode= '' ,pickup_other_phone= '' ,travel_duration= '03 hr 00 mins' ,supplier_id= 'S000000003' ,supplier_profile= '6' where booking_id= '2932';
[09/03/2020 10:38:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','2932','vouchered','2020-09-03 10:38:51','Transfer Booking TFG302932 Modified by tfg','tfg','43.250.210.87','tfg','','');
[09/03/2020 10:38:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking_transfer.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-03 10:38:51',`log_type`= 'Transfer Booking Modified',`sql_query`= ' UPDATE transfer_bookings SET pickup= \&#039;O\&#039; ,pickup_code= \&#039;\&#039; ,dropoff= \&#039;O\&#039; ,dropoff_code= \&#039;\&#039; ,pick_up_time= \&#039;10.00\&#039; ,dropoff_time= \&#039;10.38\&#039; ,sel_arr_from= \&#039;\&#039; ,flight_number= \&#039;\&#039; ,dropoff_to_hotel= \&#039;\&#039; ,dropoff_station= \&#039;\&#039; ,dropoff_station_train= \&#039;\&#039; ,dropoff_station_destination= \&#039;\&#039; ,dest_flight_no= \&#039;\&#039; ,flight_destination= \&#039;\&#039; ,dropoff_port_shipname= \&#039;\&#039; ,dropoff_port_shipcompany= \&#039;\&#039; ,dropoff_port_shipdestination= \&#039;\&#039; ,pickup_acc_address1= \&#039;\&#039; ,pickup_acc_address2= \&#039;\&#039; ,pickup_acc_city= \&#039;\&#039; ,pickup_acc_country= \&#039;\&#039; ,pickup_acc_postcode=  ,pickup_acc_phone=  ,dropoff_acc_address1= \&#039;\&#039; ,dropoff_acc_address2= \&#039;\&#039; ,dropoff_acc_city= \&#039;\&#039; ,dropoff_acc_country= \&#039;\&#039; ,dropoff_acc_postcode= \&#039;\&#039; ,dropoff_acc_phone= \&#039;\&#039; ,dropoff_other_address1= \&#039;The Steuart by Citrus, Hospital Lane, Colombo, Sri Lanka\&#039; ,dropoff_other_address2= \&#039;\&#039; ,dropoff_other_country= \&#039;Sri Lanka\&#039; ,dropoff_other_postcode= \&#039;\&#039; ,dropoff_other_phone= \&#039;\&#039; ,airport_arriving_from= \&#039;\&#039; ,arriving_flight_number= \&#039;\&#039; ,pickup_from_hotel= \&#039;\&#039; ,pickup_station_arriving_from= \&#039;\&#039; ,pickup_station_train_name= \&#039;\&#039; ,pickup_station_arriving_station= \&#039;\&#039; ,pickup_port_arriving_from= \&#039;\&#039; ,pickup_port_ship_name= \&#039;\&#039; ,pickup_port_shipping_company= \&#039;\&#039; ,pickup_other_address1= \&#039;Airport Expressway, Colombo - Katunayake Expressway, Katunayake, Sri Lanka\&#039; ,pickup_other_address2= \&#039;\&#039; ,pickup_other_country= \&#039;Sri Lanka\&#039; ,pickup_other_postcode= \&#039;\&#039; ,pickup_other_phone= \&#039;\&#039; ,travel_duration= \&#039;03 hr 00 mins\&#039; ,supplier_id= \&#039;S000000003\&#039; ,supplier_profile= \&#039;6\&#039; where booking_id= \&#039;2932\&#039;',`log_description`= 'Tranfer Booking Modified Booking_id = TFG302932',`ip`= '43.250.210.87';
[09/03/2020 10:40:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO logistics_assignment SET assignment_no='L00112',assignment_type='internal',entity_value='5',entity_type='driver',vehicle_no='1',vehicle='3',type='private_per_km',allowance='40',substitute_price='',petty_cash='',pickupSlot='2020-09-30 10:00:00',dropOffSlot='2020-10-02 14:00:00',remark='',duration='4 hours 0 mintues',create_date='2020-09-03 10:40:58',created_by='tfg';
[09/03/2020 10:40:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO logistics_bookings SET la_id='111',booking_id='2932',pax='2',start_assignment_time='2020-09-30 10:00:00',end_assignment_time='2020-09-30 13:00:00',pickup='Airport Expressway, Colombo - Katunayake Expressway, Katunayake, Sri Lanka Sri Lanka',dropoff='The Steuart by Citrus, Hospital Lane, Colombo, Sri Lanka Sri Lanka',service_name='BIA-Ella Air Transfer',created_date='2020-09-03 10:40:58';
[09/03/2020 10:40:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO logistics_bookings SET la_id='111',booking_id='2933',pax='2',start_assignment_time='2020-10-02 11:00:00',end_assignment_time='2020-10-02 14:00:00',pickup='The Steuart by Citrus, Hospital Lane, Colombo, Sri Lanka Sri Lanka',dropoff='Airport Expressway, Colombo - Katunayake Expressway, Katunayake, Sri Lanka Sri Lanka',service_name='BIA-Ella Air Transfer',created_date='2020-09-03 10:40:58';
[09/03/2020 10:40:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO logistics_bookings SET la_id='111',booking_id='2934',pax='2',start_assignment_time='2020-10-01 11:00:00',end_assignment_time='2020-10-01 14:00:00',pickup='The Steuart by Citrus, Hospital Lane, Colombo, Sri Lanka Sri Lanka',dropoff='The Steuart by Citrus, Hospital Lane, Colombo, Sri Lanka Sri Lanka',service_name='Srilanka Transfer Test',created_date='2020-09-03 10:40:58';
[09/03/2020 10:40:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],delete from bookings_tax WHERE acc_type='purchase' AND booking_id IN (2932,2933,2934);
[09/03/2020 10:40:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],update booking_rate_info SET supplier_price='0',original_supplier_price='20.000',acc_export='0' WHERE acc_type='purchase' AND booking_id IN (2932) and type != 'Assignment';
[09/03/2020 10:40:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO booking_rate_info SET agent_price='',sub_agent_price='',supplier_currency='INR',supplier_price='20.000',supplier_type='offlline',supplier_id='S000000072',acc_type='purchase',accounting_multiplier='0.01533',substitute_price='0.000',booking_id='2932',booking_log='',type='Assignment',create_date='2020-09-03 10:40:58',account_invoice='L00112',particulars='Logistics Assignment';
[09/03/2020 10:40:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],Update transfer_bookings SET old_supplier = supplier_id, supplier_id = 'S000000072' where booking_id = '2932' ;
[09/03/2020 10:40:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],update booking_rate_info SET supplier_price='0',original_supplier_price='10.000',acc_export='0' WHERE acc_type='purchase' AND booking_id IN (2934) and type != 'Assignment';
[09/03/2020 10:40:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO booking_rate_info SET agent_price='',sub_agent_price='',supplier_currency='INR',supplier_price='10.000',supplier_type='offlline',supplier_id='S000000072',acc_type='purchase',accounting_multiplier='0.01533',substitute_price='0.000',booking_id='2934',booking_log='',type='Assignment',create_date='2020-09-03 10:40:58',account_invoice='L00112',particulars='Logistics Assignment';
[09/03/2020 10:40:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],Update transfer_bookings SET old_supplier = supplier_id, supplier_id = 'S000000072' where booking_id = '2934' ;
[09/03/2020 10:40:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],update booking_rate_info SET supplier_price='0',original_supplier_price='10.000',acc_export='0' WHERE acc_type='purchase' AND booking_id IN (2933) and type != 'Assignment';
[09/03/2020 10:40:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO booking_rate_info SET agent_price='',sub_agent_price='',supplier_currency='INR',supplier_price='10.000',supplier_type='offlline',supplier_id='S000000072',acc_type='purchase',accounting_multiplier='0.01533',substitute_price='0.000',booking_id='2933',booking_log='',type='Assignment',create_date='2020-09-03 10:40:58',account_invoice='L00112',particulars='Logistics Assignment';
[09/03/2020 10:40:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],Update transfer_bookings SET old_supplier = supplier_id, supplier_id = 'S000000072' where booking_id = '2933' ;
[09/03/2020 10:41:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-03 10:41:01',`log_type`= 'Assignment',`sql_query`= 'INSERT INTO logistics_assignment SET assignment_no=\&#039;L00112\&#039;,assignment_type=\&#039;internal\&#039;,entity_value=\&#039;5\&#039;,entity_type=\&#039;driver\&#039;,vehicle_no=1,vehicle=\&#039;3\&#039;,type=\&#039;private_per_km\&#039;,allowance=40,substitute_price=0,petty_cash=0,pickupSlot=\&#039;2020-09-30 10:00:00\&#039;,dropOffSlot=\&#039;2020-10-02 14:00:00\&#039;,remark=\&#039;\&#039;,duration=\&#039;4 hours 0 mintues\&#039;,create_date=\&#039;2020-09-03 10:40:58\&#039;,created_by=\&#039;tfg\&#039;----INSERT INTO logistics_bookings SET la_id=\&#039;111\&#039;,booking_id=\&#039;2932\&#039;,pax=\&#039;2\&#039;,start_assignment_time=\&#039;2020-09-30 10:00:00\&#039;,end_assignment_time=\&#039;2020-09-30 13:00:00\&#039;,pickup=\&#039;Airport Expressway, Colombo - Katunayake Expressway, Katunayake, Sri Lanka Sri Lanka\&#039;,dropoff=\&#039;The Steuart by Citrus, Hospital Lane, Colombo, Sri Lanka Sri Lanka\&#039;,service_name=\&#039;BIA-Ella Air Transfer\&#039;,created_date=\&#039;2020-09-03 10:40:58\&#039;----INSERT INTO logistics_bookings SET la_id=\&#039;111\&#039;,booking_id=\&#039;2933\&#039;,pax=\&#039;2\&#039;,start_assignment_time=\&#039;2020-10-02 11:00:00\&#039;,end_assignment_time=\&#039;2020-10-02 14:00:00\&#039;,pickup=\&#039;The Steuart by Citrus, Hospital Lane, Colombo, Sri Lanka Sri Lanka\&#039;,dropoff=\&#039;Airport Expressway, Colombo - Katunayake Expressway, Katunayake, Sri Lanka Sri Lanka\&#039;,service_name=\&#039;BIA-Ella Air Transfer\&#039;,created_date=\&#039;2020-09-03 10:40:58\&#039;----INSERT INTO logistics_bookings SET la_id=\&#039;111\&#039;,booking_id=\&#039;2934\&#039;,pax=\&#039;2\&#039;,start_assignment_time=\&#039;2020-10-01 11:00:00\&#039;,end_assignment_time=\&#039;2020-10-01 14:00:00\&#039;,pickup=\&#039;The Steuart by Citrus, Hospital Lane, Colombo, Sri Lanka Sri Lanka\&#039;,dropoff=\&#039;The Steuart by Citrus, Hospital Lane, Colombo, Sri Lanka Sri Lanka\&#039;,service_name=\&#039;Srilanka Transfer Test\&#039;,created_date=\&#039;2020-09-03 10:40:58\&#039;',`log_description`= ' driver Allowance:-  INR petty Cash:-  INR',`ip`= '43.250.210.87';
[09/03/2020 10:41:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into user_log_link Set `user_logs_id`='3652', `entity`='BookingId', `value`='2932' ;
[09/03/2020 10:41:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into user_log_link Set `user_logs_id`='3652', `entity`='Assignment', `value`='L00112' ;
[09/03/2020 10:41:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into user_log_link Set `user_logs_id`='3652', `entity`='BookingId', `value`='2933' ;
[09/03/2020 10:41:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into user_log_link Set `user_logs_id`='3652', `entity`='Assignment', `value`='L00112' ;
[09/03/2020 10:41:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into user_log_link Set `user_logs_id`='3652', `entity`='BookingId', `value`='2934' ;
[09/03/2020 10:41:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into user_log_link Set `user_logs_id`='3652', `entity`='Assignment', `value`='L00112' ;
