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