Длина распечатанных чеков : УКМ-4

--- Кол-во расходных материалов (кассовая и весовая лента) за последнюю неделю
SET echo off newpage 0 space 0 pagesize 0 feed off head off trimspool on linesize 500
SPOOL rashod.csv
SELECT SUM (mx) || ';' || SUM (ch) || ';' || SUM (ar) || ';' || SUM (vs)
  FROM (SELECT   mx, COUNT (chek) ch, SUM (art) ar, NULL vs
            FROM (SELECT   a.locid mx, a.desknum, a.znum, a.checknum chek,
                           COUNT (b.article) art
                      FROM supermag.smcashchecks a,
                           supermag.smcashcheckitems b
                     WHERE a.locid = b.locid
                       AND a.desknum = b.desknum
                       AND a.znum = b.znum
                       AND a.checknum = b.checknum
                       AND a.printtime BETWEEN SYSDATE - 8 AND SYSDATE - 1
                  GROUP BY a.locid, a.desknum, a.znum, a.checknum)
        GROUP BY mx
        UNION
        SELECT NULL mx, NULL ch, NULL ar, SUM (c.idmeasurement) vs
          FROM supermag.smcashchecks a,
               supermag.smcashcheckitems b,
               supermag.smcard c
         WHERE a.locid = b.locid
           AND a.desknum = b.desknum
           AND a.znum = b.znum
           AND a.checknum = b.checknum
           AND a.printtime BETWEEN SYSDATE - 8 AND SYSDATE - 1
           AND b.article = c.article);
SPOOL off
exit