File "StockSrNoImport.php"

Full Path: /home/u380502875/domains/uniquesunpower.in/public_html/epc/app/Imports/StockSrNoImport.php
File size: 1.59 KB
MIME-type: text/x-php
Charset: utf-8

<?php

namespace App\Imports;

use Carbon\Carbon;
use App\Models\StockSrNo;
use App\Models\InverterStock;
use App\Models\stock\Inverter;
use App\Models\stock\InverterSrNo;
use Illuminate\Support\Facades\Session;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\Importable;
use Maatwebsite\Excel\Concerns\WithStartRow;
use Maatwebsite\Excel\Concerns\SkipsFailures;

class StockSrNoImport implements ToModel, WithStartRow
{
    use Importable;
    use SkipsFailures;
    /**
    * @param array $row
    *
    * @return \Illuminate\Database\Eloquent\Model|null
    */
    public function model(array $row)
    {
        // dd($row);
        $get_excel_data = Carbon::instance(\PhpOffice\PhpSpreadsheet\Shared\Date::excelToDateTimeObject($row[3]));
     
        if ($stockExits = Inverter::where('slack', $row[0])->first()) {
            // dd($row);
            if (!$srno = InverterSrNo::where(['stock_id'=>$row[0],'sr_no'=>$row[1]])->first()) {
                // dd($row);
                if ($row[0] !== null && $row[1] !== null) {
                    return new InverterSrNo([
                        'stock_id'=>trim($stockExits->slack),
                        'sr_no'=>$row[1],
                        'purchase_from'=>$row[2],
                        'purchase_date'=>date("d-m-Y", strtotime($get_excel_data)),
                        'is_used'=>0,
                        'created_by'=>Session::get('user.id')
                    ]);
                }
            }else{
                // dd($srno);
            }
        }
    }

    public function startRow(): int
    {
        return 2;
    }
}