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 package fr.paris.lutece.plugins.directory.modules.multiview.business.record.filter.querypart.impl;
35
36 import java.util.Map;
37 import java.util.Set;
38
39 import org.apache.commons.lang3.StringUtils;
40 import org.apache.commons.lang3.math.NumberUtils;
41
42 import fr.paris.lutece.plugins.directory.modules.multiview.business.record.RecordParameters;
43 import fr.paris.lutece.plugins.directory.modules.multiview.business.record.filter.RecordFilterQueryBuilder;
44 import fr.paris.lutece.plugins.directory.modules.multiview.util.RecordEntryNameConstants;
45
46
47
48
49 public class RecordFilterEntryQueryPart extends AbstractRecordFilterQueryPart
50 {
51
52 private static final int DEFAULT_POSITION = NumberUtils.INTEGER_MINUS_ONE;
53 private static final String ENTRY_VALUE_QUERY_PATTERN = "column_%1$s.column_%1$s_value = ";
54 private static final String ENTRY_VALUE_NAME_PATTERN = "$column_%s$";
55
56
57
58
59 @Override
60 public void buildRecordFilterQuery( RecordParameters recordParameters )
61 {
62 int nPosition = DEFAULT_POSITION;
63
64 if ( recordParameters != null )
65 {
66 Map<String, Object> mapRecordParametersNameValues = recordParameters.getRecordParametersMap( );
67 if ( mapRecordParametersNameValues != null && !mapRecordParametersNameValues.isEmpty( ) )
68 {
69 nPosition = findFilterColumnPosition( mapRecordParametersNameValues );
70 }
71 }
72
73 StringBuilder stringBuilderEntryQueryPattern = new StringBuilder( );
74 if ( nPosition != DEFAULT_POSITION )
75 {
76 String strEntryValueQueryPattern = String.format( ENTRY_VALUE_QUERY_PATTERN, nPosition );
77 String strEntryNamePattern = String.format( ENTRY_VALUE_NAME_PATTERN, nPosition );
78
79 stringBuilderEntryQueryPattern.append( strEntryValueQueryPattern );
80 stringBuilderEntryQueryPattern.append( strEntryNamePattern );
81 }
82
83 setRecordFilterQuery( RecordFilterQueryBuilder.buildRecordFilterQuery( stringBuilderEntryQueryPattern.toString( ), recordParameters ) );
84 }
85
86
87
88
89
90
91
92
93 private int findFilterColumnPosition( Map<String, Object> mapRecordParametersNameValues )
94 {
95 int nPosition = DEFAULT_POSITION;
96
97 Set<String> setParameterName = mapRecordParametersNameValues.keySet( );
98 for ( String strParameterName : setParameterName )
99 {
100 if ( strParameterName.startsWith( RecordEntryNameConstants.FILTER_ENTRY_BASE_NAME_PATTERN ) )
101 {
102 String strColumnNumber = strParameterName.replaceFirst( RecordEntryNameConstants.FILTER_ENTRY_BASE_NAME_PATTERN, StringUtils.EMPTY );
103 nPosition = NumberUtils.toInt( strColumnNumber, NumberUtils.INTEGER_MINUS_ONE );
104 break;
105 }
106 }
107
108 return nPosition;
109 }
110 }