ECSHOP商品分类商品调用关联文章方法

2016-06-13 13:05 来源：www.chinab4c.com 作者：ecshop专家

**  * 获得指定分类下所有商品的关联文章  * sun04zh3-20130321  * @access  public  * @param   integer     $cat_id  * @return  array  */ function get_category_linked_articles($cat_id) {  $sql = 'SELECT a.article_id, a.title, a.file_url,   a.open_type, a.add_time ' . 'FROM ' . $GLOBALS['ecs']->table('goods_article') . ' AS ga, ' . $GLOBALS['ecs']->table('article') . ' AS a, ' . $GLOBALS['ecs']->table('goods').' AS g '. "WHERE ga.article_id = a.article_id AND  ".get_children($cat_id).  " AND a.is_open = 1 and ga.goods_id = g.goods_id " . 'ORDER BY a.add_time DESC'; $res = $GLOBALS['db']->query($sql); $arr = array(); while ($row = $GLOBALS['db']->fetchRow($res)) { $row['url']= $row['open_type'] != 1 ?  build_uri('article', array('aid'=>$row['article_id']), $row['title'])   : trim($row['file_url']); $row['add_time']    = local_date($GLOBALS['_CFG']['date_format'],  $row['add_time']); $row['short_title'] = $GLOBALS['_CFG']['article_title_length'] > 0 ? sub_str($row['title'], $GLOBALS['_CFG'] ['article_title_length']) : $row['title']; $arr[] = $row;     }     return $arr; } category.dwt模版页调用：

  • {$jnclist.title}
    • category.php对应程序页调用： $smarty->assign('article_list',     get_category_linked_articles(8));