@Test public void findAppGroupPageList() throws Exception { List<AppGroupView> list = appGroupDao.findAppGroupPageList(paging); System.out.println("findAppGroupPageList :-------> " + list); Assert.assertTrue(list.size() > 0); }
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); }
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); } }
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); }  }
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); }  Long insertAppGroup(AppGroup appGroup); AppGroup getAppGroupById(Long id); int updateAppGroup(AppGroup appGroup); int deleteAppGroup(AppGroup appGroup); Long getCountByName(String name); Long getCountByIdAndName(Long id, String name); int changeServerGroup(Long newServerGroupId, Set<Long> appGroupIds); List<AppGroup> getAppGroupsByServerGroupId(Long serverGroupId); Long getAppGroupTotalCount(Paging<AppGroup> paging); List<AppGroupView> findAppGroupPageList(Paging<AppGroup> paging); }
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); }  Long insertAppGroup(AppGroup appGroup); AppGroup getAppGroupById(Long id); int updateAppGroup(AppGroup appGroup); int deleteAppGroup(AppGroup appGroup); Long getCountByName(String name); Long getCountByIdAndName(Long id, String name); int changeServerGroup(Long newServerGroupId, Set<Long> appGroupIds); List<AppGroup> getAppGroupsByServerGroupId(Long serverGroupId); Long getAppGroupTotalCount(Paging<AppGroup> paging); List<AppGroupView> findAppGroupPageList(Paging<AppGroup> paging);  }