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.appointmentants.business;
35
36 import fr.paris.lutece.plugins.workflow.modules.appointmentants.service.WorkflowAppointmentAntsPlugin;
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 TaskAntsAppointmentConfigDAO implements ITaskConfigDAO<TaskAntsAppointmentConfig>
46 {
47
48 public static final String BEAN_NAME = "workflow-appointmentants.taskAntsAppointmentConfigDAO";
49
50
51
52
53 private static final String SQL_QUERY_SELECT = "SELECT id_task, id_form, id_field_entry FROM workflow_task_ants_appointment WHERE id_task = ?";
54 private static final String SQL_QUERY_INSERT = "INSERT INTO workflow_task_ants_appointment ( id_task, id_form, id_field_entry ) VALUES ( ?, ?, ? ) ";
55 private static final String SQL_QUERY_DELETE = "DELETE FROM workflow_task_ants_appointment WHERE id_task = ? ";
56 private static final String SQL_QUERY_UPDATE = "UPDATE workflow_task_ants_appointment SET id_form = ?, id_field_entry = ? WHERE id_task = ?";
57
58
59
60
61 @Override
62 public void insert( TaskAntsAppointmentConfig config )
63 {
64 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_INSERT, WorkflowAppointmentAntsPlugin.getPlugin( ) ) )
65 {
66 int nIndex = 0;
67 daoUtil.setInt( ++nIndex, config.getIdTask( ) );
68 daoUtil.setInt( ++nIndex, config.getIdForm() );
69 daoUtil.setInt( ++nIndex, config.getIdFieldEntry( ) );
70
71 daoUtil.executeUpdate( );
72 }
73 }
74
75
76
77
78 @Override
79 public TaskAntsAppointmentConfig load( int nIdTask )
80 {
81 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT, WorkflowAppointmentAntsPlugin.getPlugin( ) ) )
82 {
83 daoUtil.setInt( 1, nIdTask );
84 daoUtil.executeQuery( );
85
86 TaskAntsAppointmentConfig taskAntsAppointmentConfig = null;
87
88 if ( daoUtil.next( ) )
89 {
90 taskAntsAppointmentConfig = new TaskAntsAppointmentConfig( );
91 int nIndex = 0;
92
93 taskAntsAppointmentConfig.setIdTask( daoUtil.getInt( ++nIndex ) );
94 taskAntsAppointmentConfig.setIdForm( daoUtil.getInt( ++nIndex ) );
95 taskAntsAppointmentConfig.setIdFieldEntry( daoUtil.getInt( ++nIndex ) );
96 }
97
98 return taskAntsAppointmentConfig;
99 }
100 }
101
102
103
104
105 @Override
106 public void store( TaskAntsAppointmentConfig config )
107 {
108 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_UPDATE, WorkflowAppointmentAntsPlugin.getPlugin( ) ) )
109 {
110 int nIndex = 0;
111 daoUtil.setInt( ++nIndex, config.getIdForm( ) );
112 daoUtil.setInt( ++nIndex, config.getIdFieldEntry( ) );
113 daoUtil.setInt( ++nIndex, config.getIdTask( ) );
114
115 daoUtil.executeUpdate( );
116 }
117 }
118
119
120
121
122 @Override
123 public void delete( int nIdTask )
124 {
125 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE, WorkflowAppointmentAntsPlugin.getPlugin( ) ) )
126 {
127 daoUtil.setInt( 1, nIdTask );
128 daoUtil.executeUpdate( );
129 }
130 }
131 }