Вкладки и сортировка таблицы с БД - K2

public function getPrices()
{
        // Get a storage key.
       // $store = $this->_getStoreId();
 
        // Try to load the data from internal storage.
        if (!empty($this->_cache[$store])) {
                return $this->_cache[$store];
        }
 $id = $this->getState('hotel.id');
$db=JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('pr.rid,pr.hid,pr.pid,pr.one_man,pr.two_man,pr.three_man,pr.four_man,pr.all_room,pr.child,pr.extra_bed,pr.sale,pr.nutrition');
$query->order('pr.one_man');
$query->from('#__hbm_prices as pr');
$query->where('pr.hid='.$id) ;
$this->prices= $this->_getList((string) $query, $this->getState('list.start'), $this->getState('list.limit'));
 
        // Check for a database error.
        if ($this->_db->getErrorNum()) {
                $this->setError($this->_db->getErrorMsg());
                return false;
        }
 
        // Add the items to the internal cache.
      //  $this->_cache[$store] = $this->prices;
 
        return $this->prices;
}