/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index(Request $request)
{
//listing all farmer when no search is done
$allfarmer = User::where('user_type_id', 3)->paginate(10);
//$allfarmer = User::where('user_type_id', 3)->get(); /previous code
//listing Farmerpoint for dropdown
$farmerPointList = FarmerPoint::Lists('name', 'id');
$cropList = Crop::Lists('name', 'id');
//recieving data from search field
$farmer_name = $request->input('name');
$farmer_phone = $request->input('phone');
$farmerInPoint = $request->input('id');
$farmerWithCrop = $request->input('crop');
if (!empty($farmer_name)) {
$allfarmer = User::where('user_type_id', 3)->where('name', 'LIKE', '%' . $farmer_name . '%')->paginate(10);
}
if (!empty($request->phone)) {
$allfarmer = User::where('user_type_id', 3)->where('phone', 'LIKE', '%' . $farmer_phone . '%')->paginate(10);
}
if (!empty($farmerInPoint)) {
if (!empty($farmerWithCrop)) {
$allfarmer = User::whereHas('farmerCrop', function ($query) use($farmerWithCrop) {
$query->where('crop_id', $farmerWithCrop);
})->where('user_type_id', 3)->where('farmer_point_id', $farmerInPoint)->paginate(10);
} else {
$allfarmer = User::where('user_type_id', 3)->where('farmer_point_id', $farmerInPoint)->paginate(10);
}
}
if (!empty($farmerWithCrop)) {
$allfarmer = User::whereHas('farmerCrop', function ($query) use($farmerWithCrop) {
$query->where('crop_id', $farmerWithCrop);
})->where('user_type_id', 3)->paginate(10);
}
return view('farmer.FarmerList', ['allfarmer' => $allfarmer, 'farmerPointList' => $farmerPointList, 'cropList' => $cropList]);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$cropList = Crop::lists('name', 'id')->all();
$upazilaList = Upazila::lists('name', 'id')->all();
$crop = FarmerCrop::findOrFail($id);
return view('Farmer.FarmerCropEdit', compact('crop', 'cropList', 'upazilaList'));
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
$input = $request->all();
$crop = Crop::findOrFail($id);
$crop->update($input);
if (!empty($request->profile_picture)) {
$image = Image::make($request->profile_picture);
$image->resize(250, 272);
$image->save(public_path("uploads/Crops/crop_{$id}.jpg"));
}
return redirect("crop/{$crop->id}");
}
