<?php // List users route (api/user/) global $dbh; // Auth user $user = Auth::authAPICall($dbh); // Initialize scouting db $sdb = new ScoutingDB($dbh, $user["organization_id"], 1, $user["id"]); // Default user fields $default_fields = array("id", "username", "firstname", "lastname", "active", "date_added"); $options = array_merge(array("sort_col" => "id", "sort_dir" => "up", "page" => 0, "limit" => 100, "fields" => $default_fields), $get); $safe_fields = $options["fields"] === $default_fields; // Output results $output = array("data" => $sdb->getList("organization_user", $options["sort_col"], $options["sort_dir"], $options["page"], $options["limit"], $options["fields"], $safe_fields), "numPages" => $sdb->getNumPages("organization_user", $options["limit"]));
<?php // List teams route (api/team/) global $dbh; // Auth user $user = Auth::authAPICall($dbh); // Initialize scouting db $sdb = new ScoutingDB($dbh, $user["organization_id"], 1, $user["id"]); // Default team fields $default_fields = array("id", "team_number", "team_name", "team_type", "summary", "strengths", "weaknesses", "use_markdown", "date_added"); $options = array_merge(array("sort_col" => "team_number", "sort_dir" => "up", "page" => 0, "limit" => 100, "fields" => $default_fields, "search" => ""), $get); $safe_fields = $options["fields"] === $default_fields; $options["search"] = urldecode($options["search"]); $where = array(); // Output results $output = array("data" => $sdb->getList("team", $options["sort_col"], $options["sort_dir"], $options["page"], $options["limit"], $options["fields"], $safe_fields, $where, $options["search"]), "numPages" => $sdb->getNumPages("team", $options["limit"], $where, $options["search"], $options["fields"]));
<?php // Feed route (api/feed/) global $dbh; // Auth user $user = Auth::authAPICall($dbh); $sdb = new ScoutingDB($dbh, $user["organization_id"], 1, $user["id"]); $default_fields = array("id", "organization_user_id", "name", "url", "entry", "filename", "use_markdown", "date_added"); $options = array_merge(array("sort_col" => "date_added", "sort_dir" => "down", "page" => 1, "limit" => 20, "fields" => $default_fields, "url" => ""), $get); $safe_fields = $options["fields"] === $default_fields; $where = array(); if (strlen($options["url"])) { $where["url"] = $options["url"]; } // Output results $output = array("data" => $sdb->getList("feed_entry", $options["sort_col"], $options["sort_dir"], $options["page"], $options["limit"], $options["fields"], $safe_fields, $where), "numPages" => $sdb->getNumPages("feed_entry", $options["limit"], $where)); foreach ($output["data"] as &$row) { $user = $sdb->getItem("organization_user", array("id" => $row["organization_user_id"]), array("firstname", "lastname")); $row["organization_user"] = $user["firstname"] . " " . $user["lastname"]; }