protected function _aGetCurrentListFromDb()
{
$now = time();
$stime = ceil($now / 3600.0) * 3600;
$etime = floor($now / 3600.0) * 3600;
$option = new Ko_Tool_SQL();
$listApi = $this->_aConf['listApi'];
$list = $this->{$listApi}->aGetList($option->oSelect('id, stime, etime, grp, regions, forbidregions, uids, priority')->oWhere('stime <= ? and etime >= ? and pub != 0', date('Y-m-d H:i:s', $stime), date('Y-m-d H:i:s', $etime)));
foreach ($list as &$v) {
$v['stime'] = strtotime($v['stime']);
$v['etime'] = strtotime($v['etime']);
$v['uids'] = preg_split('/;|,|\\s/', $v['uids']);
$v['regions'] = $this->_aGetRegionArr($v['regions']);
$v['forbidregions'] = $this->_aGetRegionArr($v['forbidregions']);
}
unset($v);
return $list;
}
private function _resetAlbumDigest($albumid)
{
$option = new Ko_Tool_SQL();
$photolist = $this->photoDao->aGetList($option->oSelect('photoid')->oWhere('albumid = ?', $albumid)->oLimit(1000)->oOrderBy('sort desc, photoid desc'));
$count = count($photolist);
$step = max(1, floor($count / 50));
$total = min($count, 50 * $step);
$photoids = array();
for ($i = 0; $i < $total; $i += $step) {
$photoids[] = $photolist[$i]['photoid'];
}
$this->_setDigest($albumid, $photoids);
}
