[07/01/2024 09:03:41], [file name :-/efsdata/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-07-01 09:03:41', ip = '36.99.136.137', action = 'Login' ;
[07/01/2024 09:16:45], [file name :-/efsdata/otrams/public_html/beta/tms/add_cancelation_rate.php],UPDATE bookings SET  wh_agent_rate='12' , wh_sub_agent_rate='12.36' WHERE id = '388' AND (current_status = 'cancelled' ) ;
[07/01/2024 09:16:45], [file name :-/efsdata/otrams/public_html/beta/tms/add_cancelation_rate.php],update cancellations set native_charge='0.000',display_charge='12',native_currency_code='USD',display_currency_code='USD',note=' test update notes' where booking_id=388;
[07/01/2024 09:16:45], [file name :-/efsdata/otrams/public_html/beta/tms/add_cancelation_rate.php],UPDATE agents  SET credit_usage=credit_usage+('2'),  credit_value= credit_value-('2')   WHERE id = '7867';
[07/01/2024 09:16:45], [file name :-/efsdata/otrams/public_html/beta/tms/add_cancelation_rate.php],insert into  agent_credit_log SET agent_id= '7867',credit_value= '99999442.650',credit_usage= '556.350',credit_limit= '99999999.000',receipt_id= '',amount= '2',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 09:07:45';
[07/01/2024 09:16:45], [file name :-/efsdata/otrams/public_html/beta/tms/add_cancelation_rate.php],UPDATE agents  SET  cd_credit_usage=cd_credit_usage+('2.06') , cd_credit_value=cd_credit_value-('2.06')  WHERE id = '7870';
[07/01/2024 09:16:45], [file name :-/efsdata/otrams/public_html/beta/tms/add_cancelation_rate.php], update wh_booking_rate_info set  booking_id = '388', booking_log = 'Booking Cancelled', create_date = '2024-07-01 09:16:45', agent_price = '12.000', sub_agent_price = '12.360', supplier_price = '0.000' where booking_id = '388'  and (type = "cancellation rate" or type = "cancelled rate");
[07/01/2024 09:17:03], [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 09:17:03], [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 09:17:03], [file name :-/efsdata/otrams/public_html/beta/tms/add_cancelation_rate.php],UPDATE agents  SET credit_usage=credit_usage+('-2'),  credit_value= credit_value-('-2')   WHERE id = '7867';
[07/01/2024 09:17:03], [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= '-2',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 09:07:03';
[07/01/2024 09:17:03], [file name :-/efsdata/otrams/public_html/beta/tms/add_cancelation_rate.php],UPDATE agents  SET  cd_credit_usage=cd_credit_usage+('-2.06') , cd_credit_value=cd_credit_value-('-2.06')  WHERE id = '7870';
[07/01/2024 09:17:03], [file name :-/efsdata/otrams/public_html/beta/tms/add_cancelation_rate.php], update wh_booking_rate_info set  booking_id = '388', booking_log = 'Booking Cancelled', create_date = '2024-07-01 09:17:03', agent_price = '10.000', sub_agent_price = '10.300', supplier_price = '0.000' where booking_id = '388'  and (type = "cancellation rate" or type = "cancelled rate");
[07/01/2024 09:51:52], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-01 09:51:52',login_attempt=0 where id = '7851';
[07/01/2024 09:51:53], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-07-01 09:51:53', ip = '43.239.53.130', action = 'Login' ;
[07/01/2024 09:52:44], [file name :-/efsdata/otrams/public_html/beta/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header,file_path) VALUE('632', 'SIGHT_CANCELLATION_FEE', 'v1/01_07_2024/request_sight_cancellation_fee_Viator_test_632_09_52_43_1719827563.json', 'v1/01_07_2024/response_sight_cancellation_fee_Viator_test_632_09_52_43_1719827563.json', 'v1/01_07_2024/response_header_sight_cancellation_fee_Viator_test_632_09_52_43_1719827563.json', 'viator', '2024-07-01 09:52:44', '','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_sight_cancellation_fee_Viator_test_632_09_52_43_1719827563.json');
[07/01/2024 09:53:00], [file name :-/efsdata/otrams/public_html/beta/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header,file_path) VALUE('632', 'SIGHT_CANCELLATION_FEE', 'v1/01_07_2024/request_sight_cancellation_fee_Viator_test_632_09_53_00_1719827580.json', 'v1/01_07_2024/response_sight_cancellation_fee_Viator_test_632_09_53_00_1719827580.json', 'v1/01_07_2024/response_header_sight_cancellation_fee_Viator_test_632_09_53_00_1719827580.json', 'viator', '2024-07-01 09:53:00', '','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_sight_cancellation_fee_Viator_test_632_09_53_00_1719827580.json');
[07/01/2024 09:53:06], [file name :-/efsdata/otrams/public_html/beta/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header,file_path) VALUE('632', 'SIGHT_CANCELLATION_FEE', 'v1/01_07_2024/request_sight_cancellation_fee_Viator_test_632_09_53_06_1719827586.json', 'v1/01_07_2024/response_sight_cancellation_fee_Viator_test_632_09_53_06_1719827586.json', 'v1/01_07_2024/response_header_sight_cancellation_fee_Viator_test_632_09_53_06_1719827586.json', 'viator', '2024-07-01 09:53:06', '','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_sight_cancellation_fee_Viator_test_632_09_53_06_1719827586.json');
[07/01/2024 09:53:17], [file name :-/efsdata/otrams/public_html/beta/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header,file_path) VALUE('632', 'SIGHT_CANCELLATION_FEE', 'v1/01_07_2024/request_sight_cancellation_fee_Viator_test_632_09_53_17_1719827597.json', 'v1/01_07_2024/response_sight_cancellation_fee_Viator_test_632_09_53_17_1719827597.json', 'v1/01_07_2024/response_header_sight_cancellation_fee_Viator_test_632_09_53_17_1719827597.json', 'viator', '2024-07-01 09:53:17', '','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_sight_cancellation_fee_Viator_test_632_09_53_17_1719827597.json');
