public function actionBanlist() { $this->model->authAdmin(); $this->view->users = AbstractModel::createObjects('Model_User', AbstractModel::getOnWhere('user', '*', 'isBan=?', array(1))); if ($this->request->recover !== '') { $rec = $this->request->recover; $userOnBan = Model_User::getByField('Model_User', 'user', "id", $rec); $userOnBan->isBan = 0; $userOnBan->save(); //app::redirect($_SERVER['HTTP_REFERER']); } $this->view->render('banlist'); $this->view->display(); }
/** * get all data from joined tables * * @param $class * @param $table * @param $join * @return array|bool */ public static function getAllWithJoin($class, $table, $fields, $join) { $select = new SelectPDO(); $select->from($table, $fields); if (count($join) > 0) { foreach ($join as $field) { $select->join($field[0], $field[1], $field[2]); } } $data = self::$db->select($select); return AbstractModel::createObjects($class, $data); }