problem with filter data using ajax in laravel 8

Question

I want to filter the data in my table. I want if I select the first box it will show the data accordingly and if I select the second box it will show the data accordingly but the problem is that if I select the first box here the data does not show then the second box has to be selected.

Here is my controller code

public function UpazilaWiseReportShow(Request $request){ 

       $data = [];
       $data['report_data'] = Report::distric()->status(1)     
       ->where('upazila_id',$request->upazila_id)->where('fiscal_year', $request->fiscal_year)
       ->get();
        return view('adc.reports.upazilla-wise-data', $data);
    }

here is my view code

<script>
      $(document).ready(function() {
        $('#upazila_id').on('change', function() {
          getFilterData();
        });
        $('#fiscal_year').on('change', function (e) {
                    getFilterData();
        });
    });
    function getFilterData() {
 
      $.ajax({
        type: "GET",
        data: {
         upazila_id: $("[name=upazila_id]").val(),
         fiscal_year: $("[name=fiscal_year]").val()
        },
        url: "{{url('adc/upazila-wise-report')}}",
        success:function(data) {
          $("#report_data_table").html(data);
        }
      });
    }
</script>

Answer 1

You should check if your $request has your needed fields. So you have to check if your request has these fields. You can use when method for it.

With the code below, you can either select fiscal year or upazila_id or both.

    $data['report_data'] = Report::distric()
        ->status(1)
        ->when(
            isset($request->upazila_id),
            function ($query) use ($request) {
                $query->where('upazila_id', $request->upazila_id);
            }
        )
        ->when(
            isset($request->fiscal_year),
            function ($query) use ($request) {
                $query->where('fiscal_year', $request->fiscal_year);
            }
        )
        ->get();