예제 #1
0
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Person::find();
     $dataProvider = new ActiveDataProvider(['query' => $query]);
     if (!($this->load($params) && $this->validate())) {
         return $dataProvider;
     }
     $query->andFilterWhere(['id' => $this->id]);
     $query->andFilterWhere(['like', 'prename', $this->prename])->andFilterWhere(['like', 'fname', $this->fname])->andFilterWhere(['like', 'lname', $this->lname])->andFilterWhere(['like', 'mtype', $this->mtype]);
     return $dataProvider;
 }
예제 #2
0
파일: PersonSearch.php 프로젝트: komsin/yii
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Person::find();
     $dataProvider = new ActiveDataProvider(['query' => $query]);
     $this->load($params);
     if (!$this->validate()) {
         // uncomment the following line if you do not want to any records when validation fails
         // $query->where('0=1');
         return $dataProvider;
     }
     $query->andFilterWhere(['BIRTH' => $this->BIRTH, 'MOVEIN' => $this->MOVEIN, 'DDISCHARGE' => $this->DDISCHARGE, 'D_UPDATE' => $this->D_UPDATE]);
     $query->andFilterWhere(['like', 'HOSPCODE', $this->HOSPCODE])->andFilterWhere(['like', 'CID', $this->CID])->andFilterWhere(['like', 'PID', $this->PID])->andFilterWhere(['like', 'HID', $this->HID])->andFilterWhere(['like', 'PRENAME', $this->PRENAME])->andFilterWhere(['like', 'NAME', $this->NAME])->andFilterWhere(['like', 'LNAME', $this->LNAME])->andFilterWhere(['like', 'HN', $this->HN])->andFilterWhere(['like', 'SEX', $this->SEX])->andFilterWhere(['like', 'MSTATUS', $this->MSTATUS])->andFilterWhere(['like', 'OCCUPATION_OLD', $this->OCCUPATION_OLD])->andFilterWhere(['like', 'OCCUPATION_NEW', $this->OCCUPATION_NEW])->andFilterWhere(['like', 'RACE', $this->RACE])->andFilterWhere(['like', 'NATION', $this->NATION])->andFilterWhere(['like', 'RELIGION', $this->RELIGION])->andFilterWhere(['like', 'EDUCATION', $this->EDUCATION])->andFilterWhere(['like', 'FSTATUS', $this->FSTATUS])->andFilterWhere(['like', 'FATHER', $this->FATHER])->andFilterWhere(['like', 'MOTHER', $this->MOTHER])->andFilterWhere(['like', 'COUPLE', $this->COUPLE])->andFilterWhere(['like', 'VSTATUS', $this->VSTATUS])->andFilterWhere(['like', 'DISCHARGE', $this->DISCHARGE])->andFilterWhere(['like', 'ABOGROUP', $this->ABOGROUP])->andFilterWhere(['like', 'RHGROUP', $this->RHGROUP])->andFilterWhere(['like', 'LABOR', $this->LABOR])->andFilterWhere(['like', 'PASSPORT', $this->PASSPORT])->andFilterWhere(['like', 'TYPEAREA', $this->TYPEAREA]);
     return $dataProvider;
 }
예제 #3
0
 /**
  * Finds the Person model based on its primary key value.
  * If the model is not found, a 404 HTTP exception will be thrown.
  * @param string $HOSPCODE
  * @param string $PID
  * @return Person the loaded model
  * @throws NotFoundHttpException if the model cannot be found
  */
 protected function findModel($HOSPCODE, $PID)
 {
     if (($model = Person::findOne(['HOSPCODE' => $HOSPCODE, 'PID' => $PID])) !== null) {
         return $model;
     } else {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
 }
예제 #4
0
 /**
  * Finds the Person model based on its primary key value.
  * If the model is not found, a 404 HTTP exception will be thrown.
  * @param integer $id
  * @return Person the loaded model
  * @throws NotFoundHttpException if the model cannot be found
  */
 protected function findModel($id)
 {
     if (($model = Person::findOne($id)) !== null) {
         return $model;
     } else {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
 }