预算组合维度查询
- url: common/budgets/v2/glBudgetCombination/findByCombinations
- method: POST
- 数据格式：json
- 说明: 预算组合维度查询.
参数
请求参数
| 字段名称 |
字段类型 |
字段描述 |
是否必填 |
长度限制(字节) |
| bizId |
String |
当前请求唯一标识 |
TRUE |
36 |
| timestamp |
long |
当前请求对应的时间戳 |
TRUE |
13 |
| data |
Array |
当前请求的数据集合 |
TRUE |
200 |
| data.budget_code |
String |
预算编码 |
False |
64 |
| data.department_code |
String |
部门编码 |
False |
64 |
| data.project_code |
String |
项目编码 |
False |
64 |
| data.user_code |
String |
员工编码 |
False |
64 |
| data.supplier_code |
String |
供应商编码 |
False |
64 |
| data.column1 |
String |
自定义字段1 |
False |
64 |
| data.column2 |
String |
自定义字段2 |
False |
64 |
| data.column3 |
String |
自定义字段3 |
False |
64 |
| data.column4 |
String |
自定义字段4 |
False |
64 |
| data.column5 |
String |
自定义字段5 |
False |
64 |
返回参数
| 字段名称 |
字段类型 |
字段描述 |
| bizId |
String |
当前次接口同步的唯一标识 |
| resCode |
Integer |
响应状态码（见附录） |
| resMsg |
String |
返回信息描述 |
| data |
Array |
当前请求的数据集合 |
| data.cid |
Long |
预算组合维度ID |
| data.budget_code |
String |
预算编码 |
| data.budget_id |
Long |
预算编码ID |
| data.department_code |
String |
部门编码 |
| data.department_id |
Long |
部门ID |
| data.project_code |
String |
项目编码 |
| data.project_id |
Long |
项目ID |
| data.user_code |
String |
员工编码 |
| data.user_id |
Long |
员工id |
| data.supplier_code |
String |
供应商编码 |
| data.supplier_id |
Long |
供应商ID |
| data.column1 |
String |
自定义字段1 |
| data.column2 |
String |
自定义字段2 |
| data.column3 |
String |
自定义字段3 |
| data.column4 |
String |
自定义字段4 |
| data.column5 |
String |
自定义字段5 |
| data.enabled_flag |
String |
是否启用('N':'未启用', 'Y'/null:'启用') |
示例
请求数据
{
"bizId": "a1ac76ab-58e6-419d-8798-8aefaaab7f88",
"timestamp": 1673857963327,
"data": [
{
"department_code": "D1",
"project_code": "SA015",
"supplier_code": "S001"
},
{
"budget_code": "66000",
"department_code": "D1",
"project_code": "SA015",
"supplier_code": "S001"
},
{
"budget_code": "6000134",
"department_code": "D1",
"project_code": "SA015",
"supplier_code": "S001"
},
{
"department_code": "D427",
"project_code": "SA015",
"supplier_code": "S001"
},
{
"budget_code": "66000",
"department_code": "D427",
"project_code": "SA015",
"supplier_code": "S001"
},
{
"budget_code": "6000134",
"department_code": "D427",
"project_code": "SA015",
"supplier_code": "S001"
},
{
"department_code": "D20543",
"project_code": "SA015",
"supplier_code": "S001"
},
{
"budget_code": "66000",
"department_code": "D20543",
"project_code": "SA015",
"supplier_code": "S001"
},
{
"budget_code": "6000134",
"department_code": "D20543",
"project_code": "SA015",
"supplier_code": "S001"
},
{
"project_code": "SA015",
"employee_number": "jiajia@qq.com",
"supplier_code": "S001"
},
{
"budget_code": "66000",
"project_code": "SA015",
"employee_number": "jiajia@qq.com",
"supplier_code": "S001"
},
{
"budget_code": "6000134",
"project_code": "SA015",
"employee_number": "jiajia@qq.com",
"supplier_code": "S001"
},
{
"department_code": "D1",
"project_code": "SA015",
"employee_number": "jiajia@qq.com",
"supplier_code": "S001"
},
{
"budget_code": "66000",
"department_code": "D1",
"project_code": "SA015",
"employee_number": "jiajia@qq.com",
"supplier_code": "S001"
},
{
"budget_code": "6000134",
"department_code": "D1",
"project_code": "SA015",
"employee_number": "jiajia@qq.com",
"supplier_code": "S001"
},
{
"department_code": "D427",
"project_code": "SA015",
"employee_number": "jiajia@qq.com",
"supplier_code": "S001"
},
{
"budget_code": "66000",
"department_code": "D427",
"project_code": "SA015",
"employee_number": "jiajia@qq.com",
"supplier_code": "S001"
},
{
"budget_code": "6000134",
"department_code": "D427",
"project_code": "SA015",
"employee_number": "jiajia@qq.com",
"supplier_code": "S001"
},
{
"department_code": "D20543",
"project_code": "SA015",
"employee_number": "jiajia@qq.com",
"supplier_code": "S001"
},
{
"budget_code": "66000",
"department_code": "D20543",
"project_code": "SA015",
"employee_number": "jiajia@qq.com",
"supplier_code": "S001"
},
{
"budget_code": "6000134",
"department_code": "D20543",
"project_code": "SA015",
"employee_number": "jiajia@qq.com",
"supplier_code": "S001"
},
{
"budget_code": "66000",
"department_code": "D20543",
"project_code": "900293"
},
{
"project_code": "900293",
"employee_number": "jiajia@qq.com"
},
{
"budget_code": "66000",
"project_code": "900293",
"employee_number": "jiajia@qq.com"
},
{
"budget_code": "6000134",
"project_code": "900293",
"employee_number": "jiajia@qq.com"
},
{
"department_code": "D1",
"project_code": "900293",
"employee_number": "jiajia@qq.com"
},
{
"budget_code": "66000",
"department_code": "D1",
"project_code": "900293",
"employee_number": "jiajia@qq.com"
},
{
"budget_code": "6000134",
"department_code": "D1",
"project_code": "900293",
"employee_number": "jiajia@qq.com"
},
{
"department_code": "D427",
"project_code": "900293",
"employee_number": "jiajia@qq.com"
},
{
"budget_code": "66000",
"department_code": "D427",
"project_code": "900293",
"employee_number": "jiajia@qq.com"
},
{
"department_code": "DYF036",
"employee_number": "yw1@qq.com",
"column1": "lov3",
"column2": "",
"column3": "",
"column4": "",
"column5": ""
},
{
"budget_code": "0011",
"department_code": "C010101",
"employee_number": "CAN000193",
"column1": "",
"column2": "",
"column3": "",
"column4": "",
"column5": "01"
},
{
"budget_code": "6300084",
"department_code": "DYF036",
"employee_number": "yw1@qq.com",
"supplier_code": "AK001",
"column1": "lov1",
"column2": "",
"column3": "207",
"column4": "",
"column5": ""
},
{
"budget_code": "0011",
"department_code": "DYF036",
"employee_number": "yw1@qq.com",
"column1": "lov1",
"column2": "",
"column3": "",
"column4": "",
"column5": ""
},
{
"budget_code": "66000",
"project_code": "900293",
"column5": "01"
}
]
}
返回数据
{
"resCode": 200000,
"resMsg": "success",
"bizId": "a1ac76ab-58e6-419d-8798-8aefaaab7f88",
"data": [
{
"cid": 64618,
"budget_code": "6000134",
"budget_id": 18418,
"department_code": "D1",
"department_id": 14151,
"project_code": "900293",
"project_id": 19009
},
{
"cid": 64622,
"budget_code": "66000",
"budget_id": 18416,
"project_code": "900293",
"project_id": 19009
},
{
"cid": 78804,
"budget_code": "6000134",
"budget_id": 18418,
"project_code": "SA015",
"project_id": 18971,
"supplier_code": "S001",
"supplier_id": 10
},
{
"budget_code": "0011",
"budget_id": 18472,
"department_code": "C010101",
"department_id": 86910,
"column1": "",
"column2": "",
"column3": "",
"column4": "",
"column5": "01"
},
{
"cid": 64620,
"department_code": "D1",
"department_id": 14151,
"project_code": "900293",
"project_id": 19009
},
{
"cid": 78898,
"department_code": "D1",
"department_id": 14151,
"project_code": "SA015",
"project_id": 18971,
"supplier_code": "S001",
"supplier_id": 10
},
{
"cid": 78892,
"department_code": "D20543",
"department_id": 36579,
"project_code": "SA015",
"project_id": 18971,
"supplier_code": "S001",
"supplier_id": 10
},
{
"cid": 78877,
"budget_code": "66000",
"budget_id": 18416,
"department_code": "D20543",
"department_id": 36579,
"project_code": "900293",
"project_id": 19009
},
{
"cid": 78891,
"budget_code": "66000",
"budget_id": 18416,
"department_code": "D20543",
"department_id": 36579,
"project_code": "SA015",
"project_id": 18971,
"supplier_code": "S001",
"supplier_id": 10
},
{
"budget_code": "0011",
"budget_id": 18472,
"department_code": "DYF036",
"department_id": 85926,
"column1": "lov1",
"column2": "",
"column3": "",
"column4": "",
"column5": ""
},
{
"cid": 64621,
"budget_code": "6000134",
"budget_id": 18418,
"project_code": "900293",
"project_id": 19009
},
{
"cid": 78894,
"budget_code": "66000",
"budget_id": 18416,
"department_code": "D427",
"department_id": 14577,
"project_code": "SA015",
"project_id": 18971,
"supplier_code": "S001",
"supplier_id": 10
},
{
"cid": 78890,
"budget_code": "6000134",
"budget_id": 18418,
"department_code": "D20543",
"department_id": 36579,
"project_code": "SA015",
"project_id": 18971,
"supplier_code": "S001",
"supplier_id": 10
},
{
"cid": 78895,
"department_code": "D427",
"department_id": 14577,
"project_code": "SA015",
"project_id": 18971,
"supplier_code": "S001",
"supplier_id": 10
},
{
"cid": 78777,
"department_code": "DYF036",
"department_id": 85926,
"column1": "lov3",
"column2": "",
"column3": "",
"column4": "",
"column5": ""
},
{
"cid": 78896,
"budget_code": "6000134",
"budget_id": 18418,
"department_code": "D1",
"department_id": 14151,
"project_code": "SA015",
"project_id": 18971,
"supplier_code": "S001",
"supplier_id": 10
},
{
"cid": 64619,
"budget_code": "66000",
"budget_id": 18416,
"department_code": "D1",
"department_id": 14151,
"project_code": "900293",
"project_id": 19009
},
{
"cid": 78362,
"budget_code": "66000",
"budget_id": 18416,
"project_code": "900293",
"project_id": 19009,
"column5": "01"
},
{
"cid": 78809,
"project_code": "SA015",
"project_id": 18971,
"supplier_code": "S001",
"supplier_id": 10
},
{
"cid": 78375,
"budget_code": "66000",
"budget_id": 18416,
"department_code": "D427",
"department_id": 14577,
"project_code": "900293",
"project_id": 19009
},
{
"cid": 78893,
"budget_code": "6000134",
"budget_id": 18418,
"department_code": "D427",
"department_id": 14577,
"project_code": "SA015",
"project_id": 18971,
"supplier_code": "S001",
"supplier_id": 10
},
{
"budget_code": "6300084",
"budget_id": 18419,
"department_code": "DYF036",
"department_id": 85926,
"supplier_code": "AK001",
"supplier_id": 59145,
"column1": "lov1",
"column2": "",
"column3": "207",
"column4": "",
"column5": ""
},
{
"cid": 71613,
"department_code": "D427",
"department_id": 14577,
"project_code": "900293",
"project_id": 19009
},
{
"cid": 78897,
"budget_code": "66000",
"budget_id": 18416,
"department_code": "D1",
"department_id": 14151,
"project_code": "SA015",
"project_id": 18971,
"supplier_code": "S001",
"supplier_id": 10
},
{
"cid": 64623,
"project_code": "900293",
"project_id": 19009
},
{
"cid": 78808,
"budget_code": "66000",
"budget_id": 18416,
"project_code": "SA015",
"project_id": 18971,
"supplier_code": "S001",
"supplier_id": 10
}
]
}
附录
在没有cid时,构建组合维度唯一id推荐方法
private String getGlBudgetCombinationUniqueKey(Long budgetId, Long departmentId, Long projectId, Long userId,
Long supplierId, String column1, String column2, String column3,
String column4, String column5) {
return "{" +
"budgetId:" + (Objects.nonNull(budgetId) ? budgetId : 0) + "," +
"departmentId:" + (Objects.nonNull(departmentId) ? departmentId : 0) + "," +
"projectId:" + (Objects.nonNull(projectId) ? projectId : 0) + "," +
"userId:" + (Objects.nonNull(userId) ? userId : 0) + "," +
"supplierId:" + (Objects.nonNull(supplierId) ? supplierId : 0) + "," +
"column1:" + (Objects.nonNull(column1) ? column1 : "") + "," +
"column2:" + (Objects.nonNull(column2) ? column2 : "") + "," +
"column3:" + (Objects.nonNull(column3) ? column3 : "") + "," +
"column4:" + (Objects.nonNull(column4) ? column4 : "") + "," +
"column5:" + (Objects.nonNull(column5) ? column5 : "") +
"}";
}