ecshop调用指定分类下精品产品列表

ecshop调用指定分类下精品产品列表

首先声明

/**

* 获得cat_id精品列表。

*

* @access private

* @param integer

* @return array

*/

function index_get_cat_id_goods_best_list($cat_id, $num)

{

$sql = 'Select g.goods_id, g.goods_name, g.goods_name_style, g.market_price, g.shop_price, g.promote_price, ' .

"promote_start_date, promote_end_date, g.goods_brief, g.goods_thumb, goods_img, " .

"g.is_best, g.is_new, g.is_hot, g.is_promote " .

'FROM ' . $GLOBALS['ecs']->table('goods') . ' AS g ' .

"Where g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND g.is_best = 1 AND g.cat_id = '$cat_id'".

" LIMIT $num";

$res = $GLOBALS['db']->getAll($sql);

$goods = array();

foreach ($res AS $idx => $row)

{

$goods[$idx]['id'] = $row['article_id'];

$goods[$idx]['id'] = $row['goods_id'];

$goods[$idx]['name'] = $row['goods_name'];

$goods[$idx]['brief'] = $row['goods_brief'];

$goods[$idx]['brand_name'] = $row['brand_name'];

$goods[$idx]['goods_style_name'] = add_style($row['goods_name'],$row['goods_name_style']);

$goods[$idx]['short_name'] = $GLOBALS['_CFG']['goods_name_length'] > 0 ?

sub_str($row['goods_name'], $GLOBALS['_CFG']['goods_name_length']) : $row['goods_name'];

$goods[$idx]['short_style_name'] = add_style($goods[$idx]['short_name'],$row['goods_name_style']);

$goods[$idx]['market_price'] = price_format($row['market_price']);

$goods[$idx]['shop_price'] = price_format($row['shop_price']);

$goods[$idx]['thumb'] = empty($row['goods_thumb']) ? $GLOBALS['_CFG']['no_picture'] : $row['goods_thumb'];

$goods[$idx]['goods_img'] = empty($row['goods_img']) ? $GLOBALS['_CFG']['no_picture'] : $row['goods_img'];

$goods[$idx]['url'] = build_uri('goods', array('gid' => $row['goods_id']), $row['goods_name']);

}

return $goods;

}

声明后用$smarty调用

$smarty->assign('cat_id2_best_goods', index_get_cat_id_goods_best_list(2,4));

//2指分类id，4指循环次数

然后就可以在dwt模板文件里开始调用了

具体调用方法有两种,因为产品调用要是先js调用的效果的话,就是有H和V两种,图片价格和文字标题两种.

如果是横向调用4个产品,带图片价格等.可以这样写

{$goods.short_name|truncate:7:true}

{$goods.shop_price}

如果需要调用纵向标题列表的话只需要把item=goods修改成item=list,然后删掉不需要的调用代码即可

其实横向纵向的排列方式在模板文件里修改也可以,但方法都一样,就是在css里修改.加个float:left即可.