One Hat Cyber Team

Your IP: 216.73.216.142
Server IP: 217.76.53.76
Server: Linux vmi1397931.contaboserver.net 5.4.0-105-generic #119-Ubuntu SMP Mon Mar 7 18:49:24 UTC 2022 x86_64
Server Software: Apache
PHP Version: 8.2.27
Buat File | Buat Folder

Dir : ~/www/wwwroot/test2.webi.com.ng/app/Exports/

View File Name : StockReportExport.php

<?php

namespace App\Exports;

use App\Models\Export;
USE App\Models\Item;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;


class StockReportExport implements FromCollection,WithHeadings
{
    /**
     *  Item::where('created_by', '=', \Auth::user()->creatorId())->get();
    * @return \Illuminate\Support\Collection
    */
    public function collection()
    {
        $data = Item::where('created_by', '=', \Auth::user()->creatorId())->get();
        foreach($data as $k => $item)
        {
           if($item->unit == 0 ){
                $unit_id ='0';
           }
           else{
            $unit_id    = Item::unit($item->unit);
           }

           if($item->category == 0){
            $category = '0';
           }
           else{
                $category   = Item::category($item->category);
           }
           if($item->tax == 0){
                 $taxes ='0';
           }
           else{
                $taxes      = Item::taxs($item->tax);
           }

            unset($item->id,$item->created_by,$item->created_at,$item->updated_at);
            $data[$k]["unit"]            = $unit_id;
            $data[$k]["category"]        = $category;
            $data[$k]["tax"]             = $taxes;

        }
        return $data;
    }

    public function headings(): array
    {
        return [
            "ITEM Name",
            "SKU",
            "Sale Price",
            "Purchase Price",
            "Quantity",
            "Tax",
            "Category",
            "Unit",
            "Type",
            "Description",
        ];
    }

  
}