| | |
|---|
| | | // object.put("function",this.functionArray(uuid)); |
|---|
| | | return object; |
|---|
| | | } |
|---|
| | | sql_text = "SELECT user_id,SUM(countNo) countNo, type \n" + |
|---|
| | | "FROM ( \t\n" + |
|---|
| | | "\tSELECT receiver user_id,COUNT(receiver) countNo,'待办' as type \n" + |
|---|
| | | "\tFROM product_oa_cooperate_flow_node \n" + |
|---|
| | | "\tWHERE status IN (0,1) \n" + |
|---|
| | | "\tGROUP BY receiver \t\n" + |
|---|
| | | ") a \n" + |
|---|
| | | "WHERE user_id=13563 \n" + |
|---|
| | | "GROUP BY user_id,type"; |
|---|
| | | DataTableEntity valueData = baseDao.listTable(sql_text,new Object[]{}); |
|---|
| | | //获取报表配置属性表 加echarts配置属性 |
|---|
| | | //只能查询到关联属性值的属性表，如果父级属性下有多个相同子属性。通过grouping分组。 |
|---|
| | |
|---|
| | | if (fseParentModuleData == null) { |
|---|
| | | throw new BaseException(SystemCode.PUBLISH_REPORT_FAIL_MODULE_NO_EXIST.getValue(), SystemCode.PUBLISH_REPORT_FAIL_MODULE_NO_EXIST.getText()); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | FieldSetEntity fseReport=baseDao.getFieldSetEntity(CmnConst.PRODUCT_SYS_REPORT_CONFIG, fse.getUUID(), false); |
|---|
| | | |
|---|
| | | //创建MVCC保存对象 |
|---|
