/**
* Création du slug d'un élément donné dans une langue donnée.
*
* @param integer $iItemId
* @param string $sLanguage
* @return boolean
*/
protected function setItemSlug($iItemId, $sLanguage)
{
$rsItem = $this->getItems(array('id' => $iItemId, 'language' => $sLanguage, 'active' => 2));
if ($rsItem->isEmpty()) {
throw new Exception(sprintf(__('m_galleries_error_item_%s_doesnt_exist'), $iItemId));
}
if (empty($rsItem->slug)) {
$sUrl = $rsItem->title;
} else {
$sUrl = $rsItem->slug;
}
$sUrl = util::strToSlug($sUrl, false);
# Let's check if URL is taken…
$rsTakenSlugs = $this->db->select('SELECT slug FROM ' . $this->t_items_locales . ' ' . 'WHERE slug=\'' . $this->db->escapeStr($sUrl) . '\' ' . 'AND item_id <> ' . (int) $iItemId . ' ' . 'AND language=\'' . $this->db->escapeStr($sLanguage) . '\' ' . 'ORDER BY slug DESC');
if (!$rsTakenSlugs->isEmpty()) {
$rsCurrentSlugs = $this->db->select('SELECT slug FROM ' . $this->t_items_locales . ' ' . 'WHERE slug LIKE \'' . $this->db->escapeStr($sUrl) . '%\' ' . 'AND item_id <> ' . (int) $iItemId . ' ' . 'AND language=\'' . $this->db->escapeStr($sLanguage) . '\' ' . 'ORDER BY slug DESC ');
$a = array();
while ($rsCurrentSlugs->fetch()) {
$a[] = $rsCurrentSlugs->slug;
}
$sUrl = util::getIncrementedString($a, $sUrl, '-');
}
$sQuery = 'UPDATE ' . $this->t_items_locales . ' SET ' . 'slug=\'' . $this->db->escapeStr($sUrl) . '\' ' . 'WHERE item_id=' . (int) $iItemId . ' ' . 'AND language=\'' . $this->db->escapeStr($sLanguage) . '\' ';
if (!$this->db->execute($sQuery)) {
return false;
}
return true;
}
/**
* Construit l'URL d'un produit donné
*
* @param string $title
* @param string $url
* @param integer $product_id
* @return string
*/
protected function buildProdURL($title, $url, $product_id)
{
if (empty($url)) {
$url = $title;
}
$url = util::strToSlug($url, false);
# Let's check if URL is taken…
$query = 'SELECT slug FROM ' . $this->t_products . ' ' . 'WHERE slug=\'' . $this->db->escapeStr($url) . '\' ' . 'AND id <> ' . (int) $product_id . ' ' . 'ORDER BY slug DESC';
$rs = $this->db->select($query);
if (!$rs->isEmpty()) {
$query = 'SELECT slug FROM ' . $this->t_products . ' ' . 'WHERE slug LIKE \'' . $this->db->escapeStr($url) . '%\' ' . 'AND id <> ' . (int) $product_id . ' ' . 'ORDER BY slug DESC ';
$rs = $this->db->select($query);
$a = array();
while ($rs->fetch()) {
$a[] = $rs->slug;
}
$url = util::getIncrementedString($a, $url, '-');
}
# URL is empty?
if ($url == '') {
throw new Exception(__('Empty entry URL'));
}
return $url;
}
/**
* Construit l'ID HTML d'un champ donné
*
* @param string $title
* @param string $html_id
* @param integer $iFieldId
* @return string
*/
protected function buildFieldHtmlId($title, $html_id, $iFieldId)
{
if (empty($html_id)) {
$html_id = $title;
}
$html_id = util::strToUnderscored($html_id, false);
# Let's check if URL is taken…
$query = 'SELECT html_id FROM ' . $this->t_fields . ' ' . 'WHERE html_id=\'' . $this->db->escapeStr($html_id) . '\' ' . 'AND id <> ' . (int) $iFieldId . ' ' . 'ORDER BY html_id DESC';
$rs = $this->db->select($query);
if (!$rs->isEmpty()) {
$query = 'SELECT html_id FROM ' . $this->t_fields . ' ' . 'WHERE html_id LIKE \'' . $this->db->escapeStr($html_id) . '%\' ' . 'AND id <> ' . (int) $iFieldId . ' ' . 'ORDER BY html_id DESC ';
$rs = $this->db->select($query);
$a = array();
while ($rs->fetch()) {
$a[] = $rs->html_id;
}
$html_id = util::getIncrementedString($a, $html_id, '-');
}
# URL is empty?
if ($html_id == '') {
throw new Exception(__('m_contact_Empty_HTML_ID'));
}
return $html_id;
}
/**
* Création du slug d'un article donné dans une langue donnée.
*
* @param integer $iPostId
* @param string $sLanguage
* @return boolean
*/
protected function setPostSlug($iPostId, $sLanguage)
{
$rsPost = $this->getPostsRecordset(array('id' => $iPostId, 'language' => $sLanguage));
if ($rsPost->isEmpty()) {
throw new Exception(sprintf(__('m_news_post_%s_not_exists'), $iPostId));
}
if (empty($rsPost->slug)) {
$sUrl = $rsPost->title;
} else {
$sUrl = $rsPost->slug;
}
$sUrl = util::strToSlug($sUrl, false);
# Let's check if URL is taken…
$rsTakenSlugs = $this->db->select('SELECT slug FROM ' . $this->t_news_locales . ' ' . 'WHERE slug=\'' . $this->db->escapeStr($sUrl) . '\' ' . 'AND post_id <> ' . (int) $iPostId . ' ' . 'AND language=\'' . $this->db->escapeStr($sLanguage) . '\' ' . 'ORDER BY slug DESC');
if (!$rsTakenSlugs->isEmpty()) {
$rsCurrentSlugs = $this->db->select('SELECT slug FROM ' . $this->t_news_locales . ' ' . 'WHERE slug LIKE \'' . $this->db->escapeStr($sUrl) . '%\' ' . 'AND post_id <> ' . (int) $iPostId . ' ' . 'AND language=\'' . $this->db->escapeStr($sLanguage) . '\' ' . 'ORDER BY slug DESC ');
$a = array();
while ($rsCurrentSlugs->fetch()) {
$a[] = $rsCurrentSlugs->slug;
}
$sUrl = util::getIncrementedString($a, $sUrl, '-');
}
$sQuery = 'UPDATE ' . $this->t_news_locales . ' SET ' . 'slug=\'' . $this->db->escapeStr($sUrl) . '\' ' . 'WHERE post_id=' . (int) $iPostId . ' ' . 'AND language=\'' . $this->db->escapeStr($sLanguage) . '\' ';
if (!$this->db->execute($sQuery)) {
return false;
}
return true;
}
/**
* Création du slug d'une rubrique donnée dans une langue donnée.
*
* @param integer $iCategoryId
* @param string $sLanguage
* @return boolean
*/
protected function setCategorySlug($iCategoryId, $sLanguage)
{
$rsCategory = $this->getCategories(array('id' => $iCategoryId, 'language' => $sLanguage, 'active' => 2));
if ($rsCategory->isEmpty()) {
throw new Exception(sprintf(__('m_pages_cat_%s_not_exists'), $iCategoryId));
}
if (empty($rsCategory->slug)) {
$rsParent = $this->getCategories(array('id' => $rsCategory->parent_id, 'language' => $sLanguage, 'active' => 2));
$sSlug = $rsParent->slug . '/' . $rsCategory->title;
} else {
$sSlug = $rsCategory->slug;
}
$sSlug = util::strToSlug($sSlug, true);
# Let's check if URL is taken…
$query = 'SELECT slug FROM ' . $this->t_categories_locales . ' ' . 'WHERE slug=\'' . $this->db->escapeStr($sSlug) . '\' ' . 'AND category_id <> ' . (int) $iCategoryId . ' ' . 'AND language=\'' . $this->db->escapeStr($sLanguage) . '\' ' . 'ORDER BY slug DESC';
$rsTakenSlugs = $this->db->select($query);
if (!$rsTakenSlugs->isEmpty()) {
$query = 'SELECT slug FROM ' . $this->t_categories_locales . ' ' . 'WHERE slug LIKE \'' . $this->db->escapeStr($sSlug) . '%\' ' . 'AND category_id <> ' . (int) $iCategoryId . ' ' . 'AND language=\'' . $this->db->escapeStr($sLanguage) . '\' ' . 'ORDER BY slug DESC ';
$rsCurrentSlugs = $this->db->select($query);
$a = array();
while ($rsCurrentSlugs->fetch()) {
$a[] = $rsCurrentSlugs->slug;
}
$sSlug = util::getIncrementedString($a, $sSlug, '-');
}
$query = 'UPDATE ' . $this->t_categories_locales . ' SET ' . 'slug=\'' . $this->db->escapeStr($sSlug) . '\' ' . 'WHERE category_id=' . (int) $iCategoryId . ' ' . 'AND language=\'' . $this->db->escapeStr($sLanguage) . '\' ';
if (!$this->db->execute($query)) {
throw new Exception('Unable to update category in database.');
}
return true;
}
/**
* Construit le slug d'une question donnée dans une langue donnée
*
* @param string $title
* @param string $url
* @param $question_id
* @param $lang_code
* @return string
*/
protected function buildQuestionSlug($title, $url, $question_id, $lang_code)
{
if (empty($url)) {
$url = $title;
}
$url = util::strToSlug($url, false);
# URL is empty?
if ($url == '') {
return $url;
}
# Let's check if URL is taken…
$query = 'SELECT slug FROM ' . $this->t_faq_locales . ' ' . 'WHERE slug=\'' . $this->db->escapeStr($url) . '\' ' . 'AND faq_id <> ' . (int) $question_id . ' ' . 'AND language=\'' . $this->db->escapeStr($lang_code) . '\' ' . 'ORDER BY slug DESC';
$rs = $this->db->select($query);
if (!$rs->isEmpty()) {
$query = 'SELECT slug FROM ' . $this->t_faq_locales . ' ' . 'WHERE slug LIKE \'' . $this->db->escapeStr($url) . '%\' ' . 'AND faq_id <> ' . (int) $question_id . ' ' . 'AND language=\'' . $this->db->escapeStr($lang_code) . '\' ' . 'ORDER BY slug DESC ';
$rs = $this->db->select($query);
$a = array();
while ($rs->fetch()) {
$a[] = $rs->slug;
}
$url = util::getIncrementedString($a, $url, '-');
}
# URL is empty?
// if ($url == '') {
// throw new Exception(__('Empty questions URL'));
// }
return $url;
}
