

[08/06/2020 09:21:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='3544', `entity`='Agents', `value`='25' ;
[08/06/2020 09:21:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into email_logs SET `subject`= 'Agent Changed Password - The Fabulous Getaway',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 9004 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/agent.php',create_date= '2020-08-06 09:21:53';
[08/06/2020 09:24:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-08-06 09:24:28',login_attempt=0 where id = '25';
[08/06/2020 09:24:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'PHPTEST', user_type = 'A', branch_id = '1', login_datetime = '2020-08-06 09:24:28', ip = '60.254.42.39', action = 'Login' ;
[08/06/2020 09:26:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-08-06 09:26:43',login_attempt=0 where id = '25';
[08/06/2020 09:26:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'PHPTEST', user_type = 'A', branch_id = '1', login_datetime = '2020-08-06 09:26:43', ip = '60.254.42.39', action = 'Login' ;
[08/06/2020 09:27:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-08-06 09:27:03',login_attempt=0 where id = '25';
[08/06/2020 09:27:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'PHPTEST', user_type = 'A', branch_id = '1', login_datetime = '2020-08-06 09:27:03', ip = '60.254.42.39', action = 'Login' ;
[08/06/2020 09:28:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/user.php],update psa_users set pass= '72149224ce1b272a688573eef8979206', modify_date= '2020-08-06 09:28:41',modify_by= 'tfg' where id = 'accounts';

[08/06/2020 09:29:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/user.php],update  `psa_users` set  `consultant_acc_id` ='', `lname`='SriLanka', `mname`='', `fname`='Accounts', `email`='ankita.rao@qtechsoftware.com', `time_zone_offset`='5.5', `phone`='2111111111', `messenger_type`='', `messenger_id`='', `user_description`='', `connection`='', `modify_by`='tfg', `user_type`='admin', `allow_book_under_cancellation`='1', `allow_cancellation_after_voucher`='1', `is_booking_email_received`='1', `all_bookings`='branch_booking', `designation`='', `updated`='2020-08-06 09:29:20', `modify_date`='2020-08-06 09:29:20'  where `site_id`='' and `id` ='accounts' ;
[08/06/2020 09:29:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/user.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-06 09:29:20',`log_type`= 'User',`sql_query`= 'update  `psa_users` set  `consultant_acc_id` =:accounting_id, `lname`=:last_name, `mname`=:middle_name, `fname`=:first_name, `email`=:email, `time_zone_offset`=:time_zone_offset, `phone`=:phone, `messenger_type`=:messenger_type, `messenger_id`=:messenger_id, `user_description`=:user_description, `connection`=:connection, `modify_by`=:modify_by, `user_type`=:user_type, `allow_book_under_cancellation`=:allow_book_under_cancellation, `allow_cancellation_after_voucher`=:allow_cancellation_after_voucher, `is_booking_email_received`=:is_booking_email_received, `all_bookings`=:all_bookings, `designation`=:designation, `updated`=:updated, `modify_date`=:modify_date  where `site_id`=:site_id and `id` =:user_id ',`log_description`= 'User accounts updated For  - updated=2020-07-06+09%3A25%3A17&modify_date=2020-08-06+09%3A28%3A41 changed to - updated=2020-08-06+09%3A29%3A20&modify_date=2020-08-06+09%3A29%3A20',`ip`= '60.254.42.39';
[08/06/2020 09:30:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/news_letter.php],INSERT INTO news_letter set phone= '',name= '',email_id= 'snehal.valanju@qtechsoftware.com',create_date= '2020-08-06 09:30:44',referer= 'http://uat.tfg.otrams.net/index.php',ip_address= '60.254.42.39';
[08/06/2020 09:30:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/news_letter.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'PGJyPi0tLS0tLS0tLSAKCjxicj5FcnJvcjoKU1FMU1RBVEVbNDJTMjJdOiBDb2x1bW4gbm90IGZvdW5kOiAxMDU0IFVua25vd24gY29sdW1uICdwaG9uZScgaW4gJ2ZpZWxkIGxpc3QnIGZyb20gT3RyYW1zREIucGhwIG9uIDA2LTA4LTIwMjAgMDk6MzA6NDUKIFF1ZXJ5OklOU0VSVCBJTlRPIG5ld3NfbGV0dGVyIHNldCBwaG9uZT0gJycsbmFtZT0gJycsZW1haWxfaWQ9ICdzbmVoYWwudmFsYW5qdUBxdGVjaHNvZnR3YXJlLmNvbScsY3JlYXRlX2RhdGU9ICcyMDIwLTA4LTA2IDA5OjMwOjQ0JyxyZWZlcmVyPSAnaHR0cDovL3VhdC50Zmcub3RyYW1zLm5ldC9pbmRleC5waHAnLGlwX2FkZHJlc3M9ICc2MC4yNTQuNDIuMzknCgovbmV3c19sZXR0ZXIucGhwP2FjdGlvbj1hZGQmZW1haWxfaWQ9c25laGFsLnZhbGFuanVAcXRlY2hzb2Z0d2FyZS5jb20KCjxwcmU+Ckhvc3RuYW1lOiBxdGVjaC5vdHJhbXMuY29tCiA8YnI+CgpDb25uZWN0aW9uOiBvdHJhbXNfdGhlZmFiQDIwOS4yMzYuMTE0LjE3NAoKQmFja3RyYWNlOgphcnJheSAoCiAgMCA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9PdHJhbXNEQi5waHAnLAogICAgJ2xpbmUnID0+IDI0NiwKICAgICdmdW5jdGlvbicgPT4gJ3dyaXRlRXJyb3InLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAxID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL25ld3NfbGV0dGVyLnBocCcsCiAgICAnbGluZScgPT4gMzQsCiAgICAnZnVuY3Rpb24nID0+ICdxdWVyeScsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAopCgovbmV3c19sZXR0ZXIucGhwP2FjdGlvbj1hZGQmZW1haWxfaWQ9c25laGFsLnZhbGFuanVAcXRlY2hzb2Z0d2FyZS5jb20KdWF0LnRmZy5vdHJhbXMubmV0LCBDbGllbnQgSVA6IDYwLjI1NC40Mi4zOTwvcHJlPjxicj4KYXJyYXkgKAogIDAgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvT3RyYW1zREIucGhwJywKICAgICdsaW5lJyA9PiAyNDYsCiAgICAnZnVuY3Rpb24nID0+ICd3cml0ZUVycm9yJywKICAgICdjbGFzcycgPT4gJ090cmFtc0RCJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMSA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy9uZXdzX2xldHRlci5waHAnLAogICAgJ2xpbmUnID0+IDM0LAogICAgJ2Z1bmN0aW9uJyA9PiAncXVlcnknLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKKQ==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/news_letter.php?action=add&email_id=snehal.valanju@qtechsoftware.com',create_date= '2020-08-06 09:30:45';
[08/06/2020 09:30:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/news_letter.php],insert into email_logs SET `subject`= 'Newsletter subscription',from_email_id= '',body= '[encoded data, 4396 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/news_letter.php?action=add&email_id=snehal.valanju@qtechsoftware.com',create_date= '2020-08-06 09:30:45';
[08/06/2020 09:30:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/news_letter.php],insert into email_logs SET `subject`= 'Newsletter subscription',from_email_id= '',body= '[encoded data, 4444 characters]',to_email_id= '',cc= '',bcc= '',status= 'You must provide at least one recipient email address.',page_url= '/news_letter.php?action=add&email_id=snehal.valanju@qtechsoftware.com',create_date= '2020-08-06 09:30:45';
[08/06/2020 09:30:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/news_letter.php],INSERT INTO mails_error_log set mailfrom='',mailsubject='Newsletter subscription',mailbody='
&lt;HTML&gt;
&lt;HEAD&gt;
&lt;TITLE&gt;News Letter&lt;/TITLE&gt;
&lt;style&gt;
@import url(http://fonts.googleapis.com/css?family=Source+Sans+Pro:400,600,700);
&lt;/style&gt;

&lt;/HEAD&gt;
&lt;BODY style=\&quot;font-size: 12px !important; background: #F3F6F7;\&quot;&gt;
	&lt;table cellpadding=\&quot;5\&quot; cellspacing=\&quot;0\&quot; style=\&quot;margin: 0 auto; width: 700px; border: 1px solid #efefef; background:#ECF1F2;\&quot;&gt;
		&lt;!-- createing new header page by Dilip 27-02-2014 --&gt;
&lt;tr&gt;
    &lt;td valign=\&quot;top\&quot; style=\&quot;border-bottom:1px solid #dce4e7;  padding:0 0 5px 0; height:90px; line-height:0px; background:#fff;\&quot;&gt;
        &lt;table width=\&quot;646\&quot; border=\&quot;0\&quot; align=\&quot;center\&quot; cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot;&gt;
         &lt;tr&gt;
            &lt;td colspan=\&quot;2\&quot; style=\&quot; height:21px;\&quot;&gt;&lt;/td&gt;
         &lt;/tr&gt;
         &lt;tr&gt;
        
            &lt;td rowspan=\&quot;2\&quot; valign=\&quot;top\&quot; style=\&quot;width:500px; padding:0px 0 0 0;\&quot;&gt;
            	    			 &lt;a href=\&quot;#\&quot;&gt;&lt;img src=\&quot;http://uat.tfg.otrams.net/project_folder/tfg_project/images/elogo.png\&quot; alt=\&quot;\&quot; style=\&quot;border:0px;height: 70px;\&quot;&gt;&lt;/a&gt;            &lt;/td&gt;
            &lt;td valign=\&quot;top\&quot; style=\&quot; width:146px;color:#636464; font-family:\&#039;Source Sans Pro\&#039;, sans-serif; font-size:12px; text-align:center; padding:0px 0 19px 0;\&quot;&gt;&lt;/td&gt;
         &lt;/tr&gt;
         &lt;tr&gt;
            &lt;td valign=\&quot;top\&quot;&gt;
            	
            &lt;/td&gt;
         &lt;/tr&gt;
        &lt;/table&gt;
    &lt;/td&gt;
&lt;/tr&gt; 
&lt;tr style=\&quot;background:#fff;\&quot;&gt;
   &lt;td style=\&quot;border-bottom:1px solid #dce4e7;\&quot;&gt;
    &lt;table width=\&quot;646\&quot; border=\&quot;0\&quot; align=\&quot;center\&quot; cellpadding=\&quot;0\&quot; cellspacing=\&quot;0\&quot;&gt;
      &lt;tr&gt;
        &lt;td style=\&quot;color:#686f74; font-family:\&#039;Source Sans Pro\&#039;, sans-serif; font-size:12px; text-align:left; width:220px; height:31px;\&quot;&gt;Thursday, August  6, 2020&lt;/td&gt;
        &lt;td style=\&quot;color:#686f74; font-family:\&#039;Source Sans Pro\&#039;, sans-serif; font-size:12px; text-align:left; width:180px; height:31px;\&quot;&gt;&lt;img src=\&quot;http://uat.tfg.otrams.net/project_folder/tfg_project/images/emails/phone.png\&quot; align=\&quot;\&quot; width=\&quot;12\&quot; height=\&quot;18\&quot; style=\&quot;margin-right: 5px;\&quot;/&gt;+94 (0)11 789 5820&lt;br/&gt;
        &lt;td style=\&quot;color:#686f74; font-family:\&#039;Source Sans Pro\&#039;, sans-serif; font-size:12px; text-align:left; width:auto; height:31px;\&quot;&gt;&lt;img src=\&quot;http://uat.tfg.otrams.net/project_folder/tfg_project/images/emails/mail.png\&quot; align=\&quot;\&quot; width=\&quot;20\&quot; height=\&quot;14\&quot; style=\&quot;margin-right: 5px;\&quot; /&gt;&lt;a href=\&quot;mailto:reservations@thefabulousgetaway.com\&quot; style=\&quot;color:#686f74; text-decoration:none;\&quot;&gt;reservations@thefabulousgetaway.com&lt;/a&gt;&lt;/td&gt;
      &lt;/tr&gt;
    &lt;/table&gt;    
    &lt;/td&gt;
&lt;/tr&gt;

		&lt;tr&gt;
			&lt;td style=\&quot;padding-left:10px;border-bottom: 1px solid #dfe5e6;font-family: \&#039;Source Sans Pro\&#039;, sans-serif; line-height: 18px;\&quot;&gt;&nbsp;&lt;/td&gt;
		&lt;/tr&gt;			
		&lt;tr style=\&quot;background: #ECF1F2; font-family: \&#039;Source Sans Pro\&#039;, sans-serif;\&quot;&gt;
			&lt;td colspan=\&quot;2\&quot;&gt;
				&lt;table style=\&quot;font-size: 13px;\&quot; cellspacing=\&quot;0\&quot; cellpadding=\&quot;0\&quot;  width=\&quot;99%\&quot; align=\&quot;center\&quot;&gt;
					&lt;tr style=\&quot;background:#22bed6; color:#fff; height:40px;\&quot;&gt;
						&lt;td colspan=\&quot;2\&quot; style=\&quot;padding:0px 0px 0px 10px; font-weight:bold; font-size:20px;\&quot;&gt;News Letterr&lt;/td&gt;
					&lt;tr&gt;				
					&lt;tr style=\&quot;background:#fff; height:35px;\&quot;&gt;
						&lt;td style=\&quot;padding-left:10px;border-bottom: 1px solid #dfe5e6; font-size: 14px; color: #8b8e91; line-height: 18px;\&quot;&gt;
						Following user has subscribed for newsletter. &lt;br/&gt;&lt;br/&gt;&lt;strong&gt;Email Id :&lt;/strong&gt;snehal.valanju@qtechsoftware.com&lt;br/&gt;
						&lt;/td&gt;
					&lt;/tr&gt;														
				&lt;/table&gt;
			&lt;/td&gt;
		&lt;/tr&gt;
&lt;/table&gt;

',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2020-08-06 09:30:45';
[08/06/2020 09:33:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-08-06 09:33:38',login_attempt=0 where id = '25';
[08/06/2020 09:33:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'PHPTEST', user_type = 'A', branch_id = '1', login_datetime = '2020-08-06 09:33:38', ip = '60.254.42.39', action = 'Login' ;
[08/06/2020 09:35:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-08-06 09:35:35',login_attempt=0 where id = '25';
[08/06/2020 09:35:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'PHPTEST', user_type = 'A', branch_id = '1', login_datetime = '2020-08-06 09:35:35', ip = '60.254.42.39', action = 'Login' ;
[08/06/2020 09:35:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '60.254.42.39' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/08/06' , departure_date = '2020/08/07' , nationality = '106' , nights = '1' , room_types = '2' , create_date = '2020-08-06 09:35:49' , site_id = '' , country_code = '106' , web_service = '' ;
[08/06/2020 09:35:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-08-06 09:35:52', '', '9e373ed0b0b4ce2ac4d3005d95327a55c81a21d6ea4af980685d78793e01ed84', '362');
[08/06/2020 09:35:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e373ed0b0b4ce2ac4d3005d95327a55c81a21d6ea4af980685d78793e01ed84&xml_user_id=25&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&#039;,&#039;53766&#039;,&#039;53767&web_service=no&site_id='
, http_hit_time = '2020-08-06 09:35:51.146'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.278'
, error_description = ' Uncaught MongoDB\Driver\Exception\CommandException: a collection &#039;otrams_alpha_riyatravel.log&#039; already exists in /home/otrams/public_html/otramsphp7/uat/v3otrams/vendor/mongodb/mongodb/src/Operation/CreateCollection.php:184
Stack trace:
#0 /home/otrams/public_html/otramsphp7/uat/v3otrams/vendor/mongodb/mongodb/src/Operation/CreateCollection.php(184): MongoDB\Driver\Server-&gt;executeCommand(&#039;otrams_alpha_ri...&#039;, Object(MongoDB\Driver\Command))
#1 /home/otrams/public_html/otramsphp7/uat/v3otrams/vendor/mongodb/mongodb/src/Database.php(206): MongoDB\Operation\CreateCollection-&gt;execute(Object(MongoDB\Driver\Server))
#2 /home/otrams/public_html/otramsphp7/uat/v3otrams/tms/classes/OMongo.php(363): MongoDB\Database-&gt;createCollection(&#039;log&#039;)
#3 /home/otrams/public_html/otramsphp7/uat/v3otrams/tms/classes/supplier/LocalSupplier.php(410): OMongo-&gt;track_time(Array)
#4 /home/otrams/public_html/otramsphp7/uat/v3otrams/common/functions/call.func.php(402): LocalSupplier-&gt;getAvailabilityResponse(Array)
#5 /home/otrams/public_ht | 1 | /home/otrams/public_html/otramsphp7/uat/v3otrams/vendor/mongodb/mongodb/src/Operation/CreateCollection.php:184'
, memory_used = '8020904'
WHERE id = '2945';
[08/06/2020 09:35:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-08-06 09:35:52', '', '9e373ed0b0b4ce2ac4d3005d95327a55c81a21d6ea4af980685d78793e01ed84', '362');
[08/06/2020 09:35:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e373ed0b0b4ce2ac4d3005d95327a55c81a21d6ea4af980685d78793e01ed84&xml_user_id=25&request_no=1&local_hotel_code=53768&#039;,&#039;53769&web_service=no&site_id='
, http_hit_time = '2020-08-06 09:35:51.167'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.896'
, error_description = ''
, memory_used = '8018904'
WHERE id = '2946';
[08/06/2020 09:35:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=9e373ed0b0b4ce2ac4d3005d95327a55c81a21d6ea4af980685d78793e01ed84',
  duration = '2.550',
  merge_duration = '0.188',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '1.73',
  system_load_5_min = '1.43',
  system_load_15_min = '1.32',
  system_memory_usage = '91.39',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '362') + '8149152',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '362';
[08/06/2020 09:37:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596706626','60.254.42.39');
[08/06/2020 09:37:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Lalits', 'mumbai', '106', '25', '', '1', '', 'hotelcancellationpolicy', '2020-08-06 :09:37:06','');
[08/06/2020 09:37:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/m1_write_cache.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596706655','60.254.42.39');
[08/06/2020 09:37:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/m1_write_cache.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596706656','60.254.42.39');
[08/06/2020 09:37:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/m1_write_cache.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596706657','60.254.42.39');
[08/06/2020 09:37:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/m1_write_cache.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596706658','60.254.42.39');
[08/06/2020 09:37:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/m1_write_cache.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596706662','60.254.42.39');
[08/06/2020 09:39:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/rate_diff_supplier.php],INSERT INTO frontend_roomcategory SET room_category=?;
[08/06/2020 09:40:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596706828','60.254.42.39');
[08/06/2020 09:41:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596706877','60.254.42.39');
[08/06/2020 09:41:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO bookings SET  source_type = 'localsystem', reservation_id = '1724', create_date = '2020-08-06 09:41:30', agent_id = '25', parent_agent_id = '25', agent_ref_no = '', nationality = 'Indian', city_id = 'mumbai', country_id = '106', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '4.05', display_currency_code = 'USD', native_room_rate = '230', native_currency_code = 'INR', supplier_profile_id = '1', service_type = 'hotel', service_date = '2020/08/06', check_out_date = '2020/08/07', sub_user_id = '', booking_status = '1', leader_title = '', leader_first_name = '', leader_last_name = '', booking_branch_id = '1', expiration_date = '2020-08-06 00:00:00', cancellation_policy = 'Amendment of Dates, Room Category, Passenger Names are considered as Cancel and Rebook by most of the Hotels.
        Any Changes in initial booking may be denied by the supplier or may result in extra charges.
        Confirmation of amendment requests is subject to availablity and rates at the time of amendment.<Br><Br><B><U>Detailed Cancellation Policy:</U></B> <br/> Cancellation Charges of 4.05 USD applicable if cancelled after 05 Aug 2020 23:40 hrs.', supplier_cancellation_policy = '', status_date = '2020-08-06 09:41:30',  site_url = 'http://uat.tfg.otrams.net/';
[08/06/2020 09:41:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO external_mapping_data_tracking (booking_id,search_hotel_name,booked_hotel_name_supplier,hotel_id,master_id,city_id,supplier,date)
            VALUES ('2803','LALITS','LALITS','53768','53768','mumbai','LOCAL_SUPPLIER',NOW());
[08/06/2020 09:41:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='2803'
        ;
[08/06/2020 09:41:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into bookings_details(booking_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,hotel_id,local_hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('2803','S000000238','1','2','0','-','','','53768','53768','LALITS','Test Address','+605 - 1234 5677','4.0','1','2020/08/06','2020/08/07','','http://uat.tfg.otrams.net/project_folder/tfg_project/images/imagenotavailable.jpg');
[08/06/2020 09:41:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into booking_room_detail set  booking_id = '2803', booking_detail_id = '1099', room_type_code = '2~~~133~~~1023~~~1~~~~~~~~~64440~~~0~~~S000000238', room_name = 'double', room_type_description = 'Junior Suite Tower  -Bed & Breakfast : 2 Pax <br>( Promotion)<br>(Offer Note: ~ FREE WIFI) (Non-Refundable)', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:\"displayNightlyRate\";d:4.05;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:174:\"Supplier Name - localsupplier(Lalits - S000000238), Rate - 230 INR, Currency Multiplier (INR-USD) - 0.01533 Supplier Commission-0 , Branch:% #localsystem, VAT Markup=15.000%,\";}}', native_nightly_rates = 'a:1:{i:0;a:4:{s:19:\"O_nativeNightlyRate\";i:230;s:17:\"nativeNightlyRate\";i:230;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";a:1:{i:0;s:10:\"0238-11579\";}s:4:\"Name\";a:1:{i:0;s:9:\"Promotion\";}s:7:\"S_Value\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:5:\"Value\";i:0;s:12:\"Display_Name\";a:1:{i:0;s:9:\"Promotion\";}s:10:\"Offer_Note\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:10:\"Offer_Type\";N;}}}', markup = '0', commission = '0', native_room_rate_total = '230', display_room_rate_total = '4.05', number_of_rooms = '1';
[08/06/2020 09:41:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '', confirmation_number = '', display_discount = '0', current_status = 'on_request', comment_contract = '', consultant_id = 'SalesConsultant', sales_manager_id = '', admin_booked = '0', email_id = '', leader_phone = '', agent_currency_multiplier = '1.00000', ip_addr = '60.254.42.39', backoffice_user = '', customer_id = '', applied_multiplier='0.01533', free_sale='',  applied_markup='15',  agent_markup='15',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='0.01533',  parent_agent_id='25',  sub_agent_rate='0', agent_rate='4.05',  applicable_service_tax='0',  supplier_rate='230',  original_source='',  uid='086cb28fe06c9ed7e6b46d38412b34b5'  where id='2803';
[08/06/2020 09:41:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' ,gtaToken = '' , special_request='' where booking_id ='2803';
[08/06/2020 09:41:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,supplier_charge,agent_charge,lead_time,create_date)  VALUES('2803','2020-08-06 09:40:00','2020-08-06 09:40:00','230','4.05','0','2020-08-06 09:41:30');
[08/06/2020 09:41:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], INSERT INTO booking_special_request set booking_id = '2803' , sr_id = '2',approved_status='1' ;
[08/06/2020 09:41:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('2803','6.278698','99.730656');
[08/06/2020 09:41:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set admin_booked='1' where id='2803';
[08/06/2020 09:41:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= 'Special Condition Booking - The Fabulous Getaway',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'CjxIVE1MPgo8SEVBRD4KPFRJVExFPlNwZWNpYWwgQ29uZGl0aW9uIEJvb2tpbmc8L1RJVExFPgoKPHN0eWxlIHR5cGU9InRleHQvY3NzIj4KPCEtLQpib2R5IHsKCW1hcmdpbi1sZWZ0OiAxMHB4OwoJbWFyZ2luLXRvcDogMHB4OwoJbWFyZ2luLXJpZ2h0OiAwcHg7CgltYXJnaW4tYm90dG9tOiAwcHg7Cglmb250OiBWZXJkYW5hOwoJZm9udC1zaXplOiAxM3B4Owp9Ci0tPgo8L3N0eWxlPgoKPC9IRUFEPgo8Qk9EWT4KPGJyPgpEYXRlIDogVGh1cnNkYXksIEF1Z3VzdCAgNiwgMjAyMDxicj4KPGJyPgpEZWFyIE9wZXJhdGlvbnMgVGVhbSw8YnI+CjxiPlRoZSBGYWJ1bG91cyBHZXRhd2F5PC9iPjxicj4KPGJyPgpGb2xsb3dpbmcgYm9va2luZyBpcyBkb25lIGVpdGhlciB0aHJvdWdoIHBheW1lbnQgZ2V0d2F5IHN5c3RlbSBvciB3aXRoaW4gY2FuY2VsbGF0aW9uIGRlYWRsaW5lLjxicj48YnI+CktpbmRseSByZWNoZWNrIHRoaXMgYm9va2luZyBhcyBpdCBtaWdodCBiZSBlaXRoZXI6PGJyPgoKMS4gRmFpbGVkIG9yIG9uLXJlcXVlc3QuPGJyPgoyLiBUaGlzIGJvb2tpbmcgbWF5IGJlIGNhbWUgb24gc3BlY2lhbCBjb25kaXRpb24gPGJyPjxicj4KCgpUaGUgZGV0YWlscyBvZiBib29raW5nIGlzIHByb3ZpZGVkIGJlbG93LiBQbGVhc2UgaGFuZGxlIHRoZSBib29raW5nIG1hbnVhbGx5Lgo8YnI+PGJyPgoJPGI+Qm9va2luZyBJZDwvYj4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDs6Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7VEZHMTAyODAzPGJyPgoJPGI+U3VwcGxpZXI8L2I+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7OiZuYnNwOyZuYnNwOyZuYnNwO2xvY2Fsc3lzdGVtPGJyPgoJPGJyPjxicj4KQmVzdCBSZWdhcmRzLDxicj4KVGhlIEZhYnVsb3VzIEdldGF3YXkKPGJyPgo8L0JPRFk+CjwvSFRNTD4=',to_email_id= '',cc= '',bcc= '',status= 'You must provide at least one recipient email address.',page_url= '/confirm_booking.php',create_date= '2020-08-06 09:41:30';
[08/06/2020 09:41:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO mails_error_log set mailfrom='sanket.desai@qtechsoftware.com',mailsubject='Special Condition Booking - The Fabulous Getaway',mailbody='
&lt;HTML&gt;
&lt;HEAD&gt;
&lt;TITLE&gt;Special Condition Booking&lt;/TITLE&gt;

&lt;style type=\&quot;text/css\&quot;&gt;
&lt;!--
body {
	margin-left: 10px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
	font: Verdana;
	font-size: 13px;
}
--&gt;
&lt;/style&gt;

&lt;/HEAD&gt;
&lt;BODY&gt;
&lt;br&gt;
Date : Thursday, August  6, 2020&lt;br&gt;
&lt;br&gt;
Dear Operations Team,&lt;br&gt;
&lt;b&gt;The Fabulous Getaway&lt;/b&gt;&lt;br&gt;
&lt;br&gt;
Following booking is done either through payment getway system or within cancellation deadline.&lt;br&gt;&lt;br&gt;
Kindly recheck this booking as it might be either:&lt;br&gt;

1. Failed or on-request.&lt;br&gt;
2. This booking may be came on special condition &lt;br&gt;&lt;br&gt;


The details of booking is provided below. Please handle the booking manually.
&lt;br&gt;&lt;br&gt;
	&lt;b&gt;Booking Id&lt;/b&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;&nbsp;&nbsp;&nbsp;TFG102803&lt;br&gt;
	&lt;b&gt;Supplier&lt;/b&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;&nbsp;&nbsp;localsystem&lt;br&gt;
	&lt;br&gt;&lt;br&gt;
Best Regards,&lt;br&gt;
The Fabulous Getaway
&lt;br&gt;
&lt;/BODY&gt;
&lt;/HTML&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2020-08-06 09:41:30';
[08/06/2020 09:41:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_status (booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by) VALUES ('2803','on_request','2020-08-06 09:41:30','Booking on_request ','25','60.254.42.39','0','25');
[08/06/2020 09:41:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_search_log(booking_id, details)
        VALUES(2803, 'a:30:{s:3:\"_id\";a:1:{s:4:\"$oid\";s:24:\"5f2bcef81e75f32ad21a8fc3\";}s:7:\"hotelId\";s:25:\"53768----------S000000238\";s:4:\"name\";s:6:\"LALITS\";s:14:\"local_hotel_id\";s:5:\"53768\";s:8:\"address1\";s:12:\"Test Address\";s:8:\"latitude\";d:6.278698;s:9:\"longitude\";d:99.730656;s:4:\"city\";s:5:\"64440\";s:8:\"location\";N;s:14:\"prefered_hotel\";s:1:\"0\";s:10:\"mlosSlogan\";s:0:\"\";s:16:\"isMlosApplicable\";s:2:\"no\";s:7:\"country\";s:3:\"106\";s:16:\"rateCurrencyCode\";s:3:\"USD\";s:5:\"phone\";s:16:\"+605 - 1234 5677\";s:16:\"shortDescription\";s:22:\"TEST HOTEL DESCRIPTION\";s:11:\"website_url\";s:20:\"http://www.test.com/\";s:12:\"thumbNailUrl\";s:81:\"http://uat.tfg.otrams.net/project_folder/tfg_project/images/imagenotavailable.jpg\";s:10:\"sourceType\";s:11:\"localsystem\";s:10:\"supplierid\";s:10:\"S000000238\";s:12:\"suppliername\";s:6:\"Lalits\";s:14:\"propertyRating\";s:3:\"4.0\";s:15:\"specialCategory\";a:1:{i:0;s:1:\"1\";}s:13:\"HotelProperty\";a:1:{s:11:\"localsystem\";a:2:{i:0;a:1:{s:8:\"RateInfo\";a:13:{s:10:\"room_rates\";a:1:{i:0;a:34:{s:11:\"ratebreakup\";a:4:{s:6:\"markup\";i:0;s:10:\"commission\";i:0;s:18:\"NativeNightlyRates\";a:1:{i:0;a:4:{s:19:\"O_nativeNightlyRate\";i:230;s:17:\"nativeNightlyRate\";i:230;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";a:1:{i:0;s:10:\"0238-11579\";}s:4:\"Name\";a:1:{i:0;s:9:\"Promotion\";}s:7:\"S_Value\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:5:\"Value\";i:0;s:12:\"Display_Name\";a:1:{i:0;s:9:\"Promotion\";}s:10:\"Offer_Note\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:10:\"Offer_Type\";N;}}}s:19:\"DisplayNightlyRates\";a:1:{i:0;a:3:{s:18:\"displayNightlyRate\";d:4.05;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:174:\"Supplier Name - localsupplier(Lalits - S000000238), Rate - 230 INR, Currency Multiplier (INR-USD) - 0.01533 Supplier Commission-0 , Branch:% #localsystem, VAT Markup=15.000%,\";}}}s:20:\"offer_promotion_note\";s:0:\"\";s:19:\"offer_discount_note\";s:9:\"Promotion\";s:19:\"offer_discount_type\";s:0:\"\";s:27:\"offer_discount_note_details\";s:11:\"~ FREE WIFI\";s:9:\"room_name\";s:6:\"double\";s:9:\"stay_note\";N;s:10:\"time_stamp\";s:32:\"f99273882f9e838c8653da6eb8e5a429\";s:16:\"number_of_adults\";s:1:\"2\";s:10:\"view_basis\";s:0:\"\";s:13:\"view_basis_id\";s:1:\"0\";s:9:\"available\";i:0;s:9:\"free_sale\";N;s:7:\"minStay\";s:1:\"0\";s:19:\"displayCurrencyCode\";s:3:\"USD\";s:18:\"nativeCurrencyCode\";s:3:\"INR\";s:20:\"displayRoomTypeRates\";d:4.05;s:20:\"sortingRoomTypeRates\";i:40500;s:19:\"nativeRoomTypeRates\";i:230;s:12:\"offerApplied\";N;s:7:\"room_id\";s:49:\"2~~~133~~~1023~~~1~~~~~~~~~64440~~~0~~~S000000238\";s:14:\"room_type_code\";s:1:\"2\";s:14:\"boardtype_code\";s:1:\"1\";s:16:\"valuation_number\";s:49:\"2~~~133~~~1023~~~1~~~~~~~~~64440~~~0~~~S000000238\";s:15:\"number_of_child\";i:0;s:13:\"NumberOfRooms\";i:1;s:10:\"supplierId\";s:10:\"S000000238\";s:12:\"supplierName\";s:6:\"Lalits\";s:10:\"meal_basis\";s:15:\"Bed & Breakfast\";s:4:\"note\";s:37:\"Promotion~ FREE WIFI (Non-Refundable)\";s:13:\"room_category\";s:23:\"Junior Suite Tower Room\";s:9:\"room_type\";s:107:\"Junior Suite Tower  -Bed & Breakfast : 2 Pax <br>( Promotion)<br>(Offer Note: ~ FREE WIFI) (Non-Refundable)\";s:14:\"non_refundable\";s:1:\"1\";s:15:\"class_unique_id\";s:17:\"0_0_53768_8842166\";}}s:9:\"available\";i:0;s:15:\"displayRoomRate\";d:4.05;s:14:\"nativeRoomRate\";i:230;s:9:\"unique_id\";s:37:\"1_53768----------S000000238_0_0_18405\";s:10:\"supplierId\";s:10:\"S000000238\";s:19:\"displayCurrencyCode\";s:3:\"USD\";s:18:\"nativeCurrencyCode\";s:3:\"INR\";s:18:\"applied_markup_per\";i:15;s:18:\"applied_multiplier\";d:0.01533;s:19:\"supplier_profile_id\";s:1:\"1\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53768----------S000000238\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:6:\"LALITS\";s:18:\"supp_hotel_address\";s:12:\"Test Address\";s:10:\"supplierId\";s:10:\"S000000238\";}s:8:\"no_class\";i:0;}}i:1;a:1:{s:8:\"RateInfo\";a:13:{s:10:\"room_rates\";a:1:{i:0;a:34:{s:11:\"ratebreakup\";a:4:{s:6:\"markup\";i:0;s:10:\"commission\";i:0;s:18:\"NativeNightlyRates\";a:1:{i:0;a:4:{s:19:\"O_nativeNightlyRate\";i:230;s:17:\"nativeNightlyRate\";i:230;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";a:1:{i:0;s:10:\"0238-11579\";}s:4:\"Name\";a:1:{i:0;s:9:\"Promotion\";}s:7:\"S_Value\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:5:\"Value\";i:0;s:12:\"Display_Name\";a:1:{i:0;s:9:\"Promotion\";}s:10:\"Offer_Note\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:10:\"Offer_Type\";N;}}}s:19:\"DisplayNightlyRates\";a:1:{i:0;a:3:{s:18:\"displayNightlyRate\";d:4.05;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:174:\"Supplier Name - localsupplier(Lalits - S000000238), Rate - 230 INR, Currency Multiplier (INR-USD) - 0.01533 Supplier Commission-0 , Branch:% #localsystem, VAT Markup=15.000%,\";}}}s:20:\"offer_promotion_note\";s:0:\"\";s:19:\"offer_discount_note\";s:9:\"Promotion\";s:19:\"offer_discount_type\";s:0:\"\";s:27:\"offer_discount_note_details\";s:11:\"~ FREE WIFI\";s:9:\"room_name\";s:6:\"double\";s:9:\"stay_note\";N;s:10:\"time_stamp\";s:32:\"12ef4444cfc1c3873966d5c0dbae65f4\";s:16:\"number_of_adults\";s:1:\"2\";s:10:\"view_basis\";s:0:\"\";s:13:\"view_basis_id\";s:1:\"0\";s:9:\"available\";i:0;s:9:\"free_sale\";N;s:7:\"minStay\";s:1:\"0\";s:19:\"displayCurrencyCode\";s:3:\"USD\";s:18:\"nativeCurrencyCode\";s:3:\"INR\";s:20:\"displayRoomTypeRates\";d:4.05;s:20:\"sortingRoomTypeRates\";i:40500;s:19:\"nativeRoomTypeRates\";i:230;s:12:\"offerApplied\";N;s:7:\"room_id\";s:49:\"2~~~133~~~1024~~~1~~~~~~~~~64440~~~1~~~S000000238\";s:14:\"room_type_code\";s:1:\"2\";s:14:\"boardtype_code\";s:1:\"1\";s:16:\"valuation_number\";s:49:\"2~~~133~~~1024~~~1~~~~~~~~~64440~~~1~~~S000000238\";s:15:\"number_of_child\";i:0;s:13:\"NumberOfRooms\";i:1;s:10:\"supplierId\";s:10:\"S000000238\";s:12:\"supplierName\";s:6:\"Lalits\";s:10:\"meal_basis\";s:15:\"Bed & Breakfast\";s:4:\"note\";s:20:\"Promotion~ FREE WIFI\";s:13:\"room_category\";s:23:\"Junior Suite Tower Room\";s:9:\"room_type\";s:90:\"Junior Suite Tower  -Bed & Breakfast : 2 Pax <br>( Promotion)<br>(Offer Note: ~ FREE WIFI)\";s:14:\"non_refundable\";s:1:\"0\";s:15:\"class_unique_id\";s:16:\"1_1_53768_432019\";}}s:9:\"available\";i:0;s:15:\"displayRoomRate\";d:4.05;s:14:\"nativeRoomRate\";i:230;s:9:\"unique_id\";s:37:\"1_53768----------S000000238_0_1_69441\";s:10:\"supplierId\";s:10:\"S000000238\";s:19:\"displayCurrencyCode\";s:3:\"USD\";s:18:\"nativeCurrencyCode\";s:3:\"INR\";s:18:\"applied_markup_per\";i:15;s:18:\"applied_multiplier\";d:0.01533;s:19:\"supplier_profile_id\";s:1:\"1\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53768----------S000000238\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:6:\"LALITS\";s:18:\"supp_hotel_address\";s:12:\"Test Address\";s:10:\"supplierId\";s:10:\"S000000238\";}s:8:\"no_class\";i:0;}}}}s:13:\"total_charges\";d:4.05;s:17:\"propertyAvailable\";i:0;s:8:\"no_class\";i:0;s:18:\"sort_total_charges\";i:405000;s:16:\"hotel_name_ascii\";s:6:\"lalits\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53768----------S000000238\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:6:\"LALITS\";s:18:\"supp_hotel_address\";s:12:\"Test Address\";s:10:\"supplierId\";s:10:\"S000000238\";}}');
[08/06/2020 09:41:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,to_date,supplier_to_date,supplier_charge,agent_charge,lead_time,create_date,applied_agent_charges)  VALUES('2803','2020-08-06 09:40:00','2020-08-06 09:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00','230','4.05','0','2020-08-06 09:41:30','');
[08/06/2020 09:41:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO bookings_applicable_offer set  oid= '0238-11579',  offer_type_code= 'PM',  booking_id= '2803',  room_id= '2~~~133~~~1023~~~1~~~~~~~~~64440~~~0~~~S000000238',  room_name= 'double',  supplier_id= 'S000000238',  agent_id= '',  promotion_text= '',  offer_disc_type= 'Discount',  offer_disc_value= '',  offer_disc_currency= '',  create_date= '2020-08-06 09:41:30' ;
[08/06/2020 09:41:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into booking_configuration set  booking_id = '2803', config_key = 'BOOKING OTP', config_value = 'tcDR3F1Z';;
[08/06/2020 09:41:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= ' TFG102803 /  Booking On Request ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 37620 characters]',to_email_id= 'example1@test.com,example2@test.com,example3@test.com,example@test.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking.php',create_date= '2020-08-06 09:41:31';
[08/06/2020 09:41:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('2803','example1@test.com');
[08/06/2020 09:41:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('2803','example2@test.com');
[08/06/2020 09:41:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('2803','example3@test.com');
[08/06/2020 09:41:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('2803','example1@test.com');
[08/06/2020 09:41:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('2803','example2@test.com');
[08/06/2020 09:41:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('2803','example3@test.com');
[08/06/2020 09:41:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('2803','example@test.com');
[08/06/2020 09:41:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update posted_bookings set booking_id='2803',status='1' where reservation_id='1724' and booking_id ='0';
[08/06/2020 09:41:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update xmllogs set reservation_id='2803' where agent_logs_id='362' and source_type='localsystem';
[08/06/2020 09:41:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='',  profit_percent='',  gross_profit='',  commission_tax='',  booking_id ='2803',  create_date ='2020-08-06 09:41:31', supplier_tax='';
[08/06/2020 09:41:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'PGJyPi0tLS0tLS0tLSAKCjxicj5FcnJvcjoKU1FMU1RBVEVbNDJTMjJdOiBDb2x1bW4gbm90IGZvdW5kOiAxMDU0IFVua25vd24gY29sdW1uICdzdXBwbGllcl90YXgnIGluICdmaWVsZCBsaXN0JyBmcm9tIE90cmFtc0RCLnBocCBvbiAwNi0wOC0yMDIwIDA5OjQxOjMxCiBRdWVyeTpJTlNFUlQgSU5UTyBib29raW5nX2NvbW1pc3Npb24gc2V0IGFnZW50X2NvbW1pc3Npb249JycsICBzdXBwbGllcl9jb21taXNzaW9uPScnLCAgcHJvZml0X3BlcmNlbnQ9JycsICBncm9zc19wcm9maXQ9JycsICBjb21taXNzaW9uX3RheD0nJywgIGJvb2tpbmdfaWQgPScyODAzJywgIGNyZWF0ZV9kYXRlID0nMjAyMC0wOC0wNiAwOTo0MTozMScsIHN1cHBsaWVyX3RheD0nJwoKL2NvbmZpcm1fYm9va2luZy5waHAKCjxwcmU+Ckhvc3RuYW1lOiBxdGVjaC5vdHJhbXMuY29tCiA8YnI+CgpDb25uZWN0aW9uOiBvdHJhbXNfdGhlZmFiQDIwOS4yMzYuMTE0LjE3NAoKQmFja3RyYWNlOgphcnJheSAoCiAgMCA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9PdHJhbXNEQi5waHAnLAogICAgJ2xpbmUnID0+IDI0NiwKICAgICdmdW5jdGlvbicgPT4gJ3dyaXRlRXJyb3InLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAxID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL0Jvb2tpbmcucGhwJywKICAgICdsaW5lJyA9PiAxNjQ2LAogICAgJ2Z1bmN0aW9uJyA9PiAncXVlcnknLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAyID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL0hvdGVsX0Jvb2tpbmcucGhwJywKICAgICdsaW5lJyA9PiAyMjUwLAogICAgJ2Z1bmN0aW9uJyA9PiAncG9zdF9ib29raW5nX29wZXJhdGlvbicsCiAgICAnY2xhc3MnID0+ICdCb29raW5nJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMyA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy9jb25maXJtX2Jvb2tpbmcucGhwJywKICAgICdsaW5lJyA9PiA4LAogICAgJ2Z1bmN0aW9uJyA9PiAnY29uZmlybV9ib29raW5nJywKICAgICdjbGFzcycgPT4gJ0hvdGVsX0Jvb2tpbmcnLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKKQoKL2NvbmZpcm1fYm9va2luZy5waHAKdWF0LnRmZy5vdHJhbXMubmV0LCBDbGllbnQgSVA6IDYwLjI1NC40Mi4zOTwvcHJlPjxicj4KYXJyYXkgKAogIDAgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvT3RyYW1zREIucGhwJywKICAgICdsaW5lJyA9PiAyNDYsCiAgICAnZnVuY3Rpb24nID0+ICd3cml0ZUVycm9yJywKICAgICdjbGFzcycgPT4gJ090cmFtc0RCJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMSA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9Cb29raW5nLnBocCcsCiAgICAnbGluZScgPT4gMTY0NiwKICAgICdmdW5jdGlvbicgPT4gJ3F1ZXJ5JywKICAgICdjbGFzcycgPT4gJ090cmFtc0RCJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMiA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9Ib3RlbF9Cb29raW5nLnBocCcsCiAgICAnbGluZScgPT4gMjI1MCwKICAgICdmdW5jdGlvbicgPT4gJ3Bvc3RfYm9va2luZ19vcGVyYXRpb24nLAogICAgJ2NsYXNzJyA9PiAnQm9va2luZycsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDMgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvY29uZmlybV9ib29raW5nLnBocCcsCiAgICAnbGluZScgPT4gOCwKICAgICdmdW5jdGlvbicgPT4gJ2NvbmZpcm1fYm9va2luZycsCiAgICAnY2xhc3MnID0+ICdIb3RlbF9Cb29raW5nJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCik=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking.php',create_date= '2020-08-06 09:41:31';
[08/06/2020 09:41:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= ' TFG102803 /  Booking On Request ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 27168 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,SalesConsultant@gmail.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking.php',create_date= '2020-08-06 09:41:32';
[08/06/2020 09:41:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('2803','snehal.valanju@qtechsoftware.com');
[08/06/2020 09:41:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('2803','SalesConsultant@gmail.com');
[08/06/2020 09:41:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= 'Special Remark / Request Added  For Booking ID-2803 - The Fabulous Getaway',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICwgPGJyPjxici8+U3BlY2lhbCBSZW1hcmsgLyBSZXF1ZXN0IEFkZGVkICBGb3IgQm9va2luZyBJRC0gPGI+MjgwMyA8L2I+PGJyLz4gQmVsb3cgYXJlIHRoZSBEZXRhaWxzIDxicj48YnIvPlNwZWNpYWwgUmVxdWVzdCA8YnI+MSk6IE5PTiBTTU9LSU5HIFJPT008YnI+T3RoZXIgUmVtYXJrIDo8YnI+PGJyLz4=',to_email_id= '',cc= '',bcc= '',status= 'You must provide at least one recipient email address.',page_url= '/confirm_booking.php',create_date= '2020-08-06 09:41:33';
[08/06/2020 09:41:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO mails_error_log set mailfrom='sanket.desai@qtechsoftware.com',mailsubject='Special Remark / Request Added  For Booking ID-2803 - The Fabulous Getaway',mailbody='Dear Team , &lt;br&gt;&lt;br/&gt;Special Remark / Request Added  For Booking ID- &lt;b&gt;2803 &lt;/b&gt;&lt;br/&gt; Below are the Details &lt;br&gt;&lt;br/&gt;Special Request &lt;br&gt;1): NON SMOKING ROOM&lt;br&gt;Other Remark :&lt;br&gt;&lt;br/&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2020-08-06 09:41:33';
[08/06/2020 09:43:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '60.254.42.39' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/08/06' , departure_date = '2020/08/07' , nationality = '106' , nights = '1' , room_types = '2' , create_date = '2020-08-06 09:43:30' , site_id = '' , country_code = '106' , web_service = '' ;
[08/06/2020 09:43:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs SET
type = 'ERROR'
, http_hit_time = '2020-08-06 09:43:32.77'
, total_duration = '0.853'
, hotel_count = 0
, source_type = 'localsystem'
, create_date = '2020-08-06 09:43:32'
, session_id = '9e373ed0b0b4ce2ac4d3005d95327a55c81a21d6ea4af980685d78793e01ed84'
, agent_logs_id = '363'
, error_description = ' Uncaught MongoDB\Driver\Exception\CommandException: a collection &#039;otrams_alpha_riyatravel.log&#039; already exists in /home/otrams/public_html/otramsphp7/uat/v3otrams/vendor/mongodb/mongodb/src/Operation/CreateCollection.php:184
Stack trace:
#0 /home/otrams/public_html/otramsphp7/uat/v3otrams/vendor/mongodb/mongodb/src/Operation/CreateCollection.php(184): MongoDB\Driver\Server-&gt;executeCommand(&#039;otrams_alpha_ri...&#039;, Object(MongoDB\Driver\Command))
#1 /home/otrams/public_html/otramsphp7/uat/v3otrams/vendor/mongodb/mongodb/src/Database.php(206): MongoDB\Operation\CreateCollection-&gt;execute(Object(MongoDB\Driver\Server))
#2 /home/otrams/public_html/otramsphp7/uat/v3otrams/tms/classes/OMongo.php(363): MongoDB\Database-&gt;createCollection(&#039;log&#039;)
#3 /home/otrams/public_html/otramsphp7/uat/v3otrams/common/functions/call.func.php(395): OMongo-&gt;track_time(Array)
#4 /home/otrams/public_html/otramsphp7/uat/v3otrams/call.php(26): localsystem_call(Array)
#5 {main}
  thrown | 1 | /home/otrams/public_html/otramsphp7/uat/v3otrams/vendor/mongodb/mongodb/src/Operation/CreateCollection.php:184'
, memory_used = '6555408';
[08/06/2020 09:43:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-08-06 09:43:32', '', '9e373ed0b0b4ce2ac4d3005d95327a55c81a21d6ea4af980685d78793e01ed84', '363');
[08/06/2020 09:43:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e373ed0b0b4ce2ac4d3005d95327a55c81a21d6ea4af980685d78793e01ed84&xml_user_id=25&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&#039;,&#039;53766&#039;,&#039;53767&web_service=no&site_id='
, http_hit_time = '2020-08-06 09:43:32.59'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '2.002'
, error_description = ''
, memory_used = '8021280'
WHERE id = '2948';
[08/06/2020 09:43:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=9e373ed0b0b4ce2ac4d3005d95327a55c81a21d6ea4af980685d78793e01ed84',
  duration = '2.554',
  merge_duration = '0.178',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '1.34',
  system_load_5_min = '1.11',
  system_load_15_min = '1.16',
  system_memory_usage = '91.41',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '363') + '8149608',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '363';
[08/06/2020 09:44:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO bookings SET  source_type = 'localsystem', reservation_id = 'QTECH2020081724', create_date = '2020-08-06 09:44:25', agent_id = '25', parent_agent_id = '25', agent_ref_no = '', nationality = 'Indian', city_id = 'mumbai', country_id = '106', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '4.05', display_currency_code = 'USD', native_room_rate = '230', native_currency_code = 'INR', supplier_profile_id = '1', service_type = 'hotel', service_date = '2020/08/06', check_out_date = '2020/08/07', sub_user_id = '', booking_status = '1', leader_title = '', leader_first_name = '', leader_last_name = '', booking_branch_id = '1', expiration_date = '2020-08-06 00:00:00', cancellation_policy = 'Amendment of Dates, Room Category, Passenger Names are considered as Cancel and Rebook by most of the Hotels.
        Any Changes in initial booking may be denied by the supplier or may result in extra charges.
        Confirmation of amendment requests is subject to availablity and rates at the time of amendment.<Br><Br><B><U>Detailed Cancellation Policy:</U></B> <br/> Cancellation Charges of 4.05 USD applicable if cancelled after 05 Aug 2020 23:43 hrs.', supplier_cancellation_policy = '', status_date = '2020-08-06 09:44:25',  site_url = 'http://uat.tfg.otrams.net/';
[08/06/2020 09:44:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO external_mapping_data_tracking (booking_id,search_hotel_name,booked_hotel_name_supplier,hotel_id,master_id,city_id,supplier,date)
            VALUES ('2804','COPPER CHIMNEY &NDASH; IMP UPLOAD','COPPER CHIMNEY &NDASH; IMP UPLOAD','53757','53757','mumbai','LOCAL_SUPPLIER',NOW());
[08/06/2020 09:44:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='2804'
        ;
[08/06/2020 09:44:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into bookings_details(booking_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,hotel_id,local_hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('2804','S000000227','1','2','0','-','','','53757','53757','COPPER CHIMNEY &NDASH; IMP UPLOAD','Test Address','+605 - 1234 5677','4.0','1','2020/08/06','2020/08/07','','http://uat.tfg.otrams.net/project_folder/tfg_project/images/imagenotavailable.jpg');
[08/06/2020 09:44:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into booking_room_detail set  booking_id = '2804', booking_detail_id = '1100', room_type_code = '2~~~133~~~953~~~1~~~~~~~~~64440~~~0~~~S000000227', room_name = 'double', room_type_description = 'Junior Suite Tower  -Bed & Breakfast : 2 Pax <br>( Promotion)<br>(Offer Note: ~ FREE WIFI) (Non-Refundable)', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:\"displayNightlyRate\";d:4.05;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:201:\"Supplier Name - localsupplier(Copper Chimney &ndash; Imp Upload - S000000227), Rate - 230 INR, Currency Multiplier (INR-USD) - 0.01533 Supplier Commission-0 , Branch:% #localsystem, VAT Markup=15.000%,\";}}', native_nightly_rates = 'a:1:{i:0;a:4:{s:19:\"O_nativeNightlyRate\";i:230;s:17:\"nativeNightlyRate\";i:230;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";a:1:{i:0;s:10:\"0227-11523\";}s:4:\"Name\";a:1:{i:0;s:9:\"Promotion\";}s:7:\"S_Value\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:5:\"Value\";i:0;s:12:\"Display_Name\";a:1:{i:0;s:9:\"Promotion\";}s:10:\"Offer_Note\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:10:\"Offer_Type\";N;}}}', markup = '0', commission = '0', native_room_rate_total = '230', display_room_rate_total = '4.05', number_of_rooms = '1';
[08/06/2020 09:44:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '', confirmation_number = '', display_discount = '0', current_status = 'on_request', comment_contract = '', consultant_id = 'SalesConsultant', sales_manager_id = '', admin_booked = '0', email_id = '', leader_phone = '', agent_currency_multiplier = '1.00000', ip_addr = '60.254.42.39', backoffice_user = '', customer_id = '', applied_multiplier='0.01533', free_sale='',  applied_markup='15',  agent_markup='15',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='0.01533',  parent_agent_id='25',  sub_agent_rate='0', agent_rate='4.05',  applicable_service_tax='0',  supplier_rate='230',  original_source='',  uid='7eea814565499d1885d38a50725fe473'  where id='2804';
[08/06/2020 09:44:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' ,gtaToken = '' , special_request='' where booking_id ='2804';
[08/06/2020 09:44:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,supplier_charge,agent_charge,lead_time,create_date)  VALUES('2804','2020-08-06 09:43:00','2020-08-06 09:43:00','230','4.05','0','2020-08-06 09:44:25');
[08/06/2020 09:44:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], INSERT INTO booking_special_request set booking_id = '2804' , sr_id = '2',approved_status='1' ;
[08/06/2020 09:44:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('2804','6.278698','99.730656');
[08/06/2020 09:44:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set admin_booked='1' where id='2804';
[08/06/2020 09:44:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= 'Special Condition Booking - The Fabulous Getaway',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'CjxIVE1MPgo8SEVBRD4KPFRJVExFPlNwZWNpYWwgQ29uZGl0aW9uIEJvb2tpbmc8L1RJVExFPgoKPHN0eWxlIHR5cGU9InRleHQvY3NzIj4KPCEtLQpib2R5IHsKCW1hcmdpbi1sZWZ0OiAxMHB4OwoJbWFyZ2luLXRvcDogMHB4OwoJbWFyZ2luLXJpZ2h0OiAwcHg7CgltYXJnaW4tYm90dG9tOiAwcHg7Cglmb250OiBWZXJkYW5hOwoJZm9udC1zaXplOiAxM3B4Owp9Ci0tPgo8L3N0eWxlPgoKPC9IRUFEPgo8Qk9EWT4KPGJyPgpEYXRlIDogVGh1cnNkYXksIEF1Z3VzdCAgNiwgMjAyMDxicj4KPGJyPgpEZWFyIE9wZXJhdGlvbnMgVGVhbSw8YnI+CjxiPlRoZSBGYWJ1bG91cyBHZXRhd2F5PC9iPjxicj4KPGJyPgpGb2xsb3dpbmcgYm9va2luZyBpcyBkb25lIGVpdGhlciB0aHJvdWdoIHBheW1lbnQgZ2V0d2F5IHN5c3RlbSBvciB3aXRoaW4gY2FuY2VsbGF0aW9uIGRlYWRsaW5lLjxicj48YnI+CktpbmRseSByZWNoZWNrIHRoaXMgYm9va2luZyBhcyBpdCBtaWdodCBiZSBlaXRoZXI6PGJyPgoKMS4gRmFpbGVkIG9yIG9uLXJlcXVlc3QuPGJyPgoyLiBUaGlzIGJvb2tpbmcgbWF5IGJlIGNhbWUgb24gc3BlY2lhbCBjb25kaXRpb24gPGJyPjxicj4KCgpUaGUgZGV0YWlscyBvZiBib29raW5nIGlzIHByb3ZpZGVkIGJlbG93LiBQbGVhc2UgaGFuZGxlIHRoZSBib29raW5nIG1hbnVhbGx5Lgo8YnI+PGJyPgoJPGI+Qm9va2luZyBJZDwvYj4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDs6Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7VEZHMTAyODA0PGJyPgoJPGI+U3VwcGxpZXI8L2I+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7OiZuYnNwOyZuYnNwOyZuYnNwO2xvY2Fsc3lzdGVtPGJyPgoJPGJyPjxicj4KQmVzdCBSZWdhcmRzLDxicj4KVGhlIEZhYnVsb3VzIEdldGF3YXkKPGJyPgo8L0JPRFk+CjwvSFRNTD4=',to_email_id= '',cc= '',bcc= '',status= 'You must provide at least one recipient email address.',page_url= '/confirm_booking.php',create_date= '2020-08-06 09:44:26';
[08/06/2020 09:44:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO mails_error_log set mailfrom='sanket.desai@qtechsoftware.com',mailsubject='Special Condition Booking - The Fabulous Getaway',mailbody='
&lt;HTML&gt;
&lt;HEAD&gt;
&lt;TITLE&gt;Special Condition Booking&lt;/TITLE&gt;

&lt;style type=\&quot;text/css\&quot;&gt;
&lt;!--
body {
	margin-left: 10px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
	font: Verdana;
	font-size: 13px;
}
--&gt;
&lt;/style&gt;

&lt;/HEAD&gt;
&lt;BODY&gt;
&lt;br&gt;
Date : Thursday, August  6, 2020&lt;br&gt;
&lt;br&gt;
Dear Operations Team,&lt;br&gt;
&lt;b&gt;The Fabulous Getaway&lt;/b&gt;&lt;br&gt;
&lt;br&gt;
Following booking is done either through payment getway system or within cancellation deadline.&lt;br&gt;&lt;br&gt;
Kindly recheck this booking as it might be either:&lt;br&gt;

1. Failed or on-request.&lt;br&gt;
2. This booking may be came on special condition &lt;br&gt;&lt;br&gt;


The details of booking is provided below. Please handle the booking manually.
&lt;br&gt;&lt;br&gt;
	&lt;b&gt;Booking Id&lt;/b&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;&nbsp;&nbsp;&nbsp;TFG102804&lt;br&gt;
	&lt;b&gt;Supplier&lt;/b&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;&nbsp;&nbsp;localsystem&lt;br&gt;
	&lt;br&gt;&lt;br&gt;
Best Regards,&lt;br&gt;
The Fabulous Getaway
&lt;br&gt;
&lt;/BODY&gt;
&lt;/HTML&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2020-08-06 09:44:26';
[08/06/2020 09:44:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_status (booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by) VALUES ('2804','on_request','2020-08-06 09:44:25','Booking on_request ','25','60.254.42.39','0','25');
[08/06/2020 09:44:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_search_log(booking_id, details)
        VALUES(2804, 'a:30:{s:3:\"_id\";a:1:{s:4:\"$oid\";s:24:\"5f2bd0c50bf84321f14b7f00\";}s:7:\"hotelId\";s:25:\"53757----------S000000227\";s:4:\"name\";s:33:\"COPPER CHIMNEY &NDASH; IMP UPLOAD\";s:14:\"local_hotel_id\";s:5:\"53757\";s:8:\"address1\";s:12:\"Test Address\";s:8:\"latitude\";d:6.278698;s:9:\"longitude\";d:99.730656;s:4:\"city\";s:5:\"64440\";s:8:\"location\";N;s:14:\"prefered_hotel\";s:1:\"0\";s:10:\"mlosSlogan\";s:0:\"\";s:16:\"isMlosApplicable\";s:2:\"no\";s:7:\"country\";s:3:\"106\";s:16:\"rateCurrencyCode\";s:3:\"USD\";s:5:\"phone\";s:16:\"+605 - 1234 5677\";s:16:\"shortDescription\";s:22:\"TEST HOTEL DESCRIPTION\";s:11:\"website_url\";s:20:\"http://www.test.com/\";s:12:\"thumbNailUrl\";s:81:\"http://uat.tfg.otrams.net/project_folder/tfg_project/images/imagenotavailable.jpg\";s:10:\"sourceType\";s:11:\"localsystem\";s:10:\"supplierid\";s:10:\"S000000227\";s:12:\"suppliername\";s:33:\"Copper Chimney &ndash; Imp Upload\";s:14:\"propertyRating\";s:3:\"4.0\";s:15:\"specialCategory\";a:1:{i:0;s:1:\"1\";}s:13:\"HotelProperty\";a:1:{s:11:\"localsystem\";a:2:{i:0;a:1:{s:8:\"RateInfo\";a:13:{s:10:\"room_rates\";a:1:{i:0;a:34:{s:11:\"ratebreakup\";a:4:{s:6:\"markup\";i:0;s:10:\"commission\";i:0;s:18:\"NativeNightlyRates\";a:1:{i:0;a:4:{s:19:\"O_nativeNightlyRate\";i:230;s:17:\"nativeNightlyRate\";i:230;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";a:1:{i:0;s:10:\"0227-11523\";}s:4:\"Name\";a:1:{i:0;s:9:\"Promotion\";}s:7:\"S_Value\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:5:\"Value\";i:0;s:12:\"Display_Name\";a:1:{i:0;s:9:\"Promotion\";}s:10:\"Offer_Note\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:10:\"Offer_Type\";N;}}}s:19:\"DisplayNightlyRates\";a:1:{i:0;a:3:{s:18:\"displayNightlyRate\";d:4.05;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:201:\"Supplier Name - localsupplier(Copper Chimney &ndash; Imp Upload - S000000227), Rate - 230 INR, Currency Multiplier (INR-USD) - 0.01533 Supplier Commission-0 , Branch:% #localsystem, VAT Markup=15.000%,\";}}}s:20:\"offer_promotion_note\";s:0:\"\";s:19:\"offer_discount_note\";s:9:\"Promotion\";s:19:\"offer_discount_type\";s:0:\"\";s:27:\"offer_discount_note_details\";s:11:\"~ FREE WIFI\";s:9:\"room_name\";s:6:\"double\";s:9:\"stay_note\";N;s:10:\"time_stamp\";s:32:\"bb7306b2c2d3d1f9a40892ce82add867\";s:16:\"number_of_adults\";s:1:\"2\";s:10:\"view_basis\";s:0:\"\";s:13:\"view_basis_id\";s:1:\"0\";s:9:\"available\";i:0;s:9:\"free_sale\";N;s:7:\"minStay\";s:1:\"0\";s:19:\"displayCurrencyCode\";s:3:\"USD\";s:18:\"nativeCurrencyCode\";s:3:\"INR\";s:20:\"displayRoomTypeRates\";d:4.05;s:20:\"sortingRoomTypeRates\";i:40500;s:19:\"nativeRoomTypeRates\";i:230;s:12:\"offerApplied\";N;s:7:\"room_id\";s:48:\"2~~~133~~~953~~~1~~~~~~~~~64440~~~0~~~S000000227\";s:14:\"room_type_code\";s:1:\"2\";s:14:\"boardtype_code\";s:1:\"1\";s:16:\"valuation_number\";s:48:\"2~~~133~~~953~~~1~~~~~~~~~64440~~~0~~~S000000227\";s:15:\"number_of_child\";i:0;s:13:\"NumberOfRooms\";i:1;s:10:\"supplierId\";s:10:\"S000000227\";s:12:\"supplierName\";s:33:\"Copper Chimney &ndash; Imp Upload\";s:10:\"meal_basis\";s:15:\"Bed & Breakfast\";s:4:\"note\";s:37:\"Promotion~ FREE WIFI (Non-Refundable)\";s:13:\"room_category\";s:23:\"Junior Suite Tower Room\";s:9:\"room_type\";s:107:\"Junior Suite Tower  -Bed & Breakfast : 2 Pax <br>( Promotion)<br>(Offer Note: ~ FREE WIFI) (Non-Refundable)\";s:14:\"non_refundable\";s:1:\"1\";s:15:\"class_unique_id\";s:17:\"0_0_53757_1215999\";}}s:9:\"available\";i:0;s:15:\"displayRoomRate\";d:4.05;s:14:\"nativeRoomRate\";i:230;s:9:\"unique_id\";s:37:\"1_53757----------S000000227_9_0_44219\";s:10:\"supplierId\";s:10:\"S000000227\";s:19:\"displayCurrencyCode\";s:3:\"USD\";s:18:\"nativeCurrencyCode\";s:3:\"INR\";s:18:\"applied_markup_per\";i:15;s:18:\"applied_multiplier\";d:0.01533;s:19:\"supplier_profile_id\";s:1:\"1\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53757----------S000000227\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:33:\"COPPER CHIMNEY &NDASH; IMP UPLOAD\";s:18:\"supp_hotel_address\";s:12:\"Test Address\";s:10:\"supplierId\";s:10:\"S000000227\";}s:8:\"no_class\";i:0;}}i:1;a:1:{s:8:\"RateInfo\";a:13:{s:10:\"room_rates\";a:1:{i:0;a:34:{s:11:\"ratebreakup\";a:4:{s:6:\"markup\";i:0;s:10:\"commission\";i:0;s:18:\"NativeNightlyRates\";a:1:{i:0;a:4:{s:19:\"O_nativeNightlyRate\";i:230;s:17:\"nativeNightlyRate\";i:230;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";a:1:{i:0;s:10:\"0227-11523\";}s:4:\"Name\";a:1:{i:0;s:9:\"Promotion\";}s:7:\"S_Value\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:5:\"Value\";i:0;s:12:\"Display_Name\";a:1:{i:0;s:9:\"Promotion\";}s:10:\"Offer_Note\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:10:\"Offer_Type\";N;}}}s:19:\"DisplayNightlyRates\";a:1:{i:0;a:3:{s:18:\"displayNightlyRate\";d:4.05;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:201:\"Supplier Name - localsupplier(Copper Chimney &ndash; Imp Upload - S000000227), Rate - 230 INR, Currency Multiplier (INR-USD) - 0.01533 Supplier Commission-0 , Branch:% #localsystem, VAT Markup=15.000%,\";}}}s:20:\"offer_promotion_note\";s:0:\"\";s:19:\"offer_discount_note\";s:9:\"Promotion\";s:19:\"offer_discount_type\";s:0:\"\";s:27:\"offer_discount_note_details\";s:11:\"~ FREE WIFI\";s:9:\"room_name\";s:6:\"double\";s:9:\"stay_note\";N;s:10:\"time_stamp\";s:32:\"07826fed6f092fb074ba0df62d6184ed\";s:16:\"number_of_adults\";s:1:\"2\";s:10:\"view_basis\";s:0:\"\";s:13:\"view_basis_id\";s:1:\"0\";s:9:\"available\";i:0;s:9:\"free_sale\";N;s:7:\"minStay\";s:1:\"0\";s:19:\"displayCurrencyCode\";s:3:\"USD\";s:18:\"nativeCurrencyCode\";s:3:\"INR\";s:20:\"displayRoomTypeRates\";d:4.05;s:20:\"sortingRoomTypeRates\";i:40500;s:19:\"nativeRoomTypeRates\";i:230;s:12:\"offerApplied\";N;s:7:\"room_id\";s:48:\"2~~~133~~~954~~~1~~~~~~~~~64440~~~1~~~S000000227\";s:14:\"room_type_code\";s:1:\"2\";s:14:\"boardtype_code\";s:1:\"1\";s:16:\"valuation_number\";s:48:\"2~~~133~~~954~~~1~~~~~~~~~64440~~~1~~~S000000227\";s:15:\"number_of_child\";i:0;s:13:\"NumberOfRooms\";i:1;s:10:\"supplierId\";s:10:\"S000000227\";s:12:\"supplierName\";s:33:\"Copper Chimney &ndash; Imp Upload\";s:10:\"meal_basis\";s:15:\"Bed & Breakfast\";s:4:\"note\";s:20:\"Promotion~ FREE WIFI\";s:13:\"room_category\";s:23:\"Junior Suite Tower Room\";s:9:\"room_type\";s:90:\"Junior Suite Tower  -Bed & Breakfast : 2 Pax <br>( Promotion)<br>(Offer Note: ~ FREE WIFI)\";s:14:\"non_refundable\";s:1:\"0\";s:15:\"class_unique_id\";s:16:\"1_1_53757_408331\";}}s:9:\"available\";i:0;s:15:\"displayRoomRate\";d:4.05;s:14:\"nativeRoomRate\";i:230;s:9:\"unique_id\";s:37:\"1_53757----------S000000227_9_1_11368\";s:10:\"supplierId\";s:10:\"S000000227\";s:19:\"displayCurrencyCode\";s:3:\"USD\";s:18:\"nativeCurrencyCode\";s:3:\"INR\";s:18:\"applied_markup_per\";i:15;s:18:\"applied_multiplier\";d:0.01533;s:19:\"supplier_profile_id\";s:1:\"1\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53757----------S000000227\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:33:\"COPPER CHIMNEY &NDASH; IMP UPLOAD\";s:18:\"supp_hotel_address\";s:12:\"Test Address\";s:10:\"supplierId\";s:10:\"S000000227\";}s:8:\"no_class\";i:0;}}}}s:13:\"total_charges\";d:4.05;s:17:\"propertyAvailable\";i:0;s:8:\"no_class\";i:0;s:18:\"sort_total_charges\";i:405000;s:16:\"hotel_name_ascii\";s:33:\"copper chimney &ndash; imp upload\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53757----------S000000227\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:33:\"COPPER CHIMNEY &NDASH; IMP UPLOAD\";s:18:\"supp_hotel_address\";s:12:\"Test Address\";s:10:\"supplierId\";s:10:\"S000000227\";}}');
[08/06/2020 09:44:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,to_date,supplier_to_date,supplier_charge,agent_charge,lead_time,create_date,applied_agent_charges)  VALUES('2804','2020-08-06 09:43:00','2020-08-06 09:43:00','1970-01-01 00:00:00','1970-01-01 00:00:00','230','4.05','0','2020-08-06 09:44:26','');
[08/06/2020 09:44:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO bookings_applicable_offer set  oid= '0227-11523',  offer_type_code= 'PM',  booking_id= '2804',  room_id= '2~~~133~~~953~~~1~~~~~~~~~64440~~~0~~~S000000227',  room_name= 'double',  supplier_id= 'S000000227',  agent_id= '',  promotion_text= '',  offer_disc_type= 'Discount',  offer_disc_value= '',  offer_disc_currency= '',  create_date= '2020-08-06 09:44:26' ;
[08/06/2020 09:44:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into booking_configuration set  booking_id = '2804', config_key = 'BOOKING OTP', config_value = 'N48WNWzz';;
[08/06/2020 09:44:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= ' TFG102804 /  Booking On Request ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 37692 characters]',to_email_id= 'example1@test.com,example2@test.com,example3@test.com,example@test.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking.php',create_date= '2020-08-06 09:44:26';
[08/06/2020 09:44:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('2804','example1@test.com');
[08/06/2020 09:44:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('2804','example2@test.com');
[08/06/2020 09:44:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('2804','example3@test.com');
[08/06/2020 09:44:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('2804','example1@test.com');
[08/06/2020 09:44:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('2804','example2@test.com');
[08/06/2020 09:44:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('2804','example3@test.com');
[08/06/2020 09:44:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('2804','example@test.com');
[08/06/2020 09:44:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update posted_bookings set booking_id='2804',status='1' where reservation_id='QTECH2020081724' and booking_id ='0';
[08/06/2020 09:44:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update xmllogs set reservation_id='2804' where agent_logs_id='363' and source_type='localsystem';
[08/06/2020 09:44:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='',  profit_percent='',  gross_profit='',  commission_tax='',  booking_id ='2804',  create_date ='2020-08-06 09:44:26', supplier_tax='';
[08/06/2020 09:44:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'PGJyPi0tLS0tLS0tLSAKCjxicj5FcnJvcjoKU1FMU1RBVEVbNDJTMjJdOiBDb2x1bW4gbm90IGZvdW5kOiAxMDU0IFVua25vd24gY29sdW1uICdzdXBwbGllcl90YXgnIGluICdmaWVsZCBsaXN0JyBmcm9tIE90cmFtc0RCLnBocCBvbiAwNi0wOC0yMDIwIDA5OjQ0OjI2CiBRdWVyeTpJTlNFUlQgSU5UTyBib29raW5nX2NvbW1pc3Npb24gc2V0IGFnZW50X2NvbW1pc3Npb249JycsICBzdXBwbGllcl9jb21taXNzaW9uPScnLCAgcHJvZml0X3BlcmNlbnQ9JycsICBncm9zc19wcm9maXQ9JycsICBjb21taXNzaW9uX3RheD0nJywgIGJvb2tpbmdfaWQgPScyODA0JywgIGNyZWF0ZV9kYXRlID0nMjAyMC0wOC0wNiAwOTo0NDoyNicsIHN1cHBsaWVyX3RheD0nJwoKL2NvbmZpcm1fYm9va2luZy5waHAKCjxwcmU+Ckhvc3RuYW1lOiBxdGVjaC5vdHJhbXMuY29tCiA8YnI+CgpDb25uZWN0aW9uOiBvdHJhbXNfdGhlZmFiQDIwOS4yMzYuMTE0LjE3NAoKQmFja3RyYWNlOgphcnJheSAoCiAgMCA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9PdHJhbXNEQi5waHAnLAogICAgJ2xpbmUnID0+IDI0NiwKICAgICdmdW5jdGlvbicgPT4gJ3dyaXRlRXJyb3InLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAxID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL0Jvb2tpbmcucGhwJywKICAgICdsaW5lJyA9PiAxNjQ2LAogICAgJ2Z1bmN0aW9uJyA9PiAncXVlcnknLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAyID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL0hvdGVsX0Jvb2tpbmcucGhwJywKICAgICdsaW5lJyA9PiAyMjUwLAogICAgJ2Z1bmN0aW9uJyA9PiAncG9zdF9ib29raW5nX29wZXJhdGlvbicsCiAgICAnY2xhc3MnID0+ICdCb29raW5nJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMyA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy9jb25maXJtX2Jvb2tpbmcucGhwJywKICAgICdsaW5lJyA9PiA4LAogICAgJ2Z1bmN0aW9uJyA9PiAnY29uZmlybV9ib29raW5nJywKICAgICdjbGFzcycgPT4gJ0hvdGVsX0Jvb2tpbmcnLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKKQoKL2NvbmZpcm1fYm9va2luZy5waHAKdWF0LnRmZy5vdHJhbXMubmV0LCBDbGllbnQgSVA6IDYwLjI1NC40Mi4zOTwvcHJlPjxicj4KYXJyYXkgKAogIDAgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvT3RyYW1zREIucGhwJywKICAgICdsaW5lJyA9PiAyNDYsCiAgICAnZnVuY3Rpb24nID0+ICd3cml0ZUVycm9yJywKICAgICdjbGFzcycgPT4gJ090cmFtc0RCJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMSA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9Cb29raW5nLnBocCcsCiAgICAnbGluZScgPT4gMTY0NiwKICAgICdmdW5jdGlvbicgPT4gJ3F1ZXJ5JywKICAgICdjbGFzcycgPT4gJ090cmFtc0RCJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMiA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9Ib3RlbF9Cb29raW5nLnBocCcsCiAgICAnbGluZScgPT4gMjI1MCwKICAgICdmdW5jdGlvbicgPT4gJ3Bvc3RfYm9va2luZ19vcGVyYXRpb24nLAogICAgJ2NsYXNzJyA9PiAnQm9va2luZycsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDMgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvY29uZmlybV9ib29raW5nLnBocCcsCiAgICAnbGluZScgPT4gOCwKICAgICdmdW5jdGlvbicgPT4gJ2NvbmZpcm1fYm9va2luZycsCiAgICAnY2xhc3MnID0+ICdIb3RlbF9Cb29raW5nJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCik=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking.php',create_date= '2020-08-06 09:44:26';
[08/06/2020 09:44:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= ' TFG102804 /  Booking On Request ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 27204 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,SalesConsultant@gmail.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking.php',create_date= '2020-08-06 09:44:27';
[08/06/2020 09:44:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('2804','snehal.valanju@qtechsoftware.com');
[08/06/2020 09:44:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('2804','SalesConsultant@gmail.com');
[08/06/2020 09:44:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= 'Special Remark / Request Added  For Booking ID-2804 - The Fabulous Getaway',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICwgPGJyPjxici8+U3BlY2lhbCBSZW1hcmsgLyBSZXF1ZXN0IEFkZGVkICBGb3IgQm9va2luZyBJRC0gPGI+MjgwNCA8L2I+PGJyLz4gQmVsb3cgYXJlIHRoZSBEZXRhaWxzIDxicj48YnIvPlNwZWNpYWwgUmVxdWVzdCA8YnI+MSk6IE5PTiBTTU9LSU5HIFJPT008YnI+T3RoZXIgUmVtYXJrIDo8YnI+PGJyLz4=',to_email_id= '',cc= '',bcc= '',status= 'You must provide at least one recipient email address.',page_url= '/confirm_booking.php',create_date= '2020-08-06 09:44:28';
[08/06/2020 09:44:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO mails_error_log set mailfrom='sanket.desai@qtechsoftware.com',mailsubject='Special Remark / Request Added  For Booking ID-2804 - The Fabulous Getaway',mailbody='Dear Team , &lt;br&gt;&lt;br/&gt;Special Remark / Request Added  For Booking ID- &lt;b&gt;2804 &lt;/b&gt;&lt;br/&gt; Below are the Details &lt;br&gt;&lt;br/&gt;Special Request &lt;br&gt;1): NON SMOKING ROOM&lt;br&gt;Other Remark :&lt;br&gt;&lt;br/&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2020-08-06 09:44:28';
[08/06/2020 09:44:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '60.254.42.39' , city = 'mumbai' , arrival_date='2020/08/06',  departure_date='2020/08/06',  nights='1',  create_date='2020-08-06 :09:44:51',  nationality='106',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='1',  total_children='0',  site_id = '' ;
[08/06/2020 09:46:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596707184','60.254.42.39');
[08/06/2020 09:47:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[08/06/2020 09:47:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[08/06/2020 09:48:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '60.254.42.39' , city = 'Mumbai' , arrival_date='2020/08/13',  departure_date='2020/08/13',  nights='1',  create_date='2020-08-06 :09:48:27',  nationality='106',  additional_markup='',  selected_currency='USD',  service_type='transfer',  total_adult='1',  total_children='',  site_id = '' ;
[08/06/2020 09:50:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-08-06 09:50:32',login_attempt=0 where id = '25';
[08/06/2020 09:50:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'PHPTEST', user_type = 'A', branch_id = '1', login_datetime = '2020-08-06 09:50:32', ip = '60.254.42.39', action = 'Login' ;
[08/06/2020 09:50:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[08/06/2020 09:51:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/message_action.php],insert into email_logs SET `subject`= 'Message Acknowledgment - The Fabulous Getaway',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 4740 characters]',to_email_id= 'otramsmessages@thefabulousgetaway.com,SalesConsultant@gmail.com',cc= 'snehal.valanju@qtechsoftware.com',bcc= '',status= 'Success',page_url= '/message_action.php',create_date= '2020-08-06 09:51:17';
[08/06/2020 09:51:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[08/06/2020 09:51:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/note_action.php],INSERT INTO msg_reminder set message_id= '10',remind_to= '',remind_datetime= '2020-08-06 19:00:00';
[08/06/2020 09:51:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/note_action.php],UPDATE msg_note set remind_datetime= '2020-08-06 19:00:00' where id= '10';
[08/06/2020 09:52:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/booking_list.php],update messages set mssg_status='R' where booking_id=?;


[08/06/2020 09:55:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/manage_sub_user.php],insert into email_logs SET `subject`= 'Login Details - The Fabulous Getaway',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 14784 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/manage_sub_user.php?action_name=add',create_date= '2020-08-06 09:55:54';
[08/06/2020 09:56:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/manage_sub_user.php],update sub_user SET first_name='Staffone',middle_name='',last_name='Test',address='Mumbai',city='64440',country='106',phone=' 23-12345567',mobile=' 23-12345567',designation='',can_book='',can_voucher='',view_all_bookings='0',allow_book_under_cancellation='',modify_date='2020-08-06 09:56:23',email='snehal.valanju@qtechsoftware.com',status='A'where sub_user_id='8';

[08/06/2020 09:57:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/manage_sub_user.php],UPDATE sub_user SET status='I',modify_date='2020-08-06 09:57:15'  WHERE sub_user_id='8';
[08/06/2020 09:57:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/manage_sub_user.php],UPDATE sub_user SET status='A',modify_date='2020-08-06 09:57:21' ,expiry_date='2020-11-04 09:57:21', login_attempt=0  WHERE sub_user_id='8';
[08/06/2020 09:57:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/manage_sub_user.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'PGJyPi0tLS0tLS0tLSAKCjxicj5FcnJvcjoKU1FMU1RBVEVbNDJTMjJdOiBDb2x1bW4gbm90IGZvdW5kOiAxMDU0IFVua25vd24gY29sdW1uICdsb2dpbl9hdHRlbXB0JyBpbiAnZmllbGQgbGlzdCcgZnJvbSBPdHJhbXNEQi5waHAgb24gMDYtMDgtMjAyMCAwOTo1NzoyMQogUXVlcnk6VVBEQVRFIHN1Yl91c2VyIFNFVCBzdGF0dXM9J0EnLG1vZGlmeV9kYXRlPScyMDIwLTA4LTA2IDA5OjU3OjIxJyAsZXhwaXJ5X2RhdGU9JzIwMjAtMTEtMDQgMDk6NTc6MjEnLCBsb2dpbl9hdHRlbXB0PTAgIFdIRVJFIHN1Yl91c2VyX2lkPSc4JwoKL21hbmFnZV9zdWJfdXNlci5waHA/YWN0aW9uX25hbWU9YWN0aXZlJnN1Yl91c2VyX2lkPTgKCjxwcmU+Ckhvc3RuYW1lOiBxdGVjaC5vdHJhbXMuY29tCiA8YnI+CgpDb25uZWN0aW9uOiBvdHJhbXNfdGhlZmFiQDIwOS4yMzYuMTE0LjE3NAoKQmFja3RyYWNlOgphcnJheSAoCiAgMCA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9PdHJhbXNEQi5waHAnLAogICAgJ2xpbmUnID0+IDI0NiwKICAgICdmdW5jdGlvbicgPT4gJ3dyaXRlRXJyb3InLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAxID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL1N1Yl9Vc2VyLnBocCcsCiAgICAnbGluZScgPT4gMzUsCiAgICAnZnVuY3Rpb24nID0+ICdxdWVyeScsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDIgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvbWFuYWdlX3N1Yl91c2VyLnBocCcsCiAgICAnbGluZScgPT4gNzEsCiAgICAnZnVuY3Rpb24nID0+ICdhY3RpdmUnLAogICAgJ2NsYXNzJyA9PiAnU3ViX1VzZXInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKKQoKL21hbmFnZV9zdWJfdXNlci5waHA/YWN0aW9uX25hbWU9YWN0aXZlJnN1Yl91c2VyX2lkPTgKdWF0LnRmZy5vdHJhbXMubmV0LCBDbGllbnQgSVA6IDYwLjI1NC40Mi4zOTwvcHJlPjxicj4KYXJyYXkgKAogIDAgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvT3RyYW1zREIucGhwJywKICAgICdsaW5lJyA9PiAyNDYsCiAgICAnZnVuY3Rpb24nID0+ICd3cml0ZUVycm9yJywKICAgICdjbGFzcycgPT4gJ090cmFtc0RCJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMSA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9TdWJfVXNlci5waHAnLAogICAgJ2xpbmUnID0+IDM1LAogICAgJ2Z1bmN0aW9uJyA9PiAncXVlcnknLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAyID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL21hbmFnZV9zdWJfdXNlci5waHAnLAogICAgJ2xpbmUnID0+IDcxLAogICAgJ2Z1bmN0aW9uJyA9PiAnYWN0aXZlJywKICAgICdjbGFzcycgPT4gJ1N1Yl9Vc2VyJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCik=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/manage_sub_user.php?action_name=active&sub_user_id=8',create_date= '2020-08-06 09:57:21';
[08/06/2020 09:57:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/manage_sub_user.php],UPDATE sub_user SET status='A',modify_date='2020-08-06 09:57:26' ,expiry_date='2020-11-04 09:57:26', login_attempt=0  WHERE sub_user_id='8';
[08/06/2020 09:57:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/manage_sub_user.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'PGJyPi0tLS0tLS0tLSAKCjxicj5FcnJvcjoKU1FMU1RBVEVbNDJTMjJdOiBDb2x1bW4gbm90IGZvdW5kOiAxMDU0IFVua25vd24gY29sdW1uICdsb2dpbl9hdHRlbXB0JyBpbiAnZmllbGQgbGlzdCcgZnJvbSBPdHJhbXNEQi5waHAgb24gMDYtMDgtMjAyMCAwOTo1NzoyNgogUXVlcnk6VVBEQVRFIHN1Yl91c2VyIFNFVCBzdGF0dXM9J0EnLG1vZGlmeV9kYXRlPScyMDIwLTA4LTA2IDA5OjU3OjI2JyAsZXhwaXJ5X2RhdGU9JzIwMjAtMTEtMDQgMDk6NTc6MjYnLCBsb2dpbl9hdHRlbXB0PTAgIFdIRVJFIHN1Yl91c2VyX2lkPSc4JwoKL21hbmFnZV9zdWJfdXNlci5waHA/YWN0aW9uX25hbWU9YWN0aXZlJnN1Yl91c2VyX2lkPTgKCjxwcmU+Ckhvc3RuYW1lOiBxdGVjaC5vdHJhbXMuY29tCiA8YnI+CgpDb25uZWN0aW9uOiBvdHJhbXNfdGhlZmFiQDIwOS4yMzYuMTE0LjE3NAoKQmFja3RyYWNlOgphcnJheSAoCiAgMCA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9PdHJhbXNEQi5waHAnLAogICAgJ2xpbmUnID0+IDI0NiwKICAgICdmdW5jdGlvbicgPT4gJ3dyaXRlRXJyb3InLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAxID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL1N1Yl9Vc2VyLnBocCcsCiAgICAnbGluZScgPT4gMzUsCiAgICAnZnVuY3Rpb24nID0+ICdxdWVyeScsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDIgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvbWFuYWdlX3N1Yl91c2VyLnBocCcsCiAgICAnbGluZScgPT4gNzEsCiAgICAnZnVuY3Rpb24nID0+ICdhY3RpdmUnLAogICAgJ2NsYXNzJyA9PiAnU3ViX1VzZXInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKKQoKL21hbmFnZV9zdWJfdXNlci5waHA/YWN0aW9uX25hbWU9YWN0aXZlJnN1Yl91c2VyX2lkPTgKdWF0LnRmZy5vdHJhbXMubmV0LCBDbGllbnQgSVA6IDYwLjI1NC40Mi4zOTwvcHJlPjxicj4KYXJyYXkgKAogIDAgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvT3RyYW1zREIucGhwJywKICAgICdsaW5lJyA9PiAyNDYsCiAgICAnZnVuY3Rpb24nID0+ICd3cml0ZUVycm9yJywKICAgICdjbGFzcycgPT4gJ090cmFtc0RCJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMSA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9TdWJfVXNlci5waHAnLAogICAgJ2xpbmUnID0+IDM1LAogICAgJ2Z1bmN0aW9uJyA9PiAncXVlcnknLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAyID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL21hbmFnZV9zdWJfdXNlci5waHAnLAogICAgJ2xpbmUnID0+IDcxLAogICAgJ2Z1bmN0aW9uJyA9PiAnYWN0aXZlJywKICAgICdjbGFzcycgPT4gJ1N1Yl9Vc2VyJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCik=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/manage_sub_user.php?action_name=active&sub_user_id=8',create_date= '2020-08-06 09:57:26';
[08/06/2020 09:57:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/manage_sub_user.php],UPDATE sub_user SET status='A',modify_date='2020-08-06 09:57:31' ,expiry_date='2020-11-04 09:57:31', login_attempt=0  WHERE sub_user_id='8';
[08/06/2020 09:57:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/manage_sub_user.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'PGJyPi0tLS0tLS0tLSAKCjxicj5FcnJvcjoKU1FMU1RBVEVbNDJTMjJdOiBDb2x1bW4gbm90IGZvdW5kOiAxMDU0IFVua25vd24gY29sdW1uICdsb2dpbl9hdHRlbXB0JyBpbiAnZmllbGQgbGlzdCcgZnJvbSBPdHJhbXNEQi5waHAgb24gMDYtMDgtMjAyMCAwOTo1NzozMQogUXVlcnk6VVBEQVRFIHN1Yl91c2VyIFNFVCBzdGF0dXM9J0EnLG1vZGlmeV9kYXRlPScyMDIwLTA4LTA2IDA5OjU3OjMxJyAsZXhwaXJ5X2RhdGU9JzIwMjAtMTEtMDQgMDk6NTc6MzEnLCBsb2dpbl9hdHRlbXB0PTAgIFdIRVJFIHN1Yl91c2VyX2lkPSc4JwoKL21hbmFnZV9zdWJfdXNlci5waHA/YWN0aW9uX25hbWU9YWN0aXZlJnN1Yl91c2VyX2lkPTgKCjxwcmU+Ckhvc3RuYW1lOiBxdGVjaC5vdHJhbXMuY29tCiA8YnI+CgpDb25uZWN0aW9uOiBvdHJhbXNfdGhlZmFiQDIwOS4yMzYuMTE0LjE3NAoKQmFja3RyYWNlOgphcnJheSAoCiAgMCA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9PdHJhbXNEQi5waHAnLAogICAgJ2xpbmUnID0+IDI0NiwKICAgICdmdW5jdGlvbicgPT4gJ3dyaXRlRXJyb3InLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAxID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL1N1Yl9Vc2VyLnBocCcsCiAgICAnbGluZScgPT4gMzUsCiAgICAnZnVuY3Rpb24nID0+ICdxdWVyeScsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDIgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvbWFuYWdlX3N1Yl91c2VyLnBocCcsCiAgICAnbGluZScgPT4gNzEsCiAgICAnZnVuY3Rpb24nID0+ICdhY3RpdmUnLAogICAgJ2NsYXNzJyA9PiAnU3ViX1VzZXInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKKQoKL21hbmFnZV9zdWJfdXNlci5waHA/YWN0aW9uX25hbWU9YWN0aXZlJnN1Yl91c2VyX2lkPTgKdWF0LnRmZy5vdHJhbXMubmV0LCBDbGllbnQgSVA6IDYwLjI1NC40Mi4zOTwvcHJlPjxicj4KYXJyYXkgKAogIDAgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvT3RyYW1zREIucGhwJywKICAgICdsaW5lJyA9PiAyNDYsCiAgICAnZnVuY3Rpb24nID0+ICd3cml0ZUVycm9yJywKICAgICdjbGFzcycgPT4gJ090cmFtc0RCJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMSA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9TdWJfVXNlci5waHAnLAogICAgJ2xpbmUnID0+IDM1LAogICAgJ2Z1bmN0aW9uJyA9PiAncXVlcnknLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAyID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL21hbmFnZV9zdWJfdXNlci5waHAnLAogICAgJ2xpbmUnID0+IDcxLAogICAgJ2Z1bmN0aW9uJyA9PiAnYWN0aXZlJywKICAgICdjbGFzcycgPT4gJ1N1Yl9Vc2VyJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCik=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/manage_sub_user.php?action_name=active&sub_user_id=8',create_date= '2020-08-06 09:57:31';
