View Code - 20260722

purchase_verify.php | 20260722_120325.php Initial Domain Snapshot

<?php

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

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

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

$msg = '';

/* ===== SAFE USER ID ===== */

$uid = $u['user_id'] ?? $u['id'] ?? $u['staff_id'] ?? 0;

/* ===== VERIFY ACTION ===== */

if(isset($_GET['verify'])){

$id = (int)$_GET['verify'];

$stm = $pdo->prepare("
        UPDATE purchase_entry
        SET verification_status='verified',
            verified_by=?,
            verified_at=NOW()
        WHERE purchase_id=? AND company_id=?
    ");

$stm->execute([$uid,$id,$company_id]);

activity_log([
        'company_id' => $company_id ?? 0,
        'user_id' => $u['id'] ?? ($_SESSION['user_id'] ?? 0),
        'module' => 'purchase',
        'action_name' => 'approve',
        'entity_type' => 'purchase_entry',
        'entity_id' => $id ?? 0,
        'remarks' => 'Purchase verified'
    ]);

$msg = "Purchase verified successfully";

}

/* ===== UNVERIFIED LIST ===== */

$stm = $pdo->prepare("
SELECT *
FROM purchase_entry
WHERE company_id=?
AND verification_status='unverified'
ORDER BY purchase_date DESC, purchase_id DESC
");

$stm->execute([$company_id]);

$data = $stm->fetchAll();

<h4>Purchase Verification</h4>

<?php if($msg){ ?>
<div class="alert alert-success"><?php echo htmlspecialchars($msg); ?></div>
<?php } ?>

<thead>
<tr>
<th>ID</th>
<th>Date</th>
<th>Party</th>
<th>Challan</th>
<th>Bill</th>
<th>Amount</th>
<th>Video</th>
<th>Action</th>
</tr>
</thead>

<tbody>

<?php if($data){ foreach($data as $row){ ?>

<tr>

<td>

<?php if(!empty($row['video_path'])){ ?>

<a href="<?php echo htmlspecialchars($row['video_path']); ?>" 
target="_blank" 
class="btn btn-sm btn-info">
View
</a>

<?php } else { ?>

<span class="text-danger">No Video</span>

<?php } ?>

</td>

<td>

<a href="?verify=<?php echo $row['purchase_id']; ?>"
class="btn btn-sm btn-success"
onclick="return confirm('Verify this purchase?');">

Verify

</a>

</td>

</tr>

<?php }} else { ?>

<tr>
<td colspan="8" class="text-center">No unverified purchase found</td>
</tr>

<?php } ?>

</tbody>

</table>

</div>

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