Changeset 465

Timestamp:

10/03/09 03:26:10 (15 years ago)

Author:

nanardon

Message:

• revert previous commit

Files:

• LATMOS-Accounts-Web/lib/LATMOS/Accounts/Web/Model/AttrForms.pm (modified) (1 diff)
• LATMOS-Accounts/lib/LATMOS/Accounts/Bases/Sql/User.pm (modified) (2 diffs)

LATMOS-Accounts-Web/lib/LATMOS/Accounts/Web/Model/AttrForms.pm

@@ -32 +32 @@
     postalCode => [ 'Code postal' ],
     postOfficeBox => [ 'BP' ],
-    department => [ 'Département', 'select-N:group' ],
+    department => [ 'Département' ],
     streetAddress => [ 'Rue', 'textarea' ],
     title => [ 'Fonction' ],

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

@@ -78 +78 @@
         directReports => 'directReports',
         managedObjects => 'managedObjects',
+        department => 'department',
         otheraddress => 'otheraddress',
         mainaddress => 'mainaddress',
@@ -136 +137 @@
         }
         return \@res;
+    } elsif ($field eq 'department') {
+        my $sth = $self->db->prepare_cached(
+            q{
+            select name from "group" join
+            group_attributes on "group".ikey = group_attributes.okey
+            where okey in (select okey from group_attributes_users where value = ?)
+            and attr = ? and value = ?
+            }
+        );
+        $sth->execute($self->id, 'sutype', 'dpmt');
+        my @res;
+        while (my $res = $sth->fetchrow_hashref) {
+            push(@res, $res->{name});
+        }
+        return join(',', @res);
     } elsif ($field eq 'managedObjects') {
         my $sth = $self->db->prepare_cached(