vape_shop/app/index/controller/Index.php

<?php

namespace app\index\controller;

use app\index\model\Article as ArticleModel;
use app\index\model\Comment as CommentModel;
use app\index\model\Goods as GoodsModel;

/**
 * 默认控制器
 * Class Index
 * @package app\api\controller
 */
class Index extends Controller
{
    public function index()
    {
        //banner位

        //商品区。new,video,bestseller
        $model = new GoodsModel;
        $newArrival = $model->getList(['listType' => 'on_sale'], 4)->toArray()['data'];
        $bestseller = $model->getList(['sortType' => 'sales'], 4)->toArray()['data'];

        $superDeals = $model->getList(['categoryId' => '10002',], 3)->toArray()['data'];
        //dd($superDeals);
        //return $this->renderSuccess(compact('bestseller'));

        $newGoodsId = array_column($newArrival, 'goods_id');
        $bestGoodsId = array_column($bestseller, 'goods_id');
        $superDealsGoodsId = array_column($superDeals, 'goods_id');

        //获取评价数量
        $goodsIds = array_unique(array_merge($newGoodsId, $bestGoodsId, $superDealsGoodsId));
        $commentModel = new CommentModel();
        $rows = $commentModel->rowsTotalBatch($goodsIds)->toArray();
        $rowsByGoodsId = array_column($rows, 'cnt', 'goods_id');

        //获取评论分数
        $commentScores = $commentModel->getTotalAll($goodsIds)->toArray();
        $scoresByGoodsId = array_column($commentScores, 'score_total', 'goods_id');

        //dd($rowsByGoodsId);

        //可考虑缓存

        foreach ($newArrival as &$item) {
            $item['comment_cnt'] = $rowsByGoodsId[$item['goods_id']] ?? 0;
            $temp = bcmul($item['comment_cnt'], 10, 0);
            $item['avg_score'] = bcdiv($scoresByGoodsId[$item['goods_id']] ?? '0', $temp, 0);
        }

        foreach ($bestseller as &$item) {
            $item['comment_cnt'] = $rowsByGoodsId[$item['goods_id']] ?? 0;
            $temp = bcmul($item['comment_cnt'], 10, 0);
            $item['avg_score'] = bcdiv($scoresByGoodsId[$item['goods_id']], $temp, 0);
        }

        foreach ($superDeals as &$item) {
            $item['comment_cnt'] = $rowsByGoodsId[$item['goods_id']] ?? 0;
            $temp = bcmul($item['comment_cnt'], 10, 0);
            $item['avg_score'] = bcdiv($scoresByGoodsId[$item['goods_id']], $temp, 0);
        }

        $model = new ArticleModel;
        $article = $model->getList(0, 5)->toArray()['data'];

        foreach ($article as &$datum) {
            $datum['year'] = substr($datum['create_time'], 0, 4);
            $datum['month_day'] = substr($datum['create_time'], 5, 5);
            $datum['date'] = substr($datum['create_time'], 0, 10);
        }
        //dd($article);

        return view('/index/index', [
            'newGoods' => $newArrival,
            'bestseller' => $bestseller,
            'superDealsOne' => $superDeals,
            'superDealsTwo' => $superDeals,
            'article' => $article,
        ]);


    }

    public function productDetails()
    {
        $goodsId = $this->request->param('goodsId', 0);
        if (empty($goodsId)) {
            return \redirect('index');
        }
        $goodsModel = new GoodsModel();
        $goods = $goodsModel->getDetails($goodsId)->toArray();
        $goods['content'] = html_entity_decode($goods['content']);

        $model = new CommentModel;
        $total = $model->rowsTotal($goodsId);

        return view('productDetails', ['goods' => $goods, 'comment_total' => $total]);
    }

}