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.column.querypart.impl;
35
36 import java.util.ArrayList;
37 import java.util.LinkedHashMap;
38 import java.util.List;
39 import java.util.Map;
40
41 import org.apache.commons.lang3.StringUtils;
42
43 import fr.paris.lutece.plugins.directory.modules.multiview.util.RecordWorkflowStateNameConstants;
44 import fr.paris.lutece.util.sql.DAOUtil;
45
46
47
48
49 public class RecordColumnWorkflowStateQueryPart extends AbstractRecordColumnQueryPart
50 {
51
52 private static final String WORKFLOW_STATE_SELECT_QUERY_PART = "ws_workflow_state.name AS workflow_state_name";
53 private static final String WORKFLOW_STATE_FORM_QUERY_PART = StringUtils.EMPTY;
54 private static final String WORKFLOW_STATE_JOIN_WORKFLOW_RESOURCE_QUERY_PART = "LEFT JOIN workflow_resource_workflow AS wf_resource_workflow ON wf_resource_workflow.id_resource = record.id_record";
55 private static final String WORKFLOW_STATE_JOIN_WORKFLOW_STATE_QUERY_PART = "LEFT JOIN workflow_state AS ws_workflow_state ON ws_workflow_state.id_state = wf_resource_workflow.id_state";
56
57
58
59
60 @Override
61 public String getRecordColumnSelectQuery( )
62 {
63 return WORKFLOW_STATE_SELECT_QUERY_PART;
64 }
65
66
67
68
69 @Override
70 public String getRecordColumnFromQuery( )
71 {
72 return WORKFLOW_STATE_FORM_QUERY_PART;
73 }
74
75
76
77
78 @Override
79 public List<String> getRecordColumnJoinQueries( )
80 {
81 List<String> listRecordColumnJoinQueries = new ArrayList<>( );
82 listRecordColumnJoinQueries.add( WORKFLOW_STATE_JOIN_WORKFLOW_RESOURCE_QUERY_PART );
83 listRecordColumnJoinQueries.add( WORKFLOW_STATE_JOIN_WORKFLOW_STATE_QUERY_PART );
84
85 return listRecordColumnJoinQueries;
86 }
87
88
89
90
91 @Override
92 protected Map<String, Object> getMapRecordColumnValues( DAOUtil daoUtil )
93 {
94 Map<String, Object> mapRecordColumnValues = new LinkedHashMap<>( );
95 String strWorkflowStateName = daoUtil.getString( RecordWorkflowStateNameConstants.COLUMN_WORKFLOW_STATE_NAME );
96 mapRecordColumnValues.put( RecordWorkflowStateNameConstants.COLUMN_WORKFLOW_STATE_NAME, strWorkflowStateName );
97
98 return mapRecordColumnValues;
99 }
100 }