Changeset 48096 in spip-zone

Timestamp:

May 25, 2011, 1:55:02 PM (8 years ago)

Author:

esj@…

Message:

Associaspip Dans le reçu fiscal, compter aussi les dons, pas seulement les cotisations.

File:

• _plugins_/Association/Associaspip/exec/pdf_fiscal.php (modified) (1 diff)

_plugins_/Association/Associaspip/exec/pdf_fiscal.php

@@ -44 +44 @@
                 if (!preg_match('/^\d{4}$/', $annee)) $annee = date('Y') - 1;
                 $montants = sql_getfetsel('SUM(recette) AS montant', "spip_asso_comptes", "id_journal=$id_auteur AND vu AND date_format( date, '%Y' ) = $annee AND imputation=" . sql_quote($GLOBALS['association_metas']['pc_cotisations']));
+
+                $montants += sql_getfetsel('sum(D.argent) AS montant',
+                                      "spip_asso_dons AS D LEFT JOIN spip_asso_comptes AS C ON C.id_journal=D.id_don",
+                                      'C.imputation=' . sql_quote($GLOBALS['association_metas']['pc_dons']) . " AND C.vu AND date_format( D.date_don, '%Y' ) = $annee AND id_adherent=$id_auteur");
+
                 if (!$montants)
                   {echo "Versement en $annee pour l'adherent de mail $mail: $montants";}