public function gender(Request $request)
{

    $dataGender = [];

    if($request->has('q')){
        $search = $request->q;

        $dataGender = DB::table("modified_dpprs")
                ->select("id","Jantina")
                ->where('Jantina','LIKE',"%$search%")
                ->get();
    }
    return response()->json($dataGender);
}


public function filterQuery(Request $request){

$dataGender = $request->dataGender;
 $ethnicity = $request->ethnicity;
 $area = $request->area;
 $state = $request->state;
 $namaDUN = $request->namaDUN;

    $query = ModifiedDppr::query();

    if(!empty($request->dataGender)){
        $query->where('Jantina',$dataGender);
    }

    if(!empty($request->ethnicity)){
        $query->where('Bangsa_updated','$ethnicity');
    }

    if(!empty($request->area)){
        $query->where('Taman_area',$area);
    }

    if(!empty($request->state)){
        $query->where('Negeri',$state);
    }

    if(!empty($request->namaDUN)){
        $query->where('namaDUN',$namaDUN);
    }

    $data = $query->get();

 return datatables()->of($data)->make(true);

    }