/* VALIDATION <code: ZAB_CASE_MUST_BE_CLOSE ,page: Page{id=10} ,stage: PRE ,fieldId: NULL*/
WITH service AS (
    SELECT
        CAST (
            json_extract_path_text (
                json_array_elements (
                    '[{"id":null,"caseStep":{"id":null},"medicalCase":{"id":null},"referral":{"id":null},"urgent":null,"customer":{"id":"6473050","version":null},"duration":null,"resourceGroup":{"id":null},"contract":{"id":null},"edate":null,"comment":null,"priceList":{"id":null},"beginTime":null,"plannedDate":null,"plannedTime":null,"service":{"multuplicity":null,"fictitious":null,"cul":null,"actualCul":null,"stomat":null,"filling":null,"id":"387346"},"parentService":{"id":null},"rootService":{"id":null},"whollyRendered":null,"servicePrototype":{"id":"5244"},"patientPrescription":{"id":null},"vmpMethod":{"id":null},"vmpType":{"id":null},"anesthesiaType":{"id":null},"paymentStatus":{"id":null},"bdate":"25.08.2016","organization":{"id":"10961"},"toothNumber":null,"amalgamFilling":"false","refused":"false","diagnosis":{"id":null},"anatomicZone":{"id":null},"fundingSourceType":{"id":"1"},"quantity":"1","cul":null,"culSum":"0.00","healthGroup":{"id":null,"name":null},"rendered":"false","cost":null,"totalCost":null,"protocol":"false"}]' ::json ),
                'service',
                'id' ) AS INTEGER ) ),
service1 AS (
    SELECT
        id
    FROM
        sr_service
    WHERE
        code IN (
            '311046',
            '311050',
            '311051',
            '321039',
            '321042',
            '321043',
            '601038',
            '601039',
            '601040',
            '602037',
            '602038',
            '602039' ) ),
service2 AS (
    SELECT
        id
    FROM
        sr_service
    WHERE
        code IN (
            '341001',
            '341002',
            '341003' ) )
SELECT
    CASE
        WHEN '10' ::INTEGER IN (
            2 )
        OR ARRAY (
            SELECT
                *
            FROM
                service )
        && ARRAY (
            SELECT
                *
            FROM
                service1 )
        OR ARRAY (
            SELECT
                *
            FROM
                service )
        && ARRAY (
            SELECT
                *
            FROM
                service2 )
        THEN '94' ::INTEGER IS NOT NULL
        ELSE TRUE
    END,
    CASE
        WHEN '10' ::INTEGER IN (
            2 )
        THEN 'Профилактические приемы в поликлинике! Случай необходимо закрыть!'
        ELSE CASE
            WHEN ARRAY (
                SELECT
                    *
                FROM
                    service )
            && ARRAY (
                SELECT
                    *
                FROM
                    service1 )
            THEN 'Случаи с услугами оказания неотложной помощи! Случай необходимо закрыть!'
            ELSE 'Случаи с услугами вызовов бригад скорой помощи! Случай необходимо закрыть!'
        END
    END;