$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); } # print_a($select); $stmt = $select->query(); # print_a($stmt); $result = $stmt->fetchAll(); if(!$array){ $entries = array(); foreach ($result as $row) { $entry = new Application_Model_Person($row); $entry->setID($row['personID']); $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_Person'); } return $this->_dbTable; } public function save(Application_Model_Person $person) { $data = array('personID'=> $person->getID() , 'title'=> $person->getTitle() , 'name'=> $person->getName() , 'firstname'=> $person->getFirstname() , 'street'=> $person->getStreet() , 'housenumber'=> $person->getHousenumber() , 'city'=> $person->getCity() , 'postalcode'=> $person->getPostalcode() , 'logindate'=> $person->getLogindate() , 'registerdate'=> $person->getRegisterdate() , 'email'=> $person->getEmail() , 'login'=> $person->getLogin() , 'password'=> $person->getPassword(), 'loginpassword'=> $person->getLoginpassword() , 'password_salt'=> $person->getPasswordSalt() , 'suspend'=> $person->getSuspend() ); if (null === ($id = $person->getID()) ) { unset($data['personID']); $this->getDbTable()->insert($data); } else { $this->getDbTable()->update($data, array('personID = ?' => $id)); } } public function delete(Application_Model_Person $person) { if (null === ($id = $person->getID()) ) { return; } else { $this->getDbTable()->delete(array('personID = ?' => $id)); } } public function find($id,Application_Model_Person $person = null) { $return = false; if($person == null){ $return = true; } if($return){ $person = new Application_Model_Person(); } $result = $this->getDbTable()->find($id); if (0 == count($result)) { return; } $row = $result->current(); $person->setID($row->personID) ->setTitle($row->title) ->setName($row->name) ->setFirstname($row->firstname) ->setStreet($row->street) ->setHousenumber($row->housenumber) ->setCity($row->city) ->setPostalcode($row->postalcode) ->setLogindate($row->logindate) ->setRegisterdate($row->registerdate) ->setEmail($row->email) ->setLogin($row->login) ->setPassword($row->password) ->setPasswordSalt($row->password_salt) ->setLoginpassword($row->loginpassword) ->setSuspend($row->suspend); if($return){ return $person; } } public function fetchAll() { $resultSet = $this->getDbTable()->fetchAll(); $entries = array(); foreach ($resultSet as $row) { $entry = new Application_Model_Person(); $entry->setID($row->personID) ->setTitle($row->title) ->setName($row->name) ->setFirstname($row->firstname) ->setStreet($row->street) ->setHousenumber($row->housenumber) ->setCity($row->city) ->setPostalcode($row->postalcode) ->setLogindate($row->logindate) ->setRegisterdate($row->registerdate) ->setEmail($row->email) ->setLogin($row->login) ->setPassword($row->password) ->setPasswordSalt($row->password_salt) ->setSuspend($row->suspend) ->setLoginpassword($row->loginpassword); $entries[] = $entry; } return $entries; } public function compare(Application_Model_Person $v1,Application_Model_Person $v2){ $vv1 = $v1->toArray(); $vv2 = $v2->toArray(); return array_diff($vv1,$vv2); } }