public function getMetadataForPage()
{
$controller = $this->registry->router->getCurrentController();
$Data = array();
$sql = "SELECT\n\t\t\t\t\tVT.keyword_title,\n\t\t\t\t\tC.description,\n\t\t\t\t\tVT.keyword,\n\t\t\t\t\tVT.keyword_description,\n\t\t\t\t\tVT.additionalmeta\n\t\t\t\tFROM controller C\n\t\t\t\tLEFT JOIN viewtranslation VT ON VT.viewid = :viewid AND VT.languageid = :languageid\n\t\t\t\tWHERE C.name = :controller AND C.mode = 0";
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('controller', $controller);
$stmt->bindValue('viewid', Helper::getViewId());
$stmt->bindValue('languageid', Helper::getLanguageId());
$stmt->execute();
$rs = $stmt->fetch();
if ($rs) {
if ($rs['keyword_title'] == NULL || $rs['keyword_title'] == '') {
$keyword_title = $controller == 'mainside' ? Session::getActiveShopName() : _($rs['description']);
} else {
$keyword_title = $rs['keyword_title'];
}
$title = $controller == 'mainside' ? $keyword_title : _($rs['description']);
$Data = array('keyword_title' => $title, 'keyword' => $rs['keyword'], 'keyword_description' => $rs['keyword_description'], 'additionalmeta' => $rs['additionalmeta']);
}
return $Data;
}
