/**
* Прогноз
* @param $id
* @return string
*/
public function actionPrognose($id)
{
$this->layout = '@app/themes/prognose/views/layouts/pagein';
if ($this->userIfUserLegal($id)) {
$now_id = 1;
$users_predicted_matches = implode(',', ArrayHelper::map(Totpredict::find()->where(['user_id' => $this->current_user->id])->all(), 'id', 'match_id'));
$all = Totmatch::find()->all();
foreach ($all as $one) {
/*echo date('Y-m-d H:i:s', Totmatch::formatMatchDateToTime(explode(' ', $one->date)[0]))." "
.Totmatch::formatMatchDateToTime(explode(' ', $one->date)[0])." ".time()."<br>";
var_dump(Totmatch::formatMatchDateToTime(explode(' ', $one->date)[0]) >= time());
*/
if (Totmatch::formatMatchDateToTime(explode(' ', $one->date)[0]) + 36000 <= time()) {
$now_id = $one->id;
}
}
if ($users_predicted_matches) {
$match_list = Totmatch::find()->where("id NOT IN (" . $users_predicted_matches . ") AND id > " . $now_id)->all();
} else {
$match_list = Totmatch::find()->where("id > " . $now_id)->all();
}
return $this->render('group', ['user' => $this->current_user, 'match_list' => $match_list]);
}
return $this->render('index');
}
/**
* Прогноз
* @return string
*/
public function actionPrognose()
{
if (Yii::$app->getRequest()->getQueryParam('login') && Yii::$app->getRequest()->getQueryParam('pseudo')) {
$name = Yii::$app->getRequest()->getQueryParam('login');
$pseudo = Yii::$app->getRequest()->getQueryParam('pseudo');
$user = Totuser::find()->where("name like('%" . $name . "') and pseudo like('" . $pseudo . "')")->one();
if ($user) {
//$now_id = 1;
$users_predicted_matches = implode(',', ArrayHelper::map(Totpredict::find()->where(['user_id' => $user->id])->all(), 'id', 'match_id'));
/*$all = Totmatch::find()->all();
foreach ($all as $one) {
if (Totmatch::formatMatchDateToTime(explode(' ', $one->date)[0]) + 36000 <= time()) {
$now_id = Totmatch::formatMatchDateToTime(explode(' ', $one->date)[0]);
}
}
*/
$tomorrow = date('d.m.Y', time() + 24 * 3600);
$day_after_tomorrow = date('d.m.Y', time() + 2 * 24 * 3600);
if ($users_predicted_matches) {
$match_list = Totmatch::find()->where("id NOT IN (" . $users_predicted_matches . ") AND (date like '" . $tomorrow . "%' OR date like '" . $day_after_tomorrow . "%')")->all();
} else {
$match_list = Totmatch::find()->where("date like '" . $tomorrow . "%' OR date like '" . $day_after_tomorrow . "%' ")->all();
}
//var_dump($match_list); exit;
return $this->render('group', ['user' => $user, 'match_list' => $match_list]);
}
echo 'no';
}
}
/**
* Проверка прогнозов
* @throws \Exception
*/
public function actionMarkPredictedMatches()
{
$day = date('d.m.Y', time() - 24 * 3600);
$day_before = date('d.m.Y', time() - 24 * 3600 * 2);
$predicted = Totmatch::find()->where(['foo_match_id' => 1])->andWhere("date like ('" . $day . "%') or date like ('" . $day_before . "%')")->all();
// var_dump($predicted); exit;
foreach ($predicted as $match) {
$date = explode(" ", $match->date);
try {
$d = $date[0];
} catch (\ErrorException $e) {
$d = '';
}
//echo $d; exit;
$m = Matches::find()->where("host like('_" . $match->host . "') and guest like('" . $match->guest . "_') and date like('" . $d . "')")->one();
//var_dump($match->guest); exit;
if ($m) {
echo $m->id . PHP_EOL;
//exit;
$match->foo_match_id = $m->id;
$match->update();
} else {
continue;
}
$tested = Totpredict::find()->where(['match_id' => $match->id])->all();
foreach ($tested as $play) {
//var_dump($play->host_g);
//var_dump($m->gett);
//var_dump($play->guest_g);
//var_dump($m->lett);
if ($play->host_g == $m->gett && $play->guest_g == $m->lett && ($m->prim !== ' После серии пенальти' && $m->prim !== ' После дополнительного времени')) {
$play->status = Totpredict::STATUS_RIGHT_SCORE;
$play->bet_balance = $this->getMatchBet($m->gett, $m->lett, $m->bet_h, $m->bet_n, $m->bet_g);
$play->update();
} elseif ($play->host_g == $play->guest_g && ($m->lett == $play->host_g || $m->gett == $play->guest_g) && ($m->prim == ' После серии пенальти' || $m->prim == ' После дополнительного времени')) {
var_dump($play);
$play->status = Totpredict::STATUS_RIGHT_SCORE;
$play->bet_balance = $this->getMatchBet(1, 1, $m->bet_h, $m->bet_n, $m->bet_g);
$play->update();
} elseif ($play->host_g == $play->guest_g && ($m->prim == ' После серии пенальти' || $m->prim == ' После дополнительного времени')) {
var_dump($play);
$play->status = Totpredict::STATUS_RIGHT_RESULT;
$play->bet_balance = $this->getMatchBet(1, 1, $m->bet_h, $m->bet_n, $m->bet_g);
$play->update();
} elseif ($play->host_g != $play->guest_g && ($m->prim == ' После серии пенальти' || $m->prim == ' После дополнительного времени')) {
var_dump($play);
$play->status = Totpredict::STATUS_BAD_PROGNOSE;
$play->bet_balance = -1;
$play->update();
} elseif ($play->host_g > $play->guest_g && $m->gett > $m->lett || $play->host_g == $play->guest_g && $m->gett == $m->lett || $play->host_g < $play->guest_g && $m->gett < $m->lett) {
$play->status = Totpredict::STATUS_RIGHT_RESULT;
$play->bet_balance = $this->getMatchBet($m->gett, $m->lett, $m->bet_h, $m->bet_n, $m->bet_g);
$play->update();
} else {
$play->status = Totpredict::STATUS_BAD_PROGNOSE;
$play->bet_balance = -1;
$play->update();
}
}
try {
Totpredict::getUsersStatus();
} catch (\ErrorException $e) {
echo $e->getMessage();
}
}
}