嗨我正在使用symfony 4和doctrine . 这是我的学说查询 .
public function paginationQueryByAttributes($attributes) {
$qb = $this->createQueryBuilder("c");
$qb->select('c');
if (array_key_exists('model_id', $attributes)) {
$qb->leftJoin('c.model', 'm.id');
$qb->andWhere('m.id = ' . $attributes['model_id']);
unset($attributes['model_id']);
} elseif (array_key_exists('brand_id', $attributes)) {
$qb->leftJoin('c.model', 'm');
}
}
这是我的车型 .
<?php
namespace App\Entity;
use App\Model\BaseCar;
use Doctrine\ORM\Mapping as ORM;
use Symfony\Bridge\Doctrine\Validator\Constraints\UniqueEntity;
use Symfony\Component\Validator\Constraints as Assert;
use Swagger\Annotations as SWG;
use JMS\Serializer\Annotation\Groups;
/**
* @ORM\Entity(repositoryClass="App\Repository\CarRepository")
* @UniqueEntity("id")
*/
class Car extends BaseCar
{
/**
* @ORM\ManyToOne(targetEntity="App\Entity\Model",cascade={"refresh","merge"}, inversedBy="cars")
* @ORM\JoinColumn(nullable=false)
*/
protected $model;
public function getModel()
{
return $this->model;
}
public /**
* @param $
*/function setModel( $model)
{
$this->model = $model;
return $this;
}
}
我像这样调用存储库，
$attributes = $request->request->all();
$query = $this->getDoctrine()
->getRepository(Car::class)
->paginationQueryByAttributes($attributes);
我收到了这个错误 .
[语法错误]第0行，第50列：错误：字符串的预期结束，得到' . '
这是查询......
SELECT c
FROM App\Entity\Car c
LEFT JOIN c.model m.id
LEFT JOIN m.brand b
WHERE m.id = 2
AND b.id = 1
AND c.code like :code
AND c.name like :name
1 回答
在您的加入
$qb->leftJoin('c.model', 'm.id');中，部分m.id现在是您的别名 . 将其更改为$qb->leftJoin('c.model', 'm');