public static function findByNameAndPageId($name, $id, $class = __CLASS__)
{
$params['where'] = sprintf("name='%s' AND page_id=%d", $name, $id);
$sql = Record::buildSql($params, $class);
return self::connection()->query($sql, PDO::FETCH_CLASS, $class)->fetch();
}
public static function find($params = null, $class = __CLASS__)
{
$retval = array();
$sql = Record::buildSql($params, $class);
foreach (self::connection()->query($sql, PDO::FETCH_CLASS, $class) as $object) {
$retval[] = $object;
}
return $retval;
}
public static function findBySlugAndParentId($slug, $parent_id = 0, $class = __CLASS__)
{
/* TODO: Behaviour pagehack seems kludgish. */
$parent = Page::findById($parent_id);
if ($parent && $parent->behaviorId()) {
$class = Behavior::loadPageHack($parent->behaviorId());
}
$params['where'] = sprintf("slug=%s AND parent_id=%d", self::connection()->quote($slug), $parent_id);
$sql = Record::buildSql($params, $class);
// print_r(self::connection()->query($sql, PDO::FETCH_CLASS, $class)->fetch());
return self::connection()->query($sql, PDO::FETCH_CLASS, $class)->fetch();
}
