[07/09/2020 11:06:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-07-09 11:06:39',login_attempt=0 where id = '21';
[07/09/2020 11:06:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'ankita', user_type = 'A', branch_id = '3', login_datetime = '2020-07-09 11:06:39', ip = '106.220.92.202', action = 'Login' ;
[07/09/2020 11:07:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '21' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '3' , ip = '106.220.92.202' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/07/17' , departure_date = '2020/07/18' , nationality = '3' , nights = '1' , room_types = '2' , create_date = '2020-07-09 11:07:15' , site_id = '' , country_code = '106' , web_service = '' ;
[07/09/2020 11:07:22], [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-07-09 11:07:22', '', 'b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7', '325');
[07/09/2020 11:07:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7&xml_user_id=21&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;53742&#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&web_service=no&site_id='
, http_hit_time = '2020-07-09 11:07:21.408'
, 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 = '2.036'
, error_description = ''
, memory_used = '8020136'
WHERE id = '2862';
[07/09/2020 11:07:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=21&sessionid=b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7',
  duration = '3.344',
  merge_duration = '0.157',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.57',
  system_load_5_min = '1.31',
  system_load_15_min = '1.27',
  system_memory_usage = '92.69',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '325') + '8148176',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '325';
[07/09/2020 11:08:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '21' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '3' , ip = '106.220.92.202' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/07/17' , departure_date = '2020/07/18' , nationality = '3' , nights = '1' , room_types = '2' , create_date = '2020-07-09 11:08:03' , site_id = '' , country_code = '106' , web_service = '' ;
[07/09/2020 11:08:06], [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-07-09 11:08:06', '', 'b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7', '326');
[07/09/2020 11:08:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7&xml_user_id=21&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;53742&#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&web_service=no&site_id='
, http_hit_time = '2020-07-09 11:08:06.126'
, 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.330'
, error_description = ''
, memory_used = '8020512'
WHERE id = '2863';
[07/09/2020 11:08:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=21&sessionid=b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7',
  duration = '2.246',
  merge_duration = '0.108',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.62',
  system_load_5_min = '1.24',
  system_load_15_min = '1.25',
  system_memory_usage = '92.72',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '326') + '8148400',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '326';
[07/09/2020 11:18:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '21' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '3' , ip = '106.220.92.202' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/07/17' , departure_date = '2020/07/18' , nationality = '3' , nights = '1' , room_types = '2' , create_date = '2020-07-09 11:18:32' , site_id = '' , country_code = '106' , web_service = '' ;
[07/09/2020 11:18:35], [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-07-09 11:18:35', '', 'b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7', '327');
[07/09/2020 11:18:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7&xml_user_id=21&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;53742&#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&web_service=no&site_id='
, http_hit_time = '2020-07-09 11:18:35.15'
, 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.722'
, error_description = ''
, memory_used = '8020512'
WHERE id = '2864';
[07/09/2020 11:18:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=21&sessionid=b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7',
  duration = '2.292',
  merge_duration = '0.137',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.84',
  system_load_5_min = '0.98',
  system_load_15_min = '1.07',
  system_memory_usage = '92.72',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '327') + '8148400',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '327';
[07/09/2020 11:37:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '21' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '3' , ip = '106.220.92.202' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/07/17' , departure_date = '2020/07/18' , nationality = '3' , nights = '1' , room_types = '2' , create_date = '2020-07-09 11:37:26' , site_id = '' , country_code = '106' , web_service = '' ;
[07/09/2020 11:37:29], [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-07-09 11:37:29', '', 'b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7', '328');
[07/09/2020 11:37:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7&xml_user_id=21&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;53742&#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&web_service=no&site_id='
, http_hit_time = '2020-07-09 11:37:29.134'
, 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.434'
, error_description = ''
, memory_used = '8020512'
WHERE id = '2865';
[07/09/2020 11:37:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=21&sessionid=b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7',
  duration = '1.863',
  merge_duration = '0.117',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.73',
  system_load_5_min = '1.04',
  system_load_15_min = '1.12',
  system_memory_usage = '92.83',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '328') + '8148400',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '328';
[07/09/2020 11:40:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '21' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '3' , ip = '106.220.92.202' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/07/17' , departure_date = '2020/07/18' , nationality = '3' , nights = '1' , room_types = '2' , create_date = '2020-07-09 11:40:36' , site_id = '' , country_code = '106' , web_service = '' ;
[07/09/2020 11:40:39], [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-07-09 11:40:39', '', 'b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7', '329');
[07/09/2020 11:40:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7&xml_user_id=21&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;53742&#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&web_service=no&site_id='
, http_hit_time = '2020-07-09 11:40:38.571'
, 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 = '2.421'
, error_description = ''
, memory_used = '8020512'
WHERE id = '2866';
[07/09/2020 11:40:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=21&sessionid=b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7',
  duration = '3.199',
  merge_duration = '0.236',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '1.39',
  system_load_5_min = '0.95',
  system_load_15_min = '1.04',
  system_memory_usage = '92.83',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '329') + '8148400',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '329';
[07/09/2020 11:42:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '21' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '3' , ip = '106.220.92.202' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/07/17' , departure_date = '2020/07/18' , nationality = '3' , nights = '1' , room_types = '2' , create_date = '2020-07-09 11:42:32' , site_id = '' , country_code = '106' , web_service = '' ;
[07/09/2020 11:42:35], [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-07-09 11:42:35', '', 'b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7', '330');
[07/09/2020 11:42:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7&xml_user_id=21&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;53742&#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&web_service=no&site_id='
, http_hit_time = '2020-07-09 11:42:35.93'
, 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.724'
, error_description = ''
, memory_used = '8020512'
WHERE id = '2867';
[07/09/2020 11:42:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=21&sessionid=b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7',
  duration = '2.278',
  merge_duration = '0.138',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.69',
  system_load_5_min = '0.91',
  system_load_15_min = '1.02',
  system_memory_usage = '92.78',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '330') + '8148400',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '330';
[07/09/2020 11:47:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594295239','106.220.92.202');
[07/09/2020 11:47:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Creamcentre', 'mumbai', '106', '21', '', '3', '', 'hotelcancellationpolicy', '2020-07-09 :11:47:20','');
[07/09/2020 11:47:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594295259','106.220.92.202');
[07/09/2020 11:47:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Creamcentre', 'mumbai', '106', '21', '', '3', '', 'hotelcancellationpolicy', '2020-07-09 :11:47:39','');
[07/09/2020 11:48:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594295280','106.220.92.202');
[07/09/2020 11:48:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelcancellationpolicy', '2020-07-09 :11:48:00','');
[07/09/2020 11:48:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/m1_write_cache.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594295296','106.220.92.202');
[07/09/2020 11:48:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/m1_write_cache.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594295303','106.220.92.202');
[07/09/2020 11:48:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/m1_write_cache.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594295318','106.220.92.202');
[07/09/2020 11:50:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/m1_write_cache.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594295419','106.220.92.202');
[07/09/2020 11:50:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/m1_write_cache.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594295425','106.220.92.202');
[07/09/2020 11:54:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/m1_addtoquote.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelquotation', '2020-07-09 :11:54:16','');
[07/09/2020 11:54:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/m1_addtoquote.php],UPDATE agent_quotation_sequence SET sequence_no='184' WHERE agent_id='21';
[07/09/2020 11:54:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/m1_addtoquote.php],INSERT INTO agent_quotation SET q_name = 'PHP7QUOtation',unique_id = 'RDTCD0021184',backoffice_user = 'tfg',currency ='INR',service_date='2020-07-17 00:00:00',service_checkout_date='2020-07-18 00:00:00',city_code = '64440',country_code = '106',nationality = '3',total_adult = '2',total_child = '',child_age = 'a%3A0%3A%7B%7D',sequence = '1',agent_id = '21',create_date = '2020-07-09 11:54:16',q_info = 'a%3A22%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1594944000%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2217%2F07%2F2020+--+18%2F07%2F2020%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A24%3A%225f0702acd3a2d15481678987%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253716%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A37%3A%221_53716----------S000000089_1_0_67061%22%3Bs%3A4%3A%22name%22%3Bs%3A18%3A%22HYATT+MUMBAI+PRIME%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%224.0%22%3Bs%3A10%3A%22hotel_info%22%3Ba%3A1%3A%7Bs%3A11%3A%22localsystem%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A13%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A33%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A4%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bd%3A300%3Bs%3A17%3A%22nativeNightlyRate%22%3Bd%3A300%3Bs%3A9%3A%22free_sale%22%3Bs%3A2%3A%22no%22%3Bs%3A14%3A%22Discount%2FOffer%22%3Ba%3A7%3A%7Bs%3A4%3A%22code%22%3Bs%3A0%3A%22%22%3Bs%3A4%3A%22Name%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22S_Value%22%3Bs%3A0%3A%22%22%3Bs%3A5%3A%22Value%22%3Bi%3A0%3Bs%3A12%3A%22Display_Name%22%3Bs%3A0%3A%22%22%3Bs%3A10%3A%22Offer_Note%22%3BN%3Bs%3A10%3A%22Offer_Type%22%3BN%3B%7D%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A3%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bd%3A5565.53%3Bs%3A16%3A%22promotionDisplay%22%3Bs%3A0%3A%22%22%3Bs%3A25%3A%22displayNightlyRateDisplay%22%3Bs%3A202%3A%22Supplier+Name+-+localsupplier%28Hyatt+Mumbai+Prime+-+S000000089%29%2C+Rate+-+300+MYR%2C+Currency+Multiplier+%28MYR-INR%29+-+15.45981+Supplier+Commission-0+%2C+Branch%3A%25+%23localsystem+Agent+Hotel+Category+Markup%3D20.00+%25%22%3B%7D%7D%7Ds%3A20%3A%22offer_promotion_note%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22offer_discount_type%22%3Bs%3A0%3A%22%22%3Bs%3A27%3A%22offer_discount_note_details%22%3BN%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A9%3A%22stay_note%22%3Bs%3A30%3A%22Default+Booking+Note%26lt%3Bbr%26gt%3B%22%3Bs%3A10%3A%22time_stamp%22%3Bs%3A32%3A%22afaa1087c97152e8c425b599f826d446%22%3Bs%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A10%3A%22view_basis%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22view_basis_id%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22available%22%3Bi%3A1%3Bs%3A9%3A%22free_sale%22%3BN%3Bs%3A7%3A%22minStay%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bd%3A5565.53%3Bs%3A20%3A%22sortingRoomTypeRates%22%3Bd%3A5565.53%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bd%3A300%3Bs%3A12%3A%22offerApplied%22%3BN%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%222%7E%7E%7E146%7E%7E%7E662%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000089%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A16%3A%22valuation_number%22%3Bs%3A48%3A%222%7E%7E%7E146%7E%7E%7E662%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000089%22%3Bs%3A15%3A%22number_of_child%22%3Bi%3A0%3Bs%3A13%3A%22NumberOfRooms%22%3Bi%3A1%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000089%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A18%3A%22Hyatt+Mumbai+Prime%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A4%3A%22note%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22room_category%22%3Bs%3A10%3A%22Prime+Room%22%3Bs%3A9%3A%22room_type%22%3Bs%3A32%3A%22Prime++-Bed+%26+Breakfast+%3A+2+Pax+%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A17%3A%220_0_53716_2134373%22%3B%7D%7Ds%3A9%3A%22available%22%3Bi%3A1%3Bs%3A15%3A%22displayRoomRate%22%3Bd%3A5565.53%3Bs%3A14%3A%22nativeRoomRate%22%3Bd%3A300%3Bs%3A9%3A%22unique_id%22%3Bs%3A37%3A%221_53716----------S000000089_1_0_67061%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000089%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bd%3A20%3Bs%3A18%3A%22applied_multiplier%22%3Bd%3A15.45981%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253716----------S000000089%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A18%3A%22HYATT+MUMBAI+PRIME%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000089%22%3B%7Ds%3A8%3A%22no_class%22%3Bi%3A0%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A8%3A%22latitude%22%3Bd%3A6.278698%3Bs%3A9%3A%22longitude%22%3Bd%3A99.730656%3Bs%3A13%3A%22numberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A11%3A%22totalAdults%22%3Bi%3A2%3Bs%3A13%3A%22totalChildren%22%3Bi%3A0%3Bs%3A17%3A%22selectedUserTypes%22%3Ba%3A1%3A%7Bs%3A6%3A%22double%22%3Ba%3A20%3A%7Bs%3A2%3A%22id%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22room_type_display%22%3Bs%3A6%3A%22Double%22%3Bs%3A24%3A%22room_type_display_arabic%22%3Bs%3A12%3A%22%D9%85%D8%B2%D8%AF%D9%88%D8%AC%D8%A9%22%3Bs%3A9%3A%22room_type%22%3Bs%3A6%3A%22double%22%3Bs%3A13%3A%22child_allowed%22%3Bs%3A2%3A%22no%22%3Bs%3A12%3A%22no_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A11%3A%22no_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22child_from%22%3Bs%3A1%3A%220%22%3Bs%3A8%3A%22child_to%22%3Bs%3A1%3A%220%22%3Bs%3A8%3A%22sequence%22%3Bs%3A1%3A%221%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3Bs%3A11%3A%22create_date%22%3Bs%3A10%3A%222007-09-14%22%3Bs%3A11%3A%22modify_date%22%3Bs%3A10%3A%222014-02-13%22%3Bs%3A13%3A%22property_type%22%3BN%3Bs%3A7%3A%22is_twin%22%3Bs%3A1%3A%220%22%3Bs%3A14%3A%22selected_rooms%22%3Bi%3A1%3Bs%3A8%3A%22room_key%22%3Bi%3A0%3Bs%3A9%3A%22occurance%22%3Bi%3A1%3Bs%3A10%3A%22AdultCount%22%3Bi%3A2%3Bs%3A10%3A%22childCount%22%3Bi%3A0%3B%7D%7Ds%3A13%3A%22selected_city%22%3Bs%3A6%3A%22mumbai%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22106%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A1%3A%223%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A22%3A%22TEST+HOTEL+DESCRIPTION%22%3Bs%3A11%3A%22hotel_image%22%3Bs%3A81%3A%22http%3A%2F%2Fuat.tfg.otrams.net%2Fproject_folder%2Ftfg_project%2Fimages%2Fimagenotavailable.jpg%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A14%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A33%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A4%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bd%3A300%3Bs%3A17%3A%22nativeNightlyRate%22%3Bd%3A300%3Bs%3A9%3A%22free_sale%22%3Bs%3A2%3A%22no%22%3Bs%3A14%3A%22Discount%2FOffer%22%3Ba%3A7%3A%7Bs%3A4%3A%22code%22%3Bs%3A0%3A%22%22%3Bs%3A4%3A%22Name%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22S_Value%22%3Bs%3A0%3A%22%22%3Bs%3A5%3A%22Value%22%3Bi%3A0%3Bs%3A12%3A%22Display_Name%22%3Bs%3A0%3A%22%22%3Bs%3A10%3A%22Offer_Note%22%3BN%3Bs%3A10%3A%22Offer_Type%22%3BN%3B%7D%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A3%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bd%3A5565.53%3Bs%3A16%3A%22promotionDisplay%22%3Bs%3A0%3A%22%22%3Bs%3A25%3A%22displayNightlyRateDisplay%22%3Bs%3A202%3A%22Supplier+Name+-+localsupplier%28Hyatt+Mumbai+Prime+-+S000000089%29%2C+Rate+-+300+MYR%2C+Currency+Multiplier+%28MYR-INR%29+-+15.45981+Supplier+Commission-0+%2C+Branch%3A%25+%23localsystem+Agent+Hotel+Category+Markup%3D20.00+%25%22%3B%7D%7D%7Ds%3A20%3A%22offer_promotion_note%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22offer_discount_type%22%3Bs%3A0%3A%22%22%3Bs%3A27%3A%22offer_discount_note_details%22%3BN%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A9%3A%22stay_note%22%3Bs%3A30%3A%22Default+Booking+Note%26lt%3Bbr%26gt%3B%22%3Bs%3A10%3A%22time_stamp%22%3Bs%3A32%3A%22afaa1087c97152e8c425b599f826d446%22%3Bs%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A10%3A%22view_basis%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22view_basis_id%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22available%22%3Bi%3A1%3Bs%3A9%3A%22free_sale%22%3BN%3Bs%3A7%3A%22minStay%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bd%3A5565.53%3Bs%3A20%3A%22sortingRoomTypeRates%22%3Bd%3A5565.53%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bd%3A300%3Bs%3A12%3A%22offerApplied%22%3BN%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%222%7E%7E%7E146%7E%7E%7E662%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000089%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A16%3A%22valuation_number%22%3Bs%3A48%3A%222%7E%7E%7E146%7E%7E%7E662%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000089%22%3Bs%3A15%3A%22number_of_child%22%3Bi%3A0%3Bs%3A13%3A%22NumberOfRooms%22%3Bi%3A1%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000089%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A18%3A%22Hyatt+Mumbai+Prime%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A4%3A%22note%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22room_category%22%3Bs%3A10%3A%22Prime+Room%22%3Bs%3A9%3A%22room_type%22%3Bs%3A32%3A%22Prime++-Bed+%26+Breakfast+%3A+2+Pax+%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A17%3A%220_0_53716_2134373%22%3B%7D%7Ds%3A9%3A%22available%22%3Bi%3A1%3Bs%3A15%3A%22displayRoomRate%22%3Bd%3A5565.53%3Bs%3A14%3A%22nativeRoomRate%22%3Bd%3A300%3Bs%3A9%3A%22unique_id%22%3Bs%3A37%3A%221_53716----------S000000089_1_0_67061%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000089%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bd%3A20%3Bs%3A18%3A%22applied_multiplier%22%3Bd%3A15.45981%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253716----------S000000089%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A18%3A%22HYATT+MUMBAI+PRIME%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000089%22%3B%7Ds%3A8%3A%22no_class%22%3Bi%3A0%3Bs%3A19%3A%22cancellation_policy%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A9%3A%7Bs%3A18%3A%22cancellationPolicy%22%3Bs%3A465%3A%22Amendment+of+Dates%2C+Room+Category%2C+Passenger+Names+are+considered+as+Cancel+and+Rebook+by+most+of+the+Hotels.%0A++++++++Any+Changes+in+initial+booking+may+be+denied+by+the+supplier+or+may+result+in+extra+charges.%0A++++++++Confirmation+of+amendment+requests+is+subject+to+availablity+and+rates+at+the+time+of+amendment.%3Cbr%3E%3CBr%3E%3CBr%3E%3CB%3E%3CU%3EDetailed+Cancellation+Policy%3A%3C%2FU%3E%3C%2FB%3E+%3Cbr%2F%3E+Cancellation+Charges+of+4452.42+INR+applicable+if+cancelled+after+18-Jul-2019+05%3A30+hrs.%22%3Bs%3A24%3A%22cancellationPolicy_table%22%3Ba%3A1%3A%7Bs%3A12%3A%22no_room_wise%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A3%3A%7Bs%3A9%3A%22date_from%22%3Bs%3A17%3A%2218-Jul-2019+05%3A30%22%3Bs%3A7%3A%22date_to%22%3Bs%3A17%3A%2217-Jul-2020+00%3A00%22%3Bs%3A7%3A%22charges%22%3Bs%3A11%3A%224452.42+INR%22%3B%7D%7D%7Ds%3A5%3A%22cp_id%22%3BN%3Bs%3A26%3A%22cancellationPolicy_details%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A3%3A%7Bs%3A9%3A%22from_date%22%3Bs%3A17%3A%2218-Jul-2019+05%3A30%22%3Bs%3A13%3A%22agent_charges%22%3Bd%3A4452.424%3Bs%3A16%3A%22supplier_charges%22%3Bi%3A240%3B%7D%7Ds%3A16%3A%22inventory_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A18%3A%22cancellation_hours%22%3Bd%3A8754.5%3Bs%3A6%3A%22office%22%3BN%3Bs%3A16%3A%22comment_contract%22%3Bs%3A30%3A%22Default+Booking+Note%26lt%3Bbr%26gt%3B%22%3Bs%3A21%3A%22applied_agent_charges%22%3Bd%3A4452.424%3B%7D%7D%7D%7D',service = 'hotel',hotel_id = '5f0702acd3a2d15481678987',additional_markup = '0',city_name ='mumbai',total_price ='5565.53',cancelltion_policy ='  
&lt;!-- Added code to display price change while displaying cancelltion rate change in search listing - Swapnil Nagaonkar - 6 November 2014 - START --&gt;
			
&lt;!-- Ended code to display price change while displaying cancelltion rate change in search listing - Swapnil Nagaonkar - 6 November 2014 - END --&gt;

&lt;h2 class=&quot;cancellation&quot; style=&quot;  margin:14px 0px -15px 22px;font-weight:300;font-family: &#039;Source Sans Pro&#039;, sans-serif;color: #4d4d4d; font-size: 26px;&quot;&gt;Cancellation Policy&lt;/h2&gt;
&lt;table width=&quot;100%&quot; border=&quot;0&quot; cellspacing=&quot;5&quot; cellpadding=&quot;0&quot; style=&quot;font-family: &#039;Source Sans Pro&#039;, sans-serif;&quot;&gt;
	&lt;tr&gt;
	&lt;td&gt;
		&lt;table border=&quot;0&quot; width=&quot;100%&quot; align=&quot;center&quot; cellpadding=&quot;0&quot; cellspacing=&quot;10&quot; style=&quot;border: 1px dotted grey;margin-top:20px; color: #8b8e91; font-family: &#039;Source Sans Pro&#039;,sans-serif; font-size: 14px; font-weight: 400; line-height: 18px;&quot;&gt;
		 					&lt;tr&gt;
					&lt;td align=&#039;center&#039;&gt;This hotel is not available for booking. Please select other hotel.&lt;/td&gt;
				&lt;/tr&gt;	
				
		&lt;/table&gt;
		&lt;/td&gt;
	&lt;/tr&gt;
&lt;/table&gt;	
',per_night ='5565.53',room_type ='Prime -Bed & Breakfast : 2 Pax',room_rate ='5565.53';
[07/09/2020 11:54:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/m1_addtoquote.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelquotation', '2020-07-09 :11:54:22','');
[07/09/2020 11:54:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/m1_addtoquote.php],INSERT INTO agent_quotation SET q_name = 'PHP7QUOtation',unique_id = 'RDTCD0021184',backoffice_user = 'tfg',currency ='INR',service_date='2020-07-17 00:00:00',service_checkout_date='2020-07-18 00:00:00',city_code = '64440',country_code = '106',nationality = '3',total_adult = '2',total_child = '',child_age = 'a%3A0%3A%7B%7D',sequence = '1',agent_id = '21',create_date = '2020-07-09 11:54:22',q_info = 'a%3A22%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1594944000%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2217%2F07%2F2020+--+18%2F07%2F2020%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A24%3A%225f0702acd3a2d15481678987%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253716%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A37%3A%221_53716----------S000000089_1_0_67061%22%3Bs%3A4%3A%22name%22%3Bs%3A18%3A%22HYATT+MUMBAI+PRIME%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%224.0%22%3Bs%3A10%3A%22hotel_info%22%3Ba%3A1%3A%7Bs%3A11%3A%22localsystem%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A13%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A33%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A4%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bd%3A300%3Bs%3A17%3A%22nativeNightlyRate%22%3Bd%3A300%3Bs%3A9%3A%22free_sale%22%3Bs%3A2%3A%22no%22%3Bs%3A14%3A%22Discount%2FOffer%22%3Ba%3A7%3A%7Bs%3A4%3A%22code%22%3Bs%3A0%3A%22%22%3Bs%3A4%3A%22Name%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22S_Value%22%3Bs%3A0%3A%22%22%3Bs%3A5%3A%22Value%22%3Bi%3A0%3Bs%3A12%3A%22Display_Name%22%3Bs%3A0%3A%22%22%3Bs%3A10%3A%22Offer_Note%22%3BN%3Bs%3A10%3A%22Offer_Type%22%3BN%3B%7D%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A3%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bd%3A5565.53%3Bs%3A16%3A%22promotionDisplay%22%3Bs%3A0%3A%22%22%3Bs%3A25%3A%22displayNightlyRateDisplay%22%3Bs%3A202%3A%22Supplier+Name+-+localsupplier%28Hyatt+Mumbai+Prime+-+S000000089%29%2C+Rate+-+300+MYR%2C+Currency+Multiplier+%28MYR-INR%29+-+15.45981+Supplier+Commission-0+%2C+Branch%3A%25+%23localsystem+Agent+Hotel+Category+Markup%3D20.00+%25%22%3B%7D%7D%7Ds%3A20%3A%22offer_promotion_note%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22offer_discount_type%22%3Bs%3A0%3A%22%22%3Bs%3A27%3A%22offer_discount_note_details%22%3BN%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A9%3A%22stay_note%22%3Bs%3A30%3A%22Default+Booking+Note%26lt%3Bbr%26gt%3B%22%3Bs%3A10%3A%22time_stamp%22%3Bs%3A32%3A%22afaa1087c97152e8c425b599f826d446%22%3Bs%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A10%3A%22view_basis%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22view_basis_id%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22available%22%3Bi%3A1%3Bs%3A9%3A%22free_sale%22%3BN%3Bs%3A7%3A%22minStay%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bd%3A5565.53%3Bs%3A20%3A%22sortingRoomTypeRates%22%3Bd%3A5565.53%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bd%3A300%3Bs%3A12%3A%22offerApplied%22%3BN%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%222%7E%7E%7E146%7E%7E%7E662%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000089%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A16%3A%22valuation_number%22%3Bs%3A48%3A%222%7E%7E%7E146%7E%7E%7E662%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000089%22%3Bs%3A15%3A%22number_of_child%22%3Bi%3A0%3Bs%3A13%3A%22NumberOfRooms%22%3Bi%3A1%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000089%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A18%3A%22Hyatt+Mumbai+Prime%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A4%3A%22note%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22room_category%22%3Bs%3A10%3A%22Prime+Room%22%3Bs%3A9%3A%22room_type%22%3Bs%3A32%3A%22Prime++-Bed+%26+Breakfast+%3A+2+Pax+%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A17%3A%220_0_53716_2134373%22%3B%7D%7Ds%3A9%3A%22available%22%3Bi%3A1%3Bs%3A15%3A%22displayRoomRate%22%3Bd%3A5565.53%3Bs%3A14%3A%22nativeRoomRate%22%3Bd%3A300%3Bs%3A9%3A%22unique_id%22%3Bs%3A37%3A%221_53716----------S000000089_1_0_67061%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000089%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bd%3A20%3Bs%3A18%3A%22applied_multiplier%22%3Bd%3A15.45981%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253716----------S000000089%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A18%3A%22HYATT+MUMBAI+PRIME%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000089%22%3B%7Ds%3A8%3A%22no_class%22%3Bi%3A0%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A8%3A%22latitude%22%3Bd%3A6.278698%3Bs%3A9%3A%22longitude%22%3Bd%3A99.730656%3Bs%3A13%3A%22numberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A11%3A%22totalAdults%22%3Bi%3A2%3Bs%3A13%3A%22totalChildren%22%3Bi%3A0%3Bs%3A17%3A%22selectedUserTypes%22%3Ba%3A1%3A%7Bs%3A6%3A%22double%22%3Ba%3A20%3A%7Bs%3A2%3A%22id%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22room_type_display%22%3Bs%3A6%3A%22Double%22%3Bs%3A24%3A%22room_type_display_arabic%22%3Bs%3A12%3A%22%D9%85%D8%B2%D8%AF%D9%88%D8%AC%D8%A9%22%3Bs%3A9%3A%22room_type%22%3Bs%3A6%3A%22double%22%3Bs%3A13%3A%22child_allowed%22%3Bs%3A2%3A%22no%22%3Bs%3A12%3A%22no_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A11%3A%22no_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22child_from%22%3Bs%3A1%3A%220%22%3Bs%3A8%3A%22child_to%22%3Bs%3A1%3A%220%22%3Bs%3A8%3A%22sequence%22%3Bs%3A1%3A%221%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3Bs%3A11%3A%22create_date%22%3Bs%3A10%3A%222007-09-14%22%3Bs%3A11%3A%22modify_date%22%3Bs%3A10%3A%222014-02-13%22%3Bs%3A13%3A%22property_type%22%3BN%3Bs%3A7%3A%22is_twin%22%3Bs%3A1%3A%220%22%3Bs%3A14%3A%22selected_rooms%22%3Bi%3A1%3Bs%3A8%3A%22room_key%22%3Bi%3A0%3Bs%3A9%3A%22occurance%22%3Bi%3A1%3Bs%3A10%3A%22AdultCount%22%3Bi%3A2%3Bs%3A10%3A%22childCount%22%3Bi%3A0%3B%7D%7Ds%3A13%3A%22selected_city%22%3Bs%3A6%3A%22mumbai%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22106%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A1%3A%223%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A22%3A%22TEST+HOTEL+DESCRIPTION%22%3Bs%3A11%3A%22hotel_image%22%3Bs%3A81%3A%22http%3A%2F%2Fuat.tfg.otrams.net%2Fproject_folder%2Ftfg_project%2Fimages%2Fimagenotavailable.jpg%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A14%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A33%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A4%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bd%3A300%3Bs%3A17%3A%22nativeNightlyRate%22%3Bd%3A300%3Bs%3A9%3A%22free_sale%22%3Bs%3A2%3A%22no%22%3Bs%3A14%3A%22Discount%2FOffer%22%3Ba%3A7%3A%7Bs%3A4%3A%22code%22%3Bs%3A0%3A%22%22%3Bs%3A4%3A%22Name%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22S_Value%22%3Bs%3A0%3A%22%22%3Bs%3A5%3A%22Value%22%3Bi%3A0%3Bs%3A12%3A%22Display_Name%22%3Bs%3A0%3A%22%22%3Bs%3A10%3A%22Offer_Note%22%3BN%3Bs%3A10%3A%22Offer_Type%22%3BN%3B%7D%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A3%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bd%3A5565.53%3Bs%3A16%3A%22promotionDisplay%22%3Bs%3A0%3A%22%22%3Bs%3A25%3A%22displayNightlyRateDisplay%22%3Bs%3A202%3A%22Supplier+Name+-+localsupplier%28Hyatt+Mumbai+Prime+-+S000000089%29%2C+Rate+-+300+MYR%2C+Currency+Multiplier+%28MYR-INR%29+-+15.45981+Supplier+Commission-0+%2C+Branch%3A%25+%23localsystem+Agent+Hotel+Category+Markup%3D20.00+%25%22%3B%7D%7D%7Ds%3A20%3A%22offer_promotion_note%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22offer_discount_type%22%3Bs%3A0%3A%22%22%3Bs%3A27%3A%22offer_discount_note_details%22%3BN%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A9%3A%22stay_note%22%3Bs%3A30%3A%22Default+Booking+Note%26lt%3Bbr%26gt%3B%22%3Bs%3A10%3A%22time_stamp%22%3Bs%3A32%3A%22afaa1087c97152e8c425b599f826d446%22%3Bs%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A10%3A%22view_basis%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22view_basis_id%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22available%22%3Bi%3A1%3Bs%3A9%3A%22free_sale%22%3BN%3Bs%3A7%3A%22minStay%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bd%3A5565.53%3Bs%3A20%3A%22sortingRoomTypeRates%22%3Bd%3A5565.53%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bd%3A300%3Bs%3A12%3A%22offerApplied%22%3BN%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%222%7E%7E%7E146%7E%7E%7E662%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000089%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A16%3A%22valuation_number%22%3Bs%3A48%3A%222%7E%7E%7E146%7E%7E%7E662%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000089%22%3Bs%3A15%3A%22number_of_child%22%3Bi%3A0%3Bs%3A13%3A%22NumberOfRooms%22%3Bi%3A1%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000089%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A18%3A%22Hyatt+Mumbai+Prime%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A4%3A%22note%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22room_category%22%3Bs%3A10%3A%22Prime+Room%22%3Bs%3A9%3A%22room_type%22%3Bs%3A32%3A%22Prime++-Bed+%26+Breakfast+%3A+2+Pax+%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A17%3A%220_0_53716_2134373%22%3B%7D%7Ds%3A9%3A%22available%22%3Bi%3A1%3Bs%3A15%3A%22displayRoomRate%22%3Bd%3A5565.53%3Bs%3A14%3A%22nativeRoomRate%22%3Bd%3A300%3Bs%3A9%3A%22unique_id%22%3Bs%3A37%3A%221_53716----------S000000089_1_0_67061%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000089%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bd%3A20%3Bs%3A18%3A%22applied_multiplier%22%3Bd%3A15.45981%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253716----------S000000089%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A18%3A%22HYATT+MUMBAI+PRIME%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000089%22%3B%7Ds%3A8%3A%22no_class%22%3Bi%3A0%3Bs%3A19%3A%22cancellation_policy%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A9%3A%7Bs%3A18%3A%22cancellationPolicy%22%3Bs%3A465%3A%22Amendment+of+Dates%2C+Room+Category%2C+Passenger+Names+are+considered+as+Cancel+and+Rebook+by+most+of+the+Hotels.%0A++++++++Any+Changes+in+initial+booking+may+be+denied+by+the+supplier+or+may+result+in+extra+charges.%0A++++++++Confirmation+of+amendment+requests+is+subject+to+availablity+and+rates+at+the+time+of+amendment.%3Cbr%3E%3CBr%3E%3CBr%3E%3CB%3E%3CU%3EDetailed+Cancellation+Policy%3A%3C%2FU%3E%3C%2FB%3E+%3Cbr%2F%3E+Cancellation+Charges+of+4452.42+INR+applicable+if+cancelled+after+18-Jul-2019+05%3A30+hrs.%22%3Bs%3A24%3A%22cancellationPolicy_table%22%3Ba%3A1%3A%7Bs%3A12%3A%22no_room_wise%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A3%3A%7Bs%3A9%3A%22date_from%22%3Bs%3A17%3A%2218-Jul-2019+05%3A30%22%3Bs%3A7%3A%22date_to%22%3Bs%3A17%3A%2217-Jul-2020+00%3A00%22%3Bs%3A7%3A%22charges%22%3Bs%3A11%3A%224452.42+INR%22%3B%7D%7D%7Ds%3A5%3A%22cp_id%22%3BN%3Bs%3A26%3A%22cancellationPolicy_details%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A3%3A%7Bs%3A9%3A%22from_date%22%3Bs%3A17%3A%2218-Jul-2019+05%3A30%22%3Bs%3A13%3A%22agent_charges%22%3Bd%3A4452.424%3Bs%3A16%3A%22supplier_charges%22%3Bi%3A240%3B%7D%7Ds%3A16%3A%22inventory_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A18%3A%22cancellation_hours%22%3Bd%3A8754.5%3Bs%3A6%3A%22office%22%3BN%3Bs%3A16%3A%22comment_contract%22%3Bs%3A30%3A%22Default+Booking+Note%26lt%3Bbr%26gt%3B%22%3Bs%3A21%3A%22applied_agent_charges%22%3Bd%3A4452.424%3B%7D%7D%7D%7D',service = 'hotel',hotel_id = '5f0702acd3a2d15481678987',additional_markup = '0',city_name ='mumbai',total_price ='5565.53',cancelltion_policy ='  
&lt;!-- Added code to display price change while displaying cancelltion rate change in search listing - Swapnil Nagaonkar - 6 November 2014 - START --&gt;
			
&lt;!-- Ended code to display price change while displaying cancelltion rate change in search listing - Swapnil Nagaonkar - 6 November 2014 - END --&gt;

&lt;h2 class=&quot;cancellation&quot; style=&quot;  margin:14px 0px -15px 22px;font-weight:300;font-family: &#039;Source Sans Pro&#039;, sans-serif;color: #4d4d4d; font-size: 26px;&quot;&gt;Cancellation Policy&lt;/h2&gt;
&lt;table width=&quot;100%&quot; border=&quot;0&quot; cellspacing=&quot;5&quot; cellpadding=&quot;0&quot; style=&quot;font-family: &#039;Source Sans Pro&#039;, sans-serif;&quot;&gt;
	&lt;tr&gt;
	&lt;td&gt;
		&lt;table border=&quot;0&quot; width=&quot;100%&quot; align=&quot;center&quot; cellpadding=&quot;0&quot; cellspacing=&quot;10&quot; style=&quot;border: 1px dotted grey;margin-top:20px; color: #8b8e91; font-family: &#039;Source Sans Pro&#039;,sans-serif; font-size: 14px; font-weight: 400; line-height: 18px;&quot;&gt;
		 					&lt;tr&gt;
					&lt;td align=&#039;center&#039;&gt;This hotel is not available for booking. Please select other hotel.&lt;/td&gt;
				&lt;/tr&gt;	
				
		&lt;/table&gt;
		&lt;/td&gt;
	&lt;/tr&gt;
&lt;/table&gt;	
',per_night ='5565.53',room_type ='Prime -Bed & Breakfast : 2 Pax',room_rate ='5565.53';
