/**
* Lists all Players models.
* @return mixed
*/
public function actionIndex()
{
$teamId = Teams::find()->select('id')->where(['name' => Yii::$app->params['main-team']])->one()->id;
$dataProvider['vr'] = new ActiveDataProvider(['query' => Players::find()->where(['teams_id' => $teamId, 'role' => 'вр']), 'pagination' => false]);
$dataProvider['zsh'] = new ActiveDataProvider(['query' => Players::find()->where(['teams_id' => $teamId, 'role' => 'зщ']), 'pagination' => false]);
$dataProvider['pzsh'] = new ActiveDataProvider(['query' => Players::find()->where(['teams_id' => $teamId, 'role' => 'пз']), 'pagination' => false]);
$dataProvider['np'] = new ActiveDataProvider(['query' => Players::find()->where(['teams_id' => $teamId, 'role' => 'нп']), 'pagination' => false]);
return $this->render('index', ['dataProvider' => $dataProvider]);
}
/**
* Displays a single Games model.
* @param integer $id
* @return mixed
*/
public function actionView($id)
{
$this->layout = 'main-full';
$model = $this->findModel($id);
$gameData['home'] = GamesPlayers::find()->where(['game_id' => $model->id, 'team_id' => $model->home_id])->all();
$gameData['guest'] = GamesPlayers::find()->where(['game_id' => $model->id, 'team_id' => $model->guest_id])->all();
$gameData['mainTeam'] = Teams::find()->select('id')->where(['name' => Yii::$app->params['main-team']])->one();
$gameData['nextGame'] = Games::find()->select('id')->where(['home_id' => $gameData['mainTeam']->id])->orWhere(['guest_id' => $gameData['mainTeam']->id])->andWhere(['>', 'date', $model->date])->one();
$gameData['prevGame'] = Games::find()->select('id')->where(['home_id' => $gameData['mainTeam']->id])->orWhere(['guest_id' => $gameData['mainTeam']->id])->andWhere(['<', 'date', $model->date])->orderBy('date DESC')->one();
$dataProvider['gamePlayersHome'] = new ActiveDataProvider(['query' => GamesPlayers::find()->where(['game_id' => $model->id, 'team_id' => $model->home_id])]);
$dataProvider['gamePlayersGuest'] = new ActiveDataProvider(['query' => GamesPlayers::find()->where(['game_id' => $model->id, 'team_id' => $model->guest_id])]);
return $this->render('view', ['model' => $model, 'gameData' => $gameData, 'dataProvider' => $dataProvider]);
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Teams::find()->orderBy('id DESC');
$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(['id' => $this->id]);
$query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'slug', $this->slug])->andFilterWhere(['like', 'year', $this->year])->andFilterWhere(['like', 'web_site', $this->web_site])->andFilterWhere(['like', 'description', $this->description])->andFilterWhere(['like', 'city', $this->city])->andFilterWhere(['like', 'stadium', $this->stadium]);
return $dataProvider;
}
/**
* Lists all ClubQuestionsSearch models.
* @return mixed
*/
public function actionIndex()
{
$model = new ClubQuestions();
$data['mainTeam'] = Teams::find()->where(['name' => Yii::$app->params['main-team']])->with('players')->with('coachingStaff')->one();
if ($model->load(Yii::$app->request->post())) {
// var_dump($model);die;
$ip = $_SERVER['REMOTE_ADDR'];
if (isset($ip)) {
$model->ip = $ip;
} else {
$model->ip = 'NULL';
}
// $query = BlackList::find()->where(['email'=>$model->email])->orWhere(['ip'=>$model->ip]);
// if (!Yii::$app->user->isGuest) {
// $query->orWhere(['user_id'=>$model->ip]);
// }
// $blacklistedCheck = $query->one();
// if (is_null($blacklistedCheck)) {
$model->date = time();
$model->status = 'on';
if (Yii::$app->user->isGuest) {
$model->user_id = 0;
} else {
$model->user_id = Yii::$app->user->identity->id;
$userDetails = User::findOne($model->user_id);
$model->name = $userDetails['username'];
$model->email = $userDetails['email'];
}
if ($model->save()) {
// $model = new ClubQuestions();
return Alert::widget(['options' => ['class' => 'alert-success'], 'body' => '<b>Успешно!</b> Ваша запись опубликованна.']);
} else {
var_dump($model->errors);
exit;
}
// } else {
// return Alert::widget([
// 'options' => [
// 'class' => 'alert-danger'
// ],
// 'body' => '<b>Ошибка!</b> Вы в чёрном списке.'
// ]);
// }
}
$dataProvider = new ActiveDataProvider(['query' => ClubQuestions::find()->where(['status' => 'on'])->orderBy('date DESC'), 'pagination' => ['pageSize' => 20]]);
return $this->render('index', ['dataProvider' => $dataProvider, 'model' => $model, 'data' => $data]);
}
public function searchFrontend($params)
{
$model = Teams::find()->where(['name' => Yii::$app->params['main-team']])->with('seasonDetails')->one();
$season_id = $model->lastSeasonDetails->season_id;
$query = SeasonDetails::find()->select('*, `goals_scored`-`goals_against` as `rm`')->where(['season_id' => $season_id])->orderBy('spectacles DESC, wins DESC, draws DESC, lesions, rm DESC, goals_scored DESC, goals_against');
// add conditions that should always apply here
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => false, 'sort' => false]);
$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;
}
// grid filtering conditions
$query->andFilterWhere(['id' => $this->id, 'season_id' => $this->season_id, 'team_id' => $this->team_id, 'games' => $this->games, 'wins' => $this->wins, 'draws' => $this->draws, 'lesions' => $this->lesions, 'spectacles' => $this->spectacles, 'goals_against' => $this->goals_against, 'goals_scored' => $this->goals_scored]);
return $dataProvider;
}
/**
* Updates an existing Players model.
* If update is successful, the browser will be redirected to the 'view' page.
* @param integer $id
* @return mixed
*/
public function actionUpdate($id)
{
$model = $this->findModel($id);
// var_dump($model); die;
if ($model->load(Yii::$app->request->post()) && $model->save()) {
if (!empty($_FILES['UploadForm']['tmp_name']['file'])) {
$model->removeImages();
$model->attachImage($_FILES['UploadForm']['tmp_name']['file']);
if ($model->errors) {
var_dump($model->errors);
die;
}
}
return $this->redirect(['view', 'id' => $model->id]);
} else {
return $this->render('update', ['model' => $model, 'teams' => Teams::find()->all()]);
}
}
/**
* @return \yii\db\ActiveQuery
*/
public function getTeam()
{
return $this->hasOne(Teams::className(), ['id' => 'team_id']);
}
/**
* Displays homepage.
*
* @return mixed
*/
public function actionIndex()
{
$data['questions'] = Questions::find()->where(['status' => 'on'])->orderBy('id DESC')->one();
$data['answerPoll'] = AnswersPoll::find()->where(['quest_id' => $data['questions']->id, 'ip' => $_SERVER['REMOTE_ADDR']])->one();
if (!empty($_POST)) {
$model = new AnswersPoll();
$dataPost = Yii::$app->request->post();
$model->quest_id = $dataPost['question_id'];
$model->answer_id = $dataPost['answer_id'];
$model->ip = $_SERVER['REMOTE_ADDR'];
$check = AnswersPoll::find()->where(['quest_id' => $model->quest_id, 'ip' => $model->ip])->one();
$model->date = time();
$alertMessage = '';
if ($model->save() && is_null($check)) {
$modelAnswer = Answers::findOne($dataPost['answer_id']);
$modelAnswer->how_many = $modelAnswer->how_many + 1;
$modelAnswer->save();
$data['answerPoll'] = AnswersPoll::find()->where(['quest_id' => $data['questions']->id, 'ip' => $_SERVER['REMOTE_ADDR']])->one();
} else {
$alertMessage = Alert::widget(['options' => ['class' => 'alert-danger'], 'body' => '<b>Ошибка!</b> Ответ не был записан.']);
}
return $this->render('_poll', ['answersData' => $data['questions']->answers, 'questions' => $data['questions'], 'answerPoll' => $data['answerPoll'], 'alertMessage' => $alertMessage]);
}
$dataProvider['news'] = new ActiveDataProvider(['query' => News::find()->where(['status_id' => 'on'])->orderBy('date_create DESC, id DESC')->limit(10), 'pagination' => ['pageSize' => 11]]);
$data['mainTeam'] = Teams::find()->where(['name' => Yii::$app->params['main-team']])->one();
// $CId = [2];
$CId = [3];
$allCoaches = CoachingStaff::find()->where(['teams_id' => $data['mainTeam']->id])->andWhere(['in', 'id', $CId])->all();
$PlId = [28, 4, 20, 17];
$allPlayers = Players::find()->where(['teams_id' => $data['mainTeam']->id])->andWhere(['in', 'id', $PlId])->all();
$data['allPlayers'] = [];
foreach ($allPlayers as $item) {
// $allPlayers[$item->id] = $item;
if ($item->id == 28) {
$data['allPlayers'][1] = $item;
}
if ($item->id == 4) {
$data['allPlayers'][2] = $item;
}
if ($item->id == 20) {
$data['allPlayers'][3] = $item;
}
if ($item->id == 17) {
$data['allPlayers'][4] = $item;
}
}
foreach ($allCoaches as $item) {
$data['allCoaches'][0] = $item;
}
ksort($data['allPlayers']);
// ksort($data['allCoaches']);
// $data['allPlayers'] = ksort($data['allPlayers']);
// var_dump($data['allPlayers']);
// var_dump(krsort($data['allPlayers']));
// $data['allPlayers'][0] = $allPlayers[2];
// var_dump($allPlayers);
// die;
// $data['allPlayers'][1] = $allPlayers[28];
// $data['allPlayers'][2] = $allPlayers[4];
// $data['allPlayers'][3] = $allPlayers[20];
// $data['allPlayers'][4] = $allPlayers[17];
// CaseMaster::find()->where(["DATE_FORMAT( FROM_UNIXTIME( i_date ),'%d-%m-%Y' )"=>date('d-m-Y')])->all();
// DATE_FORMAT("2008-11-19",'%d.%m.%Y');
// $sorted_articles=[];
// foreach($articles as $article){
// $dt=date('d.m.Y',$article->sort_date);
// $sorted_articles[$dt][]=$article;
// }
// $data['allPlayers'] = [];
// foreach($data['allPlayers'] as $item) {
// var_dump(date('d.m.Y', $item->date));
//// var_dump($item['date_new']);
//// $item['new_date'] = $item->date;
//// $item->date = date('d.m', $item->date);
//// $dt = date('d.m', $item->date);
// $data['allPlayers'][] = $item;
// }
// var_dump($data['allPlayers']);
$data['seasonDetails'] = $data['mainTeam']->lastSeasonDetails;
$data['season'] = $data['seasonDetails']->season;
$dataProvider['standings'] = new ActiveDataProvider(['query' => SeasonDetails::find()->where(['season_id' => $data['season']->id])->orderBy('spectacles DESC')->limit(20), 'pagination' => false]);
$data['gameLast'] = Games::find()->where(['home_id' => $data['mainTeam']->id])->orWhere(['guest_id' => $data['mainTeam']->id])->orderBy('date')->one();
$data['gameFirst'] = Games::find()->where(['home_id' => $data['mainTeam']->id])->orWhere(['guest_id' => $data['mainTeam']->id])->orderBy('date DESC')->one();
$data['gamesLast'] = Games::find()->where(['home_id' => $data['mainTeam']->id])->orWhere(['guest_id' => $data['mainTeam']->id])->andWhere(['<', 'date', time()])->orderBy('date DESC')->limit(3)->all();
$data['gamesFirst'] = Games::find()->where(['home_id' => $data['mainTeam']->id])->orWhere(['guest_id' => $data['mainTeam']->id])->andWhere(['>', 'date', time()])->orderBy('date')->limit(3)->all();
$model = new AnswersPoll();
return $this->render('index', ['dataProvider' => $dataProvider, 'data' => $data, 'model' => $model]);
}
public function getAllTeams()
{
return Teams::find()->all();
}
/**
* Finds the Teams model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Teams the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Teams::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
public function getAllTeam()
{
return ArrayHelper::map(Teams::find()->select(['id', 'name'])->asArray()->all(), 'id', 'name');
}
/**
* @return \yii\db\ActiveQuery
*/
public function getGuest()
{
return $this->hasOne(Teams::className(), ['id' => 'guest_id']);
}
<?php
use yii\helpers\Html;
use common\models\Teams;
/* @var $this yii\web\View */
/* @var $model common\models\Players */
$this->title = 'Создание игрока';
$this->params['breadcrumbs'][] = ['label' => 'Игроки', 'url' => ['index']];
$this->params['breadcrumbs'][] = $this->title;
?>
<div class="players-create">
<h1><?php
echo Html::encode($this->title);
?>
</h1>
<?php
echo $this->render('_form', ['model' => $model, 'teams' => Teams::find()->all()]);
?>
</div>
