summaryrefslogtreecommitdiff
path: root/app/Model/SubtaskTimeTracking.php
diff options
context:
space:
mode:
Diffstat (limited to 'app/Model/SubtaskTimeTracking.php')
-rw-r--r--app/Model/SubtaskTimeTracking.php298
1 files changed, 0 insertions, 298 deletions
diff --git a/app/Model/SubtaskTimeTracking.php b/app/Model/SubtaskTimeTracking.php
deleted file mode 100644
index 8b5d2545..00000000
--- a/app/Model/SubtaskTimeTracking.php
+++ /dev/null
@@ -1,298 +0,0 @@
-<?php
-
-namespace Kanboard\Model;
-
-use DateTime;
-use Kanboard\Core\Base;
-
-/**
- * Subtask timesheet
- *
- * @package model
- * @author Frederic Guillot
- */
-class SubtaskTimeTracking extends Base
-{
- /**
- * SQL table name
- *
- * @var string
- */
- const TABLE = 'subtask_time_tracking';
-
- /**
- * Get query to check if a timer is started for the given user and subtask
- *
- * @access public
- * @param integer $user_id User id
- * @return string
- */
- public function getTimerQuery($user_id)
- {
- return sprintf(
- "SELECT %s FROM %s WHERE %s='%d' AND %s='0' AND %s=%s LIMIT 1",
- $this->db->escapeIdentifier('start'),
- $this->db->escapeIdentifier(self::TABLE),
- $this->db->escapeIdentifier('user_id'),
- $user_id,
- $this->db->escapeIdentifier('end'),
- $this->db->escapeIdentifier('subtask_id'),
- Subtask::TABLE.'.id'
- );
- }
-
- /**
- * Get query for user timesheet (pagination)
- *
- * @access public
- * @param integer $user_id User id
- * @return \PicoDb\Table
- */
- public function getUserQuery($user_id)
- {
- return $this->db
- ->table(self::TABLE)
- ->columns(
- self::TABLE.'.id',
- self::TABLE.'.subtask_id',
- self::TABLE.'.end',
- self::TABLE.'.start',
- self::TABLE.'.time_spent',
- Subtask::TABLE.'.task_id',
- Subtask::TABLE.'.title AS subtask_title',
- Task::TABLE.'.title AS task_title',
- Task::TABLE.'.project_id',
- Task::TABLE.'.color_id'
- )
- ->join(Subtask::TABLE, 'id', 'subtask_id')
- ->join(Task::TABLE, 'id', 'task_id', Subtask::TABLE)
- ->eq(self::TABLE.'.user_id', $user_id);
- }
-
- /**
- * Get query for task timesheet (pagination)
- *
- * @access public
- * @param integer $task_id Task id
- * @return \PicoDb\Table
- */
- public function getTaskQuery($task_id)
- {
- return $this->db
- ->table(self::TABLE)
- ->columns(
- self::TABLE.'.id',
- self::TABLE.'.subtask_id',
- self::TABLE.'.end',
- self::TABLE.'.start',
- self::TABLE.'.time_spent',
- self::TABLE.'.user_id',
- Subtask::TABLE.'.task_id',
- Subtask::TABLE.'.title AS subtask_title',
- Task::TABLE.'.project_id',
- User::TABLE.'.username',
- User::TABLE.'.name AS user_fullname'
- )
- ->join(Subtask::TABLE, 'id', 'subtask_id')
- ->join(Task::TABLE, 'id', 'task_id', Subtask::TABLE)
- ->join(User::TABLE, 'id', 'user_id', self::TABLE)
- ->eq(Task::TABLE.'.id', $task_id);
- }
-
- /**
- * Get query for project timesheet (pagination)
- *
- * @access public
- * @param integer $project_id Project id
- * @return \PicoDb\Table
- */
- public function getProjectQuery($project_id)
- {
- return $this->db
- ->table(self::TABLE)
- ->columns(
- self::TABLE.'.id',
- self::TABLE.'.subtask_id',
- self::TABLE.'.end',
- self::TABLE.'.start',
- self::TABLE.'.time_spent',
- self::TABLE.'.user_id',
- Subtask::TABLE.'.task_id',
- Subtask::TABLE.'.title AS subtask_title',
- Task::TABLE.'.project_id',
- Task::TABLE.'.color_id',
- User::TABLE.'.username',
- User::TABLE.'.name AS user_fullname'
- )
- ->join(Subtask::TABLE, 'id', 'subtask_id')
- ->join(Task::TABLE, 'id', 'task_id', Subtask::TABLE)
- ->join(User::TABLE, 'id', 'user_id', self::TABLE)
- ->eq(Task::TABLE.'.project_id', $project_id)
- ->asc(self::TABLE.'.id');
- }
-
- /**
- * Get all recorded time slots for a given user
- *
- * @access public
- * @param integer $user_id User id
- * @return array
- */
- public function getUserTimesheet($user_id)
- {
- return $this->db
- ->table(self::TABLE)
- ->eq('user_id', $user_id)
- ->findAll();
- }
-
- /**
- * Return true if a timer is started for this use and subtask
- *
- * @access public
- * @param integer $subtask_id
- * @param integer $user_id
- * @return boolean
- */
- public function hasTimer($subtask_id, $user_id)
- {
- return $this->db->table(self::TABLE)->eq('subtask_id', $subtask_id)->eq('user_id', $user_id)->eq('end', 0)->exists();
- }
-
- /**
- * Log start time
- *
- * @access public
- * @param integer $subtask_id
- * @param integer $user_id
- * @return boolean
- */
- public function logStartTime($subtask_id, $user_id)
- {
- return
- ! $this->hasTimer($subtask_id, $user_id) &&
- $this->db
- ->table(self::TABLE)
- ->insert(array('subtask_id' => $subtask_id, 'user_id' => $user_id, 'start' => time(), 'end' => 0));
- }
-
- /**
- * Log end time
- *
- * @access public
- * @param integer $subtask_id
- * @param integer $user_id
- * @return boolean
- */
- public function logEndTime($subtask_id, $user_id)
- {
- $time_spent = $this->getTimeSpent($subtask_id, $user_id);
-
- if ($time_spent > 0) {
- $this->updateSubtaskTimeSpent($subtask_id, $time_spent);
- }
-
- return $this->db
- ->table(self::TABLE)
- ->eq('subtask_id', $subtask_id)
- ->eq('user_id', $user_id)
- ->eq('end', 0)
- ->update(array(
- 'end' => time(),
- 'time_spent' => $time_spent,
- ));
- }
-
- /**
- * Calculate the time spent when the clock is stopped
- *
- * @access public
- * @param integer $subtask_id
- * @param integer $user_id
- * @return float
- */
- public function getTimeSpent($subtask_id, $user_id)
- {
- $hook = 'model:subtask-time-tracking:calculate:time-spent';
- $start_time = $this->db
- ->table(self::TABLE)
- ->eq('subtask_id', $subtask_id)
- ->eq('user_id', $user_id)
- ->eq('end', 0)
- ->findOneColumn('start');
-
- if (empty($start_time)) {
- return 0;
- }
-
- $end = new DateTime;
- $start = new DateTime;
- $start->setTimestamp($start_time);
-
- if ($this->hook->exists($hook)) {
- return $this->hook->first($hook, array(
- 'user_id' => $user_id,
- 'start' => $start,
- 'end' => $end,
- ));
- }
-
- return $this->dateParser->getHours($start, $end);
- }
-
- /**
- * Update subtask time spent
- *
- * @access public
- * @param integer $subtask_id
- * @param float $time_spent
- * @return bool
- */
- public function updateSubtaskTimeSpent($subtask_id, $time_spent)
- {
- $subtask = $this->subtask->getById($subtask_id);
-
- // Fire the event subtask.update
- return $this->subtask->update(array(
- 'id' => $subtask['id'],
- 'time_spent' => $subtask['time_spent'] + $time_spent,
- 'task_id' => $subtask['task_id'],
- ), false);
- }
-
- /**
- * Update task time tracking based on subtasks time tracking
- *
- * @access public
- * @param integer $task_id Task id
- * @return bool
- */
- public function updateTaskTimeTracking($task_id)
- {
- $values = $this->calculateSubtaskTime($task_id);
-
- return $this->db
- ->table(Task::TABLE)
- ->eq('id', $task_id)
- ->update($values);
- }
-
- /**
- * Sum time spent and time estimated for all subtasks
- *
- * @access public
- * @param integer $task_id Task id
- * @return array
- */
- public function calculateSubtaskTime($task_id)
- {
- return $this->db
- ->table(Subtask::TABLE)
- ->eq('task_id', $task_id)
- ->columns(
- 'SUM(time_spent) AS time_spent',
- 'SUM(time_estimated) AS time_estimated'
- )
- ->findOne();
- }
-}
generated by cgit v1.2.3 (git 2.46.0) at 2024-11-27 11:14:53 +0000