add fdx-commons and fdx-consultation

Kenmegne

7 days ago 23a46b4be35277e06ec89f48730eeb694e686be8

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
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();
    }
 
}