<?php
/**
 * Created by PhpStorm.
 * User: sunil
 * Date: 12/11/18
 * Time: 2:02 PM
 */

namespace App\Imports;

use Illuminate\Http\Request;
use Illuminate\Support\Collection;
use Maatwebsite\Excel\Concerns\Importable;
use Maatwebsite\Excel\Concerns\ToCollection;

class RPSImport implements ToCollection
{

    use Importable;
    private $request;
    public $payments = null;
    public $applications = null;

    public function __construct(Request $request){
        $this->request = $request;
    }

    /**
     * @param Collection $collection
     * @return int
     */
    public function collection(Collection $collection)
    {
        unset($collection[0]);
        foreach ($collection as $item){
            $this->applications[] = $item[0];
            $this->payments[] = [
                'application_id' => $item[0],
                'installment_number' => $item[1],
                'emi_date' => $item[2],
                'due_date' => $item[3],
                'bpi_interest' => $item[4],
                'morat_interest' => $item[5],
                'interest_comp' => $item[6],
                'principal_comp' => $item[7],
                'emi_amount' => $item[8],
                'principal_outstanding' => $item[9]
            ];
        }
    }

}