首页要调用商品描述

到论坛上找了半天，都说首页要调用商品描述只要改模板就行了
使用{$goods.goods_brief}这个标签就能调用
但是这个要看具体模块的
以我的为例，我要在销售排行里面调用简单描述
index.php文件里有这样一句代码，这是调用销售排行的函数
$smarty->assign('top_goods', get_top10()); // 销售排行
而这个函数在includes/lib_goods.php文件里
找到这个函数
/**
* 调用当前分类的销售排行榜
*
* @access public
* @param string $cats 查询的分类
* @return array
*/
function get_top10($cats = '')
{
$where = !empty($cats) ? "AND ($cats OR " . get_extension_goods($cats) . ") " : '';
/* 排行统计的时间 */
switch ($GLOBALS['_CFG']['top10_time'])
{
case 1: // 一年
$top10_time = "AND o.order_sn >= '" . date('Ymd', gmtime() - 365 * 86400) . "'";
break;
case 2: // 半年
$top10_time = "AND o.order_sn >= '" . date('Ymd', gmtime() - 180 * 86400) . "'";
break;
case 3: // 三个月
$top10_time = "AND o.order_sn >= '" . date('Ymd', gmtime() - 90 * 86400) . "'";
break;
case 4: // 一个月
$top10_time = "AND o.order_sn >= '" . date('Ymd', gmtime() - 30 * 86400) . "'";
break;
default:
$top10_time = '';
}
$sql = 'SELECT g.goods_id, g.goods_name, g.goods_brief, g.goods_img, SUM(og.goods_number) as goods_number ' .
'FROM ' . $GLOBALS['ecs']->table('goods') . ' AS g, ' .
$GLOBALS['ecs']->table('order_info') . ' AS o, ' .
$GLOBALS['ecs']->table('order_goods') . ' AS og ' .
"WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 $where $top10_time " ;
//判断是否启用库存，库存数量是否大于0
if ($GLOBALS['_CFG']['use_storage'] == 1)
{
$sql .= " AND g.goods_number > 0 ";
}
$sql .= ' AND og.order_id = o.order_id AND og.goods_id = g.goods_id ' .
"AND o.order_status = '" . OS_CONFIRMED . "' " .
"AND (o.pay_status = '" . PS_PAYED . "' OR o.pay_status = '" . PS_PAYING . "') " .
"AND (o.shipping_status = '" . SS_SHIPPED . "' OR o.shipping_status = '" . SS_RECEIVED . "') " .
'GROUP BY g.goods_id ORDER BY goods_number DESC, g.goods_id DESC LIMIT ' . $GLOBALS['_CFG']['top_number'];
$arr = $GLOBALS['db']->getAll($sql);
for ($i = 0, $count = count($arr); $i < $count; $i++)
{
$arr[$i]['short_name'] = $GLOBALS['_CFG']['goods_name_length'] > 0 ?
sub_str($arr[$i]['goods_name'], $GLOBALS['_CFG']['goods_name_length']) : $arr[$i]['goods_name'];
$arr[$i]['url'] = build_uri('goods', array('gid' => $arr[$i]['goods_id']), $arr[$i]['goods_name']);
$arr[$i]['goods_img'] = get_image_path($arr[$i]['goods_id'], $arr[$i]['goods_img']);

$arr[$row['goods_id']]['goods_brief'] = $row['goods_brief'];
}
return $arr;
}

注：红色部分是我加上去的，这是为了调用数据库里的简单描述到这个模块来
然后接下来的就简单了，在销售排行的模板文件top10.lbi里面加入标签就行
我的是这样的<span>{$goods.goods_brief}</span>
也就是调用这个标签来显示简单商品描述

刪除訂購金額

update語法的好用之處就在這裡

UPDATE ecs_order_info SET discount = '';
UPDATE ecs_order_info SET goods_amount = '';
UPDATE ecs_order_info SET order_amount = '';
UPDATE ecs_order_info SET pay_fee = '';
UPDATE ecs_order_info SET pack_fee = '';
UPDATE ecs_order_info SET insure_fee = '';
UPDATE ecs_order_info SET shipping_fee = '';
UPDATE ecs_order_info SET tax = '';
UPDATE ecs_order_info SET card_fee = '';

機歪健保局

11257

004

4595737031476198

越來越討厭國家了= ="