织梦获取当前栏目及所有子栏目的文章数量

返回符合记录的文章数量* @description DEDE不允许执行子查询，解决栏目下文章统计的问题* @param $level 为真时查询所有子类目www.dede58.com织梦模板下载* */function getTotalArcByTID($tID,$level=TRUE) {global $dsql;$level==TRUE && $tID = GetSonTypeID($tID);$sql = "SELECT count(ID) as total from `dede_archives` where typeID in($tID)";$result = $dsql->Getone($sql);return $result['total'];}/** 递归获取符合条件的子栏目* @param $tID 栏目ID* @return string* */function GetSonTypeID($tID){global $dsql;$dsql->Setquery("Select ID From `dede_arctype` where reID in($tID) And ishIDden<>1 order by sortrank");$dsql->Execute($tID);$typeID = '';while($row=$dsql->Getobject($tID)){$typeID .= "{$row->ID},";$typeID .= GetSonTypeID($row->ID);}return trim($typeID,',');}