-
Notifications
You must be signed in to change notification settings - Fork 2
Description
app/model/user.php
$result["spent"] = $this->db->exec(
"SELECT DATE(u.created_date) AS date, SUM(f.new_value - f.old_value) AS val
FROM issue_update u
JOIN issue_update_field f ON u.id = f.issue_update_id AND f.field = 'hours_spent'
WHERE u.user_id = :user AND u.created_date > :date
GROUP BY date",
[":user" => $this->id, ":date" => date("Y-m-d H:i:s", $time)]
);
$result["closed"] = $this->db->exec(
"SELECT DATE(i.closed_date) AS date, COUNT() AS val
FROM issue i
WHERE i.owner_id = :user AND i.closed_date > :date
GROUP BY date",
[":user" => $this->id, ":date" => date("Y-m-d H:i:s", $time)]
);
$result["created"] = $this->db->exec(
"SELECT DATE(i.created_date) AS date, COUNT() AS val
FROM issue i
WHERE i.author_id = :user AND i.created_date > :date
GROUP BY date",
[":user" => $this->id, ":date" => date("Y-m-d H:i:s", $time)]
);