public function getAvailableChildren($fieldname)
{
if ($fieldname == "pageCollections") {
$query = "select id, name from pageCollection where tenantid=" . $this->tenantid;
$results = Database::executeQuery($query);
if ($results->num_rows == 0) {
return array();
} else {
$entities = array();
while ($r = mysqli_fetch_assoc($results)) {
$entities[] = $r;
}
return $entities;
}
return $results->fetch;
} else {
return parent::getAvailableChildren($fieldname);
}
}
public function getAvailableChildren($fieldname)
{
if ($fieldname == 'categories') {
$query = 'call getCategoriesByType(\'location\',' . $this->tenantid . ');';
$data = Database::executeQuery($query);
if ($data->num_rows == 0) {
return array();
} else {
while ($r = mysqli_fetch_assoc($data)) {
$entities[] = $r;
}
return $entities;
}
} else {
return parent::getAvailableChildren($fieldname);
}
return array();
}
