Index.php

<?php
class Dsao_Model_News_Index extends Dsao_Model_Abstract
{
  protected function _init()
  {
    $this->_setDefaultTable('news');
  }

  public function getModuleNavigation()
  {
    $role = Zend_Registry::get('user')->role;
    if ($role == 'admin')
    {
      return array
        (
          'news_overview'     => '/news/index',
          'news_create'       => '/news/admin/create'
      );
    }
    else
    {
      return array
        (
          'news_overview'     => '/news/index'
      );
    }
  }

  public function loadNews($id)
  {
    // Neuigkeiten laden
    if (isset($id))
    {
      $sqlWhere = array('id = ?' => $id);
      $rows = $this->_getTable()->fetchAll($sqlWhere, 'timeCreated DESC');
    }
    else
    {
      $rows = $this->_getTable()->fetchAll('id', 'timeCreated DESC');
    }
    return $rows->toArray();
  }

  public function createNews($data)
  {
    // Zufuegen des aktuellen Timestamps
    $data['timeCreated'] = new Zend_Db_Expr('NOW()');

    // Einspielen der Daten
    return $this->_getTable()->insert($data);
  }

  public function updateNews($data)
  {
    // Wherebedingung
    $sqlWhere = $this->_getTable()->getAdapter()->quoteInto('id = ?', $data['id']);

    // Updaten der Daten
    return $this->_getTable()->update($data, $sqlWhere);
  }

  public function deleteNews($id)
  {
    $sqlWhere = $this->_getTable()->getAdapter()->quoteInto('id = ?', $id);
    return $this->_getTable()->delete($sqlWhere);
  }
}