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; }