[09/19/2020 07:01:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours_add_rate.php],DELETE FROM tour_rates WHERE time_stamp = '832f7ca811c65061b18f1aaedab578fc';
[09/19/2020 07:01:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours_add_rate.php],DELETE FROM tour_rate_profile WHERE time_stamp = '832f7ca811c65061b18f1aaedab578fc';
[09/19/2020 07:01:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours_add_rate.php],INSERT INTO tour_rate_profile SET time_stamp ='7de0c5f03728a60fbd33ad4cb5cfc81e',rate_profile ='2';
[09/19/2020 07:01:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours_add_rate.php],INSERT INTO tour_rate_token(time_stamp,token) VALUES('7de0c5f03728a60fbd33ad4cb5cfc81e','FIT');
[09/19/2020 07:02:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours_add_rate.php],DELETE FROM tour_rates WHERE time_stamp = '7de0c5f03728a60fbd33ad4cb5cfc81e';
[09/19/2020 07:02:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours_add_rate.php],DELETE FROM tour_rate_profile WHERE time_stamp = '7de0c5f03728a60fbd33ad4cb5cfc81e';
[09/19/2020 07:02:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours_add_rate.php],INSERT INTO tour_rate_profile SET time_stamp ='1c0c907594639af2a6b1a2e8da957456',rate_profile ='2';
[09/19/2020 07:02:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours_add_rate.php],INSERT INTO tour_rate_token(time_stamp,token) VALUES('1c0c907594639af2a6b1a2e8da957456','FIT');
[09/19/2020 07:02:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '21' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '3' , ip = '43.250.210.87' , city = 'colombo' , arrival_date='2020/09/28',  departure_date='2020/09/28',  nights='1',  create_date='2020-09-19 :07:02:20',  nationality='3',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='8',  total_children='0',  site_id = '' ;
[09/19/2020 07:02:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '21' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '3' , ip = '43.250.210.87' , city = 'colombo' , arrival_date='2020/09/28',  departure_date='2020/09/28',  nights='1',  create_date='2020-09-19 :07:02:44',  nationality='106',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='4',  total_children='0',  site_id = '' ;
[09/19/2020 07:03:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '21' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '3' , ip = '43.250.210.87' , city = 'colombo' , arrival_date='2020/09/28',  departure_date='2020/09/28',  nights='1',  create_date='2020-09-19 :07:03:24',  nationality='106',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='2',  total_children='0',  site_id = '' ;
[09/19/2020 07:04:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],update tour_rate_slots set availability = '10' where time_stamp in('1c0c907594639af2a6b1a2e8da957456','d4b8e66703b9f3f69a01791aaaf12d7d') and from_slot = '0:00' AND to_slot='2:30' and date_from BETWEEN '2020-09-19' AND '2021-12-31';;
[09/19/2020 07:04:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],update tour_rates set modify_date='2020-09-19', modified_datetime='2020-09-19 07:04:14' where tour_id='2' and supplier_id='S000000003' and time_stamp in ('1c0c907594639af2a6b1a2e8da957456','d4b8e66703b9f3f69a01791aaaf12d7d');
[09/19/2020 07:04:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],insert into email_logs SET `subject`= 'Inventory Modified for Colombo by tuk tuk',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VXNlciA8Yj50Zmc8L2I+IGhhcyBtb2RpZmllZCBpbnZlbnRvcnkgZm9yIENvbG9tYm8gYnkgdHVrIHR1azxicj48YnI+QmVsb3cgYXJlIHRoZSBkZXRhaWxzIDxicj4gPGI+U3VwcGxpZXI8L2I+IDogSmlnbmVzaFNvbmk8YnI+IDxiPlBlcmlvZDwvYj4gOiAyMDIwLTA5LTE5IHRvIDIwMjEtMTItMzE8YnI+PGI+VG91ciBDYXRlZ29yeTwvYj4gOiBGSVQ8YnI+',to_email_id= '',cc= '',bcc= '',status= 'You must provide at least one recipient email address.',page_url= '/tms/tours.php',create_date= '2020-09-19 07:04:14';
[09/19/2020 07:04:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],INSERT INTO mails_error_log set mailfrom='sanket.desai@qtechsoftware.com',mailsubject='Inventory Modified for Colombo by tuk tuk',mailbody='User &lt;b&gt;tfg&lt;/b&gt; has modified inventory for Colombo by tuk tuk&lt;br&gt;&lt;br&gt;Below are the details &lt;br&gt; &lt;b&gt;Supplier&lt;/b&gt; : JigneshSoni&lt;br&gt; &lt;b&gt;Period&lt;/b&gt; : 2020-09-19 to 2021-12-31&lt;br&gt;&lt;b&gt;Tour Category&lt;/b&gt; : FIT&lt;br&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2020-09-19 07:04:14';
[09/19/2020 07:04:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php], insert into email_trigger set  subject ='Inventory Modified for Colombo by tuk tuk',  message='User <b>tfg</b> has modified inventory for Colombo by tuk tuk<br><br>Below are the details <br> <b>Supplier</b> : JigneshSoni<br> <b>Period</b> : 2020-09-19 to 2021-12-31<br><b>Tour Category</b> : FIT<br>',  email_sent ='yes', create_date ='2020-09-19 07:04:14', email_sent_to ='', email_type ='LOCAL_SYSTEM_UPDATES';
[09/19/2020 07:04:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-19 07:04:14',`log_type`= 'Inventory Modified for Colombo by tuk tuk',`sql_query`= 'update tour_rate_slots set availability = \&#039;10\&#039; where time_stamp in(\&#039;1c0c907594639af2a6b1a2e8da957456\&#039;,\&#039;d4b8e66703b9f3f69a01791aaaf12d7d\&#039;) and from_slot = \&#039;0:00\&#039; AND to_slot=\&#039;2:30\&#039; and date_from BETWEEN \&#039;2020-09-19\&#039; AND \&#039;2021-12-31\&#039;;',`log_description`= 'Inventory updated by User tfg for Tour id 2 , Supplier id :S000000003, Date:2020-09-19 to 2021-12-31, Inventory: 10 Tour Category Id: FIT',`ip`= '43.250.210.87';
[09/19/2020 07:04:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],update tour_rate_slots set availability = '10' where time_stamp in('1c0c907594639af2a6b1a2e8da957456','d4b8e66703b9f3f69a01791aaaf12d7d') and from_slot = '11:30' AND to_slot='13:30' and date_from BETWEEN '2020-09-19' AND '2021-12-31';;
[09/19/2020 07:04:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],update tour_rates set modify_date='2020-09-19', modified_datetime='2020-09-19 07:04:14' where tour_id='2' and supplier_id='S000000003' and time_stamp in ('1c0c907594639af2a6b1a2e8da957456','d4b8e66703b9f3f69a01791aaaf12d7d');
[09/19/2020 07:04:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],insert into email_logs SET `subject`= 'Inventory Modified for Colombo by tuk tuk',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VXNlciA8Yj50Zmc8L2I+IGhhcyBtb2RpZmllZCBpbnZlbnRvcnkgZm9yIENvbG9tYm8gYnkgdHVrIHR1azxicj48YnI+QmVsb3cgYXJlIHRoZSBkZXRhaWxzIDxicj4gPGI+U3VwcGxpZXI8L2I+IDogSmlnbmVzaFNvbmk8YnI+IDxiPlBlcmlvZDwvYj4gOiAyMDIwLTA5LTE5IHRvIDIwMjEtMTItMzE8YnI+PGI+VG91ciBDYXRlZ29yeTwvYj4gOiBGSVQ8YnI+',to_email_id= '',cc= '',bcc= '',status= 'You must provide at least one recipient email address.',page_url= '/tms/tours.php',create_date= '2020-09-19 07:04:14';
[09/19/2020 07:04:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],INSERT INTO mails_error_log set mailfrom='sanket.desai@qtechsoftware.com',mailsubject='Inventory Modified for Colombo by tuk tuk',mailbody='User &lt;b&gt;tfg&lt;/b&gt; has modified inventory for Colombo by tuk tuk&lt;br&gt;&lt;br&gt;Below are the details &lt;br&gt; &lt;b&gt;Supplier&lt;/b&gt; : JigneshSoni&lt;br&gt; &lt;b&gt;Period&lt;/b&gt; : 2020-09-19 to 2021-12-31&lt;br&gt;&lt;b&gt;Tour Category&lt;/b&gt; : FIT&lt;br&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2020-09-19 07:04:14';
[09/19/2020 07:04:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php], insert into email_trigger set  subject ='Inventory Modified for Colombo by tuk tuk',  message='User <b>tfg</b> has modified inventory for Colombo by tuk tuk<br><br>Below are the details <br> <b>Supplier</b> : JigneshSoni<br> <b>Period</b> : 2020-09-19 to 2021-12-31<br><b>Tour Category</b> : FIT<br>',  email_sent ='yes', create_date ='2020-09-19 07:04:14', email_sent_to ='', email_type ='LOCAL_SYSTEM_UPDATES';
[09/19/2020 07:04:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-19 07:04:14',`log_type`= 'Inventory Modified for Colombo by tuk tuk',`sql_query`= 'update tour_rate_slots set availability = \&#039;10\&#039; where time_stamp in(\&#039;1c0c907594639af2a6b1a2e8da957456\&#039;,\&#039;d4b8e66703b9f3f69a01791aaaf12d7d\&#039;) and from_slot = \&#039;11:30\&#039; AND to_slot=\&#039;13:30\&#039; and date_from BETWEEN \&#039;2020-09-19\&#039; AND \&#039;2021-12-31\&#039;;',`log_description`= 'Inventory updated by User tfg for Tour id 2 , Supplier id :S000000003, Date:2020-09-19 to 2021-12-31, Inventory: 10 Tour Category Id: FIT',`ip`= '43.250.210.87';
[09/19/2020 07:04:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],update tour_rate_slots set availability = '10' where time_stamp in('1c0c907594639af2a6b1a2e8da957456','d4b8e66703b9f3f69a01791aaaf12d7d') and from_slot = '13:30' AND to_slot='15:30' and date_from BETWEEN '2020-09-19' AND '2021-12-31';;
[09/19/2020 07:04:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],update tour_rates set modify_date='2020-09-19', modified_datetime='2020-09-19 07:04:14' where tour_id='2' and supplier_id='S000000003' and time_stamp in ('1c0c907594639af2a6b1a2e8da957456','d4b8e66703b9f3f69a01791aaaf12d7d');
[09/19/2020 07:04:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],insert into email_logs SET `subject`= 'Inventory Modified for Colombo by tuk tuk',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VXNlciA8Yj50Zmc8L2I+IGhhcyBtb2RpZmllZCBpbnZlbnRvcnkgZm9yIENvbG9tYm8gYnkgdHVrIHR1azxicj48YnI+QmVsb3cgYXJlIHRoZSBkZXRhaWxzIDxicj4gPGI+U3VwcGxpZXI8L2I+IDogSmlnbmVzaFNvbmk8YnI+IDxiPlBlcmlvZDwvYj4gOiAyMDIwLTA5LTE5IHRvIDIwMjEtMTItMzE8YnI+PGI+VG91ciBDYXRlZ29yeTwvYj4gOiBGSVQ8YnI+',to_email_id= '',cc= '',bcc= '',status= 'You must provide at least one recipient email address.',page_url= '/tms/tours.php',create_date= '2020-09-19 07:04:14';
[09/19/2020 07:04:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],INSERT INTO mails_error_log set mailfrom='sanket.desai@qtechsoftware.com',mailsubject='Inventory Modified for Colombo by tuk tuk',mailbody='User &lt;b&gt;tfg&lt;/b&gt; has modified inventory for Colombo by tuk tuk&lt;br&gt;&lt;br&gt;Below are the details &lt;br&gt; &lt;b&gt;Supplier&lt;/b&gt; : JigneshSoni&lt;br&gt; &lt;b&gt;Period&lt;/b&gt; : 2020-09-19 to 2021-12-31&lt;br&gt;&lt;b&gt;Tour Category&lt;/b&gt; : FIT&lt;br&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2020-09-19 07:04:14';
[09/19/2020 07:04:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php], insert into email_trigger set  subject ='Inventory Modified for Colombo by tuk tuk',  message='User <b>tfg</b> has modified inventory for Colombo by tuk tuk<br><br>Below are the details <br> <b>Supplier</b> : JigneshSoni<br> <b>Period</b> : 2020-09-19 to 2021-12-31<br><b>Tour Category</b> : FIT<br>',  email_sent ='yes', create_date ='2020-09-19 07:04:14', email_sent_to ='', email_type ='LOCAL_SYSTEM_UPDATES';
[09/19/2020 07:04:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-19 07:04:15',`log_type`= 'Inventory Modified for Colombo by tuk tuk',`sql_query`= 'update tour_rate_slots set availability = \&#039;10\&#039; where time_stamp in(\&#039;1c0c907594639af2a6b1a2e8da957456\&#039;,\&#039;d4b8e66703b9f3f69a01791aaaf12d7d\&#039;) and from_slot = \&#039;13:30\&#039; AND to_slot=\&#039;15:30\&#039; and date_from BETWEEN \&#039;2020-09-19\&#039; AND \&#039;2021-12-31\&#039;;',`log_description`= 'Inventory updated by User tfg for Tour id 2 , Supplier id :S000000003, Date:2020-09-19 to 2021-12-31, Inventory: 10 Tour Category Id: FIT',`ip`= '43.250.210.87';
[09/19/2020 07:04:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],update tour_rate_slots set availability = '10' where time_stamp in('1c0c907594639af2a6b1a2e8da957456','d4b8e66703b9f3f69a01791aaaf12d7d') and from_slot = '15:30' AND to_slot='17:30' and date_from BETWEEN '2020-09-19' AND '2021-12-31';;
[09/19/2020 07:04:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],update tour_rates set modify_date='2020-09-19', modified_datetime='2020-09-19 07:04:14' where tour_id='2' and supplier_id='S000000003' and time_stamp in ('1c0c907594639af2a6b1a2e8da957456','d4b8e66703b9f3f69a01791aaaf12d7d');
[09/19/2020 07:04:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],insert into email_logs SET `subject`= 'Inventory Modified for Colombo by tuk tuk',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VXNlciA8Yj50Zmc8L2I+IGhhcyBtb2RpZmllZCBpbnZlbnRvcnkgZm9yIENvbG9tYm8gYnkgdHVrIHR1azxicj48YnI+QmVsb3cgYXJlIHRoZSBkZXRhaWxzIDxicj4gPGI+U3VwcGxpZXI8L2I+IDogSmlnbmVzaFNvbmk8YnI+IDxiPlBlcmlvZDwvYj4gOiAyMDIwLTA5LTE5IHRvIDIwMjEtMTItMzE8YnI+PGI+VG91ciBDYXRlZ29yeTwvYj4gOiBGSVQ8YnI+',to_email_id= '',cc= '',bcc= '',status= 'You must provide at least one recipient email address.',page_url= '/tms/tours.php',create_date= '2020-09-19 07:04:15';
[09/19/2020 07:04:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],INSERT INTO mails_error_log set mailfrom='sanket.desai@qtechsoftware.com',mailsubject='Inventory Modified for Colombo by tuk tuk',mailbody='User &lt;b&gt;tfg&lt;/b&gt; has modified inventory for Colombo by tuk tuk&lt;br&gt;&lt;br&gt;Below are the details &lt;br&gt; &lt;b&gt;Supplier&lt;/b&gt; : JigneshSoni&lt;br&gt; &lt;b&gt;Period&lt;/b&gt; : 2020-09-19 to 2021-12-31&lt;br&gt;&lt;b&gt;Tour Category&lt;/b&gt; : FIT&lt;br&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2020-09-19 07:04:15';
[09/19/2020 07:04:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php], insert into email_trigger set  subject ='Inventory Modified for Colombo by tuk tuk',  message='User <b>tfg</b> has modified inventory for Colombo by tuk tuk<br><br>Below are the details <br> <b>Supplier</b> : JigneshSoni<br> <b>Period</b> : 2020-09-19 to 2021-12-31<br><b>Tour Category</b> : FIT<br>',  email_sent ='yes', create_date ='2020-09-19 07:04:15', email_sent_to ='', email_type ='LOCAL_SYSTEM_UPDATES';
[09/19/2020 07:04:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-19 07:04:15',`log_type`= 'Inventory Modified for Colombo by tuk tuk',`sql_query`= 'update tour_rate_slots set availability = \&#039;10\&#039; where time_stamp in(\&#039;1c0c907594639af2a6b1a2e8da957456\&#039;,\&#039;d4b8e66703b9f3f69a01791aaaf12d7d\&#039;) and from_slot = \&#039;15:30\&#039; AND to_slot=\&#039;17:30\&#039; and date_from BETWEEN \&#039;2020-09-19\&#039; AND \&#039;2021-12-31\&#039;;',`log_description`= 'Inventory updated by User tfg for Tour id 2 , Supplier id :S000000003, Date:2020-09-19 to 2021-12-31, Inventory: 10 Tour Category Id: FIT',`ip`= '43.250.210.87';
[09/19/2020 07:04:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],update tour_rate_slots set availability = '10' where time_stamp in('1c0c907594639af2a6b1a2e8da957456','d4b8e66703b9f3f69a01791aaaf12d7d') and from_slot = '17:30' AND to_slot='19:30' and date_from BETWEEN '2020-09-19' AND '2021-12-31';;
[09/19/2020 07:04:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],update tour_rates set modify_date='2020-09-19', modified_datetime='2020-09-19 07:04:14' where tour_id='2' and supplier_id='S000000003' and time_stamp in ('1c0c907594639af2a6b1a2e8da957456','d4b8e66703b9f3f69a01791aaaf12d7d');
[09/19/2020 07:04:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],insert into email_logs SET `subject`= 'Inventory Modified for Colombo by tuk tuk',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VXNlciA8Yj50Zmc8L2I+IGhhcyBtb2RpZmllZCBpbnZlbnRvcnkgZm9yIENvbG9tYm8gYnkgdHVrIHR1azxicj48YnI+QmVsb3cgYXJlIHRoZSBkZXRhaWxzIDxicj4gPGI+U3VwcGxpZXI8L2I+IDogSmlnbmVzaFNvbmk8YnI+IDxiPlBlcmlvZDwvYj4gOiAyMDIwLTA5LTE5IHRvIDIwMjEtMTItMzE8YnI+PGI+VG91ciBDYXRlZ29yeTwvYj4gOiBGSVQ8YnI+',to_email_id= '',cc= '',bcc= '',status= 'You must provide at least one recipient email address.',page_url= '/tms/tours.php',create_date= '2020-09-19 07:04:15';
[09/19/2020 07:04:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],INSERT INTO mails_error_log set mailfrom='sanket.desai@qtechsoftware.com',mailsubject='Inventory Modified for Colombo by tuk tuk',mailbody='User &lt;b&gt;tfg&lt;/b&gt; has modified inventory for Colombo by tuk tuk&lt;br&gt;&lt;br&gt;Below are the details &lt;br&gt; &lt;b&gt;Supplier&lt;/b&gt; : JigneshSoni&lt;br&gt; &lt;b&gt;Period&lt;/b&gt; : 2020-09-19 to 2021-12-31&lt;br&gt;&lt;b&gt;Tour Category&lt;/b&gt; : FIT&lt;br&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2020-09-19 07:04:15';
[09/19/2020 07:04:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php], insert into email_trigger set  subject ='Inventory Modified for Colombo by tuk tuk',  message='User <b>tfg</b> has modified inventory for Colombo by tuk tuk<br><br>Below are the details <br> <b>Supplier</b> : JigneshSoni<br> <b>Period</b> : 2020-09-19 to 2021-12-31<br><b>Tour Category</b> : FIT<br>',  email_sent ='yes', create_date ='2020-09-19 07:04:15', email_sent_to ='', email_type ='LOCAL_SYSTEM_UPDATES';
[09/19/2020 07:04:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-19 07:04:15',`log_type`= 'Inventory Modified for Colombo by tuk tuk',`sql_query`= 'update tour_rate_slots set availability = \&#039;10\&#039; where time_stamp in(\&#039;1c0c907594639af2a6b1a2e8da957456\&#039;,\&#039;d4b8e66703b9f3f69a01791aaaf12d7d\&#039;) and from_slot = \&#039;17:30\&#039; AND to_slot=\&#039;19:30\&#039; and date_from BETWEEN \&#039;2020-09-19\&#039; AND \&#039;2021-12-31\&#039;;',`log_description`= 'Inventory updated by User tfg for Tour id 2 , Supplier id :S000000003, Date:2020-09-19 to 2021-12-31, Inventory: 10 Tour Category Id: FIT',`ip`= '43.250.210.87';
[09/19/2020 07:04:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],update tour_rate_slots set availability = '10' where time_stamp in('1c0c907594639af2a6b1a2e8da957456','d4b8e66703b9f3f69a01791aaaf12d7d') and from_slot = '9:00' AND to_slot='11:30' and date_from BETWEEN '2020-09-19' AND '2021-12-31';;
[09/19/2020 07:04:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],update tour_rates set modify_date='2020-09-19', modified_datetime='2020-09-19 07:04:14' where tour_id='2' and supplier_id='S000000003' and time_stamp in ('1c0c907594639af2a6b1a2e8da957456','d4b8e66703b9f3f69a01791aaaf12d7d');
[09/19/2020 07:04:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],insert into email_logs SET `subject`= 'Inventory Modified for Colombo by tuk tuk',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VXNlciA8Yj50Zmc8L2I+IGhhcyBtb2RpZmllZCBpbnZlbnRvcnkgZm9yIENvbG9tYm8gYnkgdHVrIHR1azxicj48YnI+QmVsb3cgYXJlIHRoZSBkZXRhaWxzIDxicj4gPGI+U3VwcGxpZXI8L2I+IDogSmlnbmVzaFNvbmk8YnI+IDxiPlBlcmlvZDwvYj4gOiAyMDIwLTA5LTE5IHRvIDIwMjEtMTItMzE8YnI+PGI+VG91ciBDYXRlZ29yeTwvYj4gOiBGSVQ8YnI+',to_email_id= '',cc= '',bcc= '',status= 'You must provide at least one recipient email address.',page_url= '/tms/tours.php',create_date= '2020-09-19 07:04:15';
[09/19/2020 07:04:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],INSERT INTO mails_error_log set mailfrom='sanket.desai@qtechsoftware.com',mailsubject='Inventory Modified for Colombo by tuk tuk',mailbody='User &lt;b&gt;tfg&lt;/b&gt; has modified inventory for Colombo by tuk tuk&lt;br&gt;&lt;br&gt;Below are the details &lt;br&gt; &lt;b&gt;Supplier&lt;/b&gt; : JigneshSoni&lt;br&gt; &lt;b&gt;Period&lt;/b&gt; : 2020-09-19 to 2021-12-31&lt;br&gt;&lt;b&gt;Tour Category&lt;/b&gt; : FIT&lt;br&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2020-09-19 07:04:15';
[09/19/2020 07:04:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php], insert into email_trigger set  subject ='Inventory Modified for Colombo by tuk tuk',  message='User <b>tfg</b> has modified inventory for Colombo by tuk tuk<br><br>Below are the details <br> <b>Supplier</b> : JigneshSoni<br> <b>Period</b> : 2020-09-19 to 2021-12-31<br><b>Tour Category</b> : FIT<br>',  email_sent ='yes', create_date ='2020-09-19 07:04:15', email_sent_to ='', email_type ='LOCAL_SYSTEM_UPDATES';
[09/19/2020 07:04:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-19 07:04:15',`log_type`= 'Inventory Modified for Colombo by tuk tuk',`sql_query`= 'update tour_rate_slots set availability = \&#039;10\&#039; where time_stamp in(\&#039;1c0c907594639af2a6b1a2e8da957456\&#039;,\&#039;d4b8e66703b9f3f69a01791aaaf12d7d\&#039;) and from_slot = \&#039;9:00\&#039; AND to_slot=\&#039;11:30\&#039; and date_from BETWEEN \&#039;2020-09-19\&#039; AND \&#039;2021-12-31\&#039;;',`log_description`= 'Inventory updated by User tfg for Tour id 2 , Supplier id :S000000003, Date:2020-09-19 to 2021-12-31, Inventory: 10 Tour Category Id: FIT',`ip`= '43.250.210.87';
[09/19/2020 07:05:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],update tour_rate_slots set availability = '10' where time_stamp in('1c0c907594639af2a6b1a2e8da957456','d4b8e66703b9f3f69a01791aaaf12d7d') and from_slot = '0:00' AND to_slot='2:30' and date_from BETWEEN '2020-09-19' AND '2021-12-31';;
[09/19/2020 07:05:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],update tour_rates set modify_date='2020-09-19', modified_datetime='2020-09-19 07:05:21' where tour_id='2' and supplier_id='S000000003' and time_stamp in ('1c0c907594639af2a6b1a2e8da957456','d4b8e66703b9f3f69a01791aaaf12d7d');
[09/19/2020 07:05:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],insert into email_logs SET `subject`= 'Inventory Modified for Colombo by tuk tuk',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VXNlciA8Yj50Zmc8L2I+IGhhcyBtb2RpZmllZCBpbnZlbnRvcnkgZm9yIENvbG9tYm8gYnkgdHVrIHR1azxicj48YnI+QmVsb3cgYXJlIHRoZSBkZXRhaWxzIDxicj4gPGI+U3VwcGxpZXI8L2I+IDogSmlnbmVzaFNvbmk8YnI+IDxiPlBlcmlvZDwvYj4gOiAyMDIwLTA5LTE5IHRvIDIwMjEtMTItMzE8YnI+PGI+VG91ciBDYXRlZ29yeTwvYj4gOiBGSVQ8YnI+',to_email_id= '',cc= '',bcc= '',status= 'You must provide at least one recipient email address.',page_url= '/tms/tours.php',create_date= '2020-09-19 07:05:21';
[09/19/2020 07:05:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],INSERT INTO mails_error_log set mailfrom='sanket.desai@qtechsoftware.com',mailsubject='Inventory Modified for Colombo by tuk tuk',mailbody='User &lt;b&gt;tfg&lt;/b&gt; has modified inventory for Colombo by tuk tuk&lt;br&gt;&lt;br&gt;Below are the details &lt;br&gt; &lt;b&gt;Supplier&lt;/b&gt; : JigneshSoni&lt;br&gt; &lt;b&gt;Period&lt;/b&gt; : 2020-09-19 to 2021-12-31&lt;br&gt;&lt;b&gt;Tour Category&lt;/b&gt; : FIT&lt;br&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2020-09-19 07:05:21';
[09/19/2020 07:05:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php], insert into email_trigger set  subject ='Inventory Modified for Colombo by tuk tuk',  message='User <b>tfg</b> has modified inventory for Colombo by tuk tuk<br><br>Below are the details <br> <b>Supplier</b> : JigneshSoni<br> <b>Period</b> : 2020-09-19 to 2021-12-31<br><b>Tour Category</b> : FIT<br>',  email_sent ='yes', create_date ='2020-09-19 07:05:21', email_sent_to ='', email_type ='LOCAL_SYSTEM_UPDATES';
[09/19/2020 07:05:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-19 07:05:21',`log_type`= 'Inventory Modified for Colombo by tuk tuk',`sql_query`= 'update tour_rate_slots set availability = \&#039;10\&#039; where time_stamp in(\&#039;1c0c907594639af2a6b1a2e8da957456\&#039;,\&#039;d4b8e66703b9f3f69a01791aaaf12d7d\&#039;) and from_slot = \&#039;0:00\&#039; AND to_slot=\&#039;2:30\&#039; and date_from BETWEEN \&#039;2020-09-19\&#039; AND \&#039;2021-12-31\&#039;;',`log_description`= 'Inventory updated by User tfg for Tour id 2 , Supplier id :S000000003, Date:2020-09-19 to 2021-12-31, Inventory: 10 Tour Category Id: FIT',`ip`= '43.250.210.87';
[09/19/2020 07:05:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],update tour_rate_slots set availability = '10' where time_stamp in('1c0c907594639af2a6b1a2e8da957456','d4b8e66703b9f3f69a01791aaaf12d7d') and from_slot = '11:30' AND to_slot='13:30' and date_from BETWEEN '2020-09-19' AND '2021-12-31';;
[09/19/2020 07:05:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],update tour_rates set modify_date='2020-09-19', modified_datetime='2020-09-19 07:05:21' where tour_id='2' and supplier_id='S000000003' and time_stamp in ('1c0c907594639af2a6b1a2e8da957456','d4b8e66703b9f3f69a01791aaaf12d7d');
[09/19/2020 07:05:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],insert into email_logs SET `subject`= 'Inventory Modified for Colombo by tuk tuk',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VXNlciA8Yj50Zmc8L2I+IGhhcyBtb2RpZmllZCBpbnZlbnRvcnkgZm9yIENvbG9tYm8gYnkgdHVrIHR1azxicj48YnI+QmVsb3cgYXJlIHRoZSBkZXRhaWxzIDxicj4gPGI+U3VwcGxpZXI8L2I+IDogSmlnbmVzaFNvbmk8YnI+IDxiPlBlcmlvZDwvYj4gOiAyMDIwLTA5LTE5IHRvIDIwMjEtMTItMzE8YnI+PGI+VG91ciBDYXRlZ29yeTwvYj4gOiBGSVQ8YnI+',to_email_id= '',cc= '',bcc= '',status= 'You must provide at least one recipient email address.',page_url= '/tms/tours.php',create_date= '2020-09-19 07:05:21';
[09/19/2020 07:05:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],INSERT INTO mails_error_log set mailfrom='sanket.desai@qtechsoftware.com',mailsubject='Inventory Modified for Colombo by tuk tuk',mailbody='User &lt;b&gt;tfg&lt;/b&gt; has modified inventory for Colombo by tuk tuk&lt;br&gt;&lt;br&gt;Below are the details &lt;br&gt; &lt;b&gt;Supplier&lt;/b&gt; : JigneshSoni&lt;br&gt; &lt;b&gt;Period&lt;/b&gt; : 2020-09-19 to 2021-12-31&lt;br&gt;&lt;b&gt;Tour Category&lt;/b&gt; : FIT&lt;br&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2020-09-19 07:05:21';
[09/19/2020 07:05:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php], insert into email_trigger set  subject ='Inventory Modified for Colombo by tuk tuk',  message='User <b>tfg</b> has modified inventory for Colombo by tuk tuk<br><br>Below are the details <br> <b>Supplier</b> : JigneshSoni<br> <b>Period</b> : 2020-09-19 to 2021-12-31<br><b>Tour Category</b> : FIT<br>',  email_sent ='yes', create_date ='2020-09-19 07:05:21', email_sent_to ='', email_type ='LOCAL_SYSTEM_UPDATES';
[09/19/2020 07:05:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-19 07:05:21',`log_type`= 'Inventory Modified for Colombo by tuk tuk',`sql_query`= 'update tour_rate_slots set availability = \&#039;10\&#039; where time_stamp in(\&#039;1c0c907594639af2a6b1a2e8da957456\&#039;,\&#039;d4b8e66703b9f3f69a01791aaaf12d7d\&#039;) and from_slot = \&#039;11:30\&#039; AND to_slot=\&#039;13:30\&#039; and date_from BETWEEN \&#039;2020-09-19\&#039; AND \&#039;2021-12-31\&#039;;',`log_description`= 'Inventory updated by User tfg for Tour id 2 , Supplier id :S000000003, Date:2020-09-19 to 2021-12-31, Inventory: 10 Tour Category Id: FIT',`ip`= '43.250.210.87';
[09/19/2020 07:05:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],update tour_rate_slots set availability = '10' where time_stamp in('1c0c907594639af2a6b1a2e8da957456','d4b8e66703b9f3f69a01791aaaf12d7d') and from_slot = '13:30' AND to_slot='15:30' and date_from BETWEEN '2020-09-19' AND '2021-12-31';;
[09/19/2020 07:05:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],update tour_rates set modify_date='2020-09-19', modified_datetime='2020-09-19 07:05:21' where tour_id='2' and supplier_id='S000000003' and time_stamp in ('1c0c907594639af2a6b1a2e8da957456','d4b8e66703b9f3f69a01791aaaf12d7d');
[09/19/2020 07:05:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],insert into email_logs SET `subject`= 'Inventory Modified for Colombo by tuk tuk',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VXNlciA8Yj50Zmc8L2I+IGhhcyBtb2RpZmllZCBpbnZlbnRvcnkgZm9yIENvbG9tYm8gYnkgdHVrIHR1azxicj48YnI+QmVsb3cgYXJlIHRoZSBkZXRhaWxzIDxicj4gPGI+U3VwcGxpZXI8L2I+IDogSmlnbmVzaFNvbmk8YnI+IDxiPlBlcmlvZDwvYj4gOiAyMDIwLTA5LTE5IHRvIDIwMjEtMTItMzE8YnI+PGI+VG91ciBDYXRlZ29yeTwvYj4gOiBGSVQ8YnI+',to_email_id= '',cc= '',bcc= '',status= 'You must provide at least one recipient email address.',page_url= '/tms/tours.php',create_date= '2020-09-19 07:05:21';
[09/19/2020 07:05:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],INSERT INTO mails_error_log set mailfrom='sanket.desai@qtechsoftware.com',mailsubject='Inventory Modified for Colombo by tuk tuk',mailbody='User &lt;b&gt;tfg&lt;/b&gt; has modified inventory for Colombo by tuk tuk&lt;br&gt;&lt;br&gt;Below are the details &lt;br&gt; &lt;b&gt;Supplier&lt;/b&gt; : JigneshSoni&lt;br&gt; &lt;b&gt;Period&lt;/b&gt; : 2020-09-19 to 2021-12-31&lt;br&gt;&lt;b&gt;Tour Category&lt;/b&gt; : FIT&lt;br&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2020-09-19 07:05:21';
[09/19/2020 07:05:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php], insert into email_trigger set  subject ='Inventory Modified for Colombo by tuk tuk',  message='User <b>tfg</b> has modified inventory for Colombo by tuk tuk<br><br>Below are the details <br> <b>Supplier</b> : JigneshSoni<br> <b>Period</b> : 2020-09-19 to 2021-12-31<br><b>Tour Category</b> : FIT<br>',  email_sent ='yes', create_date ='2020-09-19 07:05:21', email_sent_to ='', email_type ='LOCAL_SYSTEM_UPDATES';
[09/19/2020 07:05:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-19 07:05:22',`log_type`= 'Inventory Modified for Colombo by tuk tuk',`sql_query`= 'update tour_rate_slots set availability = \&#039;10\&#039; where time_stamp in(\&#039;1c0c907594639af2a6b1a2e8da957456\&#039;,\&#039;d4b8e66703b9f3f69a01791aaaf12d7d\&#039;) and from_slot = \&#039;13:30\&#039; AND to_slot=\&#039;15:30\&#039; and date_from BETWEEN \&#039;2020-09-19\&#039; AND \&#039;2021-12-31\&#039;;',`log_description`= 'Inventory updated by User tfg for Tour id 2 , Supplier id :S000000003, Date:2020-09-19 to 2021-12-31, Inventory: 10 Tour Category Id: FIT',`ip`= '43.250.210.87';
[09/19/2020 07:05:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],update tour_rate_slots set availability = '10' where time_stamp in('1c0c907594639af2a6b1a2e8da957456','d4b8e66703b9f3f69a01791aaaf12d7d') and from_slot = '15:30' AND to_slot='17:30' and date_from BETWEEN '2020-09-19' AND '2021-12-31';;
[09/19/2020 07:05:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],update tour_rates set modify_date='2020-09-19', modified_datetime='2020-09-19 07:05:21' where tour_id='2' and supplier_id='S000000003' and time_stamp in ('1c0c907594639af2a6b1a2e8da957456','d4b8e66703b9f3f69a01791aaaf12d7d');
[09/19/2020 07:05:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],insert into email_logs SET `subject`= 'Inventory Modified for Colombo by tuk tuk',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VXNlciA8Yj50Zmc8L2I+IGhhcyBtb2RpZmllZCBpbnZlbnRvcnkgZm9yIENvbG9tYm8gYnkgdHVrIHR1azxicj48YnI+QmVsb3cgYXJlIHRoZSBkZXRhaWxzIDxicj4gPGI+U3VwcGxpZXI8L2I+IDogSmlnbmVzaFNvbmk8YnI+IDxiPlBlcmlvZDwvYj4gOiAyMDIwLTA5LTE5IHRvIDIwMjEtMTItMzE8YnI+PGI+VG91ciBDYXRlZ29yeTwvYj4gOiBGSVQ8YnI+',to_email_id= '',cc= '',bcc= '',status= 'You must provide at least one recipient email address.',page_url= '/tms/tours.php',create_date= '2020-09-19 07:05:22';
[09/19/2020 07:05:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],INSERT INTO mails_error_log set mailfrom='sanket.desai@qtechsoftware.com',mailsubject='Inventory Modified for Colombo by tuk tuk',mailbody='User &lt;b&gt;tfg&lt;/b&gt; has modified inventory for Colombo by tuk tuk&lt;br&gt;&lt;br&gt;Below are the details &lt;br&gt; &lt;b&gt;Supplier&lt;/b&gt; : JigneshSoni&lt;br&gt; &lt;b&gt;Period&lt;/b&gt; : 2020-09-19 to 2021-12-31&lt;br&gt;&lt;b&gt;Tour Category&lt;/b&gt; : FIT&lt;br&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2020-09-19 07:05:22';
[09/19/2020 07:05:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php], insert into email_trigger set  subject ='Inventory Modified for Colombo by tuk tuk',  message='User <b>tfg</b> has modified inventory for Colombo by tuk tuk<br><br>Below are the details <br> <b>Supplier</b> : JigneshSoni<br> <b>Period</b> : 2020-09-19 to 2021-12-31<br><b>Tour Category</b> : FIT<br>',  email_sent ='yes', create_date ='2020-09-19 07:05:22', email_sent_to ='', email_type ='LOCAL_SYSTEM_UPDATES';
[09/19/2020 07:05:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-19 07:05:22',`log_type`= 'Inventory Modified for Colombo by tuk tuk',`sql_query`= 'update tour_rate_slots set availability = \&#039;10\&#039; where time_stamp in(\&#039;1c0c907594639af2a6b1a2e8da957456\&#039;,\&#039;d4b8e66703b9f3f69a01791aaaf12d7d\&#039;) and from_slot = \&#039;15:30\&#039; AND to_slot=\&#039;17:30\&#039; and date_from BETWEEN \&#039;2020-09-19\&#039; AND \&#039;2021-12-31\&#039;;',`log_description`= 'Inventory updated by User tfg for Tour id 2 , Supplier id :S000000003, Date:2020-09-19 to 2021-12-31, Inventory: 10 Tour Category Id: FIT',`ip`= '43.250.210.87';
[09/19/2020 07:05:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],update tour_rate_slots set availability = '10' where time_stamp in('1c0c907594639af2a6b1a2e8da957456','d4b8e66703b9f3f69a01791aaaf12d7d') and from_slot = '17:30' AND to_slot='19:30' and date_from BETWEEN '2020-09-19' AND '2021-12-31';;
[09/19/2020 07:05:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],update tour_rates set modify_date='2020-09-19', modified_datetime='2020-09-19 07:05:21' where tour_id='2' and supplier_id='S000000003' and time_stamp in ('1c0c907594639af2a6b1a2e8da957456','d4b8e66703b9f3f69a01791aaaf12d7d');
[09/19/2020 07:05:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],insert into email_logs SET `subject`= 'Inventory Modified for Colombo by tuk tuk',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VXNlciA8Yj50Zmc8L2I+IGhhcyBtb2RpZmllZCBpbnZlbnRvcnkgZm9yIENvbG9tYm8gYnkgdHVrIHR1azxicj48YnI+QmVsb3cgYXJlIHRoZSBkZXRhaWxzIDxicj4gPGI+U3VwcGxpZXI8L2I+IDogSmlnbmVzaFNvbmk8YnI+IDxiPlBlcmlvZDwvYj4gOiAyMDIwLTA5LTE5IHRvIDIwMjEtMTItMzE8YnI+PGI+VG91ciBDYXRlZ29yeTwvYj4gOiBGSVQ8YnI+',to_email_id= '',cc= '',bcc= '',status= 'You must provide at least one recipient email address.',page_url= '/tms/tours.php',create_date= '2020-09-19 07:05:22';
[09/19/2020 07:05:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],INSERT INTO mails_error_log set mailfrom='sanket.desai@qtechsoftware.com',mailsubject='Inventory Modified for Colombo by tuk tuk',mailbody='User &lt;b&gt;tfg&lt;/b&gt; has modified inventory for Colombo by tuk tuk&lt;br&gt;&lt;br&gt;Below are the details &lt;br&gt; &lt;b&gt;Supplier&lt;/b&gt; : JigneshSoni&lt;br&gt; &lt;b&gt;Period&lt;/b&gt; : 2020-09-19 to 2021-12-31&lt;br&gt;&lt;b&gt;Tour Category&lt;/b&gt; : FIT&lt;br&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2020-09-19 07:05:22';
[09/19/2020 07:05:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php], insert into email_trigger set  subject ='Inventory Modified for Colombo by tuk tuk',  message='User <b>tfg</b> has modified inventory for Colombo by tuk tuk<br><br>Below are the details <br> <b>Supplier</b> : JigneshSoni<br> <b>Period</b> : 2020-09-19 to 2021-12-31<br><b>Tour Category</b> : FIT<br>',  email_sent ='yes', create_date ='2020-09-19 07:05:22', email_sent_to ='', email_type ='LOCAL_SYSTEM_UPDATES';
[09/19/2020 07:05:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-19 07:05:22',`log_type`= 'Inventory Modified for Colombo by tuk tuk',`sql_query`= 'update tour_rate_slots set availability = \&#039;10\&#039; where time_stamp in(\&#039;1c0c907594639af2a6b1a2e8da957456\&#039;,\&#039;d4b8e66703b9f3f69a01791aaaf12d7d\&#039;) and from_slot = \&#039;17:30\&#039; AND to_slot=\&#039;19:30\&#039; and date_from BETWEEN \&#039;2020-09-19\&#039; AND \&#039;2021-12-31\&#039;;',`log_description`= 'Inventory updated by User tfg for Tour id 2 , Supplier id :S000000003, Date:2020-09-19 to 2021-12-31, Inventory: 10 Tour Category Id: FIT',`ip`= '43.250.210.87';
[09/19/2020 07:05:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],update tour_rate_slots set availability = '10' where time_stamp in('1c0c907594639af2a6b1a2e8da957456','d4b8e66703b9f3f69a01791aaaf12d7d') and from_slot = '9:00' AND to_slot='11:30' and date_from BETWEEN '2020-09-19' AND '2021-12-31';;
[09/19/2020 07:05:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],update tour_rates set modify_date='2020-09-19', modified_datetime='2020-09-19 07:05:21' where tour_id='2' and supplier_id='S000000003' and time_stamp in ('1c0c907594639af2a6b1a2e8da957456','d4b8e66703b9f3f69a01791aaaf12d7d');
[09/19/2020 07:05:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],insert into email_logs SET `subject`= 'Inventory Modified for Colombo by tuk tuk',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'VXNlciA8Yj50Zmc8L2I+IGhhcyBtb2RpZmllZCBpbnZlbnRvcnkgZm9yIENvbG9tYm8gYnkgdHVrIHR1azxicj48YnI+QmVsb3cgYXJlIHRoZSBkZXRhaWxzIDxicj4gPGI+U3VwcGxpZXI8L2I+IDogSmlnbmVzaFNvbmk8YnI+IDxiPlBlcmlvZDwvYj4gOiAyMDIwLTA5LTE5IHRvIDIwMjEtMTItMzE8YnI+PGI+VG91ciBDYXRlZ29yeTwvYj4gOiBGSVQ8YnI+',to_email_id= '',cc= '',bcc= '',status= 'You must provide at least one recipient email address.',page_url= '/tms/tours.php',create_date= '2020-09-19 07:05:22';
[09/19/2020 07:05:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],INSERT INTO mails_error_log set mailfrom='sanket.desai@qtechsoftware.com',mailsubject='Inventory Modified for Colombo by tuk tuk',mailbody='User &lt;b&gt;tfg&lt;/b&gt; has modified inventory for Colombo by tuk tuk&lt;br&gt;&lt;br&gt;Below are the details &lt;br&gt; &lt;b&gt;Supplier&lt;/b&gt; : JigneshSoni&lt;br&gt; &lt;b&gt;Period&lt;/b&gt; : 2020-09-19 to 2021-12-31&lt;br&gt;&lt;b&gt;Tour Category&lt;/b&gt; : FIT&lt;br&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2020-09-19 07:05:22';
[09/19/2020 07:05:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php], insert into email_trigger set  subject ='Inventory Modified for Colombo by tuk tuk',  message='User <b>tfg</b> has modified inventory for Colombo by tuk tuk<br><br>Below are the details <br> <b>Supplier</b> : JigneshSoni<br> <b>Period</b> : 2020-09-19 to 2021-12-31<br><b>Tour Category</b> : FIT<br>',  email_sent ='yes', create_date ='2020-09-19 07:05:22', email_sent_to ='', email_type ='LOCAL_SYSTEM_UPDATES';
[09/19/2020 07:05:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-19 07:05:22',`log_type`= 'Inventory Modified for Colombo by tuk tuk',`sql_query`= 'update tour_rate_slots set availability = \&#039;10\&#039; where time_stamp in(\&#039;1c0c907594639af2a6b1a2e8da957456\&#039;,\&#039;d4b8e66703b9f3f69a01791aaaf12d7d\&#039;) and from_slot = \&#039;9:00\&#039; AND to_slot=\&#039;11:30\&#039; and date_from BETWEEN \&#039;2020-09-19\&#039; AND \&#039;2021-12-31\&#039;;',`log_description`= 'Inventory updated by User tfg for Tour id 2 , Supplier id :S000000003, Date:2020-09-19 to 2021-12-31, Inventory: 10 Tour Category Id: FIT',`ip`= '43.250.210.87';
[09/19/2020 07:05:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '21' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '3' , ip = '43.250.210.87' , city = 'colombo' , arrival_date='2020/09/28',  departure_date='2020/09/28',  nights='1',  create_date='2020-09-19 :07:05:48',  nationality='106',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='4',  total_children='0',  site_id = '' ;
[09/19/2020 07:10:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '21' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '3' , ip = '43.250.210.87' , city = 'colombo' , arrival_date='2020/09/28',  departure_date='2020/09/28',  nights='1',  create_date='2020-09-19 :07:10:21',  nationality='106',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='3',  total_children='0',  site_id = '' ;
[09/19/2020 07:12:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],UPDATE tours SET country ='132',city ='71100',area_code='N;',tour_name ='Colombo by tuk tuk',category_id ='3',tour_hightlights ='Colombo is a vibrant, compact and interesting city, rich in culture, history and heritage. There is so much to see and do! The city traffic, however, can be a little unruly at times and the best way to get around the chaos is by taking a tuk tuk. The three-wheeled taxis, fondly known by locals as ‘tuk-tuks’ for the sound of their sputtering little engines, are notoriously fast, easy to park, and can maneuver through the tiny streets of this compact city with ease, making it a great way to experience Colombo’s disorderly charm.',tour_description ='Colombo by tuk tuk is about offering travelers the exhilarating experience of riding a tuk tuk within a safe environment assisted by trained, English-speaking drivers. It is easily, the most fun way to have your own local friend and guide to show you around with their own stories and inherent knowledge of the city. As part of the standard itinerary, a list of ‘non-touristy’, rather rare and quirky recommendations will give you a current and honest sneak-peek into Colombo life.',restriction ='This experience is great for children, and not recommended for kids under 5.',duration ='2.30',min_pax ='1',max_pax ='6',tour_details ='About the Host:
Your tuk tuk guide is an authentic tuk tuk driver by profession and English is his second language. However, he is conversant in English so feel free to ask him whatever you need to, he has been doing this for a while!

What to wear or bring along:
Light, cool clothing, a hat. It gets pretty humid and, during the monsoon, a little messy.

In the know:
Bring a large shawl or sarong to cover your knees and shoulders at religious places.
',bullet ='',terms_n_condition ='',main_image ='1526106909_main_images_(3).jpg',optional_images ='1521010003_op_1_colombo-by-tuk-tuk-slider2.jpg,1521010003_op_2_colombo-by-tuk-tuk-slider3.jpg,1521010003_op_3_colombo-by-tuk-tuk-slider4.jpg,1521010003_op_4_colombo-by-tuk-tuk-slider5.jpg,1521010003_op_5_colombo-by-tuk-tuk-slider1.jpg',admin_view ='',transfer_included ='Y',activity_id ='2',activity_sub_id ='0',weekend ='',code ='',language_code ='',modified_date ='2020-09-19 07:12:18' where tour_id='2';
[09/19/2020 07:12:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],UPDATE near_by_cities SET city_id='71100,71140', modified_datetime='2020-09-19 07:12:18' where service_id='2';
[09/19/2020 07:12:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],delete from tours_includes_excludes where highlight_type ='Includes' and tour_id='2';
[09/19/2020 07:12:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],insert into tours_includes_excludes (tour_id, highlight_type, highlight, create_date)values('2','Includes','A guided tour of Colombo, all entrance tickets, bottled water and refreshments, transport by tuk tuk.',now());
[09/19/2020 07:12:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],delete from tours_includes_excludes where highlight_type ='Excludes' and tour_id='2';
[09/19/2020 07:12:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],insert into tours_includes_excludes (tour_id, highlight_type, highlight, create_date)values('2','Excludes','',now());
[09/19/2020 07:12:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-19 07:12:18',`log_type`= 'Activity Updated',`sql_query`= 'UPDATE tours SET country =\&#039;132\&#039;,city =\&#039;71100\&#039;,area_code=\&#039;N;\&#039;,tour_name =\&#039;Colombo by tuk tuk\&#039;,category_id =\&#039;3\&#039;,tour_hightlights =\&#039;Colombo is a vibrant, compact and interesting city, rich in culture, history and heritage. There is so much to see and do! The city traffic, however, can be a little unruly at times and the best way to get around the chaos is by taking a tuk tuk. The three-wheeled taxis, fondly known by locals as &lsquo;tuk-tuks&rsquo; for the sound of their sputtering little engines, are notoriously fast, easy to park, and can maneuver through the tiny streets of this compact city with ease, making it a great way to experience Colombo&rsquo;s disorderly charm.\&#039;,tour_description =\&#039;Colombo by tuk tuk is about offering travelers the exhilarating experience of riding a tuk tuk within a safe environment assisted by trained, English-speaking drivers. It is easily, the most fun way to have your own local friend and guide to show you around with their own stories and inherent knowledge of the city. As part of the standard itinerary, a list of &lsquo;non-touristy&rsquo;, rather rare and quirky recommendations will give you a current and honest sneak-peek into Colombo life.\&#039;,restriction =\&#039;This experience is great for children, and not recommended for kids under 5.\&#039;,duration =\&#039;2.30\&#039;,min_pax =\&#039;1\&#039;,max_pax =\&#039;6\&#039;,tour_details =\&#039;About the Host:
Your tuk tuk guide is an authentic tuk tuk driver by profession and English is his second language. However, he is conversant in English so feel free to ask him whatever you need to, he has been doing this for a while!

What to wear or bring along:
Light, cool clothing, a hat. It gets pretty humid and, during the monsoon, a little messy.

In the know:
Bring a large shawl or sarong to cover your knees and shoulders at religious places.
\&#039;,bullet =\&#039;\&#039;,terms_n_condition =\&#039;\&#039;,main_image =\&#039;1526106909_main_images_(3).jpg\&#039;,optional_images =\&#039;1521010003_op_1_colombo-by-tuk-tuk-slider2.jpg,1521010003_op_2_colombo-by-tuk-tuk-slider3.jpg,1521010003_op_3_colombo-by-tuk-tuk-slider4.jpg,1521010003_op_4_colombo-by-tuk-tuk-slider5.jpg,1521010003_op_5_colombo-by-tuk-tuk-slider1.jpg\&#039;,admin_view =\&#039;\&#039;,transfer_included =\&#039;Y\&#039;,activity_id =\&#039;2\&#039;,activity_sub_id =\&#039;0\&#039;,weekend =\&#039;\&#039;,code =\&#039;\&#039;,language_code =\&#039;\&#039;,modified_date =\&#039;2020-09-19 07:12:18\&#039; where tour_id=\&#039;2\&#039;',`log_description`= 'Activity Colombo by tuk tuk Updated by User tfg on 2020-09-19 07:12:18',`ip`= '43.250.210.87';
[09/19/2020 07:14:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours_add_rate.php],DELETE FROM tour_rates WHERE time_stamp = '1c0c907594639af2a6b1a2e8da957456';
[09/19/2020 07:14:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours_add_rate.php],DELETE FROM tour_rate_profile WHERE time_stamp = '1c0c907594639af2a6b1a2e8da957456';
[09/19/2020 07:14:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours_add_rate.php],INSERT INTO tour_rate_profile SET time_stamp ='3685242e3931dce7ccf757897338030e',rate_profile ='2';
[09/19/2020 07:14:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours_add_rate.php],INSERT INTO tour_rate_token(time_stamp,token) VALUES('3685242e3931dce7ccf757897338030e','FIT');
[09/19/2020 07:32:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 398;
[09/19/2020 07:32:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO agent_quotation SET q_name = '',email='',contact_no='',unique_id = 'QTECHCA002224',backoffice_user = 'tfg',create_date = '2020-09-19 07:32:25',currency ='INR',service_date='2020/09/29',service_checkout_date='2020/09/29',city_code ='71100',country_code ='132',nationality ='106',total_adult ='6',total_child ='0',child_age ='a%3A0%3A%7B%7D',sequence='3',cancelltion_policy='',rate_description_field='a%3A1%3A%7Bs%3A13%3A%22rate_break_up%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-09-29%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A4%3A%222000%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22120000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A9%3A%22160249.36%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A9%3A%22670.82272%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7D%7D%7D',agent_id = '22',q_info = 'a%3A48%3A%7Bs%3A21%3A%22selected_arrival_date%22%3Bs%3A10%3A%222020%2F09%2F29%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%226%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22SightseeingId%22%3Bs%3A1%3A%222%22%3Bs%3A16%3A%22ResponsecityCode%22%3Bs%3A5%3A%2271100%22%3Bs%3A4%3A%22name%22%3Bs%3A18%3A%22Colombo+by+tuk+tuk%22%3Bs%3A4%3A%22city%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A17%3A%22terms_n_condition%22%3BN%3Bs%3A16%3A%22tour_description%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A11%3A%22restriction%22%3Bs%3A76%3A%22This+experience+is+great+for+children%2C+and+not+recommended+for+kids+under+5.%22%3Bs%3A15%3A%22tour_highlights%22%3Bs%3A538%3A%22Colombo+is+a+vibrant%2C+compact+and+interesting+city%2C+rich+in+culture%2C+history+and+heritage.+There+is+so+much+to+see+and+do%21+The+city+traffic%2C+however%2C+can+be+a+little+unruly+at+times+and+the+best+way+to+get+around+the+chaos+is+by+taking+a+tuk+tuk.+The+three-wheeled+taxis%2C+fondly+known+by+locals+as+%E2%80%98tuk-tuks%E2%80%99+for+the+sound+of+their+sputtering+little+engines%2C+are+notoriously+fast%2C+easy+to+park%2C+and+can+maneuver+through+the+tiny+streets+of+this+compact+city+with+ease%2C+making+it+a+great+way+to+experience+Colombo%E2%80%99s+disorderly+charm.%22%3Bs%3A8%3A%22duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A13%3A%22tourExclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2276%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Excludes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A16%3A%22localsightseeing%22%3Bs%3A13%3A%22pick_up_point%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22drop_off_point%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22slot_type%22%3Bs%3A12%3A%229%3A00%5E%3A%5E11%3A30%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A4%3A%229%3A00%22%3Bs%3A7%3A%22to_slot%22%3Bs%3A5%3A%2211%3A30%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A11%3A%22TourSummary%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A13%3A%22tourInclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2275%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Includes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A101%3A%22A+guided+tour+of+Colombo%2C+all+entrance+tickets%2C+bottled+water+and+refreshments%2C+transport+by+tuk+tuk.%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A12%3A%22thumbNailUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A12%3A%22FullImageUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A10%3A%22160249.360%22%3Bs%3A14%3A%22per_adult_rate%22%3BN%3Bs%3A14%3A%22per_child_rate%22%3BN%3Bs%3A16%3A%22total_adult_rate%22%3Bi%3A0%3Bs%3A16%3A%22total_child_rate%22%3Bi%3A0%3Bs%3A19%3A%22per_adult_agentrate%22%3BN%3Bs%3A19%3A%22per_child_agentrate%22%3BN%3Bs%3A21%3A%22total_adult_agentrate%22%3Bi%3A0%3Bs%3A21%3A%22total_child_agentrate%22%3Bi%3A0%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22fullSingleSightData%22%3Ba%3A53%3A%7Bi%3A0%3Bs%3A10%3A%22160249.360%22%3Bs%3A13%3A%22SightseeingId%22%3Bs%3A1%3A%222%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A9%3A%22date_from%22%3Bs%3A10%3A%222020-09-29%22%3Bs%3A7%3A%22date_to%22%3Bs%3A10%3A%222020-09-29%22%3Bs%3A16%3A%22ResponsecityCode%22%3Bs%3A5%3A%2271100%22%3Bs%3A4%3A%22name%22%3Bs%3A18%3A%22Colombo+by+tuk+tuk%22%3Bs%3A15%3A%22TermsNCondition%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22tour_description%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A11%3A%22restriction%22%3Bs%3A76%3A%22This+experience+is+great+for+children%2C+and+not+recommended+for+kids+under+5.%22%3Bs%3A15%3A%22tour_highlights%22%3Bs%3A538%3A%22Colombo+is+a+vibrant%2C+compact+and+interesting+city%2C+rich+in+culture%2C+history+and+heritage.+There+is+so+much+to+see+and+do%21+The+city+traffic%2C+however%2C+can+be+a+little+unruly+at+times+and+the+best+way+to+get+around+the+chaos+is+by+taking+a+tuk+tuk.+The+three-wheeled+taxis%2C+fondly+known+by+locals+as+%E2%80%98tuk-tuks%E2%80%99+for+the+sound+of+their+sputtering+little+engines%2C+are+notoriously+fast%2C+easy+to+park%2C+and+can+maneuver+through+the+tiny+streets+of+this+compact+city+with+ease%2C+making+it+a+great+way+to+experience+Colombo%E2%80%99s+disorderly+charm.%22%3Bs%3A8%3A%22duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A4%3A%22city%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A12%3A%22total_people%22%3Bs%3A1%3A%226%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A16%3A%22localsightseeing%22%3Bs%3A11%3A%22TourSummary%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A13%3A%22tourInclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2275%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Includes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A101%3A%22A+guided+tour+of+Colombo%2C+all+entrance+tickets%2C+bottled+water+and+refreshments%2C+transport+by+tuk+tuk.%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A13%3A%22tourExclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2276%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Excludes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A7%3A%22to_date%22%3Bs%3A10%3A%222020-09-29%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%226%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22selected_language%22%3Bs%3A1%3A%22E%22%3Bs%3A10%3A%22child_ages%22%3Ba%3A0%3A%7B%7Ds%3A12%3A%22thumbNailUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A12%3A%22FullImageUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%222%22%3Bs%3A12%3A%22actual_adult%22%3Bs%3A1%3A%226%22%3Bs%3A12%3A%22actual_child%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22pick_up_point%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22drop_off_point%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22slot_type%22%3Bs%3A12%3A%229%3A00%5E%3A%5E11%3A30%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A4%3A%229%3A00%22%3Bs%3A7%3A%22to_slot%22%3Bs%3A5%3A%2211%3A30%22%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3Bs%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-09-29%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A4%3A%222000%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22120000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A9%3A%22160249.36%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A9%3A%22670.82272%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7Ds%3A8%3A%22TourTrip%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A14%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22Duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A17%3A%22transfer_included%22%3Bs%3A1%3A%22Y%22%3Bs%3A12%3A%22vehicle_type%22%3Bs%3A7%3A%22private%22%3Bs%3A10%3A%22vehicle_id%22%3Bs%3A1%3A%224%22%3Bs%3A12%3A%22vehicle_name%22%3Bs%3A12%3A%22VAN+6+SEATER%22%3Bs%3A17%3A%22vehicle_type_code%22%3Bs%3A1%3A%224%22%3Bs%3A13%3A%22pick_up_point%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22drop_off_point%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22slot_type%22%3Bs%3A12%3A%229%3A00%5E%3A%5E11%3A30%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A4%3A%229%3A00%22%3Bs%3A7%3A%22to_slot%22%3Bs%3A5%3A%2211%3A30%22%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A13%3A%7Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A10%3A%22160249.360%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A10%3A%22160249.360%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A4%3A%222000%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A4%3A%222000%22%3Bs%3A9%3A%22tour_rate%22%3Bs%3A10%3A%22160249.360%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7D%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A10%3A%22160249.360%22%3Bs%3A16%3A%22total_adult_rate%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22total_child_rate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A3%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A1%3A%224%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A12%3A%22Transfer+Tax%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A2%3A%2215%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A8%3A%2220902.09%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A8%3A%2219347.27%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2216.12%22%3B%7D%7D%7Ds%3A17%3A%22additional_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22RateBreakup%22%3Ba%3A14%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22Duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A17%3A%22transfer_included%22%3Bs%3A1%3A%22Y%22%3Bs%3A12%3A%22vehicle_type%22%3Bs%3A7%3A%22private%22%3Bs%3A10%3A%22vehicle_id%22%3Bs%3A1%3A%224%22%3Bs%3A12%3A%22vehicle_name%22%3Bs%3A12%3A%22VAN+6+SEATER%22%3Bs%3A17%3A%22vehicle_type_code%22%3Bs%3A1%3A%224%22%3Bs%3A13%3A%22pick_up_point%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22drop_off_point%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22slot_type%22%3Bs%3A12%3A%229%3A00%5E%3A%5E11%3A30%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A4%3A%229%3A00%22%3Bs%3A7%3A%22to_slot%22%3Bs%3A5%3A%2211%3A30%22%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A13%3A%7Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A10%3A%22160249.360%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A10%3A%22160249.360%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A4%3A%222000%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A4%3A%222000%22%3Bs%3A9%3A%22tour_rate%22%3Bs%3A10%3A%22160249.360%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7D%7Ds%3A11%3A%22tax_details%22%3Ba%3A3%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A1%3A%224%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A12%3A%22Transfer+Tax%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A2%3A%2215%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A8%3A%2220902.09%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A8%3A%2219347.27%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2216.12%22%3B%7D%7D%7D',service = 'sightseeing',hotel_id = '2',additional_markup = '33.541136',city_name ='Colombo',leader_name =' ',salutation ='Mr',first_name ='',last_name ='',quotation_type ='back_end',enquiry_id ='398',total_price ='160249.360';
[09/19/2020 07:32:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1839', q_name='', service='sightseeing', agent_id='22', create_date='2020-09-19 07:32:25', q_info='a%3A48%3A%7Bs%3A21%3A%22selected_arrival_date%22%3Bs%3A10%3A%222020%2F09%2F29%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%226%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22SightseeingId%22%3Bs%3A1%3A%222%22%3Bs%3A16%3A%22ResponsecityCode%22%3Bs%3A5%3A%2271100%22%3Bs%3A4%3A%22name%22%3Bs%3A18%3A%22Colombo+by+tuk+tuk%22%3Bs%3A4%3A%22city%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A17%3A%22terms_n_condition%22%3BN%3Bs%3A16%3A%22tour_description%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A11%3A%22restriction%22%3Bs%3A76%3A%22This+experience+is+great+for+children%2C+and+not+recommended+for+kids+under+5.%22%3Bs%3A15%3A%22tour_highlights%22%3Bs%3A538%3A%22Colombo+is+a+vibrant%2C+compact+and+interesting+city%2C+rich+in+culture%2C+history+and+heritage.+There+is+so+much+to+see+and+do%21+The+city+traffic%2C+however%2C+can+be+a+little+unruly+at+times+and+the+best+way+to+get+around+the+chaos+is+by+taking+a+tuk+tuk.+The+three-wheeled+taxis%2C+fondly+known+by+locals+as+%E2%80%98tuk-tuks%E2%80%99+for+the+sound+of+their+sputtering+little+engines%2C+are+notoriously+fast%2C+easy+to+park%2C+and+can+maneuver+through+the+tiny+streets+of+this+compact+city+with+ease%2C+making+it+a+great+way+to+experience+Colombo%E2%80%99s+disorderly+charm.%22%3Bs%3A8%3A%22duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A13%3A%22tourExclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2276%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Excludes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A16%3A%22localsightseeing%22%3Bs%3A13%3A%22pick_up_point%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22drop_off_point%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22slot_type%22%3Bs%3A12%3A%229%3A00%5E%3A%5E11%3A30%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A4%3A%229%3A00%22%3Bs%3A7%3A%22to_slot%22%3Bs%3A5%3A%2211%3A30%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A11%3A%22TourSummary%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A13%3A%22tourInclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2275%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Includes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A101%3A%22A+guided+tour+of+Colombo%2C+all+entrance+tickets%2C+bottled+water+and+refreshments%2C+transport+by+tuk+tuk.%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A12%3A%22thumbNailUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A12%3A%22FullImageUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A10%3A%22160249.360%22%3Bs%3A14%3A%22per_adult_rate%22%3BN%3Bs%3A14%3A%22per_child_rate%22%3BN%3Bs%3A16%3A%22total_adult_rate%22%3Bi%3A0%3Bs%3A16%3A%22total_child_rate%22%3Bi%3A0%3Bs%3A19%3A%22per_adult_agentrate%22%3BN%3Bs%3A19%3A%22per_child_agentrate%22%3BN%3Bs%3A21%3A%22total_adult_agentrate%22%3Bi%3A0%3Bs%3A21%3A%22total_child_agentrate%22%3Bi%3A0%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22fullSingleSightData%22%3Ba%3A53%3A%7Bi%3A0%3Bs%3A10%3A%22160249.360%22%3Bs%3A13%3A%22SightseeingId%22%3Bs%3A1%3A%222%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A9%3A%22date_from%22%3Bs%3A10%3A%222020-09-29%22%3Bs%3A7%3A%22date_to%22%3Bs%3A10%3A%222020-09-29%22%3Bs%3A16%3A%22ResponsecityCode%22%3Bs%3A5%3A%2271100%22%3Bs%3A4%3A%22name%22%3Bs%3A18%3A%22Colombo+by+tuk+tuk%22%3Bs%3A15%3A%22TermsNCondition%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22tour_description%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A11%3A%22restriction%22%3Bs%3A76%3A%22This+experience+is+great+for+children%2C+and+not+recommended+for+kids+under+5.%22%3Bs%3A15%3A%22tour_highlights%22%3Bs%3A538%3A%22Colombo+is+a+vibrant%2C+compact+and+interesting+city%2C+rich+in+culture%2C+history+and+heritage.+There+is+so+much+to+see+and+do%21+The+city+traffic%2C+however%2C+can+be+a+little+unruly+at+times+and+the+best+way+to+get+around+the+chaos+is+by+taking+a+tuk+tuk.+The+three-wheeled+taxis%2C+fondly+known+by+locals+as+%E2%80%98tuk-tuks%E2%80%99+for+the+sound+of+their+sputtering+little+engines%2C+are+notoriously+fast%2C+easy+to+park%2C+and+can+maneuver+through+the+tiny+streets+of+this+compact+city+with+ease%2C+making+it+a+great+way+to+experience+Colombo%E2%80%99s+disorderly+charm.%22%3Bs%3A8%3A%22duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A4%3A%22city%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A12%3A%22total_people%22%3Bs%3A1%3A%226%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A16%3A%22localsightseeing%22%3Bs%3A11%3A%22TourSummary%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A13%3A%22tourInclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2275%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Includes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A101%3A%22A+guided+tour+of+Colombo%2C+all+entrance+tickets%2C+bottled+water+and+refreshments%2C+transport+by+tuk+tuk.%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A13%3A%22tourExclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2276%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Excludes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A7%3A%22to_date%22%3Bs%3A10%3A%222020-09-29%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%226%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22selected_language%22%3Bs%3A1%3A%22E%22%3Bs%3A10%3A%22child_ages%22%3Ba%3A0%3A%7B%7Ds%3A12%3A%22thumbNailUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A12%3A%22FullImageUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%222%22%3Bs%3A12%3A%22actual_adult%22%3Bs%3A1%3A%226%22%3Bs%3A12%3A%22actual_child%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22pick_up_point%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22drop_off_point%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22slot_type%22%3Bs%3A12%3A%229%3A00%5E%3A%5E11%3A30%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A4%3A%229%3A00%22%3Bs%3A7%3A%22to_slot%22%3Bs%3A5%3A%2211%3A30%22%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3Bs%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-09-29%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A4%3A%222000%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22120000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A9%3A%22160249.36%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A9%3A%22670.82272%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7Ds%3A8%3A%22TourTrip%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A14%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22Duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A17%3A%22transfer_included%22%3Bs%3A1%3A%22Y%22%3Bs%3A12%3A%22vehicle_type%22%3Bs%3A7%3A%22private%22%3Bs%3A10%3A%22vehicle_id%22%3Bs%3A1%3A%224%22%3Bs%3A12%3A%22vehicle_name%22%3Bs%3A12%3A%22VAN+6+SEATER%22%3Bs%3A17%3A%22vehicle_type_code%22%3Bs%3A1%3A%224%22%3Bs%3A13%3A%22pick_up_point%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22drop_off_point%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22slot_type%22%3Bs%3A12%3A%229%3A00%5E%3A%5E11%3A30%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A4%3A%229%3A00%22%3Bs%3A7%3A%22to_slot%22%3Bs%3A5%3A%2211%3A30%22%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A13%3A%7Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A10%3A%22160249.360%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A10%3A%22160249.360%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A4%3A%222000%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A4%3A%222000%22%3Bs%3A9%3A%22tour_rate%22%3Bs%3A10%3A%22160249.360%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7D%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A10%3A%22160249.360%22%3Bs%3A16%3A%22total_adult_rate%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22total_child_rate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A3%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A1%3A%224%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A12%3A%22Transfer+Tax%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A2%3A%2215%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A8%3A%2220902.09%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A8%3A%2219347.27%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2216.12%22%3B%7D%7D%7Ds%3A17%3A%22additional_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22RateBreakup%22%3Ba%3A14%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22Duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A17%3A%22transfer_included%22%3Bs%3A1%3A%22Y%22%3Bs%3A12%3A%22vehicle_type%22%3Bs%3A7%3A%22private%22%3Bs%3A10%3A%22vehicle_id%22%3Bs%3A1%3A%224%22%3Bs%3A12%3A%22vehicle_name%22%3Bs%3A12%3A%22VAN+6+SEATER%22%3Bs%3A17%3A%22vehicle_type_code%22%3Bs%3A1%3A%224%22%3Bs%3A13%3A%22pick_up_point%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22drop_off_point%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22slot_type%22%3Bs%3A12%3A%229%3A00%5E%3A%5E11%3A30%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A4%3A%229%3A00%22%3Bs%3A7%3A%22to_slot%22%3Bs%3A5%3A%2211%3A30%22%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A13%3A%7Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A10%3A%22160249.360%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A10%3A%22160249.360%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A4%3A%222000%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A4%3A%222000%22%3Bs%3A9%3A%22tour_rate%22%3Bs%3A10%3A%22160249.360%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7D%7Ds%3A11%3A%22tax_details%22%3Ba%3A3%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A1%3A%224%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A12%3A%22Transfer+Tax%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A2%3A%2215%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A8%3A%2220902.09%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A8%3A%2219347.27%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2216.12%22%3B%7D%7D%7D', city_name='Colombo', hotel_id='2', additional_markup='34', cancelltion_policy='', per_night=NULL, total_price='160249.36', room_type=NULL, room_rate=NULL, currency='INR', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2020-09-19 07:32:25', status='A', is_visible='1', is_optional='0', unique_id='QTECHCA002224', service_date='2020-09-29 00:00:00', service_checkout_date='2020-09-29 00:00:00', city_code='71100', country_code='132', nationality='106', total_adult='6', total_child='0', child_age='a%3A0%3A%7B%7D', leader_name=' ', salutation='Mr', first_name='', last_name='', email='', contact_no='', enquiry_id='398', quotation_status='edited', sequence='3', rate_description_field='a%3A1%3A%7Bs%3A13%3A%22rate_break_up%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-09-29%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A4%3A%222000%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22120000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A9%3A%22160249.36%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A9%3A%22670.82272%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7D%7D%7D';
[09/19/2020 07:32:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_itinerary SET quote_id='1839', service_id='2', service_type='sightseeing',service_date='2020-09-29', sequence='3';
[09/19/2020 07:32:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_description SET quote_id='1839', service_date='2020-09-29';
[09/19/2020 07:32:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='drafted' WHERE unique_id='QTECHCA002224' AND quotation_status!='booked';
[09/19/2020 07:40:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours_add_rate.php],DELETE FROM tour_rates WHERE time_stamp = '3685242e3931dce7ccf757897338030e';
[09/19/2020 07:40:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours_add_rate.php],DELETE FROM tour_rate_profile WHERE time_stamp = '3685242e3931dce7ccf757897338030e';
[09/19/2020 07:40:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours_add_rate.php],INSERT INTO tour_rate_profile SET time_stamp ='bd3dd1507157bad27ca2c8001ee571fc',rate_profile ='2';
[09/19/2020 07:40:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tours_add_rate.php],INSERT INTO tour_rate_token(time_stamp,token) VALUES('bd3dd1507157bad27ca2c8001ee571fc','FIT');
