/**
* Loads the data for this ViewNode record from the database
* @return ViewNode object (this)
*/
function load($style = 'long')
{
global $DB, $CFG, $USER, $ERROR, $HUB_FLM, $HUB_SQL;
try {
$this->canview();
} catch (Exception $e) {
return access_denied_error();
}
$params = array();
$params[0] = $this->viewid;
$params[1] = $this->nodeid;
$params[2] = $this->userid;
$resArray = $DB->select($HUB_SQL->DATAMODEL_VIEWNODE_SELECT, $params);
if ($resArray !== false) {
$count = count($resArray);
if ($count == 0) {
$ERROR = new error();
$ERROR->createNodeNotFoundError($this->nodeid);
return $ERROR;
} else {
for ($i = 0; $i < $count; $i++) {
$array = $resArray[$i];
$this->xpos = stripslashes(trim($array['XPos']));
$this->ypos = $array['YPos'];
$this->creationdate = $array['CreationDate'];
$this->modificationdate = $array['ModificationDate'];
$this->node = new CNode($this->nodeid);
$this->node = $this->node->load($style);
}
}
} else {
return database_error();
}
return $this;
}
/**
* Loads the data for this ViewNode record from the database
* @return ViewConnection object (this)
*/
function load($style = 'long')
{
global $DB, $CFG, $USER, $ERROR, $HUB_FLM, $HUB_SQL;
try {
$this->canview();
} catch (Exception $e) {
return access_denied_error();
}
$currentuser = '';
if (isset($USER->userid)) {
$currentuser = $USER->userid;
}
$params = array();
$params[0] = $this->viewid;
$params[1] = $this->connid;
$params[2] = $this->userid;
$resArray = $DB->select($HUB_SQL->DATAMODEL_VIEWCONNECTION_SELECT, $params);
if ($resArray !== false) {
$count = count($resArray);
if ($count == 0) {
$ERROR = new error();
$ERROR->createNodeNotFoundError($this->connid);
return $ERROR;
} else {
for ($i = 0; $i < $count; $i++) {
$array = $resArray[$i];
$this->creationdate = $array['CreationDate'];
$this->modificationdate = $array['ModificationDate'];
$this->connection = new Connection($this->connid);
$this->connection = $this->connection->load($style);
}
}
} else {
return database_error();
}
return $this;
}
/**
* Loads the data for the node from the database
*
* @param String $style (optional - default 'long') may be 'short' or 'long' or 'mini' or 'full' or 'shortactivity' (mini used for graphs)
* 'mini' include the base information like name, description, role, user, private, creation and modifications dates, connectedness, image, thumb.
* 'short' includes 'mini' plus address information, start and end date, otherconnections, userfollow.
* 'long' includes 'short' and associated website objects, tag objects, group onjects, votes, view counts and extra properties.
* 'full' includes 'long' and all activity and voting data. This is likely to be very heavy. Use wisely.
* 'shortactivity' includes 'short' plus the activity and voting data.
* 'cif' just what is needed for cif.
* @return Node object (this)
*/
function load($style = 'long')
{
global $DB, $CFG, $USER, $ERROR, $HUB_FLM, $HUB_SQL;
try {
$this->canview();
} catch (Exception $e) {
return access_denied_error();
}
$this->style = $style;
$params = array();
$params[0] = $this->nodeid;
$resArray = $DB->select($HUB_SQL->DATAMODEL_NODE_SELECT, $params);
if ($resArray !== false) {
$count = count($resArray);
if ($count == 0) {
$ERROR = new error();
$ERROR->createNodeNotFoundError($this->nodeid);
return $ERROR;
} else {
for ($i = 0; $i < $count; $i++) {
$array = $resArray[$i];
$this->name = stripslashes(trim($array['Name']));
$this->creationdate = $array['CreationDate'];
$this->modificationdate = $array['ModificationDate'];
if (isset($array['NodeTypeID'])) {
$this->role = new Role($array['NodeTypeID']);
$this->role = $this->role->load();
}
if (trim($array['Description']) != "") {
$this->hasdesc = true;
}
if ($style == 'long' || $style == 'cif') {
$this->description = stripslashes(trim($array['Description']));
}
$this->users = array();
if ($style == 'cif') {
//CIF does not need the whole user info at present
// or just userid at this level?
$this->users[0] = new User($array['UserID']);
} else {
$maps = getMapsForNode($this->nodeid, 0, 0);
$this->mapcount = $maps->totalno;
$this->connectedness = $array['connectedness'];
$this->private = $array['Private'];
$this->users[0] = getUser($array['UserID'], $style);
if ($array['Image']) {
$this->filename = $array['Image'];
$imagedir = $HUB_FLM->getUploadsNodeDir($this->nodeid, $array['UserID']);
$originalphotopath = $HUB_FLM->createUploadsDirPath($imagedir . "/" . stripslashes($array['Image']));
if (file_exists($originalphotopath)) {
$this->image = $HUB_FLM->getUploadsWebPath($imagedir . "/" . stripslashes($array['Image']));
$this->thumb = $HUB_FLM->getUploadsWebPath($imagedir . "/" . str_replace('.', '_thumb.', stripslashes($array['Image'])));
if (!file_exists($this->thumb)) {
create_image_thumb($array['Image'], $CFG->IMAGE_THUMB_WIDTH, $imagedir);
}
} else {
if ($this->role->name == 'Map') {
$this->image = $HUB_FLM->getUploadsWebPath($CFG->DEFAULT_ISSUE_PHOTO);
$this->thumb = $HUB_FLM->getUploadsWebPath(str_replace('.', '_thumb.', stripslashes($CFG->DEFAULT_ISSUE_PHOTO)));
}
}
} else {
if ($this->role->name == 'Map') {
$this->image = $HUB_FLM->getUploadsWebPath($CFG->DEFAULT_ISSUE_PHOTO);
$this->thumb = $HUB_FLM->getUploadsWebPath(str_replace('.', '_thumb.', stripslashes($CFG->DEFAULT_ISSUE_PHOTO)));
}
}
//if(isset($array['Image'])){
// $this->imageurlid = $array['Image'];
//}
//if(isset($array['ImageThumbnail'])){
// $this->thum = $array['ImageThumbnail'];
//}
if ($style != 'mini') {
if (isset($array['StartDate']) && $array['StartDate'] != 0) {
$this->startdatetime = $array['StartDate'];
}
if (isset($array['EndDate']) && $array['EndDate'] != 0) {
$this->enddatetime = $array['EndDate'];
}
if (isset($array['LocationText'])) {
$this->location = $array['LocationText'];
} else {
$this->location = '';
}
if (isset($array['LocationCountry'])) {
$cs = getCountryList();
$this->countrycode = $array['LocationCountry'];
if (isset($cs[$array['LocationCountry']])) {
$this->country = $cs[$array['LocationCountry']];
}
}
if (isset($array['LocationLat'])) {
$this->locationlat = $array['LocationLat'];
}
if (isset($array['LocationLng'])) {
$this->locationlng = $array['LocationLng'];
}
if (isset($array['LocationAddress1'])) {
$this->locationaddress1 = $array['LocationAddress1'];
}
if (isset($array['LocationAddress2'])) {
$this->locationaddress2 = $array['LocationAddress2'];
}
if (isset($array['LocationPostCode'])) {
$this->locationpostcode = $array['LocationPostCode'];
}
if (isset($array['AdditionalIdentifier'])) {
$this->identifier = $array['AdditionalIdentifier'];
}
if (isset($array['CurrentStatus'])) {
$this->status = $array['CurrentStatus'];
}
}
}
}
}
} else {
return database_error();
}
$currentuser = '';
if (isset($USER->userid)) {
$currentuser = $USER->userid;
}
if ($style != 'mini' && $style != 'cif') {
$params = array();
$params[0] = $this->nodeid;
$params[1] = $this->nodeid;
$params[2] = $currentuser;
$resArray = $DB->select($HUB_SQL->DATAMODEL_NODE_EXTERNAL_CONNECTIONS, $params);
if ($resArray !== false) {
if (count($resArray) > 0) {
$this->otheruserconnections = $resArray[0]['connectedness'];
} else {
$this->otheruserconnections = 0;
}
}
$this->userfollow = "N";
//load the current user's following status for this node if any
$params = array();
$params[0] = $currentuser;
$params[1] = $this->nodeid;
$resArray = $DB->select($HUB_SQL->DATAMODEL_NODE_USER_FOLLOW, $params);
if ($resArray !== false) {
if (count($resArray) > 0) {
$this->userfollow = "Y";
}
}
}
if ($style == 'long' || $style == 'full' || $style == 'cif') {
$this->loadWebsites($style);
}
if ($style == 'long' || $style == 'full') {
$this->loadTags();
$this->loadGroups();
$this->loadVotes();
$this->loadProperties();
$this->loadViewCount();
}
if ($style == 'full' || $style == 'shortactivity') {
$this->activity = getAllNodeActivity($this->nodeid, 0, 0, -1);
$this->votes = getVotes($this->nodeid);
}
//load comments, pro count and con count if Solution.
/*if ($this->role->name == "Solution") {
$this->haschildren = 'N';
$conSetKids = getConnectionsByNode($this->nodeid,0,0,'date','ASC', 'all', '', 'Pro,Con,Comment');
if (!$conSetKids instanceof Error) {
if ($conSetKids->totalno > 0) {
$this->haschildren = 'Y';
}
} else {
return database_error();
}
}*/
return $this;
}