/**
* @param $model \febfeb\dynamicfield\modules\models\Table
* @param $field_ids array
*/
public static function deleteField($model, $field_ids)
{
foreach ($field_ids as $field_id) {
$field = Field::find()->where(["id" => $field_id])->one();
$db = \Yii::$app->db;
$command = $db->createCommand();
$command->dropColumn($model->slug_name, $field->slug_name)->execute();
}
}
/**
* 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]);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getFields()
{
return $this->hasMany(\febfeb\dynamicfield\modules\models\Field::className(), ['df_table_id' => 'id']);
}
