src/Repository/Events/EventsRepository.php line 77

Open in your IDE?
  1. <?php
  3. namespace App\Repository\Events;
  5. use Doctrine\ORM\Query;
  6. use App\Entity\Events\Events;
  7. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  8. use Doctrine\Persistence\ManagerRegistry;
  10. /**
  11.  * @method Events|null find($id, $lockMode = null, $lockVersion = null)
  12.  * @method Events|null findOneBy(array $criteria, array $orderBy = null)
  13.  * @method Events[]    findAll()
  14.  * @method Events[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  15.  */
  16. class EventsRepository extends ServiceEntityRepository
  17. {
  18.     public function __construct(ManagerRegistry $registry)
  19.     {
  20.         parent::__construct($registry, Events::class);
  21.     }
  23.     public function findByRange($startrange, $endrange, $status = 'inactive') {
  24.         return $this->createQueryBuilder('e')
  25.         ->andWhere('e.start_day >= :starts AND e.start_day <= :ends AND e.status = :status')
  26.         ->setParameter('starts', $startrange)
  27.         ->setParameter('ends', $endrange)
  28.         ->setParameter('status', $status)
  29.         ->addOrderBy('e.start_day', 'ASC')
  30.         ->setMaxResults(500)
  31.         ->getQuery()
  32.         ->getResult(Query::HYDRATE_ARRAY)
  33.         ;
  34.     }
  36.     public function testGrouping($token) {
  37.         return $this->createQueryBuilder('e')
  38.             ->andWhere('e.token = :token')
  39.             ->setParameter('token', $token)
  40.             ->orderBy('e.start_day', 'ASC')
  41.             ->setMaxResults(1)
  42.             ->getQuery()
  43.             ->getOneOrNullResult()
  44.         ;
  45.     }
  47.     public function xtestGrouping($name, $city, $state) {
  48.         return $this->createQueryBuilder('e')
  49.             ->andWhere('e.name = :name')
  50.             ->setParameter('name', $name)
  51.             ->andWhere('e.city = :city')
  52.             ->setParameter('city', $city)
  53.             ->andWhere('e.state = :state')
  54.             ->setParameter('state', $state)
  55.             ->orderBy('e.start_day', 'ASC')
  56.             ->setMaxResults(1)
  57.             ->getQuery()
  58.             ->getOneOrNullResult()
  59.         ;
  60.     }
  62.     public function findByToken($name, $city, $startday) {
  63.         return $this->createQueryBuilder('e')
  64.             ->andWhere('e.token = :token')
  65.             ->setParameter('token', $this->makeSswToken($name, $city, 4))
  66.             ->andWhere('e.city = :city')
  67.             ->setParameter('city', $city)
  68.             ->andWhere('e.start_day = :startday')
  69.             ->setParameter('startday', $startday)
  70.             ->orderBy('e.start_day', 'ASC')
  71.             ->setMaxResults(1)
  72.             ->getQuery()
  73.             ->getOneOrNullResult()
  74.         ;
  75.     }
  77.     public function makeSswToken($title = "", $city, $wcnt = 5) {
  78.         // Creates a slugged token for comparisons
  79.         $stopwords = array("a","about","actually","almost","ain't","aren't","also","although","always","am","an","and","any","are","as","at","be","became","become","but","by","can","could","did","do","does","each","either","else","for","from","had","has","have","hence","how","i","if","in","is","it","its","just","may","maybe","me","might","mine","must","my","mine","must","my","neither","nor","not","of","oh","ok","or","that","the", "then","when","where","whereas","wherever","whenever","whether","which","while","who","whom","whoever","whose","why","will","with","within","without","would","yes","yet","you","your");
  80.         //echo $title." now ";
  81.         $title = html_entity_decode(strip_tags($title));
  82.         $title = strtolower(str_replace("'s",'', $title));
  83.         $title = preg_replace("#[[:punct:]]#", "", $title);
  84.         $words = explode(' ', trim($title));
  85.         foreach ($words as $k => $word) {
  86.             if (strlen($word) <= 3) {
  87.                 unset($words[$k]);
  88.             }
  89.             if (in_array(strtolower($word), $stopwords)) { 
  90.                 unset($words[$k]);
  91.             }
  92.         }
  93.         $words = array_slice(array_unique($words), 0, $wcnt);
  94.         if(!empty($city)) {
  95.             array_push($words, preg_replace('/[[:space:]]+/', '-', trim($city)));
  96.         }
  97.         $preslug = implode('-', $words);
  98.         $result = strtolower(preg_replace('/[^a-zA-Z0-9-]/','', $preslug));
  99.         //echo $result."<br>";
  100.         return $result;
  101.     }
  103.     // /**
  104.     //  * @return Events[] Returns an array of Events objects
  105.     //  */
  106.     /*
  107.     public function findByExampleField($value)
  108.     {
  109.         return $this->createQueryBuilder('e')
  110.             ->andWhere('e.exampleField = :val')
  111.             ->setParameter('val', $value)
  112.             ->orderBy('e.id', 'ASC')
  113.             ->setMaxResults(10)
  114.             ->getQuery()
  115.             ->getResult()
  116.         ;
  117.     }
  118.     */
  120.     /*
  121.     public function findOneBySomeField($value): ?Events
  122.     {
  123.         return $this->createQueryBuilder('e')
  124.             ->andWhere('e.exampleField = :val')
  125.             ->setParameter('val', $value)
  126.             ->getQuery()
  127.             ->getOneOrNullResult()
  128.         ;
  129.     }
  130.     */
  131. }