<?php

namespace Database\Seeders;

use App\Models\Crop;
use App\Models\CropYield;
use Illuminate\Database\Seeder;
use App\Models\AgriculturalBase;
use Illuminate\Support\Facades\DB;

class CropYieldSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        $type = 2;
        //假数据逻辑：每个地区，每年随机一种农作物，4个季度随机值；
        $bases = AgriculturalBase::where('type', $type)->get();
        foreach ($bases as $base){
            $insertData = [];
            //随机剔除一个农作物不加数据
            $uncrop = Crop::where('is_end', 1)->where('crop_type', $type)->inRandomOrder()->first();
            $crops = Crop::where('is_end', 1)->where('crop_type', $type)->where('id', '<>', $uncrop->id)->get();
            foreach ($crops as $crop){
                for ($i = 2019; $i < 2023; $i++) {
                    for ($j = 1; $j< 5; $j++) {
                        $insertData[] = [
                            'base_id' => $base->id,
                            'crop_id' => $crop->id,
                            'category_id' => $crop->category_id,
                            'time_year' => $i,
                            'quarter' => $j,
                            'yield' => rand(1000, 9999),
                            'cultivated'=> rand(100, 999),
                            'output'=> rand(10000, 99999),
                        ];
                    }
                }
            }
            if(count($insertData) > 1){
                // DB::table('crop_yields')->truncate();
                CropYield::insert($insertData);
            }
        }
    }
}