[05/31/2022 11:03:27], [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 11:03:27], [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 11:03:33], [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 11:03:33], [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 11:07:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],INSERT INTO history_bookings set history_booking_id ='3162', agent_id ='28', itenirary_id ='', confirmation_number ='1243333', payment_confirmation_no ='', voucher_id ='1234', voucher_hashcode ='b8fd67e00f875580465c34922ee8933f672463162', email_id ='', leader_title ='', leader_first_name ='', leader_last_name ='', city_id ='Mumbai', country_id ='106', display_room_rate ='100.000', native_room_rate ='100.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 ='vouchered', booking_status ='0', status_date ='2022-05-31 10:57:36', 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 ='100.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='100.000', supplier_rate ='100.000', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='tfg', admin_booked ='0', emailed_status ='0', applied_multiplier ='0', 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 11:07:03', modified_by ='tfg', display_currency_code ='INR', created_datetime ='2022-05-31 11:07:03', sub_agent_rate ='0.000', created_by ='tfg', site_id ='0', applicable_service_tax ='0.000', wh_parent_agent_id ='0', wh_agent_id ='0', nationality ='Indian', ip_addr ='103.104.226.130', is_cancel_history ='1';
[05/31/2022 11:07:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_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
        ('','','3162','cancelled','2022-05-31 11:07:03','Cancellation Confirmation Number: Cancellation done on 2022-05-31 11:07:03  by tfg','tfg','103.104.226.130','tfg','','');
[05/31/2022 11:07:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],UPDATE bookings SET current_status='cancelled',accounts_processed ='0',status_date='2022-05-31 11:07:03' , pending_cancellation = 'no'WHERE reservation_id = 'QTECH2022051990' AND id = '3162' AND (current_status = 'pending' OR  current_status = 'confirmed' OR  current_status = 'vouchered' OR  current_status = 'on_request' OR  current_status = 'inprocess_cancel') ;
[05/31/2022 11:07:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],UPDATE bookings SET  agent_rate='0' , sub_agent_rate='0' , supplier_rate='0' , applicable_service_tax='0' WHERE id = '3162' AND (current_status = 'cancelled' ) ;
[05/31/2022 11:07:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],delete from cancellations where booking_id =? ;
[05/31/2022 11:07:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],INSERT INTO cancellations (native_charge,display_charge,native_currency_code,display_currency_code,reservation_id,booking_id,cancellation_date,confirmation_no,note,cancellation_reason) values ('0','0','USD','INR','QTECH2022051990','3162','2022-05-31 11:07:03','Cancellation done on 2022-05-31 11:07:03 ','Confirmed charges. ','');
[05/31/2022 11:07:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.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 11:07:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into  agent_credit_log SET agent_id= '28',credit_value= '6760.000',credit_usage= '3240.000',credit_limit= '10000',receipt_id= '',amount= '-100',booking_id='3162',booking_cost= '',receipt_allocation= '',balance= '',ip='103.104.226.130',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Booking Cancelled',note='Booking Cancelled',create_date='2022-05-31 11:05:03';
[05/31/2022 11:07:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],update booking_rate_info set  supplier_price = supplier_price+('-100') ,supplier_currency  ='USD', acc_export='0', accounting_multiplier='1.00000' where booking_id='3162' and acc_type='purchase' order by bid asc limit 1;
[05/31/2022 11:07:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],update booking_rate_info set  agent_price = agent_price+('-100'), acc_export='0', accounting_multiplier='0.01533' where booking_id='3162' and acc_type='sale' order by bid asc limit 1;
[05/31/2022 11:07:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1538;
[05/31/2022 11:07:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.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',from_date= '2022-05-31',to_date= '2022-06-01',price= '0.000',total_price= '0.000';
[05/31/2022 11:07:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into email_logs SET `subject`= ' TFG103162 /  Booking Cancelled ',from_email_id= 'roma.banwani@qtechsoftware.com',body= '[encoded data, 18004 characters]',to_email_id= 'altaf.shaikh@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/view_booking.php',create_date= '2022-05-31 11:07:04';
[05/31/2022 11:07:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into temp(booking_id,mail_send_to)values('3162','altaf.shaikh@qtechsoftware.com');
[05/31/2022 11:07:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into temp(booking_id,mail_send_to)values('3162','ankita.rao@qtechsoftware.com');
[05/31/2022 11:07:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into email_logs SET `subject`= ' TFG103162 /  Booking Cancelled ',from_email_id= 'roma.banwani@qtechsoftware.com',body= '[encoded data, 23676 characters]',to_email_id= 'reservations@authenticceylon.com,sales@albany.villas',cc= '',bcc= '',status= 'Success',page_url= '/tms/view_booking.php',create_date= '2022-05-31 11:07:05';
[05/31/2022 11:07:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into temp(booking_id,mail_send_to)values('3162','reservations@authenticceylon.com');
[05/31/2022 11:07:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into temp(booking_id,mail_send_to)values('3162','reservations@authenticceylon.com');
[05/31/2022 11:07:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into temp(booking_id,mail_send_to)values('3162','sales@albany.villas');
[05/31/2022 11:11:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/edit_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1653995501','103.104.226.130');
[05/31/2022 11:12:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1653995525','103.104.226.130');
[05/31/2022 11:13:49], [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 = '1992' , display_currency_code = 'INR' , created_datetime='2022-05-31 11:13:49' , create_date='2022-05-31 11:13:49' , created_by ='tfg' , sales_manager_id ='' , consultant_id = 'tfg' , backoffice_user = 'tfg', city_id='Mumbai', country_id='106', leader_title='Mr', leader_first_name='Altaf', leader_last_name='Tester', 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=' Fab Hotel Crawford Inn South Mumbai';
[05/31/2022 11:13:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='3163'
        ;
[05/31/2022 11:13:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into bookings_details set booking_id ='3163' , hotel_id='47832' , hotel_name=' Fab Hotel Crawford Inn South Mumbai' , hotel_address1='' , hotel_phone='' , hotel_rating='';
[05/31/2022 11:13:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '3163', booking_detail_id = '1263', room_type_code = '', room_name = 'single', meal_basis = '', room_category = 'Single', room_type_description = 'Single', display_nightly_rates = 'a:1:{i:0;a:1:{s:18:"displayNightlyRate";s:3:"600";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:2:"10";}}' ,native_room_rate_total = '10' ,display_room_rate_total = '600' ,number_of_rooms = '1';
[05/31/2022 11:13:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '3163', booking_detail_id = '1263', salutations = 'Mr', room = '', rid = '1871', first_name = 'Altaf', last_name = 'Tester' ,age = '';
[05/31/2022 11:13:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='6678',voucher_id='',voucher_hashcode='',native_currency_code='USD',cancellation_policy='Cancellation or charges made on/after 01-08-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 11:13:50',service_date='2022-08-04',check_out_date='2022-08-05',display_room_rate= '600',display_discount='0',native_room_rate= '10',native_discount='0',additional_charge='',expiration_date= '2022-08-01 05:30:00',source_type='localsystem',free_sale='yes',special_comment='',admin_note='' WHERE id='3163';
[05/31/2022 11:13:50], [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='600', applicable_service_tax='', agent_markup='0', supplier_rate='10' where id='3163';
[05/31/2022 11:13:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings_details set total_nights='1',supplier_id= 'S000000037',arrival_date='2022/08/04',departure_date='2022/08/05',rate_code='~',total_rooms= '1',total_adults= '1',total_children= '0',total_infants= '0' where booking_id ='3163';
[05/31/2022 11:13:50], [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
        ('','','3163','confirmed','2022-05-31 11:13:50','confirmed by tfg','tfg','103.104.226.130','tfg','','');
[05/31/2022 11:14:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='8890',status_date='2022-05-31 11:14:01',current_status='vouchered',voucher_hashcode='651a363df5bbe5e45f75291548c468dd966943163',vouchered_by ='tfg' where id='3163';
[05/31/2022 11:14:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='3163',config_key='VOUCHER_DATE', config_value='2022-05-31 11:14:01',create_date='2022-05-31 11:14:01';
[05/31/2022 11:14:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO autogenerator_invoice_number (id, number) VALUES ('','1653995641');
[05/31/2022 11:14:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2022/409' where id='3163' and is_invoiced!='yes';
[05/31/2022 11:14:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('600'),   credit_value= credit_value-('600') ,  cd_credit_usage=cd_credit_usage+('600') , cd_credit_value=cd_credit_value-('600')  WHERE id = '28';
[05/31/2022 11:14:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '28',credit_value= '6160.000',credit_usage= '3840.000',credit_limit= '10000',receipt_id= '',amount= '600',booking_id='3163',booking_cost= '600',receipt_allocation= '',balance= '600',ip='103.104.226.130',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2022-05-31 11:05:01';
[05/31/2022 11:14:01], [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='10',supplier_type='offline',supplier_id='S000000037',acc_type='purchase',accounting_multiplier='1.00000',booking_id='3163',booking_log='Booking Vouchered',type='Sale',create_date='2022-05-31 11:14:01',account_invoice='2022/409',particulars='';
[05/31/2022 11:14:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='600',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='0.01533',booking_id='3163',booking_log='Booking Vouchered',type='Sale',create_date='2022-05-31 11:14:01',account_invoice='2022/409',particulars='';
[05/31/2022 11:14:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1540;
[05/31/2022 11:14:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1540',booking_id= '3163',invoice_number= '2022/409',service_type= 'hotel',booking_type= 'offline',service_name= ' Fab Hotel Crawford Inn South Mumbai',type= 'sale',room_type= 'single',quantity_room= '1',from_date= '2022/08/04',to_date= '2022/08/05',quantity= '1',price= '600',total_price= '600';
[05/31/2022 11:14:01], [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+Qm9va2luZ0lkOi0zMTYzPGJyPkludm9pY2Ugbm86LTIwMjIvNDA5PGJyPmJyYW5jaF9pZDotMTxicj5UeXBlOi1hZ2VudDxicj5BY2NvdW50IHR5cGU6LXNhbGU8YnI+',to_email_id= 'roma.banwani@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2022-05-31 11:14:01';
[05/31/2022 11:14:01], [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:-3163<br>Invoice no:-2022/409<br>branch_id:-1<br>Type:-agent<br>Account type:-sale<br>',  email_sent ='yes', create_date ='2022-05-31 11:14:01', email_sent_to ='roma.banwani@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='TaxInvoice';
[05/31/2022 11:14:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2022/409',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 26624 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 11:14:03';
[05/31/2022 11:14:03], [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
        ('','','3163','vouchered-invoiced','2022-05-31 11:14:03',' by tfg','tfg','103.104.226.130','tfg','','');
[05/31/2022 11:14:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='3163',booking_detail_id ='3163',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 11:14:03';
[05/31/2022 11:14:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='3163',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[05/31/2022 11:14:03], [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
        ('','','3163','vouchered','2022-05-31 11:14:03','Vouchered By tfg by tfg','tfg','103.104.226.130','tfg','','');
[05/31/2022 11:14:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG103163 /  Booking Vouchered ',from_email_id= 'roma.banwani@qtechsoftware.com',body= '[encoded data, 26880 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 11:14:04';
[05/31/2022 11:14:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('3163','altaf.shaikh@qtechsoftware.com');
[05/31/2022 11:14:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('3163','ankita.rao@qtechsoftware.com');
