c24bea2687
- 系统管理模块（用户/角色/组织/权限/日志） - 教育培训计划管理模块 - 教育培训实施模块 - 考试管理模块 - 调研问卷管理模块 - 外派培训管理模块 - 年度培训总结模块 - 学习资源管理模块 - 任职资格管理模块 - 即时通讯模块 - APP 版本管理 - 统计分析模块（FineReport） - 代码审查标准和报告（CODE_REVIEW_GUIDE.md, CODE_REVIEW_REPORT.md） - 项目开发指南（PROJECT_GUIDE.md）
179 lines
4.3 KiB
XML
179 lines
4.3 KiB
XML
<?xml version="1.0" encoding="UTF-8"?>
|
|
<WorkBook xmlVersion="20151125" releaseVersion="8.0.0">
|
|
<TableDataMap>
|
|
<TableData name="ds1" class="com.fr.data.impl.DBTableData">
|
|
<Parameters>
|
|
<Parameter>
|
|
<Attributes name="id"/>
|
|
<O>
|
|
<![CDATA[d20f47e899b14c0da54370a00d093f3b]]></O>
|
|
</Parameter>
|
|
</Parameters>
|
|
<Attributes maxMemRowCount="-1"/>
|
|
<Connection class="com.fr.data.impl.NameDatabaseConnection">
|
|
<DatabaseName>
|
|
<![CDATA[trainms]]></DatabaseName>
|
|
</Connection>
|
|
<Query>
|
|
<![CDATA[select md5(uuid()) as id,class.class_person as user,class.class_person_id as user_id,b.orgname as department,'未答' as userstate,'0' as user_score
|
|
from et_exam_limitation_class as class
|
|
inner join et_train_baseuser b
|
|
on class.class_person_id = b.usercode
|
|
where class.class_person_id not in (select user_id from et_exam_usertest where exam_id='${id}' group by user_id)
|
|
and class.exam_id = '${id}'
|
|
group by class.class_person_id
|
|
union all
|
|
select md5(uuid()) as id,user,user_id,department,'已答' as userstate,sum(user_score) user_score
|
|
from et_exam_usertest
|
|
where exam_id='${id}'
|
|
group by user_id]]></Query>
|
|
</TableData>
|
|
</TableDataMap>
|
|
<Report class="com.fr.report.worksheet.WorkSheet" name="sheet1">
|
|
<ReportPageAttr>
|
|
<HR/>
|
|
<FR/>
|
|
<HC/>
|
|
<FC/>
|
|
</ReportPageAttr>
|
|
<ColumnPrivilegeControl/>
|
|
<RowPrivilegeControl/>
|
|
<RowHeight defaultValue="723900">
|
|
<![CDATA[3086100,723900,723900,723900,723900,723900,723900,723900,723900,723900,723900]]></RowHeight>
|
|
<ColumnWidth defaultValue="2743200">
|
|
<![CDATA[3848100,3886200,6858000,2743200,2743200,2743200,2743200,2743200,2743200,2743200,2743200]]></ColumnWidth>
|
|
<CellElementList>
|
|
<C c="0" r="0" cs="5" s="0">
|
|
<O>
|
|
<![CDATA[说明： 此表为考试的参与详情]]></O>
|
|
<PrivilegeControl/>
|
|
<Expand/>
|
|
</C>
|
|
<C c="0" r="1" s="1">
|
|
<O>
|
|
<![CDATA[考生]]></O>
|
|
<PrivilegeControl/>
|
|
<Expand/>
|
|
</C>
|
|
<C c="1" r="1" s="1">
|
|
<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="0">
|
|
<O>
|
|
<![CDATA[参与详情]]></O>
|
|
<PrivilegeControl/>
|
|
<Expand/>
|
|
</C>
|
|
<C c="4" r="1" s="0">
|
|
<O>
|
|
<![CDATA[成绩]]></O>
|
|
<PrivilegeControl/>
|
|
<Expand/>
|
|
</C>
|
|
<C c="0" r="2" s="0">
|
|
<O t="DSColumn">
|
|
<Attributes dsName="ds1" columnName="user"/>
|
|
<Complex/>
|
|
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper">
|
|
<Attr divideMode="1"/>
|
|
</RG>
|
|
<Parameters/>
|
|
</O>
|
|
<PrivilegeControl/>
|
|
<Expand dir="0"/>
|
|
</C>
|
|
<C c="1" r="2" s="0">
|
|
<O t="DSColumn">
|
|
<Attributes dsName="ds1" columnName="user_id"/>
|
|
<Complex/>
|
|
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper">
|
|
<Attr divideMode="1"/>
|
|
</RG>
|
|
<Parameters/>
|
|
</O>
|
|
<PrivilegeControl/>
|
|
<Expand dir="0"/>
|
|
</C>
|
|
<C c="2" r="2" s="0">
|
|
<O t="DSColumn">
|
|
<Attributes dsName="ds1" columnName="department"/>
|
|
<Complex/>
|
|
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper">
|
|
<Attr divideMode="1"/>
|
|
</RG>
|
|
<Parameters/>
|
|
</O>
|
|
<PrivilegeControl/>
|
|
<Expand dir="0"/>
|
|
</C>
|
|
<C c="3" r="2" s="0">
|
|
<O t="DSColumn">
|
|
<Attributes dsName="ds1" columnName="userstate"/>
|
|
<Complex/>
|
|
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper">
|
|
<Attr divideMode="1"/>
|
|
</RG>
|
|
<Parameters/>
|
|
</O>
|
|
<PrivilegeControl/>
|
|
<Expand dir="0"/>
|
|
</C>
|
|
<C c="4" r="2" s="1">
|
|
<O t="DSColumn">
|
|
<Attributes dsName="ds1" columnName="user_score"/>
|
|
<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 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 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>
|
|
</StyleList>
|
|
<DesignerVersion DesignerVersion="IAA"/>
|
|
<PreviewType PreviewType="0"/>
|
|
<TemplateID TemplateID="35612885-f1f4-4e4e-89f3-f9129956005d"/>
|
|
</WorkBook>
|