where("item_id", "=", $item_id) ->where("user_id", "=", $user->id) ->find(); } static function is_watching($item, $user=null) { if (empty($user)) { $user = identity::active_user(); } 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 = identity::active_user(); } $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 = identity::active_user(); } $subscription = ORM::factory("subscription") ->where("item_id", "=", $item->id) ->where("user_id", "=", $user->id) ->find()->delete(); } } static function get_subscribers($item) { $subscriber_ids = array(); foreach (ORM::factory("subscription") ->select("user_id") ->join("items", "subscriptions.item_id", "items.id") ->where("items.left_ptr", "<=", $item->left_ptr) ->where("items.right_ptr", ">", $item->right_ptr) ->find_all() ->as_array() as $subscriber) { $subscriber_ids[] = $subscriber->user_id; } if (empty($subscriber_ids)) { return array(); } $users = identity::get_user_list($subscriber_ids); $subscribers = array(); foreach ($users as $user) { if (access::user_can($user, "view", $item) && !empty($user->email)) { $subscribers[$user->email] = 1; } } return array_keys($subscribers); } static function send_item_updated($original, $item) { $subscribers = self::get_subscribers($item); if (!$subscribers) { return; } $v = new View("item_updated.html"); $v->original = $original; $v->item = $item; $v->subject = $item->is_album() ? t("Album \"%title\" updated", array("title" => $original->title)) : ($item->is_photo() ? t("Photo \"%title\" updated", array("title" => $original->title)) : t("Movie \"%title\" updated", array("title" => $original->title))); Kohana_Log::add("error",print_r($v->render(),1)); self::_notify($subscribers, $item, $v->render(), $v->subject); } static function send_item_add($item) { $subscribers = self::get_subscribers($item); if (!$subscribers) { return; } $parent = $item->parent(); $v = new View("item_added.html"); $v->item = $item; $v->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, $v->render(), $v->subject); } static function send_item_deleted($item) { $subscribers = self::get_subscribers($item); if (!$subscribers) { return; } $parent = $item->parent(); $v = new View("item_deleted.html"); $v->item = $item; $v->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, $v->render(), $v->subject); } static function send_comment_published($comment) { $item = $comment->item(); $subscribers = self::get_subscribers($item); if (!$subscribers) { return; } $v = new View("comment_published.html"); $v->comment = $comment; $v->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, $v->render(), $v->subject); } static function send_pending_notifications() { foreach (db::build() ->select(new Database_Expression("DISTINCT `email`")) ->from("pending_notifications") ->execute() as $row) { $email = $row->email; $result = ORM::factory("pending_notification") ->where("email", "=", $email) ->find_all(); if ($result->count() == 1) { $pending = $result->current(); Sendmail::factory() ->to($email) ->subject($pending->subject) ->header("Mime-Version", "1.0") ->header("Content-type", "text/html; charset=utf-8") ->message($pending->body) ->send(); $pending->delete(); } else { $text = ""; foreach ($result as $pending) { $text .= $pending->text; $pending->delete(); } Sendmail::factory() ->to($email) ->subject(t("Multiple events have occurred")) // @todo fix this terrible subject line ->header("Mime-Version", "1.0") ->header("Content-type", "text/html; charset=utf-8") ->message($text) ->send(); } } } private static function _notify($subscribers, $item, $text, $subject) { if (!empty($subscribers)) { if (!batch::in_progress()) { Sendmail::factory() ->to($subscribers) ->subject($subject) ->header("Mime-Version", "1.0") ->header("Content-type", "text/html; charset=utf-8") ->message($text) ->send(); } else { foreach ($subscribers as $subscriber) { $pending = ORM::factory("pending_notification"); $pending->subject = $subject; $pending->text = $text; $pending->email = $subscriber; $pending->save(); } } } } }