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 |