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; }