CREATE OR REPLACE FUNCTION "analitic"."func_kassa_rest" (date_start date, date_finish date, out branch "main"."domain_branch", out branch_id integer, out curr "main"."domain_curr", out ok double precision, out okv double precision, out kredet double precision, out kredetv double precision, out debet double precision, out debetv double precision) RETURNS SETOF "pg_catalog"."record" AS
$body$
SELECT 
       branch,
       bs.branch_id AS branch_id,
       bs.curr AS curr,
       oborot.sum_ok AS ok,
       oborot.sum_okv AS okv,
       kredit.kredet AS kredet,
       kredit.kredetv AS kredetv,
       debit.debet AS debet,
       debit.debetv AS debetv
FROM
--------------------------------------------------------------------------
  ( SELECT
       b.branch,
       b.branch_id,
       curr AS curr
     FROM main.branches b,
         (SELECT distinct
                 a.acc_curr AS curr
          FROM main.accounts a) c
  ) bs

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

  LEFT OUTER JOIN (
   SELECT
         o.branch_id AS branch_id,
         acc.acc_curr AS curr,
         SUM(o.ok) AS sum_ok,
         SUM(o.okv) AS sum_okv
   FROM
       main.overturn o
         LEFT OUTER JOIN main.accounts acc ON (o.acc_id = acc.acc_id)
   WHERE o.dpd BETWEEN  $ 1  AND $ 2 
   GROUP BY o.branch_id, acc.acc_curr
  ) oborot
  ON (oborot.branch_id = bs.branch_id AND oborot.curr=bs.curr)

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

  LEFT OUTER JOIN (
   SELECT
         j.branch_id as branch_id,
         acr.acc_curr as curr,
         SUM(main.j."sum") AS kredet,
         SUM(main.j."sumv") AS kredetv
   FROM
       main.j
         LEFT OUTER JOIN main.accounts acr ON (acr.acc_id = main.j.cr_acc_id)
         LEFT OUTER JOIN main.accounts acs ON (main.j.cs_acc_id = acs.acc_id)
   WHERE acr.bs in ('1001','1002','1003','1005') AND acs.bs NOT LIKE '100*'
         AND j.dav BETWEEN  $ 1  AND $ 2 
   GROUP BY main.j.branch_id, acr.acc_curr

  ) kredit
  ON (kredit.branch_id = bs.branch_id AND kredit.curr=bs.curr)

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

  LEFT OUTER JOIN (
    SELECT
          j.branch_id as branch_id,
          acr.acc_curr as curr,
          SUM(main.j."sum") AS debet,
          SUM(main.j."sumv") AS debetv
    FROM
        main.j
        LEFT OUTER JOIN main.accounts acs ON (main.j.cs_acc_id = acs.acc_id)
        LEFT OUTER JOIN main.accounts acr ON (acr.acc_id = main.j.cr_acc_id)
    WHERE acs.bs in ('1001','1002','1003','1005') AND acr.bs NOT LIKE '100*'
           AND j.dav BETWEEN  $ 1  AND $ 2 
    GROUP BY main.j.branch_id, acr.acc_curr
  ) debit
  ON (debit.branch_id = bs.branch_id AND debit.curr=bs.curr)
--------------------------------------------------------------------------
WHERE (debit.branch_id is not null OR
       kredit.branch_id is not null OR
       oborot.branch_id is not null)

ORDER BY bs.branch, bs.curr
$body$
LANGUAGE 'sql' STABLE RETURNS NULL ON NULL INPUT SECURITY INVOKER;