# **系统更新升级** ## V5.0.0 (2023-11-23) ● 升级日志 1.朋友圈功能升级调整; 2.客户标签功能调整,以及部分场景下导致we_customer表中tag_ids字段对丢失功能优化。 3.客户新增流失时间字段，以及系统其他相关bug修复。 4.更新日志文档记录规整。 ● xxl-job更新日志 INSERT INTO `xxl_job_info` (`id`, `job_group`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `schedule_type`, `schedule_conf`, `misfire_strategy`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (65, 3, '朋友圈任务执行', '2023-11-18 22:58:29', '2023-11-23 11:35:05', 'HaoN', '', 'CRON', '0/5 * * * * ?', 'DO_NOTHING', 'FIRST', 'sendWeMomentHandle', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2023-11-18 22:58:29', '', 1, 1700710730000, 1700710735000); ● 菜单更新日志 UPDATE `sys_menu` SET `menu_name` = '超级朋友圈', `parent_id` = 2198, `order_num` = 1, `path` = 'superFriendCicle', `component` = NULL, `is_frame` = 1, `menu_type` = 'M', `visible` = '0', `status` = '0', `perms` = '', `icon` = '#', `create_by` = 'admin', `create_by_id` = NULL, `create_time` = '2023-07-05 15:27:18', `update_by` = 'admin', `update_by_id` = NULL, `update_time` = '2023-11-20 15:26:39', `remark` = '' WHERE `menu_id` = 2451; INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_by_id`, `create_time`, `update_by`, `update_by_id`, `update_time`, `remark`) VALUES (2477, '列表', 2451, 5, 'list', 'friendCircle/list', 1, 'C', '1', '0', NULL, '#', 'admin', NULL, '2023-11-20 15:27:12', NULL, NULL, NULL, ''); INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_by_id`, `create_time`, `update_by`, `update_by_id`, `update_time`, `remark`) VALUES (2478, '任务统计', 2451, 10, 'statistics', 'friendCircle/statistics', 1, 'C', '1', '0', NULL, '#', 'admin', NULL, '2023-11-20 15:30:03', NULL, NULL, NULL, ''); INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_by_id`, `create_time`, `update_by`, `update_by_id`, `update_time`, `remark`) VALUES (2479, '{新增}', 2451, 8, 'publish', 'friendCircle/publish', 1, 'C', '1', '0', NULL, '#', 'admin', NULL, '2023-11-20 15:31:09', NULL, NULL, NULL, ''); ● sql更新日志 1.ALTER table we_customer add loss_time datetime; 2.DROP TABLE IF EXISTS `we_moments_attachments`; CREATE TABLE `we_moments_attachments` ( `id` bigint(20) NOT NULL COMMENT '主键id', `moments_task_id` bigint(20) NOT NULL COMMENT '朋友圈任务id', `is_material` tinyint(1) NOT NULL COMMENT '是否内容中心素材: 0不是 1是', `msg_type` tinyint(1) DEFAULT NULL COMMENT '附件类型:0图片 1视频 2链接 3位置', `media_id` varchar(255) DEFAULT NULL COMMENT '企微素材id,有效期3天', `media_id_expire` datetime DEFAULT NULL COMMENT '企微素材id失效时间', `media_id_url` varchar(255) DEFAULT NULL COMMENT '获取企微临时素材后，上传到oss', `thumb_media_id` varchar(255) DEFAULT NULL COMMENT '视频封面media_id', `thumb_media_id_expire` datetime DEFAULT NULL COMMENT '视频封面media_id的失效时间', `thumb_media_id_url` varchar(255) DEFAULT NULL COMMENT '视频封面media_id的url地址', `link_title` varchar(255) DEFAULT NULL COMMENT '网页链接标题', `link_url` varchar(255) DEFAULT NULL COMMENT '网页链接url', `location_latitude` varchar(255) DEFAULT NULL COMMENT '地理位置纬度', `location_longitude` varchar(255) DEFAULT NULL COMMENT '地理位置经度', `location_name` varchar(255) DEFAULT NULL COMMENT '地理位置名称', `material_id` bigint(20) DEFAULT NULL COMMENT '素材中心Id', `real_type` tinyint(2) DEFAULT NULL COMMENT '真实素材类型', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='朋友圈附件'; 3.DROP TABLE IF EXISTS `we_moments_customer`; CREATE TABLE `we_moments_customer` ( `id` bigint(20) NOT NULL COMMENT '主键id', `moments_task_id` bigint(20) NOT NULL COMMENT '朋友圈任务id', `moments_id` varchar(64) DEFAULT NULL COMMENT '朋友圈id', `user_id` bigint(20) DEFAULT NULL COMMENT '员工id', `we_user_id` varchar(255) NOT NULL COMMENT '企微员工id', `user_name` varchar(255) NOT NULL COMMENT '员工名称', `external_userid` varchar(255) DEFAULT NULL COMMENT '客户id', `customer_name` varchar(255) DEFAULT NULL COMMENT '客户名称', `delivery_status` int(11) DEFAULT NULL COMMENT '送达状态 0已送达 1未送达', `create_by` varchar(255) DEFAULT NULL COMMENT '创建人', `update_by` varchar(255) DEFAULT NULL COMMENT '更新人', `update_by_id` bigint(20) DEFAULT NULL COMMENT '更新人id', `create_by_id` bigint(20) DEFAULT NULL COMMENT '创建人id', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_time` datetime DEFAULT NULL COMMENT '修改时间', `del_flag` tinyint(4) DEFAULT '0' COMMENT '删除标识 0:正常 1:删除', PRIMARY KEY (`id`), KEY `moments_task_id` (`moments_task_id`,`moments_id`,`user_id`,`external_userid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='朋友圈可见客户'; 4.DROP TABLE IF EXISTS `we_moments_estimate_customer`; CREATE TABLE `we_moments_estimate_customer` ( `id` bigint(20) NOT NULL COMMENT '主键id', `moments_task_id` bigint(20) NOT NULL COMMENT '朋友圈任务id', `user_id` bigint(20) DEFAULT NULL COMMENT '员工id', `we_user_id` varchar(255) NOT NULL COMMENT '企微员工id', `user_name` varchar(255) DEFAULT NULL COMMENT '员工名称', `external_userid` varchar(255) NOT NULL COMMENT '客户id', `customer_name` varchar(255) DEFAULT NULL COMMENT '客户名称', `delivery_status` int(11) DEFAULT NULL COMMENT '送达状态 0已送达 1未送达', `create_by` varchar(255) DEFAULT NULL COMMENT '创建人', `update_by` varchar(255) DEFAULT NULL COMMENT '更新人', `update_by_id` bigint(20) DEFAULT NULL COMMENT '更新人id', `create_by_id` bigint(20) DEFAULT NULL COMMENT '创建人id', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_time` datetime DEFAULT NULL COMMENT '修改时间', `del_flag` tinyint(4) DEFAULT '0' COMMENT '删除标识 0:正常 1:删除', PRIMARY KEY (`id`) USING BTREE, KEY `moments_task_id` (`moments_task_id`,`we_user_id`,`external_userid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='预估朋友圈可见客户'; 5.DROP TABLE IF EXISTS `we_moments_estimate_user`; CREATE TABLE `we_moments_estimate_user` ( `id` bigint(20) NOT NULL COMMENT '主键Id', `moments_task_id` bigint(20) NOT NULL COMMENT '朋友圈任务id', `user_id` bigint(20) DEFAULT NULL COMMENT '员工id', `we_user_id` varchar(255) NOT NULL COMMENT '企微员工id', `user_name` varchar(255) NOT NULL COMMENT '员工名称', `dept_id` bigint(20) DEFAULT NULL COMMENT '部门id', `dept_name` varchar(255) DEFAULT NULL COMMENT '部门名称', `execute_count` int(11) DEFAULT '0' COMMENT '提醒执行次数', `execute_status` tinyint(1) NOT NULL COMMENT '执行状态:0未执行，1已执行', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='预估朋友圈执行员工'; 6.DROP TABLE IF EXISTS `we_moments_interacte`; CREATE TABLE `we_moments_interacte` ( `id` bigint(11) NOT NULL COMMENT '主键', `moments_task_id` bigint(20) NOT NULL COMMENT '朋友圈任务id', `moment_id` varchar(64) NOT NULL COMMENT '朋友圈id', `we_user_id` varchar(255) DEFAULT NULL COMMENT '企业发表成员userid', `interacte_user_id` varchar(255) DEFAULT NULL COMMENT '互动人员名称id', `interacte_type` tinyint(1) DEFAULT NULL COMMENT '互动类型:0:评论；1:点赞', `interacte_user_type` tinyint(1) DEFAULT NULL COMMENT '互动人员类型:0:员工；1:客户', `interacte_time` datetime DEFAULT NULL COMMENT '互动时间', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建人', `create_by_id` bigint(11) DEFAULT NULL COMMENT '创建人id', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新人', `update_by_id` bigint(11) DEFAULT NULL COMMENT '更新人id', `del_flag` tinyint(1) DEFAULT '0' COMMENT '是否删除:0有效,1删除', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='朋友圈互动列表'; 7.DROP TABLE IF EXISTS `we_moments_task`; CREATE TABLE `we_moments_task` ( `id` bigint(20) NOT NULL DEFAULT '0' COMMENT '主键ID', `name` varchar(20) DEFAULT NULL COMMENT '任务名称', `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '朋友圈类型:0:企业动态;1:个人动态', `send_type` tinyint(1) NOT NULL COMMENT '发送方式: 0企微群发，1个人发送，2成员群发', `is_lw_push` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否是在lw平台发布的:1:是;0:否;', `scope_type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '发送范围: 0全部客户 1按条件筛选', `customer_num` int(11) DEFAULT '0' COMMENT '朋友圈可见客户数', `dept_ids` varchar(1000) DEFAULT NULL COMMENT '部门id集合', `post_ids` varchar(1000) DEFAULT NULL COMMENT '岗位id集合', `user_ids` varchar(1000) DEFAULT NULL COMMENT '员工id集合', `customer_tag` text COMMENT '客户标签，多个使用逗号隔开', `content` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '朋友圈部分内容', `execute_time` datetime DEFAULT NULL COMMENT '执行时间', `execute_end_time` datetime DEFAULT NULL COMMENT '结束时间', `like_tag_ids` text COMMENT '点赞标签', `we_customers_query` text COMMENT '客户查询条件\n', `comment_tag_ids` text COMMENT '评论标签', `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '任务状态：1未开始，2进行中，3已结束', `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建人', `create_by_id` bigint(11) DEFAULT NULL COMMENT '创建人id', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新人', `update_by_id` bigint(11) DEFAULT NULL COMMENT '更新人id', `update_time` datetime DEFAULT NULL COMMENT '修改时间', `del_flag` tinyint(4) NOT NULL DEFAULT '0' COMMENT '删除标识 0:正常 1:删除', `establish_time` datetime DEFAULT NULL COMMENT '企微创建时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='朋友圈'; 8.DROP TABLE IF EXISTS `we_moments_task_relation`; CREATE TABLE `we_moments_task_relation` ( `id` bigint(20) NOT NULL COMMENT '主键id', `moment_task_id` bigint(20) NOT NULL COMMENT '朋友圈任务id', `job_id` varchar(64) DEFAULT NULL COMMENT '异步任务id，24小时有效', `job_id_expire` datetime DEFAULT NULL COMMENT '异步任务id失效时间', `moment_id` varchar(64) DEFAULT NULL COMMENT '朋友圈id', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='朋友圈任务和企微朋友圈关联表'; 8.DROP TABLE IF EXISTS `we_moments_user`; CREATE TABLE `we_moments_user` ( `id` bigint(20) NOT NULL COMMENT '主键id', `moments_task_id` bigint(20) NOT NULL COMMENT '朋友圈任务id', `moments_id` varchar(64) DEFAULT NULL COMMENT '朋友圈id', `user_id` bigint(20) DEFAULT NULL COMMENT '员工id', `we_user_id` varchar(255) NOT NULL COMMENT '企微员工id', `user_name` varchar(255) NOT NULL COMMENT '员工名称', `dept_id` bigint(20) DEFAULT NULL COMMENT '部门id', `dept_name` varchar(255) DEFAULT NULL COMMENT '部门名称', `execute_status` tinyint(1) NOT NULL COMMENT '执行状态:0未执行，1已执行', `execute_count` int(11) NOT NULL COMMENT '提醒执行次数', `create_by` varchar(255) DEFAULT NULL COMMENT '创建人', `update_by` varchar(255) DEFAULT NULL COMMENT '更新人', `update_by_id` bigint(20) DEFAULT NULL COMMENT '更新人id', `create_by_id` bigint(20) DEFAULT NULL COMMENT '创建人id', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_time` datetime DEFAULT NULL COMMENT '修改时间', `del_flag` tinyint(4) DEFAULT '0' COMMENT '删除标识 0:正常 1:删除', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='朋友圈执行员工'; ## V5.0.1 (2023-11-30) ● 升级日志 1.客户sop,企为群发，任务裂变客户筛选功能重构与优化; 2.群裂变条件为全部时任务通知循环发送相关BUG。 ● sql更新日志 ALTER TABLE we_fission ADD COLUMN we_customers_query text COMMENT '客户查询条件'; ALTER TABLE we_fission ADD COLUMN scope_type tinyint COMMENT '发送范围: 0全部客户 1按条件筛选'; ALTER TABLE we_sop_base ADD COLUMN we_customers_query text COMMENT '客户查询条件'; ALTER TABLE we_sop_base ADD COLUMN scope_type tinyint COMMENT '发送范围: 0全部客户 1按条件筛选'; ALTER TABLE we_group_message_task ADD COLUMN we_customers_query text COMMENT '客户查询条件'; ALTER TABLE we_group_message_task ADD COLUMN scope_type tinyint COMMENT '发送范围: 0全部客户 1按条件筛选'; ## V5.0.2 (2023-12-07) ● 升级日志 1.员工活码新增H5链接与智能短链功能,与活码统计升级。 2.客群活码活码新增H5链接与智能短链功能,与活码统计升级。 3.系统相关bug修复。 ● yml文件更新 linkwe-common.yml linkwechat: qrShortLinkDomainName: sl.linkwechat.net/st/pqr/ qrGroupShortLinkDomainName: sl.linkwechat.net/st/gqr/ linkwe-gateway.yml security: ignore: whites: - /open/gqr/** - /open/pqr/** ● 菜单更新日志 UPDATE `sys_menu` SET `menu_name` = '员工活码', `parent_id` = 2218, `order_num` = 1, `path` = 'staff', `component` = ' ', `is_frame` = 1, `menu_type` = 'M', `visible` = '0', `status` = '0', `perms` = '', `icon` = '#', `create_by` = 'admin', `create_by_id` = NULL, `create_time` = '2020-11-08 12:13:21', `update_by` = 'admin', `update_by_id` = NULL, `update_time` = '2023-02-07 21:06:31', `remark` = '' WHERE `menu_id` = 2053; UPDATE `sys_menu` SET `menu_name` = '详情', `parent_id` = 2053, `order_num` = 11, `path` = 'detail', `component` = 'drainageCode/staff/detail', `is_frame` = 1, `menu_type` = 'C', `visible` = '1', `status` = '0', `perms` = 'drainageCode:staff:detail', `icon` = '#', `create_by` = 'admin', `create_by_id` = NULL, `create_time` = '2021-02-22 16:32:05', `update_by` = 'admin', `update_by_id` = NULL, `update_time` = '2023-11-30 17:17:33', `remark` = '' WHERE `menu_id` = 2159; UPDATE `sys_menu` SET `menu_name` = '{新建}', `parent_id` = 2053, `order_num` = 12, `path` = 'add', `component` = 'drainageCode/staff/add', `is_frame` = 1, `menu_type` = 'C', `visible` = '1', `status` = '0', `perms` = 'drainageCode:staff:add', `icon` = '#', `create_by` = 'admin', `create_by_id` = NULL, `create_time` = '2021-02-22 16:38:11', `update_by` = 'admin', `update_by_id` = NULL, `update_time` = '2023-11-30 17:18:06', `remark` = '' WHERE `menu_id` = 2160; UPDATE `sys_menu` SET `menu_name` = '列表', `parent_id` = 2053, `order_num` = 1, `path` = 'list', `component` = 'drainageCode/staff/list', `is_frame` = 1, `menu_type` = 'C', `visible` = '1', `status` = '0', `perms` = '', `icon` = '#', `create_by` = 'admin', `create_by_id` = NULL, `create_time` = '2022-09-12 23:07:48', `update_by` = 'admin', `update_by_id` = NULL, `update_time` = '2022-09-14 22:11:13', `remark` = '' WHERE `menu_id` = 2283; UPDATE `sys_menu` SET `menu_name` = '客群活码', `parent_id` = 2218, `order_num` = 2, `path` = 'customerGroup', `component` = 'Layout', `is_frame` = 1, `menu_type` = 'M', `visible` = '0', `status` = '0', `perms` = '', `icon` = '#', `create_by` = 'admin', `create_by_id` = NULL, `create_time` = '2020-11-08 12:26:15', `update_by` = 'admin', `update_by_id` = NULL, `update_time` = '2023-02-28 16:35:30', `remark` = '' WHERE `menu_id` = 2056; UPDATE `sys_menu` SET `menu_name` = '{新增}', `parent_id` = 2056, `order_num` = 50, `path` = 'add', `component` = 'drainageCode/group/baseInfo', `is_frame` = 1, `menu_type` = 'C', `visible` = '1', `status` = '0', `perms` = 'drainageCode:group:add', `icon` = '#', `create_by` = 'admin', `create_by_id` = NULL, `create_time` = '2021-02-23 00:11:41', `update_by` = 'admin', `update_by_id` = NULL, `update_time` = '2023-12-03 21:33:08', `remark` = '' WHERE `menu_id` = 2164; UPDATE `sys_menu` SET `menu_name` = '详情', `parent_id` = 2056, `order_num` = 10, `path` = 'detail', `component` = 'drainageCode/group/detail', `is_frame` = 1, `menu_type` = 'C', `visible` = '1', `status` = '0', `perms` = 'drainageCode:group:detail', `icon` = '#', `create_by` = 'admin', `create_by_id` = NULL, `create_time` = '2021-02-23 00:14:50', `update_by` = 'admin', `update_by_id` = NULL, `update_time` = '2023-12-03 21:31:35', `remark` = '' WHERE `menu_id` = 2165; UPDATE `sys_menu` SET `menu_name` = '列表', `parent_id` = 2056, `order_num` = 1, `path` = 'list', `component` = 'drainageCode/group/list', `is_frame` = 1, `menu_type` = 'C', `visible` = '1', `status` = '0', `perms` = '', `icon` = '#', `create_by` = 'admin', `create_by_id` = NULL, `create_time` = '2022-09-12 23:08:33', `update_by` = 'admin', `update_by_id` = NULL, `update_time` = '2022-09-13 00:09:31', `remark` = '' WHERE `menu_id` = 2284; UPDATE `sys_menu` SET `menu_name` = '统计', `parent_id` = 2056, `order_num` = 2, `path` = 'analyse', `component` = 'drainageCode/group/analyse', `is_frame` = 1, `menu_type` = 'C', `visible` = '1', `status` = '0', `perms` = '', `icon` = '#', `create_by` = 'admin', `create_by_id` = NULL, `create_time` = '2023-02-22 12:42:39', `update_by` = 'admin', `update_by_id` = NULL, `update_time` = '2023-02-28 16:34:07', `remark` = '' WHERE `menu_id` = 2364; ● xxl-job更新日志 INSERT INTO `xxl_job_info` ( `job_group`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `schedule_type`, `schedule_conf`, `misfire_strategy`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES ( 3, '通用短链统计任务', '2023-07-24 16:41:02', '2023-11-23 11:33:15', 'sxw', '', 'CRON', '59 59 23 * * ?', 'DO_NOTHING', 'ROUND', 'weCommonLinkStatisticTask', '', 'SERIAL_EXECUTION', 60, 3, 'BEAN', '', 'GLUE代码初始化', '2023-07-24 16:41:02', '', 1, 1701878399000, 1701964799000); ## V5.0.2 (2023-12-07) ● 升级日志 1.新增客群去重功能。 2.客户SOP与客群SOP新增一键复制功能,同时移除编辑功能。 3.系统相关bug修复,以及yml相关文件优化。 ● yml文件更新 linkwe-common.yml linkwechat: shortDomain: sl.linkwechat.net #短域名 shortLinkDomainName: ${linkwechat.shortDomain}/st/t/ customerShortLinkDomainName: ${linkwechat.shortDomain}/st/l/ qrShortLinkDomainName: ${linkwechat.shortDomain}/st/pqr/ qrGroupShortLinkDomainName: ${linkwechat.shortDomain}/st/gqr/ linkwe-gateway.yml security: ignore: whites: - /open/qr/getBydetail/** - /open/groupCode/getBydetail/** ● 菜单更新日志 UPDATE `sys_menu` SET `menu_name` = '详情', `parent_id` = 2102, `order_num` = 10, `path` = 'detail', `component` = 'communityOperating/oldCustomer/detail', `is_frame` = 1, `menu_type` = 'C', `visible` = '1', `status` = '0', `perms` = '', `icon` = 'code', `create_by` = 'admin', `create_by_id` = NULL, `create_time` = '2023-11-13 14:12:12', `update_by` = 'admin', `update_by_id` = NULL, `update_time` = '2023-12-13 15:33:53', `remark` = '' WHERE `menu_id` = 2476; INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_by_id`, `create_time`, `update_by`, `update_by_id`, `update_time`, `remark`) VALUES (2482, '客群去重', 2223, 15, 'groupRepeat', 'customerManage/groupRepeat/list', 1, 'C', '0', '0', '', '#', 'admin', NULL, '2023-12-09 01:42:33', 'admin', NULL, '2023-12-14 13:12:36', ''); ## V5.0.4 (2023-12-21) ● 升级日志 1.智能表单统计优化重构 2.更新企微配置重构缓存。 3.相关功能bug修复。 ● yml文件更新 linkwe-gateway.yml security: ignore: whites: - /wx-api/form/survey/getInfo/** ● 菜单更新日志 INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_by_id`, `create_time`, `update_by`, `update_by_id`, `update_time`, `remark`) VALUES (2453, '销售洞察', 2366, 1, 'saleInsight', NULL, 1, 'M', '0', '0', '', '#', 'admin', NULL, '2023-08-07 11:34:28', 'admin', NULL, '2023-08-07 11:35:15', ''); INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_by_id`, `create_time`, `update_by`, `update_by_id`, `update_time`, `remark`) VALUES (2454, '线索分析', 2453, 5, 'clueAnalysis', 'clue/clueAnalysis/index', 1, 'C', '0', '0', NULL, '#', 'admin', NULL, '2023-08-07 11:35:08', NULL, NULL, NULL, ''); ● sql更新日志 CREATE TABLE `we_form_survey_count` ( `id` bigint(11) NOT NULL COMMENT '主键', `total_visits` bigint(20) DEFAULT NULL COMMENT '总访问量(每天记录对应当天对应ip的访问量)', `belong_id` bigint(20) DEFAULT NULL COMMENT '问卷id', `total_time` bigint(20) DEFAULT NULL COMMENT '完成总时间', `data_source` varchar(255) DEFAULT NULL COMMENT '数据来源', `visitor_ip` varchar(255) DEFAULT NULL COMMENT '访问ip', `create_by` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `create_by_id` bigint(11) DEFAULT NULL COMMENT '创建人id', `update_time` datetime DEFAULT NULL COMMENT '修改时间', `update_by` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '更新人', `update_by_id` bigint(11) DEFAULT NULL COMMENT '更新人id', `del_flag` tinyint(4) NOT NULL DEFAULT '0' COMMENT '删除标识 0 正常 1 删除', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='智能表单统计(按照每天的维度统计相关客户数据；ip+当天定位每一条记录)'; ● xxl-job更新日志 DELETE FROM xxl_job_info WHERE id=2 ## V5.0.5 (2023-12-21) ● 升级日志 1.门店活码相关功能升级。 2.相关功能bug修复。 ● sql更新日志 DROP TABLE IF EXISTS `we_store_code`; CREATE TABLE `we_store_code` ( `id` bigint(20) NOT NULL COMMENT '主键', `store_name` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '门店名称', `province_id` int(11) DEFAULT NULL COMMENT '省id', `city_id` int(11) DEFAULT NULL COMMENT '市id', `area_id` int(11) DEFAULT NULL COMMENT '区id', `area` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '省/市/区', `address` varchar(300) CHARACTER SET utf8 DEFAULT NULL COMMENT '详细地址', `longitude` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '纬度', `latitude` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '经度', `shop_guide_id` text CHARACTER SET utf8 COMMENT '导购id(we_user_id)，多个使用逗号隔开', `shop_guide_name` text CHARACTER SET utf8 COMMENT '导购名称，多个使用逗号隔开', `shop_guide_url` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '导购活码url', `shop_guide_state` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '导购码渠道标识', `shop_guide_config_id` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '导购码configId', `group_code_url` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '群活码', `group_code_id` bigint(20) DEFAULT NULL COMMENT '群活码id', `group_code_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '群活码名称', `group_code_config_id` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '群码config', `group_code_state` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '群渠道标识', `add_we_user_or_group_code` text CHARACTER SET utf8 COMMENT '添加员工或群活码', `store_state` tinyint(1) DEFAULT '1' COMMENT '门店状态(0:启用;1:关闭)', `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建人', `create_by_id` bigint(20) DEFAULT NULL COMMENT '创建人id', `create_time` datetime DEFAULT NULL COMMENT '创建人时间', `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新人', `update_by_id` bigint(20) DEFAULT NULL COMMENT '更新人id', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `del_flag` tinyint(1) DEFAULT '0' COMMENT '0:正常;1:删除;', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; ## V5.0.6 (2024-01-05) ● 升级日志 1.关键词群功能全新升级。 2.系统数据权限功能升级优化。 3.识客码状态启动关闭时数据丢失等相关bug修复。 ● yml文件更新 linkwe-common.yml linkwechat: keyWordGroupUrl: ${linkwechat.h5Domain}/#/keywords?id={0} #关键词群 ● 菜单更新日志 UPDATE `sys_menu` SET `menu_name` = '关键词群', `parent_id` = 2100, `order_num` = 50, `path` = 'keywords', `component` = 'Layout', `is_frame` = 1, `menu_type` = 'M', `visible` = '0', `status` = '0', `perms` = '', `icon` = '#', `create_by` = 'admin', `create_by_id` = NULL, `create_time` = '2020-12-30 21:31:17', `update_by` = 'admin', `update_by_id` = NULL, `update_time` = '2023-02-28 18:36:00', `remark` = '' WHERE `menu_id` = 2103; UPDATE `sys_menu` SET `menu_name` = '{新增}', `parent_id` = 2103, `order_num` = 10, `path` = 'aev', `component` = 'communityOperating/keywords/aev', `is_frame` = 1, `menu_type` = 'C', `visible` = '1', `status` = '0', `perms` = 'communityOperating/keywords/aev', `icon` = '#', `create_by` = 'admin', `create_by_id` = NULL, `create_time` = '2020-12-31 19:38:49', `update_by` = 'admin', `update_by_id` = NULL, `update_time` = '2024-01-04 11:17:36', `remark` = '' WHERE `menu_id` = 2108; UPDATE `sys_menu` SET `menu_name` = '列表', `parent_id` = 2103, `order_num` = 5, `path` = 'list', `component` = 'communityOperating/keywords/list', `is_frame` = 1, `menu_type` = 'C', `visible` = '1', `status` = '0', `perms` = NULL, `icon` = '#', `create_by` = 'admin', `create_by_id` = NULL, `create_time` = '2023-02-28 18:36:26', `update_by` = NULL, `update_by_id` = NULL, `update_time` = NULL, `remark` = '' WHERE `menu_id` = 2377; INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_by_id`, `create_time`, `update_by`, `update_by_id`, `update_time`, `remark`) VALUES (2483, '详情', 2103, 15, 'detail', 'communityOperating/keywords/detail', 1, 'C', '1', '0', NULL, '#', 'admin', NULL, '2023-12-26 23:23:14', NULL, NULL, NULL, ''); ● sql更新日志 DROP TABLE IF EXISTS `we_key_word_group_sub`; CREATE TABLE `we_key_word_group_sub` ( `id` bigint(20) NOT NULL COMMENT '主键', `keyword` varchar(255) DEFAULT NULL COMMENT '关键词', `code_name` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '活码名称', `keyword_group_id` bigint(20) DEFAULT NULL COMMENT '关键词主表主键', `chat_id_list` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '实际群id，多个使用逗号隔开', `auto_create_room` tinyint(1) DEFAULT '0' COMMENT '当群满了后，是否自动新建群。0-否；1-是。 默认为0', `room_base_name` varchar(255) DEFAULT NULL COMMENT '自动建群的群名前缀，当auto_create_room为1时有效。最长40个utf8字符', `room_base_id` int(11) DEFAULT NULL COMMENT '自动建群的群起始序号，当auto_create_room为1时有效', `group_code_config_id` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '群活码企微信的configId\n', `group_code_state` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '群活码渠道标识\n', `group_code_url` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '群活码图片地址\n', `group_code_name` varchar(255) DEFAULT NULL COMMENT '群名', `sort` tinyint(4) DEFAULT '0' COMMENT '排序', `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建人', `create_by_id` bigint(11) DEFAULT NULL COMMENT '创建人id', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新人', `update_by_id` bigint(11) DEFAULT NULL COMMENT '更新人id ', `update_time` datetime DEFAULT NULL COMMENT '修改时间', `del_flag` int(1) DEFAULT '0' COMMENT '0:正常;1:删除;', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='关键词群子表'; DROP TABLE IF EXISTS `we_keyword_group`; CREATE TABLE `we_keyword_group` ( `id` bigint(20) NOT NULL COMMENT '关键词拉群任务主键', `title` varchar(100) NOT NULL COMMENT '标题', `descrition` varchar(255) DEFAULT NULL COMMENT '描述', `keyword_group_url` varchar(255) DEFAULT NULL COMMENT '关键词群链接二维码链接', `keyword_group_qr_url` varchar(255) DEFAULT NULL COMMENT '关键词群链接二维码链接', `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建人', `create_by_id` bigint(11) DEFAULT NULL COMMENT '创建人id', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新人', `update_by_id` bigint(11) DEFAULT NULL COMMENT '更新人id', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记 0 未删除 1已删除', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='关键词拉群任务表'; DROP TABLE IF EXISTS `we_keyword_group_view_count`; CREATE TABLE `we_keyword_group_view_count` ( `id` bigint(20) NOT NULL COMMENT '主键', `view_num` int(11) DEFAULT '0' COMMENT '访问数量', `keyword_group_id` bigint(20) DEFAULT NULL COMMENT '关键词主表主键', `union_id` varchar(255) DEFAULT NULL COMMENT 'unionld', `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建人', `create_by_id` bigint(11) DEFAULT NULL COMMENT '创建人id', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新人', `update_by_id` bigint(11) DEFAULT NULL COMMENT '更新人id ', `update_time` datetime DEFAULT NULL COMMENT '修改时间', `del_flag` int(1) DEFAULT '0' COMMENT '0:正常;1:删除;', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='关键词群访问统计'; ## V5.1.0 (2024-01-12) ● 升级日志 1.系统全面接入AI【目前仅支持:腾讯混元】 2.系统相关bug修复。 ● yml文件更新 linkwe-common.yml linkwechat: txAiSecretId: txAiSecretKey: txAiRegion: linkwe-ai.yml server: port: 6060 servlet: context-path: /ai tomcat: uri-encoding: UTF-8 ● sql更新日志 CREATE TABLE `we_ai_msg` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id', `session_id` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '会话ID', `msg_id` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'AI对话ID', `user_id` bigint(20) NOT NULL COMMENT '员工ID', `role` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '角色', `content` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '内容', `request_id` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '结果ID', `send_time` datetime NOT NULL COMMENT '发送时间', `note` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '免责声明', `collection` tinyint(4) NOT NULL DEFAULT '0' COMMENT '收藏 0-未收藏 1-收藏', `prompt_tokens` int(11) DEFAULT '0' COMMENT '请求消耗token数', `completion_tokens` int(11) DEFAULT '0' COMMENT '回复消耗token数', `total_tokens` int(11) DEFAULT '0' COMMENT '总消耗token数', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建人', `create_by_id` bigint(11) DEFAULT NULL COMMENT '创建人id', `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新人', `update_by_id` bigint(11) DEFAULT NULL COMMENT '更新人id', `del_flag` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除:0有效,1删除', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=95 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='ai助手消息表'; ## V5.1.1 (2024-01-19) ● 升级日志 1.系统新增群发一键复制功能。 2.系统新增AI服务校验,如果linkwe-ai服务未启动,则关闭隐藏前端ai相关功能。 3.系统相关bug修复等 ● yml文件更新 gateway-router #以下直接覆盖即可 [{ "id": "linkwe-auth", "order": 0, "predicates": [{ "args": { "pattern": "/auth/**" }, "name": "Path" }], "filters":[{ "name":"ValidateCodeFilter" },{ "name":"CacheRequestFilter" } ], "uri": "lb://linkwe-auth" },{ "id": "linkwe-auth-system", "order": 0, "predicates": [{ "args": { "pattern": "/system/**" }, "name": "Path" }], "uri": "lb://linkwe-auth" },{ "id": "linkwe-wecom", "order": 2, "predicates": [{ "args": { "pattern": "/wecom/**" }, "name": "Path" }], "filters":[{ "args": { "_genkey_0":"1" }, "name":"StripPrefix" }], "uri": "lb://linkwe-wecom" },{ "id": "linkwe-api", "order": 3, "predicates": [{ "args": { "pattern": "/open/**" }, "name": "Path" }], "uri": "lb://linkwe-api" },{ "id": "linkwe-file", "order": 4, "predicates": [{ "args": { "pattern": "/file/**" }, "name": "Path" }], "uri": "lb://linkwe-file" },{ "id": "linkwe-auth-common", "order": 0, "predicates": [{ "args": { "pattern": "/common/**" }, "name": "Path" }], "uri": "lb://linkwe-auth" },{ "id": "linkwe-wx-api", "order": 3, "predicates": [{ "args": { "pattern": "/wx-api/**" }, "name": "Path" }], "uri": "lb://linkwe-wx-api" },{ "id": "linkwe-ai", "order": 6, "predicates": [{ "args": { "pattern": "/ai/**" }, "name": "Path" }], "uri": "lb://linkwe-ai" }] ● sql更新日志 ALTER TABLE we_group_message_template ADD COLUMN all_send tinyint; ALTER TABLE we_group_message_template ADD COLUMN we_customers_or_group_query text; ## V5.1.2 (2024-01-26) ● 升级日志 1.文件上传新增适配minio 2.系统相关bug修复等