soil-report-ai/dashboard/crop-analysis/water-test-data/water-analysis-pdf.php

<?php
/**
 * dashboard/crop-analysis/water-test-data/water-analysis-pdf.php
 *
 * Water quality analysis results display page.
 * Supports normal browser access (session login) and headless Chrome (ptoken).
 */

require_once __DIR__ . '/../../../config/database.php';
require_once __DIR__ . '/../../../lib/auth.php';
require_once __DIR__ . '/../../../lib/print_auth.php';

if (session_status() === PHP_SESSION_NONE) {
    session_start();
}

$recordId  = (int)  ($_GET['rid']  ?? 0);
$randId    = trim(  $_GET['rand']  ?? '');
$clientId  = (int)  ($_GET['cid']  ?? 0);
$printMode = isset($_GET['print']) || isset($_GET['ptoken']);

if (!$recordId || $randId === '') {
    http_response_code(400);
    die('Invalid request parameters');
}

$chromeAccess = authenticatePrintPage($recordId, $randId);

$pdo    = getDBConnection();
$userId = $chromeAccess ? null : getCurrentUserId();

$row   = null;
$specs = [];

$stmt = $pdo->prepare('SELECT * FROM water_records WHERE id = ? AND rand = ? LIMIT 1');
$stmt->execute([$recordId, $randId]);
$row = $stmt->fetch(PDO::FETCH_ASSOC);

if ($row) {
    $type = $row['analysis_type'] ?? '';
    if ($type !== '') {
        $stmtSpec = $pdo->prepare('SELECT * FROM water_specifications WHERE type = ? LIMIT 1');
        $stmtSpec->execute([$type]);
        $specs = $stmtSpec->fetch(PDO::FETCH_ASSOC) ?: [];
    }
}

$h = fn($v) => htmlspecialchars((string)($v ?? ''), ENT_QUOTES, 'UTF-8');

function waterBar(float $found, float $min, float $max): string {
    if ($max <= 0) return '<td colspan="3" class="text-muted text-center small">N/A</td>';
    if ($found < $min) {
        return '<td class="text-center"><div class="progress"><div class="progress-bar bg-danger" style="width:100%"></div></div></td>'
             . '<td></td><td></td>';
    }
    if ($found > $max) {
        return '<td></td><td></td>'
             . '<td class="text-center"><div class="progress"><div class="progress-bar bg-warning" style="width:100%"></div></div></td>';
    }
    $pct = ($max > $min) ? round(min(100, ($found - $min) / ($max - $min) * 100)) : 50;
    return '<td></td>'
         . '<td class="text-center"><div class="progress"><div class="progress-bar bg-success" style="width:' . $pct . '%"></div></div></td>'
         . '<td></td>';
}

$today     = date('jS F Y');
$pageTitle = 'Water Analysis' . (!empty($row['client_name']) ? ' — ' . $row['client_name'] : '');
$siteName  = 'Crop Monitor';

if (!$printMode) {
    include __DIR__ . '/../../../layouts/header.php';
}
?>

<link rel="stylesheet" href="/client-assets/home/css/graphPrint.css" media="print">
<style>
    @media print {
        @page { size: A4 portrait; }
        body { min-width: 992px !important; }
        .container { min-width: 992px !important; }
    }
    .progress { border-radius: 0 !important; }
    .lightgreen  { background: #d4edda !important; color: #155724 !important; }
    .lightred    { background: #f8d7da !important; color: #721c24 !important; }
    .lightblue   { background: #cce5ff !important; color: #004085 !important; }
    .lightpurple { background: #e2d9f3 !important; color: #432874 !important; }
    .stripe-1    { background: #f8f9fa; }
    .border-left   { border-left:   1px solid #dee2e6; }
    .border-right  { border-right:  1px solid #dee2e6; }
    .border-bottom { border-bottom: 1px solid #dee2e6; }
    .border-top    { border-top:    1px solid #dee2e6; }
    table.chart { width: 100%; border-collapse: collapse; }
    table.chart th, table.chart td { padding: 3px 6px; font-size: 0.85rem; }
    .chart-header th { background: #343a40; color: white; }
    .chart-header-sub th { background: #6c757d; color: white; }
</style>

<div class="container" id="content">

    <?php if (!$row): ?>
        <div class="alert alert-danger mt-4">Record not found or access denied.</div>
    <?php else: ?>

    <!-- ── Header ──────────────────────────────────────────────────────────── -->
    <div class="row mb-2 mt-3">
        <div class="col-md-3">
            <img class="img-fluid" src="/client-assets/images/crop-monitor.png" alt="Crop Monitor">
        </div>
    </div>

    <table class="title w-100 mb-3 small">
        <tbody>
            <tr>
                <td class="text-end fw-bold text-nowrap">DATE:</td>
                <td><?= $h($today) ?></td>
                <td></td>
                <td class="text-end fw-bold text-nowrap">SAMPLE ID:</td>
                <td><?= $h($row['sample_id']) ?></td>
            </tr>
            <tr>
                <td class="text-end fw-bold text-nowrap">CLIENT:</td>
                <td><?= $h($row['client_name']) ?></td>
                <td></td>
                <td class="text-end fw-bold text-nowrap">DATE SAMPLED:</td>
                <td><?= $h($row['date_sampled']) ?></td>
            </tr>
            <tr>
                <td class="text-end fw-bold text-nowrap">SITE ID:</td>
                <td><?= $h($row['site_id']) ?></td>
                <td></td>
                <td class="text-end fw-bold text-nowrap">LAB NUMBER:</td>
                <td><?= $h($row['lab_no']) ?></td>
            </tr>
            <tr>
                <td class="text-end fw-bold text-nowrap">ANALYSIS TYPE:</td>
                <td><?= $h($row['analysis_type']) ?></td>
                <td></td>
                <td></td>
                <td></td>
            </tr>
        </tbody>
    </table>

    <!-- ── Action buttons ──────────────────────────────────────────────────── -->
    <?php if (!$printMode): ?>
    <div class="d-print-none mb-3 d-flex gap-2 flex-wrap">
        <a href="/dashboard/crop-analysis/water-test-data/water-report.php?rid=<?= $recordId ?>&rand=<?= urlencode($randId) ?>&cid=<?= $clientId ?>"
           class="btn btn-outline-primary btn-sm">
            <i class="fas fa-file-alt me-1"></i>View Report
        </a>
        <a href="/pdf-files/headlessChrome_pdf.php?type=water-analysis&rid=<?= $recordId ?>&rand=<?= urlencode($randId) ?>&cid=<?= $clientId ?>"
           class="btn btn-outline-secondary btn-sm">
            <i class="fas fa-file-pdf me-1"></i>PDF — Analysis
        </a>
        <a href="/pdf-files/headlessChrome_pdf.php?type=water&rid=<?= $recordId ?>&rand=<?= urlencode($randId) ?>&cid=<?= $clientId ?>"
           class="btn btn-success btn-sm">
            <i class="fas fa-file-pdf me-1"></i>PDF — Analysis &amp; Report
        </a>
    </div>
    <?php endif; ?>

    <div class="row">
        <div class="col-md-12 text-center fw-bold h4">Water Quality Analysis Results</div>
    </div>

    <table class="chart">
        <tbody>
            <tr class="chart-header">
                <th colspan="3" class="text-center border-left border-right border-top">ELEMENT</th>
                <th colspan="3" class="text-center border-right border-top">STATUS</th>
            </tr>
            <tr class="chart-header-sub">
                <th class="text-center border-left">Parameter</th>
                <th class="text-center">Desired</th>
                <th class="text-center">Found</th>
                <th class="text-center stripe-1">Deficit</th>
                <th class="text-center stripe-1">Ideal</th>
                <th class="text-center border-right stripe-1">High</th>
            </tr>
            <tr>
                <td class="border-left"></td><td></td><td></td>
                <td></td><td></td><td class="border-right"></td>
            </tr>

            <!-- General Parameters -->
            <tr class="chart-header-sub">
                <th colspan="6" class="border-left text-center lightblue">GENERAL PARAMETERS</th>
            </tr>
            <?php
            $generalParams = [
                ['ph',       'pH',                 '',     3],
                ['cond_dsm', 'Conductivity',        'dS/m', 3],
                ['hco3-',    'Bicarbonate (HCO₃)',  'ppm',  2],
            ];
            foreach ($generalParams as [$col, $label, $unit, $dp]):
                $found   = (float)($row[$col] ?? 0);
                $min     = (float)($specs[$col . '_min'] ?? 0);
                $max     = (float)($specs[$col . '_max'] ?? 0);
                $desired = ($min > 0 || $max > 0) ? number_format($min, $dp) . '–' . number_format($max, $dp) : '—';
                $display = $unit ? $label . ' (' . $unit . ')' : $label;
            ?>
            <tr>
                <td class="border-left"><?= $h($display) ?></td>
                <td class="text-center"><?= $h($desired) ?></td>
                <td class="text-center"><?= $found > 0 ? number_format($found, $dp) : '—' ?></td>
                <?= waterBar($found, $min, $max) ?>
            </tr>
            <?php endforeach; ?>

            <tr><td colspan="6" class="border-left"></td></tr>

            <!-- Major Elements -->
            <tr class="chart-header-sub">
                <th colspan="6" class="border-left text-center lightgreen">MAJOR ELEMENTS (ppm)</th>
            </tr>
            <?php
            $majorElements = [
                ['nh4', 'Ammonium Nitrogen (NH₄)', 'ppm', 2],
                ['no3', 'Nitrate Nitrogen (NO₃)',  'ppm', 2],
                ['p',   'Phosphorus',               'ppm', 2],
                ['k',   'Potassium',                'ppm', 1],
                ['s',   'Sulphur',                  'ppm', 2],
                ['ca',  'Calcium',                  'ppm', 1],
                ['mg',  'Magnesium',                'ppm', 1],
                ['na',  'Sodium',                   'ppm', 1],
            ];
            foreach ($majorElements as [$col, $label, $unit, $dp]):
                $found   = (float)($row[$col] ?? 0);
                $min     = (float)($specs[$col . '_min'] ?? 0);
                $max     = (float)($specs[$col . '_max'] ?? 0);
                $desired = ($min > 0 || $max > 0) ? number_format($min, $dp) . '–' . number_format($max, $dp) : '—';
            ?>
            <tr>
                <td class="border-left"><?= $h($label) ?> (<?= $h($unit) ?>)</td>
                <td class="text-center"><?= $h($desired) ?></td>
                <td class="text-center"><?= $found > 0 ? number_format($found, $dp) : '—' ?></td>
                <?= waterBar($found, $min, $max) ?>
            </tr>
            <?php endforeach; ?>

            <tr><td colspan="6" class="border-left"></td></tr>

            <!-- Trace Elements -->
            <tr class="chart-header-sub">
                <th colspan="6" class="border-left text-center lightred">TRACE ELEMENTS (ppm)</th>
            </tr>
            <?php
            $traceElements = [
                ['fe', 'Iron',       'ppm', 3],
                ['mn', 'Manganese',  'ppm', 3],
                ['zn', 'Zinc',       'ppm', 3],
                ['cu', 'Copper',     'ppm', 3],
                ['b',  'Boron',      'ppm', 3],
                ['m',  'Molybdenum', 'ppm', 3],
                ['co', 'Cobalt',     'ppm', 3],
            ];
            foreach ($traceElements as [$col, $label, $unit, $dp]):
                $found   = (float)($row[$col] ?? 0);
                $min     = (float)($specs[$col . '_min'] ?? 0);
                $max     = (float)($specs[$col . '_max'] ?? 0);
                $desired = ($min > 0 || $max > 0) ? number_format($min, $dp) . '–' . number_format($max, $dp) : '—';
            ?>
            <tr>
                <td class="border-left"><?= $h($label) ?> (<?= $h($unit) ?>)</td>
                <td class="text-center"><?= $h($desired) ?></td>
                <td class="text-center"><?= $found > 0 ? number_format($found, $dp) : '—' ?></td>
                <?= waterBar($found, $min, $max) ?>
            </tr>
            <?php endforeach; ?>

            <tr>
                <td class="border-bottom border-left"></td>
                <td class="border-bottom"></td>
                <td class="border-bottom"></td>
                <td class="border-bottom"></td>
                <td class="border-bottom"></td>
                <td class="border-bottom border-right"></td>
            </tr>
        </tbody>
    </table>

    <div class="mt-4 small text-muted">
        <p><i class="fa fa-tint" style="color:#007bff"></i> Water analysis results should be interpreted in the context of intended use (irrigation, drinking, stock water).</p>
        <p><i class="fa fa-tint" style="color:#007bff"></i> Talk to your qualified consultant to make a plan for correction or maintenance of the found parameter levels.</p>
        <p class="fst-italic" style="font-size:9px;">Any recommendations provided by Crop Monitor are advice only. We are not paid consultants and accept no responsibility for any of our suggestions.</p>
    </div>

    <?php endif; ?>

</div><!-- /.container -->