comparison s4-funcs.sh @ 174:fe8a381f9483

Column "rowid" in acclog renamed to tblrowid
author HIROSE Yuuji <yuuji@gentei.org>
date Fri, 19 Feb 2016 18:03:37 +0859
parents 31e63d173d38
children 3d12521876f2
comparison
equal deleted inserted replaced
173:31e63d173d38 174:fe8a381f9483
2105 _t=${DT_CHLD%:*} _i=${DT_CHLD#*:} 2105 _t=${DT_CHLD%:*} _i=${DT_CHLD#*:}
2106 cntall="(select count($_i) from $_t where $_i=a.id)" 2106 cntall="(select count($_i) from $_t where $_i=a.id)"
2107 cntnew="(select count(val) from ${_t}_s where key='ctime' \ 2107 cntnew="(select count(val) from ${_t}_s where key='ctime' \
2108 and id in (select id from $_t where $_i=a.id) \ 2108 and id in (select id from $_t where $_i=a.id) \
2109 and val > coalesce((select time from acclog where \ 2109 and val > coalesce((select time from acclog where \
2110 user='$user' and tbl='$2' and rowid=a.rowid),\ 2110 user='$user' and tbl='$2' and tblrowid=a.rowid),\
2111 '1970-01-01'))" 2111 '1970-01-01'))"
2112 cnt="$cntnew as '新着', $cntall as '総数'," 2112 cnt="$cntnew as '新着', $cntall as '総数',"
2113 dt_class=" td2r td3r" 2113 dt_class=" td2r td3r"
2114 fi 2114 fi
2115 # Construct join expression 2115 # Construct join expression

yatex.org