/** * Fetch all password tokens * * @return Apine\Core\Collection */ public static function create_all() { $database = new Apine\Core\Database(); $request = $database->select('SELECT `id` from `apine_password_tokens` ORDER BY `user_id` ASC'); $liste = new Apine\Core\Collection(); if ($request != null && count($request) > 0) { foreach ($request as $item) { $liste->add_item(new Apine\User\PasswordToken((int) $item['id'])); } } return $liste; }
/** * Fetch apine_user_groups by user * * @param integer $user * User id * @return Collection */ public static function create_by_user($user) { $database = new Database(); $request = $database->select("SELECT `group_id` FROM `apine_users_user_groups` WHERE `user_id`={$user}"); $liste = new Collection(); if ($request != null && count($request) > 0) { foreach ($request as $item) { $liste->add_item(new Apine\User\UserGroup((int) $item['group_id'])); } } return $liste; }
/** * Fetch users by group id * * @param integer $group * User Group id * @return Apine\Core\Collection */ public static function create_by_group($group) { $database = new Apine\Core\Database(); $request = $database->select("SELECT `user_id` FROM `apine_users_user_groups` WHERE `group_id`={$group}"); $liste = new Apine\Core\Collection(); if ($request != null && count($request) > 0) { foreach ($request as $item) { $class = self::get_user_class(); $liste->add_item(new $class((int) $item['user_id'])); } } return $liste; }
/** * Fetch database fields and values for entity */ protected final function _load() { $db = new Database(); if ($this->id !== null) { if (!is_numeric($this->id)) { $field_id = $db->quote($this->id); } else { $field_id = $this->id; } $database_fields = $db->select("SELECT * from {$this->table_name} where {$this->load_field} = {$field_id}"); if ($database_fields) { $this->database_fields = $database_fields[0]; $this->field_loaded = 1; } } if (sizeof($this->modified_fields) > 0) { foreach ($this->modified_fields as $key => $values) { $this->modified_fields[$key] = false; } } }