/**
* Update the league table with parsing.
*
* @return \Illuminate\Http\RedirectResponse|\Illuminate\Routing\Redirector
*/
public function update()
{
// temp fix for unreliable package
require "../resources/assets/libs/simple_html_dom.php";
$html = file_get_html('http://mnzveza-ptuj.si/liga/175/');
$table = $html->find('table', -1);
if ($table->children(0)->tag == "tbody") {
$table = $table->children(0);
}
for ($i = 1; $i < 9; $i++) {
$id = $this->link_id($table->children($i)->children(1)->children(0)->href);
$row = LeagueTable::find($id);
$row->played = $table->children($i)->children(2)->plaintext;
$row->won = $table->children($i)->children(3)->plaintext;
$row->drawn = $table->children($i)->children(4)->plaintext;
$row->lost = $table->children($i)->children(5)->plaintext;
$row->goals_for = $table->children($i)->children(6)->plaintext;
$row->goals_against = $table->children($i)->children(7)->plaintext;
$row->goal_difference = $table->children($i)->children(8)->plaintext;
$row->points = $table->children($i)->children(9)->plaintext;
$row->save();
}
return redirect('rezultati');
}
/**
* @return \Illuminate\View\View
*/
public function results()
{
$table = LeagueTable::orderBy('points', 'DESC')->orderBy('goal_difference', 'DESC')->get();
return view('pages.results', compact('table'));
}
