/**
* test set categories
*/
public function testSetCategories()
{
$newdata = array(array('id' => 1, 'name' => 'cat 1', 'position' => 1), array('id' => 2, 'name' => 'category 2', 'position' => 0), array('id' => 0, 'name' => 'new cat', 'position' => 3));
// set new without delete an filled category
$this->model->setCategories($newdata);
$this->assertEquals($newdata[0], $this->model->find(1)->current()->toArray());
// update
$this->assertEquals($newdata[1], $this->model->find(2)->current()->toArray());
// update
$this->assertEquals(1, $this->model->fetchAll($this->model->select()->where('name=?', 'new cat'))->count());
$this->assertEquals(3, $this->model->fetchAll()->count());
// old deleted
// set with delete filled category
$newdata = array(array('id' => 0, 'name' => 'newcat', 'position' => 1));
$this->model->setCategories($newdata);
$this->assertEquals(1, $this->model->fetchAll()->count());
$this->assertEquals(0, $this->model->feeds(1));
// no more feeds in cat 1
$this->assertEquals(2, $this->model->feeds(-1));
// now all feeds in cat -1 (uncategorized)
}
/**
* checks whether a category exists or not
*
* @return boolean
* @param int $value the current category id
*/
public function isValid($value)
{
// uncategorized
if ($value == 0) {
return true;
}
$categories = new application_models_categories();
if ($categories->fetchAll($categories->select()->where("id=?", $value))->count() == 0) {
$this->_error(application_validate_categoryid::NOT_EXISTS);
return false;
}
return true;
}
/**
* set feedlist data for the current view
*
* @return void
*/
protected function feedlistData()
{
// check whether uncategorized exists or not (add it if not)
$categoriesModel = new application_models_categories();
$categoriesModel->checkUncategorized();
// categories and feeds (target template param)
$this->view->categories = array();
// load unread items
$itemCounter = Zend_Controller_Action_HelperBroker::getStaticHelper('itemcounter');
$unreadCategory = $itemCounter->unreadItemsCategories();
$unreadFeed = $itemCounter->unreadItemsFeeds();
// get open categories
if (Zend_Registry::get('session')->saveOpenCategories == 1) {
$open = explode(',', Zend_Registry::get('session')->openCategories);
} else {
$open = array();
}
// load categories
$categoriesDb = $categoriesModel->fetchAll($categoriesModel->select()->order('position ASC'));
$feedPositions = Zend_Controller_Action_HelperBroker::getStaticHelper('icon')->getFeedsIconPosition();
// read feeds and count items of the loaded categories
$feedsModel = new application_models_feeds();
foreach ($categoriesDb as $cat) {
$newcat = $cat->toArray();
// get feeds of cat
$feedRowset = $cat->findDependentRowset('application_models_feeds', null, $feedsModel->select()->order('position ASC'));
$newcat['feeds'] = array();
foreach ($feedRowset as $feed) {
$newfeed = $feed->toArray();
$newfeed['unread'] = isset($unreadFeed[$feed->id]) ? $unreadFeed[$feed->id] : 0;
$newfeed['iconposition'] = $feedPositions[$feed->id];
$newcat['feeds'][] = $newfeed;
}
// get unread items of cat
$newcat['unread'] = isset($unreadCategory[$cat->id]) ? $unreadCategory[$cat->id] : 0;
// set open (feeds visible) or not
if (in_array($cat->id, $open)) {
$newcat['open'] = true;
} else {
$newcat['open'] = false;
}
// append category
$this->view->categories[] = $newcat;
}
// count starred items
$this->view->starred = $itemCounter->starredItems();
// count unread items
$this->view->unread = $unreadCategory[0];
// count all items
$this->view->all = $itemCounter->allItems();
// count read items
$this->view->read = $this->view->all - $this->view->unread;
// count feeds
$this->view->amountfeeds = $feedsModel->count(Zend_Registry::get('session')->currentPriorityStart, Zend_Registry::get('session')->currentPriorityEnd, Zend_Registry::get('session')->view);
}
/**
* Show edit dialog
*
* @return void
*/
public function indexAction()
{
// load categories
$categories = new application_models_categories();
$this->view->categories = $categories->fetchAll($categories->select()->order('position ASC'));
}
/**
* check whether a category exists and returns the id
* else insert new category
*
* @return int category id
* @param string $category the category name
*/
protected function insertCategory($category)
{
// no category handling for uncategorized
if ($category == -1) {
return -1;
}
// search existing category
$categoriesModel = new application_models_categories();
$categories = $categoriesModel->fetchAll($categoriesModel->select()->where($categoriesModel->getAdapter()->quoteInto('name=?', trim($category))));
// use existing category
if ($categories->count() > 0) {
return $categories->current()->id;
} else {
return $categoriesModel->insert(array('name' => trim($category), 'position' => $categoriesModel->maxPosition() + 1));
}
}
/**
* set view template params for showing all available sources
* in add/edit dialog. prepares categories
*
* @return void
*/
protected function prepare()
{
// load available plugins
$plugins = Zend_Controller_Action_HelperBroker::getStaticHelper('pluginloader')->getPlugins();
// order plugins by category
$cat = array();
foreach ($plugins as $plugin => $obj) {
$cat[$obj->category][$plugin] = $obj;
}
ksort($cat);
$this->view->sources = $cat;
// load categories
$categories = new application_models_categories();
$cats = $categories->fetchAll($categories->select()->order('position ASC'));
$this->view->categories = array();
foreach ($cats as $cat) {
$this->view->categories[$cat->id] = $cat->name;
}
}
