[2024-01-27 Sat 05:00:02] : *********************** START **************************
[2024-01-27 Sat 05:00:02] : select id, status_code from status_code where status='Active'
[2024-01-27 Sat 05:00:02] : Status Code Result: 2
[2024-01-27 Sat 05:00:02] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2024-01-27 Sat 05:00:02] : App Info Result: 6
[2024-01-27 Sat 05:00:02] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:02] : Batch ID: 2024-01-27 05:00:02#Google Play Store#AppInfoId_1#AppName_Unet
[2024-01-27 Sat 05:00:02] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:02] : Misc Test: 2024-01-27 05:00:02#Google Play Store#AppInfoId_1#AppName_Unet --> APP_VERSION --> 2 --> get-app-info.php
[2024-01-27 Sat 05:00:02] : APP_VERSION
[2024-01-27 Sat 05:00:02] : 3.36
[2024-01-27 Sat 05:00:02] : 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 (1,2,'3.36','2024-01-27 05:00:02#Google Play Store#AppInfoId_1#AppName_Unet','2024-01-27','2024-01-27 05:00:02','2024-01-26 23:00:02','get-app-info.php')
[2024-01-27 Sat 05:00:02] : 1
[2024-01-27 Sat 05:00:02] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:02] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:02] : Misc Test: 2024-01-27 05:00:02#Google Play Store#AppInfoId_1#AppName_Unet --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2024-01-27 Sat 05:00:02] : APP_LAST_UPDATE
[2024-01-27 Sat 05:00:02] : 2024-01-10
[2024-01-27 Sat 05:00:02] : 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 (1,5,'2024-01-10','2024-01-27 05:00:02#Google Play Store#AppInfoId_1#AppName_Unet','2024-01-27','2024-01-27 05:00:02','2024-01-26 23:00:02','get-app-info.php')
[2024-01-27 Sat 05:00:02] : 1
[2024-01-27 Sat 05:00:02] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:02] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:02] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:02] : Batch ID: 2024-01-27 05:00:02#Google Play Store#AppInfoId_2#AppName_UClick
[2024-01-27 Sat 05:00:02] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:02] : Misc Test: 2024-01-27 05:00:02#Google Play Store#AppInfoId_2#AppName_UClick --> APP_VERSION --> 2 --> get-app-info.php
[2024-01-27 Sat 05:00:02] : APP_VERSION
[2024-01-27 Sat 05:00:02] : 1.1.1.2
[2024-01-27 Sat 05:00:02] : 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 (2,2,'1.1.1.2','2024-01-27 05:00:02#Google Play Store#AppInfoId_2#AppName_UClick','2024-01-27','2024-01-27 05:00:02','2024-01-26 23:00:02','get-app-info.php')
[2024-01-27 Sat 05:00:02] : 1
[2024-01-27 Sat 05:00:02] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:02] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:02] : Misc Test: 2024-01-27 05:00:02#Google Play Store#AppInfoId_2#AppName_UClick --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2024-01-27 Sat 05:00:02] : APP_LAST_UPDATE
[2024-01-27 Sat 05:00:02] : 2024-01-03
[2024-01-27 Sat 05:00:02] : 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 (2,5,'2024-01-03','2024-01-27 05:00:02#Google Play Store#AppInfoId_2#AppName_UClick','2024-01-27','2024-01-27 05:00:02','2024-01-26 23:00:02','get-app-info.php')
[2024-01-27 Sat 05:00:02] : 1
[2024-01-27 Sat 05:00:02] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:02] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:02] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:02] : Batch ID: 2024-01-27 05:00:02#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking
[2024-01-27 Sat 05:00:02] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:02] : Misc Test: 2024-01-27 05:00:02#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking --> APP_VERSION --> 2 --> get-app-info.php
[2024-01-27 Sat 05:00:02] : APP_VERSION
[2024-01-27 Sat 05:00:03] : 1.0.21
[2024-01-27 Sat 05:00:03] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (3,2,'1.0.21','2024-01-27 05:00:02#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking','2024-01-27','2024-01-27 05:00:02','2024-01-26 23:00:02','get-app-info.php')
[2024-01-27 Sat 05:00:03] : 1
[2024-01-27 Sat 05:00:03] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:03] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:03] : Misc Test: 2024-01-27 05:00:02#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2024-01-27 Sat 05:00:03] : APP_LAST_UPDATE
[2024-01-27 Sat 05:00:03] : 2023-12-16
[2024-01-27 Sat 05:00:03] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (3,5,'2023-12-16','2024-01-27 05:00:02#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking','2024-01-27','2024-01-27 05:00:02','2024-01-26 23:00:02','get-app-info.php')
[2024-01-27 Sat 05:00:03] : 1
[2024-01-27 Sat 05:00:03] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:03] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:03] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:03] : Batch ID: 2024-01-27 05:00:02#Apple I Store#AppInfoId_4#AppName_UCB Unet
[2024-01-27 Sat 05:00:03] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:03] : Misc Test: 2024-01-27 05:00:02#Apple I Store#AppInfoId_4#AppName_UCB Unet --> APP_VERSION --> 2 --> get-app-info.php
[2024-01-27 Sat 05:00:03] : APP_VERSION
[2024-01-27 Sat 05:00:03] : 2.3.6
[2024-01-27 Sat 05:00:03] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (4,2,'2.3.6','2024-01-27 05:00:02#Apple I Store#AppInfoId_4#AppName_UCB Unet','2024-01-27','2024-01-27 05:00:02','2024-01-26 23:00:02','get-app-info.php')
[2024-01-27 Sat 05:00:03] : 1
[2024-01-27 Sat 05:00:03] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:03] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:03] : Misc Test: 2024-01-27 05:00:02#Apple I Store#AppInfoId_4#AppName_UCB Unet --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2024-01-27 Sat 05:00:03] : APP_LAST_UPDATE
[2024-01-27 Sat 05:00:04] : 2024-01-17
[2024-01-27 Sat 05:00:04] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (4,5,'2024-01-17','2024-01-27 05:00:02#Apple I Store#AppInfoId_4#AppName_UCB Unet','2024-01-27','2024-01-27 05:00:02','2024-01-26 23:00:02','get-app-info.php')
[2024-01-27 Sat 05:00:04] : 1
[2024-01-27 Sat 05:00:04] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:04] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:04] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:04] : Batch ID: 2024-01-27 05:00:02#Apple I Store#AppInfoId_5#AppName_UClick
[2024-01-27 Sat 05:00:04] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:04] : Misc Test: 2024-01-27 05:00:02#Apple I Store#AppInfoId_5#AppName_UClick --> APP_VERSION --> 2 --> get-app-info.php
[2024-01-27 Sat 05:00:04] : APP_VERSION
[2024-01-27 Sat 05:00:04] : 1.1.3
[2024-01-27 Sat 05:00:04] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (5,2,'1.1.3','2024-01-27 05:00:02#Apple I Store#AppInfoId_5#AppName_UClick','2024-01-27','2024-01-27 05:00:02','2024-01-26 23:00:02','get-app-info.php')
[2024-01-27 Sat 05:00:04] : 1
[2024-01-27 Sat 05:00:04] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:04] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:04] : Misc Test: 2024-01-27 05:00:02#Apple I Store#AppInfoId_5#AppName_UClick --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2024-01-27 Sat 05:00:04] : APP_LAST_UPDATE
[2024-01-27 Sat 05:00:04] : 2024-01-03
[2024-01-27 Sat 05:00:04] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (5,5,'2024-01-03','2024-01-27 05:00:02#Apple I Store#AppInfoId_5#AppName_UClick','2024-01-27','2024-01-27 05:00:02','2024-01-26 23:00:02','get-app-info.php')
[2024-01-27 Sat 05:00:04] : 1
[2024-01-27 Sat 05:00:04] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:04] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:04] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:04] : Batch ID: 2024-01-27 05:00:02#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking
[2024-01-27 Sat 05:00:04] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:04] : Misc Test: 2024-01-27 05:00:02#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking --> APP_VERSION --> 2 --> get-app-info.php
[2024-01-27 Sat 05:00:04] : APP_VERSION
[2024-01-27 Sat 05:00:05] : 1.1.1
[2024-01-27 Sat 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 (6,2,'1.1.1','2024-01-27 05:00:02#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking','2024-01-27','2024-01-27 05:00:02','2024-01-26 23:00:02','get-app-info.php')
[2024-01-27 Sat 05:00:05] : 1
[2024-01-27 Sat 05:00:05] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:05] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:05] : Misc Test: 2024-01-27 05:00:02#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2024-01-27 Sat 05:00:05] : APP_LAST_UPDATE
[2024-01-27 Sat 05:00:05] : 2023-12-20
[2024-01-27 Sat 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 (6,5,'2023-12-20','2024-01-27 05:00:02#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking','2024-01-27','2024-01-27 05:00:02','2024-01-26 23:00:02','get-app-info.php')
[2024-01-27 Sat 05:00:05] : 1
[2024-01-27 Sat 05:00:05] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:05] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 05:00:05] : Connection closed
[2024-01-27 Sat 05:00:05] : ************************ END ***************************
[2024-01-27 Sat 06:25:19] : *********************** START **************************
[2024-01-27 Sat 06:25:19] : select id, status_code from status_code where status='Active'
[2024-01-27 Sat 06:25:19] : Status Code Result: 2
[2024-01-27 Sat 06:25:19] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2024-01-27 Sat 06:25:19] : App Info Result: 6
[2024-01-27 Sat 06:25:19] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:19] : Batch ID: 2024-01-27 06:25:19#Google Play Store#AppInfoId_1#AppName_Unet
[2024-01-27 Sat 06:25:19] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:19] : Misc Test: 2024-01-27 06:25:19#Google Play Store#AppInfoId_1#AppName_Unet --> APP_VERSION --> 2 --> get-app-info.php
[2024-01-27 Sat 06:25:19] : APP_VERSION
[2024-01-27 Sat 06:25:19] : 3.36
[2024-01-27 Sat 06:25:19] : 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 (1,2,'3.36','2024-01-27 06:25:19#Google Play Store#AppInfoId_1#AppName_Unet','2024-01-27','2024-01-27 06:25:19','2024-01-27 06:25:19','get-app-info.php')
[2024-01-27 Sat 06:25:19] : 1
[2024-01-27 Sat 06:25:19] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:19] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:19] : Misc Test: 2024-01-27 06:25:19#Google Play Store#AppInfoId_1#AppName_Unet --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2024-01-27 Sat 06:25:19] : APP_LAST_UPDATE
[2024-01-27 Sat 06:25:20] : 2024-01-10
[2024-01-27 Sat 06:25:20] : 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 (1,5,'2024-01-10','2024-01-27 06:25:19#Google Play Store#AppInfoId_1#AppName_Unet','2024-01-27','2024-01-27 06:25:19','2024-01-27 06:25:19','get-app-info.php')
[2024-01-27 Sat 06:25:20] : 1
[2024-01-27 Sat 06:25:20] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:20] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:20] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:20] : Batch ID: 2024-01-27 06:25:19#Google Play Store#AppInfoId_2#AppName_UClick
[2024-01-27 Sat 06:25:20] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:20] : Misc Test: 2024-01-27 06:25:19#Google Play Store#AppInfoId_2#AppName_UClick --> APP_VERSION --> 2 --> get-app-info.php
[2024-01-27 Sat 06:25:20] : APP_VERSION
[2024-01-27 Sat 06:25:20] : 1.1.1.2
[2024-01-27 Sat 06:25:20] : 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 (2,2,'1.1.1.2','2024-01-27 06:25:19#Google Play Store#AppInfoId_2#AppName_UClick','2024-01-27','2024-01-27 06:25:19','2024-01-27 06:25:19','get-app-info.php')
[2024-01-27 Sat 06:25:20] : 1
[2024-01-27 Sat 06:25:20] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:20] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:20] : Misc Test: 2024-01-27 06:25:19#Google Play Store#AppInfoId_2#AppName_UClick --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2024-01-27 Sat 06:25:20] : APP_LAST_UPDATE
[2024-01-27 Sat 06:25:20] : 2024-01-03
[2024-01-27 Sat 06:25:20] : 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 (2,5,'2024-01-03','2024-01-27 06:25:19#Google Play Store#AppInfoId_2#AppName_UClick','2024-01-27','2024-01-27 06:25:19','2024-01-27 06:25:19','get-app-info.php')
[2024-01-27 Sat 06:25:20] : 1
[2024-01-27 Sat 06:25:20] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:20] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:20] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:20] : Batch ID: 2024-01-27 06:25:19#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking
[2024-01-27 Sat 06:25:20] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:20] : Misc Test: 2024-01-27 06:25:19#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking --> APP_VERSION --> 2 --> get-app-info.php
[2024-01-27 Sat 06:25:20] : APP_VERSION
[2024-01-27 Sat 06:25:21] : 1.0.21
[2024-01-27 Sat 06:25:21] : 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 (3,2,'1.0.21','2024-01-27 06:25:19#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking','2024-01-27','2024-01-27 06:25:19','2024-01-27 06:25:19','get-app-info.php')
[2024-01-27 Sat 06:25:21] : 1
[2024-01-27 Sat 06:25:21] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:21] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:21] : Misc Test: 2024-01-27 06:25:19#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2024-01-27 Sat 06:25:21] : APP_LAST_UPDATE
[2024-01-27 Sat 06:25:21] : 2023-12-16
[2024-01-27 Sat 06:25:21] : 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 (3,5,'2023-12-16','2024-01-27 06:25:19#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking','2024-01-27','2024-01-27 06:25:19','2024-01-27 06:25:19','get-app-info.php')
[2024-01-27 Sat 06:25:21] : 1
[2024-01-27 Sat 06:25:21] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:21] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:21] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:21] : Batch ID: 2024-01-27 06:25:19#Apple I Store#AppInfoId_4#AppName_UCB Unet
[2024-01-27 Sat 06:25:21] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:21] : Misc Test: 2024-01-27 06:25:19#Apple I Store#AppInfoId_4#AppName_UCB Unet --> APP_VERSION --> 2 --> get-app-info.php
[2024-01-27 Sat 06:25:21] : APP_VERSION
[2024-01-27 Sat 06:25:21] : 2.3.6
[2024-01-27 Sat 06:25:21] : 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 (4,2,'2.3.6','2024-01-27 06:25:19#Apple I Store#AppInfoId_4#AppName_UCB Unet','2024-01-27','2024-01-27 06:25:19','2024-01-27 06:25:19','get-app-info.php')
[2024-01-27 Sat 06:25:21] : 1
[2024-01-27 Sat 06:25:21] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:21] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:21] : Misc Test: 2024-01-27 06:25:19#Apple I Store#AppInfoId_4#AppName_UCB Unet --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2024-01-27 Sat 06:25:21] : APP_LAST_UPDATE
[2024-01-27 Sat 06:25:22] : 2024-01-17
[2024-01-27 Sat 06:25:22] : 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 (4,5,'2024-01-17','2024-01-27 06:25:19#Apple I Store#AppInfoId_4#AppName_UCB Unet','2024-01-27','2024-01-27 06:25:19','2024-01-27 06:25:19','get-app-info.php')
[2024-01-27 Sat 06:25:22] : 1
[2024-01-27 Sat 06:25:22] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:22] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:22] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:22] : Batch ID: 2024-01-27 06:25:19#Apple I Store#AppInfoId_5#AppName_UClick
[2024-01-27 Sat 06:25:22] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:22] : Misc Test: 2024-01-27 06:25:19#Apple I Store#AppInfoId_5#AppName_UClick --> APP_VERSION --> 2 --> get-app-info.php
[2024-01-27 Sat 06:25:22] : APP_VERSION
[2024-01-27 Sat 06:25:22] : 1.1.3
[2024-01-27 Sat 06:25:22] : 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 (5,2,'1.1.3','2024-01-27 06:25:19#Apple I Store#AppInfoId_5#AppName_UClick','2024-01-27','2024-01-27 06:25:19','2024-01-27 06:25:19','get-app-info.php')
[2024-01-27 Sat 06:25:22] : 1
[2024-01-27 Sat 06:25:22] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:22] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:22] : Misc Test: 2024-01-27 06:25:19#Apple I Store#AppInfoId_5#AppName_UClick --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2024-01-27 Sat 06:25:22] : APP_LAST_UPDATE
[2024-01-27 Sat 06:25:22] : 2024-01-03
[2024-01-27 Sat 06:25:22] : 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 (5,5,'2024-01-03','2024-01-27 06:25:19#Apple I Store#AppInfoId_5#AppName_UClick','2024-01-27','2024-01-27 06:25:19','2024-01-27 06:25:19','get-app-info.php')
[2024-01-27 Sat 06:25:22] : 1
[2024-01-27 Sat 06:25:22] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:22] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:22] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:22] : Batch ID: 2024-01-27 06:25:19#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking
[2024-01-27 Sat 06:25:22] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:22] : Misc Test: 2024-01-27 06:25:19#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking --> APP_VERSION --> 2 --> get-app-info.php
[2024-01-27 Sat 06:25:22] : APP_VERSION
[2024-01-27 Sat 06:25:22] : 1.1.1
[2024-01-27 Sat 06:25:22] : 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 (6,2,'1.1.1','2024-01-27 06:25:19#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking','2024-01-27','2024-01-27 06:25:19','2024-01-27 06:25:19','get-app-info.php')
[2024-01-27 Sat 06:25:22] : 1
[2024-01-27 Sat 06:25:22] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:22] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:22] : Misc Test: 2024-01-27 06:25:19#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2024-01-27 Sat 06:25:22] : APP_LAST_UPDATE
[2024-01-27 Sat 06:25:22] : 2023-12-20
[2024-01-27 Sat 06:25:22] : 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 (6,5,'2023-12-20','2024-01-27 06:25:19#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking','2024-01-27','2024-01-27 06:25:19','2024-01-27 06:25:19','get-app-info.php')
[2024-01-27 Sat 06:25:22] : 1
[2024-01-27 Sat 06:25:22] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:22] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 06:25:22] : Connection closed
[2024-01-27 Sat 06:25:22] : ************************ END ***************************
[2024-01-27 Sat 06:26:51] : *********************** START Data Parsing Error Checker**************************
[2024-01-27 Sat 06:26:51] : 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` = '2024-01-27'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2024-01-27 Sat 06:26:51] : Total Record Fetch: 24
[2024-01-27 Sat 06:26:51] : 2024-01-27 06:25:19 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-17<br />
[2024-01-27 Sat 06:26:51] : 2024-01-27 05:00:02 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-17<br />
[2024-01-27 Sat 06:26:51] : 2024-01-27 06:25:19 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->2.3.6<br />
[2024-01-27 Sat 06:26:51] : 2024-01-27 05:00:02 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->2.3.6<br />
[2024-01-27 Sat 06:26:51] : 2024-01-27 06:25:19 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-03<br />
[2024-01-27 Sat 06:26:51] : 2024-01-27 05:00:02 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-03<br />
[2024-01-27 Sat 06:26:51] : 2024-01-27 06:25:19 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.3<br />
[2024-01-27 Sat 06:26:51] : 2024-01-27 05:00:02 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.3<br />
[2024-01-27 Sat 06:26:51] : 2024-01-27 06:25:19 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-12-20<br />
[2024-01-27 Sat 06:26:51] : 2024-01-27 05:00:02 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-12-20<br />
[2024-01-27 Sat 06:26:51] : 2024-01-27 06:25:19 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.1<br />
[2024-01-27 Sat 06:26:51] : 2024-01-27 05:00:02 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.1<br />
[2024-01-27 Sat 06:26:51] : 2024-01-27 06:25:19 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-03<br />
[2024-01-27 Sat 06:26:51] : 2024-01-27 05:00:02 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-03<br />
[2024-01-27 Sat 06:26:51] : 2024-01-27 06:25:19 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.1.2<br />
[2024-01-27 Sat 06:26:51] : 2024-01-27 05:00:02 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.1.2<br />
[2024-01-27 Sat 06:26:51] : 2024-01-27 06:25:19 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-10<br />
[2024-01-27 Sat 06:26:51] : 2024-01-27 05:00:02 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-10<br />
[2024-01-27 Sat 06:26:51] : 2024-01-27 06:25:19 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->3.36<br />
[2024-01-27 Sat 06:26:51] : 2024-01-27 05:00:02 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->3.36<br />
[2024-01-27 Sat 06:26:51] : 2024-01-27 06:25:19 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-12-16<br />
[2024-01-27 Sat 06:26:51] : 2024-01-27 05:00:02 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-12-16<br />
[2024-01-27 Sat 06:26:51] : 2024-01-27 06:25:19 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.21<br />
[2024-01-27 Sat 06:26:51] : 2024-01-27 05:00:02 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.21<br />
[2024-01-27 Sat 06:26:51] : 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
[2024-01-27 Sat 06:26:51] : Connection closed
[2024-01-27 Sat 06:26:51] : ************************ END ***************************
[2024-01-27 Sat 06:27:36] : *********************** START Data Parsing Error Checker**************************
[2024-01-27 Sat 06:27:58] : *********************** START Send Deviation Alert**************************
[2024-01-27 Sat 06:27:58] : 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` = '2024-01-27'
				) 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` = '2024-01-26'
				) 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
[2024-01-27 Sat 06:27:58] : Total Record Fetch: 12
[2024-01-27 Sat 06:27:58] : <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">2024-01-27</span></th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #FFA500">2024-01-26</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">UCB Unet</td><td style="border: 1px solid #000;width: auto">United Commercial 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">2024-01-17</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2024-01-17</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">UCB Unet</td><td style="border: 1px solid #000;width: auto">United Commercial 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">2.3.6</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2.3.6</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">UClick</td><td style="border: 1px solid #000;width: auto">United Commercial 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">2024-01-03</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2024-01-03</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">UClick</td><td style="border: 1px solid #000;width: auto">United Commercial 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">1.1.3</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">1.1.3</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">Apple I Store</td><td style="border: 1px solid #000;width: auto">Unet Enterprise Banking</td><td style="border: 1px solid #000;width: auto">United Commercial 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">2023-12-20</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2023-12-20</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">Apple I Store</td><td style="border: 1px solid #000;width: auto">Unet Enterprise Banking</td><td style="border: 1px solid #000;width: auto">United Commercial 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">1.1.1</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">1.1.1</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">UClick</td><td style="border: 1px solid #000;width: auto">United Commercial 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">2024-01-03</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2024-01-03</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">UClick</td><td style="border: 1px solid #000;width: auto">United Commercial 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">1.1.1.2</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">1.1.1.2</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">9</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">Unet</td><td style="border: 1px solid #000;width: auto">United Commercial 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">2024-01-10</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2024-01-10</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">10</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">Unet</td><td style="border: 1px solid #000;width: auto">United Commercial 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">3.36</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">3.36</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">11</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">Unet Enterprise Banking</td><td style="border: 1px solid #000;width: auto">United Commercial 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">2023-12-16</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2023-12-16</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">12</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">Unet Enterprise Banking</td><td style="border: 1px solid #000;width: auto">United Commercial 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">1.0.21</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">1.0.21</td><td style="border: 1px solid #000;width: auto">Matched</td></tr></tbody></table>
[2024-01-27 Sat 06:27:58] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server
[2024-01-27 Sat 06:27:58] : Connection closed
[2024-01-27 Sat 06:27:58] : ************************ END ***************************
[2024-01-27 Sat 06:28:21] : *********************** START Send Deviation Alert**************************
[2024-01-27 Sat 06:28:21] : 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` = '2024-01-27'
				) 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` = '2024-01-26'
				) 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
[2024-01-27 Sat 06:28:21] : Total Record Fetch: 12
[2024-01-27 Sat 06:28:21] : <h1 style="color:green">No Mismatch Found!!!</h1>
[2024-01-27 Sat 06:28:21] : Mail sent on 2024-01-27 06:28:21
[2024-01-27 Sat 06:28:21] : Connection closed
[2024-01-27 Sat 06:28:21] : ************************ END ***************************
[2024-01-27 Sat 06:28:43] : *********************** START Data Parsing Error Checker**************************
[2024-01-27 Sat 06:28:43] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2024-01-27'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2024-01-27 Sat 06:28:43] : Total Record Fetch: 24
[2024-01-27 Sat 06:28:43] : 2024-01-27 06:25:19 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-17<br />
[2024-01-27 Sat 06:28:43] : 2024-01-27 05:00:02 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-17<br />
[2024-01-27 Sat 06:28:43] : 2024-01-27 06:25:19 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->2.3.6<br />
[2024-01-27 Sat 06:28:43] : 2024-01-27 05:00:02 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->2.3.6<br />
[2024-01-27 Sat 06:28:43] : 2024-01-27 06:25:19 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-03<br />
[2024-01-27 Sat 06:28:43] : 2024-01-27 05:00:02 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-03<br />
[2024-01-27 Sat 06:28:43] : 2024-01-27 06:25:19 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.3<br />
[2024-01-27 Sat 06:28:43] : 2024-01-27 05:00:02 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.3<br />
[2024-01-27 Sat 06:28:43] : 2024-01-27 06:25:19 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-12-20<br />
[2024-01-27 Sat 06:28:43] : 2024-01-27 05:00:02 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-12-20<br />
[2024-01-27 Sat 06:28:43] : 2024-01-27 06:25:19 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.1<br />
[2024-01-27 Sat 06:28:43] : 2024-01-27 05:00:02 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.1<br />
[2024-01-27 Sat 06:28:43] : 2024-01-27 06:25:19 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-03<br />
[2024-01-27 Sat 06:28:43] : 2024-01-27 05:00:02 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-03<br />
[2024-01-27 Sat 06:28:43] : 2024-01-27 06:25:19 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.1.2<br />
[2024-01-27 Sat 06:28:43] : 2024-01-27 05:00:02 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.1.2<br />
[2024-01-27 Sat 06:28:43] : 2024-01-27 06:25:19 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-10<br />
[2024-01-27 Sat 06:28:43] : 2024-01-27 05:00:02 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-10<br />
[2024-01-27 Sat 06:28:43] : 2024-01-27 06:25:19 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->3.36<br />
[2024-01-27 Sat 06:28:43] : 2024-01-27 05:00:02 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->3.36<br />
[2024-01-27 Sat 06:28:43] : 2024-01-27 06:25:19 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-12-16<br />
[2024-01-27 Sat 06:28:43] : 2024-01-27 05:00:02 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-12-16<br />
[2024-01-27 Sat 06:28:43] : 2024-01-27 06:25:19 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.21<br />
[2024-01-27 Sat 06:28:43] : 2024-01-27 05:00:02 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.21<br />
[2024-01-27 Sat 06:28:43] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server Additional SMTP info: php_network_getaddresses: getaddrinfo failed: Name or service not known
[2024-01-27 Sat 06:28:43] : Connection closed
[2024-01-27 Sat 06:28:43] : ************************ END ***************************
[2024-01-27 Sat 07:00:02] : *********************** START Send Deviation Alert**************************
[2024-01-27 Sat 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` = '2024-01-27'
				) 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` = '2024-01-26'
				) 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
[2024-01-27 Sat 07:00:02] : Total Record Fetch: 12
[2024-01-27 Sat 07:00:02] : <h1 style="color:green">No Mismatch Found!!!</h1>
[2024-01-27 Sat 07:00:03] : Mail sent on 2024-01-27 07:00:02
[2024-01-27 Sat 07:00:03] : Connection closed
[2024-01-27 Sat 07:00:03] : ************************ END ***************************
[2024-01-27 Sat 07:01:53] : *********************** START **************************
[2024-01-27 Sat 07:01:53] : select id, status_code from status_code where status='Active'
[2024-01-27 Sat 07:01:53] : Status Code Result: 2
[2024-01-27 Sat 07:01:53] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2024-01-27 Sat 07:01:53] : App Info Result: 6
[2024-01-27 Sat 07:01:53] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:53] : Batch ID: 2024-01-27 07:01:53#Google Play Store#AppInfoId_1#AppName_Unet
[2024-01-27 Sat 07:01:53] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:53] : Misc Test: 2024-01-27 07:01:53#Google Play Store#AppInfoId_1#AppName_Unet --> APP_VERSION --> 2 --> get-app-info.php
[2024-01-27 Sat 07:01:53] : APP_VERSION
[2024-01-27 Sat 07:01:53] : 3.36
[2024-01-27 Sat 07:01:53] : 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 (1,2,'3.36','2024-01-27 07:01:53#Google Play Store#AppInfoId_1#AppName_Unet','2024-01-27','2024-01-27 07:01:53','2024-01-27 07:01:53','get-app-info.php')
[2024-01-27 Sat 07:01:53] : 1
[2024-01-27 Sat 07:01:53] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:53] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:53] : Misc Test: 2024-01-27 07:01:53#Google Play Store#AppInfoId_1#AppName_Unet --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2024-01-27 Sat 07:01:53] : APP_LAST_UPDATE
[2024-01-27 Sat 07:01:53] : 2024-01-10
[2024-01-27 Sat 07:01:53] : 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 (1,5,'2024-01-10','2024-01-27 07:01:53#Google Play Store#AppInfoId_1#AppName_Unet','2024-01-27','2024-01-27 07:01:53','2024-01-27 07:01:53','get-app-info.php')
[2024-01-27 Sat 07:01:53] : 1
[2024-01-27 Sat 07:01:53] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:53] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:53] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:53] : Batch ID: 2024-01-27 07:01:53#Google Play Store#AppInfoId_2#AppName_UClick
[2024-01-27 Sat 07:01:53] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:53] : Misc Test: 2024-01-27 07:01:53#Google Play Store#AppInfoId_2#AppName_UClick --> APP_VERSION --> 2 --> get-app-info.php
[2024-01-27 Sat 07:01:53] : APP_VERSION
[2024-01-27 Sat 07:01:53] : 1.1.1.2
[2024-01-27 Sat 07:01:53] : 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 (2,2,'1.1.1.2','2024-01-27 07:01:53#Google Play Store#AppInfoId_2#AppName_UClick','2024-01-27','2024-01-27 07:01:53','2024-01-27 07:01:53','get-app-info.php')
[2024-01-27 Sat 07:01:53] : 1
[2024-01-27 Sat 07:01:53] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:53] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:53] : Misc Test: 2024-01-27 07:01:53#Google Play Store#AppInfoId_2#AppName_UClick --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2024-01-27 Sat 07:01:53] : APP_LAST_UPDATE
[2024-01-27 Sat 07:01:54] : 2024-01-03
[2024-01-27 Sat 07:01:54] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (2,5,'2024-01-03','2024-01-27 07:01:53#Google Play Store#AppInfoId_2#AppName_UClick','2024-01-27','2024-01-27 07:01:53','2024-01-27 07:01:53','get-app-info.php')
[2024-01-27 Sat 07:01:54] : 1
[2024-01-27 Sat 07:01:54] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:54] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:54] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:54] : Batch ID: 2024-01-27 07:01:53#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking
[2024-01-27 Sat 07:01:54] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:54] : Misc Test: 2024-01-27 07:01:53#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking --> APP_VERSION --> 2 --> get-app-info.php
[2024-01-27 Sat 07:01:54] : APP_VERSION
[2024-01-27 Sat 07:01:55] : 1.0.21
[2024-01-27 Sat 07:01:55] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (3,2,'1.0.21','2024-01-27 07:01:53#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking','2024-01-27','2024-01-27 07:01:53','2024-01-27 07:01:53','get-app-info.php')
[2024-01-27 Sat 07:01:55] : 1
[2024-01-27 Sat 07:01:55] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:55] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:55] : Misc Test: 2024-01-27 07:01:53#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2024-01-27 Sat 07:01:55] : APP_LAST_UPDATE
[2024-01-27 Sat 07:01:55] : 2023-12-16
[2024-01-27 Sat 07:01:55] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (3,5,'2023-12-16','2024-01-27 07:01:53#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking','2024-01-27','2024-01-27 07:01:53','2024-01-27 07:01:53','get-app-info.php')
[2024-01-27 Sat 07:01:55] : 1
[2024-01-27 Sat 07:01:55] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:55] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:55] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:55] : Batch ID: 2024-01-27 07:01:53#Apple I Store#AppInfoId_4#AppName_UCB Unet
[2024-01-27 Sat 07:01:55] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:55] : Misc Test: 2024-01-27 07:01:53#Apple I Store#AppInfoId_4#AppName_UCB Unet --> APP_VERSION --> 2 --> get-app-info.php
[2024-01-27 Sat 07:01:55] : APP_VERSION
[2024-01-27 Sat 07:01:55] : 2.3.6
[2024-01-27 Sat 07:01:55] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (4,2,'2.3.6','2024-01-27 07:01:53#Apple I Store#AppInfoId_4#AppName_UCB Unet','2024-01-27','2024-01-27 07:01:53','2024-01-27 07:01:53','get-app-info.php')
[2024-01-27 Sat 07:01:55] : 1
[2024-01-27 Sat 07:01:55] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:55] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:55] : Misc Test: 2024-01-27 07:01:53#Apple I Store#AppInfoId_4#AppName_UCB Unet --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2024-01-27 Sat 07:01:55] : APP_LAST_UPDATE
[2024-01-27 Sat 07:01:55] : 2024-01-17
[2024-01-27 Sat 07:01:55] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (4,5,'2024-01-17','2024-01-27 07:01:53#Apple I Store#AppInfoId_4#AppName_UCB Unet','2024-01-27','2024-01-27 07:01:53','2024-01-27 07:01:53','get-app-info.php')
[2024-01-27 Sat 07:01:55] : 1
[2024-01-27 Sat 07:01:55] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:55] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:55] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:55] : Batch ID: 2024-01-27 07:01:53#Apple I Store#AppInfoId_5#AppName_UClick
[2024-01-27 Sat 07:01:55] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:55] : Misc Test: 2024-01-27 07:01:53#Apple I Store#AppInfoId_5#AppName_UClick --> APP_VERSION --> 2 --> get-app-info.php
[2024-01-27 Sat 07:01:55] : APP_VERSION
[2024-01-27 Sat 07:01:56] : 1.1.3
[2024-01-27 Sat 07:01:56] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (5,2,'1.1.3','2024-01-27 07:01:53#Apple I Store#AppInfoId_5#AppName_UClick','2024-01-27','2024-01-27 07:01:53','2024-01-27 07:01:53','get-app-info.php')
[2024-01-27 Sat 07:01:56] : 1
[2024-01-27 Sat 07:01:56] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:56] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:56] : Misc Test: 2024-01-27 07:01:53#Apple I Store#AppInfoId_5#AppName_UClick --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2024-01-27 Sat 07:01:56] : APP_LAST_UPDATE
[2024-01-27 Sat 07:01:56] : 2024-01-03
[2024-01-27 Sat 07:01:56] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (5,5,'2024-01-03','2024-01-27 07:01:53#Apple I Store#AppInfoId_5#AppName_UClick','2024-01-27','2024-01-27 07:01:53','2024-01-27 07:01:53','get-app-info.php')
[2024-01-27 Sat 07:01:56] : 1
[2024-01-27 Sat 07:01:56] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:56] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:56] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:56] : Batch ID: 2024-01-27 07:01:53#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking
[2024-01-27 Sat 07:01:56] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:56] : Misc Test: 2024-01-27 07:01:53#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking --> APP_VERSION --> 2 --> get-app-info.php
[2024-01-27 Sat 07:01:56] : APP_VERSION
[2024-01-27 Sat 07:01:56] : 1.1.1
[2024-01-27 Sat 07:01:56] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (6,2,'1.1.1','2024-01-27 07:01:53#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking','2024-01-27','2024-01-27 07:01:53','2024-01-27 07:01:53','get-app-info.php')
[2024-01-27 Sat 07:01:56] : 1
[2024-01-27 Sat 07:01:56] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:56] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:56] : Misc Test: 2024-01-27 07:01:53#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2024-01-27 Sat 07:01:56] : APP_LAST_UPDATE
[2024-01-27 Sat 07:01:56] : 2023-12-20
[2024-01-27 Sat 07:01:56] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (6,5,'2023-12-20','2024-01-27 07:01:53#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking','2024-01-27','2024-01-27 07:01:53','2024-01-27 07:01:53','get-app-info.php')
[2024-01-27 Sat 07:01:56] : 1
[2024-01-27 Sat 07:01:56] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:56] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2024-01-27 Sat 07:01:56] : Connection closed
[2024-01-27 Sat 07:01:56] : ************************ END ***************************
[2024-01-27 Sat 07:03:02] : *********************** START Data Parsing Error Checker**************************
[2024-01-27 Sat 07:03:02] : 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` = '2024-01-27'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2024-01-27 Sat 07:03:02] : Total Record Fetch: 36
[2024-01-27 Sat 07:03:02] : 2024-01-27 07:01:53 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-17<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 06:25:19 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-17<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 05:00:02 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-17<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 07:01:53 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->2.3.6<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 06:25:19 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->2.3.6<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 05:00:02 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->2.3.6<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 07:01:53 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-03<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 06:25:19 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-03<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 05:00:02 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-03<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 07:01:53 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.3<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 06:25:19 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.3<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 05:00:02 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.3<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 07:01:53 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-12-20<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 06:25:19 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-12-20<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 05:00:02 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-12-20<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 07:01:53 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.1<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 06:25:19 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.1<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 05:00:02 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.1<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 07:01:53 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-03<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 06:25:19 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-03<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 05:00:02 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-03<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 07:01:53 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.1.2<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 06:25:19 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.1.2<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 05:00:02 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.1.2<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 07:01:53 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-10<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 06:25:19 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-10<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 05:00:02 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-10<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 07:01:53 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->3.36<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 06:25:19 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->3.36<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 05:00:02 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->3.36<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 07:01:53 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-12-16<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 06:25:19 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-12-16<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 05:00:02 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-12-16<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 07:01:53 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.21<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 06:25:19 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.21<br />
[2024-01-27 Sat 07:03:02] : 2024-01-27 05:00:02 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.21<br />
[2024-01-27 Sat 07:03:02] : 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
[2024-01-27 Sat 07:03:02] : Connection closed
[2024-01-27 Sat 07:03:02] : ************************ END ***************************
[2024-01-27 Sat 07:03:49] : *********************** START Data Parsing Error Checker**************************
[2024-01-27 Sat 07:04:11] : *********************** START Send Deviation Alert**************************
[2024-01-27 Sat 07:04:11] : 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` = '2024-01-27'
				) 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` = '2024-01-26'
				) 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
[2024-01-27 Sat 07:04:11] : Total Record Fetch: 12
[2024-01-27 Sat 07:04:11] : <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">2024-01-27</span></th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #FFA500">2024-01-26</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">UCB Unet</td><td style="border: 1px solid #000;width: auto">United Commercial 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">2024-01-17</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2024-01-17</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">UCB Unet</td><td style="border: 1px solid #000;width: auto">United Commercial 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">2.3.6</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2.3.6</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">UClick</td><td style="border: 1px solid #000;width: auto">United Commercial 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">2024-01-03</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2024-01-03</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">UClick</td><td style="border: 1px solid #000;width: auto">United Commercial 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">1.1.3</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">1.1.3</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">Apple I Store</td><td style="border: 1px solid #000;width: auto">Unet Enterprise Banking</td><td style="border: 1px solid #000;width: auto">United Commercial 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">2023-12-20</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2023-12-20</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">Apple I Store</td><td style="border: 1px solid #000;width: auto">Unet Enterprise Banking</td><td style="border: 1px solid #000;width: auto">United Commercial 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">1.1.1</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">1.1.1</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">UClick</td><td style="border: 1px solid #000;width: auto">United Commercial 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">2024-01-03</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2024-01-03</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">UClick</td><td style="border: 1px solid #000;width: auto">United Commercial 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">1.1.1.2</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">1.1.1.2</td><td style="border: 1px solid #000;width: auto">Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">9</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">Unet</td><td style="border: 1px solid #000;width: auto">United Commercial 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">2024-01-10</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2024-01-10</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">10</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">Unet</td><td style="border: 1px solid #000;width: auto">United Commercial 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">3.36</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">3.36</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">11</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">Unet Enterprise Banking</td><td style="border: 1px solid #000;width: auto">United Commercial 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">2023-12-16</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">2023-12-16</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">12</td><td style="border: 1px solid #000;width: auto">Google Play Store</td><td style="border: 1px solid #000;width: auto">Unet Enterprise Banking</td><td style="border: 1px solid #000;width: auto">United Commercial 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">1.0.21</td><td style="border: 1px solid #000;width: auto;background-color: #0F0">1.0.21</td><td style="border: 1px solid #000;width: auto">Matched</td></tr></tbody></table>
[2024-01-27 Sat 07:04:12] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server
[2024-01-27 Sat 07:04:12] : Connection closed
[2024-01-27 Sat 07:04:12] : ************************ END ***************************
[2024-01-27 Sat 07:04:33] : *********************** START Send Deviation Alert**************************
[2024-01-27 Sat 07:04:33] : 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` = '2024-01-27'
				) 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` = '2024-01-26'
				) 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
[2024-01-27 Sat 07:04:33] : Total Record Fetch: 12
[2024-01-27 Sat 07:04:33] : <h1 style="color:green">No Mismatch Found!!!</h1>
[2024-01-27 Sat 07:04:33] : Mail sent on 2024-01-27 07:04:33
[2024-01-27 Sat 07:04:33] : Connection closed
[2024-01-27 Sat 07:04:33] : ************************ END ***************************
[2024-01-27 Sat 07:04:54] : *********************** START Data Parsing Error Checker**************************
[2024-01-27 Sat 07:04:54] : 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` = '2024-01-27'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2024-01-27 Sat 07:04:54] : Total Record Fetch: 36
[2024-01-27 Sat 07:04:54] : 2024-01-27 07:01:53 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-17<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 06:25:19 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-17<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 05:00:02 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-17<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 07:01:53 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->2.3.6<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 06:25:19 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->2.3.6<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 05:00:02 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->2.3.6<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 07:01:53 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-03<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 06:25:19 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-03<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 05:00:02 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-03<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 07:01:53 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.3<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 06:25:19 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.3<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 05:00:02 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.3<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 07:01:53 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-12-20<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 06:25:19 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-12-20<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 05:00:02 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-12-20<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 07:01:53 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.1<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 06:25:19 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.1<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 05:00:02 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.1<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 07:01:53 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-03<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 06:25:19 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-03<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 05:00:02 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-03<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 07:01:53 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.1.2<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 06:25:19 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.1.2<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 05:00:02 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.1.2<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 07:01:53 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-10<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 06:25:19 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-10<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 05:00:02 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-01-10<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 07:01:53 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->3.36<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 06:25:19 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->3.36<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 05:00:02 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->3.36<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 07:01:53 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-12-16<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 06:25:19 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-12-16<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 05:00:02 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-12-16<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 07:01:53 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.21<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 06:25:19 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.21<br />
[2024-01-27 Sat 07:04:54] : 2024-01-27 05:00:02 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.21<br />
[2024-01-27 Sat 07:04:54] : 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
[2024-01-27 Sat 07:04:54] : Connection closed
[2024-01-27 Sat 07:04:54] : ************************ END ***************************