NN2025112501/database/seeders/PayMealsSeeder.php

<?php

namespace Database\Seeders;

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

class PayMealsSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        $time = time();

        // 话费充值套餐
        $phoneMeals = [
            ['product_id' => 1101, 'money' => 10.00, 'discount' => 98, 'remark' => '10元话费', 'type' => 1, 'sort' => 100],
            ['product_id' => 1102, 'money' => 20.00, 'discount' => 98, 'remark' => '20元话费', 'type' => 1, 'sort' => 90],
            ['product_id' => 1103, 'money' => 30.00, 'discount' => 97, 'remark' => '30元话费', 'type' => 1, 'sort' => 80],
            ['product_id' => 1104, 'money' => 50.00, 'discount' => 97, 'remark' => '50元话费', 'type' => 1, 'sort' => 70],
            ['product_id' => 1105, 'money' => 100.00, 'discount' => 96, 'remark' => '100元话费', 'type' => 1, 'sort' => 60],
            ['product_id' => 1106, 'money' => 200.00, 'discount' => 95, 'remark' => '200元话费', 'type' => 1, 'sort' => 50],
            ['product_id' => 1107, 'money' => 300.00, 'discount' => 95, 'remark' => '300元话费', 'type' => 1, 'sort' => 40],
            ['product_id' => 1108, 'money' => 500.00, 'discount' => 94, 'remark' => '500元话费', 'type' => 1, 'sort' => 30],
        ];

        // 电费充值套餐
        $electricityMeals = [
            ['product_id' => 1040, 'money' => 100.00, 'discount' => 99, 'remark' => '100元电费', 'type' => 2, 'sort' => 100],
            ['product_id' => 1041, 'money' => 200.00, 'discount' => 98, 'remark' => '200元电费', 'type' => 2, 'sort' => 90],
            ['product_id' => 1042, 'money' => 300.00, 'discount' => 98, 'remark' => '300元电费', 'type' => 2, 'sort' => 80],
            ['product_id' => 1043, 'money' => 500.00, 'discount' => 97, 'remark' => '500元电费', 'type' => 2, 'sort' => 70],
            ['product_id' => 1044, 'money' => 1000.00, 'discount' => 96, 'remark' => '1000元电费', 'type' => 2, 'sort' => 60],
        ];

        // 燃气充值套餐
        $gasMeals = [
            ['product_id' => 1458, 'money' => 100.00, 'discount' => 99, 'remark' => '100元燃气', 'type' => 3, 'sort' => 100],
            ['product_id' => 1459, 'money' => 200.00, 'discount' => 98, 'remark' => '200元燃气', 'type' => 3, 'sort' => 90],
            ['product_id' => 1460, 'money' => 300.00, 'discount' => 98, 'remark' => '300元燃气', 'type' => 3, 'sort' => 80],
            ['product_id' => 1461, 'money' => 500.00, 'discount' => 97, 'remark' => '500元燃气', 'type' => 3, 'sort' => 70],
            ['product_id' => 1462, 'money' => 1000.00, 'discount' => 96, 'remark' => '1000元燃气', 'type' => 3, 'sort' => 60],
        ];

        // 合并所有套餐
        $allMeals = array_merge($phoneMeals, $electricityMeals, $gasMeals);

        // 添加通用字段
        foreach ($allMeals as &$meal) {
            $meal['create_time'] = $time;
            $meal['update_time'] = $time;
            $meal['status'] = 1;
            $meal['mark'] = 1;
        }

        // 插入数据
        DB::table('pay_meals')->insert($allMeals);

        $this->command->info('缴费充值套餐测试数据添加成功！');
        $this->command->info('- 话费充值套餐：' . count($phoneMeals) . ' 条');
        $this->command->info('- 电费充值套餐：' . count($electricityMeals) . ' 条');
        $this->command->info('- 燃气充值套餐：' . count($gasMeals) . ' 条');
    }
}