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

<?php

namespace App\Exports;

use App\Models\Sale;
use App\Models\Tax;
use App\Models\Customer;

use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;

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

        $data = Sale::where('created_by', \Auth::user()->creatorId())->get();
        foreach ($data as $k => $Sale) {

            $datas = [];
            $datas['start_date'] = '';
            $datas['end_date'] = '';
            $datas['branch_id'] = '-1';
            $datas['cash_register_id'] = $Sale->cash_register_id;
            $datas['customer_id'] = $Sale->customer_id;

            $datas = Tax::getProductSaleTaxAnalysis($datas);



            $customername = Sale::customers($Sale->customer_id);

            unset($Sale->created_by, $Sale->updated_at, $Sale->invoice_id, $Sale->customer_id, $Sale->branch_id, $Sale->cash_register_id, $Sale->status);

            $data[$k]["name"] = $customername;
            $data[$k]["Product Tax"] = $datas['totalSaledTaxAmount'];
            $data[$k]["Grand Total"] = $datas['totalSaledSubTotal'];
        }

        return $data;
    }
    public function headings(): array
    {
        return [
            "Reference No",
            "Date",
            "Customer",
            "Product Tax",
            "Grand Total"
        ];

    }
}