timw4mail / tims-todo

	 * Retrieves list of category types from the database

	 * @return array

	 */

	public function get_category_list()

	{

		$user_group_id  = $this->get_user_group();

		$cat = $this->CI->db->select('id,title,description,group_id')

			->from('category')

			->where('group_id', $user_group_id)

			->or_where('group_id', 0)

			->order_by('group_id', 'desc')

			->order_by('title', 'asc')

			->get();

		return $cat->result_array();

	}

	// --------------------------------------------------------------------------

	 * @param int $user_id

	 * @return array

	 */

	private function get_groups($user_id)

	{

		$username = $this->get_user_from_id($user_id);

		$groups = $this->CI->db->select("group.id, name")

			->from('group')

			->join('group_users_link', 'group.id = group_users_link.group_id', 'inner')

			->where('user_id', $user_id)

			->where('name !=', $username)

			->where('is_admin', 1)

			->order_by('name')

			->get();

		return $groups->result_array();

	}

	// --------------------------------------------------------------------------