public function actionFillcountries()
{
$countries = Country::find()->all();
foreach ($countries as $country) {
try {
if (TeamSum::find()->where("name like '" . addslashes($country->name) . "'")->one()) {
continue;
} else {
$team = new TeamSum();
$team->name = $country->name;
$team->tournament_id = 4;
$team->is_club = 0;
$team->save(false);
//var_dump($team);
}
} catch (\ErrorException $e) {
echo $e->getMessage();
}
// if($country->id == 11) { $country->iso_code = 'ad'; $country->soccer_code = 19; $country->update(); }
}
}
/**
* Коэффициенты УЕФА
*/
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;
}
}
