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 : EstimateExport.php

<?php

namespace App\Exports;

use App\Models\Export;
use App\Models\Estimate;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;

class EstimateExport implements FromCollection,WithHeadings
{
    /**
    * @return \Illuminate\Support\Collection
    */
    public function collection()
    {
        
        $data = Estimate::where('created_by', '=', \Auth::user()->creatorId())->get();
   


       

        foreach($data as $k => $estimates)
        {
            unset($estimates->send_date,$estimates->discount_apply,$estimates->is_convert,$estimates->created_by,$estimates->created_at,$estimates->updated_at);
            $data[$k]["id"]            = $estimates->id;
            $data[$k]["estimate"]         = $estimates->estimate;
            $data[$k]["client"]      = $estimates->client;
            $data[$k]["issue_date"]      = $estimates->issue_date;
            $data[$k]["expiry_date"]      = $estimates->expiry_date;
            $data[$k]["category"]     = $estimates->category;

           
        }  

        return $data;
    }

    public function headings(): array
    {
        return [
            "id",
            "estimate",
            "client",
            "issue_date",
            "expiry_date",
            "category",
          
        ];
    }
}