/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { // $clients = Clients::all(); $data = ['clients' => $clients, 'NewOrderCounter' => Purchase::Neworders()->count()]; return view('admin.clients')->with($data); }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { // $validator = Validator::make($request->all(), ['subj' => 'required', 'text' => 'required']); if ($validator->fails()) { return back()->withErrors($validator)->withInput(); } else { Setting::get('config.logo', Null) ? $logoMain = asset('/files/img/' . Setting::get('config.logo')) : ($logoMain = asset('dist/img/logo.png')); $data = ['logoMain' => $logoMain, 'msg' => $request->text]; $clients = Clients::all(); $counter = 0; $counterTime = 5; foreach ($clients as $client) { $subj = $request->subj; $email = $client->email; if (++$counter % 5 === 0) { $counterTime = $counterTime + 10; } Mail::later($counterTime, 'mail.message', $data, function ($message) use($email, $subj) { $message->from(Setting::get('config.email'), Setting::get('config.sitename')); $message->subject($subj); $message->to($email); }); } $data = ['count' => $counter]; Mail::later($counterTime, 'mail.messageSuccess', $data, function ($message) { $message->from(Setting::get('config.email'), Setting::get('config.sitename')); $message->subject('Рассылка завершена!'); $message->to(Setting::get('config.email')); }); // code...*/ /*//dd($client->email); $subj=$request->subj; $email=$client->email; Mail::later(5, 'mail.message', $data, function ($message) use ($email,$subj) { $message->from(Setting::get('config.email') , Setting::get('config.sitename')); $message->subject($subj); $message->to($email); });*/ //} $request->session()->flash('alert-success', 'Рассылка будет создана в ближайшее время!'); return redirect('message'); } }
/** * 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); }