public function create() { $user = Auth::user(); $userGroups = UserGroup::where('level', '>', $user->user_group_id)->lists('name_en', 'id'); $designations = Designation::lists('name', 'id'); $workspaces = Workspace::lists('name', 'id'); return view('employees.create', compact('designations', 'workspaces', 'userGroups')); }
public function sumUserGroup($date) { $userGroup = UserGroup::where('item_id', $this->item->id)->where('user_grouping_date', $date)->first(); if ($userGroup && $this->getNextUserGroupDate($date) < date("Y-m-d")) { return $userGroup; } $userDefinition = $this->item->project->userDefinition; $value = DB::connection($this->item->project->db)->table($userDefinition->table_name)->whereRaw($this->item->other_criteria ? $this->item->other_criteria : 'TRUE')->where($userDefinition->date_column, '>=', $date)->where($userDefinition->date_column, '<', $this->getNextUserGroupDate($date))->count(); if (!$userGroup) { $userGroup = new UserGroup(); $userGroup->user_grouping_date = $date; } $userGroup->value = $value; return $this->item->userGroups()->save($userGroup); }
public function getForEdit($id) { $data = []; $e = $this->empDto->findById($id); if ($e) { $ug = UserGroup::where('user_id', $e->user->id)->first(); $data['empId'] = $e->id; $data['id_number'] = substr($e->id_number, 4); $data['first_name'] = $e->first_name; $data['middle_name'] = $e->middle_name; $data['last_name'] = $e->last_name; $data['sex'] = $e->sex; $data['birthday'] = $e->birthday; $data['email'] = $e->user->email; $data['shift'] = ['id' => $e->shift->id]; $data['group'] = ['id' => $ug->group->id]; } return $data; }
public function create() { $groups = UserGroup::where('id', '!=', 1)->lists('name_en', 'id'); $workspaces = Workspace::lists('name', 'id'); return view('users.create', compact('groups', 'workspaces')); }
/** * @param $userId * @return 1 if User is Administrator * @return 2 if User is Student * @return 3 if User is Teacher */ public static function checkUserTypeByUserId($userId) { $userGroup = UserGroup::where('user_id', $userId)->get()->first(); return $userGroup->group_id; }
<?php use App\Models\UserGroup; use App\Models\UserDetails; use App\Models\Groups; $user_id = Auth::user()->id; $user_group = UserGroup::where('user_id', '=', $user_id)->get()->first(); $userDetails = UserDetails::where('user_id', '=', $user_id)->get()->first(); $admin_group_id = Groups::Administrator_Group_ID; $teacher_group_id = Groups::Teacher_Group_Id; $student_group_id = Groups::Student_Group_Id; ?> @section('upper-dropdown') <a data-toggle="dropdown" data-hover="dropdown" class="dropdown-toggle" data-close-others="true" href="#"> @if($userDetails->pic == null) <img src="{{ URL::asset('assets/images/anonymous.jpg') }}" class="img-circle" alt="" width="30px" height="30px" id="upper_dropdown_menu_profile_image"> @else <img src="{{ URL::asset('school/images/user/profile_images/'.$userDetails->pic) }}" class="img-circle" alt="" width="30px" height="30px" id="upper_dropdown_menu_profile_image"> @endif <span class="username hidden-xs">{{ $userDetails->first_name }} {{ $userDetails->last_name }}</span> <i class="fa fa-caret-down "></i> </a> @stop @section('left-user-profile') <div class="inline-block"> @if($userDetails->pic == null) <img src="{{ URL::asset('assets/images/anonymous.jpg') }}" class="img-circle" alt="" width="50px" height="50px" id="left_menu_profile_image"> @else
function save(array $params) { $response = new ResponseEntity(); DB::transaction(function () use(&$response, $params) { $empId = isset($params['empId']) ? intval($params['empId']) : 0; $idNumber = Config::get('hris_system.employee_id_prefix') . $params['id_number']; $existingEmp = Employee::with('user')->find($empId); // check for duplicate id_number $tempEmp = Employee::where('id_number', '=', $idNumber)->first(); if ($tempEmp) { if (!$existingEmp) { // new $response->setMessages(['id_number' => ['Id number is already taken']]); return $response; } else { if ($existingEmp && $existingEmp->id != $tempEmp->id) { // update $response->setMessages(['id_number' => ['Id number is already taken']]); return $response; } } } if ($empId > 0 && !$existingEmp) { // check when updating $response->setMessages(['Employee is not available!']); return $response; } else { // employee user account $user = $existingEmp ? $existingEmp->user : new User(); $user->email = $params['email']; if (!$existingEmp) { // for new employee user account $user->password = Hash::make($idNumber); //default password is the ID Number of the employee $user->active = '1'; } $user->save(); // clear user group UserGroup::where('user_id', $user->id)->delete(); // assign group $ug = new UserGroup(); $ug->user_id = $user->id; $ug->group_id = $params['group_id']; $ug->save(); // employee records $employee = $existingEmp ? $existingEmp : new Employee(); $employee->user_id = $user->id; $employee->id_number = $idNumber; $employee->first_name = $params['first_name']; $employee->last_name = $params['last_name']; if (isset($params['middle_name'])) { $employee->middle_name = $params['middle_name']; } if (isset($params['supervisor_id'])) { $employee->supervisor_id = $params['supervisor_id']; } $employee->sex = $params['sex']; $employee->birthday = Carbon::createFromFormat('m/d/Y', $params['birthday']); $employee->shift_id = $params['shift_id']; $employee->active = $existingEmp ? $existingEmp->active : '1'; $ok = $employee->save(); if ($ok) { $response->setSuccess(true); $response->setData(['empId' => $employee->id]); $response->setMessages(['Employee successfully ' . ($existingEmp ? 'saved' : 'created')]); } else { $response->setMessages(['Failed to ' . ($existingEmp ? 'save' : 'create') . ' employee!']); } } }); return $response; }
public function getUserGroup() { return UserGroup::where('UserID', $this->UserID)->where('Default', 'Y'); }