<?php
// Database configuration
// $host = 'localhost';
// $username = 'root';
// $password = '';
// $dbname = 'matrix';

$host = '203.115.101.51';
$username = 'ashutosh';
$password = 'ashutosh@#888';
$dbname = 'matrix';

// Create connection
$conn = mysqli_connect($host, $username, $password, $dbname, 3306);

// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

// Set charset
mysqli_set_charset($conn, "latin1");

// Handle update/insert request
if (isset($_POST['action']) && $_POST['action'] == 'update') {
    $id = mysqli_real_escape_string($conn, $_POST['id']);
    $sys_service_id = mysqli_real_escape_string($conn, $_POST['sys_service_id']);
    $min_temp = mysqli_real_escape_string($conn, $_POST['min_temp']);
    $max_temp = mysqli_real_escape_string($conn, $_POST['max_temp']);
    $avg_temp = mysqli_real_escape_string($conn, $_POST['avg_temp']);
    $temp_date = mysqli_real_escape_string($conn, $_POST['temp_date']);

    // Check if record exists
    $check_sql = "SELECT id FROM temperature_summary WHERE sys_service_id = '$sys_service_id' AND temp_date = '$temp_date'";
    $check_result = mysqli_query($conn, $check_sql);

    if (mysqli_num_rows($check_result) > 0) {
        // Update existing record
        $sql = "UPDATE temperature_summary SET 
                min_temp = '$min_temp',
                max_temp = '$max_temp',
                avg_temp = '$avg_temp'
                WHERE sys_service_id = '$sys_service_id' AND temp_date = '$temp_date'";
    } else {
        // Insert new record
        $sql = "INSERT INTO temperature_summary (sys_service_id, min_temp, max_temp, avg_temp, temp_date) 
                VALUES ('$sys_service_id', '$min_temp', '$max_temp', '$avg_temp', '$temp_date')";
    }

    if (mysqli_query($conn, $sql)) {
        echo json_encode(array('success' => true, 'message' => 'Record saved successfully'));
    } else {
        echo json_encode(array('success' => false, 'message' => 'Error: ' . mysqli_error($conn)));
    }
    exit;
}

// Handle fetch data request
if (isset($_POST['action']) && $_POST['action'] == 'fetch') {
    $start_date = mysqli_real_escape_string($conn, $_POST['start_date']);
    $end_date = mysqli_real_escape_string($conn, $_POST['end_date']);
    $sys_service_id = mysqli_real_escape_string($conn, $_POST['sys_service_id']);

    // Check if all filters are provided
    if (empty($start_date) || empty($end_date) || empty($sys_service_id)) {
        echo json_encode(array('error' => true, 'message' => 'All three filters (Start Date, End Date, and Service ID) are required'));
        exit;
    }

    // Get existing records from database
    $sql = "SELECT * FROM temperature_summary 
            WHERE sys_service_id = '$sys_service_id' 
            AND temp_date BETWEEN '$start_date' AND '$end_date'
            ORDER BY temp_date ASC";

    error_log("SQL Query: " . $sql);

    $result = mysqli_query($conn, $sql);

    if (!$result) {
        echo json_encode(array('error' => true, 'message' => mysqli_error($conn)));
        exit;
    }

    // Create array of existing dates
    $existing_data = array();
    $existing_dates = array();

    while ($row = mysqli_fetch_assoc($result)) {
        $existing_data[] = $row;
        $existing_dates[] = $row['temp_date'];
    }

    // Generate all dates in the range
    $all_dates = array();
    $current = strtotime($start_date);
    $end = strtotime($end_date);

    while ($current <= $end) {
        $all_dates[] = date('Y-m-d', $current);
        $current = strtotime('+1 day', $current);
    }

    // Find missing dates
    $missing_dates = array_diff($all_dates, $existing_dates);

    // Create dummy records for missing dates
    $complete_data = array();

    // Add existing records
    foreach ($existing_data as $row) {
        $complete_data[] = $row;
    }

    // Add dummy records for missing dates
    foreach ($missing_dates as $date) {
        $dummy_record = array(
            'id' => 'new_' . $date, // Temporary ID for new records
            'sys_service_id' => $sys_service_id,
            'min_temp' => '0.00000000',
            'max_temp' => '0.00000000',
            'avg_temp' => '0.00000000',
            'temp_date' => $date,
            'is_dummy' => true // Flag to identify dummy records
        );
        $complete_data[] = $dummy_record;
    }

    // Sort complete data by date
    usort($complete_data, function ($a, $b) {
        return strtotime($a['temp_date']) - strtotime($b['temp_date']);
    });

    echo json_encode(array('data' => $complete_data, 'sql' => $sql));
    exit;
}

// Handle Excel download
if (isset($_POST['action']) && $_POST['action'] == 'excel_download') {
    $start_date = mysqli_real_escape_string($conn, $_POST['start_date']);
    $end_date = mysqli_real_escape_string($conn, $_POST['end_date']);
    $sys_service_id = mysqli_real_escape_string($conn, $_POST['sys_service_id']);

    // Check if all filters are provided
    if (empty($start_date) || empty($end_date) || empty($sys_service_id)) {
        echo json_encode(array('error' => true, 'message' => 'All three filters are required'));
        exit;
    }

    // Get ONLY existing records from database (no dummy records)
    $sql = "SELECT * FROM temperature_summary 
            WHERE sys_service_id = '$sys_service_id' 
            AND temp_date BETWEEN '$start_date' AND '$end_date'
            ORDER BY temp_date ASC";

    $result = mysqli_query($conn, $sql);
    $data = array();

    while ($row = mysqli_fetch_assoc($result)) {
        $data[] = $row;
    }

    // Generate HTML table for Excel
    $html = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/1999/xhtml">
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Temperature Summary Export</title>
        <style>
            table { border-collapse: collapse; width: 100%; }
            th { background: #4CAF50; color: white; padding: 8px; text-align: left; }
            td { border: 1px solid #ddd; padding: 6px; }
            tr:nth-child(even) { background: #f2f2f2; }
        </style>
    </head>
    <body>
        <table>
            <thead>
                <tr>
                    <th>Service ID</th>
                    <th>Min Temp</th>
                    <th>Max Temp</th>
                    <th>Avg Temp</th>
                    <th>Date</th>
                </tr>
            </thead>
            <tbody>';

    if (count($data) > 0) {
        foreach ($data as $row) {
            // $html .= '<tr>
            //             <td>' . htmlspecialchars($row['sys_service_id']) . '</td>
            //             <td>' . htmlspecialchars(number_format((float) $row['min_temp'], 1, '.', '')) . '</td>
            //             <td>' . htmlspecialchars(number_format((float) $row['max_temp'], 1, '.', '')) . '</td>
            //             <td>' . htmlspecialchars(number_format((float) $row['avg_temp'], 1, '.', '')) . '</td>
            //             <td>' . htmlspecialchars($row['temp_date']) . '</td>
            //         </tr>';
            $html .= '<tr>
                        <td>' . htmlspecialchars($row['sys_service_id']) . '</td>
                        <td>' . htmlspecialchars($row['min_temp']) . '</td>
                        <td>' . htmlspecialchars($row['max_temp']) . '</td>
                        <td>' . htmlspecialchars($row['avg_temp']) . '</td>
                        <td>' . htmlspecialchars($row['temp_date']) . '</td>
                    </tr>';
        }
    } else {
        $html .= '<tr><td colspan="5" class="text-center">No records found in database for the selected criteria</td></tr>';
    }

    $html .= '</tbody></table></body></html>';

    // Set headers for Excel download
    header('Content-Type: application/vnd.ms-excel');
    header('Content-Disposition: attachment; filename="temperature_summary_' . date('Y-m-d_H-i-s') . '.xls"');
    header('Cache-Control: max-age=0');

    echo $html;
    exit;
}
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Temperature Summary</title>

    <!-- Bootstrap 3 CSS -->
    <link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">

    <!-- SweetAlert2 -->
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/limonte-sweetalert2/7.33.1/sweetalert2.min.css">

    <!-- Font Awesome 4 -->
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">

    <!-- TableFilter CSS -->
    <link rel="stylesheet" href="dist/tablefilter/style/tablefilter.css">

    <style>
        .filter-container {
            background: #f8f9fa;
            padding: 20px;
            border-radius: 8px;
            margin-bottom: 20px;
            border: 1px solid #ddd;
        }

        .edit-mode input {
            width: 100%;
            padding: 4px;
            border: 1px solid #ddd;
            border-radius: 4px;
            font-size: 12px;
        }

        .edit-mode td {
            padding: 4px !important;
        }

        .btn-edit,
        .btn-update,
        .btn-cancel {
            padding: 4px 8px;
            margin: 0 2px;
            font-size: 12px;
        }

        .action-buttons {
            white-space: nowrap;
        }

        .table-responsive {
            overflow-x: auto;
        }

        table {
            font-size: 12px;
            width: 100%;
            border-collapse: collapse;
        }

        table th {
            background: #f2f2f2;
            padding: 8px;
            text-align: left;
        }

        table td {
            padding: 6px;
            border-bottom: 1px solid #ddd;
        }

        .btn-sm {
            padding: 3px 8px;
        }

        .form-control-sm {
            height: 28px;
            padding: 3px 6px;
            font-size: 12px;
        }

        #filtertableallveh_wrapper {
            margin-top: 20px;
        }

        .reset-button {
            margin-bottom: 10px;
        }

        .date-input {
            background: #fff;
        }

        .btn-excel {
            background-color: #27ae60;
            border-color: #27ae60;
            color: white;
            margin-left: 10px;
        }

        .btn-excel:hover {
            background-color: #219a52;
            color: white;
        }

        .filter-required {
            color: #e74c3c;
            font-weight: bold;
            margin-left: 5px;
        }

        .dummy-row {
            background-color: #fff3cd !important;
        }

        .dummy-row td {
            font-style: italic;
            color: #856404;
        }

        .required-field {
            border-left: 3px solid #e74c3c !important;
        }

        .form-group.required .control-label:after {
            content: " *";
            color: #e74c3c;
            font-weight: bold;
        }
    </style>
</head>

<body>
    <div class="container-fluid" style="margin: 20px;">
        <h2 class="mb-4">Temperature Summary</h2>

        <!-- Filter Section -->
        <div class="filter-container">
            <form id="filterForm" class="form-horizontal" role="form">
                <div class="row">
                    <div class="col-md-3">
                        <div class="form-group required">
                            <label for="start_date" class="control-label">
                                Start Date: <span class="filter-required">*</span>
                            </label>
                            <input type="date" class="form-control date-input" id="start_date" name="start_date"
                                max="<?php echo date('Y-m-d'); ?>" required>
                        </div>
                    </div>

                    <div class="col-md-3">
                        <div class="form-group required">
                            <label for="end_date" class="control-label">
                                End Date: <span class="filter-required">*</span>
                            </label>
                            <input type="date" class="form-control date-input" id="end_date" name="end_date"
                                max="<?php echo date('Y-m-d'); ?>" required>
                        </div>
                    </div>

                    <div class="col-md-2">
                        <div class="form-group required">
                            <label for="sys_service_id" class="control-label">
                                Service ID: <span class="filter-required">*</span>
                            </label>
                            <input type="number" class="form-control" id="sys_service_id" name="sys_service_id"
                                placeholder="Enter ID" required>
                        </div>
                    </div>

                    <div class="col-md-4">
                        <div class="form-group" style="margin-top: 27px; margin-left: 7px;">
                            <button type="submit" class="btn btn-primary">
                                <i class="fa fa-search"></i> Search
                            </button>
                            <button type="button" class="btn btn-default" onclick="resetFilters()">
                                <i class="fa fa-undo"></i> Reset
                            </button>
                            <button type="button" class="btn btn-excel" onclick="downloadExcel()">
                                <i class="fa fa-file-excel-o"></i> Download Excel
                            </button>
                        </div>
                    </div>
                </div>
                <div class="row">
                    <div class="col-md-12 text-info">
                        <small><i class="fa fa-info-circle"></i> <span class="text-danger">*</span> All three filters
                            are required to search or download data</small>
                    </div>
                </div>
            </form>
        </div>

        <!-- Data Table -->
        <div class="table-responsive">
            <table id="filtertableallveh" class="table table-striped table-bordered" style="width:100%">
                <thead>
                    <tr>
                        <th>Service ID</th>
                        <th>Min Temp</th>
                        <th>Max Temp</th>
                        <th>Avg Temp</th>
                        <th>Date</th>
                        <th>Actions</th>
                    </tr>
                </thead>
                <tbody id="tableBody">
                    <tr>
                        <td colspan="6" class="text-center">Please apply all three filters to search data</td>
                    </tr>
                </tbody>
            </table>
        </div>
    </div>

    <!-- jQuery -->
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/limonte-sweetalert2/7.33.1/sweetalert2.min.js"></script>
    <script src="dist/tablefilter/tablefilter.js"></script>

    <script>
        var tf;
        var editingRow = null;
        var currentFilters = {
            start_date: '',
            end_date: '',
            sys_service_id: ''
        };

        // Set max date for date inputs (today)
        var today = new Date().toISOString().split('T')[0];
        document.getElementById('start_date').setAttribute('max', today);
        document.getElementById('end_date').setAttribute('max', today);

        // Validate that end date is not before start date
        document.getElementById('start_date').addEventListener('change', function () {
            document.getElementById('end_date').setAttribute('min', this.value);
        });

        jQuery(document).ready(function ($) {
            // Initialize TableFilter
            setTimeout(function () {
                if (document.getElementById('filtertableallveh')) {
                    var filtersConfig = {
                        base_path: 'dist/tablefilter/',
                        paging: false,
                        remember_grid_values: false,
                        remember_page_number: false,
                        remember_page_length: false,
                        alternate_rows: true,
                        btn_reset: true,
                        rows_counter: true,
                        loader: true,
                        status_bar: true,
                        col_types: [
                            'string', 'number', 'number', 'number', 'string', 'string'
                        ],
                        extensions: [{
                            name: 'sort'
                        }]
                    };

                    tf = new TableFilter('filtertableallveh', filtersConfig);
                    tf.init();
                }
            }, 100);

            // Handle form submission
            $('#filterForm').on('submit', function (e) {
                e.preventDefault();

                // Check if all filters are provided
                var startDate = $('#start_date').val();
                var endDate = $('#end_date').val();
                var serviceId = $('#sys_service_id').val();

                if (!startDate || !endDate || !serviceId) {
                    swal({
                        type: 'warning',
                        title: 'All Filters Required',
                        text: 'Please provide Start Date, End Date, and Service ID to search data'
                    });
                    return;
                }

                // Validate date range
                if (new Date(startDate) > new Date(endDate)) {
                    swal({
                        type: 'error',
                        title: 'Invalid Date Range',
                        text: 'End Date cannot be before Start Date'
                    });
                    return;
                }

                // Save current filters
                currentFilters.start_date = startDate;
                currentFilters.end_date = endDate;
                currentFilters.sys_service_id = serviceId;

                loadData();
            });
        });

        function loadData() {
            $('#tableBody').html('<tr><td colspan="6" class="text-center"><i class="fa fa-spinner fa-spin"></i> Loading...</td></tr>');

            $.ajax({
                url: '',
                type: 'POST',
                data: {
                    action: 'fetch',
                    start_date: currentFilters.start_date,
                    end_date: currentFilters.end_date,
                    sys_service_id: currentFilters.sys_service_id
                },
                dataType: 'json',
                success: function (response) {
                    if (response.error) {
                        $('#tableBody').html('<tr><td colspan="6" class="text-center text-danger">' + response.message + '</td></tr>');
                        return;
                    }

                    if (response.data && response.data.length > 0) {
                        renderTableData(response.data);
                    } else {
                        $('#tableBody').html('<tr><td colspan="6" class="text-center">No data found for the selected filters</td></tr>');
                    }

                    // Refresh TableFilter
                    if (tf) {
                        tf.destroy();
                        setTimeout(function () {
                            tf = new TableFilter('filtertableallveh', {
                                base_path: 'dist/tablefilter/',
                                paging: false,
                                remember_grid_values: false,
                                alternate_rows: true,
                                btn_reset: true,
                                rows_counter: true,
                                loader: true,
                                status_bar: true,
                                col_types: [
                                    'string', 'number', 'number', 'number', 'string', 'string'
                                ],
                                extensions: [{
                                    name: 'sort'
                                }]
                            });
                            tf.init();
                        }, 100);
                    }
                },
                error: function (xhr, status, error) {
                    $('#tableBody').html('<tr><td colspan="6" class="text-center text-danger">Error loading data: ' + error + '</td></tr>');
                    swal({
                        type: 'error',
                        title: 'Error',
                        text: 'Failed to load data'
                    });
                }
            });
        }

        function renderTableData(data) {
            var html = '';
            for (var i = 0; i < data.length; i++) {
                var row = data[i];
                var rowClass = row.is_dummy ? 'dummy-row' : '';
                var editButton = row.is_dummy ?
                    '<button class="btn btn-success btn-xs btn-edit" onclick="editRow(this)">' +
                    '<i class="fa fa-plus"></i> Add Data</button>' :
                    '<button class="btn btn-primary btn-xs btn-edit" onclick="editRow(this)">' +
                    '<i class="fa fa-edit"></i> Edit</button>';

                html += '<tr class="' + rowClass + '" data-id="' + row.id + '" data-sys-service-id="' + row.sys_service_id + '" data-date="' + row.temp_date + '" data-is-dummy="' + (row.is_dummy || false) + '">' +
                    '<td>' + (row.sys_service_id || '') + '</td>' +
                    '<td>' + (row.min_temp || '') + '</td>' +
                    '<td>' + (row.max_temp || '') + '</td>' +
                    '<td>' + (row.avg_temp || '') + '</td>' +
                    '<td>' + (row.temp_date || '') + '</td>' +
                    '<td><div class="action-buttons">' + editButton + '</div></td>' +
                    '</tr>';
            }
            $('#tableBody').html(html);
        }

        function resetFilters() {
            // Clear all filter fields
            $('#start_date').val('');
            $('#end_date').val('');
            $('#sys_service_id').val('');

            // Clear min attribute from end_date
            $('#end_date').removeAttr('min');

            // Clear current filters
            currentFilters = {
                start_date: '',
                end_date: '',
                sys_service_id: ''
            };

            // Show empty table message
            $('#tableBody').html('<tr><td colspan="6" class="text-center">Please apply all three filters to search data</td></tr>');

            // Refresh TableFilter with empty table
            if (tf) {
                tf.destroy();
                setTimeout(function () {
                    tf = new TableFilter('filtertableallveh', {
                        base_path: 'dist/tablefilter/',
                        paging: false,
                        remember_grid_values: false,
                        alternate_rows: true,
                        btn_reset: true,
                        rows_counter: true,
                        loader: true,
                        status_bar: true,
                        col_types: [
                            'string', 'number', 'number', 'number', 'string', 'string'
                        ],
                        extensions: [{
                            name: 'sort'
                        }]
                    });
                    tf.init();
                }, 100);
            }
        }

        function downloadExcel() {
            // Check if all filters are provided
            var startDate = $('#start_date').val();
            var endDate = $('#end_date').val();
            var serviceId = $('#sys_service_id').val();

            if (!startDate || !endDate || !serviceId) {
                swal({
                    type: 'warning',
                    title: 'All Filters Required',
                    text: 'Please provide Start Date, End Date, and Service ID to download data'
                });
                return;
            }

            // Validate date range
            if (new Date(startDate) > new Date(endDate)) {
                swal({
                    type: 'error',
                    title: 'Invalid Date Range',
                    text: 'End Date cannot be before Start Date'
                });
                return;
            }

            // Use current filter values from inputs
            var form = $('<form method="POST" style="display:none;">');
            form.append('<input type="hidden" name="action" value="excel_download">');
            form.append('<input type="hidden" name="start_date" value="' + startDate + '">');
            form.append('<input type="hidden" name="end_date" value="' + endDate + '">');
            form.append('<input type="hidden" name="sys_service_id" value="' + serviceId + '">');
            $('body').append(form);
            form.submit();
            form.remove();
        }

        function editRow(button) {
            // If already editing a row, cancel it first
            if (editingRow) {
                cancelEdit(editingRow.find('.btn-cancel'));
            }

            var tr = $(button).closest('tr');
            var cells = tr.find('td');
            var isDummy = tr.data('is-dummy') === true || tr.data('is-dummy') === 'true';

            // Store original values and flags
            var originalValues = [];
            for (var i = 0; i < cells.length - 1; i++) {
                originalValues.push($(cells[i]).text());
            }
            tr.data('original', originalValues);
            tr.data('is-dummy', isDummy);

            // Convert cells to input fields (except last column - actions)
            for (var i = 0; i < cells.length - 1; i++) {
                var cell = $(cells[i]);
                var value = cell.text().trim();
                var header = $('#filtertableallveh thead th').eq(i).text().trim();

                if (i == 0) { // Service ID - readonly
                    var input = $('<input>')
                        .attr('type', 'text')
                        .addClass('form-control input-sm')
                        .val(value)
                        .prop('readonly', true);
                } else {
                    var input = $('<input>')
                        .addClass('form-control input-sm');

                    // Set input type based on column
                    if (header === 'Date') {
                        input.attr('type', 'date')
                            .attr('max', today)
                            .attr('readonly', true) // Date should not be editable
                            .val(value);
                    } else if (header === 'Min Temp' || header === 'Max Temp' || header === 'Avg Temp') {
                        input.attr('type', 'number')
                            .attr('step', 'any')
                            .attr('min', '-100')
                            .attr('max', '200')
                            .attr('onkeypress', 'return validateNumber(event)')
                            .val(value === '0.00000000' ? '' : value) // Clear zero values for better UX
                            .attr('placeholder', 'Enter temperature');
                    } else {
                        input.attr('type', 'text');
                        input.val(value);
                    }
                }
                cell.html(input).addClass('edit-mode');
            }

            // Replace action buttons with Update and Cancel
            var actionCell = $(cells[cells.length - 1]);
            actionCell.html(
                '<button class="btn btn-success btn-xs btn-update" onclick="validateAndUpdate(this)">' +
                '<i class="fa fa-save"></i> Save</button> ' +
                '<button class="btn btn-default btn-xs btn-cancel" onclick="cancelEdit(this)">' +
                '<i class="fa fa-times"></i> Cancel</button>'
            );

            editingRow = tr;
        }

        // Function to validate number input
        function validateNumber(event) {
            var charCode = (event.which) ? event.which : event.keyCode;

            // Allow: backspace, delete, tab, escape, enter, decimal point, minus sign
            if (charCode == 8 || charCode == 9 || charCode == 13 || charCode == 27 ||
                charCode == 46 || charCode == 45 || charCode == 190 || charCode == 110) {
                return true;
            }

            // Allow: Ctrl+A, Ctrl+C, Ctrl+V, Ctrl+X
            if (event.ctrlKey === true && (charCode == 65 || charCode == 67 || charCode == 86 || charCode == 88)) {
                return true;
            }

            // Ensure that it is a number and stop the keypress if not
            if ((charCode < 48 || charCode > 57) && charCode != 45 && charCode != 46) {
                event.preventDefault();
                swal({
                    type: 'warning',
                    title: 'Invalid Input',
                    text: 'Only numbers, decimal points, and minus sign are allowed',
                    timer: 1500,
                    showConfirmButton: false
                });
                return false;
            }

            return true;
        }

        // Add CSS for error border
        $('<style>')
            .prop('type', 'text/css')
            .html('\
        .error-border {\
            border: 2px solid #e74c3c !important;\
            background-color: #fff5f5 !important;\
        }\
        .error-border:focus {\
            outline: none !important;\
            box-shadow: 0 0 5px #e74c3c !important;\
        }\
    ')
            .appendTo('head');

        function validateAndUpdate(button) {
            var tr = $(button).closest('tr');
            var cells = tr.find('td');
            var headers = [];
            var isValid = true;
            var firstInvalidField = null;
            var hasValue = false;

            $('#filtertableallveh thead th').each(function () {
                var headerText = $(this).text().trim();
                if (headerText !== 'Actions') {
                    headers.push(headerText);
                }
            });

            // Validate each field
            for (var i = 0; i < cells.length - 1; i++) {
                var input = $(cells[i]).find('input');
                var value = input.val().trim();
                var header = headers[i];

                // Skip validation for Service ID (readonly) and Date (readonly)
                if (header === 'Service ID' || header === 'Date') {
                    continue;
                }

                // Check if temperature fields are empty
                if (header === 'Min Temp' || header === 'Max Temp' || header === 'Avg Temp') {
                    if (value === '') {
                        isValid = false;
                        firstInvalidField = firstInvalidField || header;
                        input.addClass('error-border');

                        swal({
                            type: 'warning',
                            title: 'Required Field',
                            text: header + ' cannot be empty',
                            timer: 1500,
                            showConfirmButton: false
                        });
                        break;
                    }

                    // Validate numeric value
                    var num = Number(value);
                    if (isNaN(num)) {
                        isValid = false;
                        firstInvalidField = firstInvalidField || header;
                        input.addClass('error-border');

                        swal({
                            type: 'error',
                            title: 'Invalid Number',
                            text: header + ' must be a valid number',
                            timer: 1500,
                            showConfirmButton: false
                        });
                        break;
                    }

                    hasValue = true;
                    input.removeClass('error-border');
                }
            }

            if (isValid && hasValue) {
                updateRow(button);
            } else if (isValid && !hasValue) {
                swal({
                    type: 'warning',
                    title: 'No Data',
                    text: 'Please enter at least one temperature value'
                });
            }
        }

        function updateRow(button) {
            var tr = $(button).closest('tr');
            var id = tr.data('id');
            var sys_service_id = tr.data('sys-service-id');
            var date = tr.data('date');
            var isDummy = tr.data('is-dummy');
            var cells = tr.find('td');

            // Collect updated data
            var updatedData = {
                id: id,
                sys_service_id: sys_service_id,
                temp_date: date,
                action: 'update'
            };

            // Get column names from table headers
            var headers = [];
            $('#filtertableallveh thead th').each(function () {
                var headerText = $(this).text().trim();
                if (headerText !== 'Actions') {
                    headers.push(headerText);
                }
            });

            // Get values from input fields
            for (var i = 0; i < cells.length - 1; i++) {
                var input = $(cells[i]).find('input');
                var columnName = mapColumnName(headers[i]);
                var value = input.val();

                // Format temperature values to 8 decimal places
                if (headers[i] === 'Min Temp' || headers[i] === 'Max Temp' || headers[i] === 'Avg Temp') {
                    if (value && !isNaN(value)) {
                        value = parseFloat(value).toFixed(8);
                    }
                }

                updatedData[columnName] = value;
            }

            // Show loading message
            swal({
                title: 'Saving...',
                text: 'Please wait while we save the record',
                type: 'info',
                showConfirmButton: false,
                allowOutsideClick: false
            });

            // Send update request
            $.ajax({
                url: '',
                type: 'POST',
                data: updatedData,
                dataType: 'json',
                success: function (response) {
                    if (response.success) {
                        // Update row data attributes
                        tr.data('is-dummy', false);

                        // Restore normal view with updated values
                        restoreRowView(tr, updatedData);

                        swal({
                            type: 'success',
                            title: 'Success!',
                            text: response.message,
                            timer: 2000,
                            showConfirmButton: false
                        });
                    } else {
                        swal({
                            type: 'error',
                            title: 'Error!',
                            text: response.message
                        });
                    }
                },
                error: function (xhr, status, error) {
                    swal({
                        type: 'error',
                        title: 'Error!',
                        text: 'Failed to save record: ' + error
                    });
                }
            });
        }

        function mapColumnName(header) {
            var map = {
                'Service ID': 'sys_service_id',
                'Min Temp': 'min_temp',
                'Max Temp': 'max_temp',
                'Avg Temp': 'avg_temp',
                'Date': 'temp_date'
            };
            return map[header] || header.toLowerCase().replace(' ', '_');
        }

        function cancelEdit(button) {
            var tr = $(button).closest('tr');
            var originalValues = tr.data('original');
            var cells = tr.find('td');

            // Restore original values
            for (var i = 0; i < cells.length - 1; i++) {
                $(cells[i]).text(originalValues[i]).removeClass('edit-mode error-border');
            }

            // Restore action buttons based on row type
            var actionCell = $(cells[cells.length - 1]);
            var isDummy = tr.data('is-dummy');
            var editButton = isDummy ?
                '<button class="btn btn-success btn-xs btn-edit" onclick="editRow(this)">' +
                '<i class="fa fa-plus"></i> Add Data</button>' :
                '<button class="btn btn-primary btn-xs btn-edit" onclick="editRow(this)">' +
                '<i class="fa fa-edit"></i> Edit</button>';

            actionCell.html('<div class="action-buttons">' + editButton + '</div>');

            editingRow = null;

            swal({
                type: 'info',
                title: 'Edit Cancelled',
                text: 'No changes were saved',
                timer: 1500,
                showConfirmButton: false
            });
        }

        function restoreRowView(tr, data) {
            var cells = tr.find('td');
            var headers = [];
            $('#filtertableallveh thead th').each(function () {
                var headerText = $(this).text().trim();
                if (headerText !== 'Actions') {
                    headers.push(headerText);
                }
            });

            // Restore cell values
            for (var i = 0; i < cells.length - 1; i++) {
                var columnName = mapColumnName(headers[i]);
                var value = data[columnName] || '';

                // Format temperature display
                if (headers[i] === 'Min Temp' || headers[i] === 'Max Temp' || headers[i] === 'Avg Temp') {
                    if (value && !isNaN(value)) {
                        value = parseFloat(value).toFixed(8);
                    }
                }

                $(cells[i]).text(value).removeClass('edit-mode error-border');
            }

            // Remove dummy row class if it was a dummy row
            tr.removeClass('dummy-row');

            // Restore action buttons
            var actionCell = $(cells[cells.length - 1]);
            actionCell.html(
                '<div class="action-buttons">' +
                '<button class="btn btn-primary btn-xs btn-edit" onclick="editRow(this)">' +
                '<i class="fa fa-edit"></i> Edit</button>' +
                '</div>'
            );

            // Update data attributes
            tr.data('sys-service-id', data.sys_service_id);
            tr.data('date', data.temp_date);
            tr.data('is-dummy', false);

            editingRow = null;
        }
    </script>
</body>

</html>
<?php mysqli_close($conn); ?>