/** * 关键字搜索。 * @param string $sKeyword 搜索关键字。 * @return array */ public function handle($sKeyword) { $sSQL = 'SELECT *, rowid FROM ' . Account::TABLE_NAME . ' WHERE parent=0 AND valid=' . Account::STATUS_VALID . ' AND (name like ? OR value like ?)'; return u\DB::getList($sSQL, ['%' . $sKeyword . '%', '%' . $sKeyword . '%']); }
/** * 推荐帐号。 * @param int $iSize 推荐个数。 * @return array */ public function get($iSize) { $sSQL = 'SELECT rowid, name, value FROM ' . Account::TABLE_NAME . ' WHERE valid=1 AND parent=0 ORDER BY RANDOM() LIMIT ' . $iSize; $ret = u\DB::getList($sSQL); foreach ($ret as $k => $v) { $ret[$k]['url'] = c\Router::genURL('Detail', ['id' => $v['rowid']]); } return $ret; }
public function run() { $aConfig = c\Config::get('dsn'); u\DB::connect($aConfig['data']); $sSQL = 'SELECT rowid,name,value FROM ' . m\Account::TABLE_NAME . ' WHERE parent=0 AND valid=' . m\Account::STATUS_VALID; $aList = u\DB::getList($sSQL); foreach ($aList as $aInfo) { $aInfo['http_code'] = $this->check('http://' . $aInfo['value']); $sMessge = implode(' - ', $aInfo); $sTheme = $aInfo['http_code'] == 200 ? 'notice' : 'error'; c\cecho($sMessge, $sTheme); } }
/** * 获得一个帐号的所有记录。 * @param int $iAccountID 帐号ID。 * @return array */ public function getAccountFields($iAccountID) { $sSQL = 'SELECT *, rowid FROM ' . self::TABLE_NAME . ' WHERE parent=? AND valid=' . self::STATUS_VALID; $aResult = u\DB::getList($sSQL, [$iAccountID]); foreach ($aResult as $k => $v) { $aResult[$k]['value'] = $sRealValue = $this->decrypt(gzinflate($v['value'])); $aResult[$k]['name'] = base64_decode(gzinflate($v['name'])); if (substr($sRealValue, 0, 5) === 'link:') { $sSQLAccount = 'SELECT rowid FROM ' . self::TABLE_NAME; $sSQLAccount .= ' WHERE valid=' . self::STATUS_VALID . ' AND name=? LIMIT 1'; $sLinkAccount = substr($sRealValue, 5); $aAccountID = u\DB::getOne($sSQLAccount, [$sLinkAccount]); $aResult[$k]['link'] = c\Router::genURL('Detail', ['id' => $aAccountID['rowid']]); $aResult[$k]['linkname'] = $sLinkAccount; } } return $aResult; }