コード例 #1
0
 function loadTicketsBySearch()
 {
     $db = JFactory::getDBO();
     $query = "SELECT t.*, s.title as status, s.color, u.name, au.name as assigned, u.email as useremail, u.username as username, au.email as handleremail, au.username as handlerusername, \n";
     $query .= " dept.title as department, cat.title as category, prod.title as product, pri.title as priority, pri.color as pricolor, \n";
     $query .= " grp.groupname as groupname, grp.id as group_id \n";
     $query .= " , pri.translation as ptl, dept.translation as dtr, s.translation as str, cat.translation as ctr, prod.translation as prtr\n";
     $query .= " FROM #__fss_ticket_ticket as t \n";
     $query .= " LEFT JOIN #__fss_ticket_status as s ON t.ticket_status_id = s.id \n";
     $query .= " LEFT JOIN #__users as u ON t.user_id = u.id \n";
     $query .= " LEFT JOIN #__users as au ON t.admin_id = au.id \n";
     $query .= " LEFT JOIN #__fss_ticket_dept as dept ON t.ticket_dept_id = dept.id \n";
     $query .= " LEFT JOIN #__fss_ticket_cat as cat ON t.ticket_cat_id = cat.id \n";
     $query .= " LEFT JOIN #__fss_prod as prod ON t.prod_id = prod.id \n";
     $query .= " LEFT JOIN #__fss_ticket_pri as pri ON t.ticket_pri_id = pri.id \n";
     $query .= " LEFT JOIN (SELECT group_id, user_id FROM #__fss_ticket_group_members GROUP BY user_id) as mem ON t.user_id = mem.user_id \n";
     $query .= " LEFT JOIN #__fss_ticket_group as grp ON grp.id = mem.group_id \n";
     // add custom fields to the sql
     foreach (FSSCF::GetAllCustomFields() as $field) {
         if (!$field['inlist']) {
             continue;
         }
         $id = $field['id'];
         if ($field['peruser']) {
             $query .= " LEFT JOIN #__fss_ticket_user_field as cf{$id} ON cf{$id}.user_id = t.user_id AND cf{$id}.field_id = {$id} \n";
         } else {
             $query .= " LEFT JOIN #__fss_ticket_field as cf{$id} ON cf{$id}.ticket_id = t.id AND cf{$id}.field_id = {$id} \n";
         }
     }
     $searchtype = FSS_Input::getCmd('searchtype', 'basic');
     $wherebits = array();
     if ($searchtype == "basic") {
         $search = FSS_Input::getString('search', '');
         if ($search != "") {
             $mode = "";
             if (FSS_Helper::contains($search, array('*', '+', '-', '<', '>', '(', ')', '~', '"'))) {
                 $mode = "IN BOOLEAN MODE";
             }
             //$wherebits[] = " t.title LIKE '%".FSSJ3Helper::getEscaped($db, $search)."%' ";
             $wherebits[] = " MATCH (t.title) AGAINST ('" . $db->escape($search) . "' {$mode}) /* Title */ ";
             $wherebits[] = " t.reference LIKE '%" . FSSJ3Helper::getEscaped($db, $search) . "%' /* Reference */ ";
             // search custom fields that are set to be searched
             $this->searchFields($wherebits, "basicsearch");
             // basic search optional fields
             if (FSS_Settings::get('support_basic_name')) {
                 $wherebits[] = " u.name LIKE '%" . FSSJ3Helper::getEscaped($db, $search) . "%' /* Name */ ";
                 $wherebits[] = " unregname LIKE '%" . FSSJ3Helper::getEscaped($db, $search) . "%' /* UnReg Name */ ";
             }
             if (FSS_Settings::get('support_basic_username')) {
                 $wherebits[] = " u.username LIKE '%" . FSSJ3Helper::getEscaped($db, $search) . "%' /* Username */ ";
             }
             if (FSS_Settings::get('support_basic_email')) {
                 $wherebits[] = " u.email LIKE '%" . FSSJ3Helper::getEscaped($db, $search) . "%' /* User email */ ";
                 $wherebits[] = " t.email LIKE '%" . FSSJ3Helper::getEscaped($db, $search) . "%' /* Unreg Email */ ";
             }
             if (FSS_Settings::get('support_basic_messages')) {
                 $qry = "SELECT ticket_ticket_id FROM #__fss_ticket_messages WHERE subject LIKE '%" . FSSJ3Helper::getEscaped($db, $search) . "%' OR ";
                 $qry .= " MATCH (body) AGAINST ('" . $db->escape($search) . "' {$mode}) GROUP BY ticket_ticket_id";
                 $qry .= " AND admin IN (0, 1, 2, 4) ";
                 $db->setQuery($qry);
                 $wherebits[] = $this->TicketIDsToWhere($db->loadObjectList(), "ticket_ticket_id") . " /* Messages */ ";
             }
         }
         if (count($wherebits) == 0) {
             $wherebits[] = "1 /* Catch All */";
         }
         $query .= "\n WHERE (" . implode("\n OR ", $wherebits) . ")";
     } else {
         if ($searchtype == "advanced") {
             $search = FSS_Input::getString('search', '');
             $wherebits = array();
             $subject = FSS_Input::getString('subject', '');
             if ($subject) {
                 $wherebits[] = " t.title LIKE '%" . FSSJ3Helper::getEscaped($db, $subject) . "%' /* Title */ ";
             }
             $reference = FSS_Input::getString('reference', '');
             if ($reference) {
                 $wherebits[] = " t.reference LIKE '%" . FSSJ3Helper::getEscaped($db, $reference) . "%' /* Reference */ ";
             }
             $username = FSS_Input::getString('username', '');
             if ($username) {
                 $wherebits[] = " u.username LIKE '%" . FSSJ3Helper::getEscaped($db, $username) . "%' /* Username */ ";
             }
             $useremail = FSS_Input::getString('useremail', '');
             if ($useremail) {
                 $wherebits[] = " ( u.email LIKE '%" . FSSJ3Helper::getEscaped($db, $useremail) . "%' OR t.email LIKE '%" . FSSJ3Helper::getEscaped($db, $useremail) . "%' ) /* EMail */";
             }
             $userfullname = FSS_Input::getString('userfullname', '');
             if ($userfullname) {
                 $wherebits[] = " ( u.name LIKE '%" . FSSJ3Helper::getEscaped($db, $userfullname) . "%' OR unregname LIKE '%" . FSSJ3Helper::getEscaped($db, $userfullname) . "%' ) /* Name */";
             }
             $content = FSS_Input::getString('content', '');
             if ($content) {
                 $mode = "";
                 if (FSS_Helper::contains($search, array('*', '+', '-', '<', '>', '(', ')', '~', '"'))) {
                     $mode = "IN BOOLEAN MODE";
                 }
                 $qry = "SELECT ticket_ticket_id FROM #__fss_ticket_messages WHERE subject LIKE '%" . FSSJ3Helper::getEscaped($db, $content) . "%' OR ";
                 $qry .= " MATCH (body) AGAINST ('" . $db->escape($content) . "' {$mode})";
                 $qry .= " AND admin IN (0, 1, 2, 4) ";
                 $db->setQuery($qry);
                 $wherebits[] = $this->TicketIDsToWhere($db->loadObjectList(), "ticket_ticket_id") . " /* Messages */ ";
             }
             $handler = FSS_Input::getInt('handler', '');
             if ($handler) {
                 $user = JFactory::getUser();
                 if ($handler == -5) {
                     $wherebits[] = " t.admin_id = '" . $user->id . "' /* Handler -1 */ ";
                 } else {
                     if ($handler == -2) {
                         $wherebits[] = " t.admin_id != '" . $user->id . "' /* Handler -2 */ ";
                         $wherebits[] = " t.admin_id != 0 /* Handler -2 */";
                     } else {
                         if ($handler == -3) {
                             $wherebits[] = " t.admin_id = 0 /* Handler -3 */";
                         } elseif ($handler == -4) {
                             $temp_where[] = " t.admin_id = '" . $db->escape($user->id) . "' ";
                             $qry = "SELECT ticket_id FROM #__fss_ticket_cc WHERE isadmin = 1 AND user_id = " . $db->escape($user->id);
                             $db->setQuery($qry);
                             $wherebits[] = $this->TicketIDsToWhere($db->loadObjectList(), "ticket_id") . " /* Handler -4 */";
                         } else {
                             // handler
                             if ($handler == -1) {
                                 $handler = JFactory::getUser()->id;
                             }
                             $qry = "SELECT * FROM #__fss_ticket_cc WHERE isadmin = 1 AND user_id = " . $db->escape($handler);
                             $db->setQuery($qry);
                             $temp_where[] = $this->TicketIDsToWhere($db->loadObjectList(), "ticket_id");
                             $temp_where[] = " t.admin_id = '" . $db->escape($handler) . "' ";
                             $wherebits[] = " ( " . implode(" OR ", $temp_where) . " ) /* Handler specified */ ";
                             //$wherebits[] = " t.admin_id = '".FSSJ3Helper::getEscaped($db, $handler)."' ";
                         }
                     }
                 }
             }
             $status = FSS_Input::getCmd('status', '');
             if ($status) {
                 if ($status == "open") {
                     $open = FSS_Ticket_Helper::GetStatusIDs("def_open");
                     // tickets that arent closed
                     $wherebits[] = " t.ticket_status_id IN ( " . implode(", ", $open) . ") /* Def open */ ";
                 } elseif ($status == 'allopen') {
                     $allopen = FSS_Ticket_Helper::GetStatusIDs("is_closed", true);
                     // tickets that arent closed
                     $wherebits[] = " t.ticket_status_id IN ( " . implode(", ", $allopen) . ") /* All open */ ";
                 } elseif ($status == 'closed') {
                     $allopen = FSS_Ticket_Helper::GetStatusIDs("is_closed");
                     // remove the archived tickets from the list to deal with
                     $def_archive = FSS_Ticket_Helper::GetStatusID('def_archive');
                     foreach ($allopen as $offset => $value) {
                         if ($value == $def_archive) {
                             unset($allopen[$offset]);
                         }
                     }
                     // tickets that are closed
                     $wherebits[] = " t.ticket_status_id IN ( " . implode(", ", $allopen) . ") /* all closed */";
                 } elseif ($status == 'all') {
                     // need all tickets that arent archived
                     $allopen = FSS_Ticket_Helper::GetStatusIDs("def_archive", true);
                     $wherebits[] = " t.ticket_status_id IN ( " . implode(", ", $allopen) . " ) /* all (not archived) */ ";
                 } elseif ($status == 'archived') {
                     // need all tickets that arent archived
                     $allopen = FSS_Ticket_Helper::GetStatusIDs("def_archive");
                     $wherebits[] = " t.ticket_status_id IN ( " . implode(", ", $allopen) . " ) /* archived */ ";
                 } else {
                     $wherebits[] = " t.ticket_status_id = " . (int) FSSJ3Helper::getEscaped($db, $status) . " /* specified status */";
                 }
             }
             $product = FSS_Input::getInt('product', '');
             if ($product) {
                 $wherebits[] = " t.prod_id = '" . FSSJ3Helper::getEscaped($db, $product) . "' /* Product */";
             }
             $department = FSS_Input::getInt('department', '');
             if ($department) {
                 $wherebits[] = " t.ticket_dept_id = '" . FSSJ3Helper::getEscaped($db, $department) . "' /* Department */ ";
             }
             $cat = FSS_Input::getInt('cat', '');
             if ($cat) {
                 $wherebits[] = " t.ticket_cat_id = '" . FSSJ3Helper::getEscaped($db, $cat) . "' /* Category */";
             }
             $pri = FSS_Input::getInt('priority', '');
             if ($pri) {
                 $wherebits[] = " t.ticket_pri_id = '" . FSSJ3Helper::getEscaped($db, $pri) . "' /* Priority */";
             }
             $group = FSS_Input::getInt('group', '');
             if ($group > 0) {
                 $wherebits[] = " t.user_id IN (SELECT user_id FROM #__fss_ticket_group_members WHERE group_id = '" . FSSJ3Helper::getEscaped($db, $group) . "' GROUP BY user_id) /* Ticket Group */";
             }
             $date_from = FSS_Helper::DateValidate(FSS_Input::getString('date_from', ''));
             $date_to = FSS_Helper::DateValidate(FSS_Input::getString('date_to', ''));
             if ($date_from) {
                 $wherebits[] = " t.lastupdate > DATE_SUB('" . FSSJ3Helper::getEscaped($db, $date_from) . "',INTERVAL 1 DAY) /* Date From */";
             }
             if ($date_to) {
                 $wherebits[] = " t.opened < DATE_ADD('" . FSSJ3Helper::getEscaped($db, $date_to) . "',INTERVAL 1 DAY) /* Date To */";
             }
             $this->searchFields($wherebits, "advancedsearch");
             if (count($wherebits) == 0) {
                 $wherebits[] = "1  /* Catch All */";
             }
             $query .= "\n WHERE " . implode("\n AND ", $wherebits);
         } else {
             $query .= " WHERE 1  /* Catch All */";
         }
     }
     $query .= "\n AND " . $this->getTagFilter() . " /* Tag Filter */";
     $query .= "\n AND " . SupportUsers::getAdminWhere() . " /* getAdminWhere */";
     $query .= "\n AND " . SupportSource::admin_show_sql() . " /* admin_show_sql */";
     $order = array();
     if (SupportUsers::getSetting("group_products")) {
         $order[] = "prod.ordering";
     }
     if (SupportUsers::getSetting("group_departments")) {
         $order[] = "dept.title";
     }
     if (SupportUsers::getSetting("group_cats")) {
         $order[] = "cat.title";
     }
     if (SupportUsers::getSetting("group_pri")) {
         $order[] = "pri.ordering DESC";
     }
     if (SupportUsers::getSetting("group_group")) {
         $order[] = "case when grp.groupname is null then 1 else 0 end";
         $order[] = "grp.groupname";
     }
     $ordering = JFactory::getApplication()->getUserStateFromRequest("fss_admin.ordering", "ordering", "");
     if ($ordering) {
         $order = array();
         $ordering = str_replace(".asc", " ASC", $ordering);
         $ordering = str_replace(".desc", " DESC", $ordering);
         $order[] = $ordering;
     } else {
         $order[] = "lastupdate DESC";
     }
     $query .= "\n ORDER BY " . implode(", ", $order);
     $session = JFactory::getSession();
     $session->set("last_admin_query", (string) $query);
     $session->set("last_admin_list", $_SERVER['REQUEST_URI']);
     $session->set("last_admin_post", $_POST);
     //echo "<br>".str_replace("\n", "<br>", $query)."<br>";
     $db->setQuery($query);
     $db->query();
     $this->ticket_count = $db->getNumRows();
     $db->setQuery($query, $this->limitstart, $this->limit);
     $this->LoadFromRows($db->loadObjectList());
 }
コード例 #2
0
ファイル: kb.php プロジェクト: vstorm83/propertease
 function _buildArtQuery()
 {
     $db = JFactory::getDBO();
     $catid = FSS_Input::getInt('catid');
     $prodid = FSS_Input::getInt('prodid');
     $search = FSS_Input::getString('kbsearch');
     $query1 = "SELECT a.* FROM #__fss_kb_art as a WHERE 1 ";
     if ($catid > 0) {
         $query1 .= " AND kb_cat_id = " . FSSJ3Helper::getEscaped($db, $catid);
     }
     if ($prodid > 0) {
         $query1 .= " AND a.id IN (SELECT kb_art_id FROM #__fss_kb_art_prod WHERE prod_id = " . FSSJ3Helper::getEscaped($db, $prodid) . ") ";
     }
     // stuff to show extra arts when have edit permission
     $where = array();
     if (FSS_Permission::auth("core.edit", "com_fss.kb")) {
     } else {
         if (FSS_Permission::auth("core.edit.own", "com_fss.kb")) {
             $where[] = " ( published = 1 OR author = {$this->content->userid} ) ";
         } else {
             $where[] = "published = 1";
         }
     }
     $where[] = 'language in (' . $db->Quote(JFactory::getLanguage()->getTag()) . ',' . $db->Quote('*') . ')';
     $where[] = 'access IN (' . implode(',', JFactory::getUser()->getAuthorisedViewLevels()) . ')';
     $mode = "";
     if (FSS_Helper::contains($search, array('*', '+', '-', '<', '>', '(', ')', '~', '"'))) {
         $mode = "IN BOOLEAN MODE";
     }
     // search
     if ($search != '') {
         $query1 .= " AND MATCH (title, body) AGAINST ('" . $db->escape($search) . "' {$mode}) ";
     }
     if (count($where) > 0) {
         $query1 .= " AND " . implode(" AND ", $where);
     }
     $query2 = "SELECT a.* FROM #__fss_kb_art as a WHERE 1 ";
     if ($catid > 0) {
         $query2 .= " AND kb_cat_id = " . FSSJ3Helper::getEscaped($db, $catid);
     }
     if ($search != '') {
         $query2 .= " AND MATCH (title, body) AGAINST ('" . $db->escape($search) . "' {$mode}) ";
     }
     $query2 .= " AND a.allprods = 1";
     // AND published = 1 ";
     if (count($where) > 0) {
         $query2 .= " AND " . implode(" AND ", $where);
     }
     if ($search) {
         $query = "(" . $query1 . ") UNION (" . $query2 . ")";
     } else {
         $query = "(" . $query1 . ") UNION (" . $query2 . ") ORDER BY ordering";
     }
     //echo $query."<br>";
     return $query;
 }
コード例 #3
0
ファイル: ticket.php プロジェクト: vstorm83/propertease
 function &getTickets()
 {
     $db = JFactory::getDBO();
     $user = JFactory::getUser();
     $userid = $user->get('id');
     $uidlist = $this->getUIDS($userid);
     $tidlist = $this->getTIDS($userid);
     $query = "SELECT t.*, s.title as status, s.color, u.name, au.name as assigned, u.email as useremail, u.username as username, au.email as handleremail, au.username as handlerusername, ";
     $query .= " dept.title as department, cat.title as category, prod.title as product, pri.title as priority, pri.color as pricolor, ";
     $query .= " grp.groupname as groupname, grp.id as group_id ";
     $query .= " , pri.translation as ptl, dept.translation as dtr, s.translation as str, cat.translation as ctr, prod.translation as prtr";
     $query .= " FROM #__fss_ticket_ticket as t ";
     $query .= " LEFT JOIN #__fss_ticket_status as s ON t.ticket_status_id = s.id ";
     $query .= " LEFT JOIN #__users as u ON t.user_id = u.id ";
     $query .= " LEFT JOIN #__users as au ON t.admin_id = au.id ";
     $query .= " LEFT JOIN #__fss_ticket_dept as dept ON t.ticket_dept_id = dept.id ";
     $query .= " LEFT JOIN #__fss_ticket_cat as cat ON t.ticket_cat_id = cat.id ";
     $query .= " LEFT JOIN #__fss_prod as prod ON t.prod_id = prod.id ";
     $query .= " LEFT JOIN #__fss_ticket_pri as pri ON t.ticket_pri_id = pri.id ";
     $query .= " LEFT JOIN (SELECT group_id, user_id FROM #__fss_ticket_group_members GROUP BY user_id) as mem ON t.user_id = mem.user_id ";
     $query .= " LEFT JOIN #__fss_ticket_group as grp ON grp.id = mem.group_id ";
     // add product, department and category
     $query .= " WHERE ( t.user_id IN (" . implode(", ", $uidlist) . ") OR t.id IN (" . implode(", ", $tidlist) . ") ) ";
     $query .= " AND " . SupportSource::user_list_sql();
     $tickets = FSS_Input::getCmd('tickets', 'open');
     if (FSS_Settings::get('support_simple_userlist_tabs')) {
         $tickets = "all";
     }
     if (FSS_Input::getCmd('search_all')) {
         $tickets = "";
     }
     if ($tickets == 'open') {
         $allopen = FSS_Ticket_Helper::GetStatusIDs("is_closed", true);
         // tickets that arent closed
         $query .= " AND ticket_status_id IN ( " . implode(", ", $allopen) . ") ";
     }
     if ($tickets == 'closed') {
         $allopen = FSS_Ticket_Helper::GetStatusIDs("is_closed");
         // remove the archived tickets from the list to deal with
         $def_archive = FSS_Ticket_Helper::GetStatusID('def_archive');
         foreach ($allopen as $offset => $value) {
             if ($value == $def_archive) {
                 unset($allopen[$offset]);
             }
         }
         // tickets that are closed
         $query .= " AND ticket_status_id IN ( " . implode(", ", $allopen) . ") ";
     } else {
         if ($tickets > 0) {
             $statuss = SupportHelper::getStatuss(false);
             $status_list = array();
             $status_list[] = (int) $tickets;
             foreach ($statuss as $status) {
                 if ($status->combine_with == (int) $tickets) {
                     $status_list[] = $status->id;
                 }
             }
             $query .= " AND ticket_status_id IN (" . implode(", ", $status_list) . ")";
         }
     }
     $search = FSS_Input::getString('search');
     if ($search != "") {
         FSS_Helper::AllowCache();
         // We have the nearly full query here, so use it to get a list of ticket ids
         $db->setQuery($query);
         $recs = $db->loadObjectList();
         $ids = array();
         $ids[] = 0;
         foreach ($recs as $rec) {
             $ids[] = $rec->id;
         }
         $mode = "";
         if (FSS_Helper::contains($search, array('*', '+', '-', '<', '>', '(', ')', '~', '"'))) {
             $mode = "IN BOOLEAN MODE";
         }
         $msgsrch = "SELECT ticket_ticket_id FROM #__fss_ticket_messages WHERE ticket_ticket_id IN (" . implode(", ", $ids) . ") AND admin < 3 AND ";
         $msgsrch .= " MATCH (body) AGAINST ('" . $db->escape($search) . "' {$mode}) ";
         $db->setQuery($msgsrch);
         $results = $db->loadObjectList();
         $ids = array();
         $ids[] = 0;
         foreach ($results as $rec) {
             $ids[] = $rec->ticket_ticket_id;
         }
         // search custom fields that are set to be searched
         $fields = FSSCF::GetAllCustomFields(true);
         foreach ($fields as $field) {
             if (!$field["basicsearch"]) {
                 continue;
             }
             if ($field['permissions'] > 1 && $field['permissions'] < 5) {
                 continue;
             }
             $fieldid = $field['id'];
             if ($field['type'] == "checkbox") {
                 if ($search == "1") {
                     $search = "on";
                 } else {
                     $search = "";
                 }
             }
             if ($field['peruser']) {
                 continue;
             }
             if ($field['type'] == "plugin") {
                 // try to do a plugin based search
                 $data = array();
                 foreach ($field['values'] as $item) {
                     list($key, $value) = explode("=", $item, 2);
                     $data[$key] = $value;
                 }
                 if (array_key_exists("plugin", $data)) {
                     $plugins = FSSCF::get_plugins();
                     if (array_key_exists($data['plugin'], $plugins)) {
                         $po = $plugins[$data['plugin']];
                         if (method_exists($po, "Search")) {
                             $res = $po->Search($data['plugindata'], $search, false, false);
                             if ($res !== false) {
                                 foreach ($res as $item) {
                                     $ids[] = (int) $item->ticket_id;
                                 }
                                 continue;
                             }
                         }
                     }
                 }
             }
             $qry = "SELECT ticket_id FROM #__fss_ticket_field WHERE field_id = '" . FSSJ3Helper::getEscaped($db, $fieldid) . "' AND value LIKE '%" . FSSJ3Helper::getEscaped($db, $search) . "%'";
             $db->setQuery($qry);
             $data = $db->loadObjectList();
             foreach ($data as $item) {
                 $id = (int) $item->ticket_id;
                 if ($id > 0) {
                     $ids[] = $id;
                 }
             }
         }
         //"MATCH (question, answer) AGAINST ('" . $db->escape($search) . "')"
         $query .= " AND ( t.id IN (" . implode(", ", $ids) . ") OR MATCH (t.title) AGAINST ('" . $db->escape($search) . "' {$mode}) OR t.reference LIKE '%" . $db->escape($search) . "%' ) ";
     }
     $order = FSS_Input::getCmd('order');
     $order_dir = FSS_Input::getCmd('order_dir', 'asc');
     $order_dir_allowed = array('asc', 'desc');
     if (!in_array($order_dir, $order_dir_allowed)) {
         $order_dir = 'asc';
     }
     $order_allowed = array('t.title', 'lastupdate', 'status', 'assigned', 'lastupdate', 'u.name');
     if (!in_array($order, $order_allowed)) {
         $order = '';
     }
     if ($order != "") {
         $query .= " ORDER BY {$order} {$order_dir}";
     } else {
         $query .= " ORDER BY lastupdate DESC ";
     }
     $mainframe = JFactory::getApplication();
     $limit = $mainframe->getUserStateFromRequest('global.list.limit_ticket', 'limit', FSS_Settings::Get('ticket_per_page'), 'int');
     $limitstart = FSS_Input::getInt('limitstart');
     $limitstart = $limit != 0 ? floor($limitstart / $limit) * $limit : 0;
     $db->setQuery($query);
     $db->query();
     //echo $query . "<br>";
     $count = $db->getNumRows();
     $result['pagination'] = new JPaginationJs($count, $limitstart, $limit);
     $db->setQuery($query, $limitstart, $limit);
     $result['tickets'] = $db->loadObjectList();
     foreach ($result['tickets'] as &$ticket) {
         $fields = FSSCF::GetCustomFields($ticket->id, $ticket->prod_id, $ticket->ticket_dept_id);
         $values = FSSCF::GetTicketValues($ticket->id, $ticket);
         $ticket->fields = array();
         foreach ($fields as &$field) {
             $ticket->fields[$field['id']] = array();
             $ticket->fields[$field['id']]['name'] = $field['description'];
             $ticket->fields[$field['id']]['value'] = '';
             if (isset($values[$field['id']])) {
                 $ticket->fields[$field['id']]['value'] = $values[$field['id']]['value'];
             }
         }
     }
     return $result;
 }
コード例 #4
0
ファイル: faq.php プロジェクト: vstorm83/propertease
 function _buildQuery()
 {
     $db = JFactory::getDBO();
     $query = "SELECT * FROM #__fss_faq_faq";
     $where = array();
     if ($this->_search != "") {
         $mode = "";
         if (FSS_Helper::contains($this->_search, array('*', '+', '-', '<', '>', '(', ')', '~', '"'))) {
             $mode = "IN BOOLEAN MODE";
         }
         $where[] = "MATCH (question, answer) AGAINST ('" . $db->escape($this->_search) . "' {$mode})";
     } else {
         if ($this->_curcatid > 0) {
             $where[] = "faq_cat_id = '" . FSSJ3Helper::getEscaped($db, $this->_curcatid) . "'";
         }
     }
     if ($this->_curcatid == -5) {
         $where[] = "featured = 1";
     }
     if (FSS_Permission::auth("core.edit", "com_fss.faq")) {
     } else {
         if (FSS_Permission::auth("core.edit.own", "com_fss.faq")) {
             $where[] = " ( published = 1 OR author = {$this->content->userid} ) ";
         } else {
             $where[] = "published = 1";
         }
     }
     $where[] = 'language in (' . $db->Quote(JFactory::getLanguage()->getTag()) . ',' . $db->Quote('*') . ')';
     $user = JFactory::getUser();
     $where[] = 'access IN (' . implode(',', $user->getAuthorisedViewLevels()) . ')';
     $tag = FSS_Input::getString('tag');
     if ($tag) {
         $qry2 = "SELECT faq_id FROM #__fss_faq_tags WHERE tag = '" . FSSJ3Helper::getEscaped($db, $tag) . "'";
         $db->setQuery($qry2);
         $rows = $db->loadObjectList();
         $ids = array();
         foreach ($rows as &$row) {
             $ids[] = $row->faq_id;
         }
         if (count($ids) > 0) {
             $where[] = "id IN (" . implode(", ", $ids) . ")";
         } else {
             $where[] = "id = 0";
         }
     }
     if (count($where) > 0) {
         $query .= " WHERE " . implode(" AND ", $where);
     }
     $query .= " ORDER BY ordering";
     //echo $query."<br>";
     return $query;
 }