[2023-08-06 Sun 04:00:02] : *********************** START **************************
[2023-08-06 Sun 04:00:02] : select id, status_code from status_code where status='Active'
[2023-08-06 Sun 04:00:02] : Status Code Result: 2
[2023-08-06 Sun 04:00:02] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2023-08-06 Sun 04:00:02] : App Info Result: 6
[2023-08-06 Sun 04:00:02] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:02] : Batch ID: 2023-08-06 04:00:02#Google Play Store#AppInfoId_1#AppName_Unet
[2023-08-06 Sun 04:00:02] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:02] : Misc Test: 2023-08-06 04:00:02#Google Play Store#AppInfoId_1#AppName_Unet --> APP_VERSION --> 2 --> get-app-info.php
[2023-08-06 Sun 04:00:02] : APP_VERSION
[2023-08-06 Sun 04:00:03] : 
[2023-08-06 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,'','2023-08-06 04:00:02#Google Play Store#AppInfoId_1#AppName_Unet','2023-08-06','2023-08-06 04:00:02','2023-08-05 22:00:02','get-app-info.php')
[2023-08-06 Sun 04:00:03] : 1
[2023-08-06 Sun 04:00:03] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:03] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:03] : Misc Test: 2023-08-06 04:00:02#Google Play Store#AppInfoId_1#AppName_Unet --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2023-08-06 Sun 04:00:03] : APP_LAST_UPDATE
[2023-08-06 Sun 04:00:03] : 2023-07-27
[2023-08-06 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,'2023-07-27','2023-08-06 04:00:02#Google Play Store#AppInfoId_1#AppName_Unet','2023-08-06','2023-08-06 04:00:02','2023-08-05 22:00:02','get-app-info.php')
[2023-08-06 Sun 04:00:03] : 1
[2023-08-06 Sun 04:00:03] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:03] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:03] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:03] : Batch ID: 2023-08-06 04:00:02#Google Play Store#AppInfoId_2#AppName_UClick
[2023-08-06 Sun 04:00:03] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:03] : Misc Test: 2023-08-06 04:00:02#Google Play Store#AppInfoId_2#AppName_UClick --> APP_VERSION --> 2 --> get-app-info.php
[2023-08-06 Sun 04:00:03] : APP_VERSION
[2023-08-06 Sun 04:00:04] : 1.0.0.7
[2023-08-06 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,'1.0.0.7','2023-08-06 04:00:02#Google Play Store#AppInfoId_2#AppName_UClick','2023-08-06','2023-08-06 04:00:02','2023-08-05 22:00:02','get-app-info.php')
[2023-08-06 Sun 04:00:04] : 1
[2023-08-06 Sun 04:00:04] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:04] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:04] : Misc Test: 2023-08-06 04:00:02#Google Play Store#AppInfoId_2#AppName_UClick --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2023-08-06 Sun 04:00:04] : APP_LAST_UPDATE
[2023-08-06 Sun 04:00:04] : 2023-05-04
[2023-08-06 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,'2023-05-04','2023-08-06 04:00:02#Google Play Store#AppInfoId_2#AppName_UClick','2023-08-06','2023-08-06 04:00:02','2023-08-05 22:00:02','get-app-info.php')
[2023-08-06 Sun 04:00:04] : 1
[2023-08-06 Sun 04:00:04] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:04] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:04] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:04] : Batch ID: 2023-08-06 04:00:02#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking
[2023-08-06 Sun 04:00:04] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:04] : Misc Test: 2023-08-06 04:00:02#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking --> APP_VERSION --> 2 --> get-app-info.php
[2023-08-06 Sun 04:00:04] : APP_VERSION
[2023-08-06 Sun 04:00:04] : 1.0.17
[2023-08-06 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.17','2023-08-06 04:00:02#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking','2023-08-06','2023-08-06 04:00:02','2023-08-05 22:00:02','get-app-info.php')
[2023-08-06 Sun 04:00:04] : 1
[2023-08-06 Sun 04:00:04] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:04] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:04] : Misc Test: 2023-08-06 04:00:02#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2023-08-06 Sun 04:00:04] : APP_LAST_UPDATE
[2023-08-06 Sun 04:00:05] : 2023-05-28
[2023-08-06 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 (3,5,'2023-05-28','2023-08-06 04:00:02#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking','2023-08-06','2023-08-06 04:00:02','2023-08-05 22:00:02','get-app-info.php')
[2023-08-06 Sun 04:00:05] : 1
[2023-08-06 Sun 04:00:05] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:05] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:05] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:05] : Batch ID: 2023-08-06 04:00:02#Apple I Store#AppInfoId_4#AppName_UCB Unet
[2023-08-06 Sun 04:00:05] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:05] : Misc Test: 2023-08-06 04:00:02#Apple I Store#AppInfoId_4#AppName_UCB Unet --> APP_VERSION --> 2 --> get-app-info.php
[2023-08-06 Sun 04:00:05] : APP_VERSION
[2023-08-06 Sun 04:00:05] : 
[2023-08-06 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 (4,2,'','2023-08-06 04:00:02#Apple I Store#AppInfoId_4#AppName_UCB Unet','2023-08-06','2023-08-06 04:00:02','2023-08-05 22:00:02','get-app-info.php')
[2023-08-06 Sun 04:00:05] : 1
[2023-08-06 Sun 04:00:05] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:05] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:05] : Misc Test: 2023-08-06 04:00:02#Apple I Store#AppInfoId_4#AppName_UCB Unet --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2023-08-06 Sun 04:00:05] : APP_LAST_UPDATE
[2023-08-06 Sun 04:00:06] : 2023-07-30
[2023-08-06 Sun 04:00:06] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (4,5,'2023-07-30','2023-08-06 04:00:02#Apple I Store#AppInfoId_4#AppName_UCB Unet','2023-08-06','2023-08-06 04:00:02','2023-08-05 22:00:02','get-app-info.php')
[2023-08-06 Sun 04:00:06] : 1
[2023-08-06 Sun 04:00:06] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:06] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:06] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:06] : Batch ID: 2023-08-06 04:00:02#Apple I Store#AppInfoId_5#AppName_UClick
[2023-08-06 Sun 04:00:06] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:06] : Misc Test: 2023-08-06 04:00:02#Apple I Store#AppInfoId_5#AppName_UClick --> APP_VERSION --> 2 --> get-app-info.php
[2023-08-06 Sun 04:00:06] : APP_VERSION
[2023-08-06 Sun 04:00:07] : 1.0.8
[2023-08-06 Sun 04:00:07] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (5,2,'1.0.8','2023-08-06 04:00:02#Apple I Store#AppInfoId_5#AppName_UClick','2023-08-06','2023-08-06 04:00:02','2023-08-05 22:00:02','get-app-info.php')
[2023-08-06 Sun 04:00:07] : 1
[2023-08-06 Sun 04:00:07] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:07] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:07] : Misc Test: 2023-08-06 04:00:02#Apple I Store#AppInfoId_5#AppName_UClick --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2023-08-06 Sun 04:00:07] : APP_LAST_UPDATE
[2023-08-06 Sun 04:00:07] : 2023-05-04
[2023-08-06 Sun 04:00:07] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (5,5,'2023-05-04','2023-08-06 04:00:02#Apple I Store#AppInfoId_5#AppName_UClick','2023-08-06','2023-08-06 04:00:02','2023-08-05 22:00:02','get-app-info.php')
[2023-08-06 Sun 04:00:07] : 1
[2023-08-06 Sun 04:00:07] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:07] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:07] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:07] : Batch ID: 2023-08-06 04:00:02#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking
[2023-08-06 Sun 04:00:07] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:07] : Misc Test: 2023-08-06 04:00:02#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking --> APP_VERSION --> 2 --> get-app-info.php
[2023-08-06 Sun 04:00:07] : APP_VERSION
[2023-08-06 Sun 04:00:08] : 
[2023-08-06 Sun 04:00:08] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (6,2,'','2023-08-06 04:00:02#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking','2023-08-06','2023-08-06 04:00:02','2023-08-05 22:00:02','get-app-info.php')
[2023-08-06 Sun 04:00:08] : 1
[2023-08-06 Sun 04:00:08] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:08] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:08] : Misc Test: 2023-08-06 04:00:02#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2023-08-06 Sun 04:00:08] : APP_LAST_UPDATE
[2023-08-06 Sun 04:00:08] : 2023-05-30
[2023-08-06 Sun 04:00:08] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (6,5,'2023-05-30','2023-08-06 04:00:02#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking','2023-08-06','2023-08-06 04:00:02','2023-08-05 22:00:02','get-app-info.php')
[2023-08-06 Sun 04:00:08] : 1
[2023-08-06 Sun 04:00:08] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:08] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 04:00:08] : Connection closed
[2023-08-06 Sun 04:00:08] : ************************ END ***************************
[2023-08-06 Sun 06:00:02] : *********************** START Send Deviation Alert**************************
[2023-08-06 Sun 06: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` = '2023-08-06'
				) 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` = '2023-08-05'
				) 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
[2023-08-06 Sun 06:00:02] : Total Record Fetch: 12
[2023-08-06 Sun 06:00:02] : <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">2023-08-06</span></th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #FFA500">2023-08-05</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_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #F00"></td><td style="border: 1px solid #000;width: auto;background-color: #F00">2.3.0</td><td style="border: 1px solid #000;width: auto">Not Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">2</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: #F00"></td><td style="border: 1px solid #000;width: auto;background-color: #F00">1.0.8</td><td style="border: 1px solid #000;width: auto">Not Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">3</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: #F00"></td><td style="border: 1px solid #000;width: auto;background-color: #F00">3.30</td><td style="border: 1px solid #000;width: auto">Not Matched</td></tr></tbody></table>
[2023-08-06 Sun 06:00:07] : Mail sent on 2023-08-06 06:00:02
[2023-08-06 Sun 06:00:07] : Connection closed
[2023-08-06 Sun 06:00:07] : ************************ END ***************************
[2023-08-06 Sun 10:34:36] : *********************** START Send Deviation Alert**************************
[2023-08-06 Sun 10:34:36] : 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` = '2023-08-06'
				) 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` = '2023-08-05'
				) 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
[2023-08-06 Sun 10:34:36] : Total Record Fetch: 12
[2023-08-06 Sun 10:34:36] : <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">2023-08-06</span></th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #FFA500">2023-08-05</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_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #F00"></td><td style="border: 1px solid #000;width: auto;background-color: #F00">2.3.0</td><td style="border: 1px solid #000;width: auto">Not Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">2</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: #F00"></td><td style="border: 1px solid #000;width: auto;background-color: #F00">1.0.8</td><td style="border: 1px solid #000;width: auto">Not Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">3</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: #F00"></td><td style="border: 1px solid #000;width: auto;background-color: #F00">3.30</td><td style="border: 1px solid #000;width: auto">Not Matched</td></tr></tbody></table>
[2023-08-06 Sun 10:34:38] : *********************** START Send Deviation Alert**************************
[2023-08-06 Sun 10:34:38] : 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` = '2023-08-06'
				) 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` = '2023-08-05'
				) 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
[2023-08-06 Sun 10:34:38] : Total Record Fetch: 12
[2023-08-06 Sun 10:34:38] : <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">2023-08-06</span></th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #FFA500">2023-08-05</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_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #F00"></td><td style="border: 1px solid #000;width: auto;background-color: #F00">2.3.0</td><td style="border: 1px solid #000;width: auto">Not Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">2</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: #F00"></td><td style="border: 1px solid #000;width: auto;background-color: #F00">1.0.8</td><td style="border: 1px solid #000;width: auto">Not Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">3</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: #F00"></td><td style="border: 1px solid #000;width: auto;background-color: #F00">3.30</td><td style="border: 1px solid #000;width: auto">Not Matched</td></tr></tbody></table>
[2023-08-06 Sun 10:34:40] : Mail sent on 2023-08-06 10:34:36
[2023-08-06 Sun 10:34:40] : Connection closed
[2023-08-06 Sun 10:34:40] : ************************ END ***************************
[2023-08-06 Sun 10:34:40] : Mail sent on 2023-08-06 10:34:38
[2023-08-06 Sun 10:34:40] : Connection closed
[2023-08-06 Sun 10:34:40] : ************************ END ***************************
[2023-08-06 Sun 10:35:11] : *********************** START **************************
[2023-08-06 Sun 10:35:11] : select id, status_code from status_code where status='Active'
[2023-08-06 Sun 10:35:11] : Status Code Result: 2
[2023-08-06 Sun 10:35:11] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2023-08-06 Sun 10:35:11] : App Info Result: 6
[2023-08-06 Sun 10:35:11] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:11] : Batch ID: 2023-08-06 10:35:11#Google Play Store#AppInfoId_1#AppName_Unet
[2023-08-06 Sun 10:35:11] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:11] : Misc Test: 2023-08-06 10:35:11#Google Play Store#AppInfoId_1#AppName_Unet --> APP_VERSION --> 2 --> get-app-info.php
[2023-08-06 Sun 10:35:11] : APP_VERSION
[2023-08-06 Sun 10:35:11] : 3.30
[2023-08-06 Sun 10:35:11] : 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.30','2023-08-06 10:35:11#Google Play Store#AppInfoId_1#AppName_Unet','2023-08-06','2023-08-06 10:35:11','2023-08-06 10:35:11','get-app-info.php')
[2023-08-06 Sun 10:35:11] : 1
[2023-08-06 Sun 10:35:11] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:11] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:11] : Misc Test: 2023-08-06 10:35:11#Google Play Store#AppInfoId_1#AppName_Unet --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2023-08-06 Sun 10:35:11] : APP_LAST_UPDATE
[2023-08-06 Sun 10:35:11] : 2023-07-27
[2023-08-06 Sun 10:35:11] : 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,'2023-07-27','2023-08-06 10:35:11#Google Play Store#AppInfoId_1#AppName_Unet','2023-08-06','2023-08-06 10:35:11','2023-08-06 10:35:11','get-app-info.php')
[2023-08-06 Sun 10:35:11] : 1
[2023-08-06 Sun 10:35:11] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:11] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:11] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:11] : Batch ID: 2023-08-06 10:35:11#Google Play Store#AppInfoId_2#AppName_UClick
[2023-08-06 Sun 10:35:11] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:11] : Misc Test: 2023-08-06 10:35:11#Google Play Store#AppInfoId_2#AppName_UClick --> APP_VERSION --> 2 --> get-app-info.php
[2023-08-06 Sun 10:35:11] : APP_VERSION
[2023-08-06 Sun 10:35:11] : 1.0.0.7
[2023-08-06 Sun 10:35:11] : 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.0.0.7','2023-08-06 10:35:11#Google Play Store#AppInfoId_2#AppName_UClick','2023-08-06','2023-08-06 10:35:11','2023-08-06 10:35:11','get-app-info.php')
[2023-08-06 Sun 10:35:11] : 1
[2023-08-06 Sun 10:35:11] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:11] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:11] : Misc Test: 2023-08-06 10:35:11#Google Play Store#AppInfoId_2#AppName_UClick --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2023-08-06 Sun 10:35:11] : APP_LAST_UPDATE
[2023-08-06 Sun 10:35:12] : 2023-05-04
[2023-08-06 Sun 10:35:12] : 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,'2023-05-04','2023-08-06 10:35:11#Google Play Store#AppInfoId_2#AppName_UClick','2023-08-06','2023-08-06 10:35:11','2023-08-06 10:35:11','get-app-info.php')
[2023-08-06 Sun 10:35:12] : 1
[2023-08-06 Sun 10:35:12] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:12] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:12] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:12] : Batch ID: 2023-08-06 10:35:11#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking
[2023-08-06 Sun 10:35:12] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:12] : Misc Test: 2023-08-06 10:35:11#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking --> APP_VERSION --> 2 --> get-app-info.php
[2023-08-06 Sun 10:35:12] : APP_VERSION
[2023-08-06 Sun 10:35:12] : 1.0.17
[2023-08-06 Sun 10:35:12] : 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.17','2023-08-06 10:35:11#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking','2023-08-06','2023-08-06 10:35:11','2023-08-06 10:35:11','get-app-info.php')
[2023-08-06 Sun 10:35:12] : 1
[2023-08-06 Sun 10:35:12] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:12] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:12] : Misc Test: 2023-08-06 10:35:11#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2023-08-06 Sun 10:35:12] : APP_LAST_UPDATE
[2023-08-06 Sun 10:35:12] : 2023-05-28
[2023-08-06 Sun 10:35:12] : 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-05-28','2023-08-06 10:35:11#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking','2023-08-06','2023-08-06 10:35:11','2023-08-06 10:35:11','get-app-info.php')
[2023-08-06 Sun 10:35:12] : 1
[2023-08-06 Sun 10:35:12] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:12] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:12] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:12] : Batch ID: 2023-08-06 10:35:11#Apple I Store#AppInfoId_4#AppName_UCB Unet
[2023-08-06 Sun 10:35:12] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:12] : Misc Test: 2023-08-06 10:35:11#Apple I Store#AppInfoId_4#AppName_UCB Unet --> APP_VERSION --> 2 --> get-app-info.php
[2023-08-06 Sun 10:35:12] : APP_VERSION
[2023-08-06 Sun 10:35:13] : 2.3.0
[2023-08-06 Sun 10:35:13] : 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.0','2023-08-06 10:35:11#Apple I Store#AppInfoId_4#AppName_UCB Unet','2023-08-06','2023-08-06 10:35:11','2023-08-06 10:35:11','get-app-info.php')
[2023-08-06 Sun 10:35:13] : 1
[2023-08-06 Sun 10:35:13] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:13] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:13] : Misc Test: 2023-08-06 10:35:11#Apple I Store#AppInfoId_4#AppName_UCB Unet --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2023-08-06 Sun 10:35:13] : APP_LAST_UPDATE
[2023-08-06 Sun 10:35:13] : 2023-07-30
[2023-08-06 Sun 10:35:13] : 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,'2023-07-30','2023-08-06 10:35:11#Apple I Store#AppInfoId_4#AppName_UCB Unet','2023-08-06','2023-08-06 10:35:11','2023-08-06 10:35:11','get-app-info.php')
[2023-08-06 Sun 10:35:13] : 1
[2023-08-06 Sun 10:35:13] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:13] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:13] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:13] : Batch ID: 2023-08-06 10:35:11#Apple I Store#AppInfoId_5#AppName_UClick
[2023-08-06 Sun 10:35:13] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:13] : Misc Test: 2023-08-06 10:35:11#Apple I Store#AppInfoId_5#AppName_UClick --> APP_VERSION --> 2 --> get-app-info.php
[2023-08-06 Sun 10:35:13] : APP_VERSION
[2023-08-06 Sun 10:35:14] : 1.0.8
[2023-08-06 Sun 10:35:14] : 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.0.8','2023-08-06 10:35:11#Apple I Store#AppInfoId_5#AppName_UClick','2023-08-06','2023-08-06 10:35:11','2023-08-06 10:35:11','get-app-info.php')
[2023-08-06 Sun 10:35:14] : 1
[2023-08-06 Sun 10:35:14] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:14] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:14] : Misc Test: 2023-08-06 10:35:11#Apple I Store#AppInfoId_5#AppName_UClick --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2023-08-06 Sun 10:35:14] : APP_LAST_UPDATE
[2023-08-06 Sun 10:35:14] : 2023-05-04
[2023-08-06 Sun 10:35:14] : 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,'2023-05-04','2023-08-06 10:35:11#Apple I Store#AppInfoId_5#AppName_UClick','2023-08-06','2023-08-06 10:35:11','2023-08-06 10:35:11','get-app-info.php')
[2023-08-06 Sun 10:35:14] : 1
[2023-08-06 Sun 10:35:14] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:14] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:14] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:14] : Batch ID: 2023-08-06 10:35:11#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking
[2023-08-06 Sun 10:35:14] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:14] : Misc Test: 2023-08-06 10:35:11#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking --> APP_VERSION --> 2 --> get-app-info.php
[2023-08-06 Sun 10:35:14] : APP_VERSION
[2023-08-06 Sun 10:35:15] : 1.0.8
[2023-08-06 Sun 10:35:15] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (6,2,'1.0.8','2023-08-06 10:35:11#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking','2023-08-06','2023-08-06 10:35:11','2023-08-06 10:35:11','get-app-info.php')
[2023-08-06 Sun 10:35:15] : 1
[2023-08-06 Sun 10:35:15] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:15] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:15] : Misc Test: 2023-08-06 10:35:11#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2023-08-06 Sun 10:35:15] : APP_LAST_UPDATE
[2023-08-06 Sun 10:35:16] : 2023-05-30
[2023-08-06 Sun 10:35:16] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (6,5,'2023-05-30','2023-08-06 10:35:11#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking','2023-08-06','2023-08-06 10:35:11','2023-08-06 10:35:11','get-app-info.php')
[2023-08-06 Sun 10:35:16] : 1
[2023-08-06 Sun 10:35:16] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:16] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 10:35:16] : Connection closed
[2023-08-06 Sun 10:35:16] : ************************ END ***************************
[2023-08-06 Sun 10:35:27] : *********************** START Send Deviation Alert**************************
[2023-08-06 Sun 10:35:27] : 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` = '2023-08-06'
				) 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` = '2023-08-05'
				) 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
[2023-08-06 Sun 10:35:27] : Total Record Fetch: 15
[2023-08-06 Sun 10:35:27] : <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">2023-08-06</span></th>
	  <th style="width: 140px">Status Value as on <span style="background-color: #FFA500">2023-08-05</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_VERSION</td><td style="border: 1px solid #000;width: auto;background-color: #F00"></td><td style="border: 1px solid #000;width: auto;background-color: #F00">2.3.0</td><td style="border: 1px solid #000;width: auto">Not Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">2</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: #F00"></td><td style="border: 1px solid #000;width: auto;background-color: #F00">1.0.8</td><td style="border: 1px solid #000;width: auto">Not Matched</td></tr><tr style="text-align: center;vertical-align: middle"><td style="border: 1px solid #000;width: auto">3</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: #F00"></td><td style="border: 1px solid #000;width: auto;background-color: #F00">3.30</td><td style="border: 1px solid #000;width: auto">Not Matched</td></tr></tbody></table>
[2023-08-06 Sun 10:35:28] : Mail sent on 2023-08-06 10:35:27
[2023-08-06 Sun 10:35:28] : Connection closed
[2023-08-06 Sun 10:35:28] : ************************ END ***************************
[2023-08-06 Sun 11:51:22] : *********************** START **************************
[2023-08-06 Sun 11:51:22] : select id, status_code from status_code where status='Active'
[2023-08-06 Sun 11:51:22] : Status Code Result: 2
[2023-08-06 Sun 11:51:22] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2023-08-06 Sun 11:51:22] : App Info Result: 6
[2023-08-06 Sun 11:51:22] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:22] : Batch ID: 2023-08-06 11:51:22#Google Play Store#AppInfoId_1#AppName_Unet
[2023-08-06 Sun 11:51:22] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:22] : Misc Test: 2023-08-06 11:51:22#Google Play Store#AppInfoId_1#AppName_Unet --> APP_VERSION --> 2 --> get-app-info.php
[2023-08-06 Sun 11:51:22] : APP_VERSION
[2023-08-06 Sun 11:51:22] : 3.30
[2023-08-06 Sun 11:51: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 (1,2,'3.30','2023-08-06 11:51:22#Google Play Store#AppInfoId_1#AppName_Unet','2023-08-06','2023-08-06 11:51:22','2023-08-06 11:51:22','get-app-info.php')
[2023-08-06 Sun 11:51:22] : 1
[2023-08-06 Sun 11:51:22] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:22] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:22] : Misc Test: 2023-08-06 11:51:22#Google Play Store#AppInfoId_1#AppName_Unet --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2023-08-06 Sun 11:51:22] : APP_LAST_UPDATE
[2023-08-06 Sun 11:51:23] : 2023-07-27
[2023-08-06 Sun 11:51:23] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (1,5,'2023-07-27','2023-08-06 11:51:22#Google Play Store#AppInfoId_1#AppName_Unet','2023-08-06','2023-08-06 11:51:22','2023-08-06 11:51:22','get-app-info.php')
[2023-08-06 Sun 11:51:23] : 1
[2023-08-06 Sun 11:51:23] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:23] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:23] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:23] : Batch ID: 2023-08-06 11:51:22#Google Play Store#AppInfoId_2#AppName_UClick
[2023-08-06 Sun 11:51:23] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:23] : Misc Test: 2023-08-06 11:51:22#Google Play Store#AppInfoId_2#AppName_UClick --> APP_VERSION --> 2 --> get-app-info.php
[2023-08-06 Sun 11:51:23] : APP_VERSION
[2023-08-06 Sun 11:51:23] : 1.0.0.7
[2023-08-06 Sun 11:51:23] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (2,2,'1.0.0.7','2023-08-06 11:51:22#Google Play Store#AppInfoId_2#AppName_UClick','2023-08-06','2023-08-06 11:51:22','2023-08-06 11:51:22','get-app-info.php')
[2023-08-06 Sun 11:51:23] : 1
[2023-08-06 Sun 11:51:23] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:23] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:23] : Misc Test: 2023-08-06 11:51:22#Google Play Store#AppInfoId_2#AppName_UClick --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2023-08-06 Sun 11:51:23] : APP_LAST_UPDATE
[2023-08-06 Sun 11:51:23] : 2023-05-04
[2023-08-06 Sun 11:51:23] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (2,5,'2023-05-04','2023-08-06 11:51:22#Google Play Store#AppInfoId_2#AppName_UClick','2023-08-06','2023-08-06 11:51:22','2023-08-06 11:51:22','get-app-info.php')
[2023-08-06 Sun 11:51:23] : 1
[2023-08-06 Sun 11:51:23] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:23] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:23] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:23] : Batch ID: 2023-08-06 11:51:22#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking
[2023-08-06 Sun 11:51:23] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:23] : Misc Test: 2023-08-06 11:51:22#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking --> APP_VERSION --> 2 --> get-app-info.php
[2023-08-06 Sun 11:51:23] : APP_VERSION
[2023-08-06 Sun 11:51:23] : 1.0.17
[2023-08-06 Sun 11:51:23] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (3,2,'1.0.17','2023-08-06 11:51:22#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking','2023-08-06','2023-08-06 11:51:22','2023-08-06 11:51:22','get-app-info.php')
[2023-08-06 Sun 11:51:23] : 1
[2023-08-06 Sun 11:51:23] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:23] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:23] : Misc Test: 2023-08-06 11:51:22#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2023-08-06 Sun 11:51:23] : APP_LAST_UPDATE
[2023-08-06 Sun 11:51:24] : 2023-05-28
[2023-08-06 Sun 11:51:24] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (3,5,'2023-05-28','2023-08-06 11:51:22#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking','2023-08-06','2023-08-06 11:51:22','2023-08-06 11:51:22','get-app-info.php')
[2023-08-06 Sun 11:51:24] : 1
[2023-08-06 Sun 11:51:24] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:24] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:24] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:24] : Batch ID: 2023-08-06 11:51:22#Apple I Store#AppInfoId_4#AppName_UCB Unet
[2023-08-06 Sun 11:51:24] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:24] : Misc Test: 2023-08-06 11:51:22#Apple I Store#AppInfoId_4#AppName_UCB Unet --> APP_VERSION --> 2 --> get-app-info.php
[2023-08-06 Sun 11:51:24] : APP_VERSION
[2023-08-06 Sun 11:51:24] : 2.3.0
[2023-08-06 Sun 11:51:24] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (4,2,'2.3.0','2023-08-06 11:51:22#Apple I Store#AppInfoId_4#AppName_UCB Unet','2023-08-06','2023-08-06 11:51:22','2023-08-06 11:51:22','get-app-info.php')
[2023-08-06 Sun 11:51:24] : 1
[2023-08-06 Sun 11:51:24] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:24] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:24] : Misc Test: 2023-08-06 11:51:22#Apple I Store#AppInfoId_4#AppName_UCB Unet --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2023-08-06 Sun 11:51:24] : APP_LAST_UPDATE
[2023-08-06 Sun 11:51:24] : 2023-07-30
[2023-08-06 Sun 11:51:24] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (4,5,'2023-07-30','2023-08-06 11:51:22#Apple I Store#AppInfoId_4#AppName_UCB Unet','2023-08-06','2023-08-06 11:51:22','2023-08-06 11:51:22','get-app-info.php')
[2023-08-06 Sun 11:51:24] : 1
[2023-08-06 Sun 11:51:24] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:24] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:24] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:24] : Batch ID: 2023-08-06 11:51:22#Apple I Store#AppInfoId_5#AppName_UClick
[2023-08-06 Sun 11:51:24] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:24] : Misc Test: 2023-08-06 11:51:22#Apple I Store#AppInfoId_5#AppName_UClick --> APP_VERSION --> 2 --> get-app-info.php
[2023-08-06 Sun 11:51:24] : APP_VERSION
[2023-08-06 Sun 11:51:25] : 1.0.8
[2023-08-06 Sun 11:51:25] : 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.0.8','2023-08-06 11:51:22#Apple I Store#AppInfoId_5#AppName_UClick','2023-08-06','2023-08-06 11:51:22','2023-08-06 11:51:22','get-app-info.php')
[2023-08-06 Sun 11:51:25] : 1
[2023-08-06 Sun 11:51:25] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:25] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:25] : Misc Test: 2023-08-06 11:51:22#Apple I Store#AppInfoId_5#AppName_UClick --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2023-08-06 Sun 11:51:25] : APP_LAST_UPDATE
[2023-08-06 Sun 11:51:26] : 2023-05-04
[2023-08-06 Sun 11:51:26] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (5,5,'2023-05-04','2023-08-06 11:51:22#Apple I Store#AppInfoId_5#AppName_UClick','2023-08-06','2023-08-06 11:51:22','2023-08-06 11:51:22','get-app-info.php')
[2023-08-06 Sun 11:51:26] : 1
[2023-08-06 Sun 11:51:26] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:26] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:26] : <<<<<<<<<<<<<<<<<<<<START App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:26] : Batch ID: 2023-08-06 11:51:22#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking
[2023-08-06 Sun 11:51:26] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:26] : Misc Test: 2023-08-06 11:51:22#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking --> APP_VERSION --> 2 --> get-app-info.php
[2023-08-06 Sun 11:51:26] : APP_VERSION
[2023-08-06 Sun 11:51:27] : 1.0.8
[2023-08-06 Sun 11:51:27] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (6,2,'1.0.8','2023-08-06 11:51:22#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking','2023-08-06','2023-08-06 11:51:22','2023-08-06 11:51:22','get-app-info.php')
[2023-08-06 Sun 11:51:27] : 1
[2023-08-06 Sun 11:51:27] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:27] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:27] : Misc Test: 2023-08-06 11:51:22#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking --> APP_LAST_UPDATE --> 5 --> get-app-info.php
[2023-08-06 Sun 11:51:27] : APP_LAST_UPDATE
[2023-08-06 Sun 11:51:27] : 2023-05-30
[2023-08-06 Sun 11:51:27] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (6,5,'2023-05-30','2023-08-06 11:51:22#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking','2023-08-06','2023-08-06 11:51:22','2023-08-06 11:51:22','get-app-info.php')
[2023-08-06 Sun 11:51:27] : 1
[2023-08-06 Sun 11:51:27] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:27] : <<<<<<<<<<<<<<<<<<<<END App Info Loop>>>>>>>>>>>>>>>>>>>>
[2023-08-06 Sun 11:51:27] : Connection closed
[2023-08-06 Sun 11:51:27] : ************************ END ***************************
[2023-08-06 Sun 11:58:55] : *********************** START Send Deviation Alert**************************
[2023-08-06 Sun 11:58:55] : 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` = '2023-08-06'
				) 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` = '2023-08-05'
				) 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
[2023-08-06 Sun 11:58:55] : Total Record Fetch: 12
[2023-08-06 Sun 11:58:55] : <h1 style="color:green">No Mismatch Found!!!</h1>
[2023-08-06 Sun 11:59:00] : Mail sent on 2023-08-06 11:58:55
[2023-08-06 Sun 11:59:00] : Connection closed
[2023-08-06 Sun 11:59:00] : ************************ END ***************************