/** * 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')); }