/** * Load all user levels and set them to group index. * Every user can have only one level for a group. * * <code> * $options = array( * 'user_id' => 1, * 'group_id' => 2 * ); * * $userLevels = new Gamification\User\Levels(\JFactory::getDbo()); * $userLevels->load($options); * </code> * * @param array $options */ public function load(array $options = array()) { $userId = $this->getOptionId($options, 'user_id'); $groupId = $this->getOptionId($options, 'group_id'); // Create a new query object. $query = $this->db->getQuery(true); $query->select('a.level_id, a.user_id, a.group_id')->select('b.title, b.points, b.value, b.published, b.points_id, b.rank_id, b.group_id')->from($this->db->quoteName('#__gfy_userlevels', 'a'))->innerJoin($this->db->quoteName('#__gfy_levels', 'b') . ' ON a.level_id = b.id')->where('a.user_id = ' . (int) $userId); if (!empty($groupId)) { $query->where('a.group_id = ' . (int) $groupId); } $this->db->setQuery($query); $results = (array) $this->db->loadAssocList(); if (count($results) > 0) { $this->userId = $userId; if ($groupId > 0) { $this->groupId = $groupId; } foreach ($results as $result) { $level = new Level(\JFactory::getDbo()); $level->bind($result); $this->items[$result['group_id']][$level->getLevelId()] = $level; } } }
/** * Load all user levels and set them to group index. * Every user can have only one level for a group. * * <code> * $options = array( * "user_id" => 1, * "group_id" => 2 * ); * * $userLevels = new Gamification\User\Levels(\JFactory::getDbo()); * $userLevels->load($options); * </code> * * @param array $options */ public function load($options = array()) { $userId = ArrayHelper::getValue($options, "user_id"); $groupId = ArrayHelper::getValue($options, "group_id"); // Create a new query object. $query = $this->db->getQuery(true); $query->select("a.level_id, a.user_id, a.group_id")->select("b.title, b.points, b.value, b.published, b.points_id, b.rank_id, b.group_id")->from($this->db->quoteName("#__gfy_userlevels", "a"))->innerJoin($this->db->quoteName("#__gfy_levels", "b") . ' ON a.level_id = b.id')->where("a.user_id = " . (int) $userId); if (!empty($groupId)) { $query->where("a.group_id = " . (int) $groupId); } $this->db->setQuery($query); $results = (array) $this->db->loadAssocList(); if (!empty($results)) { $this->userId = $userId; if (!empty($groupId)) { $this->groupId = $groupId; } foreach ($results as $result) { $level = new Level(\JFactory::getDbo()); $level->bind($result); $this->items[$result["group_id"]][$level->getLevelId()] = $level; } } }