@extends('layout.index')
@section('title', 'Farmer Anomaly Data')

<!-- Dashboard Ecommerce start -->
@section('content')
<style>
    th {
        background-color: #0f265c !important;
        color: white !important;
    }
</style>
<section> 
    <div class="content-header row">
        <div class="content-header-left col-md-6 col-12 mb-2">
            <div class="row breadcrumbs-top">
                <div class="col-12 d-flex">
                    <h2 class="content-header-title float-start mb-0 ml-2">Farmer Anomaly Data</h2>
                    
                </div>
            </div>
        </div>
        <div class="col-md-6 col-12">
            <button type="button" class="btn btn-danger pull-right mr-2"
                    onclick="window.location.href='{{ url('anomaly_dashboard') }}'">
                ← Back
            </button>
        </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="alert alert-success p-1" id="success-alert" style="display: none;">
            <i class="fa fa-check-circle" style="font-size:16px;" aria-hidden="true"></i>
            <span id="success-message"></span>
        </div>
        
        <div class="alert alert-danger p-1" id="error-alert" style="display: none;">
            <i class="fa fa-exclamation-triangle" style="font-size:16px;" aria-hidden="true"></i>
            <span id="error-message"></span>
        </div>

        
        <div class="content-body">
            <div class="col-sm-12">
            <form class="form" id="" action="" method="POST">
				<input type="hidden" name="form_type" value="view_fe_farmer">
								    @csrf
                    <div class="card mb-1" style="border-radius:15px;">
                        <div class="card-body" style="padding: 0.5rem 0.5rem">
                            <div class="row justify-content-between mx-1">
                                <div class="col-sm-2" style="min-width: 140px;">
                                    <div class="form-group mb-0">
                                        <lable class="text-primary"> Programmes</label>
                                        <select class="text-primary form-control form-select program_filter" id="chart_program_id" name='program' onchange="get_brands_filters(); get_pg();">
                                           
                                                                                    </select>
                                       
                                    </div>
                                </div>
                                
                                <div class="col-sm-2" style="min-width: 140px; ">
                                    <div class="form-group mb-0">
                                        <lable class="text-primary"> Brands</label>
                                        <select class="text-primary form-control form-select brand_filter" id="chart_brand_id" name='brand' onchange="get_season_filters(); get_pg();">
                                                                                    </select>
                                        <h5><small class="text-danger" id="chart_brand_err"></small></h5>
                                    </div> 
                                </div>
                               
                                <div class="col-sm-2" style="min-width: 140px;">
                                    <div class="form-group mb-0">
                                        <lable class="text-primary"> Seasons <span style="color:red;">*</span></label>
                                        <select class="text-primary form-control form-select season_filter" id="chart_season" name='season' onchange="get_country_filters(); get_pg();">
                                                                                    </select>
                                        <small class="text-danger" id="chart_season_err"></small>
                                    </div>
                                </div>

                                <div class="col-sm-2" style="min-width: 140px;">
                                    <div class="form-group mb-0">
                                        <lable class="text-primary"> Countries <span style="color:red;">*</span></label> 
                                        
                                        <select class="text-primary form-control form-select country_filter" id="chart_country" name='country' onchange="get_state_filters(); get_pg();">
                                            <option value='0'>All Country</option>
                                                                                    </select>
                                        <small class="text-danger" id="chart_country_err"></small> 
                                    </div>
                                </div>

                                <div class="col-sm-2" style="min-width: 140px;">
                                    <div class="form-group mb-0">
                                        <lable class="text-primary"> States</label>
                                            
                                        <select class="text-primary form-control form-select state_filter" id="chart_state" name='state' onchange="get_district_filters(); get_pg();">
                                            <option value='0'>All States</option>
                                                                                    </select>
                                        <small class="text-danger" id="chart_state_err"></small>
                                    </div>
                                </div>

                                <div class="col-sm-2" style="min-width: 140px;">
                                    <div class="form-group mb-0">
                                        <lable class="text-primary"> Districts</label>
                                        <select class="text-primary form-control form-select district_filter" id="chart_district" name='district' onchange="get_FE();get_block_filters();">
                                            <option value='0'>All Districts</option>
                                                                                    </select>
                                        <small class="text-danger" id="chart_district_err"></small> 
                                    </div>
                                </div>

                                <div class="col-sm-2" style="min-width: 140px;">
                                    <div class="form-group mb-0">
                                        <lable class="text-primary"> PG</label>
                                        <select class="text-primary form-control form-select pg_filter" id="pgCode" name='pgCode'>
                                            <option value='0'>All PG</option>
                                        </select>
                                        <small class="text-danger" id="pgCode_err"></small> 
                                    </div>
                                </div>

                                <div class="col-sm-2" style="min-width: 140px;">
                                    <div class="form-group mb-0">
                                        <lable class="text-primary"> Blocks</label>
                                        <select class="text-primary form-control form-select block_filter" id="chart_block" name='block'>
                                            <option value='0'>All Block</option>
                                        </select>
                                        <small class="text-danger" id="chart_block_err"></small> 
                                    </div>
                                </div>

                                <div class="col-sm-2" style="min-width: 140px;">
                                    <div class="form-group mb-0">
                                        <lable class="text-primary"> Farmer Type</label>
                                        <select class="text-primary form-control form-select farmerType_filter" id="farmerType" name='farmerType'>
                                            <option value="">All Farmers</option>
                                            <option value="project" {{$farmerType=='project' ? 'selected' : ''}}>Project</option>
                                            <option value="control" {{$farmerType=='control' ? 'selected' : ''}}>Control</option>
                                        </select>
                                        <small class="text-danger" id="farmerType_err"></small> 
                                    </div>
                                </div>

                                <div class="col-sm-2" style="min-width: 140px;">
                                    <div class="form-group mb-0">
                                        <lable class="text-primary"> Field Executive</label>
                                        <select class="text-primary form-control form-select select2" id="chart_FE" name='fieldExecutive'>
                                            <option value='0'>Select All</option>
                                        </select>
                                    </div>
                                </div>

                                <div class="col-sm-2" style="min-width: 140px;">
                                    <div class="form-group mb-0">
                                        <label class="text-primary"> Anomaly Type</label>
                                        <select class="text-primary form-control form-select" id="anomalyType" name='anomalyType' onchange="anomaly_type_changed();">
                                            <option value='0'>Select Anomaly</option>
                                                                                    </select>
                                    </div>
                                </div>
                                
                                <div class="col-sm-2" style="min-width: 140px;display:none;" id="fertilizerTypeDiv">
                                    <div class="form-group mb-0">
                                        <label class="text-primary"> Fertilizer Type</label>
                                        <select class="text-primary form-control form-select select2" id="fertilizerType" name='fertilizerType'>
                                            <option value='0'>Select Fertilizer</option>
                                                                                    </select>
                                    </div>
                                </div>

                                <div class="col-sm-2" style="min-width: 140px;display:none;" id="pesticideTypeDiv">
                                    <div class="form-group mb-0">
                                        <label class="text-primary"> Pesticide Type</label>
                                        <select class="text-primary form-control form-select select2" id="pesticideType" name='pesticideType'>
                                            <option value='0'>Select Pesticide</option>
                                                                                    </select>
                                    </div>
                                </div>

                                <div class="col-sm-2" style="min-width: 140px;display:none;" id="extraDiv">
                                </div>
                            
                                <div id='loader_outer'>
                                    <div id='loader'></div>
                                </div>
                                
                                <div class="col-sm-4" style="min-width: 140px;">
                                    <div class="form-group mb-0">
                                        <label>&nbsp;</label>
                                        <div class="d-flex flex-wrap gap-2">
                                           
                                            <button type="submit" 
                                                    name="button" 
                                                    value="Search" 
                                                    class="btn btn-primary flex-fill mb-1 mr-1">
                                                <i class="fa fa-search"></i> Search
                                            </button>

                                            @if(!empty($stateId) || !empty($districtId) || !empty($brandId) || !empty($programId))
                                                <a title="Clear" 
                                                href="{{ url('show_anomaly_chart/clear_search') }}" 
                                                class="btn btn-outline-primary flex-fill mb-1 mr-1">
                                                    <i data-feather="rotate-ccw" class="me-25"></i> Clear
                                                </a>
                                            @endif

                                            <button type="button" 
                                                    id="exportSeasonFarmer" 
                                                    class="btn btn-primary flex-fill mb-1"
                                                    onclick="return export_anomaly_list();" 
                                                    name="button" 
                                                    value="exportSeasonFarmer">
                                                Export
                                            </button>
                                        </div>
                                    </div>
                                </div>

                                <div class="col-sm-8 text-right">
                                    <button type="button" class="btn btn-primary flex-fill mb-1 mt-2" onclick="export_anomaly_list_all();" name="button">Export All Data</button>
                                    <!-- <a href="javascript:void(0);" onclick="export_anomaly_list_all()">Export All Data</a> -->
                                </div>
                                {{-- <div class="col-md-1">
                                    10
                                </div> --}}
                                
                                {{-- <div class="col-md-1">
                                    10
                                </div> --}}
                            </div>
                        </div>
                    </div>
                
                </form>
            </div>
            <div class="row" style="margin: 0.4rem 0.4rem">
                <div class="col-12">
                    <div class="card " id="custom_anomaly_table">
						
                        <div>
                            @if (!empty($feFarmer) && count($feFarmer) > 0)
                          
                            <table class="table table-bordered table-responsive w-100">
                                <thead>
                                    <tr>
                                        <th>Sr.No.</th>
                                        <th>Farmer Code</th>
                                        <th>Farmer Name</th>
                                        <th>Farmer Type</th>
                                        <th>Producer Group</th>
                                        <th>Cotton Land</th>
                                        <th>Country</th>
                                        <th>State</th>
                                        <th>District</th>
                                        <th>Block</th>
                                        <th>Village</th>
                                        <th>Field Executive</th>
                                        
                                        @php
                                            // Normalize to lowercase for safe comparison
                                            $type = strtolower(trim($anomalyType));

                                            // All datasets mapped by lowercase keys
                                            $dataMap = [
                                                'input cost' => $inputCostData ?? [],
                                                'water use' => $waterUseData ?? [],
                                                'profit' => $profitData ?? [],
                                                'cotton picking vs estimated quantity' =>$cottonPickingVsEstimatedData ??[],
                                            ];
                                        @endphp

                                        @if (!in_array($type, ['input cost', 'water use', 'profit','cotton picking vs estimated quantity']))
                                            <th style="width: 50%;">{{ ucfirst($anomalyType) }} Anomaly</th>
                                        @else
                                    
                                            @php
                                                $sampleData = current($dataMap[$type] ?? []);
                                                $firstFarmer = !empty($sampleData) ? current($sampleData) : [];
                                            
                                            @endphp

                                            @if (!empty($firstFarmer) && isset($firstFarmer))
                                                @foreach (array_keys($firstFarmer) as $col)
                                                    <th style="width: 20%;">{{ $col }}</th>
                                                @endforeach
                                            @endif
                                        @endif
                                    </tr>
                                </thead>

                                <tbody>
                                    @foreach ($feFarmer as $row)
                                                                                <tr>
                                            <td>{{ $count }}</td>
                                            <td>{{ $row->code ?? '-' }}</td>
                                            <td>{{ $row->name ?? '-' }}</td>
                                            <td>{{ $row->farmer_type ?? '-' }}</td>
                                            <td>{{ $row->pgName ?? '-' }} {{ $row->pgCode ? ($row->pgCode) : '-' }}</td>
                                            <td>{{ $row->cottonArea ?? '-' }}</td>
                                                                                        <td>{{ $row->country ?? '-' }}</td>
                                            <td>{{ $row->state ?? '-' }}</td>
                                            <td>{{ $row->district ?? '-' }}</td>
                                            <td>{{ $row->block ?? '-' }}</td>
                                            <td>{{ $row->village ?? '-' }}</td>
                                            <td>{{ (!empty($aFE[$row->fe_sync])) ? $aFE[$row->fe_sync] : '-' }}</td>
                                            @php
                                                // Map again in lowercase for per-row lookup
                                                $dataMap = [
                                                    'fertilizer' => $fertilizerData ?? [],
                                                    'pesticide' => $pesticideData ?? [],
                                                    'pest management' => $PesticideManagementData ?? [],
                                                    'input cost' => $inputCostData ?? [],
                                                    'water use' => $waterUseData ?? [],
                                                    'profit' => $profitData ?? [],
                                                    'cotton picking vs estimated quantity' =>$cottonPickingVsEstimatedData ??[],
                                                ];
                                                $rowType = strtolower(trim($row->anomalyType ?? ''));
                                            @endphp

                                            @if (!empty($row->anomaly_data) && array_key_exists($rowType, $dataMap))
                                                @php $aData = $dataMap[$rowType]; @endphp

                                                @if (array_key_exists($row->code, $aData))
                                                    @if (in_array($rowType, ['input cost', 'water use', 'profit','cotton picking vs estimated quantity']))
                                                    
                                                        @foreach ($aData[$row->code][0] as $v)
                                                    
                                                            <td>{{ $v}}</td>
                                                        @endforeach
                                                    @else
                                                        {{-- ✅ Show nested table for other anomalies --}}
                                                        <td style="width: 50%;">
                                                            <div style="overflow-x: auto;">
                                                                <table class="table table-bordered w-100 mb-0">
                                                                    <thead class="table-dark">
                                                                        <tr>
                                                                            @foreach (array_keys($aData[$row->code][0]) as $col)
                                                                                <th>{{ $col }}</th>
                                                                            @endforeach
                                                                        </tr>
                                                                    </thead>
                                                                    <tbody>
                                                                        @foreach ($aData[$row->code] as $val)
                                                                            <tr>
                                                                                @foreach ($val as $v)
                                                                                    <td>{{ $v ?? '-' }}</td>
                                                                                @endforeach
                                                                            </tr>
                                                                        @endforeach
                                                                    </tbody>
                                                                </table>
                                                            </div>
                                                        </td>
                                                    @endif
                                                @endif
                                            @else
                                                {{-- If no anomaly data --}}
                                                @if (!in_array($type, ['input cost', 'water use', 'profit']))
                                                    <td>-</td>
                                                @endif
                                            @endif
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>


                            @else
                                <p class="text-muted">No data available</p>
                            @endif
                        </div> 
                    </div>
                   
                    <div class="card-body">
						<div class="d-flex justify-content-end">
                        {{ $Paginator }}
						</div>
					</div>
                               
                </div>
            </div>
            <!-- Bordered table end -->
        </div>
      

    </section>

    <script>
    var aPBRMapping = [];
    var aUserDetails = [];
    var a_country     = [];
    var a_user_details= [];
    var a_states      = [];
    var a_season      = [];
    var a_districts   = [];
    var a_block   = [];
    var a_brand   = [];
    var aFEFilter     = [];

    var aPesticides     = [];
    var aFertilizers     = [];

    var currentSeason = null;

    // Helper function to get first element if array, else use value
    var brandId    = 0;
    var programId  = 0;
    var countryId =0; 
    var stateId = 0; 
    var districtId =0; 
    var blockId =0; 
    var feId = 0; 
    var pgCode = 0; 

    $(document).ready(function() {
        anomaly_type_changed();
        get_brands_filters();
        // get_season_filters();
        // farmer_data_anomaly();
        get_pg();
    });

    function goBackToDashboard() {
        window.location.href = "{{ url('anomaly_dashboard') }}";
    }

    function get_brands_filters(){
        let programId = $('.program_filter').val()
        let pageName = $('#pageName').val();
        let selected = '';
        let html = '';
       
        $.each(a_brand, function(_, brand) {
            if(is_brand_exist_in_mapping(programId, brand.id) && is_brand_exist_in_access(programId, brand.id)){
                if(brandId==brand.id){
                    selected = 'selected';
                }
                html += `<option value="${brand.id}" ${selected}>${brand.brand_name}</option>`;
                selected = '';
            }
        });

        $('.brand_filter').html(html)
        get_season_filters()
    }

    function is_brand_exist_in_access(programId, brandId){
        let flag = (aUserDetails.length > 0) ? false : true;
        for (let index = 0; index < aUserDetails.length; index++) {
            if((programId == aUserDetails[index].program_id || 0 == aUserDetails[index].program_id) && (brandId == aUserDetails[index].brand_id || 0 == aUserDetails[index].brand_id)){
                flag = true;
                break;
            }
        }
        return flag;
    }

    function is_brand_exist_in_mapping(programId, brandId){
        let flag = false;
        for (let index = 0; index < aPBRMapping.length; index++) {
            if(programId == aPBRMapping[index].programId && brandId == aPBRMapping[index].brandId){
                flag = true;
                break;
            }
        }
        return flag;
    }


    function get_season_filters() {
        let html = '';
        html = '<option value="0">Select Season</option>';

        $.each(a_season, function(_, season) {
            let selected = '';

            // Include season only if it exists in both mapping and access
            if (is_season_exist_in_mapping(season.season) &&
                is_season_exist_in_access(season.season)) {

                if (currentSeason === season.season) {
                    selected = 'selected';
                }

                html += `<option value="${season.season}" ${selected}>${season.season}</option>`;
            }
        });

        $('#chart_season').html(html);

        get_country_filters();
    }

    function is_season_exist_in_access(season) {
        // If no user access details, allow all by default
        let flag = (aUserDetails.length > 0) ? false : true;

        for (let index = 0; index < aUserDetails.length; index++) {
            let access = aUserDetails[index];

            let seasonMatch = (access.season == season);

            if (seasonMatch) {
                flag = true;
                break;
            }
        }
        return flag;
    }

    function is_season_exist_in_mapping(season) {
        let flag = false;

        for (let index = 0; index < aPBRMapping.length; index++) {
            let mapping = aPBRMapping[index];

            // If brandId is 0, ignore brand match; otherwise, match all
            if ( mapping.season == season) {
                flag = true;
                break;
            }
        }
        return flag;
    }

    function get_country_filters() {
        let html = `<option value="0">Select Country</option>`;
        let season = $('#chart_season').val() || 0;
      
        // Loop through available countries
        $.each(a_country, function(_, country) {
            let selected = ''; 
           
           if (
                is_country_exist_in_mapping(season, country.id) &&
                is_country_exist_in_access(season, country.id)
            ) {
                if (country.id == countryId) {
                    selected = 'selected';
                }
               
                html += `<option value="${country.id}" ${selected}>${country.country_name}</option>`;
            }
        });
       
        $('#chart_country').html(html);

        get_state_filters();
    }


    function is_country_exist_in_access(season='', countryId){
        // season = (season === undefined || season === 'undefined') ? '' : season;

        let flag = (aUserDetails.length > 0) ? false : true;
        for (let index = 0; index < aUserDetails.length; index++) {
            if( (season=='' || season==aUserDetails[index].season) && (countryId==aUserDetails[index].country_id || aUserDetails[index].country_id==0)){
                flag = true;
                break;
            }
        }
        return flag;
    }

    function is_country_exist_in_mapping(season='', countryId){
        // season = (season === undefined || season === 'undefined') ? '' : season;


        let flag = false;
        for (let index = 0; index < aPBRMapping.length; index++) {
            if((season=='' || season==aPBRMapping[index].season) && countryId==aPBRMapping[index].countryId){
                flag = true;
                break;
            }
        }
        return flag;
    }

    function get_state_filters(){
       let season = $('#chart_season').val();
       let countryId = $('#chart_country').val();

        
       
        let html = `<option value="0">Select State</option>`;
     
        $.each(a_states, function(_, state) {
            let selected = '';
            if(countryId==state.country_id && is_state_exist_in_mapping(season, countryId, state.id) && is_state_exist_in_access(season, countryId, state.id)){
                if(stateId == state.id){
                    selected = 'selected';
                }
                html += `<option value="${state.id}" ${selected}>${state.state_name}</option>`;
            }
        });
        $('#chart_state').html(html)
        // console.log(html);
        get_district_filters()
    }

    function is_state_exist_in_access(season='', countryId, stateId){

        let flag = (aUserDetails.length > 0) ? false : true;
        for (let index = 0; index < aUserDetails.length; index++) {
            if((season=='' || season==aUserDetails[index].season) && (countryId==aUserDetails[index].country_id || aUserDetails[index].country_id==0) && (stateId==parseInt(aUserDetails[index].state_ids) || parseInt(aUserDetails[index].state_ids)==0)){
                flag = true;
                break;
            }
        }
        return flag;
    }


    function is_state_exist_in_mapping(season='', countryId, stateId){

        let flag = false;
        for (let index = 0; index < aPBRMapping.length; index++) {
            if((season=='' || season==aPBRMapping[index].season) && countryId==aPBRMapping[index].countryId && stateId==aPBRMapping[index].stateId){
                flag = true;
                break;
            }
        }
        return flag;
    }

    function get_district_filters(){
        let season = $('#chart_season').val();
        let countryId = $('#chart_country').val();
        let stateId = $('#chart_state').val()
       
      
        let html = `<option value="0">Select District</option>`;
      
        $.each(a_districts, function(_, district) {
            let selected = '';
            if(countryId==district.country_id && stateId==district.state_id && is_district_exist_in_mapping( season, countryId, stateId, district.id) && is_district_exist_in_access( season, countryId, stateId, district.id)){
                if(districtId==district.id){
                    selected = 'selected';
                }
                html += `<option value="${district.id}" ${selected}>${district.district_name}</option>`;
            }
        });
       
        $('#chart_district').html(html);
        get_block_filters();
        get_FE();
    }

    function get_block_filters(){
        let season = $('#chart_season').val();
        let countryId = $('#chart_country').val()
        let stateId = $('#chart_state').val()
        let districtIds = $('#chart_district').val()
    
        let html = ``;
        let selected = '';
        
        html = `<option value="0">All Block</option>`;

        $.each(a_block, function(_, block) {
            if(block.country_id==countryId && block.state_id==stateId && districtIds==block.district_id){
                if(blockId==block.id){
                    selected = 'selected';
                }
                html += `<option value="${block.id}" ${selected}>${block.block_name}</option>`;
                selected=''
            }
        });
    
        $('.block_filter').html(html);
    }

    function is_district_exist_in_access( season='', countryId, stateId, districtId){

        let flag = (aUserDetails.length > 0) ? false : true;
        for (let index = 0; index < aUserDetails.length; index++) {
            if((season=='' || season==aUserDetails[index].season) && (countryId==aUserDetails[index].country_id || aUserDetails[index].country_id==0) && (stateId==parseInt(aUserDetails[index].state_ids) || parseInt(aUserDetails[index].state_ids)==0) && (districtId==parseInt(aUserDetails[index].district_ids) || parseInt(aUserDetails[index].district_ids)==0)){
                flag = true;
                break;
            }
        }
        return flag;
    }


    function is_district_exist_in_mapping( season='', countryId, stateId, districtId){

        let flag = false;
        for (let index = 0; index < aPBRMapping.length; index++) {
            if((season=='' || season==aPBRMapping[index].season) && countryId==aPBRMapping[index].countryId && stateId==aPBRMapping[index].stateId && districtId==aPBRMapping[index].districtId){
                flag = true;
                break;
            }
        }
        return flag;
    }


    function get_FE() {
        let season = $('#chart_season').val();
        let countryId = $('#chart_country').val();
        let stateId = $('#chart_state').val() || 0;
        let districtId = $('#chart_district').val() || 0;

        let html = `<option value="0">Select All</option>`;

        $.each(aFEFilter, function(_, aFE) {
            let districts = aFE.district_id ? aFE.district_id.split(',') : [];

            if (
                aFE.country_id == countryId &&
                (stateId == 0 || aFE.state_id == stateId) &&
                (districtId == 0 || districts.includes(districtId.toString()) || feId == aFE.id)
            ) {
                let selected = (feId == aFE.id) ? 'selected' : '';
                html += `<option value="${aFE.id}" ${selected}>${aFE.firstname} ${aFE.lastname}</option>`;
            }
        });

        $('#chart_FE').html(html);
    }

    function export_anomaly_list(){
        let selectedSeason = $('#chart_season').val();
        let countryId = $('#chart_country').val();
        let stateId = $('#chart_state').val();
        let districtId = $('#chart_district').val();
        let blockId = $('#chart_block').val();
        let feId = $('#chart_FE').val();
        // let fertilizer =$('#chart_fertilizer').val();
        // let pesticide =$('#chart_pesticide').val();
        let program =$('#chart_program_id').val();
        let brand =$('#chart_brand_id').val();
        let programName = $('#chart_program_id option:selected').text();
        let brandName = $('#chart_brand_id option:selected').text();
        var anomalyType = $('#anomalyType option:selected').text();
        let fertilizerType = $('#fertilizerType').val();
        let pesticideType = $('#pesticideType').val();
        let pgCode = $('#pgCode').val();
        let farmerType = $('#farmerType').val();

        var url = '