[10/13/2023 09:40:17], [file name :-/home/otrams/public_html/beta/tms/add_cancelation_rate.php],UPDATE bookings SET  agent_rate='0' , sub_agent_rate='0' , supplier_rate='10' , applicable_service_tax='0' WHERE id = '44' AND (current_status = 'cancelled' ) ;
[10/13/2023 09:40:17], [file name :-/home/otrams/public_html/beta/tms/add_cancelation_rate.php],update cancellations set native_charge='10',display_charge='-20',native_currency_code='USD',display_currency_code='INR',note=' ' where booking_id=44;
[10/13/2023 09:40:17], [file name :-/home/otrams/public_html/beta/tms/add_cancelation_rate.php],UPDATE agents SET credit_usage=credit_usage+('-20'),   credit_value= credit_value-('-20') ,  cd_credit_usage=cd_credit_usage+('-20') , cd_credit_value=cd_credit_value-('-20')  WHERE id = '7862';
[10/13/2023 09:40:17], [file name :-/home/otrams/public_html/beta/tms/add_cancelation_rate.php],insert into  agent_credit_log SET agent_id= '7862',credit_value= '5000020.000',credit_usage= '-20.000',credit_limit= '5000000.000',receipt_id= '',amount= '-20',booking_id='44',booking_cost= '',receipt_allocation= '',balance= '',ip='43.239.53.130',user_type='admin',admin_id='v3alpha',temp_credit_limit='50000',log_type='Modify Cancellation Rate..',note='Modify Cancellation Rate..',create_date='2023-10-13 09:10:17';
[10/13/2023 09:40:17], [file name :-/home/otrams/public_html/beta/tms/add_cancelation_rate.php], insert into booking_rate_info set  booking_id = '44', booking_log = 'Booking Cancelled', create_date = '2023-10-13 09:40:17', supplier_currency ='USD', type = 'Cancelled Rate Amendment', agent_price = '-20', sub_agent_price ='', supplier_price = '10', supplier_id = 'expedia', supplier_type = 'online';
[10/13/2023 09:40:30], [file name :-/home/otrams/public_html/beta/tms/add_cancelation_rate.php],UPDATE bookings SET  agent_rate='0' , sub_agent_rate='0' , supplier_rate='10' , applicable_service_tax='0' WHERE id = '44' AND (current_status = 'cancelled' ) ;
[10/13/2023 09:40:30], [file name :-/home/otrams/public_html/beta/tms/add_cancelation_rate.php],update cancellations set native_charge='10',display_charge='-20',native_currency_code='USD',display_currency_code='INR',note='' where booking_id=44;
[10/13/2023 09:40:30], [file name :-/home/otrams/public_html/beta/tms/add_cancelation_rate.php],UPDATE agents SET credit_usage=credit_usage+('-20'),   credit_value= credit_value-('-20') ,  cd_credit_usage=cd_credit_usage+('-20') , cd_credit_value=cd_credit_value-('-20')  WHERE id = '7862';
[10/13/2023 09:40:30], [file name :-/home/otrams/public_html/beta/tms/add_cancelation_rate.php],insert into  agent_credit_log SET agent_id= '7862',credit_value= '5000040.000',credit_usage= '-40.000',credit_limit= '5000000.000',receipt_id= '',amount= '-20',booking_id='44',booking_cost= '',receipt_allocation= '',balance= '',ip='43.239.53.130',user_type='admin',admin_id='v3alpha',temp_credit_limit='50000',log_type='Modify Cancellation Rate..',note='Modify Cancellation Rate..',create_date='2023-10-13 09:10:30';
[10/13/2023 09:40:30], [file name :-/home/otrams/public_html/beta/tms/add_cancelation_rate.php], insert into booking_rate_info set  booking_id = '44', booking_log = 'Booking Cancelled', create_date = '2023-10-13 09:40:30', supplier_currency ='USD', type = 'Cancelled Rate Amendment', agent_price = '-20', sub_agent_price ='', supplier_price = '', supplier_id = 'expedia', supplier_type = 'online';
[10/13/2023 09:41:52], [file name :-/home/otrams/public_html/beta/tms/add_cancelation_rate.php],UPDATE bookings SET  agent_rate='20' , sub_agent_rate='0' , supplier_rate='10.000' , applicable_service_tax='' WHERE id = '44' AND (current_status = 'cancelled' ) ;
[10/13/2023 09:41:52], [file name :-/home/otrams/public_html/beta/tms/add_cancelation_rate.php],update cancellations set native_charge='10.000',display_charge='20',native_currency_code='USD',display_currency_code='INR',note='' where booking_id=44;
[10/13/2023 09:41:52], [file name :-/home/otrams/public_html/beta/tms/add_cancelation_rate.php],UPDATE agents SET credit_usage=credit_usage+('20'),   credit_value= credit_value-('20') ,  cd_credit_usage=cd_credit_usage+('20') , cd_credit_value=cd_credit_value-('20')  WHERE id = '7862';
[10/13/2023 09:41:52], [file name :-/home/otrams/public_html/beta/tms/add_cancelation_rate.php],insert into  agent_credit_log SET agent_id= '7862',credit_value= '5000020.000',credit_usage= '-20.000',credit_limit= '5000000.000',receipt_id= '',amount= '20',booking_id='44',booking_cost= '',receipt_allocation= '',balance= '',ip='43.239.53.130',user_type='admin',admin_id='v3alpha',temp_credit_limit='50000',log_type='Modify Cancellation Rate..',note='Modify Cancellation Rate..',create_date='2023-10-13 09:10:52';
[10/13/2023 09:41:52], [file name :-/home/otrams/public_html/beta/tms/add_cancelation_rate.php], insert into booking_rate_info set  booking_id = '44', booking_log = 'Booking Cancelled', create_date = '2023-10-13 09:41:52', supplier_currency ='USD', type = 'Cancelled Rate Amendment', agent_price = '20', sub_agent_price ='', supplier_price = '', supplier_id = 'expedia', supplier_type = 'online';
