<?php

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

    class ResellerTableSeeder extends Seeder
    {
        /**
         * Run the database seeds.
         *
         * @return void
         */
        public function run()
        {
            $role_id = DB::table('roles')->where('name', 'reseller')->first()->id;
            DB::table('users')->insert([
                'organisation' => 'Npontu',
                'first_name' => 'Reseller',
                'full_name' => 'Reseller',
                'phone_number' => '023',
                'username' => 'reseller',
                'email' => 'reseller@npontu.com',
                'password' => bcrypt('reseller123456'),
                'role_id' => $role_id
            ]);
            $user_id = DB::table('users')->where('username', 'reseller')->first()->id;

            DB::table('credits')->insert([
                'user_id' => $user_id,
                'username' => 'reseller',
                'price' => '0.028',
                'credit_alloted' => '0.15',
                'old_bal' => '0',
                'new_bal' => '0.3',
                'credit_used' => '0',
                'credited' => '0',
                'currency' => 'GHC'
            ]);
        }
    }