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.assignment.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 TaskAssignmentConfigDAO implements ITaskConfigDAO<TaskAssignmentConfig>
46 {
47 private static final String SQL_QUERY_FIND_BY_PRIMARY_KEY = "SELECT id_task,title,is_multiple_owner,is_notify,message,subject,is_use_user_name"
48 + " FROM workflow_task_assignment_cf WHERE id_task=?";
49 private static final String SQL_QUERY_INSERT = "INSERT INTO workflow_task_assignment_cf "
50 + "(id_task,title,is_multiple_owner,is_notify,message,subject,is_use_user_name)VALUES(?,?,?,?,?,?,?)";
51 private static final String SQL_QUERY_UPDATE = "UPDATE workflow_task_assignment_cf "
52 + "SET id_task=?,title=?,is_multiple_owner=?,is_notify=?,message=?,subject=?,is_use_user_name=? " + " WHERE id_task=? ";
53 private static final String SQL_QUERY_DELETE = "DELETE FROM workflow_task_assignment_cf WHERE id_task=? ";
54
55
56
57
58 @Override
59 public synchronized void insert( TaskAssignmentConfig config )
60 {
61 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_INSERT, WorkflowUtils.getPlugin( ) ) )
62 {
63 int nPos = 0;
64
65 daoUtil.setInt( ++nPos, config.getIdTask( ) );
66 daoUtil.setString( ++nPos, config.getTitle( ) );
67
68 daoUtil.setBoolean( ++nPos, config.isMultipleOwner( ) );
69 daoUtil.setBoolean( ++nPos, config.isNotify( ) );
70 daoUtil.setString( ++nPos, config.getMessage( ) );
71 daoUtil.setString( ++nPos, config.getSubject( ) );
72 daoUtil.setBoolean( ++nPos, config.isUseUserName( ) );
73 daoUtil.executeUpdate( );
74 }
75 }
76
77
78
79
80 @Override
81 public void store( TaskAssignmentConfig config )
82 {
83 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_UPDATE, WorkflowUtils.getPlugin( ) ) )
84 {
85 int nPos = 0;
86
87 daoUtil.setInt( ++nPos, config.getIdTask( ) );
88 daoUtil.setString( ++nPos, config.getTitle( ) );
89
90 daoUtil.setBoolean( ++nPos, config.isMultipleOwner( ) );
91 daoUtil.setBoolean( ++nPos, config.isNotify( ) );
92 daoUtil.setString( ++nPos, config.getMessage( ) );
93 daoUtil.setString( ++nPos, config.getSubject( ) );
94 daoUtil.setBoolean( ++nPos, config.isUseUserName( ) );
95 daoUtil.setInt( ++nPos, config.getIdTask( ) );
96 daoUtil.executeUpdate( );
97 }
98 }
99
100
101
102
103 @Override
104 public TaskAssignmentConfig load( int nIdTask )
105 {
106 TaskAssignmentConfig config = null;
107 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_FIND_BY_PRIMARY_KEY, WorkflowUtils.getPlugin( ) ) )
108 {
109 daoUtil.setInt( 1, nIdTask );
110 daoUtil.executeQuery( );
111
112 if ( daoUtil.next( ) )
113 {
114 int nPos = 0;
115 config = new TaskAssignmentConfig( );
116 config.setIdTask( daoUtil.getInt( ++nPos ) );
117 config.setTitle( daoUtil.getString( ++nPos ) );
118
119 config.setMultipleOwner( daoUtil.getBoolean( ++nPos ) );
120 config.setNotify( daoUtil.getBoolean( ++nPos ) );
121 config.setMessage( daoUtil.getString( ++nPos ) );
122 config.setSubject( daoUtil.getString( ++nPos ) );
123 config.setUseUserName( daoUtil.getBoolean( ++nPos ) );
124 }
125 }
126 return config;
127 }
128
129
130
131
132 @Override
133 public void delete( int nIdTask )
134 {
135 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE, WorkflowUtils.getPlugin( ) ) )
136 {
137 daoUtil.setInt( 1, nIdTask );
138 daoUtil.executeUpdate( );
139 }
140 }
141 }