263 lines
16 KiB
PHP
263 lines
16 KiB
PHP
<div class="pagetitle d-flex justify-content-between align-items-center mb-3">
|
|
<div>
|
|
<h4 class="mb-0 text-success">
|
|
<i class="bi bi-card-checklist"></i> GRN Inspection Details
|
|
<span class="badge bg-light text-dark border ms-2 font-monospace"><?= esc($grn['grn_number'] ?? 'GRN') ?></span>
|
|
</h4>
|
|
<small class="text-muted">Inward Goods Inspection & Live Stock Posting</small>
|
|
</div>
|
|
<div class="d-flex gap-2">
|
|
<a href="javascript:load_form_div('<?= base_url('Medical/grn_list') ?>','medical-main','GRN Register :Pharmacy');" class="btn btn-outline-secondary btn-sm">
|
|
<i class="bi bi-arrow-left"></i> Back to GRN List
|
|
</a>
|
|
<?php if (!empty($grn['grn_id'])): ?>
|
|
<button type="button" class="btn btn-warning btn-sm" onclick="load_form_div('<?= base_url('Medical/grn_edit/' . (int)$grn['grn_id']) ?>','medical-main','Edit GRN Inspection');">
|
|
<i class="bi bi-pencil-square"></i> Edit GRN Details
|
|
</button>
|
|
<a href="<?= base_url('Medical/grn_print/' . (int)$grn['grn_id']) ?>" target="_blank" class="btn btn-outline-secondary btn-sm">
|
|
<i class="bi bi-printer"></i> Print Slip
|
|
</a>
|
|
<?php endif; ?>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="card shadow-sm border-0 mb-3">
|
|
<div class="card-body p-3">
|
|
<div class="row g-3">
|
|
<div class="col-md-3">
|
|
<small class="text-muted d-block">Supplier / Vendor</small>
|
|
<strong><?= esc($grn['name_supplier'] ?? 'Supplier') ?></strong>
|
|
</div>
|
|
<div class="col-md-2">
|
|
<small class="text-muted d-block">Vendor Invoice #</small>
|
|
<strong><?= esc($grn['supplier_invoice_no'] ?? '-') ?></strong>
|
|
</div>
|
|
<div class="col-md-2">
|
|
<small class="text-muted d-block">Invoice Date</small>
|
|
<span><?= !empty($grn['invoice_date']) ? date('d-M-Y', strtotime($grn['invoice_date'])) : '-' ?></span>
|
|
</div>
|
|
<div class="col-md-2">
|
|
<small class="text-muted d-block">GRN Date</small>
|
|
<span><?= !empty($grn['grn_date']) ? date('d-M-Y', strtotime($grn['grn_date'])) : '-' ?></span>
|
|
</div>
|
|
<div class="col-md-3">
|
|
<small class="text-muted d-block">Linked PO</small>
|
|
<?php if (!empty($grn['po_number'])): ?>
|
|
<span class="badge bg-light text-primary border font-monospace"><?= esc($grn['po_number']) ?></span>
|
|
<?php else: ?>
|
|
<span class="text-muted">Direct Intake</span>
|
|
<?php endif; ?>
|
|
</div>
|
|
</div>
|
|
|
|
<?php if (!empty($grn['remarks'])): ?>
|
|
<div class="alert alert-light border mt-3 mb-0 py-2">
|
|
<small><strong>Inspection Remarks:</strong> <?= esc($grn['remarks']) ?></small>
|
|
</div>
|
|
<?php endif; ?>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="card shadow-sm border-0 mb-3">
|
|
<div class="card-header bg-light py-2 d-flex justify-content-between align-items-center">
|
|
<strong class="text-secondary"><i class="bi bi-capsule"></i> Verified Medicine Items</strong>
|
|
<span class="badge bg-<?= (($grn['status'] ?? '') === 'posted_to_inventory') ? 'success' : 'info text-dark' ?> text-uppercase">
|
|
<?= str_replace('_', ' ', esc($grn['status'] ?? 'draft')) ?>
|
|
</span>
|
|
</div>
|
|
<div class="card-body p-0">
|
|
<div class="table-responsive">
|
|
<table class="table table-sm table-striped align-middle mb-0" style="font-size: 13px;">
|
|
<thead class="table-light">
|
|
<tr>
|
|
<th style="width: 30px;">#</th>
|
|
<th>Medicine Name</th>
|
|
<th style="width: 90px;">Batch No</th>
|
|
<th style="width: 95px;">Expiry</th>
|
|
<th class="text-center" style="width: 50px;">Pack</th>
|
|
<th class="text-center" style="width: 65px;">Rec. Qty</th>
|
|
<th class="text-center" style="width: 50px;">Free</th>
|
|
<th class="text-end" style="width: 75px;">Rate/Pack</th>
|
|
<th class="text-end" style="width: 70px;">MRP</th>
|
|
<th class="text-end" style="width: 80px;">Gross Amt</th>
|
|
<th class="text-center" style="width: 55px;">Disc %</th>
|
|
<th class="text-end" style="width: 75px;">Sch Disc</th>
|
|
<th class="text-end" style="width: 85px;">Taxable Amt</th>
|
|
<th class="text-center" style="width: 90px;">GST</th>
|
|
<th class="text-end" style="width: 90px;">Line Total</th>
|
|
<th class="text-center" style="width: 85px;">Live Stock ID</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php
|
|
$totalGross = 0.0;
|
|
$totalDiscount = 0.0;
|
|
?>
|
|
<?php if (!empty($grnItems)): ?>
|
|
<?php foreach ($grnItems as $idx => $it): ?>
|
|
<?php
|
|
$recPacks = (float)($it['received_packs'] ?? 0);
|
|
$rate = (float)($it['unit_purchase_rate'] ?? 0);
|
|
$gross = isset($it['gross_amount']) && (float)$it['gross_amount'] > 0
|
|
? (float)$it['gross_amount']
|
|
: round($recPacks * $rate, 2);
|
|
|
|
$schPer = (float)($it['sch_disc_per'] ?? 0);
|
|
$schAmt = (float)($it['sch_disc_amt'] ?? 0);
|
|
$schTotal = ($schPer > 0 ? round($gross * $schPer / 100, 2) : 0) + $schAmt;
|
|
$tradeDisc = (float)($it['discount_percent'] ?? 0);
|
|
$afterSch = max(0, $gross - $schTotal);
|
|
$tradeDiscAmt = ($tradeDisc > 0) ? round($afterSch * $tradeDisc / 100, 2) : 0;
|
|
$rowDisc = $schTotal + $tradeDiscAmt;
|
|
|
|
$totalGross += $gross;
|
|
$totalDiscount += $rowDisc;
|
|
|
|
$cgstPer = (float)($it['cgst_percent'] ?? 0);
|
|
$sgstPer = (float)($it['sgst_percent'] ?? 0);
|
|
$igstPer = (float)($it['igst_percent'] ?? 0);
|
|
|
|
$isInter = (!empty($grn['gst_type']) && $grn['gst_type'] === 'inter_state') || ($igstPer > 0);
|
|
$gstLabel = $isInter
|
|
? number_format($igstPer, 1) . '% IGST'
|
|
: number_format($cgstPer + $sgstPer, 0) . '% (' . number_format($cgstPer, 1) . '+' . number_format($sgstPer, 1) . '%)';
|
|
|
|
$taxableAmt = isset($it['taxable_amount']) ? (float)$it['taxable_amount'] : ($gross - $rowDisc);
|
|
$totalAmt = isset($it['total_amount']) ? (float)$it['total_amount'] : ($taxableAmt + ($taxableAmt * ($cgstPer + $sgstPer + $igstPer) / 100));
|
|
?>
|
|
<tr>
|
|
<td><?= $idx + 1 ?></td>
|
|
<td>
|
|
<strong><?= esc($it['item_name'] ?? 'Item') ?></strong>
|
|
<?php if (!empty($it['rejected_packs']) && (float)$it['rejected_packs'] > 0): ?>
|
|
<small class="d-block text-danger">Damaged: <?= (float)$it['rejected_packs'] ?> (<?= esc($it['rejection_reason'] ?? 'Damaged') ?>)</small>
|
|
<?php endif; ?>
|
|
</td>
|
|
<td><span class="badge bg-light text-dark font-monospace border"><?= esc($it['batch_no'] ?? '-') ?></span></td>
|
|
<td><?= !empty($it['expiry_date']) ? date('d-M-Y', strtotime($it['expiry_date'])) : '-' ?></td>
|
|
<td class="text-center"><?= (int)($it['packing'] ?? 1) ?>s</td>
|
|
<td class="text-center fw-bold"><?= $recPacks ?></td>
|
|
<td class="text-center text-success"><?= (float)($it['free_packs'] ?? 0) ?></td>
|
|
<td class="text-end">₹<?= number_format($rate, 2) ?></td>
|
|
<td class="text-end">₹<?= number_format((float)($it['mrp'] ?? 0), 2) ?></td>
|
|
<td class="text-end font-monospace">₹<?= number_format($gross, 2) ?></td>
|
|
<td class="text-center"><?= number_format($tradeDisc, 1) ?>%</td>
|
|
<td class="text-end text-muted font-monospace">₹<?= number_format($schTotal, 2) ?></td>
|
|
<td class="text-end font-monospace fw-semibold">₹<?= number_format($taxableAmt, 2) ?></td>
|
|
<td class="text-center small"><?= esc($gstLabel) ?></td>
|
|
<td class="text-end font-monospace fw-semibold">₹<?= number_format($totalAmt, 2) ?></td>
|
|
<td class="text-center">
|
|
<?php if (!empty($it['purchase_item_id'])): ?>
|
|
<span class="badge bg-success font-monospace">Item #<?= (int)$it['purchase_item_id'] ?></span>
|
|
<?php else: ?>
|
|
<span class="text-muted">Pending Post</span>
|
|
<?php endif; ?>
|
|
</td>
|
|
</tr>
|
|
<?php endforeach; ?>
|
|
<?php endif; ?>
|
|
</tbody>
|
|
<tfoot class="table-light">
|
|
<tr>
|
|
<th colspan="12" class="text-end text-muted">Sub Total (Gross Amount):</th>
|
|
<th colspan="3" class="text-end font-monospace">₹<?= number_format($totalGross, 2) ?></th>
|
|
<th></th>
|
|
</tr>
|
|
<tr>
|
|
<th colspan="12" class="text-end text-muted">Total Discount (Trade & Scheme):</th>
|
|
<th colspan="3" class="text-end font-monospace text-danger">₹<?= number_format($totalDiscount, 2) ?></th>
|
|
<th></th>
|
|
</tr>
|
|
<tr>
|
|
<th colspan="12" class="text-end text-dark">Taxable Amount:</th>
|
|
<th colspan="3" class="text-end font-monospace fw-bold">₹<?= number_format((float)($grn['total_received_amount'] ?? $totalGross), 2) ?></th>
|
|
<th></th>
|
|
</tr>
|
|
<?php if (!empty($grn['gst_type']) && $grn['gst_type'] === 'inter_state'): ?>
|
|
<tr>
|
|
<th colspan="12" class="text-end text-muted">IGST Amount:</th>
|
|
<th colspan="3" class="text-end font-monospace text-primary">₹<?= number_format((float)($grn['igst_amount'] ?? ($grn['total_tax_amount'] ?? 0)), 2) ?></th>
|
|
<th></th>
|
|
</tr>
|
|
<?php else: ?>
|
|
<tr>
|
|
<th colspan="12" class="text-end text-muted">CGST Amount:</th>
|
|
<th colspan="3" class="text-end font-monospace text-primary">₹<?= number_format((float)($grn['cgst_amount'] ?? (((float)($grn['total_tax_amount'] ?? 0)) / 2)), 2) ?></th>
|
|
<th></th>
|
|
</tr>
|
|
<tr>
|
|
<th colspan="12" class="text-end text-muted">SGST Amount:</th>
|
|
<th colspan="3" class="text-end font-monospace text-primary">₹<?= number_format((float)($grn['sgst_amount'] ?? (((float)($grn['total_tax_amount'] ?? 0)) / 2)), 2) ?></th>
|
|
<th></th>
|
|
</tr>
|
|
<?php endif; ?>
|
|
<tr>
|
|
<th colspan="12" class="text-end text-dark">Total GST:</th>
|
|
<th colspan="3" class="text-end font-monospace fw-bold">₹<?= number_format((float)($grn['total_tax_amount'] ?? 0), 2) ?></th>
|
|
<th></th>
|
|
</tr>
|
|
<?php if (isset($grn['round_off']) && (float)$grn['round_off'] != 0): ?>
|
|
<tr>
|
|
<th colspan="12" class="text-end text-muted">Round Off:</th>
|
|
<th colspan="3" class="text-end font-monospace"><?= ((float)$grn['round_off'] > 0 ? '+' : '') . number_format((float)$grn['round_off'], 2) ?></th>
|
|
<th></th>
|
|
</tr>
|
|
<?php endif; ?>
|
|
<tr class="table-success">
|
|
<th colspan="12" class="text-end fs-6">Net Inward Bill Total (Grand Total):</th>
|
|
<th colspan="3" class="text-end fs-6 font-monospace text-success fw-bold">₹<?= number_format((float)($grn['net_amount'] ?? 0), 2) ?></th>
|
|
<th></th>
|
|
</tr>
|
|
</tfoot>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="card p-3 border-0 bg-light">
|
|
<div class="d-flex justify-content-between align-items-center flex-wrap gap-2">
|
|
<div>
|
|
<?php if (($grn['status'] ?? '') === 'posted_to_inventory'): ?>
|
|
<span class="text-success fw-bold">
|
|
<i class="bi bi-check-circle-fill"></i> Posted to Live Store Inventory (Purchase Bill Ref #<?= (int)($grn['purchase_id'] ?? 0) ?>)
|
|
</span>
|
|
<?php else: ?>
|
|
<span class="text-warning fw-bold">
|
|
<i class="bi bi-clock-history"></i> Verified by Pharmacist • Ready to Post to Live Hospital Inventory
|
|
</span>
|
|
<?php endif; ?>
|
|
</div>
|
|
<div class="d-flex gap-2">
|
|
<?php if (!empty($grn['grn_id'])): ?>
|
|
<button type="button" class="btn btn-warning" onclick="load_form_div('<?= base_url('Medical/grn_edit/' . (int)$grn['grn_id']) ?>','medical-main','Edit GRN Inspection');">
|
|
<i class="bi bi-pencil-square"></i> Edit GRN
|
|
</button>
|
|
<?php endif; ?>
|
|
<?php if (($grn['status'] ?? '') !== 'posted_to_inventory' && !empty($grn['grn_id'])): ?>
|
|
<button type="button" class="btn btn-success px-4" onclick="postGrnToLiveInventory(<?= (int)$grn['grn_id'] ?>)">
|
|
<i class="bi bi-box-arrow-in-down"></i> Post to Live Inventory
|
|
</button>
|
|
<?php elseif (!empty($grn['purchase_id'])): ?>
|
|
<a href="javascript:load_form_div('<?= base_url('Medical/PurchaseInvoiceEdit/' . (int)$grn['purchase_id']) ?>','medical-main');" class="btn btn-outline-primary btn-sm">
|
|
<i class="bi bi-receipt"></i> View Purchase Invoice
|
|
</a>
|
|
<?php endif; ?>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<script>
|
|
function postGrnToLiveInventory(grnId) {
|
|
if (!confirm('Confirm posting verified items into live pharmacy store inventory? This will generate live batches and update available stock.')) return;
|
|
|
|
$.post('<?= base_url('Medical/grn_post_inventory/') ?>' + grnId, {}, function(data) {
|
|
alert(data.message || 'Done');
|
|
if (data.status) {
|
|
load_form_div('<?= base_url('Medical/grn_detail/') ?>' + grnId, 'medical-main', 'GRN Inspection Detail');
|
|
}
|
|
}, 'json').fail(function() {
|
|
alert('Error posting GRN.');
|
|
});
|
|
}
|
|
</script>
|