//修改后的信息統計。$day參數11表示本年1月，12表示本年二月，...，22表示本年12月 function user_TotalData1($classid,$enews=0,$day=0,$totaltype=0){ global $empire,$class_r,$class_zr,$dbtbpre,$fun_r,$class_tr; if(empty($classid)) { return ""; } //統計類型 if($totaltype==1)//評論數 { $totalfield='sum(plnum) as total'; } elseif($totaltype==2)//點擊數 { $totalfield='sum(onclick) as total'; } elseif($totaltype==3)//下載數 { $totalfield='sum(totaldown) as total'; } else//信息數 { $totalfield='count(*) as total'; } if($day) { if($day==1)//今日信息 { $date=date("Y-m-d"); $starttime=$date." 00:00:01"; $endtime=$date." 23:59:59"; } elseif($day==2)//本月信息 { $date=date("Y-m"); $starttime=$date."-01 00:00:01"; $endtime=$date."-".date("t")." 23:59:59"; } elseif($day==3)//本年信息 { $date=date("Y"); $starttime=$date."-01-01 00:00:01"; $endtime=($date+1)."-01-01 00:00:01"; } elseif($day>10)//本年某月信息 { $yue=$day-10; $date=date("Y"); $starttime=$date."-".$yue."-01 00:00:01"; if($yue==12){$endtime=$date."-".$yue."-31 23:59:59";}else{$endtime=$date."-".($yue+1)."-01 00:00:01";} } $and=" and newstime>=".to_time($starttime)." and newstime<=".to_time($endtime); } if($enews==1)//統計標題分類 { if(empty($class_tr[$classid][tbname])) { echo $fun_r['BqErrorTtid']."=<b>".$classid."</b>".$fun_r['BqErrorNtb']; return ""; } $query="select ".$totalfield." from {$dbtbpre}ecms_".$class_tr[$classid][tbname]." where ttid='$classid'".$and; } elseif($enews==2)//統計數據表 { $query="select ".$totalfield." from {$dbtbpre}ecms_".$classid.(empty($and)?'':' where '.substr($and,5)); } else//統計欄目數據 { if(empty($class_r[$classid][tbname])) { echo $fun_r['BqErrorCid']."=<b>".$classid."</b>".$fun_r['BqErrorNtb']; return ""; } if($class_r[$classid][islast])//終極欄目 { $where="classid='$classid'"; } else//大欄目 { $where=ReturnClass($class_r[$classid][sonclass]); } $query="select ".$totalfield." from {$dbtbpre}ecms_".$class_r[$classid][tbname]." where ".$where.$and; } $num=$empire->gettotal($query); echo $num; } ?> |
新聞熱點
疑難解答
