public static Set<SqlParams<?>> filtreToSqlparams(final FiltreForm filtreForm) { Set<SqlParams<?>> args = new HashSet<SqlParams<?>>(); int anneeDebut = filtreForm.getAnneeDebut(); if (anneeDebut > 0) { args.add( new SqlParams<Date>( dateFabrication, SUPERIOR_OR_EQUALS, CommonUtils.toSqlDate(1, 0, anneeDebut))); } int anneeFin = filtreForm.getAnneeFin(); if (anneeFin > 0) { args.add( new SqlParams<Date>( dateFabrication, INFERIOR_OR_EQUALS, CommonUtils.toSqlDate(1, 0, anneeFin))); } Set<String> couleur = filtreForm.getCouleur(); if (CommonUtils.isNotNullOrEmpty(couleur)) { args.add(new SqlParams<String>("couleur", EQUALS, couleur)); } Set<String> etat = filtreForm.getEtat(); if (CommonUtils.isNotNullOrEmpty(etat)) { args.add(new SqlParams<String>(Props.etat, EQUALS, etat)); } String marque = filtreForm.getMarque(); if (isNotNullOrEmpty(marque)) { args.add(new SqlParams<String>(Props.marque, EQUALS, marque)); } int prixMaximum = filtreForm.getPrixMaximum(); if (prixMaximum > 0) { args.add(new SqlParams<Double>(montantHt, INFERIOR_OR_EQUALS, getMontantHT(prixMaximum))); } int prixMinimum = filtreForm.getPrixMinimum(); if (prixMinimum > 0) { args.add(new SqlParams<Double>(montantHt, SUPERIOR_OR_EQUALS, getMontantHT(prixMinimum))); } Set<String> categorie = toSelection(filtreForm.getCategoriesTree()); if (CommonUtils.isNotNullOrEmpty(categorie)) { args.add(new SqlParams<String>(Props.categorie, EQUALS, categorie)); } return args; }
private static boolean isNotNullOrEmpty(final String value) { return CommonUtils.isNotNullOrEmpty(value) && !Consts.tousValue.equals(value); }