/**
* Vraci ankety dle kriterii: limit, offset
* @param array $limits
* @return Entities\Vote[]
*/
public function findAllVotes($limits = [])
{
if (empty($limits)) {
return $this->myVoteRepository->findAll();
}
return $this->myVoteRepository->findBy([], ['id' => 'DESC'], $limits['limit'], $limits['offset']);
}
/**
* @inheritdoc
*/
protected function execute(InputInterface $input, OutputInterface $output)
{
ini_set('memory_limit', '4G');
$lang = $input->getArgument(self::LANGUAGE_ARGUMENT);
/** @var Language $language */
if (($language = $this->languagesRepository->findOneBy(['shortCode' => $lang])) === NULL) {
$output->writeln("<error>Unknown language {$lang} given!");
return 1;
}
$index = $this->elastic->getIndex('dwarf');
$type = $index->getType($language->getShortCode() . '_screenplay');
/** @var Season[] $seasons */
$seasons = $this->seasonsRepository->findBy(['language' => $language]);
foreach ($seasons as $season) {
$output->writeln("Importing season {$season->getNumber()}...");
foreach ($season->getEpisodes() as $episode) {
foreach ($episode->getScenarios() as $screenplay) {
if ($screenplay->getCharacter() !== NULL) {
$document = new Document($screenplay->getId(), ['text' => $screenplay->getText(), 'episode' => ['id' => $episode->getId(), 'number' => $episode->getNumber(), 'name' => $episode->getName(), 'slug' => $episode->getSlug()], 'season' => ['id' => $season->getId(), 'number' => $season->getNumber()], 'character' => ['name' => $screenplay->getCharacter()->getName(), 'slug' => $screenplay->getCharacter()->getSLug()], 'line' => $screenplay->getLine()], $type, $index);
$type->addDocument($document);
}
}
}
}
}
/**
* Vraci vsechny uzivatele systemu
* @param array $limits SQL limit a offset
* @return Entities\User[]
*/
public function findAllUsers($limits = [])
{
if (empty($limits)) {
$limits['offset'] = NULL;
$limits['limit'] = NULL;
}
return $this->repository->findBy([], ['id' => 'DESC'], $limits['limit'], $limits['offset']);
}
/**
* @inheritdoc
*/
protected function execute(InputInterface $input, OutputInterface $output)
{
$languageArgument = $input->getArgument(self::LANGUAGE_ARGUMENT);
/** @var Language $language */
if (($language = $this->languagesRepository->findOneBy(['shortCode' => $languageArgument])) === NULL) {
$output->writeln("<error>Unknown language {$languageArgument}</error>");
return 1;
}
/** @var Season $season */
foreach ($this->seasonsRepository->findBy(['language' => $language]) as $season) {
foreach ($season->getEpisodes() as $episode) {
$file = "S{$season->getNumber()}E{$episode->getNumber()}{$language->getShortCode()}.txt";
$handle = fopen($this->scenariosDir . '/' . $file, 'r');
if ($handle) {
$screenplayLine = 1;
while (($line = fgets($handle)) !== FALSE) {
$name = Strings::before($line, ':');
$isCharacter = $name && !in_array($name, self::KNOWN_NON_CHARACTERS, TRUE) && str_word_count($name, 0) < 3 ? TRUE : FALSE;
/** @var Character|NULL $character */
$character = $isCharacter ? $this->charactersRepository->findOneBy(['slug' => Strings::webalize($name), 'language' => $language]) : NULL;
if ($isCharacter && $character === NULL) {
$character = new Character(Strings::capitalize($name), $language);
$this->entityManager->persist($character);
$this->entityManager->flush($character);
}
$text = $isCharacter ? str_replace($name . ': ', '', $line) : $line;
$text = Strings::trim($text);
if (empty($text)) {
continue;
}
$screenplay = new Screenplay($episode, $text, $character, $screenplayLine, !$isCharacter);
$this->entityManager->persist($screenplay);
$this->entityManager->flush($screenplay);
$screenplayLine++;
}
fclose($handle);
} else {
$output->writeln("<error>Scénář {$file} neexistuje!</error>");
return 1;
}
}
}
return 0;
}
/**
* @param int $cityId
* @return array
*/
protected function streetWithRegions($cityId, $title = NULL)
{
$data = [];
$partCities = $this->partCityRepository->findBy(['city.code' => $cityId], ['title' => Criteria::ASC, 'id' => Criteria::ASC]);
foreach ($partCities as $key => $partCity) {
if (!is_numeric($partCity->title)) {
$data[$key] = ['title' => $partCity->title, 'code' => $partCity->code, 'minZip' => $partCity->minZip, 'maxZip' => $partCity->maxZip];
}
$data[$key] += $this->getStreetsFromPartCity($partCity->id, $title);
}
return ['partCities' => $data];
}
/**
* @param array $limits
* @return Entities\Article[] Vsechny clanky
*/
public function findAllArticles($limits = [])
{
if (empty($limits)) {
return $this->myArticleRepository->findAll();
}
//vychozi razeni
if (!array_key_exists('order', $limits)) {
$limits['order'] = ['publishDate' => 'DESC'];
}
if (!array_key_exists('criteria', $limits)) {
$limits['criteria'] = [];
}
return $this->myArticleRepository->findBy($limits['criteria'], $limits['order'], $limits['limit'], $limits['offset']);
}
/**
* @param int $genreId
* @return Entity\Song[]|array
*/
public function getSongsByGenreId(int $genreId = null) : array
{
return $this->songRepository->findBy(['genre' => $genreId]);
}
/**
* @return Entity\TaskGroup[]
*/
public function getAll()
{
return $this->taskGroup->findBy(array());
}
/**
* @return Entities\Tag[]
*/
public function getAllTags()
{
//$result = $this->repository->findAll();
$result = $this->repository->findBy([], ['title' => 'ASC']);
return $result;
}
public function findBy(array $criteria, array $order = null, $limit = null, $offset = null)
{
return $this->repository->findBy($criteria, $order, $limit, $offset);
}
/**
* @param Language $language
* @return Season[]
*/
public function findAll(Language $language)
{
return $this->seasonsRepository->findBy(['language' => $language], ['number' => 'ASC']);
}
public function renderDefault()
{
$this->template->invitation = $this->invitation;
$this->template->registration = $this->registration;
$this->template->registrations = $this->registrationRepository->findBy(array('enabled' => true, 'invitation' => false));
}
/**
* @param \App\Model\Event\Entity\Event $event
*
* @return array
*/
public function findChildByEvent(Entity\Event $event)
{
return $this->childRepository->findBy(["event" => $event]);
}
/**
* @param number $idTaskGroup
* @return Entity\Task[]
*/
public function getByTaskGroupOrderByDateDESC($idTaskGroup, $oderBy)
{
return $this->task->findBy(array('taskGroup' => $idTaskGroup), $oderBy);
}
