/** * Creates a new Job model. * If creation is successful, the browser will be redirected to the 'view' page. * @return mixed */ public function actionCreate() { $model = new Job(); if ($model->load(Yii::$app->request->post()) && $model->save()) { return $this->redirect(['view', 'id' => $model->id]); } else { return $this->render('create', ['model' => $model]); } }
/** * Creates a new Job model. * If creation is successful, the browser will be redirected to the 'view' page. * @return mixed */ public function actionCreate() { $admin_id = Yii::$app->user->identity->id; $model = new Job(); // $companies = Company::findBySql('SELECT * FROM wolf_company order by company_name')->all(); // $companies = Company::find()->all(); $companies = Company::find(); if (Yii::$app->user->identity->type == 'normal') { $companies = $companies->innerJoin('wolf_admin_to_company wc', 'wc.company_id=wolf_company.company_id'); $companies = $companies->where('admin_id=' . $admin_id); } $companies = $companies->orderBy('company_name'); $companies = $companies->asArray(); $companies = $companies->all(); // echo $companies->createCommand()->getRawSql();exit; if ($model->load(Yii::$app->request->post())) { $time_in_hour = $_POST['Job']['time_in_hour']; $time_in_minute = $_POST['Job']['time_in_minute']; $time_out_hour = $_POST['Job']['time_out_hour']; $time_out_minute = $_POST['Job']['time_out_minute']; $model->time_in = $time_in_hour . ':' . $time_in_minute . ':00'; $model->time_out = $time_out_hour . ':' . $time_out_minute . ':00'; } if ($model->load(Yii::$app->request->post()) && $model->save()) { return $this->redirect(['view', 'id' => $model->job_id]); } else { return $this->render('create', ['model' => $model, 'companies' => $companies]); } }
/** * Updates an existing Person model. * If update is successful, the browser will be redirected to the 'view' page. * @param string $id * @return mixed */ public function actionUpdate($id) { $model = $this->findModel($id); $jobModel = $model->job; if ($jobModel->load(Yii::$app->request->post()) && $jobModel->validate() && $model->load(Yii::$app->request->post()) && $model->validate()) { $transaction = $model->getDb()->beginTransaction(); try { if (is_numeric($jobModel->name)) { $jobModel = $jobModel->findOne($jobModel->name); } else { $jobModel = new Job(); $jobModel->load(Yii::$app->request->post()); if (!$jobModel->save(false)) { throw new Exception(Yii::t('app', 'Error saving {model}: {msj}', ['model' => Yii::t('app', ucfirst($jobModel->tableName())), 'msj' => print_r($jobModel->getErrors(), true)]), 500); } } if ($model->job_id != $jobModel->id) { $model->job_id = $jobModel->id; } if (!$model->save(false)) { throw new Exception(Yii::t('app', 'Error saving {model}: {msj}', ['model' => Yii::t('app', ucfirst($model->tableName())), 'msj' => print_r($model->getErrors(), true)]), 500); } $transaction->commit(); } catch (\Exception $e) { $transaction->rollBack(); throw $e; } return $this->redirect(['index']); } else { return $this->render('update', ['model' => $model, 'jobModel' => $jobModel]); } }