コード例 #1
0
 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);
 }