"distance": {
"tableId": 1,
"field": "distance",
"dataType": "varchar",
"title": "距离",
"remark": "计算2点之间距离",
"name": "distance_val",
"alias": "distance",
"isData": false,
"editPropertie": { "showMethod": "text" },
"pagePropertie": {
"showMethod": "text"
},
"maxLength": 36,
"range": [
{
"min": 0,
"max": 1000,
"format": "f0",
"unit": "m"
},
{
"min": 1000,
"format": "f1",
"unit": "km",
"divisor": 1000
}
],
"placeholder": "-"
},
"basis": {
//列表情况默认显示条数，如果自定义通过 参数pageSize控制
//"pageSize": 1,
"bridgeColumn": "address,birthday,city,create_time,email,head_icon,level,id_card,is_guide,is_hide_phone,nike_name,pin_yin,post_code,province,real_name,remark,sex,sort_id,telephone,user_id,view_count,push_name",
//,image_id,bit_val,distance_val,geography_val,geography_val_text,role_val,json_val,money,
"auth": true,
//"show": "user_id,null user_name,{geography_val},null sys_id,null role_id,null dep_id,sex,real_name,telephone,user_status,bit_val,distance_val distance,json_val,is_hide_phone,create_time",
//"original": "'' account,'' role,'' sys,'' merger,'' job,'' dep,role_val,0.0 lng,0.0 lat,view_count",
"original": "null account,user_status,null user_name,null dep_id,null role_id,null role,null dep,null area,null job",
"show": "pin_yin,user_id,null user_name,null sys_id,null role_id,null dep_id,sex,real_name,telephone,id_card,user_status,is_hide_phone,create_time,level,head_icon,'00000000000000000' push_name",
"all": "",
"base64": "",
"field": {
"sort": {
"createTime": {
"column": "create_time",
"dateDiffMinute": 30
}
},
//手机号编码
"enc": {
//"telephone": {
// "columnName": "telephone"
//}
},
//字段格式化显示
"format": {
"createTime": "yyyy-MM-dd"
},
//bit类型转换
"bit": {
"bitVal": "bit_val"
},
//字符正则方式替换展示
"rep": {
//"telephone": [
// {
// "regex": "\\d",
// "key": "",
// "value": "#",
// "sortId": 1
// }
//]
},
//图片补全转换
"doUrl": {
"headIcon": {
"beforeRoot": "beforeRoot:fileWebRoot",
"beforeChar": []
}
},
//多名字情况，按优先基本有数据展示
"doName": {
"pushName": [
{
"name": "push_name",
"path": "real_name",
"sortId": 1
},
{
"key": "user_id", //主键别名 使用于 1对1
"path": "account:nike_name", // : 前面为主表列 ， 后面为1对1里面表列
"value": "-",
"sortId": 2
},
{
"path": "email",
"sortId": 3
},
{
"path": "telephone",
"value": "-",
"sortId": 4
}
]
}
},
"where": "{where_sql}",
"dimField": [ "isHidePhone", "sex" ],
//添加额外扩展
//"where": "{where_sql} and user_id in @fieldWhere",
//"fieldWhere": {
// "filterDemo": {
// "enabled": true,
// "moduleKey": "",
// "responseField": "",
// "sql": "aaaadddd"
// }
//},
//自定义sql方式 sqlPage:[] 优先， 其次： page:"", 最后 动态拼接
//"selectSql": {
// "sqlPage": [
// {
// "sortId": 1,
// "value": "sss"
// },
// {
// "sortId": 0,
// "value": "aaa"
// }
// ],
// "sqlDetail": [
// {
// "sortId": 1,
// "value": "sss"
// },
// {
// "sortId": 0,
// "value": "aaa"
// }
// ],
// "sqlCount": [
// {
// "sortId": 1,
// "value": "sss"
// },
// {
// "sortId": 0,
// "value": "aaa"
// }
// ],
// "sqlList": [
// {
// "sortId": 1,
// "value": "sss"
// },
// {
// "sortId": 0,
// "value": "aaa"
// }
// ]
//},
"fieldChild": {
//1对多 1对1 情况下 继承操作
"account": {
"moduleKey": "bo-user-account",
"responseField": "basis_detail",
"showMethod": "childobject"
},
"role": {
"moduleKey": "bo-user-role",
"responseField": "basis_detail"
}
//,
//"roleVal": {
// "moduleKey": "bo-sys-role",
// "responseField": "user-role"
//}
},
"columns": {
//"geographyVal": {
// "geography": {
// "outPut": "lnglat" //lnglat json geography
// }
//},
"createTime": {
"detailPropertie": {
"showMethodOut": "kv" // n v kv sn
},
"addPropertie": {
},
"editPropertie": {
},
"pagePropertie": {
"showMethodOut": "kv" // n v kv sn
},
"listPropertie": {
}
}
//,
//"distance": {
// "detailPropertie": {
// "showMethodOut": "n" // n v kv sn
// },
// "addPropertie": {
// },
// "editPropertie": {
// },
// "pagePropertie": {
// "showMethodOut": "kv" // n v kv sn
// },
// "listPropertie": {
// }
//}
}
//,
////点击后累加数
//"viewCount": [
// {
// "name": "view_count",
// "alias": "view_count",
// "field": "viewCount"
// }
//]
},
"basis_detail": {
"saveSqlExtand": true,
"bridgeColumn": "level,address,birthday,bit_val,city,create_time,email,head_icon,id_card,image_id,is_guide,is_hide_phone,nike_name,pin_yin,post_code,province,real_name,remark,sex,sort_id,telephone,user_id,view_count",
//distance_val,json_val,level,money,role_val,geography_val,geography_val_text,
"show": "level,user_id,real_name,null account,user_status,head_icon,null user_name,telephone",
"original": "null dep_id,null role_id",
"all": "",
"base64": "",
"auth": true,
"beforeClick": {
//点击数/访问量
"sqlUpdate": "update bo_user set max(isnull(view_count,0))+1 where user_id=@userId"
},
"popedom": [ "t2_user_id", "user_id", "account" ]
},
"manager_detail": {
"auth": true,
"saveSqlExtand": true,
"extend": "basis_detail",
"bridgeColumn": "level,address,birthday,city,email,head_icon,id_card,is_hide_phone,nike_name,post_code,province,real_name,remark,sex,sort_id,telephone,user_id,role,dep,area,job",
"show": "level,address,birthday,city,email,head_icon,id_card,is_hide_phone,nike_name,post_code,province,real_name,remark,sex,sort_id,telephone,user_id",
//distance_val,json_val,level,money,role_val,geography_val,geography_val_text,
"original": "null account,user_status,null user_name,null dep_id,null role_id,null role,null dep,null area,null job,'' merger",
"fieldChild": {
//1对多 1对1 情况下 继承操作
"account": {
"moduleKey": "bo-user-account",
"responseField": "basis_detail",
"showMethod": "childobject",
//控制 bridge里面子表数据显示的位置
"tabId": "3",
"rowId": "3",
"columnBridges": {
"userId": {
"hidden": true
},
"nikeName": {
"fieldSort": 10000,
"tabId": "9",
"rowId": "9"
},
"userName": {
"fieldSort": 10004,
"tabId": "9",
"rowId": "9"
},
"userPwd": {
"fieldSort": 10005,
"tabId": "9",
"rowId": "9"
},
"isMultipleLogin": {
"fieldSort": 10015,
"tabId": "9",
"rowId": "9"
},
"isDeveloper": {
"fieldSort": 10018,
"tabId": "9",
"rowId": "9"
},
"isApp": {
"fieldSort": 10020,
"tabId": "9",
"rowId": "9"
},
"unlockTime": {
"fieldSort": 10023,
"tabId": "9",
"rowId": "9"
},
"errorCount": {
"fieldSort": 10025,
"tabId": "9",
"rowId": "9"
},
"userStatus": {
"fieldSort": 10027,
"tabId": "9",
"rowId": "9",
"fromShowMethod": "childobject"
},
"refusalReason": {
"fieldSort": 10030,
"tabId": "9",
"rowId": "9"
}
}
},
"role": {
"moduleKey": "bo-user-role",
"responseField": "basis_detail",
//多对多， 数据映射， 便于前端控制转换
"showMethod": "child",
"dimBridges": {
"id": "roleId",
"value": "roleId",
"name": "roleName"
}
},
"dep": {
"moduleKey": "bo-user-dep",
"responseField": "basis_detail",
//多对多， 数据映射， 便于前端控制转换
"showMethod": "child",
"dimBridges": {
"id": "depId",
"value": "depId",
"name": "depName"
}
},
"area": {
"moduleKey": "bo-user-area",
"responseField": "basis_detail",
//多对多， 数据映射， 便于前端控制转换
"showMethod": "child",
"dimBridges": {
"id": "areaCode",
"value": "areaCode",
"name": "areaName"
}
},
"job": {
"moduleKey": "bo-user-job",
"responseField": "basis_detail",
//多对多， 数据映射， 便于前端控制转换
"showMethod": "child",
"dimBridges": {
"id": "jobId",
"value": "jobId",
"name": "jobName"
}
},
"merger": {
"moduleKey": "bo-user-merge",
"responseField": "login",
//多对多， 数据映射， 便于前端控制转换
"showMethod": "child",
"dimBridges": {
"id": "userId",
"value": "mergeUserId",
"name": "mergeUserId"
}
}
//,
//"roleVal": {
// "moduleKey": "bo-sys-role",
// "responseField": "user-role"
//}
}
},文档更新时间: 2022-06-04 16:24 作者：admin
