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.document.business.portlet;
35
36 import fr.paris.lutece.portal.service.util.AppPropertiesService;
37
38 import org.apache.commons.lang3.StringUtils;
39
40
41
42
43 public class PortletOrder
44 {
45
46 public static final int DATE_UPDATE_PORTLET = AppPropertiesService.getPropertyInt( "document.order.date_update_portlet", 0 );
47 public static final int PAGE_NAME = AppPropertiesService.getPropertyInt( "document.order.page_name", 1 );
48 public static final int PAGE_ID = AppPropertiesService.getPropertyInt( "document.order.page_id", 2 );
49 public static final int PORTLET_NAME = AppPropertiesService.getPropertyInt( "document.order.portlet_name", 3 );
50 public static final int SORT_ASC = AppPropertiesService.getPropertyInt( "document.order.asc", 1 );
51 private static final String SQL_ORDER_BY_PAGE_NAME = " ORDER BY f.name ";
52 private static final String SQL_ORDER_BY_PAGE_ID = " ORDER BY a.id_page ";
53 private static final String SQL_ORDER_BY_PORTLET_NAME = " ORDER BY a.name ";
54 private static final String SQL_ORDER_BY_DATE_UPDATE_PORTLET = " ORDER BY a.date_update ";
55 private static final String SQL_ASC = " ASC ";
56 private static final String SQL_DESC = " DESC ";
57
58
59 private boolean _bSortAsc;
60 private int _nTypeOrder;
61
62
63
64
65 public PortletOrder( )
66 {
67 _bSortAsc = false;
68 _nTypeOrder = DATE_UPDATE_PORTLET;
69 }
70
71
72
73
74
75
76
77
78
79 public PortletOrder( boolean bSortAsc, int nTypeOrder )
80 {
81 _bSortAsc = bSortAsc;
82 _nTypeOrder = nTypeOrder;
83 }
84
85
86
87
88
89
90
91 public void setSortAsc( boolean bSortAsc )
92 {
93 _bSortAsc = bSortAsc;
94 }
95
96
97
98
99
100
101 public boolean isSortAsc( )
102 {
103 return _bSortAsc;
104 }
105
106
107
108
109
110
111
112 public void setTypeOrder( int nTypeOrder )
113 {
114 _nTypeOrder = nTypeOrder;
115 }
116
117
118
119
120
121
122 public int getTypeOrder( )
123 {
124 return _nTypeOrder;
125 }
126
127
128
129
130
131
132 public String getSQLOrderBy( )
133 {
134 StringBuilder sbSQL = new StringBuilder( );
135
136 if ( _nTypeOrder == PAGE_NAME )
137 {
138 sbSQL.append( SQL_ORDER_BY_PAGE_NAME );
139 }
140 else
141 if ( _nTypeOrder == PAGE_ID )
142 {
143 sbSQL.append( SQL_ORDER_BY_PAGE_ID );
144 }
145 else
146 if ( _nTypeOrder == PORTLET_NAME )
147 {
148 sbSQL.append( SQL_ORDER_BY_PORTLET_NAME );
149 }
150 else
151 if ( _nTypeOrder == DATE_UPDATE_PORTLET )
152 {
153 sbSQL.append( SQL_ORDER_BY_DATE_UPDATE_PORTLET );
154 }
155
156 if ( StringUtils.isNotBlank( sbSQL.toString( ) ) )
157 {
158 sbSQL.append( _bSortAsc ? SQL_ASC : SQL_DESC );
159 }
160
161 return sbSQL.toString( );
162 }
163 }