/** {@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> ");
}
/**
* @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;
}
/**
* Add field
*
* @param \AppBundle\Entity\Field $field
*
* @return Object
*/
public function addField(\AppBundle\Entity\Field $field)
{
$this->fields[] = $field;
$field->setObject($this);
return $this;
}