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.state.business;
35
36 import fr.paris.lutece.plugins.workflowcore.business.config.ITaskConfigDAO;
37 import fr.paris.lutece.util.sql.DAOUtil;
38
39 public class ChooseStateTaskConfigDao implements ITaskConfigDAO<ChooseStateTaskConfig>
40 {
41
42
43 private static final String SQL_INSERT = "INSERT INTO workflow_task_choose_state_config (id_task, controller_name, id_state_ok, id_state_ko) VALUES (?, ?, ?, ?)";
44 private static final String SQL_UPDATE = "UPDATE workflow_task_choose_state_config SET controller_name = ?, id_state_ok = ?, id_state_ko = ? WHERE id_task = ?";
45 private static final String SQL_DELETE = "DELETE FROM workflow_task_choose_state_config WHERE id_task = ?";
46 private static final String SQL_SELECT = "SELECT id_task, controller_name, id_state_ok, id_state_ko FROM workflow_task_choose_state_config WHERE id_task = ?";
47
48 @Override
49 public void insert( ChooseStateTaskConfig config )
50 {
51 try ( DAOUtil daoUtil = new DAOUtil( SQL_INSERT ) )
52 {
53 int nPos = 1;
54 daoUtil.setInt( nPos++, config.getIdTask( ) );
55 daoUtil.setString( nPos++, config.getControllerName( ) );
56 daoUtil.setInt( nPos++, config.getIdStateOK( ) );
57 daoUtil.setInt( nPos++, config.getIdStateKO( ) );
58 daoUtil.executeUpdate( );
59 }
60
61 }
62
63 @Override
64 public void store( ChooseStateTaskConfig config )
65 {
66 try ( DAOUtil daoUtil = new DAOUtil( SQL_UPDATE ) )
67 {
68 int nPos = 1;
69 daoUtil.setString( nPos++, config.getControllerName( ) );
70 daoUtil.setInt( nPos++, config.getIdStateOK( ) );
71 daoUtil.setInt( nPos++, config.getIdStateKO( ) );
72 daoUtil.setInt( nPos++, config.getIdTask( ) );
73
74 daoUtil.executeUpdate( );
75 }
76
77 }
78
79 @Override
80 public ChooseStateTaskConfig load( int nIdTask )
81 {
82 ChooseStateTaskConfig config = null;
83
84 try ( DAOUtil daoUtil = new DAOUtil( SQL_SELECT ) )
85 {
86 int nPos = 1;
87 daoUtil.setInt( nPos++, nIdTask );
88 daoUtil.executeQuery( );
89
90 if ( daoUtil.next( ) )
91 {
92 int nIndex = 1;
93 config = new ChooseStateTaskConfig( );
94 config.setIdTask( daoUtil.getInt( nIndex++ ) );
95 config.setControllerName( daoUtil.getString( nIndex++ ) );
96 config.setIdStateOK( daoUtil.getInt( nIndex++ ) );
97 config.setIdStateKO( daoUtil.getInt( nIndex++ ) );
98 }
99 }
100 return config;
101 }
102
103 @Override
104 public void delete( int nIdTask )
105 {
106 try ( DAOUtil daoUtil = new DAOUtil( SQL_DELETE ) )
107 {
108 int nPos = 1;
109 daoUtil.setInt( nPos++, nIdTask );
110
111 daoUtil.executeUpdate( );
112 }
113 }
114 }