Backend\Modules\Blog\Engine\Model::getCommentStatusCount PHP Method

getCommentStatusCount() public static method

Get a count per comment
public static getCommentStatusCount ( ) : array
return array
    public static function getCommentStatusCount()
    {
        return (array) BackendModel::getContainer()->get('database')->getPairs('SELECT i.status, COUNT(i.id)
             FROM blog_comments AS i
             WHERE i.language = ?
             GROUP BY i.status', array(BL::getWorkingLanguage()));
    }

Usage Example

Example #1
0
 /**
  * Load the data
  */
 private function loadData()
 {
     $this->comments = BackendBlogModel::getLatestComments('published', 5);
     $this->numCommentStatus = BackendBlogModel::getCommentStatusCount();
 }