public function getContent() { $out = $q = $qN = ''; $Website = $this->Website; $Profile = $Website->profile; $User = $Website->_User; $hasMe = $Website->isMyProfile($User, $Profile); $Module = $Website->getModule(); $moduleInfo = $Website->getActiveModules(); $templateDefault = 'modules/image/image_listing'; $templateDefaultContent = 'modules/image/image_content'; if (array_key_exists($Module, $moduleInfo)) { if (!empty($moduleInfo[$Module]['all']['template_index'])) { $templateDefault = $moduleInfo[$Module]['all']['template_index']; $templateDefault = str_replace('.tpl.php', '', $templateDefault); } if (!empty($moduleInfo[$Module]['all']['template_content'])) { $templateDefaultContent = $moduleInfo[$Module]['all']['template_content']; $templateDefaultContent = str_replace('.tpl.php', '', $templateDefaultContent); } } $nameTable = '_m_' . $Website->getRealUri($Website->getModule()); $categories = $Website->loadCategories($Website->getModule()); $categoriesIds = $Website->categoriesIds; $_imgTime = URL . 'themes/' . $Website->getTheme() . '/img/icone_time.png'; $_imgTag = URL . 'themes/' . $Website->getTheme() . '/img/icone_tag.png'; $_imgCalendar = URL . 'themes/' . $Website->getTheme() . '/img/icone_calendar.png'; $_imgComment = URL . 'themes/' . $Website->getTheme() . '/img/icone_comment.png'; if ($Website->getPosition() === 'root' || $Website->getPosition() === 'category') { $Params = $Website->getParams(); $ModuleInfos = $Website->moduleInfos($Website->getModule()); $par = $ModuleInfos['groupe_by']; if (array_key_exists('q', $Params['GET']) && !empty($Params['GET']['q'])) { $q = mb_strtolower($Params['GET']['q'], 'UTF-8'); } if (!empty($q)) { $qN = '&q=' . $q; } $outFilterAND = $sqlGroupe = $getCategory = ''; $outGroupe = 'all'; $valFilter = 'date'; $outFilterORDER = ' ' . $nameTable . '.date_creation DESC '; $outSqlGroupe = " WHERE " . $nameTable . ".active = 2 AND "; if ($hasMe) { $outSqlGroupe = " WHERE "; } $outSqlGroupe .= $nameTable . ".id_user = '******'id'] . "'"; $outSqlGroupe .= " AND " . $nameTable . "_traduction.id_content = " . $nameTable . ".id\n AND " . $nameTable . "_traduction.langue = '" . $Website->myLanguage() . "'\n ORDER BY " . $nameTable . ".date_creation DESC "; $outRub = $Website->getModule(); $categoryLabel = ''; if (array_key_exists('doorgets', $Params['GET'])) { $getCategory = $Params['GET']['doorgets']; $isCategorie = $Website->dbQS($getCategory, '_categories_traduction', 'uri'); if (!empty($isCategorie)) { $outGroupe = $getCategory; $outSqlGroupe = " WHERE " . $nameTable . ".active = 2 AND "; if ($hasMe) { $outSqlGroupe = " WHERE "; } $outSqlGroupe .= " " . $nameTable . ".id_user = '******'id'] . "'"; $outSqlGroupe .= " AND " . $nameTable . "_traduction.id_content = " . $nameTable . ".id\n AND " . $nameTable . ".categorie LIKE '%" . $isCategorie['id_cat'] . ",%'\n AND " . $nameTable . "_traduction.langue = '" . $Website->myLanguage() . "'\n ORDER BY " . $nameTable . ".date_creation DESC "; $outRub = 'doorgets=' . $getCategory; if (array_key_exists($getCategory, $categories)) { $categoryLabel = $categories[$getCategory]; } $parentCategories = $Website->getBreadcrumb($Website->getModule(), $isCategorie['id_cat']); sort($parentCategories); } } if (!empty($q)) { $outSqlGroupe = " WHERE " . $nameTable . ".active = 2 AND "; if ($hasMe) { $outSqlGroupe = " WHERE "; } $outSqlGroupe .= $nameTable . "_traduction.id_content = " . $nameTable . ".id\n AND " . $nameTable . "_traduction.langue = '" . $Website->myLanguage() . "' "; } $champsliste[] = $nameTable . '_traduction.titre'; $champsliste[] = $nameTable . '_traduction.description'; $champsliste[] = $nameTable . '_traduction.uri'; $champsliste[] = $nameTable . '_traduction.article_tinymce'; $champsliste[] = $nameTable . '_traduction.meta_titre'; $champsliste[] = $nameTable . '_traduction.meta_description'; $champsliste[] = $nameTable . '_traduction.meta_keys'; if (!empty($q) && !empty($champsliste)) { $sqlGroupe .= " AND ("; foreach ($champsliste as $v) { $sqlGroupe .= " " . $v . " LIKE '%" . $q . "%' OR"; } $sqlGroupe = substr($sqlGroupe, 0, -2); $sqlGroupe .= ") "; } $outSqlGroupe = $outSqlGroupe . $sqlGroupe; $isContents = $Website->dbQ('SELECT COUNT(*) as counter FROM ' . $nameTable . ', ' . $nameTable . '_traduction ' . $outSqlGroupe); $totalContents = (int) $isContents[0]['counter']; $urlPage = $Website->getBaseUrl() . "?{$outRub}{$qN}&p="; $p = 1; $ini = 0; $per = $par; if (array_key_exists('p', $Params['GET']) && is_numeric($Params['GET']['p']) && $Params['GET']['p'] <= ceil($totalContents / $per)) { $p = $Params['GET']['p']; $ini = $p * $per - $per; } $sqlLimit = " {$outSqlGroupe} LIMIT " . $ini . "," . $per; $getPagination = ''; if ($totalContents > $per) { $getPagination = Pagination::pagePublic($totalContents, $p, $per, $urlPage); } $all = $Website->dbQ('SELECT * FROM ' . $nameTable . ', ' . $nameTable . '_traduction ' . $sqlLimit); $cAll = count($all); $finalPer = $ini + $per; if ($finalPer > $totalContents) { $finalPer = $totalContents; } $out = ''; $contents = array(); $iMaxDescription = 500; if (!empty($all)) { foreach ($all as $k => $data) { $contents[$k]['active'] = $data['active']; $contents[$k]['uri'] = $data['uri']; $contents[$k]['title'] = $data['titre']; $contents[$k]['image'] = $data['image']; $contents[$k]['description'] = $data['description']; $contents[$k]['article'] = html_entity_decode($data['article_tinymce']); $lenArticle = strlen($contents[$k]['article']); if ($lenArticle > $iMaxDescription - 1) { $contents[$k]['article'] = substr(strip_tags($contents[$k]['article']), 0, $iMaxDescription) . '...'; } $contents[$k]['order'] = $data['ordre']; $contents[$k]['categories'] = $data['categorie']; $contents[$k]['date'] = GetDate::in($data['date_creation'], 2, $Website->myLanguage); } } $groupeBy = $par; if (!empty($contents)) { $ini = $ini + 1; } $labelModuleGroup = $Website->getActiveModules(); $labelModule = $labelModuleGroup[$Website->getModule()]['all']['nom']; $urlAfterAction = urlencode($Website->getCurrentUrl()); $urlAdd = URL_USER . $Website->_lgUrl . '?controller=moduleimage&uri=' . $Website->getModule() . '&action=add&back=' . $urlAfterAction; $tplModuleNewsListing = Template::getWebsiteUserView($templateDefault, $Website->getTheme()); ob_start(); if (is_file($tplModuleNewsListing)) { include $tplModuleNewsListing; } $out .= ob_get_clean(); } else { $linksToCategories = ''; $isContent = $Website->dbQS($Website->getUri(), $nameTable . '_traduction', 'uri'); if (!empty($isContent)) { $isContentActive = $Website->dbQS($isContent['id_content'], $nameTable, 'id', " AND active = 2 LIMIT 1"); $isContentActiveVersion = $Website->dbQS($isContent['id_content'], $nameTable . '_version', 'id_content', " AND active = 2 AND langue = '" . $Website->myLanguage . "' LIMIT 1"); if (!empty($isContentActive)) { $isContent['article'] = htmlspecialchars_decode(html_entity_decode($isContent['article_tinymce'])); $isContent['article'] = $Website->_convertMethod($isContent['article']); $isContent['title'] = $isContent['titre']; unset($isContent['titre']); unset($isContent['article_tinymce']); unset($isContent['id']); unset($isContent['meta_titre']); unset($isContent['meta_description']); unset($isContent['meta_keys']); unset($isContent['langue']); $isContent['active'] = $isContentActive['active']; $isContent['author_badge'] = $isContentActive['author_badge']; $isContent['id_user'] = $isContentActive['id_user']; $isContent['id_groupe'] = $isContentActive['id_groupe']; $isContent['comments'] = $isContentActive['comments']; $isContent['sharethis'] = $isContentActive['partage']; $isContent['facebook'] = $isContentActive['facebook']; $isContent['disqus'] = $isContentActive['disqus']; $isContent['image_gallery'] = $Website->_toArray($isContent['image_gallery'], ';'); $isContent['date_creation'] = GetDate::in($isContent['date_modification'], 2, $Website->myLanguage); $aCategories = $Website->_toArray($isContentActive['categorie']); if (!empty($aCategories)) { foreach ($aCategories as $id_category) { if (array_key_exists($id_category, $categoriesIds)) { $linksToCategories .= '<a href="' . BASE_URL . '?doorgets=' . $categoriesIds[$id_category] . '">' . $Website->categorieSimple[$id_category] . '</a>'; } } } } elseif (empty($isContentActive) && !empty($isContentActiveVersion)) { $isContentActive = $Website->dbQS($isContent['id_content'], $nameTable); if (!empty($isContentActive)) { $isContent['article'] = htmlspecialchars_decode(html_entity_decode($isContentActiveVersion['article_tinymce'])); $isContent['article'] = $Website->_convertMethod($isContent['article']); $isContent['title'] = $isContentActiveVersion['titre']; unset($isContent['titre']); unset($isContent['article_tinymce']); unset($isContent['id']); unset($isContent['meta_titre']); unset($isContent['meta_description']); unset($isContent['meta_keys']); unset($isContent['langue']); $isContent['active'] = $isContentActive['active']; $isContent['author_badge'] = $isContentActive['author_badge']; $isContent['id_user'] = $isContentActive['id_user']; $isContent['id_groupe'] = $isContentActive['id_groupe']; $isContent['comments'] = $isContentActive['comments']; $isContent['sharethis'] = $isContentActive['partage']; $isContent['facebook'] = $isContentActive['facebook']; $isContent['disqus'] = $isContentActive['disqus']; $isContent['image_gallery'] = $Website->_toArray($isContent['image_gallery'], ';'); $isContent['date_creation'] = GetDate::in($isContent['date_modification'], 2, $Website->myLanguage); $aCategories = $Website->_toArray($isContentActive['categorie']); if (!empty($aCategories)) { foreach ($aCategories as $id_category) { if (array_key_exists($id_category, $categoriesIds)) { $linksToCategories .= '<a href="' . BASE_URL . '?doorgets=' . $categoriesIds[$id_category] . '">' . $Website->categorieSimple[$id_category] . '</a>'; } } } } } } $nexContent = $Website->getUrlNextContent(); $prevContent = $Website->getUrlPreviousContent(); $cComment = $Website->getCountComment($Website->getModule(), $isContent['uri']); $urlAfterAction = $Website->getBaseUrl() . '?' . $Website->getModule() . '=' . urlencode($isContent['uri']); $urlGoToComments = $urlAfterAction . '#comments'; $urlEdition = URL_USER . $Website->_lgUrl . '?controller=moduleimage&uri=' . $Website->getModule() . '&action=edit&id=' . $isContent['id_content'] . '&lg=' . $Website->getLangueTradution() . '&back=' . $urlAfterAction; $urlDelete = URL_USER . $Website->_lgUrl . '?controller=moduleimage&uri=' . $Website->getModule() . '&action=delete&id=' . $isContent['id_content'] . '&lg=' . $Website->getLangueTradution(); $urlAdd = URL_USER . $Website->_lgUrl . '?controller=moduleimage&uri=' . $Website->getModule() . '&action=add&back=' . $urlAfterAction; $labelModuleGroup = $Website->getActiveModules(); $labelModule = $labelModuleGroup[$Website->getModule()]['all']['nom']; $this->userPrivilege['modo'] = $Website->isUser && (in_array($labelModuleGroup[$Website->getModule()]['all']['id'], $Website->_User['liste_module']) && in_array($isContent['id_groupe'], $Website->_User['liste_enfant']) && in_array($isContent['id_groupe'], $Website->_User['liste_enfant_modo'])) ? true : false; $this->userPrivilege['edit'] = $Website->isUser && (in_array($labelModuleGroup[$Website->getModule()]['all']['id'], $Website->_User['liste_module']) && $isContent['id_user'] === $Website->_User['id'] && $this->userPrivilege['edit'] || $this->userPrivilege['modo']) ? true : false; $this->userPrivilege['delete'] = $Website->isUser && (in_array($labelModuleGroup[$Website->getModule()]['all']['id'], $Website->_User['liste_module']) && $isContent['id_user'] === $Website->_User['id'] && $this->userPrivilege['delete'] || $this->userPrivilege['modo']) ? true : false; extract($isContent); $tplModuleNewsContent = Template::getWebsiteUserView($templateDefaultContent, $Website->getTheme()); ob_start(); if (is_file($tplModuleNewsContent)) { include $tplModuleNewsContent; } $out .= ob_get_clean(); } return $out; }
static function page($nbFields, $pos = 1, $nbCount = 10, $path, $LgPrem = '', $LgPrec = '', $LgSuiv = '', $LgDern = '') { return Pagination::pagePublic($nbFields, $pos, $nbCount, $path, $LgPrem, $LgPrec, $LgSuiv, $LgDern); }