/**
* @name operationAttenteAssociation($pTypePaiement)
* @return array(OperationDetailVO) ou false en erreur
* @desc Retourne l'ensemble des des opérations pour le comtpe association non pointées
*/
public static function operationAttenteAssociation($pTypePaiement)
{
// Initialisation du Logger
$lLogger =& Log::singleton('file', CHEMIN_FICHIER_LOGS);
$lLogger->setMask(Log::MAX(LOG_LEVEL));
$lRequete = "SELECT " . AdherentManager::CHAMP_ADHERENT_ID . "," . AdherentManager::CHAMP_ADHERENT_NUMERO . "," . AdherentManager::CHAMP_ADHERENT_NOM . "," . AdherentManager::CHAMP_ADHERENT_PRENOM . "," . CompteManager::CHAMP_COMPTE_LABEL . "," . CompteManager::CHAMP_COMPTE_SOLDE . "," . OperationManager::CHAMP_OPERATION_MONTANT . "," . OperationManager::CHAMP_OPERATION_TYPE_PAIEMENT . "," . OperationManager::CHAMP_OPERATION_DATE . "," . OperationManager::CHAMP_OPERATION_LIBELLE . "," . OperationManager::CHAMP_OPERATION_ID . "," . OperationChampComplementaireManager::CHAMP_OPERATIONCHAMPCOMPLEMENTAIRE_CHCP_ID . "," . OperationChampComplementaireManager::CHAMP_OPERATIONCHAMPCOMPLEMENTAIRE_VALEUR . "," . OperationRemiseChequeManager::CHAMP_OPERATIONREMISECHEQUE_ID_REMISE_CHEQUE . ',' . RemiseChequeManager::CHAMP_REMISECHEQUE_NUMERO . "\n\t\tFROM " . OperationManager::TABLE_OPERATION . "\n\t\tLEFT JOIN " . OperationChampComplementaireManager::TABLE_OPERATIONCHAMPCOMPLEMENTAIRE . "\n\t\tON " . OperationChampComplementaireManager::CHAMP_OPERATIONCHAMPCOMPLEMENTAIRE_OPE_ID . " = " . OperationManager::CHAMP_OPERATION_ID . "\n\t\tLEFT JOIN " . OperationRemiseChequeManager::TABLE_OPERATIONREMISECHEQUE . " \n\t\t\tON " . OperationRemiseChequeManager::CHAMP_OPERATIONREMISECHEQUE_ID_OPERATION . " = " . OperationManager::CHAMP_OPERATION_ID . "\n\t\t\tAND " . OperationRemiseChequeManager::CHAMP_OPERATIONREMISECHEQUE_ETAT . " = 0\n\t\tLEFT JOIN " . AdhesionAdherentManager::TABLE_ADHESIONADHERENT . "\n\t\tON " . AdhesionAdherentManager::CHAMP_ADHESIONADHERENT_ID_OPERATION . " = " . OperationManager::CHAMP_OPERATION_ID . "\n\t\tLEFT JOIN " . AdherentManager::TABLE_ADHERENT . "\n\t\tON " . AdherentManager::CHAMP_ADHERENT_ID . " = " . AdhesionAdherentManager::CHAMP_ADHESIONADHERENT_ID_ADHERENT . "\n\t\tLEFT JOIN " . CompteManager::TABLE_COMPTE . "\n\t\tON " . AdherentManager::CHAMP_ADHERENT_ID_COMPTE . " = " . CompteManager::CHAMP_COMPTE_ID . "\n\t\tJOIN " . TypePaiementManager::TABLE_TYPEPAIEMENT . "\n\t\tON " . OperationManager::CHAMP_OPERATION_TYPE_PAIEMENT . " = " . TypePaiementManager::CHAMP_TYPEPAIEMENT_ID . "\n\t\tLEFT JOIN " . RemiseChequeManager::TABLE_REMISECHEQUE . "\n\t\t\tON " . OperationRemiseChequeManager::CHAMP_OPERATIONREMISECHEQUE_ID_REMISE_CHEQUE . " = " . RemiseChequeManager::CHAMP_REMISECHEQUE_ID . "\n\t\tWHERE " . OperationManager::CHAMP_OPERATION_TYPE . " = 0\n\t\tAND " . OperationManager::CHAMP_OPERATION_ID_COMPTE . " = -4\n\t\tAND " . OperationManager::CHAMP_OPERATION_TYPE_PAIEMENT . " = '" . StringUtils::securiser($pTypePaiement) . "'\n\t\tGROUP BY " . OperationManager::CHAMP_OPERATION_ID . ", " . OperationChampComplementaireManager::CHAMP_OPERATIONCHAMPCOMPLEMENTAIRE_CHCP_ID . "\n\t\tORDER BY " . OperationManager::CHAMP_OPERATION_DATE . ";";
$lLogger->log("Execution de la requete : " . $lRequete, PEAR_LOG_DEBUG);
// Maj des logs
$lSql = Dbutils::executerRequete($lRequete);
$lListeOperationAttente = array();
$lChampComplementaire = array();
if (mysql_num_rows($lSql) > 0) {
$lOpeId = NULL;
while ($lLigne = mysql_fetch_assoc($lSql)) {
if ($lOpeId != $lLigne[OperationManager::CHAMP_OPERATION_ID]) {
if (!is_null($lOpeId)) {
$lOperationAttente->setOpeTypePaiementChampComplementaire($lChampComplementaire);
$lListeOperationAttente[$lOpeId] = $lOperationAttente;
}
$lOpeId = $lLigne[OperationManager::CHAMP_OPERATION_ID];
$lOperationAttente = OperationManager::remplirOperationAttenteAdherentEntete($lLigne[AdherentManager::CHAMP_ADHERENT_ID], $lLigne[AdherentManager::CHAMP_ADHERENT_NUMERO], $lLigne[AdherentManager::CHAMP_ADHERENT_NOM], $lLigne[AdherentManager::CHAMP_ADHERENT_PRENOM], $lLigne[CompteManager::CHAMP_COMPTE_LABEL], $lLigne[CompteManager::CHAMP_COMPTE_SOLDE], $lLigne[OperationManager::CHAMP_OPERATION_MONTANT], $lLigne[OperationManager::CHAMP_OPERATION_TYPE_PAIEMENT], $lLigne[OperationManager::CHAMP_OPERATION_DATE], $lLigne[OperationManager::CHAMP_OPERATION_LIBELLE], $lLigne[OperationManager::CHAMP_OPERATION_ID], $lLigne[OperationRemiseChequeManager::CHAMP_OPERATIONREMISECHEQUE_ID_REMISE_CHEQUE], $lLigne[RemiseChequeManager::CHAMP_REMISECHEQUE_NUMERO]);
}
if (!is_null($lLigne[OperationChampComplementaireManager::CHAMP_OPERATIONCHAMPCOMPLEMENTAIRE_CHCP_ID])) {
$lChampComplementaire[$lLigne[OperationChampComplementaireManager::CHAMP_OPERATIONCHAMPCOMPLEMENTAIRE_CHCP_ID]] = OperationManager::remplirOperationDetail(NULL, NULL, NULL, NULL, NULL, $lLigne[OperationChampComplementaireManager::CHAMP_OPERATIONCHAMPCOMPLEMENTAIRE_CHCP_ID], NULL, NULL, NULL, $lLigne[OperationManager::CHAMP_OPERATION_ID], $lLigne[OperationChampComplementaireManager::CHAMP_OPERATIONCHAMPCOMPLEMENTAIRE_VALEUR]);
}
}
$lOperationAttente->setOpeTypePaiementChampComplementaire($lChampComplementaire);
$lListeOperationAttente[$lOpeId] = $lOperationAttente;
} else {
$lListeOperationAttente[0] = new OperationAttenteAdherentVO();
}
return $lListeOperationAttente;
}
