/**
* [numTrainCourse description]
* @return [type] [description]
*/
public static function numTrainCourse()
{
$userid = Auth::getUser()->id;
$roleid = RoleUser::where('user_id', $userid)->get(array('role_id'));
$numCourse = Training::where('target', 'LIKE', '%' . $roleid[0]->role_id . '%')->where('status', '!=', false)->count();
// echo $numCourse;exit;
return $numCourse;
}
public function delRoleAction($id)
{
try {
Roles::where('id', '=', $id)->delete();
RolePolicy::where('role_id', '=', $id)->delete();
RoleUser::where('role_id', '=', $id)->delete();
return Redirect::to('role')->with('success', 'ลบทิ้งบทบาทรหัส = ' . $id . ' สำเร็จ.');
} catch (Exception $e) {
return Redirect::to('role')->with('warning', 'Error occur info:' . $e->getMessage());
//throw new Exception( 'Something really gone wrong', 0, $e);
}
}
/**
* [userApprovalSave save method of user information after approval]
* @param [integer] $id [user id]
* @return [none] [redirect to user list]
*/
public function userApprovalSave($id)
{
$data = Input::all();
//var_dump($data);exit;
$rules = array('user_approve' => 'required');
$messages = array('user_approve.required' => 'กรุณาระบุสถานะการใช้งาน');
$validator = Validator::make($data, $rules, $messages);
//var_dump($validator->messages());exit;
if ($validator->passes()) {
$usernhc = Usernhc::find($id);
$usernhc->status = $data['user_approve'];
//approve user
$usernhc->grp_id = $data['user_grp'];
//promote user
$usernhc->save();
//set role to user
// //DB::table('role_user')
// ->where('user_id','=',$id)
// ->update(array('role_id' => $data['role_approve']));
$roleuser = new RoleUser();
$_roleuser = $roleuser->getRoleById($id);
if (isset($_roleuser)) {
//if it exist
RoleUser::where('user_id', '=', $id)->update(array('role_id' => $data['role_approve']));
} else {
$roleuser->role_id = $data['role_approve'];
//role id
$roleuser->user_id = $id;
//user id
$roleuser->save();
}
// $rolepolicy = new RolePolicy;
// $rolepolicy->role_id = $data['role_approve'];//role id
// $rolepolicy->policy_id = $id;//user id
// $roleuser->save();
if ($data['user_approve'] == 'yes') {
//Send email when status is allow to user.
self::emailToUser($usernhc->email, $usernhc->fname . ' ' . $usernhc->lname, $data['user_approve'], $data['user_grp'], $data['role_approve']);
}
return Redirect::route('userlist');
} else {
return Redirect::to('/userlist/approval/' . $id)->withErrors($validator);
}
}
public function getRoleById($id)
{
$role = RoleUser::where('user_id', '=', $id)->first();
return $role;
}
