public function show($tag) { $rs = Tag::where('tag', $tag)->get(); $arr = array(); foreach ($rs as $v) { array_push($arr, $v->article_id); } $articles = Article::whereIn('id', $arr)->get(); $tags = Tag::select('tag')->distinct()->get(); return view('member.tags.show', compact('tag', 'tags', 'articles')); }
/** * Display the specified resource. * * @param int $id * @return Response */ public function getArticles($id, $number) { $category = Category::whereName($id)->first(); $sources = $category->sources; $ids = []; foreach ($sources as $source) { $ids[] = $source->id; } $articles = Article::whereIn('source_id', $ids)->orderBy('date', 'DESC')->paginate($number); return ['name' => $category->name, 'id' => $category->id, 'image_url' => $category->image_url, 'articles' => $articles->toArray()]; }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(Request $request) { $usr = Practicante::where('email', '=', $request->user()->email)->get(); $actual_rank = Tag::where('name', Config::get('constants.ranks')[$usr[0]->actual_rank])->get()[0]->id; $withTags = DB::table('article_tag')->where('tag_id', $actual_rank)->get(array('article_id')); //Cleaning the array $justTags = array(); foreach ($withTags as $key => $value) { array_push($justTags, $value->article_id); } $articles = Article::whereIn('id', $justTags)->get(); return View('practicante.tecnicas.index')->with('articles', $articles)->with('actual_rank', $usr[0]->actual_rank)->with('ranks', Config::get('constants.ranks')); }
public function articlesTag($tag) { $withTags = DB::table('article_tag')->where('tag_id', $tag)->get(array('article_id')); //Cleaning the array $justTags = array(); foreach ($withTags as $key => $value) { array_push($justTags, $value->article_id); } $articles = Article::whereIn('id', $justTags)->get(); if (count($articles) == 0) { return response()->json(['error' => ['message' => 'No existen articulos con esta etiqueta']], 404); } return response()->json($articles, 200); }
public function checkout(Request $request) { if (isset($_COOKIE['basket'])) { $entries = $_COOKIE['basket']; $entries = json_decode($entries); } else { return redirect('/'); } $ids = array_pluck($entries, 'article_id'); $items = Article::whereIn('id', $ids)->get(); //->toArray(); $items = $items->keyBy('id'); $order = Order::create(['name' => $request->name, 'address' => $request->address, 'phone' => $request->phone]); $summary = []; $total_cost = 0; foreach ($entries as $entry) { OrdersToArticles::create(['article_id' => $entry->article_id, 'order_id' => $order->id, 'price' => $items->get($entry->article_id)->price, 'quantity' => $entry->amount]); $summary[] = ['article_id' => $entry->article_id, 'title' => $items->get($entry->article_id)->title, 'price' => $items->get($entry->article_id)->price, 'amount' => $entry->amount]; $total_cost += end($summary)['price'] * end($summary)['amount']; } setcookie('basket', '', 0, '/'); //удаляем куки return view('finish_order', ['order' => $order, 'entries' => $summary, 'total' => $total_cost]); }
public function deleteArticle() { $articles = Input::get('formarr', array()); Articlecontent::whereIn('article_id', $articles)->delete(); foreach ($articles as $article) { Article::find($article)->menu_relations()->detach(); } Article::whereIn('id', $articles)->delete(); return 1; }
/** * Return the favorites of a certain model or table, leave the data as is under $model->settings['favorites'] * * @param $model * @param $data * * @return object|false */ static function getFavoritesByModel($model, $data) { if (!isset($data[$model])) { return false; } $data = array_keys($data[$model]); switch ($model) { case 'articles': return Article::whereIn('id', $data)->get(); case 'sites': return Site::whereIn('id', $data)->get(); case 'professions': return Profession::whereIn('id', $data)->get(); case 'classifieds': return Classified::whereIn('id', $data)->get(); case 'albums': return Album::whereIn('id', $data)->get(); case 'agoda': return AgodaHotel::whereIn('hotel_id', $data)->get(); default: return false; } }
/** * batch update * @param string $act * @return json */ public function postBatch($act = 'update') { $result = false; $ids = \Request::input('ids'); $idsArr = explode(',', $ids); switch ($act) { case 'delete': $result = Article::whereIn('id', $idsArr)->delete(); break; case 'update': $key = \Request::input('key'); $value = \Request::input('value'); $tempData = $this->parseKey($key, $value); $result = Article::whereIn('id', $idsArr)->update($tempData); break; } $msg = []; if ($result) { $msg['status'] = 'success'; } else { $msg['status'] = 'failed'; } return response(json_encode($msg))->header('Content-Type', 'application/json'); }