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.history;
35
36 import fr.paris.lutece.plugins.workflow.modules.appointmentants.service.WorkflowAppointmentAntsPlugin;
37 import fr.paris.lutece.portal.service.plugin.Plugin;
38 import fr.paris.lutece.util.sql.DAOUtil;
39
40
41
42
43
44
45 public class TaskAntsAppointmentHistoryDAO implements ITaskAntsAppointmentHistoryDAO
46 {
47 public static final String BEAN_NAME = WorkflowAppointmentAntsPlugin.PLUGIN_NAME + ".taskAntsAppointmentHistoryDAO";
48
49
50
51
52 private static final String SQL_QUERY_SELECT = "SELECT id_history, id_task, is_task_successful, value_ants_application_numbers FROM workflow_task_ants_appointment_history WHERE id_history = ? AND id_task = ?";
53 private static final String SQL_QUERY_INSERT = "INSERT INTO workflow_task_ants_appointment_history ( id_history, id_task, is_task_successful, value_ants_application_numbers ) VALUES ( ?, ?, ?, ? )";
54 private static final String SQL_QUERY_DELETE_BY_HISTORY = "DELETE FROM workflow_task_ants_appointment_history WHERE id_history = ? AND id_task = ?";
55 private static final String SQL_QUERY_DELETE_BY_TASK = "DELETE FROM workflow_task_ants_appointment_history WHERE id_task = ?";
56
57
58
59
60 @Override
61 public void insert( TaskAntsAppointmentHistory history, Plugin plugin )
62 {
63 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_INSERT, plugin ) )
64 {
65 int nIndex = 0;
66 daoUtil.setInt( ++nIndex, history.getIdResourceHistory( ) );
67 daoUtil.setInt( ++nIndex, history.getIdTask( ) );
68 daoUtil.setBoolean( ++nIndex, history.isTaskSuccessful( ) );
69 daoUtil.setString( ++nIndex, history.getAntsApplicationNumbers( ) );
70
71 daoUtil.executeUpdate( );
72 }
73 }
74
75
76
77
78 @Override
79 public TaskAntsAppointmentHistory load( int idHistory, int idTask, Plugin plugin )
80 {
81 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT, plugin ) )
82 {
83 int nIndex = 0;
84 daoUtil.setInt( ++nIndex, idHistory );
85 daoUtil.setInt( ++nIndex, idTask );
86 daoUtil.executeQuery( );
87
88 TaskAntsAppointmentHistory taskAntsAppointmentHistory = null;
89
90 if ( daoUtil.next( ) )
91 {
92 taskAntsAppointmentHistory = new TaskAntsAppointmentHistory( );
93 nIndex = 0;
94
95 taskAntsAppointmentHistory.setIdResourceHistory( daoUtil.getInt( ++nIndex ) );
96 taskAntsAppointmentHistory.setIdTask( daoUtil.getInt( ++nIndex ) );
97 taskAntsAppointmentHistory.setTaskSuccessState( daoUtil.getBoolean( ++nIndex ) );
98 taskAntsAppointmentHistory.setAntsApplicationNumbers( daoUtil.getString( ++nIndex ) );
99 }
100 return taskAntsAppointmentHistory;
101 }
102 }
103
104
105
106
107 @Override
108 public void deleteByHistory(int idHistory, int idTask, Plugin plugin)
109 {
110 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE_BY_HISTORY, plugin ) )
111 {
112 int nIndex = 0;
113 daoUtil.setInt( ++nIndex, idHistory );
114 daoUtil.setInt( ++nIndex, idTask );
115
116 daoUtil.executeUpdate( );
117 }
118 }
119
120
121
122
123 @Override
124 public void deleteByTask(int idTask, Plugin plugin)
125 {
126 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE_BY_TASK, plugin ) )
127 {
128 int nIndex = 0;
129 daoUtil.setInt( ++nIndex, idTask );
130
131 daoUtil.executeUpdate( );
132 }
133 }
134 }