class AppGroupDao extends BaseDao {

    public List<AppGroupView> findAppGroupPageList(Paging<AppGroup> paging) throws SQLException {
        String sql = " SELECT t1.id, t1.server_enabled, t1.server_group_id, t1.name, t1.comment, t1.insert_time, t1.update_time, t2.name as server_group_name , t3.name as project_names, t3.id as project_ids,t4.user_real_name " +
                "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" + appenCondition(paging);
        log.info("findAppGroupPageList-----> " + sql);
        return this.queryBySql(sql, AppGroupView.class);
    }

}