[08/24/2020 01:07:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1598274437','42.106.253.119');
[08/24/2020 01:07:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1598274448','42.106.253.119');
[08/24/2020 01:13:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1598274831','42.106.253.119');
[08/24/2020 01:13:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],INSERT into bookings SET reservation_id = '1759' ,agent_id = '25' ,backoffice_user = 'tfg' ,city_id = 'Mumbai' ,country_id = '106' ,leader_title = 'Mrs' ,leader_first_name = 'Snehal' ,leader_last_name = 'Gangan' ,nationality = 'Indian' ,display_room_rate = '1.53' ,display_currency_code = 'USD' ,native_room_rate = '100' ,native_discount = '0' ,display_discount = '0' ,native_currency_code = 'INR' ,current_status = 'confirmed' ,expiration_date = '2020-08-29' ,status_date = '2020-08-24 13:13:51' ,create_date = '2020-08-24 13:13:51' ,source_type = 'misc' ,service_type = 'misc' ,consultant_id = 'tfg' ,sales_manager_id = 'otrams' ,applied_multiplier = '0.01533' ,basecurrency_multiplier = '1' ,basecurrency_multiplier_native = '0.01533' ,agent_currency_multiplier = '1' ,created_datetime = '2020-08-24 13:13:51' ,created_by = 'tfg' ,applied_markup = '0' ,agent_markup = '0' ,ip_addr = '42.106.253.119' ,booking_type= 'offline', supplier_rate = '100' ,agent_rate = '1.53' ,parent_agent_id = '25' ,booking_branch_id = '1' ,service_type_detail = 'Breakfast' ,unit_type = 'Per Sevice' ,unit = '' ,unit_rate = '' ,check_out_date = '2020-08-29' ,service_date = '2020-08-29' ;
[08/24/2020 01:13:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],INSERT into misc_bookings SET booking_id = '2822' ,service_name = 'Breakfast' ,country = '106' ,title = 'Mrs' ,first_name = 'Snehal' ,last_name = 'Gangan' ,city = 'Mumbai' ,book_for = 'Breakfast' ,no_of_services = '1' ,from_date = '2020-08-29' ,to_date = '2020-08-29' ,service_tax_id = '30' ,supplier_adult_rate = '100' ,agent_adult_rate = '1.53' ,per_supplier_adult_rate = '' ,per_supplier_child_rate = '' ,per_supplier_infant_rate = '' ,per_agent_adult_rate = '' ,per_agent_child_rate = '' ,per_agent_infant_rate = '' ,supplier_id  = 'S000000068' ;
[08/24/2020 01:13:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','2822','confirmed','2020-08-24 13:13:51','Offline Addtional Service Booking by tfg','tfg','42.106.253.119','tfg','','');
[08/24/2020 01:13:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],insert into email_logs SET `subject`= ' TFG402822 / Booking Confirmed ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 19412 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/offline_additional_service_booking.php',create_date= '2020-08-24 13:13:51';
[08/24/2020 01:13:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],insert into email_logs SET `subject`= ' TFG402822 / Booking Confirmed ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 19924 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/offline_additional_service_booking.php',create_date= '2020-08-24 13:13:52';
[08/24/2020 01:14:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='123',status_date='2020-08-24 13:14:45',current_status='vouchered',voucher_hashcode='a520abe62fb805d903890944b69c9944977012822',vouchered_by ='tfg' where id='2822';
[08/24/2020 01:14:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2822',config_key='VOUCHER_DATE', config_value='2020-08-24 13:14:45',create_date='2020-08-24 13:14:45';
[08/24/2020 01:14:45], [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
        ('','','2822','vouchered','2020-08-24 13:14:45','Vouchered By tfg by tfg','tfg','42.106.253.119','tfg','','');
[08/24/2020 01:14:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG402822 / 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-24 13:14:46';
[08/24/2020 01:14:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],INSERT INTO autogenerator_invoice_number (id, number) VALUES ('','1598274896');
[08/24/2020 01:14:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],update bookings set is_invoiced='yes',invoice_number= '2020/369' where id='2822' and is_invoiced!='yes';
[08/24/2020 01:14:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],UPDATE agents SET credit_usage=credit_usage+('1.53'),   credit_value= credit_value-('1.53') ,  cd_credit_usage=cd_credit_usage+('1.53') , cd_credit_value=cd_credit_value-('1.53')  WHERE id = '25';
[08/24/2020 01:14:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '10874.630',credit_usage= '3125.370',credit_limit= '14000',receipt_id= '',amount= '1.53',booking_id='2822',booking_cost= '',receipt_allocation= '',balance= '',ip='42.106.253.119',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-08-24 13:08:56';
[08/24/2020 01:14:56], [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='100',supplier_type='offline',supplier_id='S000000068',acc_type='purchase',accounting_multiplier='0.01533',booking_id='2822',booking_log='Misc Booking Invoiced',type='Sale',create_date='2020-08-24 13:14:56',account_invoice='2020/369',particulars='';
[08/24/2020 01:14:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],insert into booking_rate_info set agent_price='1.53',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='1.00000',booking_id='2822',booking_log='Misc Booking Invoiced',type='Sale',create_date='2020-08-24 13:14:56',account_invoice='2020/369',particulars='';
[08/24/2020 01:14:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1314;
[08/24/2020 01:14:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],INSERT INTO accounts_invoice_transaction SET bid= '1314',booking_id= '2822',invoice_number= '2020/369',service_type= 'misc',booking_type= 'offline',service_name= 'Breakfast',type= 'sale',from_date= '2020-08-29',to_date= '2020-08-29',price= '1.530',total_price= '1.530';
[08/24/2020 01:14:57], [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+Qm9va2luZ0lkOi0yODIyPGJyPkludm9pY2Ugbm86LTIwMjAvMzY5PGJyPmJyYW5jaF9pZDotMTxicj5UeXBlOi1hZ2VudDxicj5BY2NvdW50IHR5cGU6LXNhbGU8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_invoice.php?booking_id=2822',create_date= '2020-08-24 13:14:57';
[08/24/2020 01:14:57], [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:-2822<br>Invoice no:-2020/369<br>branch_id:-1<br>Type:-agent<br>Account type:-sale<br>',  email_sent ='yes', create_date ='2020-08-24 13:14:57', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='TaxInvoice';
[08/24/2020 01:14:58], [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
        ('','','2822','vouchered-invoiced','2020-08-24 13:14:58',' by tfg','tfg','42.106.253.119','tfg','','');
[08/24/2020 01:14:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],INSERT INTO agent_commission SET booking_id ='2822',booking_detail_id ='2822',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-24 13:14:58';
[08/24/2020 01:14:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_invoice.php],insert into accounting_status set booking_id ='2822',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[08/24/2020 01:39:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1598276342','150.129.31.205');
[08/24/2020 01:39:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1598276354','150.129.31.205');
[08/24/2020 01:47:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1598276853','150.129.31.205');
[08/24/2020 01:47:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1598276873','150.129.31.205');
