1 /*
2 * Copyright (c) 2002-2018, Mairie de Paris
3 * All rights reserved.
4 *
5 * Redistribution and use in source and binary forms, with or without
6 * modification, are permitted provided that the following conditions
7 * are met:
8 *
9 * 1. Redistributions of source code must retain the above copyright notice
10 * and the following disclaimer.
11 *
12 * 2. Redistributions in binary form must reproduce the above copyright notice
13 * and the following disclaimer in the documentation and/or other materials
14 * provided with the distribution.
15 *
16 * 3. Neither the name of 'Mairie de Paris' nor 'Lutece' nor the names of its
17 * contributors may be used to endorse or promote products derived from
18 * this software without specific prior written permission.
19 *
20 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
21 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
22 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
23 * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDERS OR CONTRIBUTORS BE
24 * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
25 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
26 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
27 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
28 * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
29 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
30 * POSSIBILITY OF SUCH DAMAGE.
31 *
32 * License 1.0
33 */
34 package fr.paris.lutece.plugins.directory.modules.multiview.business.record.column.querypart;
35
36 import java.util.ArrayList;
37 import java.util.List;
38
39 import org.apache.commons.lang3.StringUtils;
40
41 import fr.paris.lutece.plugins.directory.modules.multiview.business.record.filter.RecordFilterQueryConstants;
42
43 /**
44 * Query builder utility class for RecordColumn class
45 */
46 public final class RecordColumnQueryBuilder
47 {
48 /**
49 * Constructor
50 */
51 private RecordColumnQueryBuilder( )
52 {
53
54 }
55
56 /**
57 * Return the list of all select query part from the given list of record columns
58 *
59 * @param listRecordColumnQueryPart
60 * The list of record column query part to retrieve the query parts from
61 * @return the list of all select query parts from the given list of record columns
62 */
63 public static List<String> buildRecordColumnSelectQueryPart( List<IRecordColumnQueryPart> listRecordColumnQueryPart )
64 {
65 List<String> listSelectQueryParts = new ArrayList<>( );
66
67 if ( listRecordColumnQueryPart != null && !listRecordColumnQueryPart.isEmpty( ) )
68 {
69 for ( IRecordColumnQueryPart recordColumnQueryPart : listRecordColumnQueryPart )
70 {
71 String strRecordColumnSelectQueryPart = recordColumnQueryPart.getRecordColumnSelectQuery( );
72 if ( StringUtils.isNotBlank( strRecordColumnSelectQueryPart ) )
73 {
74 listSelectQueryParts.add( strRecordColumnSelectQueryPart );
75 }
76 }
77 }
78
79 return listSelectQueryParts;
80 }
81
82 /**
83 * Return the list of all from query part from the given list of record columns
84 *
85 * @param listRecordColumnQueryPart
86 * The list of record column query part to retrieve the query parts from
87 * @return the list of all from query parts from the given list of record columns
88 */
89 public static List<String> buildRecordColumnFromQueryParts( List<IRecordColumnQueryPart> listRecordColumnQueryPart )
90 {
91 List<String> listRecordColumnFromQueryParts = new ArrayList<>( );
92
93 if ( listRecordColumnQueryPart != null && !listRecordColumnQueryPart.isEmpty( ) )
94 {
95 for ( IRecordColumnQueryPart recordColumnQueryPart : listRecordColumnQueryPart )
96 {
97 String strRecordColumnFromQuery = recordColumnQueryPart.getRecordColumnFromQuery( );
98 if ( StringUtils.isNotBlank( strRecordColumnFromQuery ) )
99 {
100 listRecordColumnFromQueryParts.add( strRecordColumnFromQuery );
101 }
102 }
103 }
104
105 return listRecordColumnFromQueryParts;
106 }
107
108 /**
109 * Populate the given string builder with all the join queries from all the record column from the given list
110 *
111 * @param stringBuilderJoinQueryPart
112 * The string builder to populate with all the join queries
113 * @param listRecordColumnQueryPart
114 * The list of all record column to retrieve the list of all join queries from
115 */
116 public static void buildRecordColumnJoinQueryParts( StringBuilder stringBuilderJoinQueryPart, List<IRecordColumnQueryPart> listRecordColumnQueryPart )
117 {
118 for ( IRecordColumnQueryPart recordColumnQueryPart : listRecordColumnQueryPart )
119 {
120 List<String> listRecordColumnJoinQueries = recordColumnQueryPart.getRecordColumnJoinQueries( );
121 if ( listRecordColumnJoinQueries != null && !listRecordColumnJoinQueries.isEmpty( ) )
122 {
123 for ( String strRecordColumnJoinQuery : listRecordColumnJoinQueries )
124 {
125 if ( StringUtils.isNotBlank( strRecordColumnJoinQuery ) )
126 {
127 stringBuilderJoinQueryPart.append( strRecordColumnJoinQuery );
128 stringBuilderJoinQueryPart.append( RecordFilterQueryConstants.SPACE_SEPARATOR );
129 }
130 }
131 }
132 }
133 }
134 }