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