<?php

use Illuminate\Database\Seeder;

class TransactionSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        $total_trans = rand(20, 50);
        for($sno = 1; $sno <= $total_trans; $sno++){
            $payref = $sno . rand(1000, 1000000);
            $amount = rand(1000, 1000000);
            
            $service_prov_id = rand(1, 8);
            $tax_type_id = rand(1, 3);
            $payment_channel_id = rand(1, 3);
            $bank_id = rand(1, 5);
            $switching_platform_id = rand(1, 3);
            
            DB::table('transactions')->insert([
                'payref' => "$payref",
                'transdate' => '2018-01-11 07:46:18',
                'client_id' => 1,
                'service_prov_id' => $service_prov_id,
                'firs_tin' => '123',
                'new_tin' => '123',
                'taxpayer_name' => 'John Doe',
                'taxoffice_id' => 1,
                'amount' => $amount,
                'currency_id' => 1,
                'tax_type_id' => $tax_type_id,
                'payment_channel_id' => $payment_channel_id,
                'assessment_no' => '123456',
                'assessment_period' => 'December 2017',
                'bank_id' => $bank_id,
                'switching_platform_id' => $switching_platform_id
            ]);
        }
    }
}