public function findRetardDePaiementBySociete(Societe $societe, $nbJourSeuil = 0) { $jour = new \DateTime(); $jour->modify("-" . $nbJourSeuil . " days"); $q = $this->createQueryBuilder(); $q->field('numeroFacture')->notEqual(null); $q->field('societe')->equals($societe->getId()); $q->field('cloture')->equals(false); $q->field('montantTTC')->gt(0.0); $q->field('avoir')->equals(null); $q->field('dateLimitePaiement')->lt($jour)->sort('dateFacturation', 'asc'); $query = $q->getQuery(); return $query->execute(); }