« Back to History
cutting_stock.php
|
20260722_120325.php
Initial Domain Snapshot
Copy Code
<?php require_once __DIR__ . '/modules/auth/page_acl.php'; $ctx = page_require_access('cutting_stock'); $pdo = $ctx['pdo']; $company_id = (int)$ctx['company_id']; require_once __DIR__ . '/partials/header.php'; /* ===== FETCH ===== */ $stmt = $pdo->prepare(" SELECT cs.quality, fq.quality_name, cs.in_pcs, cs.out_pcs, cs.balance_pcs FROM cutting_stock cs LEFT JOIN fabric_quality_master fq ON fq.id = cs.quality AND fq.company_id = cs.company_id WHERE cs.company_id = :cid ORDER BY fq.quality_name "); $stmt->execute([':cid'=>$company_id]); $data = $stmt->fetchAll(PDO::FETCH_ASSOC); ?> <div class="container mt-4"> <div class="card p-3"> <h4>Cutting Stock (PCS)</h4> <table class="table table-bordered table-sm"> <thead> <tr> <th>Quality</th> <th>In PCS</th> <th>Out PCS</th> <th>Balance PCS</th> </tr> </thead> <tbody> <?php foreach($data as $r): ?> <tr> <td><?= htmlspecialchars($r['quality_name']) ?></td> <td><?= $r['in_pcs'] ?></td> <td><?= $r['out_pcs'] ?></td> <td><b><?= $r['balance_pcs'] ?></b></td> </tr> <?php endforeach; ?> </tbody> </table> </div> </div> <?php require_once __DIR__ . '/partials/footer.php'; ?>