function Init()
{
if (empty($this->permission)) {
$this->tmplpath = JPATH_SITE . DS . 'components' . DS . 'com_fsf' . DS . 'tmpl' . DS . 'content';
$this->permission = FSF_Ticket_Helper::getAdminPermissions();
$user = JFactory::getUser();
$userid = $user->get('id');
$this->userid = $userid;
$document = JFactory::getDocument();
$document->addStyleSheet(JURI::root() . 'components/com_fsf/assets/css/popup.css');
$document->addScript(JURI::base() . 'components/com_fsf/assets/js/popup.js');
}
}
function TestRef()
{
$format = JRequest::getVar('ref');
$ref = FSF_Ticket_Helper::createRef(1234, $format);
echo $ref;
exit;
}
static function getUserSetting($setting)
{
if (empty(FSF_Helper::$_permissions)) {
FSF_Ticket_Helper::getAdminPermissions();
}
if (empty(FSF_Helper::$user_defaults)) {
FSF_Helper::getUserDefaults();
}
if (array_key_exists('settings', FSF_Ticket_Helper::$_permissions) && is_array(FSF_Ticket_Helper::$_permissions['settings']) && array_key_exists($setting, FSF_Ticket_Helper::$_permissions['settings'])) {
return FSF_Ticket_Helper::$_permissions['settings'][$setting];
}
if (array_key_exists($setting, FSF_Helper::$user_defaults)) {
return FSF_Helper::$user_defaults[$setting];
}
return 0;
}
function ParserPopulateTicket(&$parser, $row)
{
$parser->Clear();
if ($row) {
$parser->SetVar('ref', $row['reference']);
$parser->SetVar('subject', "<a href='" . FSFRoute::_('index.php?option=com_fsf&view=admin&layout=support&ticketid=' . $row['id']) . "'>" . $row['title'] . "</a>");
$parser->SetVar("status", "<span style='color:" . $row['color'] . ";'>" . $row['status'] . "</span>");
if ($row['user_id'] == 0) {
$name = $row['unregname'] . " (" . JText::_("UNREG") . ")";
} else {
$name = $row['name'];
}
$parser->SetVar("name", $name);
$parser->SetVar("lastactivity", FSF_Helper::Date($row['lastupdate'], FSF_DATETIME_SHORT));
$parser->SetVar("opened", FSF_Helper::Date($row['opened'], FSF_DATETIME_SHORT));
$parser->SetVar("closed", FSF_Helper::Date($row['closed'], FSF_DATETIME_SHORT));
$parser->SetVar("department", $row['department']);
$parser->SetVar("category", $row['category']);
$parser->SetVar("product", $row['product']);
$parser->SetVar("priority", "<span style='color:" . $row['pricolor'] . ";'>" . $row['priority'] . "</span>");
$groups = implode(", ", $row['groups']);
$parser->SetVar('groups', $groups);
$parser->SetVar('deletebutton', 'deletebutton');
$parser->SetVar('archivebutton', 'archivebutton');
if (array_key_exists("custom", $row)) {
$allcustom = array();
if (count($row['custom']) > 0) {
foreach ($row['custom'] as $id => $value) {
if (array_key_exists($id, $this->customfields)) {
$field = $this->customfields[$id];
if ($field['type'] == "plugin") {
$aparams = FSFCF::GetValues($field);
if (array_key_exists("plugin", $aparams) && array_key_exists("plugindata", $aparams)) {
$plugin = FSFCF::get_plugin($aparams['plugin']);
$value = $plugin->Display($value, $aparams['plugindata'], array('ticketid' => $row['id'], 'userid' => $row['user_id'], 'ticket' => $row), $field['id']);
}
}
$text = "<span class='fsf_support_fieldname'>" . $this->customfields[$id]['description'] . "</span>";
if ($this->customfields[$id]['type'] == "checkbox") {
if ($value == "on") {
$value = JText::_("Yes");
} else {
$value = JText::_("No");
}
}
$parser->SetVar("custom" . $id, $value);
$parser->SetVar("custom_" . $id, $value);
$allcustom[] = $text . ": " . $value;
}
}
}
//echo "All custom : " . implode(", ",$allcustom) . "<br>";
$parser->SetVar("custom", implode(", ", $allcustom));
}
if ($row['assigned'] == '') {
$parser->SetVar('handlername', JText::_("UNASSIGNED"));
} else {
$parser->SetVar('handlername', $row['assigned']);
}
$parser->SetVar('username', $row['username']);
$parser->SetVar('email', $row['useremail']);
$parser->SetVar('handlerusername', $row['handlerusername']);
$parser->SetVar('handleremail', $row['handleremail']);
$icons = "";
if (FSF_Settings::get('support_show_msg_counts')) {
$icons .= "<span>";
$icons .= "<span style='font-weight:normal;top:-2px;position:relative;padding-right:2px;'>" . $row['msgcount']['total'] . "</span><span style='font-weight:normal;top:-2px;position:relative;padding-right:2px;'>x</span><img src='" . JURI::root(true) . "/components/com_fsf/assets/images/messages.png'>";
$icons .= "</span>";
}
$cotime = $this->db_time - strtotime($row['checked_out_time']);
if ($cotime < FSF_Settings::get('support_lock_time') && $row['checked_out'] != $this->userid && $row['checked_out'] > 0) {
$html = "<div class='fsf_user_tt'>" . $row['co_user']->name . " (" . $row['co_user']->email . ")</div>";
$icons .= "<img class='fsj_tip' src='" . JURI::root(true) . "/components/com_fsf/assets/images/lock.png' title=\"" . JText::_('TICKET_LOCKED') . "::" . $html . "\">";
} else {
$icons .= "<img src='" . JURI::root(true) . "/components/com_fsf/assets/images/blank_16.png'>";
}
if (!FSF_Settings::get('support_hide_tags')) {
if (isset($row['tags'])) {
$html = "";
foreach ($row['tags'] as $tag) {
$html .= "<div class='fsf_tag_tt'>" . $tag['tag'] . "</div>";
}
$icons .= "<img class='fsj_tip' src='" . JURI::root(true) . "/components/com_fsf/assets/images/tag.png' title=\"" . JText::_('TICKET_TAGS') . "::" . $html . "\">";
} else {
$icons .= "<img src='" . JURI::root(true) . "/components/com_fsf/assets/images/blank_16.png'>";
}
}
if (isset($row['attach'])) {
$html = "<table class='fsf_attach_tt'>";
foreach ($row['attach'] as $attach) {
$html .= "<tr style='border:0px;'><td nowrap style='border:0px;'>" . $attach['filename'] . " </td><td nowrap style='border:0px;'> " . FSF_Helper::display_filesize($attach['size']) . "</td></tr>";
}
$html .= "<table>";
$icons .= "<img class='fsj_tip' src='" . JURI::root(true) . "/components/com_fsf/assets/images/attach.png' title=\"" . JText::_('TICKET_ATTACHMENTS') . "::" . $html . "\">";
} else {
$icons .= "<img src='" . JURI::root(true) . "/components/com_fsf/assets/images/blank_16.png'>";
}
$parser->SetVar('icons', $icons);
$delete = "<a href='" . FSFRoute::x('index.php?option=com_fsf&view=admin&layout=support&tickets=' . JRequest::getVar('tickets') . '&delete=' . $row['id']) . "'>";
$delete .= "<img src='" . JURI::root(true) . "/components/com_fsf/assets/images/delete_ticket.png'>";
$delete .= JText::_("DELETE") . "</a>";
$archive = "<a href='" . FSFRoute::x('index.php?option=com_fsf&view=admin&layout=support&tickets=' . JRequest::getVar('tickets') . '&archive=' . $row['id']) . "'>";
$archive .= "<img src='" . JURI::root(true) . "/components/com_fsf/assets/images/archive_ticket.png'>";
$archive .= JText::_("ARCHIVE") . "</a>";
$parser->SetVar('archivebutton', $archive);
$parser->SetVar('deletebutton', $delete);
// TODO: trhl
/*id='ticket_<?php echo $ticket['id'];?>'
onmouseover="$('ticket_<?php echo $ticket['id'];?>').style.background = '<?php echo FSF_Settings::get('css_hl'); ?>';$('ticket_<?php echo $ticket['id'];?>_2').style.background = '<?php echo FSF_Settings::get('css_hl'); ?>';"
onmouseout="$('ticket_<?php echo $ticket['id'];?>').style.background = '';$('ticket_<?php echo $ticket['id'];?>_2').style.background = '';"*/
$this->_permissions = FSF_Ticket_Helper::getAdminPermissions();
$type = "unassigned";
if ($row['admin_id'] == $this->_permissions['id']) {
$type = "mine";
} else {
if ($row['admin_id'] > 0) {
$type = "other";
}
}
$style = "";
if (array_key_exists($row['ticket_pri_id'], $this->priorities)) {
$pri = $this->priorities[$row['ticket_pri_id']];
if ($pri['backcolor']) {
$style .= "background-color: {$pri['backcolor']};";
}
}
$handler_highlight = "ticket_type_{$type}";
$parser->SetVar('handler_highlight', $handler_highlight);
$trhl = " class='ticket_{$row['id']} ' onmouseover='highlightticket({$row['id']})' onmouseout='unhighlightticket({$row['id']})' ";
if (FSF_Settings::get('support_entire_row')) {
$style .= "cursor: pointer;";
$trhl .= " onclick='window.location=\"" . FSFRoute::x('&limitstart=&ticketid=' . $row['id']) . "\"' ";
}
$trhl .= " style='{$style}' ";
$parser->SetVar('trhl', $trhl);
}
$parser->SetVar("showassigned", $this->showassigned);
$parser->SetVar("hidehandler", FSF_Settings::get('support_hide_handler'));
$parser->SetVar("candelete", FSF_Settings::get('support_delete'));
$parser->SetVar("view", $this->ticket_view);
}
static function getAdminPermissions()
{
if (empty(FSF_Ticket_Helper::$_permissions)) {
$mainframe = JFactory::getApplication();
global $option;
$user = JFactory::getUser();
$userid = $user->id;
$db = JFactory::getDBO();
$query = "SELECT * FROM #__fsf_user WHERE user_id = '" . FSFJ3Helper::getEscaped($db, $userid) . "'";
$db->setQuery($query);
FSF_Ticket_Helper::$_permissions = $db->loadAssoc();
if (!FSF_Ticket_Helper::$_permissions) {
FSF_Ticket_Helper::$_permissions['mod_kb'] = 0;
FSF_Ticket_Helper::$_permissions['mod_test'] = 0;
FSF_Ticket_Helper::$_permissions['support'] = 0;
FSF_Ticket_Helper::$_permissions['seeownonly'] = 1;
FSF_Ticket_Helper::$_permissions['autoassignexc'] = 1;
FSF_Ticket_Helper::$_permissions['allprods'] = 1;
FSF_Ticket_Helper::$_permissions['allcats'] = 1;
FSF_Ticket_Helper::$_permissions['alldepts'] = 1;
FSF_Ticket_Helper::$_permissions['artperm'] = 0;
FSF_Ticket_Helper::$_permissions['id'] = 0;
FSF_Ticket_Helper::$_permissions['groups'] = 0;
FSF_Ticket_Helper::$_permissions['reports'] = 0;
FSF_Ticket_Helper::$_permissions['settings'] = '';
}
FSF_Ticket_Helper::$_permissions['userid'] = $userid;
FSF_Ticket_Helper::$_perm_only = '';
FSF_Ticket_Helper::$_perm_prods = '';
FSF_Ticket_Helper::$_perm_depts = '';
FSF_Ticket_Helper::$_perm_cats = '';
FSF_Ticket_Helper::$_permissions['perm_where'] = '';
//
// check for permission overrides for Joomla 1.6
if (FSF_Settings::get('perm_article_joomla') || FSF_Settings::get('perm_mod_joomla')) {
if (FSF_Helper::Is16()) {
$newart = 0;
$newmod = 0;
$user = JFactory::getUser();
if ($user->authorise('core.edit.own', 'com_fsf')) {
$newart = 1;
}
if ($user->authorise('core.edit', 'com_fsf')) {
$newart = 2;
$newmod = 1;
}
if ($user->authorise('core.edit.state', 'com_fsf')) {
$newart = 3;
$newmod = 1;
}
if (FSF_Settings::get('perm_article_joomla') && $newart > FSF_Ticket_Helper::$_permissions['artperm']) {
FSF_Ticket_Helper::$_permissions['artperm'] = $newart;
}
if (FSF_Settings::get('perm_mod_joomla') && $newmod > FSF_Ticket_Helper::$_permissions['mod_kb']) {
FSF_Ticket_Helper::$_permissions['mod_kb'] = $newmod;
}
//
} else {
$newart = 0;
$newmod = 0;
$user = JFactory::getUser();
if ($user->authorize('com_fsf', 'create', 'content', 'own')) {
$newart = 1;
}
if ($user->authorize('com_fsf', 'edit', 'content', 'own')) {
$newart = 2;
$newmod = 1;
}
if ($user->authorize('com_fsf', 'publish', 'content', 'all')) {
$newart = 3;
$newmod = 1;
}
if (FSF_Settings::get('perm_article_joomla') && $newart > FSF_Ticket_Helper::$_permissions['artperm']) {
FSF_Ticket_Helper::$_permissions['artperm'] = $newart;
}
if (FSF_Settings::get('perm_mod_joomla') && $newmod > FSF_Ticket_Helper::$_permissions['mod_kb']) {
FSF_Ticket_Helper::$_permissions['mod_kb'] = $newmod;
}
}
}
}
return FSF_Ticket_Helper::$_permissions;
}
