public function prepareQueryBeforeCount(xPDOQuery $c)
{
$c = parent::prepareQueryBeforeCount($c);
$where = array('class_key' => 'SocietyBlog');
$c->where($where);
return $c;
}
protected function setSelection(xPDOQuery $c)
{
$c = parent::setSelection($c);
/*
Получаем данные диалоговой ветви
*/
$c->leftJoin('SocietyThread', 'thread', "thread.target_class='modResource' AND thread.target_id={$this->classKey}.id");
/*
Проверяем, есть ли голос пользователя здесь
*/
$c->leftJoin('SocietyVote', 'vote', "vote.target_class='modResource' AND vote.target_id={$this->classKey}.id AND vote.user_id = " . $this->modx->user->id);
$c->leftJoin('modUser', 'CreatedBy');
$c->select(array("CreatedBy.username as author_username", "thread.id as thread_id", "thread.positive_votes", "thread.negative_votes", "thread.comments_count", "vote.id as vote_id", "vote.vote_direction", "vote.vote_value"));
$c->prepare();
return $c;
}
