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

<?php
/**
 * soil-report-pdf.php
 *
 * Print / PDF-export version of a completed soil analysis report.
 * Displays the saved AI-generated sections from the reports table alongside
 * the element requirement cards and five-year balancing plan.
 *
 * Normal access (logged-in user):
 *   ?rid=<id>&rand=<token>
 *
 * Headless Chrome access (no session, called from headlessChrome_pdf.php):
 *   ?rid=<id>&rand=<token>&ptoken=<one-time-file-token>
 *   The ptoken is a short-lived file written by the generator. This lets Chrome
 *   render the page without a PHP session cookie.
 */

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

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

$recordId = (int)  ($_GET['rid']  ?? 0);
$randId   = trim(  $_GET['rand']  ?? '');

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

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

$row  = null;
$spec = [];
$savedComments = [];
$today = date('jS F Y');

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

    if ($row) {
        // Load spec ranges for this soil type
        if (!empty($row['soil_type'])) {
            $stmtSpec = $pdo->prepare('SELECT * FROM soil_specifications WHERE soil_type = ? LIMIT 1');
            $stmtSpec->execute([$row['soil_type']]);
            $spec = $stmtSpec->fetch(PDO::FETCH_ASSOC) ?: [];
        }

        // Load saved report comments — use modx_user_id when available, else any comment for this record
        if ($userId !== null) {
            $stmtRpt = $pdo->prepare(
                'SELECT comment FROM reports WHERE record_id = ? AND modx_user_id = ? ORDER BY id DESC LIMIT 1'
            );
            $stmtRpt->execute([$recordId, $userId]);
        } else {
            $stmtRpt = $pdo->prepare(
                'SELECT comment FROM reports WHERE record_id = ? ORDER BY id DESC LIMIT 1'
            );
            $stmtRpt->execute([$recordId]);
        }
        $savedRow = $stmtRpt->fetchColumn();
        if ($savedRow) {
            $decoded = json_decode($savedRow, true);
            if (is_array($decoded)) {
                $savedComments = $decoded;
            }
        }
    }
}

// ── Five-year plan ────────────────────────────────────────────────────────────
$planElements = [
    ['Calcium',   'BS_ca_ppm', 'ca_ppm_min', 'ca_ppm_max', 'kg/ha'],
    ['Magnesium', 'BS_mg_ppm', 'mg_ppm_min', 'mg_ppm_max', 'kg/ha'],
    ['Potassium', 'BS_k_ppm',  'k_ppm_min',  'k_ppm_max',  'kg/ha'],
    ['Sodium',    'BS_na_ppm', 'na_ppm_min', 'na_ppm_max', 'kg/ha'],
    ['Phosphate', 'p_colwell', '',           '',            'kg/ha'],
    ['Sulfur',    's_morgan',  '',           '',            'kg/ha'],
    ['Boron',     'b_cacl2',   '',           '',            'kg/ha'],
    ['Manganese', 'mn_dtpa',   '',           '',            'kg/ha'],
    ['Zinc',      'zn_dtpa',   '',           '',            'kg/ha'],
    ['Copper',    'cu_dtpa',   '',           '',            'kg/ha'],
];

$acHa = 2.4710559990832394739;

function calcDeficitPdf(array $row, array $spec, string $col, string $minCol, string $maxCol): float
{
    global $acHa;
    $value  = (float)($row[$col] ?? 0);
    $maxVal = $maxCol !== '' ? (float)($row[$maxCol] ?? 0) : (float)($spec[$col] ?? 0);
    $deficit = ($maxVal - $value) * $acHa;
    return $deficit > 0 ? round($deficit, 2) : 0.0;
}

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

// Parse and render markdown text from AI-generated report sections
function formatReportText(string $text): string
{
    if (trim($text) === '') {
        return '<p class="text-muted fst-italic">No content saved.</p>';
    }
    $parsedown = new Parsedown();
    $parsedown->setSafeMode(true);  // strip any raw HTML in the text
    return $parsedown->text($text);
}
?>
<!doctype html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>Soil Analysis Report | Crop Monitor</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.0/dist/css/bootstrap.min.css" rel="stylesheet" crossorigin="anonymous">
    <link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.9.0/css/all.css" rel="stylesheet" crossorigin="anonymous">
    <link href="/client-assets/css/dashboard.css" rel="stylesheet">
    <link rel="stylesheet" href="/client-assets/css/graphPrint.css" media="print">
    <style>
        @media print {
            .d-print-none  { display: none !important; }
            .page-break    { page-break-before: always; }
            body           { font-size: 11px; }
            .report-section p { font-size: 11px; }
        }
        .report-section p   { margin-bottom: 0.6rem; line-height: 1.6; }
        .report-section h1,
        .report-section h2,
        .report-section h3,
        .report-section h4  { font-size: 1rem; font-weight: 600; margin: 1rem 0 0.4rem; }
        .report-section ul,
        .report-section ol  { padding-left: 1.4rem; margin-bottom: 0.6rem; }
        .report-section li  { margin-bottom: 0.25rem; line-height: 1.5; }
        .report-section table {
            width: 100%;
            border-collapse: collapse;
            margin-bottom: 0.8rem;
            font-size: 0.85rem;
        }
        .report-section table th,
        .report-section table td {
            border: 1px solid #dee2e6;
            padding: 4px 8px;
            text-align: left;
        }
        .report-section table thead th {
            background: #f8f9fa;
            font-weight: 600;
        }
        .section-header {
            background: #212529;
            color: #fff;
            padding: 6px 12px;
            font-weight: 600;
            margin-bottom: 0;
        }
        .section-body {
            border: 1px solid #dee2e6;
            border-top: 0;
            padding: 14px 16px;
            margin-bottom: 1.2rem;
        }
        .title-table td, .title-table th { padding: 2px 8px; }
        .element-required-module .col { padding: 0 6px; }
    </style>
</head>
<body>

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

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

    <!-- ── Header ──────────────────────────────────────────────────────────── -->
    <div class="row align-items-center mb-3 mt-3">
        <div class="col-3">
            <img class="img-fluid" src="/client-assets/images/crop-monitor.png"
                 alt="Crop Monitor" style="max-height:55px;">
        </div>
        <div class="col-9 text-end">
            <div class="fw-bold h5 mb-0">Soil Analysis Report</div>
            <div class="text-muted small"><?= $h($today) ?></div>
        </div>
    </div>

    <table class="title-table w-100 mb-3 small">
        <tbody>
            <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">SAMPLE ID:</td>
                <td><?= $h($row['site_id']) ?></td>
            </tr>
            <tr>
                <td class="text-end fw-bold text-nowrap">ADDRESS:</td>
                <td><?= $h($row['site_address']) ?></td>
                <td></td>
                <td class="text-end fw-bold text-nowrap">DATE SAMPLED:</td>
                <td><?= $h($row['date_sampled']) ?></td>
            </tr>
            <tr>
                <td></td>
                <td><?= $h($row['state_postcode']) ?></td>
                <td></td>
                <td class="text-end fw-bold text-nowrap">LAB NUMBER:</td>
                <td><?= $h($row['lab_no']) ?></td>
            </tr>
            <tr>
                <td></td>
                <td><?= $h($row['email']) ?></td>
                <td></td>
                <td class="text-end fw-bold text-nowrap">CROP:</td>
                <td><?= $h($row['sample_id']) ?></td>
            </tr>
            <tr>
                <td></td>
                <td></td>
                <td></td>
                <td class="text-end fw-bold text-nowrap">SOIL TYPE:</td>
                <td><?= $h($row['soil_type']) ?></td>
            </tr>
        </tbody>
    </table>

    <!-- ── Download / Back buttons ─────────────────────────────────────────── -->
    <div class="d-print-none mb-3 d-flex gap-2">
        <a href="/dashboard/crop-analysis/soil-test-data/soil-report.php?rid=<?= $recordId ?>&rand=<?= urlencode($randId) ?>"
           class="btn btn-outline-secondary btn-sm">
            &larr; Back to Report
        </a>
        <a href="/pdf-files/headlessChrome_pdf.php?type=soil-report&rid=<?= $recordId ?>&rand=<?= urlencode($randId) ?>"
           class="btn btn-success btn-sm">
            <i class="fas fa-download me-1"></i>Download PDF
        </a>
        <button class="btn btn-outline-dark btn-sm" onclick="window.print()">
            <i class="fas fa-print me-1"></i>Print
        </button>
    </div>

    <hr>

    <!-- ── 1. Element requirements ─────────────────────────────────────────── -->
    <div class="section-header">
        Total kilograms per hectare of each element needed to balance soil
    </div>
    <div class="section-body">
        <div class="element-required-module">
            <div class="row row-cols-2 row-cols-sm-3 row-cols-md-4 row-cols-lg-6 g-2">
                <?php
                echo soilAnalysisReportCalcs('Ca',  'BS_ca_ppm', 'ca_ppm_min', 'ca_ppm_max', 'Calcium',       'kg', 'col', $recordId, $randId);
                echo soilAnalysisReportCalcs('Mg',  'BS_mg_ppm', 'mg_ppm_min', 'mg_ppm_max', 'Magnesium',     'kg', 'col', $recordId, $randId);
                echo soilAnalysisReportCalcs('K',   'BS_k_ppm',  'k_ppm_min',  'k_ppm_max',  'Potassium',     'kg', 'col', $recordId, $randId);
                echo soilAnalysisReportCalcs('Na',  'BS_na_ppm', 'na_ppm_min', 'na_ppm_max', 'Sodium',        'kg', 'col', $recordId, $randId);
                echo soilAnalysisReportCalcs('P',   'p_colwell', '',           '',            'Phosphate',     'kg', 'col', $recordId, $randId);
                echo soilAnalysisReportCalcs('S',   's_morgan',  '',           '',            'Sulfur',        'kg', 'col', $recordId, $randId);
                echo soilAnalysisReportCalcs('Mn',  'mn_dtpa',   '',           '',            'Manganese',     'kg', 'col', $recordId, $randId);
                echo soilAnalysisReportCalcs('Fe',  'fe_dtpa',   '',           '',            'Iron',          'kg', 'col', $recordId, $randId);
                echo soilAnalysisReportCalcs('Zn',  'zn_dtpa',   '',           '',            'Zinc',          'kg', 'col', $recordId, $randId);
                echo soilAnalysisReportCalcs('Cu',  'cu_dtpa',   '',           '',            'Copper',        'kg', 'col', $recordId, $randId);
                echo soilAnalysisReportCalcs('AmN', 'NH3_N',     '',           '',            'Amm. Nitrogen', 'kg', 'col', $recordId, $randId);
                echo soilAnalysisReportCalcs('B',   'b_cacl2',   '',           '',            'Boron',         'kg', 'col', $recordId, $randId);
                echo soilAnalysisReportCalcs('NN',  'NO3_N',     '',           '',            'Nit. Nitrogen', 'kg', 'col', $recordId, $randId);
                ?>
            </div>
        </div>
    </div>

    <!-- ── 2. Five-year balancing plan ─────────────────────────────────────── -->
    <div class="section-header">
        Ideal Soil Balancing Program — 5-Year Plan (kg/ha per year)
    </div>
    <div class="section-body p-0">
        <table class="table table-sm table-bordered mb-0">
            <thead class="table-light">
                <tr>
                    <th>Element</th>
                    <th class="text-center">Total Deficit</th>
                    <?php for ($y = 1; $y <= 5; $y++): ?>
                    <th class="text-center">Year <?= $y ?></th>
                    <?php endfor; ?>
                </tr>
            </thead>
            <tbody>
                <?php foreach ($planElements as [$label, $col, $minCol, $maxCol, $unit]):
                    $total   = calcDeficitPdf($row, $spec, $col, $minCol, $maxCol);
                    $perYear = $total > 0 ? round($total / 5, 2) : 0;
                ?>
                <tr>
                    <td><?= $h($label) ?></td>
                    <td class="text-center <?= $total > 0 ? 'text-danger fw-semibold' : 'text-success' ?>">
                        <?= $total > 0 ? $total . ' ' . $unit : '&#10003; Adequate' ?>
                    </td>
                    <?php for ($y = 1; $y <= 5; $y++): ?>
                    <td class="text-center">
                        <?= $perYear > 0 ? $perYear . ' ' . $unit : '—' ?>
                    </td>
                    <?php endfor; ?>
                </tr>
                <?php endforeach; ?>
            </tbody>
        </table>
    </div>

    <!-- ── 3. Overview ─────────────────────────────────────────────────────── -->
    <div class="section-header">Overview</div>
    <div class="section-body report-section">
        <?= formatReportText($savedComments['overview'] ?? '') ?>
    </div>

    <!-- ── 4. AI Soil Interpretation ───────────────────────────────────────── -->
    <div class="section-header">AI Soil Interpretation</div>
    <div class="section-body report-section">
        <?= formatReportText($savedComments['ai_interpretation'] ?? '') ?>
    </div>

    <!-- ── 5. Foliar Program ────────────────────────────────────────────────── -->
    <div class="section-header">
        <?= $h($savedComments['header1'] ?? 'Foliar Program') ?>
    </div>
    <div class="section-body report-section">
        <?= formatReportText($savedComments['foliar_details'] ?? '') ?>
    </div>

    <!-- ── 6. Microbial Program ─────────────────────────────────────────────── -->
    <div class="section-header">Microbial Program</div>
    <div class="section-body report-section">
        <?= formatReportText($savedComments['microbe_program'] ?? '') ?>
    </div>

    <!-- ── Disclaimer ──────────────────────────────────────────────────────── -->
    <div class="mt-3 pt-3 border-top">
        <p class="text-muted" style="font-size:0.7rem;">
            Any recommendations provided by Crop Monitor are advice only. We are not paid consultants
            and accept no responsibility for any of our suggestions. No control can be exercised over
            storage, handling, mixing, application, or use, or over weather, plant or soil conditions
            before, during or after application — all of which may affect the performance of our
            program. No responsibility for, or liability for, any failure in performance, losses,
            damage or injuries consequential or otherwise arising from such storage, mixing,
            application or use will be accepted under any circumstances whatsoever. The buyer assumes
            all responsibility for the use of any of our products.
        </p>
    </div>

    <?php endif; ?>

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

<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.0/dist/js/bootstrap.bundle.min.js" crossorigin="anonymous"></script>

</body>
</html>