private function updateCatelog($cate_id) { $dir = WEBPATH . '/' . $this->app; if (!is_dir($dir)) { mkdir($dir, 0777, true); } $cate = getCategory($cate_id); if (empty($cate)) { exit("不存在的分类"); } if ($cate['fid'] == 0) { $level = 'fid'; } else { $level = $cid; } $c = getContentCount($this->app, $cate_id, 'fid'); $pager = new Swoole\Pager(array('total' => $c, 'perpage' => $this->swoole->config->cms['pagesize'])); for ($i = 1; $i <= $pager->totalpage; $i++) { $html = getHtmlList($this->app, $cate_id, $i, $level); $filename = $dir . '/list_' . $cate_id . '_' . $i . '.html'; file_put_contents($filename, $html); } }
function getContentCount($cat_id, &$total, $inDB){ $sql = "SELECT c.*, IFNULL(COUNT(i.id), 0) as content_count FROM cms_uc_cats c LEFT JOIN cms_uc_items i ON i.category_id = c.id AND i.published = 1 WHERE (c.parent_id = {$cat_id}) AND c.published = 1 GROUP BY i.category_id ORDER BY c.title"; $result = $inDB->query($sql); if ( !$inDB->num_rows($result)>0 ){ return ''; } while($cat = $inDB->fetch_assoc($result)){ $total += $cat['content_count']; getContentCount($cat['id'], $total, $inDB); } return ; }