/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Tiles::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(['id' => $this->id, 'x' => $this->x, 'y' => $this->y, 'category' => $this->category, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at, 'created_by' => $this->created_by, 'updated_by' => $this->updated_by]);
$query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'description', $this->description])->andFilterWhere(['like', 'text', $this->text]);
return $dataProvider;
}
/**
* Displays the more page
*
* @return mixed
*/
public function actionMore()
{
$resultsPage = $this->findResultsPageModel(4);
$tiles = Tiles::find()->orderBy(['x' => SORT_ASC, 'y' => SORT_ASC])->all();
$levels = Levels::find()->all();
$tilesUsersArray = ArrayHelper::map(TilesUsers::find()->where(['created_by' => Yii::$app->getUser()->id])->all(), 'tile', 'level');
foreach ($tiles as $tile) {
if (array_key_exists($tile->id, $tilesUsersArray)) {
$tilesUsers[$tile->id] = $tilesUsersArray[$tile->id];
} else {
$tilesUsers[$tile->id] = -1;
}
}
$pass = true;
if (Yii::$app->request->getIsPost()) {
$tilesUsers = Yii::$app->request->post()['TilesUsers'];
TilesUsers::deleteAll(['created_by' => Yii::$app->getUser()->id]);
foreach ($tilesUsers as $id => $tilesUser) {
$model = new TilesUsers();
$model->tile = $id;
$model->level = $tilesUser !== '' ? $tilesUser : -1;
$model->save();
if ($tilesUser === '-1') {
$pass = false;
}
}
if ($pass) {
return $this->redirect(['moreresults']);
}
}
return $this->render('more', ['resultsPage' => $resultsPage, 'tiles' => $tiles, 'levels' => $levels, 'tilesUsers' => $tilesUsers, 'pass' => $pass]);
}
