X-Git-Url: https://git.rapsys.eu/airbundle/blobdiff_plain/55e36a4be5160b00a7ec5c2146da4fab5e7da537..98d9c3dc2b46ac796418794aae53b20925d45a8b:/Repository/DanceRepository.php diff --git a/Repository/DanceRepository.php b/Repository/DanceRepository.php index 24ab2b4..251a1ba 100644 --- a/Repository/DanceRepository.php +++ b/Repository/DanceRepository.php @@ -11,18 +11,159 @@ namespace Rapsys\AirBundle\Repository; +use Doctrine\ORM\AbstractQuery; use Doctrine\ORM\Query\ResultSetMapping; +use Rapsys\AirBundle\Repository; + /** * DanceRepository */ -class DanceRepository extends EntityRepository { +class DanceRepository extends Repository { + /** + * Find dances indexed by id + * + * @return array The dances + */ + public function findAllIndexed(): array { + //Set the request + $req = <<tableKeys, $this->tableValues, $req); + + //Get result set mapping instance + //XXX: DEBUG: see ../blog.orig/src/Rapsys/BlogBundle/Repository/ArticleRepository.php + $rsm = new ResultSetMapping(); + + //Declare all fields + //XXX: see vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/Types.php + //addScalarResult($sqlColName, $resColName, $type = 'string'); + $rsm->addEntityResult('Rapsys\AirBundle\Entity\Dance', 'd') + ->addFieldResult('d', 'id', 'id') + ->addFieldResult('d', 'name', 'name') + ->addFieldResult('d', 'type', 'type') + ->addIndexByColumn('d', 'id'); + + //Return return + return $this->_em + ->createNativeQuery($req, $rsm) + ->getResult(); + } + + /** + * Find dance choices as array + * + * @return array The dance choices + */ + public function findChoicesAsArray(): array { + //Set the request + $req = <<tableKeys, $this->tableValues, $req); + + //Get result set mapping instance + //XXX: DEBUG: see ../blog.orig/src/Rapsys/BlogBundle/Repository/ArticleRepository.php + $rsm = new ResultSetMapping(); + + //Declare all fields + //XXX: see vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/Types.php + //addScalarResult($sqlColName, $resColName, $type = 'string'); + $rsm->addScalarResult('name', 'name', 'string') + ->addScalarResult('ids', 'ids', 'string') + ->addScalarResult('types', 'types', 'string') + ->addIndexByScalar('name'); + + //Get result + $result = $this->_em + ->createNativeQuery($req, $rsm) + ->getArrayResult(); + + //Set return + $return = []; + + //Iterate on each name + foreach($result as $name) { + //Set types + $types = []; + + //Explode ids + $name['ids'] = explode("\n", $name['ids']); + + //Explode types + $name['types'] = explode("\n", $name['types']); + + //Iterate on each type + foreach($name['ids'] as $k => $id) { + //Add to types + $types[$this->translator->trans($name['types'][$k]).' ('.$id.')'] = intval($id); + } + + //Add to return + $return[$this->translator->trans($name['name'])] = $types; + } + + //Return return + return $return; + } + + /** + * Find dances ids by nametype + * + * @param array $nametype The nametype filter + * @return array The dance ids + */ + public function findIdByNameTypeAsArray(array $nametype): array { + //Set the request + $req = <<tableKeys, $this->tableValues, $req); + + //Get result set mapping instance + //XXX: DEBUG: see ../blog.orig/src/Rapsys/BlogBundle/Repository/ArticleRepository.php + $rsm = new ResultSetMapping(); + + //Declare all fields + //XXX: see vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/Types.php + //XXX: we don't use a result set as we want to translate group and civility + $rsm->addScalarResult('id', 'id', 'integer'); + + //Return result + return $this->_em + ->createNativeQuery($req, $rsm) + ->setParameter('nametype', $nametype) + //XXX: instead of array_column on the result + ->getResult(AbstractQuery::HYDRATE_SCALAR_COLUMN); + } + /** * Find dance names as array * * @return array The dance names */ - public function findNamesAsArray() { + public function findNamesAsArray(): array { //Set the request $req = << $id, 'type' => $type = $this->translator->trans($name['types'][$k]), 'slug' => $stype = $this->slugger->slug($type), - 'link' => $this->router->generate('rapsys_air_dance_view', ['id' => $id, 'name' => $slug, 'type' => $stype]) + 'link' => $this->router->generate('rapsysair_dance_view', ['id' => $id, 'name' => $slug, 'type' => $stype]) ]; } @@ -88,7 +229,7 @@ SQL; $return[$sname = $this->slugger->short($name['name'])] = [ 'name' => $tname, 'slug' => $slug, - 'link' => $this->router->generate('rapsys_air_dance_name', ['name' => $sname, 'dance' => $slug]), + 'link' => $this->router->generate('rapsysair_dance_name', ['name' => $sname, 'dance' => $slug]), 'types' => $types, 'modified' => $name['modified'] ]; @@ -104,11 +245,11 @@ SQL; * @param $id The user id * @return array The user dances */ - public function findByUserId($userId) { + public function findByUserId($userId): array { //Set the request $req = 'SELECT d.id, d.name, d.type -FROM RapsysAirBundle:UserDance AS ud -JOIN RapsysAirBundle:Dance AS d ON (d.id = ud.dance_id) +FROM Rapsys\AirBundle\Entity\UserDance AS ud +JOIN Rapsys\AirBundle\Entity\Dance AS d ON (d.id = ud.dance_id) WHERE ud.user_id = :uid'; //Replace bundle entity name by table name @@ -119,7 +260,7 @@ WHERE ud.user_id = :uid'; $rsm = new ResultSetMapping(); //Declare result set for our request - $rsm->addEntityResult('RapsysAirBundle:Dance', 'd'); + $rsm->addEntityResult('Rapsys\AirBundle\Entity\Dance', 'd'); $rsm->addFieldResult('d', 'id', 'id'); $rsm->addFieldResult('d', 'name', 'name'); $rsm->addFieldResult('d', 'type', 'type');