...
此示例主数据模型 SalaryResultData 关联DepartmentHierarchy、统计维度相对二级部门、薪酬方案、岗位。合计项应发合计、去重项为人员id。
对应hcm.model.count参数为：
| 信息code |
|---|
{"model": "SalaryResultData", "filter_dict": { "month": "2020-01" }, "extra_property": { "relations":[ { [ { "model": "DepartmentHierarchy", "filter":{ { "dept_level.department_id": ":depart_id", "dept_level.begin_date":{ { "lte": "2020-01-31" }, }, "dept_level.end_date":{ { "gt": "2020-01-31" }, }, "dept_level.l0_id":13567318 }, 13567318 }, "key": "dept_level" } ] }, } ] }, "group_by": [ "dept_level.l1_id", "program_id", "position_id" ], "sum_by": [ "salary_count" ], "distinct_count_by": [ "employee_id" ] } |
2. 设置模型参数（月份month、月份最后一天date_str、部门dept_id）
...