/** * Applying order by create datetime and limitation to one record. * * @param Varien_Db_Select $select * @return Varien_Db_Select */ protected function _addSingleLimitation($select) { $select->order($this->getMainTable() . '.created_at ' . Varien_Db_Select::SQL_DESC)->limit(1); return $select; }
/** * Adds order by random to select object * Possible using integer field for optimization * * @param Varien_Db_Select $select * @param string $field * @return Varien_Db_Adapter_Pdo_Mysql */ public function orderRand(Varien_Db_Select $select, $field = null) { if ($field !== null) { $expression = new Zend_Db_Expr(sprintf('RAND() * %s', $this->quoteIdentifier($field))); $select->columns(array('mage_rand' => $expression)); $spec = new Zend_Db_Expr('mage_rand'); } else { $spec = new Zend_Db_Expr('RAND()'); } $select->order($spec); return $this; }
/** * Order by qty * * @param Varien_Db_Select $select * @return Varien_Db_Select */ protected function _loadPriceDataSelect($select) { $select->order('qty'); return $select; }