<?php

namespace Database\Seeders;

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

class IncomeExpenseHead extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        DB::table('income_heads')->delete();
        DB::table('expense_heads')->delete();


        $data = [
            ['id' => 1,'name'   => 'New Customer'],
            ['id' => 2,'name'   => 'OTC'],
            ['id' => 3,'name'   => 'Billing Cycle Change'],
            ['id' => 4,'name'   => 'Package Change'],
            ['id' => 5,'name'   => 'Monthly Bill'],
            ['id' => 6,'name'   => 'Advanced Payment'],
            ['id' => 7,'name'   => 'House Rent'],
            ['id' => 8,'name'   => 'Router Sell'],
            ['id' => 9,'name'   => 'Old Item Sell'],
            ['id' => 10,'name'  => 'Reseller Recharge'],
            ['id' => 11,'name'  => 'Online Bill Payment'],
            ['id' => 12,'name'  => 'Other'],

        ];

        DB::table('income_heads')->insert($data);


        $data = [
            ['id' => 1,'name' => 'Salary'],
            ['id' => 2,'name' => 'House Rent'],
            ['id' => 3,'name' => 'Office Expense'],
            ['id' => 4,'name' => 'Electricity Bill'],
            ['id' => 5,'name' => 'Bandwidth Bill'],
            ['id' => 6,'name' => 'Reseller Commission'],
            ['id' => 7,'name' => 'Employee Salary']
        ];

        DB::table('expense_heads')->insert($data);


    }
}
