s4

changeset 286:1c4f13f0813e

Add newer article flag representing by time string decoration.
author HIROSE Yuuji <yuuji@gentei.org>
date Mon, 15 Aug 2016 11:15:20 +0859
parents e87d6bc1e62a
children 422270e94adc
files examples/common/default/default.css s4-blog.sh
diffstat 2 files changed, 9 insertions(+), 2 deletions(-) [+]
line diff
     1.1 --- a/examples/common/default/default.css	Mon Aug 15 10:08:27 2016 +0859
     1.2 +++ b/examples/common/default/default.css	Mon Aug 15 11:15:20 2016 +0859
     1.3 @@ -87,6 +87,9 @@
     1.4      width: 400px; height: 300px; max-width: 50em; max-height: 20em;
     1.5      padding: 0; border: 0;
     1.6  }
     1.7 +.blog_replies span.new {	/* New Article from last visit */
     1.8 +    background: white; color: red;
     1.9 +}
    1.10  p.profimg {float: left; max-width: 400px; max-height: 400px;
    1.11  	   overflow: hidden; margin-right: 1em;
    1.12  	   padding: 0; border: white 1px solid; box-shadow: 2px 3px 4px
     2.1 --- a/s4-blog.sh	Mon Aug 15 10:08:27 2016 +0859
     2.2 +++ b/s4-blog.sh	Mon Aug 15 11:15:20 2016 +0859
     2.3 @@ -143,6 +143,9 @@
     2.4    hlink="$myname?home" elink="$myname?editart"
     2.5    catlink="$myname?showattc+article_m"
     2.6    deficon="img/file-icon.png"
     2.7 +  # 2016-08-15 Newer flag introduced
     2.8 +  atime=`query "SELECT time FROM acclog
     2.9 +		WHERE tbl='blog' AND tblrowid=$rowid AND user='$user';"`
    2.10    sq $db<<EOF |
    2.11  WITH a_s AS (
    2.12    SELECT id,
    2.13 @@ -167,6 +170,7 @@
    2.14  			author) uname,
    2.15  	a.rowid,
    2.16  	s.TIME,
    2.17 +        CASE WHEN s.TIME > '$atime' THEN 'new' ELSE '' END newer,
    2.18  	hex(s.TEXT),
    2.19  	(SELECT group_concat(rowid||':'||length(bin)||':'||hex(val), ' ')
    2.20  	 FROM article_m
    2.21 @@ -177,14 +181,14 @@
    2.22       a_s s
    2.23    ON a.id=s.id;
    2.24  EOF
    2.25 -  while IFS='|' read id edit notify uid uname aid tm hte imgids; do
    2.26 +  while IFS='|' read id edit notify uid uname aid tm new hte imgids; do
    2.27      nt="<label style=\"font-size: 70%;\"><input type=\"checkbox\"
    2.28  	 name=\"notifyto\" value=\"$uid\">返信通知送信</label>"
    2.29      cat<<EOF |
    2.30  <tr id="$id">
    2.31  <td>${edit:+<a href="$elink+$edit">編集</a> }#$aid
    2.32  <a href="$hlink+$uid">$uname</a>
    2.33 -$tm
    2.34 +<span${new:+ class="new"}>$tm</span>
    2.35  ${notify:+$nt}</td><td id="$aid">`echo "$hte"|unhexize|htmlescape`
    2.36  EOF
    2.37      hreflink