[12/02/2020 01:15:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '20'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-02' AND inventory_class_id= '132123';
[12/02/2020 01:15:29], [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 = '132123',room_basis = '',date_from = '2020-12-02',availability = '20',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_13_15_29_1606914929_53773.xml',create_date = '2020-12-02 13:15:29';
[12/02/2020 01:15:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-02 13:15:29',channel_manager_name= 'rategain',hotel_id= '53773',rate_id= '132123',start_date= '2020-12-02';
[12/02/2020 01:15:30], [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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDIgMTM6MTU6Mjk8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTAyPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-02 13:15:30';
[12/02/2020 01:15:30], [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-02 13:15:29<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-02<br>',  email_sent ='yes', create_date ='2020-12-02 13:15:30', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/02/2020 01:18: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-02 13:18:49',channel_manager_name= 'rategain',hotel_id= '53773',rate_id= '132',start_date= '2020-12-02';
[12/02/2020 01:18: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+IDxiPlN1cHBsaWVyPC9iPiA6IDxicj4gPGI+RGF0ZSA8L2I+IDogMjAyMC0xMi0wMiAxMzoxODo0OTxicj4gPGI+SG90ZWwgPC9iPiA6IFJhdGVHYWluT25lPGJyPiA8Yj5Ib3RlbCBDb2RlPC9iPiA6IDUzNzczPGJyPiA8Yj5TdXBwbGllciBJRCA8L2I+IDogPGJyPiA8Yj5EYXRlcyA8L2I+IDogMjAyMC0xMi0wMjxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-02 13:18:49';
[12/02/2020 01:18: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> : <br> <b>Date </b> : 2020-12-02 13:18:49<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : <br> <b>Dates </b> : 2020-12-02<br>',  email_sent ='yes', create_date ='2020-12-02 13:18:49', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/02/2020 01:19:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-02 13:19:13',channel_manager_name= 'rategain',hotel_id= '53773',rate_id= '132',start_date= '2020-12-02';
[12/02/2020 01:19:14], [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+IDxiPlN1cHBsaWVyPC9iPiA6IDxicj4gPGI+RGF0ZSA8L2I+IDogMjAyMC0xMi0wMiAxMzoxOToxMzxicj4gPGI+SG90ZWwgPC9iPiA6IFJhdGVHYWluT25lPGJyPiA8Yj5Ib3RlbCBDb2RlPC9iPiA6IDUzNzczPGJyPiA8Yj5TdXBwbGllciBJRCA8L2I+IDogPGJyPiA8Yj5EYXRlcyA8L2I+IDogMjAyMC0xMi0wMjxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-02 13:19:14';
[12/02/2020 01:19:14], [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> : <br> <b>Date </b> : 2020-12-02 13:19:13<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : <br> <b>Dates </b> : 2020-12-02<br>',  email_sent ='yes', create_date ='2020-12-02 13:19:14', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/02/2020 01:19:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-02 13:19:55',channel_manager_name= 'rategain',hotel_id= '53773',rate_id= '132',start_date= '2020-12-02';
[12/02/2020 01:19: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+IDxiPlN1cHBsaWVyPC9iPiA6IDxicj4gPGI+RGF0ZSA8L2I+IDogMjAyMC0xMi0wMiAxMzoxOTo1NTxicj4gPGI+SG90ZWwgPC9iPiA6IFJhdGVHYWluT25lPGJyPiA8Yj5Ib3RlbCBDb2RlPC9iPiA6IDUzNzczPGJyPiA8Yj5TdXBwbGllciBJRCA8L2I+IDogPGJyPiA8Yj5EYXRlcyA8L2I+IDogMjAyMC0xMi0wMjxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-02 13:19:56';
[12/02/2020 01:19: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> : <br> <b>Date </b> : 2020-12-02 13:19:55<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : <br> <b>Dates </b> : 2020-12-02<br>',  email_sent ='yes', create_date ='2020-12-02 13:19:56', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/02/2020 01:20:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-02 13:20:10',channel_manager_name= 'rategain',hotel_id= '53773',rate_id= '132',start_date= '2020-12-02';
[12/02/2020 01:20:10], [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+IDxiPlN1cHBsaWVyPC9iPiA6IDxicj4gPGI+RGF0ZSA8L2I+IDogMjAyMC0xMi0wMiAxMzoyMDoxMDxicj4gPGI+SG90ZWwgPC9iPiA6IFJhdGVHYWluT25lPGJyPiA8Yj5Ib3RlbCBDb2RlPC9iPiA6IDUzNzczPGJyPiA8Yj5TdXBwbGllciBJRCA8L2I+IDogPGJyPiA8Yj5EYXRlcyA8L2I+IDogMjAyMC0xMi0wMjxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php?ez_queries=1',create_date= '2020-12-02 13:20:10';
[12/02/2020 01:20:10], [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> : <br> <b>Date </b> : 2020-12-02 13:20:10<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : <br> <b>Dates </b> : 2020-12-02<br>',  email_sent ='yes', create_date ='2020-12-02 13:20:10', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/02/2020 01:26:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-12-02 01:26:30',login_attempt=0 where id = '24';
[12/02/2020 01:26:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'snehal', user_type = 'A', branch_id = '1', login_datetime = '2020-12-02 13:26:30', ip = '60.254.11.202', action = 'Login' ;
[12/02/2020 01:26:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '24' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '60.254.11.202' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2021/06/02' , departure_date = '2021/06/03' , nationality = '106' , nights = '1' , room_types = '1' , create_date = '2020-12-02 13:26:54' , site_id = '' , country_code = '106' , web_service = '' ;
[12/02/2020 01:26:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-12-02 01:26:57', '', '85e228eab0fe039c886cdf84de2f87706e0491627648c9a9ca54f3017ab9efb7', '487');
[12/02/2020 01:26:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=85e228eab0fe039c886cdf84de2f87706e0491627648c9a9ca54f3017ab9efb7&xml_user_id=24&request_no=1&local_hotel_code=53769&#039;,&#039;53771&#039;,&#039;53773&#039;,&#039;53775&#039;,&#039;53776&#039;,&#039;53742&web_service=no&site_id='
, http_hit_time = '2020-12-02 13:26:56.964'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '0.862'
, error_description = ''
, memory_used = '7908600'
WHERE id = '3311';
[12/02/2020 01:26:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-12-02 01:26:58', '', '85e228eab0fe039c886cdf84de2f87706e0491627648c9a9ca54f3017ab9efb7', '487');
[12/02/2020 01:26:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=85e228eab0fe039c886cdf84de2f87706e0491627648c9a9ca54f3017ab9efb7&xml_user_id=24&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&#039;,&#039;53766&#039;,&#039;53767&#039;,&#039;53768&web_service=no&site_id='
, http_hit_time = '2020-12-02 13:26:56.966'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.767'
, error_description = ''
, memory_used = '7910040'
WHERE id = '3312';
[12/02/2020 01:26:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=24&sessionid=85e228eab0fe039c886cdf84de2f87706e0491627648c9a9ca54f3017ab9efb7',
  duration = '2.400',
  merge_duration = '0.101',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.76',
  system_load_5_min = '0.94',
  system_load_15_min = '1.16',
  system_memory_usage = '88.21',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '487') + '8042584',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '487';
[12/02/2020 01:27:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1606915630','60.254.11.202');
[12/02/2020 01:27:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1606915646','60.254.11.202');
[12/02/2020 01:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO bookings SET  source_type = 'localsystem', reservation_id = '1888', create_date = '2020-12-02 13:27:30', 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 = '11.98', display_currency_code = 'USD', native_room_rate = '40', native_currency_code = 'AED', supplier_profile_id = '1', service_type = 'hotel', service_date = '2021/06/02', check_out_date = '2021/06/03', sub_user_id = '', booking_status = '1', leader_title = 'Mrs', leader_first_name = 'Snehal', leader_last_name = 'CaseOne', booking_branch_id = '1', expiration_date = '2020-12-02 01:28: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 11.98 USD applicable if cancelled after 02 Dec 2020 06:57 hrs.', supplier_cancellation_policy = '', status_date = '2020-12-02 13:27:30',  site_url = 'https://alpha.otrams.thefabulousgetaway.com/';
[12/02/2020 01:27:30], [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 ('3064','RATEGAINONE','RATEGAINONE','53773','53773','mumbai','LOCAL_SUPPLIER',NOW());
[12/02/2020 01:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='3064'
        ;
[12/02/2020 01:27:30], [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('3064','S000000241','1','1','0','-','','','53773','53773','RATEGAINONE','Mumbai','123456789','5.0','1','2021/06/02','2021/06/03','','https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/images/imagenotavailable.jpg');
[12/02/2020 01:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into booking_room_detail set  booking_id = '3064', booking_detail_id = '1202', 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\";d:11.98;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:187:\"Supplier Name - localsupplier(RateGainSupplier - S000000241), Rate - 40 AED, Currency Multiplier (AED-USD) - 0.27222 Supplier Commission-0 #localsystem Agent Hotel Category Markup=10.00 %\";}}', native_nightly_rates = 'a:1:{i:0;a:4:{s:19:\"O_nativeNightlyRate\";i:40;s:17:\"nativeNightlyRate\";i:40;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 = '40', display_room_rate_total = '11.98', number_of_rooms = '1';
[12/02/2020 01:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into passangers set  booking_id = '3064', booking_detail_id = '1202', rid = '1800', room = '0', salutations = 'Mrs', first_name = 'Snehal', last_name = 'CaseOne', passenger_type = 'adult', age = '';
[12/02/2020 01:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '', confirmation_number = '', display_discount = '0', current_status = 'confirmed', comment_contract = '', consultant_id = 'SalesConsultant', sales_manager_id = '', admin_booked = '1', email_id = '', leader_phone = '', agent_currency_multiplier = '1.00000', ip_addr = '60.254.11.202', backoffice_user = 'tfg', customer_id = '', applied_multiplier='0.27222', free_sale='',  applied_markup='10',  agent_markup='10',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='0.27222',  parent_agent_id='24',  sub_agent_rate='0', agent_rate='11.98',  applicable_service_tax='0',  supplier_rate='40',  original_source='',  uid='df14399feb317151af662b69a2aaecc5'  where id='3064';
[12/02/2020 01:27:30], [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 ='3064';
[12/02/2020 01:27:30], [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 = '3064';
[12/02/2020 01:27:30], [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('3064','2020-12-02 13:27:00','2020-12-02 13:27:00','40','11.98','0','2020-12-02 13:27:30');
[12/02/2020 01:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('3064','','');
[12/02/2020 01:27:30], [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 ('3064','confirmed','2020-12-02 13:27:30','Booking confirmed . Booked by Back Office tfg on behalf of Agent - Snehal  Valanju(CD0024)','24','60.254.11.202','0','24');
[12/02/2020 01:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_search_log(booking_id, details)
        VALUES(3064, 'a:30:{s:3:\"_id\";a:1:{s:4:\"$oid\";s:24:\"5fc79621008af21a1a358c53\";}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:\"USD\";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:40;s:17:\"nativeNightlyRate\";i:40;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\";d:11.98;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:187:\"Supplier Name - localsupplier(RateGainSupplier - S000000241), Rate - 40 AED, Currency Multiplier (AED-USD) - 0.27222 Supplier Commission-0 #localsystem Agent Hotel Category Markup=10.00 %\";}}}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:\"47727d9c0c5074375f8e855c57fa89b6\";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:\"USD\";s:18:\"nativeCurrencyCode\";s:3:\"AED\";s:20:\"displayRoomTypeRates\";d:11.98;s:20:\"sortingRoomTypeRates\";d:11.98;s:19:\"nativeRoomTypeRates\";i:40;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_8828663\";}}s:9:\"available\";i:1;s:15:\"displayRoomRate\";d:11.98;s:14:\"nativeRoomRate\";i:40;s:9:\"unique_id\";s:37:\"1_53773----------S000000241_0_0_51783\";s:10:\"supplierId\";s:10:\"S000000241\";s:19:\"displayCurrencyCode\";s:3:\"USD\";s:18:\"nativeCurrencyCode\";s:3:\"AED\";s:18:\"applied_markup_per\";i:10;s:18:\"applied_multiplier\";d:0.27222;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\";d:11.98;s:17:\"propertyAvailable\";i:1;s:8:\"no_class\";i:0;s:18:\"sort_total_charges\";d:11.98;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/02/2020 01:27:30], [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('3064','2020-12-02 13:27:00','2020-12-02 13:27:00','1970-01-01 00:00:00','1970-01-01 00:00:00','40','11.98','0','2020-12-02 13:27:30','');
[12/02/2020 01:27:30], [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 = '3064';
[12/02/2020 01:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO bookings_applicable_offer set  oid= '',  offer_type_code= '',  booking_id= '3064',  room_id= '1~~~132~~~1039~~~1~~~~~~~~~64440~~~0~~~S000000241',  room_name= 'single',  supplier_id= 'S000000241',  agent_id= '',  applied_native_discount= '0',  original_native_rate= '40',  native_rate= '40',  promotion_text= '',  offer_disc_type= '',  offer_disc_value= '',  offer_disc_currency= '',  create_date= '2020-12-02 13:27:30' ;
[12/02/2020 01:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set confirmation_number='',itenirary_id='3064' where  id ='3064';
[12/02/2020 01:27:30], [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-02';
[12/02/2020 01:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update supplement_rate set inventory = '0' where supplement_rate_id = '1';
[12/02/2020 01:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into booking_configuration set  booking_id = '3064', config_key = 'BOOKING OTP', config_value = 'iqyIJjaP';;
[12/02/2020 01:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= ' TFG103064 /  Booking Confirmed ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 40068 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking.php',create_date= '2020-12-02 13:27:30';
[12/02/2020 01:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3064','snehal.valanju@qtechsoftware.com');
[12/02/2020 01:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3064','snehal.valanju@qtechsoftware.com');
[12/02/2020 01:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update posted_bookings set booking_id='3064',status='1' where reservation_id='1888' and booking_id ='0';
[12/02/2020 01:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update xmllogs set reservation_id='3064' where agent_logs_id='487' and source_type='localsystem';
[12/02/2020 01:27:30], [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 ='3064',  create_date ='2020-12-02 13:27:30', supplier_tax='';
[12/02/2020 01:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set voucher_id='Test123',status_date='2020-12-02 13:27:30',current_status='vouchered',voucher_hashcode='5107ec536bd16f6b0ae3713f5fa3aecf829313064',vouchered_by ='' where id='3064';
[12/02/2020 01:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],Insert into booking_configuration set booking_id='3064',config_key='VOUCHER_DATE', config_value='2020-12-02 13:27:30',create_date='2020-12-02 13:27:30';
[12/02/2020 01:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO autogenerator_invoice_number (id, number) VALUES ('','1606915650');
[12/02/2020 01:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set is_invoiced='yes',invoice_number= '2020/391' where id='3064' and is_invoiced!='yes';
[12/02/2020 01:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],UPDATE agents SET credit_usage=credit_usage+('11.98'),   credit_value= credit_value-('11.98') ,  cd_credit_usage=cd_credit_usage+('11.98') , cd_credit_value=cd_credit_value-('11.98')  WHERE id = '24';
[12/02/2020 01:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into  agent_credit_log SET agent_id= '24',credit_value= '9988.020',credit_usage= '11.980',credit_limit= '10000',receipt_id= '',amount= '11.98',booking_id='3064',booking_cost= '11.98',receipt_allocation= '',balance= '11.98',ip='60.254.11.202',user_type='User',admin_id='Agent - Snehal  Valanju(CD0024)',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-12-02 13:12:30';
[12/02/2020 01:27:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into booking_rate_info set agent_price='0',sub_agent_price='0',supplier_currency='AED',supplier_price='40',supplier_type='offline',supplier_id='S000000241',acc_type='purchase',accounting_multiplier='0.27222',booking_id='3064',booking_log='Booking Vouchered',type='Sale',create_date='2020-12-02 13:27:30',account_invoice='2020/391',particulars='';
[12/02/2020 01:27:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into booking_rate_info set agent_price='11.98',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='1.00000',booking_id='3064',booking_log='Booking Vouchered',type='Sale',create_date='2020-12-02 13:27:30',account_invoice='2020/391',particulars='';
[12/02/2020 01:27:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1504;
[12/02/2020 01:27:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO accounts_invoice_transaction SET bid= '1504',booking_id= '3064',invoice_number= '2020/391',service_type= 'hotel',booking_type= 'online',service_name= 'RATEGAINONE',type= 'sale',room_type= 'single',quantity_room= '1',from_date= '2021/06/02',to_date= '2021/06/03',quantity= '1',price= '11.98',total_price= '11.98';
[12/02/2020 01:27:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= 'The Fabulous Getaway Tax Dispute(TaxInvoice)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'Rm9yIEZvbGxvd2luZyBib29raW5nIFRheCBpcyBub3QgaW5zZXJ0ZWQ8YnI+Qm9va2luZ0lkOi0zMDY0PGJyPkludm9pY2Ugbm86LTIwMjAvMzkxPGJyPmJyYW5jaF9pZDotMTxicj5UeXBlOi1hZ2VudDxicj5BY2NvdW50IHR5cGU6LXNhbGU8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking.php',create_date= '2020-12-02 13:27:31';
[12/02/2020 01:27:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into email_trigger set  subject ='The Fabulous Getaway Tax Dispute',  message='For Following booking Tax is not inserted<br>BookingId:-3064<br>Invoice no:-2020/391<br>branch_id:-1<br>Type:-agent<br>Account type:-sale<br>',  email_sent ='yes', create_date ='2020-12-02 13:27:31', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='TaxInvoice';
[12/02/2020 01:27:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_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
        ('','','3064','vouchered-invoiced','2020-12-02 13:27:31','Booking invoiced by Back Office tfg on behalf of Agent - Snehal  Valanju(CD0024)','24','60.254.11.202','','','');
[12/02/2020 01:27:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO agent_commission SET booking_id ='3064',booking_detail_id ='3064',agent_id ='24',is_sub_agent ='N',parent_id ='',display_commission ='1.08888',display_currency ='USD',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 10 %',create_date ='2020-12-02 13:27:31';
[12/02/2020 01:27:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into accounting_status set booking_id ='3064',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[12/02/2020 01:27:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_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
        ('','','3064','vouchered','2020-12-02 13:27:31','Voucherd by Back Office tfg on behalf of Agent - Snehal  Valanju(CD0024)','24','60.254.11.202','','','');
[12/02/2020 01:27:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= ' TFG103064 /  Booking Vouchered ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 27840 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,SalesConsultant@gmail.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking.php',create_date= '2020-12-02 13:27:32';
[12/02/2020 01:27:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3064','snehal.valanju@qtechsoftware.com');
[12/02/2020 01:27:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3064','SalesConsultant@gmail.com');
[12/02/2020 01:27:51], [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 = '3064';
[12/02/2020 01:29: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-02 13:29:43',channel_manager_name= 'rategain',hotel_id= '53773',rate_id= '132',start_date= '2020-12-02';
[12/02/2020 01:29: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+IDxiPlN1cHBsaWVyPC9iPiA6IDxicj4gPGI+RGF0ZSA8L2I+IDogMjAyMC0xMi0wMiAxMzoyOTo0Mzxicj4gPGI+SG90ZWwgPC9iPiA6IFJhdGVHYWluT25lPGJyPiA8Yj5Ib3RlbCBDb2RlPC9iPiA6IDUzNzczPGJyPiA8Yj5TdXBwbGllciBJRCA8L2I+IDogPGJyPiA8Yj5EYXRlcyA8L2I+IDogMjAyMC0xMi0wMjxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-02 13:29:44';
[12/02/2020 01:29: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> : <br> <b>Date </b> : 2020-12-02 13:29:43<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : <br> <b>Dates </b> : 2020-12-02<br>',  email_sent ='yes', create_date ='2020-12-02 13:29:44', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/02/2020 01:35: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-02 13:35:02',channel_manager_name= 'rategain',hotel_id= '53773',rate_id= '132',start_date= '2020-12-02';
[12/02/2020 01:35: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+IDxiPlN1cHBsaWVyPC9iPiA6IDxicj4gPGI+RGF0ZSA8L2I+IDogMjAyMC0xMi0wMiAxMzozNTowMjxicj4gPGI+SG90ZWwgPC9iPiA6IFJhdGVHYWluT25lPGJyPiA8Yj5Ib3RlbCBDb2RlPC9iPiA6IDUzNzczPGJyPiA8Yj5TdXBwbGllciBJRCA8L2I+IDogPGJyPiA8Yj5EYXRlcyA8L2I+IDogMjAyMC0xMi0wMjxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-02 13:35:03';
[12/02/2020 01:35: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> : <br> <b>Date </b> : 2020-12-02 13:35:02<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : <br> <b>Dates </b> : 2020-12-02<br>',  email_sent ='yes', create_date ='2020-12-02 13:35:03', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/02/2020 01:35:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '20'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-12-02' AND inventory_class_id= '132123';
[12/02/2020 01:35:07], [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 = '132123',room_basis = '',date_from = '2020-12-02',availability = '20',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/02_12_2020/request_getHotelARIUpdate_13_35_07_1606916107_53773.xml',create_date = '2020-12-02 13:35:07';
[12/02/2020 01:35:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-12-02 13:35:07',channel_manager_name= 'rategain',hotel_id= '53773',rate_id= '132123',start_date= '2020-12-02';
[12/02/2020 01:35: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+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTItMDIgMTM6MzU6MDc8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEyLTAyPGJyPg==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-12-02 13:35:08';
[12/02/2020 01:35: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-02 13:35:07<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-12-02<br>',  email_sent ='yes', create_date ='2020-12-02 13:35:08', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[12/02/2020 01:42:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '24' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '60.254.11.202' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2021/06/02' , departure_date = '2021/06/03' , nationality = '106' , nights = '1' , room_types = '1' , create_date = '2020-12-02 13:42:13' , site_id = '' , country_code = '106' , web_service = '' ;
[12/02/2020 01:42:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-12-02 01:42:16', '', '85e228eab0fe039c886cdf84de2f87706e0491627648c9a9ca54f3017ab9efb7', '488');
[12/02/2020 01:42:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-12-02 01:42:16', '', '85e228eab0fe039c886cdf84de2f87706e0491627648c9a9ca54f3017ab9efb7', '488');
[12/02/2020 01:42:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=85e228eab0fe039c886cdf84de2f87706e0491627648c9a9ca54f3017ab9efb7&xml_user_id=24&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&#039;,&#039;53766&#039;,&#039;53767&#039;,&#039;53768&web_service=no&site_id='
, http_hit_time = '2020-12-02 13:42:15.867'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '0.979'
, error_description = ''
, memory_used = '7910040'
WHERE id = '3313';
[12/02/2020 01:42:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=85e228eab0fe039c886cdf84de2f87706e0491627648c9a9ca54f3017ab9efb7&xml_user_id=24&request_no=1&local_hotel_code=53769&#039;,&#039;53771&#039;,&#039;53773&#039;,&#039;53775&#039;,&#039;53776&#039;,&#039;53742&web_service=no&site_id='
, http_hit_time = '2020-12-02 13:42:15.884'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '0.998'
, error_description = ''
, memory_used = '7908600'
WHERE id = '3314';
[12/02/2020 01:42:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=24&sessionid=85e228eab0fe039c886cdf84de2f87706e0491627648c9a9ca54f3017ab9efb7',
  duration = '1.431',
  merge_duration = '0.062',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.61',
  system_load_5_min = '1.08',
  system_load_15_min = '1.28',
  system_memory_usage = '88.31',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '488') + '8042624',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '488';
[12/02/2020 01:42:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1606916555','60.254.11.202');
[12/02/2020 01:43:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1606916608','60.254.11.202');
[12/02/2020 01:43:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO bookings SET  source_type = 'localsystem', reservation_id = '1890', create_date = '2020-12-02 13:43:34', 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 = '11.98', display_currency_code = 'USD', native_room_rate = '40', native_currency_code = 'AED', supplier_profile_id = '1', service_type = 'hotel', service_date = '2021/06/02', check_out_date = '2021/06/03', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'Deep', leader_last_name = 'Mishra', booking_branch_id = '1', expiration_date = '2020-12-02 01:43: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 11.98 USD applicable if cancelled after 02 Dec 2020 07:12 hrs.', supplier_cancellation_policy = '', status_date = '2020-12-02 13:43:34',  site_url = 'https://alpha.otrams.thefabulousgetaway.com/';
[12/02/2020 01:43:34], [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 ('3065','RATEGAINONE','RATEGAINONE','53773','53773','mumbai','LOCAL_SUPPLIER',NOW());
[12/02/2020 01:43:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='3065'
        ;
[12/02/2020 01:43:34], [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('3065','S000000241','1','1','0','-','','','53773','53773','RATEGAINONE','Mumbai','123456789','5.0','1','2021/06/02','2021/06/03','','https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/images/imagenotavailable.jpg');
[12/02/2020 01:43:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into booking_room_detail set  booking_id = '3065', booking_detail_id = '1203', 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\";d:11.98;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:187:\"Supplier Name - localsupplier(RateGainSupplier - S000000241), Rate - 40 AED, Currency Multiplier (AED-USD) - 0.27222 Supplier Commission-0 #localsystem Agent Hotel Category Markup=10.00 %\";}}', native_nightly_rates = 'a:1:{i:0;a:4:{s:19:\"O_nativeNightlyRate\";i:40;s:17:\"nativeNightlyRate\";i:40;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 = '40', display_room_rate_total = '11.98', number_of_rooms = '1';
[12/02/2020 01:43:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into passangers set  booking_id = '3065', booking_detail_id = '1203', rid = '1801', room = '0', salutations = 'Mr', first_name = 'Deep', last_name = 'Mishra', passenger_type = 'adult', age = '';
[12/02/2020 01:43:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '', confirmation_number = '', display_discount = '0', current_status = 'confirmed', comment_contract = '', consultant_id = 'SalesConsultant', sales_manager_id = '', admin_booked = '1', email_id = 'deep.mishra@rategain.com', leader_phone = '+123451914108628', agent_currency_multiplier = '1.00000', ip_addr = '60.254.11.202', backoffice_user = 'tfg', customer_id = '', applied_multiplier='0.27222', free_sale='',  applied_markup='10',  agent_markup='10',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='0.27222',  parent_agent_id='24',  sub_agent_rate='0', agent_rate='11.98',  applicable_service_tax='0',  supplier_rate='40',  original_source='',  uid='b01124a7b42001fd5dd5a18a0ab24ab8'  where id='3065';
[12/02/2020 01:43:34], [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 ='3065';
[12/02/2020 01:43:34], [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 = '3065';
[12/02/2020 01:43:34], [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('3065','2020-12-02 13:42:00','2020-12-02 13:42:00','40','11.98','0','2020-12-02 13:43:34');
[12/02/2020 01:43:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('3065','','');
[12/02/2020 01:43:34], [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 ('3065','confirmed','2020-12-02 13:43:34','Booking confirmed . Booked by Back Office tfg on behalf of Agent - Snehal  Valanju(CD0024)','24','60.254.11.202','0','24');
[12/02/2020 01:43:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_search_log(booking_id, details)
        VALUES(3065, 'a:30:{s:3:\"_id\";a:1:{s:4:\"$oid\";s:24:\"5fc799b8143d0e361a10a9a3\";}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:\"USD\";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:40;s:17:\"nativeNightlyRate\";i:40;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\";d:11.98;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:187:\"Supplier Name - localsupplier(RateGainSupplier - S000000241), Rate - 40 AED, Currency Multiplier (AED-USD) - 0.27222 Supplier Commission-0 #localsystem Agent Hotel Category Markup=10.00 %\";}}}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:\"47727d9c0c5074375f8e855c57fa89b6\";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:\"USD\";s:18:\"nativeCurrencyCode\";s:3:\"AED\";s:20:\"displayRoomTypeRates\";d:11.98;s:20:\"sortingRoomTypeRates\";d:11.98;s:19:\"nativeRoomTypeRates\";i:40;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_1817779\";}}s:9:\"available\";i:1;s:15:\"displayRoomRate\";d:11.98;s:14:\"nativeRoomRate\";i:40;s:9:\"unique_id\";s:36:\"1_53773----------S000000241_0_0_2224\";s:10:\"supplierId\";s:10:\"S000000241\";s:19:\"displayCurrencyCode\";s:3:\"USD\";s:18:\"nativeCurrencyCode\";s:3:\"AED\";s:18:\"applied_markup_per\";i:10;s:18:\"applied_multiplier\";d:0.27222;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\";d:11.98;s:17:\"propertyAvailable\";i:1;s:8:\"no_class\";i:0;s:18:\"sort_total_charges\";d:11.98;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/02/2020 01:43:34], [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('3065','2020-12-02 13:42:00','2020-12-02 13:42:00','1970-01-01 00:00:00','1970-01-01 00:00:00','40','11.98','0','2020-12-02 13:43:34','');
[12/02/2020 01:43:34], [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 = '3065';
[12/02/2020 01:43:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO bookings_applicable_offer set  oid= '',  offer_type_code= '',  booking_id= '3065',  room_id= '1~~~132~~~1039~~~1~~~~~~~~~64440~~~0~~~S000000241',  room_name= 'single',  supplier_id= 'S000000241',  agent_id= '',  applied_native_discount= '0',  original_native_rate= '40',  native_rate= '40',  promotion_text= '',  offer_disc_type= '',  offer_disc_value= '',  offer_disc_currency= '',  create_date= '2020-12-02 13:43:34' ;
[12/02/2020 01:43:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set confirmation_number='',itenirary_id='3065' where  id ='3065';
[12/02/2020 01:43:34], [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-02';
[12/02/2020 01:43:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update supplement_rate set inventory = '0' where supplement_rate_id = '1';
[12/02/2020 01:43:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into booking_configuration set  booking_id = '3065', config_key = 'BOOKING OTP', config_value = 'gTfYxU8y';;
[12/02/2020 01:43:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= ' TFG103065 /  Booking Confirmed ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 40056 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking.php',create_date= '2020-12-02 13:43:35';
[12/02/2020 01:43:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3065','snehal.valanju@qtechsoftware.com');
[12/02/2020 01:43:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3065','snehal.valanju@qtechsoftware.com');
[12/02/2020 01:43:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update posted_bookings set booking_id='3065',status='1' where reservation_id='1890' and booking_id ='0';
[12/02/2020 01:43:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update xmllogs set reservation_id='3065' where agent_logs_id='488' and source_type='localsystem';
[12/02/2020 01:43:35], [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 ='3065',  create_date ='2020-12-02 13:43:35', supplier_tax='';
[12/02/2020 01:43:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set voucher_id='Test123',status_date='2020-12-02 13:43:35',current_status='vouchered',voucher_hashcode='645b87c89071b8b0ed1b129597e290bb264943065',vouchered_by ='' where id='3065';
[12/02/2020 01:43:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],Insert into booking_configuration set booking_id='3065',config_key='VOUCHER_DATE', config_value='2020-12-02 13:43:35',create_date='2020-12-02 13:43:35';
[12/02/2020 01:43:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO autogenerator_invoice_number (id, number) VALUES ('','1606916615');
[12/02/2020 01:43:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set is_invoiced='yes',invoice_number= '2020/392' where id='3065' and is_invoiced!='yes';
[12/02/2020 01:43:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],UPDATE agents SET credit_usage=credit_usage+('11.98'),   credit_value= credit_value-('11.98') ,  cd_credit_usage=cd_credit_usage+('11.98') , cd_credit_value=cd_credit_value-('11.98')  WHERE id = '24';
[12/02/2020 01:43:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into  agent_credit_log SET agent_id= '24',credit_value= '9976.040',credit_usage= '23.960',credit_limit= '10000',receipt_id= '',amount= '11.98',booking_id='3065',booking_cost= '11.98',receipt_allocation= '',balance= '11.98',ip='60.254.11.202',user_type='User',admin_id='Agent - Snehal  Valanju(CD0024)',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-12-02 13:12:35';
[12/02/2020 01:43:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into booking_rate_info set agent_price='0',sub_agent_price='0',supplier_currency='AED',supplier_price='40',supplier_type='offline',supplier_id='S000000241',acc_type='purchase',accounting_multiplier='0.27222',booking_id='3065',booking_log='Booking Vouchered',type='Sale',create_date='2020-12-02 13:43:35',account_invoice='2020/392',particulars='';
[12/02/2020 01:43:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into booking_rate_info set agent_price='11.98',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='1.00000',booking_id='3065',booking_log='Booking Vouchered',type='Sale',create_date='2020-12-02 13:43:35',account_invoice='2020/392',particulars='';
[12/02/2020 01:43:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1506;
[12/02/2020 01:43:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO accounts_invoice_transaction SET bid= '1506',booking_id= '3065',invoice_number= '2020/392',service_type= 'hotel',booking_type= 'online',service_name= 'RATEGAINONE',type= 'sale',room_type= 'single',quantity_room= '1',from_date= '2021/06/02',to_date= '2021/06/03',quantity= '1',price= '11.98',total_price= '11.98';
[12/02/2020 01:43:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= 'The Fabulous Getaway Tax Dispute(TaxInvoice)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'Rm9yIEZvbGxvd2luZyBib29raW5nIFRheCBpcyBub3QgaW5zZXJ0ZWQ8YnI+Qm9va2luZ0lkOi0zMDY1PGJyPkludm9pY2Ugbm86LTIwMjAvMzkyPGJyPmJyYW5jaF9pZDotMTxicj5UeXBlOi1hZ2VudDxicj5BY2NvdW50IHR5cGU6LXNhbGU8YnI+',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking.php',create_date= '2020-12-02 13:43:35';
[12/02/2020 01:43:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into email_trigger set  subject ='The Fabulous Getaway Tax Dispute',  message='For Following booking Tax is not inserted<br>BookingId:-3065<br>Invoice no:-2020/392<br>branch_id:-1<br>Type:-agent<br>Account type:-sale<br>',  email_sent ='yes', create_date ='2020-12-02 13:43:35', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='TaxInvoice';
[12/02/2020 01:43:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_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
        ('','','3065','vouchered-invoiced','2020-12-02 13:43:36','Booking invoiced by Back Office tfg on behalf of Agent - Snehal  Valanju(CD0024)','24','60.254.11.202','','','');
[12/02/2020 01:43:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO agent_commission SET booking_id ='3065',booking_detail_id ='3065',agent_id ='24',is_sub_agent ='N',parent_id ='',display_commission ='1.08888',display_currency ='USD',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 10 %',create_date ='2020-12-02 13:43:36';
[12/02/2020 01:43:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into accounting_status set booking_id ='3065',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[12/02/2020 01:43:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_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
        ('','','3065','vouchered','2020-12-02 13:43:36','Voucherd by Back Office tfg on behalf of Agent - Snehal  Valanju(CD0024)','24','60.254.11.202','','','');
[12/02/2020 01:43:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= ' TFG103065 /  Booking Vouchered ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 27836 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,SalesConsultant@gmail.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking.php',create_date= '2020-12-02 13:43:37';
[12/02/2020 01:43:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3065','snehal.valanju@qtechsoftware.com');
[12/02/2020 01:43:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3065','SalesConsultant@gmail.com');
[12/02/2020 01:43:44], [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 = '3065';
[12/02/2020 01:45:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '24' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '60.254.11.202' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2021/06/02' , departure_date = '2021/06/03' , nationality = '106' , nights = '1' , room_types = '1' , create_date = '2020-12-02 13:45:35' , site_id = '' , country_code = '106' , web_service = '' ;
[12/02/2020 01:45:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-12-02 01:45:38', '', '85e228eab0fe039c886cdf84de2f87706e0491627648c9a9ca54f3017ab9efb7', '489');
[12/02/2020 01:45:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-12-02 01:45:38', '', '85e228eab0fe039c886cdf84de2f87706e0491627648c9a9ca54f3017ab9efb7', '489');
[12/02/2020 01:45:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=85e228eab0fe039c886cdf84de2f87706e0491627648c9a9ca54f3017ab9efb7&xml_user_id=24&request_no=1&local_hotel_code=53769&#039;,&#039;53771&#039;,&#039;53773&#039;,&#039;53775&#039;,&#039;53776&#039;,&#039;53742&web_service=no&site_id='
, http_hit_time = '2020-12-02 13:45:37.440'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.007'
, error_description = ''
, memory_used = '7908600'
WHERE id = '3315';
[12/02/2020 01:45:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=85e228eab0fe039c886cdf84de2f87706e0491627648c9a9ca54f3017ab9efb7&xml_user_id=24&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&#039;,&#039;53766&#039;,&#039;53767&#039;,&#039;53768&web_service=no&site_id='
, http_hit_time = '2020-12-02 13:45:37.420'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.086'
, error_description = ''
, memory_used = '7910040'
WHERE id = '3316';
[12/02/2020 01:45:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=24&sessionid=85e228eab0fe039c886cdf84de2f87706e0491627648c9a9ca54f3017ab9efb7',
  duration = '1.681',
  merge_duration = '0.166',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '4.98',
  system_load_5_min = '2.18',
  system_load_15_min = '1.61',
  system_memory_usage = '88.33',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '489') + '8042624',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '489';
[12/02/2020 01:46:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1606916761','60.254.11.202');
