[06/01/2022 11:00:19], [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 = '1996' , display_currency_code = 'INR' , created_datetime='2022-06-01 11:00:19' , create_date='2022-06-01 11:00:19' , created_by ='tfg' , sales_manager_id ='' , consultant_id = 'tfg' , backoffice_user = 'tfg', city_id='Mumbai', country_id='106', leader_title='Mr', leader_first_name='sanjay', leader_last_name='soni', nationality='Afghanistan', site_id='0', supplier_profile_id='4', comment_contract='', supplier_cancellation_policy='', special_remark='', source_type='localsystem', booking_type='offline', booking_branch_id='1', service_type_detail='';
[06/01/2022 11:00:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='3165'
        ;
[06/01/2022 11:00:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into bookings_details set booking_id ='3165' , hotel_id='' , hotel_name='' , hotel_address1='' , hotel_phone='' , hotel_rating='';
[06/01/2022 11:00:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '3165', booking_detail_id = '1265', 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:"200";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:2:"20";}}' ,native_room_rate_total = '20' ,display_room_rate_total = '200' ,number_of_rooms = '1';
[06/01/2022 11:00:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '3165', booking_detail_id = '1265', salutations = 'Mr', room = '', rid = '1873', first_name = 'dd', last_name = 'sd' ,age = '';
[06/01/2022 11:00:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='',voucher_id='',voucher_hashcode='',native_currency_code='USD',cancellation_policy='Cancellation or charges made on/after 29-05-2022 will be subject to FULL CHARGE.',supplier_cancellation_policy='',applied_multiplier='10',applied_markup='0',consultant_id='tfg',basecurrency_multiplier='0.01533',basecurrency_multiplier_native='0.01533'_native,agent_currency_multiplier='1',current_status='on_request',status_date='2022-06-01 11:00:19',service_date='2022-06-01',check_out_date='2022-06-02',display_room_rate= '200',display_discount='0',native_room_rate= '20',native_discount='0',additional_charge='',expiration_date= '2022-05-29 05:30:00',source_type='localsystem',special_comment='',admin_note='' WHERE id='3165';
[06/01/2022 11:00:19], [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='200', applicable_service_tax='', agent_markup='0', supplier_rate='20' where id='3165';
[06/01/2022 11:00:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings_details set total_nights='1',supplier_id= 'S000000002',arrival_date='2022/06/01',departure_date='2022/06/02',rate_code='~',total_rooms= '1',total_adults= '1',total_children= '0',total_infants= '0' where booking_id ='3165';
[06/01/2022 11:00:19], [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
        ('','','3165','on_request','2022-06-01 11:00:19','on_request by tfg','tfg','106.194.131.190','tfg','','');
[06/01/2022 11:00:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3165','altaf.shaikh@qtechsoftware.com');
[06/01/2022 11:00:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3165','ankita.rao@qtechsoftware.com');
[06/01/2022 11:01:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],UPDATE bookings_details SET hotel_confirmation_no='gd',hotel_staff_name='rsdhf',hotel_confirm_date='2022-06-08 16:31:00' ,hotel_remarks='hd'  where booking_id = '3165';
[06/01/2022 11:01:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],UPDATE bookings SET free_sale='yes', name= 'rsdhf' ,confirmation_number= 'gd'  where id= '3165';
[06/01/2022 11:01:43], [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
        ('','','3165','on_request','2022-06-01 11:01:43','Booking Hotel Confimation Number is updated by tfg','tfg','106.194.131.190','tfg','','');
[06/01/2022 11:01:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2022-06-01 11:01:43',`log_type`= 'Hotel Confimation Number',`sql_query`= '------UPDATE bookings_details SET hotel_confirmation_no=\&#039;gd\&#039;,hotel_staff_name=\&#039;rsdhf\&#039;,hotel_confirm_date=\&#039;2022-06-08 16:31:00\&#039; ,hotel_remarks=\&#039;hd\&#039;  where booking_id = \&#039;3165\&#039;------------UPDATE bookings SET free_sale=\&#039;yes\&#039;, name= \&#039;rsdhf\&#039; ,confirmation_number= \&#039;gd\&#039;  where id= \&#039;3165\&#039;------',`log_description`= 'Booking Hotel Confimation Number is updated By User: tfg, Hotel Confimation number is: gd and Booking Id is: 3165',`ip`= '106.194.131.190';
[06/01/2022 11:02:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],UPDATE bookings_details SET hotel_confirmation_no='123654',hotel_staff_name='rsdhf',hotel_confirm_date='2022-06-08 16:31:00' ,hotel_remarks='hd'  where booking_id = '3165';
[06/01/2022 11:02:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],UPDATE bookings SET free_sale='yes', name= 'rsdhf'  where id= '3165';
[06/01/2022 11:02:40], [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
        ('','','3165','on_request','2022-06-01 11:02:40','Booking Hotel Confimation Number is updated by tfg','tfg','106.194.131.190','tfg','','');
[06/01/2022 11:02:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2022-06-01 11:02:40',`log_type`= 'Hotel Confimation Number',`sql_query`= '------UPDATE bookings_details SET hotel_confirmation_no=\&#039;123654\&#039;,hotel_staff_name=\&#039;rsdhf\&#039;,hotel_confirm_date=\&#039;2022-06-08 16:31:00\&#039; ,hotel_remarks=\&#039;hd\&#039;  where booking_id = \&#039;3165\&#039;------------UPDATE bookings SET free_sale=\&#039;yes\&#039;, name= \&#039;rsdhf\&#039;  where id= \&#039;3165\&#039;------',`log_description`= 'Booking Hotel Confimation Number is updated By User: tfg, Hotel Confimation number is: 123654 and Booking Id is: 3165',`ip`= '106.194.131.190';
[06/01/2022 11:02:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],update bookings set voucher_id='3165',status_date='2022-06-01 11:02:57',current_status='vouchered',voucher_hashcode='3fffcf11a08ce84e9f7880fa819c281a666063165',vouchered_by ='tfg' where id='3165';
[06/01/2022 11:02:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],Insert into booking_configuration set booking_id='3165',config_key='VOUCHER_DATE', config_value='2022-06-01 11:02:57',create_date='2022-06-01 11:02:57';
[06/01/2022 11:02:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],INSERT INTO autogenerator_invoice_number (id, number) VALUES ('','1654081378');
[06/01/2022 11:02:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],update bookings set is_invoiced='yes',invoice_number= '2022/410' where id='3165' and is_invoiced!='yes';
[06/01/2022 11:02:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],UPDATE agents SET credit_usage=credit_usage+('200'),   credit_value= credit_value-('200') ,  cd_credit_usage=cd_credit_usage+('200') , cd_credit_value=cd_credit_value-('200')  WHERE id = '28';
[06/01/2022 11:02:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],insert into  agent_credit_log SET agent_id= '28',credit_value= '5960.000',credit_usage= '4040.000',credit_limit= '10000',receipt_id= '',amount= '200',booking_id='3165',booking_cost= '200',receipt_allocation= '',balance= '200',ip='106.194.131.190',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2022-06-01 11:06:58';
[06/01/2022 11:02:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],insert into booking_rate_info set agent_price='0',sub_agent_price='0',supplier_currency='USD',supplier_price='20',supplier_type='offline',supplier_id='S000000002',acc_type='purchase',accounting_multiplier='1.00000',booking_id='3165',booking_log='Booking Vouchered',type='Sale',create_date='2022-06-01 11:02:58',account_invoice='2022/410',particulars='';
[06/01/2022 11:02:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],insert into booking_rate_info set agent_price='200',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='0.01533',booking_id='3165',booking_log='Booking Vouchered',type='Sale',create_date='2022-06-01 11:02:58',account_invoice='2022/410',particulars='';
[06/01/2022 11:02:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1542;
[06/01/2022 11:02:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],INSERT INTO accounts_invoice_transaction SET bid= '1542',booking_id= '3165',invoice_number= '2022/410',service_type= 'hotel',booking_type= 'offline',service_name= '',type= 'sale',room_type= 'single',quantity_room= '1',from_date= '2022/06/01',to_date= '2022/06/02',quantity= '1',price= '200',total_price= '200';
[06/01/2022 11:02:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],insert into email_logs SET `subject`= 'The Fabulous Getaway Tax Dispute(TaxInvoice)',from_email_id= 'roma.banwani@qtechsoftware.com',body= 'Rm9yIEZvbGxvd2luZyBib29raW5nIFRheCBpcyBub3QgaW5zZXJ0ZWQ8YnI+Qm9va2luZ0lkOi0zMTY1PGJyPkludm9pY2Ugbm86LTIwMjIvNDEwPGJyPmJyYW5jaF9pZDotMTxicj5UeXBlOi1hZ2VudDxicj5BY2NvdW50IHR5cGU6LXNhbGU8YnI+',to_email_id= 'roma.banwani@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/force_confirm_booking.php',create_date= '2022-06-01 11:02:58';
[06/01/2022 11:02:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php], insert into email_trigger set  subject ='The Fabulous Getaway Tax Dispute',  message='For Following booking Tax is not inserted<br>BookingId:-3165<br>Invoice no:-2022/410<br>branch_id:-1<br>Type:-agent<br>Account type:-sale<br>',  email_sent ='yes', create_date ='2022-06-01 11:02:58', email_sent_to ='roma.banwani@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='TaxInvoice';
[06/01/2022 11:02:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_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
        ('','','3165','vouchered-invoiced','2022-06-01 11:02:58',' by tfg','tfg','106.194.131.190','tfg','','');
[06/01/2022 11:02:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],INSERT INTO agent_commission SET booking_id ='3165',booking_detail_id ='3165',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-06-01 11:02:58';
[06/01/2022 11:02:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],insert into accounting_status set booking_id ='3165',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[06/01/2022 11:02:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_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
        ('','','3165','vouchered','2022-06-01 11:02:58','Force confirm : Auto Vouchered Within cancellation policy by tfg','tfg','106.194.131.190','tfg','','');
[06/01/2022 11:02:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],insert into email_logs SET `subject`= ' TFG103165 /  Booking Vouchered ',from_email_id= 'roma.banwani@qtechsoftware.com',body= '[encoded data, 26708 characters]',to_email_id= 'altaf.shaikh@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/force_confirm_booking.php',create_date= '2022-06-01 11:02:59';
[06/01/2022 11:02:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3165','altaf.shaikh@qtechsoftware.com');
[06/01/2022 11:02:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3165','ankita.rao@qtechsoftware.com');
[06/01/2022 11:03:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],UPDATE bookings SET free_sale='yes', confirmation_number='gd' where id='3165';
[06/01/2022 11:03:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],update bookings_details set hotel_confirmation_no='gd' where booking_id = '3165' ;
[06/01/2022 11:04:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3165','altaf.shaikh@qtechsoftware.com');
[06/01/2022 11:04:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3165','ankita.rao@qtechsoftware.com');
[06/01/2022 11:07:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3164','altaf.shaikh@qtechsoftware.com');
[06/01/2022 11:07:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3164','ankita.rao@qtechsoftware.com');
