/** * @name select($pId, $pActive) * @param IdReservationVO * @param bool * @return ReservationVO * @desc Retourne une Reservation */ public function select($pId, $pActive = false) { $lOperations = $this->selectOperationReservation($pId, $pActive); $lReservation = new ReservationVO(); $lReservation->setId($pId); // Recherche du détail de la reservation $lDetailOperationService = new DetailOperationService(); $lStockService = new StockService(); if (!is_null($lOperations[0]->getTypePaiement())) { $lReservation->setEtat($lOperations[0]->getTypePaiement()); switch ($lOperations[0]->getTypePaiement()) { /* case 7: // Un achat foreach($lOperations as $lOperation) { if($lOperation->getTypePaiement() == 7) { // Mise à jour du détail de réservation à partir de l'historique du stock HistoriqueStockManager::selectReservation($lOperation->getId(), $lReservation); $lReservation->setTotal($lOperation->getMontant()); } } break;*/ case 22: // Reservation achetée // Reservation achetée case 0: // Reservation en cours $lOperation = $lOperations[0]; $lDetailsReservation = ReservationDetailViewManager::selectDetail($lOperation->getId(), 0, 0); foreach ($lDetailsReservation as $lDetail) { if ($lDetail->getDopeTypePaiement() == 0) { $lDetailReservation = new DetailReservationVO(); $lDetailReservation->getId()->setIdStock($lDetail->getStoId()); $lDetailReservation->getId()->setIdDetailOperation($lDetail->getDopeId()); $lDetailReservation->setIdDetailCommande($lDetail->getStoIdDetailCommande()); $lDetailReservation->setMontant($lDetail->getDopeMontant()); $lDetailReservation->setQuantite($lDetail->getStoQuantite()); $lDetailReservation->setIdProduit($lDetail->getDcomIdProduit()); $lDetailReservation->setIdNomProduit($lDetail->getDcomIdNomProduit()); $lDetailReservation->setUnite($lDetail->getStoUnite()); $lReservation->addDetailReservation($lDetailReservation); } } $lReservation->setTotal($lOperation->getMontant()); break; case 15: // Reservation non récupérée $lOperation = $lOperations[0]; $lDetailsReservation = ReservationDetailViewManager::selectDetail($lOperation->getId(), 15, 5); foreach ($lDetailsReservation as $lDetail) { if ($lDetail->getDopeTypePaiement() == 15) { $lDetailReservation = new DetailReservationVO(); $lDetailReservation->getId()->setIdStock($lDetail->getStoId()); $lDetailReservation->getId()->setIdDetailOperation($lDetail->getDopeId()); $lDetailReservation->setIdDetailCommande($lDetail->getStoIdDetailCommande()); $lDetailReservation->setMontant($lDetail->getDopeMontant()); $lDetailReservation->setQuantite($lDetail->getStoQuantite()); $lDetailReservation->setIdProduit($lDetail->getDcomIdProduit()); $lDetailReservation->setIdNomProduit($lDetail->getDcomIdNomProduit()); $lDetailReservation->setUnite($lDetail->getStoUnite()); $lReservation->addDetailReservation($lDetailReservation); } } $lReservation->setTotal($lOperation->getMontant()); break; case 16: // Reservation annulée $lOperation = $lOperations[0]; $lDetailsReservation = ReservationDetailViewManager::selectDetail($lOperation->getId(), 16, 6); foreach ($lDetailsReservation as $lDetail) { if ($lDetail->getDopeTypePaiement() == 16) { $lDetailReservation = new DetailReservationVO(); $lDetailReservation->getId()->setIdStock($lDetail->getStoId()); $lDetailReservation->getId()->setIdDetailOperation($lDetail->getDopeId()); $lDetailReservation->setIdDetailCommande($lDetail->getStoIdDetailCommande()); $lDetailReservation->setMontant($lDetail->getDopeMontant()); $lDetailReservation->setQuantite($lDetail->getStoQuantite()); $lDetailReservation->setIdProduit($lDetail->getDcomIdProduit()); $lDetailReservation->setIdNomProduit($lDetail->getDcomIdNomProduit()); $lDetailReservation->setUnite($lDetail->getStoUnite()); $lReservation->addDetailReservation($lDetailReservation); } } $lReservation->setTotal($lOperation->getMontant()); break; } } return $lReservation; }
/** * @name selectReservation($pIdOperation, &$pReservation) * @param integer * @param ReservationVO * @desc Récupère le détail d'une réservation (achetée) à partir de l'historique du stock */ public static function selectReservation($pIdOperation, &$pReservation) { // Initialisation du Logger $lLogger =& Log::singleton('file', CHEMIN_FICHIER_LOGS); $lLogger->setMask(Log::MAX(LOG_LEVEL)); $lRequete = "SELECT \n\t\t\t\t hStock." . HistoriqueStockManager::CHAMP_HISTORIQUESTOCK_STO_ID . ", hStock." . HistoriqueStockManager::CHAMP_HISTORIQUESTOCK_ID_DETAIL_COMMANDE . ", hStock." . HistoriqueStockManager::CHAMP_HISTORIQUESTOCK_QUANTITE . "," . DetailCommandeManager::CHAMP_DETAILCOMMANDE_ID_PRODUIT . " FROM " . HistoriqueStockManager::TABLE_HISTORIQUESTOCK . " as hStock " . "INNER JOIN (" . "SELECT max(" . HistoriqueStockManager::CHAMP_HISTORIQUESTOCK_DATE . ") as date" . "," . HistoriqueStockManager::CHAMP_HISTORIQUESTOCK_ID_DETAIL_COMMANDE . " FROM " . HistoriqueStockManager::TABLE_HISTORIQUESTOCK . " WHERE " . HistoriqueStockManager::CHAMP_HISTORIQUESTOCK_ID_OPERATION . " = " . $pIdOperation . " AND " . HistoriqueStockManager::CHAMP_HISTORIQUESTOCK_TYPE . " = 0 " . " GROUP BY " . HistoriqueStockManager::CHAMP_HISTORIQUESTOCK_ID_DETAIL_COMMANDE . ") gp " . " ON gp.date = hStock.hsto_date AND gp." . HistoriqueStockManager::CHAMP_HISTORIQUESTOCK_ID_DETAIL_COMMANDE . " = hStock." . HistoriqueStockManager::CHAMP_HISTORIQUESTOCK_ID_DETAIL_COMMANDE . " INNER JOIN " . DetailCommandeManager::TABLE_DETAILCOMMANDE . " ON " . DetailCommandeManager::CHAMP_DETAILCOMMANDE_ID . " = hStock." . HistoriqueStockManager::CHAMP_HISTORIQUESTOCK_ID_DETAIL_COMMANDE . " WHERE " . HistoriqueStockManager::CHAMP_HISTORIQUESTOCK_ID_OPERATION . " = " . $pIdOperation . " AND " . HistoriqueStockManager::CHAMP_HISTORIQUESTOCK_TYPE . " = 0;"; $lLogger->log("Execution de la requete : " . $lRequete, PEAR_LOG_DEBUG); // Maj des logs $lSql = Dbutils::executerRequete($lRequete); if (mysql_num_rows($lSql) > 0) { while ($lLigne = mysql_fetch_assoc($lSql)) { $lDetailReservation = new DetailReservationVO(); $lDetailReservation->getId()->setIdStock($lLigne[HistoriqueStockManager::CHAMP_HISTORIQUESTOCK_STO_ID]); $lDetailReservation->setIdDetailCommande($lLigne[HistoriqueStockManager::CHAMP_HISTORIQUESTOCK_ID_DETAIL_COMMANDE]); $lDetailReservation->setQuantite($lLigne[HistoriqueStockManager::CHAMP_HISTORIQUESTOCK_QUANTITE]); $lDetailReservation->setIdProduit($lLigne[DetailCommandeManager::CHAMP_DETAILCOMMANDE_ID_PRODUIT]); $pReservation->addDetailReservation($lDetailReservation); } } }