/** * Display a listing of the resource. * * @return Response */ public function index() { // $keyword = Input::get('keyword'); $option = Input::get('search_opt'); if ($keyword && $option == "fullname") { $users = User::where('fullname', 'LIKE', "%{$keyword}%")->get(); $users_id = array(); foreach ($users as $key => $user) { $users_id[] = $user->id; } $posts = Post::whereIn('user_id', $users_id)->paginate(5); } if ($keyword && $option == "content") { $posts = Post::select('*')->where($option, 'LIKE', "%{$keyword}%")->paginate(5); } else { $posts = Post::select('*')->paginate(5); } return View::make('backend.post.index', compact('posts')); }
/** * Show a list of all the blog posts formatted for Datatables. * * @return Datatables JSON */ public function getData() { $posts = Post::select(array('posts.id', 'posts.title', 'posts.id as comments', 'posts.created_at')); return Datatables::of($posts)->edit_column('comments', '{{ DB::table(\'comments\')->where(\'post_id\', \'=\', $id)->count() }}')->add_column('actions', '<a href="{{{ URL::to(\'admin/blogs/\' . $id . \'/edit\' ) }}}" class="btn btn-default btn-xs iframe" >{{{ Lang::get(\'button.edit\') }}}</a> <a href="{{{ URL::to(\'admin/blogs/\' . $id . \'/delete\' ) }}}" class="btn btn-xs btn-danger iframe">{{{ Lang::get(\'button.delete\') }}}</a> ')->remove_column('id')->make(); }
/** * Show a list of all the blog posts formatted for Datatables. * * @return Datatables JSON */ public function getData() { $posts = Post::select(array('posts.id', 'posts.title', 'posts.id as comments', 'posts.created_at')); return Datatables::of($posts)->edit_column('created_at', '{{ $created_at->format("Y-m-d h:i:s") }}')->edit_column('comments', '{{ DB::table(\'comments\')->where(\'post_id\', \'=\', $id)->count() }}')->add_column('actions', ' <div class="btn-group"> <a href="{{{ URL::to(\'admin/blogs/\' . $id . \'/edit\' ) }}}" class="btn btn-primary btn-xs iframe" ><i class="fa fa-pencil"></i> {{{ Lang::get(\'button.edit\') }}}</a> <a href="{{{ URL::to(\'admin/blogs/\' . $id . \'/delete\' ) }}}" class="btn btn-xs btn-danger iframe"><i class="fa fa-trash-o"></i> {{{ Lang::get(\'button.delete\') }}}</a> </div> ')->remove_column('id')->remove_column('rn')->make(); }
public function hof() { $data['page'] = 'halloffame'; $teams = array(); // get yg plg aktif di vote $total_votes = Vote::select(DB::raw('count(votes.id) as total'), 'teams.name', 'teams.id')->join('users', 'votes.user_id', '=', 'users.id')->join('teams', 'users.team_id', '=', 'teams.id')->groupBy('teams.id')->orderBy('total', 'desc')->take(5)->get(); if ($total_votes) { foreach ($total_votes as $value) { $teams[$value->id] = $value->total; } } // get total komen aktif $total_comments = Comment::select(DB::raw('count(comments.id) as total'), 'teams.name', 'teams.id')->join('users', 'comments.user_id', '=', 'users.id')->join('teams', 'users.team_id', '=', 'teams.id')->groupBy('teams.id')->orderBy('total', 'desc')->take(5)->get(); if ($total_comments) { foreach ($total_comments as $value) { if (isset($teams[$value->id])) { $teams[$value->id] = $teams[$value->id] + $value->total; } else { $teams[$value->id] = $value->total; } } } // get total post $total_posts = Post::select(DB::raw('count(posts.id) as total'), 'teams.name', 'teams.id')->join('users', 'posts.user_id', '=', 'users.id')->join('teams', 'users.team_id', '=', 'teams.id')->groupBy('teams.id')->orderBy('total', 'desc')->take(5)->get(); if ($total_posts) { foreach ($total_posts as $value) { if (isset($teams[$value->id])) { $teams[$value->id] = $teams[$value->id] + $value->total; } else { $teams[$value->id] = $value->total; } } } if (count($teams) > 0) { $winningteam = array_search(max($teams), $teams); $data['clubwinner'] = Team::find($winningteam); } else { $data['clubwinner'] = null; } $startingeleven = array(); $data['defenders'] = array(); $data['assisters'] = array(); $data['attackers'] = array(); // player $defenders = User::select(array('users.id', 'users.username', 'jersey_image', 'jersey_no', 'profile_pic', DB::raw('count(comments.id) as total')))->join('comments', 'users.id', '=', 'comments.user_id')->join('teams', 'teams.id', '=', 'users.team_id')->orderBy('total', 'desc')->groupBy('users.id')->where('comments.type', 'defense')->take(5)->get(); $assisters = User::select(array('users.id', 'users.username', 'jersey_image', 'jersey_no', 'profile_pic', DB::raw('count(comments.id) as total')))->join('comments', 'users.id', '=', 'comments.user_id')->join('teams', 'teams.id', '=', 'users.team_id')->orderBy('total', 'desc')->groupBy('users.id')->where('comments.type', 'assist')->take(3)->get(); $attackers = User::select(array('users.id', 'users.username', 'jersey_image', 'jersey_no', 'profile_pic', DB::raw('count(comments.id) as total')))->join('comments', 'users.id', '=', 'comments.user_id')->join('teams', 'teams.id', '=', 'users.team_id')->orderBy('total', 'desc')->groupBy('users.id')->where('comments.type', 'attack')->take(3)->get(); if ($defenders) { foreach ($defenders as $value) { $startingeleven[$value->id] = array('name' => $value->username, 'no' => $value->jersey_no, 'pic' => $value->profile_pic, 'jersey_image' => $value->jersey_image, 'total' => $value->total, 'position' => 'D'); } } if ($assisters) { foreach ($assisters as $value) { if (isset($startingeleven[$value->id]) && $startingeleven[$value->id]['total'] > $value->total) { $startingeleven[$value->id] = array('name' => $value->username, 'no' => $value->jersey_no, 'pic' => $value->profile_pic, 'jersey_image' => $value->jersey_image, 'total' => $value->total, 'position' => 'M'); } else { $startingeleven[$value->id] = array('name' => $value->username, 'no' => $value->jersey_no, 'pic' => $value->profile_pic, 'jersey_image' => $value->jersey_image, 'total' => $value->total, 'position' => 'M'); } } } if ($attackers) { foreach ($attackers as $value) { if (isset($startingeleven[$value->id]) && $startingeleven[$value->id]['total'] > $value->total) { $startingeleven[$value->id] = array('name' => $value->username, 'no' => $value->jersey_no, 'pic' => $value->profile_pic, 'jersey_image' => $value->jersey_image, 'total' => $value->total, 'position' => 'F'); } else { $startingeleven[$value->id] = array('name' => $value->username, 'no' => $value->jersey_no, 'pic' => $value->profile_pic, 'jersey_image' => $value->jersey_image, 'total' => $value->total, 'position' => 'F'); } } } $noplayer = array('name' => 'No player', 'no' => '0', 'pic' => '', 'jersey_image' => 'player_dummy.png', 'total' => 0); if (count($startingeleven) > 0) { foreach ($startingeleven as $se) { if ($se['position'] == 'F') { array_push($data['attackers'], $se); } if ($se['position'] == 'M') { array_push($data['assisters'], $se); } if ($se['position'] == 'D') { array_push($data['defenders'], $se); } } if (count($data['defenders']) < 5) { $selisih = 5 - count($data['defenders']); for ($i = 0; $i < $selisih; $i++) { array_push($data['defenders'], $noplayer); } } if (count($data['assisters']) < 3) { $selisih = 3 - count($data['assisters']); for ($i = 0; $i < $selisih; $i++) { array_push($data['assisters'], $noplayer); } } if (count($data['attackers']) < 3) { $selisih = 3 - count($data['attackers']); for ($i = 0; $i < $selisih; $i++) { array_push($data['attackers'], $noplayer); } } } else { for ($i = 0; $i < 5; $i++) { array_push($data['defenders'], $noplayer); } for ($i = 0; $i < 3; $i++) { array_push($data['attackers'], $noplayer); array_push($data['assisters'], $noplayer); } } return View::make('halloffame2')->with($data); }
public function carnival() { //return 'We Are Working'; //Changed $data['date'] = $this->getBaseDateTime(); /*19-May-2015 Ehsan*/ $user = User::find(Auth::user()->id); $url = Picture::find($user->picture); $data['self'] = $url; /*!!!!19-May-2015 Ehsan*/ // Everyday Question Generation $data['question'] = null; $data['prev_question'] = null; $question = Question::orderBy('id', 'desc')->first(); $prev_question = Question::orderBy('id', 'desc')->skip(1)->first(); if ($question) { $data['question'] = $question; $data['options_of_question'] = QuestionOption::whereQuestionId($question->id)->get(); //$get_count_of_the_answers = DB::table('users_answers')->select(DB::raw('option_number,count(*) as count'))->join('question_options','users_answers.option_id', '=', 'question_options.id')->whereQuestionId($question->id)->groupBy('option_id')->groupBy('option_number')->orderBy('option_number')->get(); $data['answered'] = UsersAnswer::whereUserId(Auth::user()->id)->whereQuestionId($question->id)->first(); } if ($prev_question) { $data['prev_question'] = $prev_question; $options_of_question = QuestionOption::whereQuestionId($prev_question->id)->get(); $total_answer = 0; foreach ($options_of_question as $key) { $current_answer = DB::table('users_answers')->select(DB::raw('count(*) as count'))->whereOptionId($key->id)->first()->count; $total_answer += $current_answer; $answers_count[$key->option_number] = array('option_details' => $key->option_details, 'total_answer' => $current_answer); } try { foreach ($options_of_question as $key) { $cur = $answers_count[$key->option_number]['total_answer'] * 1.0; $percentage = $cur / $total_answer * 100.0; $answers_count[$key->option_number]['total_answer'] = number_format((double) $percentage, 2, '.', ''); } } catch (Exception $e) { $answers_count[1]['total_answer'] = 33; $answers_count[2]['total_answer'] = 33; $answers_count[3]['total_answer'] = 33; } $data['total_votes'] = $total_answer; $data['answers'] = $answers_count; } // ENd of Question Related Code // Top And Flop Post Generation $posts = Post::select('posts.*')->join('users', 'users.id', '=', 'posts.user_id')->where('users.disable', '0')->whereType('3')->orderBy('posts.id', 'desc')->take(30)->lists('id'); $top_post = DB::table('likes')->select(DB::raw('count(*) as like_count, post_id'))->whereIn('post_id', $posts)->orderBy('like_count', 'desc')->groupBy('post_id')->first(); // return json_encode($top_post); $flop_post = DB::table('dislikes')->select(DB::raw('count(*) as dislike_count, post_id'))->whereIn('post_id', $posts)->orderBy('dislike_count', 'desc')->groupBy('post_id')->first(); $data['flop_post'] = null; $data['top_post'] = null; if ($top_post) { $post = Post::whereId($top_post->post_id)->first(); /*19-May-2015 Ehsan*/ $user = User::find($post->user_id); $url = Picture::find($user->picture); $url = $url->url; /*!!!!19-May-2015 Ehsan*/ $text = htmlentities($post->post); /*Eve-26-May-Ehsan*/ /*!!!!Eve-26-May-Ehsan*/ $text = preg_replace('@(https?://([-\\w\\.]+)+(:\\d+)?(/([\\w/_\\.]*(\\?\\S+)?)?)?)@', '<a target="_blank" href="$1">$1</a>', $text); $text = preg_replace('/#([a-zA-Z0-9\\x{0980}-\\x{09FF}_])+/u', '<a href="#" class="tags">$0</a>', $text); $text = nl2br($text); $text = Emojione::shortnameToImage($text); $now = Carbon::parse($post->created_at); $data['top_post'] = array('id' => $post->id, 'post' => $text, 'user_id' => $post->user_id, 'img' => asset($url), 'like' => Like::wherePostId($post->id)->get()->count(), 'dislike' => Dislike::wherePostId($post->id)->get()->count(), 'liked' => Like::wherePostId($post->id)->whereUserId(Auth::user()->id)->get()->count(), 'disliked' => Dislike::wherePostId($post->id)->whereUserId(Auth::user()->id)->get()->count(), 'comment' => Comment::wherePostId($post->id)->get()->count(), 'ago' => $now->diffForHumans()); } else { $data['top_post'] = null; } if ($flop_post) { $post = Post::whereId($flop_post->post_id)->first(); /*19-May-2015 Ehsan*/ $user = User::find($post->user_id); $url = Picture::find($user->picture); $url = $url->url; /*!!!!19-May-2015 Ehsan*/ $text = htmlentities($post->post); /*Eve-26-May-Ehsan*/ /*!!!!Eve-26-May-Ehsan*/ $text = preg_replace('@(https?://([-\\w\\.]+)+(:\\d+)?(/([\\w/_\\.]*(\\?\\S+)?)?)?)@', '<a target="_blank" href="$1">$1</a>', $text); $text = preg_replace('/#([a-zA-Z0-9\\x{0980}-\\x{09FF}_])+/u', '<a href="#" class="tags">$0</a>', $text); $text = nl2br($text); $text = Emojione::shortnameToImage($text); $now = Carbon::parse($post->created_at); $data['flop_post'] = array('id' => $post->id, 'post' => $text, 'user_id' => $post->user_id, 'img' => asset($url), 'like' => Like::wherePostId($post->id)->get()->count(), 'dislike' => Dislike::wherePostId($post->id)->get()->count(), 'liked' => Like::wherePostId($post->id)->whereUserId(Auth::user()->id)->get()->count(), 'disliked' => Dislike::wherePostId($post->id)->whereUserId(Auth::user()->id)->get()->count(), 'comment' => Comment::wherePostId($post->id)->get()->count(), 'ago' => $now->diffForHumans()); } else { $data['flop_post'] = null; } // Top And Flop Post Generation end // Get All Available Reports and Feelings $data['feelings'] = Feeling::get(); $data['reports'] = Report::get(); // $data['notifications'] = $this->getNotification(); //Get Current Trends $now = Carbon::now(); $before_12hours = Carbon::now()->subHours(12); $data['tags'] = DB::table('hash_tagged_posts')->select('tag_id', 'tag', DB::raw('count(*) as count'))->join('hashtags', 'hashtags.id', '=', 'hash_tagged_posts.tag_id')->whereIn('hash_tagged_posts.post_id', function ($query) { $query->select('id')->from('posts')->whereType('3'); })->whereBetween('hash_tagged_posts.created_at', array($before_12hours, $now))->groupBy(['tag_id', 'tag'])->orderBy('count', 'desc')->take(3)->get(); //Get Current Trends End $data['page'] = "carnival"; return View::make('carnival')->with('data', $data); }
<?php require_once __DIR__ . '/Model.php'; require_once __DIR__ . '/Connect.php'; require_once __DIR__ . '/Post.php'; require_once __DIR__ . '/User.php'; $database = ['dsn' => 'mysql:host=localhost;dbname=ecole_multimedia', 'password' => 'root', 'username' => 'antoine']; $connect = new Connect($database); /* ------------------------------------------------- *\ Name of Model $postModel or $userModel ... \* ------------------------------------------------- */ $postModel = new Post($connect->getDB()); var_dump($postModel->count()); $posts = $postModel->select(['title', 'status', 'content'])->where('id', '>', 1)->where('status', '=', 'published')->get(); foreach ($posts as $post) { echo "<h1>{$post->title}</h1>"; } /* ------------------------------------------------- *\ Count method \* ------------------------------------------------- */ var_dump($postModel->count()); var_dump($postModel->where('id', '>', 1)->count()); /* ------------------------------------------------- *\ Method all \* ------------------------------------------------- */ var_dump($postModel->all()); $posts = $postModel->all(); foreach ($posts as $post) { echo "<h1>{$post->title}...</h1>"; } /* ------------------------------------------------- *\
public function ajaxGetNextPage($type, $page) { $skip = $page * 12; switch ($type) { case 'fresh': $images = Post::orderBy('created_at', 'desc'); break; case 'mine': $images = Post::where('user_id', Auth::id())->orderBy('created_at', 'desc'); break; case 'trending': $images = Post::select('posts.*', DB::raw('count(votes.id) as total'))->leftJoin('votes', 'posts.id', '=', 'votes.post_id')->groupBy('posts.id')->orderBy('total', 'desc'); break; default: $userid = explode('_', $type); $userid = $userid[1]; $images = Post::where('user_id', $userid)->orderBy('created_at', 'desc'); break; } if (Auth::user()) { $images = $images->with(array('votes' => function ($query) { $query->where('user_id', Auth::id()); })); } $images = $images->skip($skip)->take(12)->get(); $result = ''; if ($images->count() > 0) { foreach ($images as $img) { if (isset($img->votes)) { if (!empty($img->votes->first()) && $img->votes->first()->type == "like") { $classlike = 'activeAct like'; } else { $classlike = 'like'; } if (!empty($img->votes->first()) && $img->votes->first()->type == 'dislike') { $classdislike = 'activeAct dislike'; } else { $classdislike = 'dislike'; } $buttons = '<a href="#" class="' . $classlike . '" data-id="' . $img->id . '"><i class="fa fa-thumbs-up"></i></a> <a href="#" class="' . $classdislike . '" data-id="' . $img->id . '"><i class="fa fa-thumbs-down"></i></a>'; } else { $buttons = '<a class="disabledlike" data-toggle="modal" data-target="#modalSignin"><i class="fa fa-thumbs-up"></i></a> <a class="disabledlike" data-toggle="modal" data-target="#modalSignin"><i class="fa fa-thumbs-down"></i></a>'; } $attack = Comment::where('post_id', $img->id)->where('type', 'attack')->count(); $assist = Comment::where('post_id', $img->id)->where('type', 'assist')->count(); $defense = Comment::where('post_id', $img->id)->where('type', 'defense')->count(); $result = $result . '<div class="col-sm-12"> <a href="' . url('post/' . $img->slug) . '"><h3 class="text-left mtm0">' . str_limit($img->title, $limit = 50, $end = '...') . '</h3></a> <div class="imageBox"> <a href="' . url('post/' . $img->slug) . '"><img src="' . url('imgpost/' . $img->user_id . '/' . $img->image) . '" alt="' . $img->title . '" title="' . $img->title . '"></a> </div><!-- imageBox --> <div class="row infoBarTrend mt10 text-left"> <div class="leftBarTrend pull-left col-sm-7 col-xs-12"> <p class="inlineB">' . Vote::where('post_id', $img->id)->where('type', 'like')->count() . ' likes</p> <p class="inlineB ml10">' . Vote::where('post_id', $img->id)->where('type', 'dislike')->count() . ' dislikes</p> <p class="inlineB ml10">' . Comment::where('post_id', $img->id)->count() . ' comments</p> <div class="actionRow"> ' . $buttons . ' <a href="' . url('post/' . $img->slug) . '"><i class="fa fa-comment"></i></a> </div><!-- actionRow --> </div><!-- leftBarTrend --> <div class="rightBarTrend pull-right col-sm-5 col-xs-12"> <p><img src="' . asset('images/icon_attack.jpg') . '" alt="icon_attack"><span class="clrGrey"> Attack: </span><span> ' . $attack . ' </span> points</p> <p><img src="' . asset('images/icon_defense.jpg') . '" alt="icon_defense"><span class="clrGrey"> Defense: </span><span> ' . $assist . ' </span> points</p> <p><img src="' . asset('images/icon_assist.jpg') . '" alt="icon_assist"><span class="clrGrey"> Assist: </span><span> ' . $defense . ' </span> points</p> </div><!-- rightBarTrend --> </div><!-- infoBarTrend --> </div>'; } $nextpage = $page + 1; $result = $result . '<div class="col-sm-12 mt30 mb40"><a href="' . url('next/' . $type . '/' . $nextpage) . '" class="btn btn-default">Load More</a></div>'; } return $result; }
public function approve($user_id, $ip_addr) { self::connection()->executeSql("UPDATE tag_aliases SET is_pending = FALSE WHERE id = ?", $this->id); Post::select('posts.*')->joins('JOIN posts_tags pt ON posts.id = pt.post_id JOIN tags ON pt.tag_id = tags.id')->where("tags.name LIKE ?", $this->name)->take()->each(function ($post) use($user_id, $ip_addr) { $post->reload(); $post->updateAttributes(['tags' => $post->cached_tags, 'updater_user_id' => $user_id, 'updater_ip_addr' => $ip_addr]); }); Moebooru\CacheHelper::expire_tag_version(); }
/** * function for send ajax request to view * * @return Response */ public function listing_ajax() { $query = Post::select('id', 'title', 'user_id', 'category_id', 'created_at', 'show')->get(); return Datatable::collection($query)->addColumn('title', function ($model) { return '<a href="' . action('AdminPostsController@edit', $model->id) . '">' . $model->title . '</a>'; })->addColumn('author', function ($model) { return $model->user->name; })->addColumn('show', function ($model) { return $model->show == 0 ? 'Unpublished' : 'Published'; })->addColumn('category', function ($model) { return $model->category->name; })->showColumns('created_at')->addColumn('edit', function ($model) { return '<a href="' . action('AdminPostsController@edit', $model->id) . '" class="btn btn-success btn-constant"><i class="fa fa-edit fa-fw"></i>Edit</a>'; })->addColumn('delete', function ($model) { return '<form action="' . action('AdminPostsController@delete', $model->id) . '" method="POST"><button type="submit" class="btn btn-danger btn-constant" onclick = "return confirm(\'Are you sure?\')"><i class="fa fa-times fa-fw"></i>Delete</button></form>'; })->searchColumns('title', 'category')->orderColumns('id', 'title', 'created_at', 'category')->make(); }
/** * Show a list of all the blog posts formatted for Datatables. * * @return Datatables JSON */ public function getData() { $posts = Post::select(array('posts.id', 'posts.title', 'posts.id as comments', 'posts.created_at')); if (Api::Enabled()) { $u = $posts->get(); return Api::make($u->toArray()); } else { return Datatables::of($posts)->edit_column('comments', '{{ DB::table(\'comments\')->where(\'post_id\', \'=\', $id)->count() }}')->add_column('actions', '<div class="btn-group"><a href="{{{ URL::to(\'admin/slugs/\' . $id . \'/edit\' ) }}}" class="btn btn-primary btn-sm modalfy" >{{{ Lang::get(\'button.edit\') }}}</a> <a data-method="delete" data-row="{{{ $id }}}" data-table="blogs" href="{{{ URL::to(\'admin/slugs/\' . $id . \'\' ) }}}" class="ajax-alert-confirm btn btn-sm btn-danger">{{{ Lang::get(\'button.delete\') }}}</a></div> ')->make(); } }
public function blogShow() { $blogs = Post::select('id', 'title', 'body')->paginate(10); return View::make('blog.show')->with('blogs', $blogs); }