/**
* prepare frontend wall replies render
*
* @param WallTable $reply
* @param GroupTable $group
* @param UserTable $user
* @return array|null
*/
public function showReplies( $reply, $group, $user )
{
global $_CB_framework, $_CB_database;
CBGroupJive::getTemplate( 'replies', true, true, $this->element );
$canModerate = ( CBGroupJive::isModerator( $user->get( 'id' ) ) || ( CBGroupJive::getGroupStatus( $user, $group ) >= 2 ) );
$limit = (int) $this->params->get( 'groups_wall_replies_limit', 15 );
$limitstart = $_CB_framework->getUserStateFromRequest( 'gj_group_wall_replies_limitstart{com_comprofiler}', 'gj_group_wall_replies_limitstart' );
if ( $reply->get( '_replies' ) ) {
$query = 'SELECT COUNT(*)'
. "\n FROM " . $_CB_database->NameQuote( '#__groupjive_plugin_wall' ) . " AS r"
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__comprofiler' ) . " AS cb"
. ' ON cb.' . $_CB_database->NameQuote( 'id' ) . ' = r.' . $_CB_database->NameQuote( 'user_id' )
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__users' ) . " AS j"
. ' ON j.' . $_CB_database->NameQuote( 'id' ) . ' = cb.' . $_CB_database->NameQuote( 'id' )
. "\n WHERE r." . $_CB_database->NameQuote( 'group' ) . " = " . (int) $group->get( 'id' )
. "\n AND r." . $_CB_database->NameQuote( 'reply' ) . " = " . (int) $reply->get( 'id' )
. "\n AND cb." . $_CB_database->NameQuote( 'approved' ) . " = 1"
. "\n AND cb." . $_CB_database->NameQuote( 'confirmed' ) . " = 1"
. "\n AND j." . $_CB_database->NameQuote( 'block' ) . " = 0";
if ( ! $canModerate ) {
$query .= "\n AND ( r." . $_CB_database->NameQuote( 'user_id' ) . " = " . (int) $user->get( 'id' )
. ' OR r.' . $_CB_database->NameQuote( 'published' ) . ' = 1 )';
}
$_CB_database->setQuery( $query );
$total = (int) $_CB_database->loadResult();
} else {
$total = 0;
}
if ( ( ! $total ) && ( ! CBGroupJive::canCreateGroupContent( $user, $group, 'wall' ) ) ) {
return null;
}
$pageNav = new cbPageNav( $total, $limitstart, $limit );
$pageNav->setClasses( array( 'cbPaginationLinks' => 'cbPaginationLinks pagination pagination-sm' ) );
$pageNav->setInputNamePrefix( 'gj_group_wall_replies_' );
if ( $reply->get( '_replies' ) ) {
switch( (int) $this->params->get( 'groups_wall_replies_orderby', 2 ) ) {
case 1:
$orderBy = 'r.' . $_CB_database->NameQuote( 'date' ) . ' ASC';
break;
case 2:
default:
$orderBy = 'r.' . $_CB_database->NameQuote( 'date' ) . ' DESC';
break;
}
$query = 'SELECT r.*'
. "\n FROM " . $_CB_database->NameQuote( '#__groupjive_plugin_wall' ) . " AS r"
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__comprofiler' ) . " AS cb"
. ' ON cb.' . $_CB_database->NameQuote( 'id' ) . ' = r.' . $_CB_database->NameQuote( 'user_id' )
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__users' ) . " AS j"
. ' ON j.' . $_CB_database->NameQuote( 'id' ) . ' = cb.' . $_CB_database->NameQuote( 'id' )
. "\n WHERE r." . $_CB_database->NameQuote( 'group' ) . " = " . (int) $group->get( 'id' )
. "\n AND r." . $_CB_database->NameQuote( 'reply' ) . " = " . (int) $reply->get( 'id' )
. "\n AND cb." . $_CB_database->NameQuote( 'approved' ) . " = 1"
. "\n AND cb." . $_CB_database->NameQuote( 'confirmed' ) . " = 1"
. "\n AND j." . $_CB_database->NameQuote( 'block' ) . " = 0";
if ( ! $canModerate ) {
$query .= "\n AND ( r." . $_CB_database->NameQuote( 'user_id' ) . " = " . (int) $user->get( 'id' )
. ' OR r.' . $_CB_database->NameQuote( 'published' ) . ' = 1 )';
}
$query .= "\n ORDER BY " . $orderBy;
if ( $this->params->get( 'groups_wall_replies_paging', 1 ) ) {
$_CB_database->setQuery( $query, $pageNav->limitstart, $pageNav->limit );
} else {
$_CB_database->setQuery( $query );
}
$rows = $_CB_database->loadObjectList( null, '\CB\Plugin\GroupJiveWall\Table\WallTable', array( $_CB_database ) );
CBGroupJiveWall::getPost( $rows );
CBGroupJive::preFetchUsers( $rows );
} else {
$rows = array();
}
return HTML_groupjiveWallReplies::showReplies( $reply, $rows, $pageNav, $group, $user, $this );
}
