public function updateProject(Project $project)
{
$stmt = $this->db->prepare('INSERT OR REPLACE INTO project (slug, name, repository, branch, command, url_pattern) VALUES (:slug, :name, :repository, :branch, :command, :url_pattern)');
$stmt->bindValue(':slug', $project->getSlug(), SQLITE3_TEXT);
$stmt->bindValue(':name', $project->getName(), SQLITE3_TEXT);
$stmt->bindValue(':repository', $project->getRepository(), SQLITE3_TEXT);
$stmt->bindValue(':branch', $project->getBranch(), SQLITE3_TEXT);
$stmt->bindValue(':command', $project->getCommand(), SQLITE3_TEXT);
$stmt->bindValue(':url_pattern', $project->getUrlPattern(), SQLITE3_TEXT);
if (false === $stmt->execute()) {
// @codeCoverageIgnoreStart
throw new \RuntimeException(sprintf('Unable to save project "%s".', $project->getName()));
// @codeCoverageIgnoreEnd
}
// related commits
$stmt = $this->db->prepare('SELECT sha, author, date, build_date, message, status, output FROM `commit` WHERE slug = :slug ORDER BY build_date DESC LIMIT 100');
$stmt->bindValue(':slug', $project->getSlug(), SQLITE3_TEXT);
if (false === ($results = $stmt->execute())) {
// @codeCoverageIgnoreStart
throw new \RuntimeException(sprintf('Unable to get latest commit for project "%s".', $project->getName()));
// @codeCoverageIgnoreEnd
}
$commits = array();
while ($result = $results->fetchArray(\SQLITE3_ASSOC)) {
$commits[] = $this->createCommit($project, $result);
}
$project->setCommits($commits);
// project building?
$stmt = $this->db->prepare('SELECT COUNT(*) AS count FROM `commit` WHERE slug = :slug AND status = "building"');
$stmt->bindValue(':slug', $project->getSlug(), SQLITE3_TEXT);
$building = false;
if (false !== ($result = $stmt->execute())) {
if (false !== ($result = $result->fetchArray(\SQLITE3_ASSOC))) {
if ($result['count'] > 0) {
$building = true;
}
}
}
$project->setBuilding($building);
}
/**
* Find all tasks in project, and prepare them for objects list
*
* @param Project $project
* @param User $user
* @param int $state
* @return array
*/
static function findForObjectsList(Project $project, User $user, $state = STATE_VISIBLE)
{
$result = array();
$today = strtotime(date('Y-m-d'));
$tasks = DB::execute("SELECT o.id, o.name,\r\n\t\t\t\t\t\to.category_id,\r\n\t\t\t\t\t\to.milestone_id,\r\n\t\t\t\t\t\to.completed_on,\r\n\t\t\t\t\t\to.integer_field_1 as task_id,\r\n\t\t\t\t\t\to.label_id,\r\n\t\t\t\t\t\to.assignee_id,\r\n\t\t\t\t\t\to.priority,\r\n\t\t\t\t\t\to.delegated_by_id,\r\n\t\t\t\t\t\to.state,\r\n\t\t\t\t\t\to.visibility,\r\n\t\t\t\t\t\to.created_on,\r\n\t\t\t\t\t\to.updated_on,\r\n\t\t\t\t\t\to.due_on,\r\n\t\t\t\t\t\trec.tracked_time\r\n\t\t\t\t\tFROM " . TABLE_PREFIX . "project_objects o \r\n\t\t\t\t\tLEFT JOIN (SELECT parent_id, sum(value) tracked_time FROM " . TABLE_PREFIX . "time_records WHERE state = ? GROUP BY(parent_id)) rec ON(o.id=rec.parent_id)\r\n\t\t\t\t\tWHERE o.type = 'Task' AND o.project_id = ? AND o.state = ? AND o.visibility >= ? ORDER BY o.id DESC", $state, $project->getId(), $state, $user->getMinVisibility());
if (is_foreachable($tasks)) {
$task_url = Router::assemble('project_task', array('project_slug' => $project->getSlug(), 'task_id' => '--TASKID--'));
$project_id = $project->getId();
$labels = Labels::getIdDetailsMap('AssignmentLabel');
foreach ($tasks as $task) {
list($total_subtasks, $open_subtasks) = ProjectProgress::getObjectProgress(array('project_id' => $project_id, 'object_type' => 'Task', 'object_id' => $task['id']));
$taskObj = new Task($task['id']);
$result[] = array('id' => $task['id'], 'name' => $task['name'], 'project_id' => $project_id, 'category_id' => $task['category_id'], 'milestone_id' => $task['milestone_id'], 'task_id' => $task['task_id'], 'is_completed' => $task['completed_on'] ? 1 : 0, 'permalink' => str_replace('--TASKID--', $task['task_id'], $task_url), 'label_id' => $task['label_id'], 'label' => $task['label_id'] ? $labels[$task['label_id']] : null, 'assignee_id' => $task['assignee_id'], 'priority' => $task['priority'], 'delegated_by_id' => $task['delegated_by_id'], 'total_subtasks' => $total_subtasks, 'open_subtasks' => $open_subtasks, 'estimated_time' => $taskObj->tracking()->canAdd($user) && $taskObj->tracking()->getEstimate() ? $taskObj->tracking()->getEstimate()->getValue() : 0, 'tracked_time' => $taskObj->tracking()->canAdd($user) ? $task['tracked_time'] : 0, 'is_favorite' => Favorites::isFavorite(array('Task', $task['id']), $user), 'is_archived' => $task['state'] == STATE_ARCHIVED ? 1 : 0, 'visibility' => $task['visibility'], 'created_on' => $task['created_on'] ? $task['created_on'] : $task['updated_on'], 'updated_on' => $task['updated_on'], 'has_attachments' => $taskObj->attachments()->has() ? true : false, 'due_on' => $task['due_on'] ? $task['due_on'] : lang('No due date set'));
}
// foreach
}
// if
return $result;
}
/**
* Set the project.
*
* @param Project|string $project The project or project slug.
*
* @return \CyberSpectrum\Transifex\TranslationResource
*/
public function setProject($project)
{
if ($project instanceof Project) {
$this->project = $project->getSlug();
return $this;
}
$this->project = (string) $project;
return $this;
}
/**
* Find tasks for outline
*
* @param Project $project
* @param User $user
* @param int $state
* @return array
*/
static function findForOutline(Project $project, User $user, $state = STATE_VISIBLE)
{
$today = strtotime(date('Y-m-d'));
$task_ids = DB::executeFirstColumn('SELECT id
FROM ' . TABLE_PREFIX . 'project_objects
WHERE project_id = ?
AND type = ?
AND state >= ?
AND visibility >= ?
AND completed_on IS NULL', $project->getId(), 'Task', $state, $user->getMinVisibility());
if (!is_foreachable($task_ids)) {
return false;
}
// if
$tasks = DB::execute('SELECT o.id,
o.integer_field_1 AS task_id,
o.name,
o.body,
o.due_on,
o.date_field_1 AS start_on,
o.assignee_id,
o.priority,
o.visibility,
o.created_by_id,
o.label_id,
o.milestone_id,
o.category_id,
o.completed_on,
o.delegated_by_id,
o.state,
o.created_on,
o.updated_on,
o.due_on,
u.first_name,
u.last_name
FROM ' . TABLE_PREFIX . 'project_objects o LEFT JOIN ' . TABLE_PREFIX . 'users u ON(o.assignee_id=u.id)
WHERE o.ID IN(?) ORDER BY ' . self::$task_order_by . ' ' . self::$task_sort_by, $task_ids);
// casting
// $tasks->setCasting(array(
// 'due_on' => DBResult::CAST_DATE,
// 'start_on' => DBResult::CAST_DATE
// ));
$tasks_id_prefix_pattern = '--TASK-ID--';
$task_url_params = array('project_slug' => $project->getSlug(), 'task_id' => $tasks_id_prefix_pattern);
$view_task_url_pattern = Router::assemble('project_task', $task_url_params);
$edit_task_url_pattern = Router::assemble('project_task_edit', $task_url_params);
$trash_task_url_pattern = Router::assemble('project_task_trash', $task_url_params);
$subscribe_task_url_pattern = Router::assemble('project_task_subscribe', $task_url_params);
$unsubscribe_task_url_pattern = Router::assemble('project_task_unsubscribe', $task_url_params);
$reschedule_task_url_pattern = Router::assemble('project_task_reschedule', $task_url_params);
$tracking_task_url_pattern = Router::assemble('project_task_tracking', $task_url_params);
// can_manage_tasks
$can_manage_tasks = $user->projects()->getPermission('task', $project) >= ProjectRole::PERMISSION_MANAGE;
// all assignees
$user_assignments_on_tasks = DB::executeFirstColumn('SELECT parent_id FROM ' . TABLE_PREFIX . 'assignments WHERE parent_id IN (?) AND parent_type = ? AND user_id = ?', $task_ids, 'Task', $user->getId());
// all subscriptions
$user_subscriptions_on_tasks = DB::executeFirstColumn('SELECT parent_id FROM ' . TABLE_PREFIX . 'subscriptions WHERE parent_id IN (?) AND parent_type = ? AND user_id = ?', $task_ids, 'Task', $user->getId());
// other assignees
$other_assignees = array();
$raw_other_assignees = DB::execute('SELECT user_id, parent_id FROM ' . TABLE_PREFIX . 'assignments WHERE parent_type = ? AND parent_id IN (?)', 'Task', $task_ids);
foreach ($raw_other_assignees as $raw_assignee) {
if (!is_array($other_assignees[$raw_assignee['parent_id']])) {
$other_assignees[$raw_assignee['parent_id']] = array();
}
// if
$other_assignees[$raw_assignee['parent_id']][] = array('id' => $raw_assignee['user_id']);
}
// foreach
// expenses & time
$expenses = array();
$time = array();
$estimates = array();
if (AngieApplication::isModuleLoaded('tracking')) {
$raw_expenses = DB::execute('SELECT parent_id, SUM(value) as expense FROM ' . TABLE_PREFIX . 'expenses WHERE parent_id IN (?) AND parent_type = ? GROUP BY parent_id', $task_ids, 'Task');
if (is_foreachable($raw_expenses)) {
foreach ($raw_expenses as $raw_expense) {
$expenses[$raw_expense['parent_id']] = $raw_expense['expense'];
}
// if
}
// if
$raw_time = DB::execute('SELECT parent_id, SUM(value) as time FROM ' . TABLE_PREFIX . 'time_records WHERE parent_id IN (?) AND parent_type = ? GROUP BY parent_id', $task_ids, 'Task');
if (is_foreachable($raw_time)) {
foreach ($raw_time as $raw_single_time) {
$time[$raw_single_time['parent_id']] = $raw_single_time['time'];
}
// foreach
}
// if
$raw_estimates = DB::execute('SELECT parent_id, value, job_type_id FROM (SELECT * FROM ' . TABLE_PREFIX . 'estimates WHERE parent_id IN (?) AND parent_type = ? ORDER BY created_on DESC) as estimates_inverted GROUP BY parent_id', $task_ids, 'Task');
if (is_foreachable($raw_estimates)) {
foreach ($raw_estimates as $raw_estimate) {
$estimates[$raw_estimate['parent_id']] = array('value' => $raw_estimate['value'], 'job_type_id' => $raw_estimate['job_type_id']);
}
// foreach
}
// if
}
// if
$task_url = Router::assemble('project_task', array('project_slug' => $project->getSlug(), 'task_id' => '--TASKID--'));
$project_id = $project->getId();
$labels = Labels::getIdDetailsMap('AssignmentLabel');
$results = array();
foreach ($tasks as $subobject) {
$task_id = array_var($subobject, 'id');
$task_task_id = array_var($subobject, 'task_id');
list($total_subtasks, $open_subtasks) = ProjectProgress::getObjectProgress(array('project_id' => $project_id, 'object_type' => 'Task', 'object_id' => $subobject['id']));
$results[] = array('id' => $task_id, 'task_id' => $task_task_id, 'name' => array_var($subobject, 'name'), 'body' => array_var($subobject, 'body'), 'priority' => array_var($subobject, 'priority'), 'milestone_id' => array_var($subobject, 'milestone_id', null), 'class' => 'Task', 'start_on' => array_var($subobject, 'start_on'), 'assignee_id' => array_var($subobject, 'assignee_id'), 'other_assignees' => array_var($other_assignees, $task_id, null), 'label_id' => array_var($subobject, 'label_id', null), 'label' => $subobject['label_id'] ? $labels[$subobject['label_id']] : null, 'project_id' => $project_id, 'category_id' => $subobject['category_id'], 'is_completed' => $subobject['completed_on'] ? 1 : 0, 'permalink' => str_replace('--TASKID--', $subobject['task_id'], $task_url), 'priority' => self::$priority_map[$subobject['priority']], 'delegated_by_id' => $subobject['delegated_by_id'], 'total_subtasks' => $total_subtasks, 'open_subtasks' => $open_subtasks, 'is_favorite' => Favorites::isFavorite(array('Task', $task_id), $user), 'is_archived' => $subobject['state'] == STATE_ARCHIVED ? 1 : 0, 'visibility' => $subobject['visibility'], 'created_on' => $subobject['created_on'] ? $subobject['created_on'] : $subobject['updated_on'], 'updated_on' => $subobject['updated_on'], 'assignee_name' => $subobject['first_name'] . " " . $subobject['last_name'], 'due_on' => $subobject['due_on'] ? $subobject['due_on'] : lang('No due date set'), 'stato' => $subobject['due_on'] ? $subobject['due_on'] >= $today ? 'orario' : 'ritardo' : 'not_set', 'user_is_subscribed' => in_array($task_id, $user_subscriptions_on_tasks), 'object_time' => array_var($time, $task_id, 0), 'object_expenses' => array_var($expenses, $task_id, 0), 'estimate' => array_var($estimates, $task_id, null), 'event_names' => array('updated' => 'task_updated'), 'urls' => array('view' => str_replace($tasks_id_prefix_pattern, $task_task_id, $view_task_url_pattern), 'edit' => str_replace($tasks_id_prefix_pattern, $task_task_id, $edit_task_url_pattern), 'trash' => str_replace($tasks_id_prefix_pattern, $task_task_id, $trash_task_url_pattern), 'subscribe' => str_replace($tasks_id_prefix_pattern, $task_task_id, $subscribe_task_url_pattern), 'unsubscribe' => str_replace($tasks_id_prefix_pattern, $task_task_id, $unsubscribe_task_url_pattern), 'reschedule' => str_replace($tasks_id_prefix_pattern, $task_task_id, $reschedule_task_url_pattern), 'tracking' => str_replace($tasks_id_prefix_pattern, $task_task_id, $tracking_task_url_pattern)), 'permissions' => array('can_edit' => can_edit_project_object($subobject, $user, $project, $can_manage_tasks, $user_assignments_on_tasks), 'can_trash' => can_trash_project_object($subobject, $user, $project, $can_manage_tasks, $user_assignments_on_tasks)));
}
// foreach
return $results;
}
