### [dedecms织梦tag keyword怎么调用相关文章](https://www.prosaas.cn/article/7464) **Published:** 2019-12-16T01:50:02 **Author:** 5201314 **Excerpt:** dedecms织梦tag keyword怎么调用相关文章?DEDE官方的dede:likearticle是利用… **** **dedecms织梦tag keyword怎么调用相关文章?** DEDE官方的dede:likearticle是利用文章中输入的关键词或者自动分词形成的关键词来关联文章,但是有时候自动生成的关键词并不精确,造成关联不准,这里我们通过自定义一个类库文件来实现精准获取相关文章 推荐学习:织梦cms 可以单用tag来调用相关文章,也可用tag+keyword来调用相关文章(默认tag优先于keyword,可以自己排序) 在 \\include\\taglib\\ 下添加一个liketags.lib.php 代码如下 CAttribute->Items,$attlist); extract($ctag->CAttribute->Items, EXTR\_SKIP); $revalue = ''; if(empty($tablewidth)) $tablewidth = 100; if(empty($col)) $col = 1; $colWidth = ceil(100/$col); $tablewidth = $tablewidth."%"; $colWidth = $colWidth."%"; $orwheres = ''; if($flag != '') { $flags = explode(',', $flag); for($i=0; isset($flags\[$i\]); $i++) $orwheres .= " AND FIND\_IN\_SET('{$flags\[$i\]}', arc.flag)>0 "; } $ids = array(); $tids = array(); if(!empty($refObj->Fields\['tags'\])) { $keyword = $refObj->Fields\['tags'\]; } else { $keyword = ( !empty($refObj->Fields\['keywords'\]) ? $refObj->Fields\['keywords'\] : '' ); } $typeid = ( !empty($mytypeid) ? $mytypeid : 0 ); if(empty($typeid)) { if(!empty($refObj->Typelink->TypeInfos\['reid'\])) { $typeid = $refObj->Typelink->TypeInfos\['reid'\]; } else { if(!empty($refObj->Fields\['typeid'\])) $typeid = $refObj->Fields\['typeid'\]; } } if( !empty($typeid) && !preg\_match('#,#', $typeid) ) { $typeid = GetSonIds($typeid); } if(!empty($refObj->Fields\['tags'\]) && $eregtype != 'keyword' ) { $tags = explode(',', addslashes($refObj->Fields\['tags'\])); $getsql = " tag like '".join("' OR tag like '", $tags)."' "; $dsql->Execute('me', "Select \* From \`dede\_tagindex\` where $getsql "); while($arow = $dsql->GetArray('me')) { $tids\[\] = $arow\['id'\]; } $tid = join(',', $tids); if($tid!='') { 061 $dsql->Execute("me", "Select aid From \`dede\_taglist\` where tid in($tid) And arcrank > -1 group by aid order by aid desc"); while($arow = $dsql->GetArray("me")) { $ids\[\] = $arow\['aid'\]; $arcid = $refObj->Fields\['aid'\]; } } } if($eregtype == 'tag' && count($ids) == 0 ) { return; } else { if(count($ids) > 0) { if(!empty($typeid)) { $typeid = " And arc.typeid in($typeid) And arc.id<>$arcid "; } $idsStr = join(',', $ids); $query = "Select arc.\*,tp.typedir,tp.typename,tp.corank,tp.isdefault,tp.defaultname,tp.namerule, tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath from \`dede\_archives\` arc left join \`dede\_arctype\` tp on arc.typeid=tp.id where arc.arcrank>-1 and arc.id in($idsStr) $typeid order by arc.id desc limit 0, $row"; } else { $limitRow = $row - count($ids); $keyword = ''; if(!empty($refObj->Fields\['keywords'\])) { $keywords = explode(',' , trim($refObj->Fields\['keywords'\])); $keyword = ''; $n = 1; foreach($keywords as $k) { if($n > 3) break; if(trim($k)=='') continue; else $k = addslashes($k); $keyword .= ($keyword=='' ? " CONCAT(arc.keywords,' ',arc.title) like '%$k%' " : " OR CONCAT(arc.keywords,' ',arc.title) like '%$k%' "); $n++; } } $arcid = (!empty($refObj->Fields\['id'\]) ? $refObj->Fields\['aid'\] : 0); if( empty($arcid) || $byabs==0 ) { $orderquery = " order by arc.id desc "; } else { $orderquery = " order by ABS(arc.id - ".$arcid.") "; } if($keyword != '') { if(!empty($typeid)) { $typeid = " And arc.typeid in($typeid) And arc.id<>$arcid "; } $query = "Select arc.\*,tp.typedir,tp.typename,tp.corank,tp.isdefault,tp.defaultname,tp.namerule, tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath from \`dede\_archives\` arc left join \`dede\_arctype\` tp on arc.typeid=tp.id where arc.arcrank>-1 and ($keyword) $typeid $orderquery limit 0, $row"; } else { if(!empty($typeid)) { $typeid = " arc.typeid in($typeid) And arc.id<>$arcid "; } $query = "Select arc.\*,tp.typedir,tp.typename,tp.corank,tp.isdefault,tp.defaultname,tp.namerule, tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath from \`dede\_archives\` arc left join \`dede\_arctype\` tp on arc.typeid=tp.id where arc.arcrank>-1 and $typeid $orderquery limit 0, $row"; } } } $innertext = trim( $ctag->GetInnerText() ); if($innertext=='') $innertext = GetSysTemplets('part\_arclist.htm'); $dsql->SetQuery($query); $dsql->Execute('al'); $artlist = ''; if($col > 1){ $artlist = "
| \\r\\n";
if($row = $dsql->GetArray("al"))
{
$ids\[\] = $row\['id'\];
//处理一些特殊字段
$row\['info'\] = $row\['infos'\] = cn\_substr($row\['description'\],$infolen);
$row\['id'\] = $row\['id'\];
if($row\['corank'\] > 0 && $row\['arcrank'\]==0)
{
$row\['arcrank'\] = $row\['corank'\];
}
$row\['filename'\] = $row\['arcurl'\] = GetFileUrl($row\['id'\],$row\['typeid'\],$row\['senddate'\],$row\['title'\],$row\['ismake'\],
$row\['arcrank'\],$row\['namerule'\],$row\['typedir'\],$row\['money'\],$row\['filename'\],$row\['moresite'\],$row\['siteurl'\],$row\['sitepath'\]);
$row\['typeurl'\] = GetTypeUrl($row\['typeid'\],$row\['typedir'\],$row\['isdefault'\],$row\['defaultname'\],$row\['ispart'\],
$row\['namerule'\],$row\['moresite'\],$row\['siteurl'\],$row\['sitepath'\]);
if($row\['litpic'\] == '-' || $row\['litpic'\] == '')
{
$row\['litpic'\] = $GLOBALS\['cfg\_cmspath'\].'/images/defaultpic.gif';
}
if(!preg\_match("#^http:\\/\\/#i", $row\['litpic'\]) && $GLOBALS\['cfg\_multi\_site'\] == 'Y')
{
$row\['litpic'\] = $GLOBALS\['cfg\_mainsite'\].$row\['litpic'\];
}
$row\['picname'\] = $row\['litpic'\];
$row\['stime'\] = GetDateMK($row\['pubdate'\]);
$row\['typelink'\] = "".$row\['typename'\]."";
$row\['image'\] = " | \\r\\n";
}
//Loop Col
if($col>1) $i += $col - 1;
if($col>1) $artlist .= "
\[field:title/\]