/**
* @return \yii\db\ActiveQuery
*/
public function getEventHeroesList()
{
return $this->hasMany(DotaEventHero::className(), ['event_id' => 'id'])->with('hero');
}
/**
* @return \yii\db\ActiveQuery
*/
public function getEventHero()
{
return $this->hasOne(DotaEventHero::className(), ['hero_id' => 'hero_id']);
}
/**
* проверяем изменения в героях
*/
public function checkHeroes($model)
{
$array_identical = false;
if (count($model->dotaEventHeroes) != count($model->hero_id)) {
$array_identical = false;
} else {
foreach ($model->dotaEventHeroes as $model1) {
$array_identical = false;
foreach ($model->hero_id as $value) {
$array_identical = false;
if ($model1->hero_id == $value) {
if ($model->price_md_h[$model1->hero_id] == $model1->price_md && $model->price_hd[$model1->hero_id] == $model1->price_hd) {
$array_identical = true;
} else {
$array_identical = false;
}
}
if ($array_identical === false) {
break;
}
}
if ($array_identical === false) {
break;
}
}
}
if ($array_identical == false) {
foreach ($model->dotaEventHeroes as $model1) {
$model1->delete();
}
foreach ($model->hero_id as $hero_id) {
if ($model->price_md_h[$hero_id] != 0 || $model->price_hd[$hero_id] != 0) {
$model_n = new DotaEventHero();
$model_n->event_id = $model->id;
$model_n->hero_id = $hero_id;
if ($model->price_md_h[$hero_id] != 0) {
$model_n->price_md = $model->price_md_h[$hero_id];
}
if ($model->price_hd[$hero_id] != 0) {
$model_n->price_hd = $model->price_hd[$hero_id];
}
$model_n->save();
//echo'<pre>';var_dump($model_n);echo'</pre>';die;
}
}
}
}
public function actionAddNewRate()
{
//$current_action = Yii::$app->controller->action->id;
$fantasy_id = (int) Yii::$app->request->post('id', 0);
//$draft_id = (int)Yii::$app->request->post('draft_id', 0);
$fantasy = DotaFantasy::findOne($fantasy_id);
if ($fantasy === null) {
return;
}
$draft_id = $fantasy->draft_id;
$params = DotaParams::loadParams();
//echo'<pre>';var_dump($fantasy->draft_id);echo'</pre>';//die;
$data = ['params' => $params, 'draft_id' => $draft_id, 'fantasy_id' => $fantasy_id, 'fantasyModel' => $fantasy, 'game_name' => GamesParams::GAME_DOTA_NAME];
switch ($fantasy->draft_id) {
case DotaFantasySearch::DOTA_PLAYERS_DRAFT_ID:
$view = 'add-new-rate-form-players';
$playersList = DotaEventPlayer::loadPlayersListOnFantasy($fantasy_id);
$data['playersList'] = $playersList;
break;
case DotaFantasySearch::DOTA_HEROES_DRAFT_ID:
$view = 'add-new-rate-form-heroes';
$heroesList = DotaEventHero::loadHeroesListOnFantasy($fantasy_id);
$data['heroesList'] = $heroesList;
break;
case DotaFantasySearch::DOTA_MIXED_DRAFT_ID:
$view = 'add-new-rate-form-mixed';
$playersList = DotaEventPlayer::loadPlayersListOnFantasy($fantasy_id);
$heroesList = DotaEventHero::loadHeroesListOnFantasy($fantasy_id);
$data['playersList'] = $playersList;
$data['heroesList'] = $heroesList;
break;
default:
$view = '';
break;
}
//echo'<pre>'; print_r('actionAddNewRate');echo'</pre>';die;
if ($fantasy_id == 0 || $draft_id == 0 || $view == '') {
return;
}
return $this->renderPartial($view, $data);
}
public static function updateDotaEventHeroStat()
{
$params = DotaParams::loadParams();
$events = DotaEvent::getActualEventsList();
$event_ids = ArrayHelper::map($events, 'id', 'id');
$heroesInEvents = DotaEventHeroStat::getHeroesInEvents($event_ids);
$DotaEventLeague = new DotaEventLeague();
$LeaguesInEvents = $DotaEventLeague->getLeaguesInEvents($event_ids);
//echo'<pre>';print_r($LeaguesInEvents);echo'</pre>';die;
$league_ids = [];
foreach ($LeaguesInEvents as $event) {
foreach ($event as $leagueid) {
$league_ids[] = $leagueid;
}
}
$played_matches = DotaMatchHistoryHeroes::getCountPlayedMatches($league_ids);
//echo'<pre>';print_r($played_matches);echo'</pre>';die;
$HeroesInLeagues = DotaLeagueHeroesStat::getHeroesInLeagues($league_ids);
//echo'<pre>';print_r($HeroesInLeagues);echo'</pre>';die;
$HeroesInEvents = DotaEventHero::getHeroesInEvents();
$hero_ids = [];
foreach ($HeroesInEvents as $event) {
foreach ($event as $hero) {
$hero_ids[] = $hero;
}
}
$hero_ids = array_unique($hero_ids);
//echo'<pre>';print_r($hero_ids);echo'</pre>';die;
//$player_roles = DotaPlayer::getPlayersRolesList($account_ids);
//echo'<pre>';print_r($LeaguesInEvents);echo'</pre>';//die;
$summaries = [];
foreach ($LeaguesInEvents as $event_id => $event) {
foreach ($event as $leagueid) {
if (isset($HeroesInLeagues[$leagueid])) {
foreach ($HeroesInLeagues[$leagueid] as $hero_id => $heroesInLeague) {
if (isset($HeroesInEvents[$event_id][$hero_id])) {
$summaries[$event_id][$hero_id] = $heroesInLeague;
}
}
}
}
}
$data_for_insert = [];
//echo'<pre>';print_r($summaries);echo'</pre>';die;
foreach ($summaries as $event_id => $heroes) {
foreach ($heroes as $hero_id => $hero) {
$kills = $deaths = $assists = $gold_per_min = $xp_per_min = $level = $picks = $bans = 0;
$kills += $hero['kills'];
$deaths += $hero['deaths'];
$assists += $hero['assists'];
$gold_per_min += $hero['gold_per_min'];
$xp_per_min += $hero['xp_per_min'];
$level += $hero['level'];
$picks += $hero['picks'];
$bans += $hero['bans'];
if (isset($heroesInEvents[$event_id][$hero_id])) {
//если есть запись по игроку в event, то обновляем ее
$data = ['`kills`' => $kills, '`deaths`' => $deaths, '`assists`' => $assists, '`gold_per_min`' => $gold_per_min, '`xp_per_min`' => $xp_per_min, '`level`' => $level, '`picks`' => $picks, '`bans`' => $bans, '`matches`' => isset($played_matches[$hero_id]) ? $played_matches[$hero_id] : 0];
$where = ['`id` = ' . $heroesInEvents[$event_id][$hero_id]];
//echo'<pre>updateRow</pre>';//die;
DotaEventHeroStat::updateRow($data, $where);
} else {
$data = [$event_id, $hero_id, $kills, $deaths, $assists, $gold_per_min, $xp_per_min, $level, $picks, $bans, isset($played_matches[$hero_id]) ? $played_matches[$hero_id] : 0];
$data_for_insert[] = "(" . implode(',', $data) . ")";
}
}
}
//echo'<pre>';print_r($data_for_insert);echo'</pre>';die;
if (count($data_for_insert) > 0) {
DotaEventHeroStat::addRows($data_for_insert);
}
// перерасчет кол-ва очков у каждого героя
foreach ($summaries as $event_id => $heroes) {
DotaEventHeroStat::calculateScoresForEvent($event_id);
}
return true;
}
