| @@ 172-184 (lines=13) @@ | ||
| 169 | ); |
|
| 170 | } else { |
|
| 171 | // Review date before |
|
| 172 | if (!empty($params['ReviewDateBefore'])) { |
|
| 173 | // TODO Get value from DateField->dataValue() once we have access to form elements here |
|
| 174 | $nextReviewUnixSec = strtotime( |
|
| 175 | ' + 1 day', |
|
| 176 | strtotime($params['ReviewDateBefore']) |
|
| 177 | ); |
|
| 178 | $records = $records->where( |
|
| 179 | sprintf( |
|
| 180 | "\"NextReviewDate\" < '%s'", |
|
| 181 | DBDatetime::create()->setValue($nextReviewUnixSec)->Format('y-MM-dd') |
|
| 182 | ) |
|
| 183 | ); |
|
| 184 | } |
|
| 185 | ||
| 186 | // Review date after |
|
| 187 | if (!empty($params['ReviewDateAfter'])) { |
|
| @@ 187-195 (lines=9) @@ | ||
| 184 | } |
|
| 185 | ||
| 186 | // Review date after |
|
| 187 | if (!empty($params['ReviewDateAfter'])) { |
|
| 188 | // TODO Get value from DateField->dataValue() once we have access to form elements here |
|
| 189 | $records = $records->where( |
|
| 190 | sprintf( |
|
| 191 | "\"NextReviewDate\" >= '%s'", |
|
| 192 | DBDatetime::create()->setValue(strtotime($params['ReviewDateAfter']))->Format('y-MM-dd') |
|
| 193 | ) |
|
| 194 | ); |
|
| 195 | } |
|
| 196 | } |
|
| 197 | ||
| 198 | // Show virtual pages? |
|