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