/**
* @param Mana_Db_Model_Formula_Context $context
* @param Mana_Db_Model_Formula_Expr[] $args
* @throws Mana_Db_Exception_Formula
* @throws Exception
* @return Mana_Db_Model_Formula_Expr
*/
public function select($context, $args)
{
if (count($args) != 3) {
throw new Mana_Db_Exception_Formula($this->__("Function '%s' expects three parameters", $this->getName()));
}
if ($args[0]->getIsAggregate()) {
throw new Mana_Db_Exception_Formula($this->__("You can only use aggregate function on aggregate fields"));
}
/* @var $helper Mana_Db_Helper_Formula_Selector */
$helper = $context->getHelper();
/* @var $formulaHelper Mana_Db_Helper_Formula */
$formulaHelper = Mage::helper('mana_db/formula');
$condition = $args[0]->getExpr();
switch ($formulaHelper->getType($args[0]->getType())) {
case 'string':
$condition .= "<> ''";
break;
case 'int':
$condition .= "<> 0";
break;
case 'bool':
break;
default:
throw new Exception('Not implemented');
}
$helper->binaryCast($args[1], $args[2]);
return $helper->expr()->setExpr("IF({$condition}, {$args[1]->getExpr()}, {$args[2]->getExpr()})")->setType($args[1]->getType());
}
/**
* @param Mana_Db_Model_Formula_Context $context
* @param Mana_Db_Model_Formula_Expr[] $args
* @throws Mana_Db_Exception_Formula
* @return Mana_Db_Model_Formula_Expr
*/
public function select($context, $args)
{
if (count($args) != 1) {
throw new Mana_Db_Exception_Formula($this->__("Function '%s' expects one parameter", $this->getName()));
}
if ($args[0]->getIsAggregate()) {
throw new Mana_Db_Exception_Formula($this->__("You can only use aggregate function on aggregate fields"));
}
$helper = $context->getHelper();
return $helper->expr()->setExpr("LOWER({$helper->cast($args[0], 'varchar(255)')->getExpr()})")->setType('varchar(255)');
}
/**
* @param Mana_Db_Model_Formula_Context $context
* @param Mana_Db_Model_Formula_Expr[] $args
* @throws Mana_Db_Exception_Formula
* @return Mana_Db_Model_Formula_Expr
*/
public function select($context, $args)
{
if (count($args) != 1) {
throw new Mana_Db_Exception_Formula($this->__("Function '%s' expects one parameter", $this->getName()));
}
if ($args[0]->getIsAggregate()) {
throw new Mana_Db_Exception_Formula($this->__("You can only use aggregate function on aggregate fields"));
}
$helper = $context->getHelper();
$urlConstant = str_replace('\'', '\\\'', substr($args[0]->getExpr(), 1, strlen($args[0]->getExpr())));
return $helper->expr()->setExpr("'{{= {$this->getName()}(\\'{$urlConstant}\\')'")->setType('varchar(255)');
}
/**
* @param Mana_Db_Model_Formula_Context $context
* @param Mana_Db_Model_Formula_Expr[] $args
* @throws Mana_Db_Exception_Formula
* @return Mana_Db_Model_Formula_Expr
*/
public function select($context, $args)
{
/* @var $formulaHelper Mana_Db_Helper_Formula */
$formulaHelper = Mage::helper('mana_db/formula');
if (count($args) < 2 || count($args) > 3) {
throw new Mana_Db_Exception_Formula($this->__("Function '%s' expects 2 or 3 parameters", $this->getName()));
}
if (!$args[0]->getIsAggregate()) {
throw new Mana_Db_Exception_Formula($this->__("Function '%s' expects 1 parameter to be a field of aggregate entity", $this->getName()));
}
$helper = $context->getHelper();
$sep = $helper->cast($args[1], 'varchar (255)')->getExpr();
$lastSep = count($args) == 3 ? $helper->cast($args[2], 'varchar (255)')->getExpr() : '';
if ($args[0]->getSubSelect()) {
$field = $helper->cast($args[0], 'varchar (255)')->getFieldExpr();
if (count($args) == 3) {
$expr = "IF (COUNT({$args[0]->getFieldExpr()}) > 1, " . "REPLACE(CONCAT(" . "SUBSTRING_INDEX(GROUP_CONCAT({$field} SEPARATOR '{$this->_separator}'), " . "'{$this->_separator}', COUNT({$field}) - 1), " . "{$lastSep}, " . "SUBSTRING_INDEX(GROUP_CONCAT({$field} SEPARATOR '{$this->_separator}'), " . "'{$this->_separator}', -1)" . "), '{$this->_separator}', {$sep}), " . "GROUP_CONCAT({$field} SEPARATOR {$sep})" . ")";
} else {
$expr = "GROUP_CONCAT({$field} SEPARATOR {$sep})";
}
return $helper->expr()->setExpr("({$args[0]->getSubSelect()->columns($expr)})")->setType('varchar(255)');
} else {
$expr = '';
$fieldExpr = $args[0]->getFieldExpr();
foreach ($fieldExpr as $index => $field) {
$nextField = isset($fieldExpr[$index + 1]) ? $fieldExpr[$index + 1] : '';
if ($expr) {
if (count($args) == 3) {
if ($nextField) {
$expr .= ", IF ({$field} IS NULL, '', CONCAT(IF ({$nextField} IS NULL, {$lastSep}, {$sep}), {$field}))";
} else {
$expr .= ", IF ({$field} IS NULL, '', CONCAT({$lastSep}, {$field}))";
}
} else {
$expr .= ", IF ({$field} IS NULL, '', CONCAT({$sep}, {$field}))";
}
} else {
$expr .= "COALESCE({$helper->cast($args[0]->setExpr($field), 'varchar (255)')->getExpr()}, '')";
}
}
$expr = "CONCAT({$expr})";
return $helper->expr()->setExpr($expr)->setType('varchar(255)');
}
}
/**
* @param Mana_Db_Model_Formula_Context $context
* @param Mana_Db_Model_Formula_Expr[] $args
* @throws Mana_Db_Exception_Formula
* @return Mana_Db_Model_Formula_Expr
*/
public function select($context, $args)
{
if (count($args) != 1) {
throw new Mana_Db_Exception_Formula($this->__("Function '%s' expects one parameter", $this->getName()));
}
if (!$args[0]->getIsAggregate()) {
throw new Mana_Db_Exception_Formula($this->__("Function '%s' expects 1 parameter to be a field of aggregate entity", $this->getName()));
}
$helper = $context->getHelper();
if ($args[0]->getSubSelect()) {
$expr = "COUNT({$args[0]->getFieldExpr()})";
return $helper->expr()->setExpr("({$args[0]->getSubSelect()->columns($expr)})")->setType('int');
} else {
$expr = '';
$fieldExpr = $args[0]->getFieldExpr();
foreach ($fieldExpr as $field) {
if ($expr) {
$expr .= " + ";
}
$expr .= "IF ({$field} IS NULL, 0, 1)";
}
return $helper->expr()->setExpr($expr)->setType('int');
}
}
