mysql - 调用未定义的方法 Doctrine\ORM\QueryBuilder::limit()

Question

调用未定义的方法Doctrine\ORM\QueryBuilder::limit()

我搜索了相关查询但没有得到结果

public function getAllCTCCompensationData($ouCode,$langCode)
    { 
    $queryBuilder = $this->entityManager->createQueryBuilder();
    $queryBuilder->select('ppp.payperiodSdesc, ppesa.grossPay, pptpp.pfEmployerContribution, pptpp.esiEmployerContribution, pplw.employercontribution')
        ->from(PyProcessEmpStatusApproved::class, 'ppesa')
        ->leftJoin(PyProcessTdsPfPt::class, 'pptpp', 'with', 'ppesa.ouCode = pptpp.ouCode')
        ->leftJoin(PyPayGroup::class, 'ppg', 'with', 'pptpp.pgCode = ppg.pgCode')
        ->leftJoin(PyProcessLabourWelfare::class, 'pplw', 'with', 'ppg.pgCode = pplw.pgCode')
        ->leftJoin(PyPayPeriod::class,'ppp','with','pplw.payperiodCode = ppp.payperiodCode')
        ->leftJoin(PyPayrollCalendar::class, 'ppc', 'with', 'ppp.paycalCode = ppc.paycalCode')
                ->where('ppesa.ouCode = ?1')
                ->andWhere('ppesa.langCode = ?2')
                ->setParameter('1','ouCode')
                ->setParameter('2','langCode')
                ->where('ppesa.ouCode','DESC')
                ->limit(20);

    $compData  = $queryBuilder->getQuery()->getResult();

    return $compData;

我想在查询中应用限制条件。如何对查询应用限制？

请使用此链接 https://www.doctrine-project.org/projects/doctrine1/en/latest/manual/dql-doctrine-query-language.html#limit-and-offset-clauses 作为引用

为什么说未定义的方法限制？

Answer 1

在 limit 之前使用 orderBy ，我认为这是错误。

public function getAllCTCCompensationData($ouCode,$langCode)
{ 
    $queryBuilder = $this->entityManager->createQueryBuilder();
    $queryBuilder->select('ppp.payperiodSdesc, ppesa.grossPay, pptpp.pfEmployerContribution, pptpp.esiEmployerContribution, pplw.employercontribution')
        ->from(PyProcessEmpStatusApproved::class, 'ppesa')
        ->leftJoin(PyProcessTdsPfPt::class, 'pptpp', 'with', 'ppesa.ouCode = pptpp.ouCode')
        ->leftJoin(PyPayGroup::class, 'ppg', 'with', 'pptpp.pgCode = ppg.pgCode')
        ->leftJoin(PyProcessLabourWelfare::class, 'pplw', 'with', 'ppg.pgCode = pplw.pgCode')
        ->leftJoin(PyPayPeriod::class,'ppp','with','pplw.payperiodCode = ppp.payperiodCode')
        ->leftJoin(PyPayrollCalendar::class, 'ppc', 'with', 'ppp.paycalCode = ppc.paycalCode')
                ->where('ppesa.ouCode = ?1')
                ->andWhere('ppesa.langCode = ?2')
                ->setParameter('1','ouCode')
                ->setParameter('2','langCode')
                ->orderBy('ppesa.ouCode','DESC')
                ->limit(20);

    $compData  = $queryBuilder->getQuery()->getResult();

    return $compData;
}