惠安惠达项目新需求：首页增加待命车明细

点击待命车，希望看到明细信息

增加代码：

@RequestMapping(value = "/summaryHostVehInfo", method = RequestMethod.GET)
@ResponseBody
public BaseResp summaryHostVehInfo(){
	AbstractRequestExecutor executor = new AbstractRequestExecutor("请求访问待命车辆信息查询接口", "query summaryInfo"){
		@Override
		protected BaseResp queryDetail(String key) throws Exception{
			return messageService.querySummaryHostVehInfo();
		}
	};
	
	return executor.executeQueryDetail("");
}

ListResp querySummaryHostVehInfo();

@Override
public ListResp querySummaryHostVehInfo(){
    ListResp resp = new ListResp();
    
    List<VehUseSummaryInfoResp> summaryInfoResp = new ArrayList<VehUseSummaryInfoResp>(); ;
    
    summaryInfoResp =vehUseMessageDao.querySummaryHostVehInfo();
    
    resp.setList(summaryInfoResp);
    
    return resp;
}

List<VehUseSummaryInfoResp> querySummaryHostVehInfo();

@Override
public List<VehUseSummaryInfoResp> querySummaryHostVehInfo(){
    HibernateParams hParams = new HibernateParams();
    OrgDeptSearchFilter helper = new OrgDeptSearchFilter();
    UserSysDeptRes userSysDeptRes = Common.getLoginInfo().getUserSysDept();
    Integer querySysId = userSysDeptRes.getAppSysId();
    Integer queryDeptId = userSysDeptRes.getAppDeptId();
    
    hParams.addSqlStrBuffer("select m.item_name hostVehType,count(m.item_name) hostVehTypeCount from ");
    hParams.addSqlStrBuffer("(select b.item_name,v.* from vd_veh_assign_list v inner join ");
    hParams.addSqlStrBuffer("(select t.hostid,t.HOST_VEH_TYPE,t.owner_appsysid,t.owner_appdeptid, a.item_name ");
    hParams.addSqlStrBuffer("  from position_host_info_extend t, DICTIONARY_ITEM a ");
    hParams.addSqlStrBuffer(" where a.dic_type = 'HOST_VEH_TYPE' ");
    hParams.addSqlStrBuffer("and t.host_veh_type = a.item_value)b on v.host_id=b.hostid ");
    hParams.addSqlStrBuffer("and v.execute_status=").addSqlStrBuffer(Constant.ASSIGN_EXECUTE_STATUS_NOEXECUTE.toString())
    .addSqlStrBuffer(" and ((b.owner_appsysid, b.owner_appdeptid) in( ")
    .addSqlStrBuffer(helper.getSubDeptSql(querySysId, queryDeptId, hParams))
    .addSqlStrBuffer(" )))m group by m.item_name ");
    List<VehUseSummaryInfoResp> list = findBySql(hParams.getSqlStr(), hParams.getParamObj(), VehUseSummaryInfoResp.class);
    return list;
}

sql语句：

接口测试OK：

2017.6.6补充：上面的sql查询的数据不对，待命车辆数超过了车辆总数

发现关联的表不对，修改sql如下：

代码：