@extends('admin.admin_dashboard')
@section('admin')

<div class="page-content">
    <div class="container-fluid">

        <!-- Messages -->
        @if(session('success'))
            <div class="alert alert-success">{{ session('success') }}</div>
        @endif
        @if(session('error'))
            <div class="alert alert-danger">{{ session('error') }}</div>
        @endif

        <div class="card shadow-sm rounded">
            <div class="card-header" style="background-color:#6F4E37; color:white;">
                <h4 class="mb-0">Merge Duplicate Farmers</h4>
            </div>

            <div class="card-body">
                <form action="{{ route('farmers.merge.process') }}" method="POST">
                    @csrf
                    <div class="table-responsive">
                        <table id="example" class="table table-striped table-hover align-middle">
                            <thead class="table-dark">
                                <tr>
                                    <th>Select</th>
                                    <th>Main</th>
                                    <th>Farmer Code</th>
                                    <th>Name</th>
                                    <th>Village</th>
                                    <th>Ledger</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach($farmers as $farmer)
                                    <tr>
                                        <td>
                                            <input type="checkbox" name="farmers[]" value="{{ $farmer->id_farmer }}">
                                        </td>
                                        <td>
                                            <input type="radio" name="main_farmer" value="{{ $farmer->id_farmer }}">
                                        </td>
                                        <td><b>{{ $farmer->farmer_number }}</b></td>
                                        <td><b>{{ $farmer->farmer_fname }} {{ $farmer->farmer_lname }}</b></td>
                                        <td><b>{{ $farmer->farmer_village }}</b></td>
                                        <td>{{ $farmer->account_name ?? '-' }}</td>

                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>

                    <button type="submit" class="btn btn-success mt-3">
                        ✅ Merge Selected Farmers
                    </button>
                </form>
            </div>
        </div>
    </div>
</div>

<!-- DataTables scripts -->
<link rel="stylesheet" href="https://cdn.datatables.net/1.13.6/css/dataTables.bootstrap5.min.css">
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script src="https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/1.13.6/js/dataTables.bootstrap5.min.js"></script>

<script>
    $(document).ready(function () {
        $('#example').DataTable({
            pageLength: 10,
            lengthMenu: [5, 10, 20, 50],
            ordering: true,
            searching: true
        });
    });
</script>

@endsection