public function getLatestSuccessUser($offset, $limit) { $dbManager = Db::getInstance(); $statement = $dbManager->prepare(self::GET_LATEST_USER); $statement->bindValue(':offset', $offset, PDO::PARAM_INT); $statement->bindValue(':limit', $limit, PDO::PARAM_INT); if (!$statement->execute()) { return null; } $result = $statement->fetchAll(PDO::FETCH_ASSOC); if (!$result) { return null; } $uidList = []; foreach ($result as $row) { $uidList[] = $row['uid']; } return $uidList; }
public function getUserRosterGroup($uid) { if (!$uid) { $this->setLastError(Code::FAIL_GROUP_ROSTER_NOT_EXISTS, 'uid is empty'); return null; } $dbManager = Db::getInstance(); $statement = $dbManager->prepare(self::GET_USER_ROSTER_GROUP); if (!$statement->execute([$uid])) { $this->setLastError(Code::FAIL_DATABASE_ERROR, 'get roster groups failed'); return null; } $list = $statement->fetchAll(PDO::FETCH_CLASS, 'minions\\model\\RosterGroup'); return $this->addDefaultGroupToList($list, $this->getUserDefaultGroup($uid)); }
public function _initDb() { Db::getInstance()->initConfig(\Yaf\Application::app()->getConfig()->get('application')->get('database')); }
public function getGroupUserArray(GroupUser $model) { $dbManager = Db::getInstance(); $statement = $dbManager->prepare(self::GET_GROUP_USER); if (!$statement->execute([$model->gid, $model->uid])) { return new ApiResponse(Code::FAIL_DATABASE_ERROR, 'execute to get group user failed'); } return $statement->fetch(PDO::FETCH_ASSOC); }
public function moveGroup(Roster $model, RosterGroup $from, RosterGroup $to) { if (!$model->uid) { return new ApiResponse(Code::FAIL_USER_NOT_EXISTS, 'uid is empty'); } if ($from->id == $to->id) { return new ApiResponse(Code::FAIL_MOVE_GROUP, 'from is same as to'); } $dbManager = Db::getInstance(); $statement = $dbManager->prepare(self::MOVE_GROUP); if (!$statement->execute([$to->id, $model->uid, $from->id])) { return new ApiResponse(Code::FAIL_DATABASE_ERROR, 'move group failed'); } return null; }
public function getHotGroups(Group $model) { if (!$model->checkType()) { $this->setLastError(Code::FAIL_GROUP_TYPE, 'type is error'); return null; } $dbManager = Db::getInstance(); $statement = $dbManager->prepare(self::GET_HOT_GROUPS); if (!$statement->execute([$model->type])) { $this->setLastError(Code::FAIL_DATABASE_ERROR, 'get hot groups failed'); return null; } return $statement->fetchAll(PDO::FETCH_CLASS, 'minions\\model\\Group'); }
<?php use jegarn\cache\Cache; use minions\db\Db; define('PIC_HOST', '/upload/'); define('TEST_HOST', 'http://192.168.199.243'); require __DIR__ . '/../../examples/web-chat-system/src/bootstrap.php'; require __DIR__ . '/../../sdk/php/src/jegarn.php'; require __DIR__ . '/AppTestBase.php'; $config = new \Yaf\Config\Ini(__DIR__ . '/../../examples/web-chat-system/config/application.ini', 'develop'); Db::getInstance()->initConfig($config->get('application')->get('database')); Cache::getInstance()->initConfig($config->get('application')->get('cache'));
public function removeUser(User $model) { $dbManager = Db::getInstance(); if ($model->id) { $statement = $dbManager->prepare(self::REMOVE_USER_BY_UID); $statement->bindValue(1, $model->id, PDO::PARAM_INT); // this add to get user's user name if (!$model->username) { if ($resp = $this->getUser($model)) { return $resp; } } } else { if ($model->username) { $statement = $dbManager->prepare(self::REMOVE_USER_BY_USERNAME); $statement->bindValue(1, $model->username, PDO::PARAM_STR); } else { return new ApiResponse(Code::FAIL_USER_UID_OR_NAME_NOT_EXISTS, null); } } if (!$statement->execute()) { return new ApiResponse(Code::FAIL_DATABASE_ERROR, null); } JegarnUtil::removeUser($model->username); return null; }