[08/12/2022 10:44:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],update bookings set voucher_id='3169',status_date='2022-08-12 10:44:19',current_status='vouchered',voucher_hashcode='8711dbfb17644209e22e4c8e74e68710415013169',vouchered_by ='tfg' where id='3169';
[08/12/2022 10:44:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],Insert into booking_configuration set booking_id='3169',config_key='VOUCHER_DATE', config_value='2022-08-12 10:44:19',create_date='2022-08-12 10:44:19';
[08/12/2022 10:44:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],INSERT INTO autogenerator_invoice_number (id, number) VALUES ('','1660301059');
[08/12/2022 10:44:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],update bookings set is_invoiced='yes',invoice_number= '2022/412' where id='3169' and is_invoiced!='yes';
[08/12/2022 10:44:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],UPDATE agents SET credit_usage=credit_usage+('14000'),   credit_value= credit_value-('14000') ,  cd_credit_usage=cd_credit_usage+('14000') , cd_credit_value=cd_credit_value-('14000')  WHERE id = '21';
[08/12/2022 10:44:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],insert into  agent_credit_log SET agent_id= '21',credit_value= '-889269.262',credit_usage= '3717986.782',credit_limit= '2828717.52',receipt_id= '',amount= '14000',booking_id='3169',booking_cost= '14000',receipt_allocation= '',balance= '14000',ip='43.239.53.130',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2022-08-12 10:08:19';
[08/12/2022 10:44:19], [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='AED',supplier_price='1250',supplier_type='offline',supplier_id='S000000241',acc_type='purchase',accounting_multiplier='0.27222',booking_id='3169',booking_log='Booking Vouchered',type='Sale',create_date='2022-08-12 10:44:19',account_invoice='2022/412',particulars='';
[08/12/2022 10:44:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],insert into booking_rate_info set agent_price='14000',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='0.01533',booking_id='3169',booking_log='Booking Vouchered',type='Sale',create_date='2022-08-12 10:44:19',account_invoice='2022/412',particulars='';
[08/12/2022 10:44:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1546;
[08/12/2022 10:44:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],INSERT INTO accounts_invoice_transaction SET bid= '1546',booking_id= '3169',invoice_number= '2022/412',service_type= 'hotel',booking_type= 'offline',service_name= 'SassySpoon',type= 'sale',room_type= 'double',quantity_room= '1',from_date= '2022/07/23',to_date= '2022/07/24',quantity= '1',price= '1120',total_price= '1120';
[08/12/2022 10:44:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],INSERT INTO accounts_invoice_transaction SET bid= '1546',booking_id= '3169',invoice_number= '2022/412',service_type= 'hotel',booking_type= 'offline',service_name= 'SassySpoon',type= 'sale',room_type= 'double',quantity_room= '1',from_date= '2022/07/23',to_date= '2022/07/24',quantity= '1',price= '11200',total_price= '11200';
[08/12/2022 10:44:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],INSERT INTO accounts_invoice_transaction SET bid= '1546',booking_id= '3169',invoice_number= '2022/412',service_type= 'hotel',booking_type= 'offline',service_name= 'SassySpoon',type= 'sale',room_type= 'double',quantity_room= '1',from_date= '2022/07/23',to_date= '2022/07/24',quantity= '1',price= '1680',total_price= '1680';
[08/12/2022 10:44:19], [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+Qm9va2luZ0lkOi0zMTY5PGJyPkludm9pY2Ugbm86LTIwMjIvNDEyPGJyPmJyYW5jaF9pZDotMzxicj5UeXBlOi1hZ2VudDxicj5BY2NvdW50IHR5cGU6LXNhbGU8YnI+',to_email_id= 'roma.banwani@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/force_confirm_booking.php',create_date= '2022-08-12 10:44:19';
[08/12/2022 10:44:19], [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:-3169<br>Invoice no:-2022/412<br>branch_id:-3<br>Type:-agent<br>Account type:-sale<br>',  email_sent ='yes', create_date ='2022-08-12 10:44:19', email_sent_to ='roma.banwani@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='TaxInvoice';
[08/12/2022 10:44:19], [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
        ('','','3169','vouchered-invoiced','2022-08-12 10:44:19',' by tfg','tfg','43.239.53.130','tfg','','');
[08/12/2022 10:44:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],INSERT INTO agent_commission SET booking_id ='3169',booking_detail_id ='3169',agent_id ='21',is_sub_agent ='N',parent_id ='',display_commission ='1500',display_currency ='INR',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 12 %',create_date ='2022-08-12 10:44:19';
[08/12/2022 10:44:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],insert into accounting_status set booking_id ='3169',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[08/12/2022 10:44:20], [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
        ('','','3169','vouchered','2022-08-12 10:44:20','Force confirm : Auto Vouchered Within cancellation policy by tfg','tfg','43.239.53.130','tfg','','');
[08/12/2022 10:44:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],insert into email_logs SET `subject`= ' TFG103169 /  Booking Vouchered ',from_email_id= 'roma.banwani@qtechsoftware.com',body= '[encoded data, 46528 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/force_confirm_booking.php',create_date= '2022-08-12 10:44:21';
[08/12/2022 10:44:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3169','snehal.valanju@qtechsoftware.com');
[08/12/2022 10:44:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3169','ankita.rao@qtechsoftware.com');
[08/12/2022 10:44:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],UPDATE bookings SET free_sale='yes', confirmation_number='12' where id='3169';
[08/12/2022 10:44:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/force_confirm_booking.php],update bookings_details set hotel_confirmation_no='12' where booking_id = '3169' ;
[08/12/2022 10:45:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3169','snehal.valanju@qtechsoftware.com');
[08/12/2022 10:45:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3169','snehal.valanju@qtechsoftware.com');
[08/12/2022 10:45:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/daily_email.php],insert into temp(booking_id,mail_send_to)values('3164','altaf.shaikh@qtechsoftware.com');
[08/12/2022 10:45:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/daily_email.php],insert into temp(booking_id,mail_send_to)values('3164','ankita.rao@qtechsoftware.com');
[08/12/2022 10:46:01], [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');
[08/12/2022 10:46:01], [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');
[08/12/2022 10:46:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/daily_email.php],insert into temp(booking_id,mail_send_to)values('3164','altaf.shaikh@qtechsoftware.com');
[08/12/2022 10:46:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/daily_email.php],insert into temp(booking_id,mail_send_to)values('3164','ankita.rao@qtechsoftware.com');
[08/12/2022 10:46:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3164','prajakta.prabhu@qtechsoftware.com');
[08/12/2022 10:46:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3164','prajakta.prabhu@qtechsoftware.com');
