[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotels SET  name='Oberoi Internationals', infant_lower_limit='', infant_upper_limit='2', tiny_child_lower_limit='3', tiny_child_upper_limit='6', child_lower_limit='7', child_upper_limit='9', teen_child_lower_limit='9', teen_child_upper_limit='11', rating='5.0', first_name='Ankita', last_name='Rao', city='64440', country='106', status='A', address='Test Address', fax='+605 - 1234 5689', latitude='6.278698', longitude='99.730656', phone='+605 - 1234 5677', email='ankita.rao@qtechsoftware.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';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='41' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='1' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='42' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='43' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='44' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='45' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='46' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='47' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='3' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='37' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='48' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='49' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='17' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='50' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='6' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='51' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='52' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='7' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='53' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='54' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='55' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='56' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='22' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='10' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='23' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='57' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='58' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='59' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='60' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='61' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='62' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='63' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='18' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='11' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='64' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='65' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='66' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='67' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='68' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='36' , hotel_id='53778';
[01/20/2021 05:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='12' , hotel_id='53778';
[01/20/2021 05:25:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='69' , hotel_id='53778';
[01/20/2021 05:25:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='28' , hotel_id='53778';
[01/20/2021 05:25:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='40' , hotel_id='53778';
[01/20/2021 05:25:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='34' , hotel_id='53778';
[01/20/2021 05:25:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='14' , hotel_id='53778';
[01/20/2021 05:25:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='19' , hotel_id='53778';
[01/20/2021 05:25:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='20' , hotel_id='53778';
[01/20/2021 05:25:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='70' , hotel_id='53778';
[01/20/2021 05:25:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='15' , hotel_id='53778';
[01/20/2021 05:25:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='31' , hotel_id='53778';
[01/20/2021 05:25:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO psa_users set updated='2021-01-20 05:25:14' ,lname='' ,fname='Oberoi Internationals' ,mname='' ,email='' ,phone='+605 - 1234 5677' ,time_zone_offset='8' ,enable_dst='' ,id='oberoi' ,pass='17f5ecd2c55bbb7709f2ffbe3792218c' ,hash='869ff686bf97dc2b28ee016f28b43af7' ,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='' ;
[01/20/2021 05:25:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO psa_pass_recover (question, answer, id) VALUES ('', '', '869ff686bf97dc2b28ee016f28b43af7');

[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotels SET  name='Oberoi Internationals', infant_lower_limit='', infant_upper_limit='2', tiny_child_lower_limit='3', tiny_child_upper_limit='6', child_lower_limit='7', child_upper_limit='9', teen_child_lower_limit='10', teen_child_upper_limit='11', rating='5.0', first_name='Ankita', last_name='Rao', city='64440', country='106', status='A', address='Test Address', fax='+605 - 1234 5689', latitude='6.278698', longitude='99.730656', phone='+605 - 1234 5677', email='ankita.rao@qtechsoftware.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';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='41' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='1' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='42' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='43' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='44' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='45' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='46' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='47' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='3' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='37' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='48' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='49' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='17' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='50' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='6' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='51' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='52' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='7' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='53' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='54' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='55' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='56' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='22' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='10' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='23' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='57' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='58' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='59' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='60' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='61' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='62' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='63' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='18' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='11' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='64' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='65' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='66' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='67' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='68' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='36' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='12' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='69' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='28' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='40' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='34' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='14' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='19' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='20' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='70' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='15' , hotel_id='53779';
[01/20/2021 05:26:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='31' , hotel_id='53779';

[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotels SET  name='Suzi Plaza', infant_lower_limit='', infant_upper_limit='2', tiny_child_lower_limit='3', tiny_child_upper_limit='6', child_lower_limit='7', child_upper_limit='9', teen_child_lower_limit='10', teen_child_upper_limit='11', rating='5.0', first_name='Ankita', last_name='Rao', city='64440', country='106', status='A', address='Test Address', fax='+605 - 1234 5689', latitude='6.278698', longitude='99.730656', phone='+605 - 1234 5677', email='ankita.rao@qtechsoftware.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';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='41' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='1' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='42' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='43' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='44' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='45' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='46' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='47' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='3' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='37' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='48' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='49' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='17' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='50' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='6' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='51' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='52' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='7' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='53' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='54' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='55' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='56' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='22' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='10' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='23' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='57' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='58' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='59' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='60' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='61' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='62' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='63' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='18' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='11' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='64' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='65' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='66' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='67' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='68' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='36' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='12' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='69' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='28' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='40' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='34' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='14' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='19' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='20' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='70' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='15' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='31' , hotel_id='53780';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO psa_users set updated='2021-01-20 05:28:24' ,lname='' ,fname='Suzi Plaza' ,mname='' ,email='' ,phone='+605 - 1234 5677' ,time_zone_offset='8' ,enable_dst='' ,id='SuziPlaza' ,pass='2c517f5c7158fefc6e0ffb6b61d835b2' ,hash='2a7d6faa75c5df84e8067f7360bf9f10' ,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='' ;
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO psa_pass_recover (question, answer, id) VALUES ('', '', '2a7d6faa75c5df84e8067f7360bf9f10');

[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2021-01-20 05:28:24',`log_type`= 'Excel Upload',`sql_query`= 'File Path=alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/csv_roomrates/a5ce2fa3bb7a9d9d4b619e8adb074f28.xlsx',`log_description`= 'Created Hotel:- Suzi Plaza(53780) and Supplier:-Suzi Plaza(S000000246) From Excel',`ip`= '43.250.210.125';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],insert into user_log_link Set `user_logs_id`='4073', `entity`='Hotels', `value`='53780' ;
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],insert into user_log_link Set `user_logs_id`='4073', `entity`='Suppliers', `value`='S000000246' ;
[01/20/2021 05:28:24], [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';
[01/20/2021 05:28:24], [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='S000000246' ,inventory_class_id='140' ,is_adult_extrabed='no' ,is_child_extrabed='no' ,deny_both_extrabed='0',non_refundable='0';
[01/20/2021 05:28:24], [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='S000000246' ,inventory_class_id='140' ,is_adult_extrabed='no' ,is_child_extrabed='no' ,deny_both_extrabed='0',non_refundable='1';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO room_class SET room_class='Double, Max Pax-3, Extrabed - 1' ,min_adult='2' ,max_adult='3' ,max_capacity='4' ,supplier_id='S000000246' ,inventory_class_id='140' ,is_adult_extrabed='yes' ,is_child_extrabed='yes' ,deny_both_extrabed='0',non_refundable='0';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],Insert into hotel_room_class_mapping SET class_id='1065' , hotel_id='53780' , supplier_id='S000000246';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],Insert into hotel_room_class_mapping SET class_id='1066' , hotel_id='53780' , supplier_id='S000000246';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],Insert into hotel_room_class_mapping SET class_id='1067' , hotel_id='53780' , supplier_id='S000000246';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT into hotel_supplier_mapping SET SupplierId='S000000246' ,hotel_id='53780' ,city_code='64440' ,supplier_type='hotel' ,country_code='106';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT into hotel_supplier_currency_mapping SET SupplierId='S000000246' ,hotel_id='53780' ,city_code='64440' ,currency_code='INR' ,created_datetime='21-01-20 05:28:24' ,ip_addr='43.250.210.125' ,created_by='#admin#excel' ,country_code='106';
[01/20/2021 05:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],delete from room_rates where supplier_id='S000000246';
[01/20/2021 05:28:25], [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='53780' AND supplier_id='S000000246'  AND room_class='1065'  AND inventory_class_id='140'  AND (date_from BETWEEN '2021-02-01' AND '2021-04-28')  AND room_basis IN (1);
[01/20/2021 05:28:25], [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='S000000246',hotel_id='53780',inventory_class_id='140',room_class='1065',room_basis='1',from_date='2021-02-01',to_date='2021-04-28';
[01/20/2021 05:28:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-01', to_date='2021-02-01', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-02', to_date='2021-02-02', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-03', to_date='2021-02-03', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-04', to_date='2021-02-04', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-05', to_date='2021-02-05', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-06', to_date='2021-02-06', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-07', to_date='2021-02-07', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-08', to_date='2021-02-08', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-09', to_date='2021-02-09', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-10', to_date='2021-02-10', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-11', to_date='2021-02-11', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-12', to_date='2021-02-12', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-13', to_date='2021-02-13', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-14', to_date='2021-02-14', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-15', to_date='2021-02-15', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-16', to_date='2021-02-16', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-17', to_date='2021-02-17', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-18', to_date='2021-02-18', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-19', to_date='2021-02-19', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-20', to_date='2021-02-20', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-21', to_date='2021-02-21', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-22', to_date='2021-02-22', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-23', to_date='2021-02-23', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-24', to_date='2021-02-24', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-25', to_date='2021-02-25', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-26', to_date='2021-02-26', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-27', to_date='2021-02-27', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-28', to_date='2021-02-28', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-01', to_date='2021-03-01', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-02', to_date='2021-03-02', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-03', to_date='2021-03-03', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-04', to_date='2021-03-04', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-05', to_date='2021-03-05', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-06', to_date='2021-03-06', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-07', to_date='2021-03-07', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-08', to_date='2021-03-08', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-09', to_date='2021-03-09', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-10', to_date='2021-03-10', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-11', to_date='2021-03-11', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-12', to_date='2021-03-12', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-13', to_date='2021-03-13', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-14', to_date='2021-03-14', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-15', to_date='2021-03-15', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-16', to_date='2021-03-16', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-17', to_date='2021-03-17', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-18', to_date='2021-03-18', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-19', to_date='2021-03-19', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-20', to_date='2021-03-20', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-21', to_date='2021-03-21', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-22', to_date='2021-03-22', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-23', to_date='2021-03-23', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-24', to_date='2021-03-24', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-25', to_date='2021-03-25', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-26', to_date='2021-03-26', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-27', to_date='2021-03-27', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-28', to_date='2021-03-28', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-29', to_date='2021-03-29', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-30', to_date='2021-03-30', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-31', to_date='2021-03-31', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-01', to_date='2021-04-01', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-02', to_date='2021-04-02', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-03', to_date='2021-04-03', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-04', to_date='2021-04-04', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-05', to_date='2021-04-05', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-06', to_date='2021-04-06', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-07', to_date='2021-04-07', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-08', to_date='2021-04-08', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-09', to_date='2021-04-09', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-10', to_date='2021-04-10', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-11', to_date='2021-04-11', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-12', to_date='2021-04-12', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-13', to_date='2021-04-13', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-14', to_date='2021-04-14', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-15', to_date='2021-04-15', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-16', to_date='2021-04-16', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-17', to_date='2021-04-17', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-18', to_date='2021-04-18', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-19', to_date='2021-04-19', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-20', to_date='2021-04-20', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-21', to_date='2021-04-21', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-22', to_date='2021-04-22', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-23', to_date='2021-04-23', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-24', to_date='2021-04-24', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-25', to_date='2021-04-25', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-26', to_date='2021-04-26', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-27', to_date='2021-04-27', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-28', to_date='2021-04-28', supplier_id='S000000246', hotel_id='53780', room_basis_id='1', room_class_id='1067',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:28:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO localsystem_cancellation_policy SET  hotel_id='53780', supplier_id='S000000246', duration_type='days', from_duration='0', to_duration='1', amount_type='no_of_nights', amount_value='1', from_date='2021-02-01', to_date='2021-04-28', added_by='admin', inventory_room_class_id='140';
[01/20/2021 05:28:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],update room_rates set availability='10' ,time_limit='0' where hotel_id='53780' and  supplier_id='S000000246' and inventory_class_id in ('140') and date_from>='2021-02-01' AND date_from<='2021-04-28' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),weekend)>'0';
[01/20/2021 05:28:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],update room_rates set availability='10' ,time_limit='0' where hotel_id='53780' and supplier_id='S000000246' and inventory_class_id in ('140') and date_from>='2021-02-01' AND date_from<='2021-04-28' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),weekend)='0';
[01/20/2021 05:33:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotels SET  name='Malbar Hills', infant_lower_limit='', infant_upper_limit='2', tiny_child_lower_limit='3', tiny_child_upper_limit='6', child_lower_limit='7', child_upper_limit='9', teen_child_lower_limit='10', teen_child_upper_limit='11', rating='5.0', first_name='Ankita', last_name='Rao', city='64440', country='106', status='A', address='Test Address', fax='+605 - 1234 5689', latitude='6.278698', longitude='99.730656', phone='+605 - 1234 5677', email='ankita.rao@qtechsoftware.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';
[01/20/2021 05:33:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='41' , hotel_id='53781';
[01/20/2021 05:33:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='1' , hotel_id='53781';
[01/20/2021 05:33:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='42' , hotel_id='53781';
[01/20/2021 05:33:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='43' , hotel_id='53781';
[01/20/2021 05:33:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='44' , hotel_id='53781';
[01/20/2021 05:33:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='45' , hotel_id='53781';
[01/20/2021 05:33:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='46' , hotel_id='53781';
[01/20/2021 05:33:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='47' , hotel_id='53781';
[01/20/2021 05:33:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='3' , hotel_id='53781';
[01/20/2021 05:33:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='37' , hotel_id='53781';
[01/20/2021 05:33:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='48' , hotel_id='53781';
[01/20/2021 05:33:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='49' , hotel_id='53781';
[01/20/2021 05:33:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='17' , hotel_id='53781';
[01/20/2021 05:33:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='50' , hotel_id='53781';
[01/20/2021 05:33:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='6' , hotel_id='53781';
[01/20/2021 05:33:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='51' , hotel_id='53781';
[01/20/2021 05:33:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='52' , hotel_id='53781';
[01/20/2021 05:33:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='7' , hotel_id='53781';
[01/20/2021 05:33:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='53' , hotel_id='53781';
[01/20/2021 05:33:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='54' , hotel_id='53781';
[01/20/2021 05:33:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='55' , hotel_id='53781';
[01/20/2021 05:33:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='56' , hotel_id='53781';
[01/20/2021 05:33:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='22' , hotel_id='53781';
[01/20/2021 05:33:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='10' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='23' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='57' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='58' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='59' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='60' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='61' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='62' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='63' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='18' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='11' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='64' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='65' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='66' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='67' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='68' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='36' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='12' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='69' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='28' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='40' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='34' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='14' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='19' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='20' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='70' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='15' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO hotel_amenity SET amenity_id='31' , hotel_id='53781';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO psa_users set updated='2021-01-20 05:33:04' ,lname='' ,fname='Malbar Hills' ,mname='' ,email='' ,phone='+605 - 1234 5677' ,time_zone_offset='8' ,enable_dst='' ,id='MalbarHills' ,pass='0184db0329e7a2762c233c809960f029' ,hash='d4c18034cd588a2d14c8bd058b8e4ec5' ,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='' ;
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO psa_pass_recover (question, answer, id) VALUES ('', '', 'd4c18034cd588a2d14c8bd058b8e4ec5');

[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2021-01-20 05:33:04',`log_type`= 'Excel Upload',`sql_query`= 'File Path=alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/csv_roomrates/b6b06fdfb5cb69870163f4300fbf004f.xlsx',`log_description`= 'Created Hotel:- Malbar Hills(53781) and Supplier:-Malbar Hills(S000000247) From Excel',`ip`= '43.250.210.125';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],insert into user_log_link Set `user_logs_id`='4074', `entity`='Hotels', `value`='53781' ;
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],insert into user_log_link Set `user_logs_id`='4074', `entity`='Suppliers', `value`='S000000247' ;
[01/20/2021 05:33:04], [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';
[01/20/2021 05:33:04], [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='S000000247' ,inventory_class_id='140' ,is_adult_extrabed='no' ,is_child_extrabed='no' ,deny_both_extrabed='0',non_refundable='0';
[01/20/2021 05:33:04], [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='S000000247' ,inventory_class_id='140' ,is_adult_extrabed='no' ,is_child_extrabed='no' ,deny_both_extrabed='0',non_refundable='1';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO room_class SET room_class='Double, Max Pax-3, Extrabed - 1' ,min_adult='2' ,max_adult='3' ,max_capacity='4' ,supplier_id='S000000247' ,inventory_class_id='140' ,is_adult_extrabed='yes' ,is_child_extrabed='yes' ,deny_both_extrabed='0',non_refundable='0';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],Insert into hotel_room_class_mapping SET class_id='1068' , hotel_id='53781' , supplier_id='S000000247';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],Insert into hotel_room_class_mapping SET class_id='1069' , hotel_id='53781' , supplier_id='S000000247';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],Insert into hotel_room_class_mapping SET class_id='1070' , hotel_id='53781' , supplier_id='S000000247';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT into hotel_supplier_mapping SET SupplierId='S000000247' ,hotel_id='53781' ,city_code='64440' ,supplier_type='hotel' ,country_code='106';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT into hotel_supplier_currency_mapping SET SupplierId='S000000247' ,hotel_id='53781' ,city_code='64440' ,currency_code='INR' ,created_datetime='21-01-20 05:33:04' ,ip_addr='43.250.210.125' ,created_by='#admin#excel' ,country_code='106';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],delete from room_rates where supplier_id='S000000247';
[01/20/2021 05:33:04], [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='53781' AND supplier_id='S000000247'  AND room_class='1068'  AND inventory_class_id='140'  AND (date_from BETWEEN '2021-02-01' AND '2021-04-28')  AND room_basis IN (1);
[01/20/2021 05:33:04], [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='S000000247',hotel_id='53781',inventory_class_id='140',room_class='1068',room_basis='1',from_date='2021-02-01',to_date='2021-04-28';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-01', to_date='2021-02-01', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-02', to_date='2021-02-02', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-03', to_date='2021-02-03', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-04', to_date='2021-02-04', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-05', to_date='2021-02-05', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-06', to_date='2021-02-06', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-07', to_date='2021-02-07', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-08', to_date='2021-02-08', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-09', to_date='2021-02-09', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-10', to_date='2021-02-10', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-11', to_date='2021-02-11', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-12', to_date='2021-02-12', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-13', to_date='2021-02-13', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-14', to_date='2021-02-14', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-15', to_date='2021-02-15', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-16', to_date='2021-02-16', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-17', to_date='2021-02-17', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-18', to_date='2021-02-18', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-19', to_date='2021-02-19', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-20', to_date='2021-02-20', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-21', to_date='2021-02-21', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-22', to_date='2021-02-22', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-23', to_date='2021-02-23', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-24', to_date='2021-02-24', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-25', to_date='2021-02-25', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-26', to_date='2021-02-26', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-27', to_date='2021-02-27', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-02-28', to_date='2021-02-28', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-01', to_date='2021-03-01', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-02', to_date='2021-03-02', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-03', to_date='2021-03-03', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-04', to_date='2021-03-04', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-05', to_date='2021-03-05', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-06', to_date='2021-03-06', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-07', to_date='2021-03-07', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-08', to_date='2021-03-08', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-09', to_date='2021-03-09', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-10', to_date='2021-03-10', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-11', to_date='2021-03-11', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-12', to_date='2021-03-12', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-13', to_date='2021-03-13', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-14', to_date='2021-03-14', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-15', to_date='2021-03-15', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-16', to_date='2021-03-16', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-17', to_date='2021-03-17', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-18', to_date='2021-03-18', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-19', to_date='2021-03-19', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-20', to_date='2021-03-20', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-21', to_date='2021-03-21', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-22', to_date='2021-03-22', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-23', to_date='2021-03-23', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-24', to_date='2021-03-24', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-25', to_date='2021-03-25', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-26', to_date='2021-03-26', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-27', to_date='2021-03-27', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-28', to_date='2021-03-28', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-29', to_date='2021-03-29', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-30', to_date='2021-03-30', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-03-31', to_date='2021-03-31', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-01', to_date='2021-04-01', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-02', to_date='2021-04-02', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-03', to_date='2021-04-03', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-04', to_date='2021-04-04', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-05', to_date='2021-04-05', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-06', to_date='2021-04-06', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-07', to_date='2021-04-07', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-08', to_date='2021-04-08', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-09', to_date='2021-04-09', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-10', to_date='2021-04-10', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-11', to_date='2021-04-11', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-12', to_date='2021-04-12', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-13', to_date='2021-04-13', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-14', to_date='2021-04-14', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-15', to_date='2021-04-15', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-16', to_date='2021-04-16', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-17', to_date='2021-04-17', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-18', to_date='2021-04-18', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-19', to_date='2021-04-19', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-20', to_date='2021-04-20', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-21', to_date='2021-04-21', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-22', to_date='2021-04-22', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-23', to_date='2021-04-23', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-24', to_date='2021-04-24', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-25', to_date='2021-04-25', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-26', to_date='2021-04-26', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-27', to_date='2021-04-27', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_extrabed_rates SET  from_date='2021-04-28', to_date='2021-04-28', supplier_id='S000000247', hotel_id='53781', room_basis_id='1', room_class_id='1070',	child_no='', adult_wb_rate='100', adult_wb_weekend_rate='111', adult_display='yes',	tiny_child_wtb_rate='20.5',tiny_child_wtb_weekend_rate='20.5',tiny_display='yes', child_wtb_rate='30.5', child_wtb_weekend_rate='30.5',child_display='yes', teen_child_wtb_rate='40.5', teen_child_wtb_weekend_rate='40.5', teen_display='yes';
[01/20/2021 05:33:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO localsystem_cancellation_policy SET  hotel_id='53781', supplier_id='S000000247', duration_type='days', from_duration='0', to_duration='1', amount_type='no_of_nights', amount_value='1', from_date='2021-02-01', to_date='2021-04-28', added_by='admin', inventory_room_class_id='140';
[01/20/2021 05:33:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],update room_rates set availability='10' ,time_limit='0' where hotel_id='53781' and  supplier_id='S000000247' and inventory_class_id in ('140') and date_from>='2021-02-01' AND date_from<='2021-04-28' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),weekend)>'0';
[01/20/2021 05:33:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],update room_rates set availability='10' ,time_limit='0' where hotel_id='53781' and supplier_id='S000000247' and inventory_class_id in ('140') and date_from>='2021-02-01' AND date_from<='2021-04-28' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),weekend)='0';
