PHP群:95885625 Hbuilder+MUI群:81989597 站长QQ:634381967
    您现在的位置: 首页 > CMS教程 > ecshop教程 > 正文

    ecshop商品详细页显示已售商品数量和评论数量

    作者:admin来源:网络浏览:时间:2020-09-30 00:07:50我要评论
    导读:1.在ecshop程序goods.php页面最下面加入这两个函数function get_buy_sum($goods_id){ $sql = 'SELECT IFNULL(SUM(g.goods_number)...
    1.在ecshop程序goods.php页面最下面加入这两个函数
    function get_buy_sum($goods_id)
    {
        $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'";
        return $GLOBALS['db']->getOne($sql);
    }

    function get_comment_num($goods_id)  {
         $sql= "select count(*)  from ".$GLOBALS['ecs']->table('comment')." where id_value='".$goods_id."'  AND status = 1";
         return $GLOBALS['db']->getOne($sql);
    }

    2.在ecshop程序goods.php中加入


    $smarty->assign('buy_num',get_buy_sum($goods_id));

    $smarty->assign('comment_num',get_comment_num($goods_id));

    在$smarty->display('goods.dwt',      $cache_id);之前哈!

    3.ecshop中goods.dwt模板中加这个,大概在221行
      <!-- {if $buy_num} 已出售量-->
           <li class="clearfix">
             <dd>
              <strong>累计售出:</strong>{$buy_num}
             </dd>
           </li>
      <!--{/if}-->
      <!-- {if $comment_num} 评论数量-->
             <li class="clearfix">
             <dd>
              <strong>评论数量:</strong><a href="#comment">{$comment_num}</a>
             </dd>
           </li>
      <!--{/if}-->
    转载请注明(B5教程网)原文链接:https://b5.mxunkeji.com/content-104-2011-1.html
    相关热词搜索: