@php use Illuminate\Support\Facades\DB; $monthInvoice = DB::table('invoices')->where('invoice_code', $record->invoice_code)->first(); $moneyTotal = $monthInvoice->total_amount; $moneyTotalFormatted = number_format($moneyTotal, 0, ',', '.'); $landlord = $record->motel->landlords->first(); // Thông tin ngân hàng mặc định nếu chủ trọ chưa cập nhật $bankName = $landlord->bank_name; $bankAccount = $landlord->bank_account; $bankAccountName = $landlord->bank_account_name; $invoiceCode = $record->invoice_code; $qrUrl = "https://qr.sepay.vn/img?acc={$bankAccount}&bank={$bankName}&amount={$moneyTotal}&des=Thanh toan hoa don {$invoiceCode}"; // $qrUrl = "https://qr.sepay.vn/img?acc=0889737517&bank=TPBank&amount={$moneyTotal}&des=Chuyển tiền trọ {$record->motel->name} phòng {$record->room->name}"; @endphp