View Code - 20260723

kasab_preview.php | 20260723_000646.php Initial Domain Snapshot

<?php
/* ======================================================
   File: /erp/kasab_view.php
   Purpose: View Kasab Data with Date Filter
   ====================================================== */
error_reporting(E_ALL);
ini_set('display_errors', 1);

require_once __DIR__ . '/modules/auth/page_acl.php'; 
$ctx = page_require_access('kasab_preview');
$pdo = $ctx['pdo'];

// फिल्टर वैल्यूज प्राप्त करें
$from_date = $_GET['from_date'] ?? date('Y-m-01'); // महीने की पहली तारीख
$to_date = $_GET['to_date'] ?? date('Y-m-d');    // आज की तारीख

// SQL Query with Date Filter
$sql = "SELECT * FROM kasab_entry 
        WHERE entry_date BETWEEN ? AND ? 
        ORDER BY entry_date DESC, id DESC";
$stmt = $pdo->prepare($sql);
$stmt->execute([$from_date, $to_date]);
$entries = $stmt->fetchAll(PDO::FETCH_ASSOC);

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

<div class="mb-4">
        <h4 class="fw-bold">
            Kasab Stock View 
            <span class="text-muted fs-6">| Date-wise Reports</span>
        </h4>
    </div>

<div class="card shadow-sm mb-4">
        <div class="card-body">

<div class="col-md-3">
                        <label class="form-label">From Date</label>
                        <input type="date" name="from_date" value="<?= $from_date ?>" class="form-control">
                    </div>

<div class="col-md-3">
                        <label class="form-label">To Date</label>
                        <input type="date" name="to_date" value="<?= $to_date ?>" class="form-control">
                    </div>

<div class="col-md-3 d-flex gap-2">
                        <button type="submit" class="btn btn-primary w-100">
                            Filter Data
                        </button>
                        <a href="kasab_view.php" class="btn btn-outline-secondary w-100">
                            Reset
                        </a>
                    </div>

</div>
            </form>

</div>
    </div>

<?php if (empty($entries)): ?>
        <div class="card shadow-sm mb-4">
            <div class="card-body text-center text-muted">
                इस तारीख के बीच कोई डेटा नहीं मिला।
            </div>
        </div>
    <?php endif; ?>

<?php foreach($entries as $row):

$weightsData = json_decode($row['weight_json'], true);
        $rollsData   = json_decode($row['rolls_json'], true);

$weights = $weightsData['weights'] ?? $weightsData;
        $rolls   = $rollsData['rolls'] ?? $rollsData;
    ?>

<div class="card-header bg-light d-flex justify-content-between align-items-center">

<span class="ms-3 fw-semibold">
                    Color: <?= htmlspecialchars($row['color']) ?>
                </span>

<a href="kasab_edit.php?id=<?= $row['id'] ?>" 
               class="btn btn-sm btn-outline-primary">
                Edit Entry
            </a>

</div>

<div class="card-body p-0">

<div class="table-responsive">
                <table class="table table-bordered table-striped mb-0 text-center">
                    <thead class="table-light">
                        <tr>
                            <th style="width:60px;">#</th>
                            <th>Rolls</th>
                            <th>Weight (kg)</th>
                            <th>Avg / Roll</th>
                        </tr>
                    </thead>
                    <tbody>

<?php 
                        $sum_wt = 0; 
                        $sum_rl = 0;

if(is_array($weights)):
                            foreach($weights as $index => $wt):

$rl = is_array($rolls) 
                                    ? ($rolls[$index] ?? 0) 
                                    : (float)$rolls;

$avg = ($rl > 0) ? ($wt / $rl) : 0;

$sum_wt += (float)$wt;
                                $sum_rl += (float)$rl;
                        ?>

<?php endforeach; endif; ?>

</tbody>

<tfoot class="table-secondary fw-bold">
                        <tr>
                            <td>Total</td>
                            <td><?= $sum_rl ?></td>
                            <td><?= number_format($sum_wt, 3) ?></td>
                            <td>
                                <?= ($sum_rl > 0) 
                                    ? number_format($sum_wt / $sum_rl, 4) 
                                    : '0.0000' ?>
                            </td>
                        </tr>
                    </tfoot>

</table>
            </div>

</div>
    </div>

<?php endforeach; ?>

</div>

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