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

<?php
/**
 * dashboard/crop-analysis/water-test-data/water-report.php
 *
 * Water 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';
require_once __DIR__ . '/../../../vendor/autoload.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 water_records WHERE id = ? AND rand = ?');
    $stmt->execute([$recordId, $randId]);
    $row = $stmt->fetch(PDO::FETCH_ASSOC);

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

    // 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 water-report.php: ' . $e->getMessage());
    die('Database error occurred');
}

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

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);
    return $parsedown->text($text);
}

include __DIR__ . '/../../../layouts/header.php';
?>
<link rel="stylesheet" href="/client-assets/home/css/graphPrint.css" media="print">
<style>
    @media print {
        .report-textarea { display: none; }
        .report-print-preview { display: block !important; }
    }
    .report-print-preview { display: none; }
    .report-textarea { overflow: hidden; resize: none; overflow-y: auto; }
</style>

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

    <!-- ── Page heading ─────────────────────────────────────────── -->
    <div class="d-flex align-items-center justify-content-between mt-4 mb-3">
        <h1 class="h3 mb-0">Water Analysis Report</h1>
        <div class="d-flex gap-2 d-print-none">
            <a href="/dashboard/crop-analysis/water-test-data/water-analysis-pdf.php?rid=<?= $recordId ?>&rand=<?= urlencode($randId) ?>&cid=<?= $clientId ?>"
               class="btn btn-outline-secondary btn-sm">
                &larr; Analysis
            </a>
            <a href="/dashboard/crop-analysis/water-test-data/water-report-pdf.php?rid=<?= $recordId ?>&rand=<?= urlencode($randId) ?>&cid=<?= $clientId ?>"
               class="btn btn-outline-success btn-sm" target="_blank">
                <i class="fas fa-file-pdf me-1"></i>PDF — Report
            </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>
            <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>Analysis Type:</strong> <?= $h($row['analysis_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>
                <div class="d-flex d-print-none">
                    <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>
            <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 water analysis..."
                ><?= $h($savedComments['general_details']) ?></textarea>
                <div class="report-print-preview"><?= formatReportText($savedComments['general_details']) ?></div>
            </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 Water Interpretation</span>
                <div class="d-flex d-print-none">
                    <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>
            <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 class="report-print-preview"><?= formatReportText($savedComments['ai_interpretation']) ?></div>
            </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>
                <div class="d-flex d-print-none">
                    <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>
            <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 class="report-print-preview"><?= formatReportText($savedComments['recommended_details']) ?></div>
            </div>
        </div>

        <!-- ── 4. Foliar / Application Program ──────────────────────── -->
        <div class="card mb-4">
            <div class="card-header d-flex justify-content-between align-items-center fw-bold">
                <span>Application Program</span>
                <div class="d-flex d-print-none">
                    <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>
            <div class="card-body">
                <textarea id="foliar_details" name="foliar_details"
                          class="form-control report-textarea" rows="6"
                          placeholder="Enter application / treatment program details..."
                ><?= $h($savedComments['foliar_details']) ?></textarea>
                <div class="report-print-preview"><?= formatReportText($savedComments['foliar_details']) ?></div>
            </div>
        </div>

        <!-- ── Disclaimer ─────────────────────────────────────────── -->
        <div class="card mb-4 border-0 bg-light">
            <div class="card-body">
                <p class="text-muted mb-0 fst-italic" style="font-size:0.75rem;">
                    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/water-test-data/water-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');
    }

    function autoResize(el) {
        el.style.height = 'auto';
        el.style.height = el.scrollHeight + 'px';
    }

    document.querySelectorAll('.report-textarea').forEach(function (el) {
        setTimeout(function () { autoResize(el); }, 0);
        el.addEventListener('input', function () {
            autoResize(el);
            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();
    });

    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: 'water',
            }),
        })
        .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);
        });
    });

    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>

<?php include __DIR__ . '/../../../layouts/footer.php'; ?>