c24bea2687
- 系统管理模块（用户/角色/组织/权限/日志） - 教育培训计划管理模块 - 教育培训实施模块 - 考试管理模块 - 调研问卷管理模块 - 外派培训管理模块 - 年度培训总结模块 - 学习资源管理模块 - 任职资格管理模块 - 即时通讯模块 - APP 版本管理 - 统计分析模块（FineReport） - 代码审查标准和报告（CODE_REVIEW_GUIDE.md, CODE_REVIEW_REPORT.md） - 项目开发指南（PROJECT_GUIDE.md）
295 lines
6.8 KiB
XML
295 lines
6.8 KiB
XML
<?xml version="1.0" encoding="UTF-8"?>
|
||
<WorkBook xmlVersion="20151125" releaseVersion="8.0.0">
|
||
<TableDataMap>
|
||
<TableData name="result" class="com.fr.data.impl.DBTableData">
|
||
<Parameters>
|
||
<Parameter>
|
||
<Attributes name="id"/>
|
||
<O>
|
||
<![CDATA[3205fca8ad874d009e2690228cb9dcc1]]></O>
|
||
</Parameter>
|
||
</Parameters>
|
||
<Attributes maxMemRowCount="-1"/>
|
||
<Connection class="com.fr.data.impl.NameDatabaseConnection">
|
||
<DatabaseName>
|
||
<![CDATA[trainms]]></DatabaseName>
|
||
</Connection>
|
||
<Query>
|
||
<![CDATA[select user_id,user,name,round(sum(user_score),2) as total_score,user_time,mark_teacher,department
|
||
from
|
||
et_exam_usertest
|
||
where exam_id = '${id}'
|
||
group by user_id]]></Query>
|
||
</TableData>
|
||
<TableData name="ds1" class="com.fr.data.impl.DBTableData">
|
||
<Parameters>
|
||
<Parameter>
|
||
<Attributes name="id"/>
|
||
<O>
|
||
<![CDATA[3205fca8ad874d009e2690228cb9dcc1]]></O>
|
||
</Parameter>
|
||
</Parameters>
|
||
<Attributes maxMemRowCount="-1"/>
|
||
<Connection class="com.fr.data.impl.NameDatabaseConnection">
|
||
<DatabaseName>
|
||
<![CDATA[trainms]]></DatabaseName>
|
||
</Connection>
|
||
<Query>
|
||
<![CDATA[select * from et_exam_exampaper_and_editexampaper
|
||
where id = '${id}']]></Query>
|
||
</TableData>
|
||
</TableDataMap>
|
||
<Report class="com.fr.report.worksheet.WorkSheet" name="基本信息">
|
||
<ReportPageAttr>
|
||
<HR/>
|
||
<FR/>
|
||
<HC/>
|
||
<FC/>
|
||
</ReportPageAttr>
|
||
<ColumnPrivilegeControl/>
|
||
<RowPrivilegeControl/>
|
||
<RowHeight defaultValue="723900">
|
||
<![CDATA[2895600,1485900,1143000,1143000,1257300,1181100,723900,723900,723900,723900,723900]]></RowHeight>
|
||
<ColumnWidth defaultValue="2743200">
|
||
<![CDATA[2743200,4648200,7886700,2743200,2743200,2743200,2743200,2743200,2743200,2743200,2743200]]></ColumnWidth>
|
||
<CellElementList>
|
||
<C c="0" r="0" cs="3" s="0">
|
||
<O>
|
||
<![CDATA[模板导入说明： 1、本模板可以在考试判卷中导入； 2、打“*”号的内容为必填项；]]></O>
|
||
<PrivilegeControl/>
|
||
<Expand/>
|
||
</C>
|
||
<C c="0" r="1" s="0">
|
||
<O>
|
||
<![CDATA[*试卷名称]]></O>
|
||
<PrivilegeControl/>
|
||
<Expand/>
|
||
</C>
|
||
<C c="1" r="1" s="0">
|
||
<O t="DSColumn">
|
||
<Attributes dsName="ds1" columnName="name"/>
|
||
<Complex/>
|
||
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
|
||
<Parameters/>
|
||
</O>
|
||
<PrivilegeControl/>
|
||
<Expand dir="0"/>
|
||
</C>
|
||
<C c="2" r="1" s="0">
|
||
<O>
|
||
<![CDATA[备注：小于50个字符]]></O>
|
||
<PrivilegeControl/>
|
||
<Expand/>
|
||
</C>
|
||
<C c="0" r="2" s="0">
|
||
<O>
|
||
<![CDATA[*试卷描述]]></O>
|
||
<PrivilegeControl/>
|
||
<Expand/>
|
||
</C>
|
||
<C c="1" r="2" s="0">
|
||
<O t="DSColumn">
|
||
<Attributes dsName="ds1" columnName="description"/>
|
||
<Complex/>
|
||
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
|
||
<Parameters/>
|
||
</O>
|
||
<PrivilegeControl/>
|
||
<Expand dir="0"/>
|
||
</C>
|
||
<C c="2" r="2" s="0">
|
||
<O>
|
||
<![CDATA[备注：小于200个字符]]></O>
|
||
<PrivilegeControl/>
|
||
<Expand/>
|
||
</C>
|
||
<C c="0" r="3" s="0">
|
||
<O>
|
||
<![CDATA[*试卷类别]]></O>
|
||
<PrivilegeControl/>
|
||
<Expand/>
|
||
</C>
|
||
<C c="1" r="3" s="0">
|
||
<O t="DSColumn">
|
||
<Attributes dsName="ds1" columnName="category"/>
|
||
<Complex/>
|
||
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
|
||
<Parameters/>
|
||
</O>
|
||
<PrivilegeControl/>
|
||
<Expand dir="0"/>
|
||
</C>
|
||
<C c="2" r="3" s="0">
|
||
<PrivilegeControl/>
|
||
<Expand/>
|
||
</C>
|
||
<C c="0" r="4" rs="2" s="0">
|
||
<O>
|
||
<![CDATA[*开放时间]]></O>
|
||
<PrivilegeControl/>
|
||
<Expand/>
|
||
</C>
|
||
<C c="1" r="4" s="0">
|
||
<O t="DSColumn">
|
||
<Attributes dsName="ds1" columnName="startdate"/>
|
||
<Complex/>
|
||
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
|
||
<Parameters/>
|
||
</O>
|
||
<PrivilegeControl/>
|
||
<Expand dir="0"/>
|
||
</C>
|
||
<C c="2" r="4" s="0">
|
||
<O>
|
||
<![CDATA[备注：填写开始时间，如：2020/1/1]]></O>
|
||
<PrivilegeControl/>
|
||
<Expand/>
|
||
</C>
|
||
<C c="1" r="5" s="0">
|
||
<O t="DSColumn">
|
||
<Attributes dsName="ds1" columnName="enddate"/>
|
||
<Complex/>
|
||
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
|
||
<Parameters/>
|
||
</O>
|
||
<PrivilegeControl/>
|
||
<Expand dir="0"/>
|
||
</C>
|
||
<C c="2" r="5" s="0">
|
||
<O>
|
||
<![CDATA[备注：填写结束时间，如：2020/1/2]]></O>
|
||
<PrivilegeControl/>
|
||
<Expand/>
|
||
</C>
|
||
</CellElementList>
|
||
<ReportAttrSet>
|
||
<ReportSettings headerHeight="0" footerHeight="0">
|
||
<PaperSetting/>
|
||
</ReportSettings>
|
||
</ReportAttrSet>
|
||
<PrivilegeControl/>
|
||
</Report>
|
||
<Report class="com.fr.report.worksheet.WorkSheet" name="成绩">
|
||
<ReportPageAttr>
|
||
<HR/>
|
||
<FR/>
|
||
<HC/>
|
||
<FC/>
|
||
</ReportPageAttr>
|
||
<ColumnPrivilegeControl/>
|
||
<RowPrivilegeControl/>
|
||
<RowHeight defaultValue="723900">
|
||
<![CDATA[2705100,723900,723900,723900,723900,723900,723900,723900,723900,723900,723900]]></RowHeight>
|
||
<ColumnWidth defaultValue="2743200">
|
||
<![CDATA[4305300,3924300,3352800,6324600,2743200,2743200,2743200,2743200,2743200,2743200,2743200]]></ColumnWidth>
|
||
<CellElementList>
|
||
<C c="0" r="0" cs="4" s="0">
|
||
<O>
|
||
<![CDATA[模板导入说明： 1、本模板可以在考试判卷中导入； 2、打“*”号的内容为必填项；]]></O>
|
||
<PrivilegeControl/>
|
||
<Expand/>
|
||
</C>
|
||
<C c="0" r="1" s="0">
|
||
<O>
|
||
<![CDATA[*答题人]]></O>
|
||
<PrivilegeControl/>
|
||
<Expand/>
|
||
</C>
|
||
<C c="1" r="1" s="0">
|
||
<O>
|
||
<![CDATA[*答题人工资号]]></O>
|
||
<PrivilegeControl/>
|
||
<Expand/>
|
||
</C>
|
||
<C c="2" r="1" s="0">
|
||
<O>
|
||
<![CDATA[*总分数]]></O>
|
||
<PrivilegeControl/>
|
||
<Expand/>
|
||
</C>
|
||
<C c="3" r="1" s="1">
|
||
<O>
|
||
<![CDATA[*部门]]></O>
|
||
<PrivilegeControl/>
|
||
<Expand/>
|
||
</C>
|
||
<C c="0" r="2" s="0">
|
||
<O t="DSColumn">
|
||
<Attributes dsName="result" columnName="user"/>
|
||
<Complex/>
|
||
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
|
||
<Parameters/>
|
||
</O>
|
||
<PrivilegeControl/>
|
||
<Expand dir="0"/>
|
||
</C>
|
||
<C c="1" r="2" s="0">
|
||
<O t="DSColumn">
|
||
<Attributes dsName="result" columnName="user_id"/>
|
||
<Complex/>
|
||
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
|
||
<Parameters/>
|
||
</O>
|
||
<PrivilegeControl/>
|
||
<Expand dir="0"/>
|
||
</C>
|
||
<C c="2" r="2" s="0">
|
||
<O t="DSColumn">
|
||
<Attributes dsName="result" columnName="total_score"/>
|
||
<Complex/>
|
||
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
|
||
<Parameters/>
|
||
</O>
|
||
<PrivilegeControl/>
|
||
<Expand dir="0"/>
|
||
</C>
|
||
<C c="3" r="2" s="1">
|
||
<O t="DSColumn">
|
||
<Attributes dsName="result" columnName="department"/>
|
||
<Complex/>
|
||
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
|
||
<Parameters/>
|
||
</O>
|
||
<PrivilegeControl/>
|
||
<Expand dir="0"/>
|
||
</C>
|
||
</CellElementList>
|
||
<ReportAttrSet>
|
||
<ReportSettings headerHeight="0" footerHeight="0">
|
||
<PaperSetting/>
|
||
</ReportSettings>
|
||
</ReportAttrSet>
|
||
<PrivilegeControl/>
|
||
</Report>
|
||
<ReportParameterAttr>
|
||
<Attributes showWindow="true" delayPlaying="true" windowPosition="1" align="0"/>
|
||
<PWTitle>
|
||
<![CDATA[参数]]></PWTitle>
|
||
</ReportParameterAttr>
|
||
<StyleList>
|
||
<Style horizontal_alignment="2" imageLayout="1">
|
||
<FRFont name="SimSun" style="0" size="72"/>
|
||
<Background name="NullBackground"/>
|
||
<Border>
|
||
<Top style="1"/>
|
||
<Bottom style="1"/>
|
||
<Left style="1"/>
|
||
<Right style="1"/>
|
||
</Border>
|
||
</Style>
|
||
<Style imageLayout="1">
|
||
<FRFont name="SimSun" style="0" size="72"/>
|
||
<Background name="NullBackground"/>
|
||
<Border>
|
||
<Top style="1"/>
|
||
<Bottom style="1"/>
|
||
<Left style="1"/>
|
||
<Right style="1"/>
|
||
</Border>
|
||
</Style>
|
||
</StyleList>
|
||
<DesignerVersion DesignerVersion="IAA"/>
|
||
<PreviewType PreviewType="0"/>
|
||
<TemplateID TemplateID="1c109b15-374a-4d87-81b8-adbc75f80aa9"/>
|
||
</WorkBook>
|