countDetail
@countDetail($src, $fieldId, $strTableName, $key, $target, $other, $systemId)
#function countDetail($src, $fieldId, $strTableName, $key, $target, $other, $systemId)
#if ($vs.util.isNull($other))
#set($other = $vs.util.newMap())
#end
#set($ids = @collectSet($src, $fieldId))
$other.put($key, $ids)
#set($counts = @countGroup($strTableName, $key, $other, $systemId))
#set($countMap = @list2map($counts, $fieldId, 'COUNT'))
@listPut($src, $countMap, $fieldId, $target)
#foreach ($row in $src)
#if ($vs.util.isNull($row.get($target)))
$row.put($target, 0)
#end
#end
return $src
#end
#function collectSet($list, $fieldId)
#set($result = $vs.util.newList())
#if (!$vs.util.isList($list))
return $result
#end
#set($set = $vs.util.newList())
#foreach($row in $list)
#set($value = $row)
#if ($vs.util.isNotNull($fieldId))
#set($value = $row.get($fieldId))
#end
#if ($vs.util.isNotNull($value) and !$set.contains($value))
$result.add($value)
$set.add($value)
#end
#end
return $result
#end
#function countGroup ($strTableName, $groupColumns, $where, $systemId)
#set($whereSql = @andWhere($where))
#set($strSql = `
select
${$groupColumns},
count(1) as count
from ${$strTableName}
where 1 = 1 ${$whereSql}
group by ${$groupColumns}
`)
#if ($vs.util.isNull($systemId))
return $vs.dbTools.list($strSql, $where)
#else
return $vs.dbTools.remoteList($systemId, $strSql ,$where)
#end
#end
#function andWhere($where)
#set($sql = '')
#if ($vs.util.isMap($where))
#foreach ($key in $vs.util.getMapKeys($where))
#set($value = $where.get($key))
#if ($vs.util.isList($value))
#set($sql = $sql + " and " + $vs.sqlHelper.listIn($value, $key))
#else
#set($sql = $sql + $vs.sqlHelper.and($where, $key))
#end
#end
#end
return $sql
#end
#function list2map ($list, $keyField, $valueField)
#set($map = $vs.util.newMap())
#if ($vs.util.isList($list))
#foreach($row in $list)
#set($value = $row)
#if (!$vs.util.isNull($valueField))
#set($value = $row.get($valueField))
#end
$map.put($row.get($keyField), $value)
#end
#end
return $map
#end
#function listPut($list, $dataMap, $keyFieldId, $dataFieldId)
#if ($vs.util.isBlankOne($list, $dataMap, $keyFieldId))
return $list
#end
#if ($vs.util.isNull($dataFieldId))
#set($dataFieldId = 'data')
#end
#foreach($item in $list)
#set($fieldValue = $item.get($keyFieldId))
#set($data = $dataMap.get($fieldValue))
$item.put($dataFieldId, $data)
#end
return $list
#end