Пример #1
0
 public function index()
 {
     $f3 = \Base::instance();
     $this->_requireLogin();
     $user = $f3->get('user');
     $user_obj = $f3->get('user_obj');
     $user_org_links = $f3->get('user_org_links');
     $db = $f3->get('db.instance');
     // Redirect to welcome page if user has no organisations
     if (count($user_org_links) == 0) {
         $f3->reroute('/dashboard/welcome');
     }
     /*
      *
      * HOME PAGE STATS
      *
      */
     // Use the organisation the user selected, if none take first in database
     if ($f3->exists('SESSION.selected_organisation')) {
         $orgId = $f3->get('SESSION.selected_organisation');
         foreach ($user_org_links as $orgKey => $orgValue) {
             if ($orgValue['orgId'] == $orgId) {
                 $validated = true;
             }
         }
     }
     if (!isset($validated)) {
         // Select first
         $orgId = $user_org_links[0]['orgId'];
     }
     $f3->set('user_org_selected', (new \Models\Organisation())->load($orgId)->cast());
     // Newsletter opens
     $result = $f3->get('db.instance')->exec('SELECT COUNT(*) AS `count` FROM newsletter_opens WHERE orgId = ? AND DATE(open_time) > DATE_SUB(CURDATE(), INTERVAL 7 DAY)', $orgId);
     $f3->set('stats_views', $result[0]['count']);
     // Chart stats
     $f3->set('stats_chart_views', json_encode(Organisations::views($orgId)));
     $f3->set('stats_chart_sending', json_encode(Organisations::sends($orgId)));
     // Subscriptions and Unsubscriptions
     $result = $db->exec('SELECT COUNT(*) AS `count` FROM organisation_subs WHERE orgId = ? AND DATE(sub_time) > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND unsub_time = NULL', $orgId);
     $f3->set('stats_subs', $result[0]['count']);
     $result = $db->exec('SELECT COUNT(*) AS `count` FROM organisation_subs WHERE orgId = ? AND DATE(sub_time) > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND unsub_time IS NOT NULL', $orgId);
     $f3->set('stats_unsubs', $result[0]['count']);
     // Stats Subscriptions
     // Stats mails sent
     $result = $db->exec('SELECT COUNT(*) AS `count` FROM mails_sent WHERE orgId = ? AND DATE(sent_time) > DATE_SUB(CURDATE(), INTERVAL 7 DAY)', $orgId);
     $f3->set('stats_mails_sent', $result[0]['count']);
     // Organisation subscription details
     $orgSub = new \Models\Subscriptions();
     $orgSub->load(array('orgId = ?', $orgId));
     $f3->set('org_sub', $orgSub->calculate());
     // Display a notification to masquerading administrators
     if ($f3->exists('SESSION.mask')) {
         new Notification('You are currently masquerading as a client, <a href="/dashboard/admin/masquerade/reveal">back to your admin account</a>', 'danger', true);
     }
     $f3->set('target', 'dashboard/index/index.html');
     $this->_render('base.html');
 }
Пример #2
0
 /**
  * Shows the recent SquareMS update log and the user's newsletters statistics (or a button "Create a newsletter")
  *
  * @param $f3
  */
 public function home()
 {
     $f3 = \Base::instance();
     $this->_requireLogin();
     $user = $f3->get('user');
     $user_obj = $f3->get('user_obj');
     $user_org_links = $f3->get('user_org_links');
     // Create new organisation if the user has none
     if ($f3->exists('POST.organisationName')) {
         $org = $f3->get('POST.organisationName');
         $org = $f3->scrub($org);
         if (strlen($org) < 4) {
             $notif = new Notification();
             $notif->title = 'Error';
             $notif->body = 'Organisation name must be at least 4 long.';
             $notif->save();
         } else {
             $orgEntry = new \Models\Organisation();
             $orgEntry->name = $org;
             $orgEntry->desc = NULL;
             $orgEntry->ownerId = $user['id'];
             $orgEntry->save();
             // Create a new org member entry and give the user all rights to it (fields starting with 'r' for rights)
             $orgMemberEntry = new \Models\OrganisationMembers();
             $orgMemberEntry->orgId = $orgEntry->id;
             $orgMemberEntry->memberId = $user['id'];
             $orgMemberEntry->rEdit = true;
             $orgMemberEntry->rSend = true;
             $orgMemberEntry->save();
             // Create a new subsription entry
             $orgSubEntry = new \Models\Subscriptions();
             $orgSubEntry->orgId = $orgEntry->id;
             $orgSubEntry->planId = 1;
             $orgSubEntry->payDay = date("d");
             $orgSubEntry->save();
             $f3->reroute($f3->get('PATH'));
         }
     }
     if (count($user_org_links) == 0) {
         $f3->set('target', 'dashboard/index/first-org.html');
     } else {
         // Home-page stats
         if ($f3->exists('SESSION.selected_organisation')) {
             $orgId = $f3->get('SESSION.selected_organisation');
             foreach ($user_org_links as $orgKey => $orgValue) {
                 if ($orgValue['orgId'] == $orgId) {
                     $validated = true;
                 }
             }
         }
         if (!isset($validated)) {
             // Select first
             $orgId = $user_org_links[0]['orgId'];
         }
         // Gather some stats
         $result = $f3->get('db.instance')->exec('SELECT COUNT(*) AS `count` FROM newsletter_opens WHERE orgId = ? AND DATE(open_time) > DATE_SUB(CURDATE(), INTERVAL 7 DAY)', $orgId);
         $f3->set('stats_views', $result[0]['count']);
         //            $result = $f3->get('db.instance')->exec('SELECT COUNT(*) AS `count` FROM newsletter_unsub WHERE orgId = ? AND DATE(open_time) > DATE_SUB(CURDATE(), INTERVAL 7 DAY)', $orgId);
         //            $f3->set('stats_unsub', $result[0]['count']);
         // Gather some stats for the chart
         $f3->set('stats_chart_views', json_encode(Organisations::views($orgId)));
         $f3->set('stats_chart_sending', json_encode(Organisations::sends($orgId)));
         $orgMap = new \Models\Organisation();
         $orgMap->load($orgId);
         $f3->set('user_org_selected', $orgMap->cast());
         // Stats Subscriptions
         $db = $f3->get('db.instance');
         $result = $db->exec('SELECT COUNT(*) AS `count` FROM organisation_subs WHERE orgId = ? AND DATE(sub_time) > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND unsub_time = NULL', $orgId);
         $f3->set('stats_subs', $result[0]['count']);
         $result = $db->exec('SELECT COUNT(*) AS `count` FROM organisation_subs WHERE orgId = ? AND DATE(sub_time) > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND unsub_time IS NOT NULL', $orgId);
         $f3->set('stats_unsubs', $result[0]['count']);
         // Stats mails sent
         $result = $db->exec('SELECT COUNT(*) AS `count` FROM mails_sent WHERE orgId = ? AND DATE(sent_time) > DATE_SUB(CURDATE(), INTERVAL 7 DAY)', $orgId);
         $f3->set('stats_mails_sent', $result[0]['count']);
         // Organisation subscription details
         $orgSub = new \Models\Subscriptions();
         $orgSub->load(array('orgId = ?', $orgId));
         $f3->set('org_sub', $orgSub->calculate());
         $f3->set('target', 'dashboard/index/index.html');
         if ($f3->exists('SESSION.mask')) {
             $notif = new Notification();
             $notif->text = 'You are currently masquerading as a client, <a href="/dashboard/admin/masquerade/reveal">back to your admin account</a>';
             $notif->type = 'danger';
             $notif->save();
         }
     }
     $this->_render('base.html');
 }