查询机构人员信息

接口名称：queryOrgMemberInfo
涉及到表结构：
SELECT * FROM BASEDATA.BAS_ORG_MEMBER;
SELECT * FROM BASEDATA.BAS_ORG_MEMBER_IMAGE;
SELECT * FROM BASEDATA.BAS_ORG_DEPT_MEMBER;
SELECT * FROM BASEDATA.BAS_ORG_MEMBER_OPERPOWER;
SELECT * FROM BASEDATA.BAS_ORG_MEMBER_PROPERTY;

https://www.processon.com/f/681ecb3a99215745c2df5448#查询机构人员信息

请求参数

Header 参数

Token

string

可选

默认值:

7d7bc205-a05f-40a0-a79b-addea1ded679

示例值:

7d7bc205-a05f-40a0-a79b-addea1ded679

appId

string

可选

默认值:

trasen

Body 参数application/json

orgCode

string

医院编码

必需

hospCode

string | null

院区编码

必需

pageIndex

integer

当前页数

必需

pageSize

integer

每页查询数量

必需

sortOrder

string

排序方式

必需

0-创建时间，1-工号，默认0

memberIdList

array[string] | null

人员ID集合

必需

keyWord

string | null

查询关键字

可选

支持按工号、姓名、拼音码、五笔码模糊查询

memberRole

string | null

人员类型编码

必需

数据库字段：MEMBER_ROLE
通用字典明细中code:分类编码: TD_00013 分类名称:人员类别代码 1-医生 2-护士 3-医技 4-药剂 5-行政 6-收费 9-其他

status

string

有效状态

必需

数据库字段：STATUS 1-有效 2-无效，包含停用则此字段不判别

默认值:

doctorTitleCode

string | null

医生职称编码

必需

数据库字段：DOCTOR_CODE
通用字典明细中code:分类编码: doctor_title 分类名称:医生职称 1-正主任医师 2-副主任医师 3-主治医师 4-一般医师 5-简易门诊 6-名老专家 0-实习医生

nurseTitleCode

string | null

护士级别编码

必需

数据库字段：NURSE_TITLE
通用字典明细中code:分类编码: nurse_title 分类名称:护士职称 1-护士 2-护师 3-主管护师 4-副主任护师 5-主任护师

officeId

string | null

归属科室ID

必需

数据库字段：OFFICE

deptIdList

array[string] | null

工作科室ID集合

必需

对应于人员科室关联表中的科室ID
BASEDATA.BAS_ORG_DEPT_MEMBER.DEPT_ID

operateDictIdList

array[string] | null

手术权限字典ID集合

必需

对应于人员手术权限字典ID
BASEDATA.BAS_ORG_MEMBER_OPERPOWER.OPER_DICT_ID

isContainToAudit

string

是否包含待审核

必需

0-不包含 1-包含默认0
包含待审核数据库端为 IS_DELETE IN ('N','S')

默认值:

isGetMemberDept

string

是否获取人员科室

必需

0-否 1-是默认0

默认值:

isGetMemberProperty

string

是否获取人员属性

必需

0-否 1-是默认0

默认值:

isGetMemberImage

string

是否获取人员照片信息

必需

0-否 1-是默认0

默认值:

isGetMemberOpePower

string

是否获取人员手术分级权限

必需

0-否 1-是默认0

默认值:

startUpdateDate

string <date-time> | null

开始更新时间

必需

根据UPDATE_DATE查询

endUpdateDate

string <date-time> | null

结束更新时间

必需

根据UPDATE_DATE查询

示例

{
    "orgCode": "string",
    "hospCode": "string",
    "pageIndex": 0,
    "pageSize": 0,
    "sortOrder": "string",
    "memberIdList": [
        "string"
    ],
    "keyWord": "string",
    "memberRole": "string",
    "status": "1",
    "doctorTitleCode": "string",
    "nurseTitleCode": "string",
    "officeId": "string",
    "deptIdList": [
        "string"
    ],
    "operateDictIdList": [
        "string"
    ],
    "isContainToAudit": "0",
    "isGetMemberDept": "0",
    "isGetMemberProperty": "0",
    "isGetMemberImage": "0",
    "isGetMemberOpePower": "0",
    "startUpdateDate": "2019-08-24T14:15:22Z",
    "endUpdateDate": "2019-08-24T14:15:22Z"
}

示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

返回响应

🟢200成功

application/json

Body

Code

string

返回码

必需

200段正常返回 400段业务逻辑错误 500段系统级代码级错误

Message

string

消息

可选

exception

string

详细异常

可选

apiCode

string

接口编码

可选

data

object

返回数据

可选

totalCount

integer

记录总数量

必需

list

array [object {94}]

可选

示例

{
    "Code": "string",
    "Message": "string",
    "exception": "string",
    "apiCode": "string",
    "data": {
        "totalCount": 0,
        "list": [
            {
                "id": "string",
                "orgCode": "string",
                "createDate": "2019-08-24T14:15:22Z",
                "createUserId": "string",
                "updateDate": "2019-08-24T14:15:22Z",
                "updateUserId": "string",
                "isDelete": "0",
                "updateKey": 0,
                "code": "string",
                "name": "string",
                "sex": "s",
                "age": "string",
                "idCard": "string",
                "phone": "string",
                "pyCode": "string",
                "wbCode": "string",
                "nationCode": "string",
                "nationName": "string",
                "memberTypeCode": "string",
                "memberTypeName": "string",
                "titleCode": "string",
                "titleName": "string",
                "specialField": "string",
                "description": "string",
                "email": "string",
                "homePhone": "string",
                "homeAddress": "string",
                "imgUrl": "string",
                "remarks": "string",
                "status": "0",
                "postNatureCode": "string",
                "postNatureName": "string",
                "memberRole": "st",
                "doctorCode": "string",
                "doctorTitle": "s",
                "prescribe": "s",
                "prescribeStartDate": "2019-08-24T14:15:22Z",
                "prescribeEndDate": "2019-08-24T14:15:22Z",
                "prescribeExpireDate": "string",
                "anesthesia": "s",
                "herbal": "s",
                "cipherPrescription": "s",
                "poisonous": "s",
                "nurseTitle": "s",
                "isNurseMaster": "0",
                "birthday": "2019-08-24T14:15:22Z",
                "onState": "s",
                "reEmploy": "s",
                "isOnline": "s",
                "officeId": "string",
                "sign": "string",
                "expiryDate": "SYSDATE",
                "isGroupLeader": "s",
                "fromHosp": "string",
                "isRefund": "stri",
                "password": "string",
                "isAudit": "N",
                "sortNo": 0,
                "antiLevel": "stri",
                "psyRight": "string",
                "materApply": "strin",
                "zlypLevel": "string",
                "signUrl": "string",
                "ukeyCode": "string",
                "memberLevelPower": "0",
                "medicalInsuranceCode": "",
                "specialAnti": "s",
                "noLimitLeapfrog": "s",
                "limitLeapfrog": "s",
                "isEnableCaVerify": "0",
                "platId": "string",
                "canDispensing": "stri",
                "sitInfo": "string",
                "therapeutist": "s",
                "sitroomInfo": "string",
                "daySurgeryOpen": "N",
                "herbalMedicine": "N",
                "isBelongpRovince": "0",
                "clinicalPostCode": "st",
                "clinicalPostName": "string",
                "source": "1",
                "slowExcess": "s",
                "leapfrogSpecial": "s",
                "groupId": "string",
                "consultationOpen": "N",
                "directorDoctorName": "string",
                "directorDoctorId": "string",
                "parentDoctorId": "string",
                "parentDoctorName": "string",
                "officeDeptName": "string",
                "memberDeptList": [
                    {
                        "id": "string",
                        "orgCode": "string",
                        "orgName": "string",
                        "createDate": "2019-08-24",
                        "createUserName": "string",
                        "createUserId": "string",
                        "updateDate": "2019-08-24",
                        "updateUserName": "string",
                        "updateUserId": "string",
                        "isDelete": "0",
                        "updatekey": "BASEDATA.ISEQ$$_107074.nextval",
                        "deptId": "string",
                        "deptName": "string",
                        "memberId": "string",
                        "masterFlag": "N",
                        "bmove": 0
                    }
                ],
                "memberImageList": [
                    {
                        "id": "string",
                        "orgCode": "string",
                        "createDate": "2019-08-24",
                        "createUserId": "string",
                        "updateDate": "2019-08-24",
                        "updateUserId": "string",
                        "isDelete": "Y",
                        "updatekey": "BASEDATA.ISEQ$$_107732.nextval",
                        "memberId": "string",
                        "imageContent": "string",
                        "picType": "string",
                        "bmove": 0
                    }
                ],
                "memberOpePowerList": [
                    {
                        "id": "string",
                        "orgCode": "string",
                        "createDate": "2019-08-24",
                        "createUserId": "string",
                        "updateDate": "2019-08-24",
                        "updateUserId": "string",
                        "updatekey": "BASEDATA.ISEQ$$_106893.nextval",
                        "memberId": "string",
                        "surgeryDictId": "string",
                        "surgeryDictName": "string",
                        "surgeryDictCode": "string",
                        "powerValue": "st"
                    }
                ],
                "memberExtendPropertyList": [
                    {
                        "id": "string",
                        "orgCode": "string",
                        "updatekey": "BASEDATA.ISEQ$$_106755.nextval",
                        "memberId": "string",
                        "operationType": 0,
                        "dictCode": "string",
                        "controlValue": "string",
                        "bmove": 0,
                        "propertyType": "st"
                    }
                ]
            }
        ]
    }
}