/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = SoStatus::find(); // add conditions that should always apply here $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } // grid filtering conditions $query->andFilterWhere(['ID' => $this->ID, 'STT_PROCESS' => $this->STT_PROCESS, 'UPDATE_AT' => $this->UPDATE_AT]); $query->andFilterWhere(['like', 'KD_SO', $this->KD_SO])->andFilterWhere(['like', 'ID_USER', $this->ID_USER]); return $dataProvider; }
public function actionCreateSales() { $model = new SoHeader(); $model_status = new SoStatus(); # code... if ($model->load(Yii::$app->request->post())) { # SoHeader $kode = Yii::$app->ambilkonci->getSMO(); $model->KD_SO = $kode; $model->STT_PROCESS = 0; $model->CREATE_BY = Yii::$app->user->identity->id; # SoStatus $model_status->KD_SO = $kode; $model_status->ID_USER = $model->USER_SIGN1; $model_status->STT_PROCESS = 0; $transaction = self::Esm_connent()->beginTransaction(); try { # SoHeader $model->save(); # SoStatus $model_status->save(); // ...other DB operations... $transaction->commit(); } catch (\Exception $e) { $transaction->rollBack(); throw $e; } return $this->redirect(['/purchasing/salesman-order/review-new', 'id' => $model->KD_SO, 'stt' => 1, 'cust_kd' => $model->CUST_ID, 'user_id' => $model->USER_SIGN1, 'tgl' => $model->TGL]); } else { return $this->renderAjax('new_so', ['model' => $model, 'data_cus' => self::get_aryCustomers(), 'data_user' => self::get_aryUser_id()]); } }
public function actionSignAuth3($kdso) { $model = new Auth3Model(); $model_header = $this->findModelHeader($kdso); $model_status = new SoStatus(); $profile = Yii::$app->getUserOpt->Profile_user(); $id = $profile->id; # code... if ($model->load(Yii::$app->request->post())) { $transaction = self::Esm_connent()->beginTransaction(); try { # SoHeader $model_header->STT_PROCESS = $model->status; $model_header->USER_SIGN3 = $id; $model_header->TGL_SIGN2 = date('Y-m-d h:i:s'); $model_header->save(); # SoStatus $model_status->KD_SO = $model->kdso; $model_status->STT_PROCESS = $model->status; $model_status->ID_USER = $id; $model_status->save(); // ...other DB operations... $transaction->commit(); } catch (\Exception $e) { $transaction->rollBack(); throw $e; } return $this->redirect(['/purchasing/salesman-order/review', 'id' => $kdso, 'stt' => 1]); } else { return $this->renderAjax('sign_3', ['model' => $model, 'kode_som' => $kdso]); } }
/** * Finds the SoStatus model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return SoStatus the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = SoStatus::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }