<?php
namespace Database\Seeders;
use Illuminate\Database\Seeder;
use Carbon\Carbon;
use App\CoiUsers;
class CoiuserSeed extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
      CoiUsers::truncate();

          $csvFile = fopen(base_path("database/seeds/employee.csv"), "r");

          $firstline = true;
          while (($data = fgetcsv($csvFile, 2000, ",")) !== FALSE) {
              if (!$firstline) {
                  CoiUsers::create([
                      "name" => $data['1'],
                      "email" => $data['2'],
                      "phone" => $data['3'],
                      "dept" => $data['4'],
                      "division" => $data['5'],
                      "username" => $data['6'],
                      "level" => $data['7'],
                      "employment_status" => $data['8'],
                      "created_at" => \Carbon\Carbon::now(),
                      "updated_at" => \Carbon\Carbon::now(),
                  ]);
              }
              $firstline = false;
          }

          fclose($csvFile);
    }
}