
[2026-11-10 Tue 05:00:03] : *********************** START **************************
[2026-11-10 Tue 05:00:03] : select id, status_code from status_code where status='Active'
[2026-11-10 Tue 05:00:03] : Status Code Result: 2
[2026-11-10 Tue 05:00:03] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2026-11-10 Tue 05:00:03] : App Info Result: 4
[2026-11-10 Tue 05:00:03] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 05:00:03] : Batch ID: 2026-11-10 05:00:03#Google Play Store#AppInfoId_11#AppName_City Touch
[2026-11-10 Tue 05:00:03] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 05:00:03] : Misc Test: 2026-11-10 05:00:03#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-10 Tue 05:00:03] : APP_VERSION
[2026-11-10 Tue 05:00:03] : 
[2026-11-10 Tue 05:00:03] : 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-10 05:00:03#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-10','2026-11-10 05:00:03','2026-11-09 23:00:03','get-app-info.php')
[2026-11-10 Tue 05:00:03] : 1
[2026-11-10 Tue 05:00:03] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 05:00:03] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 05:00:03] : Misc Test: 2026-11-10 05:00:03#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-10 Tue 05:00:03] : APP_LAST_UPDATE
[2026-11-10 Tue 05:00:03] : 2026-11-05
[2026-11-10 Tue 05:00:03] : 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-10 05:00:03#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-10','2026-11-10 05:00:03','2026-11-09 23:00:03','get-app-info.php')
[2026-11-10 Tue 05:00:03] : 1
[2026-11-10 Tue 05:00:03] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 05:00:03] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 05:00:03] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 05:00:03] : Batch ID: 2026-11-10 05:00:03#Google Play Store#AppInfoId_12#AppName_City Corp
[2026-11-10 Tue 05:00:03] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 05:00:03] : Misc Test: 2026-11-10 05:00:03#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-10 Tue 05:00:03] : APP_VERSION
[2026-11-10 Tue 05:00:03] : 
[2026-11-10 Tue 05:00:03] : 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-10 05:00:03#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-10','2026-11-10 05:00:03','2026-11-09 23:00:03','get-app-info.php')
[2026-11-10 Tue 05:00:03] : 1
[2026-11-10 Tue 05:00:03] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 05:00:03] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 05:00:03] : Misc Test: 2026-11-10 05:00:03#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-10 Tue 05:00:03] : APP_LAST_UPDATE
[2026-11-10 Tue 05:00:04] : 2026-09-09
[2026-11-10 Tue 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 (12,5,'2026-09-09','2026-11-10 05:00:03#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-10','2026-11-10 05:00:03','2026-11-09 23:00:03','get-app-info.php')
[2026-11-10 Tue 05:00:04] : 1
[2026-11-10 Tue 05:00:04] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 05:00:04] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 05:00:04] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 05:00:04] : Batch ID: 2026-11-10 05:00:03#Apple I Store#AppInfoId_16#AppName_City Touch
[2026-11-10 Tue 05:00:04] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 05:00:04] : Misc Test: 2026-11-10 05:00:03#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-10 Tue 05:00:04] : APP_VERSION
[2026-11-10 Tue 05:00:04] : 
[2026-11-10 Tue 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 (16,2,'','2026-11-10 05:00:03#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-10','2026-11-10 05:00:03','2026-11-09 23:00:03','get-app-info.php')
[2026-11-10 Tue 05:00:04] : 1
[2026-11-10 Tue 05:00:04] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 05:00:04] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 05:00:04] : Misc Test: 2026-11-10 05:00:03#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-10 Tue 05:00:04] : APP_LAST_UPDATE
[2026-11-10 Tue 05:00:04] : --00
[2026-11-10 Tue 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 (16,5,'--00','2026-11-10 05:00:03#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-10','2026-11-10 05:00:03','2026-11-09 23:00:03','get-app-info.php')
[2026-11-10 Tue 05:00:04] : 1
[2026-11-10 Tue 05:00:04] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 05:00:04] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 05:00:04] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 05:00:04] : Batch ID: 2026-11-10 05:00:03#Apple I Store#AppInfoId_17#AppName_City Corp
[2026-11-10 Tue 05:00:04] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 05:00:04] : Misc Test: 2026-11-10 05:00:03#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-10 Tue 05:00:04] : APP_VERSION
[2026-11-10 Tue 05:00:04] : 
[2026-11-10 Tue 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 (17,2,'','2026-11-10 05:00:03#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-10','2026-11-10 05:00:03','2026-11-09 23:00:03','get-app-info.php')
[2026-11-10 Tue 05:00:04] : 1
[2026-11-10 Tue 05:00:04] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 05:00:04] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 05:00:04] : Misc Test: 2026-11-10 05:00:03#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-10 Tue 05:00:04] : APP_LAST_UPDATE
[2026-11-10 Tue 05:00:04] : --00
[2026-11-10 Tue 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 (17,5,'--00','2026-11-10 05:00:03#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-10','2026-11-10 05:00:03','2026-11-09 23:00:03','get-app-info.php')
[2026-11-10 Tue 05:00:04] : 1
[2026-11-10 Tue 05:00:04] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 05:00:04] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 05:00:04] : Connection closed
[2026-11-10 Tue 05:00:04] : ************************ END ***************************
[2026-11-10 Tue 07:00:04] : *********************** START Send Deviation Alert**************************
[2026-11-10 Tue 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-10'
				) 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-09'
				) 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-10 Tue 07:00:04] : Total Record Fetch: 8
[2026-11-10 Tue 07:00:04] : <h1 style="color:green">No Mismatch Found!!!</h1>
[2026-11-10 Tue 07:00:04] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: QUIT command failed Detail: Ø\x®�µöÒpÊ/l€Íal–r<Ø?‡>¿·‘|½UûLÉ¶'˜·.·/ÞC�SÇTvŠ7#:BWB‰ªàaiºÑ\#^6fœc{7þ<Û´M¯ÉÍqäç3µašf¡ÏX™Å7˜(UÚPíy¤ªm+Ã3Äø¢ŽY‘á³uü]{dŠë!L›f ´dÝsg'§œÝ‘b	¢¾èË†zk—Jÿa+£37¤MÙÀÔtMRu]*`èE…ƒQ�¦¢]Û‘ÚõÀwWO(†yú…ÑÉ×³„>×åú@€¿?Cm~b(²’¬¶Â#ç²\”º¸ì®!ÖSŸjmkIç¿T
a�²p®Õå@:$Bk>2õ*™æ+õàü7> RK© EóÄÑìÛ?Óz>u]ç¯L–Z¸*<™ÃóÙ�Õ+õMvy­{žeO¸î6¼Läs÷]L¼^á,XÐÃ÷ØHu&žœ\&221 pink.dnsnetservice.com closing connection

[2026-11-10 Tue 07:00:04] : Connection closed
[2026-11-10 Tue 07:00:04] : ************************ END ***************************
[2026-11-10 Tue 11:58:50] : *********************** START **************************
[2026-11-10 Tue 11:58:50] : select id, status_code from status_code where status='Active'
[2026-11-10 Tue 11:58:50] : Status Code Result: 2
[2026-11-10 Tue 11:58:50] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2026-11-10 Tue 11:58:50] : App Info Result: 4
[2026-11-10 Tue 11:58:50] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 11:58:50] : Batch ID: 2026-11-10 11:58:50#Google Play Store#AppInfoId_11#AppName_City Touch
[2026-11-10 Tue 11:58:50] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 11:58:50] : Misc Test: 2026-11-10 11:58:50#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-10 Tue 11:58:50] : APP_VERSION
[2026-11-10 Tue 11:58:50] : 
[2026-11-10 Tue 11:58:50] : 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-10 11:58:50#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-10','2026-11-10 11:58:50','2026-11-10 11:58:50','get-app-info.php')
[2026-11-10 Tue 11:58:50] : 1
[2026-11-10 Tue 11:58:50] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 11:58:50] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 11:58:50] : Misc Test: 2026-11-10 11:58:50#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-10 Tue 11:58:50] : APP_LAST_UPDATE
[2026-11-10 Tue 11:58:50] : 2026-11-05
[2026-11-10 Tue 11:58:50] : 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-10 11:58:50#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-10','2026-11-10 11:58:50','2026-11-10 11:58:50','get-app-info.php')
[2026-11-10 Tue 11:58:50] : 1
[2026-11-10 Tue 11:58:50] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 11:58:50] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 11:58:50] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 11:58:50] : Batch ID: 2026-11-10 11:58:50#Google Play Store#AppInfoId_12#AppName_City Corp
[2026-11-10 Tue 11:58:50] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 11:58:50] : Misc Test: 2026-11-10 11:58:50#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-10 Tue 11:58:50] : APP_VERSION
[2026-11-10 Tue 11:58:51] : 
[2026-11-10 Tue 11:58:51] : 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-10 11:58:50#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-10','2026-11-10 11:58:50','2026-11-10 11:58:50','get-app-info.php')
[2026-11-10 Tue 11:58:51] : 1
[2026-11-10 Tue 11:58:51] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 11:58:51] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 11:58:51] : Misc Test: 2026-11-10 11:58:50#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-10 Tue 11:58:51] : APP_LAST_UPDATE
[2026-11-10 Tue 11:58:51] : 2026-09-09
[2026-11-10 Tue 11:58:51] : 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-10 11:58:50#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-10','2026-11-10 11:58:50','2026-11-10 11:58:50','get-app-info.php')
[2026-11-10 Tue 11:58:51] : 1
[2026-11-10 Tue 11:58:51] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 11:58:51] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 11:58:51] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 11:58:51] : Batch ID: 2026-11-10 11:58:50#Apple I Store#AppInfoId_16#AppName_City Touch
[2026-11-10 Tue 11:58:51] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 11:58:51] : Misc Test: 2026-11-10 11:58:50#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-10 Tue 11:58:51] : APP_VERSION
[2026-11-10 Tue 11:58:51] : 
[2026-11-10 Tue 11:58:51] : 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-10 11:58:50#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-10','2026-11-10 11:58:50','2026-11-10 11:58:50','get-app-info.php')
[2026-11-10 Tue 11:58:51] : 1
[2026-11-10 Tue 11:58:51] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 11:58:51] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 11:58:51] : Misc Test: 2026-11-10 11:58:50#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-10 Tue 11:58:51] : APP_LAST_UPDATE
[2026-11-10 Tue 11:58:52] : --00
[2026-11-10 Tue 11:58:52] : 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-10 11:58:50#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-10','2026-11-10 11:58:50','2026-11-10 11:58:50','get-app-info.php')
[2026-11-10 Tue 11:58:52] : 1
[2026-11-10 Tue 11:58:52] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 11:58:52] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 11:58:52] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 11:58:52] : Batch ID: 2026-11-10 11:58:50#Apple I Store#AppInfoId_17#AppName_City Corp
[2026-11-10 Tue 11:58:52] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 11:58:52] : Misc Test: 2026-11-10 11:58:50#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-10 Tue 11:58:52] : APP_VERSION
[2026-11-10 Tue 11:58:52] : 
[2026-11-10 Tue 11:58:52] : 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-10 11:58:50#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-10','2026-11-10 11:58:50','2026-11-10 11:58:50','get-app-info.php')
[2026-11-10 Tue 11:58:52] : 1
[2026-11-10 Tue 11:58:52] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 11:58:52] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 11:58:52] : Misc Test: 2026-11-10 11:58:50#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-10 Tue 11:58:52] : APP_LAST_UPDATE
[2026-11-10 Tue 11:58:52] : --00
[2026-11-10 Tue 11:58:52] : 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-10 11:58:50#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-10','2026-11-10 11:58:50','2026-11-10 11:58:50','get-app-info.php')
[2026-11-10 Tue 11:58:52] : 1
[2026-11-10 Tue 11:58:52] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 11:58:52] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 11:58:52] : Connection closed
[2026-11-10 Tue 11:58:52] : ************************ END ***************************
[2026-11-10 Tue 11:59:57] : *********************** START Send Deviation Alert**************************
[2026-11-10 Tue 11:59:57] : 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-10'
				) 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-09'
				) 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-10 Tue 11:59:57] : Total Record Fetch: 8
[2026-11-10 Tue 11:59:57] : <h1 style="color:green">No Mismatch Found!!!</h1>
[2026-11-10 Tue 11:59:57] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: QUIT command failed Detail: „<ºL*¤·a1Oº½ŸùSß)kùÀÂ÷†+ÍŸÛ¾9a‚ó�i™'íƒ×Œ…@ó5(fØ¶ÕÿõÖ‹š©<ë»ä6^š°iQFö¯<»›¿¯‘™¨Cb2î×\
_\$.JÐ],¿G)m%	�qOïügæ${[7Ë5\õÓ<ßˆ|7ˆd$ÿÐ�Î’…=­
Áy®fýV²÷ZÕœg²sŒçL£Ýs|”øþX'6±ãpþ–]@@‘âÇÒœeÿ™Î°�ÒËºîi_Øê
G‡uµÈˆÛº^"àTxL%µœ·0‚Ÿx.–ˆIêÍ%Ã´s¢—1ÌªÇ4(»µ= Ì—ùr‡XYó˜êÀ{`D�Ï¿Œà¤Qk¥œøFßIí« E.`Q�Ä‡è€�=Î¤�åJHÌf«{Qÿ”ðmJ�£ì%%Z
¨v'¥±“[ò¾W¦<é8N4Õ,?ãˆçð¡ì"–221 pink.dnsnetservice.com closing connection

[2026-11-10 Tue 11:59:57] : Connection closed
[2026-11-10 Tue 11:59:57] : ************************ END ***************************
[2026-11-10 Tue 11:59:59] : *********************** START Send Deviation Alert**************************
[2026-11-10 Tue 11:59:59] : 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-10'
				) 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-09'
				) 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-10 Tue 11:59:59] : Total Record Fetch: 8
[2026-11-10 Tue 11:59:59] : <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-10</span></th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #FFA500">2026-11-09</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-11-05</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2026-11-05</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-10 Tue 11:59:59] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server
[2026-11-10 Tue 11:59:59] : Connection closed
[2026-11-10 Tue 11:59:59] : ************************ END ***************************
[2026-11-10 Tue 11:59:59] : *********************** START Data Parsing Error Checker**************************
[2026-11-10 Tue 12:00:00] : *********************** START Data Parsing Error Checker**************************
[2026-11-10 Tue 12:00:00] : 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-10'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2026-11-10 Tue 12:00:00] : Total Record Fetch: 16
[2026-11-10 Tue 12:00:00] : 2026-11-10 11:58:50 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-10 Tue 12:00:00] : 2026-11-10 05:00:03 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-10 Tue 12:00:00] : 2026-11-10 11:58:50 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 12:00:00] : 2026-11-10 05:00:03 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 12:00:00] : 2026-11-10 11:58:50 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-10 Tue 12:00:00] : 2026-11-10 05:00:03 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-10 Tue 12:00:00] : 2026-11-10 11:58:50 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 12:00:00] : 2026-11-10 05:00:03 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 12:00:00] : 2026-11-10 11:58:50 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-10 Tue 12:00:00] : 2026-11-10 05:00:03 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-10 Tue 12:00:00] : 2026-11-10 11:58:50 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 12:00:00] : 2026-11-10 05:00:03 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 12:00:00] : 2026-11-10 11:58:50 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-10 Tue 12:00:00] : 2026-11-10 05:00:03 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-10 Tue 12:00:00] : 2026-11-10 11:58:50 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 12:00:00] : 2026-11-10 05:00:03 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 12:00:00] : 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-10 Tue 12:00:00] : Connection closed
[2026-11-10 Tue 12:00:00] : ************************ END ***************************
[2026-11-10 Tue 12:00:01] : *********************** START Data Parsing Error Checker**************************
[2026-11-10 Tue 12:00:01] : 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-10'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2026-11-10 Tue 12:00:01] : Total Record Fetch: 16
[2026-11-10 Tue 12:00:01] : 2026-11-10 11:58:50 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-10 Tue 12:00:01] : 2026-11-10 05:00:03 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-10 Tue 12:00:01] : 2026-11-10 11:58:50 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 12:00:01] : 2026-11-10 05:00:03 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 12:00:01] : 2026-11-10 11:58:50 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-10 Tue 12:00:01] : 2026-11-10 05:00:03 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-10 Tue 12:00:01] : 2026-11-10 11:58:50 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 12:00:01] : 2026-11-10 05:00:03 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 12:00:01] : 2026-11-10 11:58:50 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-10 Tue 12:00:01] : 2026-11-10 05:00:03 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-10 Tue 12:00:01] : 2026-11-10 11:58:50 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 12:00:01] : 2026-11-10 05:00:03 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 12:00:01] : 2026-11-10 11:58:50 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-10 Tue 12:00:01] : 2026-11-10 05:00:03 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-10 Tue 12:00:01] : 2026-11-10 11:58:50 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 12:00:01] : 2026-11-10 05:00:03 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 12:00:01] : 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-10 Tue 12:00:01] : Connection closed
[2026-11-10 Tue 12:00:01] : ************************ END ***************************
[2026-11-10 Tue 13:01:20] : *********************** START Data Parsing Error Checker**************************
[2026-11-10 Tue 13:01:20] : 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-10'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2026-11-10 Tue 13:01:20] : Total Record Fetch: 16
[2026-11-10 Tue 13:01:20] : 2026-11-10 11:58:50 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-10 Tue 13:01:20] : 2026-11-10 05:00:03 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-10 Tue 13:01:20] : 2026-11-10 11:58:50 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 13:01:20] : 2026-11-10 05:00:03 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 13:01:20] : 2026-11-10 11:58:50 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-10 Tue 13:01:20] : 2026-11-10 05:00:03 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-10 Tue 13:01:20] : 2026-11-10 11:58:50 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 13:01:20] : 2026-11-10 05:00:03 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 13:01:20] : 2026-11-10 11:58:50 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-10 Tue 13:01:20] : 2026-11-10 05:00:03 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-10 Tue 13:01:20] : 2026-11-10 11:58:50 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 13:01:20] : 2026-11-10 05:00:03 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 13:01:20] : 2026-11-10 11:58:50 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-10 Tue 13:01:20] : 2026-11-10 05:00:03 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-10 Tue 13:01:20] : 2026-11-10 11:58:50 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 13:01:20] : 2026-11-10 05:00:03 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 13:01:20] : 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-10 Tue 13:01:20] : Connection closed
[2026-11-10 Tue 13:01:20] : ************************ END ***************************
[2026-11-10 Tue 13:01:38] : *********************** START Data Parsing Error Checker**************************
[2026-11-10 Tue 13:01:38] : 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-10'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2026-11-10 Tue 13:01:38] : Total Record Fetch: 16
[2026-11-10 Tue 13:01:38] : 2026-11-10 11:58:50 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-10 Tue 13:01:38] : 2026-11-10 05:00:03 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-10 Tue 13:01:38] : 2026-11-10 11:58:50 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 13:01:38] : 2026-11-10 05:00:03 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 13:01:38] : 2026-11-10 11:58:50 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-10 Tue 13:01:38] : 2026-11-10 05:00:03 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-10 Tue 13:01:38] : 2026-11-10 11:58:50 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 13:01:38] : 2026-11-10 05:00:03 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 13:01:38] : 2026-11-10 11:58:50 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-10 Tue 13:01:38] : 2026-11-10 05:00:03 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-10 Tue 13:01:38] : 2026-11-10 11:58:50 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 13:01:38] : 2026-11-10 05:00:03 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 13:01:38] : 2026-11-10 11:58:50 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-10 Tue 13:01:38] : 2026-11-10 05:00:03 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-10 Tue 13:01:38] : 2026-11-10 11:58:50 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 13:01:38] : 2026-11-10 05:00:03 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-10 Tue 13:01:38] : 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-10 Tue 13:01:38] : Connection closed
[2026-11-10 Tue 13:01:38] : ************************ END ***************************
[2026-11-10 Tue 13:01:54] : *********************** START **************************
[2026-11-10 Tue 13:01:54] : select id, status_code from status_code where status='Active'
[2026-11-10 Tue 13:01:54] : Status Code Result: 2
[2026-11-10 Tue 13:01:54] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2026-11-10 Tue 13:01:54] : App Info Result: 4
[2026-11-10 Tue 13:01:54] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 13:01:54] : Batch ID: 2026-11-10 13:01:54#Google Play Store#AppInfoId_11#AppName_City Touch
[2026-11-10 Tue 13:01:54] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 13:01:54] : Misc Test: 2026-11-10 13:01:54#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-10 Tue 13:01:54] : APP_VERSION
[2026-11-10 Tue 13:01:54] : 
[2026-11-10 Tue 13:01:54] : 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-10 13:01:54#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-10','2026-11-10 13:01:54','2026-11-10 13:01:54','get-app-info.php')
[2026-11-10 Tue 13:01:54] : 1
[2026-11-10 Tue 13:01:54] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 13:01:54] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 13:01:54] : Misc Test: 2026-11-10 13:01:54#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-10 Tue 13:01:54] : APP_LAST_UPDATE
[2026-11-10 Tue 13:01:55] : 2026-11-05
[2026-11-10 Tue 13:01:55] : 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-10 13:01:54#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-10','2026-11-10 13:01:54','2026-11-10 13:01:54','get-app-info.php')
[2026-11-10 Tue 13:01:55] : 1
[2026-11-10 Tue 13:01:55] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 13:01:55] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 13:01:55] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 13:01:55] : Batch ID: 2026-11-10 13:01:54#Google Play Store#AppInfoId_12#AppName_City Corp
[2026-11-10 Tue 13:01:55] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 13:01:55] : Misc Test: 2026-11-10 13:01:54#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-10 Tue 13:01:55] : APP_VERSION
[2026-11-10 Tue 13:01:56] : 
[2026-11-10 Tue 13:01:56] : 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-10 13:01:54#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-10','2026-11-10 13:01:54','2026-11-10 13:01:54','get-app-info.php')
[2026-11-10 Tue 13:01:56] : 1
[2026-11-10 Tue 13:01:56] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 13:01:56] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 13:01:56] : Misc Test: 2026-11-10 13:01:54#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-10 Tue 13:01:56] : APP_LAST_UPDATE
[2026-11-10 Tue 13:01:56] : 2026-09-09
[2026-11-10 Tue 13:01:56] : 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-10 13:01:54#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-10','2026-11-10 13:01:54','2026-11-10 13:01:54','get-app-info.php')
[2026-11-10 Tue 13:01:56] : 1
[2026-11-10 Tue 13:01:56] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 13:01:56] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 13:01:56] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 13:01:56] : Batch ID: 2026-11-10 13:01:54#Apple I Store#AppInfoId_16#AppName_City Touch
[2026-11-10 Tue 13:01:56] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 13:01:56] : Misc Test: 2026-11-10 13:01:54#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-10 Tue 13:01:56] : APP_VERSION
[2026-11-10 Tue 13:01:56] : 
[2026-11-10 Tue 13:01:56] : 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-10 13:01:54#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-10','2026-11-10 13:01:54','2026-11-10 13:01:54','get-app-info.php')
[2026-11-10 Tue 13:01:56] : 1
[2026-11-10 Tue 13:01:56] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 13:01:56] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 13:01:56] : Misc Test: 2026-11-10 13:01:54#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-10 Tue 13:01:56] : APP_LAST_UPDATE
[2026-11-10 Tue 13:01:56] : --00
[2026-11-10 Tue 13:01:56] : 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-10 13:01:54#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-10','2026-11-10 13:01:54','2026-11-10 13:01:54','get-app-info.php')
[2026-11-10 Tue 13:01:56] : 1
[2026-11-10 Tue 13:01:56] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 13:01:56] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 13:01:56] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 13:01:56] : Batch ID: 2026-11-10 13:01:54#Apple I Store#AppInfoId_17#AppName_City Corp
[2026-11-10 Tue 13:01:56] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 13:01:56] : Misc Test: 2026-11-10 13:01:54#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-10 Tue 13:01:56] : APP_VERSION
[2026-11-10 Tue 13:01:56] : 
[2026-11-10 Tue 13:01:56] : 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-10 13:01:54#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-10','2026-11-10 13:01:54','2026-11-10 13:01:54','get-app-info.php')
[2026-11-10 Tue 13:01:56] : 1
[2026-11-10 Tue 13:01:56] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 13:01:56] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 13:01:56] : Misc Test: 2026-11-10 13:01:54#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-10 Tue 13:01:56] : APP_LAST_UPDATE
[2026-11-10 Tue 13:01:56] : --00
[2026-11-10 Tue 13:01:56] : 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-10 13:01:54#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-10','2026-11-10 13:01:54','2026-11-10 13:01:54','get-app-info.php')
[2026-11-10 Tue 13:01:56] : 1
[2026-11-10 Tue 13:01:56] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 13:01:56] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-10 Tue 13:01:56] : Connection closed
[2026-11-10 Tue 13:01:56] : ************************ END ***************************
[2026-11-10 Tue 13:01:56] : *********************** START Send Deviation Alert**************************
[2026-11-10 Tue 13:01:56] : 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-10'
				) 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-09'
				) 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-10 Tue 13:01:57] : Total Record Fetch: 8
[2026-11-10 Tue 13:01:57] : <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-10</span></th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #FFA500">2026-11-09</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-11-05</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2026-11-05</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-10 Tue 13:01:57] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server
[2026-11-10 Tue 13:01:57] : Connection closed
[2026-11-10 Tue 13:01:57] : ************************ END ***************************
[2026-11-10 Tue 13:02:09] : *********************** START Send Deviation Alert**************************
[2026-11-10 Tue 13:02: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-10'
				) 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-09'
				) 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-10 Tue 13:02:09] : Total Record Fetch: 8
[2026-11-10 Tue 13:02:09] : <h1 style="color:green">No Mismatch Found!!!</h1>
[2026-11-10 Tue 13:02:09] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: QUIT command failed Detail: nçfó\ßJ& œZ»ydì‹‹ñ�´_/D{³EL›ÌÝ´Í¾jl?ó}1§)¾Â°>ùOÎç<v2*ƒn¼|ŠºS\öW@Óu³¢F¤ìˆ L¶$ÿñ&P’/qû[‘ŽÏRCHõ@yþò¨¨$2JO…Ôý[Ø­\è®OÚ&hÀ@,Lêß,A÷@óÅæk‹_ˆŽqÁT®S�7b»›¢M‡�(ÒðÒ%Ó&pcªSY}ÌTŽG!ÃP×#â*íW^p0w«Eç1JÛ„ã}“Ä÷;5´S·Ð_åSîA/­�3Kc=·‡w8l=î'§MœÌ9WÈÕÇÇŽ^ÀzÔà°É‰aˆ2ô¢ EªYåA#íR£>çÊkÍeG4*¿—�ºíüÀiZL§SzðXZå’…=Üú(y<g4´•bjÌ8pÅ$&V5Beý221 pink.dnsnetservice.com closing connection

[2026-11-10 Tue 13:02:09] : Connection closed
[2026-11-10 Tue 13:02:09] : ************************ END ***************************
[2026-11-10 Tue 13:02:35] : *********************** START Data Parsing Error Checker**************************