[07/20/2020 11:09:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO customers SET first_name='Snehal', last_name='Valanju', email='',address='', mobile='7208049265',phone='',country='106', create_date='2020-07-20 11:09:47';;
[07/20/2020 11:09:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO enquiry SET email_id = '', contact_first_name = 'Snehal', contact_last_name = 'Valanju', contact_name = 'Snehal Valanju', contact_no = '7208049265', is_travel_agent = 'no', enquiry_source = 'direct', residing_country = '106', group_name = 'Valanju', group_type = 'Family', num_pax_adults = '10', num_pax_children = '5', num_pax_infants = '1', currency = 'USD', budget_minimum = '1000', budget_maximum = '2000', service_hotel = '1', service_tour = '1', service_transfer = '1', service_misc = '1', service_flight = 'no', service_carrental = 'no', service_packages = 'no', destination = '132', destination_city = '71129', month = '11', week = '2', duration = '1', group_amenities = '3,6,7,8,22', hotel_star_rating = '3', meals_type = '5', hotel_type = '1', transfer_type = 'sic', transfer_is_arrival = '1', transfer_is_departure = '1', check_in_date = '2020-11-18', check_out_date = '2020-11-19', customer_id = '62', created_by = 'tfg', create_date= '2020-07-20 11:09:47';
[07/20/2020 11:09:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO task SET module_id='367',module='enquiry',task_status='open',status='A',create_date='2020-07-20 11:09:47' ,created_by='tfg', task_priority='medium', task_description='Offline Quotation Enquiry has been added by tfg&lt;br/&gt;Group Name : Valanju&lt;br/&gt;Group : Family&lt;br/&gt;Checkin Date : 18-11-2020&lt;br/&gt;Checkout Date : 19-11-2020&lt;br/&gt;Country : Sri Lanka&lt;br/&gt;City : Bentota&lt;br/&gt;Selected Currency : USD&lt;br/&gt;Adult : 10&lt;br/&gt;Child : 5&lt;br/&gt;Infant : 1&lt;br/&gt;Budget : 1000 - 2000&lt;br/&gt;';
[07/20/2020 11:09:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE task SET assigned_to='',modified_date='2020-07-20 11:09:49' WHERE module_id='367' AND module='enquiry';;
[07/20/2020 11:09:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-20 11:09:49',`log_type`= 'Enquiry Assigned',`sql_query`= '',`log_description`= '',`ip`= '60.254.42.40';
[07/20/2020 11:09:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],insert into user_log_link Set `user_logs_id`='3363', `entity`='EnquiryId', `value`='367' ;
[07/20/2020 11:11:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE customers SET first_name='Snehal', last_name='Valanju', email='',address='', mobile='7208049265',phone='',country='106', modify_date='2020-07-20 11:11:12' WHERE id='62';;
[07/20/2020 11:11:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry SET email_id = '', contact_first_name = 'Snehal', contact_last_name = 'Valanju', contact_name = 'Snehal Valanju', contact_no = '7208049265',is_travel_agent = 'no', enquiry_source = 'direct', residing_country = '106', group_name = 'Valanju', group_type = 'Family', num_pax_adults = '10', num_pax_children = '5', num_pax_infants = '1', currency = 'USD', budget_minimum = '1000', budget_maximum = '2000', service_hotel = '1', service_tour = 'no', service_transfer = '1', service_misc = '1', service_flight = 'no', service_carrental = 'no', service_packages = 'no', destination = '132', destination_city = '71129', month = '11', week = '2', duration = '1', group_amenities = '3,6,7,8,22', hotel_star_rating = '3', meals_type = '5', hotel_type = '1', transfer_is_arrival = '1', transfer_is_departure = '1', check_in_date = '2020-11-18', check_out_date = '2020-11-25', modified_by = 'tfg', modified_date= '2020-07-20 11:11:12'  where id= '367';

[07/20/2020 11:14:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'24' , cal_hashcode='f8dcd7568a176d441a689632c36837'24'cee'24'4eef'24'74ece826d78c221872dd855f' ,cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ? and site_id = ''24'';
[07/20/2020 11:14:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into email_logs SET `subject`= 'Registration Acknowledgement - Agent ID - 24 The Fabulous Getaway',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 20404 characters]',to_email_id= 'ankita.rao@qtechsoftware.com,snehal.valanju@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/agent.php?branch_search=&consultant_search=&agent_type_search=&country_srch=&agency_name_search=&username_search=&status_search=&person_name_search=&search=&country_search=&city_search=&currency_search=&rate_profile_search=&email_search=&agency_id_search=',create_date= '2020-07-20 11:14:20';
[07/20/2020 11:18:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE customers SET first_name='Snehal', last_name='Valanju', email='',address='', mobile='7208049265',phone='',country='106', modify_date='2020-07-20 11:18:00' WHERE id='62';;
[07/20/2020 11:18:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry SET email_id = '', contact_first_name = 'Snehal', contact_last_name = 'Valanju', contact_name = 'Snehal Valanju', contact_no = '7208049265',is_travel_agent = 'no', enquiry_source = 'direct', residing_country = '106', group_name = 'Valanju', group_type = 'Family', num_pax_adults = '10', num_pax_children = '5', num_pax_infants = '1', currency = 'USD', budget_minimum = '1000', budget_maximum = '2000', service_hotel = '1', service_tour = 'no', service_transfer = '1', service_misc = '1', service_flight = 'no', service_carrental = 'no', service_packages = 'no', destination = '132', destination_city = '71129', month = '11', week = '2', duration = '1', group_amenities = '3,6,7,8,22', hotel_star_rating = '3', meals_type = '5', hotel_type = '1', transfer_is_arrival = '1', transfer_is_departure = '1', check_in_date = '2020-11-18', check_out_date = '2020-11-25', modified_by = 'tfg', modified_date= '2020-07-20 11:18:00'  where id= '367';
[07/20/2020 11:21:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE customers SET first_name='Snehal', last_name='Valanju', email='',address='', mobile='7208049265',phone='',country='106', modify_date='2020-07-20 11:21:56' WHERE id='62';;
[07/20/2020 11:21:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry SET email_id = '', contact_first_name = 'Snehal', contact_last_name = 'Valanju', contact_name = 'Snehal Valanju', contact_no = '7208049265',is_travel_agent = 'no', enquiry_source = 'direct', residing_country = '106', group_name = 'Valanju', group_type = 'Family', num_pax_adults = '10', num_pax_children = '5', num_pax_infants = '1', currency = 'USD', budget_minimum = '1000', budget_maximum = '2000', service_hotel = '1', service_tour = 'no', service_transfer = '1', service_misc = '1', service_flight = 'no', service_carrental = 'no', service_packages = 'no', destination = '132', destination_city = '71129', month = '11', week = '2', duration = '1', group_amenities = '3,6,7,8,22', hotel_star_rating = '3', meals_type = '5', hotel_type = '1', transfer_is_arrival = '1', transfer_is_departure = '1', check_in_date = '2020-11-18', check_out_date = '2020-11-25', modified_by = 'tfg', modified_date= '2020-07-20 11:21:56'  where id= '367';
[07/20/2020 11:25:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO enquiry SET email_id = '', contact_first_name = 'Snehal', contact_last_name = 'Valanju', contact_name = 'Snehal Valanju', contact_no = '7208049265', is_travel_agent = 'no', enquiry_source = 'email', residing_country = '106', group_name = 'CAP Group', group_type = 'Corporate', num_pax_adults = '10', num_pax_children = '5', num_pax_infants = '1', currency = 'USD', budget_minimum = '1000', budget_maximum = '1500', service_hotel = '1', service_tour = '1', service_transfer = '1', service_misc = '1', service_flight = 'no', service_carrental = 'no', service_packages = 'no', destination = '132', destination_city = '71100', month = '9', week = '1', duration = '8', hotel_star_rating = '4', meals_type = '5', hotel_type = '2', transfer_type = 'private per pax', transfer_is_arrival = '1', transfer_is_departure = '1', check_in_date = '2020-09-08', check_out_date = '2020-09-16', customer_id = '62', created_by = 'tfg', create_date= '2020-07-20 11:25:29';
[07/20/2020 11:25:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO task SET module_id='368',module='enquiry',task_status='open',status='A',create_date='2020-07-20 11:25:29' ,created_by='tfg', task_priority='medium', task_description='Offline Quotation Enquiry has been added by tfg&lt;br/&gt;Group Name : CAP Group&lt;br/&gt;Group : Corporate&lt;br/&gt;Checkin Date : 08-09-2020&lt;br/&gt;Checkout Date : 16-09-2020&lt;br/&gt;Country : Sri Lanka&lt;br/&gt;City : Colombo&lt;br/&gt;Selected Currency : USD&lt;br/&gt;Adult : 10&lt;br/&gt;Child : 5&lt;br/&gt;Infant : 1&lt;br/&gt;Budget : 1000 - 1500&lt;br/&gt;';
[07/20/2020 11:25:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE task SET assigned_to='',modified_date='2020-07-20 11:25:29' WHERE module_id='368' AND module='enquiry';;
[07/20/2020 11:25:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-20 11:25:29',`log_type`= 'Enquiry Assigned',`sql_query`= '',`log_description`= '',`ip`= '60.254.42.40';
[07/20/2020 11:25:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],insert into user_log_link Set `user_logs_id`='3364', `entity`='EnquiryId', `value`='368' ;
[07/20/2020 11:26:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE customers SET first_name='Snehal', last_name='Valanju', email='',address='', mobile='7208049265',phone='',country='106', modify_date='2020-07-20 11:26:03' WHERE id='62';;
[07/20/2020 11:26:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry SET email_id = '', contact_first_name = 'Snehal', contact_last_name = 'Valanju', contact_name = 'Snehal Valanju', contact_no = '7208049265',is_travel_agent = 'no', enquiry_source = 'direct', residing_country = '106', group_name = 'Valanju', group_type = 'Family', num_pax_adults = '10', num_pax_children = '5', num_pax_infants = '1', currency = 'USD', budget_minimum = '1000', budget_maximum = '2000', service_hotel = '1', service_tour = 'no', service_transfer = '1', service_misc = '1', service_flight = 'no', service_carrental = 'no', service_packages = 'no', destination = '132', destination_city = '71129', month = '11', week = '2', duration = '1', group_amenities = '3,6,7,8,22', hotel_star_rating = '3', meals_type = '5', hotel_type = '1', transfer_is_arrival = '1', transfer_is_departure = '1', check_in_date = '2020-11-18', check_out_date = '2020-11-25', modified_by = 'tfg', modified_date= '2020-07-20 11:26:04'  where id= '367';
[07/20/2020 11:27:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE task SET assigned_to='salesconsultant',modified_date='2020-07-20 11:27:07' WHERE module_id='367' AND module='enquiry';;
[07/20/2020 11:27:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-20 11:27:07',`log_type`= 'Enquiry Assigned',`sql_query`= '',`log_description`= '',`ip`= '60.254.42.40';
[07/20/2020 11:27:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],insert into user_log_link Set `user_logs_id`='3365', `entity`='EnquiryId', `value`='367' ;
[07/20/2020 11:27:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE customers SET salutations='Mr',first_name='Snehal', last_name='Valanju', email='',address='', mobile='7208049265', modify_date='2020-07-20 11:27:52' WHERE id='62';;
[07/20/2020 11:27:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry SET agent_id = '24', contact_salutation = 'Mr', contact_first_name = 'Snehal', contact_last_name = 'Valanju', contact_name = 'Snehal Valanju', contact_no = '7208049265', residing_country = '106', currency = 'USD', enquiry_source = 'direct', destination = '132', nationality = '106', customer_id = '62',modified_by = 'tfg', modified_date= '2020-07-20 11:27:52'  where id = '367';
[07/20/2020 11:30:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE customers SET salutations='Mr',first_name='Snehal', last_name='Valanju', email='',address='', mobile='7208049265', modify_date='2020-07-20 11:30:54' WHERE id='62';;
[07/20/2020 11:30:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry SET agent_id = '24', contact_salutation = 'Mr', contact_first_name = 'Snehal', contact_last_name = 'Valanju', contact_name = 'Snehal Valanju', contact_no = '7208049265', residing_country = '106', currency = 'USD', enquiry_source = 'direct', destination = '132', nationality = '106', customer_id = '62',modified_by = 'tfg', modified_date= '2020-07-20 11:30:54'  where id = '367';
[07/20/2020 11:31:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.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-20 11:31:38', '', '', '');
[07/20/2020 11:31:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.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-20 11:31:56', '', '', '');
[07/20/2020 11:44:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_supplier_mapping.php],DELETE from hotel_supplier_mapping WHERE SupplierId= 'S000000078' AND city_code= '71129' AND country_code= '132';
[07/20/2020 11:44:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_supplier_mapping.php],INSERT INTO hotel_supplier_mapping SET SupplierId = 'S000000078',hotel_id = '53704',city_code = '71129',country_code = '132';
[07/20/2020 11:44:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_supplier_mapping.php],INSERT INTO hotel_supplier_mapping SET SupplierId = 'S000000078',hotel_id = '53707',city_code = '71129',country_code = '132';
[07/20/2020 11:44:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_supplier_mapping.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-20 11:44:49',`log_type`= 'Hotel Supplier Mapping Updated',`sql_query`= ' ------ INSERT INTO hotel_supplier_mapping SET SupplierId = \&#039;S000000078\&#039;,hotel_id = \&#039;53704\&#039;,city_code = \&#039;71129\&#039;,country_code = \&#039;132\&#039; ------ INSERT INTO hotel_supplier_mapping SET SupplierId = \&#039;S000000078\&#039;,hotel_id = \&#039;53707\&#039;,city_code = \&#039;71129\&#039;,country_code = \&#039;132\&#039;',`log_description`= 'Hotel Supplier Mapping Updated for Supplier  : S000000078, City : 71129, Country : 132, Hotels are : 53704,53707',`ip`= '60.254.42.40';
[07/20/2020 11:44:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_supplier_mapping.php],insert into user_log_link Set `user_logs_id`='3366', `entity`='Suppliers', `value`='S000000078' ;
