Inheritance: implements eZ\Publish\SPI\Persistence\Content\Language\Handler
Example #1
0
 /**
  * Internal method for creating global or custom URL alias (these are handled in the same way).
  *
  * @throws \eZ\Publish\Core\Base\Exceptions\ForbiddenException if the path already exists for the given language
  *
  * @param string $action
  * @param string $path
  * @param bool $forward
  * @param string|null $languageCode
  * @param bool $alwaysAvailable
  *
  * @return \eZ\Publish\SPI\Persistence\Content\UrlAlias
  */
 protected function createUrlAlias($action, $path, $forward, $languageCode, $alwaysAvailable)
 {
     $pathElements = explode('/', $path);
     $topElement = array_pop($pathElements);
     $languageId = $this->languageHandler->loadByLanguageCode($languageCode)->id;
     $parentId = 0;
     // Handle all path elements except topmost one
     $isPathNew = false;
     foreach ($pathElements as $level => $pathElement) {
         $pathElement = $this->slugConverter->convert($pathElement, 'noname' . ($level + 1));
         $pathElementMD5 = $this->getHash($pathElement);
         if (!$isPathNew) {
             $row = $this->gateway->loadRow($parentId, $pathElementMD5);
             if (empty($row)) {
                 $isPathNew = true;
             } else {
                 $parentId = $row['link'];
             }
         }
         if ($isPathNew) {
             $parentId = $this->insertNopEntry($parentId, $pathElement, $pathElementMD5);
         }
     }
     // Handle topmost path element
     $topElement = $this->slugConverter->convert($topElement, 'noname' . (count($pathElements) + 1));
     // If last (next to topmost) entry parent is special root entry we handle topmost entry as first level entry
     // That is why we need to reset $parentId to 0
     if ($parentId != 0 && $this->gateway->isRootEntry($parentId)) {
         $parentId = 0;
     }
     $topElementMD5 = $this->getHash($topElement);
     // Set common values for two cases below
     $data = array('action' => $action, 'is_alias' => 1, 'alias_redirects' => $forward ? 1 : 0, 'parent' => $parentId, 'text' => $topElement, 'text_md5' => $topElementMD5, 'is_original' => 1);
     // Try to load topmost element
     if (!$isPathNew) {
         $row = $this->gateway->loadRow($parentId, $topElementMD5);
     }
     // If nothing was returned perform insert
     if ($isPathNew || empty($row)) {
         $data['lang_mask'] = $languageId | (int) $alwaysAvailable;
         $id = $this->gateway->insertRow($data);
     } elseif ($row['action'] == 'nop:' || $row['is_original'] == 0) {
         // Row exists, check if it is reusable. There are 2 cases when this is possible:
         // 1. NOP entry
         // 2. history entry
         $data['lang_mask'] = $languageId | (int) $alwaysAvailable;
         // If history is reused move link to id
         $data['link'] = $id = $row['id'];
         $this->gateway->updateRow($parentId, $topElementMD5, $data);
     } else {
         throw new ForbiddenException("Path '%path%' already exists for the given language", ['%path%' => $path]);
     }
     $data['raw_path_data'] = $this->gateway->loadPathData($id);
     return $this->mapper->extractUrlAliasFromData($data);
 }
Example #2
0
 /**
  * Internal method for creating global or custom URL alias (these are handled in the same way)
  *
  * @throws \eZ\Publish\Core\Base\Exceptions\ForbiddenException if the path already exists for the given language
  *
  * @param string $action
  * @param string $path
  * @param boolean $forward
  * @param string|null $languageCode
  * @param boolean $alwaysAvailable
  *
  * @return \eZ\Publish\SPI\Persistence\Content\UrlAlias
  */
 protected function createUrlAlias($action, $path, $forward, $languageCode, $alwaysAvailable)
 {
     $pathElements = explode("/", $path);
     $topElement = array_pop($pathElements);
     $languageId = $this->languageHandler->loadByLanguageCode($languageCode)->id;
     $parentId = 0;
     // Handle all path elements except topmost one
     $isPathNew = false;
     foreach ($pathElements as $level => $pathElement) {
         $pathElement = $this->slugConverter->convert($pathElement, "noname" . ($level + 1));
         $pathElementMD5 = $this->getHash($pathElement);
         if (!$isPathNew) {
             $row = $this->gateway->loadRow($parentId, $pathElementMD5);
             if (empty($row)) {
                 $isPathNew = true;
             } else {
                 $parentId = $row["link"];
             }
         }
         if ($isPathNew) {
             $parentId = $this->insertNopEntry($parentId, $pathElement, $pathElementMD5);
         }
     }
     // Handle topmost path element
     $topElement = $this->slugConverter->convert($topElement, "noname" . (count($pathElements) + 1));
     // If last (next to topmost) entry parent is special root entry we handle topmost entry as first level entry
     // That is why we need to reset $parentId to 0 and empty $createdPath
     if ($parentId != 0 && $this->gateway->isRootEntry($parentId)) {
         $parentId = 0;
     }
     $topElementMD5 = $this->getHash($topElement);
     // Set common values for two cases below
     $data = array("action" => $action, "is_alias" => 1, "alias_redirects" => $forward ? 1 : 0, "parent" => $parentId, "text" => $topElement, "text_md5" => $topElementMD5, "is_original" => 1);
     // Try to load topmost element
     if (!$isPathNew) {
         $row = $this->gateway->loadRow($parentId, $topElementMD5);
     }
     // If nothing was returned perform insert
     if ($isPathNew || empty($row)) {
         $data["lang_mask"] = $languageId | (int) $alwaysAvailable;
         $id = $this->gateway->insertRow($data);
     } else {
         if ($row["action"] == "nop:" || $row["is_original"] == 0) {
             $data["lang_mask"] = $languageId | (int) $alwaysAvailable;
             // If history is reused move link to id
             $data["link"] = $id = $row["id"];
             $this->gateway->updateRow($parentId, $topElementMD5, $data);
         } else {
             throw new ForbiddenException("Path '{$path}' already exists for the given language");
         }
     }
     $data["raw_path_data"] = $this->gateway->loadPathData($id);
     return $this->mapper->extractUrlAliasFromData($data);
 }
 /**
  * Sets the name for Content $contentId in version $version to $name in $language.
  *
  * @param int $contentId
  * @param int $version
  * @param string $name
  * @param string $language
  */
 public function setName($contentId, $version, $name, $language)
 {
     $language = $this->languageHandler->loadByLanguageCode($language);
     // Is it an insert or an update ?
     $qSelect = $this->dbHandler->createSelectQuery();
     $qSelect->select($qSelect->alias($qSelect->expr->count('*'), 'count'))->from($this->dbHandler->quoteTable('ezcontentobject_name'))->where($qSelect->expr->lAnd($qSelect->expr->eq($this->dbHandler->quoteColumn('contentobject_id'), $qSelect->bindValue($contentId)), $qSelect->expr->eq($this->dbHandler->quoteColumn('content_version'), $qSelect->bindValue($version)), $qSelect->expr->eq($this->dbHandler->quoteColumn('content_translation'), $qSelect->bindValue($language->languageCode))));
     $stmt = $qSelect->prepare();
     $stmt->execute();
     $res = $stmt->fetchAll(\PDO::FETCH_ASSOC);
     $insert = $res[0]['count'] == 0;
     if ($insert) {
         $q = $this->dbHandler->createInsertQuery();
         $q->insertInto($this->dbHandler->quoteTable('ezcontentobject_name'));
     } else {
         $q = $this->dbHandler->createUpdateQuery();
         $q->update($this->dbHandler->quoteTable('ezcontentobject_name'))->where($q->expr->lAnd($q->expr->eq($this->dbHandler->quoteColumn('contentobject_id'), $q->bindValue($contentId)), $q->expr->eq($this->dbHandler->quoteColumn('content_version'), $q->bindValue($version)), $q->expr->eq($this->dbHandler->quoteColumn('content_translation'), $q->bindValue($language->languageCode))));
     }
     $q->set($this->dbHandler->quoteColumn('contentobject_id'), $q->bindValue($contentId, null, \PDO::PARAM_INT))->set($this->dbHandler->quoteColumn('content_version'), $q->bindValue($version, null, \PDO::PARAM_INT))->set($this->dbHandler->quoteColumn('language_id'), $q->bindValue($language->id, null, \PDO::PARAM_INT))->set($this->dbHandler->quoteColumn('content_translation'), $q->bindValue($language->languageCode))->set($this->dbHandler->quoteColumn('real_translation'), $q->bindValue($language->languageCode))->set($this->dbHandler->quoteColumn('name'), $q->bindValue($name));
     $q->prepare()->execute();
 }
 /**
  * Loads the actual content based on the provided IDs
  *
  * @param array $contentIds
  * @param mixed $translations
  *
  * @return mixed[]
  */
 protected function loadContent(array $contentIds, $translations)
 {
     $loadQuery = $this->queryBuilder->createFindQuery($translations);
     $loadQuery->where($loadQuery->expr->eq('ezcontentobject_version.status', VersionInfo::STATUS_PUBLISHED), $loadQuery->expr->in($this->handler->quoteColumn('id', 'ezcontentobject'), $contentIds));
     $statement = $loadQuery->prepare();
     $statement->execute();
     $rows = $statement->fetchAll(\PDO::FETCH_ASSOC);
     // Sort array, as defined in the $contentIds array
     $contentIdOrder = array_flip($contentIds);
     usort($rows, function ($current, $next) use($contentIdOrder) {
         return $contentIdOrder[$current['ezcontentobject_id']] - $contentIdOrder[$next['ezcontentobject_id']];
     });
     foreach ($rows as &$row) {
         $row['ezcontentobject_always_available'] = $this->languageMaskGenerator->isAlwaysAvailable($row['ezcontentobject_language_mask']);
         $row['ezcontentobject_main_language_code'] = $this->languageHandler->load($row['ezcontentobject_initial_language_id'])->languageCode;
         $row['ezcontentobject_version_languages'] = $this->languageMaskGenerator->extractLanguageIdsFromMask($row['ezcontentobject_version_language_mask']);
         $row['ezcontentobject_version_initial_language_code'] = $this->languageHandler->load($row['ezcontentobject_version_initial_language_id'])->languageCode;
     }
     return $rows;
 }