// wdev-18049 public Boolean countContractsWithTheSameServiceForTheSaneCCGCode( ContractConfigRefVo contractId, ServiceRefVo serviceRef, String cCGCode) { if (cCGCode == null || cCGCode == "") return null; StringBuilder hqlBuilder = new StringBuilder( "select c1_1.id, count (c1_1.id) from ContractConfig as c1_1 left join c1_1.serviceLocations as c2_1 left join c2_1.service as s1_1 left join c1_1.cCGsForContract as c3_1 where ( "); ArrayList<String> paramNames = new ArrayList<String>(); ArrayList<Object> paramValues = new ArrayList<Object>(); String and = ""; if (contractId != null && contractId.getID_ContractConfigIsNotNull()) { hqlBuilder.append("c1_1.id <> :cID "); and = "and "; paramNames.add("cID"); paramValues.add(contractId.getID_ContractConfig()); } if (serviceRef != null && serviceRef.getID_ServiceIsNotNull()) { hqlBuilder.append(and); hqlBuilder.append("s1_1.id = :service "); and = "and "; paramNames.add("service"); paramValues.add(serviceRef.getID_Service()); } if (cCGCode != null) { hqlBuilder.append(and); hqlBuilder.append(" c3_1.cCGCode like :ccgCode and c3_1.isActive = 1"); and = "and "; paramNames.add("ccgCode"); paramValues.add("%" + cCGCode + "%"); } hqlBuilder.append(") group by c1_1.id"); List<?> dos = getDomainFactory().find(hqlBuilder.toString(), paramNames, paramValues); if (dos != null && dos.size() > 0) { Object[] value = (Object[]) dos.get(0); Integer nrcontracts = (Integer) value[0]; if (nrcontracts > 0) return true; else return false; } return null; }
// WDEV-20181 public ContractServiceLocationsConfigVo getContractServiceLocConfByContractService( ContractConfigRefVo contractRef, ServiceRefVo serviceRef) { if (contractRef == null || serviceRef == null) { return null; } String sql = "select serviceLoc from ContractConfig as contractConf left join contractConf.serviceLocations as serviceLoc where contractConf.id = :ContractID and serviceLoc.service.id = :ServiceID"; List<?> listServiceLoc = getDomainFactory() .find( sql, new String[] {"ContractID", "ServiceID"}, new Object[] {contractRef.getID_ContractConfig(), serviceRef.getID_Service()}); if (listServiceLoc != null && listServiceLoc.size() > 0) return ContractServiceLocationsConfigVoAssembler.create( (ContractServiceLocationsConfig) listServiceLoc.get(0)); return null; }