process_sheet/fastadmin/application/sql/ps_admin_zh_menu.sql

-- 后台菜单中文化 + 流程单按功能分组
-- 可重复执行

-- ----------------------------
-- 系统默认菜单改为中文
-- ----------------------------
UPDATE `fa_auth_rule` SET `title`='控制台' WHERE `name`='dashboard';
UPDATE `fa_auth_rule` SET `title`='常规管理' WHERE `name`='general';
UPDATE `fa_auth_rule` SET `title`='分类管理' WHERE `name`='category';
UPDATE `fa_auth_rule` SET `title`='插件管理' WHERE `name`='addon';
UPDATE `fa_auth_rule` SET `title`='权限管理' WHERE `name`='auth';
UPDATE `fa_auth_rule` SET `title`='会员管理' WHERE `name`='user';
UPDATE `fa_auth_rule` SET `title`='系统配置' WHERE `name`='general/config';
UPDATE `fa_auth_rule` SET `title`='附件管理' WHERE `name`='general/attachment';
UPDATE `fa_auth_rule` SET `title`='个人资料' WHERE `name`='general/profile';
UPDATE `fa_auth_rule` SET `title`='管理员管理' WHERE `name`='auth/admin';
UPDATE `fa_auth_rule` SET `title`='管理员日志' WHERE `name`='auth/adminlog';
UPDATE `fa_auth_rule` SET `title`='角色组' WHERE `name`='auth/group';
UPDATE `fa_auth_rule` SET `title`='菜单规则' WHERE `name`='auth/rule';
UPDATE `fa_auth_rule` SET `title`='会员' WHERE `name`='user/user';
UPDATE `fa_auth_rule` SET `title`='会员分组' WHERE `name`='user/group';
UPDATE `fa_auth_rule` SET `title`='会员规则' WHERE `name`='user/rule';
UPDATE `fa_auth_rule` SET `title`='选择附件' WHERE `name`='general/attachment/select';
UPDATE `fa_auth_rule` SET `title`='更新个人信息' WHERE `name`='general/profile/update';
UPDATE `fa_auth_rule` SET `title`='本地插件' WHERE `name`='addon/downloaded';
UPDATE `fa_auth_rule` SET `title`='禁用启用' WHERE `name`='addon/state';
UPDATE `fa_auth_rule` SET `title`='配置' WHERE `name`='addon/config';
UPDATE `fa_auth_rule` SET `title`='刷新' WHERE `name`='addon/refresh';
UPDATE `fa_auth_rule` SET `title`='详情' WHERE `name`='auth/adminlog/detail';

UPDATE `fa_auth_rule` SET `title`='查看' WHERE `title`='View';
UPDATE `fa_auth_rule` SET `title`='添加' WHERE `title`='Add';
UPDATE `fa_auth_rule` SET `title`='编辑' WHERE `title`='Edit';
UPDATE `fa_auth_rule` SET `title`='删除' WHERE `title` IN ('Delete','Del');
UPDATE `fa_auth_rule` SET `title`='批量更新' WHERE `title`='Multi';
UPDATE `fa_auth_rule` SET `title`='导入' WHERE `title`='Import';

UPDATE `fa_auth_group` SET `name`='超级管理组' WHERE `id`=1 AND `name`='Admin group';
UPDATE `fa_auth_group` SET `name`='二级管理组' WHERE `id`=2 AND `name`='Second group';
UPDATE `fa_auth_group` SET `name`='三级管理组' WHERE `id`=3 AND `name`='Third group';
UPDATE `fa_auth_group` SET `name`='二级管理组2' WHERE `id`=4 AND `name`='Second group 2';
UPDATE `fa_auth_group` SET `name`='三级管理组2' WHERE `id`=5 AND `name`='Third group 2';

-- ----------------------------
-- 流程单管理提到控制台下方
-- ----------------------------
UPDATE `fa_auth_rule` SET `title`='流程单管理', `icon`='fa fa-clipboard', `weigh`=140 WHERE `name`='ps';

-- ----------------------------
-- 功能分组（无对应控制器，仅作父级菜单）
-- ----------------------------
SET @psid = (SELECT `id` FROM `fa_auth_rule` WHERE `name`='ps' LIMIT 1);

INSERT INTO `fa_auth_rule` (`type`,`pid`,`name`,`title`,`icon`,`ismenu`,`status`,`weigh`,`createtime`,`updatetime`)
SELECT 'file', @psid, 'ps/group_factory', '工厂管理', 'fa fa-university', 1, 'normal', 86, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
FROM DUAL WHERE @psid IS NOT NULL AND NOT EXISTS (SELECT 1 FROM `fa_auth_rule` WHERE `name`='ps/group_factory');

INSERT INTO `fa_auth_rule` (`type`,`pid`,`name`,`title`,`icon`,`ismenu`,`status`,`weigh`,`createtime`,`updatetime`)
SELECT 'file', @psid, 'ps/group_template', '模板管理', 'fa fa-file-text-o', 1, 'normal', 85, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
FROM DUAL WHERE @psid IS NOT NULL AND NOT EXISTS (SELECT 1 FROM `fa_auth_rule` WHERE `name`='ps/group_template');

INSERT INTO `fa_auth_rule` (`type`,`pid`,`name`,`title`,`icon`,`ismenu`,`status`,`weigh`,`createtime`,`updatetime`)
SELECT 'file', @psid, 'ps/group_produce', '生产管理', 'fa fa-cubes', 1, 'normal', 84, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
FROM DUAL WHERE @psid IS NOT NULL AND NOT EXISTS (SELECT 1 FROM `fa_auth_rule` WHERE `name`='ps/group_produce');

INSERT INTO `fa_auth_rule` (`type`,`pid`,`name`,`title`,`icon`,`ismenu`,`status`,`weigh`,`createtime`,`updatetime`)
SELECT 'file', @psid, 'ps/group_print', '打印管理', 'fa fa-print', 1, 'normal', 83, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
FROM DUAL WHERE @psid IS NOT NULL AND NOT EXISTS (SELECT 1 FROM `fa_auth_rule` WHERE `name`='ps/group_print');

INSERT INTO `fa_auth_rule` (`type`,`pid`,`name`,`title`,`icon`,`ismenu`,`status`,`weigh`,`createtime`,`updatetime`)
SELECT 'file', @psid, 'ps/group_mall', '模板商城', 'fa fa-shopping-cart', 1, 'normal', 82, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
FROM DUAL WHERE @psid IS NOT NULL AND NOT EXISTS (SELECT 1 FROM `fa_auth_rule` WHERE `name`='ps/group_mall');

INSERT INTO `fa_auth_rule` (`type`,`pid`,`name`,`title`,`icon`,`ismenu`,`status`,`weigh`,`createtime`,`updatetime`)
SELECT 'file', @psid, 'ps/group_pay', '支付管理', 'fa fa-credit-card', 1, 'normal', 81, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
FROM DUAL WHERE @psid IS NOT NULL AND NOT EXISTS (SELECT 1 FROM `fa_auth_rule` WHERE `name`='ps/group_pay');

-- ----------------------------
-- 子菜单挂到对应分组，去掉「流程单-」前缀
-- ----------------------------
UPDATE `fa_auth_rule` a
JOIN `fa_auth_rule` p ON p.name='ps/group_factory'
SET a.pid=p.id, a.title='工厂', a.weigh=30
WHERE a.name='ps/factory';

UPDATE `fa_auth_rule` a
JOIN `fa_auth_rule` p ON p.name='ps/group_factory'
SET a.pid=p.id, a.title='积分流水', a.weigh=20
WHERE a.name='ps/factory_score_log';

UPDATE `fa_auth_rule` a
JOIN `fa_auth_rule` p ON p.name='ps/group_factory'
SET a.pid=p.id, a.title='字段字典', a.weigh=10
WHERE a.name='ps/field_dict';

INSERT INTO `fa_auth_rule` (`type`,`pid`,`name`,`title`,`icon`,`ismenu`,`status`,`weigh`,`createtime`,`updatetime`)
SELECT 'file', p.id, 'ps/home_block', '工厂端首页', 'fa fa-home', 1, 'normal', 40, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
FROM `fa_auth_rule` p
WHERE p.name='ps/group_factory'
AND NOT EXISTS (SELECT 1 FROM `fa_auth_rule` WHERE `name`='ps/home_block');

INSERT INTO `fa_auth_rule` (`type`,`pid`,`name`,`title`,`icon`,`ismenu`,`status`,`weigh`,`createtime`,`updatetime`)
SELECT 'file', a.id, 'ps/home_block/index', '查看', 'fa fa-circle-o', 0, 'normal', 0, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
FROM `fa_auth_rule` a
WHERE a.name='ps/home_block'
AND NOT EXISTS (SELECT 1 FROM `fa_auth_rule` WHERE `name`='ps/home_block/index');

INSERT INTO `fa_auth_rule` (`type`,`pid`,`name`,`title`,`icon`,`ismenu`,`status`,`weigh`,`createtime`,`updatetime`)
SELECT 'file', a.id, 'ps/home_block/add', '添加', 'fa fa-circle-o', 0, 'normal', 0, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
FROM `fa_auth_rule` a
WHERE a.name='ps/home_block'
AND NOT EXISTS (SELECT 1 FROM `fa_auth_rule` WHERE `name`='ps/home_block/add');

INSERT INTO `fa_auth_rule` (`type`,`pid`,`name`,`title`,`icon`,`ismenu`,`status`,`weigh`,`createtime`,`updatetime`)
SELECT 'file', a.id, 'ps/home_block/edit', '编辑', 'fa fa-circle-o', 0, 'normal', 0, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
FROM `fa_auth_rule` a
WHERE a.name='ps/home_block'
AND NOT EXISTS (SELECT 1 FROM `fa_auth_rule` WHERE `name`='ps/home_block/edit');

INSERT INTO `fa_auth_rule` (`type`,`pid`,`name`,`title`,`icon`,`ismenu`,`status`,`weigh`,`createtime`,`updatetime`)
SELECT 'file', a.id, 'ps/home_block/del', '删除', 'fa fa-circle-o', 0, 'normal', 0, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
FROM `fa_auth_rule` a
WHERE a.name='ps/home_block'
AND NOT EXISTS (SELECT 1 FROM `fa_auth_rule` WHERE `name`='ps/home_block/del');

INSERT INTO `fa_auth_rule` (`type`,`pid`,`name`,`title`,`icon`,`ismenu`,`status`,`weigh`,`createtime`,`updatetime`)
SELECT 'file', a.id, 'ps/home_block/multi', '批量更新', 'fa fa-circle-o', 0, 'normal', 0, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
FROM `fa_auth_rule` a
WHERE a.name='ps/home_block'
AND NOT EXISTS (SELECT 1 FROM `fa_auth_rule` WHERE `name`='ps/home_block/multi');

UPDATE `fa_auth_rule` a
JOIN `fa_auth_rule` p ON p.name='ps/group_template'
SET a.pid=p.id, a.title='模板', a.weigh=30
WHERE a.name='ps/template';

UPDATE `fa_auth_rule` a
JOIN `fa_auth_rule` p ON p.name='ps/group_template'
SET a.pid=p.id, a.title='模板版本', a.weigh=20
WHERE a.name='ps/template_version';

UPDATE `fa_auth_rule` a
JOIN `fa_auth_rule` p ON p.name='ps/group_template'
SET a.pid=p.id, a.title='AI识版', a.weigh=10
WHERE a.name='ps/ai_job';

INSERT INTO `fa_auth_rule` (`type`,`pid`,`name`,`title`,`icon`,`ismenu`,`status`,`weigh`,`createtime`,`updatetime`)
SELECT 'file', p.id, 'ps/llm', '大模型设置', 'fa fa-cloud', 1, 'normal', 15, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
FROM `fa_auth_rule` p
WHERE p.name='ps/group_template'
AND NOT EXISTS (SELECT 1 FROM `fa_auth_rule` WHERE `name`='ps/llm');

INSERT INTO `fa_auth_rule` (`type`,`pid`,`name`,`title`,`icon`,`ismenu`,`status`,`weigh`,`createtime`,`updatetime`)
SELECT 'file', a.id, 'ps/llm/testLocal', '测试本地模型', 'fa fa-circle-o', 0, 'normal', 0, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
FROM `fa_auth_rule` a
WHERE a.name='ps/llm'
AND NOT EXISTS (SELECT 1 FROM `fa_auth_rule` WHERE `name`='ps/llm/testLocal');

INSERT INTO `fa_auth_rule` (`type`,`pid`,`name`,`title`,`icon`,`ismenu`,`status`,`weigh`,`createtime`,`updatetime`)
SELECT 'file', a.id, 'ps/llm/testOnline', '测试线上模型', 'fa fa-circle-o', 0, 'normal', 0, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
FROM `fa_auth_rule` a
WHERE a.name='ps/llm'
AND NOT EXISTS (SELECT 1 FROM `fa_auth_rule` WHERE `name`='ps/llm/testOnline');

INSERT INTO `fa_auth_rule` (`type`,`pid`,`name`,`title`,`icon`,`ismenu`,`status`,`weigh`,`createtime`,`updatetime`)
SELECT 'file', a.id, 'ps/ai_job/run', '开始识别', 'fa fa-circle-o', 0, 'normal', 0, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
FROM `fa_auth_rule` a
WHERE a.name='ps/ai_job'
AND NOT EXISTS (SELECT 1 FROM `fa_auth_rule` WHERE `name`='ps/ai_job/run');

UPDATE `fa_auth_rule` a
JOIN `fa_auth_rule` p ON p.name='ps/group_produce'
SET a.pid=p.id, a.title='产品', a.weigh=40
WHERE a.name='ps/product';

UPDATE `fa_auth_rule` a
JOIN `fa_auth_rule` p ON p.name='ps/group_produce'
SET a.pid=p.id, a.title='产品工序', a.weigh=30
WHERE a.name='ps/product_process';

UPDATE `fa_auth_rule` a
JOIN `fa_auth_rule` p ON p.name='ps/group_produce'
SET a.pid=p.id, a.title='工单', a.weigh=20
WHERE a.name='ps/workorder';

UPDATE `fa_auth_rule` a
JOIN `fa_auth_rule` p ON p.name='ps/group_produce'
SET a.pid=p.id, a.title='工单工序', a.weigh=10
WHERE a.name='ps/workorder_process';

UPDATE `fa_auth_rule` a
JOIN `fa_auth_rule` p ON p.name='ps/group_print'
SET a.pid=p.id, a.title='打印任务', a.weigh=20
WHERE a.name='ps/print_job';

UPDATE `fa_auth_rule` a
JOIN `fa_auth_rule` p ON p.name='ps/group_print'
SET a.pid=p.id, a.title='打印快照', a.weigh=10
WHERE a.name='ps/print_snapshot';

UPDATE `fa_auth_rule` a
JOIN `fa_auth_rule` p ON p.name='ps/group_mall'
SET a.pid=p.id, a.title='模板商品', a.weigh=30
WHERE a.name='ps/market_goods';

UPDATE `fa_auth_rule` a
JOIN `fa_auth_rule` p ON p.name='ps/group_mall'
SET a.pid=p.id, a.title='模板订单', a.weigh=20
WHERE a.name='ps/market_order';

UPDATE `fa_auth_rule` a
JOIN `fa_auth_rule` p ON p.name='ps/group_mall'
SET a.pid=p.id, a.title='模板授权', a.weigh=10
WHERE a.name='ps/market_license';

UPDATE `fa_auth_rule` a
JOIN `fa_auth_rule` p ON p.name='ps/group_pay'
SET a.pid=p.id, a.title='支付单', a.weigh=10
WHERE a.name='ps/pay_order';

-- ----------------------------
-- 系统配置分组中文
-- ----------------------------
UPDATE `fa_config` SET `value`='{"basic":"基础配置","email":"邮件配置","dictionary":"字典配置","user":"会员配置","example":"示例分组","ps":"流程单","llm":"大模型"}' WHERE `name`='configgroup';
UPDATE `fa_config` SET `value`='{"default":"默认","page":"单页","article":"文章","test":"测试"}' WHERE `name`='categorytype';
UPDATE `fa_config` SET `value`='{"category1":"分类1","category2":"分类2","custom":"自定义"}' WHERE `name`='attachmentcategory';
UPDATE `fa_config` SET `value`='1.0.2' WHERE `name`='version';