/**
* Creates a new AnItems model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreate()
{
$model = new AnItems();
$NeccFunc = new NeccFunctions();
// вибираємо головних батьків
$parentCats = AnCats::find()->roots()->all();
$list = $NeccFunc->getCorrectList($parentCats);
// вибираємо регіони
$regionsQuery = AnRegions::find()->asArray()->all();
$regions = array();
// формую правильний масив для select форми
// хоча потрібно було б використати ArrayHelper::map($array, 'key', 'key')
foreach ($regionsQuery as $region) {
$regions[$region['id']] = $region['name'];
}
if ($model->load(Yii::$app->request->post())) {
$model->created_at = DATE('Y-m-d H:i:s');
$model->status = 0;
$model->local = Yii::$app->language;
$model->save();
return $this->redirect('/announcement/anitems');
} else {
return $this->render('create', ['model' => $model, 'regions' => $regions, 'list' => $list]);
}
}
/**
* Updates an existing AnRegions model.
* If update is successful, the browser will be redirected to the 'view' page.
* @param integer $id
* @return mixed
*/
public function actionUpdate($id)
{
$model = $this->findModel($id);
$model->getParentReg();
$regionsQuery = AnRegions::find()->asArray()->all();
$regions = array();
$regions[0] = 'Немає';
foreach ($regionsQuery as $region) {
$regions[$region['id']] = $region['name'];
}
if ($model->load(Yii::$app->request->post())) {
$formsData = Yii::$app->request->post();
$formsData = $formsData['AnRegions'];
if ($formsData['parentReg'] == 0) {
$reg = AnRegions::findOne(['name' => $formsData['name']]);
$reg->local = $formsData['local'];
$reg->makeRoot();
} else {
$parent = AnRegions::findOne(['id' => $formsData['parentReg']]);
$reg = AnRegions::findOne(['name' => $formsData['name']]);
$reg->local = $formsData['local'];
$reg->appendTo($parent);
}
return $this->redirect(['view', 'id' => $reg->id]);
} else {
return $this->render('update', ['model' => $model, 'regions' => $regions]);
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = AnRegions::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'tree' => $this->parentReg, 'lft' => $this->lft, 'rgt' => $this->rgt, 'depth' => $this->depth]);
$query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'local', $this->local]);
return $dataProvider;
}
public function init()
{
parent::init();
$NeccFunc = new NeccFunctions();
$perPage = $this->perPage ? $this->perPage : 10;
// вибираємо головних батьків
$parentCats = AnCats::find()->where(['local' => Yii::$app->language])->roots()->all();
$this->categories = $NeccFunc->getCorrectList($parentCats);
foreach ($parentCats as $cats) {
$this->categories[$cats->id] = $cats->name;
}
// виборка категорій та регіонів
//$this->categories = AnCats::find()->addOrderBy('tree')->addOrderBy('lft')->all();
$parentRegs = AnRegions::find()->roots()->all();
$this->regions = $NeccFunc->getCorrectList($parentRegs);
//$this->regions = AnRegions::find()->addOrderBy('tree')->addOrderBy('lft')->all();
// пошукові запроси, якщо такі є
$this->searchModel = new AnItemsSearch();
$this->dataProvider = $this->searchModel->search(Yii::$app->request->queryParams, $perPage);
$this->registerTranslations();
}
/**
* Creates a new AnItems model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreate()
{
$model = new AnItems();
$catsQuery = AnCats::find()->asArray()->all();
$cats = array();
foreach ($catsQuery as $cat) {
$cats[$cat['id']] = $cat['name'];
}
$regionsQuery = AnRegions::find()->asArray()->all();
$regions = array();
foreach ($regionsQuery as $region) {
$regions[$region['id']] = $region['name'];
}
if ($model->load(Yii::$app->request->post())) {
$model->created_at = DATE('Y-m-d H:i:s');
$model->status = 0;
$model->local = Yii::$app->language;
$model->save();
return $this->redirect(['view', 'id' => $model->id]);
} else {
return $this->render('create', ['model' => $model, 'cats' => $cats, 'regions' => $regions]);
}
}
public function getParents()
{
return AnRegions::find()->roots()->all();
}
