📄 inc_freelist_view.php
字号:
$innertext = trim($this->ListObj->GetInnerText());
if(empty($innertext)) $innertext = GetSysTemplets("list_fulllist.htm");
$tablewidth=100;
if($col=="") $col=1;
$colWidth = ceil(100/$col);
$tablewidth = $tablewidth."%";
$colWidth = $colWidth."%";
//按不同情况设定SQL条件
$orwhere = " arc.arcrank > -1 And channel>-1 ";
$typeid = $this->ListObj->GetAtt('typeid');
$subday = $this->ListObj->GetAtt('subday');
$listtype = $this->ListObj->GetAtt('type');
$att = $this->ListObj->GetAtt('att');
$channelid = $this->ListObj->GetAtt('channel');
if(empty($channelid)) $channelid = 0;
//是否指定栏目条件
if(!empty($typeid)){
if($cfg_list_son=='N') $orwhere .= " And (arc.typeid='$typeid' or arc.typeid2='$typeid') ";
else $orwhere .= " And (".$this->TypeLink->GetSunID($typeid,"arc",$this->Fields['channeltype'])." Or arc.typeid2='$typeid') ";
}
//自定义属性条件
if($att!="") $orwhere .= "And arc.arcatt='$att' ";
//文档的频道模型
if($channelid>0 && !eregi("spec",$listtype)) $orwhere .= " And arc.channel = '$channelid' ";
//推荐文档 带缩略图 专题文档
if(eregi("commend",$listtype)) $orwhere .= " And arc.iscommend > 10 ";
if(eregi("image",$listtype)) $orwhere .= " And arc.litpic <> '' ";
if(eregi("spec",$listtype) || $channelid==-1) $orwhere .= " And arc.channel = -1 ";
if(!empty($subday)){
$starttime = time() - $subday;
$orwhere .= " And arc.senddate > $starttime ";
}
$keyword = $this->ListObj->GetAtt('keyword');
if(!empty($keyword)) $orwhere .= " And CONCAT(arc.title,arc.keywords) REGEXP '$keyword' ";
$orderby = $this->ListObj->GetAtt('orderby');
$orderWay = $this->ListObj->GetAtt('orderway');
//排序方式
$ordersql = "";
if($orderby=="senddate") $ordersql=" order by arc.senddate $orderWay";
else if($orderby=="pubdate") $ordersql=" order by arc.pubdate $orderWay";
else if($orderby=="id") $ordersql=" order by arc.ID $orderWay";
else if($orderby=="hot"||$orderby=="click") $ordersql = " order by arc.click $orderWay";
else if($orderby=="lastpost") $ordersql = " order by arc.lastpost $orderWay";
else if($orderby=="postnum") $ordersql = " order by arc.postnum $orderWay";
else if($orderby=="rand") $ordersql = " order by rand()";
else $ordersql=" order by arc.sortrank $orderWay";
//获得附加表的相关信息
//-----------------------------
$addField = "";
$addJoin = "";
if(is_object($this->ChannelUnit)){
$addtable = $this->ChannelUnit->ChannelInfos['addtable'];
if($addtable!=""){
$addJoin = " left join $addtable on arc.ID = ".$addtable.".aid ";
$addField = "";
$fields = explode(",",$this->ChannelUnit->ChannelInfos['listadd']);
foreach($fields as $k=>$v){ $nfields[$v] = $k; }
foreach($this->ChannelUnit->ChannelFields as $k=>$arr){
if(isset($nfields[$k])){
if($arr['rename']!="") $addField .= ",".$addtable.".".$k." as ".$arr['rename'];
else $addField .= ",".$addtable.".".$k;
}
}
}
}
//
//----------------------------
$query = "Select arc.ID,arc.title,arc.iscommend,arc.color,
arc.typeid,arc.ismake,arc.money,arc.description,arc.shorttitle,
arc.memberid,arc.writer,arc.postnum,arc.lastpost,
arc.pubdate,arc.senddate,arc.arcrank,arc.click,arc.litpic,
tp.typedir,tp.typename,tp.isdefault,tp.defaultname,
tp.namerule,tp.namerule2,tp.ispart,tp.moresite,tp.siteurl
$addField
from {$this->maintable} arc
left join #@__arctype tp on arc.typeid=tp.ID
$addJoin
where $orwhere $ordersql limit $limitstart,".$this->PageSize;
$this->dsql->SetQuery($query);
$this->dsql->Execute("al");
$artlist = "";
if($col>1) $artlist = "<table width='$tablewidth' border='0' cellspacing='0' cellpadding='0'>\r\n";
$indtp = new DedeTagParse();
$indtp->SetNameSpace("field","[","]");
$indtp->LoadSource($innertext);
$GLOBALS['autoindex'] = 0;
for($i=0;$i<$this->PageSize;$i++)
{
if($col>1) $artlist .= "<tr>\r\n";
for($j=0;$j<$col;$j++)
{
if($col>1) $artlist .= "<td width='$colWidth'>\r\n";
if($row = $this->dsql->GetArray("al"))
{
$GLOBALS['autoindex']++;
//处理一些特殊字段
$row['id'] = $row['ID'];
$row['arcurl'] = $this->GetArcUrl($row['id'],$row['typeid'],$row['senddate'],$row['title'],$row['ismake'],$row['arcrank'],$row['namerule'],$row['typedir'],$row['money']);
$row['typeurl'] = $this->GetListUrl($row['typeid'],$row['typedir'],$row['isdefault'],$row['defaultname'],$row['ispart'],$row['namerule2'],"abc");
if($ismake==0 && $GLOBALS['cfg_multi_site']=='Y'){
if($row["siteurl"]=="") $row["siteurl"] = $GLOBALS['cfg_mainsite'];
if(!eregi("^http://",$row['picname'])){
$row['litpic'] = $row['siteurl'].$row['litpic'];
$row['picname'] = $row['litpic'];
}
}
$row['description'] = cnw_left($row['description'],$infolen);
if($row['litpic']=="") $row['litpic'] = $GLOBALS['cfg_plus_dir']."/img/dfpic.gif";
$row['picname'] = $row['litpic'];
$row['info'] = $row['description'];
$row['filename'] = $row['arcurl'];
$row['stime'] = GetDateMK($row['pubdate']);
$row['textlink'] = "<a href='".$row['filename']."' title='".str_replace("'","",$row['title'])."'>".$row['title']."</a>";
$row['typelink'] = "<a href='".$row['typeurl']."'>[".$row['typename']."]</a>";
$row['imglink'] = "<a href='".$row['filename']."'><img src='".$row['picname']."' border='0' width='$imgwidth' height='$imgheight' alt='".str_replace("'","",$row['title'])."'></a>";
$row['image'] = "<img src='".$row['picname']."' border='0' width='$imgwidth' height='$imgheight' alt='".str_replace("'","",$row['title'])."'>";
$row['phpurl'] = $GLOBALS['cfg_plus_dir'];
$row['plusurl'] = $GLOBALS['cfg_plus_dir'];
$row['templeturl'] = $GLOBALS['cfg_templets_dir'];
$row['memberurl'] = $GLOBALS['cfg_member_dir'];
$row['title'] = cn_substr($row['title'],$titlelen);
if($row['color']!="") $row['title'] = "<font color='".$row['color']."'>".$row['title']."</font>";
if($row['iscommend']==5||$row['iscommend']==16) $row['title'] = "<b>".$row['title']."</b>";
//编译附加表里的数据
if(is_object($this->ChannelUnit)){
foreach($row as $k=>$v){
if(ereg("[A-Z]",$k)) $row[strtolower($k)] = $v;
}
foreach($this->ChannelUnit->ChannelFields as $k=>$arr){
if(isset($row[$k])) $row[$k] = $this->ChannelUnit->MakeField($k,$row[$k]);
}
}
//---------------------------
//解析单条记录
//-------------------------
if(is_array($indtp->CTags)){
foreach($indtp->CTags as $k=>$ctag){
$_f = $ctag->GetName();
if(isset($row[$_f])) $indtp->Assign($k,$row[$_f]);
else $indtp->Assign($k,"");
}
}
$artlist .= $indtp->GetResult();
}//if hasRow
else{
$artlist .= "";
}
if($col>1) $artlist .= " </td>\r\n";
}//Loop Col
if($col>1) $i += $col - 1;
if($col>1) $artlist .= " </tr>\r\n";
}//Loop Line
if($col>1) $artlist .= "</table>\r\n";
$this->dsql->FreeResult("al");
return $artlist;
}
//---------------------------------
//获取静态的分页列表
//---------------------------------
function GetPageListST($list_len,$listitem="info,index,end,pre,next,pageno")
{
$prepage="";
$nextpage="";
$prepagenum = $this->PageNo-1;
$nextpagenum = $this->PageNo+1;
if($list_len==""||ereg("[^0-9]",$list_len)) $list_len=3;
$totalpage = ceil($this->TotalResult/$this->PageSize);
if($totalpage<=1 && $this->TotalResult>0) return "共1页/".$this->TotalResult."条记录";
if($this->TotalResult == 0) return "共0页/".$this->TotalResult."条记录";
$maininfo = " 共{$totalpage}页/".$this->TotalResult."条记录 ";
$purl = $this->GetCurUrl();
$tnamerule = $this->GetMakeFileRule();
$tnamerule = ereg_replace('^(.*)/','',$tnamerule);
//获得上一页和主页的链接
if($this->PageNo != 1){
$prepage.="<a href='".str_replace("{page}",$prepagenum,$tnamerule)."'>上一页</a>\r\n";
$indexpage="<a href='".str_replace("{page}",1,$tnamerule)."'>首页</a>\r\n";
}else{ $indexpage="<a href='#'>首页</a>\r\n"; }
//下一页,未页的链接
if($this->PageNo!=$totalpage && $totalpage>1){
$nextpage.="<a href='".str_replace("{page}",$nextpagenum,$tnamerule)."'>下一页</a>\r\n";
$endpage="<a href='".str_replace("{page}",$totalpage,$tnamerule)."'>末页</a>\r\n";
}else{
$endpage="<a href='#'>末页</a>\r\n";
}
//option链接
$optionlen = strlen($totalpage);
$optionlen = $optionlen*20+18;
$optionlist = "<select name='sldd' style='width:$optionlen' onchange='location.href=this.options[this.selectedIndex].value;'>\r\n";
for($mjj=1;$mjj<=$totalpage;$mjj++){
if($mjj==$this->PageNo) $optionlist .= "<option value='".str_replace("{page}",$mjj,$tnamerule)."' selected>$mjj</option>\r\n";
else $optionlist .= "<option value='".str_replace("{page}",$mjj,$tnamerule)."'>$mjj</option>\r\n";
}
$optionlist .= "</select>";
//获得数字链接
$listdd="";
$total_list = $list_len * 2 + 1;
if($this->PageNo >= $total_list) {
$j = $this->PageNo-$list_len;
$total_list = $this->PageNo+$list_len;
if($total_list>$totalpage) $total_list=$totalpage;
}
else{
$j=1;
if($total_list>$totalpage) $total_list=$totalpage;
}
for($j;$j<=$total_list;$j++){
if($j==$this->PageNo) $listdd.= "<strong>{$j}</strong>\r\n";
else $listdd.="<a href='".str_replace("{page}",$j,$tnamerule)."'>".$j."</a>\r\n";
}
$plist = "";
if(eregi('info',$listitem)) $plist .= $maininfo.' ';
if(eregi('index',$listitem)) $plist .= $indexpage.' ';
if(eregi('pre',$listitem)) $plist .= $prepage.' ';
if(eregi('pageno',$listitem)) $plist .= $listdd.' ';
if(eregi('next',$listitem)) $plist .= $nextpage.' ';
if(eregi('end',$listitem)) $plist .= $endpage.' ';
if(eregi('option',$listitem)) $plist .= $optionlist;
return $plist;
}
//---------------------------------
//获取动态的分页列表
//---------------------------------
function GetPageListDM($list_len,$listitem="index,end,pre,next,pageno")
{
$prepage="";
$nextpage="";
$prepagenum = $this->PageNo-1;
$nextpagenum = $this->PageNo+1;
if($list_len==""||ereg("[^0-9]",$list_len)) $list_len=3;
$totalpage = ceil($this->TotalResult/$this->PageSize);
if($totalpage<=1 && $this->TotalResult>0) return "共1页/".$this->TotalResult."条记录";
if($this->TotalResult == 0) return "共0页/".$this->TotalResult."条记录";
$maininfo = "共{$totalpage}页/".$this->TotalResult."条记录";
$purl = $this->GetCurUrl();
$geturl = "lid=".$this->FreeID."&TotalResult=".$this->TotalResult."&";
$hidenform = "<input type='hidden' name='lid' value='".$this->FreeID."'>\r\n";
$hidenform .= "<input type='hidden' name='TotalResult' value='".$this->TotalResult."'>\r\n";
$purl .= "?".$geturl;
//获得上一页和下一页的链接
if($this->PageNo != 1){
$prepage.="<a href='".$purl."PageNo=$prepagenum'>上一页</a>\r\n";
$indexpage="<a href='".$purl."PageNo=1'>首页</a>\r\n";
}
else{
$indexpage="<a href='#'>首页</a>\r\n";
}
if($this->PageNo!=$totalpage && $totalpage>1){
$nextpage.="<a href='".$purl."PageNo=$nextpagenum'>下一页</a>\r\n";
$endpage="<a href='".$purl."PageNo=$totalpage'>末页</a>\r\n";
}
else{
$endpage="<a href='#'>末页</a>\r\n";
}
//获得数字链接
$listdd="";
$total_list = $list_len * 2 + 1;
if($this->PageNo >= $total_list) {
$j = $this->PageNo-$list_len;
$total_list = $this->PageNo+$list_len;
if($total_list>$totalpage) $total_list=$totalpage;
}else{
$j=1;
if($total_list>$totalpage) $total_list=$totalpage;
}
for($j;$j<=$total_list;$j++){
if($j==$this->PageNo) $listdd.= "<a href='#'>.$j.</a>\r\n";
else $listdd.="<a href='".$purl."PageNo=$j'>".$j."</a>\r\n";
}
$plist = "<form name='pagelist' action='".$this->GetCurUrl()."'>$hidenform";
$plist .= $maininfo.$indexpage.$prepage.$listdd.$nextpage.$endpage;
if($totalpage>$total_list){
$plist.="<input type='text' name='PageNo' value='".$this->PageNo."'>\r\n";
$plist.="<input type='submit' name='plistgo' value='GO' >\r\n";
}
$plist .= "</form>\r\n";
return $plist;
}
//--------------------------
//获得一个指定的频道的链接
//--------------------------
function GetListUrl($typeid,$typedir,$isdefault,$defaultname,$ispart,$namerule2,$siteurl=""){
return GetTypeUrl($typeid,MfTypedir($typedir),$isdefault,$defaultname,$ispart,$namerule2,$siteurl);
}
//--------------------------
//获得一个指定档案的链接
//--------------------------
function GetArcUrl($aid,$typeid,$timetag,$title,$ismake=0,$rank=0,$namerule="",$artdir="",$money=0){
return GetFileUrl($aid,$typeid,$timetag,$title,$ismake,$rank,$namerule,$artdir,$money);
}
//---------------
//获得当前的页面文件的url
//----------------
function GetCurUrl()
{
if(!empty($_SERVER["REQUEST_URI"])){
$nowurl = $_SERVER["REQUEST_URI"];
$nowurls = explode("?",$nowurl);
$nowurl = $nowurls[0];
}else{ $nowurl = $_SERVER["PHP_SELF"]; }
return $nowurl;
}
}//End Class
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -