Exemple #1
0
 /** {@inheritdoc} */
 protected function execute(InputInterface $input, OutputInterface $output)
 {
     $output->writeln("Loading lecture fields...");
     foreach ($this->config as $fieldConfig) {
         $field = new Field();
         $field->setName($fieldConfig['name']);
         $field->setDescription($fieldConfig['description']);
         $field->setImageName($fieldConfig['image']);
         $this->getEm()->persist($field);
     }
     $this->getEm()->flush();
     $output->writeln("<info>Lecture fields loaded</info> ");
 }
Exemple #2
0
 /**
  * @param Field|null $field
  * @return array
  */
 public function findWithTags(Field $field = null)
 {
     //todo add caching
     $qb = $this->createQueryBuilder('field');
     if ($field) {
         //needs to execute query with join anyway
         $qb->andWhere($qb->expr()->eq('field.id', $field->getId()));
     }
     $fields = $qb->leftJoin('field.lectures', 'lecture')->groupBy('field')->select('field.id', 'field.name', 'COUNT(lecture.id) AS lecture_count')->orderBy('lecture_count', 'DESC')->getQuery()->getArrayResult();
     foreach ($fields as &$field) {
         $qb = $this->createQueryBuilder('field');
         $tags = $qb->andWhere($qb->expr()->eq('field.id', $field['id']))->innerJoin('field.lectures', 'lecture')->innerJoin('lecture.tags', 'tag')->groupBy('tag')->select(['tag.id', 'tag.name', 'COUNT(lecture.id) AS lecture_count'])->orderBy('lecture_count', 'DESC')->getQuery()->getArrayResult();
         $field['tags'] = $tags;
     }
     return $fields;
 }
Exemple #3
0
 /**
  * Add field
  *
  * @param \AppBundle\Entity\Field $field
  *
  * @return Object
  */
 public function addField(\AppBundle\Entity\Field $field)
 {
     $this->fields[] = $field;
     $field->setObject($this);
     return $this;
 }