public function actionEdit($id)
{
$model = Products::findOne(['id' => $id]);
$all_cats = ModArendaTree::find()->asArray()->all();
if ($model->load(Yii::$app->request->post())) {
$model->imageFile = UploadedFile::getInstance($model, 'imageFile');
if ($model->validate()) {
if (!empty($model->imageFile)) {
$model->upload();
$model->image = md5($model->imageFile->baseName . date("Y-m-d-H-i-s")) . '.' . $model->imageFile->extension;
}
if ($model->save()) {
$last_id = $_GET['id'];
foreach (Yii::$app->request->post('character') as $key => $value) {
$model1 = CharacteristicsProducts::findOne(['product_id' => $last_id, 'character_id' => $key]);
if (!$model1) {
$model1 = new CharacteristicsProducts();
$model1->product_id = $last_id;
}
$model1->character_id = $key;
$model1->value = empty($value) ? 'none' : $value;
$model1->save();
}
}
// form inputs are valid, do something here
}
}
$result = CharacteristicsForCats::find()->select(['characteristics_for_cats.*', 'characteristics.name AS characteristic_name'])->where(['cat_id' => $model->cat_id])->leftJoin('characteristics', 'characteristics_for_cats.character_id=characteristics.id')->leftJoin('characteristics_products', 'characteristics_for_cats.character_id=characteristics_products.character_id')->asArray()->all();
if (empty($result)) {
$cat = ModArendaTree::findOne(['id' => $model->cat_id]);
while ($cat->parent_id != 0) {
$result = CharacteristicsForCats::find()->select(['characteristics_for_cats.*', 'characteristics.name AS characteristic_name', 'characteristics_products.value AS VALUE'])->where(['cat_id' => $cat->parent_id])->leftJoin('characteristics', 'characteristics_for_cats.character_id=characteristics.id')->leftJoin('characteristics_products', 'characteristics_for_cats.character_id=characteristics_products.character_id AND characteristics_products.product_id="' . $_GET['id'] . '"')->asArray()->all();
if (!empty($result)) {
break;
}
$cat = ModArendaTree::findOne(['id' => $cat->parent_id]);
}
} else {
}
$html = '';
if (!empty($result)) {
foreach ($result as $key => $value) {
$VAL = !empty($value['VALUE']) ? $value['VALUE'] : '';
$html .= '
<div class="form-group">
<label><p>' . $value['characteristic_name'] . '</p>
<input value="' . $VAL . '" type="text" class="form-control" name="character[' . $value['character_id'] . ']" >
</label>
</div>
';
}
}
return $this->render('edit', ['model' => $model, 'all_cats' => $all_cats, 'html' => $html]);
}
