/** * Updates an existing Table model. * If update is successful, the browser will be redirected to the 'view' page. * @param integer $id * @return mixed */ public function actionUpdate($id) { $modelTable = $this->findModel($id); $modelsField = $modelTable->fields; if ($modelTable->load(\Yii::$app->request->post())) { $oldIDs = ArrayHelper::map($modelsField, 'id', 'id'); $modelsField = Model::createMultiple(Field::classname(), $modelsField); Model::loadMultiple($modelsField, \Yii::$app->request->post()); $deletedIDs = array_diff($oldIDs, array_filter(ArrayHelper::map($modelsField, 'id', 'id'))); for ($i = 0; $i < count($modelsField); $i++) { if ($modelsField[$i]->isNewRecord) { $modelsField[$i]->slug_name = PhysicalTableGenerator::getSafeFieldName($modelTable->slug_name, $modelsField[$i]->name); //Util::slugifyToDbSafe($modelsField[$i]->name) . "_" . \Yii::$app->security->generateRandomString(6); $modelsField[$i]->df_table_id = $modelTable->id; } } // validate all models $valid = $modelTable->validate(); $valid = Model::validateMultiple($modelsField) && $valid; if ($valid) { $transaction = \Yii::$app->db->beginTransaction(); try { if ($flag = $modelTable->save(false)) { if (!empty($deletedIDs)) { PhysicalTableGenerator::deleteField($modelTable, $deletedIDs); Field::deleteAll(['id' => $deletedIDs]); } foreach ($modelsField as $modelField) { $beforeIsNewRecord = $modelField->isNewRecord; if (!($flag = $modelField->save(false))) { $transaction->rollBack(); break; } else { if ($beforeIsNewRecord == true) { PhysicalTableGenerator::addField($modelTable, $modelField); } else { PhysicalTableGenerator::updateField($modelTable, $modelField); } } } } if ($flag) { $transaction->commit(); return $this->redirect(['view', 'id' => $modelTable->id]); } } catch (Exception $e) { $transaction->rollBack(); } } } return $this->render('update', ['modelTable' => $modelTable, 'modelsField' => empty($modelsField) ? [new Field()] : $modelsField]); }