comparison: src/main/kotlin/de/uapcore/lightpit/dao/PostgresDataAccessObject.kt
src/main/kotlin/de/uapcore/lightpit/dao/PostgresDataAccessObject.kt
- changeset 257
- c1be672af7ff
- parent 248
- 90dc13c78b5d
- child 260
- fb2ae2d63a56
equal
deleted
inserted
replaced
| 256:a7da88714dc3 | 257:c1be672af7ff |
|---|---|
| 442 } | 442 } |
| 443 summary | 443 summary |
| 444 } | 444 } |
| 445 } | 445 } |
| 446 | 446 |
| 447 override fun collectIssueSummary(assignee: User): IssueSummary = | |
| 448 withStatement( | |
| 449 """ | |
| 450 select phase, count(*) as total | |
| 451 from lpit_issue | |
| 452 join lpit_issue_phases using(status) | |
| 453 where assignee = ? | |
| 454 group by phase | |
| 455 """.trimIndent() | |
| 456 ) { | |
| 457 setInt(1, assignee.id) | |
| 458 executeQuery().use { | |
| 459 val summary = IssueSummary() | |
| 460 while (it.next()) { | |
| 461 val phase = it.getInt("phase") | |
| 462 val total = it.getInt("total") | |
| 463 when (phase) { | |
| 464 0 -> summary.open = total | |
| 465 1 -> summary.active = total | |
| 466 2 -> summary.done = total | |
| 467 } | |
| 468 } | |
| 469 summary | |
| 470 } | |
| 471 } | |
| 472 | |
| 447 //</editor-fold> | 473 //</editor-fold> |
| 448 | 474 |
| 449 //<editor-fold desc="Issue"> | 475 //<editor-fold desc="Issue"> |
| 450 | 476 |
| 451 //language=SQL | 477 //language=SQL |
