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.reply.business.config;
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 public class TaskReplyConfigDAO implements ITaskConfigDAO<TaskReplyConfig>
45 {
46 private static final String SQL_QUERY_FIND_BY_PRIMARY_KEY = "SELECT id_task, is_mandatory, is_rich_text, title, default_message "
47 + " FROM workflow_task_reply_cf WHERE id_task = ?";
48 private static final String SQL_QUERY_INSERT = "INSERT INTO workflow_task_reply_cf"
49 + " (id_task, is_mandatory, is_rich_text, title, default_message) VALUES (?, ?, ?, ?, ? )";
50 private static final String SQL_QUERY_UPDATE = "UPDATE workflow_task_reply_cf" + " SET id_task = ?, is_mandatory = ?, is_rich_text = ?, title = ?, default_message = ? "
51 + " WHERE id_task = ?";
52 private static final String SQL_QUERY_DELETE = "DELETE FROM workflow_task_reply_cf WHERE id_task = ?";
53
54
55
56
57 @Override
58 public void delete( int nIdTask )
59 {
60 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE, WorkflowUtils.getPlugin( ) );
61
62 daoUtil.setInt( 1, nIdTask );
63 daoUtil.executeUpdate( );
64 daoUtil.free( );
65 }
66
67
68
69
70 @Override
71 public void insert( TaskReplyConfig config )
72 {
73 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_INSERT, WorkflowUtils.getPlugin( ) );
74
75 int index=1;
76 daoUtil.setInt( index++, config.getIdTask( ) );
77 daoUtil.setInt( index++, config.isMandatory( )?1:0 );
78 daoUtil.setInt( index++, config.isRichText( )?1:0 );
79 daoUtil.setString( index++, config.getTitle( ) );
80 daoUtil.setString( index++, config.getDefaultMessage( ) );
81
82 daoUtil.executeUpdate( );
83 daoUtil.free( );
84 }
85
86
87
88
89 @Override
90 public TaskReplyConfig load( int nIdTask )
91 {
92 TaskReplyConfig config = null;
93 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_FIND_BY_PRIMARY_KEY, WorkflowUtils.getPlugin( ) );
94
95 daoUtil.setInt( 1, nIdTask );
96
97 daoUtil.executeQuery( );
98
99 if ( daoUtil.next( ) )
100 {
101 config = new TaskReplyConfig( );
102
103 int index =1;
104 config.setIdTask( daoUtil.getInt( index++ ) );
105 config.setMandatory( daoUtil.getInt( index++ )==1 );
106 config.setRichText( daoUtil.getInt( index++ )==1 );
107 config.setTitle( daoUtil.getString( index++ ) );
108 config.setDefaultMessage( daoUtil.getString( index++ ) );
109 }
110
111 daoUtil.free( );
112
113 return config;
114 }
115
116
117
118
119 @Override
120 public void store( TaskReplyConfig config )
121 {
122 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_UPDATE, WorkflowUtils.getPlugin( ) );
123
124 int index = 1;
125
126 daoUtil.setInt( index++, config.getIdTask( ) );
127 daoUtil.setInt( index++, config.isMandatory( )?1:0 );
128 daoUtil.setInt( index++, config.isRichText( )?1:0 );
129 daoUtil.setString( index++, config.getTitle( ) );
130 daoUtil.setString( index++, config.getDefaultMessage( ) );
131
132 daoUtil.setInt( index++, config.getIdTask( ) );
133
134 daoUtil.executeUpdate( );
135 daoUtil.free( );
136 }
137 }