Symfony2，学说自定义DQL函数

Question

我在Doctrine中创建了一个自定义的'REPLACE'函数。但是当我使用它时，我有一个错误。

$result->andWhere("replace(weight,X,C) <= :weight_from")
       ->setParameter('weight_from',$data['weight_from']);

替换功能：

namespace DoctrineORMQueryASTFunctions;
use DoctrineORMQueryLexer;
/**
 * "REPLACE" "(" StringPrimary "," StringSecondary "," StringThird ")"
 *
 * 
 * @link    www.prohoney.com
 * @since   2.0
 * @author  Igor Aleksejev
 */
class ReplaceFunction extends FunctionNode {
    public $stringPrimary;
    public $stringSecondary;
    public $stringThird;
    /**
     * @override
     */
    public function getSql(DoctrineORMQuerySqlWalker $sqlWalker) {
        return $sqlWalker->getConnection()->getDatabasePlatform()->getReplaceExpression(
                        $this->stringPrimary, $this->stringSecondary, $this->stringThird
        );
    }
    /**
     * @override
     */
    public function parse(DoctrineORMQueryParser $parser) {
        $parser->match(Lexer::T_IDENTIFIER);
        $parser->match(Lexer::T_OPEN_PARENTHESIS);
        $this->stringPrimary = $parser->StringPrimary();
        $parser->match(Lexer::T_COMMA);
        $this->stringSecondary = $parser->StringPrimary();
        $parser->match(Lexer::T_COMMA);
        $this->stringThird = $parser->StringPrimary();
        $parser->match(Lexer::T_CLOSE_PARENTHESIS);
    }
}

AbstracPlatfrom.php包含：

/**
 * Returns the replace of a text field.
 *
 * @param string $column
 * @param string $x
 * @param string $y
 *
 * @return string
 */
public function getReplaceExpression($column,$x,$y)
{
    return "REPLACE($column,'$x','$y')";
} 

错误：

[
   {
      "message":"[Syntax Error] line 0, col 103: Error: Expected '.' or '(', got 'weight'",
      "class":"Doctrine\ORM\Query\QueryException",
      "trace":[
         {
            "namespace":"",
            "short_class":"",
            "class":"",
            "type":"",
            "function":"",
            "file":"C:\webserver\symfony\vendor\doctrine\orm\lib\Doctrine\ORM\Query\QueryException.php",
            "line":44,
            "args":[
            ]
         },
         {
            "namespace":"Doctrine\ORM\Query",
            "short_class":"QueryException",
            "class":"Doctrine\ORM\Query\QueryException",
            "type":"::",
            "function":"syntaxError",
            // ...

Answer 1

我遇到了类似的问题，我想您应该在表格字段"权重"中添加前缀（例如"a."）：

$result->andWhere("replace(a.weight,X,C) <= :weight_from")
   ->setParameter('weight_from',$data['weight_from']);