页面历史记录

...

信息

title	元数据设置

{
"key": "dept_list",
"data": {
"type": "list",
"field": [{
"key": "origin_id",
"align": "right",
"field": ["origin_id"],
"label": "ORIGIN_ID",
"state": null,
"width": 100,
"format": null,
"object": null,
"is_blur": false,
"sequence": 10,
"data_type": "integer",
"fieldFunc": null
}, {
"key": "name",
"align": "left",
"field": ["name"],
"label": "名称",
"state": null,
"width": 250,
"format": null,
"object": null,
"is_blur": true,
"sequence": 20,
"data_type": "string",
"fieldFunc": null
}]
},
"name": "组织",
"class": "list",
"sorts": [{
"key": "orderno",
"type": "asc",
"label": "排序码"
}],
"source": {
"meta": {
"model": "DepartmentHistory",
"relations": [],
"conditions": {
"enabled": 1,
"end_date": {
"gt": "=date_"
},
"org_type": {
"neq": 40
},
"parent_id": "=depart_id",
"begin_date": {
"lte": "=date_"
}
},
"relation_mode": null,
"static_filters": [{
"key": "date_",
"label": "日期"
}, {
"key": "depart_id",
"label": "上级组织"
}]
},
"type": "meta"
},
"page_count": true,
"filter_dict": {
"date_": "=CURR_DATE",
"depart_id": "=CURR_DEPARTMENT"
},
"total_include": false
}

数据源二：基于此表需要的条件做分组。

注意点：一：基于人员做统计分析，主模型是JobInformation 内关联到：Employee，OrgPositionHistory，OrgDepartmentHistory，DepartmentHierarchy

二、系统的人员是在最末级部门，这里需要用的组织层级 DepartmentHierarchy 这个模型

三、因为要关联最高学历，这里的关联类型不要选内关联。

Image Added

{
"key": "emp_count",
"data": {
"dim": [{
"dim": {
"field": "dept_level.l1_id"
},
"key": "dept_",
"align": "left",
"field": ["dept_level_l1_id_5", "name"],
"label": "二级部门",
"state": null,
"width": 160,
"format": null,
"object": "OrgDepartment",
"is_blur": false,
"sequence": 10,
"data_type": "integer",
"fieldFunc": null
}, {
"dim": {
"field": "employee_category_id"
},
"key": "category",
"align": "left",
"field": ["master_employee_category_id_b", "name"],
"label": "用工类型",
"state": null,
"width": 160,
"format": null,
"object": "EmployeeCategory",
"is_blur": false,
"sequence": 20,
"data_type": "integer",
"fieldFunc": null
}, {
"dim": {
"field": "position.position_sequence_id"
},
"key": "position_position_sequence_id",
"align": "left",
"field": ["position_position_sequence", "name"],
"label": "序列",
"state": null,
"width": 160,
"format": null,
"object": "JobStepType",
"is_blur": false,
"sequence": 60,
"data_type": "integer",
"fieldFunc": null
}],
"aggr": [{
"key": "count",
"aggr": {
"ag": "count",
"field": "employee_id"
},
"align": "left",
"field": ["master_employee_id_dvli"],
"label": "员工",
"state": null,
"width": 160,
"format": null,
"object": "Employee",
"is_blur": true,
"sequence": 10,
"data_type": "integer",
"fieldFunc": null
}],
"type": "aggr"
},
"name": "全员用工类型",
"class": "list",
"source": {
"meta": {
"model": "JobInformation",
"relations": [{
"key": "employee",
"name": "人员基础信息",
"model": "Employee",
"filter": {
"employee.id": ":employee_id"
}
}, {
"key": "position",
"name": "岗位信息",
"type": "outer",
"model": "OrgPositionHistory",
"filter": {
"position.end_date": {
"gt": "=date_"
},
"position.origin_id": ":position_id",
"position.begin_date": {
"lte": "=date_"
}
}
}, {
"key": "department",
"name": "部门信息",
"type": "outer",
"model": "OrgDepartmentHistory",
"filter": {
"department.end_date": {
"gt": "=date_"
},
"department.origin_id": ":position.parent_id",
"department.begin_date": {
"lte": "=date_"
}
}
}, {
"key": "dept_level",
"name": "组织层级",
"type": "inner",
"model": "DepartmentHierarchy",
"filter": {
"dept_level.l0_id": "=depart_id",
"dept_level.end_date": {
"gt": "=date_"
},
"dept_level.begin_date": {
"lte": "=date_"
},
"dept_level.department_id": ":department.origin_id"
},
"field_context": {
"date_": "=date_",
"root_id": "=depart_id",
"is_relative_level": true
}
}],
"conditions": {
"on_job": 1,
"end_date": {
"gt": "=date_"
},
"begin_date": {
"lte": "=date_"
},
"position_type": 1
},
"static_filters": [{
"key": "date_",
"label": "日期"
}, {
"key": "depart_id",
"label": "上级组织"
}]
},
"type": "meta"
},
"page_count": false,
"filter_dict": {
"date_": "=CURR_DATE",
"depart_id": "=CURR_DEPARTMENT"
},
"total_include": false
}

信息

title	元数据设置如下

信息

title	元数据设置如下

配置excel公式

此模版用到了两个excel公式、还有很多其他公式我们后面会有详细介绍。

...

页面树

版本比较

旧版本 9

新版本 10

标识

配置excel公式