public function show($id) { $marketAc = Market::find($id); if (count($marketAc) < 1) { abort(404); } $day = getWeekDate(); $cardAr = []; $orderAr = []; $rechargeAr = []; foreach ($day as $day) { $cardAr[] = UserCa::where('market_id', $id)->whereBetween('created_at', [$day . ' 00:00:00', $day . ' 23:59:59'])->count(); /* 订单金额 */ $orders = Order::where('market_id', $id)->whereBetween('created_at', [$day . ' 00:00:00', $day . ' 23:59:59'])->get(); $orderPrice = 0; foreach ($orders as $order) { $orderPrice += $order->price; } $orderAr[] = $orderPrice; /* 混合订单金额 */ $mixOrders = MixOrder::where('market_id', $id)->whereBetween('created_at', [$day . ' 00:00:00', $day . ' 23:59:59'])->get(); $mixOrderPrice = 0; foreach ($mixOrders as $order) { $mixOrderPrice += $order->price; } $mixOrderAr[] = $mixOrderPrice; /* 充值金额 */ $recharges = Recharge::where('market_id', $id)->whereBetween('created_at', [$day . ' 00:00:00', $day . ' 23:59:59'])->get(); $rechargePrice = 0; foreach ($recharges as $d) { $rechargePrice += $d->price; } $rechargeAr[] = $rechargePrice; } $data['cards'] = $cardAr; $data['orderPrice'] = $orderAr; $data['mixOrderPrice'] = $mixOrderAr; $data['rechargePrice'] = $rechargeAr; $markets = Market::all(); $data['markets'] = $markets; $data['marketAc'] = $marketAc; return view('card.data_day.show', $data); }