[07/01/2024 08:06:58], [file name :-/efsdata/otrams/public_html/beta/tms/add_cancelation_rate.php],UPDATE bookings SET  wh_agent_rate='10' , wh_sub_agent_rate='10.3' WHERE id = '388' AND (current_status = 'cancelled' ) ;
[07/01/2024 08:06:58], [file name :-/efsdata/otrams/public_html/beta/tms/add_cancelation_rate.php],update cancellations set native_charge='0.000',display_charge='10',native_currency_code='USD',display_currency_code='USD',note=' test update notes' where booking_id=388;
[07/01/2024 08:06:58], [file name :-/efsdata/otrams/public_html/beta/tms/add_cancelation_rate.php],update bookings set is_invoiced='yes',invoice_number= '2024/00086' where id='388' and is_invoiced!='yes';
[07/01/2024 08:06:58], [file name :-/efsdata/otrams/public_html/beta/tms/add_cancelation_rate.php],UPDATE agents  SET credit_usage=credit_usage+('10'),  credit_value= credit_value-('10')   WHERE id = '7867';
[07/01/2024 08:06:58], [file name :-/efsdata/otrams/public_html/beta/tms/add_cancelation_rate.php],insert into  agent_credit_log SET agent_id= '7867',credit_value= '99999444.650',credit_usage= '554.350',credit_limit= '99999999.000',receipt_id= '',amount= '10',booking_id='388',booking_cost= '',receipt_allocation= '',balance= '',ip='43.239.53.130',user_type='admin',admin_id='hotelyards',temp_credit_limit='',log_type='Modify Cancellation Rate..',note='Modify Cancellation Rate..',create_date='2024-07-01 08:07:58';
[07/01/2024 08:06:58], [file name :-/efsdata/otrams/public_html/beta/tms/add_cancelation_rate.php],UPDATE agents  SET  cd_credit_usage=cd_credit_usage+('10.3') , cd_credit_value=cd_credit_value-('10.3')  WHERE id = '7870';
[07/01/2024 08:06:58], [file name :-/efsdata/otrams/public_html/beta/tms/add_cancelation_rate.php], insert into wh_booking_rate_info set  booking_id = '388', booking_log = 'Booking Cancelled', create_date = '2024-07-01 08:06:58', type = 'cancellation rate', agent_price = '10', sub_agent_price = '0', supplier_price = '0';
