<?php

class MOgloszenia extends Zend_Db_Table_Abstract
{
    protected $_name = 'ogloszenia';

    public function pobierzOgloszenia($id_kategorii)
    {
        $select = $this->select();
        $select->from($this->_name)
                ->where('id_kategorii = ?', $id_kategorii);

        $query = $this->getAdapter()->query($select);
        $query->setFetchMode(Zend_Db::FETCH_OBJ);

        return $query->fetchAll();
    }

    public function pobierzOgloszenie($id_ogloszenia)
    {
        return $ogloszenie = $this->find($id_ogloszenia)->current();
    }

    public function pobierzPromowaneOgloszenia()
    {
        $select = $this->select();
        $select->from(array('o' => 'ogloszenia'),
                    array('id_ogloszenia', 'tytul', 'data_dodania'))
                ->join(array('u' => 'uzytkownicy'),
                        'o.id_uzytkownika = u.id_uzytkownika',
                        array())
                ->where('u.id_typ_konta = ?', 3)
                ->order('data_dodania DESC');

        $query = $this->getAdapter()->query($select);
        $query->setFetchMode(Zend_Db::FETCH_OBJ);

        return $query->fetchAll();
    }
}


?>