public static function findItems($id)
{
$items = new Item();
$subquery = $items->_db->select();
$subquery->from('line_items', 'item_id');
$subquery->where('user_id = ?', $id);
return $items->fetchAll('id IN (' . $subquery . ')');
}
public static function rebuild()
{
$index = self::create();
$itemTable = new Item();
$items = $itemTable->fetchAll();
foreach ($items as $item) {
$tags = '';
foreach ($itemTable->findTags($item->id) as $tag) {
$tags .= $tag->name . ' ';
}
self::_insert($index, $item, $tags);
}
}
public function indexAction()
{
$item = new Item();
$items = $item->fetchAll()->toArray();
$this->view->items = $items;
}
