public static function getByName($db, $r, $name)
{
$set = new Dase_DBO_Itemset($db);
$set->name = $name;
$set->findOne();
return $set->asArray($r);
}
public function getSets()
{
$isis = new Dase_DBO_ItemsetItem($this->db);
$isis->item_id = $this->id;
foreach ($isis->findAll(1) as $isi) {
$set = new Dase_DBO_Itemset($this->db);
$set->load($isi->itemset_id);
$this->sets[] = $set;
}
return $this->sets;
}
public function postToSet($r)
{
$set = new Dase_DBO_Itemset($this->db);
if (!$set->load($r->get('set_id'))) {
$r->renderError(404);
}
foreach ($r->get('item', true) as $item_id) {
$isi = new Dase_DBO_ItemsetItem($this->db);
$isi->item_id = $item_id;
$isi->itemset_id = $set->id;
$isi->created = date(DATE_ATOM);
$isi->insert();
}
$r->renderRedirect('set/' . $set->name);
}
public function getItems($r)
{
$t = new Dase_Template($r);
$items = new Dase_DBO_Item($this->db);
$items->orderBy('updated DESC');
$items = $items->findAll(1);
$result = array();
if ($r->get('filter')) {
$filter = $r->get('filter');
$t->assign('filter', $filter);
$parts = explode(':', $filter);
//grab slice w/ format like 4:22
if (2 == count($parts) && is_int((int) $parts[0]) && is_int((int) $parts[1])) {
$result = array_slice($items, $parts[0] - 1, $parts[1] - $parts[0] + 1);
$t->assign('filter', '');
} else {
foreach ($items as $item) {
if (false !== strpos($item->name, $filter) || false !== strpos($item->title, $filter) || false !== strpos($item->body, $filter) || false !== strpos($item->meta1, $filter) || false !== strpos($item->meta1, $filter) || false !== strpos($item->meta3, $filter)) {
$result[] = $item;
}
}
}
} else {
$result = $items;
}
$sets = Dase_DBO_Itemset::getList($this->db);
$t->assign('sets', $sets);
$t->assign('items', $result);
$r->renderResponse($t->fetch('items.tpl'));
}
public function getItem($r)
{
$t = new Dase_Template($r);
//if no format, assume name is ID
$item = new Dase_DBO_Item($this->db);
if ($item->load($r->get('name'))) {
$item->getSets();
$t->assign('item', $item);
$sets = Dase_DBO_Itemset::getList($this->db);
$t->assign('sets', $sets);
$r->renderResponse($t->fetch('framework/item.tpl'));
} else {
$r->renderRedirect('items');
//$r->renderError(404);
}
}
private function _findUniqueName($name, $iter = 0)
{
if ($iter) {
$checkname = $name . '_' . $iter;
} else {
$checkname = $name;
}
$set = new Dase_DBO_Itemset($this->db);
$set->name = $checkname;
if (!$set->findOne()) {
return $checkname;
} else {
$iter++;
return $this->_findUniqueName($name, $iter);
}
}
