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

<?php
/**
 * dashboard/crop-analysis/plant-test-data/plant-report.php
 *
 * Plant analysis report — editable sections with auto-save and Ollama AI interpretation.
 */

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

requireLogin();

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

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

try {
    $pdo    = getDBConnection();
    $userId = getCurrentUserId();

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

    if (!$row) {
        http_response_code(404);
        die('Plant record not found');
    }

    // Load spec ranges
    $specs = [];
    if (!empty($row['crop_type'])) {
        $stmtSpec = $pdo->prepare('SELECT * FROM plant_specifications WHERE plant_type = ? LIMIT 1');
        $stmtSpec->execute([$row['crop_type']]);
        $specs = $stmtSpec->fetch(PDO::FETCH_ASSOC) ?: [];
    }

    // Load saved report comments
    $savedComments = [
        'general_details'     => '',
        'ai_interpretation'   => '',
        'recommended_details' => '',
        'foliar_details'      => '',
    ];
    $stmtRpt = $pdo->prepare(
        'SELECT comment FROM reports WHERE record_id = ? AND modx_user_id = ? ORDER BY id DESC LIMIT 1'
    );
    $stmtRpt->execute([$recordId, $userId]);
    $savedRow = $stmtRpt->fetchColumn();
    if ($savedRow) {
        $decoded = json_decode($savedRow, true);
        if (is_array($decoded)) {
            $savedComments = array_merge($savedComments, $decoded);
        }
    }

} catch (PDOException $e) {
    error_log('DB error in plant-report.php: ' . $e->getMessage());
    die('Database error occurred');
}

$h         = fn($v) => htmlspecialchars((string)($v ?? ''), ENT_QUOTES, 'UTF-8');
$today     = date('jS F Y');
$pageTitle = 'Plant Report' . (!empty($row['client_name']) ? ' — ' . $row['client_name'] : '');
$siteName  = 'Crop Monitor';

include __DIR__ . '/../../../layouts/header.php';
?>


            <div class="container-fluid px-4">

                <!-- ── Page heading ─────────────────────────────────────────── -->
                <div class="d-flex align-items-center justify-content-between mt-4 mb-3">
                    <h1 class="h3 mb-0">Plant Analysis Report</h1>
                    <div class="d-flex gap-2 d-print-none">
                        <a href="/dashboard/crop-analysis/plant-test-data/plant-analysis.php?rid=<?= $recordId ?>&rand=<?= urlencode($randId) ?>&cid=<?= $clientId ?>"
                           class="btn btn-outline-secondary btn-sm">
                            &larr; Analysis
                        </a>
                        <a href="/pdf-files/headlessChrome_pdf.php?type=plant-report&rid=<?= $recordId ?>&rand=<?= urlencode($randId) ?>&cid=<?= $clientId ?>"
                           class="btn btn-outline-success btn-sm">
                            <i class="fas fa-file-pdf me-1"></i>PDF — Report
                        </a>
                        <a href="/pdf-files/headlessChrome_pdf.php?type=plant&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>
                        <button type="button" class="btn btn-primary btn-sm" id="btn-generate-all">
                            <i class="fas fa-robot me-1"></i>Interpret All with AI
                        </button>
                    </div>
                </div>

                <!-- ── Client info card ──────────────────────────────────────── -->
                <div class="card mb-4">
                    <div class="card-body py-2">
                        <div class="row row-cols-2 row-cols-md-3 g-1 small">
                            <div><strong>Client:</strong> <?= $h($row['client_name']) ?></div>
                            <div><strong>Sample ID:</strong> <?= $h($row['sample_id']) ?></div>
                            <div><strong>Date Sampled:</strong> <?= $h($row['date_sampled']) ?></div>
                            <div><strong>Address:</strong> <?= $h($row['site_address']) ?>, <?= $h($row['state_postcode']) ?></div>
                            <div><strong>Crop Type:</strong> <?= $h($row['crop_type']) ?></div>
                            <div><strong>Lab No:</strong> <?= $h($row['lab_no']) ?></div>
                            <div><strong>Site ID:</strong> <?= $h($row['site_id']) ?></div>
                            <div><strong>Report Date:</strong> <?= $h($today) ?></div>
                        </div>
                    </div>
                </div>

                <div id="save-status" class="text-muted small mb-2" style="min-height:1.2rem;"></div>

                <form class="report-form" method="post">
                    <input type="hidden" name="csrf_token"
                           value="<?= htmlspecialchars(generateCsrfToken(), ENT_QUOTES, 'UTF-8') ?>">
                    <input type="hidden" name="rid"  value="<?= $recordId ?>">
                    <input type="hidden" name="rand" value="<?= $h($randId) ?>">

                    <!-- ── 1. General Comment ─────────────────────────────────── -->
                    <div class="card mb-4">
                        <div class="card-header d-flex justify-content-between align-items-center fw-bold">
                            <span>General Comment</span>
                            <button type="button" class="btn btn-outline-primary btn-sm ai-generate-btn"
                                    data-section="general" data-target="#general_details">
                                <i class="fas fa-robot me-1"></i>Generate with AI
                            </button>
                        </div>
                        <div class="card-body">
                            <textarea id="general_details" name="general_details"
                                      class="form-control report-textarea" rows="6"
                                      placeholder="Enter a general comment on this plant analysis..."
                            ><?= $h($savedComments['general_details']) ?></textarea>
                        </div>
                    </div>

                    <!-- ── 2. AI Interpretation ───────────────────────────────── -->
                    <div class="card mb-4">
                        <div class="card-header d-flex justify-content-between align-items-center fw-bold">
                            <span>AI Plant Interpretation</span>
                            <button type="button" class="btn btn-outline-primary btn-sm ai-generate-btn"
                                    data-section="ai_interpretation" data-target="#ai_interpretation">
                                <i class="fas fa-robot me-1"></i>Interpret with AI
                            </button>
                        </div>
                        <div class="card-body">
                            <p class="text-muted small mb-2">
                                AI-generated agronomic interpretation. Review and edit before including in the final report.
                            </p>
                            <textarea id="ai_interpretation" name="ai_interpretation"
                                      class="form-control report-textarea" rows="10"
                                      placeholder="Click 'Interpret with AI' to generate an interpretation, or type manually..."
                            ><?= $h($savedComments['ai_interpretation']) ?></textarea>
                        </div>
                    </div>

                    <!-- ── 3. Recommended Remedial Program ───────────────────── -->
                    <div class="card mb-4">
                        <div class="card-header d-flex justify-content-between align-items-center fw-bold">
                            <span>Recommended Remedial Program</span>
                            <button type="button" class="btn btn-outline-primary btn-sm ai-generate-btn"
                                    data-section="recommended" data-target="#recommended_details">
                                <i class="fas fa-robot me-1"></i>Generate with AI
                            </button>
                        </div>
                        <div class="card-body">
                            <textarea id="recommended_details" name="recommended_details"
                                      class="form-control report-textarea" rows="6"
                                      placeholder="Enter recommended remedial program details..."
                            ><?= $h($savedComments['recommended_details']) ?></textarea>
                        </div>
                    </div>

                    <!-- ── 4. Foliar Program ──────────────────────────────────── -->
                    <div class="card mb-4">
                        <div class="card-header d-flex justify-content-between align-items-center fw-bold">
                            <span>Foliar Program</span>
                            <button type="button" class="btn btn-outline-primary btn-sm ai-generate-btn"
                                    data-section="foliar" data-target="#foliar_details">
                                <i class="fas fa-robot me-1"></i>Generate with AI
                            </button>
                        </div>
                        <div class="card-body">
                            <textarea id="foliar_details" name="foliar_details"
                                      class="form-control report-textarea" rows="6"
                                      placeholder="Enter foliar spray program details..."
                            ><?= $h($savedComments['foliar_details']) ?></textarea>
                        </div>
                    </div>

                    <!-- ── Disclaimer ─────────────────────────────────────────── -->
                    <div class="card mb-4 border-0 bg-light">
                        <div class="card-body">
                            <p class="text-muted mb-1" style="font-size:0.75rem;">
                                <i class="fa fa-leaf" style="color:green"></i>
                                It is always an advantage to assess tissue analysis results along with a corresponding soil analysis for more accurate diagnosis of plant nutrient status.
                            </p>
                            <p class="text-muted mb-1" style="font-size:0.75rem;">
                                <i class="fa fa-leaf" style="color:green"></i>
                                Trace element levels — manganese, copper and zinc — can all be affected by fungicide spray residues, giving misleading results.
                            </p>
                            <p class="text-muted mb-0 fst-italic" 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.
                            </p>
                        </div>
                    </div>

                </form>

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

<script>
(function () {
    'use strict';

    var saveTimer  = null;
    var statusEl   = document.getElementById('save-status');
    var SAVE_URL   = '/dashboard/crop-analysis/plant-test-data/plant-report-save.php'
                   + '?rid=<?= $recordId ?>&rand=<?= urlencode($randId) ?>';
    var AI_URL     = '/controllers/ollamaGenerate.php';
    var CSRF_TOKEN = <?= json_encode(generateCsrfToken()) ?>;

    function setStatus(msg, cls) {
        statusEl.textContent = msg;
        statusEl.className   = 'small mb-2 text-' + (cls || 'secondary');
    }

    // ── Auto-save ────────────────────────────────────────────────────────── //
    document.querySelectorAll('.report-form .report-textarea')
        .forEach(function (el) {
            el.addEventListener('input', function () {
                clearTimeout(saveTimer);
                saveTimer = setTimeout(saveReport, 1200);
            });
        });

    function saveReport() {
        var form = document.querySelector('.report-form');
        var data = new URLSearchParams(new FormData(form));
        setStatus('Saving…', 'secondary');

        fetch(SAVE_URL, { method: 'POST', body: data })
            .then(function (r) { return r.json(); })
            .then(function (d) {
                if (d.success) {
                    setStatus('Saved — ' + new Date().toLocaleTimeString(), 'success');
                } else {
                    setStatus('Save failed: ' + (d.message || 'unknown error'), 'danger');
                }
            })
            .catch(function () { setStatus('Network error — not saved', 'danger'); });
    }

    document.querySelector('.report-form').addEventListener('submit', function (e) {
        e.preventDefault();
        saveReport();
    });

    // ── AI generation ────────────────────────────────────────────────────── //
    function generateSection(btn, section, targetSelector) {
        var textarea = document.querySelector(targetSelector);
        if (!textarea) return;

        var origHTML = btn.innerHTML;
        btn.disabled = true;
        btn.innerHTML = '<span class="spinner-border spinner-border-sm me-1"></span>Generating…';
        setStatus('Requesting AI interpretation…', 'secondary');

        fetch(AI_URL, {
            method: 'POST',
            headers: { 'Content-Type': 'application/x-www-form-urlencoded' },
            body: new URLSearchParams({
                csrf_token:  CSRF_TOKEN,
                rid:         <?= $recordId ?>,
                rand:        <?= json_encode($randId) ?>,
                section:     section,
                record_type: 'plant',
            }),
        })
        .then(function (r) { return r.json(); })
        .then(function (d) {
            if (d.success && d.text) {
                textarea.value = d.text;
                textarea.dispatchEvent(new Event('input'));
                setStatus('AI text generated — review before publishing', 'success');
            } else {
                setStatus('AI error: ' + (d.error || 'no response returned'), 'danger');
            }
        })
        .catch(function () {
            setStatus('Could not reach AI service. Is Ollama running on port 11434?', 'danger');
        })
        .finally(function () {
            btn.disabled = false;
            btn.innerHTML = origHTML;
        });
    }

    document.querySelectorAll('.ai-generate-btn').forEach(function (btn) {
        btn.addEventListener('click', function () {
            generateSection(btn, btn.dataset.section, btn.dataset.target);
        });
    });

    // "Interpret All" — stagger requests
    document.getElementById('btn-generate-all').addEventListener('click', function () {
        var sections = [
            { section: 'general',          target: '#general_details' },
            { section: 'ai_interpretation',target: '#ai_interpretation' },
            { section: 'recommended',      target: '#recommended_details' },
            { section: 'foliar',           target: '#foliar_details' },
        ];
        sections.forEach(function (s, i) {
            setTimeout(function () {
                var sectionBtn = document.querySelector('.ai-generate-btn[data-section="' + s.section + '"]');
                generateSection(
                    sectionBtn || document.getElementById('btn-generate-all'),
                    s.section, s.target
                );
            }, i * 4000);
        });
    });

})();
</script>