ProjetNormandie\ComptaBundle\Repository\DonationRepository

Complexity

Total Complexity

2

Size/Duplication

Total Lines	18
Duplicated Lines	0 %

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	getDonors()	0	11	1
A	__construct()	0	3	1

<?php

namespace ProjetNormandie\ComptaBundle\Repository;

use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
use Doctrine\ORM\Query\ResultSetMappingBuilder;
use Doctrine\Persistence\ManagerRegistry;
use ProjetNormandie\ComptaBundle\Entity\Donation;

class DonationRepository extends ServiceEntityRepository
{
    public function __construct(ManagerRegistry $registry)
    {
        parent::__construct($registry, Donation::class);
    }

    public function getDonors()
    {
        $rsm = new ResultSetMappingBuilder($this->_em);
        $rsm->addRootEntityFromClassMetadata('ProjetNormandie\ComptaBundle\Entity\UserInterface', 'u');
        $query = $this->_em->createNativeQuery(
            "SELECT distinct user.id, user.username, user.avatar, user.slug 
            FROM cpt_donation INNER JOIN user ON cpt_donation.idUser = user.id ORDER BY user.id DESC",
            $rsm
        );

        return $query->getResult();
    }
}