151 lines
6.1 KiB
PHP
151 lines
6.1 KiB
PHP
|
<?php
|
||
|
|
|
||
|
|
namespace Database\Seeders;
|
||
|
|
|
||
|
|
use App\Models\Category;
|
||
|
|
use Illuminate\Database\Seeder;
|
||
|
|
|
||
|
|
class CategorySeeder extends Seeder
|
||
|
|
{
|
||
|
|
/**
|
||
|
|
* Run the database seeds.
|
||
|
|
*/
|
||
|
|
public function run(): void
|
||
|
|
{
|
||
|
|
$categories = [
|
||
|
|
[
|
||
|
|
'name' => '写作与内容',
|
||
|
|
'slug' => 'writing',
|
||
|
|
'description' => 'AI 写作与内容生产工具',
|
||
|
|
'children' => [
|
||
|
|
['name' => 'AI 写作', 'slug' => 'ai-writing'],
|
||
|
|
['name' => '改写润色', 'slug' => 'rewriting'],
|
||
|
|
['name' => '摘要与笔记', 'slug' => 'summaries'],
|
||
|
|
['name' => '文案营销', 'slug' => 'copywriting'],
|
||
|
|
],
|
||
|
|
],
|
||
|
|
[
|
||
|
|
'name' => '设计与图像',
|
||
|
|
'slug' => 'design',
|
||
|
|
'description' => '视觉设计与图像处理',
|
||
|
|
'children' => [
|
||
|
|
['name' => '图像生成', 'slug' => 'image-generation'],
|
||
|
|
['name' => '设计工具', 'slug' => 'design-tools'],
|
||
|
|
['name' => '图像修复', 'slug' => 'image-restoration'],
|
||
|
|
['name' => '背景去除', 'slug' => 'background-removal'],
|
||
|
|
],
|
||
|
|
],
|
||
|
|
[
|
||
|
|
'name' => '视频与音频',
|
||
|
|
'slug' => 'media',
|
||
|
|
'description' => '视频与音频内容生产',
|
||
|
|
'children' => [
|
||
|
|
['name' => '视频生成', 'slug' => 'video-generation'],
|
||
|
|
['name' => '视频剪辑', 'slug' => 'video-editing'],
|
||
|
|
['name' => '配音合成', 'slug' => 'voice-over'],
|
||
|
|
['name' => '音频转写', 'slug' => 'audio-transcription'],
|
||
|
|
],
|
||
|
|
],
|
||
|
|
[
|
||
|
|
'name' => '编程与开发',
|
||
|
|
'slug' => 'development',
|
||
|
|
'description' => '面向开发者的 AI 工具',
|
||
|
|
'children' => [
|
||
|
|
['name' => '代码助手', 'slug' => 'code-assistant'],
|
||
|
|
['name' => '低代码', 'slug' => 'low-code'],
|
||
|
|
['name' => 'API 与平台', 'slug' => 'api-platforms'],
|
||
|
|
['name' => '测试与调试', 'slug' => 'testing-debugging'],
|
||
|
|
],
|
||
|
|
],
|
||
|
|
[
|
||
|
|
'name' => '办公与效率',
|
||
|
|
'slug' => 'productivity',
|
||
|
|
'description' => '日常办公与效率工具',
|
||
|
|
'children' => [
|
||
|
|
['name' => '日程与任务', 'slug' => 'tasks'],
|
||
|
|
['name' => '文档协作', 'slug' => 'docs'],
|
||
|
|
['name' => '会议助手', 'slug' => 'meetings'],
|
||
|
|
['name' => '邮件助手', 'slug' => 'email'],
|
||
|
|
],
|
||
|
|
],
|
||
|
|
[
|
||
|
|
'name' => '商业与营销',
|
||
|
|
'slug' => 'business',
|
||
|
|
'description' => '市场与业务增长',
|
||
|
|
'children' => [
|
||
|
|
['name' => '广告创意', 'slug' => 'ads'],
|
||
|
|
['name' => 'SEO 与增长', 'slug' => 'seo-growth'],
|
||
|
|
['name' => '电商运营', 'slug' => 'ecommerce'],
|
||
|
|
['name' => '客户服务', 'slug' => 'customer-support'],
|
||
|
|
],
|
||
|
|
],
|
||
|
|
[
|
||
|
|
'name' => '数据与研究',
|
||
|
|
'slug' => 'research',
|
||
|
|
'description' => '数据分析与研究工具',
|
||
|
|
'children' => [
|
||
|
|
['name' => '数据分析', 'slug' => 'data-analysis'],
|
||
|
|
['name' => '可视化', 'slug' => 'visualization'],
|
||
|
|
['name' => '搜索与洞察', 'slug' => 'insights'],
|
||
|
|
['name' => '研究助手', 'slug' => 'research-assistant'],
|
||
|
|
],
|
||
|
|
],
|
||
|
|
[
|
||
|
|
'name' => '教育与学习',
|
||
|
|
'slug' => 'education',
|
||
|
|
'description' => '学习与教育类工具',
|
||
|
|
'children' => [
|
||
|
|
['name' => '语言学习', 'slug' => 'language-learning'],
|
||
|
|
['name' => '课程与题库', 'slug' => 'courses'],
|
||
|
|
['name' => '学习助手', 'slug' => 'study-assistant'],
|
||
|
|
['name' => '儿童教育', 'slug' => 'kids-education'],
|
||
|
|
],
|
||
|
|
],
|
||
|
|
[
|
||
|
|
'name' => '生产力工具',
|
||
|
|
'slug' => 'automation',
|
||
|
|
'description' => '自动化与工作流',
|
||
|
|
'children' => [
|
||
|
|
['name' => '自动化', 'slug' => 'automation-tools'],
|
||
|
|
['name' => '代理与工作流', 'slug' => 'agents-workflows'],
|
||
|
|
['name' => '集成工具', 'slug' => 'integrations'],
|
||
|
|
['name' => '浏览器插件', 'slug' => 'browser-extensions'],
|
||
|
|
],
|
||
|
|
],
|
||
|
|
[
|
||
|
|
'name' => 'AI 平台与模型',
|
||
|
|
'slug' => 'platforms',
|
||
|
|
'description' => '模型平台与评测工具',
|
||
|
|
'children' => [
|
||
|
|
['name' => '模型平台', 'slug' => 'model-platforms'],
|
||
|
|
['name' => '提示词工具', 'slug' => 'prompt-tools'],
|
||
|
|
['name' => '训练与微调', 'slug' => 'finetuning'],
|
||
|
|
['name' => '模型评测', 'slug' => 'model-evaluation'],
|
||
|
|
],
|
||
|
|
],
|
||
|
|
];
|
||
|
|
|
||
|
|
foreach ($categories as $index => $categoryData) {
|
||
|
|
$parent = Category::updateOrCreate(
|
||
|
|
['slug' => $categoryData['slug']],
|
||
|
|
[
|
||
|
|
'name' => $categoryData['name'],
|
||
|
|
'description' => $categoryData['description'],
|
||
|
|
'sort' => $index + 1,
|
||
|
|
]
|
||
|
|
);
|
||
|
|
|
||
|
|
foreach ($categoryData['children'] as $childIndex => $child) {
|
||
|
|
Category::updateOrCreate(
|
||
|
|
['slug' => $child['slug']],
|
||
|
|
[
|
||
|
|
'name' => $child['name'],
|
||
|
|
'parent_id' => $parent->id,
|
||
|
|
'sort' => $childIndex + 1,
|
||
|
|
]
|
||
|
|
);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|