[08/07/2020 05:47:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-08-07 05:47:38',login_attempt=0 where id = '25';
[08/07/2020 05:47:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'PhpTest', user_type = 'A', branch_id = '1', login_datetime = '2020-08-07 05:47:38', ip = '103.104.226.130', action = 'Login' ;
[08/07/2020 05:52:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='FronentEndBookingVoucher',status_date='2020-08-07 05:52:06',current_status='vouchered',voucher_hashcode='57ace94d774e691f7812d2400bcdff9f997372789',vouchered_by ='tfg' where id='2789';
[08/07/2020 05:52:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2789',config_key='VOUCHER_DATE', config_value='2020-08-07 05:52:06',create_date='2020-08-07 05:52:06';
[08/07/2020 05:52:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO autogenerator_invoice_number (id, number) VALUES ('','1596779526');
[08/07/2020 05:52:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/365' where id='2789' and is_invoiced!='yes';
[08/07/2020 05:52:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('1138.5'),   credit_value= credit_value-('1138.5') ,  cd_credit_usage=cd_credit_usage+('1138.5') , cd_credit_value=cd_credit_value-('1138.5')  WHERE id = '25';
[08/07/2020 05:52:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '-138.500',credit_usage= '1138.500',credit_limit= '1000',receipt_id= '',amount= '1138.5',booking_id='2789',booking_cost= '1138.5',receipt_allocation= '',balance= '1138.5',ip='103.104.226.130',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-08-07 05:08:06';
[08/07/2020 05:52:06], [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='900',supplier_type='offline',supplier_id='S000000229',acc_type='purchase',accounting_multiplier='1.00000',booking_id='2789',booking_log='Booking Invoiced',type='Sale',create_date='2020-08-07 05:52:06',account_invoice='2020/365',particulars='';
[08/07/2020 05:52:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='1138.5',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='1.00000',booking_id='2789',booking_log='Booking Invoiced',type='Sale',create_date='2020-08-07 05:52:06',account_invoice='2020/365',particulars='';
[08/07/2020 05:52:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1298;
[08/07/2020 05:52:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1298',booking_id= '2789',invoice_number= '2020/365',service_type= 'hotel',booking_type= 'offline',service_name= 'TangyIndia',type= 'sale',room_type= 'double',quantity_room= '1',from_date= '2020/08/07',to_date= '2020/08/08',quantity= '1',price= '1138.5',total_price= '1138.5';
[08/07/2020 05:52:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'The Fabulous Getaway Tax Dispute(TaxInvoice)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'Rm9yIEZvbGxvd2luZyBib29raW5nIFRheCBpcyBub3QgaW5zZXJ0ZWQ8YnI+Qm9va2luZ0lkOi0yNzg5PGJyPkludm9pY2Ugbm86LTIwMjAvMzY1PGJyPmJyYW5jaF9pZDotMTxicj5UeXBlOi1hZ2VudDxicj5BY2NvdW50IHR5cGU6LXNhbGU8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-08-07 05:52:06';
[08/07/2020 05:52:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php], insert into email_trigger set  subject ='The Fabulous Getaway Tax Dispute',  message='For Following booking Tax is not inserted<br>BookingId:-2789<br>Invoice no:-2020/365<br>branch_id:-1<br>Type:-agent<br>Account type:-sale<br>',  email_sent ='yes', create_date ='2020-08-07 05:52:06', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='TaxInvoice';
[08/07/2020 05:52:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/365',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 32728 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-08-07 05:52:08';
[08/07/2020 05:52:08], [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
        ('','','2789','vouchered-invoiced','2020-08-07 05:52:08',' by tfg','tfg','103.104.226.130','tfg','','');
[08/07/2020 05:52:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2789',booking_detail_id ='2789',agent_id ='25',is_sub_agent ='N',parent_id ='',display_commission ='238.5',display_currency ='USD',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 26.5 %',create_date ='2020-08-07 05:52:08';
[08/07/2020 05:52:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2789',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[08/07/2020 05:52:08], [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
        ('','','2789','vouchered','2020-08-07 05:52:08','Vouchered By tfg by tfg','tfg','103.104.226.130','tfg','','');
[08/07/2020 05:52:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG102789 /  Booking Vouchered ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 27304 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-08-07 05:52:09';
[08/07/2020 05:52:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('2789','snehal.valanju@qtechsoftware.com');
[08/07/2020 05:52:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('2789','ankita.rao@qtechsoftware.com');
[08/07/2020 05:52:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='FronentEndBookingVoucher',status_date='2020-08-07 05:52:09',current_status='vouchered',voucher_hashcode='8af33a86d1fcf8a1cdc56917f3cb2e54685562790',vouchered_by ='tfg' where id='2790';
[08/07/2020 05:52:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2790',config_key='VOUCHER_DATE', config_value='2020-08-07 05:52:09',create_date='2020-08-07 05:52:09';
[08/07/2020 05:52: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
        ('','','2790','vouchered','2020-08-07 05:52:09','Vouchered By tfg by tfg','tfg','103.104.226.130','tfg','','');
[08/07/2020 05:52:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302790/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 34964 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-08-07 05:52:11';
[08/07/2020 05:52:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302790/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 34964 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-08-07 05:52:13';
[08/07/2020 05:52:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='FronentEndBookingVoucher',status_date='2020-08-07 05:52:14',current_status='vouchered',voucher_hashcode='9900b520ce5019cb2b794675d0a20e6a211982791',vouchered_by ='tfg' where id='2791';
[08/07/2020 05:52:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2791',config_key='VOUCHER_DATE', config_value='2020-08-07 05:52:14',create_date='2020-08-07 05:52:14';
[08/07/2020 05:52:14], [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
        ('','','2791','vouchered','2020-08-07 05:52:14','Vouchered By tfg by tfg','tfg','103.104.226.130','tfg','','');
[08/07/2020 05:52:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG202791/   Booking Vouchered ',from_email_id= '',body= '[encoded data, 20200 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-08-07 05:52:16';
[08/07/2020 05:52:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG202791/   Booking Vouchered ',from_email_id= '',body= '[encoded data, 20200 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-08-07 05:52:18';
[08/07/2020 05:52:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='FronentEndBookingVoucher',status_date='2020-08-07 05:52:19',current_status='vouchered',voucher_hashcode='8a86d3142a419ea58ebb4a7c19765d24117892792',vouchered_by ='tfg' where id='2792';
[08/07/2020 05:52:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2792',config_key='VOUCHER_DATE', config_value='2020-08-07 05:52:19',create_date='2020-08-07 05:52:19';
[08/07/2020 05:52:19], [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
        ('','','2792','vouchered','2020-08-07 05:52:19','Vouchered By tfg by tfg','tfg','103.104.226.130','tfg','','');
[08/07/2020 05:52:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG402792 / Booking Vouchered ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 24336 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-08-07 05:52:19';
[08/07/2020 05:52:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='FronentEndBookingVoucher',status_date='2020-08-07 05:52:20',current_status='vouchered',voucher_hashcode='55fc03f0c2d50708c62e6acddcc15d5f155362798',vouchered_by ='tfg' where id='2798';
[08/07/2020 05:52:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2798',config_key='VOUCHER_DATE', config_value='2020-08-07 05:52:20',create_date='2020-08-07 05:52:20';
[08/07/2020 05:52:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/365' where id='2798' and is_invoiced!='yes';
[08/07/2020 05:52:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('1138.5'),   credit_value= credit_value-('1138.5') ,  cd_credit_usage=cd_credit_usage+('1138.5') , cd_credit_value=cd_credit_value-('1138.5')  WHERE id = '25';
[08/07/2020 05:52:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '-1277.000',credit_usage= '2277.000',credit_limit= '1000',receipt_id= '',amount= '1138.5',booking_id='2798',booking_cost= '1138.5',receipt_allocation= '',balance= '1138.5',ip='103.104.226.130',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-08-07 05:08:20';
[08/07/2020 05:52:20], [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='900',supplier_type='offline',supplier_id='S000000229',acc_type='purchase',accounting_multiplier='1.00000',booking_id='2798',booking_log='Booking Invoiced',type='Sale',create_date='2020-08-07 05:52:20',account_invoice='2020/365',particulars='';
[08/07/2020 05:52:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='1138.5',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='1.00000',booking_id='2798',booking_log='Booking Invoiced',type='Sale',create_date='2020-08-07 05:52:20',account_invoice='2020/365',particulars='';
[08/07/2020 05:52:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1300;
[08/07/2020 05:52:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1300',booking_id= '2798',invoice_number= '2020/365',service_type= 'hotel',booking_type= 'offline',service_name= 'TangyIndia',type= 'sale',room_type= 'double',quantity_room= '1',from_date= '2020/08/07',to_date= '2020/08/08',quantity= '1',price= '1138.5',total_price= '1138.5';
[08/07/2020 05:52:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'The Fabulous Getaway Tax Dispute(TaxInvoice)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'Rm9yIEZvbGxvd2luZyBib29raW5nIFRheCBpcyBub3QgaW5zZXJ0ZWQ8YnI+Qm9va2luZ0lkOi0yNzk4PGJyPkludm9pY2Ugbm86LTIwMjAvMzY1PGJyPmJyYW5jaF9pZDotMTxicj5UeXBlOi1hZ2VudDxicj5BY2NvdW50IHR5cGU6LXNhbGU8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-08-07 05:52:20';
[08/07/2020 05:52:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php], insert into email_trigger set  subject ='The Fabulous Getaway Tax Dispute',  message='For Following booking Tax is not inserted<br>BookingId:-2798<br>Invoice no:-2020/365<br>branch_id:-1<br>Type:-agent<br>Account type:-sale<br>',  email_sent ='yes', create_date ='2020-08-07 05:52:20', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='TaxInvoice';
[08/07/2020 05:52:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/365',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 34488 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-08-07 05:52:21';
[08/07/2020 05:52: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
        ('','','2798','vouchered-invoiced','2020-08-07 05:52:21',' by tfg','tfg','103.104.226.130','tfg','','');
[08/07/2020 05:52:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2798',booking_detail_id ='2798',agent_id ='25',is_sub_agent ='N',parent_id ='',display_commission ='238.5',display_currency ='USD',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 26.5 %',create_date ='2020-08-07 05:52:21';
[08/07/2020 05:52:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2798',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[08/07/2020 05:52:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/365' where id='2790' and is_invoiced!='yes';
[08/07/2020 05:52:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('253'),   credit_value= credit_value-('253') ,  cd_credit_usage=cd_credit_usage+('253') , cd_credit_value=cd_credit_value-('253')  WHERE id = '25';
[08/07/2020 05:52:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '-1530.000',credit_usage= '2530.000',credit_limit= '1000',receipt_id= '',amount= '253',booking_id='2790',booking_cost= '253',receipt_allocation= '',balance= '253',ip='103.104.226.130',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-08-07 05:08:21';
[08/07/2020 05:52:21], [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='S000000068',acc_type='purchase',accounting_multiplier='1.00000',booking_id='2790',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-08-07 05:52:21',account_invoice='2020/365',particulars='';
[08/07/2020 05:52:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='253',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='1.00000',booking_id='2790',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-08-07 05:52:21',account_invoice='2020/365',particulars='';
[08/07/2020 05:52:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1302;
[08/07/2020 05:52:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1302',booking_id= '2790',invoice_number= '2020/365',service_type= 'transfer',booking_type= 'offline',service_name= 'Mumbai Darshan',type= 'sale',from_date= '2020-08-08',to_date= '2020-08-08',price= '253.000',total_price= '253.000';
[08/07/2020 05:52:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'The Fabulous Getaway Tax Dispute(TaxInvoice)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'Rm9yIEZvbGxvd2luZyBib29raW5nIFRheCBpcyBub3QgaW5zZXJ0ZWQ8YnI+Qm9va2luZ0lkOi0yNzkwPGJyPkludm9pY2Ugbm86LTIwMjAvMzY1PGJyPmJyYW5jaF9pZDotMTxicj5UeXBlOi1hZ2VudDxicj5BY2NvdW50IHR5cGU6LXNhbGU8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-08-07 05:52:22';
[08/07/2020 05:52:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php], insert into email_trigger set  subject ='The Fabulous Getaway Tax Dispute',  message='For Following booking Tax is not inserted<br>BookingId:-2790<br>Invoice no:-2020/365<br>branch_id:-1<br>Type:-agent<br>Account type:-sale<br>',  email_sent ='yes', create_date ='2020-08-07 05:52:22', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='TaxInvoice';
[08/07/2020 05:52:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/365',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 36104 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-08-07 05:52:23';
[08/07/2020 05:52:23], [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
        ('','','2790','vouchered-invoiced','2020-08-07 05:52:23',' by tfg','tfg','103.104.226.130','tfg','','');
[08/07/2020 05:52:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2790',booking_detail_id ='2790',agent_id ='25',is_sub_agent ='N',parent_id ='',display_commission ='53',display_currency ='USD',paid ='N',type ='transfer',description ='Agent Mark Up Percentage is 26.5 %',create_date ='2020-08-07 05:52:23';
[08/07/2020 05:52:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2790',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[08/07/2020 05:52:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/365' where id='2791' and is_invoiced!='yes';
[08/07/2020 05:52:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('575'),   credit_value= credit_value-('575') ,  cd_credit_usage=cd_credit_usage+('575') , cd_credit_value=cd_credit_value-('575')  WHERE id = '25';
[08/07/2020 05:52:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '-2105.000',credit_usage= '3105.000',credit_limit= '1000',receipt_id= '',amount= '575',booking_id='2791',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-08-07 05:08:23';
[08/07/2020 05:52:23], [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='400',supplier_type='offline',supplier_id='S000000068',acc_type='purchase',accounting_multiplier='1.00000',booking_id='2791',booking_log='Sightseeing Booking Vouchered',type='Sale',create_date='2020-08-07 05:52:23',account_invoice='2020/365',particulars='';
[08/07/2020 05:52:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='575',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='1.00000',booking_id='2791',booking_log='Sightseeing Booking Vouchered',type='Sale',create_date='2020-08-07 05:52:23',account_invoice='2020/365',particulars='';
[08/07/2020 05:52:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1304;
[08/07/2020 05:52:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1304',booking_id= '2791',invoice_number= '2020/365',service_type= 'sightseeing',booking_type= 'offline',service_name= 'RidetoGatewayOfIndia',type= 'sale',from_date= '2020-08-09',to_date= '',price= '575.000',total_price= '575.000';
[08/07/2020 05:52:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'The Fabulous Getaway Tax Dispute(TaxInvoice)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'Rm9yIEZvbGxvd2luZyBib29raW5nIFRheCBpcyBub3QgaW5zZXJ0ZWQ8YnI+Qm9va2luZ0lkOi0yNzkxPGJyPkludm9pY2Ugbm86LTIwMjAvMzY1PGJyPmJyYW5jaF9pZDotMTxicj5UeXBlOi1hZ2VudDxicj5BY2NvdW50IHR5cGU6LXNhbGU8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-08-07 05:52:23';
[08/07/2020 05:52:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php], insert into email_trigger set  subject ='The Fabulous Getaway Tax Dispute',  message='For Following booking Tax is not inserted<br>BookingId:-2791<br>Invoice no:-2020/365<br>branch_id:-1<br>Type:-agent<br>Account type:-sale<br>',  email_sent ='yes', create_date ='2020-08-07 05:52:23', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='TaxInvoice';
[08/07/2020 05:52:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/365',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 37728 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-08-07 05:52:24';
[08/07/2020 05:52:24], [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
        ('','','2791','vouchered-invoiced','2020-08-07 05:52:24',' by tfg','tfg','103.104.226.130','tfg','','');
[08/07/2020 05:52:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2791',booking_detail_id ='2791',agent_id ='25',is_sub_agent ='N',parent_id ='',display_commission ='175',display_currency ='USD',paid ='N',type ='sightseeing',description ='Agent Mark Up Percentage is 43.75 %',create_date ='2020-08-07 05:52:24';
[08/07/2020 05:52:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2791',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[08/07/2020 05:52:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/365' where id='2792' and is_invoiced!='yes';
[08/07/2020 05:52:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('3.07'),   credit_value= credit_value-('3.07') ,  cd_credit_usage=cd_credit_usage+('3.07') , cd_credit_value=cd_credit_value-('3.07')  WHERE id = '25';
[08/07/2020 05:52:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '-2108.070',credit_usage= '3108.070',credit_limit= '1000',receipt_id= '',amount= '3.07',booking_id='2792',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-08-07 05:08:24';
[08/07/2020 05:52:24], [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='S000000068',acc_type='purchase',accounting_multiplier='0.01533',booking_id='2792',booking_log='Misc Booking Vouchered',type='Sale',create_date='2020-08-07 05:52:24',account_invoice='2020/365',particulars='';
[08/07/2020 05:52:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='3.07',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='1.00000',booking_id='2792',booking_log='Misc Booking Vouchered',type='Sale',create_date='2020-08-07 05:52:24',account_invoice='2020/365',particulars='';
[08/07/2020 05:52:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1306;
[08/07/2020 05:52:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1306',booking_id= '2792',invoice_number= '2020/365',service_type= 'misc',booking_type= 'offline',service_name= 'Breakfast',type= 'sale',from_date= '2020-08-09',to_date= '2020-08-09',price= '3.070',total_price= '3.070';
[08/07/2020 05:52:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'The Fabulous Getaway Tax Dispute(TaxInvoice)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'Rm9yIEZvbGxvd2luZyBib29raW5nIFRheCBpcyBub3QgaW5zZXJ0ZWQ8YnI+Qm9va2luZ0lkOi0yNzkyPGJyPkludm9pY2Ugbm86LTIwMjAvMzY1PGJyPmJyYW5jaF9pZDotMTxicj5UeXBlOi1hZ2VudDxicj5BY2NvdW50IHR5cGU6LXNhbGU8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-08-07 05:52:25';
[08/07/2020 05:52:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php], insert into email_trigger set  subject ='The Fabulous Getaway Tax Dispute',  message='For Following booking Tax is not inserted<br>BookingId:-2792<br>Invoice no:-2020/365<br>branch_id:-1<br>Type:-agent<br>Account type:-sale<br>',  email_sent ='yes', create_date ='2020-08-07 05:52:25', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='TaxInvoice';
[08/07/2020 05:52:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/365',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 39448 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-08-07 05:52:26';
[08/07/2020 05:52:26], [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
        ('','','2792','vouchered-invoiced','2020-08-07 05:52:26',' by tfg','tfg','103.104.226.130','tfg','','');
[08/07/2020 05:52:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2792',booking_detail_id ='2792',agent_id ='25',is_sub_agent ='N',parent_id ='',display_commission ='0',display_currency ='USD',paid ='N',type ='misc',description ='Agent Mark Up Percentage is 0 %',create_date ='2020-08-07 05:52:26';
[08/07/2020 05:52:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2792',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[08/07/2020 05:52:26], [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
        ('','','2798','vouchered','2020-08-07 05:52:26','Vouchered By tfg by tfg','tfg','103.104.226.130','tfg','','');
[08/07/2020 05:52:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG102798 /  Booking Vouchered ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 27312 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-08-07 05:52:27';
[08/07/2020 05:52:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('2798','snehal.valanju@qtechsoftware.com');
[08/07/2020 05:52:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('2798','ankita.rao@qtechsoftware.com');
[08/07/2020 05:52:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='FronentEndBookingVoucher',status_date='2020-08-07 05:52:27',current_status='vouchered',voucher_hashcode='84ec84681d5c976878498bdfb8533a06920522799',vouchered_by ='tfg' where id='2799';
[08/07/2020 05:52:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2799',config_key='VOUCHER_DATE', config_value='2020-08-07 05:52:27',create_date='2020-08-07 05:52:27';
[08/07/2020 05:52:27], [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
        ('','','2799','vouchered','2020-08-07 05:52:27','Vouchered By tfg by tfg','tfg','103.104.226.130','tfg','','');
[08/07/2020 05:52:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302799/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 34964 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-08-07 05:52:29';
[08/07/2020 05:52:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302799/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 34964 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-08-07 05:52:31';
