$file_contents = file_get_contents($file);
$data = array("stats" => array("defenses" => json_decode($file_contents, 1)));
$team_stats = array();
foreach ($data["stats"] as $stat => $teams) {
if (is_string($teams)) {
$teams = json_decode($teams, 1);
}
foreach ($teams as $team_number => $stats) {
if (!isset($team_stats[$team_number])) {
$team_stats[$team_number] = array();
}
$team_stats[$team_number][$stat] = $stats;
}
}
$json_fields = array("questions", "stats");
foreach ($team_stats as $team_number => $stats) {
$existing = $sdb->getItem("team", array("team_number" => $team_number), array("id", "stats_json"));
if ($existing["id"] > 0) {
$sdb->updateTeam($team_number, array_merge($existing, array("stats" => $stats)));
} else {
$tba_team = $tba->get("team/frc{$team_number}");
$data = array_merge($default_fields, $tba_team, array("team_number" => $team_number, "team_name" => $tba_team["nickname"], "stats" => $stats));
foreach ($json_fields as $field) {
if (isset($data[$field])) {
$data["{$field}_json"] = json_encode($data[$field]);
}
}
$sdb->addTeam($data);
}
}
die(print_r($team_stats));
if (isset($post[$field])) {
if (strlen(trim($post[$field]))) {
$team_data[$field] = trim($post[$field]);
} else {
$errors[] = array("field" => $field, "msg" => "{$label} can't be blank");
$success = false;
}
}
}
foreach ($other_fields as $field) {
if (isset($post[$field])) {
$team_data[$field] = trim($post[$field]);
}
}
if ($success) {
$existing = $sdb->getItem("team", array("team_number" => $data["teamID"]));
if (!count($existing)) {
$success = false;
$errors[] = array("field" => "team_number", "msg" => "Team #{$data["teamID"]} doesn't exist!");
}
}
if ($success) {
$data = $sdb->updateTeam($data["teamID"], $team_data);
if (!isset($data["id"]) || !$data["id"] && !$data["error"]) {
$success = false;
$data = array();
$errors[] = "Database error";
}
}
}
$output = array("data" => $data, "error" => $errors, "success" => $success);
