Changeset 114

Timestamp:

05/16/09 16:25:26 (15 years ago)

Author:

nanardon

Message:

• Manage account expire date/time

Location:

LATMOS-Accounts/lib/LATMOS/Accounts/Bases

Files:

• Ad/User.pm (modified) (1 diff)
• Sql/User.pm (modified) (3 diffs)

LATMOS-Accounts/lib/LATMOS/Accounts/Bases/Ad/User.pm

@@ -61 +61 @@
         title modbile homePhone
         memberOf
+        accountExpires
         ),
         ($mode !~ /w/

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

@@ -61 +61 @@
         uidNumber       => 'uid',
         gidNumber       => 'gid',
+        Expire          => 'expire',
         (($for !~ /w/)
         ? (
@@ -66 +67 @@
             sAMAccountName  => 'sAMAccountName',
             uid          => 'login',
+            accountExpires => 'accountExpires',
+            shadowExpire => 'shadowExpire',
         )
         : ()),
@@ -93 +96 @@
         }
         return \@res;
+    } elsif ($field eq 'accountExpires') {
+        my $sth = $self->db->prepare_cached(
+            sprintf(
+                q{select extract(epoch from expire) + 11644474161 as expire
+                from %s where %s = ?},
+                $self->db->quote_identifier($self->object_table),
+                $self->db->quote_identifier($self->key_field),
+            )
+        );
+        $sth->execute($self->id);
+        my $res = $sth->fetchrow_hashref;
+        $sth->finish;
+        return $res->{expire} ? sprintf("%.f", $res->{expire} * 1E7) : '9223372036854775807';
+    } elsif ($field eq 'shadowExpire') {
+        my $sth = $self->db->prepare_cached(
+            sprintf(
+                q{select justify_hours(expire - '1/1/1970'::timestamp) as expire
+                from %s where %s = ?},
+                $self->db->quote_identifier($self->object_table),
+                $self->db->quote_identifier($self->key_field),
+            )
+        );
+        $sth->execute($self->id);
+        my $res = $sth->fetchrow_hashref;
+        $sth->finish;
+        return -1 unless($res->{expire});
+        $res->{expire} =~ /(\d+) days\s*(\w)?/;
+        return $1 + ($2 ? 1 : 0);
     } else {
         return $self->SUPER::get_field($field);