Mercurial > hgrepos > hgweb.cgi > s4

changeset 304:ab11a49bd64e

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Sort search result by "DATE DESC, TITLE, x.ctime"
author HIROSE Yuuji <yuuji@gentei.org>
date Thu, 13 Oct 2016 23:04:33 +0859
parents 170fd6b81a95
children e751156de740
files s4-blog.sh
diffstat 1 files changed, 4 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/s4-blog.sh	Thu Oct 13 12:18:07 2016 +0859
+++ b/s4-blog.sh	Thu Oct 13 23:04:33 2016 +0859
@@ -458,6 +458,9 @@
 	# Not sure GROUP BY a.blogid is comfortable for searchers...?
 	kc=$kc${kc:+" AND "}"s.ctime GLOB '${ctime}*'"
 	##### kwdgrp=" GROUP BY a.blogid"
+      elif [ x"$k" = x"@today" -o x"$k" = x"@今日" ]; then
+	ctime=`date +%F`
+	kc=$kc${kc:+" AND "}"s.ctime GLOB '${ctime}*'"
       else
 	kc=$kc${kc:+" AND "}"s.text LIKE '%$k%'"
       fi
@@ -503,7 +506,7 @@
 	       ON a.id=s.id WHERE $kc$kwdgrp)
 	     x ON b.id=x.blogid
 	 WHERE b.id IN (SELECT id FROM blog_s $cond)
-       ORDER by x.ctime DESC;"
+       ORDER by DATE DESC, TITLE, x.ctime;"
   sedopt="s,<TR><TD>\([^<]*\)</TD>,<TR><TD><a\
  href=\"?replyblog+\1\">VIEW</a></TD>,"

yatex.org