DedeCMS列表页获取热搜排行榜文章的方法
有的时候需要在列表页调用搜索最多的文章列表，做一个展示，此时需要做下二次开发。
打开织梦/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)/}
其他函数调用方法类似。
