PHP Comment::all方法代码示例

 /**
  * Display a listing of the resource.
  *
  * @return Response
  */
 public function index()
 {
     //
     $id = Auth::id();
     $comment_data = Comment::all();
     foreach ($comment_data as $comment) {
         $user_id = $comment['user_id'];
         $user = User::getUserById($user_id);
         $comment['username'] = $user['username'];
         $comment['email'] = $user['email'];
         $post = Post::getPostById($comment["post_id"]);
         $comment['title'] = $post['title'];
         $format = "F j, Y, g:i a";
         $date = new DateTime($post['updated_at']);
         $formatDate = $date->format($format);
         $comment['update_time'] = $formatDate;
         if (isset($user['fb_img'])) {
             $comment['fb_img'] = $user['fb_img'];
         }
         if ($comment["user_id"] == $id) {
             $comment["owner"] = true;
         } else {
             $comment["owner"] = false;
         }
     }
     return Response::json($comment_data);
 }

 public function comments()
 {
     //$media = MediaFlag::groupBy('media_id')->get();
     $comments = Comment::all();
     $data = array('comments' => $comments);
     return View::make('admin.sections.comments', $data);
 }

 public function testGetListCommentSuccessNoComment()
 {
     $comment = Comment::destroy(1);
     $response = $this->call('GET', 'api/comment/1');
     $comment_infor = Comment::all();
     $this->assertEquals(array("code" => ApiResponse::OK, "data" => $comment_infor->toArray()), json_decode($response->getContent(), true));
 }

 /**
  * Comments list
  *
  * @param $request
  * @return mixed
  */
 public function comments_list($request)
 {
     // Delete page
     if ($request->get('delete')) {
         $delete = $request->get('delete');
         if ($delete != 'all') {
             $comment = \Comment::find_by_id(intval($delete));
             if ($comment) {
                 // Delete child comments
                 \Comment::table()->delete('parent_id = ' . $comment->id);
                 if ($comment->delete()) {
                     $this->view->assign('message', $this->lang->translate('form.deleted'));
                 }
             }
         } else {
             \Comment::table()->delete('1');
             $this->view->assign('message', $this->lang->translate('form.deleted'));
         }
     }
     // Filter
     $filter = [];
     if ($request->get('author')) {
         $author = \User::find($request->get('author'));
         if ($author) {
             $filter['conditions'] = ['author_id = ?', $author->id];
         }
     }
     $filter['order'] = 'id DESC';
     if ($request->order) {
         $filter['order'] = $request->order;
     }
     /** @var Listing $paginator */
     $paginator = NCService::load('Paginator.Listing', [$request->page, \Comment::count('all')]);
     $filter = array_merge($filter, $paginator->limit());
     // Filter users
     $comments = \Comment::all($filter);
     $comments = \Comment::as_array($comments);
     return $this->view->render('comment/list.twig', ['title' => $this->lang->translate('comment.list'), 'comments_list' => $comments, 'listing' => $paginator->pages(), 'page' => $paginator->cur_page]);
 }

|--------------------------------------------------------------------------
|
| This route group applies the "web" middleware group to every route
| it contains. The "web" middleware group is defined in your HTTP
| kernel and includes session state, CSRF protection, and more.
|
*/
Route::group(['middleware' => 'web'], function () {
    Route::auth();
    Route::get('/', 'HomeController@index')->middleware('guest');
    // Article Route
    Route::group(['middleware' => 'admin'], function () {
        Route::get('/articles/create', 'ArticlesController@create');
        Route::post('/articles', 'ArticlesController@store');
        Route::get('articles/{slug}/edit', 'ArticlesController@edit');
        Route::post('/articles/{slug}', 'ArticlesController@update');
        Route::delete('/articles/{slug}', 'ArticlesController@destroy');
    });
    Route::get('/articles', 'ArticlesController@index');
    Route::get('/articles/{slug?}', 'ArticlesController@show');
    // Comment Route
    Route::post('/articles/{slug?}/comment', 'CommentsController@store');
    Route::get('/articles/comment', function () {
        $comments = Comment::all();
        dd($comments);
        return null;
    });
    // Card Route
    Route::get('/cards/{username}', 'CardsController@index')->middleware('auth');
    Route::post('/cards/{username}', 'CardsController@update')->middleware('auth');
});

<?php

use App\Storage\{Comment\Comment, Post\Post, User\User};
/*
|--------------------------------------------------------------------------
| Model Factories
|--------------------------------------------------------------------------
|
| Here you may define all of your model factories. Model factories give
| you a convenient way to create models for testing and seeding your
| database. Just tell the factory how a default model should look.
|
*/
$factory->define(User::class, function ($faker) {
    return ['name' => str_replace('.', '_', $faker->userName), 'email' => $faker->unique()->email, 'password' => bcrypt('secret')];
});
$factory->defineAs(User::class, 'admin', function ($faker) use($factory) {
    $user = $factory->raw(User::class);
    return array_merge($user, ['role' => 'admin']);
});
$factory->define(Post::class, function ($faker) {
    $title = $faker->unique()->sentence;
    return ['title' => $title, 'content' => $faker->realText(5000), 'slug' => str_slug($title), 'user_id' => User::all()->random()->id, 'published_at' => $faker->dateTimeBetween('-1 month', '+15 days')];
});
$factory->define(Comment::class, function ($faker) {
    return ['post_id' => Post::published()->get()->random()->id, 'user_id' => User::all()->random()->id, 'body' => $faker->realText(500)];
});
$factory->defineAs(Comment::class, 'reply', function ($faker) use($factory) {
    $comment = $factory->raw(Comment::class);
    return array_merge($comment, ['parent_id' => Comment::all()->random()->id]);
});

 public function getComment()
 {
     $comments = Comment::all();
     return View::make('admin.comments.index')->with('comments', $comments);
 }

 public function getComments()
 {
     return Comment::all(['article_id' => $this->id]);
 }

 /**
  * Display a listing of comments
  *
  * @return Response
  */
 public function index()
 {
     $comments = Comment::all();
     return View::make('comments.index', compact('comments'));
 }

 public function comments()
 {
     $this->load->library('pagination');
     $comments = Comment::all();
     $config['base_url'] = base_url() . 'dashboard/comments/page/';
     $config['total_rows'] = $comments->count();
     $config['per_page'] = 5;
     $skip = ($this->uri->segment(4) - 1) * $config['per_page'];
     $this->pagination->initialize($config);
     $data = ['menu' => 'comments', 'comments' => Comment::skip($skip)->take($config['per_page'])->get(), 'links' => $this->pagination->create_links(), 'row' => $this->uri->segment(4) ? $config['per_page'] * ($this->uri->segment(4) - 1) : 0];
     $this->load->view('dashboard/comments', $data);
 }

 public function comment()
 {
     $comments = Comment::all();
     $act = 'list';
     $no = 0;
     return View::make('admin.comment', compact('comments', 'act', 'no'));
 }

 public function getIndex()
 {
     $comments = Comment::all();
     return View::make('admin.teacher.comments.commentIndex')->with(compact('comments'));
 }

function build_backend_subactions()
{
    global $backend_subactions, $pluginpages_handlers;
    $backend_subactions = url_action_subactions(array("_index" => url_action_alias(array("login")), "index" => url_action_alias(array("login")), "_prelude" => function (&$data, $url_now, &$url_next) {
        global $ratatoeskr_settings, $admin_grp, $ste, $languages;
        if ($admin_grp === NULL) {
            $admin_grp = Group::by_name("admins");
        }
        $ste->vars["all_languages"] = array();
        $ste->vars["all_langcodes"] = array();
        foreach ($languages as $code => $data) {
            $ste->vars["all_languages"][$code] = $data["language"];
            $ste->vars["all_langcodes"][] = $code;
        }
        ksort($ste->vars["all_languages"]);
        sort($ste->vars["all_langcodes"]);
        /* Check authentification */
        if (isset($_SESSION["ratatoeskr_uid"])) {
            try {
                $user = User::by_id($_SESSION["ratatoeskr_uid"]);
                if ($user->pwhash == $_SESSION["ratatoeskr_pwhash"] and $user->member_of($admin_grp)) {
                    if (empty($user->language)) {
                        $user->language = $ratatoeskr_settings["default_language"];
                        $user->save();
                    }
                    load_language($user->language);
                    if ($url_next[0] == "login") {
                        $url_next = array("content", "write");
                    }
                    $data["user"] = $user;
                    $ste->vars["user"] = array("id" => $user->get_id(), "name" => $user->username, "lang" => $user->language);
                    return;
                    /* Authentification successful, continue  */
                } else {
                    unset($_SESSION["ratatoeskr_uid"]);
                }
            } catch (DoesNotExistError $e) {
                unset($_SESSION["ratatoeskr_uid"]);
            }
        }
        load_language();
        /* If we are here, user is not logged in... */
        $url_next = array("login");
    }, "login" => url_action_simple(function ($data) {
        global $ste, $admin_grp;
        if (!empty($_POST["user"])) {
            try {
                $user = User::by_name($_POST["user"]);
                if (!PasswordHash::validate($_POST["password"], $user->pwhash)) {
                    throw new Exception();
                }
                if (!$user->member_of($admin_grp)) {
                    throw new Exception();
                }
                /* Login successful. */
                $_SESSION["ratatoeskr_uid"] = $user->get_id();
                $_SESSION["ratatoeskr_pwhash"] = $user->pwhash;
                load_language($user->language);
                $data["user"] = $user;
                $ste->vars["user"] = array("id" => $user->get_id(), "name" => $user->username, "lang" => $user->language);
            } catch (Exception $e) {
                $ste->vars["login_failed"] = True;
            }
            if (isset($data["user"])) {
                throw new Redirect(array("content", "write"));
            }
        }
        echo $ste->exectemplate("/systemtemplates/backend_login.html");
    }), "logout" => url_action_simple(function ($data) {
        unset($_SESSION["ratatoeskr_uid"]);
        unset($_SESSION["ratatoeskr_pwhash"]);
        load_language();
        throw new Redirect(array("login"));
    }), "content" => url_action_subactions(array("write" => function (&$data, $url_now, &$url_next) {
        global $ste, $translation, $textprocessors, $ratatoeskr_settings, $languages, $articleeditor_plugins;
        list($article, $editlang) = array_slice($url_next, 0);
        if (!isset($editlang)) {
            $editlang = $data["user"]->language;
        }
        if (isset($article)) {
            $ste->vars["article_editurl"] = urlencode($article) . "/" . urlencode($editlang);
        } else {
            $ste->vars["article_editurl"] = "";
        }
        $url_next = array();
        $default_section = Section::by_id($ratatoeskr_settings["default_section"]);
        $ste->vars["section"] = "content";
        $ste->vars["submenu"] = isset($article) ? "articles" : "newarticle";
        $ste->vars["textprocessors"] = array();
        foreach ($textprocessors as $txtproc => $properties) {
            if ($properties[1]) {
                $ste->vars["textprocessors"][] = $txtproc;
            }
        }
        $ste->vars["sections"] = array();
        foreach (Section::all() as $section) {
            $ste->vars["sections"][] = $section->name;
        }
        $ste->vars["article_section"] = $default_section->name;
        /* Check Form */
//.........这里部分代码省略.........

 public function getComments($parent)
 {
     return Comment::all(array('conditions' => array('video_id = ? AND parent = ?', $this->id, $parent), 'order' => 'timestamp desc'));
 }

									<div class="clearfix"></div>
								</div>
							</a>
						</div> <!-- /. panel-primary -->
					</div> <!-- /. col-lg-3 -->
					
					<div class="col-lg-3 col-md-6">
						<div class="panel panel-green">
							<div class="panel-heading">
								<div class="row">
									<div class="col-xs-3">
									<i class="fa fa-comments fa-5x"></i>
									</div>
									<div class="col-xs-9 text-right">
									<div class="huge"><?php 
echo Comment::all()->count();
?>
</div>
										<div>Total Comments!</div>
									</div>
								</div>
							</div>
							<a href="<?php 
echo site_url('dashboard/comments');
?>
">
								<div class="panel-footer">
									<span class="pull-left">View Details</span>
									<span class="pull-right"><i class="fa fa-arrow-circle-right"></i></span>
									<div class="clearfix"></div>
								</div>