/**
* @param null|int $id
* @param UserTable $user
* @param stdClass $model
* @param PluginTable $plugin
*/
private function saveconsultationEdit( $id, $user, $model, $plugin )
{
global $_CB_framework, $_PLUGINS;
$consultationLimit = (int) $plugin->params->get( 'consultation_limit', null );
$cbModerator = Application::User( (int) $user->get( 'id' ) )->isGlobalModerator();
$row = new cbconsultationsconsultationTable();
$canAccess = false;
if ( $row->load( (int) $id ) ) {
if ( ! $row->get( 'id' ) ) {
if ( $cbModerator ) {
$canAccess = true;
} elseif ( $user->get( 'id' ) && Application::MyUser()->canViewAccessLevel( $plugin->params->get( 'consultation_create_access', 2 ) ) ) {
if ( ( ! $consultationLimit ) || ( $consultationLimit && ( cbconsultationsModel::getconsultationsTotal( null, $user, $user, $plugin ) < $consultationLimit ) ) ) {
$canAccess = true;
}
}
} elseif ( $cbModerator || ( $row->get( 'user' ) == $user->get( 'id' ) ) ) {
$canAccess = true;
}
}
$profileUrl = $_CB_framework->userProfileUrl( $row->get( 'user', $user->get( 'id' ) ), false, 'cbconsultationsTab' );
if ( $canAccess ) {
if ( $plugin->params->get( 'consultation_captcha', 0 ) && ( ! $row->get( 'id' ) ) && ( ! $cbModerator ) ) {
$_PLUGINS->loadPluginGroup( 'user' );
$_PLUGINS->trigger( 'onCheckCaptchaHtmlElements', array() );
if ( $_PLUGINS->is_errors() ) {
$row->setError( CBTxt::T( $_PLUGINS->getErrorMSG() ) );
}
}
$new = ( $row->get( 'id' ) ? false : true );
if ( ! $row->bind( $_POST ) ) {
$this->showconsultationEdit( $id, $user, $model, $plugin, CBTxt::T( 'consultation_FAILED_TO_BIND_ERROR_ERROR', 'consultation failed to bind! Error: [error]', array( '[error]' => $row->getError() ) ) ); return;
}
if ( ! $row->check() ) {
$this->showconsultationEdit( $id, $user, $model, $plugin, CBTxt::T( 'consultation_FAILED_TO_VALIDATE_ERROR_ERROR', 'consultation failed to validate! Error: [error]', array( '[error]' => $row->getError() ) ) ); return;
}
if ( $row->getError() || ( ! $row->store() ) ) {
$this->showconsultationEdit( $id, $user, $model, $plugin, CBTxt::T( 'consultation_FAILED_TO_SAVE_ERROR_ERROR', 'consultation failed to save! Error: [error]', array( '[error]' => $row->getError() ) ) ); return;
}
//Creating the Auction
$saveAuctionResult = $this->saveAuction($row->get('id'),
$row->get('user'),
$new,
$row->get('title'),
$this->input( 'datetime', null, GetterInterface::STRING ),
$row->get('published'));
if ( $saveAuctionResult!=null ) {
$this->showconsultationEdit( $id, $user, $model, $plugin, CBTxt::T( 'consultation_FAILED_TO_SAVE_ERROR_ERROR', 'consultation failed to save! Error: [error]', array( '[error]' => $saveAuctionResult ) ) ); return;
}
if ( $new && ( ! $row->get( 'published' ) ) && $plugin->params->get( 'approval_notify', 1 ) && ( ! $cbModerator ) ) {
$cbUser = CBuser::getInstance( (int) $row->get( 'user' ), false );
$extraStrings = array( 'site_name' => $_CB_framework->getCfg( 'sitename' ),
'site' => '<a href="' . $_CB_framework->getCfg( 'live_site' ) . '">' . $_CB_framework->getCfg( 'sitename' ) . '</a>',
'consultation_id' => (int) $row->get( 'id' ),
'consultation_title' => $row->get( 'title' ),
'consultation_intro' => $row->get( 'consultation_intro' ),
'consultation_full' => $row->get( 'consultation_full' ),
'consultation_created' => $row->get( 'consultation_created' ),
'consultation_user' => (int) $row->get( 'user' ),
'consultation_url' => cbconsultationsModel::getUrl( $row ),
'consultation_tab_url' => $_CB_framework->viewUrl( 'userprofile', false, array( 'user' => (int) $row->get( 'user_id' ), 'tab' => 'cbconsultationsTab' ) ),
'user_name' => $cbUser->getField( 'formatname', null, 'html', 'none', 'profile' ),
'user' => '<a href="' . $_CB_framework->viewUrl( 'userprofile', true, array( 'user' => (int) $row->get( 'user_id' ) ) ) . '">' . $cbUser->getField( 'formatname', null, 'html', 'none', 'profile' ) . '</a>'
);
$subject = $cbUser->replaceUserVars( CBTxt::T( 'consultations - New consultation Created!' ), false, true, $extraStrings, false );
$message = $cbUser->replaceUserVars( CBTxt::T( '[user] created [consultation_title] and requires <a href="[consultation_tab_url]">approval</a>!' ), false, true, $extraStrings, false );
$notifications = new cbNotification();
$notifications->sendToModerators( $subject, $message, false, 1 );
}
cbRedirect( $profileUrl, CBTxt::T( 'consultation saved successfully!' ) );
} else {
cbRedirect( $profileUrl, CBTxt::T( 'Not authorized.' ), 'error' );
}
}
/**
* Generates the HTML to display the user profile tab
*
* @param \CB\Database\Table\TabTable $tab the tab database entry
* @param \CB\Database\Table\UserTable $user the user being displayed
* @param int $ui 1 for front-end, 2 for back-end
* @return string|boolean Either string HTML for tab content, or false if ErrorMSG generated
*/
public function getDisplayTab( $tab, $user, $ui )
{
global $_CB_framework, $_CB_database;
outputCbJs( 1 );
outputCbTemplate( 1 );
cbimport( 'cb.pagination' );
$plugin = cbconsultationsClass::getPlugin();
$model = cbconsultationsClass::getModel();
$viewer = CBuser::getMyUserDataInstance();
cbconsultationsClass::getTemplate( 'tab' );
$limit = (int) $this->params->get( 'tab_limit', 15 );
$limitstart = $_CB_framework->getUserStateFromRequest( 'tab_consultations_limitstart{com_comprofiler}', 'tab_consultations_limitstart' );
$filterSearch = $_CB_framework->getUserStateFromRequest( 'tab_consultations_search{com_comprofiler}', 'tab_consultations_search' );
$where = null;
if ( isset( $filterSearch ) && ( $filterSearch != '' ) ) {
if ( $model->type != 2 ) {
$where .= "\n AND ( a." . $_CB_database->NameQuote( 'title' ) . " LIKE " . $_CB_database->Quote( '%' . $_CB_database->getEscaped( $filterSearch, true ) . '%', false )
. " OR a." . $_CB_database->NameQuote( 'introtext' ) . " LIKE " . $_CB_database->Quote( '%' . $_CB_database->getEscaped( $filterSearch, true ) . '%', false )
. " OR a." . $_CB_database->NameQuote( 'fulltext' ) . " LIKE " . $_CB_database->Quote( '%' . $_CB_database->getEscaped( $filterSearch, true ) . '%', false ) . " )";
} else {
$where .= "\n AND ( a." . $_CB_database->NameQuote( 'title' ) . " LIKE " . $_CB_database->Quote( '%' . $_CB_database->getEscaped( $filterSearch, true ) . '%', false )
. " OR a." . $_CB_database->NameQuote( 'consultation_intro' ) . " LIKE " . $_CB_database->Quote( '%' . $_CB_database->getEscaped( $filterSearch, true ) . '%', false )
. " OR a." . $_CB_database->NameQuote( 'consultation_full' ) . " LIKE " . $_CB_database->Quote( '%' . $_CB_database->getEscaped( $filterSearch, true ) . '%', false ) . " )";
}
}
$searching = ( $where ? true : false );
$total = cbconsultationsModel::getconsultationsTotal( $where, $viewer, $user, $plugin );
if ( $total <= $limitstart ) {
$limitstart = 0;
}
$pageNav = new cbPageNav( $total, $limitstart, $limit );
$pageNav->setInputNamePrefix( 'tab_consultations_' );
$rows = cbconsultationsModel::getconsultations( ( $this->params->get( 'tab_paging', 1 ) ? array( $pageNav->limitstart, $pageNav->limit ) : null ), $where, $viewer, $user, $plugin );
$input = array();
$input['search'] = '<input type="text" name="tab_consultations_search" value="' . htmlspecialchars( $filterSearch ) . '" onchange="document.consultationForm.submit();" placeholder="' . htmlspecialchars( CBTxt::T( 'Search consultations...' ) ) . '" class="form-control" />';
$tab->params = $this->params;
$class = $plugin->params->get( 'general_class', null );
$return = '<div id="cbconsultations" class="cbconsultations' . ( $class ? ' ' . htmlspecialchars( $class ) : null ) . '">'
. '<div id="cbconsultationsInner" class="cbconsultationsInner">'
. HTML_cbconsultationsTab::showconsultationTab( $rows, $pageNav, $searching, $input, $viewer, $user, $model, $tab, $plugin )
. '</div>'
. '</div>';
return $return;
}
