private function SetItemPublicationDate(RssItem $rssItem)
{
if (isset($this->itemPublicationDateFieldName)) {
$fieldValue = $this->dataset->GetFieldValueByName($this->itemPublicationDateFieldName);
if (!(is_object($fieldValue) && get_class($fieldValue) == 'SMDateTime')) {
$fieldValue = SMDateTime::Parse($fieldValue, '%d-%m-%Y %H:%M:%S');
}
$rssItem->SetPublicationDate($fieldValue);
}
}
public function GetFieldValueAsSQL($fieldInfo, $value)
{
if ($fieldInfo->FieldType == ftNumber) {
$result = str_replace(',', '.', $value);
if (!is_numeric($result)) {
RaiseError('Field "' . $fieldInfo->Name . '" must be a number.');
}
return $this->EscapeString($result);
} elseif ($fieldInfo->FieldType == ftDateTime) {
if (!is_string($value) && get_class($value) == 'SMDateTime') {
return $this->GetDateTimeFieldValueAsSQL($fieldInfo, $value);
} else {
return $this->GetDateTimeFieldValueAsSQL($fieldInfo, SMDateTime::Parse($value, ''));
}
} elseif ($fieldInfo->FieldType == ftDate) {
if (!is_string($value) && get_class($value) == 'SMDateTime') {
return $this->GetDateFieldValueAsSQL($fieldInfo, $value);
} else {
return $this->GetDateFieldValueAsSQL($fieldInfo, SMDateTime::Parse($value, ''));
}
} elseif ($fieldInfo->FieldType == ftTime) {
if (!is_string($value) && get_class($value) == 'SMDateTime') {
return $this->GetTimeFieldValueAsSQL($fieldInfo, $value);
} else {
return $this->GetTimeFieldValueAsSQL($fieldInfo, SMDateTime::Parse($value, ''));
}
} elseif ($fieldInfo->FieldType == ftBlob) {
if (is_array($value)) {
return '\'' . mysql_escape_string(file_get_contents($value[0])) . '\'';
} else {
return '\'' . mysql_escape_string($value) . '\'';
}
} else {
return '\'' . $this->EscapeString($value) . '\'';
}
}
protected function DoGetValueForSql($value)
{
return SMDateTime::Parse($value, $this->dateTimeFormat);
}
public function getFilterValueForDataset()
{
return SMDateTime::Parse(parent::getFilterValueForDataset(), $this->format);
}
/**
* @param string $value
* @return mixed
*/
public function prepareValueForDataset($value)
{
return SMDateTime::Parse($value, $this->format);
}
public function ExtractsValueFromPost(&$valueChanged)
{
if (GetApplication()->IsPOSTValueSet($this->GetName())) {
$valueChanged = true;
$value = GetApplication()->GetPOSTValue($this->GetName());
if ($value == '') {
return null;
} else {
// return $value;
return SMDateTime::Parse($value, $this->format);
}
} else {
$valueChanged = false;
return null;
}
}
protected function GetTimeFieldValueByName(&$value)
{
if (isset($value)) {
return SMDateTime::Parse($value, '%H:%M:%S');
} else {
return null;
}
}
protected function GetDateTimeFieldValueByName(&$value)
{
if (isset($value)) {
if (is_object($value) && get_class($value) == 'variant' && version_compare(PHP_VERSION, '5.1', '<')) {
//$offset = (60 * 60 * 24) + strtotime('1970-01-02 00:00:00');
return new SMDateTime(variant_date_to_timestamp($value));
} else {
return SMDateTime::Parse(strval($value), '%Y-%m-%d %H:%M:%S');
}
} else {
return null;
}
}
public function SetValue($value)
{
if (!StringUtils::IsNullOrEmpty($value)) {
$this->value = SMDateTime::Parse($value, $this->showsTime ? 'Y-m-d H:i:s' : 'Y-m-d');
} else {
$this->value = null;
}
}
