public function indexSitemap() { //$date=LocalizedCarbon::parse($order->created_at)->format('d M Y H:i:s'); //Sitemap::addSitemap('/catalog'); Sitemap::addtag(URL::to('/'), date('Y-m-d H:i:s')); Sitemap::addtag(URL::to('/gallery'), date('Y-m-d H:i:s')); Sitemap::addtag(URL::to('/catalog'), date('Y-m-d H:i:s')); Sitemap::addtag(URL::to('/info'), date('Y-m-d H:i:s')); $cats = Categories::all(); foreach ($cats as $cat) { Sitemap::addtag(URL::to('/' . $cat->urlhash), $cat->updated_at, 'daily', '0.8'); } $products = Products::all(); foreach ($products as $product) { Sitemap::addtag(URL::to('/' . $product->urlhash . '.html'), $product->updated_at, 'daily', '0.8'); } //$sitemap = App::make("sitemap"); //$sitemap->add(URL::to('/'), date('Y-m-d H:i:s'), '1.0', 'daily'); return Sitemap::renderSitemap(); }
/** * 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); }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { // $order = Purchase::findOrFail($id); $totalCount = 0; $totalSumm = 0; foreach ($order->items as $item) { /* if (!in_array($item->product_id, ['np','fast', 'gift'])) { $totalCount=$totalCount+$item->qty; $totalSumm=$totalSumm+($item->product->price*$item->qty); }*/ 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 { $totalCount = $totalCount + $item->qty; $totalSumm = $totalSumm + $item->product->price * $item->qty; } } } } $dNP = true; $dADR = false; if ($order->items()->where('product_id', 'np')->exists()) { $dNP = false; $dADR = true; } $privat24 = false; $privat_terminal = false; $liqpay = false; switch ($order->pay_type) { case 'privat24': // code... $privat24 = true; break; case 'privat_terminal': // code... $privat_terminal = true; break; case 'liqpay': // code... $liqpay = true; break; default: // code... break; } $prods = Products::all(); $prods_arr = []; foreach ($prods as $key => $value) { $prods_arr[$value->id] = $value->name; } $data = ['order' => $order, 'totalCount' => $totalCount, 'totalSumm' => $totalSumm, 'dNP' => $dNP, 'dADR' => $dADR, 'Prods' => $prods_arr, 'privat24' => $privat24, 'privat_terminal' => $privat_terminal, 'liqpay' => $liqpay, 'NewOrderCounter' => Purchase::Neworders()->count()]; return view('admin.orderEdit')->with($data); }