/* PrĂ©paration de la requĂȘte */
$select = "id_souscription, courriel, type_souscription,"
."montant, reglee, spip_transactions.statut, date_paiement, mode, autorisation_id,"
- ."nom, prenom, adresse, code_postal, ville, pays, telephone, recu_fiscal, envoyer_info, date_souscription,"
+ ."nom, prenom, adresse, code_postal, ville, pays, telephone, recu_fiscal, envoyer_info, informer_comite_local, date_souscription,"
."spip_souscription_campagnes.id_souscription_campagne, titre";
$from = "spip_souscriptions LEFT JOIN spip_transactions USING(id_transaction) LEFT JOIN spip_souscription_campagnes USING(id_souscription_campagne)";
if($statut) {
if($statut == "paye")
- $where[] = "reglee='oui'";
+ $where[] = "spip_transactions.statut='ok' and reglee='oui'";
elseif($statut == "commande")
$where[] = "spip_transactions.statut='commande'";
elseif($statut == "erreur")
_T("souscription:label_exporter_entete_telephone"),
_T("souscription:label_exporter_entete_recu_fiscal"),
_T("souscription:label_exporter_entete_informer"),
+ _T("souscription:label_exporter_entete_informer_comite_local"),
_T("souscription:label_exporter_entete_date_don"),
_T("souscription:label_exporter_entete_id_campagne"),
_T("souscription:label_exporter_entete_titre_campagne"));