/**
* Helper to populate the database.
* @param array $data Data to be saved.
* @throws Exception is thrown when unable to save.
*/
private function populateTable($data)
{
//skip first row
for ($i = 1; $i < count($data); $i++) {
$teamStats = new TeamStat();
$teamStats->name = $data[$i][0];
$teamStats->played = $data[$i][1];
$teamStats->wins = $data[$i][2];
$teamStats->loses = $data[$i][3];
$teamStats->draws = $data[$i][4];
$teamStats->goals_for = $data[$i][5];
$teamStats->goals_against = $data[$i][6];
$teamStats->points = $data[$i][7];
$teamStats->last_game_day = $data[$i][8];
$saved = $teamStats->save();
if (!$saved) {
throw new Exception("Unable to insert data");
}
}
}
/**
* Creates a new row in the database.
* Required field is the name.
* @return json
*/
public function create()
{
$name = Input::get('name');
if ($name) {
$wins = (int) Input::get('wins', 0);
$loses = (int) Input::get('loses', 0);
$draws = (int) Input::get('draws', 0);
$teamStatsModel = new TeamStat();
$teamStatsModel->name = $name;
$teamStatsModel->played = $wins + $loses + $draws;
$teamStatsModel->wins = $wins;
//default value 0
$teamStatsModel->loses = $loses;
//default value 0
$teamStatsModel->draws = $draws;
//default value 0
$teamStatsModel->goals_for = (int) Input::get('goals_for', 0);
//default value 0
$teamStatsModel->goals_against = (int) Input::get('goals_against', 0);
//default value 0
$teamStatsModel->points = (int) Input::get('points', 0);
//default value 0
$teamStatsModel->last_game_day = (int) Input::get('last_game_day', 0);
//default value 0
$saved = $teamStatsModel->save();
if (!$saved) {
return response()->json(array('status' => false, 'error' => 'Unable to save'));
}
return response()->json(array('status' => true));
}
return response()->json('name is a required field');
}
