"manager": {
"showExtand": "{geography},null lng_lat",
"bridgeColumnExtand": "lng_lat,workshop,factory_user",
"originalExtand": "0.0 lng,0.0 lat",
// #region 开启扩展入库配置
"saveSqlExtand": true,
// #endregion 开启扩展入库配置
"guidMethod": "None",
"dataFromType": "Database",
"extend": "basis",
"original": "'' workshop,'' factory_user,is_enabled",
"auth": true,
"viewCountClosed": false,
"fieldChild": {},
"mapperType": {
// true 开启强制外部的
"replaces": false,
// key 对应角色id,如果包含,_mapperType=值,如果外部传递,使用外部的
// value 对应 op-eq值
"mappers": [
{
"key": "111",
"value": "",
"sortId": 1,
//关联对象类型, type 1=角色权限,2=用户增加特殊权限,3=用户减少的特殊权限,4=单位权限 5 职位
"type": null
}
]
},
"wheres": [
"{where_sql} ",
"{s-if:_mapperType}",
// #region 添加不存在用户过滤
"{op-eq:1}",
" and ( ",
"create_user_id<>@_userId ",
"and fact_id not in (select factory_id from cpc_ws_factory_user where user_id=@_userId)",
") ",
"{op-eq:1}",
// #endregion 添加不存在用户过滤
"{e-if:_mapperType}",
"{s-if:_mapperType}",
// #region 获取我的下达权限工厂 13 派单员,9 工厂 启用 审核通过
"{op-eq:2}",
//注意 and 前面必须有空格,否则where条件可能被过滤
" and fact_id in (select factory_id from cpc_ws_factory_user where user_id=@_userId and is_enabled=1 and audit_status=1 and user_type in (13,9))",
"{op-eq:2}",
"{e-if:_mapperType}"
// #endregion 获取我的下达权限工厂
]
},
文档更新时间: 2022-07-05 16:14 作者:admin