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); }