Changeset 2339

Timestamp:

02/07/20 07:27:15 (4 years ago)

Author:

nanardon

Message:

Fix currentEmployment computation

File:

• trunk/LATMOS-Accounts/lib/LATMOS/Accounts/Bases/Sql/User.pm (modified) (2 diffs)

trunk/LATMOS-Accounts/lib/LATMOS/Accounts/Bases/Sql/User.pm

@@ -1496 +1496 @@
                     my $sth = $self->base->db->prepare_cached(
                         q{
-                        select name from employment where (lastday > ?::timestamp or lastday IS NULL) and "user" = ?
+                        select name from employment where (lastday >= ?::timestamp - '1 days'::interval or lastday IS NULL) and "user" = ?
                         order by firstday asc
                         limit 1
@@ -1523 +1523 @@
                         q{
                         select name from employment where
-                        (lastday is not null and lastday <= ?::timestamp - '1 days'::interval) and "user" = ?
+                        (lastday is not null and lastday < ?::timestamp - '1 days'::interval) and "user" = ?
                         order by firstday desc
                         limit 1