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

View File Name : InvoiceExport.php

<?php

namespace App\Exports;

use App\Models\Customer;
use App\Models\Invoice;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;

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

        if (!\Auth::guard('customer')->check()) {
            $data = Invoice::where('created_by', \Auth::user()->id)->get();
        } else {
            $data = Invoice::where('customer_id', '=', \Auth::guard('customer')->check())->where('status', '!=', '0')->get();
        }

        if (!empty($data)) {
            foreach ($data as $k => $Invoice) {
                $customer  = Invoice::customers($Invoice->customer_id);
                $category  = Invoice::Invoicecategory($Invoice->category_id);
                if($Invoice->status == 0)
                {
                    $status = 'Draft';
                }
                elseif($Invoice->status == 1)
                {
                    $status = 'Sent';
                }
                elseif($Invoice->status == 2)
                {
                    $status = 'Unpaid';
                }
                elseif($Invoice->status == 3)
                {
                    $status = 'Partialy Paid';
                }
                elseif($Invoice->status == 4)
                {
                    $status = 'Paid';
                }
                unset($Invoice->discount_apply,$Invoice->shipping_display,$Invoice->id,$Invoice->created_by, $Invoice->updated_at, $Invoice->created_at);
                if(!\Auth::guard('customer')->check())
                {
                    $data[$k]["invoice_id"] = \Auth::user()->invoiceNumberFormat($Invoice->invoice_id);
                }
                else{
                    $data[$k]["invoice_id"] = Customer::invoiceNumberFormat($Invoice->invoice_id);
                }
                $data[$k]["customer_id"]        = $customer;
                $data[$k]["category_id"]   = $category;
                $data[$k]["status"]   = $status;

            }
        }

        return $data;
    }

    public function headings(): array
    {
        return [
            "Invoice Id",
            "Customer Name",
            "Issue Date",
            "Due Date",
            "Send Date",
            "Category_name",
            "Ref number",
            "status",
        ];
    }
}