View Code - 20260721

master_stock_report.php | 20260721_154033.php Initial Bulk Import

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

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

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

/* ===== GRAY ===== */
$gray = $pdo->query("
SELECT IFNULL(SUM(balance),0)
FROM gray_stock
WHERE company_id=$company_id
")->fetchColumn();

$gray_saree = $gray / 5.20;

/* ===== CUTTING ===== */
$cutting = $pdo->query("
SELECT IFNULL(SUM(balance_pcs),0)
FROM cutting_stock
WHERE company_id=$company_id
")->fetchColumn();

/* ===== VA SEND ===== */
$va_send = $pdo->query("
SELECT IFNULL(SUM(pcs),0)
FROM va_send_entry
WHERE company_id=$company_id
")->fetchColumn();

/* ===== VA RECEIVE ===== */
$va_receive = $pdo->query("
SELECT IFNULL(SUM(total_pcs),0)
FROM va_receive_entry
WHERE company_id=$company_id
")->fetchColumn();

$va_pending = max($va_send - $va_receive, 0);

/* ===== WORK ===== */
$work = $pdo->query("
SELECT IFNULL(SUM(balance),0)
FROM work_saree_stock
WHERE company_id=$company_id
")->fetchColumn();

/* ===== GRAND TOTAL (PCS BASED) ===== */
$grand_total = $cutting + $va_pending + $work;
?>

<h4>Master Stock Report</h4>

<tr>
<td><b>Gray Stock</b></td>
<td>
<?= number_format($gray,2) ?> mtr
<br>
<small class="text-muted">≈ <?= number_format($gray_saree,0) ?> Saree</small>
</td>
</tr>

<tr>
<td><b>Cutting Stock</b></td>
<td><?= number_format($cutting,0) ?> pcs</td>
</tr>

<tr>
<td><b>VA Pending</b></td>
<td><?= number_format($va_pending,0) ?> pcs</td>
</tr>

<tr>
<td><b>Work Saree Stock</b></td>
<td><?= number_format($work,0) ?> pcs</td>
</tr>

<tr style="background:#f1f1f1;">
<td><b>Grand Total (PCS)</b></td>
<td><b><?= number_format($grand_total,0) ?> pcs</b></td>
</tr>

</table>

</div>
</div>

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