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