public static function getAllparentCat()
{
$data = [];
$parent = ProductCategorySelfRel::find()->where(['parent_cat_id' => 0])->all();
$i = 0;
echo '<pre>';
foreach ($parent as $key) {
$data[$i]['title'] = $key->category_name_with_cat_id->cat_title;
$data[$i]['slug'] = $key->category_name_with_cat_id->cat_slug;
$data[$i]['sort_order'] = $key->category_name_with_cat_id->sort_order;
$data[$i]['desc'] = $key->category_name_with_cat_id->cat_desc;
$i++;
}
return $data;
}
public function actionGet_landing_section()
{
// \Yii::$app->response->format = \yii\web\Response::FORMAT_JSON;
$response = [];
$data_q = MenuPageRels::getMenu_new(6);
$response['main_menu'] = $data_q;
// return $response;
$slider_data = Slider::get_slider_1(3);
$response['home-slider'] = $slider_data;
$categories = ProductCategorySelfRel::getAllparentCat();
$response['categories'] = $categories;
$fp = fopen('json/landing_json.json', 'w');
fwrite($fp, \yii\helpers\Json::encode($response));
fclose($fp);
return $this->redirect(['/']);
}
public function getProject_category_category_self_rel()
{
return $this->hasOne(ProductCategorySelfRel::className(), ['cat_id' => 'category_id']);
}
public static function get_parent_cat($id, $data)
{
$parent = ProductCategorySelfRel::find()->where(['cat_id' => $id])->one();
if (!empty($parent)) {
$parent_cat = self::find()->where(['id' => $parent->parent_cat_id])->one();
if (!empty($parent_cat)) {
$data = $parent_cat->cat_slug . '/' . $data;
self::get_parent_cat($parent->parent_cat_id, $data);
}
}
return $data;
}
