/**
* 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 )
);
}
/**
* @param OrderedTable $row
* @param UserTable $user
* @param stdClass $model
* @param PluginTable $plugin
*/
static function showBlog($row, $user, $model, $plugin)
{
global $_CB_framework;
$_CB_framework->setPageTitle($row->get('title'));
$_CB_framework->appendPathWay(htmlspecialchars(CBTxt::T('Blogs')), $_CB_framework->userProfileUrl($row->get('user', $user->get('id')), true, 'cbblogsTab'));
$_CB_framework->appendPathWay(htmlspecialchars($row->get('title')), $_CB_framework->pluginClassUrl($plugin->element, true, array('action' => 'blogs', 'func' => 'show', 'id' => (int) $row->get('id'))));
$cbUser =& CBuser::getInstance((int) $row->get('user'), false);
$return = '<div class="blowShow">' . '<div class="blogsTitle page-header"><h3>' . $row->get('title') . ' <small>' . CBTxt::T('WRITTEN_BY_BLOG_AUTHOR', 'Written by [blog_author]', array('[blog_author]' => $cbUser->getField('formatname', null, 'html', 'none', 'list', 0, true))) . '</small></h3></div>' . '<div class="blogsHeader well well-sm">' . CBTxt::T('CATEGORY_CATEGORY', 'Category: [category]', array('[category]' => $row->get('category'))) . ' / ' . CBTxt::T('CREATED_CREATED', 'Created: [created]', array('[created]' => cbFormatDate($row->get('created')))) . ($row->get('modified') && $row->get('modified') != '0000-00-00 00:00:00' ? ' / ' . CBTxt::T('MODIFIED_MODIFIED', 'Modified: [modified]', array('[modified]' => cbFormatDate($row->get('modified')))) : null) . '</div>' . '<div class="blogsText">' . $row->get('blog_intro') . $row->get('blog_full') . '</div>' . '</div>';
echo $return;
}
/**
* @param OrderedTable $row
* @param UserTable $user
* @param stdClass $model
* @param PluginTable $plugin
*/
static function showconsultation( $row, $user, /** @noinspection PhpUnusedParameterInspection */ $model, $plugin, $bids )
{
global $_CB_framework;
$_CB_framework->setPageTitle( $row->get( 'title' ) );
$_CB_framework->appendPathWay( htmlspecialchars( CBTxt::T( 'consultations' ) ), $_CB_framework->userProfileUrl( $row->get( 'user', $user->get( 'id' ) ), true, 'cbconsultationsTab' ) );
$_CB_framework->appendPathWay( htmlspecialchars( $row->get( 'title' ) ), $_CB_framework->pluginClassUrl( $plugin->element, true, array( 'action' => 'consultations', 'func' => 'show', 'id' => (int) $row->get( 'id' ) ) ) );
$cbUser =& CBuser::getInstance( (int) $row->get( 'user' ), false );
$return = '<div class="blowShow">'
. '<div class="consultationsTitle page-header"><h3>' . $row->get( 'title' ) . ' <small>' . CBTxt::T( 'WRITTEN_BY_consultation_AUTHOR', 'Written by [consultation_author]', array( '[consultation_author]' => $cbUser->getField( 'formatname', null, 'html', 'none', 'list', 0, true ) ) ) . '</small></h3></div>'
. '<div class="consultationsHeader well well-sm">'
. CBTxt::T( 'CATEGORY_CATEGORY', 'Category: [category]', array( '[category]' => $row->get( 'category' ) ) )
. ' / ' . CBTxt::T( 'CREATED_CREATED', 'Created: [created]', array( '[created]' => cbFormatDate( $row->get( 'created' ) ) ) )
. ( $row->get( 'modified' ) && ( $row->get( 'modified' ) != '0000-00-00 00:00:00' ) ? ' / ' . CBTxt::T( 'MODIFIED_MODIFIED', 'Modified: [modified]', array( '[modified]' => cbFormatDate( $row->get( 'modified' ) ) ) ) : null )
. '</div>'
. '<div class="consultationsText">' . $row->get( 'consultation_intro' ) . $row->get( 'consultation_full' ) . '</div>'
. '</div>';
if($bids!=null){
$return .= '<script >
window.___gcfg = {
lang: \'ru\',
parsetags: \'onload\'
};
</script>
<script src="https://apis.google.com/js/platform.js" async defer></script>
';
$return .= '<h2>Ставки</h2>';
if(empty($bids)){
$return .= "Нет ставок";
}else{
$return .= '<table cellspacing="5" class="consultationsContainer table table-hover table-responsive">';
$return .= '<tr><th>Дата</th><th>Пользователь</th><th>e-mail</th><th>Цена</th><th></th></tr>';
foreach($bids as $key=>$value){
$return .='<tr>';
$return .= '<td>'.$value->bid_date.'</td>';
$return .= '<td>'.$value->name.'</td>';
$return .= '<td>'.$value->email.'</td>';
$return .= '<td>$'.$value->bid_price.'</td>';
$return .= '<td>';
if($key==0){
//Old version was using Goolge Hangouts for communications.
//$return .= '<g:hangout render="createhangout" hangout_type="normal" topic="'.addslashes($row->get('title')).'"
// invites="[{ id : \''.$value->email.'\', invite_type : \'EMAIL\' }]">
// </g:hangout>';
//New version is using CloudInterpreter
$return .= '<a target="_blank" href="http://dev.cloudinterpreter.com:8901/'.md5($row->get('id')).'"><button class="btn btn-success">Начать консультацию</button></a>';
}
$return .= '</td>';
$return .='</tr>';
}
$return .= '</table>';
}
}
echo $return;
}
/**
* @param cbautoactionsActionTable $trigger
* @param UserTable $user
*/
public function execute( $trigger, $user )
{
if ( ! $this->installed() ) {
if ( $trigger->getParams()->get( 'debug', false, GetterInterface::BOOLEAN ) ) {
var_dump( CBTxt::T( 'AUTO_ACTION_BLOGS_NOT_INSTALLED', ':: Action [action] :: CB Blogs is not installed', array( '[action]' => (int) $trigger->get( 'id' ) ) ) );
}
return;
}
foreach ( $trigger->getParams()->subTree( 'blog' ) as $row ) {
/** @var ParamsInterface $row */
$blog = new cbblogsBlogTable();
$owner = $row->get( 'owner', null, GetterInterface::STRING );
if ( ! $owner ) {
$owner = (int) $user->get( 'id' );
} else {
$owner = (int) $trigger->getSubstituteString( $owner );
}
if ( ! $owner ) {
if ( $trigger->getParams()->get( 'debug', false, GetterInterface::BOOLEAN ) ) {
var_dump( CBTxt::T( 'AUTO_ACTION_BLOGS_NO_OWNER', ':: Action [action] :: CB Blogs skipped due to missing owner', array( '[action]' => (int) $trigger->get( 'id' ) ) ) );
}
continue;
}
$blogData = array( 'user' => $owner,
'title' => $trigger->getSubstituteString( $row->get( 'title', null, GetterInterface::STRING ) ),
'blog_intro' => $trigger->getSubstituteString( $row->get( 'intro', null, GetterInterface::RAW ), false ),
'blog_full' => $trigger->getSubstituteString( $row->get( 'full', null, GetterInterface::RAW ), false ),
'category' => $row->get( 'category', null, GetterInterface::STRING ),
'published' => (int) $row->get( 'published', 1, GetterInterface::INT ),
'access' => (int) $row->get( 'access', 1, GetterInterface::INT )
);
if ( ! $blog->bind( $blogData ) ) {
if ( $trigger->getParams()->get( 'debug', false, GetterInterface::BOOLEAN ) ) {
var_dump( CBTxt::T( 'AUTO_ACTION_BLOGS_BIND_FAILED', ':: Action [action] :: CB Blogs failed to bind. Error: [error]', array( '[action]' => (int) $trigger->get( 'id' ), '[error]' => $blog->getError() ) ) );
}
continue;
}
if ( ! $blog->store() ) {
if ( $trigger->getParams()->get( 'debug', false, GetterInterface::BOOLEAN ) ) {
var_dump( CBTxt::T( 'AUTO_ACTION_BLOGS_FAILED', ':: Action [action] :: CB Blogs failed to save. Error: [error]', array( '[action]' => (int) $trigger->get( 'id' ), '[error]' => $blog->getError() ) ) );
}
}
}
}
/**
* @param cbautoactionsActionTable $trigger
* @param UserTable $user
*/
public function execute( $trigger, $user )
{
global $_CB_PMS;
foreach ( $trigger->getParams()->subTree( 'pms' ) as $row ) {
/** @var ParamsInterface $row */
$pmFrom = $row->get( 'form', null, GetterInterface::STRING );
if ( ! $pmFrom ) {
$pmFrom = (int) $user->get( 'id' );
} else {
$pmFrom = (int) $trigger->getSubstituteString( $pmFrom );
}
if ( ! $pmFrom ) {
if ( $trigger->getParams()->get( 'debug', false, GetterInterface::BOOLEAN ) ) {
var_dump( CBTxt::T( 'AUTO_ACTION_PMS_NO_FROM', ':: Action [action] :: Private Message skipped due to missing from', array( '[action]' => (int) $trigger->get( 'id' ) ) ) );
}
continue;
}
$pmTo = $trigger->getSubstituteString( $row->get( 'to', null, GetterInterface::STRING ) );
if ( ! $pmTo ) {
if ( $trigger->getParams()->get( 'debug', false, GetterInterface::BOOLEAN ) ) {
var_dump( CBTxt::T( 'AUTO_ACTION_PMS_NO_TO', ':: Action [action] :: Private Message skipped due to missing to', array( '[action]' => (int) $trigger->get( 'id' ) ) ) );
}
continue;
}
$pmMessage = $trigger->getSubstituteString( $row->get( 'message', null, GetterInterface::RAW ), false );
if ( ! $pmMessage ) {
if ( $trigger->getParams()->get( 'debug', false, GetterInterface::BOOLEAN ) ) {
var_dump( CBTxt::T( 'AUTO_ACTION_PMS_NO_MSG', ':: Action [action] :: Private Message skipped due to missing message', array( '[action]' => (int) $trigger->get( 'id' ) ) ) );
}
continue;
}
$pmSubject = $trigger->getSubstituteString( $row->get( 'subject', null, GetterInterface::STRING ) );
$_CB_PMS->sendPMSMSG( $pmTo, $pmFrom, $pmSubject, $pmMessage, true );
}
}
/**
* Evaluate CB Fields replacements
*
* @access private (public because it's recursively calling itself in the preg_replace_callback function at bottom)
*
* @param string|array $input
* @param boolean|array $htmlspecialcharsParam on replaced values only: FALSE : no htmlspecialchars, TRUE: do htmlspecialchars, ARRAY: callback method
* @return string
*/
public function _evaluateCbFields( $input, $htmlspecialcharsParam = null )
{
static $htmlspecialchars = null;
$regex = '/\[([\w-]+)\]/';
if ( is_array( $input ) ) {
$val = $this->getField( $input[1], null, 'php', 'none', 'profile', 0, true ); // allow accessing all fields in the data
if ( is_array( $val ) ) {
$val = array_shift( $val );
if ( is_array( $val ) ) {
$val = implode( '|*|', $val );
}
} elseif ( isset( $this->_cbuser->$input[1] ) ) {
$val = $this->_cbuser->get( $input[1] );
if ( is_array( $val ) ) {
$val = implode( '|*|', $val );
}
} else {
$lowercaseVarName = strtolower( $input[1] );
if ( isset( $this->_cbuser->$lowercaseVarName ) ) {
$val = $this->_cbuser->get( $lowercaseVarName );
if ( is_array( $val ) ) {
$val = implode( '|*|', $val );
}
} else {
$val = array(); // avoid substitution
}
}
// Ensure user id is always an integer:
if ( in_array( $input[1], array( 'id', 'user_id' ) ) ) {
$val = ( is_object( $val ) || is_array( $val ) ? 0 : (int) $val );
}
if ( ( ! is_object( $val ) ) && ( ! is_array( $val ) ) ) {
if ( ! ( ( strtolower( $input[1] ) == 'password' ) && ( strlen( $val ) >= 32 ) ) ) {
if ( is_array( $htmlspecialchars ) ) {
$val = call_user_func_array( $htmlspecialchars, array( $val ) );
} elseif ( $htmlspecialchars ) {
$val = htmlspecialchars( $val );
}
return $val;
}
}
return '[' . $input[1] . ']';
}
$htmlspecialchars = $htmlspecialcharsParam;
return preg_replace_callback( $regex, array( $this, '_evaluateCbFields' ), $input );
}
/**
* Gets articles
*
* @param int[] $paging
* @param string $where
* @param UserTable $viewer
* @param UserTable $user
* @param PluginTable $plugin
* @return Table[]
*/
public static function getArticles($paging, $where, $viewer, $user, $plugin)
{
global $_CB_database;
$categories = $plugin->params->get('article_k2_category', null);
$query = 'SELECT a.*' . ', b.' . $_CB_database->NameQuote('id') . ' AS category' . ', b.' . $_CB_database->NameQuote('name') . ' AS category_title' . ', b.' . $_CB_database->NameQuote('published') . ' AS category_published' . ', b.' . $_CB_database->NameQuote('alias') . ' AS category_alias' . "\n FROM " . $_CB_database->NameQuote('#__k2_items') . " AS a" . "\n LEFT JOIN " . $_CB_database->NameQuote('#__k2_categories') . " AS b" . ' ON b.' . $_CB_database->NameQuote('id') . ' = a.' . $_CB_database->NameQuote('catid') . "\n WHERE a." . $_CB_database->NameQuote('created_by') . " = " . (int) $user->get('id') . "\n AND a." . $_CB_database->NameQuote('published') . " = 1" . "\n AND a." . $_CB_database->NameQuote('trash') . " = 0" . "\n AND a." . $_CB_database->NameQuote('access') . " IN " . $_CB_database->safeArrayOfIntegers(Application::MyUser()->getAuthorisedViewLevels()) . "\n AND b." . $_CB_database->NameQuote('published') . " = 1" . "\n AND b." . $_CB_database->NameQuote('trash') . " = 0" . "\n AND b." . $_CB_database->NameQuote('access') . " IN " . $_CB_database->safeArrayOfIntegers(Application::MyUser()->getAuthorisedViewLevels());
if ($categories) {
$categories = explode('|*|', $categories);
cbArrayToInts($categories);
$query .= "\n AND a." . $_CB_database->NameQuote('catid') . " NOT IN ( " . implode(',', $categories) . " )";
}
$query .= $where . "\n ORDER BY a." . $_CB_database->NameQuote('created') . " DESC";
if ($paging) {
$_CB_database->setQuery($query, $paging[0], $paging[1]);
} else {
$_CB_database->setQuery($query);
}
return $_CB_database->loadObjectList(null, '\\CBLib\\Database\\Table\\Table', array(null, '#__k2_items', 'id'));
}
/**
* Returns an array of all current params
*
* @return array
*/
public function asArray()
{
$params = parent::asArray();
$params['source'] = $this->source;
$params['user'] = (int) $this->user->get( 'id' );
return $params;
}
/**
* @param OrderedTable $row
* @param string[] $input
* @param UserTable $user
* @param stdClass $model
* @param PluginTable $plugin
*/
static function showBlogEdit($row, $input, $user, $model, $plugin)
{
global $_CB_framework, $_PLUGINS;
cbValidator::loadValidation();
$blogMode = $plugin->params->get('blog_mode', 1);
$pageTitle = $row->get('id') ? CBTxt::T('Edit Blog') : CBTxt::T('Create Blog');
$cbModerator = Application::User((int) $user->get('id'))->isGlobalModerator();
$_CB_framework->setPageTitle($pageTitle);
$_CB_framework->appendPathWay(htmlspecialchars(CBTxt::T('Blogs')), $_CB_framework->userProfileUrl($row->get('user', $user->get('id')), true, 'cbblogsTab'));
$_CB_framework->appendPathWay(htmlspecialchars($pageTitle), $_CB_framework->pluginClassUrl($plugin->element, true, $row->get('id') ? array('action' => 'blogs', 'func' => 'edit', 'id' => (int) $row->get('id')) : array('action' => 'blogs', 'func' => 'new')));
initToolTip();
$return = '<div class="blogEdit">' . '<form action="' . $_CB_framework->pluginClassUrl($plugin->element, true, array('action' => 'blogs', 'func' => 'save', 'id' => (int) $row->get('id'))) . '" method="post" enctype="multipart/form-data" name="blogForm" id="blogForm" class="cb_form blogForm form-auto cbValidation">' . ($pageTitle ? '<div class="blogsTitle page-header"><h3>' . $pageTitle . '</h3></div>' : null);
if ($cbModerator || !$plugin->params->get('blog_approval', 0)) {
$return .= '<div class="cbft_select cbtt_select form-group cb_form_line clearfix">' . '<label for="published" class="col-sm-3 control-label">' . CBTxt::Th('Published') . '</label>' . '<div class="cb_field col-sm-9">' . $input['published'] . getFieldIcons(1, 0, null, CBTxt::T('Select publish status of the blog. Unpublished blogs will not be visible to the public.')) . '</div>' . '</div>';
}
if ($plugin->params->get('blog_category_config', 1) || $cbModerator) {
$return .= '<div class="cbft_select cbtt_select form-group cb_form_line clearfix">' . '<label for="category" class="col-sm-3 control-label">' . CBTxt::Th('Category') . '</label>' . '<div class="cb_field col-sm-9">' . $input['category'] . getFieldIcons(1, 0, null, CBTxt::T('Select blog category. Select the category that best describes your blog.')) . '</div>' . '</div>';
}
if ($plugin->params->get('blog_access_config', 1) || $cbModerator) {
$return .= '<div class="cbft_select cbtt_select form-group cb_form_line clearfix">' . '<label for="access" class="col-sm-3 control-label">' . CBTxt::Th('Access') . '</label>' . '<div class="cb_field col-sm-9">' . $input['access'] . getFieldIcons(1, 0, null, CBTxt::T('Select access to blog; all groups above that level will also have access to the blog.')) . '</div>' . '</div>';
}
$return .= '<div class="cbft_text cbtt_input form-group cb_form_line clearfix">' . '<label for="title" class="col-sm-3 control-label">' . CBTxt::Th('Title') . '</label>' . '<div class="cb_field col-sm-9">' . $input['title'] . getFieldIcons(1, 1, null, CBTxt::T('Input blog title. This is the title that will distinguish this blog from others. Suggested to input something unique and intuitive.')) . '</div>' . '</div>';
if (in_array($blogMode, array(1, 2))) {
$return .= '<div class="cbft_textarea cbtt_textarea form-group cb_form_line clearfix">' . '<label for="blog_intro" class="col-sm-3 control-label">' . ($blogMode == 1 ? CBTxt::T('Blog Intro') : CBTxt::T('Blog')) . '</label>' . '<div class="cb_field col-sm-9">' . $input['blog_intro'] . getFieldIcons(1, 0, null, CBTxt::T('Input HTML supported blog intro contents. Suggested to use minimal but well formatting for easy readability.')) . '</div>' . '</div>';
}
if (in_array($blogMode, array(1, 3))) {
$return .= '<div class="cbft_textarea cbtt_textarea form-group cb_form_line clearfix">' . '<label for="blog_full" class="col-sm-3 control-label">' . ($blogMode == 1 ? CBTxt::T('Blog Full') : CBTxt::T('Blog')) . '</label>' . '<div class="cb_field col-sm-9">' . $input['blog_full'] . getFieldIcons(1, 0, null, CBTxt::T('Input HTML supported blog contents. Suggested to use minimal but well formatting for easy readability.')) . '</div>' . '</div>';
}
if ($cbModerator) {
$return .= '<div class="cbft_text cbtt_input form-group cb_form_line clearfix">' . '<label for="user" class="col-sm-3 control-label">' . CBTxt::T('Owner') . '</label>' . '<div class="cb_field col-sm-9">' . $input['user'] . getFieldIcons(1, 1, null, CBTxt::T('Input owner of blog as single integer user_id.')) . '</div>' . '</div>';
}
if ($plugin->params->get('blog_captcha', 0) && !$cbModerator) {
$_PLUGINS->loadPluginGroup('user');
$captcha = $_PLUGINS->trigger('onGetCaptchaHtmlElements', array(false));
if (!empty($captcha)) {
$captcha = $captcha[0];
$return .= '<div class="form-group cb_form_line clearfix">' . '<label class="col-sm-3 control-label">' . CBTxt::Th('Captcha') . '</label>' . '<div class="cb_field col-sm-9">' . (isset($captcha[0]) ? $captcha[0] : null) . '</div>' . '</div>' . '<div class="form-group cb_form_line clearfix">' . '<div class="cb_field col-sm-offset-3 col-sm-9">' . str_replace('inputbox', 'form-control', isset($captcha[1]) ? $captcha[1] : null) . getFieldIcons(1, 1, null) . '</div>' . '</div>';
}
}
$return .= '<div class="form-group cb_form_line clearfix">' . '<div class="col-sm-offset-3 col-sm-9">' . '<input type="submit" value="' . htmlspecialchars($row->get('id') ? CBTxt::T('Update Blog') : CBTxt::T('Create Blog')) . '" class="blogsButton blogsButtonSubmit btn btn-primary"' . cbValidator::getSubmitBtnHtmlAttributes() . ' /> ' . ' <input type="button" value="' . htmlspecialchars(CBTxt::T('Cancel')) . '" class="blogsButton blogsButtonCancel btn btn-default" onclick="if ( confirm( \'' . addslashes(CBTxt::T('Are you sure you want to cancel? All unsaved data will be lost!')) . '\' ) ) { location.href = \'' . $_CB_framework->userProfileUrl($row->get('user', $user->get('id')), false, 'cbblogsTab') . '\'; }" />' . '</div>' . '</div>' . cbGetSpoofInputTag('plugin') . '</form>' . '</div>';
echo $return;
}
/**
* @param int $userId
* @param UserTable $user
* @param cbPluginHandler $plugin
*/
static public function showDisable( $userId, $user, $plugin )
{
global $_CB_framework;
cbValidator::loadValidation();
$profileUrl = $_CB_framework->userProfileUrl( $user->get( 'id' ) );
$pageTitle = CBTxt::T( 'Disable My Account' );
$_CB_framework->setPageTitle( $pageTitle );
$_CB_framework->appendPathWay( htmlspecialchars( $pageTitle ), $profileUrl );
initToolTip();
$tooltip = cbTooltip( null, CBTxt::T( 'Optionally input a reason for disabling your account.' ), null, null, null, null, null, 'data-hascbtooltip="true"' );
$return = '<div class="privacyDisableAccount">'
. '<form action="' . $_CB_framework->pluginClassUrl( $plugin->element, true, array( 'action' => 'privacy', 'func' => 'disableuser', 'id' => (int) $userId ) ) . '" method="post" enctype="multipart/form-data" name="privacyForm" id="privacyForm" class="cb_form privacyForm form-auto cbValidation">'
. ( $pageTitle ? '<div class="privacyTitle page-header"><h3>' . $pageTitle . '</h3></div>' : null )
. '<div class="cbft_textarea cbtt_textarea form-group cb_form_line clearfix">'
. '<label for="reason" class="col-sm-3 control-label">' . CBTxt::T( 'Reason' ) . '</label>'
. '<div class="cb_field col-sm-9">'
. '<textarea id="reason" name="reason" class="form-control" cols="40" rows="5"' . ( $tooltip ? ' ' . $tooltip : null ) . '></textarea>'
. getFieldIcons( 1, 0, null, CBTxt::T( 'Optionally input a reason for disabling your account.' ) )
. '</div>'
. '</div>'
. '<div class="form-group cb_form_line clearfix">'
. '<div class="col-sm-offset-3 col-sm-9">'
. '<input type="submit" value="' . htmlspecialchars( CBTxt::T( 'Disable Account' ) ) . '" class="privacyButton privacyButtonSubmit btn btn-primary"' . cbValidator::getSubmitBtnHtmlAttributes() . ' /> '
. ' <input type="button" value="' . htmlspecialchars( CBTxt::T( 'Cancel' ) ) . '" class="privacyButton privacyButtonCancel btn btn-default" onclick="location.href = \'' . $profileUrl . '\';" />'
. '</div>'
. '</div>'
. cbGetSpoofInputTag( 'plugin' )
. '</form>'
. '</div>';
echo $return;
}
/**
* @param cbantispamWhitelistTable $row
* @param array $input
* @param string $type
* @param int|string $tab
* @param UserTable $user
* @param cbPluginHandler $plugin
*/
static public function showWhitelist( $row, $input, $type, $tab, $user, $plugin )
{
global $_CB_framework;
cbValidator::loadValidation();
$name = CBuser::getInstance( (int) $user->get( 'id' ), false )->getField( 'formatname', null, 'html', 'none', 'profile', 0, true );
$pageTitle = CBTxt::T( 'WHITELIST_NAME', 'Whitelist [name]', array( '[name]' => $name ) );
$_CB_framework->setPageTitle( $pageTitle );
$_CB_framework->appendPathWay( htmlspecialchars( CBTxt::T( 'Whitelists' ) ), $_CB_framework->userProfileUrl( (int) $user->get( 'id' ), true, $tab ) );
$_CB_framework->appendPathWay( htmlspecialchars( $pageTitle ), $_CB_framework->pluginClassUrl( $plugin->element, true, ( $row->get( 'id' ) ? array( 'action' => 'whitelist', 'func' => ( $type ? $type : 'edit' ), 'id' => (int) $row->get( 'id' ), 'usr' => (int) $user->get( 'id' ) ) : array( 'action' => 'whitelist', 'func' => ( $type ? $type : 'new' ), 'usr' => (int) $user->get( 'id' ) ) ) ) );
$return = '<div class="whitelistEdit">'
. '<form action="' . $_CB_framework->pluginClassUrl( $plugin->element, true, array( 'action' => 'whitelist', 'func' => 'save', 'id' => (int) $row->get( 'id' ), 'usr' => (int) $user->get( 'id' ) ) ) . '" method="post" enctype="multipart/form-data" name="whitelistForm" id="whitelistForm" class="cb_form whitelistForm form-auto cbValidation">'
. ( $pageTitle ? '<div class="whitelistTitle page-header"><h3>' . $pageTitle . '</h3></div>' : null )
. '<div class="cbft_select cbtt_select form-group cb_form_line clearfix">'
. '<label for="type" class="col-sm-3 control-label">' . CBTxt::T( 'Type' ) . '</label>'
. '<div class="cb_field col-sm-9">'
. $input['type']
. getFieldIcons( 1, 1, null, CBTxt::T( 'Select the whitelist type. Type determines what value should be supplied.' ) )
. '</div>'
. '</div>'
. '<div class="cbft_text cbtt_input form-group cb_form_line clearfix">'
. '<label for="value" class="col-sm-3 control-label">' . CBTxt::T( 'Value' ) . '</label>'
. '<div class="cb_field col-sm-9">'
. $input['value']
. getFieldIcons( 1, 1, null, CBTxt::T( 'Input whitelist value in relation to the type. User type use the users user_id (e.g. 42). IP Address type use a full valid IP Address (e.g. 192.168.0.1). Email type use a fill valid email address (e.g. invalid@cb.invalid). Email Domain type use a full email address domain after @ (e.g. example.com).' ) )
. '</div>'
. '</div>'
. '<div class="cbft_textarea cbtt_textarea form-group cb_form_line clearfix">'
. '<label for="reason" class="col-sm-3 control-label">' . CBTxt::T( 'Reason' ) . '</label>'
. '<div class="cb_field col-sm-9">'
. $input['reason']
. getFieldIcons( 1, 0, null, CBTxt::T( 'Optionally input whitelist reason. Note this is for administrative purposes only.' ) )
. '</div>'
. '</div>'
. '<div class="form-group cb_form_line clearfix">'
. '<div class="col-sm-offset-3 col-sm-9">'
. '<input type="submit" value="' . htmlspecialchars( ( $row->get( 'id' ) ? CBTxt::T( 'Update Whitelist' ) : CBTxt::T( 'Create Whitelist' ) ) ) . '" class="whitelistButton whitelistButtonSubmit btn btn-primary"' . cbValidator::getSubmitBtnHtmlAttributes() . ' /> '
. ' <input type="button" value="' . htmlspecialchars( CBTxt::T( 'Cancel' ) ) . '" class="whitelistButton whitelistButtonCancel btn btn-default" onclick="if ( confirm( \'' . addslashes( CBTxt::T( 'Are you sure you want to cancel? All unsaved data will be lost!' ) ) . '\' ) ) { location.href = \'' . $_CB_framework->userProfileUrl( (int) $user->get( 'id' ), false, $tab ) . '\'; }" />'
. '</div>'
. '</div>'
. cbGetSpoofInputTag( 'plugin' )
. '</form>'
. '</div>';
echo $return;
}
/**
* Gets articles
*
* @param int[] $paging
* @param string $where
* @param UserTable $viewer
* @param UserTable $user
* @param PluginTable $plugin
* @return Table[]
*/
static public function getDocman( $paging, $where, /** @noinspection PhpUnusedParameterInspection */ $viewer, $user, $plugin )
{
global $_CB_database;
$categories = $plugin->params->get( 'article_j_category', null );
$query = 'SELECT a.*'
. ', b.' . $_CB_database->NameQuote( 'docman_category_id' ) . ' AS category'
. ', b.' . $_CB_database->NameQuote( 'title' ) . ' AS category_title'
. ', b.' . $_CB_database->NameQuote( 'enabled' ) . ' AS category_published'
. ', b.' . $_CB_database->NameQuote( 'slug' ) . ' AS category_slug'
. "\n FROM " . $_CB_database->NameQuote( '#__docman_documents' ) . " AS a"
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__docman_categories' ) . " AS b"
. ' ON b.' . $_CB_database->NameQuote( 'docman_category_id' ) . ' = a.' . $_CB_database->NameQuote( 'docman_category_id' )
. "\n WHERE a." . $_CB_database->NameQuote( 'created_by' ) . " = " . (int) $user->get( 'id' )
. "\n AND a." . $_CB_database->NameQuote( 'enabled' ) . " = 1"
. "\n AND (a." . $_CB_database->NameQuote( 'access' ) . " IN " . $_CB_database->safeArrayOfIntegers( Application::MyUser()->getAuthorisedViewLevels() )
. "\n OR a." . $_CB_database->NameQuote( 'access' ) . " = -1 )"
. "\n AND b." . $_CB_database->NameQuote( 'enabled' ) . " = 1"
. "\n AND b." . $_CB_database->NameQuote( 'access' ) . " IN " . $_CB_database->safeArrayOfIntegers( Application::MyUser()->getAuthorisedViewLevels() );
if ( $categories ) {
$categories = explode( '|*|', $categories );
cbArrayToInts( $categories );
$query .= "\n AND a." . $_CB_database->NameQuote( 'catid' ) . " NOT IN ( " . implode( ',', $categories ) . " )";
}
$query .= $where
. "\n ORDER BY a." . $_CB_database->NameQuote( 'created_on' ) . " DESC";
if ( $paging ) {
$_CB_database->setQuery( $query, $paging[0], $paging[1] );
} else {
$_CB_database->setQuery( $query );
}
return $_CB_database->loadObjectList( null, '\CBLib\Database\Table\Table', array( null, '#__docman_documents', 'id' ) );
}
/**
* render frontend group edit
*
* @param GroupTable $row
* @param array $input
* @param CategoryTable $category
* @param UserTable $user
* @param CBplug_cbgroupjive $plugin
* @return string
*/
static function showGroupEdit( $row, $input, $category, $user, $plugin )
{
global $_CB_framework, $_PLUGINS;
cbValidator::loadValidation();
initToolTip();
$js = "$( '#canvas_method' ).on( 'change', function() {"
. "if ( $( this ).val() == 1 ) {"
. "$( '#gjCanvasUpload' ).removeClass( 'hidden' ).find( 'input' ).removeClass( 'cbValidationDisabled' );"
. "} else {"
. "$( '#gjCanvasUpload' ).addClass( 'hidden' ).find( 'input' ).addClass( 'cbValidationDisabled' ).val( '' );"
. "}"
. "}).change();"
. "$( '#logo_method' ).on( 'change', function() {"
. "if ( $( this ).val() == 1 ) {"
. "$( '#gjLogoUpload' ).removeClass( 'hidden' ).find( 'input' ).removeClass( 'cbValidationDisabled' );"
. "} else {"
. "$( '#gjLogoUpload' ).addClass( 'hidden' ).find( 'input' ).addClass( 'cbValidationDisabled' ).val( '' );"
. "}"
. "}).change();";
$_CB_framework->outputCbJQuery( $js );
$isModerator = CBGroupJive::isModerator( $user->get( 'id' ) );
$returnUrl = CBGroupJive::getReturn( true, true );
$return = null;
$integrations = $_PLUGINS->trigger( 'gj_onBeforeDisplayGroupEdit', array( &$return, &$row, &$input, $category, $user ) );
if ( $row->get( 'id' ) ) {
$pageTitle = CBTxt::T( 'Edit Group' );
if ( ! $returnUrl ) {
$returnUrl = $_CB_framework->pluginClassUrl( $plugin->element, false, array( 'action' => 'groups', 'func' => 'show', 'id' => (int) $row->get( 'id' ) ) );
}
} else {
$pageTitle = CBTxt::T( 'New Group' );
if ( ! $returnUrl ) {
$returnUrl = $_CB_framework->pluginClassUrl( $plugin->element, false, array( 'action' => 'categories', 'func' => 'show', 'id' => (int) $category->get( 'id' ) ) );
}
}
$_CB_framework->setPageTitle( $pageTitle );
$return .= '<div class="gjGroupEdit">'
. '<form action="' . $_CB_framework->pluginClassUrl( $plugin->element, true, array( 'action' => 'groups', 'func' => 'save', 'id' => (int) $row->get( 'id' ), 'return' => CBGroupJive::getReturn( true ) ) ) . '" method="post" enctype="multipart/form-data" name="gjGroupEditForm" id="gjGroupEditForm" class="cb_form gjGroupEditForm form-auto cbValidation">'
. ( $pageTitle ? '<div class="gjGroupEditTitle page-header"><h3>' . $pageTitle . '</h3></div>' : null );
if ( $isModerator || ( $row->get( 'id' ) && ( $row->get( 'published' ) != -1 ) ) || ( ! $plugin->params->get( 'groups_create_approval', 0 ) ) ) {
$return .= '<div class="cbft_select cbtt_select form-group cb_form_line clearfix">'
. '<label for="published" class="col-sm-3 control-label">' . CBTxt::T( 'Published' ) . '</label>'
. '<div class="cb_field col-sm-9">'
. $input['published']
. getFieldIcons( null, 0, null, CBTxt::T( 'Select publish state of this group. Unpublished groups will not be visible to the public.' ) )
. '</div>'
. '</div>';
}
if ( $input['category'] ) {
$return .= '<div class="cbft_select cbtt_select form-group cb_form_line clearfix">'
. '<label for="category" class="col-sm-3 control-label">' . CBTxt::T( 'Category' ) . '</label>'
. '<div class="cb_field col-sm-9">'
. $input['category']
. getFieldIcons( null, 0, null, CBTxt::T( 'Select the group category. This is the category a group will belong to and decide its navigation path.' ) )
. '</div>'
. '</div>';
}
$return .= '<div class="cbft_select cbtt_select form-group cb_form_line clearfix">'
. '<label for="type" class="col-sm-3 control-label">' . CBTxt::T( 'Type' ) . '</label>'
. '<div class="cb_field col-sm-9">'
. $input['type']
. getFieldIcons( null, 0, null, CBTxt::T( 'Select the group type. Type determines the way your group is joined (e.g. Invite requires new users to be invited to join your group).' ) )
. '</div>'
. '</div>'
. '<div class="cbft_text cbtt_input form-group cb_form_line clearfix">'
. '<label for="name" class="col-sm-3 control-label">' . CBTxt::T( 'Name' ) . '</label>'
. '<div class="cb_field col-sm-9">'
. $input['name']
. getFieldIcons( null, 1, null, CBTxt::T( 'Input the group name. This is the name that will distinguish this group from others. Suggested to input something unique and intuitive.' ) )
. '</div>'
. '</div>'
. '<div class="cbft_textarea cbtt_textarea form-group cb_form_line clearfix">'
. '<label for="description" class="col-sm-3 control-label">' . CBTxt::T( 'Description' ) . '</label>'
. '<div class="cb_field col-sm-9">'
. $input['description']
. getFieldIcons( null, 0, null, CBTxt::T( 'Optionally input the group description. The group description should be short and to the point; describing what your group is all about.' ) )
. '</div>'
. '</div>';
if ( $row->get( 'canvas' ) ) {
$return .= '<div class="cbft_delimiter form-group cb_form_line clearfix">'
. '<label for="canvas_method" class="col-sm-3 control-label">' . CBTxt::T( 'Canvas' ) . '</label>'
. '<div class="cb_field col-sm-9">'
. $row->canvas()
. '</div>'
. '</div>'
. '<div id="gjCanvasMethod" class="cbft_select cbtt_select form-group cb_form_line clearfix">'
. '<div class="cb_field col-sm-offset-3 col-sm-9">'
. $input['canvas_method']
. '</div>'
. '</div>';
}
$return .= '<div id="gjCanvasUpload" class="cbft_file cbtt_input form-group cb_form_line clearfix' . ( $row->get( 'canvas' ) ? ' hidden' : null ) . '">'
. ( ! $row->get( 'canvas' ) ? '<label for="canvas" class="col-sm-3 control-label">' . CBTxt::T( 'Canvas' ) . '</label>' : null )
. '<div class="cb_field' . ( $row->get( 'canvas' ) ? ' col-sm-offset-3' : null ) . ' col-sm-9">'
. $input['canvas']
. getFieldIcons( null, 0, null, CBTxt::T( 'Optionally select the group canvas. A canvas should represent the topic of your group; please be respectful and tasteful when selecting a canvas.' ) )
. '<div class="help-block">' . implode( ' ', $input['canvas_limits'] ) . '</div>'
. '</div>'
. '</div>';
if ( $row->get( 'logo' ) ) {
$return .= '<div class="cbft_delimiter form-group cb_form_line clearfix">'
. '<label for="logo_method" class="col-sm-3 control-label">' . CBTxt::T( 'Logo' ) . '</label>'
. '<div class="cb_field col-sm-9">'
. $row->logo()
. '</div>'
. '</div>'
. '<div id="gjLogoMethod" class="cbft_select cbtt_select form-group cb_form_line clearfix">'
. '<div class="cb_field col-sm-offset-3 col-sm-9">'
. $input['logo_method']
. '</div>'
. '</div>';
}
$return .= '<div id="gjLogoUpload" class="cbft_file cbtt_input form-group cb_form_line clearfix' . ( $row->get( 'logo' ) ? ' hidden' : null ) . '">'
. ( ! $row->get( 'logo' ) ? '<label for="logo" class="col-sm-3 control-label">' . CBTxt::T( 'Logo' ) . '</label>' : null )
. '<div class="cb_field' . ( $row->get( 'logo' ) ? ' col-sm-offset-3' : null ) . ' col-sm-9">'
. $input['logo']
. getFieldIcons( null, 0, null, CBTxt::T( 'Optionally select the group logo. A logo should represent the topic of your group; please be respectful and tasteful when selecting a logo.' ) )
. '<div class="help-block">' . implode( ' ', $input['logo_limits'] ) . '</div>'
. '</div>'
. '</div>';
if ( ( $row->get( 'type' ) != 3 ) && ( $isModerator || $plugin->params->get( 'groups_invites_display', 1 ) ) ) {
$return .= '<div class="cbft_select cbtt_select form-group cb_form_line clearfix">'
. '<label for="params__invites" class="col-sm-3 control-label">' . CBTxt::T( 'Invites' ) . '</label>'
. '<div class="cb_field col-sm-9">'
. $input['invites']
. getFieldIcons( null, 0, null, CBTxt::T( 'Optionally enable or disable usage of group invites. Group invites allow group users to invite other users to join the group. Group owner and group administrators are exempt from this configuration and can always invite users. Note existing invites will still be accessible.' ) )
. '</div>'
. '</div>';
}
if ( is_array( $integrations ) && $integrations ) {
$return .= implode( '', $integrations );
}
if ( $isModerator ) {
$return .= '<div class="cbft_text cbtt_input form-group cb_form_line clearfix">'
. '<label for="user_id" class="col-sm-3 control-label">' . CBTxt::T( 'Owner' ) . '</label>'
. '<div class="cb_field col-sm-9">'
. $input['user_id']
. getFieldIcons( null, 1, null, CBTxt::T( 'Input the group owner id. Group owner determines the creator of the group specified as User ID.' ) )
. '</div>'
. '</div>';
}
if ( ( ! $isModerator ) && $plugin->params->get( 'groups_create_captcha', 0 ) ) {
$_PLUGINS->loadPluginGroup( 'user' );
$captcha = $_PLUGINS->trigger( 'onGetCaptchaHtmlElements', array( false ) );
if ( ! empty( $captcha ) ) {
$captcha = $captcha[0];
$return .= '<div class="form-group cb_form_line clearfix">'
. '<label class="col-sm-3 control-label">' . CBTxt::T( 'Captcha' ) . '</label>'
. '<div class="cb_field col-sm-9">'
. ( isset( $captcha[0] ) ? $captcha[0] : null )
. '</div>'
. '</div>'
. '<div class="form-group cb_form_line clearfix">'
. '<div class="cb_field col-sm-offset-3 col-sm-9">'
. str_replace( 'inputbox', 'form-control', ( isset( $captcha[1] ) ? $captcha[1] : null ) )
. getFieldIcons( null, 1, null )
. '</div>'
. '</div>';
}
}
$return .= '<div class="form-group cb_form_line clearfix">'
. '<div class="col-sm-offset-3 col-sm-9">'
. '<input type="submit" value="' . htmlspecialchars( ( $row->get( 'id' ) ? CBTxt::T( 'Update Group' ) : CBTxt::T( 'Create Group' ) ) ) . '" class="gjButton gjButtonSubmit btn btn-primary" ' . cbValidator::getSubmitBtnHtmlAttributes() . ' />'
. ' <input type="button" value="' . htmlspecialchars( CBTxt::T( 'Cancel' ) ) . '" class="gjButton gjButtonCancel btn btn-default" onclick="cbjQuery.cbconfirm( \'' . addslashes( CBTxt::T( 'Are you sure you want to cancel? All unsaved data will be lost!' ) ) . '\' ).done( function() { window.location.href = \'' . $returnUrl . '\'; })" />'
. '</div>'
. '</div>'
. cbGetSpoofInputTag( 'plugin' )
. '</form>'
. '</div>';
$_PLUGINS->trigger( 'gj_onAfterDisplayGroupEdit', array( &$return, $row, $input, $category, $user ) );
$_CB_framework->setMenuMeta();
echo $return;
}
/**
* save notifications
*
* @param int $id
* @param UserTable $user
*/
private function saveNotifications( $id, $user )
{
global $_CB_framework;
$row = new NotificationTable();
$isModerator = CBGroupJive::isModerator( $user->get( 'id' ) );
$group = CBGroupJive::getGroup( $id );
$row->load( array( 'user_id' => (int) $user->get( 'id' ), 'group' => (int) $group->get( 'id' ) ) );
$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 ( ! $this->params->get( 'notifications', 1 ) ) {
cbRedirect( $returnUrl, CBTxt::T( 'You do not have access to notifications in this group.' ), '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 users notifications.' ), 'error' );
} elseif ( ! $isModerator ) {
if ( ! CBGroupJive::canCreateGroupContent( $user, $group ) ) {
cbRedirect( $returnUrl, CBTxt::T( 'You do not have sufficient permissions to notifications in this group.' ), 'error' );
}
}
$row->set( 'user_id', $row->get( 'user_id', (int) $user->get( 'id' ) ) );
$row->set( 'group', $row->get( 'group', (int) $group->get( 'id' ) ) );
foreach ( $this->getInput()->subTree( 'params' ) as $k => $v ) {
if ( is_array( $v ) || is_object( $v ) ) {
continue;
}
$k = Get::clean( $k, GetterInterface::COMMAND );
if ( $k ) {
if ( is_numeric( $v ) ) {
$v = (int) $this->input( 'post/params.' . $k, null, GetterInterface::INT );
} else {
$v = $this->input( 'post/params.' . $k, null, GetterInterface::STRING );
}
$row->params()->set( $k, $v );
}
}
$row->set( 'params', $row->params()->asJson() );
if ( $row->getError() || ( ! $row->check() ) ) {
$_CB_framework->enqueueMessage( CBTxt::T( 'GROUP_NOTIFICATIONS_FAILED_TO_SAVE', 'Notifications failed to save! Error: [error]', array( '[error]' => $row->getError() ) ), 'error' );
$this->showGroupNotifications( $id, $user );
return;
}
if ( $row->getError() || ( ! $row->store() ) ) {
$_CB_framework->enqueueMessage( CBTxt::T( 'GROUP_NOTIFICATIONS_FAILED_TO_SAVE', 'Notifications failed to save! Error: [error]', array( '[error]' => $row->getError() ) ), 'error' );
$this->showGroupNotifications( $id, $user );
return;
}
cbRedirect( $returnUrl, CBTxt::T( 'Notifications saved successfully!' ) );
}
/**
* Notifies connection changes
*
* @param int $userId
* @param int $connectionId
* @param string $msg
* @param string $subject
* @param string $messageHTML
* @param string $messageText
* @param string $userMessage
* @return boolean
*/
protected function _notifyConnectionChange( $userId, $connectionId, $msg, $subject, $messageHTML, $messageText, $userMessage = null )
{
global $_CB_framework, $ueConfig;
$rowFrom = new UserTable();
$rowFrom->load( (int) $userId );
$fromName = getNameFormat( $rowFrom->name, $rowFrom->username, $ueConfig['name_format'] );
$fromURL = 'index.php?option=com_comprofiler&view=userprofile&user='******'&tab=1' . getCBprofileItemid(true);
$fromURL = cbSef( $fromURL );
if ( strncasecmp( 'http', $fromURL, 4 ) != 0 ) {
$fromURL = $_CB_framework->getCfg( 'live_site' ) . '/' . $fromURL;
}
$subject = sprintf( $subject, $fromName );
if ( $userMessage != null ) {
$messageHTML .= sprintf( str_replace( "\n", "\n<br />", CBTxt::T( 'UE_CONNECTIONMSGPREFIX', " %s included the following personal message:\n\n%s" ) ),
htmlspecialchars( $fromName ),
'<strong>' . htmlspecialchars( $userMessage ) . '</strong>' );
$messageText .= sprintf( str_replace( "\n", "\r\n", CBTxt::T( 'UE_CONNECTIONMSGPREFIX', " %s included the following personal message:\n\n%s" ) ),
$fromName,
$userMessage );
}
$notificationMsgHTML = sprintf( $messageHTML, '<strong><a href="' . $fromURL . '">' . htmlspecialchars( $fromName ) . '</a></strong>' );
$notificationMsgText = sprintf( $messageText, $fromName );
$manageURL = 'index.php?option=com_comprofiler&view=manageconnections' . getCBprofileItemid( true );
$manageURL = cbSef( $manageURL );
if ( strncasecmp( 'http', $manageURL, 4 ) != 0 ) {
$manageURL = $_CB_framework->getCfg( 'live_site' ) . '/' . $manageURL;
}
$notificationMsgHTML = $notificationMsgHTML
. "\n<br /><br /><a href=\"" . $manageURL . '">'
. CBTxt::T( 'UE_MANAGECONNECTIONS_LINK UE_MANAGECONNECTIONS', 'Manage Connections' )
. "</a>\n";
$notificationMsgText = $notificationMsgText
. "\r\n\r\n\r\n" . $fromName . ' '
. CBTxt::T( 'CONNECTION_PROFILE UE_PROFILE', 'Profile' )
. ': '
. cbUnHtmlspecialchars( $fromURL );
$notificationMsgText = $notificationMsgText
. "\r\n\r\n"
. CBTxt::T( 'UE_MANAGECONNECTIONS_URL_LABEL UE_MANAGECONNECTIONS', 'Manage Connections' )
. ': '
. cbUnHtmlspecialchars( $manageURL )
. "\r\n";
$notificationMsgHTML = '<div style="padding: 4px; margin: 4px 3px 6px 0px; background: #C44; font-weight: bold;" class="cbNotice">'
. CBTxt::T( 'UE_SENDPMSNOTICE', 'NOTE: This is a message generated automatically by the Connections system. It has the connecting user\'s address, so you can conveniently reply if you wish to.' )
. "</div>\n\n"
. $notificationMsgHTML;
$cbNotification = new cbNotification();
$cbNotification->sendFromUser( $connectionId, $userId, $subject, $notificationMsgHTML, $notificationMsgText );
$this->_setUserMSG( $msg );
return true;
}
/**
* Renders the Articles tab
*
* @param Table[] $rows Articles to render
* @param cbPageNav $pageNav Pagination
* @param boolean $searching Currently searching
* @param string[] $input HTML of input elements
* @param UserTable $viewer Viewing user
* @param UserTable $user Viewed user
* @param stdClass $model The model reference
* @param TabTable $tab Current Tab
* @param PluginTable $plugin Current Plugin
* @return string HTML
*/
static public function showPreparatyTab( $rows, $pageNav, $searching, $input, $viewer, $user, /** @noinspection PhpUnusedParameterInspection */ $model, $tab, /** @noinspection PhpUnusedParameterInspection */ $plugin )
{
global $_CB_framework, $_LANG;
$app =& JFactory::getApplication();
$menu = $app->getMenu();
$active = $menu->getActive();
$Itemid = $active->id;
$tabPaging = $tab->params->get( 'tab_paging', 1 );
$canSearch = ( $tab->params->get( 'tab_search', 1 ) && ( $searching || $pageNav->total ) );
$canCreate = false;
$profileOwner = ( $viewer->get( 'id' ) == $user->get( 'id' ) );
$cbModerator = Application::User( (int) $viewer->get( 'id' ) )->isGlobalModerator();
//$canPublish = ( $cbModerator || ( $profileOwner && ( ! $plugin->params->get( 'hangout_approval', 0 ) ) ) );
if ( $profileOwner ) {
if ( $cbModerator ) {
$canCreate = true;
} elseif ( $user->get( 'id' ) && Application::User( (int) $viewer->get( 'id' ) )->canViewAccessLevel( (int) $plugin->params->get( 'hangout_create_access', 2 ) ) ) {
if ( ( ! $blogLimit ) || ( $blogLimit && ( $pageNav->total < $blogLimit ) ) ) {
$canCreate = true;
}
}
}
$return = '<div class="articlesTab">'
. '<form action="' . $_CB_framework->userProfileUrl( $user->id, true, $tab->tabid ) . '" method="post" name="articleForm" id="articleForm" class="articleForm">';
if ( $canCreate ) {
$return .= '<div class="' . ( ! $canSearch ? 'col-sm-12' : 'col-sm-8' ) . ' text-left">'
. '<button type="button" onclick="location.href=\'' . ($_CB_framework->getCfg( 'live_site' ).'/index.php?option=com_flexicontent&view=item&typeid=2&task=add&Itemid='.$Itemid) . '\';" class="blogsButton blogsButtonNew btn btn-success"><span class="fa fa-plus-circle"></span> ' . $_LANG['New Preparat'] . '</button>'
. '</div>';
}
if ( $canSearch ) {
$return .= '<div class="articlesHeader row" style="margin-bottom: 10px;">'
. '<div class="col-sm-offset-8 col-sm-4 text-right">'
. '<div class="input-group">'
. '<span class="input-group-addon"><span class="fa fa-search"></span></span>'
. $input['search']
. '</div>'
. '</div>'
. '</div>';
}
$return .= '<table class="articlesContainer table table-hover table-responsive">'
. '<thead>'
. '<tr>'
. '<th style="width: 50%;" class="text-left">' . $_LANG['Preparat'] . '</th>'
. '<th style="width: 25%;" class="text-left hidden-xs">' . CBTxt::T( 'Category' ) . '</th>'
. '<th style="width: 25%;" class="text-left hidden-xs">' . CBTxt::T( 'Created' ) . '</th>'
. '<th style="width: 1%;" class="text-left hidden-xs"></th>'
. '</tr>'
. '</thead>'
. '<tbody>';
$attribs = '';
$image = FLEXI_J16GE ?
JHTML::image(FLEXI_ICONPATH.'edit.png', JText::_( 'FLEXI_EDIT' ), $attribs) :
JHTML::_('image.site', 'edit.png', FLEXI_ICONPATH, NULL, NULL, JText::_( 'FLEXI_EDIT' ), $attribs) ;
if ( $rows ) foreach ( $rows as $row ) {
$item_url = cbpreparatyModel::getUrl( $row, true, 'article' , $Itemid);
//$item_url_edit = cbpreparatyModel::getUrl( $row, true, 'article' , 445);
$link = $_CB_framework->getCfg( 'live_site' ). '/' .$item_url .(strstr($item_url, '?') ? '&' : '?'). 'task=edit';
$edit_row = $profileOwner ? '<a href="'.$link.'">'.$image.'</a> ' : '';
$return .= '<tr>'
. '<td style="width: 50%;" class="text-left">'.$edit_row.'<a href="' . cbpreparatyModel::getUrl( $row, true, 'article' ) . '">' . $row->get( 'title' ) . '</a></td>'
. '<td style="width: 25%;" class="text-left hidden-xs">' . ( $row->get( 'category' ) ? $row->get( 'category_title' ) : CBTxt::T( 'None' ) ) . '</td>'
. '<td style="width: 25%;" class="text-left hidden-xs">' . cbFormatDate( $row->get( 'created' ) ) . '</td>';
if ( ( $cbModerator || $profileOwner ) ) {
$menuItems = '<ul class="invitesMenuItems dropdown-menu" style="display: block; position: relative; margin: 0;">';
$menuItems .= '<li class="invitesMenuItem"><a href="' . $link . '"><span class="fa fa-edit"></span> ' . CBTxt::T( 'Edit' ) . '</a></li>'
. '<li class="invitesMenuItem"><a href="javascript: void(0);" onclick="if ( confirm( \'' . addslashes( CBTxt::T( 'Are you sure you want to delete this Drug?' ) ) . '\' ) ) { location.href = \'' . $_CB_framework->pluginClassUrl( $plugin->element, false, array( 'action' => 'preparaty', 'func' => 'delete', 'id' => (int) $row->get( 'id' ) ) ) . '\'; }"><span class="fa fa-trash-o"></span> ' . CBTxt::T( 'Delete' ) . '</a></li>';
$menuItems .= '</ul>';
$menuAttr = cbTooltip( 1, $menuItems, null, 'auto', null, null, null, 'class="btn btn-default btn-xs" data-cbtooltip-menu="true" data-cbtooltip-classes="qtip-nostyle"' );
$return .= '<td style="width: 1%;" class="text-right">'
. '<div class="invitesMenu btn-group">'
. '<button type="button"' . $menuAttr . '><span class="fa fa-cog"></span> <span class="fa fa-caret-down"></span></button>'
. '</div>'
. '</td>';
} else{
$return .= '<td style="width: 1%;" class="text-right"></td>';
}
$return .= '</tr>';
} else {
$return .= '<tr>'
. '<td colspan="3" class="text-left">';
if ( $searching ) {
$return .= $_LANG['No preparaty search results found.'];
} else {
if ( $viewer->id == $user->id ) {
$return .= $_LANG['You have no preparaty.'];
} else {
$return .= $_LANG['This user has no preparaty.'];
}
}
$return .= '</td>'
. '</tr>';
}
$return .= '</tbody>';
if ( $tabPaging && ( $pageNav->total > $pageNav->limit ) ) {
$return .= '<tfoot>'
. '<tr>'
. '<td colspan="3" class="text-center">'
. $pageNav->getListLinks()
. '</td>'
. '</tr>'
. '</tfoot>';
}
$return .= '</table>'
. $pageNav->getLimitBox( false )
. '</form>'
. '</div>';
return $return;
}
/**
* @param string $type
* @param TabTable $tab
* @param UserTable $user
* @param UserTable $viewer
* @param bool|int $start
* @return null|string
*/
private function getItems( $type, $tab, $user, $viewer, $start = false )
{
global $_CB_framework, $_CB_database, $_PLUGINS;
/** @var Registry $params */
$params = $tab->params;
$tabPrefix = 'tab_' . (int) $tab->get( 'tabid' ) . '_';
$publishedOnly = ( ( $viewer->get( 'id' ) != $user->get( 'id' ) ) && ( ! Application::User( (int) $viewer->get( 'id' ) )->isGlobalModerator() ) );
$input = array();
// Items:
$typePrefix = $tabPrefix . $type . '_items_';
$limit = (int) $params->get( 'tab_' . $type . '_items_limit', 15 );
$limitstart = ( $start !== false ? (int) $start : $_CB_framework->getUserStateFromRequest( $typePrefix . 'limitstart{com_comprofiler}', $typePrefix . 'limitstart' ) );
$search = $_CB_framework->getUserStateFromRequest( $typePrefix . 'search{com_comprofiler}', $typePrefix . 'search' );
$where = null;
if ( $search && $params->get( 'tab_' . $type . '_items_search', 1 ) ) {
$where .= "\n AND ( " . $_CB_database->NameQuote( 'value' ) . " LIKE " . $_CB_database->Quote( '%' . $_CB_database->getEscaped( $search, true ) . '%', false )
. " OR " . $_CB_database->NameQuote( 'title' ) . " LIKE " . $_CB_database->Quote( '%' . $_CB_database->getEscaped( $search, true ) . '%', false )
. " OR " . $_CB_database->NameQuote( 'description' ) . " LIKE " . $_CB_database->Quote( '%' . $_CB_database->getEscaped( $search, true ) . '%', false ) . " )";
}
$itemsSearching = ( $where ? true : false );
$query = 'SELECT COUNT(*)'
. "\n FROM " . $_CB_database->NameQuote( '#__comprofiler_plugin_gallery_items' )
. "\n WHERE " . $_CB_database->NameQuote( 'type' ) . " = " . $_CB_database->Quote( $type )
. "\n AND " . $_CB_database->NameQuote( 'user_id' ) . " = " . (int) $user->get( 'id' )
. "\n AND " . $_CB_database->NameQuote( 'folder' ) . " = 0"
. ( $publishedOnly ? "\n AND " . $_CB_database->NameQuote( 'published' ) . " = 1" : null )
. $where;
$_CB_database->setQuery( $query );
$total = (int) $_CB_database->loadResult();
if ( $total <= $limitstart ) {
$limitstart = 0;
}
$itemsPageNav = new cbPageNav( $total, $limitstart, $limit );
$itemsPageNav->setInputNamePrefix( $typePrefix );
$orderBy = $params->get( 'tab_' . $type . '_items_orderby', 'date_desc' );
if ( ! $orderBy ) {
$orderBy = 'date_desc';
}
$orderBy = explode( '_', $orderBy );
$query = 'SELECT *'
. "\n FROM " . $_CB_database->NameQuote( '#__comprofiler_plugin_gallery_items' )
. "\n WHERE " . $_CB_database->NameQuote( 'type' ) . " = " . $_CB_database->Quote( $type )
. "\n AND " . $_CB_database->NameQuote( 'user_id' ) . " = " . (int) $user->get( 'id' )
. "\n AND " . $_CB_database->NameQuote( 'folder' ) . " = 0"
. ( $publishedOnly ? "\n AND " . $_CB_database->NameQuote( 'published' ) . " = 1" : null )
. $where
. "\n ORDER BY " . $_CB_database->NameQuote( $orderBy[0] ) . " " . strtoupper( $orderBy[1] );
if ( $params->get( 'tab_' . $type . '_items_paging', 1 ) ) {
$_CB_database->setQuery( $query, $itemsPageNav->limitstart, $itemsPageNav->limit );
} else {
$_CB_database->setQuery( $query );
}
$items = $_CB_database->loadObjectList( null, 'cbgalleryItemTable', array( $_CB_database ) );
$itemsCount = count( $items );
$_PLUGINS->trigger( 'gallery_onLoadItems', array( &$items, $user ) );
if ( $itemsCount && ( ! count( $items ) ) ) {
return $this->getItems( $type, $tab, $user, $viewer, ( $limitstart + $limit ) );
}
switch( $type ) {
case 'photos':
$placeholder = CBTxt::T( 'Search Photos...' );
break;
case 'files':
$placeholder = CBTxt::T( 'Search Files...' );
break;
case 'videos':
$placeholder = CBTxt::T( 'Search Videos...' );
break;
case 'music':
$placeholder = CBTxt::T( 'Search Music...' );
break;
default:
$placeholder = CBTxt::T( 'Search...' );
break;
}
$input['search_items'] = '<input type="text" name="' . htmlspecialchars( $typePrefix . 'search' ) . '" value="' . htmlspecialchars( $search ) . '" onchange="document.' . htmlspecialchars( $type ) . 'ItemsForm.submit();" placeholder="' . htmlspecialchars( $placeholder ) . '" class="form-control" />';
return array( $items, $itemsPageNav, $itemsSearching, $input );
}
/**
* @param int[] $paging
* @param string $where
* @param UserTable $viewer
* @param UserTable $user
* @param PluginTable $plugin
* @return cbblogsBlogTable[]
*/
static public function getBlogs( $paging, $where, $viewer, $user, $plugin )
{
global $_CB_database;
$section = $plugin->params->get( 'blog_j_section', null );
$query = 'SELECT a.*'
. ', a.' . $_CB_database->NameQuote( 'created_by' ) . ' AS user'
. ', a.' . $_CB_database->NameQuote( 'introtext' ) . ' AS blog_intro'
. ', a.' . $_CB_database->NameQuote( 'fulltext' ) . ' AS blog_full'
. ', a.' . $_CB_database->NameQuote( 'state' ) . ' AS published'
. ', b.' . $_CB_database->NameQuote( 'title' ) . ' AS category'
. ', b.' . $_CB_database->NameQuote( 'published' ) . ' AS category_published'
. ', b.' . $_CB_database->NameQuote( 'alias' ) . ' AS category_alias'
. "\n FROM " . $_CB_database->NameQuote( '#__content' ) . " AS a"
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__categories' ) . " AS b"
. ' ON b.' . $_CB_database->NameQuote( 'id' ) . ' = a.' . $_CB_database->NameQuote( 'catid' )
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__users' ) . " AS c"
. ' ON c.' . $_CB_database->NameQuote( 'id' ) . ' = a.' . $_CB_database->NameQuote( 'created_by' );
if ( $section ) {
$query .= "\n LEFT JOIN " . $_CB_database->NameQuote( '#__categories' ) . " AS d"
. ' ON d.' . $_CB_database->NameQuote( 'id' ) . ' = ' . (int) $section;
}
$query .= "\n WHERE b." . $_CB_database->NameQuote( 'extension' ) . " = " . $_CB_database->Quote( 'com_content' );
if ( $section ) {
$query .= "\n AND b." . $_CB_database->NameQuote( 'lft' ) . " BETWEEN ( d." . $_CB_database->NameQuote( 'lft' ) . " + 1 ) AND ( d." . $_CB_database->NameQuote( 'rgt' ) . " - 1 )"
. "\n AND d." . $_CB_database->NameQuote( 'extension' ) . " = " . $_CB_database->Quote( 'com_content' );
}
$query .= "\n AND a." . $_CB_database->NameQuote( 'created_by' ) . " = " . (int) $user->get( 'id' )
. ( ( $viewer->get( 'id' ) != $user->get( 'id' ) ) && ( ! Application::User( (int) $viewer->get( 'id' ) )->isGlobalModerator() ) ? "\n AND a." . $_CB_database->NameQuote( 'state' ) . " = 1" : null )
. "\n AND a." . $_CB_database->NameQuote( 'access' ) . " IN " . $_CB_database->safeArrayOfIntegers( Application::MyUser()->getAuthorisedViewLevels() )
. "\n AND b." . $_CB_database->NameQuote( 'published' ) . " = 1"
. "\n AND b." . $_CB_database->NameQuote( 'access' ) . " IN " . $_CB_database->safeArrayOfIntegers( Application::MyUser()->getAuthorisedViewLevels() )
. $where
. "\n ORDER BY a." . $_CB_database->NameQuote( 'created' ) . " DESC";
if ( $paging ) {
$_CB_database->setQuery( $query, $paging[0], $paging[1] );
} else {
$_CB_database->setQuery( $query );
}
return $_CB_database->loadObjectList( null, 'cbblogsBlogTable', array( $_CB_database ) );
}
/**
* @param cbgalleryItemTable[] $rows
* @param cbPageNav $pageNav
* @param cbgalleryFolderTable|null $folder
* @param bool $searching
* @param UserTable $viewer
* @param UserTable $user
* @param TabTable $tab
* @param cbTabHandler $plugin
* @return string
*/
static public function showFiles( $rows, $pageNav, $folder, $searching, $viewer, $user, $tab, $plugin )
{
global $_CB_framework, $_PLUGINS;
$_PLUGINS->trigger( 'gallery_onBeforeDisplayFiles', array( &$rows, $pageNav, $folder, $searching, $viewer, $user, $tab, $plugin ) );
/** @var Registry $params */
$params = $tab->params;
$profileOwner = ( $viewer->get( 'id' ) == $user->get( 'id' ) );
$cbModerator = Application::User( (int) $viewer->get( 'id' ) )->isGlobalModerator();
$return = '<table class="filesItemsContainer table table-hover table-responsive">'
. '<thead>'
. '<tr>'
. '<th colspan="2"> </th>'
. '<th style="width: 15%;" class="text-center">' . CBTxt::T( 'Type' ) . '</th>'
. '<th style="width: 15%;" class="text-left">' . CBTxt::T( 'Size' ) . '</th>'
. '<th style="width: 20%;" class="text-left hidden-xs">' . CBTxt::T( 'Date' ) . '</th>'
. '<th style="width: 1%;" class="text-right"> </th>'
. '</tr>'
. '</thead>'
. '<tbody>';
if ( $rows ) foreach ( $rows as $row ) {
$extension = null;
$size = 0;
$title = ( $row->get( 'title' ) ? htmlspecialchars( $row->get( 'title' ) ) : $row->getFileName() );
$item = $title;
if ( $row->checkExists() ) {
if ( $row->getLinkDomain() ) {
$showPath = htmlspecialchars( $row->getFilePath() );
$downloadPath = $showPath;
} else {
$showPath = $_CB_framework->pluginClassUrl( $plugin->element, true, array( 'action' => 'items', 'func' => 'show', 'type' => 'files', 'id' => (int) $row->get( 'id' ), 'user' => (int) $user->get( 'id' ), 'tab' => (int) $tab->get( 'tabid' ), 'v' => uniqid() ), 'raw', 0, true );
$downloadPath = $_CB_framework->pluginClassUrl( $plugin->element, true, array( 'action' => 'items', 'func' => 'download', 'type' => 'files', 'id' => (int) $row->get( 'id' ), 'user' => (int) $user->get( 'id' ), 'tab' => (int) $tab->get( 'tabid' ), 'v' => uniqid() ), 'raw', 0, true );
}
$extension = $row->getExtension();
$size = $row->getFileSize();
switch ( $extension ) {
case 'txt':
case 'pdf':
case 'jpg':
case 'jpeg':
case 'png':
case 'gif':
case 'js':
case 'css':
case 'mp4':
case 'mp3':
case 'wav':
$item = '<a href="' . $showPath . '" target="_blank">'
. $item
. '</a>';
break;
default:
$item = '<a href="' . $downloadPath . '" target="_blank">'
. $item
. '</a>';
break;
}
$download = '<a href="' . $downloadPath . '" target="_blank" title="' . htmlspecialchars( CBTxt::T( 'Click to Download' ) ) . '" class="filesItemsDownload btn btn-xs btn-default">'
. '<span class="fa fa-download"></span>'
. '</a>';
} else {
$download = '<button type="button" class="filesItemsDownload btn btn-xs btn-default disabled">'
. '<span class="fa fa-download"></span>'
. '</button>';
}
if ( $row->get( 'description' ) ) {
$item .= ' ' . cbTooltip( 1, $row->get( 'description' ), $title, 400, null, '<span class="fa fa-info-circle text-muted"></span>' );
}
$return .= '<tr>'
. '<td style="width: 1%;" class="text-center">' . $download . '</td>'
. '<td class="text-left">' . $item . '</td>'
. '<td style="width: 15%;" class="text-center"><span class="filesItemsType fa fa-' . htmlspecialchars( self::getFileIcon( $extension ) ) . '" title="' . htmlspecialchars( ( $extension ? strtoupper( $extension ) : CBTxt::T( 'Unknown' ) ) ) . '"></span></td>'
. '<td style="width: 15%;" class="text-left">' . $size . '</td>'
. '<td style="width: 20%;" class="text-left hidden-xs">'
. '<span title="' . htmlspecialchars( $row->get( 'date' ) ) . '">'
. cbFormatDate( $row->get( 'date' ), true, (int) $params->get( 'tab_files_items_time_display', 0 ), $params->get( 'tab_files_items_date_format', 'M j, Y' ), $params->get( 'tab_files_items_time_format', ' g:h A' ) )
. '</span>'
. '</td>';
if ( $cbModerator || $profileOwner ) {
$menuItems = '<ul class="galleryItemsMenuItems dropdown-menu" style="display: block; position: relative; margin: 0;">'
. '<li class="galleryItemsMenuItem"><a href="' . $_CB_framework->pluginClassUrl( $plugin->element, true, array( 'action' => 'items', 'func' => 'edit', 'type' => 'files', 'id' => (int) $row->get( 'id' ), 'user' => (int) $user->get( 'id' ), 'tab' => (int) $tab->get( 'tabid' ) ) ) . '"><span class="fa fa-edit"></span> ' . CBTxt::T( 'Edit' ) . '</a></li>';
if ( ( $row->get( 'published' ) == -1 ) && $plugin->params->get( 'files_item_approval', 0 ) ) {
if ( $cbModerator ) {
$menuItems .= '<li class="galleryItemsMenuItem"><a href="' . $_CB_framework->pluginClassUrl( $plugin->element, true, array( 'action' => 'items', 'func' => 'publish', 'type' => 'files', 'id' => (int) $row->get( 'id' ), 'user' => (int) $user->get( 'id' ), 'tab' => (int) $tab->get( 'tabid' ) ) ) . '"><span class="fa fa-check"></span> ' . CBTxt::T( 'Approve' ) . '</a></li>';
}
} elseif ( $row->get( 'published' ) > 0 ) {
$menuItems .= '<li class="galleryItemsMenuItem"><a href="javascript: void(0);" onclick="if ( confirm( \'' . addslashes( CBTxt::T( 'Are you sure you want to unpublish this File?' ) ) . '\' ) ) { location.href = \'' . $_CB_framework->pluginClassUrl( $plugin->element, false, array( 'action' => 'items', 'func' => 'unpublish', 'type' => 'files', 'id' => (int) $row->get( 'id' ), 'user' => (int) $user->get( 'id' ), 'tab' => (int) $tab->get( 'tabid' ) ) ) . '\'; }"><span class="fa fa-times-circle"></span> ' . CBTxt::T( 'Unpublish' ) . '</a></li>';
} else {
$menuItems .= '<li class="galleryItemsMenuItem"><a href="' . $_CB_framework->pluginClassUrl( $plugin->element, true, array( 'action' => 'items', 'func' => 'publish', 'type' => 'files', 'id' => (int) $row->get( 'id' ), 'user' => (int) $user->get( 'id' ), 'tab' => (int) $tab->get( 'tabid' ) ) ) . '"><span class="fa fa-check"></span> ' . CBTxt::T( 'Publish' ) . '</a></li>';
}
$menuItems .= '<li class="galleryItemsMenuItem"><a href="javascript: void(0);" onclick="if ( confirm( \'' . addslashes( CBTxt::T( 'Are you sure you want to delete this File?' ) ) . '\' ) ) { location.href = \'' . $_CB_framework->pluginClassUrl( $plugin->element, false, array( 'action' => 'items', 'func' => 'delete', 'type' => 'files', 'id' => (int) $row->get( 'id' ), 'user' => (int) $user->get( 'id' ), 'tab' => (int) $tab->get( 'tabid' ) ) ) . '\'; }"><span class="fa fa-trash-o"></span> ' . CBTxt::T( 'Delete' ) . '</a></li>'
. '</ul>';
$menuAttr = cbTooltip( 1, $menuItems, null, 'auto', null, null, null, 'class="btn btn-default btn-xs" data-cbtooltip-menu="true" data-cbtooltip-classes="qtip-nostyle"' );
$return .= '<td style="width: 1%;" class="text-right">'
. '<div class="galleryItemsMenu btn-group">'
. '<button type="button" ' . trim( $menuAttr ) . '><span class="fa fa-cog"></span> <span class="fa fa-caret-down"></span></button>'
. '</div>'
. '</td>';
} else{
$return .= '<td style="width: 1%;"></td>';
}
$return .= '</tr>';
} else {
$return .= '<tr>'
. '<td colspan="6" class="text-left">';
if ( $searching ) {
$return .= CBTxt::T( 'No file search results found.' );
} else {
if ( $folder ) {
$return .= CBTxt::T( 'This folder has no files.' );
} else {
if ( $viewer->get( 'id' ) == $user->get( 'id' ) ) {
$return .= CBTxt::T( 'You have no files.' );
} else {
$return .= CBTxt::T( 'This user has no files.' );
}
}
}
$return .= '</td>'
. '</tr>';
}
$return .= '</tbody>';
if ( $params->get( ( $folder ? 'tab_files_folder_items_paging' : 'tab_files_items_paging' ), 1 ) && ( $pageNav->total > $pageNav->limit ) ) {
$return .= '<tfoot>'
. '<tr>'
. '<td colspan="6" class="galleryItemsPaging text-center">'
. $pageNav->getListLinks()
. '</td>'
. '</tr>'
. '</tfoot>';
}
$return .= '</table>'
. $pageNav->getLimitBox( false );
return $return;
}
/**
* Called when a user is deleted to clean up their private messages
*
* @param UserTable $user
* @param bool $success
* @return bool
*/
public function userDeleted($user, $success)
{
global $_CB_database;
if ($this->isInstalled() && $this->params->get('pmsDelete', 0)) {
$sent = $this->params->get('pmsDeleteSent', 0);
$received = $this->params->get('pmsDeleteRecieved', 1);
if ($sent || $received) {
// Private Messages:
$query = 'DELETE' . "\n FROM " . $_CB_database->NameQuote('#__uddeim');
if ($sent && $received) {
$query .= "\n WHERE ( " . $_CB_database->NameQuote('fromid') . " = " . (int) $user->get('id') . ' OR ' . $_CB_database->NameQuote('toid') . ' = ' . (int) $user->get('id') . ' )';
} elseif ($sent) {
$query .= "\n WHERE " . $_CB_database->NameQuote('fromid') . " = " . (int) $user->get('id');
} elseif ($received) {
$query .= "\n WHERE " . $_CB_database->NameQuote('toid') . " = " . (int) $user->get('id');
}
$_CB_database->setQuery($query);
$_CB_database->query();
}
// Notifications:
$query = 'DELETE' . "\n FROM " . $_CB_database->NameQuote('#__uddeim_emn') . "\n WHERE " . $_CB_database->NameQuote('userid') . " = " . (int) $user->get('id');
$_CB_database->setQuery($query);
$_CB_database->query();
// Blocks:
$query = 'DELETE' . "\n FROM " . $_CB_database->NameQuote('#__uddeim_blocks') . "\n WHERE ( " . $_CB_database->NameQuote('blocker') . " = " . (int) $user->get('id') . ' OR ' . $_CB_database->NameQuote('blocked') . ' = ' . (int) $user->get('id') . ' )';
$_CB_database->setQuery($query);
$_CB_database->query();
// Userlists:
$query = 'DELETE' . "\n FROM " . $_CB_database->NameQuote('#__uddeim_userlists') . "\n WHERE " . $_CB_database->NameQuote('userid') . " = " . (int) $user->get('id');
$_CB_database->setQuery($query);
$_CB_database->query();
// Spam:
$query = 'DELETE' . "\n FROM " . $_CB_database->NameQuote('#__uddeim_spam') . "\n WHERE ( " . $_CB_database->NameQuote('fromid') . " = " . (int) $user->get('id') . ' OR ' . $_CB_database->NameQuote('toid') . ' = ' . (int) $user->get('id') . ' )';
$_CB_database->setQuery($query);
$_CB_database->query();
}
}
/**
* @param cbantispamLogTable[] $rows
* @param cbPageNav $pageNav
* @param UserTable $viewer
* @param UserTable $user
* @param TabTable $tab
* @param cbTabHandler $plugin
* @return string
*/
static public function showLogs( $rows, $pageNav, $viewer, $user, $tab, $plugin )
{
global $_CB_framework;
/** @var Registry $params */
$params = $tab->params;
$return = '<div class="logsTab">'
. '<form action="' . $_CB_framework->userProfileUrl( (int) $user->get( 'id' ), true, (int) $tab->get( 'tabid' ) ) . '" method="post" name="logsForm" id="logsForm" class="logsForm">'
. '<table class="logsContainer table table-hover table-responsive">'
. '<thead>'
. '<tr>'
. '<th class="text-left">' . CBTxt::T( 'IP Address' ) . '</th>'
. '<th style="width: 25%;" class="text-left hidden-xs">' . CBTxt::T( 'Date' ) . '</th>'
. '<th style="width: 10%;" class="text-center hidden-xs">' . CBTxt::T( 'Count' ) . '</th>'
. '<th style="width: 1%;" class="text-right"> </th>'
. '</tr>'
. '</thead>'
. '<tbody>';
if ( $rows ) foreach ( $rows as $row ) {
$return .= '<tr>'
. '<td class="text-left">' . $row->get( 'ip_address' ) . '</td>'
. '<td style="width: 25%;" class="text-left hidden-xs">' . cbFormatDate( $row->get( 'date' ), false ) . '</td>'
. '<td style="width: 10%;" class="text-center hidden-xs">' . $row->get( 'count' ) . '</td>'
. '<td style="width: 1%;" class="text-right">'
. '<a href="javascript: void(0);" onclick="if ( confirm( \'' . addslashes( CBTxt::T( 'Are you sure you want to delete this Log?' ) ) . '\' ) ) { location.href = \'' . $_CB_framework->pluginClassUrl( $plugin->element, false, array( 'action' => 'log', 'func' => 'delete', 'id' => (int) $row->get( 'id' ), 'usr' => (int) $user->get( 'id' ), 'tab' => (int) $tab->get( 'tabid' ) ) ) . '\'; }" title="' . htmlspecialchars( CBTxt::T( 'Delete' ) ) . '"><span class="fa fa-trash-o"></span></a>'
. '</td>'
. '</tr>';
} else {
$return .= '<tr>'
. '<td colspan="3" class="text-left">';
if ( $viewer->get( 'id' ) == $user->get( 'id' ) ) {
$return .= CBTxt::T( 'You have no logs.' );
} else {
$return .= CBTxt::T( 'This user has no logs.' );
}
$return .= '</td>'
. '</tr>';
}
$return .= '</tbody>';
if ( $params->get( 'tab_paging', 1 ) && ( $pageNav->total > $pageNav->limit ) ) {
$return .= '<tfoot>'
. '<tr>'
. '<td colspan="3" class="text-center">'
. $pageNav->getListLinks()
. '</td>'
. '</tr>'
. '</tfoot>';
}
$return .= '</table>'
. $pageNav->getLimitBox( false )
. '</form>'
. '</div>';
return $return;
}
/**
* @param int[] $paging
* @param string $where
* @param UserTable $viewer
* @param UserTable $user
* @param PluginTable $plugin
* @return cbconsultationsconsultationTable[]
*/
static public function getconsultations( $paging, $where, $viewer, $user, /** @noinspection PhpUnusedParameterInspection */ $plugin )
{
global $_CB_database;
$categories = cbconsultationsModel::getCategoriesList( true );
$consultations = array();
if ( $categories ) {
$query = 'SELECT a.*'
. ', a.' . $_CB_database->NameQuote( 'created_by' ) . ' AS user'
. ', a.' . $_CB_database->NameQuote( 'introtext' ) . ' AS consultation_intro'
. ', a.' . $_CB_database->NameQuote( 'fulltext' ) . ' AS consultation_full'
. ', b.' . $_CB_database->NameQuote( 'name' ) . ' AS category'
. ', b.' . $_CB_database->NameQuote( 'published' ) . ' AS category_published'
. ', b.' . $_CB_database->NameQuote( 'alias' ) . ' AS category_alias'
. "\n FROM " . $_CB_database->NameQuote( '#__k2_items' ) . " AS a"
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__k2_categories' ) . " AS b"
. ' ON b.' . $_CB_database->NameQuote( 'id' ) . ' = a.' . $_CB_database->NameQuote( 'catid' )
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__users' ) . " AS c"
. ' ON c.' . $_CB_database->NameQuote( 'id' ) . ' = a.' . $_CB_database->NameQuote( 'created_by' )
. "\n WHERE a." . $_CB_database->NameQuote( 'catid' ) . " IN ( " . implode( ',', $categories ) . " )"
. "\n AND a." . $_CB_database->NameQuote( 'created_by' ) . " = " . (int) $user->get( 'id' )
. ( ( $viewer->get( 'id' ) != $user->get( 'id' ) ) && ( ! Application::User( (int) $viewer->get( 'id' ) )->isGlobalModerator() ) ? "\n AND a." . $_CB_database->NameQuote( 'published' ) . " = 1" : null )
. "\n AND a." . $_CB_database->NameQuote( 'access' ) . " IN " . $_CB_database->safeArrayOfIntegers( Application::MyUser()->getAuthorisedViewLevels() )
. $where
. "\n ORDER BY a." . $_CB_database->NameQuote( 'created' ) . " DESC";
if ( $paging ) {
$_CB_database->setQuery( $query, $paging[0], $paging[1] );
} else {
$_CB_database->setQuery( $query );
}
$consultations = $_CB_database->loadObjectList( null, 'cbconsultationsconsultationTable', array( $_CB_database ) );
}
return $consultations;
}
/**
* Renders the Blogs tab
*
* @param OrderedTable[] $rows Blogs to render
* @param cbPageNav $pageNav Pagination
* @param boolean $searching Currently searching
* @param string[] $input HTML of input elements
* @param UserTable $viewer Viewing user
* @param UserTable $user Viewed user
* @param stdClass $model The model reference
* @param TabTable $tab Current Tab
* @param PluginTable $plugin Current Plugin
* @return string HTML
*/
static function showBlogTab($rows, $pageNav, $searching, $input, $viewer, $user, $model, $tab, $plugin)
{
global $_CB_framework;
$blogLimit = (int) $plugin->params->get('blog_limit', null);
$tabPaging = $tab->params->get('tab_paging', 1);
$canSearch = $tab->params->get('tab_search', 1) && ($searching || $pageNav->total);
$canCreate = false;
$profileOwner = $viewer->get('id') == $user->get('id');
$cbModerator = Application::User((int) $viewer->get('id'))->isGlobalModerator();
$canPublish = $cbModerator || $profileOwner && !$plugin->params->get('blog_approval', 0);
if ($profileOwner) {
if ($cbModerator) {
$canCreate = true;
} elseif ($user->get('id') && Application::User((int) $viewer->get('id'))->canViewAccessLevel((int) $plugin->params->get('blog_create_access', 2))) {
if (!$blogLimit || $blogLimit && $pageNav->total < $blogLimit) {
$canCreate = true;
}
}
}
$return = '<div class="blogsTab">' . '<form action="' . $_CB_framework->userProfileUrl($user->get('id'), true, $tab->tabid) . '" method="post" name="blogForm" id="blogForm" class="blogForm">';
if ($canCreate || $canSearch) {
$return .= '<div class="blogsHeader row" style="margin-bottom: 10px;">';
if ($canCreate) {
$return .= '<div class="' . (!$canSearch ? 'col-sm-12' : 'col-sm-8') . ' text-left">' . '<button type="button" onclick="location.href=\'' . $_CB_framework->pluginClassUrl($plugin->element, false, array('action' => 'blogs', 'func' => 'new')) . '\';" class="blogsButton blogsButtonNew btn btn-success"><span class="fa fa-plus-circle"></span> ' . CBTxt::T('New Blog') . '</button>' . '</div>';
}
if ($canSearch) {
$return .= '<div class="' . (!$canCreate ? 'col-sm-offset-8 ' : null) . 'col-sm-4 text-right">' . '<div class="input-group">' . '<span class="input-group-addon"><span class="fa fa-search"></span></span>' . $input['search'] . '</div>' . '</div>';
}
$return .= '</div>';
}
$menuAccess = $cbModerator || $profileOwner || $canPublish;
$return .= '<table class="blogsContainer table table-hover table-responsive">' . '<thead>' . '<tr>' . '<th style="width: 50%;" class="text-left">' . CBTxt::T('Title') . '</th>' . '<th style="width: 25%;" class="text-left hidden-xs">' . CBTxt::T('Category') . '</th>' . '<th style="width: 24%;" class="text-left hidden-xs">' . CBTxt::T('Created') . '</th>' . ($menuAccess ? '<th style="width: 1%;" class="text-right"> </th>' : null) . '</tr>' . '</thead>' . '<tbody>';
if ($rows) {
foreach ($rows as $row) {
$return .= '<tr>' . '<td style="width: 50%;" class="text-left">' . ($row->get('published') ? '<a href="' . cbblogsModel::getUrl($row, true, 'article') . '">' . $row->get('title') . '</a>' : $row->get('title')) . '</td>' . '<td style="width: 25%;" class="text-left hidden-xs">' . ($row->get('category_published') ? '<a href="' . cbblogsModel::getUrl($row, true, 'category') . '">' . $row->get('category') . '</a>' : $row->get('category')) . '</td>' . '<td style="width: 24%;" class="text-left hidden-xs">' . cbFormatDate($row->get('created')) . '</td>';
if ($menuAccess) {
$menuItems = '<ul class="blogsMenuItems dropdown-menu" style="display: block; position: relative; margin: 0;">';
if ($cbModerator || $profileOwner) {
$menuItems .= '<li class="blogsMenuItem"><a href="' . $_CB_framework->pluginClassUrl($plugin->element, true, array('action' => 'blogs', 'func' => 'edit', 'id' => (int) $row->get('id'))) . '"><span class="fa fa-edit"></span> ' . CBTxt::T('Edit') . '</a></li>';
}
if ($canPublish) {
if ($row->get('published')) {
$menuItems .= '<li class="blogsMenuItem"><a href="javascript: void(0);" onclick="if ( confirm( \'' . addslashes(CBTxt::T('Are you sure you want to unpublish this Blog?')) . '\' ) ) { location.href = \'' . $_CB_framework->pluginClassUrl($plugin->element, false, array('action' => 'blogs', 'func' => 'unpublish', 'id' => (int) $row->get('id'))) . '\'; }"><span class="fa fa-times-circle"></span> ' . CBTxt::T('Unpublish') . '</a></li>';
} else {
$menuItems .= '<li class="blogsMenuItem"><a href="' . $_CB_framework->pluginClassUrl($plugin->element, true, array('action' => 'blogs', 'func' => 'publish', 'id' => (int) $row->get('id'))) . '"><span class="fa fa-check"></span> ' . CBTxt::T('Publish') . '</a></li>';
}
}
if ($cbModerator || $profileOwner) {
$menuItems .= '<li class="blogsMenuItem"><a href="javascript: void(0);" onclick="if ( confirm( \'' . addslashes(CBTxt::T('Are you sure you want to delete this Blog?')) . '\' ) ) { location.href = \'' . $_CB_framework->pluginClassUrl($plugin->element, false, array('action' => 'blogs', 'func' => 'delete', 'id' => (int) $row->get('id'))) . '\'; }"><span class="fa fa-trash-o"></span> ' . CBTxt::T('Delete') . '</a></li>';
}
$menuItems .= '</ul>';
$menuAttr = cbTooltip(1, $menuItems, null, 'auto', null, null, null, 'class="btn btn-default btn-xs" data-cbtooltip-menu="true" data-cbtooltip-classes="qtip-nostyle"');
$return .= '<td style="width: 1%;" class="text-right">' . '<div class="blogsMenu btn-group">' . '<button type="button"' . $menuAttr . '><span class="fa fa-cog"></span> <span class="fa fa-caret-down"></span></button>' . '</div>' . '</td>';
}
$return .= '</tr>';
}
} else {
$return .= '<tr>' . '<td colspan="' . ($menuAccess ? 4 : 3) . '" class="text-left">';
if ($searching) {
$return .= CBTxt::T('No blog search results found.');
} else {
if ($viewer->id == $user->id) {
$return .= CBTxt::T('You have no blogs.');
} else {
$return .= CBTxt::T('This user has no blogs.');
}
}
$return .= '</td>' . '</tr>';
}
$return .= '</tbody>';
if ($tabPaging && $pageNav->total > $pageNav->limit) {
$return .= '<tfoot>' . '<tr>' . '<td colspan="' . ($menuAccess ? 4 : 3) . '" class="text-center">' . $pageNav->getListLinks() . '</td>' . '</tr>' . '</tfoot>';
}
$return .= '</table>' . $pageNav->getLimitBox(false) . '</form>' . '</div>';
return $return;
}
/**
* render frontend videos
*
* @param VideoTable[] $rows
* @param cbPageNav $pageNav
* @param bool $searching
* @param array $input
* @param array $counters
* @param GroupTable $group
* @param UserTable $user
* @param cbgjVideoPlugin $plugin
* @return string
*/
static function showVideos( $rows, $pageNav, $searching, $input, &$counters, $group, $user, $plugin )
{
global $_CB_framework, $_PLUGINS;
$_CB_framework->outputCbJQuery( "$( '.gjVideoPlayer' ).mediaelementplayer();", 'media' );
$counters[] = '<span class="gjGroupVideoIcon fa-before fa-film"> ' . CBTxt::T( 'GROUP_VIDEOS_COUNT', '%%COUNT%% Video|%%COUNT%% Videos', array( '%%COUNT%%' => (int) $pageNav->total ) ) . '</span>';
initToolTip();
$isModerator = CBGroupJive::isModerator( $user->get( 'id' ) );
$isOwner = ( $user->get( 'id' ) == $group->get( 'user_id' ) );
$userStatus = CBGroupJive::getGroupStatus( $user, $group );
$canCreate = CBGroupJive::canCreateGroupContent( $user, $group, 'video' );
$canSearch = ( $plugin->params->get( 'groups_video_search', 1 ) && ( $searching || $pageNav->total ) );
$return = null;
$_PLUGINS->trigger( 'gj_onBeforeDisplayVideos', array( &$return, &$rows, $group, $user ) );
$return .= '<div class="gjGroupVideo">'
. '<form action="' . $_CB_framework->pluginClassUrl( $plugin->_gjPlugin->element, true, array( 'action' => 'groups', 'func' => 'show', 'id' => (int) $group->get( 'id' ) ) ) . '" method="post" name="gjGroupVideoForm" id="gjGroupVideoForm" class="gjGroupVideoForm">';
if ( $canCreate || $canSearch ) {
$return .= '<div class="gjHeader gjGroupVideoHeader row">';
if ( $canCreate ) {
$return .= '<div class="' . ( ! $canSearch ? 'col-sm-12' : 'col-sm-8' ) . ' text-left">'
. '<button type="button" onclick="window.location.href=\'' . $_CB_framework->pluginClassUrl( $plugin->element, false, array( 'action' => 'video', 'func' => 'new', 'group' => (int) $group->get( 'id' ) ) ) . '\';" class="gjButton gjButtonNewVideo btn btn-success"><span class="fa fa-plus-circle"></span> ' . CBTxt::T( 'New Video' ) . '</button>'
. '</div>';
}
if ( $canSearch ) {
$return .= '<div class="' . ( ! $canCreate ? 'col-sm-offset-8 ' : null ) . 'col-sm-4 text-right">'
. '<div class="input-group">'
. '<span class="input-group-addon"><span class="fa fa-search"></span></span>'
. $input['search']
. '</div>'
. '</div>';
}
$return .= '</div>';
}
$return .= '<div class="gjGroupVideoRows">';
if ( $rows ) foreach ( $rows as $row ) {
$rowCounters = array();
$content = null;
$menu = array();
$_PLUGINS->trigger( 'gj_onDisplayVideo', array( &$row, &$rowCounters, &$content, &$menu, $group, $user ) );
$return .= '<div class="gjGroupVideoRow gjContainerBox img-thumbnail">'
. '<div class="gjContainerBoxHeader">'
. '<video width="640" height="360" style="width: 100%; height: 100%;" id="gjVideoPlayer' . (int) $row->get( 'id' ) . '" src="' . htmlspecialchars( $row->get( 'url' ) ) . '" type="' . htmlspecialchars( $row->mimeType() ) . '" controls="controls" preload="none" class="gjVideoPlayer"></video>'
. '</div>'
. '<div class="gjContainerBoxBody text-left">'
. '<div class="gjContainerBoxTitle">'
. '<a href="' . htmlspecialchars( $row->get( 'url' ) ) . '" target="_blank" rel="nofollow">' . htmlspecialchars( ( $row->get( 'title' ) ? $row->get( 'title' ) : $row->name() ) ) . '</a>'
. '</div>'
. '<div class="gjContainerBoxCounters text-muted small row">'
. '<div class="gjGroupVideoPublisher gjContainerBoxCounter col-sm-6">' . CBuser::getInstance( (int) $row->get( 'user_id' ), false )->getField( 'formatname', null, 'html', 'none', 'list', 0, true ) . '</div>'
. '<div class="gjContainerBoxCounter col-sm-6 text-right">'
. '<span title="' . htmlspecialchars( $row->get( 'date' ) ) . '">'
. cbFormatDate( $row->get( 'date' ), true, false, CBTxt::T( 'GROUP_VIDEO_DATE_FORMAT', 'M j, Y' ) )
. '</span>'
. '</div>'
. ( $rowCounters ? '<div class="gjContainerBoxCounter col-sm-6">' . implode( '</div><div class="gjContainerBoxCounter col-sm-6">', $rowCounters ) . '</div>' : null )
. '</div>'
. ( $content ? '<div class="gjContainerBoxContent">' . $content . '</div>' : null )
. ( $row->get( 'caption' ) ? '<div class="gjContainerBoxDescription">' . cbTooltip( 1, $row->get( 'caption' ), $row->name(), 400, null, '<span class="fa fa-info-circle text-muted"></span>' ) . '</div>' : null );
if ( ( $isModerator || $isOwner || ( $userStatus >= 2 ) ) && ( $row->get( 'published' ) == -1 ) && ( $group->params()->get( 'video', 1 ) == 2 ) ) {
$return .= '<div class="gjContainerBoxButton text-right">'
. '<button type="button" onclick="window.location.href=\'' . $_CB_framework->pluginClassUrl( $plugin->element, true, array( 'action' => 'video', 'func' => 'publish', 'id' => (int) $row->get( 'id' ) ) ) . '\';" class="gjButton gjButtonApprove btn btn-xs btn-success">' . CBTxt::T( 'Approve' ) . '</button>'
. '</div>';
}
$return .= '</div>';
if ( $isModerator || $isOwner || ( $user->get( 'id' ) == $row->get( 'user_id' ) ) || ( $userStatus >= 2 ) || $menu ) {
$menuItems = '<ul class="gjVideoMenuItems dropdown-menu" style="display: block; position: relative; margin: 0;">';
if ( $isModerator || $isOwner || ( $user->get( 'id' ) == $row->get( 'user_id' ) ) || ( $userStatus >= 2 ) ) {
$menuItems .= '<li class="gjVideoMenuItem"><a href="' . $_CB_framework->pluginClassUrl( $plugin->element, true, array( 'action' => 'video', 'func' => 'edit', 'id' => (int) $row->get( 'id' ) ) ) . '"><span class="fa fa-edit"></span> ' . CBTxt::T( 'Edit' ) . '</a></li>';
if ( ( $row->get( 'published' ) == -1 ) && ( $group->params()->get( 'video', 1 ) == 2 ) ) {
if ( $isModerator || $isOwner || ( $userStatus >= 2 ) ) {
$menuItems .= '<li class="gjVideoMenuItem"><a href="' . $_CB_framework->pluginClassUrl( $plugin->element, true, array( 'action' => 'video', 'func' => 'publish', 'id' => (int) $row->get( 'id' ) ) ) . '"><span class="fa fa-check"></span> ' . CBTxt::T( 'Approve' ) . '</a></li>';
}
} elseif ( $row->get( 'published' ) == 1 ) {
$menuItems .= '<li class="gjVideoMenuItem"><a href="javascript: void(0);" onclick="cbjQuery.cbconfirm( \'' . addslashes( CBTxt::T( 'Are you sure you want to unpublish this Video?' ) ) . '\' ).done( function() { window.location.href = \'' . $_CB_framework->pluginClassUrl( $plugin->element, false, array( 'action' => 'video', 'func' => 'unpublish', 'id' => (int) $row->get( 'id' ) ) ) . '\'; })"><span class="fa fa-times-circle"></span> ' . CBTxt::T( 'Unpublish' ) . '</a></li>';
} else {
$menuItems .= '<li class="gjVideoMenuItem"><a href="' . $_CB_framework->pluginClassUrl( $plugin->element, true, array( 'action' => 'video', 'func' => 'publish', 'id' => (int) $row->get( 'id' ) ) ) . '"><span class="fa fa-check"></span> ' . CBTxt::T( 'Publish' ) . '</a></li>';
}
}
if ( $menu ) {
$menuItems .= '<li class="gjVideoMenuItem">' . implode( '</li><li class="gjVideoMenuItem">', $menu ) . '</li>';
}
if ( $isModerator || $isOwner || ( $user->get( 'id' ) == $row->get( 'user_id' ) ) || ( $userStatus >= 2 ) ) {
$menuItems .= '<li class="gjVideoMenuItem"><a href="javascript: void(0);" onclick="cbjQuery.cbconfirm( \'' . addslashes( CBTxt::T( 'Are you sure you want to delete this Video?' ) ) . '\' ).done( function() { window.location.href = \'' . $_CB_framework->pluginClassUrl( $plugin->element, false, array( 'action' => 'video', 'func' => 'delete', 'id' => (int) $row->get( 'id' ) ) ) . '\'; })"><span class="fa fa-trash-o"></span> ' . CBTxt::T( 'Delete' ) . '</a></li>';
}
$menuItems .= '</ul>';
$menuAttr = cbTooltip( 1, $menuItems, null, 'auto', null, null, null, 'class="btn btn-default btn-xs" data-cbtooltip-menu="true" data-cbtooltip-classes="qtip-nostyle"' );
$return .= '<div class="gjContainerBoxMenu">'
. '<div class="gjVideoMenu btn-group">'
. '<button type="button" ' . trim( $menuAttr ) . '><span class="fa fa-cog"></span> <span class="fa fa-caret-down"></span></button>'
. '</div>'
. '</div>';
}
$return .= '</div>';
} else {
if ( $searching ) {
$return .= CBTxt::T( 'No group video search results found.' );
} else {
$return .= CBTxt::T( 'This group currently has no videos.' );
}
}
$return .= '</div>';
if ( $plugin->params->get( 'groups_video_paging', 1 ) && ( $pageNav->total > $pageNav->limit ) ) {
$return .= '<div class="gjGroupVideoPaging text-center">'
. $pageNav->getListLinks()
. '</div>';
}
$return .= $pageNav->getLimitBox( false )
. '</form>'
. '</div>';
$_PLUGINS->trigger( 'gj_onAfterDisplayVideos', array( &$return, $rows, $group, $user ) );
return $return;
}
/**
* Outputs search format including $html being html with input fields
*
* @param FieldTable $field
* @param UserTable $user
* @param string $html
* @param string $type 'text', 'choice', 'isisnot', 'none'
* @param int $list_compare_types IF reason == 'search' : 0 : simple 'is' search, 1 : advanced search with modes, 2 : simple 'any' search
* @param string $class Extra-class (e.g. for jQuery)
* @return string
*/
protected function _fieldSearchModeHtml(&$field, &$user, $html, $type, $list_compare_types, $class = '')
{
switch ($list_compare_types) {
case 1:
// Advanced: all possibilities:
$col = $field->name . '__srmch';
$selected = $user->get($col);
switch ($type) {
case 'text':
$choices = array('is' => CBTxt::T('UE_MATCH_IS_EXACTLY', 'is exactly'), 'phrase' => CBTxt::T('UE_MATCH_PHRASE', 'contains phrase'), 'all' => CBTxt::T('UE_MATCH_ALL', 'contains all of'), 'any' => CBTxt::T('UE_MATCH_ANY', 'contains any of'), '-' => CBTxt::T('UE_MATCH_EXCLUSIONS', 'Exclusions:'), 'isnot' => CBTxt::T('UE_MATCH_IS_EXACTLY_NOT', 'is exactly not'), 'phrasenot' => CBTxt::T('UE_MATCH_PHRASE_NOT', 'doesn\'t contain phrase'), 'allnot' => CBTxt::T('UE_MATCH_ALL_NOT', 'doesn\'t contain all of'), 'anynot' => CBTxt::T('UE_MATCH_ANY_NOT', 'doesn\'t contain any of'));
break;
case 'singlechoice':
$choices = array('is' => CBTxt::T('UE_MATCH_IS', 'is'), 'anyis' => CBTxt::T('UE_MATCH_IS_ONE_OF', 'is one of'), '-' => CBTxt::T('UE_MATCH_EXCLUSIONS', 'Exclusions:'), 'isnot' => CBTxt::T('UE_MATCH_IS_NOT', 'is not'), 'anyisnot' => CBTxt::T('UE_MATCH_IS_NOT_ONE_OF', 'is not one of'));
break;
case 'multiplechoice':
$choices = array('is' => CBTxt::T('UE_MATCH_ARE_EXACTLY', 'are exactly'), 'all' => CBTxt::T('UE_MATCH_INCLUDE_ALL_OF', 'include all of'), 'any' => CBTxt::T('UE_MATCH_INCLUDE_ANY_OF', 'include any of'), '-' => CBTxt::T('Exclusions:'), 'isnot' => CBTxt::T('UE_MATCH_ARE_EXACTLY_NOT', 'are exactly not'), 'allnot' => CBTxt::T('UE_MATCH_INCLUDE_ALL_OF_NOT', 'don\'t include all of'), 'anynot' => CBTxt::T('UE_MATCH_INCLUDE_ANY_OF_NOT', 'don\'t include any of'));
break;
case 'isisnot':
$choices = array('is' => CBTxt::T('UE_MATCH_IS', 'is'), '-' => CBTxt::T('UE_MATCH_EXCLUSIONS_COLUMN', 'Exclusions:'), 'isnot' => CBTxt::T('UE_MATCH_IS_NOT', 'is not'));
break;
case 'none':
default:
$choices = null;
break;
}
if ($choices !== null) {
$drop = array();
$drop[] = moscomprofilerHTML::makeOption('', CBTxt::T('UE_NO_PREFERENCE', 'No preference'));
$group = false;
foreach ($choices as $k => $v) {
if ($k == '-') {
$drop[] = moscomprofilerHTML::makeOptGroup($v);
$group = true;
} else {
$drop[] = moscomprofilerHTML::makeOption($k, $v);
}
}
if ($group) {
$drop[] = moscomprofilerHTML::makeOptGroup(null);
}
$additional = ' class="form-control"';
$list = moscomprofilerHTML::selectList($drop, $field->name . '__srmch', $additional, 'value', 'text', $selected, 1);
} else {
$list = null;
}
$return = '<div class="cbSearchContainer cbSearchAdvanced' . ($type ? ' cbSearchAdvanced' . ucfirst($type) : '') . '">' . ($list ? '<div class="cbSearchKind' . ($type ? ' cbSearchKind' . ucfirst($type) : '') . '">' . $list . '</div>' : '') . '<div class="cbSearchCriteria' . ($type ? ' cbSearchCriteria' . ucfirst($type) : '') . ($class ? ' ' . $class : '') . '">' . $html . '</div>' . '</div>';
break;
case 2:
// Simple "contains" and ranges:
// Simple "contains" and ranges:
case 0:
default:
// Simple: Only 'is' and ranges:
$return = '<div class="cbSearchContainer cbSearchSimple">' . '<div class="cbSearchCriteria' . ($class ? ' ' . $class : '') . '">' . $html . '</div>' . '</div>';
break;
}
return $return;
}
/**
* 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 )
);
}
/**
* Deletes a user without any check or warning, and related reports, sessions
*
* @deprecated 2.0 Use UserTable()->load( $condition or $id )->delete( null, $cbUserOnly )
*
* @param int $id User id
* @param string $condition ONLY allowed string: "return (\$user->block == 1);" (CBSubs 3.0.0) php condition string on $user e.g. "return (\$user->block == 1);"
* @param boolean $inComprofilerOnly deletes user only in CB, not in Mambo/Joomla
* @return null|boolean|string '' if user deleted and found ok, NULL if user not found, FALSE if condition was not met, STRING error in case of error raised by plugin
*/
function cbDeleteUser($id, $condition = null, $inComprofilerOnly = false)
{
if (!$id) {
return null;
}
$user = new UserTable();
if ($inComprofilerOnly) {
$user->load(array('user_id' => (int) $id));
} else {
$user->load((int) $id);
}
if (!$user->id) {
return null;
}
if ($condition == null || eval($condition)) {
if (!$user->delete((int) $id, $inComprofilerOnly)) {
return $user->getError();
}
return '';
}
return false;
}
/**
* @param ActivityTable $row
* @param Activity $stream
* @param int $output 0: Normal, 1: Raw, 2: Inline, 3: Load, 4: Save
* @param UserTable $user
* @param UserTable $viewer
* @param cbPluginHandler $plugin
* @return null|string
*/
static public function showAttachments( $row, $stream, $output, $user, $viewer, $plugin )
{
global $_PLUGINS;
if ( ! $stream->get( 'links', 1 ) ) {
return null;
}
$links = $row->attachments();
$_PLUGINS->trigger( 'activity_onDisplayActivityAttachments', array( &$row, &$links, $stream, $output ) );
if ( ! $links ) {
return null;
}
$cbModerator = CBActivity::isModerator( (int) $viewer->get( 'id' ) );
$isStatus = ( ( $row->get( 'type' ) == 'status' ) || ( $row->get( 'subtype' ) == 'status' ) );
$rowOwner = ( $viewer->get( 'id' ) == $row->get( 'user_id' ) );
$count = count( $links );
$return = '<div class="streamItemScroll">'
. '<div class="streamItemScrollLeft' . ( $count > 1 ? null : ' hidden' ) . '">'
. '<table>'
. '<tr>'
. '<td>'
. '<span class="streamItemScrollLeftIcon fa fa-chevron-left"></span>'
. '</td>'
. '</tr>'
. '</table>'
. '</div>';
foreach ( $links as $i => $link ) {
$hasMedia = ( ( $link['type'] == 'custom' ) || ( ( $link['type'] != 'url' ) && $link['media']['url'] ) || ( ( $link['type'] == 'url' ) && $link['media']['url'] && $link['thumbnail'] ) );
$return .= '<div class="activityContainerAttachment streamItemScrollContent ' . ( $link['type'] == 'url' ? 'streamMedia media' : 'streamPanel panel' ) . ( $i != 0 ? ' hidden' : null ) . '">';
if ( $hasMedia ) {
$return .= '<div class="activityContainerAttachmentMedia ' . ( $link['type'] == 'url' ? 'streamMediaLeft media-left' : 'streamPanelBody panel-body' ) . ' text-center">';
switch ( $link['type'] ) {
case 'custom':
$return .= $link['media']['custom'];
break;
case 'video':
$return .= '<video width="640" height="360" style="width: 100%; height: 100%;" src="' . htmlspecialchars( $link['media']['url'] ) . '" type="' . htmlspecialchars( $link['media']['mimetype'] ) . '" class="streamItemVideo" preload="none" controls></video>';
break;
case 'audio':
$return .= '<audio width="640" style="width: 100%;" src="' . htmlspecialchars( $link['media']['url'] ) . '" type="' . htmlspecialchars( $link['media']['mimetype'] ) . '" class="streamItemAudio" preload="none" controls></audio>';
break;
case 'image':
$return .= '<a href="' . htmlspecialchars( $link['url'] ) . '" rel="nofollow" target="_blank">'
. '<img src="' . htmlspecialchars( $link['media']['url'] ) . '" class="img-responsive streamItemImage" />'
. '</a>';
break;
case 'url':
default:
$return .= '<a href="' . htmlspecialchars( $link['url'] ) . '" rel="nofollow" target="_blank">'
. '<img src="' . htmlspecialchars( $link['media']['url'] ) . '" class="img-responsive streamItemImage" />'
. '</a>';
break;
}
$return .= '</div>';
}
if ( $link['title'] || $link['description'] || ( ( ! $link['internal'] ) && ( ( ! $link['title'] ) || $link['text'] ) ) || ( $count > 1 ) ) {
$hypertext = ( $link['text'] ? CBTxt::T( $link['text'] ) : $link['url'] );
$return .= '<div class="streamPanelFooter streamItemDisplay activityContainerAttachmentInfo panel-footer' . ( $link['type'] == 'url' ? ' streamMediaBody media-body' : null ) . '">'
. '<div class="cbMoreLess">'
. '<div class="cbMoreLessContent">'
. ( $link['title'] ? '<div><strong><a href="' . htmlspecialchars( $link['url'] ) . '" rel="nofollow" target="_blank">' . ( $isStatus ? htmlspecialchars( CBTxt::T( $link['title'] ) ) : CBTxt::T( $link['title'] ) ) . '</a></strong></div>' : null )
. ( $isStatus ? htmlspecialchars( CBTxt::T( $link['description'] ) ) : CBTxt::T( $link['description'] ) )
. '</div>'
. '<div class="activityContainerAttachmentUrl small">'
. ( ( ! $link['internal'] ) && ( ( ! $link['title'] ) || $link['text'] ) ? '<a href="' . htmlspecialchars( $link['url'] ) . '" rel="nofollow" target="_blank">' . ( $isStatus ? htmlspecialchars( $hypertext ) : $hypertext ) . '</a>' : null )
. ( $count > 1 ? '<div class="activityContainerAttachmentCount text-muted">' . ( $i + 1 ) . ' - ' . $count . '</div>' : null )
. '</div>'
. '<div class="cbMoreLessOpen fade-edge hidden">'
. '<a href="javascript: void(0);" class="cbMoreLessButton">' . CBTxt::T( 'See More' ) . '</a>'
. '</div>'
. '</div>'
. '</div>';
}
if ( $isStatus && ( $cbModerator || $rowOwner ) ) {
$return .= '<div class="streamPanelFooter streamItemEdit activityContainerAttachmentInfo panel-footer' . ( $link['type'] == 'url' ? ' streamMediaBody media-body' : null ) . ' hidden">'
. '<input type="text" id="' . $stream->id() . '_links_title_edit_' . (int) $row->get( 'id' ) . '_' . ( $i + 1 ) . '" name="links[' . $i . '][title]" value="' . htmlspecialchars( $link['title'] ) . '" class="streamInput streamInputLinkTitle form-control" placeholder="' . htmlspecialchars( CBTxt::T( 'Title' ) ) . '" />'
. '<textarea id="' . $stream->id() . '_links_description_edit_' . (int) $row->get( 'id' ) . '_' . ( $i + 1 ) . '" name="links[' . $i . '][description]" rows="1" class="streamInput streamInputAutosize streamInputLinkDescription form-control" placeholder="' . htmlspecialchars( CBTxt::T( 'Description' ) ) . '">' . htmlspecialchars( $link['description'] ) . '</textarea>';
if ( $link['type'] == 'url' ) {
$return .= '<div class="streamInput">'
. '<label class="checkbox-inline">'
. '<input type="checkbox" id="' . $stream->id() . '_links_thumbnail_edit_' . (int) $row->get( 'id' ) . '_' . ( $i + 1 ) . '" name="links[' . $i . '][thumbnail]" value="0"' . ( ! $link['thumbnail'] ? ' checked="checked"' : null ) . '> ' . CBTxt::T( 'Do not display thumbnail' )
. '</label>'
. '</div>';
}
$return .= '</div>';
}
$return .= '</div>';
}
$return .= '<div class="streamItemScrollRight' . ( $count > 1 ? null : ' hidden' ) . '">'
. '<table>'
. '<tr>'
. '<td>'
. '<span class="streamItemScrollRightIcon fa fa-chevron-right"></span>'
. '</td>'
. '</tr>'
. '</table>'
. '</div>'
. '</div>';
return $return;
}
/**
* Saves legacy user edit display
*
* @param string $option
* @param string $task
*/
public function saveUser($option, $task = 'save')
{
global $_CB_framework, $_CB_Backend_task, $_POST, $_PLUGINS;
cbimport('language.all');
cbimport('cb.tabs');
cbimport('cb.params');
cbimport('cb.adminfilesystem');
cbimport('cb.imgtoolbox');
$userIdPosted = (int) cbGetParam($_POST, 'id', 0);
if ($userIdPosted == 0) {
$_POST['id'] = null;
}
$msg = $this->_authorizedEdit($userIdPosted);
if (!$msg) {
if ($userIdPosted != 0) {
$msg = checkCBpermissions(array($userIdPosted), 'save', true);
} else {
$msg = checkCBpermissions(null, 'save', true);
}
}
if ($userIdPosted != 0) {
$_PLUGINS->trigger('onBeforeUserProfileSaveRequest', array($userIdPosted, &$msg, 2));
}
if ($msg) {
cbRedirect($_CB_framework->backendViewUrl('showusers', false), $msg, 'error');
}
$_PLUGINS->loadPluginGroup('user');
// Get current user state:
if ($userIdPosted != 0) {
$userComplete = CBuser::getUserDataInstance($userIdPosted);
if (!($userComplete && $userComplete->id)) {
cbRedirect($_CB_framework->backendViewUrl('showusers', false), CBTxt::T('Your profile could not be updated.'), 'error');
}
} else {
$userComplete = new UserTable();
}
// Store new user state:
$saveResult = $userComplete->saveSafely($_POST, $_CB_framework->getUi(), 'edit');
if (!$saveResult) {
$regErrorMSG = $userComplete->getError();
$msg = checkCBpermissions(array((int) $userComplete->id), 'edit', true);
if ($userIdPosted != 0) {
$_PLUGINS->trigger('onBeforeUserProfileEditRequest', array((int) $userComplete->id, &$msg, 2));
}
if ($msg) {
cbRedirect($_CB_framework->backendViewUrl('showusers', false), $msg, 'error');
}
if ($userIdPosted != 0) {
$_PLUGINS->trigger('onAfterUserProfileSaveFailed', array(&$userComplete, &$regErrorMSG, 2));
} else {
$_PLUGINS->trigger('onAfterUserRegistrationSaveFailed', array(&$userComplete, &$regErrorMSG, 2));
}
$_CB_framework->enqueueMessage($regErrorMSG, 'error');
$_CB_Backend_task = 'edit';
// so the toolbar comes up...
$_PLUGINS->loadPluginGroup('user');
// resets plugin errors
$userView = _CBloadView('user');
/** @var CBController_user $userView */
$userView->edituser($userComplete, $option, $userComplete->user_id != null ? 0 : 1, $_POST);
return;
}
// Checks-in the row:
$userComplete->checkin();
if ($userIdPosted != 0) {
$_PLUGINS->trigger('onAfterUserProfileSaved', array(&$userComplete, 2));
} else {
$messagesToUser = array();
$_PLUGINS->trigger('onAfterSaveUserRegistration', array(&$userComplete, &$messagesToUser, 2));
}
if ($task == 'apply') {
cbRedirect($_CB_framework->backendViewUrl('edit', false, array('cid' => (int) $userComplete->user_id)), CBTxt::T('SUCCESSFULLY_SAVED_USER_USERNAME', 'Successfully Saved User: [username]', array('[username]' => $userComplete->username)));
} else {
cbRedirect($_CB_framework->backendViewUrl('showusers', false), CBTxt::T('SUCCESSFULLY_SAVED_USER_USERNAME', 'Successfully Saved User: [username]', array('[username]' => $userComplete->username)));
}
}
/**
* @param int[] $paging
* @param string $where
* @param UserTable $viewer
* @param UserTable $user
* @param PluginTable $plugin
* @return cbconsultationsconsultationTable[]
*/
static public function getconsultations( $paging, $where, $viewer, $user, /** @noinspection PhpUnusedParameterInspection */ $plugin )
{
global $_CB_database;
$query = 'SELECT a.*'
. "\n FROM " . $_CB_database->NameQuote( '#__comprofiler_plugin_consultations' ) . " AS a"
. "\n LEFT JOIN " . $_CB_database->NameQuote( '#__users' ) . " AS c"
. ' ON c.' . $_CB_database->NameQuote( 'id' ) . ' = a.' . $_CB_database->NameQuote( 'user' )
. "\n WHERE a." . $_CB_database->NameQuote( 'user' ) . " = " . (int) $user->get( 'id' )
. ( ( $viewer->get( 'id' ) != $user->get( 'id' ) ) && ( ! Application::User( (int) $viewer->get( 'id' ) )->isGlobalModerator() ) ? "\n AND a." . $_CB_database->NameQuote( 'published' ) . " = 1" : null )
. "\n AND a." . $_CB_database->NameQuote( 'access' ) . " IN " . $_CB_database->safeArrayOfIntegers( Application::MyUser()->getAuthorisedViewLevels() )
. $where
. "\n ORDER BY a." . $_CB_database->NameQuote( 'created' ) . " DESC";
if ( $paging ) {
$_CB_database->setQuery( $query, $paging[0], $paging[1] );
} else {
$_CB_database->setQuery( $query );
}
$consultations = $_CB_database->loadObjectList( null, 'cbconsultationsconsultationTable', array( $_CB_database ) );
return $consultations;
}
