Notes

<?php

namespace AppExports;

use IlluminateSupportCollection;
use MaatwebsiteExcelConcernsFromCollection;
use MaatwebsiteExcelConcernsWithHeadings;
use MaatwebsiteExcelConcernsWithMapping;
use MaatwebsiteExcelConcernsShouldAutoSize;
use MaatwebsiteExcelConcernsWithChunkReading;

class SpectrumInventoryExport implements
FromCollection,
WithHeadings,
WithMapping,
ShouldAutoSize,
WithChunkReading
{
protected Collection $data;

public function __construct(array $resultArray)
{
// Reindex array (VERY IMPORTANT for Excel)
$this->data = collect(array_values($resultArray));
}

/**
* Source data
*/
public function collection(): Collection
{
return $this->data;
}

/**
* Excel column headings (EXACT, CLEAN, PROFESSIONAL)
*/
public function headings(): array
{
return [
'Company Code',
'Item Code',
'Item Description',
'Item Category',
'Phase Code',
'Cost Type',
'Default Cost Category',
'ABC Class',

'EDP Part Number',
'Vendor Part Number',
'Primary Vendor',
'Alternate Vendor',

'Purchase Unit Of Measure',
'Sell Unit Of Measure',
'Unit Of Measure Conversion',
'Unit Weight',

'Standard Cost',
'Price List 1',
'Price List 2',
'Price List 3',
'Price List 4',
'Price List 5',
'Price Per Factor',
'Markup Price',

'Status Discontinue Flag',
'Date Discontinued',
];
}

/**
* Row mapping (NULL SAFE, TYPE SAFE)
*/
public function map($row): array
{
return [
$row['Company_Code'] ?? '',
$row['Item_Code'] ?? '',
$row['Item_Description'] ?? '',
$row['Item_Category'] ?? '',
$row['Phase_Code'] ?? '',
$row['Cost_Type'] ?? '',
$row['Default_Cost_Category'] ?? '',
$row['ABC_Class'] ?? '',

$row['EDP_Part_Number'] ?? '',
$row['Vendor_Part_Number'] ?? '',
$row['Primary_Vendor'] ?? '',
$row['Alternate_Vendor'] ?? '',

$row['Purchase_Unit_Of_Measure1'] ?? '',
$row['Sell_Unit_Of_Measure2'] ?? '',
(float) ($row['Unit_Of_Measure_Conversion'] ?? 0),
(float) ($row['Unit_Weight'] ?? 0),

(float) ($row['Standard_Cost'] ?? 0),
(float) ($row['Price_List1'] ?? 0),
(float) ($row['Price_List2'] ?? 0),
(float) ($row['Price_List3'] ?? 0),
(float) ($row['Price_List4'] ?? 0),
(float) ($row['Price_List5'] ?? 0),
(float) ($row['Price_Per_Factor'] ?? 0),
(float) ($row['Markup_Price'] ?? 0),

$row['Status_Discontinue_Flag'] ?? '',
!empty($row['Date_Discontinued'])
? date('Y-m-d', strtotime($row['Date_Discontinued']))
: '',
];
}

/**
* Chunk size for large Spectrum data
*/
public function chunkSize(): int
{
return 1000;
}
}