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(); }