s4

annotate s4-blog.sh @ 67:3b70f847277e

Rearrangement
author HIROSE Yuuji <yuuji@gentei.org>
date Fri, 31 Jul 2015 10:04:14 +0900
parents 54bbd7ce3766
children 7380bcf19078
rev   line source
yuuji@0 1 #
yuuji@17 2 type cgiinit >/dev/null 2>&1 || . ./s4-funcs.sh
yuuji@0 3
yuuji@0 4 blog_genform() {
yuuji@0 5 #
yuuji@0 6 t=$1
yuuji@0 7 }
yuuji@0 8
yuuji@0 9 blog_writable() (
yuuji@0 10 # $1=articleid $2=user
yuuji@0 11 blogowner=`getvalbyid blog owner "$1"`
yuuji@0 12 [ x"$blogowner" = x"$2" ] || isuser "$blogowner" || ismember "$2" "$blogowner"
yuuji@0 13 )
yuuji@50 14 blog_notify_reply() (
yuuji@0 15 # $1=articleid $2=ReplyingUser $3=WrittenText
yuuji@0 16 blogowner=`getvalbyid blog owner "$1"`
yuuji@28 17 [ x"$2" = x"$blogowner" ] && return # If author=blogowner, unnecessary
yuuji@0 18 blogtitle=`getvalbyid blog title "$1"`
yuuji@0 19 blogurl="$urlbase?replyblog+$1"
yuuji@50 20 mode=`getvalbyid blog notify "$1"`
yuuji@50 21 case $mode in
yuuji@48 22 admin)
yuuji@55 23 if isgroup "$blogowner"; then
yuuji@55 24 emails=`for i in $(getgroupadmins $blogowner); do\
yuuji@55 25 [ x"$i" = x"$user" ] && continue;\
yuuji@58 26 email4group "$blogowner" "$i" ;\
yuuji@55 27 done`
yuuji@48 28 else
yuuji@48 29 emails=`collectemail $blogowner`
yuuji@48 30 fi
yuuji@48 31 ;;
yuuji@48 32 no) return ;;
yuuji@48 33 *) emails=`collectemail $blogowner` ;;
yuuji@48 34 esac
yuuji@57 35 err notify: user=$user Admins=`getgroupadmins $blogowner` Mode=$mode Emails="[$emails]"
yuuji@0 36 smail "$emails" "書込通知 $urlbase"<<EOF
yuuji@48 37 [$blogtitle]板に書き込みがありました。
yuuji@0 38 場所: $blogurl
yuuji@0 39 題目: $blogtitle
yuuji@0 40 筆者: `gecos $2`
yuuji@0 41 内容:
yuuji@0 42 `echo "$3"|sed 's/^/> /'`
yuuji@0 43 EOF
yuuji@50 44 )
yuuji@0 45 blog_showentry() {
yuuji@0 46 # $1=table $2=rowid
yuuji@0 47 if [ -n "$2" ]; then
yuuji@0 48 if [ -n "$imgcached" ]; then
yuuji@42 49 bstmpdir=$tmpdir/$imgcached/$thumbxy
yuuji@0 50 else
yuuji@42 51 bstmpdir=$tmpd
yuuji@42 52 # tmpd=`mktempd`
yuuji@42 53 # tmpfiles=$tmpfiles" $tmpd"
yuuji@0 54 fi
yuuji@0 55 fi
yuuji@0 56 tbl=${1%%[!A-Z0-9a-z_]*} rowid=${2%%[!A-Z0-9a-z_]*}
yuuji@0 57 err rowid=$rowid, '$2'=$2
yuuji@0 58 ts=${tbl}_s tm=${tbl}_m
yuuji@0 59 at=article as=article_s am=article_m
yuuji@0 60 serial=$(($(date +%s)-1420038000))s$$
yuuji@64 61 blog_writable $rowid $user && iswritable=true || iswritable=false
yuuji@0 62 # This function grasps blog entry definiton directly.
yuuji@0 63 # blog: id
yuuji@0 64 # blog_s: title,ctime,heading
yuuji@0 65 # blog_m: *article
yuuji@0 66
yuuji@0 67 err "SELECT id from $tbl where rowid=$rowid"
yuuji@2 68 id=`query "select id from $tbl where rowid=$rowid;"`
yuuji@0 69 err id=$id
yuuji@0 70 err "select val from $ts where key='title' and id='$id';"
yuuji@0 71
yuuji@0 72
yuuji@0 73 #(1)Display root article
yuuji@0 74 cat<<EOF
yuuji@0 75 <form class="replyblog" action="$myname?replyblog+$rowid" method="POST" enctype="multipart/form-data">
yuuji@0 76 <table class="bloghead">
yuuji@0 77 EOF
yuuji@0 78
yuuji@0 79 href="<a href=\"?editheading+$rowid\"> 編集 </a>"
yuuji@64 80 if $iswritable; then
yuuji@64 81 href2="<a href=\"?lshandout+$rowid\"> 提出状況 </a>"
yuuji@64 82 href3="(<a href=\"?gethandout+$rowid\">ファイル取得</a>)"
yuuji@64 83 fi
yuuji@0 84 cat<<EOF | sq -html $db \
yuuji@0 85 | sed -e "s|\(<TR><TD>\),e,|\1 $href |" \
yuuji@2 86 -e "s|,s,\(</TD>\)|$href2$href3\1|"
yuuji@0 87 -- select val from $ts where key="title" and id="$id";
yuuji@2 88 select
yuuji@2 89 coalesce((select ",e," from blog where rowid=$rowid and author='$user'),'')
yuuji@2 90 ||val||" "
yuuji@0 91 ||case (select val from $ts where key="mode" and id="$id")
yuuji@0 92 when 'report-closed' then "レポート提出用(自身のファイルのみ参照可),s,"
yuuji@0 93 when 'report-open' then "レポート提出用,s,"
yuuji@0 94 else ""
yuuji@0 95 end
yuuji@0 96 from $ts where key="ctime" and id="$id";
yuuji@0 97 select val from $ts where key="heading" and id="$id";
yuuji@0 98 EOF
yuuji@0 99 cat<<EOF
yuuji@0 100 </table>
yuuji@0 101 <table class="blog_replies">
yuuji@0 102 EOF
yuuji@0 103
yuuji@0 104 #(2)Display following articles
yuuji@0 105 textform='<div><table class="b">
yuuji@0 106 <tr><td><textarea name="text" cols="40" rows="4"></textarea></td></tr>
yuuji@0 107 <tr><td>添付ファイル: <input type="file" name="image" multiple></td></tr>
yuuji@0 108 </table>
yuuji@0 109 <input type="submit" value="送信">
yuuji@0 110 <input type="reset" value="リセット"></div>
yuuji@0 111 '
yuuji@0 112 ## 6/11の次: articleを出して行く
yuuji@0 113 : <<EOF
yuuji@0 114 シリアル:id:p:serial:
yuuji@0 115 blogID:blogid:f:blog(id):
yuuji@0 116 筆者:author:s:owner
yuuji@0 117 時刻:ctime:s:stamp:
yuuji@0 118 参照元:parent:s:parent:
yuuji@0 119 パス:path:s:path:
yuuji@0 120 本文:text:s:textarea:cols="60" rows="8"
yuuji@0 121 画像:image:m:image:
yuuji@0 122 stage:stage:x:hidden:value="replyblog"
yuuji@0 123
yuuji@0 124 article(id, blogid, author)
yuuji@0 125 article_s: Visible = ctime, text Invisible = parent, path
yuuji@0 126 article_m: image
yuuji@0 127
yuuji@0 128 article = hoge|1433812374x20849|yuuji@gentei.org
yuuji@0 129 article_s = hoge|ctime|string|2015-06-13 12:27:34|
yuuji@0 130 hoge|text|string|Shall we dance?|
yuuji@0 131 EOF
yuuji@0 132 ##
yuuji@0 133 ##
yuuji@0 134 err "select id from $at where blogid='$id';"
yuuji@0 135 # arts=`sq $db "select a.rowid,a.id,
yuuji@0 136 #-- coalesce(b.gecos, a.author)
yuuji@0 137 # a.author from $at a
yuuji@0 138 # LEFT JOIN (select name,val as gecos from user_s where key='gecos') b
yuuji@0 139 # on a.author=b.name where blogid='$id'";`
yuuji@0 140 arts=`query "select rowid,id,author from $at where blogid='$id';"`
yuuji@34 141 # err arts="[$arts]"
yuuji@0 142 number=0
yuuji@2 143 hrefhome0="<a href=\"?home"
yuuji@0 144 for a in $arts; do
yuuji@59 145 arid=${a%%\|*} aid=`echo "$a"|cut -d'|' -f2` author=${a##*\|} imgs=""
yuuji@41 146 err a=$a, aid=$aid, author=$author
yuuji@0 147 # name='' # Get gecos??
yuuji@42 148 td=$(echo $bstmpdir/`echo $a|md5`)
yuuji@59 149 val=`getvalbyid article image "$arid" "$td"`
yuuji@41 150 err val="[$val]" and td as follows:
yuuji@0 151
yuuji@0 152 if true; then
yuuji@0 153 if [ -n "$val" ]; then
yuuji@0 154 hrfb="$myname?showattc+article_m"
yuuji@0 155 imgs="<br>"$(echo "$val"\
yuuji@0 156 |while read fn; do
yuuji@0 157
yuuji@0 158 #data=`percenthex $td/$fn`
yuuji@0 159 #ct=`cat $td/$fn.content-type`
yuuji@0 160 ri=`cat $td/$fn.rowid`
yuuji@41 161 err fn=$fn ct=$ct ri=$ri; ls -lF $td/ 1>&3
yuuji@0 162 iconhref $td/$fn "$hrfb+$ri" "$fn" "$fn"
yuuji@0 163 done)
yuuji@41 164 imgs=`echo "$imgs"|tr -d '\n'` # kill newlines for sed
yuuji@0 165 fi
yuuji@0 166 fi
yuuji@0 167
yuuji@0 168 ### number=$((number+1))
yuuji@0 169 # reply="<input type=\"radio\" name=\"parent\" class=\"replybtn\" \
yuuji@0 170 # value=\"$number\">"
yuuji@2 171 getgecos="(select rowid from user where name='$author')||':'||\
yuuji@2 172 coalesce((select val from user_s \
yuuji@2 173 where name='$author' and key='gecos'), '$author')||',[/a],'"
yuuji@0 174 href="$myname?editart+$arid+$rowid"
yuuji@0 175 link="<a href=\"$href\">編集</a>"
yuuji@0 176 cat<<EOF | sq -html $db \
yuuji@2 177 | sed -e "s|,n,\([0-9]*\):|,n,$hrefhome0+\1\">|" \
yuuji@2 178 -e 's|,\[/a\],|</a>|' \
yuuji@2 179 -e 's/,n,/<br>/g' -e "s|,i,|$imgs|" \
yuuji@0 180 -e "s|<TR>\(<TD>\)|<TR id=\"$aid\">\1|" \
yuuji@35 181 -e "s|^href=\([-A-Za-z0-9,.:/~_%#&+?]*\)|<a &>\1</a>|" \
yuuji@2 182 -e "s|\(<TR.*>\)\(<TD>\),e,|\1\2$link|"
yuuji@0 183 select
yuuji@0 184 coalesce((select ",e," from article where id='$aid' and author='$user'),"")
yuuji@0 185 ||
yuuji@0 186 max(case key when 'ctime' then ",n,"||val||
yuuji@0 187 ",n,"||$getgecos end) as TIME,
yuuji@0 188 -- max(case key when 'parent' then val||"への返信" end) as REPLYTO,
yuuji@0 189 max(case key when 'text' then val||",i," end) as TEXT
yuuji@0 190 from article_s where id = '$aid'
yuuji@0 191 group by id order by TIME;
yuuji@0 192 EOF
yuuji@0 193 done
yuuji@0 194 echo "</table>"
yuuji@0 195
yuuji@0 196
yuuji@64 197 $iswritable && cat<<EOF
yuuji@0 198 <div class="blogcomment">
yuuji@0 199 <p>コメント記入</p>
yuuji@0 200 <input type="hidden" name="blogid" value="$id">
yuuji@0 201 <input type="hidden" name="stage" value="replyblog">
yuuji@0 202 <input type="hidden" name="serial" value="$serial">
yuuji@0 203 $textform
yuuji@0 204 </div>
yuuji@0 205 EOF
yuuji@0 206 echo "</form>"
yuuji@0 207
yuuji@0 208 # Record access log
yuuji@0 209 acclog blog $rowid
yuuji@0 210 }
yuuji@0 211
yuuji@0 212 lshandout() {
yuuji@0 213 # $1=rowid of blog
yuuji@64 214 if ! blog_writable $1 $user; then
yuuji@64 215 echo "メンバー以外は利用できません。" | html p; return
yuuji@64 216 fi
yuuji@0 217 time=`getvalbyid blog ctime $1|colrm 11`
yuuji@0 218 owner=`getvalbyid blog owner $1`
yuuji@0 219 title=`getvalbyid blog title $1`
yuuji@2 220 ge=`gecos $owner`
yuuji@0 221 lshandoutsub $owner "$@" \
yuuji@0 222 |m4 -D_TITLE_="提出状況" \
yuuji@67 223 -D_FORMHEAD_="$time [$title]@${ge:-$owner}" \
yuuji@67 224 -D_FORM_="syscmd(cat)" -D_DUMPHEAD_= -D_DUMPTABLE_= \
yuuji@67 225 $layout/html.m4.html $layout/form+dump-whead.m4.html
yuuji@0 226 }
yuuji@0 227 lshandoutsub() {
yuuji@0 228 # $1=owner $2=rowid of blog
yuuji@2 229 if isgroup $1; then
yuuji@2 230 sample="(select user from grp_mem where gname='$1')"
yuuji@2 231 else
yuuji@2 232 sample="(select distinct author as user from arts)"
yuuji@67 233 echo "(集計は板への投稿者のみ)" | html p
yuuji@2 234 fi
yuuji@2 235 sql="with arts as (select id,author from article \
yuuji@0 236 where blogid=(select id from blog where rowid=$2))\
yuuji@0 237 select (select rowid from user where name=c0.user)||' '|| \
yuuji@0 238 coalesce((select val from user_s where name=c0.user \
yuuji@0 239 and key='gecos'),\
yuuji@0 240 c0.user) as 'メンバー',\
yuuji@0 241 sum(case when c1.key is not null then 1 else 0 end)\
yuuji@0 242 as 'コメント記入',\
yuuji@0 243 sum(case when c2.key is not null then 1 else 0 end)\
yuuji@0 244 as 'ファイルの提出'\
yuuji@2 245 from $sample c0 \
yuuji@0 246 left join (select id,author from arts) a\
yuuji@0 247 on c0.user=a.author\
yuuji@0 248 left join (select id,key from article_s where key='text') c1\
yuuji@0 249 on a.id=c1.id left join (select id,key from article_m ) c2\
yuuji@0 250 on c1.id=c2.id group by c0.user order by c0.user;"
yuuji@0 251 err ishandoutsub: sql="$sql"
yuuji@0 252 echo '<table class="b td2r td3r">'
yuuji@0 253 hrb="<a href=\"?home+"
yuuji@0 254 echo "$sql" | sq -header -html $db \
yuuji@0 255 | sed -e "s,\(<TR><TD>\)\([^ ]*\) \(.*\)</TD>,\1$hrb\2\">\3</TD>," -e 's,<TD>0</TD>,<TD class="warn">0</TD>,'
yuuji@0 256 echo '</table>'
yuuji@0 257 }
yuuji@2 258 gethandout() {
yuuji@2 259 # $1=rowid of blog
yuuji@64 260 if ! blog_writable $1 $user; then
yuuji@64 261 echo "メンバー以外は利用できません。" | html p; return
yuuji@64 262 fi
yuuji@2 263 i=0
yuuji@2 264 bd=$tmpd/archive.$$
yuuji@2 265 mkdir $bd
yuuji@2 266 query "select m.rowid,author,m.val from article a join article_m m\
yuuji@2 267 on a.id=m.id where blogid=(select id from blog where rowid=$1)\
yuuji@2 268 and m.key in ('image', 'document', 'binary');" \
yuuji@2 269 | while IFS='|' read rowid author filename; do
yuuji@63 270 # err isfilereadable $user article_m $rowid
yuuji@63 271 isfilereadable $user article_m $rowid || continue
yuuji@63 272 # err ok
yuuji@2 273 i=$((i+1))
yuuji@2 274 dir=`printf $bd/%03d $i`
yuuji@2 275 mkdir $dir
yuuji@2 276 query "select quote(bin) from article_m where rowid=$rowid;" \
yuuji@8 277 | unhexize > $dir/$filename
yuuji@2 278 done
yuuji@2 279 if [ ! -d $bd/001 ]; then
yuuji@2 280 contenttype; echo
yuuji@67 281 echo "取得できるファイルがありませんでした。" | html p
yuuji@2 282 return
yuuji@2 283 fi
yuuji@2 284 (cd $bd
yuuji@2 285 err cdto$bd; (pwd; ls -lFa) 1>&3
yuuji@2 286 tar zcf .archive.tar.gz * && mv .archive.tar.gz archive.tar.gz
yuuji@2 287 )
yuuji@2 288 arc=$bd/archive.tar.gz
yuuji@2 289 echo "Content-type: application/x-gzip"
yuuji@2 290 echo "Content-Length: `cat $arc|wc -c`"
yuuji@2 291 echo "Content-Disposition: filename=\"archive.tar.gz\""
yuuji@2 292 echo
yuuji@2 293 cat $arc
yuuji@2 294 }
yuuji@0 295
yuuji@0 296 listblog() (
yuuji@67 297 # $1={user,group}
yuuji@67 298 qow=`sqlquote $1`
yuuji@67 299 cond="where a.id in (select id from blog_s where key='owner' and val=$qow) order by ctime desc"
yuuji@0 300 DT_CHLD=article:blogid
yuuji@0 301 cgi_form searchart<<EOF
yuuji@0 302 <label>`cgi_text kwd`という語を含む記事を検索</label>
yuuji@0 303 `cgi_hidden owner $user`
yuuji@0 304 EOF
yuuji@0 305 dumptable html blog 'ctime title heading' "$cond"
yuuji@0 306 )
yuuji@0 307
yuuji@0 308 blog_addentry() {
yuuji@0 309 # $1=GRPname(if it is a group)
yuuji@16 310 grprowid=$1
yuuji@0 311 rowid=`getpar rowid`
yuuji@0 312 err ba: rowid=$rowid
yuuji@0 313 #if [ -z "$rowid" ]; then
yuuji@0 314 # When rowid is SET, it is updation of existing entry
yuuji@0 315 if [ -z "$1" ]; then
yuuji@0 316 listing=$user guide="[個人]"
yuuji@0 317 #listing代入は rowid 時でもするべき
yuuji@0 318 else
yuuji@16 319 grp=`getgroupbyid $grprowid`
yuuji@16 320 if [ -n "$grp" ]; then
yuuji@67 321 listing=$grp guide="[${grp}]" GF_OWNER=$grp
yuuji@0 322 else
yuuji@67 323 echo "無効なグループ指定です。" | html p
yuuji@0 324 return
yuuji@0 325 fi
yuuji@0 326 fi
yuuji@0 327 #fi
yuuji@0 328 if [ -n "`getpar title`" ]; then
yuuji@0 329 owner=`getpar owner`
yuuji@0 330 if isuser $owner; then
yuuji@0 331 if [ x"$user" != x"$owner" ]; then
yuuji@67 332 echo "他人の日記は書けません" | html p
yuuji@0 333 return
yuuji@0 334 fi
yuuji@0 335 elif isgroup $owner; then # if write to group log
yuuji@0 336 grp=$owner #\`getpar grp\`
yuuji@0 337 err ismember: $user $grp
yuuji@0 338 if ! ismember "$user" "$grp"; then
yuuji@67 339 echo "(話題作成はこのグループに加入してから)" | html p
yuuji@0 340 return
yuuji@0 341 fi
yuuji@0 342 fi
yuuji@0 343 par2table $formdir/blog.def
yuuji@0 344 serial=`getpar serial`
yuuji@0 345 err SERIAL: $serial ROWID=$rowid listing=$listing
yuuji@0 346 id=""
yuuji@0 347 if [ -n "$rowid" ]; then
yuuji@0 348 # Here, id becomes NULL when removal of entries at par2table
yuuji@0 349 id=`query "select rowid from blog where rowid=$rowid;"`
yuuji@0 350 elif [ -n "$serial" ]; then
yuuji@0 351 # If new blog leader created, traverse to its head.
yuuji@0 352 id=`query "select rowid from blog where id='$serial';"`
yuuji@0 353 fi
yuuji@0 354 if [ -n "$id" ]; then
yuuji@0 355 ## If new aritcle is entered, JUMP to blog_reply
yuuji@0 356 blog_reply $id
yuuji@0 357 return
yuuji@0 358 fi
yuuji@0 359 fi
yuuji@67 360 m4 -D_TITLE_="${guide}新規話題作成" \
yuuji@67 361 -D_FORMHEAD_="序文は簡単に詳しくはコメントに" \
yuuji@67 362 -D_DUMPHEAD_="これまでの蓄積" \
yuuji@0 363 -D_FORM_="`genform $formdir/blog.def`" \
yuuji@0 364 -D_DUMPTABLE_="`listblog $listing`" \
yuuji@0 365 $layout/html.m4.html \
yuuji@67 366 $layout/form+dump-whead.m4.html
yuuji@0 367 }
yuuji@0 368
yuuji@0 369 blog_reply() {
yuuji@0 370 rowid=$1
yuuji@0 371 err rowid=$1
yuuji@0 372
yuuji@0 373 if [ -z "$rowid" ]; then
yuuji@67 374 echo "表示する日記番号が未指定です。" | html p
yuuji@0 375 return
yuuji@0 376 fi
yuuji@0 377 title=`getvalbyid blog title $rowid`
yuuji@0 378 owner=`getvalbyid blog owner $rowid`
yuuji@0 379 if isuser "$owner"; then
yuuji@0 380 subtitle="`gecos $owner` さんの話題"
yuuji@0 381 else
yuuji@16 382 grprowid=`query "select rowid from grp where gname=\"$owner\";"`
yuuji@54 383 subtitle="グループ <a href=\"?grp+$grprowid\">$owner</a> での話題"
yuuji@0 384 fi
yuuji@0 385 if [ -z "$title" ]; then
yuuji@67 386 echo "日記番号指定が無効です。" | html p
yuuji@0 387 return
yuuji@0 388 fi
yuuji@0 389
yuuji@0 390 text=`getpar text`
yuuji@0 391 if [ -n "$text" ]; then
yuuji@0 392 if blog_writable $rowid $user; then
yuuji@0 393 if par2table $formdir/article.def; then
yuuji@0 394 blog_notify_reply $rowid $user "$text"
yuuji@0 395 fi
yuuji@0 396 else
yuuji@0 397 title="$title(加入してないので書き込み不可)"
yuuji@0 398 fi
yuuji@0 399 fi
yuuji@0 400 def=$formdir/article.def
yuuji@67 401 blog_showentry blog $rowid \
yuuji@67 402 | m4 -D_TITLE_="$title" -D_BODYCLASS_=general \
yuuji@67 403 -D_FORMHEAD_="$subtitle" -D_FORM_="" \
yuuji@67 404 -D_DUMPTABLE_="syscmd(cat)" -D_DUMPHEAD_="" \
yuuji@67 405 $layout/html.m4.html $layout/form+dump-whead.m4.html
yuuji@0 406 }