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

View File Name : ProductExport.php

<?php

namespace App\Exports;

use App\Models\Product;
use App\Models\User;
use App\Models\Store;
use App\Models\ProductTax;
use App\Models\ProductCategorie;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;

class ProductExport implements FromCollection, WithHeadings
{
    /**
    * @return \Illuminate\Support\Collection
    */
    public function collection()
    {

        $user             = \Auth::user();
        isset($user->current_store) ? $user->current_store  : '';
        $storeid         = Store::where('id', $user->current_store)->first();

        $data           = Product::where('store_id', $storeid->id)->get();


        foreach($data as $k => $product)
        {
        	$store_id=Store::find($product->store_id);
        	$store=isset($store_id)?$store_id->name:'';

        	$product_taxs=ProductTax::find($product->product_tax);
        	$product_tax=isset($product_taxs)?$product_taxs->name:'';

        	$product_categories=ProductCategorie::find($product->product_categorie);
        	$product_categorie=isset($product_categories)?$product_categories->name:'';

        	$created_bys=User::find($product->created_by);
        	$created_by=isset($created_bys)?$created_bys->name:'';

        	 $data[$k]["store_id"]=$store;
        	 $data[$k]["product_tax"]=$product_tax;
        	 $data[$k]["product_categorie"]=$product_categorie;
        	 $data[$k]["created_by"]=$created_by;

        }


        return $data;
    }
    public function headings(): array
    {
        return [
            "Product Id",
            "Store Name",
            "Product Name",
            "Product Categorie",
            "Price",
            "Last Price",
            "Quantity",
            "SKU",
            "Product Tax",
            "Custom_Field_1",
            "Custom_Value_1",
            "Custom_field_2",
            "Custom_value_2",
            "Custom_field_3",
            "Custom_value_3",
            "Custom_field_4",
            "Custom_value_4",
            "Product Display",
            "Downloadable Prodcut",
            "Enable_Product_Variant",
            "Variants_Json",
            "Is_Cover",
            "Attachment",
            "Is_Active",
            "Description",
            "Detail",
            "Specification",
            "Created_by",
            "Created_at",
            "updated_at",
        ];
    }
}