our ($VERSION, @ISA, @EXPORT, @EXPORT_OK, %EXPORT_TAGS);
$VERSION = 1.00;
@ISA = qw(Exporter);
- @EXPORT = qw(db_connect db_commit expires2timet
+ @EXPORT = qw(db_connect db_commit
+ expires2timet expirestime2show
$dbh);
%EXPORT_TAGS = ( );
@EXPORT_OK = qw();
sub expires2timet ($) {
my ($str) = @_;
- if ($str eq '') {
+ if ($str eq '' or $str =~ m/never/i) {
return undef;
}
open F, "-|", qw(date -d),'$str',qw(+%s) or die $!;
return $dtime+0;
}
+sub expirestime2show ($) {
+ my ($tt) = @_;
+ if (!defined $tt) {
+ return 'never';
+ } else {
+ return strftime("%Y-%m-%d %H:%M");
+ }
+}
+
sub db_commit () {
nooutput("SELECT * FROM addresses LEFT JOIN config".
" USING (emailaddr) WHERE forwardfile IS NULL");
nooutput("SELECT * FROM addresses LEFT JOIN texts".
- " USING (textid) WHERE name IS NULL");
+ " USING (textid) WHERE desc IS NULL");
$dbh->do("COMMIT");
}
<%init>
use AwayMsg;
db_connect();
+my ($sth,$row,$sthi,$rowi);
</%init>
<html lang="en"><head>
<title>Email "out of office" setup</title>
</head><body>
<h1>Email "out of office" setup</h1>
-<h2>Email addresses and their configuration</h2>
-
+<h2>Email addresses and their configuration</h2>
<%perl>
-my %row;
-my $sth = $dbh->prepare(<<END);
+$sth = $dbh->prepare(<<END);
SELECT *
FROM addresses
LEFT JOIN config USING (emailaddr)
LEFT JOIN texts USING (textid)
ORDER BY emailaddr
END
+$sth->execute();
</%perl>
-
<table rules="all">
<tr>
<td>Address</td>
<td>Which message?</td>
<td>Expiry date</td>
</tr><tr>
-% $sth->execute();
% while (my $row= $sth->fetchrow_hashref()) {
<tr>
<td><% $row->{'emailaddr'} |h %></td>
% } else {
<td>active</td>
% }
-<td><% $row->{'name'} |h %></td>
-% if (defined $expires) {
-<td><% $row->{'expires'} |h %></td>
-% } else {
-<td>never</td>
-% }
+<td><% $row->{'desc'} |h %></td>
+<td><% expirestime2show($expires) |h %></td>
% } else {
<td>inactive</td>
<td></td>
</tr>
% }
</table>
+
+<h2>Outbound messages</h2>
+<%perl>
+$sth = $dbh->prepare("SELECT * FROM texts ORDER BY desc");
+$sthi = $dbh->prepare(<<END);
+ SELECT * FROM addresses
+ WHERE textid = ?
+ ORDER BY emailaddr
+END
+$sth->execute();
+</%perl>
+% while (my $row= $sth->fetchrow_hashref()) {
+<h3>Message "<% $row->{'desc'} |h %>"</h3>
+<table>
+<tr><td>Short name:</td><td><% $row->{'desc'} |h %></td></tr>
+<tr><td>Expires:</td><td><%
+ expirestime2show(expires2timet($row->{'expires'}))
+ |h %></td></tr>
+<tr><td>Subject:</td>
+ <td><code><% $row->{'subject'} |h %></code></td></tr>
+</table>
+<p>
+<pre>
+<% $row->{'text'} |h %>
+</pre>
+% }