[10/13/2020 07:06:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT into areas SET status='A',area_name='Test Location',city_code='71129',country_code='132',transfer_type_code= 'H';
[10/13/2020 07:06:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotels SET  name='HappyStay', infant_lower_limit='', infant_upper_limit='2', tiny_child_lower_limit='3', tiny_child_upper_limit='4', child_lower_limit='5', child_upper_limit='6', teen_child_lower_limit='7', teen_child_upper_limit='11', rating='4.0', first_name='test name', last_name='test last name', middle_name='test middle name', city='71129', country='132', status='A', location_id='100', address='Test Address', fax='+605 - 1234 5689', latitude='6.278698', longitude='99.730656', phone='+605 - 1234 5677', email='example1@test.com,example2@test.com,example3@test.com', website='http://www.test.com/', long_desc='TEST HOTEL DESCRIPTION', hotel_amenities='Banquet,Business Centre,Jacuzzi,Data Port,Buffet,Fax,Coffee,Massage,Internet Service,Meeting Rooms,Sauna,Elevator,Spa,Garden,Beach,Smoke Alarm,Steam,Swimming Pool,Luggage Storage,Multilingual,Newspaper,Parking,Safe Deposit Box,Fitness Center,Wheelchair Accessible,Drug Store,Airport Transfer,Pets not Allowed,Concierge,Credit Card,Gift Shop,Doctor,Room Service,Laundry,Morning Call,Shuttle Service,Tour Desk,Taxi,Money Exchange', room_amenities='220 Volt,24 Room Service,Baby Cot,Balcony,Work Desk,Hairdryer,Air Condition,Tea Coffee,WIFI,Non smoking Room,TV,Telephone', weekend='6,7', driving_direction='TESTING DRIVING DIRECTION', near_by='Exhibition Center,Malls', check_in='2:00 pm', check_out='12:00 pm', total_room='123', category_id='1';
[10/13/2020 07:06:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='41' , hotel_id='53772';
[10/13/2020 07:06:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='1' , hotel_id='53772';
[10/13/2020 07:06:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='42' , hotel_id='53772';
[10/13/2020 07:06:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='43' , hotel_id='53772';
[10/13/2020 07:06:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='44' , hotel_id='53772';
[10/13/2020 07:06:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='45' , hotel_id='53772';
[10/13/2020 07:06:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='46' , hotel_id='53772';
[10/13/2020 07:06:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='47' , hotel_id='53772';
[10/13/2020 07:06:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='3' , hotel_id='53772';
[10/13/2020 07:06:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='37' , hotel_id='53772';
[10/13/2020 07:06:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='48' , hotel_id='53772';
[10/13/2020 07:06:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='49' , hotel_id='53772';
[10/13/2020 07:06:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='17' , hotel_id='53772';
[10/13/2020 07:06:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='50' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='6' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='51' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='52' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='7' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='53' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='54' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='55' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='56' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='22' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='10' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='23' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='57' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='58' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='59' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='60' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='61' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='62' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='63' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='18' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='11' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='64' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='65' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='66' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='67' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='68' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='36' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='12' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='69' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='28' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='40' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='34' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='14' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='19' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='20' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='70' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='15' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='31' , hotel_id='53772';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO psa_users set updated='2020-10-13 07:06:57' ,lname='' ,fname='HappyStay' ,mname='' ,email='' ,phone='+605 - 1234 5677' ,time_zone_offset='8' ,enable_dst='' ,id='happystay' ,pass='786d6ea3323842cbacc949b2eb0a7729' ,hash='8225578cfcc7a6833bf3925f29ec15e9' ,groups='6,7' ,active='Y' ,expiration='' ,branch_id='' ,can_debug='' ,allow_book_under_cancellation='' ,allow_cancellation_after_voucher='' ,all_bookings='' ,user_type='supplier' ,site_id='' ;
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO psa_pass_recover (question, answer, id) VALUES ('', '', '8225578cfcc7a6833bf3925f29ec15e9');

[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-13 07:06:57',`log_type`= 'Excel Upload',`sql_query`= 'File Path=alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/csv_roomrates/2b163df88909c73a4047cfbf02ab0b57.xlsx',`log_description`= 'Created Hotel:- HappyStay(53772) and Supplier:-HappyStay(S000000242) From Excel',`ip`= '43.250.210.121';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],insert into user_log_link Set `user_logs_id`='3710', `entity`='Hotels', `value`='53772' ;
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],insert into user_log_link Set `user_logs_id`='3710', `entity`='Suppliers', `value`='S000000242' ;
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],UPDATE inventory_room_class SET inventory_room_class='ROH (Standard/Superior)' WHERE id='140';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO room_class SET room_class='Single' ,min_adult='1' ,max_adult='1' ,max_capacity='1' ,supplier_id='S000000242' ,inventory_class_id='140' ,is_adult_extrabed='no' ,is_child_extrabed='no' ,deny_both_extrabed='0',non_refundable='0';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO room_class SET room_class='Double' ,min_adult='2' ,max_adult='2' ,max_capacity='2' ,supplier_id='S000000242' ,inventory_class_id='140' ,is_adult_extrabed='no' ,is_child_extrabed='no' ,deny_both_extrabed='0',non_refundable='0';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO room_class SET room_class='Triple' ,min_adult='3' ,max_adult='3' ,max_capacity='3' ,supplier_id='S000000242' ,inventory_class_id='140' ,is_adult_extrabed='no' ,is_child_extrabed='no' ,deny_both_extrabed='0',non_refundable='0';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO room_class SET room_class='Quad' ,min_adult='4' ,max_adult='4' ,max_capacity='4' ,supplier_id='S000000242' ,inventory_class_id='140' ,is_adult_extrabed='no' ,is_child_extrabed='no' ,deny_both_extrabed='0',non_refundable='0';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],Insert into hotel_room_class_mapping SET class_id='1040' , hotel_id='53772' , supplier_id='S000000242';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],Insert into hotel_room_class_mapping SET class_id='1041' , hotel_id='53772' , supplier_id='S000000242';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],Insert into hotel_room_class_mapping SET class_id='1042' , hotel_id='53772' , supplier_id='S000000242';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],Insert into hotel_room_class_mapping SET class_id='1043' , hotel_id='53772' , supplier_id='S000000242';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT into hotel_supplier_mapping SET SupplierId='S000000242' ,hotel_id='53772' ,city_code='71129' ,supplier_type='hotel' ,country_code='132';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT into hotel_supplier_currency_mapping SET SupplierId='S000000242' ,hotel_id='53772' ,city_code='71129' ,currency_code='MYR' ,created_datetime='20-10-13 07:06:57' ,ip_addr='43.250.210.121' ,created_by='#admin#excel' ,country_code='132';
[10/13/2020 07:06:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],delete from room_rates where supplier_id='S000000242';
[10/13/2020 07:06:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],UPDATE room_rates SET  stay_note='Tax will be collected at the time of Check-Out'  Where 1 AND hotel_id='53772' AND supplier_id='S000000242'  AND room_class='1040'  AND inventory_class_id='140'  AND (date_from BETWEEN '2021-02-01' AND '2021-04-28')  AND room_basis IN (1);
[10/13/2020 07:06:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO track_booking_note SET stay_note='Tax will be collected at the time of Check-Out' ,supplier_id='S000000242',hotel_id='53772',inventory_class_id='140',room_class='1040',room_basis='1',from_date='2021-02-01',to_date='2021-04-28';
