<?php

use App\Configuration;
use Illuminate\Database\Migrations\Migration;

use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\DB;

class AddConfigurationsData extends Migration
{
    protected $configurations=[
        ['name'=>'price_coefficient','value'=>1.3,'description'=>'采购管理价格系数'],
        ['name'=>'enquiry_time','value'=>4,'description'=>'报价需在询价发起延时时间之内有效'],
        ['name'=>'receive_time','value'=>24,'description'=>'接单需在询价发起延时时间之内有效']
    ];
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        foreach ($this->configurations as $configuration){
            DB::insert(DB::raw("INSERT INTO configurations(name,value,description,operator,created_at,updated_at) VALUES(?,?,?,?,?,?)"),[
               $configuration["name"],$configuration["value"],$configuration["description"],0,date("Y-m-d"),date("Y-m-d")
            ]);
        }
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        foreach ($this->configurations as $configuration){
            DB::delete(DB::raw("DELETE FROM configurations WHERE name = ?"),[$configuration["name"]]);
        }
    }
}