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.announce.modules.workflow.business.prerequisite;
35
36 import fr.paris.lutece.plugins.announce.modules.workflow.service.AnnounceWorkflowPlugin;
37 import fr.paris.lutece.plugins.workflowcore.business.prerequisite.IPrerequisiteConfig;
38 import fr.paris.lutece.plugins.workflowcore.business.prerequisite.IPrerequisiteConfigDAO;
39 import fr.paris.lutece.util.sql.DAOUtil;
40
41
42
43
44 public class PublicationDatePrerequisiteConfigDAO implements IPrerequisiteConfigDAO
45 {
46 private static final String INSERT_PUBLICATION_DATE_PREREQUISITE = " INSERT INTO wf_prerequisite_announce_publication ( id_prerequisite, nb_days ) VALUES (?,?) ";
47 private static final String UPDATE_PUBLICATION_DATE_PREREQUISITE = " UPDATE wf_prerequisite_announce_publication SET nb_days = ? WHERE id_prerequisite = ? ";
48 private static final String DELETE_PUBLICATION_DATE_PREREQUISITE = " DELETE FROM wf_prerequisite_announce_publication WHERE id_prerequisite = ? ";
49 private static final String SELECT_PUBLICATION_DATE_PREREQUISITE = " SELECT id_prerequisite, nb_days FROM wf_prerequisite_announce_publication WHERE id_prerequisite = ?";
50
51
52
53
54 @Override
55 public void createConfig( IPrerequisiteConfig config )
56 {
57 DAOUtil daoUtil = new DAOUtil( INSERT_PUBLICATION_DATE_PREREQUISITE, AnnounceWorkflowPlugin.getPlugin( ) );
58 daoUtil.setInt( 1, config.getIdPrerequisite( ) );
59 daoUtil.setInt( 2, ( (PublicationDatePrerequisiteConfig) config ).getNbDays( ) );
60 daoUtil.executeUpdate( );
61 daoUtil.free( );
62 }
63
64
65
66
67 @Override
68 public void updateConfig( IPrerequisiteConfig config )
69 {
70 DAOUtil daoUtil = new DAOUtil( UPDATE_PUBLICATION_DATE_PREREQUISITE, AnnounceWorkflowPlugin.getPlugin( ) );
71 daoUtil.setInt( 1, ( (PublicationDatePrerequisiteConfig) config ).getNbDays( ) );
72 daoUtil.setInt( 2, config.getIdPrerequisite( ) );
73 daoUtil.executeUpdate( );
74 daoUtil.free( );
75 }
76
77
78
79
80 @Override
81 public void removeConfig( int nIdPrerequisite )
82 {
83 DAOUtil daoUtil = new DAOUtil( DELETE_PUBLICATION_DATE_PREREQUISITE, AnnounceWorkflowPlugin.getPlugin( ) );
84 daoUtil.setInt( 1, nIdPrerequisite );
85 daoUtil.executeUpdate( );
86 daoUtil.free( );
87 }
88
89
90
91
92 @Override
93 public IPrerequisiteConfig findByPrimaryKey( int nIdPrerequisite )
94 {
95 DAOUtil daoUtil = new DAOUtil( SELECT_PUBLICATION_DATE_PREREQUISITE, AnnounceWorkflowPlugin.getPlugin( ) );
96 daoUtil.setInt( 1, nIdPrerequisite );
97 PublicationDatePrerequisiteConfig config = null;
98 daoUtil.executeQuery( );
99 if ( daoUtil.next( ) )
100 {
101 config = new PublicationDatePrerequisiteConfig( );
102 config.setIdPrerequisite( daoUtil.getInt( 1 ) );
103 config.setNbDays( daoUtil.getInt( 2 ) );
104 }
105
106 daoUtil.free( );
107
108 return config;
109 }
110
111 }