X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~ian/git?p=nj-awaymsg.git;a=blobdiff_plain;f=mason%2Fmain;h=a9bc72e20621da1a183218ecba490259ef544095;hp=b70a3de9e395e86c22e5ea54411cff70dbedd72a;hb=dc799127a0e7b0599248dd9669652aeb4af59454;hpb=a8266f995aee0cf7c39c27d9d73b267e56049374 diff --git a/mason/main b/mason/main index b70a3de..a9bc72e 100755 --- a/mason/main +++ b/mason/main @@ -1,19 +1,17 @@ <%init> use AwayMsg; db_connect(); +www_begin($r,$m); my ($sth,$row,$sthi,$rowi); - -Email "out of office" setup - -

Email "out of office" setup

+<&htmlhead, subpage => 'Overview' &>

Email addresses and their configuration

<%perl> $sth = $dbh->prepare(<execute(); Address Status Which message? -Expiry date % while (my $row= $sth->fetchrow_hashref()) { <% $row->{'emailaddr'} |h %> % if (defined $row->{'textid'}) { -% my $expires = expires2timet($row->{'expires'}); -% if (defined($expires) && $expires < time) { -expired -% } else { active -% } <% $row->{'desc'} |h %> -<% expirestime2show($expires) |h %> % } else { inactive - % } % } +

Outbound messages

<%perl> -$sth = $dbh->prepare("SELECT * FROM texts ORDER BY desc"); +$sth = $dbh->prepare("SELECT * FROM texts ORDER BY textid"); $sthi = $dbh->prepare(<execute();

Message "<% $row->{'desc'} |h %>"

-<& txtable, tx => $row &> -%# $sthi->execute($row->{'textid'}); -% # while (my $rowi= $sthi->fetchrow_hashref()) { -%#Used for:<% $rowi->{'emailaddr'} |h %> -%# } -%# +<&| txtable, tx => $row &> +% $sthi->execute($row->{'textid'}); +% my $anyused = 0; +% while (my $rowi= $sthi->fetchrow_hashref()) { +Used for:<% $rowi->{'emailaddr'} |h %> +% $anyused++; +% } +% if ($anyused) { +Not currently in use +% } + 
 <% $row->{'text'} |h %>
- +
% }

Add new message