Example #1
0
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Peoples::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(['peopleId' => $this->peopleId, 'peopleBirthday' => $this->peopleBirthday, 'peopleWorking' => $this->peopleWorking, 'peopleFluDate' => $this->peopleFluDate, 'peopleFluResult' => $this->peopleFluResult, 'peopleFluTerm' => $this->peopleFluTerm, 'peopleStreet' => $this->peopleStreet, 'peopleAdress' => $this->peopleAdress, 'fluInfo' => $this->peopleFluNumber]);
     $query->andFilterWhere(['like', 'peopleFIO', $this->peopleFIO])->andFilterWhere(['like', 'peopleFluNumber', $this->peopleFluNumber]);
     return $dataProvider;
 }
Example #2
0
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getPeoples()
 {
     return $this->hasMany(Peoples::className(), ['peopleWorking' => 'workingId']);
 }
 /**
  * Экшн поиска людей по улице и сроку флюры.
  * @return mixed
  */
 public function actionPprintfind($streetId)
 {
     $model = new Peoples();
     $peoplesArr = Peoples::find()->where(['peopleStreet' => $streetId])->all();
     foreach ($peoplesArr as $p) {
         $findRes = graftsPeoples::find()->where(['peopleId' => $p['peopleId']])->all();
         if (empty($findRes)) {
             continue;
         } else {
             foreach ($findRes as $f) {
                 $graftName = Grafts::find()->where(['graftId' => $f['graftId']])->all();
                 $arr[$p['peopleId']][] = $graftName[0]['graftName'];
             }
         }
     }
     return $this->render('pprintFind', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'model' => $model, 'dt' => $peoplesArr]);
 }
Example #4
0
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getPeople()
 {
     return $this->hasOne(Peoples::className(), ['peopleId' => 'peopleId']);
 }
Example #5
0
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getPeoples()
 {
     return $this->hasMany(Peoples::className(), ['peopleStreet' => 'streetId']);
 }