From: Raphaƫl Gertz Date: Mon, 28 Dec 2020 07:50:19 +0000 (+0100) Subject: Add findOrganizerGroupedByGroup function X-Git-Tag: 0.1.7~19 X-Git-Url: https://git.rapsys.eu/airbundle/commitdiff_plain/186cf9c608b4ba575917e6833621cf3a0f9cd624 Add findOrganizerGroupedByGroup function --- diff --git a/Repository/UserRepository.php b/Repository/UserRepository.php index 9f112ee..8991bf4 100644 --- a/Repository/UserRepository.php +++ b/Repository/UserRepository.php @@ -122,4 +122,109 @@ class UserRepository extends \Doctrine\ORM\EntityRepository { //Send result return $ret; } + + /** + * Find all organizer grouped by translated group + * + * @param $translator The TranslatorInterface instance + * @return array|null The organizer array or null + */ + public function findOrganizerGroupedByGroup(TranslatorInterface $translator) { + //Get entity manager + $em = $this->getEntityManager(); + + //Get quote strategy + $qs = $em->getConfiguration()->getQuoteStrategy(); + $dp = $em->getConnection()->getDatabasePlatform(); + + //Get quoted table names + //XXX: this allow to make this code table name independent + $tables = [ + 'RapsysAirBundle:GroupUser' => $qs->getJoinTableName($em->getClassMetadata('RapsysAirBundle:User')->getAssociationMapping('groups'), $em->getClassMetadata('RapsysAirBundle:User'), $dp), + 'RapsysAirBundle:Group' => $qs->getTableName($em->getClassMetadata('RapsysAirBundle:Group'), $dp), + 'RapsysAirBundle:User' => $qs->getTableName($em->getClassMetadata('RapsysAirBundle:User'), $dp), + //XXX: Set limit used to workaround mariadb subselect optimization + ':limit' => PHP_INT_MAX, + "\t" => '', + "\n" => ' ' + ]; + + //Set the request + $req = <<addScalarResult('id', 'id', 'integer') + ->addScalarResult('pseudonym', 'pseudonym', 'string') + ->addScalarResult('g_id', 'g_id', 'integer') + ->addScalarResult('g_title', 'g_title', 'string') + ->addIndexByScalar('id'); + + //Fetch result + $res = $em + ->createNativeQuery($req, $rsm) + ->getResult(); + + //Init return + $ret = []; + + //Process result + foreach($res as $data) { + //Get translated group + $group = $translator->trans($data['g_title']?:'User'); + + //Init group subarray + if (!isset($ret[$group])) { + $ret[$group] = []; + } + + //Set data + $ret[$group][$data['id']] = $data['pseudonym']; + } + + //Send result + return $ret; + + header('Content-Type: text/plain'); + var_dump($ret); + exit; + + //Get entity manager + $em = $this->getEntityManager(); + + //Fetch sessions + $ret = $this->getEntityManager() + ->createQuery('SELECT u.id, u.pseudonym, g.title FROM RapsysAirBundle:User u JOIN RapsysAirBundle:GroupUser gu WITH gu.user = u.id JOIN RapsysAirBundle:Group g WITH g.id = gu.group GROUP BY u.id ORDER BY g.id DESC') + ->getResult(); + + header('Content-Type: text/plain'); + var_dump($ret); + exit; + + //Process result + $ret = array_column($ret, 'id', 'pseudonym'); + + //Send result + return $ret; + } }