From 23a46b4be35277e06ec89f48730eeb694e686be8 Mon Sep 17 00:00:00 2001
From: Kenmegne <stephanie.kenmegne@gmail.com>
Date: Thu, 18 Jun 2026 15:40:06 +0000
Subject: [PATCH] add fdx-commons and fdx-consultation
---
fdx-consultation/fdxconsultation-dao-impl/src/main/java/com/megatim/fdxconsultation/dao/impl/log/util/QueryExtendsWithApiUserActionSummarySearch.java | 106 +++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 106 insertions(+), 0 deletions(-)
diff --git a/fdx-consultation/fdxconsultation-dao-impl/src/main/java/com/megatim/fdxconsultation/dao/impl/log/util/QueryExtendsWithApiUserActionSummarySearch.java b/fdx-consultation/fdxconsultation-dao-impl/src/main/java/com/megatim/fdxconsultation/dao/impl/log/util/QueryExtendsWithApiUserActionSummarySearch.java
new file mode 100644
index 0000000..c8ecffa
--- /dev/null
+++ b/fdx-consultation/fdxconsultation-dao-impl/src/main/java/com/megatim/fdxconsultation/dao/impl/log/util/QueryExtendsWithApiUserActionSummarySearch.java
@@ -0,0 +1,106 @@
+package com.megatim.fdxconsultation.dao.impl.log.util;
+
+import com.megatim.fdxconsultation.model.log.dtos.ApiUserActionSummarySearch;
+import javax.persistence.EntityManager;
+import javax.persistence.TypedQuery;
+
+/**
+ *
+ * @author Gabuntu
+ */
+public class QueryExtendsWithApiUserActionSummarySearch {
+
+ private final ApiUserActionSummarySearch apiUserActionSummarySearch;
+ private final String selectQueryString;
+ private final String whereQueryString;
+ private final String groupQueryString;
+ private final EntityManager em;
+
+ public QueryExtendsWithApiUserActionSummarySearch(
+ ApiUserActionSummarySearch apiUserActionSummarySearch,
+ EntityManager em,
+ String selectQueryString,
+ String whereQueryString,
+ String groupQueryString) {
+
+ this.apiUserActionSummarySearch = apiUserActionSummarySearch;
+ this.selectQueryString = selectQueryString;
+ this.whereQueryString = whereQueryString;
+ this.groupQueryString = groupQueryString;
+ this.em = em;
+ }
+
+ public TypedQuery<Object[]> query() {
+
+ TypedQuery<Object[]> query = em.createQuery(queryString(), Object[].class);
+ setParameter(query);
+ return query;
+ }
+
+ private void setParameter(TypedQuery<Object[]> query) {
+
+ if (apiUserActionSummarySearch.getParticipant() != null) {
+ query.setParameter("participant", apiUserActionSummarySearch.getParticipant().getCode());
+ }
+
+ if (apiUserActionSummarySearch.getDateDebut() != null) {
+ query.setParameter("dateDebut", apiUserActionSummarySearch.getDateDebut());
+ }
+
+ if (apiUserActionSummarySearch.getDateFin() != null) {
+ query.setParameter("dateFin", apiUserActionSummarySearch.getDateFin().toLocalDate().atTime(23, 59, 59));
+ }
+
+ }
+
+ private String queryString() {
+
+ StringBuilder stringBuilder = new StringBuilder(selectQueryString);
+
+ boolean result = withWhereString();
+ if (result) {
+ stringBuilder.append(" ").append(whereQueryString);
+ }
+
+ if (apiUserActionSummarySearch.getParticipant() != null) {
+ if (result) {
+ stringBuilder.append(" AND ");
+ } else {
+ stringBuilder.append(" WHERE ");
+ }
+
+ stringBuilder.append("u.userName = :participant");
+ result = true;
+ }
+
+ if (apiUserActionSummarySearch.getDateDebut() != null) {
+ if (result) {
+ stringBuilder.append(" AND ");
+ } else {
+ stringBuilder.append(" WHERE ");
+ }
+
+ stringBuilder.append("u.dateAction >= :dateDebut");
+ result = true;
+ }
+
+ if (apiUserActionSummarySearch.getDateFin() != null) {
+ if (result) {
+ stringBuilder.append(" AND ");
+ } else {
+ stringBuilder.append(" WHERE ");
+ }
+
+ stringBuilder.append("u.dateAction <= :dateFin");
+ }
+
+ stringBuilder.append(" ").append(groupQueryString);
+
+ return stringBuilder.toString();
+ }
+
+ private boolean withWhereString() {
+ return whereQueryString != null && !whereQueryString.isEmpty();
+ }
+
+}
--
Gitblit v1.10.0