controller.php

<?php

/**
 * @package  Teamdaily
 * @author   Ryan Bouche <rightbit@gmail.com>
 * @version  1.0.1
 */

namespace Plugin\Teamdaily;

class Controller extends \Controller
{
    /**
     * Handle HTTP GET request
     * @param \Base $f3
     */
    public function dashboard($f3)
    {
        $this->_requireLogin();
        $db = $f3->get("db.instance");

        $group_list = \Model\User\Group::getUserGroups();
        $f3->set("group_list", $group_list);

        $start_group = (empty($group_list[0]['id'])) ? $f3->get('td.default.team') : $group_list[0]['id'];

        $group_id = $f3->get("GET.group_id") ?: $start_group;
        if (!$f3->get('GET.date')) {
            $date = date("Y-m-d", strtotime("Yesterday", \Helper\View::instance()->utc2local()));
        } else {
            $date = date("Y-m-d", strtotime($f3->get('GET.date')));
        }
        $members = new \Model\Custom("user_group_user");
        foreach ($members->find(array("group_id = ? AND deleted_date IS NULL", $group_id)) as $r) {
            $team_members[] = $r->user_id;
        }

        if (!$team_members) {
            $team_members = [$f3->get('user.id')];
        }

        $team_ids = implode(",", $team_members);

        $sprint = new \Model\Sprint();
        $sprint->load(array("? BETWEEN start_date AND end_date", date("Y-m-d")));
        $f3->set("sprint", $sprint);

        $scores = $db->exec(
            "SELECT u.id, u.name, u.username,
                SUM(IF(f.field = 'hours_spent', f.new_value - f.old_value, 0)) as hours,
                SUM(IF(f.field = 'status' AND f.new_value = 3, 1, 0)) as closed,
                COUNT(DISTINCT i.id) as late
            FROM user u
            LEFT JOIN issue_update_detail d on u.id = d.user_id AND DATE(CONVERT_TZ(d.created_date, 'GMT', '{$f3->get('site.timezone')}')) = '$date'
            LEFT JOIN issue_update_field f ON d.id = f.issue_update_id
            LEFT JOIN issue i on u.id = i.owner_id AND i.due_date = '$date' AND i.closed_date IS NULL AND (i.closed_date IS NULL OR i.due_date < DATE(CONVERT_TZ(i.closed_date, 'GMT', '{$f3->get('site.timezone')}')))
            WHERE u.id IN ($team_ids) GROUP BY u.id ORDER BY u.name"
        );

        // Get the Team user
        $user = new \Model\User();
        $user->load($group_id);
        $teamscore = array(
            'id' => $user->id,
            'name' => $user->name,
            'username' => $user->username,
            'hours' => 0,
            'closed' => 0,
            'late' => 0,
            'status' => 'warning',
            'tasks' => array(),
            'avatar' => $user->avatar(128),
            'avatar2x' => $user->avatar(256)
        );
        $teampoints = 0;

        $user ->reset();
        $issue = new \Model\Issue();

        foreach ($scores as &$score) {
            // Increment Team Scores
            $teamscore['hours'] += $score['hours'];
            $teamscore['closed'] += $score['closed'];
            $teamscore['late'] += $score['late'];
            $points = 0;
            if ($score['hours'] >= 6) {
                $points += 2;
            }
            if ($score['closed'] > 0) {
                $points += 1;
            }
            if ($score['late'] == 0) {
                $points += 2;
            }

            if ($points >= 4) {
                $score['status'] = 'success';
                $teampoints += 1;
            } elseif ($points >= 2) {
                $score['status'] = 'warning';
            } else {
                $score['status'] = 'danger';
            }

            // Load the User's avatar
            $user->load($score['id']);
            $score['avatar'] = $user->avatar(128);
            $score['avatar2x'] = $user->avatar(256);

            // Load the user's top issues
            $score['tasks']['Active'] = $issue->findone(array("owner_id = ? AND closed_date IS NULL AND deleted_date IS NULL AND status= '2'", $user->id), array('order' => 'due_date, priority DESC'));
            $score['tasks']['Due'] = $issue->findone(array("owner_id = ? AND closed_date IS NULL AND deleted_date IS NULL AND date(due_date) < DATE_ADD(NOW(), INTERVAL 2 day)", $user->id), array('order' => 'due_date, priority DESC'));
            $score['tasks']['High'] = $issue->findone(array("owner_id = ? AND closed_date IS NULL AND deleted_date IS NULL AND priority > '0'", $user->id), array('order' => 'priority DESC'));
            $user->reset();
        }

        // Calculate team overall success then add team to scores
        if ($teampoints > (count($scores) / 2)) {
            $teamscore['status'] = 'success';
        } else {
            $teamscore['status'] = 'danger';
        }
        $scores[] = $teamscore;
        $f3->set("results", $scores);

        // Render page
        $f3->set("title", "Team Wins");
        $this->_render("teamdaily/view/td_dashboard.html");
    }
}