730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
|
$message .= "\n\n--\n".$config->get('nom_asso')."\n".$config->get('site_asso');
if ($dest == 0)
$where = 'id_categorie NOT IN (SELECT id FROM membres_categories WHERE cacher = 1)';
else
$where = 'id_categorie = '.(int)$dest;
if ($subscribed_only)
{
$where .= ' AND lettre_infos = 1';
}
$db = DB::getInstance();
$res = $db->query('SELECT email FROM membres WHERE LENGTH(email) > 0 AND '.$where.' ORDER BY id;');
$sujet = '['.$config->get('nom_asso').'] '.$sujet;
|
>
>
>
>
>
|
>
|
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
|
$message .= "\n\n--\n".$config->get('nom_asso')."\n".$config->get('site_asso');
if ($dest == 0)
$where = 'id_categorie NOT IN (SELECT id FROM membres_categories WHERE cacher = 1)';
else
$where = 'id_categorie = '.(int)$dest;
// FIXME: filtrage plus intelligent, car le champ lettre_infos peut ne pas exister
if ($subscribed_only)
{
$champs = Config::getInstance()->get('champs_membres');
if ($champs->get('lettre_infos'))
{
$where .= ' AND lettre_infos = 1';
}
}
$db = DB::getInstance();
$res = $db->query('SELECT email FROM membres WHERE LENGTH(email) > 0 AND '.$where.' ORDER BY id;');
$sujet = '['.$config->get('nom_asso').'] '.$sujet;
|