<%init>
use AwayMsg;
+db_connect();
</%init>
<html lang="en"><head>
<title>Email "out of office" setup</title>
<%perl>
my %row;
-my $sth = $dbh->prepare("SELECT emailaddr, textid, expires"
- " FROM schema
- " RIGHT JOIN addresses USING (emailaddr)".
- " JOIN texts USING (textid)",
- " ORDER BY emailaddr");
+my $sth = $dbh->prepare(<<END);
+ SELECT emailaddr, textid, expires
+ FROM config
+ LEFT JOIN addresses USING (emailaddr)
+ LEFT JOIN texts USING (textid)
+ ORDER BY emailaddr
+END
</%perl>
<table>
<td>Which message?</td>
<td>Expiry date</td>
</tr><tr>
-% while ($row= $sth->fetchrow_hashref()) {
+% while (my $row= $sth->fetchrow_hashref()) {
+<tr>
<td><% $row->{'emailaddr'} |h %></td>
% if (defined $row->{'textid'}) {
% my $expiry = expires2timet($row->{'expires'});
% if ($expiry > time) {
<td>active</td>
+% } else {
+<td>expired</td>
+% }
<td><% $row->{'textid'} |h %></td>
<td><% $row->{'expires'} |h %></td>
-<td>
+% } else {
+<td>inactive</td>
+<td></td>
+<td></td>
+% }
+</tr>
+% }
+</table>