/** * @param ContentBlock $contentBlock * @param Locale $locale */ public function __construct(ContentBlock $contentBlock, Locale $locale) { parent::__construct('SELECT i.id, i.revision_id, i.title, UNIX_TIMESTAMP(i.edited_on) AS edited_on, i.user_id FROM content_blocks AS i WHERE i.status = :archived AND i.id = :id AND i.language = :language ORDER BY i.edited_on DESC', ['archived' => ContentBlockStatus::archived(), 'language' => $locale, 'id' => $contentBlock->getId()]); }
/** * @param CopyContentBlocksToOtherLocale $copyContentBlocksToOtherLocale * * @return ContentBlock */ public function handle(CopyContentBlocksToOtherLocale $copyContentBlocksToOtherLocale) { $fromLocaleContentBlocks = (array) $this->contentBlockRepository->findBy(['locale' => $copyContentBlocksToOtherLocale->fromLocale, 'status' => ContentBlockStatus::active()]); $id = $this->contentBlockRepository->getNextIdForLanguage($copyContentBlocksToOtherLocale->toLocale); array_map(function (ContentBlock $contentBlock) use($copyContentBlocksToOtherLocale, &$id) { $copyContentBlocksToOtherLocale->extraIdMap[$contentBlock->getExtraId()] = $this->getNewExtraId(); $otherLocaleContentBlock = ContentBlock::create($id++, $contentBlock->getUserId(), $copyContentBlocksToOtherLocale->extraIdMap[$contentBlock->getExtraId()], $copyContentBlocksToOtherLocale->toLocale, $contentBlock->getTitle(), $contentBlock->getText(), $contentBlock->isHidden(), $contentBlock->getTemplate()); $this->contentBlockRepository->add($otherLocaleContentBlock); }, $fromLocaleContentBlocks); }
/** * @param string $status * @param AbstractPlatform $platform * * @return ContentBlockStatus */ public function convertToPHPValue($status, AbstractPlatform $platform) { return ContentBlockStatus::fromString($status); }
public function archive() { $this->status = ContentBlockStatus::archived(); }
/** * @param int $id * @param Locale $locale * * @return ContentBlock|null */ public function findOneByIdAndLocale($id, Locale $locale) { return $this->findOneBy(['id' => $id, 'status' => ContentBlockStatus::active(), 'locale' => $locale]); }
/** * @param Locale $locale */ public function __construct(Locale $locale) { parent::__construct('SELECT i.id, i.title, i.hidden FROM content_blocks AS i WHERE i.status = :active AND i.language = :language', ['active' => ContentBlockStatus::active(), 'language' => $locale]); }