/**
* Up
**/
public function up()
{
if ($this->db->tableExists('#__support_tickets')) {
$this->db->setQuery("SELECT id, report FROM `#__support_tickets` WHERE `created` < '2013-01-01 00:00:00' AND `report` LIKE '%\\\\\\'%' AND `type`=0 AND `open`=1");
if ($records = $this->db->loadObjectList()) {
$path = PATH_CORE . DS . 'components' . DS . 'com_support' . DS . 'tables' . DS . 'ticket.php';
if (!file_exists($path)) {
$path = PATH_ROOT . DS . 'administrator' . DS . 'components' . DS . 'com_support' . DS . 'tables' . DS . 'ticket.php';
}
include_once $path;
// Update the query
foreach ($records as $record) {
if (class_exists('SupportTicket')) {
$row = new SupportTicket($this->db);
} else {
$row = new \Components\Support\Tables\Ticket($this->db);
}
$row->bind($record);
$row->report = str_replace('"', '"', $row->report);
$row->report = stripslashes($row->report);
$row->report = html_entity_decode($row->report);
$row->summary = substr($row->report, 0, 70);
if (strlen($row->summary) >= 70) {
$row->summary .= '...';
}
$row->store();
}
}
}
}
/**
* Suggest license
*
* @return string
*/
protected function _suggestLicense()
{
// Incoming
$pid = $this->_pid ? $this->_pid : Request::getInt('pid', 0);
$version = Request::getVar('version', 'default');
$ajax = Request::getInt('ajax', 0);
// Load publication
$pub = new \Components\Publications\Models\Publication($pid, $version);
if (!$pub->exists()) {
$this->setError(Lang::txt('PLG_PROJECTS_PUBLICATIONS_PUBLICATION_NOT_FOUND'));
$this->_task = '';
return $this->browse();
}
// File a support ticket
if ($this->_task == 'save_license') {
$l_title = htmlentities(Request::getVar('license_title', '', 'post'));
$l_url = htmlentities(Request::getVar('license_url', '', 'post'));
$l_text = htmlentities(Request::getVar('details', '', 'post'));
if (!$l_title && !$l_url && !$l_text) {
$this->setError(Lang::txt('PLG_PROJECTS_PUBLICATIONS_LICENSE_SUGGESTION_ERROR'));
} else {
// Include support scripts
include_once PATH_CORE . DS . 'components' . DS . 'com_support' . DS . 'tables' . DS . 'ticket.php';
include_once PATH_CORE . DS . 'components' . DS . 'com_support' . DS . 'tables' . DS . 'comment.php';
// Load the support config
$sparams = Component::params('com_support');
$row = new \Components\Support\Tables\Ticket($this->_database);
$row->created = Date::toSql();
$row->login = User::get('username');
$row->email = User::get('email');
$row->name = User::get('name');
$row->summary = Lang::txt('PLG_PROJECTS_PUBLICATIONS_LICENSE_SUGGESTION_NEW');
$report = Lang::txt('PLG_PROJECTS_PUBLICATIONS_LICENSE_TITLE') . ': ' . $l_title . "\r\n";
$report .= Lang::txt('PLG_PROJECTS_PUBLICATIONS_LICENSE_URL') . ': ' . $l_url . "\r\n";
$report .= Lang::txt('PLG_PROJECTS_PUBLICATIONS_LICENSE_COMMENTS') . ': ' . $l_text . "\r\n";
$row->report = $report;
$row->referrer = Request::getVar('HTTP_REFERER', NULL, 'server');
$row->type = 0;
$row->severity = 'normal';
$admingroup = $this->model->config()->get('admingroup', '');
$group = \Hubzero\User\Group::getInstance($admingroup);
$row->group = $group ? $group->get('cn') : '';
if (!$row->store()) {
$this->setError($row->getError());
} else {
$ticketid = $row->id;
// Notify project admins
$message = $row->name . ' ' . Lang::txt('PLG_PROJECTS_PUBLICATIONS_LICENSE_SUGGESTED') . "\r\n";
$message .= '----------------------------' . "\r\n";
$message .= $report;
$message .= '----------------------------' . "\r\n";
if ($ticketid) {
$message .= Lang::txt('PLG_PROJECTS_PUBLICATIONS_LICENSE_TICKET_PATH') . "\n";
$message .= Request::base() . 'support/ticket/' . $ticketid . "\n\n";
}
if ($group) {
$members = $group->get('members');
$managers = $group->get('managers');
$admins = array_merge($members, $managers);
$admins = array_unique($admins);
// Send out email to admins
if (!empty($admins)) {
\Components\Projects\Helpers\Html::sendHUBMessage($this->_option, $this->model, $admins, Lang::txt('PLG_PROJECTS_PUBLICATIONS_LICENSE_SUGGESTION_NEW'), 'projects_new_project_admin', 'admin', $message);
}
}
$this->_msg = Lang::txt('PLG_PROJECTS_PUBLICATIONS_LICENSE_SUGGESTION_SENT');
}
}
} else {
$view = new \Hubzero\Plugin\View(array('folder' => 'projects', 'element' => 'publications', 'name' => 'suggestlicense'));
// Output HTML
$view->option = $this->_option;
$view->database = $this->_database;
$view->project = $this->model;
$view->uid = $this->_uid;
$view->pid = $pid;
$view->pub = $pub;
$view->task = $this->_task;
$view->config = $this->model->config();
$view->pubconfig = $this->_pubconfig;
$view->ajax = $ajax;
$view->version = $version;
$view->title = $this->_area['title'];
// Get messages and errors
$view->msg = $this->_msg;
if ($this->getError()) {
$view->setError($this->getError());
}
return $view->loadTemplate();
}
// Pass error or success message
if ($this->getError()) {
\Notify::message($this->getError(), 'error', 'projects');
} elseif (!empty($this->_msg)) {
\Notify::message($this->_msg, 'success', 'projects');
}
// Redirect
App::redirect(Route::url($pub->link('editversion') . '§ion=license'));
return;
}
