NN2025112501/database/seeders/StoreCategorySeeder.php

<?php

namespace Database\Seeders;

use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\DB;

/**
 * 商家行业分类数据填充
 */
class StoreCategorySeeder extends Seeder
{
    /**
     * 运行数据填充
     *
     * @return void
     */
    public function run()
    {
        $now = time();

        // 获取表名（带前缀）
        $tableName = DB::getTablePrefix() . 'stores_categorys';

        // 一级分类数据
        $categories = [
            // 一级分类
            ['name' => '餐饮美食', 'pid' => 0, 'sort' => 100, 'status' => 1, 'remark' => '各类餐饮服务'],
            ['name' => '零售百货', 'pid' => 0, 'sort' => 90, 'status' => 1, 'remark' => '各类商品零售'],
            ['name' => '生活服务', 'pid' => 0, 'sort' => 80, 'status' => 1, 'remark' => '日常生活服务'],
            ['name' => '教育培训', 'pid' => 0, 'sort' => 70, 'status' => 1, 'remark' => '教育培训机构'],
            ['name' => '医疗健康', 'pid' => 0, 'sort' => 60, 'status' => 1, 'remark' => '医疗健康服务'],
            ['name' => '美容美发', 'pid' => 0, 'sort' => 50, 'status' => 1, 'remark' => '美容美发服务'],
            ['name' => '汽车服务', 'pid' => 0, 'sort' => 40, 'status' => 1, 'remark' => '汽车相关服务'],
            ['name' => '房产装修', 'pid' => 0, 'sort' => 30, 'status' => 1, 'remark' => '房产装修服务'],
            ['name' => '娱乐休闲', 'pid' => 0, 'sort' => 20, 'status' => 1, 'remark' => '娱乐休闲场所'],
            ['name' => '其他服务', 'pid' => 0, 'sort' => 10, 'status' => 1, 'remark' => '其他服务类别'],
        ];

        // 插入一级分类
        $categoryIds = [];
        foreach ($categories as $category) {
            $id = DB::table($tableName)->insertGetId([
                'name' => $category['name'],
                'pid' => $category['pid'],
                'sort' => $category['sort'],
                'remark' => $category['remark'],
                'status' => $category['status'],
                'create_time' => $now,
                'update_time' => $now,
                'mark' => 1,
            ]);
            $categoryIds[$category['name']] = $id;
        }


        echo "商家行业分类数据填充完成！\n";
        echo "共添加 " . count($categories) . " 个一级分类\n";
    }
}