[12/03/2020 01:01:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/channel_manager_push_reservation.php],update bookings_details set reservation_pushed = '0', channel_manager = 'rategain',room_type_description='' where booking_id = '3074';
[12/03/2020 01:04:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1607000651','60.254.11.202');
[12/03/2020 01:04:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1607000678','60.254.11.202');
[12/03/2020 01:04:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO bookings SET  source_type = 'localsystem', reservation_id = '1918', create_date = '2020-12-03 13:04:43', agent_id = '24', parent_agent_id = '24', agent_ref_no = '', nationality = 'Indian', city_id = 'mumbai', country_id = '106', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '440', display_currency_code = 'AED', native_room_rate = '440', native_currency_code = 'AED', supplier_profile_id = '1', service_type = 'hotel', service_date = '2021/06/03', check_out_date = '2021/06/04', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'Deep', leader_last_name = 'Mishra', booking_branch_id = '1', expiration_date = '2021-05-29 00:00:00', cancellation_policy = 'Amendment of Dates, Room Category, Passenger Names are considered as Cancel and Rebook by most of the Hotels.
        Any Changes in initial booking may be denied by the supplier or may result in extra charges.
        Confirmation of amendment requests is subject to availablity and rates at the time of amendment.<Br><Br><B><U>Detailed Cancellation Policy:</U></B> <br/> Cancellation Charges of 440 AED applicable if cancelled after 29-May-2021 05:30 hrs.', supplier_cancellation_policy = '', status_date = '2020-12-03 13:04:43',  site_url = 'https://alpha.otrams.thefabulousgetaway.com/';
[12/03/2020 01:04:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO external_mapping_data_tracking (booking_id,search_hotel_name,booked_hotel_name_supplier,hotel_id,master_id,city_id,supplier,date) VALUES ('3075','RATEGAINONE','RATEGAINONE','53773','53773','mumbai','LOCAL_SUPPLIER',NOW());
[12/03/2020 01:04:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='3075'
        ;
[12/03/2020 01:04:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into bookings_details(booking_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,hotel_id,local_hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('3075','S000000241','1','1','0','-','','','53773','53773','RATEGAINONE','Mumbai','123456789','5.0','1','2021/06/03','2021/06/04','','https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/images/imagenotavailable.jpg');
[12/03/2020 01:04:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into booking_room_detail set  booking_id = '3075', booking_detail_id = '1213', room_type_code = '1~~~132~~~1039~~~1~~~~~~~~~64440~~~0~~~S000000241', room_name = 'single', room_type_description = 'Standard  -Bed & Breakfast : 1 Pax <font color=\'red\'>-D</font>', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:\"displayNightlyRate\";i:440;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:152:\"Supplier Name - localsupplier(RateGainSupplier - S000000241), Rate - 440 AED, Currency Multiplier (AED-AED) - 1.00000 Supplier Commission-0 #localsystem\";}}', native_nightly_rates = 'a:1:{i:0;a:4:{s:19:\"O_nativeNightlyRate\";i:440;s:17:\"nativeNightlyRate\";i:440;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";s:0:\"\";s:4:\"Name\";s:0:\"\";s:7:\"S_Value\";s:0:\"\";s:5:\"Value\";i:0;s:12:\"Display_Name\";s:0:\"\";s:10:\"Offer_Note\";N;s:10:\"Offer_Type\";N;}}}', markup = '0', commission = '0', native_room_rate_total = '440', display_room_rate_total = '440', number_of_rooms = '1';
[12/03/2020 01:04:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into passangers set  booking_id = '3075', booking_detail_id = '1213', rid = '1816', room = '0', salutations = 'Mr', first_name = 'Deep', last_name = 'Mishra', passenger_type = 'adult', age = '';
[12/03/2020 01:04:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set  special_remark = 'We are celebrating our 14th Wedding Anniversary with the hotel', itenirary_id = '', confirmation_number = '', display_discount = '0', current_status = 'confirmed', comment_contract = '', consultant_id = 'SalesConsultant', sales_manager_id = '', admin_booked = '0', email_id = 'deep.mishra@rategain.com', leader_phone = '+543514149600', agent_currency_multiplier = '0.27222', ip_addr = '60.254.11.202', backoffice_user = 'tfg', customer_id = '', applied_multiplier='1.00000', free_sale='',  applied_markup='0',  agent_markup='0',  basecurrency_multiplier='0.27222',  basecurrency_multiplier_native='0.27222',  parent_agent_id='24',  sub_agent_rate='0', agent_rate='440',  applicable_service_tax='0',  supplier_rate='440',  original_source='',  uid='c701775ab5408c2860edc3cf2984daf7'  where id='3075';
[12/03/2020 01:04:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' ,gtaToken = '' , special_request='' where booking_id ='3075';
[12/03/2020 01:04:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings_details set reservation_pushed = '1', channel_manager = 'rategain',room_type_description='' where booking_id = '3075';
[12/03/2020 01:04:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,supplier_charge,agent_charge,lead_time,create_date)  VALUES('3075','2021-05-29 05:30:00','2021-05-29 05:30:00','440','440','0','2020-12-03 13:04:43');
[12/03/2020 01:04:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('3075','','');
[12/03/2020 01:04:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_status (booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by) VALUES ('3075','confirmed','2020-12-03 13:04:43','Booking confirmed . Booked by Back Office tfg on behalf of Agent - Snehal  Valanju(CD0024)','24','60.254.11.202','0','24');
[12/03/2020 01:04:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_search_log(booking_id, details)
        VALUES(3075, 'a:30:{s:3:\"_id\";a:1:{s:4:\"$oid\";s:24:\"5fc8dad8e446db38631230b3\";}s:7:\"hotelId\";s:25:\"53773----------S000000241\";s:4:\"name\";s:11:\"RATEGAINONE\";s:14:\"local_hotel_id\";s:5:\"53773\";s:8:\"address1\";s:6:\"Mumbai\";s:8:\"latitude\";s:0:\"\";s:9:\"longitude\";s:0:\"\";s:4:\"city\";s:5:\"64440\";s:8:\"location\";s:0:\"\";s:14:\"prefered_hotel\";s:1:\"0\";s:10:\"mlosSlogan\";s:0:\"\";s:16:\"isMlosApplicable\";s:2:\"no\";s:7:\"country\";s:3:\"106\";s:16:\"rateCurrencyCode\";s:3:\"AED\";s:5:\"phone\";s:9:\"123456789\";s:16:\"shortDescription\";s:24:\"No Description Available\";s:11:\"website_url\";s:0:\"\";s:12:\"thumbNailUrl\";s:99:\"https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/images/imagenotavailable.jpg\";s:10:\"sourceType\";s:11:\"localsystem\";s:10:\"supplierid\";s:10:\"S000000241\";s:12:\"suppliername\";s:16:\"RateGainSupplier\";s:14:\"propertyRating\";s:3:\"5.0\";s:15:\"specialCategory\";a:1:{i:0;s:1:\"1\";}s:13:\"HotelProperty\";a:1:{s:11:\"localsystem\";a:1:{i:0;a:1:{s:8:\"RateInfo\";a:13:{s:10:\"room_rates\";a:1:{i:0;a:33:{s:11:\"ratebreakup\";a:4:{s:6:\"markup\";i:0;s:10:\"commission\";i:0;s:18:\"NativeNightlyRates\";a:1:{i:0;a:4:{s:19:\"O_nativeNightlyRate\";i:440;s:17:\"nativeNightlyRate\";i:440;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";s:0:\"\";s:4:\"Name\";s:0:\"\";s:7:\"S_Value\";s:0:\"\";s:5:\"Value\";i:0;s:12:\"Display_Name\";s:0:\"\";s:10:\"Offer_Note\";N;s:10:\"Offer_Type\";N;}}}s:19:\"DisplayNightlyRates\";a:1:{i:0;a:3:{s:18:\"displayNightlyRate\";i:440;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:152:\"Supplier Name - localsupplier(RateGainSupplier - S000000241), Rate - 440 AED, Currency Multiplier (AED-AED) - 1.00000 Supplier Commission-0 #localsystem\";}}}s:20:\"offer_promotion_note\";s:0:\"\";s:19:\"offer_discount_type\";s:0:\"\";s:27:\"offer_discount_note_details\";N;s:9:\"room_name\";s:6:\"single\";s:9:\"stay_note\";N;s:10:\"time_stamp\";s:32:\"45d33fef9a5a7b6ec3a37485aa3da5d1\";s:16:\"number_of_adults\";s:1:\"1\";s:10:\"view_basis\";s:0:\"\";s:13:\"view_basis_id\";s:1:\"0\";s:9:\"available\";i:1;s:9:\"free_sale\";N;s:7:\"minStay\";s:1:\"1\";s:19:\"displayCurrencyCode\";s:3:\"AED\";s:18:\"nativeCurrencyCode\";s:3:\"AED\";s:20:\"displayRoomTypeRates\";i:440;s:20:\"sortingRoomTypeRates\";i:440;s:19:\"nativeRoomTypeRates\";i:440;s:12:\"offerApplied\";N;s:7:\"room_id\";s:49:\"1~~~132~~~1039~~~1~~~~~~~~~64440~~~0~~~S000000241\";s:14:\"room_type_code\";s:1:\"1\";s:14:\"boardtype_code\";s:1:\"1\";s:16:\"valuation_number\";s:49:\"1~~~132~~~1039~~~1~~~~~~~~~64440~~~0~~~S000000241\";s:15:\"number_of_child\";i:0;s:13:\"NumberOfRooms\";i:1;s:10:\"supplierId\";s:10:\"S000000241\";s:12:\"supplierName\";s:16:\"RateGainSupplier\";s:10:\"meal_basis\";s:15:\"Bed & Breakfast\";s:4:\"note\";s:0:\"\";s:13:\"room_category\";s:13:\"Standard Room\";s:9:\"room_type\";s:62:\"Standard  -Bed & Breakfast : 1 Pax <font color=\'red\'>-D</font>\";s:14:\"non_refundable\";s:1:\"0\";s:15:\"class_unique_id\";s:17:\"0_0_53773_5908841\";}}s:9:\"available\";i:1;s:15:\"displayRoomRate\";i:440;s:14:\"nativeRoomRate\";i:440;s:9:\"unique_id\";s:37:\"1_53773----------S000000241_0_0_22514\";s:10:\"supplierId\";s:10:\"S000000241\";s:19:\"displayCurrencyCode\";s:3:\"AED\";s:18:\"nativeCurrencyCode\";s:3:\"AED\";s:18:\"applied_markup_per\";i:0;s:18:\"applied_multiplier\";s:7:\"1.00000\";s:19:\"supplier_profile_id\";s:1:\"1\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53773----------S000000241\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:11:\"RATEGAINONE\";s:18:\"supp_hotel_address\";s:6:\"Mumbai\";s:10:\"supplierId\";s:10:\"S000000241\";}s:8:\"no_class\";i:0;}}}}s:13:\"total_charges\";i:440;s:17:\"propertyAvailable\";i:1;s:8:\"no_class\";i:0;s:18:\"sort_total_charges\";i:440;s:16:\"hotel_name_ascii\";s:11:\"rategainone\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53773----------S000000241\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:11:\"RATEGAINONE\";s:18:\"supp_hotel_address\";s:6:\"Mumbai\";s:10:\"supplierId\";s:10:\"S000000241\";}}');
[12/03/2020 01:04:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,to_date,supplier_to_date,supplier_charge,agent_charge,lead_time,create_date,applied_agent_charges)  VALUES('3075','2021-05-29 05:30:00','2021-05-29 05:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00','440','440','0','2020-12-03 13:04:43','');
[12/03/2020 01:04:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings_details set reservation_pushed = '1', channel_manager = 'rategain',room_type_description='' where booking_id = '3075';
[12/03/2020 01:04:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO bookings_applicable_offer set  oid= '',  offer_type_code= '',  booking_id= '3075',  room_id= '1~~~132~~~1039~~~1~~~~~~~~~64440~~~0~~~S000000241',  room_name= 'single',  supplier_id= 'S000000241',  agent_id= '',  applied_native_discount= '0',  original_native_rate= '440',  native_rate= '440',  promotion_text= '',  offer_disc_type= '',  offer_disc_value= '',  offer_disc_currency= '',  create_date= '2020-12-03 13:04:43' ;
[12/03/2020 01:04:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set confirmation_number='',itenirary_id='3075' where  id ='3075';
[12/03/2020 01:04:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],UPDATE room_rates SET availability = availability-1,consumed_inventory = consumed_inventory+1 WHERE hotel_id = '53773' and inventory_class_id = '132' and supplier_id = 'S000000241' and date_from = '2021-06-03';
[12/03/2020 01:04:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update supplement_rate set inventory = '0' where supplement_rate_id = '1';
[12/03/2020 01:04:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into booking_configuration set  booking_id = '3075', config_key = 'BOOKING OTP', config_value = 'EkYwra7u';;
[12/03/2020 01:04:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= ' TFG103075 /  Booking Confirmed ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 40520 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking.php',create_date= '2020-12-03 13:04:43';
[12/03/2020 01:04:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3075','snehal.valanju@qtechsoftware.com');
[12/03/2020 01:04:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3075','snehal.valanju@qtechsoftware.com');
[12/03/2020 01:04:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update posted_bookings set booking_id='3075',status='1' where reservation_id='1918' and booking_id ='0';
[12/03/2020 01:04:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update xmllogs set reservation_id='3075' where agent_logs_id='511' and source_type='localsystem';
[12/03/2020 01:04:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='',  profit_percent='',  gross_profit='',  commission_tax='',  booking_id ='3075',  create_date ='2020-12-03 13:04:43', supplier_tax='';
[12/03/2020 01:04:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= ' TFG103075 /  Booking Confirmed ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 27588 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,SalesConsultant@gmail.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking.php',create_date= '2020-12-03 13:04:45';
[12/03/2020 01:04:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3075','snehal.valanju@qtechsoftware.com');
[12/03/2020 01:04:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3075','SalesConsultant@gmail.com');
[12/03/2020 01:04:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= 'Special Remark / Request Added  For Booking ID-3075 - The Fabulous Getaway',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICwgPGJyPjxici8+U3BlY2lhbCBSZW1hcmsgLyBSZXF1ZXN0IEFkZGVkICBGb3IgQm9va2luZyBJRC0gPGI+MzA3NSA8L2I+PGJyLz4gQmVsb3cgYXJlIHRoZSBEZXRhaWxzIDxicj48YnIvPk90aGVyIFJlbWFyayA6V2UgYXJlIGNlbGVicmF0aW5nIG91ciAxNHRoIFdlZGRpbmcgQW5uaXZlcnNhcnkgd2l0aCB0aGUgaG90ZWw8YnI+PGJyLz4=',to_email_id= '',cc= '',bcc= '',status= 'You must provide at least one recipient email address.',page_url= '/confirm_booking.php',create_date= '2020-12-03 13:04:45';
[12/03/2020 01:04:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO mails_error_log set mailfrom='sanket.desai@qtechsoftware.com',mailsubject='Special Remark / Request Added  For Booking ID-3075 - The Fabulous Getaway',mailbody='Dear Team , &lt;br&gt;&lt;br/&gt;Special Remark / Request Added  For Booking ID- &lt;b&gt;3075 &lt;/b&gt;&lt;br/&gt; Below are the Details &lt;br&gt;&lt;br/&gt;Other Remark :We are celebrating our 14th Wedding Anniversary with the hotel&lt;br&gt;&lt;br/&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2020-12-03 01:04:45';
[12/03/2020 01:04:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/channel_manager_push_reservation.php],update bookings_details set reservation_pushed = '0', channel_manager = 'rategain',room_type_description='' where booking_id = '3075';
[12/03/2020 01:22:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '0'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-03' AND inventory_class_id= '132';
[12/03/2020 01:22:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2020-12-03',availability = '0',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_19_1607001739_53773.xml',create_date = '2020-12-03 13:22:19';
[12/03/2020 01:22:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 13:22:19',channel_manager_name= 'rategain',hotel_id= '53773',rate_id= '132',start_date= '2020-12-03';
[12/03/2020 01:22:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTM6MjI6MTk8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTAzPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 13:22:20';
[12/03/2020 01:22:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 13:22:19<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-03<br>',  email_sent ='yes', create_date ='2020-12-03 13:22:20', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 01:22:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '1'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-03' AND inventory_class_id= '132';
[12/03/2020 01:22:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2020-12-03',availability = '1',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_24_1607001744_53773.xml',create_date = '2020-12-03 13:22:24';
[12/03/2020 01:22:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 13:22:24',channel_manager_name= 'rategain',hotel_id= '53773',rate_id= '132',start_date= '2020-12-03';
[12/03/2020 01:22:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTM6MjI6MjQ8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTAzPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 13:22:24';
[12/03/2020 01:22:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 13:22:24<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-03<br>',  email_sent ='yes', create_date ='2020-12-03 13:22:24', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 01:22:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '10'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-03' AND inventory_class_id= '132';
[12/03/2020 01:22:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2020-12-03',availability = '10',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_28_1607001748_53773.xml',create_date = '2020-12-03 13:22:28';
[12/03/2020 01:22:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 13:22:28',channel_manager_name= 'rategain',hotel_id= '53773',rate_id= '132',start_date= '2020-12-03';
[12/03/2020 01:22:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTM6MjI6Mjg8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTAzPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 13:22:28';
[12/03/2020 01:22:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 13:22:28<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-03<br>',  email_sent ='yes', create_date ='2020-12-03 13:22:28', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 01:22:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '999'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-03' AND inventory_class_id= '132';
[12/03/2020 01:22:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2020-12-03',availability = '999',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_32_1607001752_53773.xml',create_date = '2020-12-03 13:22:32';
[12/03/2020 01:22:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 13:22:32',channel_manager_name= 'rategain',hotel_id= '53773',rate_id= '132',start_date= '2020-12-03';
[12/03/2020 01:22:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTM6MjI6MzI8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTAzPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 13:22:33';
[12/03/2020 01:22:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 13:22:32<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-03<br>',  email_sent ='yes', create_date ='2020-12-03 13:22:33', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 01:22:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '11'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-03' AND inventory_class_id= '132';
[12/03/2020 01:22:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2020-12-03',availability = '11',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_36_1607001756_53773.xml',create_date = '2020-12-03 13:22:36';
[12/03/2020 01:22:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '11'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-04' AND inventory_class_id= '132';
[12/03/2020 01:22:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2020-12-04',availability = '11',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_36_1607001756_53773.xml',create_date = '2020-12-03 13:22:36';
[12/03/2020 01:22:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '11'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-05' AND inventory_class_id= '132';
[12/03/2020 01:22:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2020-12-05',availability = '11',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_36_1607001756_53773.xml',create_date = '2020-12-03 13:22:36';
[12/03/2020 01:22:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '11'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-06' AND inventory_class_id= '132';
[12/03/2020 01:22:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2020-12-06',availability = '11',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_36_1607001756_53773.xml',create_date = '2020-12-03 13:22:36';
[12/03/2020 01:22:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '11'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-07' AND inventory_class_id= '132';
[12/03/2020 01:22:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2020-12-07',availability = '11',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_36_1607001756_53773.xml',create_date = '2020-12-03 13:22:37';
[12/03/2020 01:22:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '11'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-08' AND inventory_class_id= '132';
[12/03/2020 01:22:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2020-12-08',availability = '11',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_36_1607001756_53773.xml',create_date = '2020-12-03 13:22:37';
[12/03/2020 01:22:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '11'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-09' AND inventory_class_id= '132';
[12/03/2020 01:22:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2020-12-09',availability = '11',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_36_1607001756_53773.xml',create_date = '2020-12-03 13:22:37';
[12/03/2020 01:22:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 13:22:36',channel_manager_name= 'rategain',hotel_id= '53773',rate_id= '132',start_date= '2020-12-03';
[12/03/2020 01:22:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTM6MjI6MzY8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTAzICwgMjAyMC0xMi0wNCAsIDIwMjAtMTItMDUgLCAyMDIwLTEyLTA2ICwgMjAyMC0xMi0wNyAsIDIwMjAtMTItMDggLCAyMDIwLTEyLTA5PGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 13:22:37';
[12/03/2020 01:22:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 13:22:36<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-03 , 2020-12-04 , 2020-12-05 , 2020-12-06 , 2020-12-07 , 2020-12-08 , 2020-12-09<br>',  email_sent ='yes', create_date ='2020-12-03 13:22:37', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-28' AND inventory_class_id= '132';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-01-28',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:42';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-29' AND inventory_class_id= '132';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-01-29',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:42';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-30' AND inventory_class_id= '132';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-01-30',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:42';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-31' AND inventory_class_id= '132';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-01-31',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:42';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-01' AND inventory_class_id= '132';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-01',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:42';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-02' AND inventory_class_id= '132';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-02',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:42';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-03' AND inventory_class_id= '132';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-03',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:42';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-04' AND inventory_class_id= '132';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-04',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:42';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-05' AND inventory_class_id= '132';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-05',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:42';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-06' AND inventory_class_id= '132';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-06',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:42';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-07' AND inventory_class_id= '132';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-07',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:42';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-08' AND inventory_class_id= '132';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-08',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:42';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-09' AND inventory_class_id= '132';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-09',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:42';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-10' AND inventory_class_id= '132';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-10',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:42';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-11' AND inventory_class_id= '132';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-11',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:42';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-12' AND inventory_class_id= '132';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-12',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:42';
[12/03/2020 01:22:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-13' AND inventory_class_id= '132';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-13',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:43';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-14' AND inventory_class_id= '132';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-14',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:43';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-15' AND inventory_class_id= '132';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-15',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:43';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-16' AND inventory_class_id= '132';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-16',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:43';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-17' AND inventory_class_id= '132';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-17',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:43';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-18' AND inventory_class_id= '132';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-18',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:43';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-19' AND inventory_class_id= '132';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-19',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:43';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-20' AND inventory_class_id= '132';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-20',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:43';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-21' AND inventory_class_id= '132';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-21',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:43';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-22' AND inventory_class_id= '132';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-22',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:43';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-23' AND inventory_class_id= '132';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-23',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:43';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-24' AND inventory_class_id= '132';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-24',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:43';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-25' AND inventory_class_id= '132';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-25',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:43';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-26' AND inventory_class_id= '132';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-26',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:43';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-27' AND inventory_class_id= '132';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-27',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:43';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-28' AND inventory_class_id= '132';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-28',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:43';
[12/03/2020 01:22:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-03-01' AND inventory_class_id= '132';
[12/03/2020 01:22:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-03-01',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:44';
[12/03/2020 01:22:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-03-02' AND inventory_class_id= '132';
[12/03/2020 01:22:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-03-02',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:44';
[12/03/2020 01:22:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '12'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-03-03' AND inventory_class_id= '132';
[12/03/2020 01:22:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-03-03',availability = '12',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_42_1607001762_53773.xml',create_date = '2020-12-03 13:22:44';
[12/03/2020 01:22:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 13:22:42',channel_manager_name= 'rategain',hotel_id= '53773',rate_id= '132',start_date= '2021-01-28';
[12/03/2020 01:22:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTM6MjI6NDI8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIxLTAxLTI4ICwgMjAyMS0wMS0yOSAsIDIwMjEtMDEtMzAgLCAyMDIxLTAxLTMxICwgMjAyMS0wMi0wMSAsIDIwMjEtMDItMDIgLCAyMDIxLTAyLTAzICwgMjAyMS0wMi0wNCAsIDIwMjEtMDItMDUgLCAyMDIxLTAyLTA2ICwgMjAyMS0wMi0wNyAsIDIwMjEtMDItMDggLCAyMDIxLTAyLTA5ICwgMjAyMS0wMi0xMCAsIDIwMjEtMDItMTEgLCAyMDIxLTAyLTEyICwgMjAyMS0wMi0xMyAsIDIwMjEtMDItMTQgLCAyMDIxLTAyLTE1ICwgMjAyMS0wMi0xNiAsIDIwMjEtMDItMTcgLCAyMDIxLTAyLTE4ICwgMjAyMS0wMi0xOSAsIDIwMjEtMDItMjAgLCAyMDIxLTAyLTIxICwgMjAyMS0wMi0yMiAsIDIwMjEtMDItMjMgLCAyMDIxLTAyLTI0ICwgMjAyMS0wMi0yNSAsIDIwMjEtMDItMjYgLCAyMDIxLTAyLTI3ICwgMjAyMS0wMi0yOCAsIDIwMjEtMDMtMDEgLCAyMDIxLTAzLTAyICwgMjAyMS0wMy0wMzxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 13:22:44';
[12/03/2020 01:22:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 13:22:42<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2021-01-28 , 2021-01-29 , 2021-01-30 , 2021-01-31 , 2021-02-01 , 2021-02-02 , 2021-02-03 , 2021-02-04 , 2021-02-05 , 2021-02-06 , 2021-02-07 , 2021-02-08 , 2021-02-09 , 2021-02-10 , 2021-02-11 , 2021-02-12 , 2021-02-13 , 2021-02-14 , 2021-02-15 , 2021-02-16 , 2021-02-17 , 2021-02-18 , 2021-02-19 , 2021-02-20 , 2021-02-21 , 2021-02-22 , 2021-02-23 , 2021-02-24 , 2021-02-25 , 2021-02-26 , 2021-02-27 , 2021-02-28 , 2021-03-01 , 2021-03-02 , 2021-03-03<br>',  email_sent ='yes', create_date ='2020-12-03 13:22:44', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 01:22:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '13'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-31' AND inventory_class_id= '132';
[12/03/2020 01:22:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2020-12-31',availability = '13',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_52_1607001772_53773.xml',create_date = '2020-12-03 13:22:52';
[12/03/2020 01:22:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '13'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-31' AND inventory_class_id= '132';
[12/03/2020 01:22:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-01-31',availability = '13',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_52_1607001772_53773.xml',create_date = '2020-12-03 13:22:52';
[12/03/2020 01:22:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '13'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-02-28' AND inventory_class_id= '132';
[12/03/2020 01:22:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-02-28',availability = '13',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_52_1607001772_53773.xml',create_date = '2020-12-03 13:22:52';
[12/03/2020 01:22:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '13'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-03-31' AND inventory_class_id= '132';
[12/03/2020 01:22:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-03-31',availability = '13',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_52_1607001772_53773.xml',create_date = '2020-12-03 13:22:53';
[12/03/2020 01:22:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '13'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-04-30' AND inventory_class_id= '132';
[12/03/2020 01:22:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-04-30',availability = '13',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_52_1607001772_53773.xml',create_date = '2020-12-03 13:22:53';
[12/03/2020 01:22:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '13'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-05-31' AND inventory_class_id= '132';
[12/03/2020 01:22:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-05-31',availability = '13',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_52_1607001772_53773.xml',create_date = '2020-12-03 13:22:53';
[12/03/2020 01:22:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '13'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-06-30' AND inventory_class_id= '132';
[12/03/2020 01:22:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-06-30',availability = '13',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_52_1607001772_53773.xml',create_date = '2020-12-03 13:22:53';
[12/03/2020 01:22:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '13'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-07-31' AND inventory_class_id= '132';
[12/03/2020 01:22:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-07-31',availability = '13',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_52_1607001772_53773.xml',create_date = '2020-12-03 13:22:53';
[12/03/2020 01:22:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '13'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-08-31' AND inventory_class_id= '132';
[12/03/2020 01:22:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-08-31',availability = '13',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_52_1607001772_53773.xml',create_date = '2020-12-03 13:22:53';
[12/03/2020 01:22:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '13'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-09-30' AND inventory_class_id= '132';
[12/03/2020 01:22:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-09-30',availability = '13',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_52_1607001772_53773.xml',create_date = '2020-12-03 13:22:53';
[12/03/2020 01:22:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '13'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-10-31' AND inventory_class_id= '132';
[12/03/2020 01:22:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-10-31',availability = '13',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_52_1607001772_53773.xml',create_date = '2020-12-03 13:22:53';
[12/03/2020 01:22:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '13'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-11-30' AND inventory_class_id= '132';
[12/03/2020 01:22:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-11-30',availability = '13',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_52_1607001772_53773.xml',create_date = '2020-12-03 13:22:53';
[12/03/2020 01:22:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '13'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-12-31' AND inventory_class_id= '132';
[12/03/2020 01:22:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-12-31',availability = '13',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_22_52_1607001772_53773.xml',create_date = '2020-12-03 13:22:53';
[12/03/2020 01:22:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 13:22:52',channel_manager_name= 'rategain',hotel_id= '53773',rate_id= '132',start_date= '2021-12-31';
[12/03/2020 01:22:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTM6MjI6NTI8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTMxICwgMjAyMS0wMS0zMSAsIDIwMjEtMDItMjggLCAyMDIxLTAzLTMxICwgMjAyMS0wNC0zMCAsIDIwMjEtMDUtMzEgLCAyMDIxLTA2LTMwICwgMjAyMS0wNy0zMSAsIDIwMjEtMDgtMzEgLCAyMDIxLTA5LTMwICwgMjAyMS0xMC0zMSAsIDIwMjEtMTEtMzAgLCAyMDIxLTEyLTMxPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 13:22:53';
[12/03/2020 01:22:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 13:22:52<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-31 , 2021-01-31 , 2021-02-28 , 2021-03-31 , 2021-04-30 , 2021-05-31 , 2021-06-30 , 2021-07-31 , 2021-08-31 , 2021-09-30 , 2021-10-31 , 2021-11-30 , 2021-12-31<br>',  email_sent ='yes', create_date ='2020-12-03 13:22:53', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 01:23:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '14'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-03' AND inventory_class_id= '132';
[12/03/2020 01:23:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2020-12-03',availability = '14',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_23_48_1607001828_53773.xml',create_date = '2020-12-03 13:23:48';
[12/03/2020 01:23:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '14'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-05' AND inventory_class_id= '132';
[12/03/2020 01:23:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2020-12-05',availability = '14',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_23_48_1607001828_53773.xml',create_date = '2020-12-03 13:23:48';
[12/03/2020 01:23:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '14'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-07' AND inventory_class_id= '132';
[12/03/2020 01:23:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2020-12-07',availability = '14',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_23_48_1607001828_53773.xml',create_date = '2020-12-03 13:23:48';
[12/03/2020 01:23:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '14'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-09' AND inventory_class_id= '132';
[12/03/2020 01:23:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2020-12-09',availability = '14',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_23_48_1607001828_53773.xml',create_date = '2020-12-03 13:23:48';
[12/03/2020 01:23:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '14'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-11' AND inventory_class_id= '132';
[12/03/2020 01:23:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2020-12-11',availability = '14',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_23_48_1607001828_53773.xml',create_date = '2020-12-03 13:23:48';
[12/03/2020 01:23:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '14'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-13' AND inventory_class_id= '132';
[12/03/2020 01:23:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2020-12-13',availability = '14',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_23_48_1607001828_53773.xml',create_date = '2020-12-03 13:23:48';
[12/03/2020 01:23:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '14'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-15' AND inventory_class_id= '132';
[12/03/2020 01:23:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2020-12-15',availability = '14',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_23_48_1607001828_53773.xml',create_date = '2020-12-03 13:23:48';
[12/03/2020 01:23:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '14'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-17' AND inventory_class_id= '132';
[12/03/2020 01:23:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2020-12-17',availability = '14',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_23_48_1607001828_53773.xml',create_date = '2020-12-03 13:23:48';
[12/03/2020 01:23:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 13:23:48',channel_manager_name= 'rategain',hotel_id= '53773',rate_id= '132',start_date= '2020-12-17';
[12/03/2020 01:23:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTM6MjM6NDg8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTAzICwgMjAyMC0xMi0wNSAsIDIwMjAtMTItMDcgLCAyMDIwLTEyLTA5ICwgMjAyMC0xMi0xMSAsIDIwMjAtMTItMTMgLCAyMDIwLTEyLTE1ICwgMjAyMC0xMi0xNzxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 13:23:48';
[12/03/2020 01:23:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 13:23:48<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-03 , 2020-12-05 , 2020-12-07 , 2020-12-09 , 2020-12-11 , 2020-12-13 , 2020-12-15 , 2020-12-17<br>',  email_sent ='yes', create_date ='2020-12-03 13:23:48', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 01:24:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],UPDATE bookings SET special_remark='We are celebrating our 20th Wedding Anniversary with the hotel' WHERE id='3075';
[12/03/2020 01:24:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-12-03 13:24:51',`log_type`= 'Booking Details Updated',`sql_query`= 'UPDATE bookings SET special_remark=\&#039;We are celebrating our 20th Wedding Anniversary with the hotel\&#039; WHERE id=\&#039;3075\&#039;',`log_description`= 'User tfg updated special_remark column from We are celebrating our 14th Wedding Anniversary with the hotel to We are celebrating our 20th Wedding Anniversary with the hotel on 03-12-2020 13:24',`ip`= '60.254.11.202';
[12/03/2020 01:25:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='3075', agent_id ='24', itenirary_id ='3075', sequence = '', confirmation_number ='', payment_confirmation_no ='', voucher_id ='', voucher_hashcode ='', email_id ='deep.mishra@rategain.com', leader_title ='Mr', leader_first_name ='Deep', leader_last_name ='Mishra', city_id ='mumbai', country_id ='106', display_room_rate ='440.000', native_room_rate ='440.000', native_currency_code ='AED', additional_charge ='0.000', cancellation_policy ='Amendment of Dates, Room Category, Passenger Names are considered as Cancel and Rebook by most of the Hotels.
        Any Changes in initial booking may be denied by the supplier or may result in extra charges.
        Confirmation of amendment requests is subject to availablity and rates at the time of amendment.<Br><Br><B><U>Detailed Cancellation Policy:</U></B> <br/> Cancellation Charges of 440 AED applicable if cancelled after 29-May-2021 05:30 hrs.', supplier_cancellation_policy ='', current_status ='confirmed', booking_status ='1', status_date ='2020-12-03 13:04:43', create_date ='2020-12-03 13:04:43', source_type ='localsystem', expiration_date ='2021-05-29 00:00:00', comment_contract ='', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='440.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='0.000', supplier_rate ='440.000', special_comment ='', special_remark ='We are celebrating our 20th Wedding Anniversary with the hotel', sms_status ='', is_xml ='0', consultant_id ='SalesConsultant', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='0', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='0', wh_agent_markup ='0.000', basecurrency_multiplier ='0.27222', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='0.27222', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='0.27222', wh_agent_currency_multiplier ='1.000', modified_datetime ='2020-12-03 13:25:12', modified_by ='tfg', display_currency_code ='AED', created_datetime ='2020-12-03 13:25:12', sub_agent_rate ='0.000', discount_to_sub ='0', created_by ='tfg', site_id ='0', applicable_service_tax ='0.000', wh_parent_agent_id ='0', wh_agent_id ='0', nationality ='Indian', ip_addr ='60.254.11.202';
[12/03/2020 01:25:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='1213', old_reff_id ='549', booking_id ='3075', supplier_id ='S000000241', total_nights ='1', arrival_date ='2021/06/03', departure_date ='2021/06/04', hotel_id ='53773', hotel_name ='RATEGAINONE', hotel_address1 ='Mumbai', hotel_phone ='123456789', hotel_rating ='5.0', rate_code ='', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='rategain', reservation_pushed ='0', gtaToken ='';
[12/03/2020 01:25:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '6421', old_reff_id = '549', booking_id = '3075', booking_detail_id = '1213', salutations = 'Mr', room = '0', rid = '1816', first_name = 'Deep', last_name = 'Mishra' ,passenger_type = 'adult' ,age = '';
[12/03/2020 01:25:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[12/03/2020 01:25:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '1816', old_reff_id = '549', booking_id = '3075', booking_detail_id = '1213', room_type_code = '1~~~132~~~1039~~~1~~~~~~~~~64440~~~0~~~S000000241', room_name = 'single', room_type_description = 'Standard  -Bed & Breakfast : 1 Pax <font color=\'red\'>-D</font>', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:"displayNightlyRate";i:440;s:16:"promotionDisplay";s:0:"";s:25:"displayNightlyRateDisplay";s:152:"Supplier Name - localsupplier(RateGainSupplier - S000000241), Rate - 440 AED, Currency Multiplier (AED-AED) - 1.00000 Supplier Commission-0 #localsystem";}}' ,native_nightly_rates = 'a:1:{i:0;a:4:{s:19:"O_nativeNightlyRate";i:440;s:17:"nativeNightlyRate";i:440;s:9:"free_sale";s:2:"no";s:14:"Discount/Offer";a:7:{s:4:"code";s:0:"";s:4:"Name";s:0:"";s:7:"S_Value";s:0:"";s:5:"Value";i:0;s:12:"Display_Name";s:0:"";s:10:"Offer_Note";N;s:10:"Offer_Type";N;}}}' ,native_room_rate_total = '440' ,display_room_rate_total = '440' ,wh_room_rate_total = '' ,number_of_rooms = '1';
[12/03/2020 01:25:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[12/03/2020 01:25:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[12/03/2020 01:25:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '3075', booking_detail_id = '1213', room_type_code = '1~~~132~~~1039~~~1~~~~~~~~~64440~~~0~~~S000000241', room_name = 'single', meal_basis = '', room_type_description = 'Standard -Bed & Breakfast : 1 Pax -D', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"440";s:13:"whNightlyRate";s:0:"";}}' ,native_nightly_rates = 'a:1:{i:0;a:3:{s:17:"nativeNightlyRate";s:3:"440";s:19:"O_nativeNightlyRate";i:440;s:14:"Discount/Offer";a:7:{s:4:"code";s:0:"";s:4:"Name";s:0:"";s:7:"S_Value";s:0:"";s:5:"Value";i:0;s:12:"Display_Name";s:0:"";s:10:"Offer_Note";N;s:10:"Offer_Type";N;}}}' ,native_room_rate_total = '440' ,display_room_rate_total = '440' ,number_of_rooms = '1';
[12/03/2020 01:25:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '3075', booking_detail_id = '1213', salutations = 'Mr', room = '', rid = '1817', first_name = 'Deep', last_name = 'Mishra' ,age = '';
[12/03/2020 01:25:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='Test123',native_currency_code='AED',display_currency_code='AED',cancellation_policy='Amendment of Dates, Room Category, Passenger Names are considered as Cancel and Rebook by most of the Hotels.
        Any Changes in initial booking may be denied by the supplier or may result in extra charges.
        Confirmation of amendment requests is subject to availablity and rates at the time of amendment.&lt;Br&gt;&lt;Br&gt;&lt;B&gt;&lt;U&gt;Detailed Cancellation Policy:&lt;/U&gt;&lt;/B&gt; &lt;br/&gt; Cancellation Charges of 440 AED applicable if cancelled after 29-May-2021 05:30 hrs.                                ',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',consultant_id='tfg',basecurrency_multiplier='0.27222',basecurrency_multiplier_native='0.27222'_native,agent_currency_multiplier='0.27222',service_type_detail='RATEGAINONE',current_status='confirmed',status_date='2020-12-03 13:25:12',service_date='2021-06-03',check_out_date='2021-06-04',display_room_rate= '440',display_discount='0.000',modified_datetime='2020-12-03 13:25:12',modified_by ='tfg',native_room_rate='440',native_discount='0.000',additional_charge='0.000',applicable_service_tax='',leader_title='Mr',leader_first_name='Deep',leader_last_name='Mishra',nationality ='Indian',accounts_processed ='0',booking_type ='online',agent_ref_no ='',supplier_profile_id ='1',expiration_date= '2021-05-29 00:00:00',source_type='localsystem',free_sale='yes',leader_phone='+543514149600',admin_note='',comment_contract='' WHERE id='3075';
[12/03/2020 01:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-12-03 13:25:13',`log_type`= 'Accounts Data Added',`sql_query`= '',`log_description`= 'Accounts Only : Data Added by \&#039;tfg\&#039; From IP \&#039;60.254.11.202\&#039; for booking \&#039;3075\&#039;',`ip`= '60.254.11.202';
[12/03/2020 01:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings set  parent_agent_id='24', sub_agent_rate='', agent_rate='440', agent_markup='0', supplier_rate='440', wh_sub_agent_rate='', discount_to_sub='', wh_agent_rate='' where id='3075';
[12/03/2020 01:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings_details set total_nights='1' , supplier_id= 'S000000241' , total_rooms= '1', arrival_date='2021/06/03', departure_date='2021/06/04', rate_code='~', hotel_address1='Mumbai', hotel_name='RATEGAINONE', hotel_phone='123456789', reservation_pushed='2' where booking_id ='3075';
[12/03/2020 01:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3075','confirmed','2020-12-03 13:25:13','Booking Modified by tfg','tfg','60.254.11.202','tfg','','');
[12/03/2020 01:25:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update booking_currency_multiplier set multiplier='1.00000' where booking_id='3075' and from_currency='AED' and to_currency='AED';
[12/03/2020 01:25:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/channel_manager_push_reservation.php],update bookings_details set reservation_pushed = '0', channel_manager = 'rategain',room_type_description='' where booking_id = '3075';
[12/03/2020 01:26:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],INSERT INTO history_bookings set history_booking_id ='3075', agent_id ='24', itenirary_id ='3075', confirmation_number ='Test123', payment_confirmation_no ='', voucher_id ='', voucher_hashcode ='', email_id ='deep.mishra@rategain.com', leader_title ='Mr', leader_first_name ='Deep', leader_last_name ='Mishra', city_id ='mumbai', country_id ='106', display_room_rate ='440.000', native_room_rate ='440.000', native_currency_code ='AED', additional_charge ='0.000', cancellation_policy ='Amendment of Dates, Room Category, Passenger Names are considered as Cancel and Rebook by most of the Hotels.
        Any Changes in initial booking may be denied by the supplier or may result in extra charges.
        Confirmation of amendment requests is subject to availablity and rates at the time of amendment.&lt;Br&gt;&lt;Br&gt;&lt;B&gt;&lt;U&gt;Detailed Cancellation Policy:&lt;/U&gt;&lt;/B&gt; &lt;br/&gt; Cancellation Charges of 440 AED applicable if cancelled after 29-May-2021 05:30 hrs.                                ', supplier_cancellation_policy ='', current_status ='confirmed', booking_status ='1', status_date ='2020-12-03 13:25:12', create_date ='2020-12-03 13:04:43', source_type ='localsystem', expiration_date ='2021-05-29 00:00:00', comment_contract ='', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='RATEGAINONE', native_rate ='', display_rate ='', agent_rate ='440.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='0.000', supplier_rate ='440.000', special_comment ='', special_remark ='We are celebrating our 20th Wedding Anniversary with the hotel', sms_status ='', is_xml ='0', consultant_id ='tfg', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='0', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='0', wh_agent_markup ='0.000', basecurrency_multiplier ='0.27222', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='0.27222', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='0.27222', wh_agent_currency_multiplier ='1.000', modified_datetime ='2020-12-03 13:26:06', modified_by ='tfg', display_currency_code ='AED', created_datetime ='2020-12-03 13:26:06', sub_agent_rate ='0.000', created_by ='tfg', site_id ='0', applicable_service_tax ='0.000', wh_parent_agent_id ='0', wh_agent_id ='0', nationality ='Indian', ip_addr ='60.254.11.202', is_cancel_history ='1';
[12/03/2020 01:26:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3075','cancelled','2020-12-03 13:26:06','Cancellation Confirmation Number: Cancellation done on 2020-12-03 13:26:06  by tfg','tfg','60.254.11.202','tfg','','');
[12/03/2020 01:26:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],UPDATE bookings SET current_status='cancelled',accounts_processed ='0',status_date='2020-12-03 13:26:06' , pending_cancellation = 'no'WHERE reservation_id = 'QTECH2020121918' AND id = '3075' AND (current_status = 'pending' OR  current_status = 'confirmed' OR  current_status = 'vouchered' OR  current_status = 'on_request' OR  current_status = 'inprocess_cancel') ;
[12/03/2020 01:26:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],INSERT INTO loyalty_detail SET booking_id= '3075',type= 'earn',log= 'Loyalty Points Reverted due to Cancellation Of Booking Id :3075';
[12/03/2020 01:26:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-12-03 13:26:06',`log_type`= 'Agent Loyalty Point Detail',`sql_query`= 'INSERT INTO loyalty_detail SET booking_id= :booking_id,type= :type,log= :log',`log_description`= 'Loyalty earn Points is &nbsp;&nbsp; of agent &nbsp;due to cancellation of booking id \&#039;3075\&#039;',`ip`= '60.254.11.202';
[12/03/2020 01:26:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],UPDATE bookings SET  agent_rate='0' , sub_agent_rate='0' , supplier_rate='0' , applicable_service_tax='0' WHERE id = '3075' AND (current_status = 'cancelled' ) ;
[12/03/2020 01:26:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],delete from cancellations where booking_id =? ;
[12/03/2020 01:26:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],INSERT INTO cancellations (native_charge,display_charge,native_currency_code,display_currency_code,reservation_id,booking_id,cancellation_date,confirmation_no,note,cancellation_reason) values ('0','0','AED','AED','QTECH2020121918','3075','2020-12-03 13:26:06','Cancellation done on 2020-12-03 13:26:06 ','Confirmed charges. ','');
[12/03/2020 01:26:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],update bookings_details set reservation_pushed = '3', channel_manager = 'rategain',room_type_description='' where booking_id = '3075';
[12/03/2020 01:26:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into email_logs SET `subject`= ' TFG103075 /  Booking Cancelled ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 20340 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/view_booking.php',create_date= '2020-12-03 13:26:07';
[12/03/2020 01:26:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into temp(booking_id,mail_send_to)values('3075','snehal.valanju@qtechsoftware.com');
[12/03/2020 01:26:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into temp(booking_id,mail_send_to)values('3075','ankita.rao@qtechsoftware.com');
[12/03/2020 01:26:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into email_logs SET `subject`= ' TFG103075 /  Booking Cancelled ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 27624 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/view_booking.php',create_date= '2020-12-03 13:26:08';
[12/03/2020 01:26:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into temp(booking_id,mail_send_to)values('3075','snehal.valanju@qtechsoftware.com');
[12/03/2020 01:26:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/view_booking.php],insert into temp(booking_id,mail_send_to)values('3075','snehal.valanju@qtechsoftware.com');
[12/03/2020 01:26:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/crons/channel_manager_push_reservation.php],update bookings_details set reservation_pushed = '0', channel_manager = 'rategain',room_type_description='' where booking_id = '3075';
[12/03/2020 01:39:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '3'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-03' AND inventory_class_id= '132';
[12/03/2020 01:39:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '1',date_from = '2020-12-03',stop_sale = '3',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_39_48_1607002788_53773.xml',create_date = '2020-12-03 13:39:48';
[12/03/2020 01:39:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 13:39:48',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2020-12-03';
[12/03/2020 01:39:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTM6Mzk6NDg8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTAzPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 13:39:48';
[12/03/2020 01:39:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 13:39:48<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-03<br>',  email_sent ='yes', create_date ='2020-12-03 13:39:48', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 01:39:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 13:39:52',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2020-12-03';
[12/03/2020 01:39:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTM6Mzk6NTI8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTAzPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 13:39:52';
[12/03/2020 01:39:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 13:39:52<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-03<br>',  email_sent ='yes', create_date ='2020-12-03 13:39:52', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 01:39:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '3'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-04' AND inventory_class_id= '132';
[12/03/2020 01:39:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '1',date_from = '2020-12-04',stop_sale = '3',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_39_56_1607002796_53773.xml',create_date = '2020-12-03 13:39:56';
[12/03/2020 01:39:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '3'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-07' AND inventory_class_id= '132';
[12/03/2020 01:39:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '1',date_from = '2020-12-07',stop_sale = '3',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_39_56_1607002796_53773.xml',create_date = '2020-12-03 13:39:56';
[12/03/2020 01:39:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  stop_sale= '3'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-09' AND inventory_class_id= '132';
[12/03/2020 01:39:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '1',date_from = '2020-12-09',stop_sale = '3',type = 'stop_sale',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/03_12_2020/request_getHotelARIUpdate_13_39_56_1607002796_53773.xml',create_date = '2020-12-03 13:39:56';
[12/03/2020 01:39:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 13:39:56',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2020-12-03';
[12/03/2020 01:39:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTM6Mzk6NTY8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTAzICwgMjAyMC0xMi0wNCAsIDIwMjAtMTItMDUgLCAyMDIwLTEyLTA2ICwgMjAyMC0xMi0wNyAsIDIwMjAtMTItMDggLCAyMDIwLTEyLTA5PGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 13:39:56';
[12/03/2020 01:39:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 13:39:56<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-03 , 2020-12-04 , 2020-12-05 , 2020-12-06 , 2020-12-07 , 2020-12-08 , 2020-12-09<br>',  email_sent ='yes', create_date ='2020-12-03 13:39:56', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 01:40:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 13:40:03',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2021-01-28';
[12/03/2020 01:40:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTM6NDA6MDM8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIxLTAxLTI4ICwgMjAyMS0wMS0yOSAsIDIwMjEtMDEtMzAgLCAyMDIxLTAxLTMxICwgMjAyMS0wMi0wMSAsIDIwMjEtMDItMDIgLCAyMDIxLTAyLTAzICwgMjAyMS0wMi0wNCAsIDIwMjEtMDItMDUgLCAyMDIxLTAyLTA2ICwgMjAyMS0wMi0wNyAsIDIwMjEtMDItMDggLCAyMDIxLTAyLTA5ICwgMjAyMS0wMi0xMCAsIDIwMjEtMDItMTEgLCAyMDIxLTAyLTEyICwgMjAyMS0wMi0xMyAsIDIwMjEtMDItMTQgLCAyMDIxLTAyLTE1ICwgMjAyMS0wMi0xNiAsIDIwMjEtMDItMTcgLCAyMDIxLTAyLTE4ICwgMjAyMS0wMi0xOSAsIDIwMjEtMDItMjAgLCAyMDIxLTAyLTIxICwgMjAyMS0wMi0yMiAsIDIwMjEtMDItMjMgLCAyMDIxLTAyLTI0ICwgMjAyMS0wMi0yNSAsIDIwMjEtMDItMjYgLCAyMDIxLTAyLTI3ICwgMjAyMS0wMi0yOCAsIDIwMjEtMDMtMDEgLCAyMDIxLTAzLTAyICwgMjAyMS0wMy0wMzxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 13:40:03';
[12/03/2020 01:40:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 13:40:03<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2021-01-28 , 2021-01-29 , 2021-01-30 , 2021-01-31 , 2021-02-01 , 2021-02-02 , 2021-02-03 , 2021-02-04 , 2021-02-05 , 2021-02-06 , 2021-02-07 , 2021-02-08 , 2021-02-09 , 2021-02-10 , 2021-02-11 , 2021-02-12 , 2021-02-13 , 2021-02-14 , 2021-02-15 , 2021-02-16 , 2021-02-17 , 2021-02-18 , 2021-02-19 , 2021-02-20 , 2021-02-21 , 2021-02-22 , 2021-02-23 , 2021-02-24 , 2021-02-25 , 2021-02-26 , 2021-02-27 , 2021-02-28 , 2021-03-01 , 2021-03-02 , 2021-03-03<br>',  email_sent ='yes', create_date ='2020-12-03 13:40:03', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 01:40:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 13:40:12',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2021-12-31';
[12/03/2020 01:40:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTM6NDA6MTI8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTMxICwgMjAyMS0wMS0zMSAsIDIwMjEtMDItMjggLCAyMDIxLTAzLTMxICwgMjAyMS0wNC0zMCAsIDIwMjEtMDUtMzEgLCAyMDIxLTA2LTMwICwgMjAyMS0wNy0zMSAsIDIwMjEtMDgtMzEgLCAyMDIxLTA5LTMwICwgMjAyMS0xMC0zMSAsIDIwMjEtMTEtMzAgLCAyMDIxLTEyLTMxPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 13:40:13';
[12/03/2020 01:40:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 13:40:12<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-31 , 2021-01-31 , 2021-02-28 , 2021-03-31 , 2021-04-30 , 2021-05-31 , 2021-06-30 , 2021-07-31 , 2021-08-31 , 2021-09-30 , 2021-10-31 , 2021-11-30 , 2021-12-31<br>',  email_sent ='yes', create_date ='2020-12-03 13:40:13', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 01:41:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 13:41:08',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2020-12-17';
[12/03/2020 01:41:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTM6NDE6MDg8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTAzICwgMjAyMC0xMi0wNSAsIDIwMjAtMTItMDcgLCAyMDIwLTEyLTA5ICwgMjAyMC0xMi0xMSAsIDIwMjAtMTItMTMgLCAyMDIwLTEyLTE1ICwgMjAyMC0xMi0xNzxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 13:41:08';
[12/03/2020 01:41:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 13:41:08<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-03 , 2020-12-05 , 2020-12-07 , 2020-12-09 , 2020-12-11 , 2020-12-13 , 2020-12-15 , 2020-12-17<br>',  email_sent ='yes', create_date ='2020-12-03 13:41:08', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 01:45:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 13:45:05',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2020-12-03';
[12/03/2020 01:45:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTM6NDU6MDU8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTAzPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 13:45:05';
[12/03/2020 01:45:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 13:45:05<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-03<br>',  email_sent ='yes', create_date ='2020-12-03 13:45:05', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 01:52:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 13:52:38',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2020-12-03';
[12/03/2020 01:52:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTM6NTI6Mzg8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTAzPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 13:52:38';
[12/03/2020 01:52:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 13:52:38<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-03<br>',  email_sent ='yes', create_date ='2020-12-03 13:52:38', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 01:56:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],update room_rates set stop_sale='0' where supplier_id='S000000241' and hotel_id=53773  and inventory_class_id in ('132') and date_from >='2020-12-03' AND date_from <='2021-01-31' ;
[12/03/2020 01:56:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-12-03 13:56:19',`log_type`= 'Sell Policy',`sql_query`= 'update room_rates set stop_sale=\&#039;0\&#039; where supplier_id=\&#039;S000000241\&#039; and hotel_id=53773  and inventory_class_id in (\&#039;132\&#039;) and date_from &gt;=\&#039;2020-12-03\&#039; AND date_from &lt;=\&#039;2021-01-31\&#039; &lt;br&gt;',`log_description`= 'Updated Sell Policy For hotel RateGainOne- Inventory Room Class:-Standard From:-03-12-2020 To:-31-01-2021 Weekday Policy:-Withdraw Stop/Free Sell Weekend Policy:-Withdraw Stop/Free Sell',`ip`= '60.254.11.202',`username`= 'tfg',`user_id`= 'S000000241';
[12/03/2020 01:56:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4056', `entity`='Hotels', `value`='53773' ;
[12/03/2020 01:56:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4056', `entity`='Suppliers', `value`='S000000241' ;
[12/03/2020 01:56:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4056', `entity`='Inventory', `value`='' ;
[12/03/2020 01:56:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4056', `entity`='Roomclass', `value`='' ;
[12/03/2020 01:56:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 13:56:39',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2020-12-03';
[12/03/2020 01:56:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTM6NTY6Mzk8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTAzPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 13:56:39';
[12/03/2020 01:56:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 13:56:39<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-03<br>',  email_sent ='yes', create_date ='2020-12-03 13:56:39', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 01:57:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],update room_rates set stop_sale='0' where supplier_id='S000000241' and hotel_id=53773  and inventory_class_id in ('132') and date_from >='2020-12-03' AND date_from <='2021-01-31' ;
[12/03/2020 01:57:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-12-03 13:57:38',`log_type`= 'Sell Policy',`sql_query`= 'update room_rates set stop_sale=\&#039;0\&#039; where supplier_id=\&#039;S000000241\&#039; and hotel_id=53773  and inventory_class_id in (\&#039;132\&#039;) and date_from &gt;=\&#039;2020-12-03\&#039; AND date_from &lt;=\&#039;2021-01-31\&#039; &lt;br&gt;',`log_description`= 'Updated Sell Policy For hotel RateGainOne- Inventory Room Class:-Standard From:-03-12-2020 To:-31-01-2021 Weekday Policy:-Withdraw Stop/Free Sell Weekend Policy:-Withdraw Stop/Free Sell',`ip`= '60.254.11.202',`username`= 'tfg',`user_id`= 'S000000241';
[12/03/2020 01:57:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4057', `entity`='Hotels', `value`='53773' ;
[12/03/2020 01:57:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4057', `entity`='Suppliers', `value`='S000000241' ;
[12/03/2020 01:57:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4057', `entity`='Inventory', `value`='' ;
[12/03/2020 01:57:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4057', `entity`='Roomclass', `value`='' ;
[12/03/2020 01:57:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 13:57:47',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2020-12-03';
[12/03/2020 01:57:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTM6NTc6NDc8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTAzPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 13:57:47';
[12/03/2020 01:57:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 13:57:47<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-03<br>',  email_sent ='yes', create_date ='2020-12-03 13:57:47', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 01:58:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],update room_rates set stop_sale='0' where supplier_id='S000000241' and hotel_id=53773  and inventory_class_id in ('132') and date_from >='2021-01-28' AND date_from <='2021-03-03' ;
[12/03/2020 01:58:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-12-03 13:58:40',`log_type`= 'Sell Policy',`sql_query`= 'update room_rates set stop_sale=\&#039;0\&#039; where supplier_id=\&#039;S000000241\&#039; and hotel_id=53773  and inventory_class_id in (\&#039;132\&#039;) and date_from &gt;=\&#039;2021-01-28\&#039; AND date_from &lt;=\&#039;2021-03-03\&#039; &lt;br&gt;',`log_description`= 'Updated Sell Policy For hotel RateGainOne- Inventory Room Class:-Standard From:-28-01-2021 To:-03-03-2021 Weekday Policy:-Withdraw Stop/Free Sell Weekend Policy:-Withdraw Stop/Free Sell',`ip`= '60.254.11.202',`username`= 'tfg',`user_id`= 'S000000241';
[12/03/2020 01:58:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4058', `entity`='Hotels', `value`='53773' ;
[12/03/2020 01:58:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4058', `entity`='Suppliers', `value`='S000000241' ;
[12/03/2020 01:58:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4058', `entity`='Inventory', `value`='' ;
[12/03/2020 01:58:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4058', `entity`='Roomclass', `value`='' ;
[12/03/2020 01:58:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 13:58:49',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2021-01-28';
[12/03/2020 01:58:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTM6NTg6NDk8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIxLTAxLTI4ICwgMjAyMS0wMS0yOSAsIDIwMjEtMDEtMzAgLCAyMDIxLTAxLTMxICwgMjAyMS0wMi0wMSAsIDIwMjEtMDItMDIgLCAyMDIxLTAyLTAzICwgMjAyMS0wMi0wNCAsIDIwMjEtMDItMDUgLCAyMDIxLTAyLTA2ICwgMjAyMS0wMi0wNyAsIDIwMjEtMDItMDggLCAyMDIxLTAyLTA5ICwgMjAyMS0wMi0xMCAsIDIwMjEtMDItMTEgLCAyMDIxLTAyLTEyICwgMjAyMS0wMi0xMyAsIDIwMjEtMDItMTQgLCAyMDIxLTAyLTE1ICwgMjAyMS0wMi0xNiAsIDIwMjEtMDItMTcgLCAyMDIxLTAyLTE4ICwgMjAyMS0wMi0xOSAsIDIwMjEtMDItMjAgLCAyMDIxLTAyLTIxICwgMjAyMS0wMi0yMiAsIDIwMjEtMDItMjMgLCAyMDIxLTAyLTI0ICwgMjAyMS0wMi0yNSAsIDIwMjEtMDItMjYgLCAyMDIxLTAyLTI3ICwgMjAyMS0wMi0yOCAsIDIwMjEtMDMtMDEgLCAyMDIxLTAzLTAyICwgMjAyMS0wMy0wMzxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 13:58:49';
[12/03/2020 01:58:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 13:58:49<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2021-01-28 , 2021-01-29 , 2021-01-30 , 2021-01-31 , 2021-02-01 , 2021-02-02 , 2021-02-03 , 2021-02-04 , 2021-02-05 , 2021-02-06 , 2021-02-07 , 2021-02-08 , 2021-02-09 , 2021-02-10 , 2021-02-11 , 2021-02-12 , 2021-02-13 , 2021-02-14 , 2021-02-15 , 2021-02-16 , 2021-02-17 , 2021-02-18 , 2021-02-19 , 2021-02-20 , 2021-02-21 , 2021-02-22 , 2021-02-23 , 2021-02-24 , 2021-02-25 , 2021-02-26 , 2021-02-27 , 2021-02-28 , 2021-03-01 , 2021-03-02 , 2021-03-03<br>',  email_sent ='yes', create_date ='2020-12-03 13:58:49', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/03/2020 01:59:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-03 13:59:01',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',rate_id= '132',start_date= '2021-12-31';
[12/03/2020 01:59:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDMgMTM6NTk6MDE8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTMxICwgMjAyMS0wMS0zMSAsIDIwMjEtMDItMjggLCAyMDIxLTAzLTMxICwgMjAyMS0wNC0zMCAsIDIwMjEtMDUtMzEgLCAyMDIxLTA2LTMwICwgMjAyMS0wNy0zMSAsIDIwMjEtMDgtMzEgLCAyMDIxLTA5LTMwICwgMjAyMS0xMC0zMSAsIDIwMjEtMTEtMzAgLCAyMDIxLTEyLTMxPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-03 13:59:02';
[12/03/2020 01:59:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-12-03 13:59:01<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-31 , 2021-01-31 , 2021-02-28 , 2021-03-31 , 2021-04-30 , 2021-05-31 , 2021-06-30 , 2021-07-31 , 2021-08-31 , 2021-09-30 , 2021-10-31 , 2021-11-30 , 2021-12-31<br>',  email_sent ='yes', create_date ='2020-12-03 13:59:02', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
