|
Lines 197-209
sub GetNewsToDisplay {
Link Here
|
| 197 |
OR expirationdate IS NULL |
197 |
OR expirationdate IS NULL |
| 198 |
OR expirationdate = '00-00-0000' |
198 |
OR expirationdate = '00-00-0000' |
| 199 |
) |
199 |
) |
| 200 |
AND `timestamp` < CURRENT_DATE()+1 |
200 |
AND CAST( `timestamp` AS DATE ) <= CURRENT_DATE() |
| 201 |
AND (lang = '' OR lang = ?) |
201 |
AND (lang = '' OR lang = ?) |
| 202 |
AND (branchcode IS NULL OR branchcode = ?) |
202 |
AND (branchcode IS NULL OR branchcode = ?) |
| 203 |
ORDER BY number |
203 |
ORDER BY number |
| 204 |
}; # expirationdate field is NOT in ISO format? |
204 |
}; # expirationdate field is NOT in ISO format? |
| 205 |
# timestamp has HH:mm:ss, CURRENT_DATE generates 00:00:00 |
205 |
# casting timestamp to date truncates HH:mm:ss |
| 206 |
# by adding 1, that captures today correctly. |
206 |
# changing to <= CURRENT_DATE() today is captured. |
| 207 |
my $sth = $dbh->prepare($query); |
207 |
my $sth = $dbh->prepare($query); |
| 208 |
$lang = $lang // q{}; |
208 |
$lang = $lang // q{}; |
| 209 |
$sth->execute($lang,$branch); |
209 |
$sth->execute($lang,$branch); |
| 210 |
- |
|
|