/** * Process users badges */ public function process() { $badges = $this->getBadges(); foreach (Users::find() as $user) { $this->processUserBadges($user, $badges); } }
/** * Sends the digest */ public function send() { $lastMonths = new \DateTime(); $lastMonths->modify('-6 month'); $parameters = array('modified_at >= ?0 AND digest = "Y" AND notifications <> "N"', 'bind' => array($lastMonths->getTimestamp())); $users = array(); foreach (Users::find($parameters) as $user) { if ($user->email && strpos($user->email, '@') !== false && strpos($user->email, '@users.noreply.github.com') === false) { $users[trim($user->email)] = $user->name; } } $fromName = $this->config->mail->fromName; $fromEmail = $this->config->mail->fromEmail; $url = $this->config->site->url; $subject = 'Top Stories from Phosphorum ' . date('d/m/y'); $lastWeek = new \DateTime(); $lastWeek->modify('-1 week'); $order = 'number_views + ' . '((IF(votes_up IS NOT NULL, votes_up, 0) - ' . 'IF(votes_down IS NOT NULL, votes_down, 0)) * 4) + ' . 'number_replies + IF(accepted_answer = "Y", 10, 0) DESC'; $parameters = array('created_at >= ?0 AND deleted != 1 AND categories_id <> 4', 'bind' => array($lastWeek->getTimestamp()), 'order' => $order, 'limit' => 10); $e = $this->escaper; $content = '<html><head></head><body><p><h1 style="font-size:22px;color:#333;letter-spacing:-0.5px;line-height:1.25;font-weight:normal;padding:16px 0;border-bottom:1px solid #e2e2e2">Top Stories from Phosphorum</h1></p>'; foreach (Posts::find($parameters) as $post) { $user = $post->user; if ($user == false) { continue; } $content .= '<p><a style="text-decoration:none;display:block;font-size:20px;color:#333;letter-spacing:-0.5px;line-height:1.25;font-weight:normal;color:#155fad" href="' . $url . '/discussion/' . $post->id . '/' . $post->slug . '">' . $e->escapeHtml($post->title) . '</a></p>'; $content .= '<p><table width="100%"><td><table><tr><td>' . '<img src="https://secure.gravatar.com/avatar/' . $user->gravatar_id . '?s=32&r=pg&d=identicon" width="32" height="32" alt="' . $user->name . ' icon">' . '</td><td><a style="text-decoration:none;color:#155fad" href="' . $url . '/user/' . $user->id . '/' . $user->login . '">' . $user->name . '<br><span style="text-decoration:none;color:#999;text-decoration:none">' . $user->getHumanKarma() . '</span></a></td></tr></table></td><td align="right"><table style="border: 1px solid #dadada;" cellspacing=5>' . '<td align="center"><label style="color:#999;margin:0px;font-weight:normal;">Created</label><br>' . $post->getHumanCreatedAt() . '</td>' . '<td align="center"><label style="color:#999;margin:0px;font-weight:normal;">Replies</label><br>' . $post->number_replies . '</td>' . '<td align="center"><label style="color:#999;margin:0px;font-weight:normal;">Views</label><br>' . $post->number_views . '</td>' . '<td align="center"><label style="color:#999;margin:0px;font-weight:normal;">Votes</label><br>' . ($post->votes_up - $post->votes_down) . '</td>' . '</tr></table></td></tr></table></p>'; $content .= $this->markdown->render($e->escapeHtml($post->content)); $content .= '<p><a style="color:#155fad" href="' . $url . '/discussion/' . $post->id . '/' . $post->slug . '">Read more</a></p>'; $content .= '<hr style="border: 1px solid #dadada">'; } $textContent = strip_tags($content); $htmlContent = $content . '<p style="font-size:small;-webkit-text-size-adjust:none;color:#717171;">'; $htmlContent .= PHP_EOL . 'This email was sent by Phalcon Framework. Change your e-mail preferences <a href="' . $url . '/settings">here</a></p>'; foreach ($users as $email => $name) { try { $message = new \Swift_Message('[Phalcon Forum] ' . $subject); $message->setTo(array($email => $name)); $message->setFrom(array($fromEmail => $fromName)); $bodyMessage = new \Swift_MimePart($htmlContent, 'text/html'); $bodyMessage->setCharset('UTF-8'); $message->attach($bodyMessage); $bodyMessage = new \Swift_MimePart($textContent, 'text/plain'); $bodyMessage->setCharset('UTF-8'); $message->attach($bodyMessage); if (!$this->transport) { $this->transport = \Swift_SmtpTransport::newInstance($this->config->smtp->host, $this->config->smtp->port, $this->config->smtp->security); $this->transport->setUsername($this->config->smtp->username); $this->transport->setPassword($this->config->smtp->password); } if (!$this->mailer) { $this->mailer = \Swift_Mailer::newInstance($this->transport); } $this->mailer->send($message); } catch (\Exception $e) { echo $e->getMessage(), PHP_EOL; } } }
/** * Shows the user profile * * @param int $id User id * @param string $username User name */ public function viewAction($id, $username) { $user = $id ? Users::findFirstById($id) : Users::findFirstByLogin($username); if (!$user) { $user = Users::findFirstByName($username); } if (!$user) { $this->flashSession->error('The user does not exist'); $this->response->redirect(); return; } $this->view->setVar('user', $user); $parametersNumberPosts = ['users_id = ?0 AND deleted = 0', 'bind' => [$user->id]]; $this->view->setVar('numberPosts', Posts::count($parametersNumberPosts)); $parametersNumberReplies = ['users_id = ?0', 'bind' => [$user->id]]; $this->view->setVar('numberReplies', PostsReplies::count($parametersNumberReplies)); $parametersActivities = ['users_id = ?0', 'bind' => [$user->id], 'order' => 'created_at DESC', 'limit' => 15]; $this->view->setVar('activities', Activities::find($parametersActivities)); $users = Users::find(['columns' => 'id', 'conditions' => 'karma != 0', 'order' => 'karma DESC']); $ranking = count($users); foreach ($users as $position => $everyUser) { if ($everyUser->id == $user->id) { $ranking = $position + 1; break; } } $this->gravatar->setSize(220); $this->view->setVars(['ranking' => $ranking, 'total_ranking' => count($users), 'avatar' => $this->gravatar->getAvatar($user->email)]); $this->tag->setTitle('Profile - ' . $this->escaper->escapeHtml($user->name)); }
public function onConstruct() { $lastThreads = $this->modelsManager->createBuilder()->from(['p' => 'Phosphorum\\Models\\Posts'])->groupBy("p.id")->join('Phosphorum\\Models\\Categories', "r.id = p.categories_id", 'r')->join('Phosphorum\\Models\\Users', "u.id = p.users_id", 'u')->columns(['p.title as title_post', 'p.id as id_post', 'p.slug as slug_post', 'r.name as name_category', 'u.name as name_user'])->where('p.deleted = 0')->orderBy('p.created_at DESC')->limit(3)->getQuery()->execute(); /** @var Simple $lastMember */ $lastMember = Users::find(['order' => 'created_at DESC', 'limit' => 1, 'columns' => 'login']); $login = null; if ($lastMember->valid()) { $login = $lastMember->getFirst()->login; } $this->view->setVars(['app_name' => $this->config->get('site')->name, 'app_version' => VERSION, 'threads' => Posts::count(), 'last_threads' => $lastThreads, 'users' => Users::count(), 'users_latest' => $login, 'actionName' => $this->dispatcher->getActionName(), 'controllerName' => $this->dispatcher->getControllerName()]); }
public function karmaAction() { foreach (Users::find() as $user) { if ($user->karma === null) { $parametersNumbersPost = array('users_id = ?0', 'bind' => array($user->id)); $numberPosts = Posts::count($parametersNumbersPost); $parametersNumberReplies = array('users_id = ?0', 'bind' => array($user->id)); $numberReplies = PostsReplies::count($parametersNumberReplies); $user->karma = $numberReplies * 10 + $numberPosts * 5; $user->votes = intval($user->karma / 50); $user->save(); } } }
public function afterCreate() { /** * Register a new activity */ if ($this->id > 0) { /** * Register the activity */ $activity = new Activities(); $activity->users_id = $this->users_id; $activity->posts_id = $this->id; $activity->type = Activities::NEW_POST; $activity->save(); /** * Notify users that always want notifications */ $notification = new PostsNotifications(); $notification->users_id = $this->users_id; $notification->posts_id = $this->id; $notification->save(); /** * Notify users that always want notifications */ $toNotify = []; foreach (Users::find(['notifications = "Y"', 'columns' => 'id']) as $user) { if ($this->users_id != $user->id) { $notification = new Notifications(); $notification->users_id = $user->id; $notification->posts_id = $this->id; $notification->type = 'P'; $notification->save(); $toNotify[$user->id] = $notification->id; } } /** * Update the total of posts related to a category */ $this->category->number_posts++; $this->category->save(); /** * Queue notifications to be sent */ $this->getDI()->getQueue()->put($toNotify); } }
/** * Sends the digest */ public function send() { $lastMonths = new \DateTime(); $lastMonths->modify('-6 month'); $parameters = ['modified_at >= ?0 AND digest = "Y" AND notifications <> "N"', 'bind' => [$lastMonths->getTimestamp()]]; $users = []; foreach (Users::find($parameters) as $user) { if ($user->email && strpos($user->email, '@') !== false && strpos($user->email, '@users.noreply.github.com') === false) { $users[trim($user->email)] = $user->name; } } $view = new View(); $view->setViewsDir($this->config->application->viewsDir); $fromName = $this->config->mail->fromName; $fromEmail = $this->config->mail->fromEmail; $url = rtrim($this->config->site->url, '/'); $subject = sprintf('Top Stories from Phosphorum %s', date('d/m/y')); $view->setVar('title', $subject); $lastWeek = new \DateTime(); $lastWeek->modify('-1 week'); $order = 'number_views + ' . '((IF(votes_up IS NOT NULL, votes_up, 0) - ' . 'IF(votes_down IS NOT NULL, votes_down, 0)) * 4) + ' . 'number_replies + IF(accepted_answer = "Y", 10, 0) DESC'; $parameters = ['created_at >= ?0 AND deleted != 1 AND categories_id <> 4', 'bind' => [$lastWeek->getTimestamp()], 'order' => $order, 'limit' => 10]; $e = $this->escaper; /** @var \Phalcon\Logger\AdapterInterface $logger */ $logger = $this->getDI()->get('logger', ['mail']); $stories = []; foreach (Posts::find($parameters) as $i => $post) { $user = $post->user; if ($user == false) { continue; } $this->gravatar->setSize(32); $stories[$i]['user_name'] = $user->name; $stories[$i]['user_avatar'] = $this->gravatar->getAvatar($user->email); $stories[$i]['user_url'] = "{$url}/user/{$user->id}/{$user->login}"; $stories[$i]['user_karma'] = $user->getHumanKarma(); $stories[$i]['post_title'] = $e->escapeHtml($post->title); $stories[$i]['post_created'] = $post->getHumanCreatedAt(); $stories[$i]['post_replies'] = (int) $post->number_replies; $stories[$i]['post_views'] = (int) $post->number_views; $stories[$i]['post_votes'] = $post->votes_up - $post->votes_down; $stories[$i]['post_content'] = $this->markdown->render($e->escapeHtml($post->content)); $stories[$i]['post_url'] = "{$url}/discussion/{$post->id}/{$post->slug}"; } if (empty($stories)) { return; } $view->setVar('stories', $stories); $view->setVar('notice', sprintf('This email was sent by %s mail sender. Change your e-mail preferences <a href="%s/settings">here</a>', $this->config->site->name, $url)); $content = $view->render('mail/digest.phtml'); $textContent = preg_replace('#<a[^>]+href="([^"]+)"[^>]*>([^<]+)<\\/a>#', '$2:' . "\n" . '$1', $content); $textContent = str_replace('<span class="foot-line"></span>', "--\n", $textContent); $textContent = trim(strip_tags($textContent)); $textContent = str_replace(' ', ' ', $textContent); $textContent = preg_replace('#\\t+#', '', $textContent); $textContent = preg_replace('# {2,}#', ' ', $textContent); $textContent = preg_split('#(\\r|\\n)#', $textContent); $textContent = join("\n\n", array_filter($textContent, function ($line) { return '' !== trim($line); })); $textContent = preg_replace('#^[ \\t]+#m', '', $textContent); foreach ($users as $email => $name) { try { $message = new \Swift_Message("[{$this->config->site->name} Forum] " . $subject); $message->setTo([$email => $name]); $message->setFrom([$fromEmail => $fromName]); $bodyMessage = new \Swift_MimePart($content, 'text/html'); $bodyMessage->setCharset('UTF-8'); $message->attach($bodyMessage); $bodyMessage = new \Swift_MimePart($textContent, 'text/plain'); $bodyMessage->setCharset('UTF-8'); $message->attach($bodyMessage); if (!$this->transport) { $this->transport = \Swift_SmtpTransport::newInstance($this->config->smtp->host, $this->config->smtp->port, $this->config->smtp->security); $this->transport->setUsername($this->config->smtp->username); $this->transport->setPassword($this->config->smtp->password); } if (!$this->mailer) { $this->mailer = \Swift_Mailer::newInstance($this->transport); } $failedRecipients = []; $this->mailer->send($message, $failedRecipients); if (empty($failedRecipients)) { $logger->info("Sent an email to {$email}"); } else { $logger->error("Unable to sent an email to " . join(', ', $failedRecipients)); } } catch (\Exception $e) { $logger->error($e->getMessage()); throw new \Exception($e->getMessage(), $e->getCode(), $e); } } }
public function afterCreate() { if ($this->id > 0) { $activity = new Activities(); $activity->users_id = $this->users_id; $activity->posts_id = $this->posts_id; $activity->type = Activities::NEW_REPLY; $activity->save(); $toNotify = array(); /** * Notify users that always want notifications */ foreach (Users::find(array('notifications = "Y"', 'columns' => 'id')) as $user) { if ($this->users_id != $user->id) { $notification = new Notifications(); $notification->users_id = $user->id; $notification->posts_id = $this->posts_id; $notification->posts_replies_id = $this->id; $notification->type = 'C'; $notification->save(); $activity = new ActivityNotifications(); $activity->users_id = $user->id; $activity->posts_id = $this->posts_id; $activity->posts_replies_id = $this->id; $activity->users_origin_id = $this->users_id; $activity->type = 'C'; $activity->save(); $toNotify[$user->id] = $notification->id; } } /** * Register users subscribed to the post */ foreach (PostsSubscribers::findByPostsId($this->posts_id) as $subscriber) { if (!isset($toNotify[$subscriber->users_id])) { $notification = new Notifications(); $notification->users_id = $subscriber->users_id; $notification->posts_id = $this->posts_id; $notification->posts_replies_id = $this->id; $notification->type = 'C'; $notification->save(); $activity = new ActivityNotifications(); $activity->users_id = $subscriber->users_id; $activity->posts_id = $this->posts_id; $activity->posts_replies_id = $this->id; $activity->users_origin_id = $this->users_id; $activity->type = 'C'; $activity->save(); $toNotify[$subscriber->users_id] = $notification->id; } } /** * Register the user in the post's notifications */ if (!isset($toNotify[$this->users_id])) { $parameters = array('users_id = ?0 AND posts_id = ?1', 'bind' => array($this->users_id, $this->posts_id)); $hasNotifications = PostsNotifications::count($parameters); if (!$hasNotifications) { $notification = new PostsNotifications(); $notification->users_id = $this->users_id; $notification->posts_id = $this->posts_id; $notification->save(); } } /** * Notify users that have commented in the same post */ $postsNotifications = PostsNotifications::findByPostsId($this->posts_id); foreach ($postsNotifications as $postNotification) { if (!isset($toNotify[$postNotification->users_id])) { if ($postNotification->users_id != $this->users_id) { /** * Generate an e-mail notification */ $notification = new Notifications(); $notification->users_id = $postNotification->users_id; $notification->posts_id = $this->posts_id; $notification->posts_replies_id = $this->id; $notification->type = 'C'; $notification->save(); $activity = new ActivityNotifications(); $activity->users_id = $postNotification->users_id; $activity->posts_id = $this->posts_id; $activity->posts_replies_id = $this->id; $activity->users_origin_id = $this->users_id; $activity->type = 'C'; $activity->save(); $toNotify[$postNotification->users_id] = $notification->id; } } } /** * Queue notifications to be sent */ $this->getDI()->getQueue()->put($toNotify); } }
/** * Shows the user profile */ public function userAction($id, $username) { if ($id) { $user = Users::findFirstById($id); } else { $user = Users::findFirstByLogin($username); if (!$user) { $user = Users::findFirstByName($username); } } if (!$user) { $this->flashSession->error('The user does not exist'); return $this->response->redirect(); } $this->view->user = $user; $parametersNumberPosts = array('users_id = ?0 AND deleted = 0', 'bind' => array($user->id)); $this->view->numberPosts = Posts::count($parametersNumberPosts); $parametersNumberReplies = array('users_id = ?0', 'bind' => array($user->id)); $this->view->numberReplies = PostsReplies::count($parametersNumberReplies); $parametersActivities = array('users_id = ?0', 'bind' => array($user->id), 'order' => 'created_at DESC', 'limit' => 15); $this->view->activities = Activities::find($parametersActivities); $users = Users::find(array('columns' => 'id', 'conditions' => 'karma != 0', 'order' => 'karma DESC')); $ranking = count($users); foreach ($users as $position => $everyUser) { if ($everyUser->id == $user->id) { $ranking = $position + 1; break; } } $this->view->ranking = $ranking; $this->view->total_ranking = count($users); $this->tag->setTitle('Profile - ' . $this->escaper->escapeHtml($user->name)); }
} for ($i = 0; $i <= 50; $i++) { $user = new Users(); $user->name = $faker->name; $user->login = $faker->userName; $user->email = $faker->email; $user->timezone = $faker->timezone; if (!$user->save()) { $database->rollback(); die(join(PHP_EOL, $user->getMessages())); } $log->info('User: '******'columns' => 'id'])->toArray(); $userIds = Users::find(['columns' => 'id'])->toArray(); $database->begin(); for ($i = 0; $i <= 500; $i++) { $title = $faker->company; $post = new Posts(); $post->title = $title; $post->slug = Tag::friendlyTitle($title); $post->content = $faker->text(); $userRandId = array_rand($userIds); $post->users_id = $userIds[$userRandId]['id']; $categoryRandId = array_rand($categoryIds); $post->categories_id = $categoryIds[$categoryRandId]['id']; if (!$post->save()) { $database->rollback(); die(join(PHP_EOL, $post->getMessages())); }
public function onConstruct() { $last_threads = $this->modelsManager->createBuilder()->from(array('p' => 'Phosphorum\\Models\\Posts'))->groupBy("p.id")->join('Phosphorum\\Models\\Categories', "r.id = p.categories_id", 'r')->join('Phosphorum\\Models\\Users', "u.id = p.users_id", 'u')->columns(array('p.title as title_post', 'p.id as id_post', 'p.slug as slug_post', 'r.name as name_category', 'u.name as name_user'))->orderBy('p.created_at DESC')->limit(3)->getQuery()->execute(); $users = Users::find()->getLast(); $this->view->setVars(['threads' => Posts::count(), 'last_threads' => $last_threads, 'users' => Users::count(), 'users_latest' => $users->login, 'actionName' => $this->dispatcher->getActionName()]); }