条件矩阵-生产视图创建语句（兼容E9）

请求参数

Body 参数application/json

matrixName

string

矩阵中文名称

必需

会根据矩阵名称确认E10中的矩阵

matrixColumnMap

string

字段显示名称与字段名称关系

必需

矩阵名称与字段名称关系，用于生成视图中字段名：示例：部门负责人=bmfzr

matrixViewName

string

视图名称

必需

说明需要创建成哪个视图名称

示例

{
    "matrixName": "分部矩阵",
    "matrixViewName": "matrix_table_2",
    "matrixColumnMap": {
        "多人员2":"drl2",
        "多人员3":"drl3",
        "多人员1":"dry1",
        "单人员1":"drl1"
    }
}

示例代码

Shell

JavaScript

Java

Swift

Go

PHP

Python

HTTP

C

C#

Objective-C

Ruby

OCaml

Dart

R

curl --location --request POST '/api/hrm/restful/buildMatrixView' \
--header 'Content-Type: application/json' \
--data-raw '{
    "matrixName": "分部矩阵",
    "matrixViewName": "matrix_table_2",
    "matrixColumnMap": {
        "多人员2":"drl2",
        "多人员3":"drl3",
        "多人员1":"dry1",
        "单人员1":"drl1"
    }
}'

返回响应

🟢200成功

application/json

Body

message

object

接口信息

必需

errcode

string

接口状态

必需

errmsg

string

提示信息

必需

success：成功；其他为错误提示

data

string

创建视图的sql语句

必需

示例

{
    "message": {
        "errcode": "0",
        "errmsg": "success"
    },
    "data": "create view matrix_table_2 as select d.id as id,d.disporder as dataorder,drl2.relate_id as drl2,drl3.relate_id as drl3,dry1.relate_id as dry1,drl1.relate_id as drl1 from eteams.department d  left join (select GROUP_CONCAT(relate_id SEPARATOR ',') as relate_id,matrix_data_id from eteams.hrm_matrix_value_data  where TENANT_KEY ='tx32g1i3bj' and delete_type =0 and matrix_value_config_id=894539497695936514 group by matrix_data_id ) drl2 on d.id=drl2.matrix_data_id   left join (select GROUP_CONCAT(relate_id SEPARATOR ',') as relate_id,matrix_data_id from eteams.hrm_matrix_value_data  where TENANT_KEY ='tx32g1i3bj' and delete_type =0 and matrix_value_config_id=923184979570761730 group by matrix_data_id ) drl3 on d.id=drl3.matrix_data_id   left join (select GROUP_CONCAT(relate_id SEPARATOR ',') as relate_id,matrix_data_id from eteams.hrm_matrix_value_data  where TENANT_KEY ='tx32g1i3bj' and delete_type =0 and matrix_value_config_id=894539497695936513 group by matrix_data_id ) dry1 on d.id=dry1.matrix_data_id   left join (select GROUP_CONCAT(relate_id SEPARATOR ',') as relate_id,matrix_data_id from eteams.hrm_matrix_value_data  where TENANT_KEY ='tx32g1i3bj' and delete_type =0 and matrix_value_config_id=894539497695936512 group by matrix_data_id ) drl1 on d.id=drl1.matrix_data_id  where d.TENANT_KEY = 'tx32g1i3bj' and d.type ='subcompany' and d.IS_DELETE ='0' and d.STATUS ='1' "
}