<?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(){
}
}