[08/04/2020 04:34:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_transfer_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596558864','60.254.42.39');
[08/04/2020 04:37:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596559033','60.254.42.39');
[08/04/2020 04:37:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596559037','60.254.42.39');
[08/04/2020 04:37:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_transfer_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596559046','60.254.42.39');
[08/04/2020 04:37:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596559055','60.254.42.39');
[08/04/2020 04:42:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596559361','60.254.42.39');
[08/04/2020 04:42:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],INSERT into bookings SET reservation_id = '1694' ,agent_id = '25' ,backoffice_user = 'tfg' ,city_id = 'Mumbai' ,country_id = '106' ,leader_title = 'Ms' ,leader_first_name = 'Snehal' ,leader_last_name = 'Valanju' ,nationality = 'Indian' ,display_room_rate = '200' ,display_currency_code = 'INR' ,native_room_rate = '200' ,native_discount = '0' ,display_discount = '0' ,native_currency_code = 'INR' ,current_status = 'confirmed' ,expiration_date = '2020-09-05' ,status_date = '2020-08-04 16:42:41' ,create_date = '2020-08-04 16:42:41' ,source_type = 'misc' ,service_type = 'misc' ,consultant_id = 'tfg' ,sales_manager_id = '' ,applied_multiplier = '1' ,basecurrency_multiplier = '0.01533' ,basecurrency_multiplier_native = '0.01533' ,agent_currency_multiplier = '0.01533' ,created_datetime = '2020-08-04 16:42:41' ,created_by = 'tfg' ,applied_markup = '0' ,agent_markup = '0' ,ip_addr = '60.254.42.39' ,booking_type= 'offline', supplier_rate = '200' ,agent_rate = '200' ,parent_agent_id = '25' ,booking_branch_id = '1' ,service_type_detail = 'Breakfast' ,unit_type = 'Per Pax' ,unit = '2' ,unit_rate = '100' ,check_out_date = '2020-09-05' ,service_date = '2020-09-05' ;
[08/04/2020 04:42:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],INSERT into misc_bookings SET booking_id = '2797' ,service_name = 'Breakfast' ,country = '106' ,title = 'Ms' ,first_name = 'Snehal' ,last_name = 'Valanju' ,city = 'Mumbai' ,book_for = 'Breakfast' ,no_of_services = '1' ,from_date = '2020-09-05' ,to_date = '2020-09-05' ,service_tax_id = '30' ,no_of_adults = '2' ,supplier_adult_rate = '200' ,agent_adult_rate = '200' ,supplier_id  = 'S000000068' ;
[08/04/2020 04:42:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],INSERT INTO passangers SET booking_id='2797',salutations='Ms',first_name='Snehal',last_name='Valanju',passenger_type='adult',age='';
[08/04/2020 04:42:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_booking.php],INSERT INTO passangers SET booking_id='2797',salutations='Ms',first_name='ToBeAdvisedB',last_name='ToBeAdvisedB',passenger_type='adult',age='';
[08/04/2020 04:42:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/offline_additional_service_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
        ('','','2797','confirmed','2020-08-04 16:42:41','Offline Addtional Service Booking by tfg','tfg','60.254.42.39','tfg','','');
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],DELETE FROM hotel_room_class_mapping WHERE hotel_id='53704' AND supplier_id='S000000078';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='1005', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='988', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='990', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='674', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='983', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='982', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='984', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='596', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='595', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='597', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='977', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='976', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='978', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='971', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='970', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='972', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='980', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='979', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='981', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='974', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='973', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='975', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='593', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='592', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='594', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='654', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='991', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='986', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='985', is_channel_manager_mapped = '0';
[08/04/2020 04:50:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='987', is_channel_manager_mapped = '0';
[08/04/2020 04:51:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],DELETE FROM hotel_room_class_mapping WHERE hotel_id='53704' AND supplier_id='S000000078';
[08/04/2020 04:51:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='1005', is_channel_manager_mapped = '0';
[08/04/2020 04:51:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='674', is_channel_manager_mapped = '0';
[08/04/2020 04:51:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='983', is_channel_manager_mapped = '0';
[08/04/2020 04:51:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='982', is_channel_manager_mapped = '0';
[08/04/2020 04:51:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='984', is_channel_manager_mapped = '0';
[08/04/2020 04:51:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='596', is_channel_manager_mapped = '0';
[08/04/2020 04:51:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='595', is_channel_manager_mapped = '0';
[08/04/2020 04:51:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='597', is_channel_manager_mapped = '0';
[08/04/2020 04:51:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='977', is_channel_manager_mapped = '0';
[08/04/2020 04:51:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='976', is_channel_manager_mapped = '0';
[08/04/2020 04:51:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='978', is_channel_manager_mapped = '0';
[08/04/2020 04:51:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='971', is_channel_manager_mapped = '0';
[08/04/2020 04:51:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='970', is_channel_manager_mapped = '0';
[08/04/2020 04:51:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='972', is_channel_manager_mapped = '0';
[08/04/2020 04:51:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='980', is_channel_manager_mapped = '0';
[08/04/2020 04:51:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='979', is_channel_manager_mapped = '0';
[08/04/2020 04:51:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='981', is_channel_manager_mapped = '0';
[08/04/2020 04:51:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='974', is_channel_manager_mapped = '0';
[08/04/2020 04:51:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='973', is_channel_manager_mapped = '0';
[08/04/2020 04:51:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='975', is_channel_manager_mapped = '0';
[08/04/2020 04:51:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='593', is_channel_manager_mapped = '0';
[08/04/2020 04:51:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='592', is_channel_manager_mapped = '0';
[08/04/2020 04:51:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='594', is_channel_manager_mapped = '0';
[08/04/2020 04:51:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='654', is_channel_manager_mapped = '0';
[08/04/2020 04:51:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='991', is_channel_manager_mapped = '0';
[08/04/2020 04:51:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='986', is_channel_manager_mapped = '0';
[08/04/2020 04:51:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='985', is_channel_manager_mapped = '0';
[08/04/2020 04:51:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53704', supplier_id='S000000078', class_id='987', is_channel_manager_mapped = '0';
[08/04/2020 04:53:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-04 16:53:12',`log_type`= 'Excel Update',`sql_query`= 'File Path=uat.tfg.otrams.net/project_folder/tfg_project/protected/csv_roomrates/7063b29b7da83fb61384e23d7ce20ac1.xls',`log_description`= 'Update Content for Hotel:- Tamasha(53704) and Supplier:-Tamasha(S000000078) From Excel',`ip`= '60.254.42.39';
[08/04/2020 04:53:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],insert into user_log_link Set `user_logs_id`='3495', `entity`='Hotels', `value`='53704' ;
[08/04/2020 04:53:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],insert into user_log_link Set `user_logs_id`='3495', `entity`='Suppliers', `value`='S000000078' ;
