any way of showing pending comments? about rbcomment HOT 3 CLOSED

Hi,

I just released v1.4.0 (that I had in my backlog for a while now). You should be able to upgrade from 1.3.0 without problems as I have made no changes only adding new features and fixing bugs.

In this release I have added two new methods to the CommentTable class:

• fetchAllPendingForThread : This will return all the pending (visible === 0) comments for a thread.
• fetchAllUsingSelect : This allows executing custom queries against the comments table. The argument it takes is a Zend\Db\Sql\Select so you can make any query you might need.

I believe these two method should provide you with what you need.

To use the class you should add to your controller:

    /**
     * @var \RbComment\Model\CommentTable
     */
    protected $commentTable;

    /**
     * @return \RbComment\Model\CommentTable
     */
    public function getCommentTable()
    {
        if (!$this->commentTable) {
            $sm = $this->getServiceLocator();
            $this->commentTable = $sm->get('RbComment\Model\CommentTable');
        }

        return $this->commentTable;
    }

And then inside your action call:

public function myAction()
{
 ...
$pendingComments = $this->getCommentTable()->fetchAllPendingForThread($thread);
}

The thread is just the sha1() of the uri. If in doubt check: https://github.com/robertboloc/RbComment/blob/master/src/RbComment/View/Helper/Comment.php#L41

Hope this helps.

from rbcomment.

I extended the viewhelper and done it that way! Thanks though!

from rbcomment.

Ok, great! Closing the issue then.

from rbcomment.