在栏目页调用下属所有产品的销售总量、点击总数和评价积分

2016-07-07 15:04 来源：www.chinab4c.com 作者：ecshop专家



哈哈，谁要？

  2. /**
  3. * 取得商品销售总量
  4. *
  5. * @paramstring$cat_id 栏目ID
  6. *
  7. * @return销售总量
  8. */
  9. function get_catgoods_buy_sum($cat_id)
  10. {
  11. $sql = "SELECT sum(o.goods_number) as num FROM " . $GLOBALS['ecs']->table('order_goods') . " AS o RIGHT JOIN " . $GLOBALS['ecs']->table('goods') . " AS g on g.goods_id=o.goods_id WHERE g.cat_id =".$cat_id ." or g.cat_id in (SELECT c.cat_id FROM " . $GLOBALS['ecs']->table('category') . " AS c WHERE c.parent_id =".$cat_id .")";
  12. return $GLOBALS['db']->getOne($sql);
  13. }
  14. /**
  15. * 取得本栏目所有商品浏览总量
  16. *
  17. * @paramstring$cat_id 栏目ID
  18. *
  19. * @return浏览总量
  20. */
  21. function get_catgoods_click_sum($cat_id)
  22. {
  23. $sql = "SELECT sum(g.click_count) as num FROM " . $GLOBALS['ecs']->table('goods') . " AS g WHERE g.cat_id =".$cat_id ." or g.cat_id in (SELECT c.cat_id FROM " . $GLOBALS['ecs']->table('category') . " AS c WHERE c.parent_id =".$cat_id .")";
  24. return $GLOBALS['db']->getOne($sql);
  25. }
  26. /**
  27. * 取得本栏目所有商品评价总分
  28. *
  29. * @paramstring$cat_id 栏目ID
  30. *
  31. * @return评价总分
  32. */
  33. function get_catgoods_comment_sum($cat_id)
  34. {
  35. $sql = "SELECT sum(c.comment_rank) as num FROM " . $GLOBALS['ecs']->table('comment') . " AS c RIGHT JOIN " . $GLOBALS['ecs']->table('goods') . " AS g on g.goods_id=c.id_value WHERE g.cat_id =".$cat_id ." or g.cat_id in (SELECT cat.cat_id FROM " . $GLOBALS['ecs']->table('category') . " AS cat WHERE cat.parent_id =".$cat_id .")";
  36. return $GLOBALS['db']->getOne($sql);
  37. }
复制代码

回答：
支持共享

多谢楼主分享啊呵呵

好东西，支持了

如何调用呢？

上楼。接住。是这三个


goods_number
click_count
comment_rank