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); if ($temp) { $item['avg_score'] = bcdiv($scoresByGoodsId[$item['goods_id']] ?? '0', $temp, 0); } else { $item['avg_score'] = 5; } } Cache::set('index_newArrival', json_encode($newArrival), 1200); foreach ($bestseller as &$item) { $item['comment_cnt'] = $rowsByGoodsId[$item['goods_id']] ?? 0; if ($temp) { $item['avg_score'] = bcdiv($scoresByGoodsId[$item['goods_id']] ?? '0', $temp, 0); } else { $item['avg_score'] = 5; } } Cache::set('index_bestseller', json_encode($bestseller), 1200); foreach ($superDeals as &$item) { $item['comment_cnt'] = $rowsByGoodsId[$item['goods_id']] ?? 0; if ($temp) { $item['avg_score'] = bcdiv($scoresByGoodsId[$item['goods_id']] ?? '0', $temp, 0); } else { $item['avg_score'] = 5; } } Cache::set('index_superDeals', json_encode($superDeals), 1200); $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); } Cache::set('index_article', json_encode($article), 1200); } 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]); } }