public function __construct()
{
$this->user_id = Auth::getUser()->id;
$role_obj = new RoleUser();
$this->role_id = $role_obj->getRoleById($this->user_id);
$role_policy_ojb = new RolePolicy();
$this->policy_id = $role_policy_ojb->getPolicyByRoleId($this->role_id->role_id);
}
/**
* Maps a Role object contained in a recordset to an object representation
*
* @param $rs Recordset filled with the object data
* @return objeto Mapped Role object
*/
function &mapOne($rs)
{
if ($rs == null) {
return null;
}
$object = new RoleUser();
$object->setId($rs->fields["ID"]);
$object->setUserId($rs->fields["userID"]);
$object->setRoleId($rs->fields["roleID"]);
return $object;
}
/**
* [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 static function onFailure($exception, $job)
{
ResqueUtil::log('[OnFailure]Job ' . CJSON::encode($job->payload['args'][0]['email']) . ' failed with exception ' . $exception);
$userId = $job->payload['args'][0]['id'];
User::model()->deleteByPk($userId);
RoleUser::model()->deleteAllByAttributes(array('user' => $userId));
ProjectUser::model()->deleteAllByAttributes(array('user' => $userId));
Validation::model()->deleteAllByAttributes(array('code' => $job->payload['args'][0]['code']));
}
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);
}
}
/**
* @api {post} /token 登录获得token
* @apiHeader {String} Accept=api-version=1.0 api版本
* @apiHeaderExample {String} Header-Example:
* {
* "Accept": "api-version=1.0"
* }
* @apiName login
* @apiGroup Token
* @apiVersion 1.0.0
*
* @apiParam {String} username 用户名
* @apiParam {String} password 密码
*
* @apiSuccess {String} token 该用户的token，两小时后失效
*
* @apiSuccessExample Success-Response:
* HTTP/1.1 200 OK
* {
* "token": "xxx"
* }
*
* @apiUse errorExample
*/
public function login()
{
$username = $this->request->getPost('username');
$password = $this->request->getPost('password');
$userModel = new User();
$result = $userModel->login($username, $password);
if (false === $result) {
return parent::response($userModel->getMessages(), 406);
}
$roleUser = RoleUser::findFirst("user_id=" . $result->id);
$token = parent::obtainToken($result->id, $roleUser->role_id);
if (false === $token) {
return parent::response(array('errors' => array(array('code' => 500, 'field' => null, 'message' => 'unkown error'))), 500);
}
return parent::success(array('token' => $token));
}
/**
* @api {post} /token 登录获得token
* @apiHeader {String} Accept=api-version=1.0 api版本
* @apiHeaderExample {String} Header-Example:
* {
* "Accept": "api-version=1.0"
* }
* @apiName login
* @apiGroup Token
* @apiVersion 1.0.0
*
* @apiParam {String} username 用户名
* @apiParam {String} password 密码
*
* @apiSuccess {String} token 该用户的token，两小时后失效
*
* @apiSuccessExample Success-Response:
* HTTP/1.1 200 OK
* {
* "token": "xxx"
* }
*
* @apiUse errorExample
*/
public function login()
{
$username = $this->request->getPost('username');
$password = $this->request->getPost('password');
$modelUser = new User();
$result = $modelUser->login($username, $password);
if (false === $result) {
return parent::response($modelUser->getMessages(), 406);
}
$roleUser = RoleUser::findFirst("user_id=" . $result->id);
$token = parent::obtainToken($result->id, $roleUser->role_id);
if (false === $token) {
return parent::serverError();
}
return parent::success(array('token' => $token));
}
/**
* @api {delete} /admin/user/{id} 删除某个用户
* @apiUse header
*
* @apiName deleteUser
* @apiGroup User
* @apiVersion 1.0.0
*
* @apiParam {String} username 该子会议的ID
* @apiParam {String} name 该子会议名称 必选
* @apiParam {String} organization 子会议的开始时间
* @apiParam {Integer} title 子会议的结束时间
* @apiParam {String} email 子会议举行场地
* @apiParam {String} password 该子会议可接纳的人数
*
* @apiSuccess {Array} empty_array 空数组
*/
public function deleteUser($id)
{
if (empty($id)) {
return parent::required('id');
}
$where = 'id=' . $id . ' and isdeleted=0';
$user = User::findFirst($where);
if (empty($user)) {
return parent::invalid('id', $id);
}
if (false == $user->delete()) {
return parent::resWithErrMsg($user->getMessages(), 406);
}
$roleUser = new RoleUser();
$roleUser->user_id = $id;
if (false == $roleUser->delete()) {
return parent::resWithErrMsg($roleUser->getMessages());
}
return parent::success();
}
/**
* Exclude object from result
*
* @param RoleUser $roleUser Object to remove from the list of results
*
* @return RoleUserQuery The current query, for fluid interface
*/
public function prune($roleUser = null)
{
if ($roleUser) {
$this->addUsingAlias(RoleUserPeer::ID, $roleUser->getId(), Criteria::NOT_EQUAL);
}
return $this;
}
/**
* [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);
}
}
/**
* Adds an object to the instance pool.
*
* Propel keeps cached copies of objects in an instance pool when they are retrieved
* from the database. In some cases -- especially when you override doSelect*()
* methods in your stub classes -- you may need to explicitly add objects
* to the cache in order to ensure that the same objects are always returned by doSelect*()
* and retrieveByPK*() calls.
*
* @param RoleUser $value A RoleUser object.
* @param string $key (optional) key to use for instance map (for performance boost if key was already calculated externally).
*/
public static function addInstanceToPool(RoleUser $obj, $key = null)
{
if (Propel::isInstancePoolingEnabled()) {
if ($key === null) {
$key = (string) $obj->getId();
}
// if key === null
self::$instances[$key] = $obj;
}
}
public function getRoleById($id)
{
$role = RoleUser::where('user_id', '=', $id)->first();
return $role;
}
/**
* @api {post} /user 注册接口
* @apiHeader {String} Accept=api-version=1.0 api版本
* @apiHeaderExample {String} Header-Example:
* {
* "Accept": "api-version=1.0"
* }
* @apiName register
* @apiGroup User
* @apiVersion 1.0.0
*
* @apiSuccess {Array} empty_array 空数组
*
* @apiUse errorExample
*/
public function register()
{
$this->db->begin();
$data = $this->request->getPost();
$userValidator = new UserValidator();
$messages = $userValidator->validate($data);
if (0 != count($messages)) {
return parent::resWithErrMsg($messages, 406);
}
$modelUser = new User();
$duplicate = $modelUser->findFirst("lower(username)='" . strtolower($data['username']) . "'");
if (!empty($duplicate)) {
return parent::valueDuplicate('username');
}
$data['password'] = password_hash($data['password'], PASSWORD_DEFAULT);
$res = $modelUser->create($data);
if (false == $res) {
$this->db->rollback();
return parent::resWithErrMsg($modelUser->getMessages());
}
$config = $this->di->get('config');
$userRole['role_id'] = $config->role->User;
$userRole['user_id'] = $modelUser->id;
$roleUserModel = new RoleUser();
$res = $roleUserModel->create($userRole);
if (false == $res) {
$this->db->rollback();
return parent::resWithErrMsg($roleUserModel->getMessages());
}
$this->db->commit();
return parent::success();
}
public function registerAction()
{
Input::flash();
$data = Input::all();
$nhc_config = Config::get('nhc/site.init_privacy');
$rules = array('fname' => 'required', 'agency_id' => 'required', 'username' => 'required | alpha_dash', 'username' => 'required', 'password' => 'required | min:6 |same:password_confirmation', 'password_confirmation' => 'required', 'email' => 'required | email ');
$messages = array('fname.required' => 'กรุณาระบุชื่อผู้ใช้งาน', 'agency_id.required' => 'กรุณาระหน่วยงานสังกัด', 'username.required' => 'กรุณาระบุชื่อผู้ใช้งาน', 'username.alpha_dash' => 'ชื่อผู้ใช้งานต้องประกอบด้วยตัวอักษร ตัวเลข หรืออันเดอร์สกอร์เท่านั้น', 'password.required' => 'กรุณาระบุรหัสผ่าน', 'password.min' => 'ความยามรหัสผ่านอย่างน้อย :min อักษร', 'password.same' => 'รหัสผ่านที่กรอกไม่ตรงกัน', 'password_confirmation.required' => 'กรุณาระบุรหัสผ่านอีกครั้ง', 'email.required' => 'กรุณาระบุอีเมล์', 'email.email' => 'รูปแบบอีเมล์ไม่ถูกต้อง');
$validator = Validator::make($data, $rules, $messages);
if ($validator->passes()) {
$usernhc = new Usernhc();
$ck_email = $usernhc->checkUserByEmail($data['email']);
$ck_username = $usernhc->checkUsername($data['username']);
if (!$ck_email && !$ck_username) {
$usernhc->agency_id = $data['agency_id'];
$usernhc->grp_id = $data['grp_id'];
$usernhc->username = $data['username'];
$usernhc->password = Hash::make($data['password']);
$usernhc->email = $data['email'];
$usernhc->fname = $data['fname'];
$usernhc->lname = $data['lname'];
$usernhc->telno = $data['telno'];
$usernhc->status = $data['status'];
$usernhc->save();
//set basic privacy to new user
$privacy = new Privacy();
$privacy->userid = $usernhc->getUserIdByUserName($data['username']);
// $privacy->fname = true;
// $privacy->lname = false;
// $privacy->email = false;
// $privacy->telno = false;
// $privacy->agency = false;
// $privacy->ministry = false;
// $privacy->role = false;
$rs = PrivacyInit::all()->toArray();
foreach ($rs as $key => $value) {
$result[$value['name_en']]['val'] = $value['init_value'];
$result[$value['name_en']]['th'] = $value['name_th'];
$result[$value['name_en']]['en'] = $value['name_en'];
}
$privacy->fname = $result['fname']['val'];
$privacy->lname = $result['lname']['val'];
$privacy->email = $result['email']['val'];
$privacy->telno = $result['telno']['val'];
$privacy->agency = $result['agency']['val'];
$privacy->ministry = $result['ministry']['val'];
$privacy->role = $result['role']['val'];
$privacy->save();
$role = new RoleUser();
$role->role_id = 6;
$role->user_id = $usernhc->getUserIdByUserName($data['username']);
$role->save();
return Redirect::route('login')->with('success', 'ระบบบันทึกการลงทะเบียนสำเร็จกรุณารอ 24 ชั่วโมงจึงจะสามารถเข้าใช้งานระบบได้');
} else {
return Redirect::route('regis')->withInput()->withErrors(array('message' => 'อีเมล์หรือชื่อผู้ใช้งานมีอยู่ในระบบแล้ว'));
}
} else {
return Redirect::route('regis')->withErrors($validator);
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
factory(App\Models\User::class, 5)->create()->each(function ($c) {
});
$createDep = new Department();
$createDep->id = '2';
$createDep->name = 'Nerds';
$createDep->save();
$createDep = new Department();
$createDep->id = '3';
$createDep->name = 'Genius';
$createDep->save();
$newrole = new RoleUser();
$newrole->role_id = '1';
$newrole->user_id = '2';
$newrole->timestamps = false;
$newrole->save();
$newrole = new RoleUser();
$newrole->role_id = '2';
$newrole->user_id = '3';
$newrole->timestamps = false;
$newrole->save();
$newrole = new RoleUser();
$newrole->role_id = '3';
$newrole->user_id = '4';
$newrole->timestamps = false;
$newrole->save();
$newrole = new RoleUser();
$newrole->role_id = '3';
$newrole->user_id = '5';
$newrole->timestamps = false;
$newrole->save();
$newrole = new RoleUser();
$newrole->role_id = '3';
$newrole->user_id = '6';
$newrole->timestamps = false;
$newrole->save();
\DB::table('department_user')->insert([['department_id' => 1, 'user_id' => 2], ['department_id' => 2, 'user_id' => 3], ['department_id' => 3, 'user_id' => 4], ['department_id' => 3, 'user_id' => 5], ['department_id' => 2, 'user_id' => 6]]);
}
