package eu.dnetlib.usagestats.repos;


import eu.dnetlib.usagestats.portal.UsageStats;

import org.springframework.stereotype.Repository;

import java.util.ArrayList;
import java.util.List;


@Repository
public class ProjectRepo extends BaseRepository {

    public UsageStats getClicks(String projectId) {
        String query = "SELECT 'views', sum(s.count), sum(s.openaire) FROM views_stats s, project_results pr where pr.result=s.result_id and pr.id=? " +
                "UNION ALL SELECT 'downloads', sum(s.count), sum(s.openaire) FROM downloads_stats s, project_results pr where pr.result=s.result_id and pr.id=? " +
                "UNION ALL SELECT 'pageviews', sum(s.count), '0' FROM pageviews_stats s, project_results pr where pr.result=s.result_id and pr.id=?;";

        List<String> values = new ArrayList<>();
        values.add(projectId);
        values.add(projectId);
        values.add(projectId);

        return executeUsageStats(query, values, "project");
    }
}