我们有的时候需要在列表页调用搜索最多的文章列表,做一个展示,此时需要做下二次开发。打开织梦/include/extend.func.php 最后加上以下代码:
//列表页获取网友热搜 24小时 function jjGetHotSearch($tid){ global $dsql; $time = time() - 86400; $sql = "select * from dede_archives where typeid = '$tid' and shorttitle <> '' group by shorttitle order by pubdate desc limit 10"; $dsql->Execute('me',$sql); $li = ''; while($arr = $dsql->GetArray('me')) { if($arr['pubdate'] >$time ){ $class = 'new'; }else{ $class = ''; } $barr = GetOneArchive($arr['id']); $arcurl = $barr['arcurl']; $li .= '<li><span class="right"><time class="'.$class.'">'.date('Y-m-d',$arr['pubdate']).'</time></span><a href="'.$arcurl.'" title="'.$arr['shorttitle'].'">'.$arr['shorttitle'].'</a></li>'; } return $li; } //排行榜获取网友热搜 3天 function hot_3_GetHotSearch($tid){ global $dsql; $time = time() - 86400; $sql = "select * from dede_archives where pubdate > UNIX_TIMESTAMP( CURDATE( ) - INTERVAL 3 day) and typeid = '$tid' and shorttitle <> '' group by shorttitle order by click desc limit 10"; $dsql->Execute('me',$sql); $li = ''; while($arr = $dsql->GetArray('me')) { if($arr['pubdate'] >$time ){ $class = 'new'; }else{ $class = ''; } $barr = GetOneArchive($arr['id']); $arcurl = $barr['arcurl']; $li .= '<li><span class="right"><time class="'.$class.'">'.date('Y-m-d',$arr['pubdate']).'</time></span><a href="'.$arcurl.'" title="'.$arr['shorttitle'].'">'.$arr['shorttitle'].'</a></li>'; } return $li; } //排行榜获取网友热搜 7天 function hot_7_GetHotSearch($tid){ global $dsql; $time = time() - 86400; $sql = "select * from dede_archives where pubdate > UNIX_TIMESTAMP( CURDATE( ) - INTERVAL 7 day) and typeid = '$tid' and shorttitle <> '' group by shorttitle order by click desc limit 10"; $dsql->Execute('me',$sql); $li = ''; while($arr = $dsql->GetArray('me')) { if($arr['pubdate'] >$time ){ $class = 'new'; }else{ $class = ''; } $barr = GetOneArchive($arr['id']); $arcurl = $barr['arcurl']; $li .= '<li><span class="right"><time class="'.$class.'">'.date('Y-m-d',$arr['pubdate']).'</time></span><a href="'.$arcurl.'" title="'.$arr['shorttitle'].'">'.$arr['shorttitle'].'</a></li>'; } return $li; } //排行榜获取网友热搜 30天 function hot_30_GetHotSearch($tid){ global $dsql; $time = time() - 86400; $sql = "select * from dede_archives where pubdate > UNIX_TIMESTAMP( CURDATE( ) - INTERVAL 30 day) and typeid = '$tid' and shorttitle <> '' group by shorttitle order by click desc limit 10"; $dsql->Execute('me',$sql); $li = ''; while($arr = $dsql->GetArray('me')) { if($arr['pubdate'] >$time ){ $class = 'new'; }else{ $class = ''; } $barr = GetOneArchive($arr['id']); $arcurl = $barr['arcurl']; $li .= '<li><span class="right"><time class="'.$class.'">'.date('Y-m-d',$arr['pubdate']).'</time></span><a href="'.$arcurl.'" title="'.$arr['shorttitle'].'">'.$arr['shorttitle'].'</a></li>'; } return $li; } //列表页获取栏目关注 30天 14条 function hotword_30_GetHotSearch($tid){ global $dsql; $time = time() - 86400; $sql = "select * from dede_archives where pubdate > UNIX_TIMESTAMP( CURDATE( ) - INTERVAL 90 day) and typeid = '$tid' and shorttitle <> '' group by shorttitle order by click desc limit 14"; $dsql->Execute('me',$sql); $li = ''; while($arr = $dsql->GetArray('me')) { if($arr['pubdate'] >$time ){ $class = 'new'; }else{ $class = ''; } $barr = GetOneArchive($arr['id']); $arcurl = $barr['arcurl']; $li .= '<a href="'.$arcurl.'" title="'.$arr['shorttitle'].'">'.$arr['shorttitle'].'</a>'; } return $li; }
调用方法代码:
{dede:field.id function=jjGetHotSearch(@me)/}
评论前必须登录!
注册