/**
* Gets an array of all the TenantObjectInstancePropertyValues associated with this TenantObjectInstance.
* @return TenantObjectInstancePropertyValue[] all the property values associated with this instance
* @see TenantObjectInstancePropertyValue
*/
public function GetPropertyValues()
{
global $MySQL;
$query = "SELECT * FROM " . System::$Configuration["Database.TablePrefix"] . "TenantObjectInstancePropertyValues WHERE propval_InstanceID = " . $this->ID;
$result = $MySQL->query($query);
$retval = array();
if ($result === false) {
return $retval;
}
$count = $result->num_rows;
for ($i = 0; $i < $count; $i++) {
$values = $result->fetch_assoc();
$property = TenantObjectProperty::GetByID($values["propval_PropertyID"]);
$value = $property->Decode($values["propval_Value"]);
$retval[] = new TenantObjectInstancePropertyValue($property, $value);
}
return $retval;
}
public function GetProperties($max = null)
{
global $MySQL;
$query = "SELECT * FROM " . System::$Configuration["Database.TablePrefix"] . "TenantObjectProperties WHERE property_ObjectID = " . $this->ID;
if (is_numeric($max)) {
$query .= " LIMIT " . $max;
}
$result = $MySQL->query($query);
$retval = array();
if ($result === false) {
return $retval;
}
$count = $result->num_rows;
for ($i = 0; $i < $count; $i++) {
$values = $result->fetch_assoc();
$retval[] = TenantObjectProperty::GetByAssoc($values);
}
return $retval;
}
/**
* Retrieves a single TenantObjectProperty with the given ID.
* @param int $id The ID of the TenantObjectProperty to return
* @return NULL|\PhoenixSNS\Objects\TenantObjectProperty The TenantObjectProperty with the given ID, or NULL if no TenantObjectProperty with the given ID was found
*/
public static function GetByID($id)
{
if (!is_numeric($id)) {
return null;
}
global $MySQL;
$query = "SELECT * FROM " . System::$Configuration["Database.TablePrefix"] . "TenantObjectProperties";
$result = $MySQL->query($query);
$count = $result->num_rows;
if ($count == 0) {
return null;
}
$values = $result->fetch_assoc();
return TenantObjectProperty::GetByAssoc($values);
}