public function index($id) { Session::set('last_projectid', $id); $search['text'] = Input::get('search_text'); $search['type'] = Input::get('search_type'); if ($search['type'] == 'user') { $list = Comment::where('nickname', $search['text'])->where('project_id', $id)->orderBy('id', 'desc')->paginate(20); } else { if ($search['type'] == 'ip') { $list = Comment::where('ip', 'like', "%{$search['text']}%")->where('project_id', $id)->orderBy('id', 'desc')->paginate(20); } else { if ($search['type'] == 'page_id') { $list = Comment::where('page_id', 'like', "%{$search['text']}%")->where('project_id', $id)->orderBy('id', 'desc')->paginate(20); } else { if ($search['type'] == 'fid') { $list = Comment::where('fid', 'like', "%{$search['text']}%")->where('project_id', $id)->orderBy('id', 'desc')->paginate(20); } else { if ($search['type'] == 'path') { $list = Comment::where('path', 'like', "%{$search['text']}%")->where('project_id', $id)->orderBy('id', 'desc')->paginate(20); } else { if ($search['type'] == 'content') { $list = Comment::where('content', 'like', "%{$search['text']}%")->where('project_id', $id)->orderBy('id', 'desc')->paginate(20); } else { $list = Comment::where('project_id', $id)->orderBy('id', 'desc')->paginate(20); } } } } } } return View::make('admin.comment_list')->withlist($list)->withsearch($search)->withproject_id($id); }
public function show($slug) { $article = Content::article()->active()->published()->where('slug', $slug)->firstOrFail(); $comments = Comment::where('content_id', $article['id'])->active()->paginate(10); $pageTitle = $article['title']; return view('frontend.articles.show', compact('article', 'comments', 'pageTitle')); }
public function search() { //dd(Request::only('keyword')); $keyword = Request::only('keyword')['keyword']; $results = Comment::where('content', 'like', '%' . $keyword . '%')->orWhere('author', 'like', '%' . $keyword . '%')->paginate(10); //dd($results); return redirect()->back()->withComments($results); }
public function getDataSet($postData, $safetyTable, $facility_id, $occur_date, $properties) { $comment_type = $postData['CodeCommentType']; $comment = Comment::getTableName(); // \DB::enableQueryLog(); $dataSet = Comment::where("FACILITY_ID", "=", $facility_id)->where("COMMENT_TYPE", "=", $comment_type)->where("CREATED_DATE", "=", $occur_date)->select("{$comment}.ID as DT_RowId", "{$comment}.*")->get(); // \Log::info(\DB::getQueryLog()); return ['dataSet' => $dataSet]; }
public function update(Request $request, $id) { $this->validate($request, ['nickname' => 'required', 'content' => 'required']); if (Comment::where('id', $id)->update(Input::except(['_method', '_token']))) { return Redirect::to('admin/comments'); } else { return Redirect::back()->withInput()->withErrors('更新失败!'); } }
public function show($id) { $rs = Blogs::find($id); if (!$rs) { echo json_encode(["blog_title" => "Not found", "blog_content" => "Not found"]); return; } $comment = Comment::where("comment_blogs_id", $id)->get(); echo json_encode(["blog_title" => $rs->blog_title, "blog_content" => $rs->blog_content]); die; }
public function listcomment(Request $request) { $type = $request->get('type'); if ($type == 'all') { $comments = Models\Comment::all(); } elseif ($type == 'act') { $comments = Models\Comment::where('item_type', '=', 'App\\Models\\Activity')->get(); } elseif ($type == 'assoc') { $comments = Models\Comment::where('item_type', '=', 'App\\Models\\Associate')->get(); } //print_r($comments[0]->item->title);die; return view('admin.comment.index', compact('comments')); }
/** * Store a newly created resource in storage. * * @return Response */ public function product($id) { $product = Product::find($id); $avg_rating = Comment::where('product_id', '=', $product->id)->avg('rating'); $rating_cont = Comment::where('product_id', '=', $product->id)->count(); $five_star = Comment::where('product_id', '=', $product->id)->where('rating', '=', '5')->count() * 100 / $rating_cont; $four_star = Comment::where('product_id', '=', $product->id)->where('rating', '=', '4')->count() * 100 / $rating_cont; $three_star = Comment::where('product_id', '=', $product->id)->where('rating', '=', '3')->count() * 100 / $rating_cont; $two_star = Comment::where('product_id', '=', $product->id)->where('rating', '=', '2')->count() * 100 / $rating_cont; $one_star = Comment::where('product_id', '=', $product->id)->where('rating', '=', '1')->count() * 100 / $rating_cont; if (empty($product)) { Flash::error('Product not found'); return redirect(route('admin.products.index')); } return view('site.products.show')->with(['product' => $product, 'avg_rating' => $avg_rating, 'rating_count' => $rating_cont, 'five_star' => $five_star, 'four_star' => $four_star, 'three_star' => $three_star, 'two_star' => $two_star, 'one_star' => $one_star]); }
/** * Display a listing of the Comment. * GET|HEAD /comments * * @return Response */ public function index(Request $request) { $offset = $request->page ? $request->page : 1; $limit = $request->limit ? $request->limit : 12; $post_id = $request->post_id; $offset = ($offset - 1) * $limit; if ($post_id) { $posts = Comment::where('postId', $post_id)->orderBy('id', 'desc')->offset($offset)->limit($limit)->get(); foreach ($posts as $key => $value) { $posts[$key]['human_created_at'] = $value->created_at->diffForHumans(); $posts[$key]['human_updated_at'] = $value->updated_at->diffForHumans(); } } else { $posts = Comment::orderBy('id', 'desc')->offset($offset)->limit($limit)->get(); } return response()->json($posts); }
/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id) { $product = Product::findOrFail($id); $rating_cont = Comment::where('product_id', '=', $product->id)->count(); $checked_rating_count = $rating_cont > 0 ? $rating_cont : 1; $five_star = Comment::where('product_id', '=', $product->id)->where('rating', '=', '5')->count() * 100 / $checked_rating_count; $four_star = Comment::where('product_id', '=', $product->id)->where('rating', '=', '4')->count() * 100 / $checked_rating_count; $three_star = Comment::where('product_id', '=', $product->id)->where('rating', '=', '3')->count() * 100 / $checked_rating_count; $two_star = Comment::where('product_id', '=', $product->id)->where('rating', '=', '2')->count() * 100 / $checked_rating_count; $one_star = Comment::where('product_id', '=', $product->id)->where('rating', '=', '1')->count() * 100 / $checked_rating_count; $owner = $product->owner(); $mods = $product->mods(); if (empty($product)) { Flash::error('Product not found'); return redirect(route('admin.products.index')); } return view('site.products.show')->with(['product' => $product, 'rating_count' => $rating_cont, 'five_star' => $five_star, 'four_star' => $four_star, 'three_star' => $three_star, 'two_star' => $two_star, 'one_star' => $one_star, 'owner' => $owner, 'mods' => $mods]); }
/** * Bootstrap any application services. * * @return void */ public function boot() { $author = User::whereHas('role', function ($q) { $q->where('slug', 'admin'); })->first(); $categories = Category::where('is_active', 1)->get(); $postsRecents = Post::where('is_active', 1)->where('seen', 1)->orderBy('created_at', 'desc')->take(3)->get(); $postsPopular = Post::where('is_active', 1)->where('seen', 1)->orderBy('nview', 'desc')->take(3)->get(); $commentsRecents = Comment::where('seen', 1)->orderBy('created_at', 'desc')->take(3)->get(); $tags = Tag::all(); $INFO_SITE = Admin::first(); view()->share('author', $author); view()->share('categories', $categories); view()->share('tags', $tags); view()->share('postsRecents', $postsRecents); view()->share('postsPopular', $postsPopular); view()->share('commentsRecents', $commentsRecents); view()->share('INFO_SITE', $INFO_SITE); }
public function show($id) { Article::where('id', $id)->increment('views'); //阅读量加1 $article = Article::with(['comments' => function ($query) { $query->take(10); }])->find($id); // dd($article); $views = Article::where('author_id', $article->author_id)->where('author_type', $article->author_type)->sum('views'); $comments_count = Comment::where('article_id', $id)->count(); $hots = Article::orderBy('views', 'desc')->take(10)->get(); $is_like = false; $is_collection = false; $is_follow = false; if ($this->login_user) { $is_like = Like::where('user_id', $this->login_user->id)->where('like_type', 'article')->where('like_id', $id)->first(); $is_collection = Collection::where('user_id', $this->login_user->id)->where('collection_type', 'article')->where('collection_id', $id)->first(); $is_follow = DB::table('user_follow')->where('user_id', $this->login_user->id)->where('follow_id', $article->author_id)->first(); } return view('front.article.index', compact('article', 'views', 'comments_count', 'hots', 'is_like', 'is_collection', 'is_follow')); }
public function postComments($docId, $commentId) { $comment = Input::get('comment'); $parent = Comment::where('doc_id', '=', $docId)->where('id', '=', $commentId)->first(); $parent->load('user'); $parent->type = 'comment'; //Returns the new saved Comment with the User relationship loaded $result = $parent->addOrUpdateComment($comment); Event::fire(MadisonEvent::DOC_SUBCOMMENT, array('comment' => $result, 'parent' => $parent)); return Response::json($result); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(Request $request) { $contentId = $request->get('contentId') ?: null; $comments = Comment::where($contentId ? ['content_id' => $contentId] : [])->latest()->paginate(); return view('backend.comments.index', compact('comments')); }
public function index() { $comments = Comment::where('valid', '1')->get(); return view('comments.index')->with(compact('comments')); }
/** * Destroy a post if it exists. * * @param $id * @return Response */ public function destroy($id) { $post = Post::findOrFail($id); $post::destroy($id); // Delete comments whos post_id matches the current post that is being deleted Comment::where('post_id', '=', $id)->delete(); return redirect()->action('PostController@index'); }
/** * ------------------------------------------- * 查询某篇文章或某个商品下的评论 * ------------------------------------------- */ public function commentList($post_id, $type) { $comments = Comment::where(['post_id' => $post_id, 'type' => $type])->paginate(10); return view('admin.comments.list')->with('comments', $comments); }
/** * coupon function. * * @access public * @param int $limit (default: 10) * @description Devuelve los datos de un cupon * @return void */ public function getCoupon($id = 0) { $coupon = Coupon::leftJoin('categories', 'coupons.category_id', '=', 'categories.id')->leftJoin('coupons_premium', 'coupons_premium.coupon_id', '=', 'coupons.id')->where('coupons.id', '=', $id)->get(array('coupons.id', 'coupons.title', 'categories.name as category', 'coupons.description', 'coupons.restriction', 'coupons.latitude', 'coupons.longitude', DB::raw('IF(coupons_premium.coupon_id, 1, 0) AS premium')))->toArray(); if (count($coupon) == 0) { return Response::json(array()); } $coupon = $coupon[0]; $coupon['ratings'] = (double) Rating::where("coupon_id", "=", $coupon['id'])->avg('value'); $coupon['redems'] = (double) Scan::where("coupon_id", "=", $coupon['id'])->count(); $coupon['comments'] = (double) Comment::where("coupon_id", "=", $coupon['id'])->where("disabled", "=", 0)->count(); return Response::json($coupon); }
public function postFastDelete($elements, Request $request) { switch ($elements) { case 'videos': $elements = $request->input('elements'); $elements = explode(' ', $elements); PHPRedis::delete($elements); foreach ($elements as $element) { // delete video from database $elemId = Video::find($element); if (!is_null($elemId)) { $elemId->delete(); } // delete folder $destination = public_path("users_content/videos/{$element}"); if (File::exists($destination)) { File::deleteDirectory($destination); } // delete comments from database Comment::where('video_id', $element)->delete(); } return redirect()->back()->with('message_success', 'Elements have been deleted'); break; case 'users': $elements = $request->input('elements'); $elements = explode(' ', $elements); foreach ($elements as $element) { $elem = User::find($element); if (!is_null($elem)) { $elem->delete(); } } return redirect()->back()->with('message_success', 'Elements have been deleted'); break; default: $elements = $request->input('elements'); $elements = explode(' ', $elements); foreach ($elements as $element) { $elem = Comment::find($element); if (!is_null($elem)) { $elem->delete(); } } return redirect()->back()->with('message_success', 'Elements have been deleted'); break; } }
/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($id) { Comment::where('page_id', $id)->first(); }
public function rating() { return number_format(Comment::where('product_id', '=', $this->id)->avg('rating'), 2); }
public function commentDelete($id) { $comment = Comment::where('id', $id)->delete(); return redirect(route("comments")); }
public function getChiTiet($id) { $brands = $this->brands; $socho = $this->sochoxe; $tintucs = $this->tintucs; $binhluans = Comment::where('xe_id', $id)->orderBy('id', 'desc')->paginate(3); foreach ($binhluans as $key => $value) { if ($value->nguoidung_id != NULL) { $user = User::where('nguoidung_id', $value->nguoidung_id)->get()->first(); $value->nguoidung_id = $user->tendaydu; } } //dd($binhluans); // xe hiện tại $xe = Cars::where('xe_id', $id)->get()->first(); // tên lái xe theo xe $tenlaixe = TaiXe::where('taixe_id', $xe->tai_xe_id)->get()->first(); $xekhac = Cars::whereNotIn('xe_id', [$id])->where(function ($query) use($xe) { $query->where('socho_xe', $xe->socho_xe)->orWhere('hang_id', $xe->hang_id); })->get(); //dd($xekhac); //dd($xe); die(); $vote_id = Vote::where('cars_id', $id)->get()->first(); if ($vote_id->sovotes != 0) { $roundVote = round($vote_id->tongdiem / $vote_id->sovotes, 1); } else { $roundVote = 0; } //dd($vote_id); return view('frontend.pages.chitiet', compact('vote_id', 'binhluans', 'xe', 'socho', 'brands', 'tintucs', 'tenlaixe', 'xekhac', 'roundVote')); }
public function list_comment($param = null) { $rs = Comment::where("comment_blogs_id", $param)->get(); echo json_encode($rs); }
public static function deleteCommentEvent($comment_event_id) { $result = Comment::where('comment_event_id', $comment_event_id)->first(); return $result; }
public function removeComment($commentID, $cardID) { if (!Auth::check()) { return redirect("/"); } $delChecklist = Comment::where('id', '=', $commentID); $delChecklist->delete(); $card = Card::with(['checklists', 'memberCard.member', 'comments.memberComment', 'preCard'])->find($cardID); return $card; }
/** * Get load more product comments * * @param int $productId * @param int $before * * @return App\Models\Comment */ protected function _getLoadMoreComents($productId, $before = 0) { $comment = Comment::where('product_id', $productId); if ($before) { $comment->where('id', '<', $before); } return $comment->orderBy('id', 'DESC'); }
public function get_userinfo() { $project_id = $this->project_id; $page_id = $this->page_id; $uid = Input::get('user_id'); $data = Comment::where('project_id', $project_id)->where('page_id', $page_id)->where('user_id', $uid)->orderBy('id', 'desc')->first(); if ($data) { $return_data['status'] = 0; $return_data['data'][] = array_merge($data->Extend->toArray(), $data->toArray()); } else { $return_data['status'] = 0; $return_data['data'] = array(); } return $this->_return_json($return_data); }