1: <?php
  2: 
  3: /**
  4:  *
  5:  * @package Module
  6:  * @subpackage ContentSitemapHtml
  7:  * @version SVN Revision $Rev:$
  8:  *
  9:  * @version SVN Revision $Rev:$
 10:  * @author marcus.gnass@4fb.de
 11:  * @author alexander.scheider@4fb.de
 12:  * @copyright four for business AG
 13:  * @link http://www.4fb.de
 14:  */
 15: 
 16: // get globals
 17: $client = cRegistry::getClientId();
 18: $lang = cRegistry::getLanguageId();
 19: $idart = cRegistry::getArticleId();
 20: 
 21: // get content of current article
 22: $art = new cApiArticleLanguage();
 23: $art->loadByArticleAndLanguageId($idart, $lang);
 24: $content = $art->getContent('CMS_TEXT', 1);
 25: $level = $art->getContent('CMS_TEXT', 2);
 26: $article = $art->getContent('CMS_TEXT', 3);
 27: 
 28: // get smarty template instance
 29: $tpl = cSmartyFrontend::getInstance();
 30: $tpl->assign('isBackendEditMode', cRegistry::isBackendEditMode());
 31: 
 32: // assign module translations
 33: $tpl->assign('trans', array(
 34:     'headline' => mi18n("HEADLINE"),
 35:     'categoryLabel' => mi18n("CATEGORY_LABEL"),
 36:     'levelLabel' => mi18n("LEVEL_LABEL"),
 37:     'articleLabel' => mi18n("ARTICLE_LABEL"),
 38:     'articleHintLabel' => mi18n("ARTICLE_HINT_LABEL"),
 39:     'categoryHintLabel' => mi18n("GATEGORY_HINT_LABEL"),
 40:     'levelHintLabel' => mi18n("LEVEL_HINT_LABEL")
 41: ));
 42: 
 43: // assign CMS input fields
 44: $tpl->assign('category', "CMS_TEXT[1]");
 45: $tpl->assign('level', "CMS_TEXT[2]");
 46: $tpl->assign('article', "CMS_TEXT[3]");
 47: $tpl->assign('first', false);
 48: 
 49: // check if content is numeric
 50: if (false === is_numeric($content) || false === is_numeric($level)) {
 51:     $tpl->assign('error', mi18n("NOT_NUMERIC_VALUE"));
 52: } else if ($article != 0 && $article != 1) {
 53:     $tpl->assign('error', mi18n("NOT_ZERO_OR_ONE"));
 54: } else {
 55:     // get category tree
 56:     $categoryHelper = cCategoryHelper::getInstance();
 57:     $categoryHelper->setAuth(cRegistry::getAuth());
 58:     $tree = $categoryHelper->getSubCategories($content, $level);
 59:     if (1 == $article) {
 60:         $tree = addArticlesToTree($tree);
 61:     }
 62:     $tpl->assign('tree', $tree);
 63: }
 64: 
 65: $tpl->display('get.tpl');
 66: 
 67: /**
 68:  * Adds articles to categories in given array $tree as returned by
 69:  * cCategoryHelper->getSubCategories().
 70:  *
 71:  * @param array $tree
 72:  * @return array
 73:  */
 74: function addArticlesToTree(array $tree) {
 75: 
 76:     $startidartlang = getStartIdArtLang();
 77: 
 78:     foreach ($tree as $key => $wrapper) {
 79:         $tree[$key]['articles'] = getArticlesFromCategory($wrapper['idcat'], $startidartlang);
 80:         $tree[$key]['subcats'] = addArticlesToTree($tree[$key]['subcats']);
 81:     }
 82: 
 83:     return $tree;
 84: 
 85: }
 86: 
 87: /**
 88:  * Get startidartlang as array
 89:  *
 90:  * @return array startidartlang
 91:  */
 92: function getStartIdArtLang() {
 93:     $cfg = cRegistry::getConfig();
 94:     $db = cRegistry::getDb();
 95: 
 96:     // get all startidartlangs
 97:     $startidartlang = array();
 98: 
 99:     $sql = 'SELECT startidartlang FROM  `' . $cfg['tab']['cat_lang'] . '` WHERE visible = 1 AND public = 1';
100:     $ret = $db->query($sql);
101:     while ($db->next_record()) {
102:         $startidartlang[] = $db->f('startidartlang');
103:     }
104: 
105:     return $startidartlang;
106: }
107: 
108: /**
109:  * Add all online and searchable articles of theses categories to the sitemap.
110:  *
111:  * @param int $categoryId
112:  */
113: function getArticlesFromCategory($categoryId, $startidartlang) {
114: 
115:     $cfg = cRegistry::getConfig();
116:     $db = cRegistry::getDb();
117: 
118:     // get articles from DB
119:     // needed fields: idart, lastmodified, sitemapprio, changefreq
120:     $sql = '-- getArticlesFromCategory()
121:         SELECT
122:             al.idartlang
123:             , UNIX_TIMESTAMP(al.lastmodified) AS lastmod
124:             , al.changefreq
125:             , al.sitemapprio
126:             , al.title
127:         FROM
128:             `' . $cfg['tab']['art_lang'] . '` AS al
129:             , `' . $cfg['tab']['cat_art'] . '` AS ca
130:         WHERE
131:             al.idart = ca.idart
132:             AND al.idlang = ' . cSecurity::toInteger(cRegistry::getLanguageId()) . '
133:             AND ca.idcat IN (' . $categoryId . ')
134:             AND al.online = 1
135:             AND al.searchable = 1
136:         ;';
137: 
138:     $ret = $db->query($sql);
139: 
140:     $array = array();
141:     if (false !== $ret) {
142:         while ($db->next_record()) {
143: 
144:             if (!in_array($db->f('idartlang'), $startidartlang)) {
145: 
146:                 $article = new cApiArticleLanguage();
147:                 $article->loadByPrimaryKey($db->f('idartlang'));
148:                 $array[] = $article;
149:             }
150:         }
151:     }
152: 
153:     return $array;
154: 
155: }
156: 
157: ?>