@extends('layout.index')
@section('title', 'Import Farmers List')

<!-- Dashboard Ecommerce start -->
@section('content')
<style>
    .custom-option-btn{
        background: white;
        border: none;
        /* box-shadow: 0 4px 24px 0 rgba(34, 41, 47, 0.1); */
        padding: 5px;
        border-radius: 50%;
    }
</style>
<section>
    <div class="content-header row">
        <div class="content-header-left col-md-8 col-12 mb-2">
            <div class="row breadcrumbs-top">
                <div class="col-12 d-flex">
                    <h2 class="content-header-title float-start mb-0">Register Farmer List</h2>
                </div>
            </div>
        </div>
       
    </div>       
</section>
<section>
    @if ($message = Session::get('success'))
        <div class="demo-spacing-0 mb-1">
            <div class="alert alert-success alert-dismissible fade show" role="alert">
                <div class="alert-body">
                    <i class="fa fa-check-circle" style="font-size:16px;" aria-hidden="true"></i>
                    {{ $message }}
                    <button type="button" class="close" data-dismiss="alert" aria-label="Close">

                </div>
                <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                    <span aria-hidden="true">&times;</span>
                </button>
            </div>
        </div>
    @elseif ($message = Session::get('error'))
        <div class="demo-spacing-0 mb-1">
            <div class="alert alert-danger alert-dismissible fade show" role="alert">
                <div class="alert-body">
                    <i class="fa fa-exclamation-triangle" aria-hidden="true"></i>
                    {{ $message }}
                    <button type="button" class="close" data-dismiss="alert" aria-label="Close">

                </div>
                <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                    <span aria-hidden="true">&times;</span>
                </button>
            </div>
        </div>
    @endif

    <div class="content-body">
        <!-- Bordered table start -->
        <div class="row" id="table-bordered">
            <div class="col-12">
                <div class="card ">
                    <form class="dt_adv_search" action="" method="POST">
                        {{ csrf_field() }}
                        <input type="hidden" name="form_type" value="search_all_farmer">
                        <input type="hidden" name="country_id" id="country_id" value="{{ $country_id }}">

                        <div class="card-header w-100 m-0">
                            <div class="row w-150">
                                <div class="col-sm-12">
                                    <div class="row">
                                        <div class="col-md-2 col-12">   
                                            <div class="form-group">
                                                <label class="form-label" for="validationTooltip01"> Season </label>
                                                <select class=" form-control form-select select2 " id="season"  name='season'>
                                                                                
                                                </select>                

                                            </div>
                                        </div>
                                       
                                        <div class="col-md-2 col-12">   
                                            <div class="form-group">
                                                <label class="form-label" for="validationTooltip01"> Brand Name </label>
                                                <select class=" form-control form-select  " id="brand_id"  name='brand_name'>
                                                    <option value=''> Select Brand </option>
                                                    
                                                                                
                                                </select>
                                                
                                            </div>
                                        </div>
                                        
                                        <div class="col-md-2 col-12">   
                                            <div class="form-group">
                                                <label class="form-label" for="validationTooltip01"> Program Name </label>
                                                <select class=" form-control form-select " id="program_id"  name='program_name'>
                                                    <option value=''> Select Program </option>
                                                    
                                                    
                                                </select>
                                                
                                            </div>
                                        </div>

                                        <div class="col-md-2 col-12">   
                                            <div class="form-group">
                                                <label class="form-label" for="validationTooltip01"> State Name </label>
                                                <select class=" form-control form-select " id="state_id"  name='state_name' onclick="get_district()">
                                                    <option value='0'>Select State</option>

                                                                                
                                                </select>
                                                
                                            </div>
                                        </div>

                                        <div class="col-md-2 col-12">   
                                            <div class="form-group">
                                                <label class="form-label" for="validationTooltip01"> District Name </label>
                                                <select class=" form-control form-select " id="district_id"  name='district_name' >
                                                    <option value='0'>Select District</option>
                        
                                                                                
                                                </select>
                                                
                                            </div>
                                        </div>

                                        <div class="col-md-2 col-12">   
                                           
                                            <div class="form-group">
                                                <label class="form-label" for="validationTooltip01">Farmer Type</label>
                                                <select class=" form-control form-select " id="farmer_type"  name='farmer_type' >
                                                    <option value=''>Select Farmer Type</option>
                                                    
                                                                                                    </select>
                                                
                                            </div>
                                        </div>
                                        <div class="col-sm-2  ">
                                            <label class="form-label" for="validationTooltip01"> Farmer Code:
                                            </label><br>
                                            <input type="text" id="farmer_code" class="form-control" placeholder="Farmer Code"
                                                name="farmer_code" value="{{ $search_farmer_code }}" autocomplete="off" />
                                        </div>
                                        <div class="col-md-10 col-12 " >   
                                            <div class="form-group mt-2">
												<button type="submit" class="btn btn-primary">Search</button>
                                                <div id="clear_btn" class="float-xl-right" style="margin-right: 210px ">

                                                </div>

                                                @if (!empty($search_name_state )|| !empty($search_name_district) || !empty($farmer_type) || !empty($selected_brand_name)|| !empty($selected_program_name) || !empty($search_farmer_code))
                                                    <a title="Clear" href="{{ url('all_farmers/clear_search_all_farmer/'.$country_id ) }}" type="button"
                                                        class="btn btn-outline-primary ">
                                                        <i data-feather="rotate-ccw" class="me-25"></i> Clear Search
                                                    </a>
                                                @endif

                                                <div class="form-group pull-right">
                                                    <button type="button" id="uplodebtn" class="btn btn-primary"
                                                            onclick="export_all_farmers()">Export Data</button>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </form>
                    <div class="table-responsive">
                       
                        <table class="table table-striped table-bordered table_content" id="farmers_table">
                            <thead><tr> <th class="text-center">Sr. No</th>
                                <th class="text-left">Farmer Code</th>
                                <th class="text-left">Brand Name-Program Name</th>
                                <th class="text-left">State Name</th>
                                <th class="text-left">District Name</th>
                                <th class="text-left">Block Name</th>
                                <th class="text-left">Village Name</th>
                                <th class="text-left">Name</th>
                                <th class="text-left">Farmer Type</th>
                                <th class="text-left">Agriculture Irrigated</th>
                                <th class="text-left">Agriculture Flood Irrigated</th>
                                <th class="text-left">Agriculture Drip Sprinkler Irrigated</th>
                                <th class="text-left">Is Land Taken on Lease</th>
                                <th class="text-left">Agriculture Land Taken on Lease</th>
                                <th class="text-left">Is Land Given on Lease</th>
                                <th class="text-left">Agriculture Land Given on Lease</th>
                                <th class="text-left">Agriculture Rainfed</th>
                                <th class="text-left">Cotton Irrigated</th>
                                <th class="text-left">Cotton Flood Irrigated</th>
                                <th class="text-left">Cotton Drip Sprinkler Irrigated</th>
                                <th class="text-left">Is CottonLand Taken on Lease</th>
                                <th class="text-left">Cotton Land Taken on Lease Rainfed</th>
                                <th class="text-left">Cotton Land Taken on Lease Irrigated</th>
                                <th class="text-left">Is Cotton Land Given on Lease</th>
                                <th class="text-left">Cotton Land Given on Lease</th>
                                <th class="text-left">Cotton Rainfed</th>
                                <th class="text-left">Source of Irrigation</th>
                                <th class="text-left">Source of Irrigation Other</th>
                                {{-- <th class="text-left">Action</th> --}}
                            </tr>
                        </thead>
						<tbody>
												<tr>
						<td colspan="13" style="text-align:center; color:red;">No Record Found</td>
					</tr>
											</tbody>
                        </table>
                    </div> 
					<div class="card-body">
						<div class="d-flex justify-content-end">
							{{ $Paginator }}
						</div>
					</div>
                </div>

            </div>
        </div>
        <!-- Bordered table end -->
    </div>
    <div id='loader_outer'>
        <div id='loader' ></div>
    </div>
    <script>
        function export_all_farmers()
        {
            
            var season = $('#season').val();
            var country = $('#country_id').val();
            var brand = $('#brand_id').val();
            var program = $('#program_id').val();
            var state = $('#state_id').val();
            var district = $('#district_id').val();
            var farmer_type = $('#farmer_type').val();
            var farmer_code = $('#farmer_code').val() ;
            var url="