getList(['listType' => 'on_sale'], 4)->toArray()['data']; $bestseller = $model->getList(['sortType' => 'sales'], 4)->toArray()['data']; $superDeals = $model->getList(['categoryId' => '10002',], 8)->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; $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_bestseller', json_encode($bestseller), 1200); foreach ($superDeals 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_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); } $superDeals1 = $superDeals2 = []; isset($superDeals[0]) && $superDeals1[] = $superDeals[0]; isset($superDeals[1]) && $superDeals1[] = $superDeals[1]; isset($superDeals[2]) && $superDeals1[] = $superDeals[2]; isset($superDeals[3]) && $superDeals1[] = $superDeals[3]; isset($superDeals[4]) && $superDeals2[] = $superDeals[4]; isset($superDeals[5]) && $superDeals2[] = $superDeals[5]; isset($superDeals[6]) && $superDeals2[] = $superDeals[6]; isset($superDeals[7]) && $superDeals2[] = $superDeals[7]; return view('/index/index', [ 'newGoods' => $newArrival, 'bestseller' => $bestseller, 'superDealsOne' => $superDeals1, 'superDealsTwo' => $superDeals2, 'article' => $article, ]); } /** * 产品详情页 * @return \think\response\Redirect|View * @throws \cores\exception\BaseException * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\DbException * @throws \think\db\exception\ModelNotFoundException */ public function productDetails() { $goodsId = $this->request->param('goodsId', 0); if (empty($goodsId)) { return \redirect('index'); } $key = $this->request->param('key', ''); $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, 'key' => $key]); } public function aboutUs(): View { return view('aboutUs'); } public function privacyPolicy(): View { return view('privacyPolicy'); } public function salesTerms(): View { return view('salesTerms'); } public function vapePoints(): View { return view('vapePoints'); } public function returnWarranty(): View { return view('returnWarranty'); } public function newsDetail(): View { $newsId = $this->request->param('newsId'); if (empty($newsId)) { return view('/error'); } $model = new ArticleModel; $article = $model->find($newsId)->toArray(); return view('newsDetails', ['article' => $article]); } public function goldTest() { $service = new OrderGetYundanService(); $r = $service->orderCreateYundans($this->storeId); dd($r); $orderModel = new OrderModel(); $r = $orderModel->getUsableList(10001); dd($r->toArray()); $Usps = new Usps(); // 请求查询接口 $res = $Usps->getItdidaToken(); dd($res); } }