[08/25/2020 06:45:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('2831','example1@test.com');
[08/25/2020 06:45:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('2831','example2@test.com');
[08/25/2020 06:45:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('2831','example3@test.com');
[08/25/2020 06:45:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('2831','example1@test.com');
[08/25/2020 06:45:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('2831','example2@test.com');
[08/25/2020 06:45:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('2831','example3@test.com');
[08/25/2020 06:45:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('2831','example@test.com');
[08/25/2020 06:45:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='123',status_date='2020-08-25 06:45:09',current_status='vouchered',voucher_hashcode='2a4122e8e1b47c7bf03877f96a8ccf44374712832',vouchered_by ='tfg' where id='2832';
[08/25/2020 06:45:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2832',config_key='VOUCHER_DATE', config_value='2020-08-25 06:45:09',create_date='2020-08-25 06:45:09';
[08/25/2020 06:45: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
        ('','','2832','vouchered','2020-08-25 06:45:09','Vouchered By tfg by tfg','tfg','60.254.44.168','tfg','','');
[08/25/2020 06:45:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302832/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 34924 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-25 06:45:11';
[08/25/2020 06:45:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302832/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 34924 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-08-25 06:45:12';
[08/25/2020 06:45:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='123',status_date='2020-08-25 06:45:14',current_status='vouchered',voucher_hashcode='0532c504feac3877c40ae47ea7ea5515254492833',vouchered_by ='tfg' where id='2833';
[08/25/2020 06:45:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2833',config_key='VOUCHER_DATE', config_value='2020-08-25 06:45:14',create_date='2020-08-25 06:45:14';
[08/25/2020 06:45: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
        ('','','2833','vouchered','2020-08-25 06:45:14','Vouchered By tfg by tfg','tfg','60.254.44.168','tfg','','');
[08/25/2020 06:45:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG202833/   Booking Vouchered ',from_email_id= '',body= '[encoded data, 20220 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-25 06:45:16';
[08/25/2020 06:45:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG202833/   Booking Vouchered ',from_email_id= '',body= '[encoded data, 20220 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-08-25 06:45:17';
[08/25/2020 06:45:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='123',status_date='2020-08-25 06:45:18',current_status='vouchered',voucher_hashcode='5284a0a5f6139fafceeebcdf332c73da742912834',vouchered_by ='tfg' where id='2834';
[08/25/2020 06:45:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2834',config_key='VOUCHER_DATE', config_value='2020-08-25 06:45:18',create_date='2020-08-25 06:45:18';
[08/25/2020 06:45: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
        ('','','2834','vouchered','2020-08-25 06:45:19','Vouchered By tfg by tfg','tfg','60.254.44.168','tfg','','');
[08/25/2020 06:45:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG402834 / Booking Vouchered ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 24316 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-25 06:45:19';
[08/25/2020 06:45:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],INSERT INTO autogenerator_invoice_number (id, number) VALUES ('','1598337927');
[08/25/2020 06:45:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],update bookings set is_invoiced='yes',invoice_number= '2020/375' where id='2831' and is_invoiced!='yes';
[08/25/2020 06:45:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],UPDATE agents SET credit_usage=credit_usage+('1000'),   credit_value= credit_value-('1000') ,  cd_credit_usage=cd_credit_usage+('1000') , cd_credit_value=cd_credit_value-('1000')  WHERE id = '25';
[08/25/2020 06:45:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '1787.210',credit_usage= '12212.790',credit_limit= '14000',receipt_id= '',amount= '1000',booking_id='2831',booking_cost= '1000',receipt_allocation= '',balance= '1000',ip='60.254.44.168',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-08-25 06:08:27';
[08/25/2020 06:45:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],insert into booking_rate_info set agent_price='0',sub_agent_price='0',supplier_currency='USD',supplier_price='1000',supplier_type='offline',supplier_id='S000000229',acc_type='purchase',accounting_multiplier='1.00000',booking_id='2831',booking_log='Booking Invoiced',type='Sale',create_date='2020-08-25 06:45:27',account_invoice='2020/375',particulars='';
[08/25/2020 06:45:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],update booking_rate_info set account_invoice_number='2020/375',acc_export='1' where bid='1341';
[08/25/2020 06:45:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],insert into booking_rate_info set agent_price='1000',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='1.00000',booking_id='2831',booking_log='Booking Invoiced',type='Sale',create_date='2020-08-25 06:45:27',account_invoice='2020/375',particulars='';
[08/25/2020 06:45:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1342;
[08/25/2020 06:45:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],INSERT INTO accounts_invoice_transaction SET bid= '1342',booking_id= '2831',invoice_number= '2020/375',service_type= 'hotel',booking_type= 'offline',service_name= 'TangyIndia',type= 'sale',room_type= 'doublepluschild',quantity_room= '1',from_date= '2020/09/01',to_date= '2020/09/02',quantity= '1',price= '1000',total_price= '1000';
[08/25/2020 06:45:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],insert into email_logs SET `subject`= 'The Fabulous Getaway Tax Dispute(TaxInvoice)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'Rm9yIEZvbGxvd2luZyBib29raW5nIFRheCBpcyBub3QgaW5zZXJ0ZWQ8YnI+Qm9va2luZ0lkOi0yODMxPGJyPkludm9pY2Ugbm86LTIwMjAvMzc1PGJyPmJyYW5jaF9pZDotMTxicj5UeXBlOi1hZ2VudDxicj5BY2NvdW50IHR5cGU6LXNhbGU8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_invoice.php?booking_id=2831&add_invoice_combined=true',create_date= '2020-08-25 06:45:28';
[08/25/2020 06:45:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php], insert into email_trigger set  subject ='The Fabulous Getaway Tax Dispute',  message='For Following booking Tax is not inserted<br>BookingId:-2831<br>Invoice no:-2020/375<br>branch_id:-1<br>Type:-agent<br>Account type:-sale<br>',  email_sent ='yes', create_date ='2020-08-25 06:45:28', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='TaxInvoice';
[08/25/2020 06:45:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],update booking_rate_info set account_invoice_number='2020/375',acc_export='1' where bid='1342';
[08/25/2020 06:45:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','2831','vouchered-invoiced','2020-08-25 06:45:28',' by tfg','tfg','60.254.44.168','tfg','','');
[08/25/2020 06:45:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],INSERT INTO agent_commission SET booking_id ='2831',booking_detail_id ='2831',agent_id ='25',is_sub_agent ='N',parent_id ='',display_commission ='0',display_currency ='USD',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 0 %',create_date ='2020-08-25 06:45:28';
[08/25/2020 06:45:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],insert into accounting_status set booking_id ='2831',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[08/25/2020 06:45:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],update bookings set is_invoiced='yes',invoice_number= '2020/375' where id='2832' and is_invoiced!='yes';
[08/25/2020 06:45:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],UPDATE agents SET credit_usage=credit_usage+('300'),   credit_value= credit_value-('300') ,  cd_credit_usage=cd_credit_usage+('300') , cd_credit_value=cd_credit_value-('300')  WHERE id = '25';
[08/25/2020 06:45:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '1487.210',credit_usage= '12512.790',credit_limit= '14000',receipt_id= '',amount= '300',booking_id='2832',booking_cost= '300',receipt_allocation= '',balance= '300',ip='60.254.44.168',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-08-25 06:08:28';
[08/25/2020 06:45:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],insert into booking_rate_info set agent_price='0',sub_agent_price='0',supplier_currency='USD',supplier_price='250',supplier_type='offline',supplier_id='S000000068',acc_type='purchase',accounting_multiplier='1.00000',booking_id='2832',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-08-25 06:45:28',account_invoice='2020/375',particulars='';
[08/25/2020 06:45:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],update booking_rate_info set account_invoice_number='2020/375',acc_export='1' where bid='1343';
[08/25/2020 06:45:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],insert into booking_rate_info set agent_price='300',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='1.00000',booking_id='2832',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-08-25 06:45:28',account_invoice='2020/375',particulars='';
[08/25/2020 06:45:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1344;
[08/25/2020 06:45:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],INSERT INTO accounts_invoice_transaction SET bid= '1344',booking_id= '2832',invoice_number= '2020/375',service_type= 'transfer',booking_type= 'offline',service_name= 'Mumbai Darshan',type= 'sale',from_date= '2020-09-02',to_date= '2020-09-02',price= '300.000',total_price= '300.000';
[08/25/2020 06:45:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],insert into email_logs SET `subject`= 'The Fabulous Getaway Tax Dispute(TaxInvoice)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'Rm9yIEZvbGxvd2luZyBib29raW5nIFRheCBpcyBub3QgaW5zZXJ0ZWQ8YnI+Qm9va2luZ0lkOi0yODMyPGJyPkludm9pY2Ugbm86LTIwMjAvMzc1PGJyPmJyYW5jaF9pZDotMTxicj5UeXBlOi1hZ2VudDxicj5BY2NvdW50IHR5cGU6LXNhbGU8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_invoice.php?booking_id=2831&add_invoice_combined=true',create_date= '2020-08-25 06:45:29';
[08/25/2020 06:45:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php], insert into email_trigger set  subject ='The Fabulous Getaway Tax Dispute',  message='For Following booking Tax is not inserted<br>BookingId:-2832<br>Invoice no:-2020/375<br>branch_id:-1<br>Type:-agent<br>Account type:-sale<br>',  email_sent ='yes', create_date ='2020-08-25 06:45:29', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='TaxInvoice';
[08/25/2020 06:45:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],update booking_rate_info set account_invoice_number='2020/375',acc_export='1' where bid='1344';
[08/25/2020 06:45:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','2832','vouchered-invoiced','2020-08-25 06:45:30',' by tfg','tfg','60.254.44.168','tfg','','');
[08/25/2020 06:45:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],INSERT INTO agent_commission SET booking_id ='2832',booking_detail_id ='2832',agent_id ='25',is_sub_agent ='N',parent_id ='',display_commission ='50',display_currency ='USD',paid ='N',type ='transfer',description ='Agent Mark Up Percentage is 20 %',create_date ='2020-08-25 06:45:30';
[08/25/2020 06:45:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],insert into accounting_status set booking_id ='2832',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[08/25/2020 06:45:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],update bookings set is_invoiced='yes',invoice_number= '2020/375' where id='2833' and is_invoiced!='yes';
[08/25/2020 06:45:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],UPDATE agents SET credit_usage=credit_usage+('38.34'),   credit_value= credit_value-('38.34') ,  cd_credit_usage=cd_credit_usage+('38.34') , cd_credit_value=cd_credit_value-('38.34')  WHERE id = '25';
[08/25/2020 06:45:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '1448.870',credit_usage= '12551.130',credit_limit= '14000',receipt_id= '',amount= '38.34',booking_id='2833',booking_cost= '',receipt_allocation= '',balance= '',ip='60.254.44.168',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-08-25 06:08:30';
[08/25/2020 06:45:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.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='S000000070',acc_type='purchase',accounting_multiplier='0.01533',booking_id='2833',booking_log='Sightseeing Booking Vouchered',type='Sale',create_date='2020-08-25 06:45:30',account_invoice='2020/375',particulars='';
[08/25/2020 06:45:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],update booking_rate_info set account_invoice_number='2020/375',acc_export='1' where bid='1345';
[08/25/2020 06:45:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],insert into booking_rate_info set agent_price='38.34',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='1.00000',booking_id='2833',booking_log='Sightseeing Booking Vouchered',type='Sale',create_date='2020-08-25 06:45:30',account_invoice='2020/375',particulars='';
[08/25/2020 06:45:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1346;
[08/25/2020 06:45:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],INSERT INTO accounts_invoice_transaction SET bid= '1346',booking_id= '2833',invoice_number= '2020/375',service_type= 'sightseeing',booking_type= 'offline',service_name= 'Essel world',type= 'sale',from_date= '2020-09-02',to_date= '',price= '38.340',total_price= '38.340';
[08/25/2020 06:45:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],insert into email_logs SET `subject`= 'The Fabulous Getaway Tax Dispute(TaxInvoice)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'Rm9yIEZvbGxvd2luZyBib29raW5nIFRheCBpcyBub3QgaW5zZXJ0ZWQ8YnI+Qm9va2luZ0lkOi0yODMzPGJyPkludm9pY2Ugbm86LTIwMjAvMzc1PGJyPmJyYW5jaF9pZDotMTxicj5UeXBlOi1hZ2VudDxicj5BY2NvdW50IHR5cGU6LXNhbGU8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_invoice.php?booking_id=2831&add_invoice_combined=true',create_date= '2020-08-25 06:45:31';
[08/25/2020 06:45:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php], insert into email_trigger set  subject ='The Fabulous Getaway Tax Dispute',  message='For Following booking Tax is not inserted<br>BookingId:-2833<br>Invoice no:-2020/375<br>branch_id:-1<br>Type:-agent<br>Account type:-sale<br>',  email_sent ='yes', create_date ='2020-08-25 06:45:31', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='TaxInvoice';
[08/25/2020 06:45:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],update booking_rate_info set account_invoice_number='2020/375',acc_export='1' where bid='1346';
[08/25/2020 06:45:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','2833','vouchered-invoiced','2020-08-25 06:45:32',' by tfg','tfg','60.254.44.168','tfg','','');
[08/25/2020 06:45:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],INSERT INTO agent_commission SET booking_id ='2833',booking_detail_id ='2833',agent_id ='25',is_sub_agent ='N',parent_id ='',display_commission ='7.665',display_currency ='USD',paid ='N',type ='sightseeing',description ='Agent Mark Up Percentage is 25 %',create_date ='2020-08-25 06:45:32';
[08/25/2020 06:45:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],insert into accounting_status set booking_id ='2833',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[08/25/2020 06:45:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],update bookings set is_invoiced='yes',invoice_number= '2020/375' where id='2834' and is_invoiced!='yes';
[08/25/2020 06:45:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],UPDATE agents SET credit_usage=credit_usage+('5.37'),   credit_value= credit_value-('5.37') ,  cd_credit_usage=cd_credit_usage+('5.37') , cd_credit_value=cd_credit_value-('5.37')  WHERE id = '25';
[08/25/2020 06:45:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '1443.500',credit_usage= '12556.500',credit_limit= '14000',receipt_id= '',amount= '5.37',booking_id='2834',booking_cost= '',receipt_allocation= '',balance= '',ip='60.254.44.168',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-08-25 06:08:32';
[08/25/2020 06:45:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],insert into booking_rate_info set agent_price='0',sub_agent_price='0',supplier_currency='INR',supplier_price='350',supplier_type='offline',supplier_id='S000000068',acc_type='purchase',accounting_multiplier='0.01533',booking_id='2834',booking_log='Misc Booking Vouchered',type='Sale',create_date='2020-08-25 06:45:32',account_invoice='2020/375',particulars='';
[08/25/2020 06:45:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],update booking_rate_info set account_invoice_number='2020/375',acc_export='1' where bid='1347';
[08/25/2020 06:45:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],insert into booking_rate_info set agent_price='5.37',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='1.00000',booking_id='2834',booking_log='Misc Booking Vouchered',type='Sale',create_date='2020-08-25 06:45:32',account_invoice='2020/375',particulars='';
[08/25/2020 06:45:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1348;
[08/25/2020 06:45:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],INSERT INTO accounts_invoice_transaction SET bid= '1348',booking_id= '2834',invoice_number= '2020/375',service_type= 'misc',booking_type= 'offline',service_name= 'Breakfast',type= 'sale',from_date= '2020-09-03',to_date= '2020-09-03',price= '5.370',total_price= '5.370';
[08/25/2020 06:45:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],insert into email_logs SET `subject`= 'The Fabulous Getaway Tax Dispute(TaxInvoice)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'Rm9yIEZvbGxvd2luZyBib29raW5nIFRheCBpcyBub3QgaW5zZXJ0ZWQ8YnI+Qm9va2luZ0lkOi0yODM0PGJyPkludm9pY2Ugbm86LTIwMjAvMzc1PGJyPmJyYW5jaF9pZDotMTxicj5UeXBlOi1hZ2VudDxicj5BY2NvdW50IHR5cGU6LXNhbGU8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_invoice.php?booking_id=2831&add_invoice_combined=true',create_date= '2020-08-25 06:45:33';
[08/25/2020 06:45:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php], insert into email_trigger set  subject ='The Fabulous Getaway Tax Dispute',  message='For Following booking Tax is not inserted<br>BookingId:-2834<br>Invoice no:-2020/375<br>branch_id:-1<br>Type:-agent<br>Account type:-sale<br>',  email_sent ='yes', create_date ='2020-08-25 06:45:33', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='TaxInvoice';
[08/25/2020 06:45:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],update booking_rate_info set account_invoice_number='2020/375',acc_export='1' where bid='1348';
[08/25/2020 06:45:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','2834','vouchered-invoiced','2020-08-25 06:45:34',' by tfg','tfg','60.254.44.168','tfg','','');
[08/25/2020 06:45:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],INSERT INTO agent_commission SET booking_id ='2834',booking_detail_id ='2834',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-25 06:45:34';
[08/25/2020 06:45:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],insert into accounting_status set booking_id ='2834',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[08/25/2020 06:45:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],update bookings set is_invoiced='yes',invoice_number= '2020/375' where id='2832' and is_invoiced!='yes';
[08/25/2020 06:45:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],update bookings set is_invoiced='yes',invoice_number= '2020/375' where id='2833' and is_invoiced!='yes';
[08/25/2020 06:45:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],update bookings set is_invoiced='yes',invoice_number= '2020/375' where id='2834' and is_invoiced!='yes';
