benjamin.harris
/
soil-report-ai


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645
							<?php
/**
 * dashboard/crop-analysis/soil-analysis.php
 *
 * Soil Analysis Results Display Page
 * Shows detailed soil test results with calculations and recommendations
 */

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

// Start session if not already started
if (session_status() === PHP_SESSION_NONE) {
    session_start();
}

// Require authentication
requireLogin();

// Get and validate parameters
$client_id = (int)($_GET['cid'] ?? 0);
$record_id = (float)($_GET['rid'] ?? 0);
$rand_id = (float)($_GET['rand'] ?? 0);

// Validate required parameters
if (!$record_id || !$rand_id) {
    die('Invalid request parameters');
}

// Get soil record data securely
try {
    $pdo = getDBConnection();
    $stmt = $pdo->prepare("SELECT * FROM soil_records WHERE id = ? AND rand = ?");
    $stmt->execute([$record_id, $rand_id]);
    $row = $stmt->fetch(PDO::FETCH_ASSOC);

    if (!$row) {
        die('Soil record not found');
    }

    // Extract data
    $client = htmlspecialchars($row['client_name'] ?? '', ENT_QUOTES, 'UTF-8');
    $address = htmlspecialchars($row['site_address'] ?? '', ENT_QUOTES, 'UTF-8');
    $state = htmlspecialchars($row['state_postcode'] ?? '', ENT_QUOTES, 'UTF-8');
    $email = htmlspecialchars($row['email'] ?? '', ENT_QUOTES, 'UTF-8');
    $labNo = htmlspecialchars($row['lab_no'] ?? '', ENT_QUOTES, 'UTF-8');
    $sampleDate = htmlspecialchars($row['date_sampled'] ?? '', ENT_QUOTES, 'UTF-8');
    $sample = htmlspecialchars($row['site_id'] ?? '', ENT_QUOTES, 'UTF-8');
    $crop = htmlspecialchars($row['sample_id'] ?? '', ENT_QUOTES, 'UTF-8');

} catch (PDOException $e) {
    error_log("Database error in soil-analysis.php: " . $e->getMessage());
    die('Database error occurred');
}

$today = date('jS F Y');
$pageTitle = 'Soil Analysis Results - ' . $client;
?>

<!doctype html>
<html lang="en">
<head>
    <title><?php echo $pageTitle; ?> | Crop Management Platform</title>
    <base href="/" >
    <meta charset="utf-8" >
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no" >
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" >
    <meta name="keywords" content="soil analysis, crop monitoring, agriculture" >
    <meta name="description" content="Detailed soil analysis results and recommendations" >

    <link rel="icon" href="client-assets/images/favicon.ico?v=2" type="image/x-icon" >

    <script src="https://code.jquery.com/jquery-3.6.0.min.js" integrity="sha256-/xUj+3OJU5yExlq6GSYGSHk7tPXikynS7ogEvDej/m4=" crossorigin="anonymous"></script>

    <!-- Bootstrap 5 CSS -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.0/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-KyZXEAg3QhqLMpG8r+8fhAXLRk2vvoC2f3B09zVXn8CA5QIVfZOJ3BCsw2P0p/We" crossorigin="anonymous">

    <link href="https://ajax.googleapis.com/ajax/libs/jqueryui/1.12.1/themes/smoothness/jquery-ui.css" rel="stylesheet" type="text/css" />

    <link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css" integrity="sha512-9usAa10IRO0HhonpyAIVpjrylPvoDwiPUiKdWk5t3PyolY1cOd4DSE0Ga+ri4AuTroPR5aQvXU9xC6qOPnzFeg==" crossorigin="anonymous" referrerpolicy="no-referrer" rel="stylesheet" type="text/css" />

    <link type="text/css" href="/client-assets/weather-icons/css/weather-icons.min.css?version=1.16" rel="stylesheet" type="text/css" />
    <link href="https://cdnjs.cloudflare.com/ajax/libs/magnific-popup.js/1.1.0/magnific-popup.css" rel="stylesheet" type="text/css" />
        <script src="https://unpkg.com/gijgo@1.9.11/js/gijgo.min.js" type="text/javascript"></script>
        <link href="https://unpkg.com/gijgo@1.9.11/css/gijgo.min.css" rel="stylesheet" type="text/css" />
        <script src="client-assets/js/skycons.js" type="text/javascript"></script>

        <link href="client-assets/home/css/graphing.css" rel="stylesheet" type="text/css" media="screen" />
        <link href="client-assets/home/css/alux.min.css" rel="stylesheet" type="text/css" media="screen" />

        <script src="https://cdnjs.cloudflare.com/ajax/libs/html2pdf.js/0.9.3/html2pdf.bundle.min.js" integrity="sha512-YcsIPGdhPK4P/uRW6/sruonlYj+Q7UHWeKfTAkBW+g83NKM+jMJFJ4iAPfSnVp7BKD4dKMHmVSvICUbE/V1sSw==" crossorigin="anonymous" referrerpolicy="no-referrer"></script>

        <style>
            @media print {
                @page {
                    size: A4 portrait;
                }
                @page :left {
                    margin-left: 0.5cm;
                }
                @page :right {
                    margin-right: 0.5cm;
                }
                @page :top {
                    margin-top: 0cm;
                }
                @page :bottom {
                    margin-bottom: 0cm;
                }
            }
        </style>

    </head>
    <body>

        <div class="container">
            <div class="row">
                <?php
                // Replace Logo with Customer Logo if supplied.
                $client = '';

                echo "<div class='col-md-3'>";
                if ($client === "") {
                    echo "<img class='img-fluid' src='client-assets/images/crop-monitor.png'  alt='Crop Monitor' >";    
                } else {
                    echo "<img class='img-fluid' src='client-assets/images/crop-monitor.png'  alt='Crop Monitor' >";
                }

                //echo "<span class='col'></span>";


                //Client Test Description
                if ($client === "") {
                    echo "";    
                } else {
                    echo "<img class='img-fluid' src='client-assets/images/crop-monitor.png'  alt='Crop Monitor' >";
                }
                echo "</div>";

                echo "<div class='col-md-9'></div>";
                ?>
            </div>

            <table class='title'>
                <tbody>
                    <tr>
                        <th class='col-20'></th>
                        <th class='col-20'></th>
                        <th class='col-20'></th>
                        <th class='col-20'></th>
                        <th class='col-20'></th>
                    </tr>
                    <tr>
                        <td class='right'><b>DATE:</b></td>
                        <td class='left'><?php echo $today; ?></td>
                        <td></td>
                        <td class='right'><b>SAMPLE ID:</b></td>
                        <td class='left'><?php echo $sample; ?></td>
                    </tr>
                    <tr>
                        <td class='right'><b>CLIENT:</b></td>
                        <td class='left'><?php echo $client; ?></td>
                        <td></td>
                        <td class='right'><b>DATE SAMPLED:</b></td>
                        <td class='left'><?php echo $sampleDate; ?></td>
                    </tr>
                    <tr>
                        <td class='right'><b>ADDRESS:</b></td>
                        <td class='left'><?php echo $address; ?></td>
                        <td></td>
                        <td class='right'><b>LAB NUMBER:</b></td>
                        <td class='left'><?php echo $labNo; ?></td>
                    </tr>
                    <tr>
                        <td class='right'><b> </b></td>
                        <td class='left'><?php echo $state; ?></td>
                        <td></td>
                        <td class='right'><b>CROP:</b></td>
                        <td class='left'><?php echo $crop; ?></td>
                    </tr>
                    <tr>
                        <td class='right'><b> </b></td>
                        <td class='left'><?php echo $email; ?></td>
                        <td></td>
                        <td class='right'></td>
                        <td class='left'></td>
                    </tr>
                </tbody>
            </table>

            <!-- Graph Button -->
            <div class="d-print-none">
                <div class="row p-2">
                    <div class="col">
                        <button type="button" class="btn btn-primary" onclick="generateGraph()">
                            <i class="fas fa-chart-bar"></i> Generate Graph
                        </button>
                    </div>
                    <div class="col">
                        <div class="form-status-holder"></div>
                    </div>
                </div>
            </div>
            <!-- GRAPH BANNER -->

            <div class="row">
                <div class="col-md-12 text-center font-weight-bold h4">Soil Analysis Summary</div>
            </div>


            <!-- CHART HEADER  -->

            <div class="row bg-dark text-white p-2 mt-3">
                <div class="text-center col-md-12 h5">Total kilograms per hectare of each element needed to balance soil in this test</div>
            </div>

            <div class="row">
                <div class="">
                    <?php
                    require_once __DIR__.'/../../lib/soil_calculations.php';
                    echo soilAnalysisReportCalcs('Ca', 'BS_ca_ppm', 'ca_ppm_min', 'ca_ppm_max', 'Calcium', 'kg', 'col', $record_id, $rand_id);
                    echo soilAnalysisReportCalcs('Mg', 'BS_mg_ppm', 'mg_ppm_min', 'mg_ppm_max', 'Magnesium', 'kg', 'col', $record_id, $rand_id);
                    echo soilAnalysisReportCalcs('K', 'BS_k_ppm', 'k_ppm_min', 'k_ppm_max', 'Potasium', 'kg', 'col', $record_id, $rand_id);
                    echo soilAnalysisReportCalcs('Na', 'BS_na_ppm', 'na_ppm_min', 'na_ppm_max', 'Sodium', 'kg', 'col', $record_id, $rand_id);
                    echo soilAnalysisReportCalcs('P', 'p_colwell', '', '', 'Phosphate', 'kg', 'col', $record_id, $rand_id);
                    echo soilAnalysisReportCalcs('S', 's_morgan', '', '', 'Sulfur', 'kg', 'col', $record_id, $rand_id);
                    echo soilAnalysisReportCalcs('Mn', 'mn_dtpa', '', '', 'Manganese', 'kg', 'col', $record_id, $rand_id);
                    echo soilAnalysisReportCalcs('Fe', 'fe_dtpa', '', '', 'Iron', 'kg', 'col', $record_id, $rand_id);
                    echo soilAnalysisReportCalcs('Zn', 'zn_dtpa', '', '', 'Zinc', 'kg', 'col', $record_id, $rand_id);
                    echo soilAnalysisReportCalcs('Cu', 'cu_dtpa', '', '', 'Copper', 'kg', 'col', $record_id, $rand_id);
                    echo soilAnalysisReportCalcs('AmN', 'NH3_N', '', '', 'AmNitrogen', 'kg', 'col', $record_id, $rand_id);
                    echo soilAnalysisReportCalcs('B', 'b_cacl2', '', '', 'Boron', 'kg', 'col', $record_id, $rand_id);
                    echo soilAnalysisReportCalcs('NN', 'NO3_N', '', '', 'NNitrogen', 'kg', 'col', $record_id, $rand_id);
                    ?>
                </div>
            </div>

            <hr>

            <!-- **************** START OF FORM DATA **************** -->
            <form class="report-form" method="post">

                <input type="hidden" name="record_id" value="<?php echo htmlspecialchars($record_id, ENT_QUOTES, 'UTF-8'); ?>">
                <input type="hidden" name="rand_id" value="<?php echo htmlspecialchars($rand_id, ENT_QUOTES, 'UTF-8'); ?>">

                <!-- **************** OVERVIEW SECTION **************** -->
                <div class="row bg-dark text-white p-2 mt-3">
                    <div class="text-center col-md-12 h5 ">Overview</div>
                </div>
                <div class="row">
                    <div class="col-md-12 p-0" >
                        <textarea class="form-control rounded-0" rows="5" id="overview" name="overview" ></textarea>
                    </div>
                </div>

                <hr>

                <div class="row bg-dark text-white p-2 mt-3">
                    <div class="text-center col-md-12 h5 ">Ideal Soil Balancing Program for One Season of a FIVE YEAR Plan</div>
                </div>

                <div class="">
                    <?php
                    // Generate 5-year soil balancing program
                    for ($year = 1; $year <= 5; $year++) {
                        echo soilProgramCalcs('Ca', 'BS_ca_ppm', 'ca_ppm_min', 'ca_ppm_max', 'Calcium', 'kg', $record_id, $rand_id);
                    }
                    ?>
                </div> 

                <hr>

                <!-- **************** FOLIAR PROGRAM SECTION **************** -->
                <div class="row bg-dark text-white p-2 mt-3">
                    <div class="text-center col-md-12 h5" ><input type="text" class="text-center form-control-plaintext text-white border-dark bg-dark" name="header1" id="header1" value="Foliar Program"></div>
                </div>
                <div class="row">
                    <div class="col-md-12 p-0" >
                        <textarea class="form-control rounded-0" rows="5" id="foliar_Details" name="foliar_Details"></textarea>
                    </div>
                </div>

                <!-- **************** MICROBE PROGRAM SECTION **************** -->
                <div class="row bg-dark text-white p-2 mt-3">
                    <div class="text-center col-md-12 h5">Microbe Program</div>
                </div>
                <div class="row">
                    <div class="col-md-12 p-0" >
                        <textarea class="form-control rounded-0" rows="5" id="microbe_Program" name="microbe_Program" ></textarea>
                    </div>
                </div>

                <div class="row">
                    <p style="font-style: italic; font-size: 9px;">Any recommendations provided by Cropmonitor are advice only, We are not paid consultants and we are not covered to accept responsibiliy for any of our suggestions. As no control can be exercised over storage, handling, mixing application or use, or weather, plant or soil conditions before, during or after application (all of which may affect the preformance of our program), no responsibility for, or liability for any failure in performance, losses, damage or injuries consequential or otherwise, arisiing form such storage mixng 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>

            </form>
        </div>    


        <script type="text/javascript">
            $(document).ready(function(){
                var timeoutId;
                $('form textarea, form input').on('input propertychange change', function() {
                    console.log('Textarea Change');

                    clearTimeout(timeoutId);
                    timeoutId = setTimeout(function() {
                        // Runs 1 second (1000 ms) after the last change    
                        saveToDB();
                    }, 1000);
                });

                function saveToDB() {
                    console.log('Saving to the db');
                    form = $('.report-form');
                    $.ajax({
                        url: "/controllers/save_soil_analysis.php",
                        type: "POST",
                        data: form.serialize(), // serializes the form's elements.
                        beforeSend: function(xhr) {
                            // Let them know we are saving
                            $('.form-status-holder').html('Saving...');
                        },
                        success: function(data) {
                            var jqObj = jQuery(data); // You can get data returned from your ajax call here. ex. jqObj.find('.returned-data').html()
                            // Now show them we saved and when we did
                            var d = new Date();
                            $('.form-status-holder').html('Saved! Last: ' + d.toLocaleTimeString());
                        },
                    });
                }

                // This is just so we don't go anywhere  
                // and still save if you submit the form
                $('.report-form').submit(function(e) {
                    saveToDB();
                    e.preventDefault();
                });
            });
        </script>

        </div>

    <!-- 
<script src="https://cloud.tinymce.com/stable/tinymce.min.js?apiKey=xcotawi18mg1imp8im144buq68h9g3ndd3c9c8215w8qu3ld"></script>
<script>
tinymce.init({
selector: 'textarea',
menubar: false,
toolbar: 'bold italic  | alignleft aligncenter alignright alignjustify | bullist numlist | removeformat',
plugins: 'autosave',
autosave_interval: '20s'
});
</script>
-->

    <!-- jQuery first, then Popper.js, then Bootstrap JS -->
    <script type="text/javascript" src="https://code.jquery.com/ui/1.12.1/jquery-ui.min.js" integrity="sha256-VazP97ZCwtekAsvgPBSUwPFKdrwD3unUfSGVYrahUqU=" crossorigin="anonymous"></script>
    <script type="text/javascript" src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.9.3/dist/umd/popper.min.js" integrity="sha384-eMNCOe7tC1doHpGoWe/6oMVZahOyBRvxQxkjVwPtGPRwO3dRnJgOyR5MwCOgxqA==" crossorigin="anonymous"></script>
    <script type="text/javascript" src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.0/dist/js/bootstrap.bundle.min.js" integrity="sha384-ka7Sk0Gln4gmtz2MlQnikT1wXgYsOg+OMhuP+IlRH9sENBO0LRn5q+8nbTov4+1p" crossorigin="anonymous"></script>

    <script type="text/javascript">
        addEventListener("load", function() {
            setTimeout(hideURLbar, 0);
        }, false);
        function hideURLbar(){
            window.scrollTo(0,1);
        }
    </script>

    <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-easing/1.4.1/jquery.easing.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/magnific-popup.js/1.1.0/jquery.magnific-popup.js"></script>

    <script>
        function generateGraph() {
            alert('Graph generation functionality will be implemented here.');
        }
    </script>

    <script>
        //https://github.com/eKoopmans/html2pdf.js
        $('.downloadPDF').click(function () {
            var element = document.getElementById('content'); //document.createElement("body");
            element.classList.remove('screen');
            element.classList.add('print');
            var opt = {
                margin:       3,
                filename:     'soil-analysis.pdf',
                image:        { type: 'jpeg', quality: 1.0 },
                html2canvas:  { scale: 2, letterRendering: true, windowWidth: 1024 },  //, windowWidth: 1024
                jsPDF:        { orientation: 'portrait', unit: 'mm', format: 'a4', putOnlyUsedFonts: true, floatPrecision: 'smart', }
            };
            html2pdf()
                .from(element)
                .toPdf()
                .set(opt)
                .save()
                .then(function(){
                element.classList.remove('print');
                element.classList.add('screen');
            });

        });
    </script>
    </body>
</html>

<link rel="stylesheet" href="client-assets/home/css/graphPrint.css" media="print">

<style>
    .progress {
        border-radius: 0rem !important;
    }
</style>

<div class="container" id="content">
    <div class="row">
        [[!logoHeader]]
    </div>

    [[!soilAnalysisClient]]


    <!-- Graph Button -->
    <div class="d-print-none">
        [[!soilAnalysisReportButton]]
        <!-- <button class="btn btn-secondary downloadPDF" >Generate PDF</button> -->
    </div>

    <!-- GRAPH BANNER -->

    <div class="row">
        <div class="col-md-12 text-center font-weight-bold h4" >ANALYSIS RESULTS</div>
    </div>

    <hr class="p-1 m-1">

    <!-- CHART HEADER  -->
    <table class="chart">
        <tbody>
            <tr class="chart-header">
                <th colspan=3 class="text-center col-md-6 border-left border-right border-top">ELEMENT</th>
                <th colspan=3 class="text-center col-md-6 border-right border-top">STATUS</th>
            </tr>

            <tr class="chart-header-sub">
                <th class="text-center col-18 border-left"></th>
                <th class="text-center col-15">DESIRED</th>
                <th class="text-center col-15">FOUND</th>
                <th class="text-center col-16 stripe-1">LIGHT</th>
                <th class="text-center col-16 stripe-1">MEDIUM</th>
                <th class="text-center col-16 border-right stripe-1">HEAVY</th>
            </tr>

            <tr>
                <td class="border-left"></td>
                <td class="border-left"></td>
                <td class="border-left nutrient-balance"></td>
                <td class="border-left"></td>
                <td class="border-left"></td>
                <td class="border-left border-right"></td>
            </tr>

            [[!soilAnalysisCalcs? &element=cec &sbl=`` &nutrient=`CEC` &min=`` &max=`` &text=`` &recV=`n` &decimal=`2` &graph=lightorangeGraph]]
            [[!soilAnalysisCalcs? &element=tec &sbl=`` &nutrient=`TEC` &min=`` &max=`soil_type` &text=`` &recV=`max` &rec_text=`c` &decimal=`2` &graph=lightorangeGraph]]

            <tr class="chart-header-sub">
                <th class="text-center col-18 border-left text-dark bg-white"></th>
                <th class="text-center col-15 border-left text-dark bg-white"></th>
                <th class="text-center col-15 border-left nutrient-balance"></th>
                <th class="text-center col-16 border-left stripe-1">DEFICIT</th>
                <th class="text-center col-16 stripe-1">IDEAL</th>
                <th class="text-center col-16 border-right stripe-1">HIGH</th>
            </tr>

            [[!soilAnalysisCalcs? &element=ph_h2o  &sbl=`` &nutrient=`pH-level (H20)` &type=`pH` &min=`` &max=`` &text=`` &recV=`ph` &decimal=`1` &graph=lightorangeGraph]]
            [[!soilAnalysisCalcs? &element=ph_cacl2  &sbl=`` &nutrient=`pH-level (CaCl2)` &type=`pH` &min=`` &max=`` &text=`` &recV=`n` &decimal=`1` &graph=lightorangeGraph]]
            [[!soilAnalysisCalcs? &element=ec &sbl=`` &nutrient=`Conductivity (EC)` &type=`mS/cm`  &min=`` &max=`` &text=`` &decimal=`2` &graph=lightorangeGraph]]
            [[!soilAnalysisCalcs? &element=ocarbon  &sbl=`` &nutrient=`Organic Carbon` &type=`%` &min=`` &max=`` &text=`` &decimal=`1` &graph=lightorangeGraph]]
            [[!soilAnalysisCalcs? &element=omatter  &sbl=`` &nutrient=`Organic Matter` &type=`%` &min=`` &max=`` &text=`` &decimal=`1` &graph=lightorangeGraph]]

            <tr class="chart-header-sub">
                <th colspan=3 class="col-16 border-left text-center lightgreen">MAJOR ELEMENTS</th>
                <th class="text-center col-16 stripe-1"></th>
                <th class="text-center col-16 stripe-1"></th>
                <th class="text-center col-16 border-right stripe-1"></th>
            </tr>

            [[!soilAnalysisCalcs? &element=`NO3_N`  &sbl=`NO<sub>3</sub>-N` &nutrient=`Nitrate <small class="d-print-none">Nitrogen</small>` &min=`10` &max=`20` &type=ppm &text=`c` &rec_text=`r` &decimal=`0` &graph=lightgreenGraph]]
            [[!soilAnalysisCalcs? &element=`NH3_N`  &sbl=`NH<sub>3</sub>-N` &nutrient=`Ammonium <small class="d-print-none">Nitrogen</small>` &min=`` &max=`` &min=`` &max=`` &type=ppm &text=`c` &rec_text=`r` &decimal=`0` &graph=lightgreenGraph]]
            <!-- [!soilAnalysisCalcs? &element=`p_mehlick`  &sbl=`P` &nutrient=`Phosphorus <small>(mehlick III)</small>` &min=`` &max=`` &type=ppm &text=`c` &rec_text=`r` &decimal=`0` &graph=lightgreenGraph]]
[!soilAnalysisCalcs? &element=`p_bray2`  &sbl=`P` &nutrient=`Phosphorus <small>(Bray 2)</small>` &min=`` &max=`` &type=ppm &text=`c` &rec_text=`r` &decimal=`0` &graph=lightgreenGraph]]
[!soilAnalysisCalcs? &element=`p_morgan`  &sbl=`P` &nutrient=`Phosphate <small>(morgan)</small>` &min=`` &max=`` &type=ppm &text=`c` &rec_text=`r` &decimal=`0` &graph=lightgreenGraph]] -->
            [[!soilAnalysisCalcs? &element=`p_colwell`  &sbl=`P` &nutrient=`Phosphate <small>(colwell)</small>` &min=`` &max=`` &type=ppm &text=`c` &rec_text=`r` &decimal=`0` &graph=lightgreenGraph]]

            [[!soilAnalysisCalcs? &element=`BS_ca_ppm`  &sbl=`Ca` &nutrient=`Calcium` &min=`ca_ppm_min` &max=`ca_ppm_max` &type=`ppm` &text=`c` &rec_text=`r` &recV=`max` &decimal=`0` &graph=lightgreenGraph]]
            [[!soilAnalysisCalcs? &element=`BS_mg_ppm`  &sbl=`Mg` &nutrient=`Magnesium` &min=`mg_ppm_min` &max=`mg_ppm_max` &type=`ppm` &text=`c` &rec_text=`r` &recV=`max` &decimal=`0` &graph=lightgreenGraph]]
            [[!soilAnalysisCalcs? &element=`BS_k_ppm`  &sbl=`K` &nutrient=`Potassium` &min=`k_ppm_min` &max=`k_ppm_max` &type=`ppm` &text=`c` &rec_text=`r` &recV=`max` &decimal=`0` &graph=lightgreenGraph]]
            [[!soilAnalysisCalcs? &element=`BS_na_ppm`  &sbl=`Na` &nutrient=`Sodium` &min=`na_ppm_min` &max=`na_ppm_max` &type=`ppm` &text=`c` &rec_text=`r` &recV=`max` &decimal=`0` &graph=lightgreenGraph]]

            <tr class="chart-header-sub">
                <th colspan=3 class="col-16 border-left text-center lightred">TRACE ELEMENTS</th>
                <th class="text-center col-16 stripe-1"></th>
                <th class="text-center col-16 stripe-1"></th>
                <th class="text-center col-16 border-right stripe-1"></th>
            </tr>

            [[!soilAnalysisCalcs? &element=s_morgan  &sbl=`S` &nutrient=`Sulfur` &min=`` &max=`` &type=ppm &text=`c` &rec_text=`r` &decimal=`2` &graph=lightredGraph]]
            [[!soilAnalysisCalcs? &element=b_cacl2  &sbl=`B` &nutrient=`Boron` &min=`` &max=`` &type=ppm &text=`c` &rec_text=`r` &decimal=`2` &graph=lightredGraph]]
            [[!soilAnalysisCalcs? &element=mn_dtpa  &sbl=`Mn` &nutrient=`Manganese` &min=`` &max=`` &type=ppm &text=`c` &rec_text=`r` &decimal=`2` &graph=lightredGraph]]
            [[!soilAnalysisCalcs? &element=cu_dtpa  &sbl=`Cu` &nutrient=`Copper` &min=`` &max=`` &type=ppm &text=`c` &rec_text=`r` &decimal=`2` &graph=lightredGraph]]
            [[!soilAnalysisCalcs? &element=zn_dtpa  &sbl=`Zn` &nutrient=`Zinc` &min=`` &max=`` &type=ppm &text=`c` &rec_text=`r` &decimal=`2` &graph=lightredGraph]]
            [[!soilAnalysisCalcs? &element=fe_dtpa  &sbl=`Ir` &nutrient=`Iron` &min=`` &max=`` &type=ppm &text=`c` &rec_text=`r` &decimal=`2` &graph=lightredGraph]]
            [[!soilAnalysisCalcs? &element=al  &sbl=`Al` &nutrient=`Aluminium` &min=`` &max=`` &type=ppm &text=`c` &rec_text=`r` &decimal=`2` &graph=lightredGraph]]
            [[!soilAnalysisCalcs? &element=sl_cacl2  &sbl=`Si` &nutrient=`Silicon` &min=`` &max=`` &type=ppm &text=`c` &rec_text=`r` &decimal=`2` &graph=lightredGraph]]

            <tr class="chart-header-sub">
                <th colspan=3 class="col-16 border-left text-center lightpurple">BASE SATURATION</th>
                <th class="text-center col-16 stripe-1"></th>
                <th class="text-center col-16 stripe-1"></th>
                <th class="text-center col-16 border-right stripe-1"></th>
            </tr>

            [[!soilAnalysisCalcs? &element=`BS_ca2` &sbl=`Ca` &nutrient=`Calcium` &min=`cabs_min` &max=`cabs_max` &type=`%` &text=`c` &rec_text=`r` &recV=`max` &decimal=`2` &graph=lightpurpleGraph]]
            [[!soilAnalysisCalcs? &element=`BS_mg2` &sbl=`Mg` &nutrient=`Magnesium` &min=`mgbs_min` &max=`mgbs_max` &type=`%` &text=`c` &rec_text=`r` &recV=`max` &decimal=`2` &graph=lightpurpleGraph]]
            [[!soilAnalysisCalcs? &element=`BS_k` &sbl=`K` &nutrient=`Potassium` &min=`kbs_min` &max=`kbs_max` &type=`%` &text=`c` &rec_text=`r` &recV=`max` &decimal=`2` &graph=lightpurpleGraph]]
            [[!soilAnalysisCalcs? &element=`BS_na` &sbl=`Na` &nutrient=`Sodium` &min=`nabs_min` &max=`nabs_max` &type=`%` &text=`c` &rec_text=`r` &recV=`max` &decimal=`2` &graph=lightpurpleGraph]]
            [[!soilAnalysisCalcs? &element=`BS_ob` &sbl=`` &nutrient=`Other Bases` &min=`` &max=`ob_rec` &type=`%` &text=`c` &rec_text=`r` &recV=`max` &decimal=`2` &graph=lightpurpleGraph]]
            [[!soilAnalysisCalcs? &element=`BS_h` &sbl=`` &nutrient=`Hydrogen` &min=`` &max=`h_rec` &type=`%` &text=`c` &rec_text=`r` &recV=`max` &decimal=`2` &graph=lightpurpleGraph]]

            <tr class="chart-header-sub">
                <th colspan=3 class="col-16 border-left text-center lightgrey">SOLUBLE MORGAN 2 EXTRACT</th>
                <th class="text-center col-16 stripe-1"></th>
                <th class="text-center col-16 stripe-1"></th>
                <th class="text-center col-16 border-right stripe-1"></th>
            </tr>

            [[!soilAnalysisCalcs? &element=s_morgan  &sbl=`Ca` &nutrient=`Calcium` &min=`` &max=`` &type=`%` &text=`c` &rec_text=`r` &decimal=`0` &graph=lightgreyGraph]]
            [[!soilAnalysisCalcs? &element=b_cacl2  &sbl=`Mg` &nutrient=`Magnesium` &min=`` &max=`` &type=`%` &text=`c` &rec_text=`r` &decimal=`0` &graph=lightgreyGraph]]
            [[!soilAnalysisCalcs? &element=mn_dtpa  &sbl=`K` &nutrient=`Potassium` &min=`` &max=`` &type=`%` &text=`c` &rec_text=`r` &decimal=`0` &graph=lightgreyGraph]]


            <tr class="chart-header-sub">
                <th colspan=3 class="col-16 border-left text-center lightgrey">ADDITIONAL DATA</th>
                <th class="text-center col-16 stripe-1">LOW</th>
                <th class="text-center col-16 stripe-1">IDEAL</th>
                <th class="text-center col-16 border-right stripe-1">EXCELLENT</th>
            </tr>

            [[!soilAnalysisCalcs? &element=s_morgan  &sbl=`Ca` &nutrient=`Calcium` &min=`` &max=`` &type=`%` &text=`c` &rec_text=`r` &decimal=`0` &graph=lightgreyGraph]]

            <tr class="chart-header-sub">
                <th colspan=3 class="col-16 border-left text-center lightblue">RATIOS</th>
                <th class="text-center col-16 stripe-1"></th>
                <th class="text-center col-16 stripe-1"></th>
                <th class="text-center col-16 border-right stripe-1"></th>
            </tr>

            [[!soilAnalysisRatio? &element=ca_mehlick3 &elementTwo=mg_mehlick3  &sbl=`` &rec=`ca_mg_ratio` &nutrient=`Ca:Mg Ratio` &min=`` &max=`` &text=`y` &rec_text=`r` &decimal=`1` &graph=lightblueGraph]]
            [[!soilAnalysisCalcs? &element=NH3_N  &sbl=`` &nutrient=`Total Nitrogen` &type=`%` &min=`` &max=`` &text=`c` &rec_text=`r` &decimal=`1` &graph=lightblueGraph]]
            [[!soilAnalysisCalcs? &element=ocarbon  &sbl=`` &nutrient=`Total Carbon` &type=`%` &min=`` &max=`` &text=`c` &rec_text=`r` &decimal=`1` &graph=lightblueGraph]]
            [[!soilAnalysisRatio? &element=ocarbon &elementTwo=NO3_N &sbl=`` &rec=`c_n_ratio` &nutrient=`C:N Ratio `&type=`:1` &min=`` &max=`` &text=`y` &rec_text=`r` &decimal=`1` &graph=lightblueGraph]]


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

    <div class="analysis-footer">
        <div class="col text-center">&copy; 2008-[[!date?format=year]] Cropmonitor</div>
    </div>
</div>

</div>

<!-- 
<script src="https://cloud.tinymce.com/stable/tinymce.min.js?apiKey=xcotawi18mg1imp8im144buq68h9g3ndd3c9c8215w8qu3ld"></script>
<script>
tinymce.init({
selector: 'textarea',
menubar: false,
toolbar: 'bold italic  | alignleft aligncenter alignright alignjustify | bullist numlist | removeformat',
plugins: 'autosave',
autosave_interval: '20s'
});
</script>
-->

<!-- jQuery first, then Popper.js, then Bootstrap JS -->
<script type="text/javascript" src="https://code.jquery.com/ui/1.12.1/jquery-ui.min.js" integrity="sha256-VazP97ZCwtekAsvgPBSUwPFKdrwD3unUfSGVYrahUqU=" crossorigin="anonymous"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js" integrity="sha384-ZMP7rVo3mIykV+2+9J3UJ46jBk0WLaUAdn689aCwoqbBJiSnjAK/l8WvCWPIPm49" crossorigin="anonymous"></script>
<script type="text/javascript" src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js" integrity="sha384-ChfqqxuZUCnJSK3+MXmPNIyE6ZbWh2IMqE241rYiqJxyMiZ6OW/JmZQ5stwEULTy" crossorigin="anonymous"></script>	

<script type="text/javascript">
    addEventListener("load", function() { 
        setTimeout(hideURLbar, 0);
    }, false);
    function hideURLbar(){ 
        window.scrollTo(0,1);
    }
</script>

<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.bundle.min.js" integrity="sha384-xrRywqdh3PHs8keKZN+8zzc5TX0GRTLCcmivcbNJWm2rs5C8PRhcEn3czEjhAO9o" crossorigin="anonymous"></script>

<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-easing/1.4.1/jquery.easing.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/magnific-popup.js/1.1.0/jquery.magnific-popup.js"></script>

<script>
    //https://github.com/eKoopmans/html2pdf.js
    $('.downloadPDF').click(function () {
        var element = document.getElementById('content'); //document.createElement("body");
        element.classList.remove('screen');
        element.classList.add('print');
        var opt = {
            margin:       3,
            filename:     'soil-analysis.pdf',
            image:        { type: 'jpeg', quality: 1.0 },
            html2canvas:  { scale: 2, letterRendering: true, windowWidth: 1024 },  //, windowWidth: 1024
            jsPDF:        { orientation: 'portrait', unit: 'mm', format: 'a4', putOnlyUsedFonts: true, floatPrecision: 'smart', }
        };
        html2pdf()
            .from(element)
            .toPdf()
            .set(opt)
            .save()
            .then(function(){
            element.classList.remove('print');
            element.classList.add('screen');
        });

    });
</script>
</body>
</html>