/**
* 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();
}
