/**
* Deletes an existing Catalog model.
* If deletion is successful, the browser will be redirected to the 'index' page.
* @param integer $id
* @return mixed
*/
public function actionDelete($id)
{
// delete date
$date_delete = $this->findModel($id);
$id_delete = $date_delete["id_catalog"];
$name_delete = $date_delete['catalog_name'];
SearchTable::deleteAll(['name_search' => $name_delete, 'link_search' => $id_delete, 'type_search' => '1']);
$this->findModel($id)->delete();
return $this->redirect(['index']);
}
/**
* view result
*
* @return string
*/
public function actionResult()
{
if (isset($_POST['search-bt'])) {
// search
$search_text = Yii::$app->request->post('search-text');
// query
$resSearch = SearchTable::find()->where("MATCH (name_search) AGAINST ('{$search_text}' ) ")->all();
if (count($resSearch) > 0) {
foreach ($resSearch as $rowSearch) {
$name_all[] = $rowSearch->name_search;
$type_all[] = $rowSearch->type_search;
$link_all[] = $rowSearch->link_search;
}
// priority
$priority_type = $type_all[0];
$priority_link = $link_all[0];
// choice priority
switch ($priority_type) {
// catalog
case 1:
$count_catalog = count($name_all);
// phrase
if ($count_catalog != 1) {
// all product from query
for ($pr = 0; $pr < count($link_all); $pr++) {
if ($type_all[$pr] == '3') {
$bfProduct[] = $name_all[$pr];
}
}
foreach ($bfProduct as $bflProduct) {
$resSection = Section::find()->where(['=', 'catalog_id', $priority_link])->all();
foreach ($resSection as $rowSection) {
$section[] = $rowSection->id_section;
}
foreach ($section as $vlSection) {
$resProduct = Product::find()->where(['=', 'section_id', $vlSection])->andWhere(['=', 'product_name', $bflProduct])->all();
}
foreach ($resProduct as $rowProduct) {
$id_product[] = $rowProduct->id_product;
$product_name[] = $rowProduct->product_name;
$photo_image[] = $rowProduct->photo;
}
}
$product = array_combine($id_product, $product_name);
$image = array_combine($id_product, $photo_image);
} else {
$resSection = Section::find()->where(['=', 'catalog_id', $priority_link])->all();
foreach ($resSection as $rowSection) {
$section[] = $rowSection->id_section;
}
foreach ($section as $vlSection) {
$resProduct = Product::find()->where(['=', 'section_id', $vlSection])->all();
}
foreach ($resProduct as $rowProduct) {
$id_product[] = $rowProduct->id_product;
$product_name[] = $rowProduct->product_name;
$photo_image[] = $rowProduct->photo;
}
$product = array_combine($id_product, $product_name);
$image = array_combine($id_product, $photo_image);
}
break;
// section
// section
case 2:
for ($pr = 0; $pr < count($link_all); $pr++) {
if ($type_all[$pr] == '3') {
$section[] = $link_all[$pr];
}
}
foreach ($section as $vlSection) {
$resProduct = Product::find()->where(['=', 'id_product', $vlSection])->all();
foreach ($resProduct as $rowProduct) {
$id_product[] = $rowProduct->id_product;
$product_name[] = $rowProduct->product_name;
$photo_image[] = $rowProduct->photo;
}
$product = array_combine($id_product, $product_name);
$image = array_combine($id_product, $photo_image);
}
break;
// product
// product
case 3:
$resProduct = Product::find()->where(['=', 'id_product', $priority_link])->all();
foreach ($resProduct as $rowProduct) {
$id_product[] = $rowProduct->id_product;
$product_name[] = $rowProduct->product_name;
$photo_image[] = $rowProduct->photo;
}
$product = array_combine($id_product, $product_name);
$image = array_combine($id_product, $photo_image);
break;
}
} else {
$product = null;
$image = null;
}
}
return $this->render('result', ['product' => $product, 'search_text' => $search_text, 'image' => $image]);
}