Default page

Your IP: 216.73.216.138
Server IP: 186.226.58.36
Server: Linux da02.sh15.net 3.10.0-1160.119.1.vz7.224.4 #1 SMP Mon Sep 30 15:36:27 MSK 2024 x86_64
Server Software: Apache/2
PHP Version: 8.1.32
Buat File | Buat Folder

Dir : ~/home/redesystem/public_html/sys/app/Exports/

View File Name : ClientTransactionsExport.php

<?php

namespace App\Exports;

use App\Models\Payment;
use Illuminate\Contracts\View\View;
use Illuminate\Support\Facades\Auth;
use Maatwebsite\Excel\Concerns\FromView;

class ClientTransactionsExport implements FromView
{
    public function view(): View
    {
        $query = Payment::with('invoice.client.user')->select('payments.*');
        $user = Auth::user();
        if ($user->hasRole('client')) {
            $query->whereHas('invoice.client', function ($q) use ($user) {
                $q->where('user_id', $user->client->user_id);
            });
        }
        $transactions = $query->orderBy('created_at', 'desc')->get();

        return view('excel.client_transactions_excel', compact('transactions'));
    }
}