public function getNews()
{
$sql = "SELECT \n\t\t\t\tCONCAT(:url,:seo,'/',N.idnews,'/',NT.seo) as loc,\n\t\t\t\tDATE_FORMAT(N.adddate,'%Y-%m-%d') as lastmod\n\t\t\t\tFROM news N\n\t\t\t\tLEFT JOIN newstranslation NT ON N.idnews = NT.newsid AND NT.languageid = :languageid\n\t\t\t\tWHERE N.publish = 1\n\t\t\t\tGROUP BY N.idnews";
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('url', URL);
$stmt->bindValue('languageid', Helper::getLanguageId());
$stmt->bindValue('seo', Seo::getSeo('news'));
$stmt->execute();
$Data = array();
while ($rs = $stmt->fetch()) {
$Data[] = array('loc' => $rs['loc'], 'lastmod' => $rs['lastmod']);
}
return $Data;
}
public function staticcontent($id)
{
$sql = "SELECT\n\t\t\t\tCONCAT(:seo,'/',CC.idcontentcategory) AS link,\n\t\t\t\tCCT.name AS title\n\t\t\t\tFROM contentcategory CC\n\t\t\t\tLEFT JOIN contentcategorytranslation CCT ON CCT.contentcategoryid = CC.idcontentcategory AND CCT.languageid = :languageid\n\t\t\t\tWHERE CC.idcontentcategory = :id OR CC.idcontentcategory = (SELECT contentcategoryid FROM contentcategory WHERE idcontentcategory = :id)";
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('seo', Seo::getSeo('staticcontent'));
$stmt->bindValue('id', $id);
$stmt->bindValue('languageid', Helper::getLanguageId());
$stmt->execute();
while ($rs = $stmt->fetch()) {
$Data[] = array('link' => $rs['link'], 'title' => $rs['title']);
}
return $Data;
}
public function getProductSeo($seo)
{
return App::getURLAdress() . Seo::getSeo('productcart') . '/' . $seo;
}
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title><?php
echo Seo::getSeo('title');
?>
</title>
<meta name="descrition" content="<?php
echo Seo::getSeo('description');
?>
">
<meta name="keywords" content="<?php
echo Seo::getSeo('keywords');
?>
">
<link href="<?php
echo Assets::$path;
?>
css/template.css" rel="stylesheet" media="all">
<script src="<?php
echo Assets::$path;
?>
js/jquery.js" type="text/javascript" async=""></script>
<script src="<?php
echo Assets::$path;
?>
js/main.js" type="text/javascript" async=""></script>
<script src="<?php
echo Assets::$pathUtilites;
?>
