/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { // $clients = Clients::all(); $purchase = Purchase::all(); $products = Products::all(); //$orders=Purchase::all(); $ordersLim = Purchase::orderBy('id', 'desc')->take(5)->get(); foreach ($ordersLim as $order) { if ($order->status == 'paid') { $order->rowStyle = 'warning'; } else { if ($order->status == 'sent') { $order->rowStyle = 'success'; } else { $order->rowStyle = ''; } } $ordertotalCount = 0; $ordertotalSumm = 0; $itemFast = false; $itemGift = false; foreach ($order->items as $item) { if ($item->product_id == 'np') { $ordertotalSumm = $ordertotalSumm + Setting::get('product.np'); } else { if ($item->product_id == 'fast') { $itemFast = true; $ordertotalSumm = $ordertotalSumm + Setting::get('product.fast'); } else { if ($item->product_id == 'gift') { $itemGift = true; $ordertotalSumm = $ordertotalSumm + Setting::get('product.gift') * $item->qty; } else { if (strpos($item->product_id, '0000')) { //dd('consist'); $pID = explode('0000', $item->product_id); $option = Options::findOrFail($pID[1]); $product = Products::findOrFail($pID[0]); $productPrice = $option->price; $item->productPrice = $productPrice; $item->productName = $product->name . ' (' . $option->name . ')'; $item->productCover = $product->cover; $item->productUrlhash = $product->urlhash; } else { $productPrice = $item->product->price; $item->productPrice = $item->product->price; $item->productName = $item->product->name; $item->productCover = $item->product->cover; $item->productUrlhash = $item->product->urlhash; } $ordertotalCount = $ordertotalCount + $item->qty; $ordertotalSumm = $ordertotalSumm + $item->productPrice * $item->qty; } } } } $order->itemFast = $itemFast; $order->itemGift = $itemGift; $order->totalCount = $ordertotalCount; $order->totalSumm = $ordertotalSumm; } //dd($order->totalSumm); $orders = Purchase::where('status', 'sent')->get(); $totalSumm = 0; $totalCount = 0; foreach ($orders as $order) { foreach ($order->items as $item) { if ($item->product_id == 'np') { $totalSumm = $totalSumm + Setting::get('product.np'); } else { if ($item->product_id == 'fast') { $totalSumm = $totalSumm + Setting::get('product.fast'); } else { if ($item->product_id == 'gift') { $totalSumm = $totalSumm + Setting::get('product.gift') * $item->qty; } else { if (strpos($item->product_id, '0000')) { //dd('consist'); $pID = explode('0000', $item->product_id); $option = Options::findOrFail($pID[1]); $product = Products::findOrFail($pID[0]); $productPrice = $option->price; $item->productPrice = $productPrice; $item->productName = $product->name . ' (' . $option->name . ')'; $item->productCover = $product->cover; $item->productUrlhash = $product->urlhash; } else { $productPrice = $item->product->price; $item->productPrice = $item->product->price; $item->productName = $item->product->name; $item->productCover = $item->product->cover; $item->productUrlhash = $item->product->urlhash; } $totalCount = $totalCount + $item->qty; $totalSumm = $totalSumm + $item->productPrice * $item->qty; } } } } } $topProds = DB::table('order_items')->select('product_id', DB::raw('count(*) as total'))->groupBy('product_id')->orderBy('total', 'desc')->take('5')->get(); $topProdsArr = []; //dd($topProds); foreach ($topProds as $topprod) { if (!in_array($topprod->product_id, ['fast', 'np', 'gift'])) { if (strpos($topprod->product_id, '0000')) { //dd('consist'); $pID = explode('0000', $topprod->product_id); //$topprod->product_id = $pID[0]; $prodID = $pID[0]; } else { $prodID = $topprod->product_id; } $prodName = Products::findOrFail($prodID); //echo $prodName->name; array_push($topProdsArr, ['name' => $prodName->name, 'urlhash' => $prodName->urlhash, 'qty' => $topprod->total]); // code... } } /*OrderItems::whereNotIn('product_id', ['np','fast','gift']) ->orderBy('qty') ->groupBy('product_id') ->get();*/ //dd($topProdsArr); //$NewOrderCounter=Purchase::Neworders()->count(); $data = ['totalClients' => $clients->count(), 'totalPurchase' => $purchase->count(), 'totalPurchaseOk' => $purchase->where('status', 'sent')->count(), 'totalProducts' => $products->count(), 'totalMoney' => $totalSumm, 'totalCount' => $totalCount, 'orders' => $ordersLim, 'topProds' => $topProdsArr, 'NewOrderCounter' => Purchase::Neworders()->count()]; return view('admin.dashboard')->with($data); }
public function showPrivat24(Request $request) { $payment = $request->payment; $signature = $request->signature; $pass = Setting::get('money.privatKey'); $checkSignature = sha1(md5($payment . $pass)); if ($signature == $checkSignature) { // Ответ от настоящего сервера //echo ("Опа! проверка прошла успешно"); // Далее парсим $payment parse_str($payment, $data); $id_cart = $data['order']; if ($data['state'] == 'test' || $data['state'] == 'ok') { $order = Purchase::where('code', $id_cart)->first(); $order->update(['status' => 'paid']); return redirect('/'); } } return redirect('/'); }