/**
  * 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;
 }
Exemplo n.º 2
0
 /**
  * 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;
 }
Exemplo n.º 3
0
 /**
  * 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;
 }
Exemplo n.º 4
0
 /**
  * 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;
         }
     }
 }