class AppGroupDao extends BaseDao {

    public Long getAppGroupTotalCount(Paging<AppGroup> paging) throws SQLException {
        String sql = " SELECT count(1) FROM app_group t1 " +
                " left join server_group t2 on t2.id = t1.server_group_id " +
                " left join (select app_group_id, group_concat(name) as name, group_concat(id) as id from project group by app_group_id) t3 on t3.app_group_id = t1.id " +
                " left join login_users t4 on t1.update_user_no = t4.user_no " + this.appenWhere(paging);
        log.info("getAppGroupTotalCount-----> " + sql);
        return this.getCount(sql);
    }

}