<?php

use Illuminate\Database\Seeder;

class EsmeTableSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        $role_id = DB::table('roles')->where('name', 'esme')->first()->id;
        DB::table('users')->insert([
            'organisation' => 'Npontu',
            'first_name' => 'guiuser',
            'full_name' => 'guiuser',
            'phone_number' => '020',
            'username' => 'guiuser',
            'email' => 'guiuser@npontu.com',
            'password' => bcrypt('O14ns0'),
            'role_id' => $role_id,
            'status' => 'active',
            'pass' => 'O14ns0'
        ]);

        $user_id = DB::table('users')->where('username', 'guiuser')->first()->id;
        DB::table('credits')->insert([
            'user_id' => $user_id,
            'username' => 'guiuser',
            'price' => '0.032',
            'credit_alloted' => '0.15',
            'old_bal' => '0',
            'new_bal' => '0.3',
            'credit_used' => '0',
            'credited' => '0',
            'currency' => 'GHC'
        ]);
    }
}