function updateTeamData(TeamSum $team, $mtch)
{
try {
$team->cash_cout = count($mtch);
$team->cash_vic = 0;
$team->cash_nob = 0;
$team->cash_def = 0;
$team->cash_g_get = 0;
$team->cash_g_let = 0;
$team->cash_balls = 0;
foreach ($mtch as $match) {
if (strstr($match->host, $team->name)) {
// $team->cash_cout = count($mtch);
//var_dump(strstr($match->host, $key)); exit;
if ($match->gett > $match->lett) {
$team->cash_vic += 1;
$team->cash_g_get += $match->gett;
$team->cash_g_let += $match->lett;
$team->cash_balls += 3;
//$team->update(false);
} elseif ($match->gett == $match->lett) {
$team->cash_nob += 1;
$team->cash_g_get += $match->gett;
$team->cash_g_let += $match->lett;
$team->cash_balls += 1;
} else {
$team->cash_def += 1;
$team->cash_g_get += $match->gett;
$team->cash_g_let += $match->lett;
}
} else {
if ($match->gett > $match->lett) {
$team->cash_def += 1;
$team->cash_g_let += $match->gett;
$team->cash_g_get += $match->lett;
} elseif ($match->gett == $match->lett) {
$team->cash_nob += 1;
$team->cash_g_let += $match->gett;
$team->cash_g_get += $match->lett;
$team->cash_balls += 1;
} else {
$team->cash_vic += 1;
$team->cash_g_let += $match->gett;
$team->cash_g_get += $match->lett;
$team->cash_balls += 3;
}
}
$team->update(false);
}
} catch (\ErrorException $e) {
return $e->getMessage();
}
}
/**
* @return \yii\db\ActiveQuery
*/
public function getFooTeams()
{
return $this->hasMany(TeamSum::className(), ['tournament_id' => 'id']);
}
function actionGrandTeamsSummary()
{
$from = 72736;
$to = Matches::find()->select('MAX(id)')->scalar();
$matchs = [];
//$is_club = 1;
//echo TeamSum::find()->where("name like '".$team."'")->one()->is_club;
$grands = TeamSum::find()->where('is_tour_visual = 1')->all();
foreach ($grands as $grand) {
$matchs[$grand->name] = Matches::find()->orderBy('id DESC')->where("host like('_" . $grand->name . "') or guest like('" . $grand->name . "_') or (host like('_" . $grand->name . " (%') and host not like('_" . $grand->name . " (Б)%') ) or (guest like('" . $grand->name . " (%') and guest not like('" . $grand->name . " (Б)%'))")->andWhere("id > " . $from . " and id < " . $to . " ")->all();
}
//var_dump($matchs);
//var_dump($to);
// exit;
foreach ($matchs as $key => $mtch) {
$team = TeamSum::find()->where("name like '" . $key . "'")->one();
if ($team) {
echo $key . PHP_EOL;
$team->cash_cout = count($mtch);
$team->cash_vic = 0;
$team->cash_nob = 0;
$team->cash_def = 0;
$team->cash_g_get = 0;
$team->cash_g_let = 0;
$team->cash_balls = 0;
foreach ($mtch as $match) {
if (strstr($match->host, $key)) {
// $team->cash_cout = count($mtch);
//var_dump(strstr($match->host, $key)); exit;
if ($match->gett > $match->lett) {
$team->cash_vic += 1;
$team->cash_g_get += $match->gett;
$team->cash_g_let += $match->lett;
$team->cash_balls += 3;
//$team->update(false);
} elseif ($match->gett == $match->lett) {
$team->cash_nob += 1;
$team->cash_g_get += $match->gett;
$team->cash_g_let += $match->lett;
$team->cash_balls += 1;
} else {
$team->cash_def += 1;
$team->cash_g_get += $match->gett;
$team->cash_g_let += $match->lett;
}
} else {
if ($match->gett > $match->lett) {
$team->cash_def += 1;
$team->cash_g_let += $match->gett;
$team->cash_g_get += $match->lett;
} elseif ($match->gett == $match->lett) {
$team->cash_nob += 1;
$team->cash_g_let += $match->gett;
$team->cash_g_get += $match->lett;
$team->cash_balls += 1;
} else {
$team->cash_vic += 1;
$team->cash_g_let += $match->gett;
$team->cash_g_get += $match->lett;
$team->cash_balls += 3;
}
}
$team->update(false);
}
}
}
}
/**
* Коэффициенты УЕФА
*/
public function actionParsRatingUefaTeams()
{
$url = "http://www.profootball.ua/ranking/uefa_teams.html";
$content = $this->cut_content($this->get_page($url), 'class="t1"', 'UEFA Ranking By Bert Kassies');
$dom = new \DomDocument();
libxml_use_internal_errors(true);
$head = file_get_contents(Url::to("@app/commands/header.html"));
$teams = $head . $content;
//добавляем хэдер
$dom->loadHTML($teams);
$tr = $dom->getElementsByTagName("tr");
foreach ($tr as $node) {
$dom_in = new \DomDocument();
$html = $node->ownerDocument->saveHTML($node);
libxml_use_internal_errors(true);
$newhtml = $head . $html;
$dom_in->loadHTML($newhtml);
$td = $dom_in->getElementsByTagName("td");
foreach ($td as $node) {
echo $node->nodeValue . PHP_EOL;
if ($td[2]->nodeValue == 'Rus') {
break;
}
$team = new TeamSum();
$team->tournament_id = 2;
$team->alias = $td[1]->nodeValue;
$team->country = $td[2]->nodeValue;
$team->rank1old = $td[3]->nodeValue;
$team->rank2old = $td[4]->nodeValue;
$team->rank3old = $td[5]->nodeValue;
$team->rank4old = $td[6]->nodeValue;
$team->rank5old = $td[7]->nodeValue;
$team->rank = $td[8]->nodeValue;
$team->save(false);
break;
}
echo "--------------------" . PHP_EOL;
}
}
