[08/24/2020 12:18:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET agency_name= 'QtechPvt',other_language_agency_name= '',accounting_id= '123',auto_voucher_bookings = '1',outstanding_limit = '0',accounting_name= '',first_name= 'Snehal',middle_name= '',last_name= 'Valanju',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '14000',credit_limit= '14000',credit_distribution= '0',temp_credit_limit= '',address= 'MUmbai',other_language_address= '',city= '64440',pincode= '',country= '106',time_zone_offset= '-10',enable_dst= '',branch_id='1',phone= '12-123456789',mobile= '12-22333134345345',fax= '',currency= '6',email= 'snehal.valanju@qtechsoftware.com',website= '',lead_time= '',search_by_multicurrency= '1',debug= '1',profile= '',designation= '',iata_status= '0',iata_number= '',nature_of_business= 'Tour Operator',can_book= '1',sales_manager_id= 'otrams',comp_reg_no= '',allow_quotation= '1',can_voucher= '1',allow_book_under_cancellation='1',modify_date='2020-08-24 12:18:33',consultant_id= 'nitinalpha',agency_email= '',acc_name= 'A',acc_email= 'snehal.valanju@qtechsoftware.com',acc_phone= '',man_name= 'B',man_email= '',man_phone= '',res_name= 'C',res_email= '',res_phone= '',remarks= '',apply_service_tax= 'no',allow_ticketing= '',agent_category= '2',can_show_hotels= '' WHERE id= '25';
[08/24/2020 12:18:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-24 12:18:33',`log_type`= 'Agent Updated',`sql_query`= 'UPDATE agents SET agency_name= \&#039;QtechPvt\&#039;,other_language_agency_name= \&#039;\&#039;,accounting_id= \&#039;123\&#039;,auto_voucher_bookings = \&#039;1\&#039;,outstanding_limit = \&#039;0\&#039;,accounting_name= \&#039;\&#039;,first_name= \&#039;Snehal\&#039;,middle_name= \&#039;\&#039;,last_name= \&#039;Valanju\&#039;,agent_type= \&#039;CC\&#039;,sort_type= \&#039;price\&#039;,credit_limit_assigned= \&#039;14000\&#039;,credit_limit= \&#039;14000\&#039;,credit_distribution= \&#039;0\&#039;,temp_credit_limit= \&#039;\&#039;,address= \&#039;MUmbai\&#039;,other_language_address= \&#039;\&#039;,city= \&#039;64440\&#039;,pincode= \&#039;\&#039;,country= \&#039;106\&#039;,time_zone_offset= \&#039;-10\&#039;,enable_dst= 0,branch_id=\&#039;1\&#039;,phone= \&#039;12-123456789\&#039;,mobile= \&#039;12-22333134345345\&#039;,fax= \&#039;\&#039;,currency= \&#039;6\&#039;,email= \&#039;snehal.valanju@qtechsoftware.com\&#039;,website= \&#039;\&#039;,lead_time= 0,search_by_multicurrency= 1,debug= \&#039;1\&#039;,profile= \&#039;\&#039;,designation= \&#039;\&#039;,iata_status= \&#039;0\&#039;,iata_number= \&#039;\&#039;,nature_of_business= \&#039;Tour Operator\&#039;,can_book= \&#039;1\&#039;,sales_manager_id= \&#039;otrams\&#039;,comp_reg_no= \&#039;\&#039;,allow_quotation= \&#039;1\&#039;,can_voucher= \&#039;1\&#039;,allow_book_under_cancellation=\&#039;1\&#039;,modify_date=\&#039;2020-08-24 12:18:33\&#039;,consultant_id= \&#039;nitinalpha\&#039;,agency_email= \&#039;\&#039;,acc_name= \&#039;A\&#039;,acc_email= \&#039;snehal.valanju@qtechsoftware.com\&#039;,acc_phone= \&#039;\&#039;,man_name= \&#039;B\&#039;,man_email= \&#039;\&#039;,man_phone= \&#039;\&#039;,res_name= \&#039;C\&#039;,res_email= \&#039;\&#039;,res_phone= \&#039;\&#039;,remarks= \&#039;\&#039;,apply_service_tax= \&#039;no\&#039;,allow_ticketing= 0,agent_category= \&#039;2\&#039;,can_show_hotels= 0 WHERE id= \&#039;25\&#039;',`log_description`= 'Agent 25 updated For  - modify_date=2020-08-08+10%3A27%3A57&accounts_processed=1 changed to - modify_date=2020-08-24+12%3A18%3A33&accounts_processed=0',`ip`= '60.254.11.226';
[08/24/2020 12:18:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='3560', `entity`='Agents', `value`='25' ;
[08/24/2020 12:18:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'25' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?;
[08/24/2020 12:18:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '10887.880',credit_usage= '3112.120',credit_limit= '14000',receipt_id= '',amount= '',ip='60.254.11.226',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Edit_Agent',note='Agent Edited by tfg',create_date='2020-08-24 12:08:33';
[08/24/2020 12:18:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET currency= '6',branch_id= '1',consultant_id= 'nitinalpha',sales_manager_id= 'otrams',profile= '', auto_voucher_bookings = '1', outstanding_limit = '0', agent_type= 'CC' WHERE parent_agent= '25';
[08/24/2020 12:19:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/edit_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1598271561','60.254.11.226');
[08/24/2020 12:19:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1598271582','60.254.11.226');
[08/24/2020 12:21:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-08-24 12:21:21', '', '', '');
[08/24/2020 12:21:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO bookings SET agent_id = '25' , service_type = 'hotel' , reservation_id = '1754' , display_currency_code = 'INR' , created_datetime='2020-08-24 12:21:44' , create_date='2020-08-24 12:21:44' , created_by ='tfg' , sales_manager_id ='otrams' , consultant_id = 'tfg' , backoffice_user = 'tfg', city_id='Mumbai', country_id='106', leader_title='Mrs', leader_first_name='Snehal', leader_last_name='Gangan', nationality='Indian', site_id='0', supplier_profile_id='1', comment_contract='', supplier_cancellation_policy='', special_remark='', source_type='localsystem', booking_type='offline', booking_branch_id='1', service_type_detail='Tamasha';
[08/24/2020 12:21:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='2820'
        ;
[08/24/2020 12:21:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into bookings_details set booking_id ='2820' , hotel_id='53749' , hotel_name='Tamasha' , hotel_address1='Test Address' , hotel_phone='+605 - 1234 5677' , hotel_rating='4.0';
[08/24/2020 12:21:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '2820', booking_detail_id = '1104', room_type_code = '', room_name = 'double', meal_basis = 'Bed & Breakfast', room_category = 'Junior Suite Tower Room', room_type_description = 'Junior Suite Tower Room (Bed & Breakfast)', display_nightly_rates = 'a:1:{i:0;a:1:{s:18:"displayNightlyRate";s:5:"264.5";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:3:"230";}}' ,native_room_rate_total = '230' ,display_room_rate_total = '264.5' ,number_of_rooms = '1';
[08/24/2020 12:21:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '2820', booking_detail_id = '1104', salutations = 'Mr', room = '', rid = '1674', first_name = 'A', last_name = 'Gangan' ,age = '';
[08/24/2020 12:21:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '2820', booking_detail_id = '1104', salutations = 'Mr', room = '1', rid = '1674', first_name = 'B', last_name = 'Gangan' ,age = '';
[08/24/2020 12:21:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='123',voucher_id='',voucher_hashcode='',native_currency_code='INR',cancellation_policy='Cancellation or charges made on/after 21-08-2020 will be subject to FULL CHARGE.',supplier_cancellation_policy='',applied_multiplier='1',applied_markup='15',consultant_id='tfg',basecurrency_multiplier='0.01533',basecurrency_multiplier_native='0.01533'_native,agent_currency_multiplier='0.01533',current_status='confirmed',status_date='2020-08-24 12:21:44',service_date='2020-08-24',check_out_date='2020-08-25',display_room_rate= '264.5',display_discount='0',native_room_rate= '230',native_discount='0',additional_charge='',expiration_date= '2020-08-21 05:30:00',source_type='localsystem',free_sale='yes',special_comment='',admin_note='' WHERE id='2820';
[08/24/2020 12:21:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings set  parent_agent_id='25', sub_agent_rate='', agent_rate='264.5', applicable_service_tax='', agent_markup='15', supplier_rate='230' where id='2820';
[08/24/2020 12:21:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings_details set total_nights='1', supplier_id= 'S000000219',arrival_date='2020/08/24',departure_date='2020/08/25',rate_code='~', total_rooms= '1', total_adults= '2', total_children= '0', total_infants= '0' where booking_id ='2820';
[08/24/2020 12:21:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','2820','confirmed','2020-08-24 12:21:44','confirmed by tfg','tfg','60.254.11.226','tfg','','');
[08/24/2020 12:21:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into email_logs SET `subject`= ' TFG102820 /  Booking Confirmed ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 25528 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/bookings_modification.php',create_date= '2020-08-24 12:21:45';
[08/24/2020 12:21:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into temp(booking_id,mail_send_to)values('2820','snehal.valanju@qtechsoftware.com');
[08/24/2020 12:21:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into temp(booking_id,mail_send_to)values('2820','ankita.rao@qtechsoftware.com');
[08/24/2020 12:21:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into email_logs SET `subject`= ' TFG102820 /  Booking Confirmed ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 35904 characters]',to_email_id= 'example1@test.com,example2@test.com,example3@test.com,example@test.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/bookings_modification.php',create_date= '2020-08-24 12:21:46';
[08/24/2020 12:21:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into temp(booking_id,mail_send_to)values('2820','example1@test.com');
[08/24/2020 12:21:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into temp(booking_id,mail_send_to)values('2820','example2@test.com');
[08/24/2020 12:21:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into temp(booking_id,mail_send_to)values('2820','example3@test.com');
[08/24/2020 12:21:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into temp(booking_id,mail_send_to)values('2820','example1@test.com');
[08/24/2020 12:21:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into temp(booking_id,mail_send_to)values('2820','example2@test.com');
[08/24/2020 12:21:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into temp(booking_id,mail_send_to)values('2820','example3@test.com');
[08/24/2020 12:21:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into temp(booking_id,mail_send_to)values('2820','example@test.com');
[08/24/2020 12:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='123',status_date='2020-08-24 12:27:30',current_status='vouchered',voucher_hashcode='54e88f07b6f7ac74174095e18392a223879422820',vouchered_by ='tfg' where id='2820';
[08/24/2020 12:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2820',config_key='VOUCHER_DATE', config_value='2020-08-24 12:27:30',create_date='2020-08-24 12:27:30';
[08/24/2020 12:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO autogenerator_invoice_number (id, number) VALUES ('','1598272050');
[08/24/2020 12:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/367' where id='2820' and is_invoiced!='yes';
[08/24/2020 12:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('4.054785'),   credit_value= credit_value-('4.054785') ,  cd_credit_usage=cd_credit_usage+('4.054785') , cd_credit_value=cd_credit_value-('4.054785')  WHERE id = '25';
[08/24/2020 12:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '10883.825',credit_usage= '3116.175',credit_limit= '14000',receipt_id= '',amount= '4.054785',booking_id='2820',booking_cost= '264.5',receipt_allocation= '',balance= '264.5',ip='60.254.11.226',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-08-24 12:08:30';
[08/24/2020 12:27:30], [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='230',supplier_type='offline',supplier_id='S000000219',acc_type='purchase',accounting_multiplier='0.01533',booking_id='2820',booking_log='Booking Invoiced',type='Sale',create_date='2020-08-24 12:27:30',account_invoice='2020/367',particulars='';
[08/24/2020 12:27:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='264.5',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='0.01533',booking_id='2820',booking_log='Booking Invoiced',type='Sale',create_date='2020-08-24 12:27:30',account_invoice='2020/367',particulars='';
[08/24/2020 12:27:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1310;
[08/24/2020 12:27:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1310',booking_id= '2820',invoice_number= '2020/367',service_type= 'hotel',booking_type= 'offline',service_name= 'Tamasha',type= 'sale',room_type= 'double',quantity_room= '1',from_date= '2020/08/24',to_date= '2020/08/25',quantity= '1',price= '264.5',total_price= '264.5';
[08/24/2020 12:27:31], [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+Qm9va2luZ0lkOi0yODIwPGJyPkludm9pY2Ugbm86LTIwMjAvMzY3PGJyPmJyYW5jaF9pZDotMTxicj5UeXBlOi1hZ2VudDxicj5BY2NvdW50IHR5cGU6LXNhbGU8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-08-24 12:27:31';
[08/24/2020 12:27:31], [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:-2820<br>Invoice no:-2020/367<br>branch_id:-1<br>Type:-agent<br>Account type:-sale<br>',  email_sent ='yes', create_date ='2020-08-24 12:27:31', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='TaxInvoice';
[08/24/2020 12:27:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/367',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 26168 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-24 12:27:33';
[08/24/2020 12:27:33], [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
        ('','','2820','vouchered-invoiced','2020-08-24 12:27:33',' by tfg','tfg','60.254.11.226','tfg','','');
[08/24/2020 12:27:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2820',booking_detail_id ='2820',agent_id ='25',is_sub_agent ='N',parent_id ='',display_commission ='34.5',display_currency ='INR',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 15 %',create_date ='2020-08-24 12:27:33';
[08/24/2020 12:27:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2820',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[08/24/2020 12:27:33], [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
        ('','','2820','vouchered','2020-08-24 12:27:33','Vouchered By tfg by tfg','tfg','60.254.11.226','tfg','','');
[08/24/2020 12:27:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG102820 /  Booking Vouchered ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 26848 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 12:27:34';
[08/24/2020 12:27:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('2820','snehal.valanju@qtechsoftware.com');
[08/24/2020 12:27:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('2820','ankita.rao@qtechsoftware.com');
[08/24/2020 12:27:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG102820 / Booking Confirmed ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 35904 characters]',to_email_id= 'example1@test.com,example2@test.com,example3@test.com,example@test.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-08-24 12:27:35';
[08/24/2020 12:27:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('2820','example1@test.com');
[08/24/2020 12:27:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('2820','example2@test.com');
[08/24/2020 12:27:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('2820','example3@test.com');
[08/24/2020 12:27:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('2820','example1@test.com');
[08/24/2020 12:27:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('2820','example2@test.com');
[08/24/2020 12:27:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('2820','example3@test.com');
[08/24/2020 12:27:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('2820','example@test.com');
[08/24/2020 12:55:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_transfer_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1598273738','42.106.253.119');
[08/24/2020 12:57:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_transfer_booking.php],INSERT INTO bookings set reservation_id = '1755' ,agent_id = '25' ,confirmation_number = '' ,city_id = 'Mumbai' ,country_id = '106' ,nationality = 'Indian' ,display_room_rate = '500.00' ,native_discount = '' ,display_discount = '' ,display_currency_code = 'INR' ,native_room_rate = '500.00' ,consultant_id = 'tfg' ,backoffice_user = 'tfg' ,sales_manager_id = 'otrams' ,native_currency_code = 'INR' ,cancellation_policy = 'Cancellations or changes made 3 day/s prior to check in ( Noon local hotel time ) will be subject to 1 night/s fee.  No- Show/Early Departure is subjected to 1 night/s Fee' ,supplier_cancellation_policy = '' ,current_status = 'confirmed' ,booking_status= '1',create_date = '2020-08-24 12:57:56' ,status_date = '2020-08-24 12:57:56' ,source_type = 'localtransfer' ,comment_contract = '' ,booking_type= 'offline',booking_branch_id='1' ,expiration_date= '2020-08-21 00:00:00',native_rate = '0.00' ,display_rate = '0.00' ,applied_multiplier = '1' ,applied_markup = '0' ,agent_markup = '0' ,basecurrency_multiplier = '0.01533' ,basecurrency_multiplier_native = '0.01533' ,check_out_date = '2020-08-24' ,service_date = '2020-08-24' ,service_type_detail = 'Mumbai Darshan' ,agent_currency_multiplier = '0.01533' ,supplier_profile_id = '6' ,created_by = 'tfg' ,leader_title = 'Mrs' ,leader_first_name = 'Snehal' ,leader_last_name = 'Gangan' ,leader_phone = '' ,service_type= 'transfer';
[08/24/2020 12:57:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_transfer_booking.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='2821'
        ;
[08/24/2020 12:57:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_transfer_booking.php],UPDATE bookings SET  parent_agent_id= '25', sub_agent_rate= '', agent_rate= '500', applicable_service_tax= '0', supplier_rate= '500.00' where id= '2821';
[08/24/2020 12:57:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_transfer_booking.php],INSERT INTO transfer_bookings SET booking_id = '2821' ,transfer_date = '2020-08-24' ,country_code = '106' ,city_code = '64440' ,pickup = 'H' ,pickup_code = '47808_64440' ,dropoff = 'H' ,dropoff_code = '47808_64440' ,no_of_pass = '2' ,pick_up_time = '13.00' ,dropoff_time = '' ,item_code = '203' ,item_content = 'Mumbai Darshan' ,sel_arr_from = 'Mumbai' ,flight_number = '' ,dropoff_to_hotel = '47808' ,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 = '' ,dropoff_other_address2 = '' ,dropoff_other_country = '' ,dropoff_other_postcode = '' ,dropoff_other_phone = '' ,Error= '',Item_Confirm_Ref='',airport_arriving_from = '' ,arriving_flight_number = '' ,pickup_from_hotel = '47808' ,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 = '' ,pickup_other_address2 = '' ,pickup_other_country = '' ,pickup_other_postcode = '' ,pickup_other_phone = '' ,travel_duration = '1 hr 00 min' ,supplier_id = 'S000000068' ,charge_applied_type = 'private' ,vehicle_type = '2' ,supplier_profile= '6';
[08/24/2020 12:57:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_transfer_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
        ('','','2821','confirmed','2020-08-24 12:57:56','Offline transfer booking by tfg','tfg','42.106.253.119','tfg','','');
[08/24/2020 12:57:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_transfer_booking.php],INSERT INTO transfer_vehicles SET  booking_id  = '2821' ,vehicle_code = '2' ,vehicle_name = 'CAR' ,max_passenger = '2' ,max_luggage = '3' , sel_passenger  = '2' , no_of_adult  = '2' , no_of_child  = '' , lead_name  = 'Snehal' , adult_rate  = '0' , child_rate  = '0' , parking_fee  = '0' , driver_tips  = '0' , representative_cost  = '0' , guide_cost  = '0' , touristic_fee  = '0' , vehicle_native_price  = '500.00' , native_price  = '500' , display_price  = '500.00' , native_surcharge  = '0' , display_surcharge  = '0.00' ;
[08/24/2020 12:57:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_transfer_booking.php],insert into email_logs SET `subject`= ' TFG302821/   Booking Confirmed ',from_email_id= '',body= '[encoded data, 38804 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/new_offline_transfer_booking.php',create_date= '2020-08-24 12:57:58';
[08/24/2020 12:57:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_transfer_booking.php],insert into email_logs SET `subject`= ' TFG302821/   Booking Confirmed ',from_email_id= '',body= '[encoded data, 29196 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/new_offline_transfer_booking.php',create_date= '2020-08-24 12:57:58';
[08/24/2020 12:58:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='123',status_date='2020-08-24 12:58:55',current_status='vouchered',voucher_hashcode='0aecb4f760a8a4843743510c7f517049716702821',vouchered_by ='tfg' where id='2821';
[08/24/2020 12:58:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2821',config_key='VOUCHER_DATE', config_value='2020-08-24 12:58:55',create_date='2020-08-24 12:58:55';
[08/24/2020 12:58:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO autogenerator_invoice_number (id, number) VALUES ('','1598273935');
[08/24/2020 12:58:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/368' where id='2821' and is_invoiced!='yes';
[08/24/2020 12:58:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('7.665'),   credit_value= credit_value-('7.665') ,  cd_credit_usage=cd_credit_usage+('7.665') , cd_credit_value=cd_credit_value-('7.665')  WHERE id = '25';
[08/24/2020 12:58:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '10876.160',credit_usage= '3123.840',credit_limit= '14000',receipt_id= '',amount= '7.665',booking_id='2821',booking_cost= '500',receipt_allocation= '',balance= '500',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 12:08:55';
[08/24/2020 12:58:55], [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='500',supplier_type='offline',supplier_id='S000000068',acc_type='purchase',accounting_multiplier='0.01533',booking_id='2821',booking_log='Transfer Booking Invoiced',type='Sale',create_date='2020-08-24 12:58:55',account_invoice='2020/368',particulars='';
[08/24/2020 12:58:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='500',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='0.01533',booking_id='2821',booking_log='Transfer Booking Invoiced',type='Sale',create_date='2020-08-24 12:58:55',account_invoice='2020/368',particulars='';
[08/24/2020 12:58:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1312;
[08/24/2020 12:58:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1312',booking_id= '2821',invoice_number= '2020/368',service_type= 'transfer',booking_type= 'offline',service_name= 'Mumbai Darshan',type= 'sale',from_date= '2020-08-24',to_date= '2020-08-24',price= '500.000',total_price= '500.000';
[08/24/2020 12:58:55], [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+Qm9va2luZ0lkOi0yODIxPGJyPkludm9pY2Ugbm86LTIwMjAvMzY4PGJyPmJyYW5jaF9pZDotMTxicj5UeXBlOi1hZ2VudDxicj5BY2NvdW50IHR5cGU6LXNhbGU8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-08-24 12:58:55';
[08/24/2020 12:58:55], [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:-2821<br>Invoice no:-2020/368<br>branch_id:-1<br>Type:-agent<br>Account type:-sale<br>',  email_sent ='yes', create_date ='2020-08-24 12:58:55', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='TaxInvoice';
[08/24/2020 12:58:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/368',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 26036 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-24 12:58:57';
[08/24/2020 12:58:57], [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
        ('','','2821','vouchered-invoiced','2020-08-24 12:58:57',' by tfg','tfg','42.106.253.119','tfg','','');
[08/24/2020 12:58:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='2821',booking_detail_id ='2821',agent_id ='25',is_sub_agent ='N',parent_id ='',display_commission ='0',display_currency ='INR',paid ='N',type ='transfer',description ='Agent Mark Up Percentage is 0 %',create_date ='2020-08-24 12:58:57';
[08/24/2020 12:58:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='2821',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[08/24/2020 12:58:57], [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
        ('','','2821','vouchered','2020-08-24 12:58:57','Vouchered By tfg by tfg','tfg','42.106.253.119','tfg','','');
[08/24/2020 12:58:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302821/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 34576 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 12:58:59';
[08/24/2020 12:59:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG302821/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 34576 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-08-24 12:59:01';
[08/24/2020 12:59:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1598273981','42.106.253.119');
