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/softpos.com.ng/app/Exports/

View File Name : ProductExport.php

<?php

namespace App\Exports;

use App\Models\Product;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Illuminate\Support\Facades\Auth;

class ProductExport implements FromCollection, WithHeadings
{
    /**
     * @return \Illuminate\Support\Collection
     */
    public function collection()
    {
        // $data = Product::get();
        $data = Product::where('created_by',\Auth::user()->id)->get();
      
        foreach ($data as $k => $Product) {

            $taxe  = Product::tax($Product->tax_id);
            $unit  = Product::unit($Product->unit_id);
            $category  = Product::Category($Product->category_id);
            $brand  = Product::Brand($Product->brand_id);

            
            unset($Product->id,$Product->sku,$Product->image,$Product->created_by, $Product->updated_at, $Product->created_at);

            $data[$k]["id"]                = $Product->id;
            $data[$k]["tax_id"]        = $taxe;
            $data[$k]["unit_id"]          = $unit;
            $data[$k]["category_id"]   = $category;
            $data[$k]["brand_id"]   = $brand;


        }

        return $data;
    }

    public function headings(): array
    {
        return [
            "name",
            "slug",
            "purchase_price",
            "sale_price",
            "description",
            "quantity",
            "tax_Name",
            "unit_Name",
            "category_Name",
            "brand_Name",
            "product_type",
        ];
    }
}