vape_shop/app/api/controller/Index.php

<?php

namespace app\api\controller;

use app\api\model\Article as ArticleModel;
use app\api\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'];
        //return $this->renderSuccess(compact('bestseller'));

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

        //获取评价数量
        $goodsIds = array_unique(array_merge($newGoodsId,$bestGoodsId));
        $commentModel = new \app\api\model\Comment();
        $rows = $commentModel->rowsTotalBatch($goodsIds)->toArray();
        $rowsByGoodsId = array_column($rows,'cnt','goods_id');
        //可考虑缓存

        foreach ($newArrival as &$item){
            $item['comment_cnt'] = $rowsByGoodsId[$item['goods_id']] ?? 0;
        }

        foreach ($bestseller as &$item){
            $item['comment_cnt'] = $rowsByGoodsId[$item['goods_id']] ?? 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);
        }
        //dd($article);

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

        echo '当前访问的index.php，请将index.html设为默认站点入口';
    }
}