[08/05/2020 11:00:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],DELETE FROM report_access where psa_user_id='tfg';
[08/05/2020 11:00:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='receipts_report';
[08/05/2020 11:00:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='agent_wise_logs';
[08/05/2020 11:00:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='day_wise_agent_due';
[08/05/2020 11:00:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='agent_wise_business';
[08/05/2020 11:00:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='auto_recon_all';
[08/05/2020 11:00:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='city_wise_sales_report';
[08/05/2020 11:00:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='commission_report';
[08/05/2020 11:00:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='country_wise_agent_due';
[08/05/2020 11:00:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='country_wise_sales_report';
[08/05/2020 11:00:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='customer_outstanding';
[08/05/2020 11:00:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='customer_statement';
[08/05/2020 11:00:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='customer_statement_single_invoice';
[08/05/2020 11:00:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='exchange_rate';
[08/05/2020 11:00:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='daily_roe_report';
[08/05/2020 11:00:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='branch_daily_sales';
[08/05/2020 11:00:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='download_newsletter';
[08/05/2020 11:00:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='hotel_wise_sales';
[08/05/2020 11:00:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='invoice_report';
[08/05/2020 11:00:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='local_supplier_wise_business';
[08/05/2020 11:00:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='loyalty_program_report';
[08/05/2020 11:00:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='online_supplier_wise_business';
[08/05/2020 11:00:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='pg_bookings';
[08/05/2020 11:00:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='sales_manager';
[08/05/2020 11:00:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='service_tax_wise';
[08/05/2020 11:00:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='supplier_booking_track_destination';
[08/05/2020 11:00:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='supplier_outstanding_report';
[08/05/2020 11:00:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='payments_report';
[08/05/2020 11:00:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='supplier_booking_track';
[08/05/2020 11:00:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='supplier_booking_track_night';
[08/05/2020 11:00:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='supplier_profile';
[08/05/2020 11:00:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='supplier_statement_local';
[08/05/2020 11:00:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='supplier_statement_online';
[08/05/2020 11:00:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='tfg',report_function_name='voucher_report';
[08/05/2020 11:00:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO logistics_driver_vehicle_status SET vehicle_id='4',from_date='2020-08-31 05:30:00',to_date='2020-08-31 05:30:00',status='block';
[08/05/2020 11:01:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],DELETE FROM report_access where psa_user_id='accounts';
[08/05/2020 11:01:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='receipts_report';
[08/05/2020 11:01:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='agent_wise_logs';
[08/05/2020 11:01:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='day_wise_agent_due';
[08/05/2020 11:01:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='agent_wise_business';
[08/05/2020 11:01:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='auto_recon_all';
[08/05/2020 11:01:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='city_wise_sales_report';
[08/05/2020 11:01:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='commission_report';
[08/05/2020 11:01:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='country_wise_agent_due';
[08/05/2020 11:01:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='country_wise_sales_report';
[08/05/2020 11:01:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='customer_outstanding';
[08/05/2020 11:01:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='customer_statement';
[08/05/2020 11:01:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='customer_statement_single_invoice';
[08/05/2020 11:01:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='exchange_rate';
[08/05/2020 11:01:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='daily_roe_report';
[08/05/2020 11:01:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='branch_daily_sales';
[08/05/2020 11:01:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='download_newsletter';
[08/05/2020 11:01:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='hotel_wise_sales';
[08/05/2020 11:01:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='invoice_report';
[08/05/2020 11:01:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='local_supplier_wise_business';
[08/05/2020 11:01:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='loyalty_program_report';
[08/05/2020 11:01:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='online_supplier_wise_business';
[08/05/2020 11:01:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='pg_bookings';
[08/05/2020 11:01:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='sales_manager';
[08/05/2020 11:01:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='service_tax_wise';
[08/05/2020 11:01:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='supplier_booking_track_destination';
[08/05/2020 11:01:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='supplier_outstanding_report';
[08/05/2020 11:01:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='payments_report';
[08/05/2020 11:01:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='supplier_booking_track';
[08/05/2020 11:01:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='supplier_booking_track_night';
[08/05/2020 11:01:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='supplier_profile';
[08/05/2020 11:01:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='supplier_statement_local';
[08/05/2020 11:01:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='supplier_statement_online';
[08/05/2020 11:01:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access.php],INSERT INTO report_access SET psa_user_id='accounts',report_function_name='voucher_report';
[08/05/2020 11:10:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],UPDATE driver_details SET  first_name = 'SGuide1' ,  last_name = 'Valanju' ,  curr_add = 'asdfghj' ,  gender = 'female' ,  contact_number = '12345678' ,  email = '' ,  status = 'A' ,  licence_valid_from = '2020-07-01' ,  licence_valid_to = '2022-12-31' ,  license_no = '123456789' , supplier = 'S000000072' , experience = '1' , type = 'guide' WHERE ID='6';
[08/05/2020 11:16:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],Insert into logistics_daily_vehicle_movement Set
		movemnt_date='2020-08-31',
		assign_no='L00108',
		driver='5',
		assign_detail='',
		est_km='100',
		gps_km='',
		km='115',
		expected_out_time='16:45:43',
		out_time='16:52:46',
		expected_in_time='16:46:01',
		vehicle='4',
		in_time='16:52:53';
[08/05/2020 11:29:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_category.php],UPDATE hotel_categories SET status='D' WHERE id= '5';
[08/05/2020 11:29:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_category.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-05 11:29:10',`log_type`= 'Hotel Category Mapping',`sql_query`= 'UPDATE hotel_categories SET status=\&#039;D\&#039; WHERE id= \&#039;5\&#039;',`log_description`= 'A Manual Hotel Category Mapping has been Deleted',`ip`= '45.120.147.56';
[08/05/2020 11:31:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_category.php],UPDATE hotel_categories SET status='D' WHERE id= '5';
[08/05/2020 11:31:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_category.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-05 11:31:53',`log_type`= 'Hotel Category Mapping',`sql_query`= 'UPDATE hotel_categories SET status=\&#039;D\&#039; WHERE id= \&#039;5\&#039;',`log_description`= 'A Manual Hotel Category Mapping has been Deleted',`ip`= '45.120.147.56';
[08/05/2020 11:52:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-08-05',to_date='2020-08-05',supplier_id='S000000078',hotel_id='53704',room_basis_id='1',room_class_id='1005',child_no='',infant_wtc_rate='10',infant_wtc_weekend_rate='10',infant_display= 'yes',tiny_child_wtb_rate='20',tiny_child_wtb_weekend_rate='20',tiny_display= 'yes',child_wtb_rate='30',child_wtb_weekend_rate='30',child_display= 'yes',teen_child_wtb_rate='40',teen_child_wtb_weekend_rate='40',teen_display= 'yes',adult_wb_rate='50',adult_wb_weekend_rate='50',adult_display= 'yes';
[08/05/2020 11:52:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-08-05 11:52:26',`log_type`= 'ExtraBed Rates',`sql_query`= '',`log_description`= 'Extrabed Rates For Ramada Qtech Test_newTest(Do not Book) added successfully for Room Category :- 04 Suites - Double, Extrabed - 1(Bed & Breakfast) From :- 05-08-2020 To :- 05-08-2020',`ip`= '60.254.42.39',`username`= 'tfg',`user_id`= 'S000000078';
[08/05/2020 11:52:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3540', `entity`='Hotels', `value`='53704' ;
[08/05/2020 11:52:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3540', `entity`='Suppliers', `value`='S000000078' ;
[08/05/2020 11:52:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3540', `entity`='Inventory', `value`='99' ;
[08/05/2020 11:52:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3540', `entity`='Room', `value`='1005' ;
[08/05/2020 11:53:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO applicable_offer_rates SET offer_type_code= 'EBD',is_compulsory= 'no',nationality= '',rate_profile= '',room_type= '',room_basis= '',offer_room_class= '',hotel_id= '53704',country_id= '132',city_id= '71129',star_rating='',display_oid= '234567',is_min_offer= '',is_max_offer= '',min_stay= '0',max_stay= '0',sf_date='2020-08-01',st_date='2020-08-31',bf_date='2020-08-01',bt_date='2020-08-31',create_date = '2020-08-05 11:53:57',supplier_id= 'S000000078',supplier_type= 'Offline',is_refundable_offer= 'yes',offer_note= '',agent_id= '',offer_apply_on= 'total_rate',offer_options= 'all',ratetype_per_night= 'Amount',currency= 'USD',ratevalue_per_night= '10',offer_only_for= 'all';
[08/05/2020 11:53:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],UPDATE applicable_offer_rates SET oid='0078-11584' WHERE aoid='11584' AND STATUS <> 'D';
[08/05/2020 11:53:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-08-05 11:53:57',`log_type`= 'Manage Offer/Discount',`sql_query`= 'INSERT INTO applicable_offer_rates SET offer_type_code= \&#039;EBD\&#039;,is_compulsory= \&#039;no\&#039;,nationality= \&#039;\&#039;,rate_profile= \&#039;\&#039;,room_type= \&#039;\&#039;,room_basis= \&#039;\&#039;,offer_room_class= \&#039;\&#039;,hotel_id= \&#039;53704\&#039;,country_id= \&#039;132\&#039;,city_id= \&#039;71129\&#039;,star_rating=\&#039;\&#039;,display_oid= \&#039;234567\&#039;,is_min_offer= \&#039;\&#039;,is_max_offer= \&#039;\&#039;,min_stay= \&#039;0\&#039;,max_stay= \&#039;0\&#039;,sf_date=\&#039;2020-08-01\&#039;,st_date=\&#039;2020-08-31\&#039;,bf_date=\&#039;2020-08-01\&#039;,bt_date=\&#039;2020-08-31\&#039;,create_date = \&#039;2020-08-05 11:53:57\&#039;,supplier_id= \&#039;S000000078\&#039;,supplier_type= \&#039;Offline\&#039;,is_refundable_offer= \&#039;yes\&#039;,offer_note= \&#039;\&#039;,agent_id= ,offer_apply_on= \&#039;total_rate\&#039;,offer_options= \&#039;all\&#039;,ratetype_per_night= \&#039;Amount\&#039;,currency= \&#039;USD\&#039;,ratevalue_per_night= \&#039;10\&#039;,offer_only_for= \&#039;all\&#039;',`log_description`= 'New Offer -Early Bird 0078-11584 Added By Supplier ',`ip`= '60.254.42.39',`username`= 'tfg',`user_id`= 'S000000078';
[08/05/2020 11:53:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3541', `entity`='Suppliers', `value`='S000000078' ;
[08/05/2020 11:53:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3541', `entity`='Hotels', `value`='53704' ;
[08/05/2020 11:56:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596628583','60.254.42.39');
