#HTTP_HEADER{Content-Type:Text/html;charset=#CHARSET} #CACHE{0} '0000-00-00 00:00:00' and YEAR(b.date) = YEAR('[(#ENV{date_liste})]') and MONTH(b.date) = MONTH('[(#ENV{date_liste})]') group by b.id_abonnement"); echo ""; echo "" ; echo ""; $query_n = spip_query ( "select b.id_abonnement from spip_abonnements a, spip_auteurs_elargis_abonnements b , spip_auteurs_elargis c where a.id_abonnement = b.id_abonnement and c.id = b.id_auteur_elargi and c.statut_paiement = 'ok' and b.validite <> '0000-00-00 00:00:00' and YEAR(b.date) = YEAR('[(#ENV{date_liste})]') and MONTH(b.date) = MONTH('[(#ENV{date_liste})]') " ); $n = spip_num_rows($query_n); echo ""; echo "" ; while ($row = spip_fetch_array($result)){ echo "" ; echo ""; echo "" ; $id_abonnement = $row['id_abonnement']; echo "" ; echo ""; echo "" ; $result_detail = spip_query("select a.*, b.date , b.validite from spip_auteurs_elargis a, spip_auteurs_elargis_abonnements b , spip_auteurs_elargis c where a.id = b.id_auteur_elargi and b.id_abonnement = $id_abonnement and c.id = b.id_auteur_elargi and c.statut_paiement = 'ok' and YEAR(b.date) = YEAR('[(#ENV{date_liste})]') and MONTH(b.date) = MONTH('[(#ENV{date_liste})]') ORDER BY b.date desc"); // et abo ok while ($row_detail = spip_fetch_array($result_detail)){ echo "" ; echo ""; echo ""; echo ""; echo ""; echo "" ; } } echo "" ; echo ""; echo "" ; echo "
[(#ENV{date_liste}|nom_mois)] [(#ENV{date_liste}|annee)] $n
".$row['libelle']."".$row['n']."
PrenomNomadressecode postalVillepaysdateexpire
".$row_detail['prenom']."".$row_detail['nom_famille']."".$row_detail['adresse']."".$row_detail['code_postal']."".$row_detail['ville']."".$row_detail['pays']."".jour($row_detail['date'])."/".mois($row_detail['date'])."/".annee($row_detail['date'])."".jour($row_detail['validite'])."/".mois($row_detail['validite'])."/".annee($row_detail['validite'])."
" ; ?>