where("item_id", $item_id) ->where("user_id", $user->id) ->find(); } static function is_watching($item, $user=null) { if (empty($user)) { $user = user::active(); } return ORM::factory("subscription") ->where("item_id", $item->id) ->where("user_id", $user->id) ->find() ->loaded; } static function add_watch($item, $user=null) { if ($item->is_album()) { if (empty($user)) { $user = user::active(); } $subscription = ORM::factory("subscription"); $subscription->item_id = $item->id; $subscription->user_id = $user->id; $subscription->save(); } } static function remove_watch($item, $user=null) { if ($item->is_album()) { if (empty($user)) { $user = user::active(); } $subscription = ORM::factory("subscription") ->where("item_id", $item->id) ->where("user_id", $user->id) ->find()->delete(); } } static function get_subscribers($item) { $users = ORM::factory("user") ->join("subscriptions", "users.id", "subscriptions.user_id") ->join("items", "subscriptions.item_id", "items.id") ->where("email IS NOT", null) ->where("items.left <=", $item->left) ->where("items.right >", $item->right) ->find_all(); $subscribers = array(); foreach ($users as $user) { $subscribers[] = $user->email; } return $subscribers; } static function send_item_updated($old, $new) { $body = new View("item_updated.html"); $body->old = $old; $body->new = $new; $body->subject = $old->is_album() ? t("Album %title updated", array("title" => $old->title)) : ($old->is_photo() ? t("Photo %title updated", array("title" => $old->title)) : t("Movie %title updated", array("title" => $old->title))); self::_notify_subscribers($old, $body, $body->subject); } static function send_item_add($item) { $body = new View("item_added.html"); $body->item = $item; $parent = $item->parent(); $subject = $item->is_album() ? t("Album %title added to %parent_title", array("title" => $item->title, "parent_title" => $parent->title)) : ($item->is_photo() ? t("Photo %title added to %parent_title", array("title" => $item->title, "parent_title" => $parent->title)) : t("Movie %title added to %parent_title", array("title" => $item->title, "parent_title" => $parent->title))); self::_notify_subscribers($item, $body, $subject); } static function send_batch_add($parent_id) { $parent = ORM::factory("item", $parent_id); if ($parent->loaded) { $body = new View("batch_add.html"); $body->item = $parent; $subject = t("Album %title updated", array("title" => $parent->title)); self::_notify_subscribers($parent, $body, $subject); } } static function send_item_deleted($item) { $body = new View("item_deleted.html"); $body->item = $item; $parent = $item->parent(); $subject = $item->is_album() ? t("Album %title removed from %parent_title", array("title" => $item->title, "parent_title" => $parent->title)) : ($item->is_photo() ? t("Photo %title removed from %parent_title", array("title" => $item->title, "parent_title" => $parent->title)) : t("Movie %title removed from %parent_title", array("title" => $item->title, "parent_title" => $parent->title))); self::_notify_subscribers($item, $body, $subject); } static function send_comment_published($comment) { $body = new View("comment_published.html"); $body->comment = $comment; $item = $comment->item(); $subject = $item->is_album() ? t("A new comment was published for album %title", array("title" => $item->title)) : ($item->is_photo() ? t("A new comment was published for photo %title", array("title" => $item->title)) : t("A new comment was published for movie %title", array("title" => $item->title))); self::_notify_subscribers($item, $body, $subject); } static function process_notifications() { Kohana::log("error", "processing notifications in shutdown"); } private static function _notify_subscribers($item, $body, $subject) { $users = self::get_subscribers($item); if (!empty($users)) { Sendmail::factory() ->to($users) ->subject($subject) ->header("Mime-Version", "1.0") ->header("Content-type", "text/html; charset=utf-8") ->message($body->render()) ->send(); } } }