php的select case语句,php – 在Doctrine select语句中使用’case when’

我在这里遇到了同样的问题.我的项目非常陈旧,并试图快速修复它.所以我只需更改Doctrine的代码,以便我可以使用“case when”.这是我的Doctrine 1.1.3代码.

Doctrine / Query.php,将行从658更改为674：

if (count($terms) > 1 || $pos !== false) {

if($terms[0]=='case')

{

$terms=explode(" as ", $reference);

$expression = array_shift($terms);

$alias = array_pop($terms);

if ( ! $alias) {

$alias = substr($expression, 0, $pos);

}

$componentAlias = $this->getExpressionOwner($expression);

$tableAlias = $this->getTableAlias($componentAlias);

$expression=str_replace($componentAlias, $tableAlias, $expression);

$index=0;

$sqlAlias = $tableAlias . '__' . $alias;

}

else

{

$expression = array_shift($terms);

$alias = array_pop($terms);

if ( ! $alias) {

$alias = substr($expression, 0, $pos);

}

$componentAlias = $this->getExpressionOwner($expression);

$expression = $this->parseClause($expression);

$tableAlias = $this->getTableAlias($componentAlias);

$index = count($this->_aggregateAliasMap);

$sqlAlias = $this->_conn->quoteIdentifier($tableAlias . '__' . $index);

}

$this->_sqlParts['select'][] = $expression . ' AS ' . $sqlAlias;

这不是一个很大的改变,但它帮助了我……