diff options
Diffstat (limited to 'makima/src/db/repository.rs')
| -rw-r--r-- | makima/src/db/repository.rs | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/makima/src/db/repository.rs b/makima/src/db/repository.rs index 3d1efd1..36e6bc1 100644 --- a/makima/src/db/repository.rs +++ b/makima/src/db/repository.rs @@ -735,6 +735,7 @@ pub async fn list_tasks(pool: &PgPool) -> Result<Vec<TaskSummary>, sqlx::Error> r#" SELECT t.id, t.contract_id, c.name as contract_name, c.phase as contract_phase, + c.status as contract_status, t.parent_task_id, t.depth, t.name, t.status, t.priority, t.progress_summary, (SELECT COUNT(*) FROM tasks WHERE parent_task_id = t.id) as subtask_count, @@ -755,6 +756,7 @@ pub async fn list_subtasks(pool: &PgPool, parent_id: Uuid) -> Result<Vec<TaskSum r#" SELECT t.id, t.contract_id, c.name as contract_name, c.phase as contract_phase, + c.status as contract_status, t.parent_task_id, t.depth, t.name, t.status, t.priority, t.progress_summary, (SELECT COUNT(*) FROM tasks WHERE parent_task_id = t.id) as subtask_count, @@ -1129,6 +1131,7 @@ pub async fn list_tasks_for_owner( r#" SELECT t.id, t.contract_id, c.name as contract_name, c.phase as contract_phase, + c.status as contract_status, t.parent_task_id, t.depth, t.name, t.status, t.priority, t.progress_summary, (SELECT COUNT(*) FROM tasks WHERE parent_task_id = t.id) as subtask_count, @@ -1154,6 +1157,7 @@ pub async fn list_subtasks_for_owner( r#" SELECT t.id, t.contract_id, c.name as contract_name, c.phase as contract_phase, + c.status as contract_status, t.parent_task_id, t.depth, t.name, t.status, t.priority, t.progress_summary, (SELECT COUNT(*) FROM tasks WHERE parent_task_id = t.id) as subtask_count, @@ -1671,6 +1675,7 @@ pub async fn list_sibling_tasks( r#" SELECT t.id, t.contract_id, c.name as contract_name, c.phase as contract_phase, + c.status as contract_status, t.parent_task_id, t.depth, t.name, t.status, t.priority, t.progress_summary, (SELECT COUNT(*) FROM tasks WHERE parent_task_id = t.id) as subtask_count, @@ -1692,6 +1697,7 @@ pub async fn list_sibling_tasks( r#" SELECT t.id, t.contract_id, c.name as contract_name, c.phase as contract_phase, + c.status as contract_status, t.parent_task_id, t.depth, t.name, t.status, t.priority, t.progress_summary, (SELECT COUNT(*) FROM tasks WHERE parent_task_id = t.id) as subtask_count, @@ -2669,6 +2675,7 @@ pub async fn list_tasks_in_contract( r#" SELECT t.id, t.contract_id, c.name as contract_name, c.phase as contract_phase, + c.status as contract_status, t.parent_task_id, t.depth, t.name, t.status, t.priority, t.progress_summary, (SELECT COUNT(*) FROM tasks WHERE parent_task_id = t.id) as subtask_count, |