@extends('layouts.usermain')

@section('main-container')
<div class="container-xl my-4">

    <div class="row g-2 align-items-center mb-2">
        <div class="col">
            <h2 class="page-title">Well Monitoring Report</h2>
        </div>
        <div class="col-auto ms-auto d-print-none">
            <div class="btn-list">
                <a href="well_monitorings/export/csv" class="btn btn-primary btn-5">
                    Excel
                </a>  
            </div>
        </div>
    </div>
    

    <div class="card my-3">
        <div class="card-body table-responsive">
            <table id="wellMonitoringTable" class="table table-bordered table-striped">
                <thead>
                    <tr class="bg-info">
                        <th class="bg-primary text-white text-center">Unit</th>
                        <th class="bg-primary text-white text-center">State</th>
                        <th class="bg-primary text-white text-center">District</th>
                        <th class="bg-primary text-white text-center">Block</th>
                        <th class="bg-primary text-white text-center">Panchayat</th>
                        <th class="bg-primary text-white text-center">Village</th>
                        <th class="bg-primary text-white text-center">Year</th>
                        <th class="bg-primary text-white text-center">Code</th>
                        <th class="bg-primary text-white text-center">Beneficiary</th>
                        <th class="bg-primary text-white text-center">Location</th>
                        <th class="bg-primary text-white text-center">Latitude</th>
                        <th class="bg-primary text-white text-center">Longitude</th>
                        <th class="bg-primary text-white text-center">Plot No</th>
                        <th class="bg-primary text-white text-center">Depth of Well</th>
                        <th class="bg-primary text-white text-center">Dia of Well</th>
                        <th class="bg-primary text-white text-center">1st Quarter</th>
                        <th class="bg-primary text-white text-center">2nd Quarter</th>
                        <th class="bg-primary text-white text-center">3rd Quarter</th>
                        <th class="bg-primary text-white text-center">4th Quarter</th>
                        <th class="bg-primary text-white text-center">Average</th>
                        <th class="bg-primary text-white text-center">Status</th>
                        <th class="bg-primary text-white text-center">User</th>
                        <th class="bg-primary text-white text-center">Actions</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse ($wellMonitorings as $well)
                        <tr>
                            <td>{{ $well->unit->name ?? '' }}</td>
                            <td>{{ $well->state->name ?? '' }}</td>
                            <td>{{ $well->district->name ?? '' }}</td>
                            <td>{{ $well->block->name ?? '' }}</td>
                            <td>{{ $well->panchayat->name ?? '' }}</td>
                            <td>{{ $well->village->name ?? '' }}</td>
                            <td>{{ $well->financialYear->name ?? '' }}</td>
                            <td>{{ $well->micro_watershed_code }}</td>
                            <td>{{ $well->name_of_beneficiary }}</td>
                            <td>{{ $well->location }}</td>
                            <td>{{ $well->latitude }}</td>
                            <td>{{ $well->longitude }}</td>
                            <td>{{ $well->plot_no }}</td>
                            <td>{{ $well->depth_of_well }}</td>
                            <td>{{ $well->dia_of_well }}</td>
                            <td>{{ $well->first_quarter }}</td>
                            <td>{{ $well->second_quarter }}</td>
                            <td>{{ $well->third_quarter }}</td>
                            <td>{{ $well->fourth_quarter }}</td>
                            <td class="fw-bold">{{ $well->average }}</td>
                            <td>
                                <span class="badge {{ $well->status == 'Active' ? 'bg-success' : 'bg-danger' }}">
                                    {{ $well->status }}
                                </span>
                            </td>
                            <td>{{ $well->user->name ?? '' }}</td>
                            <td>
                                <a href="{{ route('well_monitorings.edit', $well->id) }}" class="btn btn-sm btn-primary">Edit</a>
                                <form action="{{ route('well_monitorings.destroy', $well->id) }}" method="POST" style="display:inline;">
                                    @csrf
                                    @method('DELETE')
                                    <button class="btn btn-sm btn-danger" onclick="return confirm('Delete this record?')">Delete</button>
                                </form>
                            </td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="23" class="text-center">No data found</td>
                        </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>
</div>

@endsection