---

INSERT INTO report.unv_annual_setting (
    client_id,
    contract_id,
    annual_deduction_flag,
    selected_tax_period,
    source,
    created_at,
    updated_at
)
VALUES (
    CAST(:client_id AS integer),
    CAST(:contract_id AS integer),
    CAST(:annual_deduction_flag AS integer),
    CAST(:tax_period_year AS smallint),
    'LKK',
    CURRENT_TIMESTAMP,
    CURRENT_TIMESTAMP
)
ON CONFLICT (client_id, contract_id)
DO UPDATE SET
    annual_deduction_flag = EXCLUDED.annual_deduction_flag,
    selected_tax_period = EXCLUDED.selected_tax_period,
    source = 'LKK',
    updated_at = CURRENT_TIMESTAMP;



UPDATE report.unv_registry_item ri
SET
    annual_deduction_flag = CAST(:annual_deduction_flag AS integer),
    updated_at = CURRENT_TIMESTAMP
FROM report.smev_register r
WHERE r.id = ri.registry_id
  AND r.smev_register_type_code = 'УНВ'
  AND r.sample_status IS DISTINCT FROM 'Удалён'
  AND r."year" >= CAST(EXTRACT(YEAR FROM CURRENT_DATE) AS integer) - 3
  AND r."year" < CAST(EXTRACT(YEAR FROM CURRENT_DATE) AS integer)
  AND ri.client_id = CAST(:client_id AS integer)
  AND ri.contract_id = CAST(:contract_id AS integer);