Changeset 2146

Timestamp:

08/29/18 20:15:47 (6 years ago)

Author:

nanardon

Message:

Add activeEmployment attribute: allow to select current and futur employment

File:

• trunk/LATMOS-Accounts/lib/LATMOS/Accounts/Bases/Sql/User.pm (modified) (1 diff)

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

@@ -1355 +1355 @@
                 }
             },
+            activeEmployment => {
+                managed => 1,
+                ro => 1,
+                reference => 'employment',
+                multiple => 1,
+                get => sub {
+                    my ($attr) = @_;
+                    my $self = $attr->object;
+
+                    my $now = DateTime->now()->iso8601 . 'Z';
+
+                    my $sth = $self->base->db->prepare_cached(
+                        q{
+                        select name from employment where (lastday > ?::timestamp or lastday IS NULL) and "user" = ?
+                        order by firstday asc
+                        limit 1
+                        }
+                    );
+                    $sth->execute($now, $self->id);
+                    my @Res;
+                    while (my  $res = $sth->fetchrow_hashref) {
+                        push(@Res, $res->{name});
+                    }
+
+                    return \@Res;
+                }
+            },
             prevEmployment => {
                 managed => 1,