/** * bind values to statement * * @param Db2PhpEntity $entity * @param PDOStatement $stmt */ public function bindValuesForFilter(Db2PhpEntity $entity, PDOStatement &$stmt) { if (0 == (self::IS_NULL & $this->mode) && array_key_exists($this->field, $entity->getFieldNames())) { $stmt->bindValue($this->getSqlParameterIdentifier($entity), $this->getSqlValue()); } }
/** * get sql ORDER BY part from DSCs * * @param Db2PhpEntity $entity entity instance * @param array $sort array of DSC instances * @return string */ public static function buildSqlOrderBy(Db2PhpEntity $entity, $sort) { if (null === $sort) { return ''; } if ($sort instanceof DSC) { $sort = array($sort); } $sql = null; $first = true; foreach ($sort as $s) { /* @var $s DSC */ if (!array_key_exists($s->getField(), $entity->getFieldNames())) { continue; } if ($first) { $sql .= ' ORDER BY '; $first = false; } else { $sql .= ','; } $sql .= $entity->getFieldNameByFieldId($s->getField()) . ' ' . $s->getModeSql(); } return $sql; }