/** * Récupère les pleins d'un véhicule. * * @param Vehicule $vehicule * @param string $order 'ASC' (par défaut) ou 'DESC'. * * @return \Doctrine\Common\Collections\ArrayCollection */ public function findByVehicule(Vehicule $vehicule, $order = 'ASC') { $queryBuilder = $this->createQueryBuilder('p'); $vehiculeID = $vehicule->getId(); $queryBuilder->where('p.vehicule = :vehicule_id')->orderBy('p.date', $order)->setParameter(':vehicule_id', $vehiculeID); $pleins = $queryBuilder->getQuery()->getResult(); return $pleins; }
/** * {@inheritdoc} */ public function load(ObjectManager $manager) { // Chargement de la configuration $configurationLoader = $this->container->get('comptes_bundle.configuration.loader'); $fixturesConfiguration = $configurationLoader->load('fixtures.yml'); // Tableau de données $vehiculesContent = $fixturesConfiguration['vehicules']; foreach ($vehiculesContent as $vehiculeContent) { $vehicule = new Vehicule(); // Date d'achat if ($vehiculeContent['date_achat'] !== null) { $dateAchat = new \DateTime(); $dateAchat->setTimestamp($vehiculeContent['date_achat']); } else { $dateAchat = null; } // Date de vente if ($vehiculeContent['date_vente'] !== null) { $dateVente = new \DateTime(); $dateVente->setTimestamp($vehiculeContent['date_vente']); } else { $dateVente = null; } // Carburant $carburantID = $vehiculeContent['carburant']; $carburant = $this->getReference("carburant-{$carburantID}"); $vehicule->setNom($vehiculeContent['nom']); $vehicule->setDateAchat($dateAchat); $vehicule->setDateVente($dateVente); $vehicule->setKilometrageAchat($vehiculeContent['kilometrage_achat']); $vehicule->setKilometrageInitial($vehiculeContent['kilometrage_initial']); $vehicule->setPrixAchat($vehiculeContent['prix_achat']); $vehicule->setCarburant($carburant); $vehicule->setCapaciteReservoir($vehiculeContent['capacite_reservoir']); $vehicule->setRang($vehiculeContent['rang']); $manager->persist($vehicule); } $manager->flush(); }