Regular Expressions 101

Save & Share

Flavor

  • PCRE2 (PHP >=7.3)
  • PCRE (PHP <7.3)
  • ECMAScript (JavaScript)
  • Python
  • Golang
  • Java 8
  • .NET 7.0 (C#)
  • Rust
  • Regex Flavor Guide

Function

  • Match
  • Substitution
  • List
  • Unit Tests

Tools

Sponsors
There are currently no sponsors. Become a sponsor today!
An explanation of your regex will be automatically generated as you type.
Detailed match information will be displayed here automatically.
  • All Tokens
  • Common Tokens
  • General Tokens
  • Anchors
  • Meta Sequences
  • Quantifiers
  • Group Constructs
  • Character Classes
  • Flags/Modifiers
  • Substitution
  • A single character of: a, b or c
    [abc]
  • A character except: a, b or c
    [^abc]
  • A character in the range: a-z
    [a-z]
  • A character not in the range: a-z
    [^a-z]
  • A character in the range: a-z or A-Z
    [a-zA-Z]
  • Any single character
    .
  • Alternate - match either a or b
    a|b
  • Any whitespace character
    \s
  • Any non-whitespace character
    \S
  • Any digit
    \d
  • Any non-digit
    \D
  • Any word character
    \w
  • Any non-word character
    \W
  • Non-capturing group
    (?:...)
  • Capturing group
    (...)
  • Zero or one of a
    a?
  • Zero or more of a
    a*
  • One or more of a
    a+
  • Exactly 3 of a
    a{3}
  • 3 or more of a
    a{3,}
  • Between 3 and 6 of a
    a{3,6}
  • Start of string
    ^
  • End of string
    $
  • A word boundary
    \b
  • Non-word boundary
    \B

Regular Expression
No Match

/
/
gm

Test String

Code Generator

Language

Generated Code

# coding=utf8 # the above tag defines encoding for this document and is for Python 2.x compatibility import re regex = r"(?s)(catch[^}]*?){(?:(?!\bthrow|new\b).)+?}" test_str = ("package fr.icdc.dei.aej.persistence.service.impl;\n\n" "import java.math.BigInteger;\n" "import java.util.ArrayList;\n" "import java.util.Calendar;\n" "import java.util.Comparator;\n" "import java.util.Date;\n" "import java.util.HashMap;\n" "import java.util.LinkedList;\n" "import java.util.List;\n" "import java.util.Map;\n" "import java.util.Set;\n" "import java.util.TreeSet;\n\n" "import org.hibernate.Query;\n" "import org.hibernate.QueryException;\n\n" "import fr.icdc.dei.aej.metier.AejColonneTriConstant;\n" "import fr.icdc.dei.aej.metier.AejConstant;\n" "import fr.icdc.dei.aej.metier.comparator.InjonctionComparator;\n" "import fr.icdc.dei.aej.metier.entite.lipti.EnTeteFlux;\n" "import fr.icdc.dei.aej.metier.entite.lipti.FichierLIPTI;\n" "import fr.icdc.dei.aej.metier.entite.lipti.InjonctionDePayer;\n" "import fr.icdc.dei.aej.metier.entite.lipti.InjonctionDePayerClose;\n" "import fr.icdc.dei.aej.metier.service.dto.ColonneNombreRenvoisCompetenceDTO;\n" "import fr.icdc.dei.aej.metier.service.dto.ColonneNombreSaisinesDirectesDTO;\n" "import fr.icdc.dei.aej.metier.service.dto.ComptageEnAttenteDecisionDTO;\n" "import fr.icdc.dei.aej.metier.service.dto.InformationTriColonneDTO;\n" "import fr.icdc.dei.aej.metier.service.dto.InformationsListePagineeDTO;\n" "import fr.icdc.dei.aej.metier.service.dto.NombreAffairesParOrigineCreanceDTO;\n" "import fr.icdc.dei.aej.metier.service.dto.NombreAffairesParTimbreDTO;\n" "import fr.icdc.dei.aej.persistence.service.InjonctionDePayerPersistenceService;\n" "import fr.icdc.dei.aej.persistence.util.AejPersistenceUtil;\n" "import fr.icdc.dei.aej.state.StateConstants;\n" "import fr.icdc.dei.fwk.business.exception.PersistenceServiceException;\n" "import fr.icdc.dei.fwk.connection.impl.hibernate.HibernateConnection;\n" "import fr.icdc.dei.fwk.transaction.TransactionException;\n" "/**\n" " * Injonction_de_Payer.<br>\n" " * <!-- begin-user-doc --><br>\n" " * <!-- end-user-doc -->\n" " * \n" " * @generated\n" " */\n" "@SuppressWarnings(\"unchecked\")\n" "public final class InjonctionDePayerPersistenceServiceImpl\n" " extends\n" " AbstractAejPersistenceService\n" " implements\n" " InjonctionDePayerPersistenceService {\n\n" " public InjonctionDePayer recupererIPParEnteteFlux(\n" " final EnTeteFlux enteteFlux) throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " InjonctionDePayer result = null;\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n" " final Query query =\n" " hConnection.getNamedQuery(\"recupererIPParEnteteFlux\");\n\n" " query.setString(\"numRG\", enteteFlux.getNumRG());\n" " query.setString(\"siret\", enteteFlux.getSiretTI());\n" " query.setString(\"idAffaireHuissier\", enteteFlux\n" " .getIdAffaireHuissier());\n\n" " final List<InjonctionDePayer> listInjonction = query.list();\n" " if (listInjonction.size() > 0) {\n" " result = listInjonction.iterator().next();\n" " }\n\n" " // end-user-code\n" " return result;\n" " } catch (final TransactionException e) {\n" " PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " /**\n" " * Recupere une injonction close à partir de l'en tete Flux en parametre\n" " * @param enteteFlux\n" " * @return\n" " * @throws PersistenceServiceException\n" " */\n" " public InjonctionDePayerClose recupererIPCloseParEnteteFlux(\n" " final EnTeteFlux enteteFlux) throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " InjonctionDePayerClose result = null;\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n" " final Query query =\n" " hConnection.getNamedQuery(\"recupererIPCloseParEnteteFlux\");\n\n" " query.setString(\"numRG\", enteteFlux.getNumRG());\n" " query.setString(\"siret\", enteteFlux.getSiretTI());\n" " query.setString(\"idAffaireHuissier\", enteteFlux\n" " .getIdAffaireHuissier());\n\n" " final List<InjonctionDePayerClose> listInjonction = query.list();\n" " if (listInjonction.size() > 0) {\n" " result = listInjonction.iterator().next();\n" " }\n\n" " // end-user-code\n" " return result;\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " \n" " /**\n" " * Mot clef SQL / HQL WHERE\n" " */\n" " private static final String WHERE = \"WHERE\";\n\n" " /**\n" " * \n" " */\n" " public Integer compterInjonctionsParEtatEtParRegistrePourDecisionnaire(\n" " final String identifiantDecisionnaire, final Integer registre,\n" " final String siretJuridiction, final String etatDemande)\n" " throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " Integer result = null;\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n" " final Query queryHibernate =\n" " hConnection\n" " .getNamedQuery(\"compterInjonctionsParEtatEtParRegistrePourDecisionnaire\");\n" " if (registre != null) {\n" " queryHibernate.setInteger(\"registre\", registre);\n" " }\n" " queryHibernate.setString(AejConstant.SIRET_JURIDICTION, siretJuridiction);\n" " queryHibernate.setString(\"etatDemande\", etatDemande);\n" " queryHibernate.setParameter(\"identifiantDecisionnaire\",\n" " identifiantDecisionnaire);\n\n" " result = (Integer) queryHibernate.uniqueResult();\n" " return result;\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // verification de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " /**\n" " * \n" " */\n" " public Integer compterInjonctionsParEtatEtParRegistre(\n" " final Integer registre, final String siretJuridiction,\n" " final String etatDemande) throws PersistenceServiceException {\n" " Integer result = null;\n" " HibernateConnection hConnection = null;\n" " // begin-user-code\n" " try {\n" " hConnection = (HibernateConnection) getConnection();\n\n" " final Query queryHibernate =\n" " hConnection\n" " .getNamedQuery(\"compterInjonctionsParEtatEtParRegistre\");\n\n" " queryHibernate.setString(\"etatDemande\", etatDemande);\n" " if (registre != null) {\n" " queryHibernate.setInteger(\"registre\", registre);\n" " }\n" " queryHibernate.setString(AejConstant.SIRET_JURIDICTION, siretJuridiction);\n\n" " result = (Integer) queryHibernate.uniqueResult();\n" " return result;\n" " // end-user-code\n" " } catch (final QueryException e) {\n" " throw new PersistenceServiceException(e);\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // verification de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " /**\n" " * \n" " */\n" " public List<ComptageEnAttenteDecisionDTO> genererSyntheseEnAttenteDecision(\n" " final String siretJuridiction) throws PersistenceServiceException {\n" " List<ComptageEnAttenteDecisionDTO> result = null;\n" " HibernateConnection hConnection = null;\n" " // begin-user-code\n" " try {\n" " hConnection = (HibernateConnection) getConnection();\n\n" " final Query query =\n" " hConnection\n" " .getNamedQuery(\"genererSyntheseEnAttenteDecision\");\n" " query.setString(\"etat\", StateConstants.ETAT_ATTENTE_DECISION);\n" " query.setString(AejConstant.SIRET_JURIDICTION, siretJuridiction);\n" " final List<Object[]> listeInter = query.list();\n" " result = new ArrayList<ComptageEnAttenteDecisionDTO>();\n" " for (final Object[] objects : listeInter) {\n" " final ComptageEnAttenteDecisionDTO comptage =\n" " new ComptageEnAttenteDecisionDTO();\n" " if (objects[0] == null) {\n" " comptage.setNomJuge(\"\");\n" " } else {\n" " comptage.setNomJuge((String) objects[0]);\n" " }\n" " if (objects[1] == null) {\n" " comptage.setPrenomJuge(\"\");\n" " } else {\n" " comptage.setPrenomJuge((String) objects[1]);\n" " }\n" " if (objects[2] == null) {\n" " comptage.setNombreAffaires(0);\n" " } else {\n" " comptage.setNombreAffaires((Integer) objects[2]);\n" " }\n\n" " result.add(comptage);\n" " }\n" " return result;\n" " // end-user-code\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // verification de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " /**\n" " * \n" " * \n" " */\n" " public java.util.List<InjonctionDePayer> listerDemandesParEtat(\n" " final InformationsListePagineeDTO informationsListePaginee,\n" " final Integer registre, final String siretJuridiction,\n" " final String etatDemande) throws PersistenceServiceException {\n" " java.util.List<InjonctionDePayer> result = null;\n" " // begin-user-code\n" " try {\n" " Map<String, Object> parametres = getParametresEtatSiretRegistre(siretJuridiction, registre, etatDemande);\n" " \n" " String namedQueryId = \"listerIdDemandeParEtat\";\n" " String namedQuery = \"listerDemandesParEtat\";\n" " String namedQuery3 = \"listerDemandesParEtat3\";\n" " \n" " if (AejColonneTriConstant.DATE_TRANSMIS.equals(informationsListePaginee.getColonneTri())) {\n" " \n" " result = getResultDateTransmis(informationsListePaginee, parametres, namedQueryId, namedQuery);\n\n" " } else if (AejColonneTriConstant.SOMME.equals(informationsListePaginee.getColonneTri())) {\n" " result = getResultSomme(informationsListePaginee, parametres,namedQueryId, namedQuery);\n" " } else {\n" " getColonneTriDecisionnaire(informationsListePaginee);\n" " result = getListePaginee(namedQueryId, namedQuery3, parametres, informationsListePaginee);\n" " }\n" " } catch (TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " }\n\n" " return result;\n" " }\n\n" " /**\n" " * Recupere le resultat dans le cas des sommes\n" " * \n" " * @param informationsListePaginee\n" " * informations sur la liste paginéee\n" " * @param parametres\n" " * les parametres a positionner\n" " * @return le resultat\n" " * @throws TransactionException\n" " * @throws TransactionException\n" " * exception transactionnelle\n" " */\n\n" " private java.util.List<InjonctionDePayer> getResultSomme(\n" " final InformationsListePagineeDTO informationsListePaginee,\n" " final Map<String, Object> parametres, final String pQueryId,\n" " final String pQuery) throws TransactionException {\n" " java.util.List<InjonctionDePayer> result;\n" " final HibernateConnection hConnection =\n" " (HibernateConnection) getConnection();\n" " final List<Integer> listId =\n" " hConnection.findByNamedQuery(pQueryId, parametres);\n" " final Query query = hConnection.getNamedQuery(pQuery);\n" " query.setParameterList(\"listeId\", listId);\n" " result = query.list();\n" " final Set<InjonctionDePayer> setTrie =\n" " new TreeSet<InjonctionDePayer>(new InjonctionComparator(\n" " AejColonneTriConstant.SOMME, informationsListePaginee\n" " .getAscendant()));\n" " setTrie.addAll(result);\n" " result = new ArrayList<InjonctionDePayer>(setTrie);\n" " return getPagination(informationsListePaginee, result);\n" " }\n\n" " /**\n" " * Pagine la liste passé en parametre\n" " * \n" " * @param informationsListePaginee\n" " * les informations concernant la liste paginé\n" " * @param result\n" " * la liste\n" " * @return\n" " */\n" " private java.util.List<InjonctionDePayer> getPagination(\n" " final InformationsListePagineeDTO informationsListePaginee,\n" " final List<InjonctionDePayer> result) {\n" " final int fromIndex = informationsListePaginee.getStart();\n\n" " int toIndex = informationsListePaginee.getNombre() + fromIndex;\n" " if (toIndex > result.size()) {\n" " toIndex = result.size();\n" " }\n" " return result.subList(fromIndex, toIndex);\n" " }\n" " /**\n" " * Recupere la colonne a trier\n" " * <ul>\n" " * <li>injonction de payer : ip</li>\n" " * <li>etats en cours : etatEnCours</li>\n" " * <li>enregistre : enreg</li>\n" " * </ul>\n" " * \n" " * @param colonneTriInfoPaginee\n" " * le nom de la colonne a trié\n" " * @return la colonne a trié + le nom de l'objet sur lequel on trie\n" " */\n" " private String getColonneTri(final String colonneTriInfoPaginee) {\n" " final String colTri;\n" " if (AejColonneTriConstant.NUM_RG.equals(colonneTriInfoPaginee)) {\n" " colTri = \"enreg.\" + AejColonneTriConstant.NUM_RG;\n" " } else if (AejColonneTriConstant.DATE_SAISINE.equals(colonneTriInfoPaginee)) {\n" " colTri = \"ip.\" + colonneTriInfoPaginee;\n" " } else if (AejColonneTriConstant.DATE_SAISIE.equals(colonneTriInfoPaginee)) {\n" " colTri = \"ip.\" + colonneTriInfoPaginee;\n" " } else if (AejColonneTriConstant.FLUX_DEMAT.equals(colonneTriInfoPaginee)) {\n" " colTri = \"ip.\" + colonneTriInfoPaginee;\n" " } else if (AejColonneTriConstant.RENVOI_COMP.equals(colonneTriInfoPaginee)) {\n" " colTri = \"ip.\" + colonneTriInfoPaginee;\n" " } else if (AejColonneTriConstant.DATE_EXECUTOIRE.equals(colonneTriInfoPaginee)) {\n" " colTri = \"ip.\" + colonneTriInfoPaginee;\n" " } else if (AejColonneTriConstant.REQUETE.equals(colonneTriInfoPaginee)) {\n" " colTri = \"ip.\" + colonneTriInfoPaginee;\n" " } else if (AejColonneTriConstant.JOURS_RESTANTS.equals(colonneTriInfoPaginee)) {\n" " colTri = \"ip.dateFinLegalDemandeExecutoire\";\n" " } else if (AejColonneTriConstant.SIMILARITE.equals(colonneTriInfoPaginee)) {\n" " colTri = \"similarites.id\";\n" " } else if (AejColonneTriConstant.DECISION.equals(colonneTriInfoPaginee)) {\n" " colTri = \"decision.\" + AejColonneTriConstant.DECISION;\n" " } else if (AejColonneTriConstant.DATE_DECISION.equals(colonneTriInfoPaginee)) {\n" " colTri = \"decision.\" + AejColonneTriConstant.DATE_DECISION;\n" " } else if (AejColonneTriConstant.DATE_DEMANDE.equals(colonneTriInfoPaginee)) {\n" " colTri = \"dpo.\" + AejColonneTriConstant.DATE_DEMANDE;\n" " } else if (AejColonneTriConstant.NATURE_CREANCE.equals(colonneTriInfoPaginee)) {\n" " colTri = \"natureCreance.\" + AejColonneTriConstant.NATURE_CREANCE;\n" " } else if (AejColonneTriConstant.DATE_TRANSMIS.equals(colonneTriInfoPaginee)) {\n" " colTri = \"etatsAttente.\" + AejColonneTriConstant.DATE_TRANSMIS;\n" " } else if (AejColonneTriConstant.SUIVI_PAR.equals(colonneTriInfoPaginee)) {\n" " colTri = \"concat(substring(etatEnCours.utilisateur.prenom,1,1),substring(etatEnCours.utilisateur.nom,1,2))\";\n" " } else if (AejColonneTriConstant.MANDATAIRE.equals(colonneTriInfoPaginee)) {\n" " colTri = \"coalesce(mandaPP.nomDeFamille,mandaPM.denomination)\";\n" " } else if (AejColonneTriConstant.DEBITEUR.equals(colonneTriInfoPaginee)) {\n" " colTri = \"coalesce(debitPP.nomDeFamille,debitPM.denomination)\";\n" " } else if (AejColonneTriConstant.CREANCIER.equals(colonneTriInfoPaginee)) {\n" " colTri = \"coalesce(creancPP.nomDeFamille,creancPM.denomination)\";\n" " } else if (AejColonneTriConstant.DATE_SIGNIFICATION\n" " .equals(colonneTriInfoPaginee)) {\n" " colTri = \"deb.\" + AejColonneTriConstant.DATE_SIGNIFICATION;\n" " } else if (AejColonneTriConstant.HUISSIER_SIGNIFIANT.equals(colonneTriInfoPaginee)) {\n" " colTri = \"deb.\" + AejColonneTriConstant.HUISSIER_SIGNIFIANT;\n" " } else if (AejColonneTriConstant.DATE_DEMANDE_PIECE.equals(colonneTriInfoPaginee)) {\n" " colTri = \"dpo.dateDemande\";\n" " } else if (AejColonneTriConstant.RETARD.equals(colonneTriInfoPaginee)) {\n" " colTri = \"dpo.\" + AejColonneTriConstant.RETARD;\n" " } else if (AejColonneTriConstant.DATE_PIECE_ARRIVEE.equals(colonneTriInfoPaginee)) {\n" " colTri = \"dpo.\" + AejColonneTriConstant.DATE_PIECE_ARRIVEE;\n" " } else if (AejColonneTriConstant.NUM_PORTALIS.equals(colonneTriInfoPaginee)) {\n" " colTri = \"enreg.\" + AejColonneTriConstant.NUM_PORTALIS;\n" " }else {\n" " colTri = \"\";\n" " }\n" " return colTri;\n" " }\n" " /**\n" " * Renvoit la map de parametre contenant etat, siret et registre\n" " * \n" " * @param siretJuridiction\n" " * @param registre\n" " * @param etat\n" " * @return\n" " */\n" " private Map<String, Object> getParametresEtatSiretRegistre(\n" " final String siretJuridiction, final Integer registre,\n" " final String etat) {\n" " final Map<String, Object> parametres = new HashMap<String, Object>();\n" " parametres.put(\"registre\", registre);\n" " parametres.put(AejConstant.SIRET_JURIDICTION, siretJuridiction);\n" " parametres.put(\"etat\", etat);\n" " return parametres;\n" " }\n\n" " /**\n" " * Méthode retournant le resultat concernant une liste paginée\n" " * \n" " * @param <E>\n" " * @param namedQueryId\n" " * la query définit dans un hibernate qui remonte la liste des id\n" " * @param namedQuery\n" " * la query definit dans un hibernate qui remonte la liste des\n" " * objets\n" " * @param parametres\n" " * une map de parametre ou la clef est le nom du parametre et la\n" " * valeur la valeur du parametre\n" " * @param colTri\n" " * @param start\n" " * @param nombre\n" " * @param isTriFinal\n" " * @return la liste d'objet représentant la liste paginée\n" " * @throws TransactionException\n" " */\n" " private <E> List<E> getListePaginee(final String namedQueryId,\n" " final String namedQuery, final Map<String, Object> parametres,\n" " final InformationsListePagineeDTO informationsListePaginee,\n" " final boolean isTriFinal) throws TransactionException {\n" " final HibernateConnection hConnection = (HibernateConnection) getConnection();\n" " \n" " final List<E> listeResult = AejPersistenceUtil.getListePaginee( hConnection, \n" " namedQueryId, \n" " namedQuery, \n" " parametres, \n" " informationsListePaginee,\n" " isTriFinal);\n" " // verification de la connexion\n" " if (hConnection != null) {\n" " // fermeture de la connexion\n" " hConnection.silentClose();\n" " }\n" " return listeResult;\n" " }\n" " /**\n" " * \n" " * @param <E>\n" " * @param queryId\n" " * @param namedQuery\n" " * @param parametres\n" " * @param informationsListePaginee\n" " * @param isTriFinal\n" " * @return\n" " * @throws TransactionException\n" " */\n" " private <E> List<E> getListePaginee(final Query queryId,\n" " final String namedQuery, final Map<String, Object> parametres,\n" " final InformationsListePagineeDTO informationsListePaginee,\n" " final boolean isTriFinal) throws TransactionException {\n" " final HibernateConnection hConnection =\n" " (HibernateConnection) getConnection();\n" " final List<E> listeResult =\n" " AejPersistenceUtil.getListePaginee(hConnection, queryId,\n" " namedQuery, parametres, informationsListePaginee,\n" " isTriFinal);\n\n" " // verification de la connexion\n" " if (hConnection != null) {\n" " // fermeture de la connexion\n" " hConnection.silentClose();\n" " }\n" " return listeResult;\n" " }\n" " /**\n" " * \n" " * @param <E>\n" " * @param namedQueryId\n" " * @param namedQuery\n" " * @param parametres\n" " * @param informationsListePaginee\n" " * @return\n" " * @throws TransactionException\n" " */\n" " private <E> List<E> getListePaginee(final String namedQueryId,\n" " final String namedQuery, final Map<String, Object> parametres,\n" " final InformationsListePagineeDTO informationsListePaginee)\n" " throws TransactionException {\n" " return getListePaginee(namedQueryId, namedQuery, parametres,informationsListePaginee, true);\n" " }\n" " \n" " /**\n" " * Retourne le resultat pour une date de transmission\n" " * \n" " * @param informationsListePaginee\n" " * les informations sur la liste paginées\n" " * @param parametres\n" " * les parametres nommées\n" " * @return le resultat pour une date de transmission\n" " * @throws TransactionException\n" " * exception transactionelle\n" " */\n" " private java.util.List<InjonctionDePayer> getResultDateTransmis(\n" " final InformationsListePagineeDTO informationsListePaginee,\n" " final Map<String, Object> parametres, final String pRequeteId,\n" " final String pRequete) throws TransactionException {\n" " java.util.List<InjonctionDePayer> result;\n" " final HibernateConnection hConnection =(HibernateConnection) getConnection();\n" " getColonneTriDecisionnaire(informationsListePaginee);\n" " final StringBuilder requeteId = new StringBuilder(hConnection.getNamedQuery(pRequeteId).getQueryString());\n" " requeteId.insert(requeteId.indexOf(WHERE), \" LEFT JOIN ip.etats etatsAttente \");\n" " requeteId.append(\" AND etatsAttente.etat = :etatAttente \");\n" " final Query queryId = hConnection.createQuery(requeteId.toString());\n" " parametres.put(\"etatAttente\", StateConstants.ETAT_ATTENTE_DECISION);\n" " result = getListePaginee(queryId, pRequete, parametres, informationsListePaginee, false);\n" " \n" " final Set<InjonctionDePayer> setTrie =\n" " new TreeSet<InjonctionDePayer>(new InjonctionComparator(\n" " AejColonneTriConstant.DATE_TRANSMIS,\n" " informationsListePaginee.getAscendant()));\n" " setTrie.addAll(result);\n" " result = new ArrayList<InjonctionDePayer>(setTrie);\n" " return result;\n" " }\n\n" " /**\n" " * Le parametre est modifié par cette méthode\n" " * \n" " * @param informationsListePaginee\n" " * les informations concernant la pagination\n" " */\n" " private void getColonneTriDecisionnaire(\n" " final InformationsListePagineeDTO informationsListePaginee) {\n" " final String colonneTri = informationsListePaginee.getColonneTri();\n\n" " // Le décisionnaire oblige a faire un tri sur 2 colonnes, c'est donc\n" " // un cas particulier\n" " if (AejColonneTriConstant.DECISIONNAIRE.equals(colonneTri)) {\n" " final List<InformationTriColonneDTO> listInfoDTO = new ArrayList<InformationTriColonneDTO>();\n" " listInfoDTO.add(new InformationTriColonneDTO(\"distrib.nom\",informationsListePaginee.getAscendant()));\n" " listInfoDTO.add(new InformationTriColonneDTO(\"distrib.prenom\", informationsListePaginee.getAscendant()));\n" " informationsListePaginee.setListeInformationsTriColonnes(listInfoDTO);\n" " } else {\n" " final String colTri = getColonneTri(colonneTri);\n" " informationsListePaginee.setColonneTri(colTri);\n" " }\n" " }\n" " /**\n" " * \n" " */\n" " public void creerInjonctionPayer(final InjonctionDePayer injonctionPayer)\n" " throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " // begin-user-code\n" " try {\n" " hConnection = (HibernateConnection) getConnection();\n" " hConnection.create(injonctionPayer);\n" " // end-user-code\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // verification de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " \n" " /**\n" " * creerInjonctionPayerClose\n" " * @param injonctionPayerClose\n" " * @throws PersistenceServiceException\n" " */\n" " public void creerInjonctionPayerClose(final InjonctionDePayerClose injonctionPayerClose)\n" " throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " // begin-user-code\n" " try {\n" " hConnection = (HibernateConnection) getConnection();\n" " hConnection.create(injonctionPayerClose);\n" " // end-user-code\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // verification de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n\n" " public void modifierInjonctionPayer(final InjonctionDePayer injonctionPayer)\n" " throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " // begin-user-code\n" " try {\n" " hConnection = (HibernateConnection) getConnection();\n" " hConnection.update(injonctionPayer);\n" " // end-user-code\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // verification de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " \n" " \n" " public void modifierInjonctionPayerClose(final InjonctionDePayerClose injonctionPayerClose)\n" " throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " // begin-user-code\n" " try {\n" " hConnection = (HibernateConnection) getConnection();\n" " hConnection.update(injonctionPayerClose);\n" " // end-user-code\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // verification de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " \n" " public void supprimer(final InjonctionDePayer injonctionPayer)\n" " throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " // begin-user-code\n" " try {\n" " hConnection = (HibernateConnection) getConnection();\n" " hConnection.delete(injonctionPayer);\n" " // end-user-code\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // verification de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " \n" " \n" " }\n" " \n" " /**\n" " * Supprimer l'IP active\n" " * @param injonctionPayer\n" " * @throws PersistenceServiceException\n" " */\n" " public void supprimerIPActive(final InjonctionDePayer injonctionPayer)\n" " throws PersistenceServiceException { \n\n" " HibernateConnection hConnection = null;\n" " // begin-user-code\n" " try {\n" " hConnection = (HibernateConnection) getConnection();\n" " final Query query = hConnection\n" " .getNamedQuery(\"deleteInjonctionDePayerById\");\n" " query.setInteger(\"identifiantIP\", injonctionPayer.getId());\n\n" " query.executeUpdate();\n" " // end-user-code\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // verification de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " \n" " /**\n" " * Supprimer l'IP close\n" " * @param injonctionPayerClose\n" " * @throws PersistenceServiceException\n" " */\n" " public void supprimerIPClose(final InjonctionDePayerClose injonctionPayerClose)\n" " throws PersistenceServiceException { \n\n" " HibernateConnection hConnection = null;\n" " // begin-user-code\n" " try {\n" " hConnection = (HibernateConnection) getConnection();\n" " final Query query = hConnection\n" " .getNamedQuery(\"deleteInjonctionDePayerCloseById\");\n" " query.setInteger(\"identifiantIP\", injonctionPayerClose.getId());\n\n" " query.executeUpdate();\n" " // end-user-code\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // verification de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " \n" " public void supprimerIPCloseDemat(final InjonctionDePayerClose injonctionPayer)\n" " throws PersistenceServiceException { \n" " \n" " HibernateConnection hConnection = null;\n" " // begin-user-code\n" " try {\n" " hConnection = (HibernateConnection) getConnection();\n" " final Query query = hConnection\n" " .getNamedQuery(\"supprimerIPCloseEtPJ\");\n" " query.setInteger(\"identifiantIP\", injonctionPayer.getId());\n" " \n" " query.executeUpdate();\n" " // end-user-code\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // verification de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " \n" " /**\n" " * \n" " * @param idTechniqueInjonctionPayer\n" " * @return\n" " * @throws PersistenceServiceException\n" " */\n" " public InjonctionDePayer recupererInjonctionParIdentifiant(final String idTechniqueInjonctionPayer)\n" " throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " hConnection = (HibernateConnection) getConnection();\n" " final Integer idInjonctionPayerInt =Integer.valueOf(idTechniqueInjonctionPayer);\n" " return (InjonctionDePayer) hConnection.get(InjonctionDePayer.class, idInjonctionPayerInt);\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " \n" " /**\n" " * \n" " * @param idTechniqueInjonctionPayerClose\n" " * @return\n" " * @throws PersistenceServiceException\n" " */\n" " public InjonctionDePayerClose recupererInjonctionCloseParIdentifiant(final String idTechniqueInjonctionPayerClose)\n" " throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " hConnection = (HibernateConnection) getConnection();\n" " final Integer idInjonctionPayerInt =Integer.valueOf(idTechniqueInjonctionPayerClose);\n" " return (InjonctionDePayerClose) hConnection.get(InjonctionDePayerClose.class, idInjonctionPayerInt);\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " /**\n" " * \n" " */\n" " public java.util.List<NombreAffairesParOrigineCreanceDTO> recupererListeNombresAffairesRegroupeesParOrigineCreance(\n" " final Date dateDebut, final Date dateFin, final String registre,\n" " final String juridiction) throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " java.util.List<NombreAffairesParOrigineCreanceDTO> result = null;\n" " \n" " Map<String, NombreAffairesParOrigineCreanceDTO> map = new HashMap<String, NombreAffairesParOrigineCreanceDTO>();\n" " \n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n\n" " result =\n" " new java.util.ArrayList<NombreAffairesParOrigineCreanceDTO>();\n\n" " Query query =\n" " hConnection\n" " .getNamedQuery(\"recupererListeNombresAffairesRegroupeesParOrigineCreance\");\n\n" " // ajout des paramètres\n\n" " query.setString(\"registre\", registre);\n" " query.setString(AejConstant.SIRET_JURIDICTION, juridiction);\n" " query.setDate(\"dateDebut\", dateDebut);\n" " query.setDate(\"dateFin\", dateFin);\n\n" " List<Object[]> listeObjets = query.list();\n" " // ajout des résultats dans l'objet retourné\n\n" " for (final Object[] objet : listeObjets) {\n" " final NombreAffairesParOrigineCreanceDTO dto =\n" " new NombreAffairesParOrigineCreanceDTO();\n\n" " dto.setNombre((Integer) objet[1]);\n" " dto.setOrigineCreance((String) objet[0]);\n" " //result.add(dto);\n" " //ajout du dto dans la map\n" " map.put(dto.getOrigineCreance(), dto);\n" " }\n" " \n" " /* recuperation des affaires clôturées avec les mêmes critères */\n" " \n" " query =\n" " hConnection\n" " .getNamedQuery(\"recupererListeNombresAffairesClotureesRegroupeesParOrigineCreance\");\n" " \n" " // ajout des paramètres\n" " \n" " query.setString(\"registre\", registre);\n" " query.setString(AejConstant.SIRET_JURIDICTION, juridiction);\n" " query.setDate(\"dateDebut\", dateDebut);\n" " query.setDate(\"dateFin\", dateFin);\n" " \n" " listeObjets = query.list();\n" " // ajout des résultats dans l'objet retourné\n" " \n" " for (final Object[] objet : listeObjets) {\n" " final NombreAffairesParOrigineCreanceDTO dto =\n" " new NombreAffairesParOrigineCreanceDTO();\n" " \n" " dto.setNombre((Integer) objet[1]);\n" " dto.setOrigineCreance((String) objet[0]);\n" " \n" " //si origine creance deja referencee sur ip ouverte => mise à jour du décompte et suppression de l'ancien dto\n" " if(map.get(dto.getOrigineCreance())!=null){\n" " dto.setNombre(dto.getNombre() + ((NombreAffairesParOrigineCreanceDTO)map.get(dto.getOrigineCreance())).getNombre());\n" " map.remove(dto.getOrigineCreance());\n" " }\n\n" " //ajout du dto dans la map\n" " map.put(dto.getOrigineCreance(), dto);\n" " }\n" " \n" " result.addAll(map.values());\n\n" " // end-user-code\n" " return result;\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " /**\n" " * récupère la liste des affaire ouvertes avec timbre non nul et date d'application dans la période regroupé par libellé de timbre\n" " * @param dateDebut\n" " * @param dateFin\n" " * @param registre\n" " * @param juridiction\n" " * @return\n" " * @throws PersistenceServiceException\n" " */\n" " public java.util.List<NombreAffairesParTimbreDTO> recupererListeNombresAffairesOuvertesRegroupeesParTimbre(\n" " final Date dateDebut, final Date dateFin, final String registre,\n" " final String juridiction) throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " java.util.List<NombreAffairesParTimbreDTO> result = null;\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n\n" " result =\n" " new java.util.ArrayList<NombreAffairesParTimbreDTO>();\n\n" " final Query query =\n" " hConnection\n" " .getNamedQuery(\"recupererListeNombresAffairesOuvertesRegroupeesParTimbre\");\n\n" " // ajout des paramètres\n\n" " query.setString(\"registre\", registre);\n" " query.setString(AejConstant.SIRET_JURIDICTION, juridiction);\n" " query.setDate(\"dateDebut\", dateDebut);\n" " query.setDate(\"dateFin\", dateFin);\n" " //sélection des affaires ouvertes (non clôturées) \n" " query.setString(\"etat\", StateConstants.ETAT_CLOTUREE);\n\n" " final List<Object[]> listeObjets = query.list();\n" " // ajout des résultats de l'objet retourné\n\n" " for (final Object[] objet : listeObjets) {\n" " final NombreAffairesParTimbreDTO dto = new NombreAffairesParTimbreDTO();\n" " \n" " if(objet[1] instanceof Integer){\n" " dto.setNombreIPEnCours((Integer) objet[1]);\n" " } else if(objet[1] instanceof BigInteger){\n" " dto.setNombreIPEnCours((Integer) ((BigInteger)objet[1]).intValue());\n" " }\n" " dto.setLibelleTimbre((String) objet[0]);\n" " result.add(dto);\n" " }\n\n" " // end-user-code\n" " return result;\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " \n" " /**\n" " * récupère la liste des affaire cloturees avec timbre non nul et date d'application dans la période regroupé par libellé de timbre\n" " * @param dateDebut\n" " * @param dateFin\n" " * @param registre\n" " * @param juridiction\n" " * @return\n" " * @throws PersistenceServiceException\n" " */\n" " public java.util.List<NombreAffairesParTimbreDTO> recupererListeNombresAffairesClotureesRegroupeesParTimbre(\n" " final Date dateDebut, final Date dateFin, final String registre,\n" " final String juridiction) throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " java.util.List<NombreAffairesParTimbreDTO> result = null;\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n\n" " result =\n" " new java.util.ArrayList<NombreAffairesParTimbreDTO>();\n\n" " final Query query =\n" " hConnection\n" " .getNamedQuery(\"recupererListeNombresAffairesClotureesRegroupeesParTimbre\");\n\n" " // ajout des paramètres\n\n" " query.setString(\"registre\", registre);\n" " query.setString(AejConstant.SIRET_JURIDICTION, juridiction);\n" " query.setDate(\"dateDebut\", dateDebut);\n" " query.setDate(\"dateFin\", dateFin);\n" " //sélection des affaires cloturées \n" " query.setString(\"etat\", StateConstants.ETAT_CLOTUREE);\n\n" " final List<Object[]> listeObjets = query.list();\n" " // ajout des résultats de l'objet retourné\n\n" " for (final Object[] objet : listeObjets) {\n" " final NombreAffairesParTimbreDTO dto = new NombreAffairesParTimbreDTO();\n" " \n" " if(objet[1] instanceof Integer){\n" " dto.setNombreIPCloses((Integer) objet[1]);\n" " } else if(objet[1] instanceof BigInteger){\n" " dto.setNombreIPCloses((Integer) ((BigInteger)objet[1]).intValue());\n" " }\n" " dto.setLibelleTimbre((String) objet[0]);\n" " result.add(dto);\n" " }\n\n" " // end-user-code\n" " return result;\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n\n" " public Integer compterAffairesEnOppositionPourDecisionsRendues(\n" " final String registre, final Date dateDebut, final Date dateFin,\n" " final String juridiction) throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " Integer result = null;\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n\n" " // cette méthode récupère le nombre d 'affaires en opposition\n" " // pour le registre sélectionné ayant au mois une date d'opposition\n" " // incluse\n" " // dans la période choisie\n\n" " final Query query =\n" " hConnection\n" " .getNamedQuery(\"compterAffairesEnOppositionPourDecisionsRendues\");\n\n" " query.setString(\"registre\", registre);\n" " query.setString(AejConstant.SIRET_JURIDICTION, juridiction);\n\n\n" " query.setDate(\"dateDebut\", dateDebut);\n" " query.setDate(\"dateFin\", dateFin);\n" " \n" " /* recuperation nombre d'affaires en opposition dans les ip closes */\n" " final Query queryClos =\n" " hConnection\n" " .getNamedQuery(\"compterAffairesEnOppositionPourDecisionsRenduesIPClose\");\n\n" " queryClos.setString(\"registre\", registre);\n" " queryClos.setString(AejConstant.SIRET_JURIDICTION, juridiction);\n" " \n" " \n" " queryClos.setDate(\"dateDebut\", dateDebut);\n" " queryClos.setDate(\"dateFin\", dateFin);\n\n" " result = (Integer) query.uniqueResult() + (Integer) queryClos.uniqueResult();\n\n" " // end-user-code\n" " return result;\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n\n" " public Integer compterAffairesEnRenvoiCompetence(final Date dateDebut,\n" " final Date dateFin, final String juridiction)\n" " throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " Integer result = null;\n" " // begin-user-code\n\n" " hConnection = (HibernateConnection) getConnection();\n\n" " /*\n" " * évol 21 il s'agit du nombre d'injonctions qui ont une date de\n" " * renvoi de compétence dans la période registre 95 pour la\n" " * juridiction\n" " */\n\n" " final Query query =\n" " hConnection\n" " .getNamedQuery(\"compterAffairesEnRenvoiCompetence\");\n\n" " query.setString(\"registre\", AejConstant.REG_95);\n" " query.setString(AejConstant.SIRET_JURIDICTION, juridiction);\n\n" " // modification de la date de fin à passer à la persistance pour\n" " // prendre en compte le dernier jour en entier\n" " final Calendar cal = Calendar.getInstance();\n" " cal.setTime(dateFin);\n" " cal.add(Calendar.DAY_OF_MONTH, 1);\n" " final Date dateFinPersistence = cal.getTime();\n\n" " query.setDate(\"dateDebut\", dateDebut);\n" " query.setDate(\"dateFin\", dateFinPersistence);\n" " \n" " /*\n" " * recuperation du nombre d'injonctions closes qui ont une date de\n" " * renvoi de compétence dans la période registre 95 pour la\n" " * juridiction\n" " */\n" " final Query queryClos =\n" " hConnection\n" " .getNamedQuery(\"compterAffairesEnRenvoiCompetenceIPClose\");\n\n" " queryClos.setString(\"registre\", AejConstant.REG_95);\n" " queryClos.setString(AejConstant.SIRET_JURIDICTION, juridiction);\n" " //sur la meme periode\n" " queryClos.setDate(\"dateDebut\", dateDebut);\n" " queryClos.setDate(\"dateFin\", dateFinPersistence);\n\n" " result = (Integer) query.uniqueResult() + (Integer) queryClos.uniqueResult();\n\n" " // end-user-code\n" " return result;\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n\n" " public java.util.List<InjonctionDePayer> listerAffairesNouvelles(\n" " final String registre, final String juridiction,\n" " final Date dateDebut, final Date dateFin)\n" " throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " java.util.List<InjonctionDePayer> result = null;\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n" " result =\n" " listerAffairesPourStatistiques(registre, juridiction,\n" " dateDebut, dateFin,\n" " StateConstants.ETAT_DEMANDE_A_DISTRIBUER, hConnection);\n" " // end-user-code\n" " return result;\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " \n" " /**\n" " * Liste des ip closes qui ont été distribuées pendant la période\n" " * @param registre\n" " * @param juridiction\n" " * @param dateDebut\n" " * @param dateFin\n" " * @return\n" " * @throws PersistenceServiceException\n" " */\n" " public java.util.List<InjonctionDePayerClose> listerAffairesNouvellesCloturees(\n" " final String registre, final String juridiction,\n" " final Date dateDebut, final Date dateFin)\n" " throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " java.util.List<InjonctionDePayerClose> result = null;\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n" " result =\n" " listerAffairesClotureesPourStatistiques(registre, juridiction,\n" " dateDebut, dateFin,\n" " StateConstants.ETAT_DEMANDE_A_DISTRIBUER, hConnection);\n" " // end-user-code\n" " return result;\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n\n" " public Integer compterAffairesNouvelles(final String registre,\n" " final String juridiction, final Date dateDebut, final Date dateFin)\n" " throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " Integer result = null;\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n" " \n" " \n" " result =\n" " compterAffairesPourStatistiques(registre, juridiction,\n" " dateDebut, dateFin,\n" " StateConstants.ETAT_DEMANDE_A_DISTRIBUER, hConnection);\n" " // end-user-code\n" " return (Integer) result;\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n\n" " public java.util.List<InjonctionDePayer> listerOrdonnancesRendues(\n" " final String registre, final String juridiction,\n" " final Date dateDebut, final Date dateFin)\n" " throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " java.util.List<InjonctionDePayer> result = null;\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n" " \n" " final Query query =\n" " hConnection.getNamedQuery(\"listerOrdonnancesRendues\");\n" " query.setParameter(\"registre\", Integer.valueOf(registre));\n" " query.setParameter(\"juridiction\", \"%\" + juridiction);\n" " query.setParameter(\"dateDebut\", dateDebut);\n" " query.setParameter(\"dateFin\", dateFin);\n" " query.setParameter(\"etat\", StateConstants.ETAT_DECISION_RENDUE);\n" " final Set<InjonctionDePayer> injonctions =\n" " new TreeSet<InjonctionDePayer>(comparateurIpId);\n" " injonctions.addAll(query.list());\n" " result = new ArrayList<InjonctionDePayer>(injonctions);\n" " \n" " // end-user-code\n" " return result;\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " \n" " /**\n" " * liste des ip closes avec une decision rendue dans la période\n" " * @param registre\n" " * @param juridiction\n" " * @param dateDebut\n" " * @param dateFin\n" " * @return\n" " * @throws PersistenceServiceException\n" " */\n" " public java.util.List<InjonctionDePayerClose> listerOrdonnancesRenduesIPClose(\n" " final String registre, final String juridiction,\n" " final Date dateDebut, final Date dateFin)\n" " throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " java.util.List<InjonctionDePayerClose> result = null;\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n" " \n" " final Query query =\n" " hConnection.getNamedQuery(\"listerOrdonnancesRenduesIPClose\");\n" " query.setParameter(\"registre\", Integer.valueOf(registre));\n" " query.setParameter(\"juridiction\", \"%\" + juridiction);\n" " query.setParameter(\"dateDebut\", dateDebut);\n" " query.setParameter(\"dateFin\", dateFin);\n" " query.setParameter(\"etat\", StateConstants.ETAT_DECISION_RENDUE);\n" " final Set<InjonctionDePayerClose> injonctions =\n" " new TreeSet<InjonctionDePayerClose>(comparateurIpCloseId);\n" " injonctions.addAll(query.list());\n" " result = new ArrayList<InjonctionDePayerClose>(injonctions);\n" " \n" " // end-user-code\n" " return result;\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n\n" " public Integer compterOrdonnancesRendues(final String registre,\n" " final String juridiction, final Date dateDebut, final Date dateFin)\n" " throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " Integer result = null;\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n" " \n" " final Query query =\n" " hConnection.getNamedQuery(\"compterOrdonnancesRendues\");\n" " query.setParameter(\"registre\", Integer.valueOf(registre));\n" " query.setParameter(\"juridiction\", juridiction);\n" " query.setParameter(\"dateDebut\", dateDebut);\n" " query.setParameter(\"dateFin\", dateFin);\n" " query.setParameter(\"etat\", StateConstants.ETAT_DECISION_RENDUE);\n" " \n" " /* recuperation du nombre d'ip closes avec decision rendue dans la periode */\n" " Query queryClose =\n" " hConnection.getNamedQuery(\"compterOrdonnancesRenduesIPCloses\");\n" " queryClose.setParameter(\"registre\", new Integer(registre));\n" " queryClose.setParameter(\"juridiction\", juridiction);\n" " queryClose.setParameter(\"dateDebut\", dateDebut);\n" " queryClose.setParameter(\"dateFin\", dateFin);\n" " queryClose.setParameter(\"etat\", StateConstants.ETAT_DECISION_RENDUE);\n" " \n" " result = (Integer) query.uniqueResult() + (Integer) queryClose.uniqueResult();\n" " \n" " // end-user-code\n" " return result;\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " /**\n" " * ip ouverte ayant eu une clôture pour motif opposition ou executoire pendant la periode\n" " */\n" " public java.util.List<InjonctionDePayer> listerOppositionsEtExecutoires(\n" " final String registre, final String juridiction,\n" " final Date dateDebut, final Date dateFin)\n" " throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " java.util.List<InjonctionDePayer> result = null;\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n" " result = new LinkedList<InjonctionDePayer>();\n" " result.addAll(listerAffairesPourStatistiques(registre, juridiction,\n" " dateDebut, dateFin, StateConstants.ETAT_CLOTUREE,\n" " AejConstant.MOTIF_OPPOSITION, hConnection));\n" " result.addAll(listerAffairesPourStatistiques(registre, juridiction,\n" " dateDebut, dateFin, StateConstants.ETAT_CLOTUREE,\n" " AejConstant.MOTIF_DELIVRANCE_EXECUTOIRE, hConnection));\n" " final Set<InjonctionDePayer> injonctions =\n" " new TreeSet<InjonctionDePayer>(comparateurIpId);\n" " injonctions.addAll(result);\n" " result = new ArrayList<InjonctionDePayer>(injonctions);\n" " // end-user-code\n" " return result;\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " \n" " /**\n" " * ip cloturees avec motif opposition ou delivrance de l'exécutoire pendant la periode \n" " * @param registre\n" " * @param juridiction\n" " * @param dateDebut\n" " * @param dateFin\n" " * @return\n" " * @throws PersistenceServiceException\n" " */\n" " public java.util.List<InjonctionDePayerClose> listerOppositionsEtExecutoiresIPClose(\n" " final String registre, final String juridiction,\n" " final Date dateDebut, final Date dateFin)\n" " throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " java.util.List<InjonctionDePayerClose> result = null;\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n" " result = new LinkedList<InjonctionDePayerClose>();\n" " result.addAll(listerAffairesClotureesPourStatistiques(registre, juridiction,\n" " dateDebut, dateFin, StateConstants.ETAT_CLOTUREE,\n" " AejConstant.MOTIF_OPPOSITION, hConnection));\n" " result.addAll(listerAffairesClotureesPourStatistiques(registre, juridiction,\n" " dateDebut, dateFin, StateConstants.ETAT_CLOTUREE,\n" " AejConstant.MOTIF_DELIVRANCE_EXECUTOIRE, hConnection));\n" " final Set<InjonctionDePayerClose> injonctions =\n" " new TreeSet<InjonctionDePayerClose>(comparateurIpCloseId);\n" " injonctions.addAll(result);\n" " result = new ArrayList<InjonctionDePayerClose>(injonctions);\n" " // end-user-code\n" " return result;\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n\n" " public Integer compterAffairesEnOpposition(final String registre,\n" " final String juridiction, final Date dateDebut, final Date dateFin)\n" " throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " Integer result = null;\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n" " result = compterAffairesPourStatistiques(registre, juridiction,\n" " dateDebut, dateFin, StateConstants.ETAT_CLOTUREE,\n" " AejConstant.MOTIF_OPPOSITION, hConnection) +\n" " compterAffairesClotureesPourStatistiques(registre, juridiction,\n" " dateDebut, dateFin, StateConstants.ETAT_CLOTUREE,\n" " AejConstant.MOTIF_OPPOSITION, hConnection);\n" " // end-user-code\n" " return result;\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n\n" " public Integer compterAffairesEnExecutoire(final String registre,\n" " final String juridiction, final Date dateDebut, final Date dateFin)\n" " throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " Integer result = null;\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n" " result =compterAffairesPourStatistiques(registre, juridiction,\n" " dateDebut, dateFin, StateConstants.ETAT_CLOTUREE,\n" " AejConstant.MOTIF_DELIVRANCE_EXECUTOIRE,\n" " hConnection) +\n" " compterAffairesClotureesPourStatistiques(registre, juridiction,\n" " dateDebut, dateFin, StateConstants.ETAT_CLOTUREE,\n" " AejConstant.MOTIF_DELIVRANCE_EXECUTOIRE,\n" " hConnection);\n" " // end-user-code\n" " return result;\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n\n" " public java.util.List<InjonctionDePayer> recupererListeInjonctionsParListeIdTechniques(\n" " final java.util.List<String> listeIdTechniques)\n" " throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " java.util.List<InjonctionDePayer> result = new ArrayList<InjonctionDePayer>();\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n" " if (listeIdTechniques != null && listeIdTechniques.size() > 0) {\n" " Query query = hConnection.getNamedQuery(\"recupererListeInjonctionsParListeIdTechniques\");\n" " List<Integer> listeId = new ArrayList<Integer>();\n" " for (String string : listeIdTechniques) {\n" " listeId.add(Integer.valueOf(string));\n" " }\n" " query.setParameterList(\"listeId\", listeId);\n" " result.addAll(query.list());\n" " }\n" " // end-user-code\n" " return result;\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n\n" " public java.util.List<ColonneNombreSaisinesDirectesDTO> recupererCompteursDecisionsSaisinesDirectes(\n" " final Date dateFin, final Date dateDebut, final String registre,\n" " final Integer idQualiteDecisionnaire, final String juridiction)\n" " throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " java.util.List<ColonneNombreSaisinesDirectesDTO> result = null;\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n" " result = new java.util.ArrayList<ColonneNombreSaisinesDirectesDTO>();\n" " \n" " Map<String, ColonneNombreSaisinesDirectesDTO> map = new HashMap<String, ColonneNombreSaisinesDirectesDTO>();\n\n" " /*\n" " * On construit la requete dynamiquement comme on a 2 cas à traiter\n" " * : -registre 21 : on remonte les injonctions qui ont un boolean\n" " * renvoiCompetence null ou false ; - registre 95 : on ne regarde\n" " * pas ce boolean\n" " */\n\n" " StringBuffer queryString = new StringBuffer();\n" " queryString.append(\"SELECT typeDecision.libelle, count(distinct ip.id) \");\n" " queryString.append(\"FROM InjonctionDePayer ip \");\n" " queryString.append(\"LEFT JOIN ip.enregistres enreg \");\n" " queryString.append(\"LEFT JOIN enreg.registre registre \");\n" " queryString.append(\"LEFT JOIN registre.juridiction juridiction \");\n" " queryString.append(\"LEFT JOIN ip.decision as decision \");\n" " queryString.append(\"LEFT JOIN decision.typeDecision as typeDecision \");\n" " queryString.append(\"LEFT JOIN ip.distribuerA as utilisateur \");\n" " queryString.append(\"LEFT JOIN utilisateur.roles as roles \");\n" " queryString.append(\"LEFT JOIN roles.qualite as qualite \");\n" " queryString.append(\"LEFT JOIN roles.application as appli \");\n\n" " /*\n" " * on récupère les ip dans le registre sélectionné et la juridiction\n" " */\n" " queryString.append(\" WHERE registre.registre = :registre \");\n" " queryString.append(\" AND juridiction.juridictionSIRET = :siretJuridiction \");\n\n" " /*\n" " * la date de décision doit être comprise dans la période choisie\n" " */\n" " queryString.append(\"AND decision.dateDecision >= :dateDebut AND decision.dateDecision < :dateFin \");\n\n" " /*\n" " * on récupère les injonctions pour la qualite de décisionnaire\n" " * choisie pour l'application injonction de payer\n" " */\n" " queryString.append(\"AND appli.id = 1 \");\n" " queryString.append(\"AND qualite.id = :idHab \");\n" " queryString.append(\"AND roles.juridiction = :siretJuridiction \");\n\n" " /*\n" " * si on est dans le registre 21 on observe le boolean renvoi de\n" " * compétence\n" " */\n" " if (AejConstant.REG_21.equals(registre)) {\n" " queryString.append(\"AND (ip.renvoiCompetence IS NULL \");\n" " queryString.append(\"OR ip.renvoiCompetence = :isRenvoi )\");\n" " }\n\n" " /*\n" " * groupage selon le libelle du type de decision\n" " */\n" " queryString.append(\"GROUP BY typeDecision.libelle \");\n\n" " Query query = hConnection.createQuery(queryString.toString());\n\n" " /* ajout des paramètres à la requete */\n" " final Calendar cal = Calendar.getInstance();\n" " cal.setTime(dateFin);\n" " cal.add(Calendar.DAY_OF_MONTH, 1);\n" " final Date dateFinPersistance = cal.getTime();\n\n" " query.setDate(\"dateDebut\", dateDebut);\n" " query.setDate(\"dateFin\", dateFinPersistance);\n" " query.setString(\"registre\", registre);\n" " query.setString(AejConstant.SIRET_JURIDICTION, juridiction);\n" " query.setInteger(\"idHab\", idQualiteDecisionnaire);\n\n" " if (AejConstant.REG_21.equals(registre)) {\n" " query.setBoolean(\"isRenvoi\", false);\n" " }\n\n" " List<Object[]> listeObjetsRemontes = query.list();\n\n" " for (final Object[] objet : listeObjetsRemontes) {\n" " final ColonneNombreSaisinesDirectesDTO dto =\n" " new ColonneNombreSaisinesDirectesDTO();\n\n" " dto.setLibelleTypeDecision((String) objet[0]);\n\n" " dto.setNombreSaisinesDirectes((Integer) objet[1]);\n\n" " //result.add(dto);\n" " //ajout du dto une map \n" " map.put(dto.getLibelleTypeDecision(), dto);\n\n" " }\n" " \n" " /* recuperation des decisions sur les injonctions closes pendant la periode */\n" " queryString = new StringBuffer();\n" " queryString.append(\"SELECT typeDecision.libelle, count(distinct ip.id) \");\n" " queryString.append(\"FROM InjonctionDePayerClose ip \");\n" " queryString.append(\"LEFT JOIN ip.enregistres enreg \");\n" " queryString.append(\"LEFT JOIN enreg.registre registre \");\n" " queryString.append(\"LEFT JOIN registre.juridiction juridiction \");\n" " queryString.append(\"LEFT JOIN ip.decision as decision \");\n" " queryString.append(\"LEFT JOIN decision.typeDecision as typeDecision \");\n" " queryString.append(\"LEFT JOIN ip.distribuerA as utilisateur \");\n" " queryString.append(\"LEFT JOIN utilisateur.roles as roles \");\n" " queryString.append(\"LEFT JOIN roles.qualite as qualite \");\n" " queryString.append(\"LEFT JOIN roles.application as appli \");\n\n" " /*\n" " * on récupère les ip dans le registre sélectionné et la juridiction\n" " */\n" " queryString.append(\" WHERE registre.registre = :registre \");\n" " queryString.append(\" AND juridiction.juridictionSIRET = :siretJuridiction \");\n\n" " /*\n" " * la date de décision doit être comprise dans la période choisie\n" " */\n" " queryString.append(\"AND decision.dateDecision >= :dateDebut AND decision.dateDecision < :dateFin \");\n\n" " /*\n" " * on récupère les injonctions pour la qualite de décisionnaire\n" " * choisie pour l'application injonction de payer\n" " */\n" " queryString.append(\"AND appli.id = 1 \");\n" " queryString.append(\"AND qualite.id = :idHab \");\n" " queryString.append(\"AND roles.juridiction = :siretJuridiction \");\n\n" " /*\n" " * si on est dans le registre 21 on observe le boolean renvoi de\n" " * compétence\n" " */\n" " if (AejConstant.REG_21.equals(registre)) {\n" " queryString.append(\"AND (ip.renvoiCompetence IS NULL \");\n" " queryString.append(\"OR ip.renvoiCompetence = :isRenvoi )\");\n" " }\n\n" " /*\n" " * groupage selon le libelle du type de decision\n" " */\n" " queryString.append(\"GROUP BY typeDecision.libelle \");\n\n" " query = hConnection.createQuery(queryString.toString());\n\n" " query.setDate(\"dateDebut\", dateDebut);\n" " query.setDate(\"dateFin\", dateFinPersistance);\n" " query.setString(\"registre\", registre);\n" " query.setString(AejConstant.SIRET_JURIDICTION, juridiction);\n" " query.setInteger(\"idHab\", idQualiteDecisionnaire);\n\n" " if (AejConstant.REG_21.equals(registre)) {\n" " query.setBoolean(\"isRenvoi\", false);\n" " }\n" " \n" " listeObjetsRemontes = query.list();\n\n" " for (final Object[] objet : listeObjetsRemontes) {\n" " final ColonneNombreSaisinesDirectesDTO dto =\n" " new ColonneNombreSaisinesDirectesDTO();\n\n" " dto.setLibelleTypeDecision((String) objet[0]);\n" " \n" " dto.setNombreSaisinesDirectes((Integer) objet[1]);\n" " \n" " //si decision referencee au niveau des decisions sur ip ouverte => maj du nombre \n" " if(map.get(dto.getLibelleTypeDecision()) != null){\n" " dto.setNombreSaisinesDirectes(dto.getNombreSaisinesDirectes() + \n" " ((ColonneNombreSaisinesDirectesDTO)map.get(dto.getLibelleTypeDecision())).getNombreSaisinesDirectes());\n" " //suppression de l'element déjà présent puis mis à jour avec le nouveau décompte\n" " map.remove(dto.getLibelleTypeDecision());\n" " }\n" " map.put(dto.getLibelleTypeDecision(), dto);\n" " }\n" " \n" " result.addAll(map.values());\n\n" " // end-user-code\n" " return result;\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " /**\n" " * \n" " */\n" " @SuppressWarnings(\"static-access\")\n" " public java.util.List<ColonneNombreRenvoisCompetenceDTO> recupererCompteursDecisionsRenvoisCompetence(\n" " final Date dateFin, final Date dateDebut, final String registre,\n" " final Integer idQualiteDecisionnaire, final String juridiction)\n" " throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " java.util.List<ColonneNombreRenvoisCompetenceDTO> result = null;\n" " Map<String, ColonneNombreRenvoisCompetenceDTO> map = new HashMap<String, ColonneNombreRenvoisCompetenceDTO>();\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n" " result = new java.util.ArrayList<ColonneNombreRenvoisCompetenceDTO>();\n\n" " Query query = hConnection.getNamedQuery(\"recupererCompteursDecisionRenvois\");\n\n" " /* ajout des paramètres à la requete */\n" " final Calendar cal = Calendar.getInstance();\n" " \n" " cal.setTime(dateFin);\n" " cal.add(cal.DAY_OF_MONTH, 1);\n" " final Date dateFinPersistance = cal.getTime();\n\n" " query.setDate(\"dateDebut\", dateDebut);\n" " query.setDate(\"dateFin\", dateFinPersistance);\n" " query.setString(\"registre\", registre);\n" " query.setString(AejConstant.SIRET_JURIDICTION, juridiction);\n" " query.setInteger(\"idHab\", idQualiteDecisionnaire);\n\n" " query.setBoolean(\"isRenvoi\", true);\n\n" " final List<Object[]> listeObjetsRemontes = query.list();\n\n" " for (final Object[] objet : listeObjetsRemontes)\n" " {\n" " final ColonneNombreRenvoisCompetenceDTO dto = new ColonneNombreRenvoisCompetenceDTO();\n" " dto.setLibelleTypeDecision((String) objet[0]);\n" " dto.setNombreRenvoisCompetence((Integer) objet[1]);\n" " //result.add(dto);\n" " //ajout dans la map\n" " map.put(dto.getLibelleTypeDecision(), dto);\n" " }\n" " \n" " /* recuperation des renvois sur ip close pendant la meme periode */\n" " query = hConnection.getNamedQuery(\"recupererCompteursDecisionRenvoisIPClose\");\n\n" " /* ajout des paramètres à la requete */\n" " query.setDate(\"dateDebut\", dateDebut);\n" " query.setDate(\"dateFin\", dateFinPersistance);\n" " query.setString(\"registre\", registre);\n" " query.setString(AejConstant.SIRET_JURIDICTION, juridiction);\n" " query.setInteger(\"idHab\", idQualiteDecisionnaire);\n\n" " query.setBoolean(\"isRenvoi\", true);\n\n" " final List<Object[]> listeObjetsRemontesClos = query.list();\n\n" " for (final Object[] objet : listeObjetsRemontesClos)\n" " {\n" " final ColonneNombreRenvoisCompetenceDTO dto = new ColonneNombreRenvoisCompetenceDTO();\n" " dto.setLibelleTypeDecision((String) objet[0]);\n" " dto.setNombreRenvoisCompetence((Integer) objet[1]);\n" " \n" " //si decision deja presente dans les ip ouverte => mise à jour du décompte + suppression de l'ancien objet\n" " if(map.get(dto.getLibelleTypeDecision()) != null){\n" " dto.setNombreRenvoisCompetence(dto.getNombreRenvoisCompetence() + \n" " ((ColonneNombreRenvoisCompetenceDTO) map.get(dto.getLibelleTypeDecision())).getNombreRenvoisCompetence());\n" " map.remove(dto.getLibelleTypeDecision());\n" " }\n" " \n" " //ajout dans la map\n" " map.put(dto.getLibelleTypeDecision(), dto);\n" " }\n" " \n" " result.addAll(map.values());\n" " \n" " // end-user-code\n" " return result;\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n\n" " /**\n" " * \n" " */\n" " public List<InjonctionDePayer> listerDemandesParEtatPourDecisionnaire(\n" " final String identifiantDecisionnaire,\n" " final InformationsListePagineeDTO informationsListePaginee,\n" " final Integer registre, final String siretJuridiction,\n" " final String etatDemande) throws PersistenceServiceException {\n" " java.util.List<InjonctionDePayer> result = null;\n" " // begin-user-code\n" " try {\n\n" " final Map<String, Object> parametres = getParametresEtatSiretRegistre(siretJuridiction, registre, etatDemande);\n" " parametres.put(\"identifiantDecisionnaire\", identifiantDecisionnaire);\n" " final String requeteId = \"listerIdDemandesParEtatPourDecisionnaire\";\n" " final String requete = \"listerDemandesParEtat\";\n" " \n" " \n" " if (AejColonneTriConstant.DATE_TRANSMIS.equals(informationsListePaginee.getColonneTri())) {\n" " \n" " result = getResultDateTransmis(informationsListePaginee, parametres, requeteId, requete);\n" " \n" " } else if (AejColonneTriConstant.SOMME.equals(informationsListePaginee.getColonneTri())) {\n" " \n" " result = getResultSomme(informationsListePaginee, parametres, requeteId, requete);\n" " \n" " } else {\n" " getColonneTriDecisionnaire(informationsListePaginee);\n" " result = getListePaginee(requeteId, requete, parametres,informationsListePaginee);\n" " }\n\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " }\n" " return result;\n" " // end-user-code\n" " }\n\n" " private final Comparator<InjonctionDePayer> comparateurIpId =\n" " new Comparator<InjonctionDePayer>() {\n\n" " public int compare(final InjonctionDePayer o1,\n" " final InjonctionDePayer o2) {\n" " if (o1.getId() == null) {\n" " return -1;\n" " }\n" " if (o2.getId() == null) {\n" " return +1;\n" " }\n" " return o1.getId().compareTo(o2.getId());\n" " }\n\n" " };\n" " private final Comparator<InjonctionDePayerClose> comparateurIpCloseId = new Comparator<InjonctionDePayerClose>() {\n\n" " public int compare(final InjonctionDePayerClose o1,\n" " final InjonctionDePayerClose o2) {\n" " if (o1.getId() == null) {\n" " return -1;\n" " }\n" " if (o2.getId() == null) {\n" " return +1;\n" " }\n" " return o1.getId().compareTo(o2.getId());\n" " }\n\n" " };\n\n" " private Integer compterAffairesPourStatistiques(final String registre,\n" " final String juridiction, final Date dateDebut, final Date dateFin,\n" " final String etat, final HibernateConnection hConnection)\n" " throws TransactionException {\n" " final Query query =\n" " hConnection.getNamedQuery(\"compterAffairesPourStatistiques\");\n" " query.setParameter(\"registre\", Integer.valueOf(registre));\n" " query.setParameter(\"juridiction\", juridiction);\n" " query.setParameter(\"dateDebut\", dateDebut);\n" " query.setParameter(\"dateFin\", dateFin);\n" " query.setParameter(\"etat\", etat);\n" " final Query queryClos =\n" " hConnection.getNamedQuery(\"compterAffairesClotureesPourStatistiques\");\n" " queryClos.setParameter(\"registre\", Integer.valueOf(registre));\n" " queryClos.setParameter(\"juridiction\", juridiction);\n" " queryClos.setParameter(\"dateDebut\", dateDebut);\n" " queryClos.setParameter(\"dateFin\", dateFin);\n" " queryClos.setParameter(\"etat\", etat);\n" " return (Integer) query.uniqueResult() + (Integer) queryClos.uniqueResult();\n" " }\n" " private List<InjonctionDePayer> listerAffairesPourStatistiques(\n" " final String registre, final String juridiction,\n" " final Date dateDebut, final Date dateFin, final String etat,\n" " final HibernateConnection hConnection) throws TransactionException {\n" " final Query query =\n" " hConnection.getNamedQuery(\"listerAffairesPourStatistiques\");\n" " query.setParameter(\"registre\", Integer.valueOf(registre));\n" " query.setParameter(\"juridiction\", \"%\" + juridiction);\n" " query.setParameter(\"dateDebut\", dateDebut);\n" " query.setParameter(\"dateFin\", dateFin);\n" " query.setParameter(\"etat\", etat);\n" " final Set<InjonctionDePayer> injonctions =\n" " new TreeSet<InjonctionDePayer>(comparateurIpId);\n" " injonctions.addAll(query.list());\n" " return new ArrayList<InjonctionDePayer>(injonctions);\n" " }\n" " private List<InjonctionDePayerClose> listerAffairesClotureesPourStatistiques(\n" " final String registre, final String juridiction,\n" " final Date dateDebut, final Date dateFin, final String etat,\n" " final HibernateConnection hConnection) throws TransactionException {\n" " final Query query =\n" " hConnection.getNamedQuery(\"listerAffairesClotureesPourStatistiques\");\n" " query.setParameter(\"registre\", Integer.valueOf(registre));\n" " query.setParameter(\"juridiction\", \"%\" + juridiction);\n" " query.setParameter(\"dateDebut\", dateDebut);\n" " query.setParameter(\"dateFin\", dateFin);\n" " query.setParameter(\"etat\", etat);\n" " final Set<InjonctionDePayerClose> injonctions =\n" " new TreeSet<InjonctionDePayerClose>(comparateurIpCloseId);\n" " injonctions.addAll(query.list());\n" " return new ArrayList<InjonctionDePayerClose>(injonctions);\n" " }\n" " private Integer compterAffairesPourStatistiques(final String registre,\n" " final String juridiction, final Date dateDebut, final Date dateFin,\n" " final String etat, final String motif,\n" " final HibernateConnection hConnection) throws TransactionException {\n" " final Query query =\n" " hConnection\n" " .getNamedQuery(\"compterAffairesPourStatistiquesAvecMotif\");\n" " query.setParameter(\"registre\", Integer.valueOf(registre));\n" " query.setParameter(\"juridiction\", \"%\" + juridiction);\n" " query.setParameter(\"dateDebut\", dateDebut);\n" " query.setParameter(\"dateFin\", dateFin);\n" " query.setParameter(\"etat\", etat);\n" " query.setParameter(\"motif\", motif);\n" " return (Integer) query.uniqueResult();\n" " }\n" " \n" " private Integer compterAffairesClotureesPourStatistiques(final String registre,\n" " final String juridiction, final Date dateDebut, final Date dateFin,\n" " final String etat, final String motif,\n" " final HibernateConnection hConnection) throws TransactionException {\n" " final Query query =\n" " hConnection\n" " .getNamedQuery(\"compterAffairesClotureesPourStatistiquesAvecMotif\");\n" " query.setParameter(\"registre\", Integer.valueOf(registre));\n" " query.setParameter(\"juridiction\", \"%\" + juridiction);\n" " query.setParameter(\"dateDebut\", dateDebut);\n" " query.setParameter(\"dateFin\", dateFin);\n" " query.setParameter(\"etat\", etat);\n" " query.setParameter(\"motif\", motif);\n" " return (Integer) query.uniqueResult();\n" " }\n" " \n" " /**\n" " * \n" " * @param registre\n" " * @param juridiction\n" " * @param dateDebut\n" " * @param dateFin\n" " * @param etat\n" " * @param motif\n" " * @param hConnection\n" " * @return\n" " * @throws TransactionException\n" " */\n" " private List<InjonctionDePayer> listerAffairesPourStatistiques(\n" " final String registre, final String juridiction,\n" " final Date dateDebut, final Date dateFin, final String etat,\n" " final String motif, final HibernateConnection hConnection)\n" " throws TransactionException {\n" " final Query query = hConnection.getNamedQuery(\"listerAffairesPourStatistiquesAvecMotif\");\n" " query.setParameter(\"registre\", Integer.valueOf(registre));\n" " query.setParameter(\"juridiction\", \"%\" + juridiction);\n" " query.setParameter(\"dateDebut\", dateDebut);\n" " query.setParameter(\"dateFin\", dateFin);\n" " query.setParameter(\"etat\", etat);\n" " query.setParameter(\"motif\", motif);\n" " final Set<InjonctionDePayer> injonctions =new TreeSet<InjonctionDePayer>(comparateurIpId);\n" " injonctions.addAll(query.list());\n" " return new ArrayList<InjonctionDePayer>(injonctions);\n" " }\n" " \n" " /**\n" " * \n" " * @param registre\n" " * @param juridiction\n" " * @param dateDebut\n" " * @param dateFin\n" " * @param etat\n" " * @param motif\n" " * @param hConnection\n" " * @return\n" " * @throws TransactionException\n" " */\n" " private List<InjonctionDePayerClose> listerAffairesClotureesPourStatistiques(\n" " final String registre, final String juridiction,\n" " final Date dateDebut, final Date dateFin, final String etat,\n" " final String motif, final HibernateConnection hConnection)\n" " throws TransactionException {\n" " final Query query = hConnection.getNamedQuery(\"listerAffairesClotureesPourStatistiquesAvecMotif\");\n" " query.setParameter(\"registre\", Integer.valueOf(registre));\n" " query.setParameter(\"juridiction\", \"%\" + juridiction);\n" " query.setParameter(\"dateDebut\", dateDebut);\n" " query.setParameter(\"dateFin\", dateFin);\n" " query.setParameter(\"etat\", etat);\n" " query.setParameter(\"motif\", motif);\n" " final Set<InjonctionDePayerClose> injonctions =new TreeSet<InjonctionDePayerClose>(comparateurIpCloseId);\n" " injonctions.addAll(query.list());\n" " return new ArrayList<InjonctionDePayerClose>(injonctions);\n" " }\n" " \n" " /**\n" " * Retourne le nombre d'IP clôturées pendant la période dateDebut dateFin avec un timbre renseigné\n" " * @param registre\n" " * @param juridiction\n" " * @param dateDebut\n" " * @param dateFin\n" " * @return\n" " * @throws PersistenceServiceException\n" " */\n" " public Integer compterInjonctionAvecTimbre(\n" " final String registre, final String juridiction,\n" " final Date dateDebut, final Date dateFin)\n" " throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n" " //recuperation des ip ouvertes qui ont été cloturées pendant la période (puis décloturées)\n" " final Query query = hConnection.getNamedQuery(\"compterAffairesPourStatistiquesAvecTimbre\");\n" " query.setParameter(\"registre\", Integer.valueOf(registre));\n" " query.setParameter(\"juridiction\", \"%\" + juridiction);\n" " query.setParameter(\"dateDebut\", dateDebut);\n" " query.setParameter(\"dateFin\", dateFin);\n" " query.setParameter(\"etat\", StateConstants.ETAT_CLOTUREE);\n" " //recuperation du nombre d'ip cloturees pendant la periode avec timbre\n" " final Query queryClos = hConnection.getNamedQuery(\"compterAffairesClotureesPourStatistiquesAvecTimbre\");\n" " queryClos.setParameter(\"registre\", new Integer(registre));\n" " queryClos.setParameter(\"juridiction\", \"%\" + juridiction);\n" " queryClos.setParameter(\"dateDebut\", dateDebut);\n" " queryClos.setParameter(\"dateFin\", dateFin);\n" " queryClos.setParameter(\"etat\", StateConstants.ETAT_CLOTUREE);\n" " return (Integer) query.uniqueResult() + (Integer) queryClos.uniqueResult();\n" " \n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " \n" " /**\n" " * \n" " * @param registre\n" " * @param juridiction\n" " * @param dateDebut\n" " * @param dateFin\n" " * @return\n" " * @throws PersistenceServiceException\n" " */\n" " public List<InjonctionDePayer> listerInjonctionAvecTimbre(\n" " final String registre, final String juridiction,\n" " final Date dateDebut, final Date dateFin)\n" " throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n" " \n" " final Query query = hConnection.getNamedQuery(\"listerAffairesPourStatistiquesAvecTimbre\");\n" " query.setParameter(\"registre\", Integer.valueOf(registre));\n" " query.setParameter(\"juridiction\", \"%\" + juridiction);\n" " query.setParameter(\"dateDebut\", dateDebut);\n" " query.setParameter(\"dateFin\", dateFin);\n" " query.setParameter(\"etat\", StateConstants.ETAT_CLOTUREE);\n" " final Set<InjonctionDePayer> injonctions =new TreeSet<InjonctionDePayer>(comparateurIpId);\n" " injonctions.addAll(query.list());\n" " return new ArrayList<InjonctionDePayer>(injonctions);\n" " \n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " \n" " /**\n" " * liste des affaires cloturees pendant la période avec un timbre fiscal \n" " * @param registre\n" " * @param juridiction\n" " * @param dateDebut\n" " * @param dateFin\n" " * @return\n" " * @throws PersistenceServiceException\n" " */\n" " public List<InjonctionDePayerClose> listerInjonctionCloseAvecTimbre(\n" " final String registre, final String juridiction,\n" " final Date dateDebut, final Date dateFin)\n" " throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n" " \n" " final Query query = hConnection.getNamedQuery(\"listerAffairesClotureesPourStatistiquesAvecTimbre\");\n" " query.setParameter(\"registre\", Integer.valueOf(registre));\n" " query.setParameter(\"juridiction\", \"%\" + juridiction);\n" " query.setParameter(\"dateDebut\", dateDebut);\n" " query.setParameter(\"dateFin\", dateFin);\n" " query.setParameter(\"etat\", StateConstants.ETAT_CLOTUREE);\n" " final Set<InjonctionDePayerClose> injonctions =new TreeSet<InjonctionDePayerClose>(comparateurIpCloseId);\n" " injonctions.addAll(query.list());\n" " return new ArrayList<InjonctionDePayerClose>(injonctions);\n" " \n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " \n" " ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////\n" " /**\n" " * @author ydjouambi-e\n" " * \n" " * Cette méthode permet de récuperer les listes paginés <br>\n" " * En attente de decision <br>\n" " * \n" " * @param idTechniqueInjonctionPayer\n" " * @return\n" " * @throws PersistenceServiceException\n" " */\n" " public InjonctionDePayer recupererDetailIPListesDecisionEnAttente(final String idTechniqueInjonctionPayer)\n" " throws PersistenceServiceException {\n" " InjonctionDePayer ip = null;\n" " HibernateConnection hConnection = null;\n" " try {\n" " hConnection = (HibernateConnection) getConnection();\n" " final Integer idInjonctionPayerInt = Integer.valueOf(idTechniqueInjonctionPayer);\n" " Query query = hConnection.getNamedQuery(\"recupererDetailIPayer\");\n" " query.setParameter(\"idInjonctionPayer\", idInjonctionPayerInt);\n" " ip = (InjonctionDePayer) query.uniqueResult();\n" " return ip;\n" " // end-user-code\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // verification de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " /**\n" " * \n" " * @author ydjouambi-e\n" " * \n" " * Cette méthode permet de récuperer les listes paginés <br>\n" " * par registre, juridiction et état :<br>\n" " * En cours de saisie ou a distribuer<br>\n" " * \n" " * @param informationsListePaginee\n" " * @param registre\n" " * @param siretJuridiction\n" " * @param isTri\n" " * @return\n" " * @throws PersistenceServiceException\n" " * \n" " */\n" " public List<InjonctionDePayer> listerDemandesEnCoursSaisiOuADistribuer( InformationsListePagineeDTO informationsListePaginee,\n" " Integer registre, String siretJuridiction, String etatDemande,\n" " Boolean isTri)throws PersistenceServiceException {\n" " List<InjonctionDePayer> result = null;\n" " try {\n" " final HibernateConnection hConnection = (HibernateConnection) getConnection();\n" " String ColTri = informationsListePaginee.getColonneTri();\n" " Map<String, Object> parametres = getParametresEtatSiretRegistre(siretJuridiction, registre, etatDemande);\n" " String namedQueryId = \"listerIDIPParEtatJuridictionRegistre\";\n" " String namedQuery = \"listerDemandesEnCoursSaisiOuADistribuer\";\n" " if(!isTri){\n" " getColonneTriDecisionnaire(informationsListePaginee);\n" " }\n" " result = AejPersistenceUtil\n" " .recupererResultatListePaginee(hConnection, namedQueryId, namedQuery, parametres, informationsListePaginee, ColTri,true);\n" " } catch (TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " }\n" " return result;\n" " }\n" " /**\n" " * \n" " * @author ydjouambi-e\n" " * \n" " * Cette méthode permet de récuperer les listes paginés <br>\n" " * par registre, juridiction :<br>\n" " * des executoires en retard ou en attente <br>\n" " * \n" " * @param informationsListePaginee\n" " * @param registre\n" " * @param siretJuridiction\n" " * @param isTri\n" " * @return\n" " * @throws PersistenceServiceException\n" " */\n" " public List<InjonctionDePayer> listerExecutoires(String namedQueryId, String namedQuery,\n" " InformationsListePagineeDTO informationsListePaginee,\n" " Integer registre, String siretJuridiction, Boolean isTri)\n" " throws PersistenceServiceException {\n" " java.util.List<InjonctionDePayer> result = null;\n" " try {\n" " final HibernateConnection hConnection = (HibernateConnection) getConnection();\n" " final Map<String, Object> parametres = getParametresEtatSiretRegistre(siretJuridiction, registre, StateConstants.ETAT_DECISION_RENDUE);\n" " if(!isTri){\n" " getColonneTriDecisionnaire(informationsListePaginee);\n" " }\n" " result = AejPersistenceUtil\n" " .recupererResultatListeExecutoire(hConnection, namedQueryId, namedQuery, parametres, informationsListePaginee ,true);\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " }\n" " return result;\n" " }\n\n" " /**\n" " * Recuperer l'IP à laquelle est associée à un fichier \n" " * @param pj\n" " * @return\n" " * @throws PersistenceServiceException\n" " */\n" " public InjonctionDePayer recupererIPParPieceJointe(\n" " final FichierLIPTI pj) throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " InjonctionDePayer result = null;\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n" " final Query query =\n" " hConnection.getNamedQuery(\"recupererIPParPieceJointe\");\n\n" " query.setString(\"idPJ\", String.valueOf(pj.getId()));\n" " \n\n" " final List<InjonctionDePayer> listInjonction = query.list();\n" " if (listInjonction.size() > 0) {\n" " result = listInjonction.iterator().next();\n" " }\n\n" " // end-user-code\n" " return result;\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " \n" " /**\n" " * Récupérer une IP à partir de la decision\n" " * @param idDecision\n" " * @return\n" " * @throws PersistenceServiceException\n" " */\n" " public InjonctionDePayer recupererInjonctionParDecision(final Integer idDecision)\n" " throws PersistenceServiceException {\n" " InjonctionDePayer ip = null;\n" " HibernateConnection hConnection = null;\n" " try {\n" " hConnection = (HibernateConnection) getConnection();\n" " Query query = hConnection.getNamedQuery(\"recupererInjonctionParDecision\");\n" " query.setParameter(\"idDecision\", idDecision);\n" " ip = (InjonctionDePayer) query.uniqueResult();\n" " return ip;\n" " // end-user-code\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // verification de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " \n" " /**\n" " * Recupere une injonction à partir de numRG, registre et juridiction\n" " * @param registre\n" " * @param siretJuridiction\n" " * @param numeroRG\n" " * @return\n" " * @throws PersistenceServiceException\n" " */\n" " public InjonctionDePayer recupererInjonctionParNumRG(final Integer registre,\n" " final String siretJuridiction, final Integer numeroRG) throws PersistenceServiceException {\n" " InjonctionDePayer result = null;\n" " HibernateConnection hConnection = null;\n" " // begin-user-code\n" " try {\n" " hConnection = (HibernateConnection) getConnection();\n\n" " final Query queryHibernate =\n" " hConnection.getNamedQuery(\"recupererInjonctionParNumRG\");\n\n" " queryHibernate.setInteger(\"registre\", registre);\n" " queryHibernate.setInteger(\"numeroRG\", numeroRG);\n" " queryHibernate.setString(AejConstant.SIRET_JURIDICTION, siretJuridiction);\n" " result = (InjonctionDePayer) queryHibernate.uniqueResult();\n\n" " return result;\n" " // end-user-code\n" " } catch (final TransactionException e) {\n" " new PersistenceServiceException(e);\n" " } finally {\n" " // verification de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n\n\n" " /**\n" " * Recupere une injonction à partir de numRG, registre, juridiction et arrondissement\n" " * @param registre\n" " * @param siretJuridiction\n" " * @param numeroRG\n" " * @param arrondissement\n" " * @return\n" " * @throws PersistenceServiceException\n" " */\n" " public InjonctionDePayer recupererInjonctionParNumRGEtArrondissement(final Integer registre,\n" " final String siretJuridiction, final Integer numeroRG, final String arrondissement) throws PersistenceServiceException {\n" " InjonctionDePayer result = null;\n" " HibernateConnection hConnection = null;\n" " // begin-user-code\n" " try {\n" " hConnection = (HibernateConnection) getConnection();\n\n" " final Query queryHibernate =\n" " hConnection.getNamedQuery(\"recupererInjonctionParNumRGEtArrondissement\");\n\n" " queryHibernate.setInteger(\"registre\", registre);\n" " queryHibernate.setInteger(\"numeroRG\", numeroRG);\n" " queryHibernate.setString(\"arrondissement\", arrondissement);\n" " queryHibernate.setString(AejConstant.SIRET_JURIDICTION, siretJuridiction);\n" " result = (InjonctionDePayer) queryHibernate.uniqueResult();\n\n" " return result;\n" " // end-user-code\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // verification de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n\n\n" " /**\n" " * Recupere une injonction close à partir de numRG, registre et juridiction\n" " * @param registre\n" " * @param siretJuridiction\n" " * @param numeroRG\n" " * @return\n" " * @throws PersistenceServiceException\n" " */\n" " public InjonctionDePayerClose recupererInjonctionCloseParNumRG(final Integer registre,\n" " final String siretJuridiction, final Integer numeroRG) throws PersistenceServiceException {\n" " InjonctionDePayerClose result = null;\n" " HibernateConnection hConnection = null;\n" " // begin-user-code\n" " try {\n" " hConnection = (HibernateConnection) getConnection();\n\n" " final Query queryHibernate =\n" " hConnection.getNamedQuery(\"recupererInjonctionCloseParNumRG\");\n\n" " queryHibernate.setInteger(\"registre\", registre);\n" " queryHibernate.setInteger(\"numeroRG\", numeroRG);\n" " queryHibernate.setString(AejConstant.SIRET_JURIDICTION, siretJuridiction);\n" " result = (InjonctionDePayerClose) queryHibernate.uniqueResult();\n\n" " return result;\n" " // end-user-code\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // verification de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n\n\n" " /**\n" " * Recupere une injonction close à partir de numRG, registre, juridiction et arrondissement\n" " * @param registre\n" " * @param siretJuridiction\n" " * @param numeroRG\n" " * @param arrondissement\n" " * @return\n" " * @throws PersistenceServiceException\n" " */\n" " public InjonctionDePayerClose recupererInjonctionCloseParNumRGEtArrondissement(final Integer registre,\n" " final String siretJuridiction, final Integer numeroRG, final String arrondissement) throws PersistenceServiceException {\n" " InjonctionDePayerClose result = null;\n" " HibernateConnection hConnection = null;\n" " // begin-user-code\n" " try {\n" " hConnection = (HibernateConnection) getConnection();\n\n" " final Query queryHibernate =\n" " hConnection.getNamedQuery(\"recupererInjonctionCloseParNumRGEtArrondissement\");\n\n" " queryHibernate.setInteger(\"registre\", registre);\n" " queryHibernate.setInteger(\"numeroRG\", numeroRG);\n" " queryHibernate.setString(\"arrondissement\", arrondissement);\n" " queryHibernate.setString(AejConstant.SIRET_JURIDICTION, siretJuridiction);\n" " result = (InjonctionDePayerClose) queryHibernate.uniqueResult();\n\n" " return result;\n" " // end-user-code\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // verification de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n\n" " /**\n" " * Liste toutes les injonctions pour lesquelles il faut prévoir un message de relance de signification\n" " * @param siret\n" " * @param registre\n" " * @param etat\n" " * @param dateDebut\n" " * @param dateFin\n" " * @return\n" " * @throws PersistenceServiceException\n" " */\n" " public List<InjonctionDePayer> listerInjonctionARelancerSignification(String siret, \n" " Integer registre, String etat, Date dateDebut, Date dateFin ) throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n" " \n" " final Query query = hConnection.getNamedQuery(\"listerInjonctionARelancerSignification\");\n" " query.setParameter(\"registre\", Integer.valueOf(registre));\n" " query.setParameter(\"siret\", siret);\n" " query.setParameter(\"dateDebut\", dateDebut);\n" " query.setParameter(\"dateFin\", dateFin);\n" " query.setParameter(\"etat\", etat);\n" " final Set<InjonctionDePayer> injonctions = new TreeSet<InjonctionDePayer>(comparateurIpId);\n" " injonctions.addAll(query.list());\n" " return new ArrayList<InjonctionDePayer>(injonctions);\n" " \n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " \n" " /**\n" " * Liste toutes les injonctions pour lesquelles il faut prévoir un message de relance d'exécutoire\n" " * @param siret\n" " * @param registre\n" " * @param etat\n" " * @param dateDebut\n" " * @param dateFin\n" " * @return\n" " * @throws PersistenceServiceException\n" " */\n" " public List<InjonctionDePayer> listerInjonctionARelancerExecutoire(String siret, \n" " Integer registre, String etat, Date dateDebut, Date dateFin ) throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n" " \n" " final Query query = hConnection.getNamedQuery(\"listerInjonctionARelancerExecutoire\");\n" " query.setParameter(\"registre\", Integer.valueOf(registre));\n" " query.setParameter(\"siret\", siret);\n" " query.setParameter(\"dateDebut\", dateDebut);\n" " query.setParameter(\"dateFin\", dateFin);\n" " query.setParameter(\"etat\", etat);\n" " final Set<InjonctionDePayer> injonctions =new TreeSet<InjonctionDePayer>(comparateurIpId);\n" " injonctions.addAll(query.list());\n" " return new ArrayList<InjonctionDePayer>(injonctions);\n" " \n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n\n" " /**\n" " * Liste toutes les injonctions qui sont restées en Décision rendue alors qu'une décision provoquant la clôture a été rendue\n" " * @return\n" " * @throws PersistenceServiceException\n" " */\n" " public List<InjonctionDePayer> listerInjonctionDecisionRendueATort() throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n" " final Query query = hConnection.getNamedQuery(\"listerInjonctionDecisionRendueATort\");\n" " final Set<InjonctionDePayer> injonctions =new TreeSet<InjonctionDePayer>(comparateurIpId);\n" " injonctions.addAll(query.list());\n" " \n" " return new ArrayList<InjonctionDePayer>(injonctions);\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n" " \n" " /**\n" " * Liste toutes les injonctions qui ont le statut cloturée et qui sont toujours avec les IPs ouvertes\n" " * @return\n" " * @throws PersistenceServiceException\n" " */\n" " public List<InjonctionDePayer> listerIPsStatutClotureeTjrsOuvertes() throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n" " final Query query = hConnection.getNamedQuery(\"listerIPsStatutClotureeTjrsOuvertes\");\n" " final Set<InjonctionDePayer> injonctions =new TreeSet<InjonctionDePayer>(comparateurIpId);\n" " injonctions.addAll(query.list());\n" " \n" " return new ArrayList<InjonctionDePayer>(injonctions);\n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n\n" " /**\n" " * Liste toutes les injonctions qu'il faut clôturer pour désistement\n" " * @param siret\n" " * @param registre\n" " * @param etat\n" " * @param dateFin\n" " * @return\n" " * @throws PersistenceServiceException\n" " */\n" " public List<InjonctionDePayer> listerInjonctionACloturerPourDesistement(String siret, \n" " Integer registre, String etat, Date dateFin ) throws PersistenceServiceException {\n" " HibernateConnection hConnection = null;\n" " try {\n" " // begin-user-code\n" " hConnection = (HibernateConnection) getConnection();\n" " \n" " final Query query = hConnection.getNamedQuery(\"listerInjonctionACloturerPourDesistement\");\n" " query.setParameter(\"registre\", Integer.valueOf(registre));\n" " query.setParameter(\"siret\", siret);\n" " query.setParameter(\"dateFin\", dateFin);\n" " query.setParameter(\"etat\", etat);\n" " final Set<InjonctionDePayer> injonctions = new TreeSet<InjonctionDePayer>(comparateurIpId);\n" " injonctions.addAll(query.list());\n" " return new ArrayList<InjonctionDePayer>(injonctions);\n" " \n" " } catch (final TransactionException e) {\n" " throw new PersistenceServiceException(e);\n" " } finally {\n" " // fermeture de la connexion\n" " fermertureConnexion(hConnection);\n" " }\n" " }\n\n" "}\n") matches = re.finditer(regex, test_str, re.MULTILINE) for matchNum, match in enumerate(matches, start=1): print ("Match {matchNum} was found at {start}-{end}: {match}".format(matchNum = matchNum, start = match.start(), end = match.end(), match = match.group())) for groupNum in range(0, len(match.groups())): groupNum = groupNum + 1 print ("Group {groupNum} found at {start}-{end}: {group}".format(groupNum = groupNum, start = match.start(groupNum), end = match.end(groupNum), group = match.group(groupNum))) # Note: for Python 2.7 compatibility, use ur"" to prefix the regex and u"" to prefix the test string and substitution.

Please keep in mind that these code samples are automatically generated and are not guaranteed to work. If you find any syntax errors, feel free to submit a bug report. For a full regex reference for Python, please visit: https://docs.python.org/3/library/re.html