function index() { $users = new User(); $users->include_related('group', 'name'); $bug = $users->bug; $bug->select_func('COUNT', '*', 'count')->where_related_status('closed', FALSE)->where_related('user', 'id', '${parent}.id'); $users->select_subquery($bug, 'bug_count'); $users->get_iterated(); $this->output->enable_profiler(TRUE); $this->load->view('template_header', array('title' => 'Users', 'section' => 'admin')); $this->load->view('users/index', array('users' => $users)); $this->load->view('template_footer'); }
/** * Returns an array of Users. Bonus point: it also returns $user->is_leader * * @author Woxxy * @param int $team_id * @return object Users with ->is_leader */ function get_members($team_id) { $this->where('team_id', $team_id)->where('accepted', 1)->get(); $members = new User(); if ($this->result_count() == 0) return $members; foreach ($this->all as $member) { $members->or_where('id', $member->user_id); } $members->include_related('profile')->get(); foreach ($members->all as $key => $member) { $member->is_leader = ($this->all[$key]->is_leader == 1) ? '1' : '0'; } return $members; }
function roles_post() { $requested_data = json_decode($this->post('models')); foreach ($requested_data as $d) { $user = new User(null, $this->entity); $user->where('id', $d->user_id); $user->get(); $role = new Role(null, $this->entity); $role->where('id', $d->role_id); $role->get(); if ($user->exists() && $role->exists()) { if ($user->save($role)) { $r = $user->include_related('role', NULL, TRUE)->get_raw(); $this->response(array('msg' => 'assigned successfully.', 'results' => $r->result()), 201); } else { $this->response(array('msg' => 'error assigning to role.', 'results' => array()), 201); } } else { $this->response(array('msg' => 'either role or user does not exist', 'results' => array()), 201); } } // $this->response(array('msg'=>'assigned successfully.', 'results'=>$r->result()), 201); }