From 09e6dc3fb7266620fafb5e341808a8eb36e080a1 Mon Sep 17 00:00:00 2001 From: wlzboy <66905212@qq.com> Date: 星期六, 13 十二月 2025 22:51:52 +0800 Subject: [PATCH] feat:增加企业微信消息提醒 --- sql/ry_20250417.sql | 12 ++++++++++-- 1 files changed, 10 insertions(+), 2 deletions(-) diff --git a/sql/ry_20250417.sql b/sql/ry_20250417.sql index 20e843f..f40e3bf 100644 --- a/sql/ry_20250417.sql +++ b/sql/ry_20250417.sql @@ -59,14 +59,22 @@ update_by varchar(64) default '' comment '鏇存柊鑰�', update_time datetime comment '鏇存柊鏃堕棿', remark varchar(500) default null comment '澶囨敞', + oa_user_id int(11) default null comment 'SQL Server涓殑OA鐢ㄦ埛ID', + oa_order_class varchar(255) default null comment 'OA绯荤粺鐨勮鍗曠紪鐮佸垪琛紙濡傦細BF,AB,SA锛�', + open_id varchar(100) default null comment '寰俊OpenID', + union_id varchar(100) default null comment '寰俊UnionID', + wechat_nickname varchar(100) default null comment '寰俊鏄电О', + qy_wechat_user_id varchar(100) default null comment '浼佷笟寰俊鐢ㄦ埛ID', + qy_wechat_update_time datetime default null comment '浼佷笟寰俊鐢ㄦ埛ID鏇存柊鏃堕棿', + can_view_all_consult char(1) default '0' comment '鏄惁鍙煡鐪嬫墍鏈夊挩璇㈠崟锛�0鍚� 1鏄級', primary key (user_id) ) engine=innodb auto_increment=100 comment = '鐢ㄦ埛淇℃伅琛�'; -- ---------------------------- -- 鍒濆鍖�-鐢ㄦ埛淇℃伅琛ㄦ暟鎹� -- ---------------------------- -insert into sys_user values(1, 103, 'admin', '鑻ヤ緷', '00', 'ry@163.com', '15888888888', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', sysdate(), 'admin', sysdate(), '', null, '绠＄悊鍛�'); -insert into sys_user values(2, 105, 'ry', '鑻ヤ緷', '00', 'ry@qq.com', '15666666666', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', sysdate(), 'admin', sysdate(), '', null, '娴嬭瘯鍛�'); +insert into sys_user values(1, 103, 'admin', '鑻ヤ緷', '00', 'ry@163.com', '15888888888', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', sysdate(), 'admin', sysdate(), '', null, '绠＄悊鍛�', null, null, null, null, null, null, null, '0'); +insert into sys_user values(2, 105, 'ry', '鑻ヤ緷', '00', 'ry@qq.com', '15666666666', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', sysdate(), 'admin', sysdate(), '', null, '娴嬭瘯鍛�', null, null, null, null, null, null, null, '0'); -- ---------------------------- -- Gitblit v1.9.1