dhkpi.php

<?php include("assets/head/h.php"); ?>
<div class="pcoded-main-container">
    <div class="pcoded-content">
        <div class="pagetitle mb-2">
            <h5 class="fw-bold text-primary mb-1">
              <i class="bi bi-bar-chart-line-fill me-2"></i>Key Performance Indicator
            </h5>
        </div>

        <div class="card">
            <div class="card-body">
                <form method="post">
                    <div class="row align-items-end">
                        <div class="col-auto">
                            <label for="date1" class="form-label">Select Month</label>
                            <input type="month" class="form-control" name="date1" id="date1"
                                value="<?= isset($_POST['date1']) ? $_POST['date1'] : date('Y-m'); ?>"
                                min="<?= date('Y-m', strtotime('-6 months')); ?>"
                                max="<?= date('Y-m'); ?>" required>
                        </div>
                        <div class="col-auto">
                            <button type="submit" name="submit1" class="btn btn-primary">Fill Data</button>
                        </div>
                    </div>
                </form>
            </div>
        </div>

<?php
if (isset($_POST['submit1'])) {
    $new_date1 = date('Y-m', strtotime($_POST['date1']));
    $_SESSION['new_date1'] = $new_date1;

    if ($new_date1 == '1970-01') {
        echo "<div class='alert alert-danger'>Kindly select a valid month.</div>";
    } else {
        $fac_id = $_SESSION['u_facilityid'];
        $check_query = "SELECT COUNT(dh_kpi_id) AS total FROM dh_kpi_in WHERE dh_kpi_date = ? AND dh_kpi_fac_id = ?";
        $stmt1 = $con->prepare($check_query);
        $stmt1->bind_param("si", $new_date1, $fac_id);
        $stmt1->execute();
        $result1 = $stmt1->get_result();
        $row1 = $result1->fetch_assoc();

        if ((int)$row1['total'] > 0) {
            echo "<div class='alert alert-danger'>The values for this month <b>($new_date1)</b> have already been recorded.</div>";
        } else {
            $q3 = mysqli_query($con, "SELECT * FROM dhkpi");
            $q = 0;
            $total = mysqli_num_rows($q3);

            echo '<form method="post">';
            while ($row = mysqli_fetch_array($q3)) {
                $q++;
                $readonly = ($row['dh_kpi_d'] === 'N/A') ? 'readonly' : '';
                $isLast = ($q == $total);
                $inputNumId = $q * 2 - 1;
                $inputDenId = $q * 2;
                $isYesNoSpecific = in_array($inputNumId, [43, 45]);

                echo "<div class='card mb-3 outcome-card' id='card$q' style='" . ($q > 1 ? "display:none;" : "") . "'>
                        <div class='card-body'>
                            <h6 class='card-title text-primary'><i class='bi bi-bar-chart-fill me-2'></i>KPI Indicator: {$row['dh_kpitext']}</h6>
                            <div class='alert alert-primary py-2 px-3 small d-flex align-items-center'>
                                <i class='bi bi-info-circle-fill me-2'></i>
                                <div><strong>Expected:</strong> <span class='text-warning'><b>Numerator:</b></span> <b>{$row['dh_kpi_n']}</b>,  <span class='text-warning'><b>Denominator:</b></span> <b>{$row['dh_kpi_d']}</b></div>
                            </div>
                            <div class='row g-2'>";

                if ($isYesNoSpecific) {
                    echo "<div class='col-md-4'>
                            <select class='form-control' name='input$inputNumId' id='input$inputNumId' onchange='calculateResult($q)'>
                                <option value=''>- Select -</option>
                                <option value='yes'>Yes</option>
                                <option value='no'>No</option>
                            </select>
                        </div>
                        <div class='col-md-4'>
                            <input type='text' class='form-control' readonly value='N/A'>
                        </div>";
                } else {
                    echo "<div class='col-md-4'>
                            <input type='number' class='form-control' name='input$inputNumId' id='input$inputNumId' placeholder='Numerator' oninput='calculateResult($q)'>
                        </div>
                        <div class='col-md-4'>
                            <input type='number' class='form-control' name='input$inputDenId' id='input$inputDenId' placeholder='Denominator' oninput='calculateResult($q)' $readonly>
                        </div>";
                }

                echo "<div class='col-md-4'>
                        <input type='text' class='form-control' name='result$q' id='result$q' readonly placeholder='Result'>
                    </div>
                    </div>
                    <input type='hidden' name='out_come_id$q' value='{$row['dh_kpi_id']}'>
                    <div class='mt-3 d-flex justify-content-between'>";
                echo ($q > 1) ? "<button type='button' class='btn btn-secondary btn-sm' onclick='showPreviousCard($q)'><i class='bi bi-arrow-left'></i> Back</button>" : "<div></div>";
                echo $isLast
                    ? "<button type='submit' name='postsubmit3' class='btn btn-primary btn-sm'>Submit All</button>"
                    : "<button type='button' class='btn btn-success btn-sm' onclick='showNextCard($q)'> Next <i class='bi bi-arrow-right'></i></button>";
                echo "</div></div></div>";
            }
            echo "</form>";
        }
    }
}
?>

<?php
if (isset($_POST['postsubmit3'])) {
    $date1 = $_SESSION['new_date1'];
    $fac_id = $_SESSION['u_facilityid'];

    $result = mysqli_query($con, "SELECT dh_kpi_id FROM dhkpi");
    $success = true;
    $errorMessages = [];
    $index = 0;

    while ($row = mysqli_fetch_assoc($result)) {
        $index++;
        $kpi_id = $row['dh_kpi_id'];
        $key = "result$index";
        $value = $_POST[$key] ?? null;

        if ($value !== null) {
            $stmt = $con->prepare("CALL insert_dhkpi(?, ?, ?, ?)");
            $stmt->bind_param("issi", $kpi_id, $value, $date1, $fac_id);
            if (!$stmt->execute()) {
                $success = false;
                $errorMessages[] = "Error inserting for Outcome ID: {$kpi_id}";
            }
            $stmt->close();
        } else {
            $errorMessages[] = "Missing result for Outcome ID: {$kpi_id}";
            $success = false;
        }
    }

    echo $success ? "<div class='alert alert-success'>Outcome Values inserted successfully!</div>"
        : "<div class='alert alert-danger'>There was an error while inserting data.</div>";

    if (!empty($errorMessages)) {
        echo "<div class='alert alert-danger'>" . implode("<br>", $errorMessages) . "</div>";
    }
}
?>
</div>
</div>

<script>
function calculateResult(q) {
    const inputNum = document.getElementById('input' + (q * 2 - 1));
    const inputDen = document.getElementById('input' + (q * 2));
    const result = document.getElementById('result' + q);

    if (!inputNum || !result) return;

    const val = inputNum.value.toLowerCase();

    if (val === 'yes' || val === 'no') {
        result.value = val.charAt(0).toUpperCase() + val.slice(1);
    } else if (inputNum.type === 'number' && inputDen && inputDen.type === 'number') {
        const numerator = parseFloat(inputNum.value);
        const denominator = parseFloat(inputDen.value);
        if (!isNaN(numerator) && !isNaN(denominator) && denominator !== 0) {
            result.value = ((numerator / denominator) * 100).toFixed(2);
        } else {
            result.value = '';
        }
    }
}

function showNextCard(current) {
    const inputNum = document.getElementById('input' + (current * 2 - 1));
    const inputDen = document.getElementById('input' + (current * 2));
    let isValid = true;

    if (!inputNum.value.trim()) {
        inputNum.focus();
        inputNum.classList.add('is-invalid');
        isValid = false;
    } else {
        inputNum.classList.remove('is-invalid');
    }

    if (inputDen && !inputDen.hasAttribute('readonly') && !inputDen.value.trim()) {
        inputDen.focus();
        inputDen.classList.add('is-invalid');
        isValid = false;
    } else if (inputDen) {
        inputDen.classList.remove('is-invalid');
    }

    if (!isValid) return;

    const currentCard = document.getElementById('card' + current);
    const nextCard = document.getElementById('card' + (current + 1));
    if (currentCard) currentCard.style.display = 'none';
    if (nextCard) nextCard.style.display = 'block';
}

function showPreviousCard(current) {
    const currentCard = document.getElementById('card' + current);
    const prevCard = document.getElementById('card' + (current - 1));
    if (currentCard) currentCard.style.display = 'none';
    if (prevCard) prevCard.style.display = 'block';
}
</script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha1/dist/js/bootstrap.bundle.min.js"></script>
<?php include("assets/head/f.php"); ?>