
[2026-11-19 Thu 05:00:05] : *********************** START **************************
[2026-11-19 Thu 05:00:05] : select id, status_code from status_code where status='Active'
[2026-11-19 Thu 05:00:05] : Status Code Result: 2
[2026-11-19 Thu 05:00:05] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2026-11-19 Thu 05:00:05] : App Info Result: 4
[2026-11-19 Thu 05:00:05] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 05:00:05] : Batch ID: 2026-11-19 05:00:05#Google Play Store#AppInfoId_11#AppName_City Touch
[2026-11-19 Thu 05:00:05] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 05:00:05] : Misc Test: 2026-11-19 05:00:05#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-19 Thu 05:00:05] : APP_VERSION
[2026-11-19 Thu 05:00:05] : 
[2026-11-19 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,2,'','2026-11-19 05:00:05#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-19','2026-11-19 05:00:05','2026-11-18 23:00:05','get-app-info.php')
[2026-11-19 Thu 05:00:05] : 1
[2026-11-19 Thu 05:00:05] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 05:00:05] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 05:00:05] : Misc Test: 2026-11-19 05:00:05#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-19 Thu 05:00:05] : APP_LAST_UPDATE
[2026-11-19 Thu 05:00:05] : 2026-11-05
[2026-11-19 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-11-05','2026-11-19 05:00:05#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-19','2026-11-19 05:00:05','2026-11-18 23:00:05','get-app-info.php')
[2026-11-19 Thu 05:00:05] : 1
[2026-11-19 Thu 05:00:05] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 05:00:05] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 05:00:05] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 05:00:05] : Batch ID: 2026-11-19 05:00:05#Google Play Store#AppInfoId_12#AppName_City Corp
[2026-11-19 Thu 05:00:05] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 05:00:05] : Misc Test: 2026-11-19 05:00:05#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-19 Thu 05:00:05] : APP_VERSION
[2026-11-19 Thu 05:00:06] : 
[2026-11-19 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 (12,2,'','2026-11-19 05:00:05#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-19','2026-11-19 05:00:05','2026-11-18 23:00:05','get-app-info.php')
[2026-11-19 Thu 05:00:06] : 1
[2026-11-19 Thu 05:00:06] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 05:00:06] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 05:00:06] : Misc Test: 2026-11-19 05:00:05#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-19 Thu 05:00:06] : APP_LAST_UPDATE
[2026-11-19 Thu 05:00:06] : 2026-09-09
[2026-11-19 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 (12,5,'2026-09-09','2026-11-19 05:00:05#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-19','2026-11-19 05:00:05','2026-11-18 23:00:05','get-app-info.php')
[2026-11-19 Thu 05:00:06] : 1
[2026-11-19 Thu 05:00:06] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 05:00:06] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 05:00:06] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 05:00:06] : Batch ID: 2026-11-19 05:00:05#Apple I Store#AppInfoId_16#AppName_City Touch
[2026-11-19 Thu 05:00:06] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 05:00:06] : Misc Test: 2026-11-19 05:00:05#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-19 Thu 05:00:06] : APP_VERSION
[2026-11-19 Thu 05:00:07] : 
[2026-11-19 Thu 05:00: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 (16,2,'','2026-11-19 05:00:05#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-19','2026-11-19 05:00:05','2026-11-18 23:00:05','get-app-info.php')
[2026-11-19 Thu 05:00:07] : 1
[2026-11-19 Thu 05:00:07] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 05:00:07] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 05:00:07] : Misc Test: 2026-11-19 05:00:05#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-19 Thu 05:00:07] : APP_LAST_UPDATE
[2026-11-19 Thu 05:00:07] : --00
[2026-11-19 Thu 05:00: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 (16,5,'--00','2026-11-19 05:00:05#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-19','2026-11-19 05:00:05','2026-11-18 23:00:05','get-app-info.php')
[2026-11-19 Thu 05:00:07] : 1
[2026-11-19 Thu 05:00:07] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 05:00:07] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 05:00:07] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 05:00:07] : Batch ID: 2026-11-19 05:00:05#Apple I Store#AppInfoId_17#AppName_City Corp
[2026-11-19 Thu 05:00:07] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 05:00:07] : Misc Test: 2026-11-19 05:00:05#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-19 Thu 05:00:07] : APP_VERSION
[2026-11-19 Thu 05:00:07] : 
[2026-11-19 Thu 05:00: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 (17,2,'','2026-11-19 05:00:05#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-19','2026-11-19 05:00:05','2026-11-18 23:00:05','get-app-info.php')
[2026-11-19 Thu 05:00:07] : 1
[2026-11-19 Thu 05:00:07] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 05:00:07] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 05:00:07] : Misc Test: 2026-11-19 05:00:05#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-19 Thu 05:00:07] : APP_LAST_UPDATE
[2026-11-19 Thu 05:00:07] : --00
[2026-11-19 Thu 05:00: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 (17,5,'--00','2026-11-19 05:00:05#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-19','2026-11-19 05:00:05','2026-11-18 23:00:05','get-app-info.php')
[2026-11-19 Thu 05:00:07] : 1
[2026-11-19 Thu 05:00:07] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 05:00:07] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 05:00:07] : Connection closed
[2026-11-19 Thu 05:00:07] : ************************ END ***************************
[2026-11-19 Thu 07:00:02] : *********************** START Send Deviation Alert**************************
[2026-11-19 Thu 07:00:02] : 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-19'
				) 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-18'
				) 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-19 Thu 07:00:02] : Total Record Fetch: 8
[2026-11-19 Thu 07:00:02] : <h1 style="color:green">No Mismatch Found!!!</h1>
[2026-11-19 Thu 07:00:03] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: QUIT command failed Detail: ¡xBÅk>�¡�¬ÐmêË€¥¶ËHp�ûÕ’©Ùûb).º´…o5lQëWqs‰nÑ%/'A03ƒ8­%Ï­ç—„)õê˜ñuÕ~°±Åu;BšåŠ.mCWÙÞÚ9Ò³’ŠÒ±Íú›ÇñÒÃä3Ê4pøÌ¿kÂp(à,Ø2Zû<þ7XT… G'ê3¡‡¿2…<¬_¯§Þÿ»qxBy<náp^†BÛ§fF�^gˆnK	½¹†ë
íÂ®~[ä©Â½Æ°î‹:"ü+–¶ðZü·²o§é¥È±‰ �„Âˆuê)fâZ/1½Ë—¸cÕ)›ÂYYÛÍz
)ÝÏpû<æœÖ]¶YlC›<¶ E–Kð5Ž"ù²î¡Aå5T^&}ðuÐY°Jô ‡Å¹N¯L:ý/J˜#aÂØçö'^¨ ñMÂµÂâ†®ú±($221 pink.dnsnetservice.com closing connection

[2026-11-19 Thu 07:00:03] : Connection closed
[2026-11-19 Thu 07:00:03] : ************************ END ***************************
[2026-11-19 Thu 21:39:03] : *********************** START **************************
[2026-11-19 Thu 21:39:03] : select id, status_code from status_code where status='Active'
[2026-11-19 Thu 21:39:03] : Status Code Result: 2
[2026-11-19 Thu 21:39:03] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2026-11-19 Thu 21:39:03] : App Info Result: 4
[2026-11-19 Thu 21:39:03] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:03] : Batch ID: 2026-11-19 21:39:03#Google Play Store#AppInfoId_11#AppName_City Touch
[2026-11-19 Thu 21:39:03] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:03] : Misc Test: 2026-11-19 21:39:03#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-19 Thu 21:39:03] : APP_VERSION
[2026-11-19 Thu 21:39:04] : 
[2026-11-19 Thu 21:39: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-19 21:39:03#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-19','2026-11-19 21:39:03','2026-11-19 21:39:03','get-app-info.php')
[2026-11-19 Thu 21:39:04] : 1
[2026-11-19 Thu 21:39:04] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:04] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:04] : Misc Test: 2026-11-19 21:39:03#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-19 Thu 21:39:04] : APP_LAST_UPDATE
[2026-11-19 Thu 21:39:04] : 2026-11-05
[2026-11-19 Thu 21:39: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,5,'2026-11-05','2026-11-19 21:39:03#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-19','2026-11-19 21:39:03','2026-11-19 21:39:03','get-app-info.php')
[2026-11-19 Thu 21:39:04] : 1
[2026-11-19 Thu 21:39:04] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:04] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:04] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:04] : Batch ID: 2026-11-19 21:39:03#Google Play Store#AppInfoId_12#AppName_City Corp
[2026-11-19 Thu 21:39:04] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:04] : Misc Test: 2026-11-19 21:39:03#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-19 Thu 21:39:04] : APP_VERSION
[2026-11-19 Thu 21:39:04] : 
[2026-11-19 Thu 21:39: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,2,'','2026-11-19 21:39:03#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-19','2026-11-19 21:39:03','2026-11-19 21:39:03','get-app-info.php')
[2026-11-19 Thu 21:39:04] : 1
[2026-11-19 Thu 21:39:04] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:04] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:04] : Misc Test: 2026-11-19 21:39:03#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-19 Thu 21:39:04] : APP_LAST_UPDATE
[2026-11-19 Thu 21:39:04] : 2026-09-09
[2026-11-19 Thu 21:39: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-19 21:39:03#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-19','2026-11-19 21:39:03','2026-11-19 21:39:03','get-app-info.php')
[2026-11-19 Thu 21:39:04] : 1
[2026-11-19 Thu 21:39:04] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:04] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:04] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:04] : Batch ID: 2026-11-19 21:39:03#Apple I Store#AppInfoId_16#AppName_City Touch
[2026-11-19 Thu 21:39:04] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:04] : Misc Test: 2026-11-19 21:39:03#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-19 Thu 21:39:04] : APP_VERSION
[2026-11-19 Thu 21:39:04] : 
[2026-11-19 Thu 21:39: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-19 21:39:03#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-19','2026-11-19 21:39:03','2026-11-19 21:39:03','get-app-info.php')
[2026-11-19 Thu 21:39:04] : 1
[2026-11-19 Thu 21:39:04] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:04] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:04] : Misc Test: 2026-11-19 21:39:03#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-19 Thu 21:39:04] : APP_LAST_UPDATE
[2026-11-19 Thu 21:39:04] : *********************** START Data Parsing Error Checker**************************
[2026-11-19 Thu 21:39:04] : 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-19'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2026-11-19 Thu 21:39:04] : Total Record Fetch: 13
[2026-11-19 Thu 21:39:04] : 2026-11-19 05:00:05 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 21:39:04] : 2026-11-19 05:00:05 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:04] : 2026-11-19 05:00:05 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 21:39:04] : 2026-11-19 21:39:03 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:04] : 2026-11-19 05:00:05 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:04] : 2026-11-19 21:39:03 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 21:39:04] : 2026-11-19 05:00:05 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 21:39:04] : 2026-11-19 21:39:03 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:04] : 2026-11-19 05:00:05 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:04] : 2026-11-19 21:39:03 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 21:39:04] : 2026-11-19 05:00:05 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 21:39:04] : 2026-11-19 21:39:03 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:04] : 2026-11-19 05:00:05 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:04] : --00
[2026-11-19 Thu 21:39: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-19 21:39:03#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-19','2026-11-19 21:39:03','2026-11-19 21:39:03','get-app-info.php')
[2026-11-19 Thu 21:39:04] : 1
[2026-11-19 Thu 21:39:04] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:04] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:04] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:04] : Batch ID: 2026-11-19 21:39:03#Apple I Store#AppInfoId_17#AppName_City Corp
[2026-11-19 Thu 21:39:04] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:04] : Misc Test: 2026-11-19 21:39:03#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-19 Thu 21:39:04] : APP_VERSION
[2026-11-19 Thu 21:39:04] : 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-19 Thu 21:39:04] : Connection closed
[2026-11-19 Thu 21:39:04] : ************************ END ***************************
[2026-11-19 Thu 21:39:05] : 
[2026-11-19 Thu 21:39: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 (17,2,'','2026-11-19 21:39:03#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-19','2026-11-19 21:39:03','2026-11-19 21:39:03','get-app-info.php')
[2026-11-19 Thu 21:39:05] : 1
[2026-11-19 Thu 21:39:05] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:05] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:05] : Misc Test: 2026-11-19 21:39:03#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-19 Thu 21:39:05] : APP_LAST_UPDATE
[2026-11-19 Thu 21:39:05] : --00
[2026-11-19 Thu 21:39: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 (17,5,'--00','2026-11-19 21:39:03#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-19','2026-11-19 21:39:03','2026-11-19 21:39:03','get-app-info.php')
[2026-11-19 Thu 21:39:05] : 1
[2026-11-19 Thu 21:39:05] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:05] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:05] : Connection closed
[2026-11-19 Thu 21:39:05] : ************************ END ***************************
[2026-11-19 Thu 21:39:05] : *********************** START Data Parsing Error Checker**************************
[2026-11-19 Thu 21:39:06] : *********************** START Send Deviation Alert**************************
[2026-11-19 Thu 21:39:06] : 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-19'
				) 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-18'
				) 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-19 Thu 21:39:06] : Total Record Fetch: 8
[2026-11-19 Thu 21:39:06] : <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-19</span></th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #FFA500">2026-11-18</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-19 Thu 21:39:06] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server
[2026-11-19 Thu 21:39:06] : Connection closed
[2026-11-19 Thu 21:39:06] : ************************ END ***************************
[2026-11-19 Thu 21:39:06] : *********************** START Send Deviation Alert**************************
[2026-11-19 Thu 21:39:06] : 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-19'
				) 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-18'
				) 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-19 Thu 21:39:06] : *********************** START Data Parsing Error Checker**************************
[2026-11-19 Thu 21:39:06] : Total Record Fetch: 8
[2026-11-19 Thu 21:39:06] : <h1 style="color:green">No Mismatch Found!!!</h1>
[2026-11-19 Thu 21:39:06] : 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-19'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2026-11-19 Thu 21:39:06] : Total Record Fetch: 16
[2026-11-19 Thu 21:39:06] : 2026-11-19 21:39:03 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 21:39:06] : 2026-11-19 05:00:05 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 21:39:06] : 2026-11-19 21:39:03 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:06] : 2026-11-19 05:00:05 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:06] : 2026-11-19 21:39:03 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 21:39:06] : 2026-11-19 05:00:05 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 21:39:06] : 2026-11-19 21:39:03 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:06] : 2026-11-19 05:00:05 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:06] : 2026-11-19 21:39:03 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 21:39:06] : 2026-11-19 05:00:05 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 21:39:06] : 2026-11-19 21:39:03 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:06] : 2026-11-19 05:00:05 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:06] : 2026-11-19 21:39:03 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 21:39:06] : 2026-11-19 05:00:05 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 21:39:06] : 2026-11-19 21:39:03 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:06] : 2026-11-19 05:00:05 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:06] : 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-19 Thu 21:39:06] : Connection closed
[2026-11-19 Thu 21:39:06] : ************************ END ***************************
[2026-11-19 Thu 21:39:06] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: QUIT command failed Detail: oé¾¸`_°0T¹�1£piŸ| ž†|Ü�£¸�8³"D­ÚÊiÐoÌz Ê$º©Q€H‘¾|¯J�;ƒÚ}5AæÌ’i!AŠüK#ç6®Ó°9ùvÞTX—²¶ÐØ›ïõ6Ôª-_€Û;œ["Ù7ç9Ã¸‡ñ#Lk`Lq¹äÑÈŽòÆÙ–a„;G*ŽÐq–s¤ÁÝê!…è0×‘ìEÎ¸4Ðm©F„`õÖ6ûÌ_àˆ—eë',+Â�ëIDü‹¹(Mœ2ýƒÀž…¹JÚM_Ã�}è—Èæ­¤!é«B/¶-jzEGGnï^[‘û¾åMß‘ËkÇÑ—ì$éŸü>ÿì®)>áÐ 8ã¢€x³?!` EµÀ¢öÂ§Å÷õó„¼ÓƒÏw<-©Þ(ÃàxÅ·YZ¹¶q0¡Ó|$s¹~ú�µr›3Xuî`³°·F¯nº? 221 pink.dnsnetservice.com closing connection

[2026-11-19 Thu 21:39:06] : Connection closed
[2026-11-19 Thu 21:39:06] : ************************ END ***************************
[2026-11-19 Thu 21:39:09] : *********************** START **************************
[2026-11-19 Thu 21:39:09] : select id, status_code from status_code where status='Active'
[2026-11-19 Thu 21:39:09] : Status Code Result: 2
[2026-11-19 Thu 21:39:09] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2026-11-19 Thu 21:39:09] : App Info Result: 4
[2026-11-19 Thu 21:39:09] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:09] : Batch ID: 2026-11-19 21:39:09#Google Play Store#AppInfoId_11#AppName_City Touch
[2026-11-19 Thu 21:39:09] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:09] : Misc Test: 2026-11-19 21:39:09#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-19 Thu 21:39:09] : APP_VERSION
[2026-11-19 Thu 21:39:09] : 
[2026-11-19 Thu 21:39: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 (11,2,'','2026-11-19 21:39:09#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-19','2026-11-19 21:39:09','2026-11-19 21:39:09','get-app-info.php')
[2026-11-19 Thu 21:39:09] : 1
[2026-11-19 Thu 21:39:09] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:09] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:09] : Misc Test: 2026-11-19 21:39:09#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-19 Thu 21:39:09] : APP_LAST_UPDATE
[2026-11-19 Thu 21:39:10] : 2026-11-05
[2026-11-19 Thu 21:39:10] : 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-19 21:39:09#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-19','2026-11-19 21:39:09','2026-11-19 21:39:09','get-app-info.php')
[2026-11-19 Thu 21:39:10] : 1
[2026-11-19 Thu 21:39:10] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:10] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:10] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:10] : Batch ID: 2026-11-19 21:39:09#Google Play Store#AppInfoId_12#AppName_City Corp
[2026-11-19 Thu 21:39:10] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:10] : Misc Test: 2026-11-19 21:39:09#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-19 Thu 21:39:10] : APP_VERSION
[2026-11-19 Thu 21:39:10] : 
[2026-11-19 Thu 21:39:10] : 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-19 21:39:09#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-19','2026-11-19 21:39:09','2026-11-19 21:39:09','get-app-info.php')
[2026-11-19 Thu 21:39:10] : 1
[2026-11-19 Thu 21:39:10] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:10] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:10] : Misc Test: 2026-11-19 21:39:09#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-19 Thu 21:39:10] : APP_LAST_UPDATE
[2026-11-19 Thu 21:39:10] : 2026-09-09
[2026-11-19 Thu 21:39:10] : 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-19 21:39:09#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-19','2026-11-19 21:39:09','2026-11-19 21:39:09','get-app-info.php')
[2026-11-19 Thu 21:39:10] : 1
[2026-11-19 Thu 21:39:10] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:10] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:10] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:10] : Batch ID: 2026-11-19 21:39:09#Apple I Store#AppInfoId_16#AppName_City Touch
[2026-11-19 Thu 21:39:10] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:10] : Misc Test: 2026-11-19 21:39:09#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-19 Thu 21:39:10] : APP_VERSION
[2026-11-19 Thu 21:39:10] : 
[2026-11-19 Thu 21:39:10] : 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-19 21:39:09#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-19','2026-11-19 21:39:09','2026-11-19 21:39:09','get-app-info.php')
[2026-11-19 Thu 21:39:10] : 1
[2026-11-19 Thu 21:39:10] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:10] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:10] : Misc Test: 2026-11-19 21:39:09#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-19 Thu 21:39:10] : APP_LAST_UPDATE
[2026-11-19 Thu 21:39:10] : --00
[2026-11-19 Thu 21:39:10] : 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-19 21:39:09#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-19','2026-11-19 21:39:09','2026-11-19 21:39:09','get-app-info.php')
[2026-11-19 Thu 21:39:10] : 1
[2026-11-19 Thu 21:39:10] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:10] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:10] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:10] : Batch ID: 2026-11-19 21:39:09#Apple I Store#AppInfoId_17#AppName_City Corp
[2026-11-19 Thu 21:39:10] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:10] : Misc Test: 2026-11-19 21:39:09#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-19 Thu 21:39:10] : APP_VERSION
[2026-11-19 Thu 21:39:10] : 
[2026-11-19 Thu 21:39:10] : 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-19 21:39:09#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-19','2026-11-19 21:39:09','2026-11-19 21:39:09','get-app-info.php')
[2026-11-19 Thu 21:39:10] : 1
[2026-11-19 Thu 21:39:10] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:10] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:10] : Misc Test: 2026-11-19 21:39:09#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-19 Thu 21:39:10] : APP_LAST_UPDATE
[2026-11-19 Thu 21:39:10] : --00
[2026-11-19 Thu 21:39:10] : 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-19 21:39:09#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-19','2026-11-19 21:39:09','2026-11-19 21:39:09','get-app-info.php')
[2026-11-19 Thu 21:39:10] : 1
[2026-11-19 Thu 21:39:10] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:10] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 21:39:10] : Connection closed
[2026-11-19 Thu 21:39:10] : ************************ END ***************************
[2026-11-19 Thu 21:39:10] : *********************** START Data Parsing Error Checker**************************
[2026-11-19 Thu 21:39: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-19'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2026-11-19 Thu 21:39:10] : Total Record Fetch: 24
[2026-11-19 Thu 21:39:10] : 2026-11-19 21:39:09 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 21:39:10] : 2026-11-19 21:39:03 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 21:39:10] : 2026-11-19 05:00:05 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 21:39:10] : 2026-11-19 21:39:09 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:10] : 2026-11-19 21:39:03 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:10] : 2026-11-19 05:00:05 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:10] : 2026-11-19 21:39:09 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 21:39:10] : 2026-11-19 21:39:03 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 21:39:10] : 2026-11-19 05:00:05 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 21:39:10] : 2026-11-19 21:39:09 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:10] : 2026-11-19 21:39:03 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:10] : 2026-11-19 05:00:05 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:10] : 2026-11-19 21:39:09 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 21:39:10] : 2026-11-19 21:39:03 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 21:39:10] : 2026-11-19 05:00:05 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 21:39:10] : 2026-11-19 21:39:09 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:10] : 2026-11-19 21:39:03 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:10] : 2026-11-19 05:00:05 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:10] : 2026-11-19 21:39:09 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 21:39:10] : 2026-11-19 21:39:03 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 21:39:10] : 2026-11-19 05:00:05 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 21:39:10] : 2026-11-19 21:39:09 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:10] : 2026-11-19 21:39:03 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:10] : 2026-11-19 05:00:05 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39: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-19 Thu 21:39:10] : Connection closed
[2026-11-19 Thu 21:39:10] : ************************ END ***************************
[2026-11-19 Thu 21:39:11] : *********************** START Data Parsing Error Checker**************************
[2026-11-19 Thu 21:39:11] : *********************** START Send Deviation Alert**************************
[2026-11-19 Thu 21:39:12] : *********************** START Send Deviation Alert**************************
[2026-11-19 Thu 21:39:12] : 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-19'
				) 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-18'
				) 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-19 Thu 21:39:12] : 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-19'
				) 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-18'
				) 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-19 Thu 21:39:12] : Total Record Fetch: 8
[2026-11-19 Thu 21:39:12] : <h1 style="color:green">No Mismatch Found!!!</h1>
[2026-11-19 Thu 21:39:12] : Total Record Fetch: 8
[2026-11-19 Thu 21:39:12] : <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-19</span></th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #FFA500">2026-11-18</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-19 Thu 21:39:12] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server
[2026-11-19 Thu 21:39:12] : Connection closed
[2026-11-19 Thu 21:39:12] : ************************ END ***************************
[2026-11-19 Thu 21:39:12] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: QUIT command failed Detail: ŒÿåJÄ¶i‚úCù_*�`ZuÌ§¡Fsë·c¯VÂ2ÅçØ4‹Às!¥Ð%!øøÓÒ(K¦heG²$÷Ú�F«ªË»FÝIºrÞ˜ù=?áÐë–¥z§W`«òß�Ã1$´ßŒ64�¢\5À;291öBó0AÅ¬ ã¥�U4ÃT½_€¾rB±•Ç"Ü[t<âoàéÑ^C�É[×°ý‡�ÓÃ-am+†ïrØ§ïÞ´F;µïñ�!iÖë†¼ŠÍ#Ë¸¶tï-"r÷o»úÓ·ª¸&ûífÒ;ÁM¡ÐT.%ì©èÑéíñ-H ò‡¹I�ð¥W›h*6·t¯vÈ;ÕF|¦–÷X4mÄ–¢ø™�…Fn9 Eoü.
¨º’Ãûªë„†Og¹ëO„.ï^L»œ_­€Å¨�µ‰Ù	/¨wÅ§ìÞÜK&Ã‚+#ÀÕí‹£$~ý04&A221 pink.dnsnetservice.com closing connection

[2026-11-19 Thu 21:39:12] : Connection closed
[2026-11-19 Thu 21:39:12] : ************************ END ***************************
[2026-11-19 Thu 21:39:12] : *********************** START Data Parsing Error Checker**************************
[2026-11-19 Thu 21:39:12] : 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-19'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2026-11-19 Thu 21:39:12] : Total Record Fetch: 24
[2026-11-19 Thu 21:39:12] : 2026-11-19 21:39:09 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 21:39:12] : 2026-11-19 21:39:03 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 21:39:12] : 2026-11-19 05:00:05 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 21:39:12] : 2026-11-19 21:39:09 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:12] : 2026-11-19 21:39:03 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:12] : 2026-11-19 05:00:05 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:12] : 2026-11-19 21:39:09 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 21:39:12] : 2026-11-19 21:39:03 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 21:39:12] : 2026-11-19 05:00:05 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 21:39:12] : 2026-11-19 21:39:09 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:12] : 2026-11-19 21:39:03 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:12] : 2026-11-19 05:00:05 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:12] : 2026-11-19 21:39:09 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 21:39:12] : 2026-11-19 21:39:03 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 21:39:12] : 2026-11-19 05:00:05 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 21:39:12] : 2026-11-19 21:39:09 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:12] : 2026-11-19 21:39:03 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:12] : 2026-11-19 05:00:05 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:12] : 2026-11-19 21:39:09 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 21:39:12] : 2026-11-19 21:39:03 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 21:39:12] : 2026-11-19 05:00:05 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 21:39:12] : 2026-11-19 21:39:09 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:12] : 2026-11-19 21:39:03 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:12] : 2026-11-19 05:00:05 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 21:39:12] : 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-19 Thu 21:39:12] : Connection closed
[2026-11-19 Thu 21:39:12] : ************************ END ***************************
[2026-11-19 Thu 23:12:15] : *********************** START **************************
[2026-11-19 Thu 23:12:15] : select id, status_code from status_code where status='Active'
[2026-11-19 Thu 23:12:15] : Status Code Result: 2
[2026-11-19 Thu 23:12:15] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2026-11-19 Thu 23:12:15] : App Info Result: 4
[2026-11-19 Thu 23:12:15] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:15] : Batch ID: 2026-11-19 23:12:15#Google Play Store#AppInfoId_11#AppName_City Touch
[2026-11-19 Thu 23:12:15] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:15] : Misc Test: 2026-11-19 23:12:15#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-19 Thu 23:12:15] : APP_VERSION
[2026-11-19 Thu 23:12:15] : 
[2026-11-19 Thu 23:12:15] : 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-19 23:12:15#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-19','2026-11-19 23:12:15','2026-11-19 23:12:15','get-app-info.php')
[2026-11-19 Thu 23:12:15] : 1
[2026-11-19 Thu 23:12:15] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:15] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:15] : Misc Test: 2026-11-19 23:12:15#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-19 Thu 23:12:15] : APP_LAST_UPDATE
[2026-11-19 Thu 23:12:15] : 2026-11-05
[2026-11-19 Thu 23:12:15] : 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-19 23:12:15#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-19','2026-11-19 23:12:15','2026-11-19 23:12:15','get-app-info.php')
[2026-11-19 Thu 23:12:15] : 1
[2026-11-19 Thu 23:12:15] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:15] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:15] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:15] : Batch ID: 2026-11-19 23:12:15#Google Play Store#AppInfoId_12#AppName_City Corp
[2026-11-19 Thu 23:12:15] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:15] : Misc Test: 2026-11-19 23:12:15#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-19 Thu 23:12:15] : APP_VERSION
[2026-11-19 Thu 23:12:16] : 
[2026-11-19 Thu 23:12:16] : 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-19 23:12:15#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-19','2026-11-19 23:12:15','2026-11-19 23:12:15','get-app-info.php')
[2026-11-19 Thu 23:12:16] : 1
[2026-11-19 Thu 23:12:16] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:16] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:16] : Misc Test: 2026-11-19 23:12:15#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-19 Thu 23:12:16] : APP_LAST_UPDATE
[2026-11-19 Thu 23:12:16] : 2026-09-09
[2026-11-19 Thu 23:12:16] : 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-19 23:12:15#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-19','2026-11-19 23:12:15','2026-11-19 23:12:15','get-app-info.php')
[2026-11-19 Thu 23:12:16] : 1
[2026-11-19 Thu 23:12:16] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:16] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:16] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:16] : Batch ID: 2026-11-19 23:12:15#Apple I Store#AppInfoId_16#AppName_City Touch
[2026-11-19 Thu 23:12:16] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:16] : Misc Test: 2026-11-19 23:12:15#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-19 Thu 23:12:16] : APP_VERSION
[2026-11-19 Thu 23:12:16] : *********************** START Data Parsing Error Checker**************************
[2026-11-19 Thu 23:12:16] : 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-19'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2026-11-19 Thu 23:12:16] : Total Record Fetch: 28
[2026-11-19 Thu 23:12:16] : 2026-11-19 21:39:09 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:16] : 2026-11-19 21:39:03 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:16] : 2026-11-19 05:00:05 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:16] : 2026-11-19 21:39:09 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:16] : 2026-11-19 21:39:03 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:16] : 2026-11-19 05:00:05 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:16] : 2026-11-19 21:39:09 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:16] : 2026-11-19 21:39:03 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:16] : 2026-11-19 05:00:05 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:16] : 2026-11-19 21:39:09 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:16] : 2026-11-19 21:39:03 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:16] : 2026-11-19 05:00:05 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:16] : 2026-11-19 23:12:15 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 23:12:16] : 2026-11-19 21:39:09 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 23:12:16] : 2026-11-19 21:39:03 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 23:12:16] : 2026-11-19 05:00:05 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 23:12:16] : 2026-11-19 23:12:15 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:16] : 2026-11-19 21:39:09 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:16] : 2026-11-19 21:39:03 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:16] : 2026-11-19 05:00:05 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:16] : 2026-11-19 23:12:15 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 23:12:16] : 2026-11-19 21:39:09 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 23:12:16] : 2026-11-19 21:39:03 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 23:12:16] : 2026-11-19 05:00:05 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 23:12:16] : 2026-11-19 23:12:15 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:16] : 2026-11-19 21:39:09 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:16] : 2026-11-19 21:39:03 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:16] : 2026-11-19 05:00:05 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:16] : 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-19 Thu 23:12:16] : Connection closed
[2026-11-19 Thu 23:12:16] : ************************ END ***************************
[2026-11-19 Thu 23:12:16] : *********************** START Data Parsing Error Checker**************************
[2026-11-19 Thu 23:12:17] : 
[2026-11-19 Thu 23:12:17] : 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-19 23:12:15#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-19','2026-11-19 23:12:15','2026-11-19 23:12:15','get-app-info.php')
[2026-11-19 Thu 23:12:17] : 1
[2026-11-19 Thu 23:12:17] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:17] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:17] : Misc Test: 2026-11-19 23:12:15#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-19 Thu 23:12:17] : APP_LAST_UPDATE
[2026-11-19 Thu 23:12:17] : --00
[2026-11-19 Thu 23:12:17] : 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-19 23:12:15#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-19','2026-11-19 23:12:15','2026-11-19 23:12:15','get-app-info.php')
[2026-11-19 Thu 23:12:17] : 1
[2026-11-19 Thu 23:12:17] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:17] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:17] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:17] : Batch ID: 2026-11-19 23:12:15#Apple I Store#AppInfoId_17#AppName_City Corp
[2026-11-19 Thu 23:12:17] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:17] : Misc Test: 2026-11-19 23:12:15#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-19 Thu 23:12:17] : APP_VERSION
[2026-11-19 Thu 23:12:17] : *********************** START Send Deviation Alert**************************
[2026-11-19 Thu 23:12:17] : 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-19'
				) 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-18'
				) 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-19 Thu 23:12:17] : Total Record Fetch: 8
[2026-11-19 Thu 23:12:17] : <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-19</span></th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #FFA500">2026-11-18</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-19 Thu 23:12:17] : *********************** START Send Deviation Alert**************************
[2026-11-19 Thu 23:12:17] : 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-19'
				) 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-18'
				) 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-19 Thu 23:12:17] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server
[2026-11-19 Thu 23:12:17] : Connection closed
[2026-11-19 Thu 23:12:17] : ************************ END ***************************
[2026-11-19 Thu 23:12:17] : Total Record Fetch: 8
[2026-11-19 Thu 23:12:17] : <h1 style="color:green">No Mismatch Found!!!</h1>
[2026-11-19 Thu 23:12:17] : 
[2026-11-19 Thu 23:12:17] : 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-19 23:12:15#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-19','2026-11-19 23:12:15','2026-11-19 23:12:15','get-app-info.php')
[2026-11-19 Thu 23:12:17] : 1
[2026-11-19 Thu 23:12:17] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:17] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:17] : Misc Test: 2026-11-19 23:12:15#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-19 Thu 23:12:17] : APP_LAST_UPDATE
[2026-11-19 Thu 23:12:17] : --00
[2026-11-19 Thu 23:12:17] : 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-19 23:12:15#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-19','2026-11-19 23:12:15','2026-11-19 23:12:15','get-app-info.php')
[2026-11-19 Thu 23:12:17] : 1
[2026-11-19 Thu 23:12:17] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:17] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:17] : Connection closed
[2026-11-19 Thu 23:12:17] : ************************ END ***************************
[2026-11-19 Thu 23:12:17] : *********************** START Data Parsing Error Checker**************************
[2026-11-19 Thu 23:12:17] : 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-19'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2026-11-19 Thu 23:12:17] : Total Record Fetch: 32
[2026-11-19 Thu 23:12:17] : 2026-11-19 23:12:15 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 21:39:09 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 21:39:03 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 05:00:05 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 23:12:15 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 21:39:09 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 21:39:03 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 05:00:05 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 23:12:15 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 21:39:09 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 21:39:03 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 05:00:05 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 23:12:15 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 21:39:09 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 21:39:03 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 05:00:05 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 23:12:15 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 21:39:09 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 21:39:03 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 05:00:05 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 23:12:15 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 21:39:09 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 21:39:03 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 05:00:05 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 23:12:15 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 21:39:09 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 21:39:03 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 05:00:05 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 23:12:15 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 21:39:09 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 21:39:03 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:17] : 2026-11-19 05:00:05 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:17] : 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-19 Thu 23:12:17] : Connection closed
[2026-11-19 Thu 23:12:17] : ************************ END ***************************
[2026-11-19 Thu 23:12:17] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: QUIT command failed Detail: wP´'~Ûã)qƒL•Ü1‡ŽL�ó%”%ð·´rÍz×²×]3ýk¡­@gÕÝ¢vàz—è§Û�Ê­·_¹æ1”0ºÐ_IŽu•²ˆ“‚+Ði{ßˆn–XK¶šºÑk¶êc±@„æô•5»¾m;·Éên_û›Jô:çž¿¤žÿnãQn‹% É%q]X�Ú&�&ŒøDÜ á/= ~J`zE†ÒlxÚÔ”H“gÙx%-e”b¬
<Š¯ÒNöÈTY>+/96e 
ôkW�f€Xfú­üåb«ON°=Æ€?ì>/–M«‘Ö&ÔP1+òsåŽåK©�¸(åäqËãwcösÚ.~GØ.%Ø\¿BÃ»ƒD¶1ÖÏÛm ER©±7|°’Ÿl¯9ýëu¤4~0LlèÐ®ÅW)AZ‡Œi:o`òÝþóxWŽX=Å§+_?�Æ	óƒW6žD-221 pink.dnsnetservice.com closing connection

[2026-11-19 Thu 23:12:17] : Connection closed
[2026-11-19 Thu 23:12:17] : ************************ END ***************************
[2026-11-19 Thu 23:12:17] : *********************** START **************************
[2026-11-19 Thu 23:12:17] : select id, status_code from status_code where status='Active'
[2026-11-19 Thu 23:12:17] : Status Code Result: 2
[2026-11-19 Thu 23:12:17] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2026-11-19 Thu 23:12:17] : App Info Result: 4
[2026-11-19 Thu 23:12:17] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:17] : Batch ID: 2026-11-19 23:12:17#Google Play Store#AppInfoId_11#AppName_City Touch
[2026-11-19 Thu 23:12:17] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:17] : Misc Test: 2026-11-19 23:12:17#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-19 Thu 23:12:17] : APP_VERSION
[2026-11-19 Thu 23:12:18] : 
[2026-11-19 Thu 23:12:18] : 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-19 23:12:17#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-19','2026-11-19 23:12:17','2026-11-19 23:12:17','get-app-info.php')
[2026-11-19 Thu 23:12:18] : 1
[2026-11-19 Thu 23:12:18] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:18] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:18] : Misc Test: 2026-11-19 23:12:17#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-19 Thu 23:12:18] : APP_LAST_UPDATE
[2026-11-19 Thu 23:12:18] : 2026-11-05
[2026-11-19 Thu 23:12:18] : 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-19 23:12:17#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-19','2026-11-19 23:12:17','2026-11-19 23:12:17','get-app-info.php')
[2026-11-19 Thu 23:12:18] : 1
[2026-11-19 Thu 23:12:18] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:18] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:18] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:18] : Batch ID: 2026-11-19 23:12:17#Google Play Store#AppInfoId_12#AppName_City Corp
[2026-11-19 Thu 23:12:18] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:18] : Misc Test: 2026-11-19 23:12:17#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-19 Thu 23:12:18] : APP_VERSION
[2026-11-19 Thu 23:12:18] : 
[2026-11-19 Thu 23:12:18] : 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-19 23:12:17#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-19','2026-11-19 23:12:17','2026-11-19 23:12:17','get-app-info.php')
[2026-11-19 Thu 23:12:18] : 1
[2026-11-19 Thu 23:12:18] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:18] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:18] : Misc Test: 2026-11-19 23:12:17#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-19 Thu 23:12:18] : APP_LAST_UPDATE
[2026-11-19 Thu 23:12:18] : 2026-09-09
[2026-11-19 Thu 23:12:18] : 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-19 23:12:17#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-19','2026-11-19 23:12:17','2026-11-19 23:12:17','get-app-info.php')
[2026-11-19 Thu 23:12:18] : 1
[2026-11-19 Thu 23:12:18] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:18] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:18] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:18] : Batch ID: 2026-11-19 23:12:17#Apple I Store#AppInfoId_16#AppName_City Touch
[2026-11-19 Thu 23:12:18] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:18] : Misc Test: 2026-11-19 23:12:17#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-19 Thu 23:12:18] : APP_VERSION
[2026-11-19 Thu 23:12:18] : 
[2026-11-19 Thu 23:12:18] : 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-19 23:12:17#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-19','2026-11-19 23:12:17','2026-11-19 23:12:17','get-app-info.php')
[2026-11-19 Thu 23:12:18] : 1
[2026-11-19 Thu 23:12:18] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:18] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:18] : Misc Test: 2026-11-19 23:12:17#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-19 Thu 23:12:18] : APP_LAST_UPDATE
[2026-11-19 Thu 23:12:18] : --00
[2026-11-19 Thu 23:12:18] : 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-19 23:12:17#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-19','2026-11-19 23:12:17','2026-11-19 23:12:17','get-app-info.php')
[2026-11-19 Thu 23:12:18] : 1
[2026-11-19 Thu 23:12:18] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:18] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:18] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:18] : Batch ID: 2026-11-19 23:12:17#Apple I Store#AppInfoId_17#AppName_City Corp
[2026-11-19 Thu 23:12:18] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:18] : Misc Test: 2026-11-19 23:12:17#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-19 Thu 23:12:18] : APP_VERSION
[2026-11-19 Thu 23:12:18] : 
[2026-11-19 Thu 23:12:18] : 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-19 23:12:17#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-19','2026-11-19 23:12:17','2026-11-19 23:12:17','get-app-info.php')
[2026-11-19 Thu 23:12:18] : 1
[2026-11-19 Thu 23:12:18] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:18] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:18] : Misc Test: 2026-11-19 23:12:17#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-19 Thu 23:12:18] : APP_LAST_UPDATE
[2026-11-19 Thu 23:12:18] : --00
[2026-11-19 Thu 23:12:18] : 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-19 23:12:17#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-19','2026-11-19 23:12:17','2026-11-19 23:12:17','get-app-info.php')
[2026-11-19 Thu 23:12:18] : 1
[2026-11-19 Thu 23:12:18] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:18] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:18] : Connection closed
[2026-11-19 Thu 23:12:18] : ************************ END ***************************
[2026-11-19 Thu 23:12:23] : *********************** START **************************
[2026-11-19 Thu 23:12:23] : select id, status_code from status_code where status='Active'
[2026-11-19 Thu 23:12:23] : Status Code Result: 2
[2026-11-19 Thu 23:12:23] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2026-11-19 Thu 23:12:23] : App Info Result: 4
[2026-11-19 Thu 23:12:23] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:23] : Batch ID: 2026-11-19 23:12:23#Google Play Store#AppInfoId_11#AppName_City Touch
[2026-11-19 Thu 23:12:23] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:23] : Misc Test: 2026-11-19 23:12:23#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-19 Thu 23:12:23] : APP_VERSION
[2026-11-19 Thu 23:12:23] : 
[2026-11-19 Thu 23:12:23] : 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-19 23:12:23#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-19','2026-11-19 23:12:23','2026-11-19 23:12:23','get-app-info.php')
[2026-11-19 Thu 23:12:23] : 1
[2026-11-19 Thu 23:12:23] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:23] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:23] : Misc Test: 2026-11-19 23:12:23#Google Play Store#AppInfoId_11#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-19 Thu 23:12:23] : APP_LAST_UPDATE
[2026-11-19 Thu 23:12:23] : 2026-11-05
[2026-11-19 Thu 23:12:23] : 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-19 23:12:23#Google Play Store#AppInfoId_11#AppName_City Touch','2026-11-19','2026-11-19 23:12:23','2026-11-19 23:12:23','get-app-info.php')
[2026-11-19 Thu 23:12:23] : 1
[2026-11-19 Thu 23:12:23] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:23] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:23] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:23] : Batch ID: 2026-11-19 23:12:23#Google Play Store#AppInfoId_12#AppName_City Corp
[2026-11-19 Thu 23:12:23] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:23] : Misc Test: 2026-11-19 23:12:23#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-19 Thu 23:12:23] : APP_VERSION
[2026-11-19 Thu 23:12:23] : 
[2026-11-19 Thu 23:12:23] : 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-19 23:12:23#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-19','2026-11-19 23:12:23','2026-11-19 23:12:23','get-app-info.php')
[2026-11-19 Thu 23:12:23] : 1
[2026-11-19 Thu 23:12:23] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:23] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:23] : Misc Test: 2026-11-19 23:12:23#Google Play Store#AppInfoId_12#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-19 Thu 23:12:23] : APP_LAST_UPDATE
[2026-11-19 Thu 23:12:24] : 2026-09-09
[2026-11-19 Thu 23:12:24] : 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-19 23:12:23#Google Play Store#AppInfoId_12#AppName_City Corp','2026-11-19','2026-11-19 23:12:23','2026-11-19 23:12:23','get-app-info.php')
[2026-11-19 Thu 23:12:24] : 1
[2026-11-19 Thu 23:12:24] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:24] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:24] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:24] : Batch ID: 2026-11-19 23:12:23#Apple I Store#AppInfoId_16#AppName_City Touch
[2026-11-19 Thu 23:12:24] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:24] : Misc Test: 2026-11-19 23:12:23#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-19 Thu 23:12:24] : APP_VERSION
[2026-11-19 Thu 23:12:24] : 
[2026-11-19 Thu 23:12:24] : 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-19 23:12:23#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-19','2026-11-19 23:12:23','2026-11-19 23:12:23','get-app-info.php')
[2026-11-19 Thu 23:12:24] : 1
[2026-11-19 Thu 23:12:24] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:24] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:24] : Misc Test: 2026-11-19 23:12:23#Apple I Store#AppInfoId_16#AppName_City Touch --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-19 Thu 23:12:24] : APP_LAST_UPDATE
[2026-11-19 Thu 23:12:24] : --00
[2026-11-19 Thu 23:12:24] : 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-19 23:12:23#Apple I Store#AppInfoId_16#AppName_City Touch','2026-11-19','2026-11-19 23:12:23','2026-11-19 23:12:23','get-app-info.php')
[2026-11-19 Thu 23:12:24] : 1
[2026-11-19 Thu 23:12:24] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:24] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:24] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:24] : Batch ID: 2026-11-19 23:12:23#Apple I Store#AppInfoId_17#AppName_City Corp
[2026-11-19 Thu 23:12:24] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:24] : Misc Test: 2026-11-19 23:12:23#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_VERSION --> 2 --> get-app-info.php
[2026-11-19 Thu 23:12:24] : APP_VERSION
[2026-11-19 Thu 23:12:24] : 
[2026-11-19 Thu 23:12:24] : 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-19 23:12:23#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-19','2026-11-19 23:12:23','2026-11-19 23:12:23','get-app-info.php')
[2026-11-19 Thu 23:12:24] : 1
[2026-11-19 Thu 23:12:24] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:24] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:24] : Misc Test: 2026-11-19 23:12:23#Apple I Store#AppInfoId_17#AppName_City Corp --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2026-11-19 Thu 23:12:24] : APP_LAST_UPDATE
[2026-11-19 Thu 23:12:24] : --00
[2026-11-19 Thu 23:12:24] : 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-19 23:12:23#Apple I Store#AppInfoId_17#AppName_City Corp','2026-11-19','2026-11-19 23:12:23','2026-11-19 23:12:23','get-app-info.php')
[2026-11-19 Thu 23:12:24] : 1
[2026-11-19 Thu 23:12:24] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:24] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-11-19 Thu 23:12:24] : Connection closed
[2026-11-19 Thu 23:12:24] : ************************ END ***************************
[2026-11-19 Thu 23:12:24] : *********************** START Data Parsing Error Checker**************************
[2026-11-19 Thu 23:12:24] : 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-19'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2026-11-19 Thu 23:12:24] : Total Record Fetch: 48
[2026-11-19 Thu 23:12:24] : 2026-11-19 23:12:23 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 23:12:17 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 23:12:15 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 21:39:09 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 21:39:03 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 05:00:05 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 23:12:23 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 23:12:17 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 23:12:15 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 21:39:09 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 21:39:03 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 05:00:05 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 23:12:23 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 23:12:17 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 23:12:15 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 21:39:09 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 21:39:03 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 05:00:05 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 23:12:23 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 23:12:17 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 23:12:15 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 21:39:09 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 21:39:03 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 05:00:05 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 23:12:23 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 23:12:17 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 23:12:15 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 21:39:09 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 21:39:03 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 05:00:05 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 23:12:23 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 23:12:17 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 23:12:15 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 21:39:09 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 21:39:03 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 05:00:05 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 23:12:23 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 23:12:17 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 23:12:15 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 21:39:09 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 21:39:03 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 05:00:05 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 23:12:23 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 23:12:17 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 23:12:15 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 21:39:09 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 21:39:03 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:24] : 2026-11-19 05:00:05 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:24] : 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-19 Thu 23:12:24] : Connection closed
[2026-11-19 Thu 23:12:24] : ************************ END ***************************
[2026-11-19 Thu 23:12:25] : *********************** START Send Deviation Alert**************************
[2026-11-19 Thu 23:12:25] : *********************** START Data Parsing Error Checker**************************
[2026-11-19 Thu 23:12:25] : 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-19'
				) 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-18'
				) 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-19 Thu 23:12:25] : Total Record Fetch: 8
[2026-11-19 Thu 23:12:25] : <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-19</span></th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #FFA500">2026-11-18</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-19 Thu 23:12:25] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server
[2026-11-19 Thu 23:12:25] : Connection closed
[2026-11-19 Thu 23:12:25] : ************************ END ***************************
[2026-11-19 Thu 23:12:25] : *********************** START Send Deviation Alert**************************
[2026-11-19 Thu 23:12:25] : 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-19'
				) 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-18'
				) 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-19 Thu 23:12:25] : Total Record Fetch: 8
[2026-11-19 Thu 23:12:25] : <h1 style="color:green">No Mismatch Found!!!</h1>
[2026-11-19 Thu 23:12:25] : *********************** START Data Parsing Error Checker**************************
[2026-11-19 Thu 23:12:25] : 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-19'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2026-11-19 Thu 23:12:25] : Total Record Fetch: 48
[2026-11-19 Thu 23:12:25] : 2026-11-19 23:12:23 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 23:12:17 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 23:12:15 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 21:39:09 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 21:39:03 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 05:00:05 -->City Corp -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 23:12:23 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 23:12:17 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 23:12:15 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 21:39:09 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 21:39:03 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 05:00:05 -->City Corp -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 23:12:23 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 23:12:17 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 23:12:15 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 21:39:09 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 21:39:03 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 05:00:05 -->City Touch -->Apple I Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->--00<br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 23:12:23 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 23:12:17 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 23:12:15 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 21:39:09 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 21:39:03 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 05:00:05 -->City Touch -->Apple I Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 23:12:23 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 23:12:17 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 23:12:15 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 21:39:09 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 21:39:03 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 05:00:05 -->City Corp -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-09-09<br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 23:12:23 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 23:12:17 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 23:12:15 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 21:39:09 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 21:39:03 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 05:00:05 -->City Corp -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 23:12:23 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 23:12:17 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 23:12:15 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 21:39:09 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 21:39:03 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 05:00:05 -->City Touch -->Google Play Store -->City Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2026-11-05<br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 23:12:23 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 23:12:17 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 23:12:15 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 21:39:09 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 21:39:03 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:25] : 2026-11-19 05:00:05 -->City Touch -->Google Play Store -->City Bank PLC -->APP_VERSION -->App Version --><br />
[2026-11-19 Thu 23:12:25] : 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-19 Thu 23:12:25] : Connection closed
[2026-11-19 Thu 23:12:25] : ************************ END ***************************
[2026-11-19 Thu 23:12:25] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: QUIT command failed Detail: »F ‹ÿEõ¤äLª–³ŸþY*sØÕ ¨(æŒÌž’ÇS?Ïæ¤­Pæe™Â«�Ìåê€ZJðNµ-‹5®;Z‡uŠÑ™ØˆxÂ0Ë¥KQïúKië(<­€�#×a›�_Yç¿ž­T¥aÜ¾JËÐr¦hª²]�Ýœže×FÆ=­ï!L‹SÑôÕË�š‚=§ÕÀ¹áÈVáÖÐ¾¡è<C
lS]HÂŽ8¨�'ùU^4ÿ>ÈiñüNq£CŒÍ3¼áŒò¿‚L÷��8Úz¯Ä‰	ïÏêÆÈÒ0Wî¢Ú744UP˜E=§Øî¸$Vhq`�Ý\Wg±ŠhSúï�í®&Ú½¿óÝp·ßñ· E“ô]oæN¦¶’K-«$HQ6±nŒ¶å€gs:ZŒsûDoFÚÊE´S\Šfz5½˜–¶s ûPoÁäþr¥øH³i²à221 pink.dnsnetservice.com closing connection

[2026-11-19 Thu 23:12:25] : Connection closed
[2026-11-19 Thu 23:12:25] : ************************ END ***************************