yii2 - how to save input in one form and automatically update another table

Question

i have condition that has been bothering me sometimes. i have two models sewalocker and loker, these two models are related. i have a form in sewalockers that required to fill locker number as loker_id. when the form is submitted, i want status of selected loker_id assigned as 'loaned' not 'available' any more in loker table. how do i do that?

here is my sewaController :

<?php

namespace app\controllers;

use Yii;
use app\models\SewaLocker;
use app\models\sewaSearch;
use app\models\loker;
use yii\web\Controller;
use yii\web\NotFoundHttpException;
use yii\filters\VerbFilter;


class SewaController extends Controller
{
 public function behaviors()
 {
    return [
        'verbs' => [
            'class' => VerbFilter::className(),
            'actions' => [
                'delete' => ['post'],
            ],
        ],
    ];
}

/**
 * Lists all SewaLocker models.
 * @return mixed
 */
public function actionIndex()
{
    $searchModel = new sewaSearch();
    $dataProvider = $searchModel->search(Yii::$app->request->queryParams);

    return $this->render('index', [
        'searchModel' => $searchModel,
        'dataProvider' => $dataProvider,
    ]);
}

/**
 * Displays a single SewaLocker model.
 * @param integer $id
 * @return mixed
 */
public function actionView($id)
{
    return $this->render('view', [
        'model' => $this->findModel($id),
    ]);
}

/**
 * Creates a new SewaLocker model.
 * If creation is successful, the browser will be redirected to the 'view' page.
 * @return mixed
 */
public function actionCreate()
{
    $model = new SewaLocker();
    $loker = new loker();

    if ($model->load(Yii::$app->request->post()) && $model->save()) {
        return $this->redirect(['view', 'id' => $model->id_sewa]);
    } else {
        return $this->render('create', [
            'model' => $model,
        ]);
    }
}

You want to do this in create action? ..

ScaisEdge
– ScaisEdge

2016-01-22 15:38:35 +00:00
Commented Jan 22, 2016 at 15:38 — ScaisEdge
– ScaisEdge, Commented Jan 22, 2016 at 15:38
yes i want to do it in actionCreate() in SewaController

ishadif
– ishadif

2016-01-22 16:09:51 +00:00
Commented Jan 22, 2016 at 16:09 — ishadif
– ishadif, Commented Jan 22, 2016 at 16:09

ishadif · Accepted Answer · 2016-01-22 17:57:08Z

1

In create you should do this way

if the SewaLocker model is saved you then can retrive the right loker model adn update..

public function actionCreate()
{
    $model = new SewaLocker();


    if ($model->load(Yii::$app->request->post()) && $model->save()) {
        $loker = $this->findLokerModel($model->locker_id);
        $loker->status ="Loaned not available";
        $loker->save();

        return $this->redirect(['view', 'id' => $model->id_sewa]);
    } else {
        return $this->render('create', [
            'model' => $model,
        ]);
    }
}

protected function findLokerModel($id)
{
    if (($model = Loker::findOne($id)) !== null) {
        return $model;
    } else {
        throw new NotFoundHttpException('The requested page does not exist.');
    }
}

edited Jan 22, 2016 at 17:57

ishadif

7312 gold badges9 silver badges20 bronze badges

answered Jan 22, 2016 at 15:45

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

ishadif Over a year ago

it says 'Call to undefined function app\controllers\findLokermodel()' . what i am missing then?

ScaisEdge Over a year ago

You added the findLoker model in your controller ? eventually change protected in public for test..

ishadif Over a year ago

yes i added in my controller. nothing's changed, it says the same.

Salem Ouerdani Over a year ago

$loker = $this->findLokerModel($model->locker_id);

Collectives™ on Stack Overflow

yii2 - how to save input in one form and automatically update another table

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related