View Code - 20260722

party_payment_receipt.php | 20260722_120325.php Initial Domain Snapshot

<?php
/* =============================================================================
   File: /erp/party_payment_receipt.php
   Purpose: Party Payment Receipt (CID Based Debit Account Only)
   ============================================================================= */

require_once __DIR__ . '/modules/auth/page_acl.php';
$ctx = page_require_access('party_payment');

$pdo        = $ctx['pdo'];
$company_id = (int)$ctx['company_id'];

function h($s){
    return htmlspecialchars((string)($s ?? ''), ENT_QUOTES, 'UTF-8');
}

/* ===================== GET RECEIPT ID ===================== */
$payment_id = (int)($_GET['id'] ?? 0);
if (!$payment_id) {
    die("Invalid receipt id");
}

/* ===================== FETCH PAYMENT ===================== */
$st = $pdo->prepare("
    SELECT *
    FROM payments
    WHERE id = ?
      AND company_id = ?
    LIMIT 1
");
$st->execute([$payment_id, $company_id]);
$payment = $st->fetch(PDO::FETCH_ASSOC);

if (!$payment) {
    die("Receipt not found.");
}

/* ===================== FETCH PARTY DETAILS ===================== */
$party = [];
if (!empty($payment['person_id'])) {
    $st2 = $pdo->prepare("
        SELECT beneficiary_name, account_no, bank_name, ifsc_code
        FROM party_ac_detail
        WHERE id = ?
          AND company_id = ?
        LIMIT 1
    ");
    $st2->execute([
        $payment['person_id'],
        $company_id
    ]);
    $party = $st2->fetch(PDO::FETCH_ASSOC) ?: [];
}

/* ===================== FETCH COMPANY DEBIT ACCOUNT (CID ONLY) ===================== */
/*
   Sirf company_id ke basis par account uthayenge
   bank_user_id ignore
*/

$st3 = $pdo->prepare("
    SELECT debit_account, debit_ac_no
    FROM company_bank_accounts
    WHERE company_id = ?
    ORDER BY id ASC
    LIMIT 1
");

$st3->execute([$company_id]);
$debitAccount = $st3->fetch(PDO::FETCH_ASSOC) ?: [];

require_once __DIR__ . '/partials/header.php';
?>

<div class="d-flex justify-content-between align-items-center mb-3">
                <h4 class="mb-0 fw-bold">Payment Receipt</h4>
                <span class="badge bg-secondary">
                    Receipt #<?= h($payment['id']) ?>
                </span>
            </div>

<hr>

<div class="col-md-6">

<p><strong>Beneficiary:</strong> <?= h($party['beneficiary_name'] ?? '-') ?></p>
                    <p><strong>Account No:</strong> <?= h($party['account_no'] ?? '-') ?></p>
                    <p><strong>Bank:</strong> <?= h($party['bank_name'] ?? '-') ?></p>
                    <p><strong>IFSC:</strong> <?= h($party['ifsc_code'] ?? '-') ?></p>

<p>
                        <strong>Debit A/C:</strong>
                        <?php if (!empty($debitAccount)): ?>
                            <?= h($debitAccount['debit_account']) ?>
                            (<?= h($debitAccount['debit_ac_no']) ?>)
                        <?php else: ?>
                            <span class="text-danger">No Bank Account Found For This Company</span>
                        <?php endif; ?>
                    </p>

<p><strong>Payment Type:</strong> CMS (NEFT)</p>

</div>

<div class="col-md-6 text-md-end">
                    <p><strong>Date:</strong> <?= h($payment['payment_date']) ?></p>

<p class="fs-5 fw-bold">
                        <strong>Amount:</strong>
                        ₹<?= number_format((float)$payment['amount'], 2) ?>
                    </p>

<p><strong>Created At:</strong> <?= h($payment['created_at']) ?></p>
                </div>

</div>

<?php if (!empty($payment['remark'])): ?>
                <div class="mt-3">
                    <div class="border rounded p-2 bg-light">
                        <?= h($payment['remark']) ?>
                    </div>
                </div>
            <?php endif; ?>

<div class="mt-4 text-end no-print">
                <button onclick="window.print()" class="btn btn-primary">
                    Print Receipt
                </button>
            </div>

</div>
    </div>
</div>

<?php require_once __DIR__ . '/partials/footer.php'; ?>