@extends('layouts.app')

@section('title', 'Dashboard')

 <style>
        .pagination {
    display: flex;
    list-style: none;
    padding: 0;
    justify-content: center;
}

.pagination li {
    margin: 0 5px;
}

.pagination li a,
.pagination li span {
    padding: 5px 10px;
    border: 1px solid #ccc;
    color: #333;
    text-decoration: none;
}

.pagination li.active a {
    background-color: #007bff;
    color: #fff;
}

.pagination li.disabled span {
    color: #aaa;
    cursor: not-allowed;
}

.pagination li.disabled a {
    pointer-events: none;
}
    </style>
@section('content')
 <div class="container-fluid">

        <!-- Page Heading -->
        <div class="d-sm-flex align-items-center justify-content-between mb-4">
            <h1 class="h3 mb-0 text-gray-800">Report</h1>
        </div>

        {{-- Alert Messages --}}
        @include('common.alert')

        <!-- DataTales Example -->
        <div class="card shadow mb-4">
            <div class="card-header py-3">
                <h6 class="m-0 font-weight-bold text-primary">List</h6>

            </div>
            <div class="card-body">
                <div class="row">
                    <div class="col-lg-4">
                        <button class="btn btn-primary mb-4" onclick="exportTableData()">Export CSV</button>
                    </div>
                    <div class="col-lg-8">
                        <label for="month">Select Date Range:</label>
                        <form action="#" method="GET" onsubmit="return validateDates()">
                            <input type="date" id="start_date" value="{{ isset($_GET['start_date']) ? $_GET['start_date'] : '' }}" name="start_date" placeholder="start date">
                            <input type="date" id="end_date" value="{{ isset($_GET['end_date']) ? $_GET['end_date'] : '' }}" name="end_date" placeholder="end date">
                            <button type="submit" class="btn btn-primary btn-sm" id="filterBtn">Filter</button>
                            <a href="{{ route('report.report') }}" class="btn btn-primary btn-sm">Clear Filters</a>
                        </form>
                    </div>
                </div>

                <div class="table-responsive">
                    <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
                        <thead>
                            <tr>
                                <td>S.No.</td>
                                <td>Farmer ID</td>
                                <td>Farmer Name</td>
                                <td>Village</td>
                                <td>District</td>
                                <td>Mobile</td>
                                <td>Date</td>
                                <td>State</td>
                                <td>Year</td>
                                <td>Crop</td>
                                <td>Cultivator No.</td>
                                <td>Parcel Plot Season (PPS)</td>
                                <td>Crop Area (Ha.)</td>
                                <td>Ha-months in ground (Ha.)</td>
                                <td>Main Product (Qtls.)</td>
                                <td>Main Product (Rs.)</td>
                                <td>By Product (Rs.)</td>
                                <td>Family Labour (Hrs.)</td>
                                <td>Family Labour (Rs.)</td>
                                <td>Attached Labour (Hrs.)</td>
                                <td>Attached Labour (Rs.)</td>
                                <td>Casual Labour (Hrs.)</td>
                                <td>Casual Labour (Rs.)</td>
                                <td>Hired Animal Labour (Hrs.)</td>
                                <td>Hired Animal Labour (Rs.)</td>
                                <td>Owned Animal Labour (Hrs.)</td>
                                <td>Owned Animal Labour (Rs.)</td>
                                <td>Hired Machine (Hrs.)</td>
                                <td>Hired Machine (Rs.)</td>
                                <td>Own Machine (Hrs.)</td>
                                <td>Own Machine (Rs.)</td>
                                <td>Hired Irrigation Machine (Hrs.)</td>
                                <td>Hired Irrigation Machine (Rs.)</td>
                                <td>Owned Irrigation Machine (Hrs.)</td>
                                <td>Owned Irrigation Machine (Rs.)</td>
                                <td>Canal and Other Irrigation Charges (Rs)</td>
                                <td>Seed Qty. (Kg.)</td>
                                <td>Seed Value (Rs.)</td>
                                <td>Fertiliser (N) (Kg.)</td>
                                <td>Fertiliser (N) (Rs.)</td>
                                <td>Fertiliser (P) (Kg.)</td>
                                <td>Fertiliser (P) (Rs.)</td>
                                <td>Fertiliser (K) (Kg.)</td>
                                <td>Fertiliser (K) (Rs.)</td>
                                <td>Other Fertiliser (Kg.)</td>
                                <td>Other Fertiliser (Rs.)</td>
                                <td>Total Fertiliser (Kg.)</td>
                                <td>Total Fertiliser (Rs.)</td>
                                <td>Manure (Qtl.)</td>
                                <td>Manure (Rs.)</td>
                                <td>Insecticides (Rs.)</td>
                                <td>Crop Insurance (Rs.</td>
                                <td>Payment to Contractor (Rs.)</td>
                                <td>Miscelaneous Cost (Rs.)</td>
                                <td>Land Revenue (Rs.)</td>
                                <td>Rent Paid for Leased in Land (Rs.)</td>
                                <td>Imputed Rent (Rs.)</td>
                                <td>Total Depreciation (Rs.)</td>
                                <td>Total Capital (Rs.)</td>
                                <td>Total No. of Growers in size group</td>
                                <td>Sample Number of Growers in size group</td>
                                <td>Cluster Factor/Weight</td>
                                <td>Area of all selected crops in Village (Ha.)</td>
                                <td>No. of Villages in Tehsil</td>
                                <td>Area of Crop in Zone (Ha.)</td>
                                <td>Production of Crop in Zone (Qtl.)</td>
                                <td>No. of Tehsils in Zone</td>
                                <td>Sample Tehsils in Zone</td>
                                <td>Area of all selected crops in Zone (Ha.)</td>
                                <td>Interest on working capital rate(%)</td>
                                <td>Interest on fixed capital rate(%)</td>
                                <td>Minimum Rent (%age of GVO)</td>
                                <td>Maximum Rent (%age of GVO)</td>
                                <td>Sample Zone in State</td>
                                <td>Sample Clusters in State</td>
                                <td>Tenure</td>
                                <td>Seed Variety</td>
                            </tr>
                        </thead>
                        <tbody>