<?php

namespace App\Http\Controllers;

use App\Bank\Payment;
use Illuminate\Http\Request;

class PagesController extends Controller
{
    public function payments()
    {
        $payments = Payment::query()->join('users', 'users.id', '=', 'payments.sender_id')
        ->join('merchant_accounts', 'merchant_accounts.id', 'payments.merchant_account_id')
        ->join('imali_accounts', 'imali_accounts.user_id', 'payments.sender_id')
        ->orderBy('payments.created_at', 'desc')
        ->select('payments.*', 'users.name as client_name', 'merchant_accounts.name as merchant_name','merchant_accounts.account_number as merchant_account', 'imali_accounts.account_number as client_account')
        ->get();

        return view('payments', compact('payments', $payments));
    }
    public function Realtorios(){

    }
}