comparison s4-funcs.sh @ 233:1ad7ef38c0a0

Display gecos correctly in listentry(user)
author HIROSE Yuuji <yuuji@gentei.org>
date Fri, 24 Jun 2016 22:28:31 +0859
parents 4511cecade55
children 014f459543d5
comparison
equal deleted inserted replaced
232:4511cecade55 233:1ad7ef38c0a0
1630 coalesce(b.$gcs, a.$nm) as nick, 1630 coalesce(b.$gcs, a.$nm) as nick,
1631 coalesce(b.gecos, a.$nm) /* If group, concat (Nusers) */ 1631 coalesce(b.gecos, a.$nm) /* If group, concat (Nusers) */
1632 || case when a.$nm in (select gname from grp) 1632 || case when a.$nm in (select gname from grp)
1633 then printf('(%d名)', 1633 then printf('(%d名)',
1634 (select count(user) from grp_mem where gname=a.$nm)) 1634 (select count(user) from grp_mem where gname=a.$nm))
1635 else '<a.$nm>' 1635 else ' <'||a.$nm||'>'
1636 end 1636 end
1637 as name, 1637 as name,
1638 b.tag, 1638 b.tag,
1639 case when a.$nm in (select user from grp_adm 1639 case when a.$nm in (select user from grp_adm
1640 where gname=$getgrp) then '(管理者)' 1640 where gname=$getgrp) then '(管理者)'

yatex.org