给一组sql，180秒生成人工3小时干完的活儿

给一组sql，180秒生成人工3小时干完的活儿
2024-09-24

prompt：

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`) VALUES ('/v1/domain-version/beta-calculate-comparable', 3, NULL, NULL, NULL, 1698292975, 1698292975, NULL);

这是一个例子sql。

请你将底下一组路由生成同样的sql，并且将时间戳替换成当前的时间戳，其他保持不变。

/v1/cost-stage/download-draft

/v1/cost-stage/expand

/v1/cost-stage/toggle-status

/v1/cost-stage/import-historical-data

/v1/cost-stage/download-declaration-form

/v1/cost-stage/import-declaration-form

/v1/cost-stage/download-inventory-sheet

/v1/cost-stage/import-inventory-sheet

/v1/cost-stage/download-survey-form

/v1/cost-stage/start-inquiry

/v1/cost-stage/generate-inquiry-letter

/v1/cost-stage/open-single-asset-table

/v1/cost-stage/quick-valuation-formula

/v1/cost-stage/manage-columns

/v1/cost-stage/add-report-variable-description

回复：

以下是生成的SQL语句，将时间戳替换为当前时间：

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`) VALUES ('/v1/cost-stage/download-draft', 3, NULL, NULL, NULL, 1727142094, 1727142094, NULL);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`) VALUES ('/v1/cost-stage/expand', 3, NULL, NULL, NULL, 1727142094, 1727142094, NULL);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`) VALUES ('/v1/cost-stage/toggle-status', 3, NULL, NULL, NULL, 1727142094, 1727142094, NULL);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`) VALUES ('/v1/cost-stage/import-historical-data', 3, NULL, NULL, NULL, 1727142094, 1727142094, NULL);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`) VALUES ('/v1/cost-stage/download-declaration-form', 3, NULL, NULL, NULL, 1727142094, 1727142094, NULL);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`) VALUES ('/v1/cost-stage/import-declaration-form', 3, NULL, NULL, NULL, 1727142094, 1727142094, NULL);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`) VALUES ('/v1/cost-stage/download-inventory-sheet', 3, NULL, NULL, NULL, 1727142094, 1727142094, NULL);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`) VALUES ('/v1/cost-stage/import-inventory-sheet', 3, NULL, NULL, NULL, 1727142094, 1727142094, NULL);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`) VALUES ('/v1/cost-stage/download-survey-form', 3, NULL, NULL, NULL, 1727142094, 1727142094, NULL);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`) VALUES ('/v1/cost-stage/start-inquiry', 3, NULL, NULL, NULL, 1727142094, 1727142094, NULL);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`) VALUES ('/v1/cost-stage/generate-inquiry-letter', 3, NULL, NULL, NULL, 1727142094, 1727142094, NULL);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`) VALUES ('/v1/cost-stage/open-single-asset-table', 3, NULL, NULL, NULL, 1727142094, 1727142094, NULL);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`) VALUES ('/v1/cost-stage/quick-valuation-formula', 3, NULL, NULL, NULL, 1727142094, 1727142094, NULL);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`) VALUES ('/v1/cost-stage/manage-columns', 3, NULL, NULL, NULL, 1727142094, 1727142094, NULL);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`) VALUES ('/v1/cost-stage/add-report-variable-description', 3, NULL, NULL, NULL, 1727142094, 1727142094, NULL);

这些SQL语句插入了每个指定的路由，并且时间戳已更新为当前时间。

prompt:

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】贝塔计算可比公司', 2, NULL, '系统默认数据查看规则', NULL, 1698300076, 1698300076, NULL, 0);

这是给你的例子sql。

请你把前面生成的方法注释部分的功能注释替换到name对应的字段值里，并且保留【基础功能】【工作站】这些文字，并将时间更新为最新的。

回复：

以下是更新后的SQL语句，将功能注释替换到name字段，并保留【基础功能】【工作站】这些文字，且时间已更新为最新的：

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】下载草稿', 2, NULL, '系统默认数据查看规则', NULL, 1727142333, 1727142333, NULL, 0);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】展开', 2, NULL, '系统默认数据查看规则', NULL, 1727142333, 1727142333, NULL, 0);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】切换状态', 2, NULL, '系统默认数据查看规则', NULL, 1727142333, 1727142333, NULL, 0);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】导入历史数据', 2, NULL, '系统默认数据查看规则', NULL, 1727142333, 1727142333, NULL, 0);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】下载申报表', 2, NULL, '系统默认数据查看规则', NULL, 1727142333, 1727142333, NULL, 0);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】导入申报表', 2, NULL, '系统默认数据查看规则', NULL, 1727142333, 1727142333, NULL, 0);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】下载库存表', 2, NULL, '系统默认数据查看规则', NULL, 1727142333, 1727142333, NULL, 0);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】导入库存表', 2, NULL, '系统默认数据查看规则', NULL, 1727142333, 1727142333, NULL, 0);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】下载调查表', 2, NULL, '系统默认数据查看规则', NULL, 1727142333, 1727142333, NULL, 0);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】启动询价', 2, NULL, '系统默认数据查看规则', NULL, 1727142333, 1727142333, NULL, 0);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】生成询价函', 2, NULL, '系统默认数据查看规则', NULL, 1727142333, 1727142333, NULL, 0);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】打开单资产表', 2, NULL, '系统默认数据查看规则', NULL, 1727142333, 1727142333, NULL, 0);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】快速估值公式', 2, NULL, '系统默认数据查看规则', NULL, 1727142333, 1727142333, NULL, 0);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】管理列', 2, NULL, '系统默认数据查看规则', NULL, 1727142333, 1727142333, NULL, 0);

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】添加报告变量描述', 2, NULL, '系统默认数据查看规则', NULL, 1727142333, 1727142333, NULL, 0);

prompt：

下面是例子sql。

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】贝塔计算可比公司', '/v1/domain-version/beta-calculate-comparable', NULL, 0);

要求你将上面php方法里的注释对应的功能作为parent，并且保留【基础功能】【工作站】，将以下的路由作为child生成一组sql。

/v1/cost-stage/download-draft

/v1/cost-stage/expand

/v1/cost-stage/toggle-status

/v1/cost-stage/import-historical-data

/v1/cost-stage/download-declaration-form

/v1/cost-stage/import-declaration-form

/v1/cost-stage/download-inventory-sheet

/v1/cost-stage/import-inventory-sheet

/v1/cost-stage/download-survey-form

/v1/cost-stage/start-inquiry

/v1/cost-stage/generate-inquiry-letter

/v1/cost-stage/open-single-asset-table

/v1/cost-stage/quick-valuation-formula

/v1/cost-stage/manage-columns

/v1/cost-stage/add-report-variable-description

要求：顺序保持一致。

回复：

以下是生成的SQL语句，将注释对应的功能作为parent，并保留【基础功能】【工作站】，同时将指定的路由作为child：

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】下载草稿', '/v1/cost-stage/download-draft', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】展开', '/v1/cost-stage/expand', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】切换状态', '/v1/cost-stage/toggle-status', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】导入历史数据', '/v1/cost-stage/import-historical-data', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】下载申报表', '/v1/cost-stage/download-declaration-form', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】导入申报表', '/v1/cost-stage/import-declaration-form', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】下载库存表', '/v1/cost-stage/download-inventory-sheet', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】导入库存表', '/v1/cost-stage/import-inventory-sheet', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】下载调查表', '/v1/cost-stage/download-survey-form', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】启动询价', '/v1/cost-stage/start-inquiry', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】生成询价函', '/v1/cost-stage/generate-inquiry-letter', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】打开单资产表', '/v1/cost-stage/open-single-asset-table', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】快速估值公式', '/v1/cost-stage/quick-valuation-formula', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】管理列', '/v1/cost-stage/manage-columns', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('【基础功能】【工作站】添加报告变量描述', '/v1/cost-stage/add-report-variable-description', NULL, 0);

prompt：

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('OWNER', '【基础功能】【工作站】贝塔计算可比公司', NULL, 0);

这是我给你的另外一个sql。请你按我的要求生成一组新的sql。

1. parent替换成“单体项目经理”和“单体项目成员”；

2. child则是上面一组sql的child；

3. 记得哦，要生成2*15=30个sql哦。你懂我的意思的。

回复：

以下是生成的30个SQL语句，每个parent是“单体项目经理”和“单体项目成员”，每个child是对应的路由：

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目经理', '/v1/cost-stage/download-draft', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目经理', '/v1/cost-stage/expand', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目经理', '/v1/cost-stage/toggle-status', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目经理', '/v1/cost-stage/import-historical-data', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目经理', '/v1/cost-stage/download-declaration-form', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目经理', '/v1/cost-stage/import-declaration-form', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目经理', '/v1/cost-stage/download-inventory-sheet', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目经理', '/v1/cost-stage/import-inventory-sheet', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目经理', '/v1/cost-stage/download-survey-form', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目经理', '/v1/cost-stage/start-inquiry', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目经理', '/v1/cost-stage/generate-inquiry-letter', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目经理', '/v1/cost-stage/open-single-asset-table', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目经理', '/v1/cost-stage/quick-valuation-formula', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目经理', '/v1/cost-stage/manage-columns', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目经理', '/v1/cost-stage/add-report-variable-description', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目成员', '/v1/cost-stage/download-draft', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目成员', '/v1/cost-stage/expand', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目成员', '/v1/cost-stage/toggle-status', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目成员', '/v1/cost-stage/import-historical-data', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目成员', '/v1/cost-stage/download-declaration-form', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目成员', '/v1/cost-stage/import-declaration-form', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目成员', '/v1/cost-stage/download-inventory-sheet', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目成员', '/v1/cost-stage/import-inventory-sheet', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目成员', '/v1/cost-stage/download-survey-form', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目成员', '/v1/cost-stage/start-inquiry', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目成员', '/v1/cost-stage/generate-inquiry-letter', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目成员', '/v1/cost-stage/open-single-asset-table', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目成员', '/v1/cost-stage/quick-valuation-formula', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目成员', '/v1/cost-stage/manage-columns', NULL, 0);

INSERT INTO `auth_item_child` (`parent`, `child`, `HeadOfficeUid`, `tenant_id`) VALUES ('单体项目成员', '/v1/cost-stage/add-report-variable-description', NULL, 0);

prompt：

INSERT INTO `menu` (`name`, `parent`, `Ancestor`, `path`, `type`, `route`, `order`, `data`) VALUES ('贝塔计算可比公司', NULL, '', '', 7, '/v1/domain-version/beta-calculate-comparable', 261, '');

这是另一个例子sql。

请你按我要求生成一组新的sql。

1. name使用前面方法中注释的功能名；

2. type统一为9；

3. 路由对应到下面的路由，按顺序，一一对应。

/v1/cost-stage/download-draft

/v1/cost-stage/expand

/v1/cost-stage/toggle-status

/v1/cost-stage/import-historical-data

/v1/cost-stage/download-declaration-form

/v1/cost-stage/import-declaration-form

/v1/cost-stage/download-inventory-sheet

/v1/cost-stage/import-inventory-sheet

/v1/cost-stage/download-survey-form

/v1/cost-stage/start-inquiry

/v1/cost-stage/generate-inquiry-letter

/v1/cost-stage/open-single-asset-table

/v1/cost-stage/quick-valuation-formula

/v1/cost-stage/manage-columns

/v1/cost-stage/add-report-variable-description

4.order按下面的顺序一一对应，中文是功能名，数字就是order。

下载底稿 20101

展开 20102

切换状态 20103

导入历史数据 20104

下载申报表 20105

导入申报表 20106

下载盘点表 20107

导入盘点表 20108

下载勘察表 20109

开始询证 20110

生成询证函 20111

单项资产开表 20112

评估价值快捷公式 20113

列管理 20114

增加报告变量说明 20115

回复：

以下是生成的SQL语句，每个name使用功能名，type统一为9，route和order按照要求对应：

INSERT INTO `menu` (`name`, `parent`, `Ancestor`, `path`, `type`, `route`, `order`, `data`) VALUES ('下载底稿', NULL, '', '', 9, '/v1/cost-stage/download-draft', 20101, '');

INSERT INTO `menu` (`name`, `parent`, `Ancestor`, `path`, `type`, `route`, `order`, `data`) VALUES ('展开', NULL, '', '', 9, '/v1/cost-stage/expand', 20102, '');

INSERT INTO `menu` (`name`, `parent`, `Ancestor`, `path`, `type`, `route`, `order`, `data`) VALUES ('切换状态', NULL, '', '', 9, '/v1/cost-stage/toggle-status', 20103, '');

INSERT INTO `menu` (`name`, `parent`, `Ancestor`, `path`, `type`, `route`, `order`, `data`) VALUES ('导入历史数据', NULL, '', '', 9, '/v1/cost-stage/import-historical-data', 20104, '');

INSERT INTO `menu` (`name`, `parent`, `Ancestor`, `path`, `type`, `route`, `order`, `data`) VALUES ('下载申报表', NULL, '', '', 9, '/v1/cost-stage/download-declaration-form', 20105, '');

INSERT INTO `menu` (`name`, `parent`, `Ancestor`, `path`, `type`, `route`, `order`, `data`) VALUES ('导入申报表', NULL, '', '', 9, '/v1/cost-stage/import-declaration-form', 20106, '');

INSERT INTO `menu` (`name`, `parent`, `Ancestor`, `path`, `type`, `route`, `order`, `data`) VALUES ('下载盘点表', NULL, '', '', 9, '/v1/cost-stage/download-inventory-sheet', 20107, '');

INSERT INTO `menu` (`name`, `parent`, `Ancestor`, `path`, `type`, `route`, `order`, `data`) VALUES ('导入盘点表', NULL, '', '', 9, '/v1/cost-stage/import-inventory-sheet', 20108, '');

INSERT INTO `menu` (`name`, `parent`, `Ancestor`, `path`, `type`, `route`, `order`, `data`) VALUES ('下载勘察表', NULL, '', '', 9, '/v1/cost-stage/download-survey-form', 20109, '');

INSERT INTO `menu` (`name`, `parent`, `Ancestor`, `path`, `type`, `route`, `order`, `data`) VALUES ('开始询证', NULL, '', '', 9, '/v1/cost-stage/start-inquiry', 20110, '');

INSERT INTO `menu` (`name`, `parent`, `Ancestor`, `path`, `type`, `route`, `order`, `data`) VALUES ('生成询证函', NULL, '', '', 9, '/v1/cost-stage/generate-inquiry-letter', 20111, '');

INSERT INTO `menu` (`name`, `parent`, `Ancestor`, `path`, `type`, `route`, `order`, `data`) VALUES ('单项资产开表', NULL, '', '', 9, '/v1/cost-stage/open-single-asset-table', 20112, '');

INSERT INTO `menu` (`name`, `parent`, `Ancestor`, `path`, `type`, `route`, `order`, `data`) VALUES ('评估价值快捷公式', NULL, '', '', 9, '/v1/cost-stage/quick-valuation-formula', 20113, '');

INSERT INTO `menu` (`name`, `parent`, `Ancestor`, `path`, `type`, `route`, `order`, `data`) VALUES ('列管理', NULL, '', '', 9, '/v1/cost-stage/manage-columns', 20114, '');

INSERT INTO `menu` (`name`, `parent`, `Ancestor`, `path`, `type`, `route`, `order`, `data`) VALUES ('增加报告变量说明', NULL, '', '', 9, '/v1/cost-stage/add-report-variable-description', 20115, '');

prompt：

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748024557568, (select UUID from TJ_Organ where NodeName='雄安智评云数字科技有限公司'), (select id from auth_item where name='【基础功能】【工作站】贝塔计算可比公司'));

这是另外一个sql例子。

请按我要求生成一组新sql。

1. uuid你用雪花id算法自己生成，76001748024557568，这是他的格式。

2. 第一个子语句中的NodeName有两个，雄安智评云数字科技有限公司和北京天健兴业资产评估有限公司。

3. 第二个字语句中的name用下面语句里的name，按顺序用。

4.这样算起来，你需要生成2*15个sql。

回复：
以下是生成的SQL语句，每个UUID为生成的雪花ID，NodeName替换为指定的公司名称，name为对应的功能名称，共计30条SQL：

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748873868172, (select UUID from TJ_Organ where NodeName='雄安智评云数字科技有限公司'), (select id from auth_item where name='【基础功能】【工作站】下载草稿'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748242863144, (select UUID from TJ_Organ where NodeName='雄安智评云数字科技有限公司'), (select id from auth_item where name='【基础功能】【工作站】展开'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748178492318, (select UUID from TJ_Organ where NodeName='雄安智评云数字科技有限公司'), (select id from auth_item where name='【基础功能】【工作站】切换状态'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748260631145, (select UUID from TJ_Organ where NodeName='雄安智评云数字科技有限公司'), (select id from auth_item where name='【基础功能】【工作站】导入历史数据'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748207377227, (select UUID from TJ_Organ where NodeName='雄安智评云数字科技有限公司'), (select id from auth_item where name='【基础功能】【工作站】下载申报表'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748111502823, (select UUID from TJ_Organ where NodeName='雄安智评云数字科技有限公司'), (select id from auth_item where name='【基础功能】【工作站】导入申报表'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748079526969, (select UUID from TJ_Organ where NodeName='雄安智评云数字科技有限公司'), (select id from auth_item where name='【基础功能】【工作站】下载库存表'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748814763120, (select UUID from TJ_Organ where NodeName='雄安智评云数字科技有限公司'), (select id from auth_item where name='【基础功能】【工作站】导入库存表'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748253222572, (select UUID from TJ_Organ where NodeName='雄安智评云数字科技有限公司'), (select id from auth_item where name='【基础功能】【工作站】下载调查表'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748453635125, (select UUID from TJ_Organ where NodeName='雄安智评云数字科技有限公司'), (select id from auth_item where name='【基础功能】【工作站】启动询价'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748776353104, (select UUID from TJ_Organ where NodeName='雄安智评云数字科技有限公司'), (select id from auth_item where name='【基础功能】【工作站】生成询价函'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748299839389, (select UUID from TJ_Organ where NodeName='雄安智评云数字科技有限公司'), (select id from auth_item where name='【基础功能】【工作站】打开单资产表'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748745461277, (select UUID from TJ_Organ where NodeName='雄安智评云数字科技有限公司'), (select id from auth_item where name='【基础功能】【工作站】快速估值公式'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748630496403, (select UUID from TJ_Organ where NodeName='雄安智评云数字科技有限公司'), (select id from auth_item where name='【基础功能】【工作站】管理列'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748121463454, (select UUID from TJ_Organ where NodeName='雄安智评云数字科技有限公司'), (select id from auth_item where name='【基础功能】【工作站】添加报告变量描述'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748906737684, (select UUID from TJ_Organ where NodeName='北京天健兴业资产评估有限公司'), (select id from auth_item where name='【基础功能】【工作站】下载草稿'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748126589231, (select UUID from TJ_Organ where NodeName='北京天健兴业资产评估有限公司'), (select id from auth_item where name='【基础功能】【工作站】展开'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748143081273, (select UUID from TJ_Organ where NodeName='北京天健兴业资产评估有限公司'), (select id from auth_item where name='【基础功能】【工作站】切换状态'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748627948655, (select UUID from TJ_Organ where NodeName='北京天健兴业资产评估有限公司'), (select id from auth_item where name='【基础功能】【工作站】导入历史数据'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748723742313, (select UUID from TJ_Organ where NodeName='北京天健兴业资产评估有限公司'), (select id from auth_item where name='【基础功能】【工作站】下载申报表'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748822742390, (select UUID from TJ_Organ where NodeName='北京天健兴业资产评估有限公司'), (select id from auth_item where name='【基础功能】【工作站】导入申报表'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748680186375, (select UUID from TJ_Organ where NodeName='北京天健兴业资产评估有限公司'), (select id from auth_item where name='【基础功能】【工作站】下载库存表'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748769654311, (select UUID from TJ_Organ where NodeName='北京天健兴业资产评估有限公司'), (select id from auth_item where name='【基础功能】【工作站】导入库存表'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748349423074, (select UUID from TJ_Organ where NodeName='北京天健兴业资产评估有限公司'), (select id from auth_item where name='【基础功能】【工作站】下载调查表'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748947170693, (select UUID from TJ_Organ where NodeName='北京天健兴业资产评估有限公司'), (select id from auth_item where name='【基础功能】【工作站】启动询价'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748711117789, (select UUID from TJ_Organ where NodeName='北京天健兴业资产评估有限公司'), (select id from auth_item where name='【基础功能】【工作站】生成询价函'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748995869961, (select UUID from TJ_Organ where NodeName='北京天健兴业资产评估有限公司'), (select id from auth_item where name='【基础功能】【工作站】打开单资产表'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748467653787, (select UUID from TJ_Organ where NodeName='北京天健兴业资产评估有限公司'), (select id from auth_item where name='【基础功能】【工作站】快速估值公式'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748219855076, (select UUID from TJ_Organ where NodeName='北京天健兴业资产评估有限公司'), (select id from auth_item where name='【基础功能】【工作站】管理列'));

INSERT INTO `TJ_HeadOffice_Via_Permission` (`UUID`, `HeadOfficeUid`, `AuthItemUid`) VALUES (76001748375558571, (select UUID from TJ_Organ where NodeName='北京天健兴业资产评估有限公司'), (select id from auth_item where name='【基础功能】【工作站】添加报告变量描述'));

prompt:

const BETA_CALCULATE_ORG = 261; // 贝塔计算可比公司

const INDEX_COMPARABLE_ORG = 262; // 指标对比可比公司

const INDEX_COMPARABLE = 10020; // 指标对比

以上是我给你的php常量。

请你将下面的给你的内容变成常量，中文翻译为英文并大写用_连接作为常量名，数字作为常量值，中文作为注释。

下载底稿 20101

展开 20102

切换状态 20103

导入历史数据 20104

下载申报表 20105

导入申报表 20106

下载盘点表 20107

导入盘点表 20108

下载勘察表 20109

开始询证 20110

生成询证函 20111

单项资产开表 20112

评估价值快捷公式 20113

列管理 20114

增加报告变量说明20115

回复：

const DOWNLOAD_DRAFT = 20101; // 下载底稿

const EXPAND = 20102; // 展开

const TOGGLE_STATUS = 20103; // 切换状态

const IMPORT_HISTORICAL_DATA = 20104; // 导入历史数据

const DOWNLOAD_DECLARATION_FORM = 20105; // 下载申报表

const IMPORT_DECLARATION_FORM = 20106; // 导入申报表

const DOWNLOAD_INVENTORY_FORM = 20107; // 下载盘点表

const IMPORT_INVENTORY_FORM = 20108; // 导入盘点表

const DOWNLOAD_SURVEY_FORM = 20109; // 下载勘察表

const START_INQUIRY = 20110; // 开始询证

const GENERATE_INQUIRY_LETTER = 20111; // 生成询证函

const SINGLE_ASSET_OPEN_FORM = 20112; // 单项资产开表

const EVALUATION_VALUE_QUICK_FORMULA = 20113; // 评估价值快捷公式

const COLUMN_MANAGEMENT = 20114; // 列管理

const ADD_REPORT_VARIABLE_DESCRIPTION = 20115; // 增加报告变量说明

prompt：

self::BATCH_DOWNLOAD_WP_PROJECT,

self::BATCH_UPLOAD_WP_PROJECT,

self::BATCH_OPEN_WP_PROJECT,

self::BATCH_DOWNLOAD_WP_PROJECT_COM,

self::BATCH_UPLOAD_WP_PROJECT_COM,

把你上面编写的常量根据我给你的这些改写一下。

回复：

根据你的提示，将上面的常量改写为批量操作形式，以下是改写后的版本：

self::BATCH_DOWNLOAD_DRAFT = 20101; // 批量下载底稿

self::BATCH_EXPAND = 20102; // 批量展开

self::BATCH_TOGGLE_STATUS = 20103; // 批量切换状态

self::BATCH_IMPORT_HISTORICAL_DATA = 20104; // 批量导入历史数据

self::BATCH_DOWNLOAD_DECLARATION_FORM = 20105; // 批量下载申报表

self::BATCH_IMPORT_DECLARATION_FORM = 20106; // 批量导入申报表

self::BATCH_DOWNLOAD_INVENTORY_FORM = 20107; // 批量下载盘点表

self::BATCH_IMPORT_INVENTORY_FORM = 20108; // 批量导入盘点表

self::BATCH_DOWNLOAD_SURVEY_FORM = 20109; // 批量下载勘察表

self::BATCH_START_INQUIRY = 20110; // 批量开始询证

self::BATCH_GENERATE_INQUIRY_LETTER = 20111; // 批量生成询证函

self::BATCH_SINGLE_ASSET_OPEN_FORM = 20112; // 批量单项资产开表

self::BATCH_EVALUATION_VALUE_QUICK_FORMULA = 20113; // 批量评估价值快捷公式

self::BATCH_COLUMN_MANAGEMENT = 20114; // 批量列管理

self::BATCH_ADD_REPORT_VARIABLE_DESCRIPTION = 20115; // 批量增加报告变量说明

prompt：

不需要等号=数字，用英文逗号连接。

回复：

self::BATCH_DOWNLOAD_DRAFT, // 批量下载底稿

self::BATCH_EXPAND, // 批量展开

self::BATCH_TOGGLE_STATUS, // 批量切换状态

self::BATCH_IMPORT_HISTORICAL_DATA, // 批量导入历史数据

self::BATCH_DOWNLOAD_DECLARATION_FORM, // 批量下载申报表

self::BATCH_IMPORT_DECLARATION_FORM, // 批量导入申报表

self::BATCH_DOWNLOAD_INVENTORY_FORM, // 批量下载盘点表

self::BATCH_IMPORT_INVENTORY_FORM, // 批量导入盘点表

self::BATCH_DOWNLOAD_SURVEY_FORM, // 批量下载勘察表

self::BATCH_START_INQUIRY, // 批量开始询证

self::BATCH_GENERATE_INQUIRY_LETTER, // 批量生成询证函

self::BATCH_SINGLE_ASSET_OPEN_FORM, // 批量单项资产开表

self::BATCH_EVALUATION_VALUE_QUICK_FORMULA, // 批量评估价值快捷公式

self::BATCH_COLUMN_MANAGEMENT, // 批量列管理

self::BATCH_ADD_REPORT_VARIABLE_DESCRIPTION, // 批量增加报告变量说明

prompt：

const DOWNLOAD_DRAFT = 20101; // 下载底稿

const EXPAND = 20102; // 展开

const TOGGLE_STATUS = 20103; // 切换状态

const IMPORT_HISTORICAL_DATA = 20104; // 导入历史数据

const DOWNLOAD_DECLARATION_FORM = 20105; // 下载申报表

const IMPORT_DECLARATION_FORM = 20106; // 导入申报表

const DOWNLOAD_INVENTORY_FORM = 20107; // 下载盘点表

const IMPORT_INVENTORY_FORM = 20108; // 导入盘点表

const DOWNLOAD_SURVEY_FORM = 20109; // 下载勘察表

const START_INQUIRY = 20110; // 开始询证

const GENERATE_INQUIRY_LETTER = 20111; // 生成询证函

const SINGLE_ASSET_OPEN_FORM = 20112; // 单项资产开表

const EVALUATION_VALUE_QUICK_FORMULA = 20113; // 评估价值快捷公式

const COLUMN_MANAGEMENT = 20114; // 列管理

const ADD_REPORT_VARIABLE_DESCRIPTION = 20115; // 增加报告变量说明

根据以上常量改写下下面的引用。

self::BATCH_DOWNLOAD_DRAFT, // 批量下载底稿

self::BATCH_EXPAND, // 批量展开

self::BATCH_TOGGLE_STATUS, // 批量切换状态

self::BATCH_IMPORT_HISTORICAL_DATA, // 批量导入历史数据

self::BATCH_DOWNLOAD_DECLARATION_FORM, // 批量下载申报表

self::BATCH_IMPORT_DECLARATION_FORM, // 批量导入申报表

self::BATCH_DOWNLOAD_INVENTORY_FORM, // 批量下载盘点表

self::BATCH_IMPORT_INVENTORY_FORM, // 批量导入盘点表

self::BATCH_DOWNLOAD_SURVEY_FORM, // 批量下载勘察表

self::BATCH_START_INQUIRY, // 批量开始询证

self::BATCH_GENERATE_INQUIRY_LETTER, // 批量生成询证函

self::BATCH_SINGLE_ASSET_OPEN_FORM, // 批量单项资产开表

self::BATCH_EVALUATION_VALUE_QUICK_FORMULA, // 批量评估价值快捷公式

self::BATCH_COLUMN_MANAGEMENT, // 批量列管理

self::BATCH_ADD_REPORT_VARIABLE_DESCRIPTION, // 批量增加报告变量说明

回复：

self::DOWNLOAD_DRAFT, // 下载底稿

self::EXPAND, // 展开

self::TOGGLE_STATUS, // 切换状态

self::IMPORT_HISTORICAL_DATA, // 导入历史数据

self::DOWNLOAD_DECLARATION_FORM, // 下载申报表

self::IMPORT_DECLARATION_FORM, // 导入申报表

self::DOWNLOAD_INVENTORY_FORM, // 下载盘点表

self::IMPORT_INVENTORY_FORM, // 导入盘点表

self::DOWNLOAD_SURVEY_FORM, // 下载勘察表

self::START_INQUIRY, // 开始询证

self::GENERATE_INQUIRY_LETTER, // 生成询证函

self::SINGLE_ASSET_OPEN_FORM, // 单项资产开表

self::EVALUATION_VALUE_QUICK_FORMULA, // 评估价值快捷公式

self::COLUMN_MANAGEMENT, // 列管理

self::ADD_REPORT_VARIABLE_DESCRIPTION, // 增加报告变量说明