/**
* 关键字搜索。
* @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;
}
