Changeset 1734 for trunk/LATMOS-Accounts/lib/LATMOS/Accounts/Bases
- Timestamp:
- 03/21/16 14:51:28 (8 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/LATMOS-Accounts/lib/LATMOS/Accounts/Bases/Sql/User.pm
r1709 r1734 1476 1476 1477 1477 my $list_empl = $self->base->db->prepare_cached(q{ 1478 SELECT *, (lastday is null or lastday >= now() ) as "current" FROM employment1478 SELECT *, (lastday is null or lastday >= now() - '1days'::interval) as "current" FROM employment 1479 1479 WHERE "user" = ? and firstday < now() 1480 1480 order by firstday desc
Note: See TracChangeset
for help on using the changeset viewer.