/** * @param ilCombinationInputGUI $filter * @param $name * @param $value */ protected function addFilterDateTimeWhere(ilCombinationInputGUI $filter, $name, $value) { if ($value["from"] != NULL or $value["to"] != NULL) { if ($value["from"] == NULL) { $value["from"] = new ilDateTime("0001-01-01", IL_CAL_DATE); } if ($value["to"] == NULL) { $value["to"] = new ilDateTime("9999-01-01", IL_CAL_DATE); } $this->active_record_list->where($this->active_record_list->getAR()->getConnectorContainerName() . "." . $name . " BETWEEN '" . $value["from"]->get(IL_CAL_DATETIME) . "' AND '" . $value["to"]->get(IL_CAL_DATETIME) . "'"); } }
/** * @param $where * @param null $operator * * @return ActiveRecordList */ public static function where($where, $operator = NULL) { $srModelObjectList = new ActiveRecordList(self::getCalledClass()); $srModelObjectList->where($where, $operator); return $srModelObjectList; }