Подключение отчета к формированию пакета для загрузки
Конфигурация иморта отчетов
report-import-config.xml
<? xml version = "1.0" encoding = "UTF-8" ?>
< report-import-config >
< csv >
< file-path >reports/descriptions/cp1251/report_template.csv</ file-path >
< file-path >reports/descriptions/cp1251/qr_report.csv</ file-path >
< file-path >reports/descriptions/cp1251/qr_report_keyword.csv</ file-path >
< file-path >reports/descriptions/cp1251/qr_report_supported_type.csv</ file-path >
< file-path >reports/descriptions/cp1251/qr_reportviewdescription.csv</ file-path >
< file-path >reports/descriptions/cp1251/ss_labels_settings.csv</ file-path >
</ csv >
< templates >
< template >
< file-path >reports/{path}/template.xml</ file-path >
< file-path >reports/{path}/{name}.docx</ file-path >
</ template >
</ templates >
</ report-import-config >
|
Описание шаблона
report_template.csv
TYPE_NAME=report_template;KEYS=name;;
name;description;constructor;type
{name};{description};docx;printform
|
Описание отчета
qr_report.csv
TYPE_NAME=QR_Report;KEYS=Name,Template;;;;;;;
Name;Comment;Module;IsSelectionBased;Template;PredefinedParameters;DefaultParamFormula;DialogSchema;IsAvailableInAnalytics;notavailableinrepcoll;isprintimmediately;issendchlog;order
{description};;select m.id from ss_module m inner join ss_moduletype mt on mt.id = m.type where mt.alias = 'QRCentre-AF5' ; true ; "name=" "{name}" "" ;;;; false ; false ; false ; false ; 60
|
Указание ключевого слова
qr_report_keyword.csv
TYPE_NAME=QR_ReportKeyword;KEYS=Report,Keyword
Report;Keyword
"name=" "{description}" "" ;{keyword}
|
Указание модуля
qr_report_supported_type.csv
TYPE_NAME=QR_ReportSupportedType;KEYS=Report,ModuleType
Report;ModuleType
SELECT r.id FROM QR_Report r JOIN report_template rt on rt.id = r.template WHERE rt.name = '{name}' ; "alias=" "{module}" ""
|
Указание дескрипторов
qr_reportviewdescription.csv
TYPE_NAME=QR_ReportViewDescription;KEYS=Report,ViewDescription
Report;ViewDescription
SELECT r.id FROM QR_Report r JOIN report_template rt on rt.id = r.template WHERE rt.name = '{name}' ;{descriptor name}
|