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 OrganizationRepo extends BaseRepository {

    public UsageStats getClicks(String organizationId) {

        //String query = "select o.id, o.name , sum (os.numberofviews) from organization o, usagestats.organizationsstats os " +
        //        "where os.organizationid=o.id and o.id=? group by o.id, o.name;";
        //String query = "select '5', maxcount from (select ooid.oid, count(*) as maxcount from usagestats.piwiklog pl, organization_oids ooid " +
        //        "where pl.entityid = ooid.oid and ooid.id=? group by ooid.oid order by count(*) DESC limit 1) as temp";
        String query = "select sum(number_of_views) from organization_stats where id=?";

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

        return executeUsageStats(query, values, "organization");

    }
}