@Override @Transaction public void createAndFillAccessEleveur(TopiaContext transaction) throws TopiaException { if (log.isDebugEnabled()) { log.debug("createAndFillAccessEleveur"); } InfoAccessDAO infoAccessDAO = SandraDAOHelper.getInfoAccessDAO(transaction); String hql = "select eleveur FROM " + Eleveur.class.getName() + " eleveur" + " WHERE acceseleveur IS NULL"; List<Eleveur> eleveurs = transaction.findAll(hql); int cnt = 0; for (Eleveur e : eleveurs) { InfoAccess infoAccess = infoAccessDAO.create(); infoAccess.setCommentaireSecurite(e.getCommentaire()); if (e.getNiveauSecurite() == 0) { infoAccess.setNiveauSecurite(-1); } e.setAccesEleveur(infoAccess); SandraDAOHelper.getEleveurDAO(transaction).update(e); infoAccessDAO.update(infoAccess); cnt++; } log.info(cnt + " access breeders are created"); }
@Override @Transaction public void findAndDeleteDuplicateInfoAccess(TopiaContext transaction) throws TopiaException, LogicException { if (log.isDebugEnabled()) { log.debug("findAndDeleteDuplicateInfoAccess"); } InfoAccessDAO dao = SandraDAOHelper.getInfoAccessDAO(transaction); int cnt = 0; List<InfoAccess> infoAccessList = dao.findAll(); Map<String, InfoAccess> infoAccessNames = new HashMap<String, InfoAccess>(); for (InfoAccess infoAccess : infoAccessList) { InfoAccess cached = infoAccessNames.get(infoAccess.getNomAcces()); if (cached != null) { Eleveur cachedEleveur = findEleveurByAccesSilo(transaction, cached.getTopiaId()); Eleveur eleveur = findEleveurByAccesSilo(transaction, infoAccess.getTopiaId()); if (cachedEleveur != null && eleveur != null && cachedEleveur.getTopiaId().equals(eleveur.getTopiaId())) { dao.delete(infoAccess); cnt = cnt + 1; } } else { String name = infoAccess.getNomAcces(); if (name != null && !name.trim().isEmpty()) { infoAccessNames.put(name, infoAccess); } } } if (log.isDebugEnabled()) { log.debug("All duplicate info access are deleted, found : " + cnt); } }
public static void deleteAccesSilo(TopiaContext transaction, String infoAccessTopiaId) throws TopiaException { if (log.isInfoEnabled()) { log.info("deleteAccesSilo " + infoAccessTopiaId); } InfoAccessDAO dao = SandraDAOHelper.getInfoAccessDAO(transaction); InfoAccess infoAccess2 = dao.findByTopiaId(infoAccessTopiaId); infoAccess2.setEtat(InfoAccessEtat.INFOACCESS_SUPPR); dao.update(infoAccess2); } }
InfoAccess infoAccessOld = infoAccessDAO.findByTopiaId(accessEleveurTopiaId); infoAccessOld = infoAccessDAO.create(); infoAccessOld.setNiveauSecurite(-1); infoAccessOld.setEtat(InfoAccessEtat.INFOACCESS_ACTIF); infoAccessOld.setType(infoAccess.getType()); infoAccessDAO.update(infoAccessOld); eleveurDAO.update(breederOld);
InfoAccess infoAccess = infoAccessDAO.create(); infoAccess.setNiveauSecurite(-1); infoAccess.setEtat(0); infoAccessDAO.update(infoAccess); eleveur.setAccesEleveur(infoAccess); if (newSilo != null) { infoAccessDAO.delete(silo); silo = infoAccessDAO.update(silo); silo = infoAccessDAO.create(); silo.setNomAcces(siloNom); silo.setEtat(InfoAccessEtat.INFOACCESS_ACTIF); silo.setType(0); silo = infoAccessDAO.update(silo); eleveur.addAccesSilos(silo);
@Override @Transaction public InfoAccess getInfoAccess(TopiaContext transaction, String topiaId) throws TopiaException, LogicException { if (log.isDebugEnabled()) { log.debug("getAccesSilo " + topiaId); } InfoAccessDAO infoAccessDAO = SandraDAOHelper.getInfoAccessDAO(transaction); InfoAccess infoAccess = infoAccessDAO.findByTopiaId(topiaId); return infoAccess; }
@Override @Transaction public void createAllActionSecurityForEleveurs(TopiaContext transaction) throws TopiaException { log.info("createAllActionSecurityForEleveurs"); EleveurDAO eleveurDAO = SandraDAOHelper.getEleveurDAO(transaction); InfoAccessDAO infoAccessDAO = SandraDAOHelper.getInfoAccessDAO(transaction); String hql = "SELECT silo" + " FROM " + InfoAccess.class.getName() + " silo WHERE silo.niveauSecurite > 1" + " AND silo.eleveur IS NOT NULL"; // Empty creation List<InfoAccess> silos = transaction.findAll(hql); for (InfoAccess silo : silos) { Eleveur eleveur = silo.getEleveur(); SandraHelper.createActionSecuriteIfNeeded(transaction, null, eleveur, silo); eleveurDAO.update(eleveur); infoAccessDAO.update(silo); } }
accesEleveur = infoAccessDAO.create(); accesEleveur.setNiveauSecurite(eleveur.getNiveauSecurite()); accesEleveur.setCommentaireSecurite(eleveur.getCommentaire());
@Override public <U extends TopiaEntity> List<U> findUsages(Class<U> type, E entity) throws TopiaException { List<?> result = new ArrayList(); List tmp; if (type == InfoAccess.class) { InfoAccessDAO dao = (InfoAccessDAO) getContext().getDAO(InfoAccess.class); tmp = dao.findAllByGps(entity); result.addAll(tmp); } if (type == TraceGPS.class) { TraceGPSDAO dao = (TraceGPSDAO) getContext().getDAO(TraceGPS.class); tmp = dao.findAllContainsListePoints(entity); result.addAll(tmp); } if (type == Lieu.class) { LieuDAO dao = (LieuDAO) getContext().getDAO(Lieu.class); tmp = dao.findAllByTomtomGPS(entity); result.addAll(tmp); } return (List<U>) result; }
@Override public <U extends TopiaEntity> List<U> findUsages(Class<U> type, E entity) throws TopiaException { List<?> result = new ArrayList(); List tmp; if (type == InfoAccess.class) { InfoAccessDAO dao = (InfoAccessDAO) getContext().getDAO(InfoAccess.class); tmp = dao.findAllByEleveur(entity); result.addAll(tmp); } if (type == Note.class) { NoteDAO dao = (NoteDAO) getContext().getDAO(Note.class); tmp = dao.findAllByEleveur(entity); result.addAll(tmp); } if (type == Etape.class) { EtapeDAO dao = (EtapeDAO) getContext().getDAO(Etape.class); tmp = dao.findAllByEleveur(entity); result.addAll(tmp); } if (type == ActionSecurite.class) { ActionSecuriteDAO dao = (ActionSecuriteDAO) getContext().getDAO(ActionSecurite.class); tmp = dao.findAllByEleveur(entity); result.addAll(tmp); } return (List<U>) result; }
InfoAccess infoAccessOld = infoAccessDAO.findByTopiaId(accessEleveurTopiaId); infoAccessOld = infoAccessDAO.create(); infoAccessOld.setNiveauSecurite(-1); infoAccessOld.setEtat(InfoAccessEtat.INFOACCESS_ACTIF); infoAccessOld.setType(infoAccess.getType()); infoAccessDAO.update(infoAccessOld); eleveurDAO.update(breederOld);
InfoAccess infoAccess = infoAccessDAO.create(); infoAccess.setNiveauSecurite(-1); infoAccess.setEtat(0); infoAccessDAO.update(infoAccess); eleveur.setAccesEleveur(infoAccess); if (newSilo != null) { infoAccessDAO.delete(silo); silo = infoAccessDAO.update(silo); silo = infoAccessDAO.create(); silo.setNomAcces(siloNom); silo.setEtat(InfoAccessEtat.INFOACCESS_ACTIF); silo.setType(0); silo = infoAccessDAO.update(silo); eleveur.addAccesSilos(silo);
@Override @Transaction public InfoAccess getInfoAccess(TopiaContext transaction, String topiaId) throws TopiaException, LogicException { if (log.isDebugEnabled()) { log.debug("getAccesSilo " + topiaId); } InfoAccessDAO infoAccessDAO = SandraDAOHelper.getInfoAccessDAO(transaction); InfoAccess infoAccess = infoAccessDAO.findByTopiaId(topiaId); return infoAccess; }
@Override @Transaction public void createAllActionSecurityForEleveurs(TopiaContext transaction) throws TopiaException { log.info("createAllActionSecurityForEleveurs"); EleveurDAO eleveurDAO = SandraDAOHelper.getEleveurDAO(transaction); InfoAccessDAO infoAccessDAO = SandraDAOHelper.getInfoAccessDAO(transaction); String hql = "SELECT silo" + " FROM " + InfoAccess.class.getName() + " silo WHERE silo.niveauSecurite > 1" + " AND silo.eleveur IS NOT NULL"; // Empty creation List<InfoAccess> silos = transaction.findAll(hql); for (InfoAccess silo : silos) { Eleveur eleveur = silo.getEleveur(); SandraHelper.createActionSecuriteIfNeeded(transaction, null, eleveur, silo); eleveurDAO.update(eleveur); infoAccessDAO.update(silo); } }
accesEleveur = infoAccessDAO.create(); accesEleveur.setNiveauSecurite(eleveur.getNiveauSecurite()); accesEleveur.setCommentaireSecurite(eleveur.getCommentaire());
public static void deleteAccesSilo(TopiaContext transaction, String infoAccessTopiaId) throws TopiaException { if (log.isInfoEnabled()) { log.info("deleteAccesSilo " + infoAccessTopiaId); } InfoAccessDAO dao = SandraDAOHelper.getInfoAccessDAO(transaction); InfoAccess infoAccess2 = dao.findByTopiaId(infoAccessTopiaId); infoAccess2.setEtat(InfoAccessEtat.INFOACCESS_SUPPR); dao.update(infoAccess2); } }
@Override @Transaction public Eleveur findEleveurByAccesSilo(TopiaContext transaction, String infoAccessTopiaId) throws TopiaException, LogicException { if (log.isInfoEnabled()) { log.info("findEleveurByAccesSilo " + infoAccessTopiaId); } InfoAccessDAO infoAccessDAO = SandraDAOHelper.getInfoAccessDAO(transaction); InfoAccess silo = infoAccessDAO.findByTopiaId(infoAccessTopiaId); Eleveur breeder = silo.getEleveur(); return breeder; }
@Override @Transaction public void requestToUnlockBreeder(TopiaContext transaction, String topiaId) throws TopiaException, LogicException { if (log.isDebugEnabled()) { log.debug("requestToUnlockBreeder : " + topiaId); } TaasUser user = getUser(); EleveurDAO eleveurDAO = SandraDAOHelper.getEleveurDAO(transaction); InfoAccessDAO infoAccessDAO = SandraDAOHelper.getInfoAccessDAO(transaction); Eleveur eleveur = eleveurDAO.findByTopiaId(topiaId); InfoAccess accesEleveur = eleveur.getAccesEleveur(); accesEleveur.addUsersVerrouillage(user); infoAccessDAO.update(accesEleveur); serviceNotifier.notifyEvent("requestUnlockGPS", ServiceHelper.getSandraName(), ServiceHelper.getSandraUrl(), user.getLogin(), topiaId); }
@Override @Transaction public void createAndFillAccessEleveur(TopiaContext transaction) throws TopiaException { if (log.isDebugEnabled()) { log.debug("createAndFillAccessEleveur"); } InfoAccessDAO infoAccessDAO = SandraDAOHelper.getInfoAccessDAO(transaction); String hql = "select eleveur FROM " + Eleveur.class.getName() + " eleveur" + " WHERE acceseleveur IS NULL"; List<Eleveur> eleveurs = transaction.findAll(hql); int cnt = 0; for (Eleveur e : eleveurs) { InfoAccess infoAccess = infoAccessDAO.create(); infoAccess.setCommentaireSecurite(e.getCommentaire()); if (e.getNiveauSecurite() == 0) { infoAccess.setNiveauSecurite(-1); } e.setAccesEleveur(infoAccess); SandraDAOHelper.getEleveurDAO(transaction).update(e); infoAccessDAO.update(infoAccess); cnt++; } log.info(cnt + " access breeders are created"); }
@Override @Transaction public void findAndDeleteDuplicateInfoAccess(TopiaContext transaction) throws TopiaException, LogicException { if (log.isDebugEnabled()) { log.debug("findAndDeleteDuplicateInfoAccess"); } InfoAccessDAO dao = SandraDAOHelper.getInfoAccessDAO(transaction); int cnt = 0; List<InfoAccess> infoAccessList = dao.findAll(); Map<String, InfoAccess> infoAccessNames = new HashMap<String, InfoAccess>(); for (InfoAccess infoAccess : infoAccessList) { InfoAccess cached = infoAccessNames.get(infoAccess.getNomAcces()); if (cached != null) { Eleveur cachedEleveur = findEleveurByAccesSilo(transaction, cached.getTopiaId()); Eleveur eleveur = findEleveurByAccesSilo(transaction, infoAccess.getTopiaId()); if (cachedEleveur != null && eleveur != null && cachedEleveur.getTopiaId().equals(eleveur.getTopiaId())) { dao.delete(infoAccess); cnt = cnt + 1; } } else { String name = infoAccess.getNomAcces(); if (name != null && !name.trim().isEmpty()) { infoAccessNames.put(name, infoAccess); } } } if (log.isDebugEnabled()) { log.debug("All duplicate info access are deleted, found : " + cnt); } }