Ejemplo n.º 1
0
 public function updateTeam($team_number, $data)
 {
     if (!($team_number > 0)) {
         return array("error" => "Invalid team number");
     }
     $where = array("organization_id" => $this->organization_id, "organization_domain_id" => $this->organization_domain_id, "team_number" => $team_number);
     $where_q = DBHandler::createWhereString($where, "e");
     $allowed_fields = array("team_name", "summary", "strengths", "weaknesses", "score", "questions_json", "scores_json", "stats_json", "use_markdown");
     $set_data = array();
     foreach ($allowed_fields as $field) {
         if (in_array($field, $allowed_fields) && isset($data[$field])) {
             $set_data[$field] = $data[$field];
         }
     }
     $set_q = DBHandler::createSetString($set_data, "e");
     $query = "UPDATE team e SET {$set_q[0]} WHERE {$where_q[0]}";
     $this->dbh->query($query, array_merge($set_q[1], $where_q[1]));
     return $this->getItem("team", array("team_number" => $team_number));
 }