diegoangel / informe-gei

            ->getResult();

    }

    public function findSubactivityByYearSectorAndActivity($year, $sector, $activity)

    {

        $dql = 'SELECT sa.id as subactivity, 

                sa.name, 

                SUM(e.value) as total

            FROM Api\Entity\Emission e 

            INNER JOIN e.subactivity sa

            WHERE e.value > 0

            AND e.sector = :sector

            AND e.activity = :activity

            AND e.year = :year

            GROUP BY e.subactivity

            ORDER BY sa.name';

        return $this->getEntityManager()->createQuery($dql)

            ->setParameter('year', $year)

            ->setParameter('sector', $sector)

            ->setParameter('activity', $activity)

            ->getResult();

    }

    public function findCategoryByYearSectorActivityAndSubactivity($year, $sector, $activity, $subactivity)

    {

            ->getResult();

    }

    public function findCategoryByYearSectorActivityAndSubactivity($year, $sector, $activity, $subactivity)

    {

        $dql = 'SELECT c.id as category, 

                c.name,

                SUM(e.value) as total

            FROM Api\Entity\Emission e 

            INNER JOIN e.category c

            WHERE e.value > 0

            AND e.sector = :sector

            AND e.activity = :activity

            AND e.subactivity = :subactivity

            AND e.year = :year

            GROUP BY e.category

            ORDER BY c.name';

        return $this->getEntityManager()->createQuery($dql)

            ->setParameter('year', $year)

            ->setParameter('sector', $sector)

            ->setParameter('activity', $activity)

            ->setParameter('subactivity', $subactivity)

            ->getResult();

    }

    public function findGasesByYear($year)

    {