NN2025112501/database/seeders/GoodsCategorySeeder.php

<?php

namespace Database\Seeders;

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

class GoodsCategorySeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        $now = time();
        $tableName = 'goods_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' => '其他类别商品'],
        ];

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


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