/**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params, $locationIds = null)
 {
     $query = Location::find();
     if (!is_null($locationIds) && is_array($locationIds)) {
         $query->where(['id' => $locationIds]);
     }
     $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;
     }
     $dataProvider->setSort(['attributes' => ['id', 'name', 'type_id']]);
     $query->andFilterWhere(['id' => $this->id, 'type_id' => $this->type_id]);
     $query->andFilterWhere(['like', 'name', $this->name]);
     return $dataProvider;
 }
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getLocation()
 {
     return $this->hasOne(Location::className(), ['id' => 'location_id']);
 }
예제 #3
0
 /**
  * @return \yii\db\ActiveQuery
  */
 public static function findLocation($input)
 {
     if (!is_array($input)) {
         return null;
     }
     $listTypes = ArrayHelper::map(static::$types, 'tag', 'id');
     $filtered = [];
     foreach ($input as $inputKey => $inputValue) {
         if (isset($listTypes[$inputKey])) {
             $filtered[$inputKey] = $inputValue;
         }
     }
     if (empty($filtered)) {
         return null;
     }
     $counter = 0;
     $locationTable = Location::tableName();
     $query = static::find();
     foreach ($filtered as $type => $name) {
         if ($counter === 0) {
             $query->andWhere(['and', [$locationTable . '.type_id' => $listTypes[$type]], [$locationTable . '.name' => $name]]);
         } else {
             $linksTable = 'link' . strval($counter);
             $query->leftJoin(LocationLinks::tableName() . ' AS ' . $linksTable, $linksTable . '.lower_id = ' . $locationTable . '.id');
             $locationTable = 'loc' . strval($counter);
             $query->leftJoin(Location::tableName() . ' AS ' . $locationTable, $locationTable . '.id = ' . $linksTable . '.upper_id');
             $query->andWhere(['and', [$locationTable . '.type_id' => $listTypes[$type]], [$locationTable . '.name' => $name]]);
         }
         $counter++;
     }
     //        $result = $query->all();
     //        if( is_array($result) && (count($result) == 1) ) return $result[0];
     //        return $result;
     return $query;
 }