public function get_array_all()
{
if (empty($this->userid)) {
//if ($this->access > 1) {
// return apiDB::getLocations();
//} else {
$user = apiDB::getUserByEmail($_SERVER['PHP_AUTH_USER']);
return apiDB::getUserLocations($user->id);
//}
} else {
return apiDB::getUserLocations($this->userid);
}
}
public function get_array_all()
{
if (empty($this->userid)) {
$user = apiDB::getUserByEmail($_SERVER['PHP_AUTH_USER']);
$locations = apiDB::getUserLocations($user->id, $this->columnName());
if (count($locations) == 1) {
return apiDB::getLocationMeasurements($locations[0]->locationid, $user->userid, get_class($this));
} else {
$error = array();
$error["ERROR"] = "cannot display all measurements - please specify a location ID";
return $error;
//This is a hack
}
}
return apiDB::getLocationMeasurements($this->locationid, $this->userid, get_class($this));
}
static function getUser($userid, $level = 1)
{
$conxn = apiDB::getConnection();
$user = new User();
$sql = "SELECT * FROM cw_user WHERE id = " . $userid;
$result = pg_query($conxn, $sql);
if (pg_num_rows($result) > 0) {
$row = pg_fetch_array($result);
if ($level > 0) {
$user->email = $row["email"];
$user->password = $row["password"];
$user->id = $row["id"];
$user->access = $row["access"];
$user->verified = $row["verified"];
$user->firstname = $row["firstname"];
$user->lastname = $row["lastname"];
$user->postal = $row["postal"];
$user->phone = $row["phone"];
$user->sub_summary = $row["sub_summary"];
$user->sub_gwadi = $row["sub_gwadi"];
$user->sub_stats = $row["sub_stats"];
$user->locations = apiDB::getUserLocations($userid, $level - 1);
} else {
$user = $row["id"];
}
}
pg_close($conxn);
return $user;
}
static function getUser($userid, $level = 1)
{
$conxn = apiDB::getConnection();
$user = new User();
$sql = "SELECT * FROM cw_user WHERE id = " . $userid;
$result = pg_query($conxn, $sql);
if (pg_num_rows($result) > 0) {
$row = pg_fetch_array($result);
if ($level > 0) {
$user->email = $row["email"];
$user->password = $row["password"];
$user->id = $row["id"];
$user->locations = apiDB::getUserLocations($userid, $level - 1);
} else {
$user = $row["id"];
}
}
pg_close($conxn);
return $user;
}
