예제 #1
0
 static function &getTicketCount()
 {
     FST_Ticket_Helper::getAdminPermissions();
     if (empty(FST_Ticket_Helper::$counts)) {
         $db = JFactory::getDBO();
         $query = "SELECT count( * ) AS count, ticket_status_id FROM #__fst_ticket_ticket WHERE 1 ";
         $query .= FST_Ticket_Helper::$_perm_where;
         $query .= " GROUP BY ticket_status_id";
         $db->setQuery($query);
         $rows = $db->loadAssocList();
         $out = array();
         FST_Ticket_Helper::GetStatusList();
         foreach (FST_Ticket_Helper::$status_list as $status) {
             $out[$status->id] = 0;
         }
         if (count($rows) > 0) {
             foreach ($rows as $row) {
                 $out[$row['ticket_status_id']] = $row['count'];
             }
         }
         // work out counts for allopen, closed, all, archived
         $archived = FST_Ticket_Helper::GetStatusID("def_archive");
         $out['archived'] = 0;
         if (array_key_exists($archived, $out)) {
             $out['archived'] = $out[$archived];
         }
         $allopen = FST_Ticket_Helper::GetStatusIDs("is_closed", true);
         $out['allopen'] = 0;
         foreach ($allopen as $id) {
             if (array_key_exists($id, $out)) {
                 $out['allopen'] += $out[$id];
             }
         }
         $allclosed = FST_Ticket_Helper::GetClosedStatus();
         $out['allclosed'] = 0;
         foreach ($allclosed as $id) {
             if (array_key_exists($id, $out)) {
                 $out['allclosed'] += $out[$id];
             }
         }
         $all = FST_Ticket_Helper::GetStatusIDs("def_archive", true);
         $out['all'] = 0;
         foreach ($all as $id) {
             if (array_key_exists($id, $out)) {
                 $out['all'] += $out[$id];
             }
         }
         FST_Ticket_Helper::$counts = $out;
     }
     return FST_Ticket_Helper::$counts;
 }
예제 #2
0
 function display($tpl = null)
 {
     JHTML::_('behavior.modal', 'a.fst_modal');
     $user = JFactory::getUser();
     $this->userid = $user->get('id');
     // remove any admin open stuff
     $_SESSION['admin_create'] = 0;
     $_SESSION['admin_create_user_id'] = 0;
     $_SESSION['ticket_email'] = "";
     $_SESSION['ticket_name'] = "";
     // set up permissions
     $mainframe = JFactory::getApplication();
     $aparams = $mainframe->getPageParameters('com_fst');
     $this->permission = FST_Ticket_Helper::getAdminPermissions();
     $model = $this->getModel();
     $model->_perm_where = FST_Ticket_Helper::$_perm_where;
     // sort layout
     $layout = JRequest::getVar('layout', JRequest::getVar('_layout', ''));
     $this->assignRef('layout', $layout);
     //
     return $this->displayModerate();
     //
 }
예제 #3
0
 static function getUserSetting($setting)
 {
     if (empty(FST_Helper::$_permissions)) {
         FST_Ticket_Helper::getAdminPermissions();
     }
     if (empty(FST_Helper::$user_defaults)) {
         FST_Helper::getUserDefaults();
     }
     if (array_key_exists('settings', FST_Ticket_Helper::$_permissions) && is_array(FST_Ticket_Helper::$_permissions['settings']) && array_key_exists($setting, FST_Ticket_Helper::$_permissions['settings'])) {
         return FST_Ticket_Helper::$_permissions['settings'][$setting];
     }
     if (array_key_exists($setting, FST_Helper::$user_defaults)) {
         return FST_Helper::$user_defaults[$setting];
     }
     return 0;
 }
예제 #4
0
 function ParserPopulateTicket(&$parser, $row)
 {
     $parser->Clear();
     if ($row) {
         $parser->SetVar('ref', $row['reference']);
         $parser->SetVar('subject', "<a href='" . FSTRoute::_('index.php?option=com_fst&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", FST_Helper::Date($row['lastupdate'], FST_DATETIME_SHORT));
         $parser->SetVar("opened", FST_Helper::Date($row['opened'], FST_DATETIME_SHORT));
         $parser->SetVar("closed", FST_Helper::Date($row['closed'], FST_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 = FSTCF::GetValues($field);
                             if (array_key_exists("plugin", $aparams) && array_key_exists("plugindata", $aparams)) {
                                 $plugin = FSTCF::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='fst_support_fieldname'>" . $this->customfields[$id]['description'] . "</span>";
                         if ($this->customfields[$id]['type'] == "checkbox") {
                             if ($value == "on") {
                                 $text .= ": " . JText::_("Yes");
                             } else {
                                 $text .= ": " . JText::_("No");
                             }
                         } else {
                             $text .= ": " . $value;
                         }
                         $parser->SetVar("custom" . $id, $text);
                         $allcustom[] = $text;
                     }
                 }
             }
             //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 (FST_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_fst/assets/images/messages.png'>";
             $icons .= "</span>";
         }
         $cotime = $this->db_time - strtotime($row['checked_out_time']);
         if ($cotime < FST_Settings::get('support_lock_time') && $row['checked_out'] != $this->userid && $row['checked_out'] > 0) {
             $html = "<div class='fst_user_tt'>" . $row['co_user']->name . " (" . $row['co_user']->email . ")</div>";
             $icons .= "<img class='fsj_tip' src='" . JURI::root(true) . "/components/com_fst/assets/images/lock.png' title=\"" . JText::_('TICKET_LOCKED') . "::" . $html . "\">";
         } else {
             $icons .= "<img src='" . JURI::root(true) . "/components/com_fst/assets/images/blank_16.png'>";
         }
         if (!FST_Settings::get('support_hide_tags')) {
             if (isset($row['tags'])) {
                 $html = "";
                 foreach ($row['tags'] as $tag) {
                     $html .= "<div class='fst_tag_tt'>" . $tag['tag'] . "</div>";
                 }
                 $icons .= "<img class='fsj_tip' src='" . JURI::root(true) . "/components/com_fst/assets/images/tag.png' title=\"" . JText::_('TICKET_TAGS') . "::" . $html . "\">";
             } else {
                 $icons .= "<img src='" . JURI::root(true) . "/components/com_fst/assets/images/blank_16.png'>";
             }
         }
         if (isset($row['attach'])) {
             $html = "<table class='fst_attach_tt'>";
             foreach ($row['attach'] as $attach) {
                 $html .= "<tr style='border:0px;'><td nowrap style='border:0px;'>" . $attach['filename'] . "&nbsp;</td><td nowrap style='border:0px;'>&nbsp;" . FST_Helper::display_filesize($attach['size']) . "</td></tr>";
             }
             $html .= "<table>";
             $icons .= "<img class='fsj_tip' src='" . JURI::root(true) . "/components/com_fst/assets/images/attach.png' title=\"" . JText::_('TICKET_ATTACHMENTS') . "::" . $html . "\">";
         } else {
             $icons .= "<img src='" . JURI::root(true) . "/components/com_fst/assets/images/blank_16.png'>";
         }
         $parser->SetVar('icons', $icons);
         $delete = "<a href='" . FSTRoute::x('index.php?option=com_fst&view=admin&layout=support&tickets=' . JRequest::getVar('tickets') . '&delete=' . $row['id']) . "'>";
         $delete .= "<img src='" . JURI::root(true) . "/components/com_fst/assets/images/delete_ticket.png'>";
         $delete .= JText::_("DELETE") . "</a>";
         $archive = "<a href='" . FSTRoute::x('index.php?option=com_fst&view=admin&layout=support&tickets=' . JRequest::getVar('tickets') . '&archive=' . $row['id']) . "'>";
         $archive .= "<img src='" . JURI::root(true) . "/components/com_fst/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 FST_Settings::get('css_hl'); ?>';$('ticket_<?php echo $ticket['id'];?>_2').style.background = '<?php echo FST_Settings::get('css_hl'); ?>';"
         		onmouseout="$('ticket_<?php echo $ticket['id'];?>').style.background = '';$('ticket_<?php echo $ticket['id'];?>_2').style.background = '';"*/
         $this->_permissions = FST_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 (FST_Settings::get('support_entire_row')) {
             $style .= "cursor: pointer;";
             $trhl .= " onclick='window.location=\"" . FSTRoute::x('&limitstart=&ticketid=' . $row['id']) . "\"' ";
         }
         $trhl .= " style='{$style}' ";
         $parser->SetVar('trhl', $trhl);
     }
     $parser->SetVar("showassigned", $this->showassigned);
     $parser->SetVar("hidehandler", FST_Settings::get('support_hide_handler'));
     $parser->SetVar("candelete", FST_Settings::get('support_delete'));
     $parser->SetVar("view", $this->ticket_view);
 }
예제 #5
0
파일: admin.php 프로젝트: AxelFG/ckbran-inf
 function &getTicket($ticketid)
 {
     $db = JFactory::getDBO();
     $query = "SELECT t.*, u.name, u.username, p.title as product, d.title as dept, c.title as cat, s.title as status, ";
     $query .= "s.color as scolor, s.id as sid, pr.title as pri, pr.color as pcolor, pr.id as pid";
     $query .= " , pr.translation as ptl, d.translation as dtr, s.translation as str, c.translation as ctr, p.translation as prtr";
     $query .= " FROM #__fst_ticket_ticket as t ";
     $query .= " LEFT JOIN #__users as u ON t.user_id = u.id ";
     $query .= " LEFT JOIN #__fst_prod as p ON t.prod_id = p.id ";
     $query .= " LEFT JOIN #__fst_ticket_dept as d ON t.ticket_dept_id = d.id ";
     $query .= " LEFT JOIN #__fst_ticket_cat as c ON t.ticket_cat_id = c.id ";
     $query .= " LEFT JOIN #__fst_ticket_status as s ON t.ticket_status_id = s.id ";
     $query .= " LEFT JOIN #__fst_ticket_pri as pr ON t.ticket_pri_id = pr.id ";
     $query .= " WHERE t.id = '" . FSTJ3Helper::getEscaped($db, $ticketid) . "' ";
     FST_Ticket_Helper::getAdminPermissions();
     $query .= FST_Ticket_Helper::$_perm_where;
     //echo $query . "<br>";
     $db->setQuery($query);
     $rows = $db->loadAssoc();
     return $rows;
 }
예제 #6
0
 function __construct($identifier, $itemid = -1, &$itemlist = null)
 {
     $this->uid = mt_rand(1000, 9999);
     if (JRequest::getVar('uid') > 0) {
         $this->uid = JRequest::getVar('uid');
     }
     /*$this->use_comments = FST_Settings::get('announce_comments_allow');
     		if (!$this->use_comments)
     			return;*/
     $this->identifier = $identifier;
     $this->_permissions = FST_Ticket_Helper::getAdminPermissions();
     $this->use_email = FST_Settings::get('commnents_use_email');
     //FSJ_Settings::GetComponentSetting( fsj_get_com(), 'comments_email', 1 );
     $this->use_website = FST_Settings::get('commnents_use_website');
     //FSJ_Settings::GetComponentSetting( fsj_get_com(), 'comments_website', 1 );
     $this->tmplpath = JPATH_SITE . DS . 'components' . DS . 'com_fst' . DS . 'tmpl' . DS . 'comments';
     $this->dest_email = FST_Settings::get('email_on_comment');
     $this->itemid = $itemid;
     $this->itemlist = $itemlist;
     $this->post = array();
     $this->post['name'] = $this->GetName();
     $this->post['email'] = '';
     $this->post['website'] = '';
     $this->post['body'] = '';
     $this->post['created'] = 'now';
     $this->post['ident'] = $identifier;
     $this->post['itemid'] = $itemid;
     $this->errors = array();
     $this->errors['name'] = '';
     $this->errors['email'] = '';
     $this->errors['website'] = '';
     $this->errors['body'] = '';
     $this->errors['captcha'] = '';
     $this->errors['itemid'] = '';
     // text templates
     $this->add_a_comment = JText::_("ADD_A_COMMENT");
     $this->post_comment = JText::_("POST_COMMENT");
     $this->comments_hide_add = FST_Settings::get('comments_hide_add');
     if (FST_Settings::get('comments_who_can_add') == "registered") {
         if ($this->_permissions['userid'] == 0) {
             $this->can_add = 0;
         }
     }
     $captcha = new FST_Captcha();
     $this->captcha = $captcha->GetCaptcha();
     // set up moderation
     $commod = FST_Settings::get('comments_moderate');
     $this->moderate = 0;
     if ($commod == "all") {
         $this->moderate = 1;
     } elseif ($commod == "guests") {
         if ($this->_permissions['userid'] == 0) {
             $this->moderate = 1;
         }
     } elseif ($commod == "registered") {
         if ($this->_permissions['mod_kb'] == 0) {
             $this->moderate = 1;
         }
     }
     // determine template and if its custom or not
     $this->IncludeTemplates();
     $this->template = "comments_general";
     $this->template_type = 3;
     if (FST_Settings::get('comments_general_use_custom')) {
         $this->template_type = 2;
     }
     if ($this->handler) {
         $this->template = "comments_" . $this->handler->GetName();
         $this->template_type = 3;
         if (FST_Settings::get('comments_' . $this->handler->GetName() . '_use_custom')) {
             $this->template_type = 2;
         }
     }
     //print_p($this);
     //exit;
 }