io.milton.cloud.server.apps.signup.GroupSignupsReport.java Source code

Introduction

Here is the source code for io.milton.cloud.server.apps.signup.GroupSignupsReport.java

Source

/*
 * Copyright 2012 McEvoy Software Ltd.
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 * This program 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 this program.  If not, see <http://www.gnu.org/licenses/>.
 */
package io.milton.cloud.server.apps.signup;

import io.milton.cloud.server.apps.reporting.TimeDataPointBean;
import io.milton.cloud.server.db.SignupLog;
import io.milton.cloud.server.web.JsonResult;
import io.milton.cloud.server.web.reporting.GraphData;
import io.milton.cloud.server.web.reporting.JsonReport;
import io.milton.vfs.db.Group;
import io.milton.vfs.db.Organisation;
import io.milton.vfs.db.Profile;
import io.milton.vfs.db.Website;
import io.milton.vfs.db.utils.SessionManager;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.HashSet;
import java.util.List;
import java.util.Map;
import java.util.Set;
import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

/**
 *
 * @author brad
 */
public class GroupSignupsReport implements JsonReport {

    private static final Logger log = LoggerFactory.getLogger(GroupSignupsReport.class);

    @Override
    public String getReportId() {
        return "groupSignups";
    }

    @Override
    public String getTitle(Organisation organisation, Website website) {
        return "Group signups report: " + website.getName();
    }

    @Override
    public GraphData runReport(Organisation org, Website website, Date start, Date finish, JsonResult jsonResult) {
        log.info("runReport: " + start + " - " + finish);
        Session session = SessionManager.session();
        Criteria crit = session.createCriteria(SignupLog.class)
                .setProjection(Projections.projectionList().add(Projections.min("reqDate"))
                        .add(Projections.rowCount()).add(Projections.groupProperty("groupEntity"))
                        .add(Projections.groupProperty("reqYear")).add(Projections.groupProperty("reqMonth"))
                        .add(Projections.groupProperty("reqDay")).add(Projections.groupProperty("reqHour")));
        //        if (start != null) {
        //            crit.add(Restrictions.ge("reqDate", start));
        //        }
        //        if (finish != null) {
        //            crit.add(Restrictions.le("reqDate", finish));
        //        }
        //        if( website != null ) {
        //            crit.add(Restrictions.le("website", website));
        //        }
        //        if( org != null ) {
        //            crit.add(Restrictions.le("organisation", org));
        //        }
        List list = crit.list();
        Set<String> groupsInSeries = new HashSet<>();
        List<Map<String, Object>> dataPoints = new ArrayList<>();
        Map<Long, Map<String, Object>> mapOfDataPointsByTime = new HashMap<>();
        log.info("results: " + list.size());
        for (Object oRow : list) {
            Object[] arr = (Object[]) oRow;
            log.info("got row: " + arr);
            Date date = (Date) arr[0];
            Long time = date.getTime();
            Integer count = (Integer) arr[1];
            Group group = (Group) arr[2];

            groupsInSeries.add(group.getName()); // keep a set of group names for labels

            Map<String, Object> dataPoint = mapOfDataPointsByTime.get(time);
            if (dataPoint == null) {
                dataPoint = new HashMap<>();
                dataPoint.put("date", time);
                mapOfDataPointsByTime.put(time, dataPoint);
                dataPoints.add(dataPoint);
            }
            dataPoint.put(group.getName(), count);

        }
        GraphData graphData = new GraphData();
        graphData.setData(dataPoints);
        String[] labels = { "Signups" };
        graphData.setLabels(labels);
        graphData.setXkey("date");
        String[] ykeys = new String[groupsInSeries.size()];
        groupsInSeries.toArray(ykeys);
        graphData.setYkeys(ykeys);
        log.info("data points: " + dataPoints.size());
        return graphData;
    }

}