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.workflow.modules.comment.business;
35
36 import fr.paris.lutece.plugins.workflow.utils.WorkflowUtils;
37 import fr.paris.lutece.plugins.workflowcore.business.config.ITaskConfigDAO;
38 import fr.paris.lutece.util.sql.DAOUtil;
39
40
41
42
43
44
45 public class TaskCommentConfigDAO implements ITaskConfigDAO<TaskCommentConfig>
46 {
47 private static final String SQL_QUERY_FIND_BY_PRIMARY_KEY = "SELECT id_task,title,is_mandatory,is_richtext"
48 + " FROM workflow_task_comment_config WHERE id_task=?";
49 private static final String SQL_QUERY_INSERT = "INSERT INTO workflow_task_comment_config " + "(id_task,title,is_mandatory,is_richtext)VALUES(?,?,?,?)";
50 private static final String SQL_QUERY_UPDATE = "UPDATE workflow_task_comment_config " + "SET id_task=?,title=?,is_mandatory=?,is_richtext=? "
51 + " WHERE id_task=?";
52 private static final String SQL_QUERY_DELETE = "DELETE FROM workflow_task_comment_config WHERE id_task=? ";
53
54
55
56
57 @Override
58 public synchronized void insert( TaskCommentConfig config )
59 {
60 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_INSERT, WorkflowUtils.getPlugin( ) ) )
61 {
62 int nPos = 0;
63
64 daoUtil.setInt( ++nPos, config.getIdTask( ) );
65 daoUtil.setString( ++nPos, config.getTitle( ) );
66 daoUtil.setBoolean( ++nPos, config.isMandatory( ) );
67 daoUtil.setBoolean( ++nPos, config.isRichText( ) );
68
69 daoUtil.executeUpdate( );
70 }
71 }
72
73
74
75
76 @Override
77 public void store( TaskCommentConfig config )
78 {
79 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_UPDATE, WorkflowUtils.getPlugin( ) ) )
80 {
81 int nPos = 0;
82
83 daoUtil.setInt( ++nPos, config.getIdTask( ) );
84 daoUtil.setString( ++nPos, config.getTitle( ) );
85 daoUtil.setBoolean( ++nPos, config.isMandatory( ) );
86 daoUtil.setBoolean( ++nPos, config.isRichText( ) );
87
88 daoUtil.setInt( ++nPos, config.getIdTask( ) );
89 daoUtil.executeUpdate( );
90 }
91 }
92
93
94
95
96 @Override
97 public TaskCommentConfig load( int nIdState )
98 {
99 TaskCommentConfig config = null;
100 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_FIND_BY_PRIMARY_KEY, WorkflowUtils.getPlugin( ) ) )
101 {
102 daoUtil.setInt( 1, nIdState );
103 daoUtil.executeQuery( );
104
105 if ( daoUtil.next( ) )
106 {
107 int nPos = 0;
108 config = new TaskCommentConfig( );
109 config.setIdTask( daoUtil.getInt( ++nPos ) );
110 config.setTitle( daoUtil.getString( ++nPos ) );
111 config.setMandatory( daoUtil.getBoolean( ++nPos ) );
112 config.setRichText( daoUtil.getBoolean( ++nPos ) );
113 }
114 }
115 return config;
116 }
117
118
119
120
121 @Override
122 public void delete( int nIdState )
123 {
124 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE, WorkflowUtils.getPlugin( ) ) )
125 {
126 daoUtil.setInt( 1, nIdState );
127 daoUtil.executeUpdate( );
128 }
129 }
130 }