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