diff options
Diffstat (limited to 'site/app/models/editor_subscription.php')
-rw-r--r-- | site/app/models/editor_subscription.php | 94 |
1 files changed, 94 insertions, 0 deletions
diff --git a/site/app/models/editor_subscription.php b/site/app/models/editor_subscription.php new file mode 100644 index 0000000..76dbe2f --- /dev/null +++ b/site/app/models/editor_subscription.php @@ -0,0 +1,94 @@ +<?php +/* ***** BEGIN LICENSE BLOCK ***** + * Version: MPL 1.1/GPL 2.0/LGPL 2.1 + * + * The contents of this file are subject to the Mozilla Public License Version + * 1.1 (the "License"); you may not use this file except in compliance with + * the License. You may obtain a copy of the License at + * http://www.mozilla.org/MPL/ + * + * Software distributed under the License is distributed on an "AS IS" basis, + * WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License + * for the specific language governing rights and limitations under the + * License. + * + * The Original Code is addons.mozilla.org site. + * + * The Initial Developer of the Original Code is + * Frederic Wenzel <fwenzel@mozilla.com> + * Portions created by the Initial Developer are Copyright (C) 2009 + * the Initial Developer. All Rights Reserved. + * + * Contributor(s): + * + * Alternatively, the contents of this file may be used under the terms of + * either the GNU General Public License Version 2 or later (the "GPL"), or + * the GNU Lesser General Public License Version 2.1 or later (the "LGPL"), + * in which case the provisions of the GPL or the LGPL are applicable instead + * of those above. If you wish to allow use of your version of this file only + * under the terms of either the GPL or the LGPL, and not to allow others to + * use your version of this file under the terms of the MPL, indicate your + * decision by deleting the provisions above and replace them with the notice + * and other provisions required by the GPL or the LGPL. If you do not delete + * the provisions above, a recipient may use your version of this file under + * the terms of any one of the MPL, the GPL or the LGPL. + * + * ***** END LICENSE BLOCK ***** */ + +class EditorSubscription extends AppModel +{ + var $name = 'EditorSubscription'; + var $useTable = 'editor_subscriptions'; + var $belongsTo = array('Addon', 'User'); + + var $recursive = -1; + + /** + * Sign editor up for an email the next time an add-on is updated. + * @param int $userid User's ID to be signed up for the next update + * @param int $addonid Addon's ID to subscribe the user to + * @return void + */ + function subscribeToUpdates($userid, $addonid) { + $this->query(" + INSERT INTO editor_subscriptions + SET + user_id = '{$userid}', + addon_id = '{$addonid}';"); + } + + /** + * Do not notify editor the next time an add-on is updated. + * @param int $userid User's ID to be signed up for the next update + * @param int $addonid Addon's ID to subscribe the user to + * @return void + */ + function cancelUpdates($userid, $addonid) { + $this->query(" + DELETE FROM editor_subscriptions + WHERE + user_id = '{$userid}' AND + addon_id = '{$addonid}';"); + } + + /** + * get list of subscribers for a given add-on + * @param int $addonid ID of the add-on whose subscribers are required + * @return array user IDs for all subscribers of the add-on + */ + function getSubscribers($addonid) { + $_result = $this->query(" + SELECT user_id + FROM editor_subscriptions + WHERE addon_id = '{$addonid};'"); + if (empty($_result)) return array(); + + $_ids = array(); + foreach ($_result as &$_id) { + $_ids[] = $_id['editor_subscriptions']['user_id']; + } + + return $_ids; + } +} +?> |