/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Racer::find(); $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['position_general' => SORT_ASC]]]); $dataProvider->sort->attributes['user.name'] = ['asc' => ['user.name' => SORT_ASC], 'desc' => ['user.name' => SORT_DESC]]; $query->joinWith(['user']); $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(['id' => $this->id, 'category_id' => $this->category_id]); $name = $this->getAttribute('user.name'); $words = explode(' ', $name); foreach ($words as $word) { $query->andFilterWhere(['or', ['like', 'user.name', $word], ['like', 'user.lastname', $word]]); } return $dataProvider; }
?> <br/> <strong>Talla de Camiseta:</strong> <?php echo $user->size; ?> <br/> <?php } ?> </div> </div> <div class="link-infcarreras"> <?php if ($model->status == 'PENDING') { if (!Yii::$app->user->isGuest) { if (Racer::find()->where('user_id=' . Yii::$app->user->id . ' AND race_id=' . $model->id)->one()) { ?> <a class="ver-inscribirse">Inscrito</a> <?php } else { $form = ActiveForm::begin(); ?> <?php echo $form->field($racer, 'user_id')->hiddenInput(['value' => Yii::$app->user->id]); ?> <?php echo $form->field($racer, 'category_id')->dropDownList(ArrayHelper::map($model->categories, 'id', 'name'), ['prompt' => 'Escoge una categoría']); ?> <?php echo Html::submitButton('Inscribirse', ['class' => 'ver-inscribirse']); ?>