/**
* prepare frontend about render
*
* @param string $return
* @param GroupTable $group
* @param string $users
* @param string $invites
* @param array $counters
* @param array $buttons
* @param array $menu
* @param cbTabs $tabs
* @param UserTable $user
* @return array|null
*/
public function showAbout( &$return, &$group, &$users, &$invites, &$counters, &$buttons, &$menu, &$tabs, $user )
{
global $_CB_framework;
if ( CBGroupJive::isModerator( $user->get( 'id' ) ) || ( ( $group->get( 'published' ) == 1 ) && ( CBGroupJive::getGroupStatus( $user, $group ) >= 3 ) ) ) {
$menu[] = '<a href="' . $_CB_framework->pluginClassUrl( $this->element, true, array( 'action' => 'about', 'func' => 'edit', 'id' => (int) $group->get( 'id' ) ) ) . '"><span class="fa fa-edit"></span> ' . CBTxt::T( 'About' ) . '</a>';
}
$about = trim( $group->params()->get( 'about_content' ) );
if ( ( ! $about ) || ( $about == '<p></p>' ) ) {
return null;
}
CBGroupJive::getTemplate( 'about', true, true, $this->element );
if ( $this->params->get( 'groups_about_substitutions', 0 ) ) {
$about = CBuser::getInstance( (int) $user->get( 'id' ), false )->replaceUserVars( $about, false, false, null, false );
}
if ( $this->params->get( 'groups_about_content_plugins', 0 ) ) {
$about = Application::Cms()->prepareHtmlContentPlugins( $about );
}
return array( 'id' => 'about',
'title' => CBTxt::T( 'About' ),
'content' => HTML_groupjiveAbout::showAbout( $about, $group, $user, $this )
);
}
/**
* save invite
*
* @param int $id
* @param UserTable $user
*/
private function saveInviteEdit( $id, $user )
{
global $_CB_framework, $_CB_database, $_PLUGINS;
$row = new InviteTable();
$row->load( (int) $id );
$isModerator = CBGroupJive::isModerator( $user->get( 'id' ) );
$groupId = $this->input( 'group', null, GetterInterface::INT );
if ( $groupId === null ) {
$group = $row->group();
} else {
$group = CBGroupJive::getGroup( $groupId );
}
$returnUrl = $_CB_framework->pluginClassUrl( $this->element, false, array( 'action' => 'groups', 'func' => 'show', 'id' => (int) $group->get( 'id' ) ) );
if ( ! CBGroupJive::canAccessGroup( $group, $user ) ) {
cbRedirect( $returnUrl, CBTxt::T( 'Group does not exist.' ), 'error' );
} elseif ( $row->get( 'id' ) && ( $user->get( 'id' ) != $row->get( 'user_id' ) ) ) {
cbRedirect( $returnUrl, CBTxt::T( 'You do not have sufficient permissions to edit this invite.' ), 'error' );
} elseif ( ! $isModerator ) {
if ( ( $group->get( 'published' ) == -1 ) || ( ( ! $this->params->get( 'groups_invites_display', 1 ) ) && ( $group->get( 'type' ) != 3 ) ) ) {
cbRedirect( $returnUrl, CBTxt::T( 'You do not have access to invites in this group.' ), 'error' );
} elseif ( ( ! $row->get( 'id' ) ) && ( ! CBGroupJive::canCreateGroupContent( $user, $group, 'invites' ) ) ) {
cbRedirect( $returnUrl, CBTxt::T( 'You do not have sufficient permissions to create an invite in this group.' ), 'error' );
}
}
$skipCaptcha = false;
$row->set( 'message', $this->input( 'post/message', $row->get( 'message' ), GetterInterface::STRING ) );
if ( ! $row->get( 'id' ) ) {
$row->set( 'user_id', (int) $row->get( 'user_id', $user->get( 'id' ) ) );
$row->set( 'group', (int) $group->get( 'id' ) );
$to = $this->input( 'post/to', null, GetterInterface::STRING );
$selected = (int) $this->input( 'post/selected', 0, GetterInterface::INT );
if ( $selected ) {
$token = $this->input( 'post/token', null, GetterInterface::STRING );
if ( $token ) {
if ( $token == md5( $row->get( 'user_id' ) . $to . $row->get( 'group' ) . $row->get( 'message' ) . $_CB_framework->getCfg( 'secret' ) ) ) {
$skipCaptcha = true;
$row->set( 'user', (int) $selected );
}
} elseif ( $this->params->get( 'groups_invites_list', 0 ) ) {
$connections = array();
$cbConnection = new cbConnection( (int) $user->get( 'id' ) );
foreach( $cbConnection->getConnectedToMe( (int) $user->get( 'id' ) ) as $connection ) {
$connections[] = (int) $connection->id;
}
if ( in_array( $selected, $connections ) ) {
$row->set( 'user', (int) $selected );
}
}
} else {
$inviteByLimit = explode( '|*|', $this->params->get( 'groups_invites_by', '1|*|2|*|3|*|4' ) );
if ( ! $inviteByLimit ) {
$inviteByLimit = array( 1, 2, 3, 4 );
}
$recipient = new UserTable();
if ( in_array( 1, $inviteByLimit ) && $recipient->load( (int) $to ) ) {
$row->set( 'user', (int) $recipient->get( 'id' ) );
} elseif ( in_array( 4, $inviteByLimit ) && cbIsValidEmail( $to ) ) {
if ( $recipient->load( array( 'email' => $to ) ) ) {
$row->set( 'user', (int) $recipient->get( 'id' ) );
} else {
$row->set( 'email', $to );
}
} elseif ( in_array( 2, $inviteByLimit ) && $recipient->load( array( 'username' => $to ) ) ) {
$row->set( 'user', (int) $recipient->get( 'id' ) );
} elseif ( in_array( 3, $inviteByLimit ) ) {
$query = 'SELECT cb.' . $_CB_database->NameQuote( 'id' )
. "\n FROM " . $_CB_database->NameQuote( '#__comprofiler' ) . " AS cb"
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__users' ) . " AS j"
. ' ON j.' . $_CB_database->NameQuote( 'id' ) . ' = cb.' . $_CB_database->NameQuote( 'id' )
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__groupjive_users' ) . " AS u"
. ' ON u.' . $_CB_database->NameQuote( 'user_id' ) . ' = cb.' . $_CB_database->NameQuote( 'id' )
. ' AND u.' . $_CB_database->NameQuote( 'group' ) . ' = ' . (int) $group->get( 'id' )
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__groupjive_invites' ) . " AS i"
. ' ON i.' . $_CB_database->NameQuote( 'group' ) . ' = ' . (int) $group->get( 'id' )
. ' AND i.' . $_CB_database->NameQuote( 'user' ) . ' = cb.' . $_CB_database->NameQuote( 'id' )
. "\n WHERE j." . $_CB_database->NameQuote( 'name' ) . " LIKE " . $_CB_database->Quote( '%' . $_CB_database->getEscaped( $to, true ) . '%', false )
. "\n AND cb." . $_CB_database->NameQuote( 'approved' ) . " = 1"
. "\n AND cb." . $_CB_database->NameQuote( 'confirmed' ) . " = 1"
. "\n AND j." . $_CB_database->NameQuote( 'block' ) . " = 0"
. "\n AND u." . $_CB_database->NameQuote( 'id' ) . " IS NULL"
. "\n AND i." . $_CB_database->NameQuote( 'id' ) . " IS NULL"
. "\n ORDER BY j." . $_CB_database->NameQuote( 'registerDate' ) . " DESC";
$_CB_database->setQuery( $query, 0, 15 );
$users = $_CB_database->loadResultArray();
if ( $users ) {
if ( count( $users ) > 1 ) {
CBGroupJive::getTemplate( 'invite_list' );
CBuser::advanceNoticeOfUsersNeeded( $users );
HTML_groupjiveInviteList::showInviteList( $to, $users, $row, $group, $user, $this );
return;
} else {
$row->set( 'user', (int) $users[0] );
}
}
}
}
}
if ( ( ! $isModerator ) && $this->params->get( 'groups_create_captcha', 0 ) && ( ! $skipCaptcha ) ) {
$_PLUGINS->loadPluginGroup( 'user' );
$_PLUGINS->trigger( 'onCheckCaptchaHtmlElements', array() );
if ( $_PLUGINS->is_errors() ) {
$row->setError( $_PLUGINS->getErrorMSG() );
}
}
$new = ( $row->get( 'id' ) ? false : true );
if ( $row->getError() || ( ! $row->check() ) ) {
$_CB_framework->enqueueMessage( CBTxt::T( 'GROUP_INVITE_FAILED_TO_SAVE', 'Invite failed to save! Error: [error]', array( '[error]' => $row->getError() ) ), 'error' );
$this->showInviteEdit( $id, $user );
return;
}
if ( $row->getError() || ( ! $row->store() ) ) {
$_CB_framework->enqueueMessage( CBTxt::T( 'GROUP_INVITE_FAILED_TO_SAVE', 'Invite failed to save! Error: [error]', array( '[error]' => $row->getError() ) ), 'error' );
$this->showInviteEdit( $id, $user );
return;
}
if ( $new ) {
cbRedirect( $returnUrl, CBTxt::T( 'Invite created successfully!' ) );
} else {
cbRedirect( $returnUrl, CBTxt::T( 'Invite saved successfully!' ) );
}
}
/**
* prepare frontend events render
*
* @param string $return
* @param GroupTable $group
* @param string $users
* @param string $invites
* @param array $counters
* @param array $buttons
* @param array $menu
* @param cbTabs $tabs
* @param UserTable $user
* @return array|null
*/
public function showEvents( &$return, &$group, &$users, &$invites, &$counters, &$buttons, &$menu, &$tabs, $user )
{
global $_CB_framework, $_CB_database;
CBGroupJive::getTemplate( 'events', true, true, $this->element );
$canModerate = ( CBGroupJive::isModerator( $user->get( 'id' ) ) || ( CBGroupJive::getGroupStatus( $user, $group ) >= 2 ) );
$limit = (int) $this->params->get( 'groups_events_limit', 15 );
$limitstart = $_CB_framework->getUserStateFromRequest( 'gj_group_events_limitstart{com_comprofiler}', 'gj_group_events_limitstart' );
$search = $_CB_framework->getUserStateFromRequest( 'gj_group_events_search{com_comprofiler}', 'gj_group_events_search' );
$where = null;
if ( $search && $this->params->get( 'groups_events_search', 1 ) ) {
$where .= "\n AND ( e." . $_CB_database->NameQuote( 'title' ) . " LIKE " . $_CB_database->Quote( '%' . $_CB_database->getEscaped( $search, true ) . '%', false )
. " OR e." . $_CB_database->NameQuote( 'event' ) . " LIKE " . $_CB_database->Quote( '%' . $_CB_database->getEscaped( $search, true ) . '%', false )
. " OR e." . $_CB_database->NameQuote( 'address' ) . " LIKE " . $_CB_database->Quote( '%' . $_CB_database->getEscaped( $search, true ) . '%', false )
. " OR e." . $_CB_database->NameQuote( 'location' ) . " LIKE " . $_CB_database->Quote( '%' . $_CB_database->getEscaped( $search, true ) . '%', false ) . " )";
}
$searching = ( $where ? true : false );
$query = 'SELECT COUNT(*)'
. "\n FROM " . $_CB_database->NameQuote( '#__groupjive_plugin_events' ) . " AS e"
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__comprofiler' ) . " AS cb"
. ' ON cb.' . $_CB_database->NameQuote( 'id' ) . ' = e.' . $_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 e." . $_CB_database->NameQuote( 'group' ) . " = " . (int) $group->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 ( e." . $_CB_database->NameQuote( 'user_id' ) . " = " . (int) $user->get( 'id' )
. ' OR e.' . $_CB_database->NameQuote( 'published' ) . ' = 1 )';
}
$query .= $where;
$_CB_database->setQuery( $query );
$total = (int) $_CB_database->loadResult();
if ( ( ! $total ) && ( ! $searching ) && ( ! CBGroupJive::canCreateGroupContent( $user, $group, 'events' ) ) ) {
return null;
}
$pageNav = new cbPageNav( $total, $limitstart, $limit );
$pageNav->setInputNamePrefix( 'gj_group_events_' );
$guests = 'SELECT COUNT(*)'
. "\n FROM " . $_CB_database->NameQuote( '#__groupjive_plugin_events_attendance' ) . " AS ea"
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__comprofiler' ) . " AS eacb"
. ' ON eacb.' . $_CB_database->NameQuote( 'id' ) . ' = ea.' . $_CB_database->NameQuote( 'user_id' )
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__users' ) . " AS eaj"
. ' ON eaj.' . $_CB_database->NameQuote( 'id' ) . ' = eacb.' . $_CB_database->NameQuote( 'id' )
. "\n WHERE ea." . $_CB_database->NameQuote( 'event' ) . " = e." . $_CB_database->NameQuote( 'id' )
. "\n AND eacb." . $_CB_database->NameQuote( 'approved' ) . " = 1"
. "\n AND eacb." . $_CB_database->NameQuote( 'confirmed' ) . " = 1"
. "\n AND eaj." . $_CB_database->NameQuote( 'block' ) . " = 0";
$now = Application::Database()->getUtcDateTime();
$query = 'SELECT e.*'
. ', TIMESTAMPDIFF( SECOND, ' . $_CB_database->Quote( $now ) . ',e.' . $_CB_database->NameQuote( 'start' ) . ' ) AS _start_ordering'
. ', TIMESTAMPDIFF( SECOND, ' . $_CB_database->Quote( $now ) . ', e.' . $_CB_database->NameQuote( 'end' ) . ' ) AS _end_ordering'
. ', a.' . $_CB_database->NameQuote( 'id' ) . ' AS _attending'
. ', ( ' . $guests . ' ) AS _guests'
. "\n FROM " . $_CB_database->NameQuote( '#__groupjive_plugin_events' ) . " AS e"
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__comprofiler' ) . " AS cb"
. ' ON cb.' . $_CB_database->NameQuote( 'id' ) . ' = e.' . $_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 LEFT JOIN " . $_CB_database->NameQuote( '#__groupjive_plugin_events_attendance' ) . " AS a"
. ' ON a.' . $_CB_database->NameQuote( 'user_id' ) . ' = ' . (int) $user->get( 'id' )
. ' AND a.' . $_CB_database->NameQuote( 'event' ) . ' = e.' . $_CB_database->NameQuote( 'id' )
. "\n WHERE e." . $_CB_database->NameQuote( 'group' ) . " = " . (int) $group->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 ( e." . $_CB_database->NameQuote( 'user_id' ) . " = " . (int) $user->get( 'id' )
. ' OR e.' . $_CB_database->NameQuote( 'published' ) . ' = 1 )';
}
$query .= $where
. "\n ORDER BY IF( _start_ordering < 0 AND _end_ordering > 0, 1, IF( _start_ordering > 0, 2, 3 ) ), ABS( _start_ordering )";
if ( $this->params->get( 'groups_events_paging', 1 ) ) {
$_CB_database->setQuery( $query, $pageNav->limitstart, $pageNav->limit );
} else {
$_CB_database->setQuery( $query );
}
$rows = $_CB_database->loadObjectList( null, '\CB\Plugin\GroupJiveEvents\Table\EventTable', array( $_CB_database ) );
$input = array();
$input['search'] = '<input type="text" name="gj_group_events_search" value="' . htmlspecialchars( $search ) . '" onchange="document.gjGroupEventsForm.submit();" placeholder="' . htmlspecialchars( CBTxt::T( 'Search Events...' ) ) . '" class="form-control" />';
CBGroupJiveEvents::getEvent( $rows );
CBGroupJive::preFetchUsers( $rows );
$group->set( '_events', $pageNav->total );
return array( 'id' => 'events',
'title' => CBTxt::T( 'Events' ),
'content' => HTML_groupjiveEvents::showEvents( $rows, $pageNav, $searching, $input, $counters, $group, $user, $this )
);
}
/**
* prepare frontend tab render
*
* @param TabTable $tab
* @param UserTable $user
* @param int $ui
* @return null|string
*/
public function getDisplayTab( $tab, $user, $ui )
{
global $_CB_framework, $_CB_database;
if ( ! ( $tab->params instanceof ParamsInterface ) ) {
$tab->params = new Registry( $tab->params );
}
$viewer = CBuser::getMyUserDataInstance();
$isModerator = CBGroupJive::isModerator( $viewer->get( 'id' ) );
$isOwner = ( $viewer->get( 'id' ) == $user->get( 'id' ) );
CBGroupJive::getTemplate( 'tab' );
$limit = (int) $tab->params->get( 'tab_limit', 30 );
$limitstart = $_CB_framework->getUserStateFromRequest( 'gj_tab_limitstart{com_comprofiler}', 'gj_tab_limitstart' );
$search = $_CB_framework->getUserStateFromRequest( 'gj_tab_search{com_comprofiler}', 'gj_tab_search' );
$where = null;
if ( $search && $tab->params->get( 'tab_search', 1 ) ) {
$where .= "\n AND ( g." . $_CB_database->NameQuote( 'name' ) . " LIKE " . $_CB_database->Quote( '%' . $_CB_database->getEscaped( $search, true ) . '%', false )
. " OR g." . $_CB_database->NameQuote( 'description' ) . " LIKE " . $_CB_database->Quote( '%' . $_CB_database->getEscaped( $search, true ) . '%', false ) . " )";
}
$searching = ( $where ? true : false );
$query = 'SELECT COUNT(*)'
. "\n FROM " . $_CB_database->NameQuote( '#__groupjive_groups' ) . " AS g";
if ( ! $isModerator ) {
$query .= "\n LEFT JOIN " . $_CB_database->NameQuote( '#__groupjive_categories' ) . " AS c"
. ' ON c.' . $_CB_database->NameQuote( 'id' ) . ' = g.' . $_CB_database->NameQuote( 'category' );
}
$query .= "\n LEFT JOIN " . $_CB_database->NameQuote( '#__groupjive_users' ) . " AS u"
. ' ON u.' . $_CB_database->NameQuote( 'group' ) . ' = g.' . $_CB_database->NameQuote( 'id' )
. ' AND u.' . $_CB_database->NameQuote( 'user_id' ) . ' = ' . (int) $user->get( 'id' )
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__groupjive_invites' ) . " AS i"
. ' ON i.' . $_CB_database->NameQuote( 'group' ) . ' = g.' . $_CB_database->NameQuote( 'id' )
. ' AND i.' . $_CB_database->NameQuote( 'accepted' ) . ' = ' . $_CB_database->Quote( '0000-00-00 00:00:00' )
. ' AND ( ( i.' . $_CB_database->NameQuote( 'email' ) . ' = ' . $_CB_database->Quote( $user->get( 'email' ) )
. ' AND i.' . $_CB_database->NameQuote( 'email' ) . ' != "" )'
. ' OR ( i.' . $_CB_database->NameQuote( 'user' ) . ' = ' . (int) $user->get( 'id' )
. ' AND i.' . $_CB_database->NameQuote( 'user' ) . ' > 0 ) )';
if ( $isOwner ) {
$query .= "\n WHERE ( g." . $_CB_database->NameQuote( 'user_id' ) . " = " . (int) $user->get( 'id' );
if ( ! $isModerator ) {
$query .= ' OR ( g.' . $_CB_database->NameQuote( 'published' ) . ' = 1'
. ' AND ( u.' . $_CB_database->NameQuote( 'status' ) . ' IN ( 0, 1, 2, 3 )'
. ' OR i.' . $_CB_database->NameQuote( 'id' ) . ' IS NOT NULL ) ) )';
} else {
$query .= ' OR u.' . $_CB_database->NameQuote( 'status' ) . ' IN ( 0, 1, 2, 3 )'
. ' OR i.' . $_CB_database->NameQuote( 'id' ) . ' IS NOT NULL )';
}
} else {
$query .= "\n LEFT JOIN " . $_CB_database->NameQuote( '#__groupjive_users' ) . " AS mu"
. ' ON mu.' . $_CB_database->NameQuote( 'group' ) . ' = g.' . $_CB_database->NameQuote( 'id' )
. ' AND mu.' . $_CB_database->NameQuote( 'user_id' ) . ' = ' . (int) $viewer->get( 'id' )
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__groupjive_invites' ) . " AS mi"
. ' ON mi.' . $_CB_database->NameQuote( 'group' ) . ' = g.' . $_CB_database->NameQuote( 'id' )
. ' AND mi.' . $_CB_database->NameQuote( 'accepted' ) . ' = ' . $_CB_database->Quote( '0000-00-00 00:00:00' )
. ' AND ( ( mi.' . $_CB_database->NameQuote( 'email' ) . ' = ' . $_CB_database->Quote( $viewer->get( 'email' ) )
. ' AND mi.' . $_CB_database->NameQuote( 'email' ) . ' != "" )'
. ' OR ( mi.' . $_CB_database->NameQuote( 'user' ) . ' = ' . (int) $viewer->get( 'id' )
. ' AND mi.' . $_CB_database->NameQuote( 'user' ) . ' > 0 ) )'
. "\n WHERE ( g." . $_CB_database->NameQuote( 'user_id' ) . " = " . (int) $user->get( 'id' );
if ( ! $isModerator ) {
$query .= ' OR ( g.' . $_CB_database->NameQuote( 'published' ) . ' = 1'
. ' AND u.' . $_CB_database->NameQuote( 'status' ) . ' IN ( 1, 2, 3 ) ) )'
. "\n AND ( g." . $_CB_database->NameQuote( 'user_id' ) . " = " . (int) $viewer->get( 'id' )
. ' OR ( g.' . $_CB_database->NameQuote( 'published' ) . ' = 1'
. ' AND ( g.' . $_CB_database->NameQuote( 'type' ) . ' IN ( 1, 2 )'
. ' OR mu.' . $_CB_database->NameQuote( 'status' ) . ' IN ( 0, 1, 2, 3 )'
. ' OR mi.' . $_CB_database->NameQuote( 'id' ) . ' IS NOT NULL ) ) )';
} else {
$query .= ' OR u.' . $_CB_database->NameQuote( 'status' ) . ' IN ( 1, 2, 3 ) )';
}
}
if ( ! $isModerator ) {
$query .= "\n AND ( ( c." . $_CB_database->NameQuote( 'published' ) . " = 1"
. ' AND c.' . $_CB_database->NameQuote( 'access' ) . ' IN ' . $_CB_database->safeArrayOfIntegers( CBGroupJive::getAccess( (int) $user->get( 'id' ) ) )
. ' AND c.' . $_CB_database->NameQuote( 'access' ) . ' IN ' . $_CB_database->safeArrayOfIntegers( CBGroupJive::getAccess( (int) $viewer->get( 'id' ) ) ) . ' )'
. ( $this->params->get( 'groups_uncategorized', 1 ) ? ' OR g.' . $_CB_database->NameQuote( 'category' ) . ' = 0 )' : ' )' );
}
$query .= $where;
$_CB_database->setQuery( $query );
$total = (int) $_CB_database->loadResult();
if ( ( ! $total ) && ( ! $searching ) && ( ( ! $isOwner ) || ( $isOwner && ( ! CBGroupJive::canCreateGroup( $user ) ) ) ) && ( ! Application::Config()->get( 'showEmptyTabs', 1 ) ) ) {
return null;
}
$pageNav = new cbPageNav( $total, $limitstart, $limit );
$pageNav->setInputNamePrefix( 'gj_tab_' );
switch( (int) $tab->params->get( 'tab_orderby', 1 ) ) {
case 2:
$orderBy = 'g.' . $_CB_database->NameQuote( 'ordering' ) . ' DESC';
break;
case 3:
$orderBy = 'g.' . $_CB_database->NameQuote( 'date' ) . ' ASC';
break;
case 4:
$orderBy = 'g.' . $_CB_database->NameQuote( 'date' ) . ' DESC';
break;
case 5:
$orderBy = 'g.' . $_CB_database->NameQuote( 'name' ) . ' ASC';
break;
case 6:
$orderBy = 'g.' . $_CB_database->NameQuote( 'name' ) . ' DESC';
break;
case 7:
$orderBy = $_CB_database->NameQuote( '_users' ) . ' ASC';
break;
case 8:
$orderBy = $_CB_database->NameQuote( '_users' ) . ' DESC';
break;
case 1:
default:
$orderBy = 'g.' . $_CB_database->NameQuote( 'ordering' ) . ' ASC';
break;
}
$users = 'SELECT COUNT(*)'
. "\n FROM " . $_CB_database->NameQuote( '#__groupjive_users' ) . " AS uc"
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__comprofiler' ) . " AS uccb"
. ' ON uccb.' . $_CB_database->NameQuote( 'id' ) . ' = uc.' . $_CB_database->NameQuote( 'user_id' )
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__users' ) . " AS ucj"
. ' ON ucj.' . $_CB_database->NameQuote( 'id' ) . ' = uccb.' . $_CB_database->NameQuote( 'id' )
. "\n WHERE uc." . $_CB_database->NameQuote( 'group' ) . " = g." . $_CB_database->NameQuote( 'id' )
. "\n AND uccb." . $_CB_database->NameQuote( 'approved' ) . " = 1"
. "\n AND uccb." . $_CB_database->NameQuote( 'confirmed' ) . " = 1"
. "\n AND ucj." . $_CB_database->NameQuote( 'block' ) . " = 0";
if ( ! $isModerator ) {
$users .= "\n AND ( g." . $_CB_database->NameQuote( 'user_id' ) . " = " . (int) $viewer->get( 'id' )
. ( ! $isOwner ? ' OR mu.' . $_CB_database->NameQuote( 'status' ) . ' >= 2' : null )
. ' OR uc.' . $_CB_database->NameQuote( 'status' ) . ' >= 1 )';
}
if ( ! $this->params->get( 'groups_users_owner', 1 ) ) {
$users .= "\n AND uc." . $_CB_database->NameQuote( 'status' ) . " != 4";
}
$query = 'SELECT g.*'
. ', c.' . $_CB_database->NameQuote( 'name' ) . ' AS _category_name';
if ( $isOwner ) {
$query .= ', u.' . $_CB_database->NameQuote( 'status' ) . ' AS _user_status'
. ', i.' . $_CB_database->NameQuote( 'id' ) . ' AS _invite_id';
} else {
$query .= ', mu.' . $_CB_database->NameQuote( 'status' ) . ' AS _user_status'
. ', mi.' . $_CB_database->NameQuote( 'id' ) . ' AS _invite_id';
}
$query .= ', ( ' . $users . ' ) AS _users'
. "\n FROM " . $_CB_database->NameQuote( '#__groupjive_groups' ) . " AS g"
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__groupjive_categories' ) . " AS c"
. ' ON c.' . $_CB_database->NameQuote( 'id' ) . ' = g.' . $_CB_database->NameQuote( 'category' )
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__groupjive_users' ) . " AS u"
. ' ON u.' . $_CB_database->NameQuote( 'user_id' ) . ' = ' . (int) $user->get( 'id' )
. ' AND u.' . $_CB_database->NameQuote( 'group' ) . ' = g.' . $_CB_database->NameQuote( 'id' )
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__groupjive_invites' ) . " AS i"
. ' ON i.' . $_CB_database->NameQuote( 'group' ) . ' = g.' . $_CB_database->NameQuote( 'id' )
. ' AND i.' . $_CB_database->NameQuote( 'accepted' ) . ' = ' . $_CB_database->Quote( '0000-00-00 00:00:00' )
. ' AND ( ( i.' . $_CB_database->NameQuote( 'email' ) . ' = ' . $_CB_database->Quote( $user->get( 'email' ) )
. ' AND i.' . $_CB_database->NameQuote( 'email' ) . ' != "" )'
. ' OR ( i.' . $_CB_database->NameQuote( 'user' ) . ' = ' . (int) $user->get( 'id' )
. ' AND i.' . $_CB_database->NameQuote( 'user' ) . ' > 0 ) )';
if ( $isOwner ) {
$query .= "\n WHERE ( g." . $_CB_database->NameQuote( 'user_id' ) . " = " . (int) $user->get( 'id' );
if ( ! $isModerator ) {
$query .= ' OR ( g.' . $_CB_database->NameQuote( 'published' ) . ' = 1'
. ' AND ( u.' . $_CB_database->NameQuote( 'status' ) . ' IN ( 0, 1, 2, 3 )'
. ' OR i.' . $_CB_database->NameQuote( 'id' ) . ' IS NOT NULL ) ) )';
} else {
$query .= ' OR u.' . $_CB_database->NameQuote( 'status' ) . ' IN ( 0, 1, 2, 3 )'
. ' OR i.' . $_CB_database->NameQuote( 'id' ) . ' IS NOT NULL )';
}
} else {
$query .= "\n LEFT JOIN " . $_CB_database->NameQuote( '#__groupjive_users' ) . " AS mu"
. ' ON mu.' . $_CB_database->NameQuote( 'user_id' ) . ' = ' . (int) $viewer->get( 'id' )
. ' AND mu.' . $_CB_database->NameQuote( 'group' ) . ' = g.' . $_CB_database->NameQuote( 'id' )
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__groupjive_invites' ) . " AS mi"
. ' ON mi.' . $_CB_database->NameQuote( 'group' ) . ' = g.' . $_CB_database->NameQuote( 'id' )
. ' AND mi.' . $_CB_database->NameQuote( 'accepted' ) . ' = ' . $_CB_database->Quote( '0000-00-00 00:00:00' )
. ' AND ( ( mi.' . $_CB_database->NameQuote( 'email' ) . ' = ' . $_CB_database->Quote( $viewer->get( 'email' ) )
. ' AND mi.' . $_CB_database->NameQuote( 'email' ) . ' != "" )'
. ' OR ( mi.' . $_CB_database->NameQuote( 'user' ) . ' = ' . (int) $viewer->get( 'id' )
. ' AND mi.' . $_CB_database->NameQuote( 'user' ) . ' > 0 ) )'
. "\n WHERE ( g." . $_CB_database->NameQuote( 'user_id' ) . " = " . (int) $user->get( 'id' );
if ( ! $isModerator ) {
$query .= ' OR ( g.' . $_CB_database->NameQuote( 'published' ) . ' = 1'
. ' AND u.' . $_CB_database->NameQuote( 'status' ) . ' IN ( 1, 2, 3 ) ) )'
. "\n AND ( g." . $_CB_database->NameQuote( 'user_id' ) . " = " . (int) $viewer->get( 'id' )
. ' OR ( g.' . $_CB_database->NameQuote( 'published' ) . ' = 1'
. ' AND ( g.' . $_CB_database->NameQuote( 'type' ) . ' IN ( 1, 2 )'
. ' OR mu.' . $_CB_database->NameQuote( 'status' ) . ' IN ( 0, 1, 2, 3 )'
. ' OR mi.' . $_CB_database->NameQuote( 'id' ) . ' IS NOT NULL ) ) )';
} else {
$query .= ' OR u.' . $_CB_database->NameQuote( 'status' ) . ' IN ( 1, 2, 3 ) )';
}
}
if ( ! $isModerator ) {
$query .= "\n AND ( ( c." . $_CB_database->NameQuote( 'published' ) . " = 1"
. ' AND c.' . $_CB_database->NameQuote( 'access' ) . ' IN ' . $_CB_database->safeArrayOfIntegers( CBGroupJive::getAccess( (int) $user->get( 'id' ) ) )
. ' AND c.' . $_CB_database->NameQuote( 'access' ) . ' IN ' . $_CB_database->safeArrayOfIntegers( CBGroupJive::getAccess( (int) $viewer->get( 'id' ) ) ) . ' )'
. ( $this->params->get( 'groups_uncategorized', 1 ) ? ' OR g.' . $_CB_database->NameQuote( 'category' ) . ' = 0 )' : ' )' );
}
$query .= $where
. "\n ORDER BY " . $orderBy;
if ( $tab->params->get( 'tab_paging', 1 ) ) {
$_CB_database->setQuery( $query, $pageNav->limitstart, $pageNav->limit );
} else {
$_CB_database->setQuery( $query );
}
$rows = $_CB_database->loadObjectList( null, '\CB\Plugin\GroupJive\Table\GroupTable', array( $_CB_database ) );
$input['search'] = '<input type="text" name="gj_tab_search" value="' . htmlspecialchars( $search ) . '" onchange="document.gjTabForm.submit();" placeholder="' . htmlspecialchars( CBTxt::T( 'Search Groups...' ) ) . '" class="form-control" />';
CBGroupJive::getGroup( $rows );
CBGroupJive::preFetchUsers( $rows );
$class = $this->params->get( 'general_class', null );
$return = '<div class="cbGroupJive' . ( $class ? ' ' . htmlspecialchars( $class ) : null ) . '">'
. '<div class="cbGroupJiveInner">'
. HTML_groupjiveTab::showTab( $rows, $pageNav, $searching, $input, $viewer, $user, $tab, $this )
. '</div>'
. '</div>';
return $return;
}
/**
* prepare frontend wall edit render
*
* @param int $id
* @param UserTable $user
*/
private function showWallEdit( $id, $user )
{
global $_CB_framework;
$row = CBGroupJiveWall::getPost( (int) $id );
$isModerator = CBGroupJive::isModerator( $user->get( 'id' ) );
$groupId = $this->input( 'group', null, GetterInterface::INT );
if ( $groupId === null ) {
$group = $row->group();
} else {
$group = CBGroupJive::getGroup( $groupId );
}
$returnUrl = $_CB_framework->pluginClassUrl( $this->_gjPlugin->element, false, array( 'action' => 'groups', 'func' => 'show', 'id' => (int) $group->get( 'id' ) ) );
if ( ! CBGroupJive::canAccessGroup( $group, $user ) ) {
cbRedirect( $returnUrl, CBTxt::T( 'Group does not exist.' ), 'error' );
} elseif ( ! $isModerator ) {
if ( ( ! $row->get( 'id' ) ) && ( ! CBGroupJive::canCreateGroupContent( $user, $group, 'wall' ) ) ) {
cbRedirect( $returnUrl, CBTxt::T( 'You do not have sufficient permissions to post in this group.' ), 'error' );
} elseif ( $row->get( 'id' ) && ( $user->get( 'id' ) != $row->get( 'user_id' ) ) && ( CBGroupJive::getGroupStatus( $user, $group ) < 2 ) ) {
cbRedirect( $returnUrl, CBTxt::T( 'You do not have sufficient permissions to edit this post.' ), 'error' );
}
}
CBGroupJive::getTemplate( 'wall_edit', true, true, $this->element );
$input = array();
$publishedTooltip = cbTooltip( null, CBTxt::T( 'Select publish state of this post. Unpublished posts will not be visible to the public.' ), null, null, null, null, null, 'data-hascbtooltip="true"' );
$input['published'] = moscomprofilerHTML::yesnoSelectList( 'published', 'class="form-control"' . $publishedTooltip, (int) $this->input( 'post/published', $row->get( 'published', 1 ), GetterInterface::INT ) );
$postTooltip = cbTooltip( null, CBTxt::T( 'Input the post to share.' ), null, null, null, null, null, 'data-hascbtooltip="true"' );
$input['post'] = '<textarea id="post" name="post" class="form-control required" cols="55" rows="8"' . $postTooltip . '>' . htmlspecialchars( $this->input( 'post/post', $row->get( 'post' ), GetterInterface::HTML ) ) . '</textarea>';
$ownerTooltip = cbTooltip( null, CBTxt::T( 'Input the post owner id. Post owner determines the creator of the post specified as User ID.' ), null, null, null, null, null, 'data-hascbtooltip="true"' );
$input['user_id'] = '<input type="text" id="user_id" name="user_id" value="' . (int) $this->input( 'post/user_id', $this->input( 'user', $row->get( 'user_id', $user->get( 'id' ) ), GetterInterface::INT ), GetterInterface::INT ) . '" class="digits required form-control" size="6"' . $ownerTooltip . ' />';
HTML_groupjiveWallEdit::showWallEdit( $row, $input, $group, $user, $this );
}
/**
* prepare frontend event edit render
*
* @param int $id
* @param UserTable $user
*/
private function showEventEdit( $id, $user )
{
global $_CB_framework;
$row = CBGroupJiveEvents::getEvent( (int) $id );
$isModerator = CBGroupJive::isModerator( $user->get( 'id' ) );
$groupId = $this->input( 'group', null, GetterInterface::INT );
if ( $groupId === null ) {
$group = $row->group();
} else {
$group = CBGroupJive::getGroup( $groupId );
}
$returnUrl = $_CB_framework->pluginClassUrl( $this->_gjPlugin->element, false, array( 'action' => 'groups', 'func' => 'show', 'id' => (int) $group->get( 'id' ) ) );
if ( ! CBGroupJive::canAccessGroup( $group, $user ) ) {
cbRedirect( $returnUrl, CBTxt::T( 'Group does not exist.' ), 'error' );
} elseif ( ! $isModerator ) {
if ( ( ! $row->get( 'id' ) ) && ( ! CBGroupJive::canCreateGroupContent( $user, $group, 'events' ) ) ) {
cbRedirect( $returnUrl, CBTxt::T( 'You do not have sufficient permissions to schedule an event in this group.' ), 'error' );
} elseif ( $row->get( 'id' ) && ( $user->get( 'id' ) != $row->get( 'user_id' ) ) && ( CBGroupJive::getGroupStatus( $user, $group ) < 2 ) ) {
cbRedirect( $returnUrl, CBTxt::T( 'You do not have sufficient permissions to edit this event.' ), 'error' );
}
}
CBGroupJive::getTemplate( 'event_edit', true, true, $this->element );
$input = array();
$publishedTooltip = cbTooltip( null, CBTxt::T( 'Select publish state of this event. Unpublished events will not be visible to the public.' ), null, null, null, null, null, 'data-hascbtooltip="true"' );
$input['published'] = moscomprofilerHTML::yesnoSelectList( 'published', 'class="form-control"' . $publishedTooltip, (int) $this->input( 'post/published', $row->get( 'published', 1 ), GetterInterface::INT ) );
$titleTooltup = cbTooltip( null, CBTxt::T( 'Input the event title. This is the title that will distinguish this event from others. Suggested to input something to uniquely identify your event.' ), null, null, null, null, null, 'data-hascbtooltip="true"' );
$input['title'] = '<input type="text" id="title" name="title" value="' . htmlspecialchars( $this->input( 'post/title', $row->get( 'title' ), GetterInterface::STRING ) ) . '" class="form-control required" size="35"' . $titleTooltup . ' />';
$event = $_CB_framework->displayCmsEditor( 'event', $this->input( 'post/event', $row->get( 'event' ), GetterInterface::HTML ), '100%', null, 40, 10, false );
$input['event'] = cbTooltip( null, CBTxt::T( 'Input a detailed description about this event.' ), null, null, null, $event, null, 'style="display:block;"' );
$locationTooltup = cbTooltip( null, CBTxt::T( 'Input the location for this event (e.g. My House, The Park, Restaurant Name, etc..).' ), null, null, null, null, null, 'data-hascbtooltip="true"' );
$input['location'] = '<input type="text" id="location" name="location" value="' . htmlspecialchars( $this->input( 'post/location', $row->get( 'location' ), GetterInterface::STRING ) ) . '" class="form-control required" size="35"' . $locationTooltup . ' />';
$addressTooltup = cbTooltip( null, CBTxt::T( 'Optionally input the address for this event or click the map button to attempt to find your current location.' ), null, null, null, null, null, 'data-hascbtooltip="true"' );
$input['address'] = '<input type="text" id="address" name="address" value="' . htmlspecialchars( $this->input( 'post/address', $row->get( 'address' ), GetterInterface::STRING ) ) . '" class="form-control" size="45"' . $addressTooltup . ' />';
$calendars = new cbCalendars( 1 );
$minYear = (int) Application::Date( ( $row->get( 'id' ) ? $row->get( 'start' ) : 'now' ), 'UTC' )->format( 'Y' );
$startTooltup = cbTooltip( null, CBTxt::T( 'Select the date and time this event starts.' ), null, null, null, null, null, 'data-hascbtooltip="true"' );
$input['start'] = $calendars->cbAddCalendar( 'start', null, true, $this->input( 'post/start', $row->get( 'start' ), GetterInterface::STRING ), false, true, $minYear, ( $minYear + 30 ), $startTooltup );
$endTooltup = cbTooltip( null, CBTxt::T( 'Optionally select the end date and time for this event.' ), null, null, null, null, null, 'data-hascbtooltip="true"' );
$input['end'] = $calendars->cbAddCalendar( 'end', null, false, $this->input( 'post/end', $row->get( 'end' ), GetterInterface::STRING ), false, true, $minYear, ( $minYear + 30 ), $endTooltup );
$limitTooltip = cbTooltip( null, CBTxt::T( 'Optionally input a guest limit for this event.' ), null, null, null, null, null, 'data-hascbtooltip="true"' );
$input['limit'] = '<input type="text" id="limit" name="limit" value="' . (int) $this->input( 'post/limit', $row->get( 'limit' ), GetterInterface::INT ) . '" class="digits form-control" size="6"' . $limitTooltip . ' />';
$ownerTooltip = cbTooltip( null, CBTxt::T( 'Input the event owner id. Event owner determines the creator of the event specified as User ID.' ), null, null, null, null, null, 'data-hascbtooltip="true"' );
$input['user_id'] = '<input type="text" id="user_id" name="user_id" value="' . (int) $this->input( 'post/user_id', $this->input( 'user', $row->get( 'user_id', $user->get( 'id' ) ), GetterInterface::INT ), GetterInterface::INT ) . '" class="digits required form-control" size="6"' . $ownerTooltip . ' />';
HTML_groupjiveEventEdit::showEventEdit( $row, $input, $group, $user, $this );
}
/**
* @param UserTable $user
* @param GroupTable $group
* @param array $counters
* @return array|null
*/
public function getTopics( $user, &$group, &$counters )
{
global $_CB_framework, $_CB_database;
$categoryId = (int) $group->params()->get( 'forum_id' );
if ( ( ! $categoryId ) || ( ! $group->params()->get( 'forums', 1 ) ) || ( $group->category()->get( 'id' ) && ( ! $group->category()->params()->get( 'forums', 1 ) ) ) ) {
return null;
}
CBGroupJive::getTemplate( 'forums', true, true, $this->plugin->element );
$limit = (int) $this->params->get( 'groups_forums_limit', 15 );
$limitstart = $_CB_framework->getUserStateFromRequest( 'gj_group_forums_limitstart{com_comprofiler}', 'gj_group_forums_limitstart' );
$search = $_CB_framework->getUserStateFromRequest( 'gj_group_forums_search{com_comprofiler}', 'gj_group_forums_search' );
$where = null;
if ( $search && $this->params->get( 'groups_forums_search', 1 ) ) {
$where .= '( m.' . $_CB_database->NameQuote( 'subject' ) . ' LIKE ' . $_CB_database->Quote( '%' . $_CB_database->getEscaped( $search, true ) . '%', false )
. ' OR t.' . $_CB_database->NameQuote( 'message' ) . ' LIKE ' . $_CB_database->Quote( '%' . $_CB_database->getEscaped( $search, true ) . '%', false ) . ' )';
}
$searching = ( $where ? true : false );
$params = array( 'starttime' => -1,
'where' => $where
);
$posts = \KunenaForumMessageHelper::getLatestMessages( $categoryId, 0, 0, $params );
$total = array_shift( $posts );
if ( ( ! $total ) && ( ! $searching ) && ( ! CBGroupJive::canCreateGroupContent( $user, $group, 'forums' ) ) ) {
return null;
}
$pageNav = new \cbPageNav( $total, $limitstart, $limit );
$pageNav->setInputNamePrefix( 'gj_group_forums_' );
switch( (int) $this->params->get( 'groups_forums_orderby', 2 ) ) {
case 1:
$params['orderby'] = 'm.' . $_CB_database->NameQuote( 'time' ) . ' ASC';
break;
}
if ( $this->params->get( 'groups_forums_paging', 1 ) ) {
$posts = \KunenaForumMessageHelper::getLatestMessages( $categoryId, (int) $pageNav->limitstart, (int) $pageNav->limit, $params );
$posts = array_pop( $posts );
} else {
$posts = array_pop( $posts );
}
$rows = array();
/** @var \KunenaForumMessage[] $posts */
foreach ( $posts as $post ) {
$row = new PostTable();
$row->post( $post );
$rows[] = $row;
}
$input = array();
$input['search'] = '<input type="text" name="gj_group_forums_search" value="' . htmlspecialchars( $search ) . '" onchange="document.gjGroupForumsForm.submit();" placeholder="' . htmlspecialchars( CBTxt::T( 'Search Posts...' ) ) . '" class="form-control" />';
CBGroupJive::preFetchUsers( $rows );
$group->set( '_forums', $pageNav->total );
return array( 'id' => 'forums',
'title' => CBTxt::T( 'Forums' ),
'content' => \HTML_groupjiveForums::showForums( $rows, $pageNav, $searching, $input, $counters, $group, $user, $this )
);
}
/**
* prepare frontend photos render
*
* @param string $return
* @param GroupTable $group
* @param string $users
* @param string $invites
* @param array $counters
* @param array $buttons
* @param array $menu
* @param cbTabs $tabs
* @param UserTable $user
* @return array|null
*/
public function showPhotos( &$return, &$group, &$users, &$invites, &$counters, &$buttons, &$menu, &$tabs, $user )
{
global $_CB_framework, $_CB_database;
CBGroupJive::getTemplate( 'photos', true, true, $this->element );
$canModerate = ( CBGroupJive::isModerator( $user->get( 'id' ) ) || ( CBGroupJive::getGroupStatus( $user, $group ) >= 2 ) );
$limit = (int) $this->params->get( 'groups_photo_limit', 15 );
$limitstart = $_CB_framework->getUserStateFromRequest( 'gj_group_photo_limitstart{com_comprofiler}', 'gj_group_photo_limitstart' );
$search = $_CB_framework->getUserStateFromRequest( 'gj_group_photo_search{com_comprofiler}', 'gj_group_photo_search' );
$where = null;
if ( $search && $this->params->get( 'groups_photo_search', 1 ) ) {
$where .= "\n AND ( p." . $_CB_database->NameQuote( 'title' ) . " LIKE " . $_CB_database->Quote( '%' . $_CB_database->getEscaped( $search, true ) . '%', false )
. " OR p." . $_CB_database->NameQuote( 'filename' ) . " LIKE " . $_CB_database->Quote( '%' . $_CB_database->getEscaped( $search, true ) . '%', false )
. " OR p." . $_CB_database->NameQuote( 'description' ) . " LIKE " . $_CB_database->Quote( '%' . $_CB_database->getEscaped( $search, true ) . '%', false ) . " )";
}
$searching = ( $where ? true : false );
$query = 'SELECT COUNT(*)'
. "\n FROM " . $_CB_database->NameQuote( '#__groupjive_plugin_photo' ) . " AS p"
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__comprofiler' ) . " AS cb"
. ' ON cb.' . $_CB_database->NameQuote( 'id' ) . ' = p.' . $_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 p." . $_CB_database->NameQuote( 'group' ) . " = " . (int) $group->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 ( p." . $_CB_database->NameQuote( 'user_id' ) . " = " . (int) $user->get( 'id' )
. ' OR p.' . $_CB_database->NameQuote( 'published' ) . ' = 1 )';
}
$query .= $where;
$_CB_database->setQuery( $query );
$total = (int) $_CB_database->loadResult();
if ( ( ! $total ) && ( ! $searching ) && ( ! CBGroupJive::canCreateGroupContent( $user, $group, 'photo' ) ) ) {
return null;
}
$pageNav = new cbPageNav( $total, $limitstart, $limit );
$pageNav->setInputNamePrefix( 'gj_group_photo_' );
switch( (int) $this->params->get( 'groups_photo_orderby', 2 ) ) {
case 1:
$orderBy = 'p.' . $_CB_database->NameQuote( 'date' ) . ' ASC';
break;
case 3:
$orderBy = 'p.' . $_CB_database->NameQuote( 'filename' ) . ' ASC';
break;
case 4:
$orderBy = 'p.' . $_CB_database->NameQuote( 'filename' ) . ' DESC';
break;
case 2:
default:
$orderBy = 'p.' . $_CB_database->NameQuote( 'date' ) . ' DESC';
break;
}
$query = 'SELECT p.*'
. "\n FROM " . $_CB_database->NameQuote( '#__groupjive_plugin_photo' ) . " AS p"
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__comprofiler' ) . " AS cb"
. ' ON cb.' . $_CB_database->NameQuote( 'id' ) . ' = p.' . $_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 p." . $_CB_database->NameQuote( 'group' ) . " = " . (int) $group->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 ( p." . $_CB_database->NameQuote( 'user_id' ) . " = " . (int) $user->get( 'id' )
. ' OR p.' . $_CB_database->NameQuote( 'published' ) . ' = 1 )';
}
$query .= $where
. "\n ORDER BY " . $orderBy;
if ( $this->params->get( 'groups_photo_paging', 1 ) ) {
$_CB_database->setQuery( $query, $pageNav->limitstart, $pageNav->limit );
} else {
$_CB_database->setQuery( $query );
}
$rows = $_CB_database->loadObjectList( null, '\CB\Plugin\GroupJivePhoto\Table\PhotoTable', array( $_CB_database ) );
$input = array();
$input['search'] = '<input type="text" name="gj_group_photo_search" value="' . htmlspecialchars( $search ) . '" onchange="document.gjGroupPhotoForm.submit();" placeholder="' . htmlspecialchars( CBTxt::T( 'Search Photos...' ) ) . '" class="form-control" />';
CBGroupJivePhoto::getPhoto( $rows );
CBGroupJive::preFetchUsers( $rows );
$group->set( '_photos', $pageNav->total );
return array( 'id' => 'photo',
'title' => CBTxt::T( 'Photos' ),
'content' => HTML_groupjivePhoto::showPhotos( $rows, $pageNav, $searching, $input, $counters, $group, $user, $this )
);
}
/**
* 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 );
}
/**
* prepare frontend file edit render
*
* @param int $id
* @param UserTable $user
*/
private function showFileEdit( $id, $user )
{
global $_CB_framework;
$row = CBGroupJiveFile::getFile( (int) $id );
$isModerator = CBGroupJive::isModerator( $user->get( 'id' ) );
$groupId = $this->input( 'group', null, GetterInterface::INT );
if ( $groupId === null ) {
$group = $row->group();
} else {
$group = CBGroupJive::getGroup( $groupId );
}
$returnUrl = $_CB_framework->pluginClassUrl( $this->_gjPlugin->element, false, array( 'action' => 'groups', 'func' => 'show', 'id' => (int) $group->get( 'id' ) ) );
if ( ! CBGroupJive::canAccessGroup( $group, $user ) ) {
cbRedirect( $returnUrl, CBTxt::T( 'Group does not exist.' ), 'error' );
} elseif ( ! $isModerator ) {
if ( ( ! $row->get( 'id' ) ) && ( ! CBGroupJive::canCreateGroupContent( $user, $group, 'file' ) ) ) {
cbRedirect( $returnUrl, CBTxt::T( 'You do not have sufficient permissions to upload a file in this group.' ), 'error' );
} elseif ( $row->get( 'id' ) && ( $user->get( 'id' ) != $row->get( 'user_id' ) ) && ( CBGroupJive::getGroupStatus( $user, $group ) < 2 ) ) {
cbRedirect( $returnUrl, CBTxt::T( 'You do not have sufficient permissions to edit this file.' ), 'error' );
}
}
CBGroupJive::getTemplate( 'file_edit', true, true, $this->element );
$minFileSize = $this->params->get( 'groups_file_min_size', 0 );
$maxFileSize = $this->params->get( 'groups_file_max_size', 1024 );
$extensions = explode( ',', $this->params->get( 'groups_file_extensions', 'zip,rar,doc,pdf,txt,xls' ) );
$fileValidation = array();
if ( $minFileSize || $maxFileSize ) {
$fileValidation[] = cbValidator::getRuleHtmlAttributes( 'filesize', array( $minFileSize, $maxFileSize, 'KB' ) );
}
if ( $extensions ) {
$fileValidation[] = cbValidator::getRuleHtmlAttributes( 'extension', implode( ',', $extensions ) );
}
$input = array();
$publishedTooltip = cbTooltip( null, CBTxt::T( 'Select publish state of this file. Unpublished files will not be visible to the public.' ), null, null, null, null, null, 'data-hascbtooltip="true"' );
$input['published'] = moscomprofilerHTML::yesnoSelectList( 'published', 'class="form-control"' . $publishedTooltip, (int) $this->input( 'post/published', $row->get( 'published', 1 ), GetterInterface::INT ) );
$titleTooltup = cbTooltip( null, CBTxt::T( 'Optionally input a file title to display instead of filename.' ), null, null, null, null, null, 'data-hascbtooltip="true"' );
$input['title'] = '<input type="text" id="title" name="title" value="' . htmlspecialchars( $this->input( 'post/title', $row->get( 'title' ), GetterInterface::STRING ) ) . '" class="form-control" size="35"' . $titleTooltup . ' />';
$fileTooltip = cbTooltip( null, CBTxt::T( 'Select the file to upload.' ), null, null, null, null, null, 'data-hascbtooltip="true"' );
$input['file'] = '<input type="file" id="file" name="file" value="" class="form-control' . ( ! $row->get( 'id' ) ? ' required' : null ) . '"' . ( $fileTooltip ? ' ' . $fileTooltip : null ) . ( $fileValidation ? implode( ' ', $fileValidation ) : null ) . ' />';
$input['file_limits'] = array();
if ( $extensions ) {
$input['file_limits'][] = CBTxt::T( 'GROUP_FILE_LIMITS_EXT', 'Your file must be of [ext] type.', array( '[ext]' => implode( ', ', $extensions ) ) );
}
if ( $minFileSize ) {
$input['file_limits'][] = CBTxt::T( 'GROUP_FILE_LIMITS_MIN', 'Your file should exceed [size].', array( '[size]' => CBGroupJive::getFormattedFileSize( $minFileSize * 1024 ) ) );
}
if ( $maxFileSize ) {
$input['file_limits'][] = CBTxt::T( 'GROUP_FILE_LIMITS_MAX', 'Your file should not exceed [size].', array( '[size]' => CBGroupJive::getFormattedFileSize( $maxFileSize * 1024 ) ) );
}
$descriptionTooltip = cbTooltip( null, CBTxt::T( 'Optionally input a file description.' ), null, null, null, null, null, 'data-hascbtooltip="true"' );
$input['description'] = '<textarea id="description" name="description" class="form-control" cols="40" rows="5"' . ( $descriptionTooltip ? ' ' . $descriptionTooltip : null ) . '>' . htmlspecialchars( $this->input( 'post/description', $row->get( 'description' ), GetterInterface::STRING ) ) . '</textarea>';
$ownerTooltip = cbTooltip( null, CBTxt::T( 'Input the file owner id. File owner determines the creator of the file specified as User ID.' ), null, null, null, null, null, 'data-hascbtooltip="true"' );
$input['user_id'] = '<input type="text" id="user_id" name="user_id" value="' . (int) $this->input( 'post/user_id', $this->input( 'user', $row->get( 'user_id', $user->get( 'id' ) ), GetterInterface::INT ), GetterInterface::INT ) . '" class="digits required form-control" size="6"' . $ownerTooltip . ' />';
HTML_groupjiveFileEdit::showFileEdit( $row, $input, $group, $user, $this );
}
/**
* prepare frontend about edit render
*
* @param int $id
* @param UserTable $user
*/
private function showAboutEdit( $id, $user )
{
global $_CB_framework;
$row = CBGroupJive::getGroup( $id );
$returnUrl = $_CB_framework->pluginClassUrl( $this->_gjPlugin->element, false, array( 'action' => 'groups', 'func' => 'show', 'id' => (int) $row->get( 'id' ) ) );
if ( CBGroupJive::canAccessGroup( $row, $user ) ) {
if ( ! CBGroupJive::isModerator( $user->get( 'id' ) ) ) {
if ( CBGroupJive::getGroupStatus( $user, $row ) < 3 ) {
cbRedirect( $returnUrl, CBTxt::T( 'You do not have sufficient permissions to edit about in this group.' ), 'error' );
}
}
} else {
cbRedirect( $returnUrl, CBTxt::T( 'Group does not exist.' ), 'error' );
}
CBGroupJive::getTemplate( 'about_edit', true, true, $this->element );
$input = array();
$about = $_CB_framework->displayCmsEditor( 'about', $this->input( 'post/about', $row->params()->get( 'about_content' ), GetterInterface::HTML ), '100%', null, 40, 15, false );
$input['about'] = cbTooltip( null, CBTxt::T( 'Optionally input a detailed description about this group.' ), null, null, null, $about, null, 'style="display:block;"' );
HTML_groupjiveAboutEdit::showAboutEdit( $row, $input, $user, $this );
}
/**
* integrates with kunena model
*
* @param string $event
* @param $config
* @param $params
*/
public function kunena( $event, &$config, &$params )
{
global $_CB_database;
if ( ( ! $this->_forumModel ) || ( $this->_forumModel->type != 'kunena' ) ) {
return;
}
if ( $event == 'loadGroups' ) {
$groups = CBGroupJive::getGroupOptions();
$options = array();
foreach ( $groups as $group ) {
$option = new stdClass();
$option->id = ( is_array( $group->value ) ? uniqid() : (int) $group->value );
$option->parent_id = 0;
$option->level = ( is_array( $group->value ) ? 0 : 1 );
$option->name = $group->text;
$options[$option->id] = $option;
}
$params['groups'] = $options;
} elseif ( $event == 'getAllowedForumsRead' ) {
static $cache = array();
$mydId = Application::MyUser()->getUserId();
if ( ! $mydId ) {
return;
}
if ( ! isset( $cache[$mydId] ) ) {
$user = CBuser::getMyUserDataInstance();
$isModerator = CBGroupJive::isModerator( $user->get( 'id' ) );
$query = 'SELECT g.*'
. "\n FROM " . $_CB_database->NameQuote( '#__groupjive_groups' ) . " AS g"
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__comprofiler' ) . " AS cb"
. ' ON cb.' . $_CB_database->NameQuote( 'id' ) . ' = g.' . $_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 LEFT JOIN " . $_CB_database->NameQuote( '#__groupjive_users' ) . " AS u"
. ' ON u.' . $_CB_database->NameQuote( 'user_id' ) . ' = ' . (int) $user->get( 'id' )
. ' AND u.' . $_CB_database->NameQuote( 'group' ) . ' = g.' . $_CB_database->NameQuote( 'id' )
. "\n WHERE cb." . $_CB_database->NameQuote( 'approved' ) . " = 1"
. "\n AND cb." . $_CB_database->NameQuote( 'confirmed' ) . " = 1"
. "\n AND j." . $_CB_database->NameQuote( 'block' ) . " = 0";
if ( ! $isModerator ) {
$query .= "\n AND ( g." . $_CB_database->NameQuote( 'user_id' ) . " = " . (int) $user->get( 'id' )
. ' OR ( g.' . $_CB_database->NameQuote( 'published' ) . ' = 1'
. ' AND u.' . $_CB_database->NameQuote( 'status' ) . ' > 0 ) )';
}
$_CB_database->setQuery( $query );
$groups = $_CB_database->loadObjectList( null, '\CB\Plugin\GroupJive\Table\GroupTable', array( $_CB_database ) );
$allowed = array();
/** @var GroupTable[] $groups */
foreach ( $groups as $group ) {
if ( $group->params()->get( 'forums', 1 ) ) {
$froumId = (int) $group->params()->get( 'forum_id' );
if ( $froumId && CBGroupJive::canCreateGroupContent( $user, $group, 'forums' ) ) {
$allowed[] = $froumId;
}
}
}
$cache[$mydId] = $allowed;
}
if ( ! $cache[$mydId] ) {
return;
}
$existingAccess = explode( ',', $params[1] );
$cleanAccess = array_diff( $cache[$mydId], $existingAccess );
$newAccess = array_merge( $existingAccess, $cleanAccess );
cbArrayToInts( $newAccess );
$params[1] = implode( ',', $newAccess );
} elseif ( $event == 'authoriseUsers' ) {
/** @var KunenaForumCategory $category */
$category = $params['category'];
$groupId = $category->get( 'access' );
if ( ( $category->get( 'accesstype' ) != 'communitybuilder' ) || ( ! $groupId ) ) {
return;
}
$users = $params['userids'];
if ( ! $users ) {
return;
}
static $allowed = array();
if ( ! isset( $allowed[$groupId] ) ) {
$allowed[$groupId] = array();
$group = CBGroupJive::getGroup( $groupId );
if ( $group->get( 'id' ) ) {
$query = 'SELECT u.' . $_CB_database->NameQuote( 'user_id' )
. "\n FROM " . $_CB_database->NameQuote( '#__groupjive_users' ) . " AS u"
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__comprofiler' ) . " AS cb"
. ' ON cb.' . $_CB_database->NameQuote( 'id' ) . ' = u.' . $_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 u." . $_CB_database->NameQuote( 'group' ) . " = " . (int) $group->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"
. "\n AND u." . $_CB_database->NameQuote( 'status' ) . " >= 1";
$_CB_database->setQuery( $query );
$allowed[$groupId] = $_CB_database->loadResultArray();
}
foreach ( $users as $userId ) {
if ( ( ! in_array( $userId, $allowed[$groupId] ) ) && CBGroupJive::isModerator( $userId ) ) {
$allowed[$groupId][] = $userId;
}
}
cbArrayToInts( $allowed[$groupId] );
}
if ( ! $allowed[$groupId] ) {
return;
}
$params['allow'] = $allowed[$groupId];
} elseif ( $this->params->get( 'groups_forums_back', 1 ) && ( $event == 'onStart' ) && ( $this->input( 'view', null, GetterInterface::STRING ) == 'category' ) ) {
$categoryId = (int) $this->input( 'catid', 0, GetterInterface::INT );
if ( ! $categoryId ) {
return;
}
$model = CBGroupJiveForums::getModel();
if ( ! $model ) {
return;
}
$category = $model->getCategory( $categoryId );
if ( ! $category->get( 'id' ) ) {
return;
}
$category = $category->category();
if ( ( $category->get( 'accesstype' ) != 'communitybuilder' ) || ( ! $category->get( 'access' ) ) ) {
return;
}
$group = CBGroupJive::getGroup( (int) $category->get( 'access' ) );
if ( ! $group->get( 'id' ) ) {
return;
}
CBGroupJive::getTemplate( 'backlink', true, true, $this->element );
echo HTML_groupjiveForumsBacklink::showBacklink( $group, $category, $this );
}
}
/**
* prepare frontend video edit render
*
* @param int $id
* @param UserTable $user
*/
private function showVideoEdit( $id, $user )
{
global $_CB_framework;
$row = CBGroupJiveVideo::getVideo( (int) $id );
$isModerator = CBGroupJive::isModerator( $user->get( 'id' ) );
$groupId = $this->input( 'group', null, GetterInterface::INT );
if ( $groupId === null ) {
$group = $row->group();
} else {
$group = CBGroupJive::getGroup( $groupId );
}
$returnUrl = $_CB_framework->pluginClassUrl( $this->_gjPlugin->element, false, array( 'action' => 'groups', 'func' => 'show', 'id' => (int) $group->get( 'id' ) ) );
if ( ! CBGroupJive::canAccessGroup( $group, $user ) ) {
cbRedirect( $returnUrl, CBTxt::T( 'Group does not exist.' ), 'error' );
} elseif ( ! $isModerator ) {
if ( ( ! $row->get( 'id' ) ) && ( ! CBGroupJive::canCreateGroupContent( $user, $group, 'video' ) ) ) {
cbRedirect( $returnUrl, CBTxt::T( 'You do not have sufficient permissions to publish a video in this group.' ), 'error' );
} elseif ( $row->get( 'id' ) && ( $user->get( 'id' ) != $row->get( 'user_id' ) ) && ( CBGroupJive::getGroupStatus( $user, $group ) < 2 ) ) {
cbRedirect( $returnUrl, CBTxt::T( 'You do not have sufficient permissions to edit this video.' ), 'error' );
}
}
CBGroupJive::getTemplate( 'video_edit', true, true, $this->element );
$input = array();
$publishedTooltip = cbTooltip( null, CBTxt::T( 'Select publish state of this video. Unpublished videos will not be visible to the public.' ), null, null, null, null, null, 'data-hascbtooltip="true"' );
$input['published'] = moscomprofilerHTML::yesnoSelectList( 'published', 'class="form-control"' . $publishedTooltip, (int) $this->input( 'post/published', $row->get( 'published', 1 ), GetterInterface::INT ) );
$titleTooltup = cbTooltip( null, CBTxt::T( 'Optionally input a video title to display instead of url.' ), null, null, null, null, null, 'data-hascbtooltip="true"' );
$input['title'] = '<input type="text" id="title" name="title" value="' . htmlspecialchars( $this->input( 'post/title', $row->get( 'title' ), GetterInterface::STRING ) ) . '" class="form-control" size="35"' . $titleTooltup . ' />';
$urlTooltip = cbTooltip( null, CBTxt::T( 'Input the URL to the video to publish.' ), null, null, null, null, null, 'data-hascbtooltip="true"' );
$input['url'] = '<input type="text" id="url" name="url" value="' . htmlspecialchars( $this->input( 'post/url', $row->get( 'url' ), GetterInterface::STRING ) ) . '" class="form-control required" size="45"' . $urlTooltip . ' />';
$input['url_limits'] = CBTxt::T( 'GROUP_VIDEO_LIMITS_EXT', 'Your url must be of [ext] type.', array( '[ext]' => implode( ', ', array( 'youtube', 'mp4', 'ogv', 'ogg', 'webm', 'm4v' ) ) ) );
$captionTooltip = cbTooltip( null, CBTxt::T( 'Optionally input a video caption.' ), null, null, null, null, null, 'data-hascbtooltip="true"' );
$input['caption'] = '<textarea id="caption" name="caption" class="form-control" cols="40" rows="5"' . $captionTooltip . '>' . htmlspecialchars( $this->input( 'post/caption', $row->get( 'caption' ), GetterInterface::STRING ) ) . '</textarea>';
$ownerTooltip = cbTooltip( null, CBTxt::T( 'Input the video owner id. Video owner determines the creator of the video specified as User ID.' ), null, null, null, null, null, 'data-hascbtooltip="true"' );
$input['user_id'] = '<input type="text" id="user_id" name="user_id" value="' . (int) $this->input( 'post/user_id', $this->input( 'user', $row->get( 'user_id', $user->get( 'id' ) ), GetterInterface::INT ), GetterInterface::INT ) . '" class="digits required form-control" size="6"' . $ownerTooltip . ' />';
HTML_groupjiveVideoEdit::showVideoEdit( $row, $input, $group, $user, $this );
}
