/**
* 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;
}
