@extends('layouts.main')

@section('main-container')
<div class="container-xl">
    <div class="page-header d-print-none">
        <div class="row align-items-center">
            <div class="col">
                <h2 class="page-title">
                    Add Rainfall Data
                </h2>
            </div>
        </div>
    </div>
@if (session('success'))
    <div class="alert alert-success alert-dismissible fade show">
        {{ session('success') }}
    </div>
@endif
@if ($errors->any())
    <div class="alert alert-danger">
        <ul class="mb-0">
            @foreach ($errors->all() as $error)
                <li>{{ $error }}</li>
            @endforeach
        </ul>
    </div>
@endif
    <div class="card">
        <div class="card-body">
            <form method="POST" action="{{ route('watershed.rainfalls.store') }}">
                @csrf
                <div class="row row-cards">

                    {{-- State --}}
                    <div class="col-md-4">
                        <label class="form-label">State</label>
                        <select name="state_id" id="state_id" class="form-select" required>
                            <option value="">Select State</option>
                            @foreach($states as $state)
                                <option value="{{ $state->id }}">{{ $state->name }}</option>
                            @endforeach
                        </select>
                    </div>

                    {{-- District --}}
                    <div class="col-md-4">
                        <label class="form-label">District</label>
                        <select name="district_id" id="district_id" class="form-select" required>
                            <option value="">-- Select District --</option>
                        </select>
                    </div>

                    {{-- Block --}}
                    <div class="col-md-4">
                        <label class="form-label">Block</label>
                        <select name="block_id" id="block_id" class="form-select" required>
                                <option value="">-- Select Block --</option>
                            </select>
                    </div>

                    {{-- Year-wise Rainfall Table --}}
                    <div class="col-12 mt-3">
                        <label class="form-label">Year-wise Rainfall</label>

                        <div class="table-responsive">
                            <table class="table table-bordered" id="rainfallTable">
    <thead class="text-center">
        <tr >
            <th style="width:80px" class="bg-primary text-white">SL#</th>
            <th  class="bg-primary  text-white">Year</th>
            <th  class="bg-primary  text-white">Rainfall (mm)</th>
            <th style="width:80px"  class="bg-primary text-white">Action</th>
        </tr>
    </thead>
    <tbody id="rainfallBody">
    <tr>
        <td class="sl text-center">1</td>

        <td>
            <select name="year_id[]" class="form-control" required>
                <option value="">-- Select Year --</option>
                @foreach ($years as $year)
                    <option value="{{ $year->id }}">{{ $year->name }}</option>
                @endforeach
            </select>
        </td>

        <td>
            <input type="number"
                   name="rainfall_mm[]"
                   class="form-control"
                   step="0.01"
                   min="0"
                   placeholder="1200.50"
                   required>
        </td>

        <td class="text-center">
            <button type="button" class="btn btn-danger btn-sm removeRow">
                ✕
            </button>
        </td>
    </tr>
</tbody>

</table>

                        </div>

                        <button type="button" class="btn btn-outline-primary btn-sm mt-2" id="addRow">
                            + Add More
                        </button>

                        {{-- Hidden JSON field --}}
                        <input type="hidden" name="sl_year_rainfall_mm" id="rainfallJson">
                    </div>

                    {{-- Average --}}
                    <div class="col-md-6 mt-3">
                        <label class="form-label">Average Rainfall (Last 10 Years)</label>
                        <input type="number"
                               step="0.01"
                               name="average_last_10_years"
                                 id="averageRainfall"
                               class="form-control"
                               placeholder="e.g. 1150.75">
                    </div>

                    {{-- Data Source --}}
                    <div class="col-md-6 mt-3">
                        <label class="form-label">Data Source</label>
                        <input type="text" name="data_source" class="form-control" placeholder="IMD / State Dept">
                    </div>

                    {{-- Submit --}}
                    <div class="col-12 mt-4">
                        <div class="d-flex justify-content-end">
                            <button type="submit" class="btn btn-primary">
                                Save Rainfall Data
                            </button>
                        </div>
                    </div>

                </div>
            </form>
        </div>
    </div>
</div>
@endsection



<script>
document.addEventListener('DOMContentLoaded', function () {
    const tableBody = document.querySelector('#rainfallTable tbody');
    const addRowBtn = document.getElementById('addRow');

    // store year dropdown HTML from first row
    const yearSelectHTML = tableBody.querySelector('select[name="year_id[]"]').outerHTML;

    function updateSL() {
        document.querySelectorAll('.sl').forEach((td, index) => {
            td.innerText = index + 1;
        });
    }

    addRowBtn.addEventListener('click', function () {
        const row = document.createElement('tr');
        row.innerHTML = `
            <td class="sl"></td>
            <td>${yearSelectHTML}</td>
            <td>
                <input type="number"
                       name="rainfall_mm[]"
                       class="form-control"
                       step="0.01"
                       required>
            </td>
            <td class="text-center">
                <button type="button" class="btn btn-danger btn-sm removeRow">✕</button>
            </td>
        `;
        tableBody.appendChild(row);
        updateSL();
    });

    tableBody.addEventListener('click', function (e) {
        if (e.target.classList.contains('removeRow')) {
            e.target.closest('tr').remove();
            updateSL();
        }
    });

    // Build JSON before submit
    document.querySelector('form').addEventListener('submit', function () {
        const years = document.getElementsByName('year_id[]');
        const rainfalls = document.getElementsByName('rainfall_mm[]');
        let data = {};

        for (let i = 0; i < years.length; i++) {
            if (years[i].value && rainfalls[i].value) {
                data[years[i].value] = rainfalls[i].value;
            }
        }

        document.getElementById('rainfallJson').value = JSON.stringify(data);
    });
});
</script>

<script>
document.addEventListener('DOMContentLoaded', function () {

    function calculateAverage() {
        const rainfallInputs = document.getElementsByName('rainfall_mm[]');
        let sum = 0;
        let count = 0;

        rainfallInputs.forEach(input => {
            if (input.value !== '') {
                sum += parseFloat(input.value);
                count++;
            }
        });

        const avgField = document.getElementById('averageRainfall');
        avgField.value = count > 0 ? (sum / count).toFixed(2) : '';
    }

    // calculate on typing
    document.addEventListener('input', function (e) {
        if (e.target.name === 'rainfall_mm[]') {
            calculateAverage();
        }
    });

    // recalc after row delete
    document.addEventListener('click', function (e) {
        if (e.target.classList.contains('removeRow')) {
            setTimeout(calculateAverage, 100);
        }
    });

});
</script>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script>
    $(document).ready(function() {
        $('#state_id').change(function() {
            var stateId = $(this).val();
            
            if (stateId) {
                $.ajax({
                    url: '/geo/get-districts/' + stateId,
                    type: 'GET',
                    dataType: 'json',
                    success: function(data) {
                        $('#district_id').empty().append('<option value="">--Select District--</option>');
                        $.each(data, function(key, district) {
                            $('#district_id').append('<option value="'+ district.id +'">'+ district.name +'</option>');
                        });
                    },
                    error: function(xhr, status, error) {
                        console.log("AJAX Error:", error);
                    }
                });
            } else {
                $('#district_id').empty().append('<option value="">--Select District--</option>');
            }
        });
    });
</script>

<script>
    $(document).ready(function() {
        $('#district_id').change(function() {
            var districtId = $(this).val();

            if (districtId) {
                $.ajax({
                    url: '/geo/get-blocks/' + districtId,
                    type: 'GET',
                    dataType: 'json',
                    success: function(data) {
                        $('#block_id').empty().append('<option value="">--Select Block--</option>');
                        
                        $.each(data, function(key, block) {
                            // Capitalize first letter of each word
                            var formattedName = block.name
                                .toLowerCase()
                                .split(' ')
                                .map(function(word) {
                                    return word.charAt(0).toUpperCase() + word.slice(1);
                                })
                                .join(' ');

                            $('#block_id').append('<option value="' + block.id + '">' + formattedName + '</option>');
                        });
                    },
                    error: function(xhr, status, error) {
                        console.error("AJAX Error:", error);
                        alert("Failed to fetch blocks. Please try again.");
                    }
                });
            } else {
                $('#block_id').empty().append('<option value="">--Select Block--</option>');
            }
        });
    });
</script>