/**
* 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;
}
