-- 售后退款/换货人工确认需要可追溯凭证及独立权限。 SET @has_refund_voucher := (SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'after_sale_return' AND COLUMN_NAME = 'refund_voucher_no'); SET @ddl := IF(@has_refund_voucher = 0, 'ALTER TABLE after_sale_return ADD COLUMN refund_voucher_no varchar(100) NULL COMMENT ''Refund or exchange voucher number'' AFTER actual_refund_price', 'SELECT 1'); PREPARE stmt FROM @ddl; EXECUTE stmt; DEALLOCATE PREPARE stmt; INSERT INTO system_menu (name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, updater) SELECT CONVERT(0xE7A1AEE8AEA4E98080E6ACBE2FE68DA2E8B4A7 USING utf8mb4), 'aftersales:return:refund', 3, 3, 602589, '', '#', NULL, NULL, 0, b'1', b'0', b'0', 'system', 'system' WHERE EXISTS (SELECT 1 FROM system_menu WHERE id = 602589 AND deleted = b'0') AND NOT EXISTS (SELECT 1 FROM system_menu WHERE permission = 'aftersales:return:refund' AND deleted = b'0'); UPDATE system_menu SET name = CONVERT(0xE7A1AEE8AEA4E98080E6ACBE2FE68DA2E8B4A7 USING utf8mb4) WHERE permission = 'aftersales:return:refund' AND deleted = b'0'; INSERT INTO system_menu (name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, updater) SELECT CONVERT(0xE58F96E6B688E98080E8B4A7 USING utf8mb4), 'aftersales:return:cancel', 3, 4, 602589, '', '#', NULL, NULL, 0, b'1', b'0', b'0', 'system', 'system' WHERE EXISTS (SELECT 1 FROM system_menu WHERE id = 602589 AND deleted = b'0') AND NOT EXISTS (SELECT 1 FROM system_menu WHERE permission = 'aftersales:return:cancel' AND deleted = b'0');