function getItemByKeyword($keyword, $lang)
{
$articleDB = new ArticleDB();
$variantDB = new VariantDB();
$res = $articleDB->getArticleByKeyword($keyword, $lang);
$items = array();
while ($itemRes = $res->fetch_object()) {
$itemName = $itemRes->ArticleName;
if ($itemRes->TranslatedName != null) {
$itemName = $itemRes->TranslatedName;
}
$itemDescription = $itemRes->ArticleDescription;
if ($itemRes->TranslatedName != null) {
$itemDescription = $itemRes->TranslatedDescription;
}
$itemImage = "No_image_available.png";
if ($itemRes->ArticleImage != null) {
$itemImage = $itemRes->ArticleImage;
}
$itemImage = "./img/" . $itemImage;
$varRes = $variantDB->getAllVariantsFromArticle($itemRes->Article_ID, $lang);
$variants = array();
while ($variant = $varRes->fetch_object()) {
$variantName = $variant->VariationName;
if ($variant->TranslatedName != null) {
$variantName = $variant->TranslatedName;
}
$variantDescription = $variant->VariationDescription;
if ($variant->TranslatedName != null) {
$variantDescription = $variant->TranslatedDescription;
}
$variants[] = new articleVariant($variant->Variation_ID, $variantName, $variant->VariationPrice);
}
$items[] = new article($itemRes->Article_ID, $itemName, $itemRes->ArticlePrice, $itemDescription, $itemImage, $variants);
}
return $items;
}
public function actionSearch()
{
$hornav = $this->getHornav();
$hornav->addData("Поиск");
$this->title = "Поиск: " . $this->request->query;
$this->meta_desc = "Поиск " . $this->request->query . ".";
$this->meta_key = "поиск, поиск " . $this->request->query;
$articles = ArticleDB::search($this->request->query);
$sr = new SearchResult();
if (mb_strlen($this->request->query) < Config::MIN_SEARCH_LEN) {
$sr->error_len = true;
}
$sr->hornav = $hornav;
$sr->field = "full";
$sr->query = $this->request->query;
$sr->data = $articles;
$this->render($sr);
}
function deleteArticle($artID)
{
require_once ROOT . "DBInterface/articleTranslationDB.php";
require_once ROOT . "DBInterface/categoryArticleDB.php";
require_once ROOT . "DBInterface/variantDB.php";
require_once ROOT . "DBInterface/variantTranslationDB.php";
$articleDB = new ArticleDB();
$articleTranslationDB = new ArticleTranslationDB();
$categoryArticleDB = new CategoryArticleDB();
$variantDB = new VariantDB();
$variantTranslationDB = new VariantTranslationDB();
$articleDB->deleteArticle($artID);
$articleTranslationDB->deleteAllTranslationsByArticle($artID);
$categoryArticleDB->deleteAllCategorysByArticle($artID);
$sqlVariantRes = $variantDB->getAllVariantIDsByArticle($artID);
while ($variant = $sqlVariantRes->fetch_object()) {
$variantTranslationDB->deleteAllVariantsByArticle($variant->Variation_ID);
}
$variantDB->deleteAllVariantsByArticle($artID);
}
