-- ============================================================ -- 售后工单:流转记录表 + 下线「退货申请」菜单 -- 日期:2026-11-05 -- 说明:仓储物流已提供退货操作,售后模块不再保留「退货申请」页面 -- ============================================================ -- 1. 售后工单流转记录表 CREATE TABLE IF NOT EXISTS `after_sale_ticket_flow` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '流转记录编号', `ticket_id` bigint NOT NULL COMMENT '售后工单编号,关联 after_sale_ticket.id', `action` varchar(32) NOT NULL COMMENT '动作编码:CREATE/UPDATE/ASSIGN/CLASSIFY/RESOLVE/ARCHIVE/CANCEL/VISIT', `action_name` varchar(64) NOT NULL COMMENT '动作名称,如:创建工单、分配处理人', `from_status` int DEFAULT NULL COMMENT '变更前状态,关联 AfterSaleTicketStatusEnum', `to_status` int DEFAULT NULL COMMENT '变更后状态,关联 AfterSaleTicketStatusEnum', `content` varchar(1000) DEFAULT NULL COMMENT '流转内容/说明', `operator_id` bigint DEFAULT NULL COMMENT '操作人用户编号', `creator` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', PRIMARY KEY (`id`), KEY `idx_ticket_id` (`ticket_id`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='售后工单流转记录'; -- 1.1 补齐工单表缺失的客户诉求/处理结果描述列(MySQL 不支持 ADD COLUMN IF NOT EXISTS) SET @exists = (SELECT COUNT(*) FROM information_schema.columns WHERE table_schema = DATABASE() AND table_name = 'after_sale_ticket' AND column_name = 'feedback_description'); SET @sql = IF(@exists = 0, 'ALTER TABLE `after_sale_ticket` ADD COLUMN `feedback_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT ''客户诉求反馈描述'' AFTER `issue_description`', 'SELECT 1'); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; SET @exists = (SELECT COUNT(*) FROM information_schema.columns WHERE table_schema = DATABASE() AND table_name = 'after_sale_ticket' AND column_name = 'result_description'); SET @sql = IF(@exists = 0, 'ALTER TABLE `after_sale_ticket` ADD COLUMN `result_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT ''处理结果描述'' AFTER `feedback_description`', 'SELECT 1'); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; -- 2. 下线「退货申请」菜单(含按钮权限) -- 退货申请菜单 id = 602589,父菜单 = 售后管理 602587; -- 如其他环境 id 不同,按 path = '/aftersales/return/index' 定位后替换。 DELETE FROM `system_role_menu` WHERE `menu_id` IN (SELECT `id` FROM `system_menu` WHERE `id` = 602589 OR `parent_id` = 602589); DELETE FROM `system_menu` WHERE `parent_id` = 602589; DELETE FROM `system_menu` WHERE `id` = 602589 AND `component` LIKE '%aftersales/return/index%';