Example #1
0
 /**
  * Возвращает прямую ссылку на пункт меню по его типу и опции
  * @param string $linktype
  * @param string $linkid
  * @return string
  */
 public function getMenuLink($linktype, $linkid)
 {
     $inDB = cmsDatabase::getInstance();
     $menulink = '';
     if ($linktype == 'component') {
         $menulink = '/' . $linkid;
     }
     if ($linktype == 'link') {
         $menulink = $linkid;
     }
     if ($linktype == 'category' || $linktype == 'content') {
         $this->loadModel('content');
         $model = new cms_model_content();
         switch ($linktype) {
             case 'category':
                 $menulink = $model->getCategoryURL(null, $inDB->get_field('cms_category', "id='{$linkid}'", 'seolink'));
                 break;
             case 'content':
                 $menulink = $model->getArticleURL(null, $inDB->get_field('cms_content', "id='{$linkid}'", 'seolink'));
                 break;
         }
     }
     if ($linktype == 'blog') {
         $this->loadModel('blogs');
         $model = new cms_model_blogs();
         $menulink = $model->getBlogURL($inDB->get_field('cms_blogs', "id='{$linkid}'", 'seolink'));
     }
     if ($linktype == 'video_cat') {
         $this->loadModel('video');
         $model = cms_model_video::initModel();
         $cat = $inDB->get_fields('cms_video_category', "id='{$linkid}'", 'id, seolink');
         $menulink = $model->getCatLink($cat['seolink'], $cat['id']);
     }
     if ($linktype == 'uccat') {
         $menulink = '/catalog/' . $linkid;
     }
     if ($linktype == 'photoalbum') {
         $menulink = '/photos/' . $linkid;
     }
     return $menulink;
 }
Example #2
0
function cmsTagItemLink($target, $item_id){
    $inCore = cmsCore::getInstance();
    $link = '';
    
    switch ($target){
        case 'content':
            $today = date("Y-m-d H:i:s");
            $sql = "SELECT i.title as title, c.title as cat, i.seolink as seolink, c.seolink as cat_seolink
                        FROM cms_content i
                        INNER JOIN cms_category c ON c.id = i.category_id
                        WHERE i.id = '$item_id' AND i.published = 1  AND i.is_arhive = 0 AND i.pubdate <= '$today' AND (i.is_end=0 OR (i.is_end=1 AND i.enddate >= '$today')) LIMIT 1";
            $rs = cmsCore::c('db')->query($sql) ;
            if (cmsCore::c('db')->num_rows($rs)){
                $item = cmsCore::c('db')->fetch_assoc($rs);
                $link =  '<a href="/'.$item['cat_seolink'].'" class="tag_searchcat">'.$item['cat'].'</a> &rarr; ';
                $link .= '<a href="/'.$item['seolink'].'.html" class="tag_searchitem">'.$item['title'].'</a>';
            }
        break;
        
        case 'blogpost':
            $sql = "SELECT i.title as title, i.id as item_id, c.title as cat, c.id as cat_id, c.owner as owner, c.user_id user_id, i.seolink as seolink, c.seolink as bloglink
                        FROM cms_blog_posts i
                        LEFT JOIN cms_blogs c ON c.id = i.blog_id
                        WHERE i.id = '$item_id' AND i.published = 1";
            $rs = cmsCore::c('db')->query($sql) ;
            if (cmsCore::c('db')->num_rows($rs)){
                $item = cmsCore::c('db')->fetch_assoc($rs);
                if ($item['owner'] == 'club') { $item['cat'] = cmsCore::c('db')->get_field('cms_clubs','id='.$item['user_id'],'title'); }
                $link =  '<a href="/blogs/'.$item['bloglink'].'" class="tag_searchcat">'.$item['cat'].'</a> &rarr; ';
                $link .= '<a href="/blogs/'.$item['bloglink'].'/'.$item['seolink'].'.html" class="tag_searchitem">'.$item['title'].'</a>';
            }
        break;
        
        case 'photo':
            $sql = "SELECT i.title as title, i.id as item_id, c.title as cat, c.id as cat_id
                        FROM cms_photo_files i
                        LEFT JOIN cms_photo_albums c ON c.id = i.album_id
                        WHERE i.id = '$item_id' AND i.published = 1";
            $rs = cmsCore::c('db')->query($sql) ;
            if (cmsCore::c('db')->num_rows($rs)){
                $item = cmsCore::c('db')->fetch_assoc($rs);
                $link =  '<a href="/photos/'.$item['cat_id'].'" class="tag_searchcat">'.$item['cat'].'</a> &rarr; ';
                $link .= '<a href="/photos/photo'.$item['item_id'].'.html" class="tag_searchitem">'.$item['title'].'</a>';
            }
        break;
        
        case 'userphoto':
            $sql = "SELECT i.title as title, i.id as item_id, c.nickname as cat, c.id as cat_id, c.login as login
                        FROM cms_user_photos i
                        LEFT JOIN cms_users c ON c.id = i.user_id
                        WHERE i.id = '$item_id'";
            $rs = cmsCore::c('db')->query($sql) ;
            if (cmsCore::c('db')->num_rows($rs)){
                $item = cmsCore::c('db')->fetch_assoc($rs);
                $link =  '<a href="'.cmsUser::getProfileURL($item['login']).'" class="tag_searchcat">'.$item['cat'].'</a> &rarr; ';
                $link .= '<a href="/users/'.$item['cat_id'].'/photo'.$item['item_id'].'.html" class="tag_searchitem">'.$item['title'].'</a>';
            }
        break;
        
        case 'catalog':
            $sql = "SELECT i.title as title, i.id as item_id, c.title as cat, c.id as cat_id
                        FROM cms_uc_items i
                        LEFT JOIN cms_uc_cats c ON c.id = i.category_id
                        WHERE i.id = '$item_id' AND i.published = 1";
                        $rs = cmsCore::c('db')->query($sql) ;
                        if (cmsCore::c('db')->num_rows($rs)){
                            $item = cmsCore::c('db')->fetch_assoc($rs);
                            $link =  '<a href="/catalog/'.$item['cat_id'].'" class="tag_searchcat">'.$item['cat'].'</a> &rarr; ';
                            $link .= '<a href="/catalog/item'.$item['item_id'].'.html" class="tag_searchitem">'.$item['title'].'</a>';
                        }
        break;
        
        case 'video':
            $inCore->loadModel('video');
            $model = cms_model_video::initModel();
            $sql = "SELECT i.title as title, i.id as item_id, i.seolink as movie_seolink, c.title as cat_title, c.id as cat_id, c.seolink as cat_seolink
                        FROM cms_video_movie i
                        INNER JOIN cms_video_category c ON c.id = i.cat_id
                        WHERE i.id = '$item_id'";
            $rs = cmsCore::c('db')->query($sql) ;
            if (cmsCore::c('db')->num_rows($rs)){
                $item = cmsCore::c('db')->fetch_assoc($rs);
                $link =  '<a href="'.$model->getCatLink($item['cat_seolink'], $item['cat_id']).'" class="tag_searchcat">'.$item['cat_title'].'</a> &rarr; ';
                $link .= '<a href="'.$model->getMovieLink($item['cat_seolink'].'/'.$item['movie_seolink'], $item['item_id']).'" class="tag_searchitem">'.$item['title'].'</a>';
            }
        break;
        
        case 'shop':
            $sql = "SELECT i.title as title, i.seolink as seolink, c.title as cat, c.seolink as cat_seolink
                        FROM cms_shop_items i
                        LEFT JOIN cms_shop_cats c ON c.id = i.category_id
                        WHERE i.id = '$item_id'";
            $rs = cmsCore::c('db')->query($sql) ;
            if (cmsCore::c('db')->num_rows($rs)){
                $item = cmsCore::c('db')->fetch_assoc($rs);
                $link =  '<a href="/shop/'.$item['cat_seolink'].'" class="tag_searchcat">'.$item['cat'].'</a> &rarr; ';
                $link .= '<a href="/shop/'.$item['seolink'].'.html" class="tag_searchitem">'.$item['title'].'</a>';
            }
        break;
        
        case 'maps':
            $sql = "SELECT i.title as title, i.seolink as seolink, c.title as cat, c.seolink as cat_seolink
                        FROM cms_map_items i
                        LEFT JOIN cms_map_cats c ON c.id = i.category_id
                        WHERE i.id = '$item_id'";
            $rs = cmsCore::c('db')->query($sql) ;
            if (cmsCore::c('db')->num_rows($rs)){
                $item = cmsCore::c('db')->fetch_assoc($rs);
                $link =  '<a href="/maps/'.$item['cat_seolink'].'" class="tag_searchcat">'.$item['cat'].'</a> &rarr; ';
                $link .= '<a href="/maps/'.$item['seolink'].'.html" class="tag_searchitem">'.$item['title'].'</a>';
            }
        break;
    }
    
    return $link;
}