AAAAhome/academiac/www/administrator/components/com_unitehcarousel/models/items.php000060400000011415151372312030024254 0ustar00getUserStateFromRequest($this->context . '.filter.published', 'filter_published', ''); $this->setState('filter.published', $published); // List state information. parent::populateState('a.ordering', 'asc'); } protected function getStoreId($id = '') { // Compile the store id. $id .= ':' . $this->getState('filter.published'); return parent::getStoreId($id); } /** * * get sliders array */ public function getArrSliders() { $arrSliders = HelperUniteHCar::getArrSliders(); return($arrSliders); } /** * * get slider id */ public function getSliderID() { $sliderID = JRequest::getVar("id"); if (empty($sliderID)) UniteFunctionsHCar::throwError("Slider ID url argument not found (id)"); return($sliderID); } protected function getListQuery() { // Create a new query object. $db = $this->getDbo(); $query = $db->getQuery(true); // Select the required fields from the table. $query->select( $this->getState( 'list.select', 'a.*' ) ); $query->from('#__unitehcarousel_slides AS a'); // Join over the users for the checked out user. $query->select('uc.name AS editor'); $query->join('LEFT', '#__users AS uc ON uc.id=a.checked_out'); // Filter by published state $published = $this->getState('filter.published'); if (is_numeric($published)) { $query->where('a.published = ' . (int) $published); } else if ($published === '') { $query->where('(a.published = 0 OR a.published = 1)'); } // Filter by category state $category = $this->getState('filter.category'); if (is_numeric($category)) { $query->where('a.catid = ' . (int) $category); } //Filter by search in title. $search = $this->getState('filter.search'); if (!empty($search)) { if (stripos($search, 'id:') === 0) { $query->where('a.id = ' . (int) substr($search, 3)); } else { $search = $db->Quote('%' . $db->getEscaped($search, true) . '%'); $query->where('(a.title LIKE ' . $search . ' OR a.alias LIKE ' . $search . ')'); } } $sliderID = $this->getSliderID(); $query->where("a.sliderid='$sliderID'"); // Add the list ordering clause. $orderCol = $this->state->get('list.ordering'); $orderDirn = $this->state->get('list.direction'); $order = $orderCol; if (!empty($orderDirn)) $order .= " " . $orderDirn; if (!empty($orderCol)) $query->order($order); return $query; } /** * get items rewrited, add slider title to slide properties */ public function getItems() { $items = parent::getItems(); $arrSlidersAssoc = HelperUniteHCar::getArrSlidersAssoc(); foreach ($items as $key => $item) { if (!isset($arrSlidersAssoc[$item->sliderid])) throw new Exception("Slider with id: {$item->sliderid} not found"); $slider = $arrSlidersAssoc[$item->sliderid]; $items[$key]->slider_name = $slider["title"]; } return($items); } }