11.5.9、微信OAuth集成

11.5.9、微信OAuth集成

配置前必看：

部署认证对接包（11.3章节）

修改配置文件（11.5章节）

1 企业微信中配置oauth可信域名

2 ../ROOT/emap.properties添加下列配置

emap.properties

# 默认选择哪种方式;微信标准oauth认证micromessenger，参数配置固定 auth.bean=micromessenger # 微信企业号的corpid及secret配置 wechart.corpid=****** wechart.corpsecret=** # 系统的域名 app.domainContext=http://ehall.wisedu.com # 添加redis配置 redis.ip=* redis.port=* redis.timeout=* redis.password=* redis.database=* redis.charset=UTF-8

3 ../emapAuth/config/checkerMapping.xml添加下列配置

其中：lwStuReportEpidemic为对接的应用包名

index.do" appName="pubauthapp" beanId="pubLoginChecker"/>

4 维护V_ALL_USERS表

若现场没有V_ALL_USERS视图，需要自行创建，数据表可引用T_LWPUB_JZG和T_LWPUB_XS

单体参考此SQL

CREATE OR REPLACE VIEW V_ALL_USERS AS SELECT ACCOUNTID AS RYID, ACCOUNTNAME as xm, '' as XBDM, '' as DWDM, '1' AS LX, '学生' AS LXMC, SYSDATE AS TBRQ, NULL AS TBLX, SYSDATE AS CZRQ, 'ADMIN' AS CZZ, 'ADMIN' AS CZZXM FROM T_FUNA_USER WHERE USERIDENTITY=1 AND USERSTATE='normal' UNION SELECT ACCOUNTID AS RYID, ACCOUNTNAME as xm, '' as XBDM, '' as DWDM, '2' AS LX, '教师' AS LXMC, SYSDATE AS TBRQ, NULL AS TBLX, SYSDATE AS CZRQ, 'ADMIN' AS CZZ, 'ADMIN' AS CZZXM FROM T_FUNA_USER WHERE (USERIDENTITY=2 or USERIDENTITY is null) AND USERSTATE='normal' UNION SELECT ACCOUNTID AS RYID, ACCOUNTNAME as xm, '' as XBDM, '' as DWDM, '3' AS LX, '访客' AS LXMC, SYSDATE AS TBRQ, NULL AS TBLX, SYSDATE AS CZRQ, 'ADMIN' AS CZZ, 'ADMIN' AS CZZXM FROM T_FUNA_USER WHERE USERIDENTITY=3 AND USERSTATE='normal' UNION SELECT USER_ID AS RYID, USER_NAME as xm, GENDER_CODE as XBDM, DEPT_CODE as DWDM, '1' AS LX, '学生' AS LXMC, SYSDATE AS TBRQ, NULL AS TBLX, SYSDATE AS CZRQ, 'ADMIN' AS CZZ, 'ADMIN' AS CZZXM FROM T_LWPUB_XS UNION SELECT USER_ID AS RYID, USER_NAME as xm, GENDER_CODE as XBDM, DEPT_CODE as DWDM, '2' AS LX, '教师' AS LXMC, SYSDATE AS TBRQ, NULL AS TBLX, SYSDATE AS CZRQ, 'ADMIN' AS CZZ, 'ADMIN' AS CZZXM FROM T_LWPUB_JZG;

上一个

11.5.8、中教科CAS认证

下一个

11.5.10、今日校园OAuth集成

最近修改: 2024-06-21Powered by