X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Faxletter%2Faxletter.inc.php;h=e238c41e1ed89e199cc54029f3f5c5dc34fc780a;hb=f0b77ba6ee05dd28da60dc8b299fdd4a9fdca8bd;hp=eed37b61122c2f81d374b030da04189680eed1b0;hpb=4478f95efc07709dbe0a4415e979ff0347651cf8;p=platal.git diff --git a/modules/axletter/axletter.inc.php b/modules/axletter/axletter.inc.php index eed37b6..e238c41 100644 --- a/modules/axletter/axletter.inc.php +++ b/modules/axletter/axletter.inc.php @@ -1,6 +1,6 @@ numRows()) { - $this->_id = null; - return; + throw new MailNotFound(); } $id = $res->fetchOneRow(); } list($this->_id, $this->_shortname, $this->_title_mail, $this->_title, $this->_body, $this->_signature, $this->_promo_min, $this->_promo_max, - $this->_echeance, $this->_date, $this->_bits) = $id; + $this->_subset_to, $this->_echeance, $this->_date, $this->_bits) = $id; if ($this->_date == '0000-00-00') { $this->_date = 0; } + $this->_subset_to = explode("\n", $this->_subset_to); + $this->_subset = (count($this->_subset_to) > 0); } protected function assignData(&$smarty) @@ -153,13 +156,13 @@ class AXLetter extends MassMailer static public function hasPerms() { - if (S::has_perms()) { + if (S::admin()) { return true; } - $res = XDB::query("SELECT 1 + $res = XDB::query("SELECT COUNT(*) FROM axletter_rights WHERE user_id = {?}", S::i('uid')); - return $res->fetchOneCell(); + return ($res->fetchOneCell() > 0); } static public function grantPerms($uid) @@ -188,7 +191,7 @@ class AXLetter extends MassMailer protected function subscriptionWhere() { - if (!$this->_promo_min && !$this->_promo_max) { + if (!$this->_promo_min && !$this->_promo_max && !$this->_subset) { return '1'; } $where = array(); @@ -198,6 +201,17 @@ class AXLetter extends MassMailer if ($this->_promo_max) { $where[] = "((ni.user_id = 0 AND ni.promo <= {$this->_promo_max}) OR (ni.user_id != 0 AND u.promo <= {$this->_promo_max}))"; } + if ($this->_subset) { + require_once("emails.inc.php"); + $ids = ids_from_mails($this->_subset_to); + $ids_list = implode(',', $ids); + if(count($ids_list) > 0) { + $where[] = "ni.user_id IN ($ids_list)"; + } else { + // No valid email + $where[] = "0"; + } + } return implode(' AND ', $where); }