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