View Code - 20260921

machine_avg_report.php | 20260921_175631.php Initial Domain Snapshot

<?php
/* machine_avg_report.php
   - Summary/Full report
   - Export CSV + Print
   - Update machine_avg table (create + upsert)
   - Behavior: NO DAY SKIPPING. Every calendar day in range counts as a FULL day.
     avg_per_day = total_meters_in_range / total_calendar_days_in_range
*/

/* ---- Auth + DB bootstrap ---- */
require_once __DIR__ . '/modules/auth/page_acl.php';
$ctx = page_require_access('machine_avg_report');
$u   = $ctx['user'] ?? null;

$COMPANY_ID = (int)($ctx['company_id'] ?? 0);
$USER_ID    = (int)($u['id'] ?? 0);
$pdo        = $ctx['pdo'] ?? null;
if (!($pdo instanceof PDO)) require __DIR__ . '/core/db.php';

if (!function_exists('h')) { function h($s){ return htmlspecialchars((string)$s, ENT_QUOTES, 'UTF-8'); } }

/* ---- Inputs ---- */
$default_to = date('Y-m-d');
$default_from = date('Y-m-d', strtotime('-29 days'));
$from = $_GET['from'] ?? $default_from;
$to   = $_GET['to'] ?? $default_to;
$machine_filter = $_GET['machine_id'] ?? 'all';
$export = $_GET['export'] ?? null;
$export_mode = $_GET['mode'] ?? 'full'; // 'full' or 'summary'

$from_dt = DateTime::createFromFormat('Y-m-d', $from);
$to_dt   = DateTime::createFromFormat('Y-m-d', $to);
if (!$from_dt || !$to_dt) { $from = $default_from; $to = $default_to; $from_dt = DateTime::createFromFormat('Y-m-d', $from); $to_dt = DateTime::createFromFormat('Y-m-d', $to); }

/* ---- Compute total calendar days in range (inclusive) - used for summary / avg denominator ---- */
$period_interval = $from_dt->diff($to_dt);
$total_days_in_range = (int)$period_interval->days + 1;
if ($total_days_in_range < 1) $total_days_in_range = 1; // safety

/* ---- Load qualities (avg_per_day_pro) ---- */
$qualities = [];
try {
    $qsql = "SELECT id, COALESCE(quality_name,'') AS qname, COALESCE(quality_code,'') AS qcode, COALESCE(avg_per_day_pro,0) AS per_day
             FROM qualities
             WHERE company_id = :cid";
    $qstmt = $pdo->prepare($qsql);
    $qstmt->execute([':cid'=>$COMPANY_ID]);
    foreach ($qstmt->fetchAll(PDO::FETCH_ASSOC) as $r) {
        $qualities[(int)$r['id']] = [
            'name' => $r['qname'],
            'code' => $r['qcode'],
            'per_day' => (float)$r['per_day']
        ];
    }
} catch (Exception $e) {
    $qualities = [];
}

/* ---- Load karigar names from loom_karigar_master ---- */
$karigar_names = [];
try {
    $ksql = "SELECT id, COALESCE(karigar_name, '') AS name FROM loom_karigar_master WHERE company_id = :cid";
    $kstmt = $pdo->prepare($ksql);
    $kstmt->execute([':cid'=>$COMPANY_ID]);
    foreach ($kstmt->fetchAll(PDO::FETCH_ASSOC) as $r) {
        $karigar_names[(int)$r['id']] = $r['name'];
    }
} catch (Exception $e) {
    $karigar_names = [];
}

/* ---- Fetch production_entry rows for date range ---- */
$params = [':cid'=>$COMPANY_ID, ':from'=>$from, ':to'=>$to];
$sql = "SELECT id, machine_id, entry_date, meter_total, lines_json, quality_id
        FROM production_entry
        WHERE company_id = :cid
          AND entry_date BETWEEN :from AND :to";
if ($machine_filter !== 'all') { $sql .= " AND machine_id = :mid"; $params[':mid'] = (int)$machine_filter; }
$sql .= " ORDER BY machine_id, entry_date, id";

try {
    $stmt = $pdo->prepare($sql);
    $stmt->execute($params);
    $prod_rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch (Exception $e) {
    $prod_rows = [];
    $error_msg = "DB error: " . $e->getMessage();
}

/* ---- Fetch pissing entries for machines present (we will still show pissing as a reason in detail) ---- */
$machines_in_data = [];
foreach ($prod_rows as $r) $machines_in_data[(int)$r['machine_id']] = true;
$machines_list = array_keys($machines_in_data);
$pissing_map = [];
if (!empty($machines_list)) {
    $in = implode(',', array_map('intval', $machines_list));
    $psql = "SELECT machine, entry_date FROM pissing_entry
            WHERE company_id = :cid
              AND entry_date BETWEEN :from AND :to
              AND machine IN ($in)";
    try {
        $pstmt = $pdo->prepare($psql);
        $pstmt->execute([':cid'=>$COMPANY_ID, ':from'=>$from, ':to'=>$to]);
        foreach ($pstmt->fetchAll(PDO::FETCH_ASSOC) as $r) {
            $mid = (int)$r['machine'];
            $d = $r['entry_date'];
            $pissing_map[$mid][$d] = true;
        }
    } catch (Exception $e) { /* ignore */ }
}

/* ---- Aggregate per machine+date: total meter, per-karigar meters, quality votes, last_non_null ---- */
$agg = [];
foreach ($prod_rows as $r) {
    $mid = (int)$r['machine_id'];
    $date = $r['entry_date'];
    $meter = (float)$r['meter_total'];
    if (!isset($agg[$mid])) $agg[$mid] = [];
    if (!isset($agg[$mid][$date])) $agg[$mid][$date] = [
        'meter' => 0.0,
        'karigars' => [],               // set of karigar ids
        'per_karigar_meter' => [],      // [karigar_id => meter_sum]
        'quality_votes' => [],
        'last_quality_id' => null
    ];
    $agg[$mid][$date]['meter'] += $meter;

// parse lines_json to extract karigar meters (if present)
    if (!empty($r['lines_json'])) {
        $json = json_decode($r['lines_json'], true);
        if (is_array($json)) {
            foreach ($json as $item) {
                if (is_array($item) && isset($item['karigar_id'])) {
                    $kid = (int)$item['karigar_id'];
                    $km = isset($item['meter']) ? (float)$item['meter'] : 0.0;
                    if ($kid) {
                        $agg[$mid][$date]['karigars'][$kid] = true;
                        if (!isset($agg[$mid][$date]['per_karigar_meter'][$kid])) $agg[$mid][$date]['per_karigar_meter'][$kid] = 0.0;
                        $agg[$mid][$date]['per_karigar_meter'][$kid] += $km;
                    }
                }
            }
        }
    }

// quality votes and safe last non-null assignment
    $qid = $r['quality_id'] !== null ? (int)$r['quality_id'] : null;
    if ($qid && $qid > 0) {
        if (!isset($agg[$mid][$date]['quality_votes'][$qid])) $agg[$mid][$date]['quality_votes'][$qid] = 0;
        $agg[$mid][$date]['quality_votes'][$qid] += 1;
        $agg[$mid][$date]['last_quality_id'] = $qid; // safe: only set when >0
    }
}

/* ---- Build report (detail rows) and compute total meters per machine in range ----
   IMPORTANT: We do NOT skip any days for summary. For detail rows, we preserve original labels/reasons
   but set every day's day_equiv = 1 (full day).
*/
$report = [];
$sum_meter_per_machine = []; // total meter across range per machine (ignores previous inclusion rules)
foreach ($agg as $mid => $dates) {
    $report[$mid] = ['rows'=>[], 'sum_meter'=>0.0, 'sum_days'=>0.0];
    $sum_meter_per_machine[$mid] = 0.0;

foreach ($dates as $date => $info) {
        $daily_total = $info['meter'];
        $sum_meter_per_machine[$mid] += $daily_total;

$per_karigar = $info['per_karigar_meter'] ?? [];
        $karigar_ids = array_keys($info['karigars'] ?? []);

// pick quality_id (mode, tie -> last_non_null, fallback)
        $picked_qid = null;
        $raw_votes = $info['quality_votes'] ?? [];
        $clean_votes = [];
        foreach ($raw_votes as $k => $v) {
            $kint = (int)$k;
            if ($kint > 0) $clean_votes[$kint] = (int)$v;
        }
        if (!empty($clean_votes)) {
            $max = 0; $modes = [];
            foreach ($clean_votes as $qid => $cnt) {
                if ($cnt > $max) { $max = $cnt; $modes = [$qid]; }
                elseif ($cnt === $max) $modes[] = $qid;
            }
            if (count($modes) === 1) $picked_qid = $modes[0];
            else {
                $last = $info['last_quality_id'] ?? null;
                if ($last && in_array((int)$last, $modes, true)) $picked_qid = (int)$last;
                else { sort($modes, SORT_NUMERIC); $picked_qid = $modes[0]; }
            }
        } else {
            $picked_qid = $info['last_quality_id'] ?? null;
        }

// per-day expected (from qualities), fallback to average if missing
        $per_day_expected = 0.0;
        if ($picked_qid && isset($qualities[$picked_qid])) $per_day_expected = (float)$qualities[$picked_qid]['per_day'];
        else {
            $vals = array_column($qualities, 'per_day');
            if (!empty($vals)) $per_day_expected = array_sum($vals) / count($vals);
        }
        $per_shift_expected = $per_day_expected > 0 ? ($per_day_expected / 2.0) : 0.0;

// pissing checks (used only to label/detail reason; DOES NOT exclude day)
        $pissing_here = isset($pissing_map[$mid][$date]);
        $prev_date = date('Y-m-d', strtotime($date . ' -1 day'));
        $pissing_prev = isset($pissing_map[$mid][$prev_date]);

// Build reason label but we do NOT exclude or half-count days
        $reason_parts = [];
        if ($pissing_here) $reason_parts[] = 'pissing_on_date';
        if ($pissing_prev) $reason_parts[] = 'pissing_prev_date';
        if (empty($reason_parts)) $reason_parts[] = 'ok';

// Always count as full day in detail and summary
        $day_equiv = 1.0;
        $reason = implode(';', $reason_parts);

// prepare per_karigar display map using names when possible
        $per_karigar_display = [];
        foreach ($per_karigar as $kid => $km) {
            $kname = $karigar_names[$kid] ?? ("#{$kid}");
            $per_karigar_display["{$kname} ({$kid})"] = $km;
        }

// prepare karigar names list
        $karigar_names_list = [];
        foreach ($karigar_ids as $kid) {
            $kname = $karigar_names[$kid] ?? ("#{$kid}");
            $karigar_names_list[] = "{$kname} ({$kid})";
        }

// append detail row
        $report[$mid]['rows'][] = [
            'date'=>$date,
            'meter'=>$daily_total,
            'karigar_ids'=>$karigar_ids,
            'karigars_display'=>$karigar_names_list,
            'per_karigar'=>$per_karigar_display,
            'picked_quality_id'=>$picked_qid,
            'picked_quality_name'=> $picked_qid && isset($qualities[$picked_qid]) ? $qualities[$picked_qid]['name'] : '',
            'picked_quality_code'=> $picked_qid && isset($qualities[$picked_qid]) ? $qualities[$picked_qid]['code'] : '',
            'per_day_expected'=>$per_day_expected,
            'per_shift_expected'=>$per_shift_expected,
            // IMPORTANT: all days count as full day
            'day_equiv'=> $day_equiv,
            'reason'=>$reason
        ];
    }

// For machines present in agg, set report sums to totals over range using full-day logic
    $report[$mid]['sum_meter'] = $sum_meter_per_machine[$mid];
    $report[$mid]['sum_days']  = $total_days_in_range;
}

/* ---- Prepare summary array (NO DAYS SKIPPED; all days are FULL) ----
   For machines that had no production rows in range but exist in machine table we will add zero rows later.
*/
$summary = [];
$all_machine_ids = array_unique(array_merge(array_keys($sum_meter_per_machine), array_keys($report)));
foreach ($all_machine_ids as $mid) {
    $sum_meter = isset($sum_meter_per_machine[$mid]) ? $sum_meter_per_machine[$mid] : 0.0;
    $sum_days = $total_days_in_range;
    $avg = $sum_days > 0 ? round($sum_meter / $sum_days, 3) : 0;
    $summary[$mid] = [
        'machine_id' => $mid,
        'machine_name' => null, // will be filled from machines table
        'sum_meter' => $sum_meter,
        'sum_days' => $sum_days,
        'avg' => $avg
    ];
}

/* ---- Handler: create+populate machine_avg table on demand ----
   Upsert uses calendar days (full days) and sum_meter computed above.
*/
if ($_SERVER['REQUEST_METHOD'] === 'POST' && ($_POST['action'] ?? '') === 'update_machine_avg') {
    // optional CSRF: if you use CSRF tokens in session, validate
    if (isset($_SESSION['csrf_token']) && isset($_POST['csrf_token']) && $_POST['csrf_token'] !== $_SESSION['csrf_token']) {
        $error_msg = "CSRF token mismatch. Update aborted.";
    } else {
        try {
            // create table if not exists
            $createSql = "CREATE TABLE IF NOT EXISTS machine_avg (
                id BIGINT AUTO_INCREMENT PRIMARY KEY,
                company_id INT NOT NULL,
                machine_id INT NOT NULL,
                period_from DATE NOT NULL,
                period_to DATE NOT NULL,
                sum_meter DOUBLE DEFAULT 0,
                sum_days DOUBLE DEFAULT 0,
                avg_per_day DOUBLE DEFAULT 0,
                updated_by INT DEFAULT NULL,
                updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                INDEX idx_company_machine (company_id, machine_id),
                UNIQUE KEY uniq_period (company_id, machine_id, period_from, period_to)
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;";
            $pdo->exec($createSql);

// prepare upsert statement (MySQL)
            $upsertSql = "INSERT INTO machine_avg
                (company_id, machine_id, period_from, period_to, sum_meter, sum_days, avg_per_day, updated_by)
                VALUES (:cid, :mid, :pfrom, :pto, :sum_meter, :sum_days, :avg, :updated_by)
                ON DUPLICATE KEY UPDATE
                  sum_meter = VALUES(sum_meter),
                  sum_days = VALUES(sum_days),
                  avg_per_day = VALUES(avg_per_day),
                  updated_by = VALUES(updated_by),
                  updated_at = CURRENT_TIMESTAMP";
            $upsertStmt = $pdo->prepare($upsertSql);

// begin transaction
            $pdo->beginTransaction();

$inserted = 0;
            foreach ($summary as $mid => $s) {
                // respect optional filter from POST
                if (!empty($_POST['machine_id']) && $_POST['machine_id'] !== 'all' && (int)$_POST['machine_id'] !== (int)$mid) continue;

$avg = isset($s['avg']) ? (float)$s['avg'] : ( (isset($s['sum_days']) && $s['sum_days']>0) ? ($s['sum_meter']/$s['sum_days']) : 0.0 );

$upsertStmt->execute([
                    ':cid' => $COMPANY_ID,
                    ':mid' => (int)$mid,
                    ':pfrom' => $from,
                    ':pto' => $to,
                    ':sum_meter' => (float)($s['sum_meter'] ?? 0.0),
                    ':sum_days' => (float)($s['sum_days'] ?? $total_days_in_range),
                    ':avg' => $avg,
                    ':updated_by' => $USER_ID ?: null
                ]);
                $inserted++;
            }

$pdo->commit();
            $success_msg = "machine_avg updated for {$inserted} machine(s) for period {$from} to {$to} (using {$total_days_in_range} calendar day(s) per machine).";
        } catch (Exception $e) {
            if ($pdo->inTransaction()) $pdo->rollBack();
            $error_msg = "Failed to update machine_avg: " . $e->getMessage();
        }
    }
}

/* ---- Machines list for dropdown and names for summary ---- */
$machines = [];
try {
    $mstmt = $pdo->prepare("SELECT id, COALESCE(name, CONCAT('Machine ', id)) AS name FROM machines WHERE company_id = :cid ORDER BY id");
    $mstmt->execute([':cid'=>$COMPANY_ID]);
    foreach ($mstmt->fetchAll(PDO::FETCH_ASSOC) as $r) {
        $machines[(int)$r['id']] = $r['name'];
        if (isset($summary[(int)$r['id']])) $summary[(int)$r['id']]['machine_name'] = $r['name'];
    }
} catch (Exception $e) {
    foreach (array_keys($summary) as $mid) {
        $machines[$mid] = "Machine {$mid}";
        if (isset($summary[$mid]) && !$summary[$mid]['machine_name']) $summary[$mid]['machine_name'] = "Machine {$mid}";
    }
}

/* ---- CSV export: full or summary ---- */
if ($export === 'csv') {
    if ($export_mode === 'summary') {
        $fn = "machine_summary_{$from}_to_{$to}.csv";
        header('Content-Type: text/csv; charset=utf-8');
        header('Content-Disposition: attachment; filename="'.basename($fn).'"');
        $out = fopen('php://output','w');
        fputcsv($out, ['machine_id','machine_name','included_meter_sum','included_days','avg_per_day']);
        foreach ($summary as $s) {
            fputcsv($out, [$s['machine_id'], $s['machine_name'] ?? "Machine {$s['machine_id']}", $s['sum_meter'], $s['sum_days'], $s['avg']]);
        }
        fclose($out); exit;
    } else {
        // full export (detail)
        $fn = "machine_avg_{$from}_to_{$to}.csv";
        header('Content-Type: text/csv; charset=utf-8');
        header('Content-Disposition: attachment; filename="'.basename($fn).'"');
        $out = fopen('php://output','w');
        fputcsv($out, ['machine_id','machine_name','date','picked_quality_id','picked_quality_code','picked_quality_name','per_day_expected','per_shift_expected','meter','day_equiv','reason','per_karigar_json']);
        foreach ($report as $mid => $info) {
            $mname = $machines[$mid] ?? "Machine {$mid}";
            foreach ($info['rows'] as $r) {
                fputcsv($out, [
                    $mid,
                    $mname,
                    $r['date'],
                    $r['picked_quality_id'],
                    $r['picked_quality_code'],
                    $r['picked_quality_name'],
                    $r['per_day_expected'],
                    $r['per_shift_expected'],
                    $r['meter'],
                    $r['day_equiv'],
                    $r['reason'],
                    json_encode($r['per_karigar'])
                ]);
            }
            // summary row (uses full calendar days)
            $sum_meter = $summary[$mid]['sum_meter'] ?? 0;
            $sum_days = $summary[$mid]['sum_days'] ?? $total_days_in_range;
            fputcsv($out, [$mid, $mname, 'SUMMARY', '', '', '', '', '', $sum_meter, $sum_days, '', '']);
        }
        fclose($out); exit;
    }
}

/* ---- Render UI ---- */
require_once __DIR__ . '/partials/header.php';
?>
<style>
.no-print { display: inline-block; }
@media print { .no-print { display: none !important; } }
.summary-table { width:100%; border-collapse: collapse; margin-bottom:1rem; }
.summary-table th, .summary-table td { border: 1px solid #ddd; padding: 8px; text-align:left; }
.summary-card { padding: 10px; background: #f7f7f7; border-radius:4px; margin-bottom:1rem; }
</style>

<div class="card">
  <div class="card-header">
    <h3>Machine — Per-day AVG (no skipping; all days counted full)</h3>
    <p>Company: <?php echo h($COMPANY_ID); ?> — Range: <?php echo h($from); ?> to <?php echo h($to); ?> — Days in range: <?php echo h($total_days_in_range); ?></p>
  </div>

<form method="get" class="form-inline no-print" style="margin-bottom:1rem;">
      <label style="margin-right:.5rem">From</label>
      <input type="date" name="from" value="<?php echo h($from); ?>" class="form-control" required>
      <label style="margin:0 .5rem">To</label>
      <input type="date" name="to" value="<?php echo h($to); ?>" class="form-control" required>
      <label style="margin:0 .5rem">Machine</label>
      <select name="machine_id" class="form-control">
        <option value="all" <?php echo $machine_filter==='all' ? 'selected' : ''; ?>>All machines</option>
        <?php foreach ($machines as $mid => $mname): ?>
          <option value="<?php echo h($mid); ?>" <?php echo ((string)$mid === (string)$machine_filter) ? 'selected' : ''; ?>><?php echo h($mname); ?></option>
        <?php endforeach; ?>
      </select>

<a class="btn no-print" href="<?php echo h($_SERVER['PHP_SELF'] . '?' . http_build_query(array_merge($_GET, ['export'=>'csv','mode'=>'full']))); ?>" style="margin-left:.5rem">Export CSV (full)</a>
      <a class="btn no-print" href="<?php echo h($_SERVER['PHP_SELF'] . '?' . http_build_query(array_merge($_GET, ['export'=>'csv','mode'=>'summary']))); ?>" style="margin-left:.5rem">Export CSV (summary)</a>

<button type="button" class="btn no-print" onclick="printFull()" style="margin-left:.5rem">Print Full</button>
      <button type="button" class="btn no-print" onclick="printSummary()" style="margin-left:.5rem">Print Summary</button>
    </form>

<div style="display:inline-block; margin-bottom:1rem;">
      <form id="update-machine-avg-form" method="post" style="display:inline-block; margin-left:.25rem;">
        <?php if (isset($_SESSION['csrf_token'])): ?>
          <input type="hidden" name="csrf_token" value="<?php echo h($_SESSION['csrf_token']); ?>">
        <?php endif; ?>
        <input type="hidden" name="action" value="update_machine_avg">
        <input type="hidden" name="from" value="<?php echo h($from); ?>">
        <input type="hidden" name="to" value="<?php echo h($to); ?>">
        <input type="hidden" name="machine_id" value="<?php echo h($machine_filter); ?>">
        <button type="button" class="btn no-print" onclick="confirmUpdateAvg()" title="Create / update machine_avg table and insert summary rows">Update machine_avg table</button>
      </form>
    </div>

<?php if (!empty($success_msg)): ?><div class="notice notice-success" style="margin-top:.5rem;"><?php echo h($success_msg); ?></div><?php endif; ?>
    <?php if (!empty($error_msg)): ?><div class="notice notice-danger" style="margin-top:.5rem;"><?php echo h($error_msg); ?></div><?php endif; ?>

<div id="summary-section" class="summary-card">
      <h4>Summary (every calendar day counted as FULL)</h4>
      <table class="summary-table">
        <thead>
          <tr>
            <th>Machine ID</th>
            <th>Machine</th>
            <th>Included meter (sum)</th>
            <th>Included days</th>
            <th>Avg / day</th>
          </tr>
        </thead>
        <tbody>
          <?php if (empty($summary)): ?>
            <tr><td colspan="5">No data</td></tr>
          <?php else: ?>
            <?php foreach ($summary as $mid => $s): ?>
              <tr>
                <td><?php echo h($s['machine_id']); ?></td>
                <td><?php echo h($s['machine_name'] ?? ($machines[$mid] ?? "Machine {$mid}")); ?></td>
                <td><?php echo h($s['sum_meter']); ?></td>
                <td><?php echo h($s['sum_days']); ?></td>
                <td><?php echo h($s['avg']); ?></td>
              </tr>
            <?php endforeach; ?>
          <?php endif; ?>
        </tbody>
      </table>
    </div>

<?php if (empty($report)): ?>
      <div class="notice">No production data found in selected range.</div>
    <?php else: ?>
      <?php foreach ($report as $mid => $info):
          $mname = $machines[$mid] ?? "Machine {$mid}";
          $sum_meter = $info['sum_meter'];
          $sum_days = $info['sum_days']; // this is total_days_in_range per machine
          $avg_detail = ($sum_days>0) ? round($sum_meter / $sum_days, 3) : 0;
      ?>
        <div class="card" style="margin-bottom:1rem;">
          <div class="card-header">
            <strong><?php echo h($mname); ?></strong>
            <span style="float:right;">
              Days counted (full): <?php echo h($sum_days); ?> |
              Avg/day: <?php echo h($avg_detail); ?>
            </span>
          </div>
          <div class="card-body">
            <table class="table table-striped table-sm">
              <thead>
                <tr>
                  <th>Date</th>
                  <th>Meter</th>
                  <th>Karigars</th>
                  <th>Per-karigar (meter)</th>
                  <th>Quality</th>
                  <th>Per-day exp</th>
                  <th>Per-shift exp</th>
                  <th>Day-eq</th>
                  <th>Reason</th>
                </tr>
              </thead>
              <tbody>
                <?php foreach ($info['rows'] as $r): ?>
                  <tr>
                    <td><?php echo h($r['date']); ?></td>
                    <td><?php echo h($r['meter']); ?></td>
                    <td><?php echo h(!empty($r['karigars_display']) ? implode(', ', $r['karigars_display']) : '-'); ?></td>
                    <td><?php echo h(!empty($r['per_karigar']) ? json_encode($r['per_karigar']) : '-'); ?></td>
                    <td><?php echo h(($r['picked_quality_code'] ? $r['picked_quality_code'] . ' - ' : '') . $r['picked_quality_name']); ?></td>
                    <td><?php echo h($r['per_day_expected'] ?: '-'); ?></td>
                    <td><?php echo h($r['per_shift_expected'] ?: '-'); ?></td>
                    <td><?php echo h($r['day_equiv']); ?></td>
                    <td><?php echo h($r['reason'] ?: '-'); ?></td>
                  </tr>
                <?php endforeach; ?>
                <tr class="table-footer">
                  <td><strong>Total (full-day logic)</strong></td>
                  <td><?php echo h($sum_meter); ?></td>
                  <td></td>
                  <td></td>
                  <td></td>
                  <td><?php echo h($sum_days); ?></td>
                  <td><strong><?php echo h($avg_detail); ?></strong></td>
                </tr>
              </tbody>
            </table>
          </div>
        </div>
      <?php endforeach; ?>
    <?php endif; ?>

</div>
</div>

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