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