io.lavagna.service.StatisticsService.java Source code

Introduction

Here is the source code for io.lavagna.service.StatisticsService.java

Source

/**
 * This file is part of lavagna.
 *
 * lavagna is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * lavagna is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with lavagna.  If not, see <http://www.gnu.org/licenses/>.
 */
package io.lavagna.service;

import io.lavagna.model.CardFull;
import io.lavagna.model.ColumnDefinition;
import io.lavagna.model.EventsCount;
import io.lavagna.model.LabelAndValueWithCount;
import io.lavagna.model.LabelListValue;
import io.lavagna.model.MilestoneCount;
import io.lavagna.model.Pair;
import io.lavagna.model.StatisticsResult;
import io.lavagna.query.StatisticsQuery;

import java.util.Date;
import java.util.EnumMap;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.commons.lang3.ObjectUtils;
import org.springframework.dao.EmptyResultDataAccessException;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

@Service
@Transactional(readOnly = true)
public class StatisticsService {

    private final StatisticsQuery queries;

    public StatisticsService(StatisticsQuery queries) {
        this.queries = queries;
    }

    @Transactional(readOnly = false)
    public void snapshotCardsStatus() {

        queries.snapshotCardsStatus(new Date());

        queries.cleanOldCardsStatusSnapshots();
    }

    private Map<Long, Map<ColumnDefinition, Long>> toStatusByDay(List<StatisticsResult> results) {
        Map<Long, Map<ColumnDefinition, Long>> statusByDay = new HashMap<>();
        for (StatisticsResult result : results) {
            if (!statusByDay.containsKey(result.getDay())) {
                statusByDay.put(result.getDay(), new EnumMap<ColumnDefinition, Long>(ColumnDefinition.class));
            }
            Map<ColumnDefinition, Long> day = statusByDay.get(result.getDay());
            day.put(result.getColumnDefinition(), result.getCount());
        }
        return statusByDay;
    }

    public Map<Long, Map<ColumnDefinition, Long>> getCardsStatusByBoard(int boardId, Date fromDate) {
        return toStatusByDay(queries.getCardsStatusByBoard(boardId, fromDate));
    }

    public Map<Long, Map<ColumnDefinition, Long>> getCardsStatusByProject(int projectId, Date fromDate) {
        return toStatusByDay(queries.getCardsStatusByProject(projectId, fromDate));
    }

    public Integer getActiveUsersOnBoard(int boardId, Date fromDate) {
        return queries.getActiveUsersOnBoard(boardId, fromDate);
    }

    public Integer getActiveUsersOnProject(int projectId, Date fromDate) {
        return queries.getActiveUsersOnProject(projectId, fromDate);
    }

    // Average users per card

    public double getAverageUsersPerCardOnBoard(int boardId) {
        return ObjectUtils.<Double>firstNonNull(queries.getAverageUsersPerCardOnBoard(boardId), 0d);
    }

    public double getAverageUsersPerCardOnProject(int projectId) {
        return ObjectUtils.<Double>firstNonNull(queries.getAverageUsersPerCardOnProject(projectId), 0d);
    }

    // Average cards per user

    public double getAverageCardsPerUserOnBoard(int boardId) {
        return ObjectUtils.<Double>firstNonNull(queries.getAverageCardsPerUserOnBoard(boardId), 0d);
    }

    public double getAverageCardsPerUserOnProject(int projectId) {
        return ObjectUtils.<Double>firstNonNull(queries.getAverageCardsPerUserOnProject(projectId), 0d);
    }

    // Cards by label

    public List<LabelAndValueWithCount> getCardsByLabelOnBoard(int boardId) {
        return queries.getCardsByLabelOnBoard(boardId);
    }

    public List<LabelAndValueWithCount> getCardsByLabelOnProject(int projectId) {
        return queries.getCardsByLabelOnProject(projectId);
    }

    // Created / closed cards

    private Map<Long, Pair<Long, Long>> mergeCounts(List<EventsCount> createdCards, List<EventsCount> closedCards) {
        Map<Long, Pair<Long, Long>> counts = new HashMap<>();
        for (EventsCount count : createdCards) {
            counts.put(count.getDate(), new Pair<>(count.getCount(), 0l));
        }
        for (EventsCount count : closedCards) {
            long created = 0;
            if (counts.containsKey(count.getDate())) {
                created = counts.get(count.getDate()).getFirst();
                counts.remove(count.getDate());
            }
            counts.put(count.getDate(), new Pair<>(created, count.getCount()));
        }
        return counts;
    }

    public Map<Long, Pair<Long, Long>> getCreatedAndClosedCardsByBoard(int boardId, Date fromDate) {
        return mergeCounts(queries.getCreatedCardsByBoard(boardId, fromDate),
                queries.getClosedCardsByBoard(boardId, fromDate));
    }

    public Map<Long, Pair<Long, Long>> getCreatedAndClosedCardsByProject(int projectId, Date fromDate) {
        return mergeCounts(queries.getCreatedCardsByProject(projectId, fromDate),
                queries.getClosedCardsByProject(projectId, fromDate));
    }

    // Most active card

    public CardFull getMostActiveCardByBoard(int boardId, Date fromDate) {
        try {
            return queries.getMostActiveCardByBoard(boardId, fromDate);
        } catch (EmptyResultDataAccessException ex) {
            return null;
        }
    }

    public CardFull getMostActiveCardByProject(int projectId, Date fromDate) {
        try {
            return queries.getMostActiveCardByProject(projectId, fromDate);
        } catch (EmptyResultDataAccessException ex) {
            return null;
        }
    }

    // Milestones

    public Map<Long, Pair<Long, Long>> getAssignedAndClosedCardsByMilestone(LabelListValue milestone,
            Date fromDate) {
        return mergeCounts(queries.getAssignedCardsByMilestone(milestone.getValue(), fromDate),
                queries.getClosedCardsByMilestone(milestone.getId(), fromDate));
    }

    public List<MilestoneCount> findCardsCountByMilestone(int projectId) {
        return queries.findCardsCountByMilestone(projectId);
    }
}