byp4a55 professor6T9

Linux world-400.fr.planethoster.net 4.18.0-425.13.1.lve.el7h.x86_64 #1 SMP Mon Feb 27 14:44:55 UTC 2023 x86_64
Apache
10.195.0.10

File Name : Payment_Purchase_Export.php

<?php

namespace App\Exports;

use App\Models\PaymentPurchase;
use App\Models\Role;
use Illuminate\Support\Facades\Auth;
use Maatwebsite\Excel\Concerns\FromArray;
use Maatwebsite\Excel\Concerns\ShouldAutoSize;
use Maatwebsite\Excel\Concerns\WithEvents;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Events\AfterSheet;

class Payment_Purchase_Export implements FromArray, WithHeadings, ShouldAutoSize, WithEvents
{
    /**
     * @return \Illuminate\Support\Collection
     */
    function array(): array
    {
        $role = Auth::user()->roles()->first();
        $view_records = Role::findOrFail($role->id)->inRole('record_view');

// Check If User Has Permission View  All Records
        $payments = PaymentPurchase::with('purchase', 'purchase.provider')
            ->where('deleted_at', '=', null)
            ->where(function ($query) use ($view_records) {
                if (!$view_records) {
                    return $query->where('user_id', '=', Auth::user()->id);
                }
            })->orderBy('id', 'DESC')->get();

if ($payments->isNotEmpty()) {

foreach ($payments as $payment) {

$item['date'] = $payment->date;
                $item['Ref'] = $payment->Ref;
                $item['Purchase'] = $payment['purchase']->Ref;
                $item['provider'] = $payment['purchase']['provider']->name;
                $item['Reg'] = $payment->Reglement;
                $item['Amount'] = $payment->montant;
                $data[] = $item;
            }
        } else {
            $data = [];
        }

return $data;
    }

public function registerEvents(): array
    {
        return [
            AfterSheet::class => function (AfterSheet $event) {
                $cellRange = 'A1:F1'; // All headers
                $event->sheet->getDelegate()->getStyle($cellRange)->getFont()->setSize(14);

$styleArray = [
                    'borders' => [
                        'outline' => [
                            'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THICK,
                            'color' => ['argb' => 'FFFF0000'],
                        ],
                    ],

'alignment' => [
                        'horizontal' => \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_RIGHT,
                    ],
                ];

},
        ];

}

public function headings(): array
    {
        return [
            'Date',
            'Reference',
            'Purchase',
            'Supplier',
            'Paid by',
            'Amount',
        ];
    }
}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	pluszzsu/pluszzsu	0755	2022-08-31 10:05:49
..	dir	-	pluszzsu/pluszzsu	0755	2022-08-31 10:05:49
AdjustmentsExport.php	text/x-php	2.5 KB	pluszzsu/pluszzsu	0644	2022-08-31 10:05:48
ClientsExport.php	text/x-php	2.04 KB	pluszzsu/pluszzsu	0644	2022-08-31 10:05:48
ExpenseExport.php	text/x-php	2.68 KB	pluszzsu/pluszzsu	0644	2022-08-31 10:05:49
Payment_Purchase_Export.php	text/x-php	2.68 KB	pluszzsu/pluszzsu	0644	2022-08-31 10:05:49
Payment_Purchase_Return_Export.php	text/x-php	2.72 KB	pluszzsu/pluszzsu	0644	2022-08-31 10:05:49
Payment_Sale_Export.php	text/x-php	2.64 KB	pluszzsu/pluszzsu	0644	2022-08-31 10:05:49
Payment_Sale_Return_Export.php	text/x-php	2.69 KB	pluszzsu/pluszzsu	0644	2022-08-31 10:05:49
ProductsExport.php	text/x-php	2.69 KB	pluszzsu/pluszzsu	0644	2022-08-31 10:05:49
ProvidersExport.php	text/x-php	2.03 KB	pluszzsu/pluszzsu	0644	2022-08-31 10:05:49
Purchase_Return.php	text/x-php	2.9 KB	pluszzsu/pluszzsu	0644	2022-08-31 10:05:49
PurchasesExport.php	text/x-php	2.87 KB	pluszzsu/pluszzsu	0644	2022-08-31 10:05:49
QuotationsExport.php	text/x-php	2.67 KB	pluszzsu/pluszzsu	0644	2022-08-31 10:05:49
Sale_Return.php	text/x-php	2.83 KB	pluszzsu/pluszzsu	0644	2022-08-31 10:05:49
SalesExport.php	text/x-php	2.8 KB	pluszzsu/pluszzsu	0644	2022-08-31 10:05:49
TransfersExport.php	text/x-php	2.71 KB	pluszzsu/pluszzsu	0644	2022-08-31 10:05:49
UsersExport.php	text/x-php	2.47 KB	pluszzsu/pluszzsu	0644	2022-08-31 10:05:49

Team Anon Force

https://t.me/Professor6T9x