
[2026-11-05 Thu 01:41:39] : *********************** START Data Parsing Error Checker**************************
[2026-11-05 Thu 01:41:39] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-05'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2026-11-05 Thu 01:41:39] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server Additional SMTP info: php_network_getaddresses: getaddrinfo failed: Name or service not known
[2026-11-05 Thu 01:41:39] : Connection closed
[2026-11-05 Thu 01:41:39] : ************************ END ***************************
[2026-11-05 Thu 03:59:10] : *********************** START Data Parsing Error Checker**************************
[2026-11-05 Thu 05:00:04] : *********************** START **************************
[2026-11-05 Thu 05:00:04] : select id, status_code from status_code where status='Active'
[2026-11-05 Thu 05:00:04] : Status Code Result: 2
[2026-11-05 Thu 05:00:04] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2026-11-05 Thu 05:00:04] : App Info Result: 4
[2026-11-05 Thu 05:00:04] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 05:00:04] : Batch ID: 2026-11-05 05:00:04#Google Play Store#AppInfoId_11#AppName_City Touch
[2026-11-05 Thu 05:00:04] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 05:00:04] : Misc Test: 2026-11-05 05:00:04#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-05 Thu 05:00:04] : APP_VERSION
[2026-11-05 Thu 05:00:04] : 
[2026-11-05 Thu 05:00:04] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (11,2,'','2026-11-05 05:00:04#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-05','2026-11-05 05:00:04','2026-11-04 23:00:04','get-app-info.php')
[2026-11-05 Thu 05:00:04] : 1
[2026-11-05 Thu 05:00:04] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 05:00:04] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 05:00:04] : Misc Test: 2026-11-05 05:00:04#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-05 Thu 05:00:04] : APP_LAST_UPDATE
[2026-11-05 Thu 05:00:05] : 2026-10-08
[2026-11-05 Thu 05:00:05] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (11,5,'2026-10-08','2026-11-05 05:00:04#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-05','2026-11-05 05:00:04','2026-11-04 23:00:04','get-app-info.php')
[2026-11-05 Thu 05:00:05] : 1
[2026-11-05 Thu 05:00:05] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 05:00:05] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 05:00:05] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 05:00:05] : Batch ID: 2026-11-05 05:00:04#Google Play Store#AppInfoId_12#AppName_City Corp
[2026-11-05 Thu 05:00:05] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 05:00:05] : Misc Test: 2026-11-05 05:00:04#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-05 Thu 05:00:05] : APP_VERSION
[2026-11-05 Thu 05:00:05] : 
[2026-11-05 Thu 05:00:05] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (12,2,'','2026-11-05 05:00:04#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-05','2026-11-05 05:00:04','2026-11-04 23:00:04','get-app-info.php')
[2026-11-05 Thu 05:00:05] : 1
[2026-11-05 Thu 05:00:05] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 05:00:05] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 05:00:05] : Misc Test: 2026-11-05 05:00:04#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-05 Thu 05:00:05] : APP_LAST_UPDATE
[2026-11-05 Thu 05:00:05] : 2026-09-09
[2026-11-05 Thu 05:00:05] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (12,5,'2026-09-09','2026-11-05 05:00:04#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-05','2026-11-05 05:00:04','2026-11-04 23:00:04','get-app-info.php')
[2026-11-05 Thu 05:00:05] : 1
[2026-11-05 Thu 05:00:05] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 05:00:05] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 05:00:05] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 05:00:05] : Batch ID: 2026-11-05 05:00:04#Apple I Store#AppInfoId_16#AppName_City Touch
[2026-11-05 Thu 05:00:05] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 05:00:05] : Misc Test: 2026-11-05 05:00:04#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-05 Thu 05:00:05] : APP_VERSION
[2026-11-05 Thu 05:00:06] : 
[2026-11-05 Thu 05:00:06] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (16,2,'','2026-11-05 05:00:04#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-05','2026-11-05 05:00:04','2026-11-04 23:00:04','get-app-info.php')
[2026-11-05 Thu 05:00:06] : 1
[2026-11-05 Thu 05:00:06] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 05:00:06] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 05:00:06] : Misc Test: 2026-11-05 05:00:04#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-05 Thu 05:00:06] : APP_LAST_UPDATE
[2026-11-05 Thu 05:00:06] : --00
[2026-11-05 Thu 05:00:06] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (16,5,'--00','2026-11-05 05:00:04#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-05','2026-11-05 05:00:04','2026-11-04 23:00:04','get-app-info.php')
[2026-11-05 Thu 05:00:06] : 1
[2026-11-05 Thu 05:00:06] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 05:00:06] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 05:00:06] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 05:00:06] : Batch ID: 2026-11-05 05:00:04#Apple I Store#AppInfoId_17#AppName_City Corp
[2026-11-05 Thu 05:00:06] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 05:00:06] : Misc Test: 2026-11-05 05:00:04#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-05 Thu 05:00:06] : APP_VERSION
[2026-11-05 Thu 05:00:06] : 
[2026-11-05 Thu 05:00:06] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (17,2,'','2026-11-05 05:00:04#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-05','2026-11-05 05:00:04','2026-11-04 23:00:04','get-app-info.php')
[2026-11-05 Thu 05:00:06] : 1
[2026-11-05 Thu 05:00:06] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 05:00:06] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 05:00:06] : Misc Test: 2026-11-05 05:00:04#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-05 Thu 05:00:06] : APP_LAST_UPDATE
[2026-11-05 Thu 05:00:06] : --00
[2026-11-05 Thu 05:00:06] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (17,5,'--00','2026-11-05 05:00:04#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-05','2026-11-05 05:00:04','2026-11-04 23:00:04','get-app-info.php')
[2026-11-05 Thu 05:00:06] : 1
[2026-11-05 Thu 05:00:06] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 05:00:06] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 05:00:06] : Connection closed
[2026-11-05 Thu 05:00:06] : ************************ END ***************************
[2026-11-05 Thu 06:41:10] : *********************** START Data Parsing Error Checker**************************
[2026-11-05 Thu 06:41:10] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-05'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2026-11-05 Thu 06:41:10] : Total Record Fetch: 8
[2026-11-05 Thu 06:41:10] : 2026-11-05 05:00:04 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 06:41:10] : 2026-11-05 05:00:04 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 06:41:10] : 2026-11-05 05:00:04 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 06:41:10] : 2026-11-05 05:00:04 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 06:41:10] : 2026-11-05 05:00:04 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-05 Thu 06:41:10] : 2026-11-05 05:00:04 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 06:41:10] : 2026-11-05 05:00:04 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-10-08<br />
[2026-11-05 Thu 06:41:10] : 2026-11-05 05:00:04 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 06:41:10] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server Additional SMTP info: php_network_getaddresses: getaddrinfo failed: Name or service not known
[2026-11-05 Thu 06:41:10] : Connection closed
[2026-11-05 Thu 06:41:10] : ************************ END ***************************
[2026-11-05 Thu 07:00:04] : *********************** START Send Deviation Alert**************************
[2026-11-05 Thu 07:00:04] : SELECT DISTINCT t1.*,t2.*  FROM 
				(
				SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.`executed_date` AS date_bd
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-05'
				) t1
				LEFT OUTER JOIN
				(
				SELECT ai.id AS id_1, ai.app_name AS app_name_1, ai.app_store AS app_store_1, ai.app_org AS app_org_1, sc.status_code AS status_code_1,
				 sc.status_code_desc AS status_code_desc_1, ais.status_value AS status_value_1
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-04'
				) t2 ON t1.id=t2.id_1 and t1.status_code=t2.status_code_1
				ORDER BY t1.`app_store`, t1.`app_name`, t1.`status_code`, t1.`date_bd` DESC
[2026-11-05 Thu 07:00:04] : Total Record Fetch: 8
[2026-11-05 Thu 07:00:04] : <h1 style="color:green">No Mismatch Found!!!</h1>
[2026-11-05 Thu 07:00:04] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: QUIT command failed Detail: êZañ£*ŒÃÖ<FŸ
•ô9f{ .üL°	b)�	-ÁÃfB¦É–Tà0çØäïâGuHýG6ì€€Ðl¢¥V;zX)û1Áü¾œ}A;Ä°IãSFÝ'`¯.Æ1~ —§~žØâEXÎú‰œ)ž©N
Ù%H�2("Èd"y!þ~µÞ‘5e+šKB™Ÿ¶…TAxB_¤Ù¾÷„ÙG÷á%mb>£åz‰ŒHEÎuM'+‡st!ÎÿŸ?OËC¿zÍx)§VxÃ÷®š7‹§ˆ]~û	C1ª·–m.Tw›0ækîæåûÍ @�‘pv¤÷„ÛûŽ’Îðv|™]ìÒþp”|òÛ´FºñŠ„ E‡�ý®‹~ž�1�0Ù§žC¦K	Øpè^ñ ø'k¾æ¸}uÀ£ú#t'Â¿»’Cð@›Ã“€1hö‹¯89ª¢ï`ÀR221 pink.dnsnetservice.com closing connection

[2026-11-05 Thu 07:00:04] : Connection closed
[2026-11-05 Thu 07:00:04] : ************************ END ***************************
[2026-11-05 Thu 08:37:35] : *********************** START **************************
[2026-11-05 Thu 08:37:35] : select id, status_code from status_code where status='Active'
[2026-11-05 Thu 08:37:35] : Status Code Result: 2
[2026-11-05 Thu 08:37:35] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2026-11-05 Thu 08:37:35] : App Info Result: 4
[2026-11-05 Thu 08:37:35] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 08:37:35] : Batch ID: 2026-11-05 08:37:35#Google Play Store#AppInfoId_11#AppName_City Touch
[2026-11-05 Thu 08:37:35] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 08:37:35] : Misc Test: 2026-11-05 08:37:35#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-05 Thu 08:37:35] : APP_VERSION
[2026-11-05 Thu 08:37:35] : 
[2026-11-05 Thu 08:37:35] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (11,2,'','2026-11-05 08:37:35#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-05','2026-11-05 08:37:35','2026-11-05 08:37:35','get-app-info.php')
[2026-11-05 Thu 08:37:35] : 1
[2026-11-05 Thu 08:37:35] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 08:37:35] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 08:37:35] : Misc Test: 2026-11-05 08:37:35#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-05 Thu 08:37:35] : APP_LAST_UPDATE
[2026-11-05 Thu 08:37:35] : 2026-10-08
[2026-11-05 Thu 08:37:35] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (11,5,'2026-10-08','2026-11-05 08:37:35#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-05','2026-11-05 08:37:35','2026-11-05 08:37:35','get-app-info.php')
[2026-11-05 Thu 08:37:35] : 1
[2026-11-05 Thu 08:37:35] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 08:37:35] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 08:37:35] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 08:37:35] : Batch ID: 2026-11-05 08:37:35#Google Play Store#AppInfoId_12#AppName_City Corp
[2026-11-05 Thu 08:37:35] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 08:37:35] : Misc Test: 2026-11-05 08:37:35#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-05 Thu 08:37:35] : APP_VERSION
[2026-11-05 Thu 08:37:36] : 
[2026-11-05 Thu 08:37:36] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (12,2,'','2026-11-05 08:37:35#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-05','2026-11-05 08:37:35','2026-11-05 08:37:35','get-app-info.php')
[2026-11-05 Thu 08:37:36] : 1
[2026-11-05 Thu 08:37:36] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 08:37:36] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 08:37:36] : Misc Test: 2026-11-05 08:37:35#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-05 Thu 08:37:36] : APP_LAST_UPDATE
[2026-11-05 Thu 08:37:36] : 2026-09-09
[2026-11-05 Thu 08:37:36] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (12,5,'2026-09-09','2026-11-05 08:37:35#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-05','2026-11-05 08:37:35','2026-11-05 08:37:35','get-app-info.php')
[2026-11-05 Thu 08:37:36] : 1
[2026-11-05 Thu 08:37:36] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 08:37:36] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 08:37:36] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 08:37:36] : Batch ID: 2026-11-05 08:37:35#Apple I Store#AppInfoId_16#AppName_City Touch
[2026-11-05 Thu 08:37:36] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 08:37:36] : Misc Test: 2026-11-05 08:37:35#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-05 Thu 08:37:36] : APP_VERSION
[2026-11-05 Thu 08:37:36] : 
[2026-11-05 Thu 08:37:36] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (16,2,'','2026-11-05 08:37:35#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-05','2026-11-05 08:37:35','2026-11-05 08:37:35','get-app-info.php')
[2026-11-05 Thu 08:37:36] : 1
[2026-11-05 Thu 08:37:36] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 08:37:36] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 08:37:36] : Misc Test: 2026-11-05 08:37:35#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-05 Thu 08:37:36] : APP_LAST_UPDATE
[2026-11-05 Thu 08:37:36] : --00
[2026-11-05 Thu 08:37:36] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (16,5,'--00','2026-11-05 08:37:35#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-05','2026-11-05 08:37:35','2026-11-05 08:37:35','get-app-info.php')
[2026-11-05 Thu 08:37:36] : 1
[2026-11-05 Thu 08:37:36] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 08:37:36] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 08:37:36] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 08:37:36] : Batch ID: 2026-11-05 08:37:35#Apple I Store#AppInfoId_17#AppName_City Corp
[2026-11-05 Thu 08:37:36] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 08:37:36] : Misc Test: 2026-11-05 08:37:35#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-05 Thu 08:37:36] : APP_VERSION
[2026-11-05 Thu 08:37:37] : 
[2026-11-05 Thu 08:37:37] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (17,2,'','2026-11-05 08:37:35#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-05','2026-11-05 08:37:35','2026-11-05 08:37:35','get-app-info.php')
[2026-11-05 Thu 08:37:37] : 1
[2026-11-05 Thu 08:37:37] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 08:37:37] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 08:37:37] : Misc Test: 2026-11-05 08:37:35#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-05 Thu 08:37:37] : APP_LAST_UPDATE
[2026-11-05 Thu 08:37:37] : --00
[2026-11-05 Thu 08:37:37] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (17,5,'--00','2026-11-05 08:37:35#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-05','2026-11-05 08:37:35','2026-11-05 08:37:35','get-app-info.php')
[2026-11-05 Thu 08:37:37] : 1
[2026-11-05 Thu 08:37:37] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 08:37:37] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 08:37:37] : Connection closed
[2026-11-05 Thu 08:37:37] : ************************ END ***************************
[2026-11-05 Thu 09:32:07] : *********************** START **************************
[2026-11-05 Thu 09:32:07] : select id, status_code from status_code where status='Active'
[2026-11-05 Thu 09:32:07] : Status Code Result: 2
[2026-11-05 Thu 09:32:07] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2026-11-05 Thu 09:32:07] : App Info Result: 4
[2026-11-05 Thu 09:32:07] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 09:32:07] : Batch ID: 2026-11-05 09:32:07#Google Play Store#AppInfoId_11#AppName_City Touch
[2026-11-05 Thu 09:32:07] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 09:32:07] : Misc Test: 2026-11-05 09:32:07#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-05 Thu 09:32:07] : APP_VERSION
[2026-11-05 Thu 09:32:07] : 
[2026-11-05 Thu 09:32:07] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (11,2,'','2026-11-05 09:32:07#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-05','2026-11-05 09:32:07','2026-11-05 09:32:07','get-app-info.php')
[2026-11-05 Thu 09:32:07] : 1
[2026-11-05 Thu 09:32:07] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 09:32:07] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 09:32:07] : Misc Test: 2026-11-05 09:32:07#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-05 Thu 09:32:07] : APP_LAST_UPDATE
[2026-11-05 Thu 09:32:08] : *********************** START Data Parsing Error Checker**************************
[2026-11-05 Thu 09:32:08] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-05'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2026-11-05 Thu 09:32:08] : 2026-10-08
[2026-11-05 Thu 09:32:08] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (11,5,'2026-10-08','2026-11-05 09:32:07#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-05','2026-11-05 09:32:07','2026-11-05 09:32:07','get-app-info.php')
[2026-11-05 Thu 09:32:08] : 1
[2026-11-05 Thu 09:32:08] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 09:32:08] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 09:32:08] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 09:32:08] : Batch ID: 2026-11-05 09:32:07#Google Play Store#AppInfoId_12#AppName_City Corp
[2026-11-05 Thu 09:32:08] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 09:32:08] : Misc Test: 2026-11-05 09:32:07#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-05 Thu 09:32:08] : APP_VERSION
[2026-11-05 Thu 09:32:08] : Total Record Fetch: 17
[2026-11-05 Thu 09:32:08] : 2026-11-05 08:37:35 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 09:32:08] : 2026-11-05 05:00:04 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 09:32:08] : 2026-11-05 08:37:35 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 09:32:08] : 2026-11-05 05:00:04 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 09:32:08] : 2026-11-05 08:37:35 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 09:32:08] : 2026-11-05 05:00:04 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 09:32:08] : 2026-11-05 08:37:35 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 09:32:08] : 2026-11-05 05:00:04 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 09:32:08] : 2026-11-05 08:37:35 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-05 Thu 09:32:08] : 2026-11-05 05:00:04 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-05 Thu 09:32:08] : 2026-11-05 08:37:35 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 09:32:08] : 2026-11-05 05:00:04 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 09:32:08] : 2026-11-05 08:37:35 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-10-08<br />
[2026-11-05 Thu 09:32:08] : 2026-11-05 05:00:04 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-10-08<br />
[2026-11-05 Thu 09:32:08] : 2026-11-05 09:32:07 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 09:32:08] : 2026-11-05 08:37:35 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 09:32:08] : 2026-11-05 05:00:04 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 09:32:08] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server Additional SMTP info: php_network_getaddresses: getaddrinfo failed: Name or service not known
[2026-11-05 Thu 09:32:08] : Connection closed
[2026-11-05 Thu 09:32:08] : ************************ END ***************************
[2026-11-05 Thu 09:32:08] : 
[2026-11-05 Thu 09:32:08] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (12,2,'','2026-11-05 09:32:07#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-05','2026-11-05 09:32:07','2026-11-05 09:32:07','get-app-info.php')
[2026-11-05 Thu 09:32:08] : 1
[2026-11-05 Thu 09:32:08] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 09:32:08] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 09:32:08] : Misc Test: 2026-11-05 09:32:07#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-05 Thu 09:32:08] : APP_LAST_UPDATE
[2026-11-05 Thu 09:32:08] : 2026-09-09
[2026-11-05 Thu 09:32:08] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (12,5,'2026-09-09','2026-11-05 09:32:07#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-05','2026-11-05 09:32:07','2026-11-05 09:32:07','get-app-info.php')
[2026-11-05 Thu 09:32:08] : 1
[2026-11-05 Thu 09:32:08] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 09:32:08] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 09:32:08] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 09:32:08] : Batch ID: 2026-11-05 09:32:07#Apple I Store#AppInfoId_16#AppName_City Touch
[2026-11-05 Thu 09:32:08] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 09:32:08] : Misc Test: 2026-11-05 09:32:07#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-05 Thu 09:32:08] : APP_VERSION
[2026-11-05 Thu 09:32:09] : *********************** START Send Deviation Alert**************************
[2026-11-05 Thu 09:32:09] : SELECT DISTINCT t1.*,t2.*  FROM 
				(
				SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.`executed_date` AS date_bd
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-05'
				) t1
				LEFT OUTER JOIN
				(
				SELECT ai.id AS id_1, ai.app_name AS app_name_1, ai.app_store AS app_store_1, ai.app_org AS app_org_1, sc.status_code AS status_code_1,
				 sc.status_code_desc AS status_code_desc_1, ais.status_value AS status_value_1
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-04'
				) t2 ON t1.id=t2.id_1 and t1.status_code=t2.status_code_1
				ORDER BY t1.`app_store`, t1.`app_name`, t1.`status_code`, t1.`date_bd` DESC
[2026-11-05 Thu 09:32:09] : *********************** START Data Parsing Error Checker**************************
[2026-11-05 Thu 09:32:09] : Total Record Fetch: 8
[2026-11-05 Thu 09:32:09] : <table width="200" border="1" cellspacing="0" cellpadding="0" style="border: 1px solid #000;font-family: Cambria, 'Hoefler Text', 'Liberation Serif', Times, 'Times New Roman', 'serif';font-size: 14px;">
  <tbody style="border: 1px solid #000;">
    <tr>
      <th style="width: 30px">SL</th>
      <th style="width: 180px">App Store</th>
      <th style="width: 300px">App Name</th>
	  <th style="width: 225px">App Organization</th>
	  <th style="width: 160px">App Status Type</th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #00FFFF">2026-11-05</span></th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #FFA500">2026-11-04</span></th>
	  <th style="width: 160px">Deviation Status</th>
    </tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">1</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">2</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">3</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">4</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">5</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2026-09-09</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2026-09-09</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">6</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">7</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2026-10-08</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2026-10-08</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">8</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr></tbody></table>
[2026-11-05 Thu 09:32:09] : 
[2026-11-05 Thu 09:32:09] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (16,2,'','2026-11-05 09:32:07#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-05','2026-11-05 09:32:07','2026-11-05 09:32:07','get-app-info.php')
[2026-11-05 Thu 09:32:09] : 1
[2026-11-05 Thu 09:32:09] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 09:32:09] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 09:32:09] : Misc Test: 2026-11-05 09:32:07#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-05 Thu 09:32:09] : APP_LAST_UPDATE
[2026-11-05 Thu 09:32:09] : --00
[2026-11-05 Thu 09:32:09] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (16,5,'--00','2026-11-05 09:32:07#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-05','2026-11-05 09:32:07','2026-11-05 09:32:07','get-app-info.php')
[2026-11-05 Thu 09:32:09] : 1
[2026-11-05 Thu 09:32:09] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 09:32:09] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 09:32:09] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 09:32:09] : Batch ID: 2026-11-05 09:32:07#Apple I Store#AppInfoId_17#AppName_City Corp
[2026-11-05 Thu 09:32:09] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 09:32:09] : Misc Test: 2026-11-05 09:32:07#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-05 Thu 09:32:09] : APP_VERSION
[2026-11-05 Thu 09:32:09] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server
[2026-11-05 Thu 09:32:09] : Connection closed
[2026-11-05 Thu 09:32:09] : ************************ END ***************************
[2026-11-05 Thu 09:32:09] : 
[2026-11-05 Thu 09:32:09] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (17,2,'','2026-11-05 09:32:07#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-05','2026-11-05 09:32:07','2026-11-05 09:32:07','get-app-info.php')
[2026-11-05 Thu 09:32:09] : 1
[2026-11-05 Thu 09:32:09] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 09:32:09] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 09:32:09] : Misc Test: 2026-11-05 09:32:07#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-05 Thu 09:32:09] : APP_LAST_UPDATE
[2026-11-05 Thu 09:32:09] : --00
[2026-11-05 Thu 09:32:09] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (17,5,'--00','2026-11-05 09:32:07#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-05','2026-11-05 09:32:07','2026-11-05 09:32:07','get-app-info.php')
[2026-11-05 Thu 09:32:09] : 1
[2026-11-05 Thu 09:32:09] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 09:32:09] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 09:32:09] : Connection closed
[2026-11-05 Thu 09:32:09] : ************************ END ***************************
[2026-11-05 Thu 09:32:09] : *********************** START Send Deviation Alert**************************
[2026-11-05 Thu 09:32:09] : SELECT DISTINCT t1.*,t2.*  FROM 
				(
				SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.`executed_date` AS date_bd
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-05'
				) t1
				LEFT OUTER JOIN
				(
				SELECT ai.id AS id_1, ai.app_name AS app_name_1, ai.app_store AS app_store_1, ai.app_org AS app_org_1, sc.status_code AS status_code_1,
				 sc.status_code_desc AS status_code_desc_1, ais.status_value AS status_value_1
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-04'
				) t2 ON t1.id=t2.id_1 and t1.status_code=t2.status_code_1
				ORDER BY t1.`app_store`, t1.`app_name`, t1.`status_code`, t1.`date_bd` DESC
[2026-11-05 Thu 09:32:09] : *********************** START Data Parsing Error Checker**************************
[2026-11-05 Thu 09:32:09] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-05'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2026-11-05 Thu 09:32:09] : Total Record Fetch: 24
[2026-11-05 Thu 09:32:09] : 2026-11-05 09:32:07 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 09:32:09] : 2026-11-05 08:37:35 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 09:32:09] : 2026-11-05 05:00:04 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 09:32:09] : 2026-11-05 09:32:07 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 09:32:09] : 2026-11-05 08:37:35 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 09:32:09] : 2026-11-05 05:00:04 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 09:32:09] : 2026-11-05 09:32:07 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 09:32:09] : 2026-11-05 08:37:35 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 09:32:09] : 2026-11-05 05:00:04 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 09:32:09] : 2026-11-05 09:32:07 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 09:32:09] : 2026-11-05 08:37:35 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 09:32:09] : 2026-11-05 05:00:04 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 09:32:09] : 2026-11-05 09:32:07 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-05 Thu 09:32:09] : 2026-11-05 08:37:35 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-05 Thu 09:32:09] : 2026-11-05 05:00:04 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-05 Thu 09:32:09] : 2026-11-05 09:32:07 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 09:32:09] : 2026-11-05 08:37:35 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 09:32:09] : 2026-11-05 05:00:04 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 09:32:09] : 2026-11-05 09:32:07 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-10-08<br />
[2026-11-05 Thu 09:32:09] : 2026-11-05 08:37:35 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-10-08<br />
[2026-11-05 Thu 09:32:09] : 2026-11-05 05:00:04 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-10-08<br />
[2026-11-05 Thu 09:32:09] : 2026-11-05 09:32:07 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 09:32:09] : 2026-11-05 08:37:35 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 09:32:09] : 2026-11-05 05:00:04 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 09:32:09] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server Additional SMTP info: php_network_getaddresses: getaddrinfo failed: Name or service not known
[2026-11-05 Thu 09:32:09] : Connection closed
[2026-11-05 Thu 09:32:09] : ************************ END ***************************
[2026-11-05 Thu 09:32:09] : Total Record Fetch: 8
[2026-11-05 Thu 09:32:09] : <h1 style="color:green">No Mismatch Found!!!</h1>
[2026-11-05 Thu 09:32:10] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: QUIT command failed Detail: ¨6X ÷iû@háp6EåŠõŽ=o(›i�]çú‡~�3¢]làmw‚üC†™wæ¨ŠgÅ7 0ß'ÝÃR`¯tfû!A›´¬óœõ0K �LDì–¯U½'³¢½¹_¨J>|ÕÉQ€…gD2Hr«²�¯ô¦ÈŒñRÑÐ•(Á61^BRsLKÖ3 <}½ES'LL×p_Ê—EøÚ `Ôb©\zÊEXc?=Eñ£šVã¯Sj`ZÑ–ªïF^lyV£o§<h+¢»•yz„�'©µÃbQÃ<RÙ†²e»f†˜óšÌ©2ËßI_’”î‚å³<ì-<µBŽŸø®è]ØÁï=ÖHZEUŽ9 E…øš%µzs?ê^,Š¥*‹q	&)Ó‚¾u%d±ÎQé\Å4ÿõ–boM÷÷�ˆ¸’â³ÎßÍDº-221 pink.dnsnetservice.com closing connection

[2026-11-05 Thu 09:32:10] : Connection closed
[2026-11-05 Thu 09:32:10] : ************************ END ***************************
[2026-11-05 Thu 20:52:26] : *********************** START **************************
[2026-11-05 Thu 20:52:26] : select id, status_code from status_code where status='Active'
[2026-11-05 Thu 20:52:26] : Status Code Result: 2
[2026-11-05 Thu 20:52:26] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2026-11-05 Thu 20:52:26] : App Info Result: 4
[2026-11-05 Thu 20:52:26] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:26] : Batch ID: 2026-11-05 20:52:26#Google Play Store#AppInfoId_11#AppName_City Touch
[2026-11-05 Thu 20:52:26] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:26] : Misc Test: 2026-11-05 20:52:26#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-05 Thu 20:52:26] : APP_VERSION
[2026-11-05 Thu 20:52:26] : 
[2026-11-05 Thu 20:52:26] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (11,2,'','2026-11-05 20:52:26#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-05','2026-11-05 20:52:26','2026-11-05 20:52:26','get-app-info.php')
[2026-11-05 Thu 20:52:26] : 1
[2026-11-05 Thu 20:52:26] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:26] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:26] : Misc Test: 2026-11-05 20:52:26#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-05 Thu 20:52:26] : APP_LAST_UPDATE
[2026-11-05 Thu 20:52:26] : 2026-11-05
[2026-11-05 Thu 20:52:26] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (11,5,'2026-11-05','2026-11-05 20:52:26#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-05','2026-11-05 20:52:26','2026-11-05 20:52:26','get-app-info.php')
[2026-11-05 Thu 20:52:26] : 1
[2026-11-05 Thu 20:52:26] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:26] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:26] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:26] : Batch ID: 2026-11-05 20:52:26#Google Play Store#AppInfoId_12#AppName_City Corp
[2026-11-05 Thu 20:52:26] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:26] : Misc Test: 2026-11-05 20:52:26#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-05 Thu 20:52:26] : APP_VERSION
[2026-11-05 Thu 20:52:26] : 
[2026-11-05 Thu 20:52:26] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (12,2,'','2026-11-05 20:52:26#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-05','2026-11-05 20:52:26','2026-11-05 20:52:26','get-app-info.php')
[2026-11-05 Thu 20:52:26] : 1
[2026-11-05 Thu 20:52:26] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:26] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:26] : Misc Test: 2026-11-05 20:52:26#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-05 Thu 20:52:26] : APP_LAST_UPDATE
[2026-11-05 Thu 20:52:27] : 2026-09-09
[2026-11-05 Thu 20:52:27] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (12,5,'2026-09-09','2026-11-05 20:52:26#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-05','2026-11-05 20:52:26','2026-11-05 20:52:26','get-app-info.php')
[2026-11-05 Thu 20:52:27] : 1
[2026-11-05 Thu 20:52:27] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:27] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:27] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:27] : Batch ID: 2026-11-05 20:52:26#Apple I Store#AppInfoId_16#AppName_City Touch
[2026-11-05 Thu 20:52:27] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:27] : Misc Test: 2026-11-05 20:52:26#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-05 Thu 20:52:27] : APP_VERSION
[2026-11-05 Thu 20:52:27] : *********************** START Data Parsing Error Checker**************************
[2026-11-05 Thu 20:52:27] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-05'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2026-11-05 Thu 20:52:27] : Total Record Fetch: 28
[2026-11-05 Thu 20:52:27] : 2026-11-05 09:32:07 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:27] : 2026-11-05 08:37:35 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:27] : 2026-11-05 05:00:04 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:27] : 2026-11-05 09:32:07 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:27] : 2026-11-05 08:37:35 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:27] : 2026-11-05 05:00:04 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:27] : 2026-11-05 09:32:07 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:27] : 2026-11-05 08:37:35 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:27] : 2026-11-05 05:00:04 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:27] : 2026-11-05 09:32:07 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:27] : 2026-11-05 08:37:35 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:27] : 2026-11-05 05:00:04 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:27] : 2026-11-05 20:52:26 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-05 Thu 20:52:27] : 2026-11-05 09:32:07 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-05 Thu 20:52:27] : 2026-11-05 08:37:35 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-05 Thu 20:52:27] : 2026-11-05 05:00:04 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-05 Thu 20:52:27] : 2026-11-05 20:52:26 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:27] : 2026-11-05 09:32:07 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:27] : 2026-11-05 08:37:35 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:27] : 2026-11-05 05:00:04 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:27] : 2026-11-05 20:52:26 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-05 Thu 20:52:27] : 2026-11-05 09:32:07 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-10-08<br />
[2026-11-05 Thu 20:52:27] : 2026-11-05 08:37:35 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-10-08<br />
[2026-11-05 Thu 20:52:27] : 2026-11-05 05:00:04 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-10-08<br />
[2026-11-05 Thu 20:52:27] : 2026-11-05 20:52:26 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:27] : 2026-11-05 09:32:07 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:27] : 2026-11-05 08:37:35 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:27] : 2026-11-05 05:00:04 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:27] : 
[2026-11-05 Thu 20:52:27] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (16,2,'','2026-11-05 20:52:26#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-05','2026-11-05 20:52:26','2026-11-05 20:52:26','get-app-info.php')
[2026-11-05 Thu 20:52:27] : 1
[2026-11-05 Thu 20:52:27] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:27] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:27] : Misc Test: 2026-11-05 20:52:26#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-05 Thu 20:52:27] : APP_LAST_UPDATE
[2026-11-05 Thu 20:52:27] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server Additional SMTP info: php_network_getaddresses: getaddrinfo failed: Name or service not known
[2026-11-05 Thu 20:52:27] : Connection closed
[2026-11-05 Thu 20:52:27] : ************************ END ***************************
[2026-11-05 Thu 20:52:27] : --00
[2026-11-05 Thu 20:52:27] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (16,5,'--00','2026-11-05 20:52:26#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-05','2026-11-05 20:52:26','2026-11-05 20:52:26','get-app-info.php')
[2026-11-05 Thu 20:52:27] : 1
[2026-11-05 Thu 20:52:27] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:27] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:27] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:27] : Batch ID: 2026-11-05 20:52:26#Apple I Store#AppInfoId_17#AppName_City Corp
[2026-11-05 Thu 20:52:27] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:27] : Misc Test: 2026-11-05 20:52:26#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-05 Thu 20:52:27] : APP_VERSION
[2026-11-05 Thu 20:52:28] : 
[2026-11-05 Thu 20:52:28] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (17,2,'','2026-11-05 20:52:26#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-05','2026-11-05 20:52:26','2026-11-05 20:52:26','get-app-info.php')
[2026-11-05 Thu 20:52:28] : 1
[2026-11-05 Thu 20:52:28] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:28] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:28] : Misc Test: 2026-11-05 20:52:26#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-05 Thu 20:52:28] : APP_LAST_UPDATE
[2026-11-05 Thu 20:52:28] : --00
[2026-11-05 Thu 20:52:28] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (17,5,'--00','2026-11-05 20:52:26#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-05','2026-11-05 20:52:26','2026-11-05 20:52:26','get-app-info.php')
[2026-11-05 Thu 20:52:28] : 1
[2026-11-05 Thu 20:52:28] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:28] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:28] : Connection closed
[2026-11-05 Thu 20:52:28] : ************************ END ***************************
[2026-11-05 Thu 20:52:28] : *********************** START Send Deviation Alert**************************
[2026-11-05 Thu 20:52:28] : *********************** START Data Parsing Error Checker**************************
[2026-11-05 Thu 20:52:28] : SELECT DISTINCT t1.*,t2.*  FROM 
				(
				SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.`executed_date` AS date_bd
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-05'
				) t1
				LEFT OUTER JOIN
				(
				SELECT ai.id AS id_1, ai.app_name AS app_name_1, ai.app_store AS app_store_1, ai.app_org AS app_org_1, sc.status_code AS status_code_1,
				 sc.status_code_desc AS status_code_desc_1, ais.status_value AS status_value_1
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-04'
				) t2 ON t1.id=t2.id_1 and t1.status_code=t2.status_code_1
				ORDER BY t1.`app_store`, t1.`app_name`, t1.`status_code`, t1.`date_bd` DESC
[2026-11-05 Thu 20:52:28] : Total Record Fetch: 9
[2026-11-05 Thu 20:52:28] : <table width="200" border="1" cellspacing="0" cellpadding="0" style="border: 1px solid #000;font-family: Cambria, 'Hoefler Text', 'Liberation Serif', Times, 'Times New Roman', 'serif';font-size: 14px;">
  <tbody style="border: 1px solid #000;">
    <tr>
      <th style="width: 30px">SL</th>
      <th style="width: 180px">App Store</th>
      <th style="width: 300px">App Name</th>
	  <th style="width: 225px">App Organization</th>
	  <th style="width: 160px">App Status Type</th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #00FFFF">2026-11-05</span></th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #FFA500">2026-11-04</span></th>
	  <th style="width: 160px">Deviation Status</th>
    </tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">1</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">2</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">3</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">4</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">5</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2026-09-09</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2026-09-09</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">6</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">7</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #F00">2026-11-05</td><td style="border: 1px solid #000;width: auto;background-color: #F00">2026-10-08</td><td style="border: 1px solid #000;width: auto">Not Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">8</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2026-10-08</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2026-10-08</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">9</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr></tbody></table>
[2026-11-05 Thu 20:52:29] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server
[2026-11-05 Thu 20:52:29] : Connection closed
[2026-11-05 Thu 20:52:29] : ************************ END ***************************
[2026-11-05 Thu 20:52:29] : *********************** START Send Deviation Alert**************************
[2026-11-05 Thu 20:52:29] : *********************** START Data Parsing Error Checker**************************
[2026-11-05 Thu 20:52:29] : SELECT DISTINCT t1.*,t2.*  FROM 
				(
				SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.`executed_date` AS date_bd
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-05'
				) t1
				LEFT OUTER JOIN
				(
				SELECT ai.id AS id_1, ai.app_name AS app_name_1, ai.app_store AS app_store_1, ai.app_org AS app_org_1, sc.status_code AS status_code_1,
				 sc.status_code_desc AS status_code_desc_1, ais.status_value AS status_value_1
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-04'
				) t2 ON t1.id=t2.id_1 and t1.status_code=t2.status_code_1
				ORDER BY t1.`app_store`, t1.`app_name`, t1.`status_code`, t1.`date_bd` DESC
[2026-11-05 Thu 20:52:29] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-05'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2026-11-05 Thu 20:52:29] : Total Record Fetch: 32
[2026-11-05 Thu 20:52:29] : 2026-11-05 20:52:26 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 09:32:07 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 08:37:35 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 05:00:04 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 20:52:26 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 09:32:07 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 08:37:35 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 05:00:04 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 20:52:26 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 09:32:07 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 08:37:35 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 05:00:04 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 20:52:26 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 09:32:07 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 08:37:35 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 05:00:04 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 20:52:26 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 09:32:07 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 08:37:35 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 05:00:04 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 20:52:26 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 09:32:07 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 08:37:35 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 05:00:04 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 20:52:26 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 09:32:07 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-10-08<br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 08:37:35 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-10-08<br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 05:00:04 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-10-08<br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 20:52:26 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 09:32:07 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 08:37:35 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:29] : 2026-11-05 05:00:04 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:29] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server Additional SMTP info: php_network_getaddresses: getaddrinfo failed: Name or service not known
[2026-11-05 Thu 20:52:29] : Connection closed
[2026-11-05 Thu 20:52:29] : ************************ END ***************************
[2026-11-05 Thu 20:52:29] : Total Record Fetch: 9
[2026-11-05 Thu 20:52:29] : <table width="200" border="1" cellspacing="0" cellpadding="0" style="border: 1px solid #000;font-family: Cambria, 'Hoefler Text', 'Liberation Serif', Times, 'Times New Roman', 'serif';font-size: 14px;">
  <tbody style="border: 1px solid #000;">
    <tr>
      <th style="width: 30px">SL</th>
      <th style="width: 180px">App Store</th>
      <th style="width: 300px">App Name</th>
	  <th style="width: 225px">App Organization</th>
	  <th style="width: 160px">App Status Type</th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #00FFFF">2026-11-05</span></th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #FFA500">2026-11-04</span></th>
	  <th style="width: 160px">Deviation Status</th>
    </tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">1</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #F00">2026-11-05</td><td style="border: 1px solid #000;width: auto;background-color: #F00">2026-10-08</td><td style="border: 1px solid #000;width: auto">Not Matched</td></tr></tbody></table>
[2026-11-05 Thu 20:52:29] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: QUIT command failed Detail: Â¿S¹.ÕMêÄ1²·ÚH	�ÞâÂÚ@0E•Ý±f�‚n¦årRžåšlÚtÙõy�£rt…%2Àöi­~Ý(¿ŒºËËÈ�ÖË’yu\u¬lGø2* §#&Aó6J~™CÂ–æ.‡2D²<dw½VRžNÉwp«¤8:0xDƒ–ŠƒŠ( —ôõä(}HÙñ}”iðf5¿BnH†|þ)N”sB‚J	ß’°?aÄ®þœ	¡NßÓX-–_ù,»´
«Q=ÉÏ60�‡5NÙƒü32�žZ‚£Ï1¹Š: ™Ò�œd§6á›u6A¬z™0*.é¬	®ž“í,ÿ '`~È|r“%{+htã¸ÍÀ—G¿ E3åQ>†„³{õ^Òã 5²´Ü¯ƒÅAÄ¾OÆnÚn�ÒíÄ�=¨/í%ï.ïÏïÕi¶�Éƒ)©¨ùO&*Âáã¢a221 pink.dnsnetservice.com closing connection

[2026-11-05 Thu 20:52:29] : Connection closed
[2026-11-05 Thu 20:52:29] : ************************ END ***************************
[2026-11-05 Thu 20:52:43] : *********************** START **************************
[2026-11-05 Thu 20:52:43] : select id, status_code from status_code where status='Active'
[2026-11-05 Thu 20:52:43] : Status Code Result: 2
[2026-11-05 Thu 20:52:43] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2026-11-05 Thu 20:52:43] : App Info Result: 4
[2026-11-05 Thu 20:52:43] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:43] : Batch ID: 2026-11-05 20:52:43#Google Play Store#AppInfoId_11#AppName_City Touch
[2026-11-05 Thu 20:52:43] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:43] : Misc Test: 2026-11-05 20:52:43#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-05 Thu 20:52:43] : APP_VERSION
[2026-11-05 Thu 20:52:43] : 
[2026-11-05 Thu 20:52:43] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (11,2,'','2026-11-05 20:52:43#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-05','2026-11-05 20:52:43','2026-11-05 20:52:43','get-app-info.php')
[2026-11-05 Thu 20:52:43] : 1
[2026-11-05 Thu 20:52:43] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:43] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:43] : Misc Test: 2026-11-05 20:52:43#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-05 Thu 20:52:43] : APP_LAST_UPDATE
[2026-11-05 Thu 20:52:43] : 2026-11-05
[2026-11-05 Thu 20:52:43] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (11,5,'2026-11-05','2026-11-05 20:52:43#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-05','2026-11-05 20:52:43','2026-11-05 20:52:43','get-app-info.php')
[2026-11-05 Thu 20:52:43] : 1
[2026-11-05 Thu 20:52:43] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:43] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:43] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:43] : Batch ID: 2026-11-05 20:52:43#Google Play Store#AppInfoId_12#AppName_City Corp
[2026-11-05 Thu 20:52:43] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:43] : Misc Test: 2026-11-05 20:52:43#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-05 Thu 20:52:43] : APP_VERSION
[2026-11-05 Thu 20:52:43] : 
[2026-11-05 Thu 20:52:43] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (12,2,'','2026-11-05 20:52:43#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-05','2026-11-05 20:52:43','2026-11-05 20:52:43','get-app-info.php')
[2026-11-05 Thu 20:52:43] : 1
[2026-11-05 Thu 20:52:43] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:43] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:43] : Misc Test: 2026-11-05 20:52:43#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-05 Thu 20:52:43] : APP_LAST_UPDATE
[2026-11-05 Thu 20:52:43] : 2026-09-09
[2026-11-05 Thu 20:52:43] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (12,5,'2026-09-09','2026-11-05 20:52:43#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-05','2026-11-05 20:52:43','2026-11-05 20:52:43','get-app-info.php')
[2026-11-05 Thu 20:52:43] : 1
[2026-11-05 Thu 20:52:43] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:43] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:43] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:43] : Batch ID: 2026-11-05 20:52:43#Apple I Store#AppInfoId_16#AppName_City Touch
[2026-11-05 Thu 20:52:43] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:43] : Misc Test: 2026-11-05 20:52:43#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-05 Thu 20:52:43] : APP_VERSION
[2026-11-05 Thu 20:52:43] : *********************** START Data Parsing Error Checker**************************
[2026-11-05 Thu 20:52:43] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-05'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2026-11-05 Thu 20:52:43] : Total Record Fetch: 36
[2026-11-05 Thu 20:52:43] : 2026-11-05 20:52:26 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 09:32:07 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 08:37:35 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 05:00:04 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 20:52:26 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 09:32:07 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 08:37:35 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 05:00:04 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 20:52:26 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 09:32:07 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 08:37:35 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 05:00:04 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 20:52:26 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 09:32:07 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 08:37:35 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 05:00:04 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 20:52:43 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 20:52:26 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 09:32:07 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 08:37:35 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 05:00:04 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 20:52:43 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 20:52:26 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 09:32:07 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 08:37:35 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 05:00:04 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 20:52:43 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 20:52:26 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 09:32:07 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-10-08<br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 08:37:35 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-10-08<br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 05:00:04 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-10-08<br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 20:52:43 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 20:52:26 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 09:32:07 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 08:37:35 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:43] : 2026-11-05 05:00:04 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:43] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server Additional SMTP info: php_network_getaddresses: getaddrinfo failed: Name or service not known
[2026-11-05 Thu 20:52:43] : Connection closed
[2026-11-05 Thu 20:52:43] : ************************ END ***************************
[2026-11-05 Thu 20:52:43] : 
[2026-11-05 Thu 20:52:43] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (16,2,'','2026-11-05 20:52:43#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-05','2026-11-05 20:52:43','2026-11-05 20:52:43','get-app-info.php')
[2026-11-05 Thu 20:52:43] : 1
[2026-11-05 Thu 20:52:43] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:43] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:43] : Misc Test: 2026-11-05 20:52:43#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-05 Thu 20:52:43] : APP_LAST_UPDATE
[2026-11-05 Thu 20:52:43] : --00
[2026-11-05 Thu 20:52:43] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (16,5,'--00','2026-11-05 20:52:43#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-05','2026-11-05 20:52:43','2026-11-05 20:52:43','get-app-info.php')
[2026-11-05 Thu 20:52:43] : 1
[2026-11-05 Thu 20:52:43] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:43] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:43] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:43] : Batch ID: 2026-11-05 20:52:43#Apple I Store#AppInfoId_17#AppName_City Corp
[2026-11-05 Thu 20:52:43] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:43] : Misc Test: 2026-11-05 20:52:43#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-05 Thu 20:52:43] : APP_VERSION
[2026-11-05 Thu 20:52:43] : 
[2026-11-05 Thu 20:52:43] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (17,2,'','2026-11-05 20:52:43#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-05','2026-11-05 20:52:43','2026-11-05 20:52:43','get-app-info.php')
[2026-11-05 Thu 20:52:43] : 1
[2026-11-05 Thu 20:52:43] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:43] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:43] : Misc Test: 2026-11-05 20:52:43#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-05 Thu 20:52:43] : APP_LAST_UPDATE
[2026-11-05 Thu 20:52:43] : --00
[2026-11-05 Thu 20:52:43] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (17,5,'--00','2026-11-05 20:52:43#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-05','2026-11-05 20:52:43','2026-11-05 20:52:43','get-app-info.php')
[2026-11-05 Thu 20:52:43] : 1
[2026-11-05 Thu 20:52:43] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:43] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-05 Thu 20:52:43] : Connection closed
[2026-11-05 Thu 20:52:43] : ************************ END ***************************
[2026-11-05 Thu 20:52:45] : *********************** START Send Deviation Alert**************************
[2026-11-05 Thu 20:52:45] : *********************** START Data Parsing Error Checker**************************
[2026-11-05 Thu 20:52:45] : SELECT DISTINCT t1.*,t2.*  FROM 
				(
				SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.`executed_date` AS date_bd
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-05'
				) t1
				LEFT OUTER JOIN
				(
				SELECT ai.id AS id_1, ai.app_name AS app_name_1, ai.app_store AS app_store_1, ai.app_org AS app_org_1, sc.status_code AS status_code_1,
				 sc.status_code_desc AS status_code_desc_1, ais.status_value AS status_value_1
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-04'
				) t2 ON t1.id=t2.id_1 and t1.status_code=t2.status_code_1
				ORDER BY t1.`app_store`, t1.`app_name`, t1.`status_code`, t1.`date_bd` DESC
[2026-11-05 Thu 20:52:45] : Total Record Fetch: 9
[2026-11-05 Thu 20:52:45] : <table width="200" border="1" cellspacing="0" cellpadding="0" style="border: 1px solid #000;font-family: Cambria, 'Hoefler Text', 'Liberation Serif', Times, 'Times New Roman', 'serif';font-size: 14px;">
  <tbody style="border: 1px solid #000;">
    <tr>
      <th style="width: 30px">SL</th>
      <th style="width: 180px">App Store</th>
      <th style="width: 300px">App Name</th>
	  <th style="width: 225px">App Organization</th>
	  <th style="width: 160px">App Status Type</th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #00FFFF">2026-11-05</span></th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #FFA500">2026-11-04</span></th>
	  <th style="width: 160px">Deviation Status</th>
    </tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">1</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #F00">2026-11-05</td><td style="border: 1px solid #000;width: auto;background-color: #F00">2026-10-08</td><td style="border: 1px solid #000;width: auto">Not Matched</td></tr></tbody></table>
[2026-11-05 Thu 20:52:45] : *********************** START Data Parsing Error Checker**************************
[2026-11-05 Thu 20:52:45] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-05'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2026-11-05 Thu 20:52:45] : Total Record Fetch: 40
[2026-11-05 Thu 20:52:45] : 2026-11-05 20:52:43 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 20:52:26 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 09:32:07 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 08:37:35 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 05:00:04 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 20:52:43 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 20:52:26 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 09:32:07 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 08:37:35 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 05:00:04 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 20:52:43 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 20:52:26 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 09:32:07 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 08:37:35 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 05:00:04 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 20:52:43 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 20:52:26 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 09:32:07 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 08:37:35 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 05:00:04 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 20:52:43 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 20:52:26 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 09:32:07 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 08:37:35 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 05:00:04 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 20:52:43 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 20:52:26 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 09:32:07 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 08:37:35 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 05:00:04 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 20:52:43 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 20:52:26 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 09:32:07 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-10-08<br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 08:37:35 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-10-08<br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 05:00:04 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-10-08<br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 20:52:43 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 20:52:26 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 09:32:07 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 08:37:35 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:45] : 2026-11-05 05:00:04 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-05 Thu 20:52:45] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server Additional SMTP info: php_network_getaddresses: getaddrinfo failed: Name or service not known
[2026-11-05 Thu 20:52:45] : Connection closed
[2026-11-05 Thu 20:52:45] : ************************ END ***************************
[2026-11-05 Thu 20:52:46] : *********************** START Send Deviation Alert**************************
[2026-11-05 Thu 20:52:46] : SELECT DISTINCT t1.*,t2.*  FROM 
				(
				SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.`executed_date` AS date_bd
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-05'
				) t1
				LEFT OUTER JOIN
				(
				SELECT ai.id AS id_1, ai.app_name AS app_name_1, ai.app_store AS app_store_1, ai.app_org AS app_org_1, sc.status_code AS status_code_1,
				 sc.status_code_desc AS status_code_desc_1, ais.status_value AS status_value_1
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2026-11-04'
				) t2 ON t1.id=t2.id_1 and t1.status_code=t2.status_code_1
				ORDER BY t1.`app_store`, t1.`app_name`, t1.`status_code`, t1.`date_bd` DESC
[2026-11-05 Thu 20:52:46] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: QUIT command failed Detail: ŒŠîôf¬Á4Ùñ2–U¬14Ê³X×™ßýí;3çôÇÞg~A\–ƒ¼ˆ­GXEæc¦?OÉ°tCÅÎè”×ˆê“GUÏË´…ü±MX´�åÃòª<•Tšë6§1V±†K¿K¨jþjikÚÏ+U¯2�Å2ôÑ"S3Ñ‘U(<±°Ï*ÔYÃÜNâ�Fz·Ï	©Ës¡)Î×äI_û-€–Ú52Ï,"óvnåËa9�fÔ‡–¦ÏçK�¶FùÜ4Í––¤D>;$Ðv!wpàµ*ØÞä8œ)f³=^Žè6qÿcJÃz¿åBwwO\Jè šÀF± ‹Î·"L¢Ô{��í#À�ÎR#©œpüÄ~4/)EŒfbh EQ„š�CK!ÂÅÅ2ÜÆ-Ð²HŠB7¬ë©á4�@B€
´cæ¹I7ÂgN-¡œ0Gû©‹ÅXö<—~z—Ciœò‹ ÆR221 pink.dnsnetservice.com closing connection

[2026-11-05 Thu 20:52:46] : Connection closed
[2026-11-05 Thu 20:52:46] : ************************ END ***************************
[2026-11-05 Thu 20:52:46] : Total Record Fetch: 9
[2026-11-05 Thu 20:52:46] : <table width="200" border="1" cellspacing="0" cellpadding="0" style="border: 1px solid #000;font-family: Cambria, 'Hoefler Text', 'Liberation Serif', Times, 'Times New Roman', 'serif';font-size: 14px;">
  <tbody style="border: 1px solid #000;">
    <tr>
      <th style="width: 30px">SL</th>
      <th style="width: 180px">App Store</th>
      <th style="width: 300px">App Name</th>
	  <th style="width: 225px">App Organization</th>
	  <th style="width: 160px">App Status Type</th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #00FFFF">2026-11-05</span></th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #FFA500">2026-11-04</span></th>
	  <th style="width: 160px">Deviation Status</th>
    </tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">1</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">2</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">3</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">--00</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">4</td><td style="border: 1px solid #000;width: auto">Apple I Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">5</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2026-09-09</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2026-09-09</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">6</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Corp</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">7</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2026-10-08</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2026-10-08</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">8</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_LAST_UPDATE</td><td style="border: 1px solid #000;width: auto;background-color: #F00">2026-11-05</td><td style="border: 1px solid #000;width: auto;background-color: #F00">2026-10-08</td><td style="border: 1px solid #000;width: auto">Not Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">9</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">City Touch</td><td style="border: 1px solid #000;width: auto">City Bank PLC</td><td style="border: 1px solid #000;width: auto">APP_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto;background-color: #0F0"></td><td style="border: 1px solid #000;width: auto">Matched</td></tr></tbody></table>
[2026-11-05 Thu 20:52:46] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server
[2026-11-05 Thu 20:52:46] : Connection closed
[2026-11-05 Thu 20:52:46] : ************************ END ***************************