public function setUp()
{
$this->commande = new Commande(1, new Utilisateur(1, 'Kévin', 'Turmel', '26C Rue Pierre Brossolette', 53100, 'Mayenne', 'kdsjglkjdfklsjdfcgbnliuez', '*****@*****.**', 150), date('Y-m-d'));
$articles = new Collection();
$article = new Article();
$article->setDescription('Bonjour')->setDesignation('ArticleTest 1')->setNumArt(2)->setPu(35)->setQte(5)->setQteStock(30)->setUrl('test');
$articles->ajouter($article);
$article2 = new Article();
$article2->setDescription('Bo2')->setDesignation('ArticleTest 2')->setNumArt(1)->setPu(800)->setQte(8)->setQteStock(90)->setUrl('test');
$articles->ajouter($article2);
$this->commande->setLesArticles($articles);
}
/**
* Récupère les commandes dont l'utilisateur est passé en paramètre.
*
* @param Utilisateur $unClient
* @param bool $index
*
* @return Collection $lesCommandes
*
* @throws CollectionException
* @throws ErrorSQLException
*/
public static function getCommandes(Utilisateur $unClient, $index = false)
{
$lesCommandes = new Collection();
try {
$conn = MConnexion::getBdd();
$req = !$index ? $conn->prepare('SELECT * FROM commande WHERE numClt = ? ORDER BY date DESC') : $conn->prepare('SELECT * FROM commande WHERE numClt = ? ORDER BY date DESC LIMIT 2');
$req->execute(array($unClient->getId()));
$req = $req->fetchAll();
foreach ($req as $tabs) {
$uneCommande = new Commande($tabs['numCde'], $unClient, $tabs['date'], $tabs['pointsUtilise']);
$uneCommande->setLesArticles(MCommander::getUneCommande($uneCommande));
$lesCommandes->ajouter($uneCommande);
}
} catch (PDOException $e) {
throw new ErrorSQLException($e->getMessage());
}
return $lesCommandes;
}
