[2025-06-15 Sun 04:00:03] : *********************** START **************************
[2025-06-15 Sun 04:00:03] : select id, status_code from status_code where status='Active'
[2025-06-15 Sun 04:00:03] : Status Code Result: 2
[2025-06-15 Sun 04:00:03] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2025-06-15 Sun 04:00:03] : App Info Result: 6
[2025-06-15 Sun 04:00:03] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:03] : Batch ID: 2025-06-15 04:00:03#Google Play Store#AppInfoId_1#AppName_Unet
[2025-06-15 Sun 04:00:03] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:03] : Misc Test: 2025-06-15 04:00:03#Google Play Store#AppInfoId_1#AppName_Unet --> APP_VERSION --> 2 --> get-app-info.php
[2025-06-15 Sun 04:00:03] : APP_VERSION
[2025-06-15 Sun 04:00:03] : 3.57
[2025-06-15 Sun 04: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 (1,2,'3.57','2025-06-15 04:00:03#Google Play Store#AppInfoId_1#AppName_Unet','2025-06-15','2025-06-15 04:00:03','2025-06-14 22:00:03','get-app-info.php')
[2025-06-15 Sun 04:00:03] : 1
[2025-06-15 Sun 04:00:03] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:03] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:03] : Misc Test: 2025-06-15 04:00:03#Google Play Store#AppInfoId_1#AppName_Unet --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2025-06-15 Sun 04:00:03] : APP_LAST_UPDATE
[2025-06-15 Sun 04:00:03] : 2025-06-02
[2025-06-15 Sun 04: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 (1,5,'2025-06-02','2025-06-15 04:00:03#Google Play Store#AppInfoId_1#AppName_Unet','2025-06-15','2025-06-15 04:00:03','2025-06-14 22:00:03','get-app-info.php')
[2025-06-15 Sun 04:00:03] : 1
[2025-06-15 Sun 04:00:03] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:03] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:03] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:03] : Batch ID: 2025-06-15 04:00:03#Google Play Store#AppInfoId_2#AppName_UClick
[2025-06-15 Sun 04:00:03] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:03] : Misc Test: 2025-06-15 04:00:03#Google Play Store#AppInfoId_2#AppName_UClick --> APP_VERSION --> 2 --> get-app-info.php
[2025-06-15 Sun 04:00:03] : APP_VERSION
[2025-06-15 Sun 04:00:04] : 2.0.1
[2025-06-15 Sun 04: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 (2,2,'2.0.1','2025-06-15 04:00:03#Google Play Store#AppInfoId_2#AppName_UClick','2025-06-15','2025-06-15 04:00:03','2025-06-14 22:00:03','get-app-info.php')
[2025-06-15 Sun 04:00:04] : 1
[2025-06-15 Sun 04:00:04] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:04] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:04] : Misc Test: 2025-06-15 04:00:03#Google Play Store#AppInfoId_2#AppName_UClick --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2025-06-15 Sun 04:00:04] : APP_LAST_UPDATE
[2025-06-15 Sun 04:00:04] : 2025-05-21
[2025-06-15 Sun 04: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 (2,5,'2025-05-21','2025-06-15 04:00:03#Google Play Store#AppInfoId_2#AppName_UClick','2025-06-15','2025-06-15 04:00:03','2025-06-14 22:00:03','get-app-info.php')
[2025-06-15 Sun 04:00:04] : 1
[2025-06-15 Sun 04:00:04] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:04] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:04] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:04] : Batch ID: 2025-06-15 04:00:03#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking
[2025-06-15 Sun 04:00:04] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:04] : Misc Test: 2025-06-15 04:00:03#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking --> APP_VERSION --> 2 --> get-app-info.php
[2025-06-15 Sun 04:00:04] : APP_VERSION
[2025-06-15 Sun 04:00:04] : 1.0.25
[2025-06-15 Sun 04: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 (3,2,'1.0.25','2025-06-15 04:00:03#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking','2025-06-15','2025-06-15 04:00:03','2025-06-14 22:00:03','get-app-info.php')
[2025-06-15 Sun 04:00:04] : 1
[2025-06-15 Sun 04:00:04] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:04] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:04] : Misc Test: 2025-06-15 04:00:03#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2025-06-15 Sun 04:00:04] : APP_LAST_UPDATE
[2025-06-15 Sun 04:00:04] : 2025-05-07
[2025-06-15 Sun 04: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 (3,5,'2025-05-07','2025-06-15 04:00:03#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking','2025-06-15','2025-06-15 04:00:03','2025-06-14 22:00:03','get-app-info.php')
[2025-06-15 Sun 04:00:04] : 1
[2025-06-15 Sun 04:00:04] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:04] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:04] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:04] : Batch ID: 2025-06-15 04:00:03#Apple I Store#AppInfoId_4#AppName_UCB Unet
[2025-06-15 Sun 04:00:04] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:04] : Misc Test: 2025-06-15 04:00:03#Apple I Store#AppInfoId_4#AppName_UCB Unet --> APP_VERSION --> 2 --> get-app-info.php
[2025-06-15 Sun 04:00:04] : APP_VERSION
[2025-06-15 Sun 04:00:04] : 2.4.7
[2025-06-15 Sun 04: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,2,'2.4.7','2025-06-15 04:00:03#Apple I Store#AppInfoId_4#AppName_UCB Unet','2025-06-15','2025-06-15 04:00:03','2025-06-14 22:00:03','get-app-info.php')
[2025-06-15 Sun 04:00:04] : 1
[2025-06-15 Sun 04:00:04] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:04] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:04] : Misc Test: 2025-06-15 04:00:03#Apple I Store#AppInfoId_4#AppName_UCB Unet --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2025-06-15 Sun 04:00:04] : APP_LAST_UPDATE
[2025-06-15 Sun 04:00:04] : 2025-06-03
[2025-06-15 Sun 04: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,'2025-06-03','2025-06-15 04:00:03#Apple I Store#AppInfoId_4#AppName_UCB Unet','2025-06-15','2025-06-15 04:00:03','2025-06-14 22:00:03','get-app-info.php')
[2025-06-15 Sun 04:00:04] : 1
[2025-06-15 Sun 04:00:04] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:04] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:04] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:04] : Batch ID: 2025-06-15 04:00:03#Apple I Store#AppInfoId_5#AppName_UClick
[2025-06-15 Sun 04:00:04] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:04] : Misc Test: 2025-06-15 04:00:03#Apple I Store#AppInfoId_5#AppName_UClick --> APP_VERSION --> 2 --> get-app-info.php
[2025-06-15 Sun 04:00:04] : APP_VERSION
[2025-06-15 Sun 04:00:05] : 2.0.0
[2025-06-15 Sun 04: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 (5,2,'2.0.0','2025-06-15 04:00:03#Apple I Store#AppInfoId_5#AppName_UClick','2025-06-15','2025-06-15 04:00:03','2025-06-14 22:00:03','get-app-info.php')
[2025-06-15 Sun 04:00:05] : 1
[2025-06-15 Sun 04:00:05] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:05] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:05] : Misc Test: 2025-06-15 04:00:03#Apple I Store#AppInfoId_5#AppName_UClick --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2025-06-15 Sun 04:00:05] : APP_LAST_UPDATE
[2025-06-15 Sun 04:00:05] : 2025-05-21
[2025-06-15 Sun 04: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 (5,5,'2025-05-21','2025-06-15 04:00:03#Apple I Store#AppInfoId_5#AppName_UClick','2025-06-15','2025-06-15 04:00:03','2025-06-14 22:00:03','get-app-info.php')
[2025-06-15 Sun 04:00:05] : 1
[2025-06-15 Sun 04:00:05] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:05] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:05] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:05] : Batch ID: 2025-06-15 04:00:03#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking
[2025-06-15 Sun 04:00:05] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:05] : Misc Test: 2025-06-15 04:00:03#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking --> APP_VERSION --> 2 --> get-app-info.php
[2025-06-15 Sun 04:00:05] : APP_VERSION
[2025-06-15 Sun 04:00:05] : 1.1.4
[2025-06-15 Sun 04: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.4','2025-06-15 04:00:03#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking','2025-06-15','2025-06-15 04:00:03','2025-06-14 22:00:03','get-app-info.php')
[2025-06-15 Sun 04:00:05] : 1
[2025-06-15 Sun 04:00:05] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:05] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:05] : Misc Test: 2025-06-15 04:00:03#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2025-06-15 Sun 04:00:05] : APP_LAST_UPDATE
[2025-06-15 Sun 04:00:05] : 2024-12-10
[2025-06-15 Sun 04: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,'2024-12-10','2025-06-15 04:00:03#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking','2025-06-15','2025-06-15 04:00:03','2025-06-14 22:00:03','get-app-info.php')
[2025-06-15 Sun 04:00:05] : 1
[2025-06-15 Sun 04:00:05] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:05] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-06-15 Sun 04:00:05] : Connection closed
[2025-06-15 Sun 04:00:05] : ************************ END ***************************
[2025-06-15 Sun 06:00:04] : *********************** START Send Deviation Alert**************************
[2025-06-15 Sun 06:00:04] : SELECT DISTINCT t1.*,t2.*  FROM 
				(
				SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.`executed_date` AS date_bd
				FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
				LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
				WHERE ais.`status`='Active' AND ais.`executed_date` = '2025-06-15'
				) 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` = '2025-06-14'
				) 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
[2025-06-15 Sun 06:00:04] : Total Record Fetch: 12
[2025-06-15 Sun 06:00:04] : <h1 style="color:green">No Mismatch Found!!!</h1>
[2025-06-15 Sun 06:00:04] : Mail sent on 2025-06-15 06:00:04
[2025-06-15 Sun 06:00:04] : Connection closed
[2025-06-15 Sun 06:00:04] : ************************ END ***************************