Changeset 1856 for trunk

Timestamp:

11/21/16 17:51:39 (8 years ago)

Author:

nanardon

Message:

Add employmentHistory attribute

File:

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

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

@@ -1324 +1324 @@
                 },
                 multiple => 1,
+            },
+            employmentHistory => {
+                reference => 'employment',
+                multiple => 1,
+                ro => 1,
             },
             hosted => {
@@ -1665 +1670 @@
     my %changes;
 
+    {
+        my $sth = $self->db->prepare_cached(q{
+            select employment.name from employment
+            where "user" = ? and employment.firstday < now()
+        });
+        $sth->execute($self->id);
+        my @values;
+        while (my $res = $sth->fetchrow_hashref) {
+            push(@values, $res->{name});
+        }
+        $changes{"employmentHistory"} = \@values;
+    }
+
     foreach my $attribute (qw(contratType)) {
         my $sth = $self->db->prepare_cached(q{