| | <?php |
| |
|
| | require_once __DIR__.'/../Base.php'; |
| |
|
| | use Kanboard\Model\ProjectModel; |
| | use Kanboard\Model\ProjectDailyColumnStatsModel; |
| | use Kanboard\Model\ConfigModel; |
| | use Kanboard\Model\TaskModel; |
| | use Kanboard\Model\TaskCreationModel; |
| |
|
| | class ProjectDailyColumnStatsTest extends Base |
| | { |
| | public function testUpdateTotalsWithScoreAtNull() |
| | { |
| | $projectModel = new ProjectModel($this->container); |
| | $projectDailyColumnStats = new ProjectDailyColumnStatsModel($this->container); |
| | $taskCreationModel = new TaskCreationModel($this->container); |
| |
|
| | $this->assertEquals(1, $projectModel->create(array('name' => 'UnitTest'))); |
| | $this->assertEquals(1, $taskCreationModel->create(array('project_id' => 1, 'title' => 'test'))); |
| |
|
| | $projectDailyColumnStats->updateTotals(1, '2016-01-16'); |
| |
|
| | $task = $this->container['db']->table(TaskModel::TABLE)->findOne(); |
| | $this->assertNull($task['score']); |
| |
|
| | $stats = $this->container['db']->table(ProjectDailyColumnStatsModel::TABLE) |
| | ->asc('day') |
| | ->asc('column_id') |
| | ->columns('day', 'project_id', 'column_id', 'total', 'score') |
| | ->findAll(); |
| |
|
| | $expected = array( |
| | array( |
| | 'day' => '2016-01-16', |
| | 'project_id' => 1, |
| | 'column_id' => 1, |
| | 'total' => 1, |
| | 'score' => 0, |
| | ), |
| | ); |
| |
|
| | $this->assertEquals($expected, $stats); |
| | } |
| |
|
| | public function testUpdateTotals() |
| | { |
| | $projectModel = new ProjectModel($this->container); |
| | $projectDailyColumnStats = new ProjectDailyColumnStatsModel($this->container); |
| | $this->assertEquals(1, $projectModel->create(array('name' => 'UnitTest'))); |
| |
|
| | $this->createTasks(1, 2, 1); |
| | $this->createTasks(1, 3, 0); |
| |
|
| | $this->createTasks(2, 5, 1); |
| | $this->createTasks(2, 8, 1); |
| | $this->createTasks(2, 0, 0); |
| | $this->createTasks(2, 0, 0); |
| |
|
| | $projectDailyColumnStats->updateTotals(1, '2016-01-16'); |
| |
|
| | $this->createTasks(1, 9, 1); |
| | $this->createTasks(1, 7, 0); |
| |
|
| | $projectDailyColumnStats->updateTotals(1, '2016-01-16'); |
| |
|
| | $this->createTasks(3, 0, 1); |
| |
|
| | $projectDailyColumnStats->updateTotals(1, '2016-01-17'); |
| |
|
| | $stats = $this->container['db']->table(ProjectDailyColumnStatsModel::TABLE) |
| | ->asc('day') |
| | ->asc('column_id') |
| | ->columns('day', 'project_id', 'column_id', 'total', 'score') |
| | ->findAll(); |
| |
|
| | $expected = array( |
| | array( |
| | 'day' => '2016-01-16', |
| | 'project_id' => 1, |
| | 'column_id' => 1, |
| | 'total' => 4, |
| | 'score' => 11, |
| | ), |
| | array( |
| | 'day' => '2016-01-16', |
| | 'project_id' => 1, |
| | 'column_id' => 2, |
| | 'total' => 4, |
| | 'score' => 13, |
| | ), |
| | array( |
| | 'day' => '2016-01-17', |
| | 'project_id' => 1, |
| | 'column_id' => 1, |
| | 'total' => 4, |
| | 'score' => 11, |
| | ), |
| | array( |
| | 'day' => '2016-01-17', |
| | 'project_id' => 1, |
| | 'column_id' => 2, |
| | 'total' => 4, |
| | 'score' => 13, |
| | ), |
| | array( |
| | 'day' => '2016-01-17', |
| | 'project_id' => 1, |
| | 'column_id' => 3, |
| | 'total' => 1, |
| | 'score' => 0, |
| | ), |
| | ); |
| |
|
| | $this->assertEquals($expected, $stats); |
| | } |
| |
|
| | public function testUpdateTotalsWithOnlyOpenTasks() |
| | { |
| | $configModel = new ConfigModel($this->container); |
| | $projectModel = new ProjectModel($this->container); |
| | $projectDailyColumnStats = new ProjectDailyColumnStatsModel($this->container); |
| |
|
| | $this->assertEquals(1, $projectModel->create(array('name' => 'UnitTest'))); |
| | $this->assertTrue($configModel->save(array('cfd_include_closed_tasks' => 0))); |
| | $this->container['memoryCache']->flush(); |
| |
|
| | $this->createTasks(1, 2, 1); |
| | $this->createTasks(1, 3, 0); |
| |
|
| | $this->createTasks(2, 5, 1); |
| | $this->createTasks(2, 8, 1); |
| | $this->createTasks(2, 0, 0); |
| | $this->createTasks(2, 0, 0); |
| |
|
| | $projectDailyColumnStats->updateTotals(1, '2016-01-16'); |
| |
|
| | $this->createTasks(1, 9, 1); |
| | $this->createTasks(1, 7, 0); |
| |
|
| | $projectDailyColumnStats->updateTotals(1, '2016-01-16'); |
| |
|
| | $this->createTasks(3, 0, 1); |
| |
|
| | $projectDailyColumnStats->updateTotals(1, '2016-01-17'); |
| |
|
| | $stats = $this->container['db']->table(ProjectDailyColumnStatsModel::TABLE) |
| | ->asc('day') |
| | ->asc('column_id') |
| | ->columns('day', 'project_id', 'column_id', 'total', 'score') |
| | ->findAll(); |
| |
|
| | $expected = array( |
| | array( |
| | 'day' => '2016-01-16', |
| | 'project_id' => 1, |
| | 'column_id' => 1, |
| | 'total' => 2, |
| | 'score' => 11, |
| | ), |
| | array( |
| | 'day' => '2016-01-16', |
| | 'project_id' => 1, |
| | 'column_id' => 2, |
| | 'total' => 2, |
| | 'score' => 13, |
| | ), |
| | array( |
| | 'day' => '2016-01-17', |
| | 'project_id' => 1, |
| | 'column_id' => 1, |
| | 'total' => 2, |
| | 'score' => 11, |
| | ), |
| | array( |
| | 'day' => '2016-01-17', |
| | 'project_id' => 1, |
| | 'column_id' => 2, |
| | 'total' => 2, |
| | 'score' => 13, |
| | ), |
| | array( |
| | 'day' => '2016-01-17', |
| | 'project_id' => 1, |
| | 'column_id' => 3, |
| | 'total' => 1, |
| | 'score' => 0, |
| | ), |
| | ); |
| |
|
| | $this->assertEquals($expected, $stats); |
| | } |
| |
|
| | public function testCountDays() |
| | { |
| | $projectModel = new ProjectModel($this->container); |
| | $projectDailyColumnStats = new ProjectDailyColumnStatsModel($this->container); |
| |
|
| | $this->assertEquals(1, $projectModel->create(array('name' => 'UnitTest'))); |
| |
|
| | $this->createTasks(1, 2, 1); |
| | $projectDailyColumnStats->updateTotals(1, '2016-01-16'); |
| | $this->assertEquals(1, $projectDailyColumnStats->countDays(1, '2016-01-16', '2016-01-17')); |
| |
|
| | $projectDailyColumnStats->updateTotals(1, '2016-01-17'); |
| | $this->assertEquals(2, $projectDailyColumnStats->countDays(1, '2016-01-16', '2016-01-17')); |
| | } |
| |
|
| | public function testGetAggregatedMetrics() |
| | { |
| | $projectModel = new ProjectModel($this->container); |
| | $projectDailyColumnStats = new ProjectDailyColumnStatsModel($this->container); |
| | $this->assertEquals(1, $projectModel->create(array('name' => 'UnitTest'))); |
| |
|
| | $this->createTasks(1, 2, 1); |
| | $this->createTasks(1, 3, 0); |
| |
|
| | $this->createTasks(2, 5, 1); |
| | $this->createTasks(2, 8, 1); |
| | $this->createTasks(2, 0, 0); |
| | $this->createTasks(2, 0, 0); |
| |
|
| | $projectDailyColumnStats->updateTotals(1, '2016-01-16'); |
| |
|
| | $this->createTasks(1, 9, 1); |
| | $this->createTasks(1, 7, 0); |
| |
|
| | $projectDailyColumnStats->updateTotals(1, '2016-01-16'); |
| |
|
| | $this->createTasks(3, 0, 1); |
| |
|
| | $projectDailyColumnStats->updateTotals(1, '2016-01-17'); |
| |
|
| | $this->createTasks(2, 1, 1); |
| | $this->createTasks(3, 1, 1); |
| | $this->createTasks(3, 0, 1); |
| |
|
| | $projectDailyColumnStats->updateTotals(1, '2016-01-18'); |
| |
|
| | $expected = array( |
| | array('Date', 'Backlog', 'Ready', 'Work in progress', 'Done'), |
| | array('2016-01-16', 4, 4, 0, 0), |
| | array('2016-01-17', 4, 4, 1, 0), |
| | array('2016-01-18', 4, 5, 3, 0), |
| | ); |
| |
|
| | $this->assertSame($expected, $projectDailyColumnStats->getAggregatedMetrics(1, '2016-01-16', '2016-01-18')); |
| |
|
| | $expected = array( |
| | array('Date', 'Backlog', 'Ready', 'Work in progress', 'Done'), |
| | array('2016-01-16', 11, 13, 0, 0), |
| | array('2016-01-17', 11, 13, 0, 0), |
| | array('2016-01-18', 11, 14, 1, 0), |
| | ); |
| |
|
| | $this->assertSame($expected, $projectDailyColumnStats->getAggregatedMetrics(1, '2016-01-16', '2016-01-18', 'score')); |
| | } |
| |
|
| | private function createTasks($column_id, $score, $is_active) |
| | { |
| | $taskCreationModel = new TaskCreationModel($this->container); |
| | $this->assertNotFalse($taskCreationModel->create(array('project_id' => 1, 'title' => 'test', 'column_id' => $column_id, 'score' => $score, 'is_active' => $is_active))); |
| | } |
| | } |
| |
|
