Changeset 1763 for trunk/LATMOS-Accounts/lib/LATMOS/Accounts

Timestamp:

05/06/16 20:53:39 (8 years ago)

Author:

nanardon

Message:

Don't manage entrance anymore in expiration warning

File:

• trunk/LATMOS-Accounts/lib/LATMOS/Accounts/Maintenance.pm (modified) (1 diff)

trunk/LATMOS-Accounts/lib/LATMOS/Accounts/Maintenance.pm

@@ -42 +42 @@
     my $sth= $base->db->prepare(q{
         select name,
-            coalesce(endcircuit, expire) as appliedexpire,
+            expire as appliedexpire,
             endcircuit,
             expire
             from "user"
             where
-            coalesce(endcircuit, expire) < now() + ?::interval
-            and coalesce(endcircuit, expire) > now()
-            and coalesce(endcircuit, expire) is not null
+            expire < now() + ?::interval
+            and expire > now()
+            and expire is not null
             and exported = True
             order by expire