# -*- coding: utf8 -*-
import libs
SQL = (
    ("lich_sostav","select F.KOD FOND_ID,O.KOD OPIS_ID, FKOD,A1, OKOD,A7,A9,sum(G7) G7, sum(G46) G46,min(G3) G3,max(G5) G5,G45 FROM `af3_opis` O LEFT JOIN `af3_fond`  F on(F.KOD=O.FOND) where G1=4 group by O.KOD order by FKOD, OKOD;"),
    ("list_rename","select F3.FOND,C1,year(C3)C3,year(C5)C5 FROM `af3_opis` O LEFT JOIN af3_fond3 F3 on(F3.FOND=O.FOND) where G1=4 order by F3.FOND, C3;"),
)
FOUND_ROWS = False
ROOT = "spravochnik"
ROOT_PREFIX = None
ROOT_POSTFIX = None
XSL_TEMPLATE = "data/spravochnik.xsl"
EVENT = {"G45":libs.make_cdata,"A1":libs.make_cdata,}
WHERE = ("dateupdate",)
PARAM = None
MESSAGE = "Страница отчётов не доступна"
TITLE="Страница списка отчётов"
ORDER = None
