mapper_{mkey}_sql.json
平台核心的字段，建表时候按下面字段，通过代码生成工具字段生成配置信息
audit_opinion,audit_status,audit_time,audit_user_id,
create_time,create_user_id,modify_time,modify_user_id,
id_card,telephone,
img_url,tags,sys_id完整的模板实例
{
"diffTableNo": 0,
"isRESTful": true,
"base": {
"connName": "ConnBt",
"isRearEnd": true,
"isFrontEnd": true
},
"responseField": {
"basis": {
"guidMethod": 0,
"dataFromType": 0,
"show": "audit_opinion,audit_status,audit_time,audit_user_id,create_time,create_user_id,from_name,id_card,img_url,ins_res_id,ins_res_name,ins_res_tag,link_audio,link_video,modify_time,modify_user_id,open_id,real_name,related_user_id,remark,res_type,show_num,sort_id,star_rating,tags,telephone",
"bridgeColumn": "audit_opinion,audit_status,audit_time,audit_user_id,create_time,create_user_id,from_name,id_card,img_url,ins_res_id,ins_res_name,ins_res_tag,link_audio,link_video,modify_time,modify_user_id,open_id,real_name,related_user_id,remark,res_type,show_num,sort_id,star_rating,tags,telephone",
"original": "",
"auth": true
},
"basis_detail": {
"guidMethod": 0,
"dataFromType": 0,
"show": "audit_opinion,audit_status,from_name,id_card,img_url,ins_res_id,ins_res_name,ins_res_tag,link_audio,link_video,open_id,real_name,related_user_id,remark,res_type,show_num,sort_id,star_rating,tags,telephone",
"bridgeColumn": "audit_opinion,audit_status,from_name,id_card,img_url,ins_res_id,ins_res_name,ins_res_tag,link_audio,link_video,open_id,real_name,related_user_id,remark,res_type,show_num,sort_id,star_rating,tags,telephone",
"original": "",
"auth": true,
"viewCount": [
{
"field": "showNum",
"name": "show_num",
"alias": "show_num"
}
]
},
"common": {
"guidMethod": 0,
"dataFromType": 0,
"columns": {
"auditOpinion": {
"fieldSort": 100,
"guidMethod": 0,
"field": "auditOpinion",
"alias": "audit_opinion"
},
"auditStatus": {
"fieldSort": 105,
"guidMethod": 0,
"field": "auditStatus",
"alias": "audit_status"
},
"auditTime": {
"fieldSort": 510,
"guidMethod": 0,
"field": "auditTime",
"alias": "audit_time"
},
"auditUserId": {
"fieldSort": 505,
"guidMethod": 0,
"field": "auditUserId",
"alias": "audit_user_id"
},
"createTime": {
"fieldSort": 555,
"guidMethod": 0,
"field": "createTime",
"alias": "create_time"
},
"createUserId": {
"fieldSort": 550,
"guidMethod": 0,
"field": "createUserId",
"alias": "create_user_id"
},
"fromName": {
"fieldSort": 130,
"guidMethod": 0,
"field": "fromName",
"alias": "from_name"
},
"idCard": {
"fieldSort": 135,
"guidMethod": 0,
"field": "idCard",
"alias": "id_card"
},
"imgUrl": {
"fieldSort": 490,
"guidMethod": 0,
"field": "imgUrl",
"alias": "img_url"
},
"insResId": {
"fieldSort": 145,
"guidMethod": 0,
"field": "insResId",
"alias": "ins_res_id"
},
"insResName": {
"fieldSort": 150,
"guidMethod": 0,
"field": "insResName",
"alias": "ins_res_name"
},
"insResTag": {
"fieldSort": 155,
"guidMethod": 0,
"field": "insResTag",
"alias": "ins_res_tag"
},
"linkAudio": {
"fieldSort": 160,
"guidMethod": 0,
"field": "linkAudio",
"alias": "link_audio"
},
"linkVideo": {
"fieldSort": 165,
"guidMethod": 0,
"field": "linkVideo",
"alias": "link_video"
},
"modifyTime": {
"fieldSort": 530,
"guidMethod": 0,
"field": "modifyTime",
"alias": "modify_time"
},
"modifyUserId": {
"fieldSort": 525,
"guidMethod": 0,
"field": "modifyUserId",
"alias": "modify_user_id"
},
"openId": {
"fieldSort": 180,
"guidMethod": 0,
"field": "openId",
"alias": "open_id"
},
"realName": {
"fieldSort": 185,
"guidMethod": 0,
"field": "realName",
"alias": "real_name"
},
"relatedUserId": {
"fieldSort": 190,
"guidMethod": 0,
"field": "relatedUserId",
"alias": "related_user_id"
},
"remark": {
"fieldSort": 500,
"guidMethod": 0,
"field": "remark",
"alias": "remark"
},
"resType": {
"fieldSort": 200,
"guidMethod": 0,
"field": "resType",
"alias": "res_type"
},
"showNum": {
"fieldSort": 205,
"guidMethod": 0,
"field": "showNum",
"alias": "show_num"
},
"sortId": {
"fieldSort": 210,
"guidMethod": 0,
"field": "sortId",
"alias": "sort_id"
},
"starRating": {
"fieldSort": 215,
"guidMethod": 0,
"field": "starRating",
"alias": "star_rating"
},
"sysId": {
"fieldSort": 220,
"guidMethod": 0,
"field": "sysId",
"alias": "sys_id"
},
"tags": {
"fieldSort": 225,
"guidMethod": 0,
"field": "tags",
"alias": "tags"
},
"telephone": {
"fieldSort": 230,
"guidMethod": 0,
"field": "telephone",
"alias": "telephone"
}
}
},
"global": {
"guidMethod": 0,
"dataFromType": 0,
"show": "",
"auth": true
},
"manager": {
"guidMethod": 0,
"dataFromType": 0,
"extend": "basis",
"bridgeColumn": "audit_opinion,audit_status,audit_time,audit_user_id,create_time,create_user_id,from_name,id_card,img_url,ins_res_id,ins_res_name,ins_res_tag,link_audio,link_video,modify_time,modify_user_id,open_id,real_name,related_user_id,remark,res_type,show_num,sort_id,star_rating,tags,telephone",
"auth": true
},
"manager-export": {
"guidMethod": 0,
"dataFromType": 0,
"extend": "manager",
"bridgeColumn": "audit_opinion,audit_status,audit_time,audit_user_id,create_time,create_user_id,from_name,id_card,img_url,ins_res_id,ins_res_name,ins_res_tag,link_audio,link_video,modify_time,modify_user_id,open_id,real_name,related_user_id,remark,res_type,show_num,sort_id,star_rating,tags,telephone",
"columns": {
"auditStatus": {
"fieldSort": 9999,
"guidMethod": 0,
"pagePropertie": {
"showMethod": 2,
"showMethodOut": 4,
"isOriginal": false
}
},
"auditTime": {
"fieldSort": 9999,
"guidMethod": 0,
"pagePropertie": {
"showMethod": 2,
"showMethodOut": 4,
"isOriginal": false
}
},
"auditUserId": {
"fieldSort": 9999,
"guidMethod": 0,
"pagePropertie": {
"showMethod": 2,
"showMethodOut": 4,
"isOriginal": false
}
},
"createTime": {
"fieldSort": 9999,
"guidMethod": 0,
"pagePropertie": {
"showMethod": 2,
"showMethodOut": 4,
"isOriginal": false
}
},
"createUserId": {
"fieldSort": 9999,
"guidMethod": 0,
"pagePropertie": {
"showMethod": 2,
"showMethodOut": 4,
"isOriginal": false
}
},
"modifyTime": {
"fieldSort": 9999,
"guidMethod": 0,
"pagePropertie": {
"showMethod": 2,
"showMethodOut": 4,
"isOriginal": false
}
},
"modifyUserId": {
"fieldSort": 9999,
"guidMethod": 0,
"pagePropertie": {
"showMethod": 2,
"showMethodOut": 4,
"isOriginal": false
}
},
"sysId": {
"fieldSort": 9999,
"guidMethod": 0,
"pagePropertie": {
"showMethod": 2,
"showMethodOut": 4,
"isOriginal": false
}
}
}
},
"manager-export_detail": {
"guidMethod": 0,
"dataFromType": 0,
"extend": "manager_detail",
"bridgeColumn": "audit_opinion,audit_status,audit_time,audit_user_id,create_time,create_user_id,from_name,id_card,img_url,ins_res_id,ins_res_name,ins_res_tag,link_audio,link_video,modify_time,modify_user_id,open_id,real_name,related_user_id,remark,res_type,show_num,sort_id,star_rating,tags,telephone",
"columns": {
"auditStatus": {
"fieldSort": 9999,
"guidMethod": 0,
"pagePropertie": {
"showMethod": 2,
"showMethodOut": 4,
"isOriginal": false
}
},
"auditTime": {
"fieldSort": 9999,
"guidMethod": 0,
"pagePropertie": {
"showMethod": 2,
"showMethodOut": 4,
"isOriginal": false
}
},
"auditUserId": {
"fieldSort": 9999,
"guidMethod": 0,
"pagePropertie": {
"showMethod": 2,
"showMethodOut": 4,
"isOriginal": false
}
},
"createTime": {
"fieldSort": 9999,
"guidMethod": 0,
"pagePropertie": {
"showMethod": 2,
"showMethodOut": 4,
"isOriginal": false
}
},
"createUserId": {
"fieldSort": 9999,
"guidMethod": 0,
"pagePropertie": {
"showMethod": 2,
"showMethodOut": 4,
"isOriginal": false
}
},
"modifyTime": {
"fieldSort": 9999,
"guidMethod": 0,
"pagePropertie": {
"showMethod": 2,
"showMethodOut": 4,
"isOriginal": false
}
},
"modifyUserId": {
"fieldSort": 9999,
"guidMethod": 0,
"pagePropertie": {
"showMethod": 2,
"showMethodOut": 4,
"isOriginal": false
}
},
"sysId": {
"fieldSort": 9999,
"guidMethod": 0,
"pagePropertie": {
"showMethod": 2,
"showMethodOut": 4,
"isOriginal": false
}
}
}
},
"manager_detail": {
"guidMethod": 0,
"dataFromType": 0,
"extend": "basis_detail",
"bridgeColumn": "audit_opinion,audit_status,from_name,id_card,img_url,ins_res_id,ins_res_name,ins_res_tag,link_audio,link_video,open_id,real_name,related_user_id,remark,res_type,show_num,sort_id,star_rating,tags,telephone",
"auth": true
}
},
"tables": [
{
"id": 1,
"name": "bt_insurance_resource",
"isPrimary": true,
"primaryColumn": [
{
"colName": "ins_res_id",
"alias": "ins_res_id",
"field": "insResId"
}
],
"type": 0
}
],
"selectSql": {
"auth": false,
"primaryWhere": "ins_res_id =@insResId",
"tableName": "bt_insurance_resource",
"order": "ins_res_id",
"listField": "*",
"pageField": "*",
"detailField": "*"
},
"saveSqlPrimary": {
"isBat": false,
"isSaveReturnObj": false,
"tableName": "bt_insurance_resource",
"primaryColumn": [
{
"isIdentity": false,
"tableId": 1,
"colName": "ins_res_id",
"field": "insResId"
}
]
},
"deleteSql": {
"delete": [
{
"sqlDelete": "delete from bt_insurance_resource where ins_res_id = @insResId",
"tableName": "bt_insurance_resource",
"primaryColumn": [
{
"isIdentity": false,
"tableId": 1,
"colName": "ins_res_id",
"field": "insResId"
}
]
}
]
},
"columns": {
"auditOpinion": {
"fieldSort": 9999,
"extendAlias": "input_basis",
"tableId": 1,
"dataType": "varchar",
"title": "审核意见",
"guidMethod": 0,
"isRequired": false,
"isData": true,
"filter": {
"isMust": false
},
"field": "auditOpinion",
"name": "audit_opinion",
"alias": "audit_opinion",
"isDate": false,
"isPrimary": false,
"isIdentity": false,
"maxLength": 36
},
"auditStatus": {
"isExportN": true,
"fieldSort": 9999,
"extendAlias": "bs_status",
"tableId": 1,
"dataType": "int",
"title": "审核状态",
"remark": "0 = 已禁用，1 = 审核通过 2 = 待审核 3 = 已驳回 -1 草稿箱 ",
"guidMethod": 0,
"isRequired": false,
"isSearch": true,
"isData": true,
"filter": {
"isMust": false
},
"editPropertie": {
"showMethod": 2,
"showMethodOut": 2,
"defaultValue": "2",
"isOriginal": false
},
"field": "auditStatus",
"name": "audit_status",
"alias": "audit_status",
"isDate": false,
"isPrimary": false,
"isIdentity": false,
"maxLength": 10,
"colDecimal": 0
},
"auditTime": {
"isExportN": true,
"fieldSort": 9999,
"extendAlias": "audit_time",
"tableId": 1,
"dataType": "datetime",
"title": "审核时间",
"remark": "审核时间:来至系统",
"guidMethod": 0,
"isRequired": false,
"isData": true,
"filter": {
"isMust": false
},
"field": "auditTime",
"name": "audit_time",
"alias": "audit_time",
"isDate": true,
"isPrimary": false,
"isIdentity": false
},
"auditUserId": {
"isExportN": true,
"fieldSort": 9999,
"extendAlias": "audit_user",
"tableId": 1,
"dataType": "varchar",
"title": "审核用户",
"remark": "审核用户，BO_USER",
"guidMethod": 0,
"isRequired": false,
"isData": true,
"filter": {
"isMust": false
},
"editPropertie": {
"showMethod": 2,
"showMethodOut": 0,
"isOriginal": false
},
"pagePropertie": {
"showMethod": 2,
"showMethodOut": 0,
"isOriginal": false
},
"field": "auditUserId",
"name": "audit_user_id",
"alias": "audit_user_id",
"isDate": false,
"isPrimary": false,
"isIdentity": false,
"maxLength": 36
},
"createTime": {
"isExportN": true,
"fieldSort": 9999,
"extendAlias": "create_time",
"tableId": 1,
"dataType": "datetime",
"title": "创建时间",
"remark": "创建时间:新增时候来至系统，修改时候不改变",
"guidMethod": 0,
"isRequired": false,
"isSearch": true,
"isData": true,
"filter": {
"isMust": false
},
"field": "createTime",
"name": "create_time",
"alias": "create_time",
"isDate": true,
"isPrimary": false,
"isIdentity": false
},
"createUserId": {
"isExportN": true,
"fieldSort": 9999,
"extendAlias": "create_user",
"tableId": 1,
"dataType": "varchar",
"title": "创建用户",
"remark": "创建用户，BO_USER",
"guidMethod": 0,
"isRequired": false,
"isData": true,
"filter": {
"isMust": false
},
"field": "createUserId",
"name": "create_user_id",
"alias": "create_user_id",
"isDate": false,
"isPrimary": false,
"isIdentity": false,
"maxLength": 36
},
"fromName": {
"fieldSort": 9999,
"extendAlias": "search_like",
"tableId": 1,
"dataType": "varchar",
"title": "资源来源",
"remark": "资源来源",
"guidMethod": 0,
"isRequired": false,
"isSearch": true,
"isData": true,
"filter": {
"isMust": false
},
"field": "fromName",
"name": "from_name",
"alias": "from_name",
"isDate": false,
"isPrimary": false,
"isIdentity": false,
"maxLength": 255
},
"idCard": {
"fieldSort": 9999,
"extendAlias": "input_basis",
"tableId": 1,
"dataType": "varchar",
"title": "身份证",
"guidMethod": 0,
"encDesMethod": 3,
"isRequired": false,
"isData": true,
"filter": {
"isMust": false
},
"field": "idCard",
"name": "id_card",
"alias": "id_card",
"isDate": false,
"isPrimary": false,
"isIdentity": false,
"maxLength": 500
},
"imgUrl": {
"fieldSort": 9999,
"extendAlias": "image",
"tableId": 1,
"dataType": "varchar",
"title": "图片地址",
"remark": "图片地址，库里面存储相对路径，返回前台是完整路径",
"guidMethod": 0,
"isRequired": false,
"isData": true,
"filter": {
"isMust": false
},
"field": "imgUrl",
"name": "img_url",
"alias": "img_url",
"isDate": false,
"isPrimary": false,
"isIdentity": false,
"maxLength": 1000
},
"insResId": {
"fieldSort": 9999,
"extendAlias": "primary",
"tableId": 1,
"dataType": "varchar",
"title": "记录编号",
"remark": "记录编号：32位 guid",
"guidMethod": 2,
"isRequired": true,
"isData": true,
"filter": {
"isMust": false
},
"field": "insResId",
"name": "ins_res_id",
"alias": "ins_res_id",
"isDate": false,
"isPrimary": true,
"isIdentity": false,
"maxLength": 36
},
"insResName": {
"fieldSort": 9999,
"extendAlias": "search_like",
"tableId": 1,
"dataType": "varchar",
"title": "资源名称",
"remark": "资源名称",
"guidMethod": 0,
"isRequired": false,
"isSearch": true,
"isData": true,
"filter": {
"isMust": false
},
"field": "insResName",
"name": "ins_res_name",
"alias": "ins_res_name",
"isDate": false,
"isPrimary": false,
"isIdentity": false,
"maxLength": 255
},
"insResTag": {
"fieldSort": 9999,
"extendAlias": "input_basis",
"tableId": 1,
"dataType": "varchar",
"title": "资源标签",
"guidMethod": 0,
"isRequired": false,
"isData": true,
"filter": {
"isMust": false
},
"editPropertie": {
"showMethod": 2,
"showMethodOut": 6,
"isOriginal": false
},
"pagePropertie": {
"showMethod": 2,
"showMethodOut": 6,
"isOriginal": false
},
"field": "insResTag",
"name": "ins_res_tag",
"alias": "ins_res_tag",
"isDate": false,
"isPrimary": false,
"isIdentity": false,
"maxLength": 255
},
"linkAudio": {
"fieldSort": 9999,
"extendAlias": "input_basis",
"tableId": 1,
"dataType": "varchar",
"title": "音频地址",
"guidMethod": 0,
"isRequired": false,
"isData": true,
"filter": {
"isMust": false
},
"field": "linkAudio",
"name": "link_audio",
"alias": "link_audio",
"isDate": false,
"isPrimary": false,
"isIdentity": false,
"maxLength": 255
},
"linkVideo": {
"fieldSort": 9999,
"extendAlias": "input_basis",
"tableId": 1,
"dataType": "varchar",
"title": "视频地址",
"guidMethod": 0,
"isRequired": false,
"isData": true,
"filter": {
"isMust": false
},
"field": "linkVideo",
"name": "link_video",
"alias": "link_video",
"isDate": false,
"isPrimary": false,
"isIdentity": false,
"maxLength": 255
},
"modifyTime": {
"isExportN": true,
"fieldSort": 9999,
"extendAlias": "modify_time",
"tableId": 1,
"dataType": "datetime",
"title": "修改时间",
"remark": "修改时间:来至系统",
"guidMethod": 0,
"isRequired": false,
"isData": true,
"filter": {
"isMust": false
},
"field": "modifyTime",
"name": "modify_time",
"alias": "modify_time",
"isDate": true,
"isPrimary": false,
"isIdentity": false
},
"modifyUserId": {
"isExportN": true,
"fieldSort": 9999,
"extendAlias": "modify_user",
"tableId": 1,
"dataType": "varchar",
"title": "修改用户",
"remark": "修改用户，BO_USER",
"guidMethod": 0,
"isRequired": false,
"isData": true,
"filter": {
"isMust": false
},
"field": "modifyUserId",
"name": "modify_user_id",
"alias": "modify_user_id",
"isDate": false,
"isPrimary": false,
"isIdentity": false,
"maxLength": 36
},
"openId": {
"fieldSort": 9999,
"extendAlias": "input_basis",
"tableId": 1,
"dataType": "varchar",
"title": "第三方账号",
"guidMethod": 0,
"isRequired": false,
"isData": true,
"filter": {
"isMust": false
},
"field": "openId",
"name": "open_id",
"alias": "open_id",
"isDate": false,
"isPrimary": false,
"isIdentity": false,
"maxLength": 500
},
"realName": {
"fieldSort": 9999,
"extendAlias": "search_like",
"tableId": 1,
"dataType": "varchar",
"title": "真实姓名",
"remark": "真实姓名",
"guidMethod": 0,
"isRequired": false,
"isSearch": true,
"isData": true,
"filter": {
"isMust": false
},
"field": "realName",
"name": "real_name",
"alias": "real_name",
"isDate": false,
"isPrimary": false,
"isIdentity": false,
"maxLength": 255
},
"relatedUserId": {
"fieldSort": 9999,
"extendAlias": "user_basis",
"tableId": 1,
"dataType": "varchar",
"title": "关联用户",
"guidMethod": 0,
"isRequired": false,
"isData": true,
"dimJoin": {
"fromDimField": "userBasis",
"allFilter": "",
"joinChar": ","
},
"filter": {
"isMust": false
},
"dimSqlRep": [
{
"name": "RelatedUserId",
"key": "_fromPrimaryIds",
"value": "_filterDimRelatedUserId",
"alias": "related_user_id"
}
],
"field": "relatedUserId",
"name": "related_user_id",
"alias": "related_user_id",
"isDate": false,
"isPrimary": false,
"isIdentity": false,
"maxLength": 255
},
"remark": {
"fieldSort": 9999,
"extendAlias": "input_basis",
"tableId": 1,
"dataType": "varchar",
"title": "资源描述",
"guidMethod": 0,
"isRequired": false,
"isData": true,
"filter": {
"isMust": false
},
"field": "remark",
"name": "remark",
"alias": "remark",
"isDate": false,
"isPrimary": false,
"isIdentity": false,
"maxLength": 4000
},
"resType": {
"fieldSort": 9999,
"extendAlias": "input_basis",
"tableId": 1,
"dataType": "varchar",
"title": "资源类别",
"remark": "资源类别， 医生等",
"guidMethod": 0,
"isRequired": false,
"isData": true,
"dimJoin": {
"fromDimField": "findResourceType",
"joinChar": ","
},
"filter": {
"isMust": false
},
"editPropertie": {
"showMethod": 2,
"showMethodOut": 2,
"isOriginal": false
},
"pagePropertie": {
"showMethod": 2,
"showMethodOut": 2,
"defaultValue": "doctor",
"isOriginal": false
},
"field": "resType",
"name": "res_type",
"alias": "res_type",
"isDate": false,
"isPrimary": false,
"isIdentity": false,
"maxLength": 255
},
"showNum": {
"fieldSort": 9999,
"tableId": 1,
"dataType": "bigint",
"title": "浏览量",
"guidMethod": 0,
"isRequired": false,
"isData": true,
"filter": {
"isMust": false
},
"editPropertie": {
"showMethod": 2,
"showMethodOut": 0,
"isOriginal": false
},
"pagePropertie": {
"showMethod": 2,
"showMethodOut": 0,
"isOriginal": false
},
"field": "showNum",
"name": "show_num",
"alias": "show_num",
"isDate": false,
"isPrimary": false,
"isIdentity": false,
"maxLength": 19,
"colDecimal": 0
},
"sortId": {
"insertSort": "insertSort",
"fieldSort": 9999,
"extendAlias": "sort",
"tableId": 1,
"dataType": "int",
"title": "排序",
"remark": "如果没设置值，按系统从999999递减",
"guidMethod": 0,
"isRequired": false,
"isData": true,
"filter": {
"isMust": false
},
"field": "sortId",
"name": "sort_id",
"alias": "sort_id",
"isDate": false,
"isPrimary": false,
"isIdentity": false,
"maxLength": 10,
"colDecimal": 0
},
"starRating": {
"fieldSort": 9999,
"tableId": 1,
"dataType": "int",
"title": "星级， 10分最高",
"guidMethod": 0,
"isRequired": false,
"isData": true,
"filter": {
"isMust": false
},
"editPropertie": {
"showMethod": 2,
"showMethodOut": 0,
"isOriginal": false
},
"pagePropertie": {
"showMethod": 2,
"showMethodOut": 0,
"isOriginal": false
},
"field": "starRating",
"name": "star_rating",
"alias": "star_rating",
"isDate": false,
"isPrimary": false,
"isIdentity": false,
"maxLength": 10,
"colDecimal": 0
},
"sysId": {
"isExportN": true,
"fieldSort": 9999,
"extendAlias": "sys_id",
"tableId": 1,
"dataType": "varchar",
"title": "所属系统",
"remark": "所属系统，对应BO_SYSTEM",
"guidMethod": 0,
"isRequired": false,
"isData": true,
"filter": {
"isMust": false
},
"field": "sysId",
"name": "sys_id",
"alias": "sys_id",
"isDate": false,
"isPrimary": false,
"isIdentity": false,
"maxLength": 4000
},
"tags": {
"fieldSort": 9999,
"extendAlias": "tags_basis",
"tableId": 1,
"dataType": "varchar",
"title": "资源标记",
"guidMethod": 0,
"isRequired": false,
"isData": true,
"filter": {
"isMust": false
},
"field": "tags",
"name": "tags",
"alias": "tags",
"isDate": false,
"isPrimary": false,
"isIdentity": false,
"maxLength": 100
},
"telephone": {
"fieldSort": 9999,
"extendAlias": "input_basis",
"tableId": 1,
"dataType": "varchar",
"title": "联系电话",
"guidMethod": 0,
"encDesMethod": 3,
"isRequired": false,
"isData": true,
"filter": {
"isMust": false
},
"field": "telephone",
"name": "telephone",
"alias": "telephone",
"isDate": false,
"isPrimary": false,
"isIdentity": false,
"maxLength": 500
}
},
"dimDatas": {
"findResourceType": {
"name": "医疗资源类别",
"allSql": "find-resource-type",
"dataFromType": 1,
"fromExtend": false
},
"global": {
"allSql": "select tb_d.ins_res_name name,tb_d.ins_res_id id,0 parent_Id,tb_d.ins_res_id value from bt_insurance_resource tb_d ",
"dataFromType": 0
},
"sysEnum": {
"extend": "sysEnum",
"dataFromType": 0
},
"sysState": {
"extend": "sysState",
"dataFromType": 1
},
"system": {
"extend": "system",
"dataFromType": 0
},
"userBasis": {
"extend": "userBasis",
"dataFromType": 0
}
},
"rules": {
"auditOpinion": [
{
"type": "maxlength",
"required": false,
"isAdd": false,
"isEdit": false,
"max": 36,
"message": "【{audit_opinion}】值最大长度为36。"
}
],
"auditStatus": [
{
"type": "digits",
"required": false,
"isAdd": true,
"isEdit": true,
"message": "【{audit_status}】值必须是整数。"
}
],
"auditTime": [
{
"type": "date",
"required": false,
"isAdd": false,
"isEdit": false,
"message": "【{audit_time}】值时间格式不对。"
}
],
"auditUserId": [
{
"type": "maxlength",
"required": false,
"isAdd": false,
"isEdit": false,
"max": 36,
"message": "【{audit_user_id}】值最大长度为36。"
}
],
"createTime": [
{
"type": "date",
"required": false,
"isAdd": false,
"isEdit": false,
"message": "【{create_time}】值时间格式不对。"
}
],
"createUserId": [
{
"type": "maxlength",
"required": false,
"isAdd": false,
"isEdit": false,
"max": 36,
"message": "【{create_user_id}】值最大长度为36。"
}
],
"fromName": [
{
"type": "maxlength",
"required": false,
"isAdd": false,
"isEdit": false,
"max": 255,
"message": "【{from_name}】值最大长度为255。"
}
],
"idCard": [
{
"type": "maxlength",
"required": false,
"isAdd": false,
"isEdit": false,
"max": 500,
"message": "【{id_card}】值最大长度为500。"
}
],
"imgUrl": [
{
"type": "maxlength",
"required": false,
"isAdd": false,
"isEdit": false,
"max": 1000,
"message": "【{img_url}】值最大长度为1000。"
}
],
"insResId": [
{
"type": "required",
"required": true,
"isAdd": true,
"isEdit": true,
"message": "【{ins_res_id}】值必须填写。"
},
{
"type": "maxlength",
"required": false,
"isAdd": false,
"isEdit": false,
"max": 36,
"message": "【{ins_res_id}】值最大长度为36。"
}
],
"insResName": [
{
"type": "maxlength",
"required": false,
"isAdd": false,
"isEdit": false,
"max": 255,
"message": "【{ins_res_name}】值最大长度为255。"
}
],
"insResTag": [
{
"type": "maxlength",
"required": false,
"isAdd": false,
"isEdit": false,
"max": 255,
"message": "【{ins_res_tag}】值最大长度为255。"
}
],
"linkAudio": [
{
"type": "maxlength",
"required": false,
"isAdd": false,
"isEdit": false,
"max": 255,
"message": "【{link_audio}】值最大长度为255。"
}
],
"linkVideo": [
{
"type": "maxlength",
"required": false,
"isAdd": false,
"isEdit": false,
"max": 255,
"message": "【{link_video}】值最大长度为255。"
}
],
"modifyTime": [
{
"type": "date",
"required": false,
"isAdd": false,
"isEdit": false,
"message": "【{modify_time}】值时间格式不对。"
}
],
"modifyUserId": [
{
"type": "maxlength",
"required": false,
"isAdd": false,
"isEdit": false,
"max": 36,
"message": "【{modify_user_id}】值最大长度为36。"
}
],
"openId": [
{
"type": "maxlength",
"required": false,
"isAdd": false,
"isEdit": false,
"max": 500,
"message": "【{open_id}】值最大长度为500。"
}
],
"realName": [
{
"type": "maxlength",
"required": false,
"isAdd": false,
"isEdit": false,
"max": 255,
"message": "【{real_name}】值最大长度为255。"
}
],
"relatedUserId": [
{
"type": "maxlength",
"required": false,
"isAdd": false,
"isEdit": false,
"max": 255,
"message": "【{related_user_id}】值最大长度为255。"
}
],
"remark": [
{
"type": "maxlength",
"required": false,
"isAdd": false,
"isEdit": false,
"max": 4000,
"message": "【{remark}】值最大长度为4000。"
}
],
"resType": [
{
"type": "maxlength",
"required": false,
"isAdd": false,
"isEdit": false,
"max": 255,
"message": "【{res_type}】值最大长度为255。"
}
],
"showNum": [
{
"type": "digits",
"required": false,
"isAdd": true,
"isEdit": true,
"message": "【{show_num}】值必须是整数。"
}
],
"sortId": [
{
"type": "digits",
"required": false,
"isAdd": true,
"isEdit": true,
"message": "【{sort_id}】值必须是整数。"
}
],
"starRating": [
{
"type": "digits",
"required": false,
"isAdd": true,
"isEdit": true,
"message": "【{star_rating}】值必须是整数。"
}
],
"sysId": [
{
"type": "maxlength",
"required": false,
"isAdd": false,
"isEdit": false,
"max": 4000,
"message": "【{sys_id}】值最大长度为4000。"
}
],
"tags": [
{
"type": "maxlength",
"required": false,
"isAdd": false,
"isEdit": false,
"max": 100,
"message": "【{tags}】值最大长度为100。"
}
],
"telephone": [
{
"type": "maxlength",
"required": false,
"isAdd": false,
"isEdit": false,
"max": 500,
"message": "【{telephone}】值最大长度为500。"
}
]
}
}详情页面输出结果案例
{
data: {
telephone: "7wpPPva/3KIf9FN6JU+GHQ==",
tags: [],
idCard: "STPRMfLtTTPZEevC1GcFXzyTD6J8vr2O",
imgUrl:
"http://localhost:5900/filelibary/bt/image/20210726/1-bt-deve-bt-20272a98-2daa-462_show.jpg",
insResId: "bt-deve-bt-20200-070c4a94-b3f8-42cb",
insResName: "ee33a订单lll",
linkAudio: "http://baid.com",
realName: "嗡",
showNum: 138,
sortId: 0,
diffTableNo: 0,
auditStatus: { name: "已禁用", value: 0 },
relatedUserId: {
name: "c-b-g2",
value: "1-bt-deve-bt-20200-247148cb-667d-4c3",
},
resType: { name: "医生", value: "doctor" },
insResTag: ["kkk", "jljl"],
},
code: "0",
retCode: "0",
success: true,
}列表页面输出结果案例
{
data: [
{
tags: [],
insResId: "bt-deve-bt-20200-5c9a8715-d188-433b",
insResName: "浏览量",
showNum: 2,
sortId: 0,
diffTableNo: 0,
auditStatus: { name: "已禁用", value: 0 },
relatedUserId: {},
resType: { name: "其它", value: "else" },
auditTime: {
name: "2021-04-16 09:21:51",
value: "2021-04-16T09:21:51",
},
createTime: {
name: "2021-04-16 09:21:51",
value: "2021-04-16T09:21:51",
},
modifyTime: {
name: "2021-04-16 09:21:51",
value: "2021-04-16T09:21:51",
},
insResTag: [],
}
],
cacheDate: "2021-07-29T08:28:40",
code: "0",
retCode: "0",
success: true,
paging: {
pageSize: 4,
totalCount: 7,
totalPage: 2,
pageIndex: 2,
currentCount: 7,
currentRate: 100,
limtStartIndex: 4,
},
}文档更新时间: 2021-08-22 08:00 作者：admin
