« Back to History
company_beam_stock_report.php
|
20261118_125741.php
Initial Domain Snapshot
Copy Code
<?php require_once __DIR__ . '/modules/auth/page_acl.php'; $ctx = page_require_access('company_beam_stock_report'); error_reporting(E_ALL); ini_set('display_errors', 1); $company_id = (int)($ctx['company_id'] ?? 0); $pdo = $ctx['pdo'] ?? null; if (!$pdo) { require_once __DIR__ . '/core/db.php'; } if (!$pdo) { die('PDO not available'); } $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); if (!function_exists('h')) { function h($v) { return htmlspecialchars((string)$v, ENT_QUOTES, 'UTF-8'); } } /* ================= FINAL QUERY ================= */ $sql = " SELECT q.name AS quality_name, COUNT(DISTINCT CONCAT(s.beam_no,'_',s.warp_date)) AS total_beams, SUM(s.taka) AS total_taka FROM company_beam_stock s JOIN beam_qualities q ON q.id = s.quality_id WHERE s.company_id = :cid AND s.load_type = 'stock' GROUP BY q.id, q.name ORDER BY q.name "; $stmt = $pdo->prepare($sql); $stmt->execute(['cid' => $company_id]); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); require_once __DIR__ . '/partials/header.php'; ?> <div class="card"> <div class="card-header"> <h3>Beam Stock Summary (All Qualities)</h3> </div> <div class="card-body"> <table class="table table-bordered table-striped"> <thead> <tr> <th>Quality Name</th> <th>Total Beams (Stock)</th> <th>Total Taka</th> </tr> </thead> <tbody> <?php if (!$rows): ?> <tr> <td colspan="3" class="text-center">No stock data</td> </tr> <?php else: foreach ($rows as $r): ?> <tr> <td><?= h($r['quality_name']) ?></td> <td><?= (int)$r['total_beams'] ?></td> <td><?= number_format((float)$r['total_taka'], 2) ?></td> </tr> <?php endforeach; endif; ?> </tbody> </table> </div> </div> <?php require_once __DIR__ . '/partials/footer.php'; ?>