Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on May 1st, 2012  |  syntax: None  |  size: 1.22 KB  |  hits: 19  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Get collection query string
  2. $collection = Mage::getModel('bannerslider/bannerslider')->getCollection()
  3.         ->addFieldToFilter('status',1)
  4.         ->addFieldToFilter('is_home',$this->_display)
  5.     ->addOrder('position', 'ASC')
  6.         ;
  7.        
  8. $collection->printLogQuery(true);
  9.  
  10. var_dump((string)$collection->getSelect());
  11.        
  12. SELECT `main_table`.* FROM `bannerslider` AS `main_table` WHERE (status = '1') AND (is_home = '0')
  13.        
  14. public function load($printQuery = false, $logQuery = false)
  15. {
  16.     // ... removed for brevity
  17.  
  18.     $this->_renderFilters()
  19.          ->_renderOrders()
  20.          ->_renderLimit();
  21.  
  22.     $this->printLogQuery($printQuery, $logQuery);
  23.     $data = $this->getData();
  24.  
  25.     // ... removed for brevity
  26. }
  27.        
  28. $collection = Mage::getModel('bannerslider/bannerslider')->getCollection()
  29.     ->addFieldToFilter('status',1)
  30.     ->addFieldToFilter('is_home',$this->_display)
  31.     ->addAtributeToSort('position', 'ASC');
  32.        
  33. $collection->setOrder('position', 'ASC'); // main order setter
  34. $collectioon->getSelect()->order('position asc'); // alternative order setter
  35.  
  36. $collection->load(); // some times you need to call load() to be sure your collection don't get changes later in some place
  37. echo $collection->getSelect(); // to print query