public function GetFieldValueAsSQL($fieldInfo, $value)
{
if ($fieldInfo->FieldType == ftBlob) {
if (is_array($value)) {
return '\'' . pg_escape_bytea(file_get_contents($value[0])) . '\'';
} else {
return '\'' . pg_escape_bytea($value) . '\'';
}
} else {
return parent::GetFieldValueAsSQL($fieldInfo, $value);
}
}
private function GetFieldValueAsSQL($fieldName, $value)
{
$fieldType = $this->fields[$fieldName];
return $this->commandImp->GetFieldValueAsSQL(new FieldInfo('', $fieldName, $fieldType, ''), $value);
}
/**
* @param BetweenFieldFilter $filter
* @return void
*/
public function VisitBetweenFieldFilter($filter)
{
$this->resultCondition = sprintf('(%s BETWEEN %s AND %s)', $this->engCommandImp->GetFieldFullName($this->field), $this->engCommandImp->GetFieldValueAsSQL($this->field, $filter->GetStartValue()), $this->engCommandImp->GetFieldValueAsSQL($this->field, $filter->GetEndValue()));
}
public function GetFieldValueAsSQL($fieldInfo, $value)
{
if ($fieldInfo->FieldType == ftBoolean) {
if (!is_numeric($value) || !($value == 0 || $value == 1)) {
RaiseError("The only valid values for the column {$fieldInfo->Name} are 0 and 1.");
}
return $this->EscapeString($value);
} else {
return parent::GetFieldValueAsSQL($fieldInfo, $value);
}
}
public function GetFieldValueAsSQL($fieldInfo, $value)
{
if ($fieldInfo->FieldType == ftString) {
return "N" . parent::GetFieldValueAsSQL($fieldInfo, $value);
} else {
return parent::GetFieldValueAsSQL($fieldInfo, $value);
}
}
