这篇文章主要介绍了ECSHOP模版系统Assign和Include模版标签介绍,需要的朋友可以参考下......
ecshop显示商品按月统计销售数量
来源：互联网
2023-03-14 12:48:49 210
复制代码代码如下:$smarty->assign('goods_count', get_goods_coun($goods_id)); ， 最后在模板文件goods.dwt中 {$goods_count} 直接调用就行了。复制代码代码如下:/*** 获取商品出售总数** @access public* @param integer $goods_id* @return integer*/function get_goods_count($goods_id){/* 统计时间段$period = intval($GLOBALS['_CFG']['top10_time']);if ($period == 1) // 一年{$ext = "AND o.add_time >'" . local_strtotime('-1 years') . "'";}elseif ($period == 2) // 半年{$ext = "AND o.add_time > '" . local_strtotime(‘-6 months’) . "'";}elseif ($period == 3) // 三个月{$ext = " AND o.add_time > '" . local_strtotime('-3 months’) . "'";}elseif ($period == 4) // 一个月{$ext = " AND o.add_time > '" . local_strtotime('-1 months') . "'";}else{$ext = '';}*//* 查询该商品销量 */$sql = 'SELECT IFNULL(SUM(g.goods_number), 0) ' .'FROM ' . $GLOBALS['ecs']->table('order_info') . 'AS o, ' .$GLOBALS['ecs']->table('order_goods') . 'AS g ' ."WHERE o.order_id = g.order_id " ."AND o.order_status = '" . OS_CONFIRMED . "'" ."AND o.shipping_status " . db_create_in(array(SS_SHIPPED, SS_RECEIVED)) ." AND o.pay_status " . db_create_in(array(PS_PAYED, PS_PAYING)) ." AND g.goods_id = '$goods_id'";$sales_count = $GLOBALS['db']->getOne($sql);return $sales_count;}去掉注释调用指定时间段内。
以上方法由办公区教程网编辑摘抄整理自互联网可供大家参考！
标签：
相关文章