protected function addFilteringDateRange($varname, $fieldname, $options = null)
{
$defaultDateTo = '';
$dateTo = $this->_getSessionParam($varname . "-to", "");
$dateFrom = $this->_getSessionParam($varname . "-from", "");
if (isset($options['default-date-to'])) {
if ($options['default-date-to'] == 'TODAY') {
$defaultDateTo = App_Env::getCurrentDate();
} else {
$defaultDateTo = $options['default-date-to'];
}
}
if (trim($dateTo) == '') {
$dateTo = $defaultDateTo;
}
if ($options['noCondition'] != true) {
if ($this->_isNotEmpty($dateTo)) {
$this->addCondition($fieldname, App_Formatter::toDBDateFormat($dateTo), "<=");
}
if ($this->_isNotEmpty($dateFrom)) {
$this->addCondition($fieldname, App_Formatter::toDBDateFormat($dateFrom), ">=");
}
}
if ($this->_isNotEmpty($dateTo) or $this->_isNotEmpty($dateFrom)) {
if ($this->_subTitleOfIndex == "(กรุณาเลือกช่วงวันที่ เพื่อแสดงรายการ)") {
$this->_subTitleOfIndex = '';
}
if ($this->_isNotEmpty($dateTo) and $this->_isNotEmpty($dateFrom)) {
$this->appendSubTitleOfIndex("ในช่วงวันที่ {$dateFrom} ถึง {$dateTo} ");
} elseif ($this->_isNotEmpty($dateTo)) {
$this->appendSubTitleOfIndex("จนถึงวันที่ {$dateTo} ");
} elseif ($this->_isNotEmpty($dateFrom)) {
$this->appendSubTitleOfIndex("ตั้งแต่วันที่ {$dateFrom} ");
}
}
//echo $this->view->filterTextbox($varname,$fieldname,$default,$options);
$this->_formfilters[] = $this->view->filterDateRange($varname, $fieldname, $dateTo, $dateFrom, $options);
$this->view->filteringSelect = $this->_formfilters;
}
