8b591f6298d78de1e35f525f58e619a2628388ba
2 /***************************************************************************
3 * Copyright (C) 2003-2009 Polytechnique.org *
4 * http://opensource.polytechnique.org/ *
6 * This program is free software; you can redistribute it and/or modify *
7 * it under the terms of the GNU General Public License as published by *
8 * the Free Software Foundation; either version 2 of the License, or *
9 * (at your option) any later version. *
11 * This program is distributed in the hope that it will be useful, *
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
14 * GNU General Public License for more details. *
16 * You should have received a copy of the GNU General Public License *
17 * along with this program; if not, write to the Free Software *
19 * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *
20 ***************************************************************************/
22 require_once("massmailer.inc.php");
24 class AXLetter
extends MassMailer
35 function __construct($id)
37 parent
::__construct('axletter/letter.mail.tpl', 'ax.css', 'ax/show', 'axletter', 'axletter_ins');
38 $this->_head
= '<cher> <prenom>,';
42 $res = XDB
::query("SELECT *
44 WHERE FIND_IN_SET('sent', bits)
47 $res = XDB
::query("SELECT *
49 WHERE id = {?} OR short_name = {?}", $id, $id);
51 if (!$res->numRows()) {
52 throw new MailNotFound();
54 $id = $res->fetchOneRow();
56 list($this->_id
, $this->_shortname
, $this->_title_mail
, $this->_title
,
57 $this->_body
, $this->_signature
, $this->_promo_min
, $this->_promo_max
,
58 $this->_subset
, $this->_echeance
, $this->_date
, $this->_bits
) = $id;
59 if ($this->_date
== '0000-00-00') {
64 protected function assignData(&$smarty)
66 $smarty->assign_by_ref('am', $this);
69 public function body($format)
71 return format_text($this->_body
, $format);
74 public function signature($format)
76 return format_text($this->_signature
, $format, 10);
79 public function valid()
81 return XDB
::execute("UPDATE axletter
83 WHERE id = {?}", $this->_id
);
86 public function invalid()
88 return XDB
::execute("UPDATE axletter
89 SET bits = 'invalid', date = CURDATE()
90 WHERE id = {?}", $this->_id
);
93 protected function setSent()
95 XDB
::execute("UPDATE axletter
96 SET bits='sent', date=CURDATE()
97 WHERE id={?}", $this->_id
);
100 protected function getAllRecipients()
103 return "SELECT ni.user_id, IF(ni.user_id = 0, NULL, u.hruid) AS hruid,
104 IF(ni.user_id = 0, ni.email, CONCAT(a.alias, '@{$globals->mail->domain}')) AS alias,
105 IF(ni.user_id = 0, ni.prenom, u.prenom) AS prenom,
106 IF(ni.user_id = 0, ni.nom, IF(u.nom_usage='', u.nom, u.nom_usage)) AS nom,
107 FIND_IN_SET('femme', IF(ni.user_id = 0, ni.flag, u.flags)) AS sexe,
108 IF(ni.user_id = 0, 'html', q.core_mail_fmt) AS pref,
109 IF(ni.user_id = 0, ni.hash, 0) AS hash
110 FROM axletter_ins AS ni
111 {$this->subsetJoin()}
112 LEFT JOIN auth_user_md5 AS u USING(user_id)
113 LEFT JOIN auth_user_quick AS q ON(q.user_id = u.user_id)
114 LEFT JOIN aliases AS a ON(u.user_id=a.id AND FIND_IN_SET('bestalias',a.flags))
115 LEFT JOIN emails AS e ON(e.uid=u.user_id AND e.flags='active')
116 WHERE ni.last < {?} AND {$this->subscriptionWhere()}
117 AND (e.email IS NOT NULL OR FIND_IN_SET('googleapps', u.mail_storage) OR ni.user_id = 0)
121 static public function subscriptionState($uid = null
)
123 $user = is_null($uid) ? S
::v('uid') : $uid;
124 $res = XDB
::query("SELECT 1
126 WHERE user_id={?}", $user);
127 return $res->fetchOneCell();
130 static public function unsubscribe($uid = null
, $hash = false
)
132 $user = is_null($uid) ? S
::v('uid') : $uid;
133 $field = !$hash ?
'user_id' : 'hash';
134 if (is_null($uid) && $hash) {
137 $res = XDB
::query("SELECT *
139 WHERE $field={?}", $user);
140 if (!$res->numRows()) {
143 XDB
::execute("DELETE FROM axletter_ins
144 WHERE $field = {?}", $user);
148 static public function subscribe($uid = null
)
150 $user = is_null($uid) ? S
::v('uid') : $uid;
151 XDB
::execute("REPLACE INTO axletter_ins (user_id,last)
152 VALUES ({?}, 0)", $user);
155 static public function hasPerms()
160 $res = XDB
::query("SELECT COUNT(*)
162 WHERE user_id = {?}", S
::i('uid'));
163 return ($res->fetchOneCell() > 0);
166 static public function grantPerms($uid)
168 if (!is_numeric($uid)) {
169 $res = XDB
::query("SELECT id FROM aliases WHERE alias = {?}", $uid);
170 $uid = $res->fetchOneCell();
175 return XDB
::execute("INSERT IGNORE INTO axletter_rights SET user_id = {?}", $uid);
178 static public function revokePerms($uid)
180 if (!is_numeric($uid)) {
181 $res = XDB
::query("SELECT id FROM aliases WHERE alias = {?}", $uid);
182 $uid = $res->fetchOneCell();
187 return XDB
::execute("DELETE FROM axletter_rights WHERE user_id = {?}", $uid);
190 protected function subsetJoin()
192 if ($this->_subset
) {
193 return "INNER JOIN axletter_subsets AS c ON (c.letter_id = ".XDB
::escape($this->_id
)." AND ni.user_id = c.uid)";
196 // TODO : force use of the adresses given by AX, not "canonical" ones
199 protected function subscriptionWhere()
201 if (!$this->_promo_min
&& !$this->_promo_max
) {
205 if ($this->_promo_min
) {
206 $where[] = "((ni.user_id = 0 AND ni.promo >= {$this->_promo_min}) OR (ni.user_id != 0 AND u.promo >= {$this->_promo_min}))";
208 if ($this->_promo_max
) {
209 $where[] = "((ni.user_id = 0 AND ni.promo <= {$this->_promo_max}) OR (ni.user_id != 0 AND u.promo <= {$this->_promo_max}))";
211 return implode(' AND ', $where);
214 static public function awaiting()
216 $res = XDB
::query("SELECT *
218 WHERE FIND_IN_SET('new', bits)");
219 if ($res->numRows()) {
220 return new AXLetter($res->fetchOneRow());
225 static public function toSend()
227 $res = XDB
::query("SELECT *
229 WHERE FIND_IN_SET('new', bits) AND echeance <= NOW() AND echeance != 0");
230 if ($res->numRows()) {
231 return new AXLetter($res->fetchOneRow());
236 static public function listSent()
238 $res = XDB
::query("SELECT IF(short_name IS NULL, id, short_name) as id, date, subject AS titre
240 WHERE NOT FIND_IN_SET('new', bits) AND NOT FIND_IN_SET('invalid', bits)
241 ORDER BY date DESC");
242 return $res->fetchAllAssoc();
245 static public function listAll()
247 $res = XDB
::query("SELECT IF(short_name IS NULL, id, short_name) as id, date, subject AS titre
249 ORDER BY date DESC");
250 return $res->fetchAllAssoc();
254 // vim:set et sw=4 sts=4 sws=4 enc=utf-8: