/** * Display module content * * @return void */ public function display() { $database = \App::get('db'); $this->moduleclass = $this->params->get('moduleclass'); $this->limit = intval($this->params->get('limit', 10)); // Find the user's most recent support tickets $recipient = new Recipient($database); $this->rows = $recipient->getUnreadMessages(User::get('id'), $this->limit); $this->total = count($recipient->getUnreadMessages(User::get('id'))); if ($recipient->getError()) { $this->setError($recipient->getError()); } require $this->getLayoutPath(); }
/** * Display module content * * @return void */ public function display() { if (!Plugin::isEnabled('members', 'messages')) { $this->setError(Lang::txt('MOD_MYMESSAGES_REQUIRED_PLUGIN_DISABLED')); } else { $database = \App::get('db'); $this->moduleclass = $this->params->get('moduleclass'); $this->limit = intval($this->params->get('limit', 10)); // Find the user's most recent support tickets $recipient = Recipient::blank(); $this->rows = $recipient->getUnreadMessages(User::get('id'), $this->limit); $this->total = $recipient->getUnreadMessagesCount(User::get('id')); if ($recipient->getError()) { $this->setError($recipient->getError()); } } require $this->getLayoutPath(); }
/** * Get records for specific type, element, component, and user * * @param string $type Action type * @param string $component Component name * @param integer $element ID of element that needs action * @param integer $uid User ID * @return object */ public static function getActionItems($type, $component, $element, $uid) { $entries = self::all(); $a = $entries->getTableName(); $m = Message::blank()->getTableName(); $r = Recipient::blank()->getTableName(); return $entries->select($m . '.id')->join($r, $r . '.actionid', $a . '.id', 'inner')->join($m, $m . '.id', $r . '.mid', 'inner')->whereEquals($m . '.type', $type)->whereEquals($r . '.uid', $uid)->whereEquals($a . '.class', $component)->whereEquals($a . '.element', $element)->rows(); }
/** * Send a message to one or more users * * @param string $type Message type (maps to #__xmessage_component table) * @param string $subject Message subject * @param string $message Message to send * @param array $from Message 'from' data (e.g., name, address) * @param array $to List of user IDs * @param string $component Component name * @param integer $element ID of object that needs an action item * @param string $description Action item description * @param integer $group_id Parameter description (if any) ... * @return mixed True if no errors else error message */ public function sendMessage($type, $subject, $message, $from = array(), $to = array(), $component = '', $element = null, $description = '', $group_id = 0) { // Do we have a message? if (!$message) { return false; } // Do we have a subject line? If not, create it from the message if (!$subject && $message) { $subject = substr($message, 0, 70); if (strlen($subject) >= 70) { $subject .= '...'; } } $database = \App::get('db'); // Create the message object and store it in the database $xmessage = new Message($database); $xmessage->subject = $subject; $xmessage->message = $message; $xmessage->created = Date::toSql(); $xmessage->created_by = User::get('id'); $xmessage->component = $component; $xmessage->type = $type; $xmessage->group_id = $group_id; if (!$xmessage->store()) { return $xmessage->getError(); } // Does this message require an action? // **DEPRECATED** $action = new Action($database); /*if ($element || $description) { $action->class = $component; $action->element = $element; $action->description = $description; if (!$action->store()) { return $action->getError(); } }*/ // Do we have any recipients? if (count($to) > 0) { // Loop through each recipient foreach ($to as $uid) { // Create a recipient object that ties a user to a message $recipient = new Recipient($database); $recipient->uid = $uid; $recipient->mid = $xmessage->id; $recipient->created = Date::toSql(); $recipient->expires = Date::of(time() + 168 * 24 * 60 * 60)->toSql(); $recipient->actionid = $action->id; if (!$recipient->store()) { return $recipient->getError(); } // Get the user's methods for being notified $notify = new Notify($database); $methods = $notify->getRecords($uid, $type); $user = User::getInstance($uid); // Do we have any methods? if ($methods) { // Loop through each method foreach ($methods as $method) { $action = strtolower($method->method); if (!Event::trigger('xmessage.onMessage', array($from, $xmessage, $user, $action))) { $this->setError(Lang::txt('Unable to message user %s with method %s', $uid, $action)); } } } } } return true; }
/** * Builds a query string based on filters passed * * @param array $filters Filters to build query from * @return string SQL */ private function buildQuery($filters = array()) { $entries = self::all(); $m = $entries->getTableName(); $u = '#__users'; if (isset($filters['group_id']) && $filters['group_id'] != 0) { $entries->select($m . '.*,' . $u . '.name')->join($u, $u . '.id', $m . '.created_by', 'inner'); } else { $r = Recipient::blank()->getTableName(); $entries->select($m . '.*,' . $u . '.name')->join($r, $r . '.mid', $m . '.id', 'inner')->join($u, $u . '.id', $r . '.uid', 'inner'); } if (isset($filters['created_by']) && $filters['created_by'] != 0) { $entries->whereEquals('created_by', $filters['created_by']); } if (isset($filters['daily_limit']) && $filters['daily_limit'] != 0) { $start = date('Y-m-d', mktime(0, 0, 0, date('m'), date('d'), date('Y'))) . " 00:00:00"; $end = date('Y-m-d', mktime(0, 0, 0, date('m'), date('d'), date('Y'))) . " 23:59:59"; $entries->where('created', '>=', $start); $entries->where('created', '<=', $end); } if (isset($filters['group_id']) && $filters['group_id'] != 0) { $entries->whereEquals('group_id', (int) $filters['group_id']); } return $entries; }