countGroup
/**
* countGroup
* 分组统计/批量统计
*
* @param $strTableName:string:表
* @param $groupColumns:string:分组字段
* @param $where:map:条件
* @param $systemId:string:系统ID
*
* @return list
*
*/
#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