$v){ if($v != null) $where2[] = "$k = '$v'"; else $where2[] = "$k IS NULL"; } $where = implode(" AND " ,$where2); try{ $db = Zend_Db_Table::getDefaultAdapter(); $select = $this->getDbTable()->select() ->from($this->_dbTable) ->where($where); if(is_array($order)){ foreach ($order as $k => $v) $a[] = "$k $v"; $select->order($a); } $stmt = $select->query(); $result = $stmt->fetchAll(); if(!$array){ $entries = array(); foreach ($result as $row) { $entry = new Application_Model_Event($row); $entry->setID($row['eventID']); $entries[] = $entry; } return $entries; }else{ return $result; } }catch (Zend_Exception $e) { echo "Error message 2: " . $e->getMessage() . "\n"; } } public function setDbTable($dbTable) { if (is_string($dbTable)) { $dbTable = new $dbTable(); } if (!$dbTable instanceof Zend_Db_Table_Abstract) { throw new Exception('Invalid table data gateway provided'); } $this->_dbTable = $dbTable; return $this; } public function getDbTable() { if (null === $this->_dbTable) { $this->setDbTable('Application_Model_DbTable_Event'); } return $this->_dbTable; } public function save(Application_Model_Event $event) { $data = array('eventID'=> $event->getID() ,'category'=> $event->getCategory() ,'title'=> $event->getTitle(), 'pbs_membershipID'=> $event->getPbsMembershipID(),'end'=> $event->getEnd() ,'immediate'=> $event->getImmediate() ,'note'=> $event->getNote() ,'participants'=> $event->getParticipants() ,'pbs_bootosID'=> $event->getPbsBootosID(),'pbs_poolID'=> $event->getPbsPoolID(),'repeat'=> $event->getRepeat(),'start'=> $event->getStart() ); if (null === ($id = $event->getID()) ) { unset($data['eventID']); return $this->getDbTable()->insert($data); } else { $this->getDbTable()->update($data, array('eventID = ?' => $id)); } } public function delete(Application_Model_Event $event) { if (null === ($id = $event->getID()) ) { return; } else { $this->getDbTable()->delete(array('eventID = ?' => $id)); } } public function find($id, Application_Model_Event $event = null) { $result = $this->getDbTable()->find($id); if (0 == count($result)) { return; } $row = $result->current(); if($event == null){ $event = new Application_Model_Event(); $event->setID($row->eventID)->setCategory($row->category)->setTitle($row->title)->setPbsMembershipID($row->pbs_membership)->setEnd($row->end)->setImmediate($row->immediate)->setNote($row->note)->setParticipants($row->participants)->setPbsBootosID($row->pbs_bootosID)->setPbsPoolID($row->pbs_poolID)->setRepeat($row->repeat)->setStart($row->start); return $event; }else{ $event->setID($row->eventID)->setCategory($row->category)->setTitle($row->title)->setPbsMembershipID($row->pbs_membership)->setEnd($row->end)->setImmediate($row->immediate)->setNote($row->note)->setParticipants($row->participants)->setPbsBootosID($row->pbs_bootosID)->setPbsPoolID($row->pbs_poolID)->setRepeat($row->repeat)->setStart($row->start); } } public function fetchAll() { $resultSet = $this->getDbTable()->fetchAll(); $entries = array(); foreach ($resultSet as $row) { $entry = new Application_Model_Event(); $entrys->setID($row->eventID)->setCategory($row->category)->setTitle($row->title)->setPbsMembershipID($row->pbs_membership)->setEnd($row->end)->setImmediate($row->immediate)->setNote($row->note)->setParticipants($row->participants)->setPbsBootosID($row->pbs_bootosID)->setPbsPoolID($row->pbs_poolID)->setRepeat($row->repeat)->setStart($row->start); $entries[$row->eventID] = $entry; } return $entries; } public function compare(Application_Model_Event $v1,Application_Model_Event $v2){ $vv1 = $v1->toArray(); $vv2 = $v2->toArray(); return array_diff($vv1,$vv2); } }