function display_edit() { $editid = FSS_Input::getInt('sigid'); if ($editid > 0) { $db = JFactory::getDBO(); $qry = "SELECT * FROM #__fss_ticket_fragments WHERE id = " . FSSJ3Helper::getEscaped($db, $editid); $db->setQuery($qry); $this->sig_item = $db->loadObject(); $this->sig_item->params = json_decode($this->sig_item->params, true); if (is_string($this->sig_item->params)) { $this->sig_item->params = array(); } $this->sig_item->personal = 0; $userid = JFactory::getUser()->id; if (isset($this->sig_item->params['userid'])) { if ($this->sig_item->params['userid'] > 0 && $userid != $this->sig_item->params['userid']) { $mainframe = JFactory::getApplication(); $link = JRoute::_('index.php?option=com_fss&view=admin_support&layout=signature&tmpl=component'); $mainframe->redirect($link); } $this->sig_item->personal = 1; } } else { $this->sig_item = new stdClass(); $this->sig_item->id = 0; $this->sig_item->description = ""; $this->sig_item->content = ""; $this->sig_item->personal = 1; } return $this->_display("edit"); }
function &getAnnounce() { $db = JFactory::getDBO(); $announceid = FSS_Input::getInt('announceid', 0); $query = "SELECT * FROM #__fss_announce"; $where = array(); $where[] = "id = '" . FSSJ3Helper::getEscaped($db, $announceid) . "'"; if (FSS_Permission::auth("core.edit", "com_fss.announce")) { } else { if (FSS_Permission::auth("core.edit.own", "com_fss.announce")) { $where[] = " ( published = 1 OR author = {$this->content->userid} ) "; } else { $where[] = "published = 1"; } } $db = JFactory::getDBO(); $where[] = 'language in (' . $db->Quote(JFactory::getLanguage()->getTag()) . ',' . $db->Quote('*') . ')'; $user = JFactory::getUser(); $where[] = 'access IN (' . implode(',', $user->getAuthorisedViewLevels()) . ')'; if (count($where) > 0) { $query .= " WHERE " . implode(" AND ", $where); } $db->setQuery($query); $rows = $db->loadAssoc(); return $rows; }
function display($tpl = null) { $db = JFactory::getDBO(); $test = FSS_Input::getInt('test'); if ($test > 0) { error_reporting(E_ALL); ini_set('display_errors', 1); $qry = "SELECT * FROM #__fss_cron WHERE id = " . FSSJ3Helper::getEscaped($db, $test); } else { $qry = "SELECT * FROM #__fss_cron WHERE published = 1 AND ((UNIX_TIMESTAMP() - lastrun) - (`interval` * 60)) > 0"; } $db->setQuery($qry); $rows = $db->loadObjectList(); if (!$rows) { exit; } foreach ($rows as $row) { $db->setQuery("UPDATE #__fss_cron SET lastrun=UNIX_TIMESTAMP() WHERE id='{$row->id}' LIMIT 1"); $db->query(); $class = "FSSCron" . $row->class; $file = strtolower($row->class) . ".php"; $path = JPATH_SITE . DS . 'components' . DS . 'com_fss' . DS . 'cron' . DS; if (file_exists($path . $file)) { require_once $path . $file; $inst = new $class(); $inst->Execute($this->ParseParams($row->params)); if ($test > 0) { echo "<pre>" . $inst->_log . "</pre>"; } else { $inst->SaveLog(); } } } exit; }
function dolist() { $ticketid = FSS_Input::getInt('ticketid'); $ticket = new SupportTicket(); $ticket->load($ticketid); echo SupportCanned::CannedList($ticket); exit; }
function &getProduct() { $db = JFactory::getDBO(); $prodid = FSS_Input::getInt('prodid'); $query = "SELECT * FROM #__fss_prod WHERE id = '" . FSSJ3Helper::getEscaped($db, $prodid) . "'"; $db->setQuery($query); $rows = $db->loadAssoc(); return $rows; }
function parseRequest() { $this->prodid = FSS_Input::getInt('prodid'); $this->deptid = FSS_Input::getInt('deptid'); $this->catid = FSS_Input::getInt('catid'); $this->mode = FSS_Input::getInt('mode'); $def_open = FSS_Ticket_Helper::GetStatusID("def_open"); $this->status = FSS_Input::getCmd('status', $def_open); }
function getLimits() { $mainframe = JFactory::getApplication(); $limit = $mainframe->getUserStateFromRequest('global.list.limit_ticket', 'limit', SupportUsers::getSetting('per_page'), 'int'); $limitstart = FSS_Input::getInt('limitstart'); $limitstart = $limit != 0 ? floor($limitstart / $limit) * $limit : 0; $this->limit = $limit; $this->limitstart = $limitstart; }
function HandleRefresh() { $this->do_refresh = FSS_Settings::Get('support_admin_refresh'); if (FSS_Input::getInt("refresh") > 0) { $output = array(); $output['count'] = $this->count; header("Content-Type: application/json"); echo json_encode($output); exit; } }
function Save($id, $params) { $params = $this->parseParams($params); $value = FSS_Input::getInt("custom_{$id}"); if ($value < $params->min) { $value = $params->min; } if ($value > $params->max) { $value = $params->max; } return $value; }
function preview() { $this->ticketid = FSS_Input::getInt('ticketid'); $this->sigid = FSS_Input::getInt('sigid'); $ticket = new SupportTicket(); $ticket->load($this->ticketid); $ticket->loadAll(); $this->ticket = $ticket; $this->signature = SupportCanned::AppendSig($this->sigid, $this->ticket); include $this->view->snippet(JPATH_SITE . DS . 'components' . DS . 'com_fss' . DS . 'views' . DS . 'admin_support' . DS . 'snippet' . DS . '_signature_preview.php'); return true; }
function Save($id, $params) { $checked = array(); $posted = FSS_Input::getInt("custom_{$id}_count"); if ($posted) { for ($i = 1; $i <= $posted; $i++) { $val = FSS_Input::getString("custom_{$id}_{$i}"); if ($val) { $checked[] = $val; } } } return json_encode($checked); }
function process() { $posted = JRequest::get('post'); $ticket_ids = array(); foreach ($posted as $var => $value) { if (substr($var, 0, 7) == "ticket_") { $ticket_id = (int) substr($var, 7); if ($ticket_id > 0) { $ticket_ids[$ticket_id] = $ticket_id; } } } if (count($ticket_ids) == 0) { return; } $db = JFactory::getDBO(); $tickets = array(); foreach ($ticket_ids as $ticketid) { $ticket = new SupportTicket(); if ($ticket->Load($ticketid)) { $ticket->is_batch = true; $tickets[$ticketid] = $ticket; } else { unset($ticket_ids[$ticket_id]); } } $new_pri = FSS_Input::getInt('batch_priority'); if ($new_pri > 0) { foreach ($ticket_ids as $ticketid) { $tickets[$ticketid]->updatePriority($new_pri); } } $new_status = FSS_Input::getInt('batch_status'); if ($new_status > 0) { foreach ($ticket_ids as $ticketid) { $tickets[$ticketid]->updateStatus($new_status); } } if (FSS_Input::getString('batch_handler') != "") { foreach ($ticket_ids as $ticketid) { $tickets[$ticketid]->assignHandler(FSS_Input::getInt('batch_handler')); } } $should_delete = FSS_Input::getCmd('batch_status'); if ($should_delete == "delete") { foreach ($ticket_ids as $ticketid) { $tickets[$ticketid]->delete(); } } }
function in() { $current_user = JFactory::getUser()->id; $manager = FSS_Permission::auth("fss.ticket_admin.ooo", "com_fss.support_admin", JFactory::getUser()->id); $user_id = FSS_Input::getInt('user_id'); if (!$manager && $current_user != $user_id) { return $this->cancel(); } // update the current users setting $values = SupportUsers::getAllSettings($user_id); $values->out_of_office = 0; SupportUsers::updateUserSettings($values, $user_id); JFactory::getApplication()->redirect(FSSRoute::_("index.php?option=com_fss&view=admin_support&layout=listhandlers", false)); }
function delete() { if (!$this->view->can_EditTicket()) { return; } // load in tickets to do $ticketid = FSS_Input::getInt('ticketid'); $fileid = FSS_Input::getInt('fileid'); $ticket = new SupportTicket(); if ($ticket->load($ticketid)) { $ticket->deleteAttach($fileid); } JFactory::getApplication()->redirect(FSSRoute::_('index.php?option=com_fss&view=admin_support&layout=ticket&ticketid=' . $ticketid, false)); exit; }
function display($tpl = NULL) { $this->current_userid = JFactory::getUser()->id; $this->userid = FSS_Input::getInt('user_id', $this->current_userid); if (!FSS_Permission::auth("fss.ticket_admin.ooo", "com_fss.support_admin", JFactory::getUser()->id)) { $this->userid = $this->current_userid; } $this->user = JFactory::getUser($this->userid); $this->loadTicketList(); $values = SupportUsers::getAllSettings($this->userid); if ($values->out_of_office) { return $this->showUserOut(); } else { return $this->showUserIn(); } // }
function display($tpl = null) { FSS_Helper::StylesAndJS(array('accordion')); $mainframe = JFactory::getApplication(); $user = JFactory::getUser(); $userid = $user->id; $db = JFactory::getDBO(); $this->params = FSS_Settings::GetViewSettingsObj('test'); $this->test_show_prod_mode = $this->params->get('test_show_prod_mode', 'accordian'); $this->test_always_prod_select = $this->params->get('test_always_prod_select', '0'); $layout = FSS_Input::getCmd('layout'); $this->prodid = FSS_Input::getInt('prodid'); if ($this->prodid == "") { $this->prodid = -1; } $this->products = $this->get('Products'); //print_p($this->products); if (count($this->products) == 0) { $this->prodid = 0; } $this->comments = new FSS_Comments("test", $this->prodid); if ($this->prodid == -1) { $this->comments->opt_show_posted_message_only = 1; } $onlyprodid = FSS_Input::getCmd('onlyprodid', 'x'); if ($onlyprodid != 'x' && $onlyprodid != -1) { $this->comments->itemid = (int) $onlyprodid; $this->comments->show_item_select = false; } if ($this->params->get('hide_add', 0)) { $this->comments->can_add = 0; } if ($layout == "create") { $this->setupCommentsCreate(); } if ($this->comments->Process()) { return; } if ($layout == "create") { return $this->displayCreate(); } if ($this->prodid != -1) { return $this->displaySingleProduct(); } return $this->displayAllProducts(); }
function display($tpl = null) { $fileid = FSS_Input::getInt('fileid'); $key = FSS_Input::getCmd('key'); $decoded = FSS_Helper::decrypt(FSS_Helper::base64url_decode($key), FSS_Helper::getEncKey("file")); if ($fileid != $decoded) { exit; } $db = JFactory::getDBO(); $sql = "SELECT * FROM #__fss_ticket_attach WHERE id = " . $fileid; $db->setQuery($sql); $attach = $db->loadObject(); $image = in_array(strtolower(pathinfo($attach->filename, PATHINFO_EXTENSION)), array('jpg', 'jpeg', 'png', 'gif')); $image_file = JPATH_SITE . DS . FSS_Settings::get('attach_location') . DS . "support" . DS . $attach->diskfile; require_once JPATH_SITE . DS . 'components' . DS . 'com_fss' . DS . 'helper' . DS . 'files.php'; FSS_File_Helper::OutputImage($image_file, pathinfo($attach->filename, PATHINFO_EXTENSION)); }
static function NoPerm() { if (array_key_exists('REQUEST_URI', $_SERVER)) { $url = $_SERVER['REQUEST_URI']; //JURI::current() . "?" . $_SERVER['QUERY_STRING']; } else { $option = FSS_Input::getCmd('option', ''); $view = FSS_Input::getCmd('view', ''); $layout = FSS_Input::getCmd('layout', ''); $Itemid = FSS_Input::getInt('Itemid', 0); $url = FSSRoute::_("index.php?option=" . $option . "&view=" . $view . "&layout=" . $layout . "&Itemid=" . $Itemid); } $url = str_replace("&what=find", "", $url); $url = base64_encode($url); $return = $url; require_once JPATH_SITE . DS . 'components' . DS . 'com_fss' . DS . 'views' . DS . 'admin' . DS . 'tmpl' . DS . 'noperm.php'; return false; }
function display($tpl = null) { if (FSS_Settings::Get('support_only_admin_open')) { return $this->noPermission("Access Denied", "CREATING_NEW_TICKETS_BY_USERS_IS_CURRENTLY_DISABLED"); } if (!FSS_Permission::auth("fss.ticket.open", "com_fss.support_user")) { return FSS_Helper::NoPerm(); } $mainframe = JFactory::getApplication(); $user = JFactory::getUser(); $userid = $user->get('id'); $this->assign('userid', $userid); $this->assign('email', ''); // defaults for blank ticket $this->ticket = new stdClass(); $this->ticket->prodid = FSS_Input::getInt('prodid'); $this->ticket->deptid = FSS_Input::getInt('deptid'); $this->ticket->catid = FSS_Input::getInt('catid'); $this->ticket->priid = FSS_Input::getInt('priid'); $this->ticket->subject = FSS_Input::getString('subject'); $this->ticket->body = FSS_Input::getBBCode('body'); $this->errors['subject'] = ''; $this->errors['body'] = ''; $this->errors['cat'] = ''; $what = FSS_Input::getCmd('what'); // done with ticket, try and save, if not, display any errors if ($what == "add") { if ($this->saveTicket()) { echo "Saved OK!"; exit; $link = 'index.php?option=com_fss&view=ticket&layout=view&Itemid=' . FSS_Input::getInt('Itemid') . '&ticketid=' . $this->ticketid; $mainframe->redirect($link); return; } } $this->product = $this->get('Product'); $this->dept = $this->get('Department'); $this->cats = SupportHelper::getCategories(); $this->pris = SupportHelper::getPriorities(); $this->support_user_attach = FSS_Settings::get('support_user_attach'); $this->fields = FSSCF::GetCustomFields(0, $prodid, $deptid); parent::display(); }
function &getFaq() { $db = JFactory::getDBO(); $faqid = FSS_Input::getInt('faqid', 0); $query = "SELECT f.id, f.question, f.answer, f.fullanswer, f.published, f.ordering, c.title, f.faq_cat_id, f.author, f.featured FROM #__fss_faq_faq as f LEFT JOIN #__fss_faq_cat as c ON f.faq_cat_id = c.id"; $where = array(); $where[] = "f.id = " . FSSJ3Helper::getEscaped($db, $faqid); $where[] = 'f.language in (' . $db->Quote(JFactory::getLanguage()->getTag()) . ',' . $db->Quote('*') . ')'; $user = JFactory::getUser(); $where[] = 'f.access IN (' . implode(',', $user->getAuthorisedViewLevels()) . ')'; if (FSS_Permission::auth("core.edit", "com_fss.faq")) { } else { if (FSS_Permission::auth("core.edit.own", "com_fss.faq")) { $where[] = " ( f.published = 1 OR f.author = {$this->content->userid} ) "; } else { $where[] = "f.published = 1"; } } $query .= " WHERE " . implode(" AND ", $where); //echo $query."<br>"; $db->setQuery($query); $rows = $db->loadAssoc(); return $rows; }
function delete() { // load in tickets to do $ticketid = FSS_Input::getInt('ticketid'); $tickets = FSS_Input::getCmd('tickets'); $def_archive = FSS_Ticket_Helper::GetStatusID('def_archive'); if ($ticketid > 0) { $ticket = new SupportTicket(); if ($ticket->load($ticketid)) { $ticket->delete(); } } else { if ($tickets != '') { $tickets = new SupportTickets(); $tickets->limitstart = 0; $tickets->limit = 100; $tickets->loadTicketsByStatus($tickets); foreach ($tickets->tickets as $ticket) { $ticket->delete(); } } } JFactory::getApplication()->redirect($_SERVER['HTTP_REFERER']); }
<tfoot> <tr> <td colspan="9"><?php echo $footer; ?> </td> </tr> </tfoot> <?php } ?> </table> <input type="hidden" name="groupid" value="<?php echo FSS_Input::getInt('groupid'); ?> " /> <input type="hidden" name="what" value="pickuser" /> <input type="hidden" name="boxchecked" value="0" /> <input type="hidden" name="filter_order" value="<?php echo FSS_Helper::escape($this->order); ?> " /> <input type="hidden" name="filter_order_Dir" value="<?php echo FSS_Helper::escape($this->order_Dir); ?> " /> <input type="hidden" name="limit_start" id="limitstart" value="<?php echo (int) $this->limit_start; ?>
static function CheckTicketLink() { $ticket_id = FSS_Input::getInt('t'); $ticket_pass = FSS_Input::getString('p'); if ($ticket_pass && $ticket_id > 0) { $db = JFactory::getDBO(); $qry = "SELECT * FROM #__fss_ticket_ticket WHERE id = " . $db->escape($ticket_id) . " AND password = '******'"; $db->setQuery($qry); $ticket = $db->loadObject(); if ($ticket) { $session = JFactory::getSession(); $session->Set('ticket_pass', $ticket_pass); $session->Set('ticket_email', $ticket->email); $link = FSSRoute::_("index.php?option=com_fss&view=ticket&layout=view&ticketid=" . $ticket_id, false); JFactory::getApplication()->redirect($link); } } }
echo JText::_('TICKET_MERGED_NOTICE_INTO'); ?> </p> <ul> <?php $db = JFactory::getDBO(); $qry = "SELECT * FROM #__fss_ticket_ticket WHERE id = " . $db->escape($this->ticket['merged']); $db->setQuery($qry); $merged = $db->loadObject(); ?> <li> <?php if (JFactory::getUser()->id > 0) { ?> <a href="<?php echo FSSRoute::_('index.php?option=com_fss&view=ticket&ticketid=' . $merged->id . "&Itemid=" . FSS_Input::getInt('Itemid'), false); ?> "> <?php echo $merged->reference; ?> - <?php echo $merged->title; ?> </a> <?php } else { ?> <?php echo $merged->reference; ?>
?> </a> </div> </div> </form> <div id="canned_replies" style="display: none;"> <?php echo SupportCanned::CannedList($this->ticket); ?> </div> <ul class="nav nav-tabs <?php if (FSS_Input::getInt('ticketid') > 0) { echo "nav-always"; } ?> "> <li class="active"> <a href='#messages' data-toggle="tab"> <?php echo JText::_('MESSAGES'); ?> </a> </li> <li> <a href='#details' data-toggle="tab">
<?php if ($use_prod) { ?> <a class='btn btn-default backprod' href="<?php echo FSSRoute::_('index.php?option=com_fss&view=ticket&layout=open&prodid=' . $this->prodid . '&admincreate=' . FSS_Input::getInt('admincreate')); ?> "><?php echo JText::_("BACK"); ?> </a> <?php } else { ?> <a class='btn btn-default backprod' href="<?php echo FSSRoute::_('index.php?option=com_fss&view=ticket&layout=open&admincreate=' . FSS_Input::getInt('admincreate')); ?> "><?php echo JText::_("BACK"); ?> </a> <?php } ?> <?php } else { ?> <?php if ($use_prod) { ?>
function display($tpl = NULL) { parent::init(); $this->plugins = $this->load_plugins(); $this->mode = FSS_Input::getcmd('mode', 'pick'); $this->usergroup = FSS_Input::getInt('usergroup'); foreach ($this->plugins as $plugin) { $plugin->mode = $this->mode; } $limitstart = FSS_Input::getInt('limitstart'); $mainframe = JFactory::getApplication(); $limit = $mainframe->getUserStateFromRequest('users.limit', 'limit', 10, 'int'); $search = FSS_Input::getString('search'); $this->lists = array(); $this->lists['order_Dir'] = FSS_Input::getCmd('filter_order_Dir'); $this->lists['order'] = FSS_Input::getCmd('filter_order'); $ticket_has_groups = false; // load in ticket if there is one $this->ticketid = FSS_Input::getInt("ticketid"); if ($this->mode == "user" || $this->mode == "admin") { $this->ticket = new SupportTicket(); $this->ticket->load($this->ticketid); $this->ticket->loadCC(); $this->ticket->loadGroups(); if (count($this->ticket->groups) > 0) { $ticket_has_groups = true; } } // ticket group, default to t if we are in user or admin mode $this->ticketgroup = null; if ($ticket_has_groups && $this->mode == "user") { $this->ticketgroup = "t"; } $this->ticketgroup = FSS_Input::getcmd('ticketgroup', $this->ticketgroup); $db = JFactory::getDBO(); $qry = "SELECT * FROM #__users "; $where = array(); if ($search != "") { $search_parts = array(); $search_parts[] = "username LIKE '%" . $db->escape($search) . "%'"; $search_parts[] = "name LIKE '%" . $db->escape($search) . "%'"; $search_parts[] = "email LIKE '%" . $db->escape($search) . "%'"; $this->searchFields($search_parts); foreach ($this->plugins as $plugin) { $ids = $plugin->search($search); if (count($ids) > 0) { $search_parts[] = "id IN ('" . implode("', '", $ids) . "')"; } } $where[] = "( " . implode(" OR ", $search_parts) . " )"; } // filter by usergroup if ($this->usergroup > 0) { $where[] = "id IN (SELECT user_id FROM #__user_usergroup_map WHERE group_id = " . $db->escape($this->usergroup) . ")"; } // filter by ticket group if ($this->ticketgroup == "t") { $group_ids = array(); $group_ids[] = 0; foreach ($this->ticket->groups as $group) { $group_ids[] = $group->id; } $where[] = "id IN (SELECT user_id FROM #__fss_ticket_group_members WHERE group_id IN (" . implode(", ", $group_ids) . "))"; } elseif ($this->ticketgroup > 0) { $where[] = "id IN (SELECT user_id FROM #__fss_ticket_group_members WHERE group_id = " . $db->escape($this->ticketgroup) . ")"; } if ($this->mode == "admin") { $handlers = SupportUsers::getHandlers(false, false); $ids = array(); $ids[] = 0; foreach ($handlers as $handler) { $ids[] = $handler->id; } $where[] = "id IN (" . implode(", ", $ids) . ")"; } // add where if (count($where) > 0) { $qry .= " WHERE " . implode(" AND ", $where); } $order = FSS_Input::getCmd('filter_order'); $dir = FSS_Input::getCmd('filter_order_Dir', 'asc'); if ($order == "username" || $order == "name" || $order == "email") { // Sort ordering $qry .= " ORDER BY {$order} {$dir} "; } else { $qry .= " ORDER BY name "; } //echo $qry . "<br>"; // get max items $db->setQuery($qry); $db->query(); $maxitems = $db->getNumRows(); // select picked items $db->setQuery($qry, $limitstart, $limit); $this->users = $db->loadObjectList(); //print_p(reset($this->users)); // build pagination $this->pagination = new JPaginationEx($maxitems, $limitstart, $limit); $this->search = $search; if ($this->mode != "admin") { // load in joomla user groups $qry = "SELECT * FROM #__usergroups ORDER BY lft"; $db->setQuery($qry); $this->groups = $db->loadObjectList(); $group_index = array(); foreach ($this->groups as &$group) { $group_index[$group->id] =& $group; if ($group->parent_id == 0) { $group->level = 0; } else { $group->level = $group_index[$group->parent_id]->level + 1; } $group->display = str_repeat("- ", $group->level) . $group->title; } array_unshift($this->groups, JHTML::_('select.option', '', JText::_("JOOMLA_USERGROUP"), 'id', 'display')); $this->jgroup_select = JHTML::_('select.genericlist', $this->groups, 'usergroup', 'class="inputbox" size="1" onchange="document.fssForm.submit( );"', 'id', 'display', $this->usergroup); // load ticket groups $qry = "SELECT * FROM #__fss_ticket_group ORDER BY groupname"; $db->setQuery($qry); $this->ticketgroups = $db->loadObjectList(); if ($this->ticketid > 0 && $ticket_has_groups) { array_unshift($this->ticketgroups, JHTML::_('select.option', 't', JText::_("CURRENT_TICKET"), 'id', 'groupname')); } array_unshift($this->ticketgroups, JHTML::_('select.option', '', JText::_("ALL_TICKET_GROUPS"), 'id', 'groupname')); $this->ticketgroup_select = JHTML::_('select.genericlist', $this->ticketgroups, 'ticketgroup', 'class="inputbox" size="1" onchange="document.fssForm.submit( );"', 'id', 'groupname', $this->ticketgroup); } $this->_display(); }
function LoadData() { if (!$this->xml) { return; } $qry = (string) $this->xml->sql; $where = array(); if ($this->xml->where) { foreach ($this->xml->where as $w) { $where[] = (string) $w; } } if ($this->xml->addbtntext) { $this->addbtntext = (string) $this->xml->addbtntext; } if ($this->xml->use_auth) { // sort out which articles the user can view here, based on published, access, author // sort published out here $published = (string) $this->xml->use_auth->attributes()->published; $access = (string) $this->xml->use_auth->attributes()->access; $author = (string) $this->xml->use_auth->attributes()->author; $where[] = "{$published} = 1"; } $this->search = FSS_Input::getString('search'); if ($this->search != "") { foreach ($this->xml->filters->search->field as $field) { $field = (string) $field; $where[] = "{$field} LIKE '%" . FSSJ3Helper::getEscaped($db, $this->search) . "%'"; } } foreach ($this->xml->filters->filter as $filter) { $type = (string) $filter->attributes()->type; $field = (string) $filter->attributes()->field; $filter_id = (string) $filter->attributes()->id; if ($type == "lookup") { $key = (string) $filter->key; $display = (string) $filter->display; $var = "filter_" . $filter_id; $value = trim(FSS_Input::getString($var)); $this->{$var} = FSS_Input::getString($var); if ($value != "") { $where[] = "{$field} = '" . FSSJ3Helper::getEscaped($db, $value) . "'"; } } } if (count($where) > 0) { $qry .= " WHERE " . implode(" AND ", $where); } $this->order = FSS_Input::getCmd('filter_order'); $this->orderdir = FSS_Input::getCmd('filter_order_Dir', 'ASC'); if ($this->order == "" && $this->xml->ordering) { $this->order = (string) $this->xml->ordering; } if ($this->order) { $qry .= " ORDER\tBY {$this->order} {$this->orderdir} "; } $db = JFactory::getDBO(); $db->setQuery($qry); //echo "Qry : $qry<br>"; $db->query(); $this->num_rows = $db->getNumRows(); $mainframe = JFactory::getApplication(); $this->limit = $mainframe->getUserStateFromRequest('global.list.limitpick', 'limit', 10, 'int'); $this->limitstart = FSS_Input::getInt('limitstart'); $this->limitstart = $this->limit != 0 ? floor($this->limitstart / $this->limit) * $this->limit : 0; $this->pagination = new JPaginationEx($this->num_rows, $this->limitstart, $this->limit); $db->setQuery($qry, $this->limitstart, $this->limit); $this->data = $db->loadObjectList(); //echo $qry."<br>"; //print_p($this->data); }
function removecc() { $this->loadTicket(); if ($this->ticket) { $ids = FSS_Input::getString('ids'); $is_admin = FSS_Input::getInt('is_admin'); $ids = explode(",", $ids); $this->ticket->removeCC($ids, $is_admin); } if (FSS_Input::getInt('nr') != 1) { $link = FSSRoute::_("index.php?option=com_fss&view=admin_support&layout=ticket&ticketid=" . $this->ticket->id, false); JFactory::getApplication()->redirect($link); } else { exit; } }
defined('_JEXEC') or die; ?> <form action="<?php echo FSSRoute::_("index.php?option=com_fss&view=ticket&tmpl=component&ticketid=" . FSS_Input::getInt('ticketid')); ?> " method="post" class="form-horizontal" id="fssForm"> <?php echo FSS_Helper::PageStylePopup(true); ?> <?php echo FSS_Helper::PageTitlePopup("SUPPORT", "EDIT_TICKET"); ?> <?php $input = FSSCF::FieldInput($this->field, $this->errors, "ticket", array('ticketid' => FSS_Input::getInt('ticketid', 0), 'userid' => $this->ticket['user_id'], 'ticket' => $this->ticket)); ?> <div class="control-group" style="min-height:<?php echo $this->field['min_popup_height']; ?> px;"> <label class="control-label"> <?php echo FSSCF::FieldHeader($this->field, false, false); ?> </label> <div class="controls"> <?php echo $input;