src/Repository/SocietyGroupRepository.php line 16

Open in your IDE?
  1. <?php
  3. namespace App\Repository;
  5. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  6. use Doctrine\Persistence\ManagerRegistry;
  8. use App\Entity\SocietyGroup;
  9. use App\Services\LogTools;
  11. class SocietyGroupRepository extends ServiceEntityRepository
  12. {
  13.     public function __construct(ManagerRegistry $registry, LogTools $logTools)
  14.     {
  15.         parent::__construct($registry, SocietyGroup::class);
  16.         $this->logTools = $logTools;
  17.     }
  19.     public function getOrderedBy_QB($field = null, $order = null)
  20.     {
  21.         $query = $this->createQueryBuilder('object');
  23.         if ($field !== null)
  24.         {
  25.             if ($order !== null)
  26.             {
  27.                 $query->addOrderBy('object.'.$field, $order);
  28.             }
  29.             else
  30.             {
  31.                 $query->addOrderBy('object.'.$field, 'ASC');
  32.             }
  33.         }
  34.         else
  35.         {
  36.             $query->addOrderBy('object.ref', 'ASC');
  37.         }
  39.         return $query;
  40.     }
  42.     public function getOrderedBy($field = null, $order = null)
  43.     {
  44.         $query = $this->getOrderedBy_QB($field, $order);
  45.         return $query->getQuery()->getResult();
  46.     }
  48.     public function getApplicationSocietyGroup()
  49.     {
  50.         $query = $this->createQueryBuilder('societyGroup');
  51.         $query->andWhere("societyGroup.application IS NOT NULL");
  53.         return $query->getQuery()->getResult();
  54.     }
  56.     public function countForActivity($activity)
  57.     {
  58.         $query = $this->createQueryBuilder('societyGroup');
  59.         $query->select('COUNT(DISTINCT societyGroup)');
  60.         $query->join('societyGroup.activities', 'activity');
  61.         $query->where('activity.id = '.$activity->getId());
  62.         return $query->getQuery()->getSingleScalarResult();
  63.     }
  65.     public function getShareManagers_QB()
  66.     {
  67.         $query = $this->createQueryBuilder('societyGroup');
  68.         $query->andWhere('societyGroup.isActive = 1');
  69.         $query->andWhere('societyGroup.rekto = 0');
  70.         $query->addOrderBy('societyGroup.ref', 'ASC');
  71.         return $query;
  72.     }
  74. //    /**
  75. //     * @return SocietyGroup[] Returns an array of SocietyGroup objects
  76. //     */
  77. //    public function findByExampleField($value): array
  78. //    {
  79. //        return $this->createQueryBuilder('s')
  80. //            ->andWhere('s.exampleField = :val')
  81. //            ->setParameter('val', $value)
  82. //            ->orderBy('s.id', 'ASC')
  83. //            ->setMaxResults(10)
  84. //            ->getQuery()
  85. //            ->getResult()
  86. //        ;
  87. //    }
  89. //    public function findOneBySomeField($value): ?SocietyGroup
  90. //    {
  91. //        return $this->createQueryBuilder('s')
  92. //            ->andWhere('s.exampleField = :val')
  93. //            ->setParameter('val', $value)
  94. //            ->getQuery()
  95. //            ->getOneOrNullResult()
  96. //        ;
  97. //    }
  98. }