public function search($params) { $query = SupplierModel::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['id_supplier' => $this->id_supplier, 'create_by' => $this->create_by, 'update_by' => $this->update_by]); $query->andFilterWhere(['like', 'cd_supplier', $this->cd_supplier])->andFilterWhere(['like', 'nm_supplier', $this->nm_supplier])->andFilterWhere(['like', 'create_at', $this->create_at])->andFilterWhere(['like', 'update_at', $this->update_at]); return $dataProvider; }
/** * @return \yii\db\ActiveQuery */ public function getIdSupplier() { return $this->hasOne(Supplier::className(), ['id_supplier' => 'id_supplier']); }
public function setNmSupplier($value) { $this->_nm_supplier = $value; $supp = Supplier::findOne(['nm_supplier' => $value]); if ($supp) { $this->id_supplier = $supp->id_supplier; } else { $this->id_supplier = null; } }
/** * Finds the Supplier model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Supplier the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Supplier::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }