public function Purge() { $retention = Settings::get('retention', 30); $retentionDate = date('Y-m-d H:i:s', strtotime('-' . $retention . ' day')); $protectRows = MessageMax::lists('row_id'); Message::whereNotIn('id', $protectRows)->where('sent_at', '<', $retentionDate)->where('read', 1)->delete(); }
protected function loadMessages($plugin, $last_id) { if (is_null($plugin) || is_null($last_id)) { return false; } $messages = Message::where('plugin', $plugin)->where('id', '>', $last_id)->where('send', 1)->whereNull('mess_id')->get(); return $messages; }
public function index_onRead() { if (($checkedIds = post('checked')) && is_array($checkedIds) && count($checkedIds)) { Message::whereIn('id', $checkedIds)->update(['read' => 1]); Flash::success('Successfully marked those messages.'); } return $this->listRefresh(); }
public function index_onDelete() { if (($checkedIds = post('checked')) && is_array($checkedIds) && count($checkedIds)) { foreach ($checkedIds as $messageId) { if (!($message = Message::find($messageId))) { continue; } $message->delete(); } Flash::success('Successfully deleted those messages.'); } return $this->listRefresh(); }
public function insertNewMessage($message) { $id = $message['id']; unset($message['id']); $newMessage = array_merge($message, ['mess_id' => $id, 'plugin' => $this->plugin, 'read' => false, 'source' => $this->url, 'updated_at' => null]); return Message::create($newMessage); }
public function render() { $this->messageCount = Message::WhereNotNull('source')->UnRead()->count(); return $this->makePartial('widget'); }