public static function getListByPackage($pkg) { $db = Loader::db(); $list = array(); $r = $db->Execute('select treeTypeID from TreeTypes where pkgID = ? order by treeTypeID asc', array($pkg->getPackageID())); while ($row = $r->FetchRow()) { $list[] = TreeType::getByID($row['treeTypeID']); } $r->Close(); return $list; }
public static final function getByID($treeID) { $app = Application::getFacadeApplication(); $db = $app->make('database')->connection(); $row = $db->fetchAssoc('select * from Trees where treeID = ?', [$treeID]); if ($row) { $tt = TreeType::getByID($row['treeTypeID']); $class = $tt->getTreeTypeClass(); $tree = $app->make($class); $tree->setPropertiesFromArray($row); $tree->loadDetails(); return $tree; } }
public static final function getByID($treeID) { $db = Database::connection(); $row = $db->GetRow('select * from Trees where treeID = ?', array($treeID)); if (!empty($row)) { $tt = TreeType::getByID($row['treeTypeID']); $class = $tt->getTreeTypeClass(); $tree = Core::make($class); $tree->setPropertiesFromArray($row); $tree->loadDetails(); return $tree; } }