Алфавитный указатель в статьях

 
$routes[] = array(
                            '_uri'  => '/^content\/([0-9]+)\/alphabet\/(.+)$/i',
                            'do'    => 'view',
							1 		=> 'id',
							2		=> 'letter'
                         );
        $routes[] = array(
                            '_uri'  => '/^content\/([a-z0-9_\/\-]+)\/alphabet\/(.+)$/i',
                            'do'    => 'view',
							1 		=> 'seolink',
							2		=> 'letter'
                         );

 
public function getArticlesByLetter($category_id, $letter, $orderby='title', $orderto='asc') {
 
        $articles = array();
		$today = date("Y-m-d H:i:s");
        $sql = "SELECT con.*, 
                       con.pubdate as fpubdate,
                       u.nickname as author,
                       u.login as user_login
                FROM cms_content con
				LEFT JOIN cms_users u ON u.id = con.user_id
                WHERE con.category_id = '$category_id' AND con.published = 1 AND con.is_arhive = 0 AND con.pubdate <= '$today'
                      AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '$today'))
					  AND UPPER(SUBSTRING(LTRIM( title ) , 1, 1))='".$letter."'
                ORDER BY con.".$orderby." ".$orderto;
 
        $result = $this->inDB->query($sql);
 
        if (!$this->inDB->num_rows($result)) { return false; }
 
        while($article = $this->inDB->fetch_assoc($result)){
			$article['fpubdate'] = cmsCore::dateFormat($article['fpubdate']);
            $articles[] = $article;
        }
 
        $articles = cmsCore::callEvent('GET_ARTICLES', $articles);
 
        //Переносим в архив просроченные статьи
        $sql = "UPDATE cms_content SET is_arhive = 1 WHERE is_end = 1 AND enddate < NOW()";
        $this->inDB->query($sql);
 
        return $articles;
 
    }	
 

 
function getAlphaList($cat_id,$seolink=''){
    $inCore = cmsCore::getInstance();
    $inDB = cmsDatabase::getInstance();
    global $_LANG;
    $html = '';
    $sql = "SELECT UPPER(SUBSTRING(LTRIM( title ) , 1, 1)) AS first_letter, COUNT( id ) AS num
            FROM cms_content
            WHERE category_id = '$cat_id' AND published = 1
            GROUP BY first_letter";
    $result = $inDB->query($sql) ;
    if ($inDB->num_rows($result)){
        $html .= '<div class="content_alpha_list">';
		if ($seolink!='') $cat_id=$seolink;
        while($a = $inDB->fetch_assoc($result)){
			if(preg_match('/^([a-zA-Zа-яёіїєґА-ЯЁІЇЄҐ0-9]+)$/i', $a['first_letter'])){
            	$html .= '<a class="content_alpha_link" href="/'.$cat_id.'/alphabet/'.urlencode($a['first_letter']).'" title="'.$_LANG['ARTICLES'].': '.$a['num'].'">'.$a['first_letter'].'</a>';
			}
        }
        $html .= '</div>';
    }
    return $html;
}
 

 
$alpha = getAlphaList($cat['id'],$seolink);
$letter = urldecode($inCore->request('letter', 'str', ''));	
	if ($letter != '')
		$content_list = $model->getArticlesByLetter($cat['id'], $letter, $cat['orderby'], $cat['orderto']);
	else
	    $content_list   = $model->getArticles($cat['id'], $page, $perpage, $cat['orderby'], $cat['orderto']);
 

$smarty->assign('alphabet', $alpha);

{if $alphabet} {$alphabet} {/if}