Revision 02118682
Von Thomas Heck vor mehr als 12 Jahren hinzugefügt
| SL/Auth.pm | ||
|---|---|---|
| 424 | 424 |
my $self = shift; |
| 425 | 425 |
|
| 426 | 426 |
my $dbh = $self->dbconnect(); |
| 427 |
my $query = qq|SELECT u.id, u.login, cfg.cfg_key, cfg.cfg_value |
|
| 428 |
FROM auth.user_config cfg |
|
| 429 |
LEFT JOIN auth."user" u ON (cfg.user_id = u.id)|; |
|
| 427 |
my $query = qq|SELECT u.id, u.login, cfg.cfg_key, cfg.cfg_value, s.mtime AS last_action |
|
| 428 |
|
|
| 429 |
FROM auth."user" AS u |
|
| 430 |
|
|
| 431 |
LEFT JOIN auth.user_config AS cfg |
|
| 432 |
ON (cfg.user_id = u.id) |
|
| 433 |
|
|
| 434 |
LEFT JOIN auth.session_content AS sc_login |
|
| 435 |
ON (sc_login.sess_key = 'login' AND sc_login.sess_value = ('--- ' \|\| u.login \|\| '\n'))
|
|
| 436 |
|
|
| 437 |
LEFT JOIN auth.session AS s |
|
| 438 |
ON (s.id = sc_login.session_id) |
|
| 439 |
|; |
|
| 430 | 440 |
my $sth = prepare_execute_query($main::form, $dbh, $query); |
| 431 | 441 |
|
| 432 | 442 |
my %users; |
| 433 | 443 |
|
| 434 | 444 |
while (my $ref = $sth->fetchrow_hashref()) {
|
| 435 |
$users{$ref->{login}} ||= { 'login' => $ref->{login}, 'id' => $ref->{id} };
|
|
| 445 |
|
|
| 446 |
$users{$ref->{login}} ||= {
|
|
| 447 |
'login' => $ref->{login},
|
|
| 448 |
'id' => $ref->{id},
|
|
| 449 |
'last_action' => $ref->{last_action},
|
|
| 450 |
}; |
|
| 436 | 451 |
$users{$ref->{login}}->{$ref->{cfg_key}} = $ref->{cfg_value} if (($ref->{cfg_key} ne 'login') && ($ref->{cfg_key} ne 'id'));
|
| 437 | 452 |
} |
| 438 | 453 |
|
| locale/de/all | ||
|---|---|---|
| 1051 | 1051 |
'Language missing!' => 'Sprache fehlt!', |
| 1052 | 1052 |
'Language saved!' => 'Sprache gespeichert!', |
| 1053 | 1053 |
'Languages' => 'Sprachen', |
| 1054 |
'Last Action' => 'Letzte Aktivität', |
|
| 1054 | 1055 |
'Last Article Number' => 'Letzte Artikelnummer', |
| 1055 | 1056 |
'Last Cost' => 'Einkaufspreis', |
| 1056 | 1057 |
'Last Credit Note Number' => 'Letzte Gutschriftnummer', |
| ... | ... | |
| 2281 | 2282 |
'not configured' => 'nicht konfiguriert', |
| 2282 | 2283 |
'not delivered' => 'nicht geliefert', |
| 2283 | 2284 |
'not executed' => 'nicht ausgeführt', |
| 2285 |
'not logged in' => 'nicht eingeloggt', |
|
| 2284 | 2286 |
'not transferred in yet' => 'noch nicht eingelagert', |
| 2285 | 2287 |
'not transferred out yet' => 'noch nicht ausgelagert', |
| 2286 | 2288 |
'not yet executed' => 'Noch nicht ausgeführt', |
| templates/webpages/admin/list_users.html | ||
|---|---|---|
| 16 | 16 |
<th class="listtop">[% 'Language' | $T8 %]</th> |
| 17 | 17 |
<th class="listtop">[% 'Dataset' | $T8 %]</th> |
| 18 | 18 |
<th class="listtop">[% 'Host' | $T8 %]</th> |
| 19 |
<th class="listtop">[% 'Last Action' | $T8 %]</th> |
|
| 19 | 20 |
<!-- <th class="listtop">[% 'Driver' | $T8 %]</th> --> |
| 20 | 21 |
</tr> |
| 21 | 22 |
|
| ... | ... | |
| 29 | 30 |
<td> [% HTML.escape(row.countrycode) %]</td> |
| 30 | 31 |
<td> [% HTML.escape(row.dbname) %]</td> |
| 31 | 32 |
<td> [% IF row.dbhost %][% HTML.escape(row.dbhost) %][% ELSE %]localhost[% END %]</td> |
| 33 |
<td> |
|
| 34 |
[% IF( row.last_action ) %] |
|
| 35 |
[% HTML.escape(row.last_action) %] |
|
| 36 |
[% ELSE %] |
|
| 37 |
[% 'not logged in' | $T8 %] |
|
| 38 |
[% END %]</td> |
|
| 32 | 39 |
<!-- <td> [% HTML.escape(row.dbdriver) %]</td> --> |
| 33 | 40 |
</tr> |
| 34 | 41 |
[% END %] |
Auch abrufbar als: Unified diff
Administrationsoberflaeche: aktive User anzeigen
implementiert #1853