/** * findByCriteria * * @since 30 okt 2007 * @param KVDdb_Criteria $criteria * @return void */ public function findByCriteria(KVDdb_Criteria $criteria) { $sql = $this->getSelectStatement() . ' ' . $criteria->generateSql(KVDdb_Criteria::MODE_PARAMETERIZED); $stmt = $this->_conn->prepare($sql); $values = $criteria->getValues(); for ($i = 0; $i < count($values); $i++) { $stmt->bindValue($i + 1, $values[$i]); } return $this->executeFindMany($stmt); }
/** * findByCriteria * * @param KVDdb_Criteria $c * @return KVDdom_DomainObjectCollection */ public function findByCriteria(KVDdb_Criteria $c) { if ($c->count() == 0) { return $this->findAll(); } // criterion toevoegen dat enkel termen uit deze thesaurus toont. $c->add(KVDdb_Criterion::equals('thesaurus_id', $this->parameters['thesaurus_id'])); $c->addAscendingOrder('term'); $c->addAscendingOrder('qualifier'); $sql = sprintf('SELECT t.id, term, tt.id AS type_id, tt.name AS type_naam, qualifier, language, sort_key FROM %s.term t LEFT JOIN %s.term_type_code tt ON ( t.type = tt.id )', $this->parameters['schema'], $this->parameters['schema']); $sql .= $c->generateSql(KVDdb_Criteria::MODE_PARAMETERIZED); $stmt = $this->conn->prepare($sql); $values = $c->getValues(); for ($i = 0; $i < count($values); $i++) { $stmt->bindValue($i + 1, $values[$i]); } $stmt->execute(); $termen = array(); while ($row = $stmt->fetch(PDO::FETCH_OBJ)) { $termen[$row->id] = $this->doLoad($row->id, $row); } return new KVDdom_DomainObjectCollection($termen); }
/** * getValues * * @since 1.4 * @return array */ public function getValues() { return $this->criteria->getValues(); }