$cateList.=' <li class="lev1"><a href="#" class="year">'.$year.' ('.$intCount.')</a></li>';
}
//循环今年
for($i=$month;$i>0;$i--){
if (strlen($i)==1){
$strSearch= $year . '-0' . $i;
}else{
$strSearch= $year . '-' . $i;
}
switch ($i) {
case 1:
$strMonth='一月';
break;
case 2:
$strMonth='二月';
break;
case 3:
$strMonth='三月';
break;
case 4:
$strMonth='四月';
break;
case 5:
$strMonth='五月';
break;
case 6:
$strMonth='六月';
break;
case 7:
$strMonth='七月';
break;
case 8:
$strMonth='八月';
break;
case 9:
$strMonth='九月';
break;
case 10:
$strMonth='十月';
break;
case 11:
$strMonth='十一月';
break;
case 12:
$strMonth='十二月';
break;
}
$SqlStr = 'SELECT COUNT( * ) from `'.DB_TABLE_PRE.'article` WHERE DATE_FORMAT(`posttime`, '%Y-%m')=''.$strSearch.''';
//栏目
$SqlStr.=$this->SqlCateId;
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query () ) {
$DB_Record = $MyDatabase->ResultArr [0];
$intCount = $DB_Record[0];
if($intCount>0){
$cateList.=' <li class="lev2"><a href="#" class="year">'.$strMonth.' ('.$intCount.')</a></li>';
}
}
}
//最近9年循环
for($i=$year-1;$i>$year-10;$i--){
$SqlStr = 'SELECT COUNT( * ) from `'.DB_TABLE_PRE.'article` WHERE DATE_FORMAT(`posttime`, '%Y')=''.$i.''';
//栏目
$SqlStr.=$this->SqlCateId;
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query () ) {
$DB_Record = $MyDatabase->ResultArr [0];
$intCount = $DB_Record[0];
if($intCount>0){
$cateList.=' <li class="lev1"><a href="#" class="year">'.$i.' ('.$intCount.')</a></li>';
}
}
}
return $cateList;
}
/**
* 根据上级栏目编号， 返回栏目标题列表。
*
* @param 上级编号 $parentid
*
*/
function getTitleListByCateId($parentid){
$CateTitleList='';
//-------------------0------1------2
$SqlStr = 'SELECT `title`, `id`, `url` FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE parentid=' . $parentid;
$SqlStr.= ' ORDER BY `level` ASC;';
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$DB_Record_Arr = $MyDatabase->ResultArr;
foreach ( $DB_Record_Arr as $DB_Record ) {
if($DB_Record[2]==''){
$CateTitleList.= '<a href="article.php?id='.$DB_Record[1].'">'.$DB_Record[0].'</a> ';
}else{
$CateTitleList.= '<a href="'.$DB_Record[2].'?id='.$DB_Record[1].'">'.$DB_Record[0].'</a> ';
}
}
}
return $CateTitleList;
}
/**
* 根据栏目编号， 返回栏目文章图文列表。
* @param $cateid 上级编号
* @param $limit 显示条数
* @param $prev 前置标记
*/
function getArticlePicListByCateId($cateid, $limit, $prev=''){
