Changeset 910

Timestamp:

02/24/12 12:51:04 (12 years ago)

Author:

nanardon

Message:

• otheraddress return main address first
• set lenght of uidnumber

File:

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

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

@@ -50 +50 @@
     $class->SUPER::_get_attr_schema($base,
         {
-            uidNumber => { inline => 1, iname => 'uidnumber', uniq => 1,
-                mandatory => 1, },
+            uidNumber => {
+                inline => 1,
+                iname => 'uidnumber',
+                uniq => 1,
+                mandatory => 1,
+                formopts => { length => 7 },
+            },
             uidnumber => { inline => 1, hide => 1, },
             gidNumber => { 
@@ -308 +313 @@
     } elsif ($field eq 'otheraddress') {
         my $sth = $self->db->prepare_cached(q{
-            select name from address where "user" = ?
+            select name from address left join address_attributes
+            on address.ikey = address_attributes.okey and
+            address_attributes.attr = 'isMainAddress'
+            where "user" = ?
+            order by address_attributes.attr
         });
         $sth->execute($self->id);