コード例 #1
0
ファイル: FactureRepository.php プロジェクト: 24eme/aurouze
 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();
 }