public function postDistricts(Request $request, $nationality_id, $state_id, $lga_id)
{
$rules = array('title' => 'required');
$validator = Validator::make($request->all(), $rules);
if ($validator->fails()) {
return Redirect::to('/place/' . $nationality_id . '/' . $state_id . '/' . $lga_id)->withErrors($validator)->withInput($request->except('password'));
} else {
$user = new User();
$user->id = 1;
//$user = Auth::user();
$record = new District();
$record->title = $request->get('title');
$record->lga()->associate(Lga::find($lga_id));
$record->state()->associate(State::find($state_id));
$record->nationality()->associate(Nationality::find($nationality_id));
$record->user()->associate($user);
$record->save();
// redirect
Session::flash('message', 'Successfully updated!');
return Redirect::to('/place/' . $nationality_id . '/' . $state_id . '/' . $lga_id);
}
}
/**
* Filter employee
* @return [type] [description]
*/
public function filter()
{
$positions = Input::get('position');
$nationalities = Input::get('nationality');
$genders = Input::get('gender');
$birthdays = Input::get('birthday');
/*Thuc hien cau truy van de lay du lieu ra ben ngoai*/
$query = Employee::where('position_id', 'LIKE', "%{$positions}")->where('nationality', 'LIKE', "%{$nationalities}%")->where('gender', 'LIKE', "%{$genders}%")->where('date_of_birth', 'LIKE', "%{$birthdays}%")->get();
/*Tra ve view list employee*/
$results = array();
foreach ($query as $key => $value) {
$results[] = $value;
}
$employees = $results;
foreach ($employees as $key => $value) {
$employees[$key]->position_name = Position::find($value->position_id)->name;
$employees[$key]->national_name = Nationality::find($value->nationality)->name;
}
$positions = Position::all();
$nationalities = Nationality::all();
return view('employee.listemployee', compact('employees', 'positions', 'nationalities'));
}
