/**
* @name selectOperationAvenir($pIdCompte)
* @param integer
* @return array(OperationVO)
* @desc Récupères toutes les lignes de la table ayant pour IdCompte $pId pour les opérations de réservation. Puis les renvoie sous forme d'une collection de OperationDetailVO
*/
public static function selectOperationAvenir($pIdCompte)
{
// Initialisation du Logger
$lLogger =& Log::singleton('file', CHEMIN_FICHIER_LOGS);
$lLogger->setMask(Log::MAX(LOG_LEVEL));
$lRequete = "SELECT " . OperationManager::CHAMP_OPERATION_ID . "," . OperationManager::CHAMP_OPERATION_ID_COMPTE . "," . OperationManager::CHAMP_OPERATION_MONTANT . "," . OperationManager::CHAMP_OPERATION_LIBELLE . "," . OperationManager::CHAMP_OPERATION_DATE . "," . CommandeManager::CHAMP_COMMANDE_DATE_MARCHE_DEBUT . " FROM " . OperationManager::TABLE_OPERATION . " LEFT JOIN " . OperationChampComplementaireManager::TABLE_OPERATIONCHAMPCOMPLEMENTAIRE . " ON " . OperationChampComplementaireManager::CHAMP_OPERATIONCHAMPCOMPLEMENTAIRE_OPE_ID . " = " . OperationManager::CHAMP_OPERATION_ID . " AND " . OperationChampComplementaireManager::CHAMP_OPERATIONCHAMPCOMPLEMENTAIRE_CHCP_ID . " = 1 " . " LEFT JOIN " . CommandeManager::TABLE_COMMANDE . " ON " . CommandeManager::CHAMP_COMMANDE_ID . " = " . OperationChampComplementaireManager::CHAMP_OPERATIONCHAMPCOMPLEMENTAIRE_VALEUR . " WHERE " . OperationManager::CHAMP_OPERATION_ID_COMPTE . " = '" . StringUtils::securiser($pIdCompte) . "'\n\t\t\t AND " . OperationManager::CHAMP_OPERATION_TYPE_PAIEMENT . " = 0 \n\t\t\t AND " . CommandeManager::CHAMP_COMMANDE_ARCHIVE . " = 0 \n\t\t\t AND " . CommandeManager::CHAMP_COMMANDE_DATE_DEBUT_RESERVATION . " <= now() \n\t\t\t AND " . CommandeManager::CHAMP_COMMANDE_DATE_MARCHE_DEBUT . " >= now() \n\t\t ORDER BY " . CommandeManager::CHAMP_COMMANDE_DATE_MARCHE_DEBUT . ";";
$lLogger->log("Execution de la requete : " . $lRequete, PEAR_LOG_DEBUG);
// Maj des logs
$lSql = Dbutils::executerRequete($lRequete);
$lListeOperation = array();
if (mysql_num_rows($lSql) > 0) {
while ($lLigne = mysql_fetch_assoc($lSql)) {
array_push($lListeOperation, OperationManager::remplirOperationAvenir($lLigne[OperationManager::CHAMP_OPERATION_ID], $lLigne[OperationManager::CHAMP_OPERATION_ID_COMPTE], $lLigne[OperationManager::CHAMP_OPERATION_MONTANT], $lLigne[OperationManager::CHAMP_OPERATION_LIBELLE], $lLigne[OperationManager::CHAMP_OPERATION_DATE], $lLigne[CommandeManager::CHAMP_COMMANDE_DATE_MARCHE_DEBUT]));
}
} else {
$lListeOperation[0] = new OperationAvenirVO();
}
return $lListeOperation;
}
