通讯录标签

设计

租户库

CREATE TABLE IF NOT EXISTS p_mark_group(
g_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
g_name VARCHAR(50) NOT NULL,
g_des VARCHAR(100),
g_editable INT,
g_deletable INT 
);
INSERT INTO p_mark_group 
(g_id,g_name,g_des,g_editable,g_deletable) 
VALUES 
(1,'默认','',0,0) 
ON DUPLICATE KEY UPDATE g_des=g_des;
CREATE TABLE IF NOT EXISTS p_mark_role(
r_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
r_name VARCHAR(50) NOT NULL,
r_des VARCHAR(100),
r_editable INT,
r_deletable INT,
g_id INT NOT NULL
);
INSERT INTO p_mark_role (r_id,r_name,r_des,r_editable,r_deletable,g_id) 
VALUES 
(1,'1W','',0,0,1), 
(2,'CFO','',0,0,1), 
(3,'CIO','',0,0,1), 
(4,'营销总','',0,0,1), 
(5,'财务总','',0,0,1), 
(6,'运营总','',0,0,1), 
(7,'采购总','',0,0,1), 
(8,'项目总','',0,0,1), 
(9,'工程总','',0,0,1), 
(10,'客服总','',0,0,1), 
(11,'物业总','',0,0,1) 
ON DUPLICATE KEY UPDATE r_des=r_des;
CREATE TABLE IF NOT EXISTS p_user_role(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
openid VARCHAR(50) NOT NULL,
r_id INT NOT NULL 
);

接口规范

获取当前企业下所有角色组和角色

接口地址

/api/open-api/get-role-groups?access_token=xxx

post参数

{
    "tenant_id": ""
}

返回值

{
    "success": 1,
    "data": {
        "code": 1,
        "message": "ok",
        "groups": [
            {
                "g_id": "1",
                "g_name": "默认",
                "g_des": "",
                "g_editable": "0",
                "g_deletable": "0",
                "roles": [
                    {
                        "r_id": "1",
                        "r_name": "1W",
                        "r_des": "",
                        "r_editable": "0",
                        "r_deletable": "0"
                    }
                ]
            },
            {
                "g_id": "2",
                "g_name": "测试",
                "g_des": "",
                "g_editable": "0",
                "g_deletable": "0",
                "roles": [
                    {
                        "r_id": "12",
                        "r_name": "开发总",
                        "r_des": "",
                        "r_editable": "0",
                        "r_deletable": "0"
                    }
                ]
            }
        ]
    }
}

获取某个角色下的所有用户

接口地址

/api/open-api/get-role-users?access_token=xxx

post参数

{
    "tenant_id": "",
    "role_id":1
}

返回值

{
    "success": 1,
    "data": {
        "code": 1,
        "message": "ok",
        "users": [
            {
                "user_name": "艾振强",
                "user_code": "aizq",
                "mobile_tel": "",
                "offcie_tel": "",
                "home_tel": "",
                "email": "aizq@mysoft.com.cn",
                "dept_guid": "171ac9eb-a983-45d2-9603-c925d2ffa961",
                "openid": "mysoft59e06805c541a344902847"
            },
            {
                "user_name": "陈炯蔚",
                "user_code": "chenjw",
                "mobile_tel": "",
                "offcie_tel": "",
                "home_tel": "",
                "email": "chenjw@mysoft.com.cn",
                "dept_guid": "171ac9eb-a983-45d2-9603-c925d2ffa961",
                "openid": "mysoft59e068c02d784281977561"
            }
        ]
    }
}

获取某个用户的所有角色

接口地址

/api/open-api/get-user-roles?access_token=xxx

post参数

{
    "tenant_id": "",
    "openid":[
        "mysoft59f14bfc4e758876156650"
    ]
}

返回值

{
    "success": 1,
    "data": {
        "code": 1,
        "message": "ok",
        "result": [
            {
                "openid": "mysoft59f14bfc4e758876156650",
                "user_id": "23488",
                "name": "梅义",
                "dept_full_name": "总部 > 深圳明源 > 产品体验",
                "dept_name": "产品体验",
                "roles": [
                    {
                        "g_id": "1",
                        "g_name": "默认",
                        "g_des": "",
                        "g_editable": "0",
                        "g_deletable": "0",
                        "r_id": "2",
                        "r_name": "CFO",
                        "r_des": "",
                        "r_editable": "0",
                        "r_deletable": "0"
                    }
                ]
            }
        ]
    }
}