/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = UserData::find(); $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; } $query->andFilterWhere(['id' => $this->id, 'sFishType' => $this->sFishType, 'sFishWeight' => $this->sFishWeight, 'FishPrice' => $this->FishPrice, 'FishExpirience' => $this->FishExpirience]); $query->andFilterWhere(['like', 'PID', $this->PID]); return $dataProvider; }
public function getUserData() { return $this->hasOne(UserData::className(), ['user_id' => 'id']); }
public function actionSetUserData() { $request = Yii::$app->request; if (!($name = $request->post('action'))) { return $this->goHome(); } $encr = new Encr(); if ($name == 'SetUserData' && $request->post('sessionId')) { if (!($session = serverSession::findOne(['sessionId' => $request->post('sessionId')]))) { return 0; } $pid = trim($encr->Decr($session->key, $request->post('pid'))); $FishType = trim($encr->Decr($session->key, $request->post('FishType'))); $FishWeight = trim($encr->Decr($session->key, $request->post('FishWeight'))); $FishPrice = trim($encr->Decr($session->key, $request->post('FishPrice'))); $FishExpirience = trim($encr->Decr($session->key, $request->post('FishExpirience'))); $userData = new UserData(); $userData->PID = $pid; $userData->FishWeight = $FishWeight; $userData->FishPrice = $FishPrice; $userData->FishExpirience = $FishExpirience; $userData->FishType = $FishType; $userData->sFishType = $userData->getFishName($FishType); $userData->sFishWeight = $userData->getFishNormalizedWeight($FishWeight); $userData->Date = date("Y-m-d H:i:s"); // $userData->save(); echo "Success"; } return 0; }
/** * Finds the UserData model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return UserData the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = UserData::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }