[05/31/2022 10:33:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3161','altaf.shaikh@qtechsoftware.com');
[05/31/2022 10:33:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3161','ankita.rao@qtechsoftware.com');
[05/31/2022 10:36:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3160','snehal.valanju@qtechsoftware.com');
[05/31/2022 10:36:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3160','ankita.rao@qtechsoftware.com');
[05/31/2022 10:37:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3161','altaf.shaikh@qtechsoftware.com');
[05/31/2022 10:37:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3161','ankita.rao@qtechsoftware.com');
[05/31/2022 10:39:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3161','altaf.shaikh@qtechsoftware.com');
[05/31/2022 10:39:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3161','ankita.rao@qtechsoftware.com');
[05/31/2022 10:39:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3161','altaf.shaikh@qtechsoftware.com');
[05/31/2022 10:39:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3161','ankita.rao@qtechsoftware.com');
[05/31/2022 10:39:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3161','altaf.shaikh@qtechsoftware.com');
[05/31/2022 10:39:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3161','ankita.rao@qtechsoftware.com');
[05/31/2022 10:39:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3161','altaf.shaikh@qtechsoftware.com');
[05/31/2022 10:39:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3161','ankita.rao@qtechsoftware.com');
[05/31/2022 10:45:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/edit_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1653993918','43.239.53.130');
[05/31/2022 10:45:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1653993943','43.239.53.130');
[05/31/2022 10:48:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO bookings SET agent_id = '28' , service_type = 'hotel' , reservation_id = '1990' , display_currency_code = 'INR' , created_datetime='2022-05-31 10:48:16' , create_date='2022-05-31 10:48:16' , created_by ='tfg' , sales_manager_id ='' , consultant_id = 'tfg' , backoffice_user = 'tfg', city_id='Mumbai', country_id='106', leader_title='Mr', leader_first_name='samyak', leader_last_name='jain', nationality='Indian', site_id='0', supplier_profile_id='3', comment_contract='', supplier_cancellation_policy='', special_remark='', source_type='localsystem', booking_type='offline', booking_branch_id='1', service_type_detail='  HOTEL SAROVAR RESIDENCY';
[05/31/2022 10:48:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='3162'
        ;
[05/31/2022 10:48:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into bookings_details set booking_id ='3162' , hotel_id='47808' , hotel_name='  HOTEL SAROVAR RESIDENCY' , hotel_address1='' , hotel_phone='' , hotel_rating='';
[05/31/2022 10:48:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '3162', booking_detail_id = '1262', room_type_code = '', room_name = '2child', meal_basis = '', room_category = '2 Child', room_type_description = '2 Child', display_nightly_rates = 'a:1:{i:0;a:1:{s:18:"displayNightlyRate";s:5:"30000";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:3:"500";}}' ,native_room_rate_total = '500' ,display_room_rate_total = '30000' ,number_of_rooms = '1';
[05/31/2022 10:48:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '3162', booking_detail_id = '1262', salutations = 'Mr', room = '', rid = '1869', first_name = 'asds', last_name = 'ssf' ,age = '';
[05/31/2022 10:48:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '3162', booking_detail_id = '1262', salutations = 'Mr', room = '1', rid = '1869', first_name = 'gxg', last_name = 'gxz' ,age = '';
[05/31/2022 10:48:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='1243333',voucher_id='',voucher_hashcode='',native_currency_code='USD',cancellation_policy='Cancellation or charges made on/after 28-05-2022 will be subject to FULL CHARGE.',supplier_cancellation_policy='',applied_multiplier='60',applied_markup='0',consultant_id='tfg',basecurrency_multiplier='0.01533',basecurrency_multiplier_native='0.01533'_native,agent_currency_multiplier='1',current_status='confirmed',status_date='2022-05-31 10:48:16',service_date='2022-05-31',check_out_date='2022-06-01',display_room_rate= '30000',display_discount='0',native_room_rate= '500',native_discount='0',additional_charge='',expiration_date= '2022-05-28 05:30:00',source_type='localsystem',free_sale='yes',special_comment='',admin_note='' WHERE id='3162';
[05/31/2022 10:48:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings set  parent_agent_id='28', sub_agent_rate='', agent_rate='30000', applicable_service_tax='', agent_markup='0', supplier_rate='500' where id='3162';
[05/31/2022 10:48:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings_details set total_nights='1',supplier_id= 'S000000008',arrival_date='2022/05/31',departure_date='2022/06/01',rate_code='~',total_rooms= '1',total_adults= '0',total_children= '2',total_infants= '0' where booking_id ='3162';
[05/31/2022 10:48:16], [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
        ('','','3162','confirmed','2022-05-31 10:48:16','confirmed by tfg','tfg','43.239.53.130','tfg','','');
[05/31/2022 10:48:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3162','altaf.shaikh@qtechsoftware.com');
[05/31/2022 10:48:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3162','ankita.rao@qtechsoftware.com');
[05/31/2022 10:57:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='3162', agent_id ='28', itenirary_id ='', sequence = '', confirmation_number ='1243333', payment_confirmation_no ='', voucher_id ='', voucher_hashcode ='', email_id ='', leader_title ='Mr', leader_first_name ='samyak', leader_last_name ='jain', city_id ='Mumbai', country_id ='106', display_room_rate ='30000.000', native_room_rate ='500.000', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='Cancellation or charges made on/after 28-05-2022 will be subject to FULL CHARGE.', supplier_cancellation_policy ='', current_status ='confirmed', booking_status ='0', status_date ='2022-05-31 10:48:16', create_date ='2022-05-31 10:48:16', source_type ='localsystem', expiration_date ='2022-05-28 05:30:00', comment_contract ='', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='  HOTEL SAROVAR RESIDENCY', native_rate ='', display_rate ='', agent_rate ='30000.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='0.000', supplier_rate ='500.000', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='tfg', admin_booked ='0', emailed_status ='0', applied_multiplier ='60', applied_markup ='0', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='0', wh_agent_markup ='0.000', basecurrency_multiplier ='0.01533', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='1', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='1', wh_agent_currency_multiplier ='1.000', modified_datetime ='2022-05-31 10:57:18', modified_by ='tfg', display_currency_code ='INR', created_datetime ='2022-05-31 10:57:18', sub_agent_rate ='0.000', discount_to_sub ='0', created_by ='tfg', site_id ='0', applicable_service_tax ='0.000', wh_parent_agent_id ='0', wh_agent_id ='0', nationality ='Indian', ip_addr ='';
[05/31/2022 10:57:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='1262', old_reff_id ='560', booking_id ='3162', supplier_id ='S000000008', total_nights ='1', arrival_date ='2022/05/31', departure_date ='2022/06/01', hotel_id ='47808', hotel_name ='  HOTEL SAROVAR RESIDENCY', hotel_address1 ='', hotel_phone ='', hotel_rating ='', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[05/31/2022 10:57:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '6528', old_reff_id = '560', booking_id = '3162', booking_detail_id = '1262', salutations = 'Mr', room = '0', rid = '1869', first_name = 'asds', last_name = 'ssf' ,passenger_type = 'adult' ,age = '';
[05/31/2022 10:57:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '6529', old_reff_id = '560', booking_id = '3162', booking_detail_id = '1262', salutations = 'Mr', room = '1', rid = '1869', first_name = 'gxg', last_name = 'gxz' ,passenger_type = 'adult' ,age = '';
[05/31/2022 10:57:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[05/31/2022 10:57:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '1869', old_reff_id = '560', booking_id = '3162', booking_detail_id = '1262', room_type_code = '', room_name = '2child', room_type_description = '2 Child', display_nightly_rates = 'a:1:{i:0;a:1:{s:18:"displayNightlyRate";s:5:"30000";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:3:"500";}}' ,native_room_rate_total = '500' ,display_room_rate_total = '30000' ,wh_room_rate_total = '' ,number_of_rooms = '1';
[05/31/2022 10:57:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[05/31/2022 10:57:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[05/31/2022 10:57:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '3162', booking_detail_id = '1262', room_type_code = '', room_name = '', meal_basis = '', room_type_description = 'ssfds', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"100";s:13:"whNightlyRate";s:3:"100";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:3:"100";}}' ,native_room_rate_total = '100' ,display_room_rate_total = '100' ,number_of_rooms = '1';
[05/31/2022 10:57:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='1243333',native_currency_code='USD',display_currency_code='INR',cancellation_policy='Cancellation or charges made on/after 28-05-2022 will be subject to FULL CHARGE.                                ',supplier_cancellation_policy='',applied_multiplier='0',applied_markup='0',agent_markup='0',consultant_id='tfg',basecurrency_multiplier='0.01533',basecurrency_multiplier_native='0.01533'_native,agent_currency_multiplier='1',service_type_detail='  HOTEL SAROVAR RESIDENCY',current_status='confirmed',status_date='2022-05-31 10:57:18',service_date='2022-05-31',check_out_date='2022-06-01',display_room_rate= '100',display_discount='0',modified_datetime='2022-05-31 10:57:18',modified_by ='tfg',native_room_rate='100',native_discount='0',additional_charge='0.000',applicable_service_tax='',leader_title='',leader_first_name='',leader_last_name='',nationality ='Indian',accounts_processed ='0',booking_type ='offline',agent_ref_no ='',supplier_profile_id ='3',expiration_date= '2022-05-28 05:30:00',source_type='localsystem',free_sale='yes',leader_phone='',admin_note='',comment_contract='' WHERE id='3162';
[05/31/2022 10:57:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2022-05-31 10:57:18',`log_type`= 'Accounts Data Added',`sql_query`= '',`log_description`= 'Accounts Only : Data Added by \&#039;tfg\&#039; From IP \&#039;43.239.53.130\&#039; for booking \&#039;3162\&#039;',`ip`= '43.239.53.130';
[05/31/2022 10:57:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings set  parent_agent_id='28', sub_agent_rate='', agent_rate='100', agent_markup='0', supplier_rate='100', wh_sub_agent_rate='', discount_to_sub='', wh_agent_rate='100' where id='3162';
[05/31/2022 10:57:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings_details set total_nights='1', supplier_id= 'S000000008', total_rooms= '1', arrival_date='2022/05/31', departure_date='2022/06/01', rate_code='~', hotel_address1='', hotel_name='  HOTEL SAROVAR RESIDENCY', hotel_phone='', reservation_pushed='2' where booking_id ='3162';
[05/31/2022 10:57:18], [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
        ('','','3162','confirmed','2022-05-31 10:57:18','Booking Modified by tfg','tfg','43.239.53.130','tfg','','');
[05/31/2022 10:57:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update booking_currency_multiplier set multiplier='0' where booking_id='3162' and from_currency='INR' and to_currency='USD';
[05/31/2022 10:57:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='1234',status_date='2022-05-31 10:57:36',current_status='vouchered',voucher_hashcode='b8fd67e00f875580465c34922ee8933f672463162',vouchered_by ='tfg' where id='3162';
[05/31/2022 10:57:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='3162',config_key='VOUCHER_DATE', config_value='2022-05-31 10:57:36',create_date='2022-05-31 10:57:36';
[05/31/2022 10:57:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO autogenerator_invoice_number (id, number) VALUES ('','1653994656');
[05/31/2022 10:57:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2022/408' where id='3162' and is_invoiced!='yes';
[05/31/2022 10:57:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('100'),   credit_value= credit_value-('100') ,  cd_credit_usage=cd_credit_usage+('100') , cd_credit_value=cd_credit_value-('100')  WHERE id = '28';
[05/31/2022 10:57:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '28',credit_value= '6660.000',credit_usage= '3340.000',credit_limit= '10000',receipt_id= '',amount= '100',booking_id='3162',booking_cost= '100',receipt_allocation= '',balance= '100',ip='43.239.53.130',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2022-05-31 10:05:36';
[05/31/2022 10:57:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='0',sub_agent_price='0',supplier_currency='USD',supplier_price='100',supplier_type='offline',supplier_id='S000000008',acc_type='purchase',accounting_multiplier='1.00000',booking_id='3162',booking_log='Booking Vouchered',type='Sale',create_date='2022-05-31 10:57:36',account_invoice='2022/408',particulars='';
[05/31/2022 10:57:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='100',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='0.01533',booking_id='3162',booking_log='Booking Vouchered',type='Sale',create_date='2022-05-31 10:57:36',account_invoice='2022/408',particulars='';
[05/31/2022 10:57:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1538;
[05/31/2022 10:57:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1538',booking_id= '3162',invoice_number= '2022/408',service_type= 'hotel',booking_type= 'offline',service_name= '  HOTEL SAROVAR RESIDENCY',type= 'sale',room_type= '',quantity_room= '1',from_date= '2022/05/31',to_date= '2022/06/01',quantity= '1',price= '100',total_price= '100';
[05/31/2022 10:57:37], [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= 'roma.banwani@qtechsoftware.com',body= 'Rm9yIEZvbGxvd2luZyBib29raW5nIFRheCBpcyBub3QgaW5zZXJ0ZWQ8YnI+Qm9va2luZ0lkOi0zMTYyPGJyPkludm9pY2Ugbm86LTIwMjIvNDA4PGJyPmJyYW5jaF9pZDotMTxicj5UeXBlOi1hZ2VudDxicj5BY2NvdW50IHR5cGU6LXNhbGU8YnI+',to_email_id= 'roma.banwani@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2022-05-31 10:57:37';
[05/31/2022 10:57:37], [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:-3162<br>Invoice no:-2022/408<br>branch_id:-1<br>Type:-agent<br>Account type:-sale<br>',  email_sent ='yes', create_date ='2022-05-31 10:57:37', email_sent_to ='roma.banwani@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='TaxInvoice';
[05/31/2022 10:57:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2022/408',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 26584 characters]',to_email_id= 'ankita.rao@qtechsoftware.com,altaf.shaikh@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2022-05-31 10:57:38';
[05/31/2022 10:57:38], [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
        ('','','3162','vouchered-invoiced','2022-05-31 10:57:38',' by tfg','tfg','43.239.53.130','tfg','','');
[05/31/2022 10:57:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='3162',booking_detail_id ='3162',agent_id ='28',is_sub_agent ='N',parent_id ='',display_commission ='0',display_currency ='INR',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 0 %',create_date ='2022-05-31 10:57:38';
[05/31/2022 10:57:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='3162',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[05/31/2022 10:57:38], [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
        ('','','3162','vouchered','2022-05-31 10:57:38','Vouchered By tfg by tfg','tfg','43.239.53.130','tfg','','');
[05/31/2022 10:57:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG103162 /  Booking Vouchered ',from_email_id= 'roma.banwani@qtechsoftware.com',body= '[encoded data, 25968 characters]',to_email_id= 'altaf.shaikh@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2022-05-31 10:57:39';
[05/31/2022 10:57:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('3162','altaf.shaikh@qtechsoftware.com');
[05/31/2022 10:57:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('3162','ankita.rao@qtechsoftware.com');
