public function getSelect()
 {
     $ret = parent::getSelect();
     if (!$ret) {
         return null;
     }
     $ret->where('IF(ISNULL(end_date), start_date, end_date) < NOW()');
     return $ret;
 }