Gecko [ thecigaretteboxes.com ]

Name	Size	Permission
AgentRawDataImport.php	3.55 KB	-rw-r--r--
ClientsImport.php	1.07 KB	-rw-r--r--
ContactsImport.php	2.99 KB	-rw-r--r--
LeadsImport.php	561 B	-rw-r--r--

Code Editor : AgentRawDataImport.php

<?php

namespace App\Imports;

use App\Models\AgentRawData;
use App\Models\Client;
use App\Models\Deal;
use App\Models\DealProduct;
use App\Models\DealProductPrinting;
use App\Models\EmailPhoneDetail;
use App\Models\ExcelSales;
use App\Models\Note;
use App\Models\Product;
use App\Models\ProductPrinting;
use App\Models\QuantityAndEstimation;
use App\Models\User;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\Importable;

use Maatwebsite\Excel\Concerns\WithHeadingRow;
use Maatwebsite\Excel\Concerns\SkipsOnFailure;
use Maatwebsite\Excel\Concerns\WithValidation;
use Maatwebsite\Excel\Concerns\SkipsFailures;
use Maatwebsite\Excel\Concerns\SkipsEmptyRows;

use Illuminate\Contracts\Queue\ShouldQueue;
use Maatwebsite\Excel\Concerns\WithChunkReading;
use Maatwebsite\Excel\Concerns\WithBatchInserts;
use Maatwebsite\Excel\Concerns\RemembersRowNumber;
use Maatwebsite\Excel\Concerns\RemembersChunkOffset;
use Carbon\Carbon;
class AgentRawDataImport implements ToModel, WithHeadingRow, SkipsEmptyRows
//, WithValidation
//, WithBatchInserts, WithChunkReading
{
    //use SkipsFailures;

/**
     * @return int
     */
    public function chunkSize(): int
    {
      return 1000;
    }
    /**
     * @return int
     */
    public function batchSize(): int
    {
        return 1000;
    }

/**
     * @return array
     */
    public function rules(): array
    {
        return [
            'date' => ['required'],
            'lead_source' => ['required'],
            'client_name' => ['required'],
            'client_email' => ['required'],
            'ph' => ['required'],
            'box_style' => ['required'],
            'product' => ['required'],
            'product_size' => ['required'],
            'stock' => ['required'],
            'color' => ['required'],
            'quantity' => ['required'],
        ];
    }

/**
     * @return array
     */
    public function customValidationMessages()
    {
        return [
            'date.required' => ':attribute Required.',
            'lead_source.required' => ':attribute Required.',
            'client_name.required' => ':attribute Required.',
            'client_email.required' => ':attribute Required.',
            'ph.required' => ':attribute Required.',
            'box_style.required' => ':attribute Required.',
            'product.required' => ':attribute Required.',
            'product_size.required' => ':attribute Required.',
            'stock.required' => ':attribute Required.',
            'color.required' => ':attribute Required.',
            'quantity.required' => ':attribute Required.',
        ];
    }

/**
    * @param array $row
    *
    * @return \Illuminate\Database\Eloquent\Model|null
    */
    public function model(array $row){

$user= User::where('email',$row['deal_owner'])->first();
      // $new_date = Carbon::createFromFormat('y-M-d', $row['date']);

$DealInsert = array(
            //  'name'=>$row['deal_name'],
            'date' => $row['date'],
            'lead_source' => $row['lead_source'],
            'client_name' => $row['client_name'],
            'client_email' => $row['client_email'],
            'phone' => $row['phone'],
            'box_style' => $row['product_style'],
            'product' => $row['product'],
            'product_size' => $row['product_size'],
            'stock' => $row['stock'],
            'color' => $row['color'],
            'quantity' => $row['quantity'],
            'remarks' => $row['remarks'],
            'deal_owner' => $user['id'],

);
        $dealData = ExcelSales::create($DealInsert);

}
}

${this.title}

Code Editor : AgentRawDataImport.php