Changeset 48096 in spip-zone
- Timestamp:
- May 25, 2011, 1:55:02 PM (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
_plugins_/Association/Associaspip/exec/pdf_fiscal.php
r47177 r48096 44 44 if (!preg_match('/^\d{4}$/', $annee)) $annee = date('Y') - 1; 45 45 $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'])); 46 47 $montants += sql_getfetsel('sum(D.argent) AS montant', 48 "spip_asso_dons AS D LEFT JOIN spip_asso_comptes AS C ON C.id_journal=D.id_don", 49 '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"); 50 46 51 if (!$montants) 47 52 {echo "Versement en $annee pour l'adherent de mail $mail: $montants";}
Note: See TracChangeset
for help on using the changeset viewer.