权限管理-用户字段获取

简要描述：

• 权限管理-用户底下字段权限信息

接口版本：

请求URL:

• http://{url参数}/bo/api/v3/bo-popedom-field/list/res/user?objectId=insured&objectType=[2,3]&_nodejs=common-data&menuId=munuid

请求方式：

• GET

请求头：

请求参数:

返回示例:

正确时返回:

{
          data: [
            {
              field: col_name",
              menuId: "bt-deve-bt-20200-d26dbebe-369e-4d67",
              objectType: "1",
              objectId: "insured",
              popedom: 1,
              diffTableNo: 0,
            }
          ],
          code: 0,
          success: true,
 }

错误时返回:

{
    "code": 0,
    "message": ""
    "error":{
      errorCode:null，
      errorText:null
    }
    "success": false,
}

返回参数说明:

SQL

    set @menuId='11';
        set @objectType=2;
    set @menuId='3985768390017945600';
set @objectId='ptdev';
select * from ( select menu_id,field,object_id,object_type,popedom,field_value from bo_popedom_field where object_id=@objectId and (object_type=2) and menu_id=@menuId union select menu_id,field,object_id,object_type,popedom,field_value from bo_popedom_field where object_id in (select role_id from bo_user_role where user_id=@objectId) and object_type=1 and menu_id=@menuId union select menu_id,field,object_id,object_type,popedom,field_value from bo_popedom_field where object_id in (select dep_id from bo_user_dep where user_id=@objectId) and object_type=4 and menu_id=@menuId union select menu_id,field,object_id,object_type,popedom,field_value from bo_popedom_field where object_id in (select job_id from bo_user_job where user_id=@objectId) and object_type=5 and menu_id=@menuId) t where field not in (select field from bo_popedom_field where object_id=@objectId and object_type=3)