cron-task-status

compliance-alerts-email-15days :

Status :

- complianceAlertsEmail15days >  Some application error has occurred. [ Got a call ]
- email not received.
- database column updated.

Query-1 (2 records):

SELECT
    `id`
FROM
    `compliance_alerts`
WHERE
    due_date = '2021-12-24'
    AND `filing_status` IS NULL
    AND `15_day_email_sent` IS NULL
    AND `compliance_alerts`.`deleted_at` IS NULL;

-------------------------------------------------------------------

Query-2 (2 records):

SELECT
    *
FROM
    `compliance_alerts`
WHERE
    due_date = '2021-12-24'
    AND `filing_status` IS NULL
    AND `15_day_email_sent` IS NULL
    AND `compliance_alerts`.`deleted_at` IS NULL;

-------------------------------------------------------------------

Query-3 (2 records):

SELECT
    *
FROM
    `compliance_alerts`
WHERE
    due_date = '2021-12-24'
    AND `filing_status` IS NULL;


-------------------------------------------------------------------

Query-4 (2 records):

SELECT
    *
FROM
    `compliance_alerts`
WHERE
    due_date = '2021-12-24'
    AND `filing_status` IS NULL
    AND `15_day_email_sent` IS NULL;

-------------------------------------------------------------------

Query-5 (4 records):

SELECT
    *
FROM
    `compliance_alerts`
WHERE
    due_date = '2021-12-24'
    AND `15_day_email_sent` IS NULL;

-------------------------------------------------------------------

Query-6 (4 records):

SELECT
    *
FROM
    `compliance_alerts`
WHERE
    due_date = '2021-12-24'
    AND `compliance_alerts`.`deleted_at` IS NULL;



----------------------------------------------------------------------------------------------------------------------

compliance-alerts-email-7days :

Status :
- E-Mail not received.
- Database column updated.


Query-1 (2 records):

SELECT
    `id`
FROM
    `compliance_alerts`
WHERE
    due_date = '2021-12-24'
    AND `filing_status` IS NULL
    AND `7_day_email_sent` IS NULL
    AND `compliance_alerts`.`deleted_at` IS NULL;


-------------------------------------------------------------------

Query-2 (2 records):

SELECT
    *
FROM
    `compliance_alerts`
WHERE
    due_date = '2021-12-24'
    AND `filing_status` IS NULL
    AND `7_day_email_sent` IS NULL
    AND `compliance_alerts`.`deleted_at` IS NULL;

-------------------------------------------------------------------

Query-3 (2 records):

SELECT
    *
FROM
    `compliance_alerts`
WHERE
    due_date = '2021-12-24'
    AND `filing_status` IS NULL;


-------------------------------------------------------------------

Query-4 (2 records):

SELECT
    *
FROM
    `compliance_alerts`
WHERE
    due_date = '2021-12-24'
    AND `filing_status` IS NULL
    AND `7_day_email_sent` IS NULL;

-------------------------------------------------------------------

Query-5 (4 records):

SELECT
    *
FROM
    `compliance_alerts`
WHERE
    due_date = '2021-12-24'
    AND `7_day_email_sent` IS NULL;

-------------------------------------------------------------------

Query-6 (4 records):

SELECT
    *
FROM
    `compliance_alerts`
WHERE
    due_date = '2021-12-24'
    AND `compliance_alerts`.`deleted_at` IS NULL;