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-commons/fdxcommons-tools/src/main/java/com/megatim/fdxcommons/tools/database/queries/jpql/JqplQueryString.java | 54 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 54 insertions(+), 0 deletions(-)
diff --git a/fdx-commons/fdxcommons-tools/src/main/java/com/megatim/fdxcommons/tools/database/queries/jpql/JqplQueryString.java b/fdx-commons/fdxcommons-tools/src/main/java/com/megatim/fdxcommons/tools/database/queries/jpql/JqplQueryString.java
new file mode 100644
index 0000000..6c423ad
--- /dev/null
+++ b/fdx-commons/fdxcommons-tools/src/main/java/com/megatim/fdxcommons/tools/database/queries/jpql/JqplQueryString.java
@@ -0,0 +1,54 @@
+package com.megatim.fdxcommons.tools.database.queries.jpql;
+
+import com.megatim.fdxcommons.model.enumeration.OrderByType;
+import com.megatim.fdxcommons.model.pojo.OrderByDefinition;
+import com.megatim.fdxcommons.tools.database.queries.metadata.jpql.JpqlQueryCriterion;
+import java.util.List;
+
+/**
+ *
+ * @author ASUS
+ */
+public class JqplQueryString {
+
+ private final String simpleClassName;
+
+ private final JpqlQueryCriterion queryCriterion;
+
+ public JqplQueryString(String simpleClassName, JpqlQueryCriterion queryCriterion) {
+ this.simpleClassName = simpleClassName;
+ this.queryCriterion = queryCriterion;
+ }
+
+ public String selectQuery(List<OrderByDefinition> orderByFields) throws Exception {
+ String classAlias = simpleClassName.toLowerCase().charAt(0) + "";
+ String selectFromQueryPart = "SELECT " + classAlias + " FROM " + simpleClassName + " " + classAlias + " ";
+ String whereQueryPart = new JpqlWhereQueryString(queryCriterion, classAlias).query();
+ String query = selectFromQueryPart + " " + whereQueryPart + " " + orderByClause(classAlias, orderByFields);
+ return query;
+ }
+
+ public String countQuery() throws Exception {
+ String classAlias = simpleClassName.toLowerCase().charAt(0) + "";
+ String selectFromQueryPart = "SELECT COUNT(*) FROM " + simpleClassName + " " + classAlias + " ";
+ String whereQueryPart = new JpqlWhereQueryString(queryCriterion, classAlias).query();
+ String query = selectFromQueryPart + " " + whereQueryPart;
+ return query;
+ }
+
+ private String orderByClause(String classAlias, List<OrderByDefinition> orderByFields) {
+ StringBuilder orderBy = new StringBuilder("ORDER BY ");
+ if (orderByFields == null || orderByFields.isEmpty()) {
+ return "";
+ }
+
+ for (OrderByDefinition def : orderByFields) {
+ if (def.getFieldName() != null && !def.getFieldName().isEmpty()) {
+ String orderByType = def.getOrderByType() != null ? def.getOrderByType().name() : OrderByType.ASC.name();
+ orderBy.append(classAlias).append(".").append(def.getFieldName()).append(" ").append(orderByType).append(",");
+ }
+ }
+ orderBy.replace(orderBy.length() - 1, orderBy.length(), "");//retirer la dernière virgule
+ return orderBy.toString();
+ }
+}
--
Gitblit v1.10.0