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.unittree.modules.notification.business;
35
36 import fr.paris.lutece.portal.service.plugin.Plugin;
37 import fr.paris.lutece.util.sql.DAOUtil;
38
39
40
41
42 public class NotificationDAO implements INotificationDAO
43 {
44 private final String SQL_SELECT_BY_UNIT = "SELECT id_unit, email, has_notif, use_email, use_list FROM unittree_unit_notification WHERE id_unit = ?";
45 private final String SQL_DELETE_BY_UNIT = "DELETE FROM unittree_unit_notification WHERE id_unit = ?";
46
47 private final String SQL_UPDATE_NOTIFICATION = "UPDATE unittree_unit_notification SET email = ?, has_notif = ?, use_email = ?, use_list = ? WHERE id_unit = ?";
48 private final String SQL_INSERT_NOTIFICATION = "INSERT INTO unittree_unit_notification ( email, has_notif, use_email, use_list, id_unit ) VALUES ( ?, ?, ?, ?, ? )";
49
50
51
52
53 @Override
54 public Notification loadByIdUnit( int nIdUnit, Plugin plugin )
55 {
56 Notification notification = null;
57
58 DAOUtil daoUtil = new DAOUtil( SQL_SELECT_BY_UNIT, plugin );
59 daoUtil.setInt( 1, nIdUnit );
60 daoUtil.executeQuery( );
61
62 if ( daoUtil.next( ) )
63 {
64 int nIndex = 1;
65
66 notification = new Notification( );
67 notification.setIdUnit( daoUtil.getInt( nIndex++ ) );
68 notification.setEmail( daoUtil.getString( nIndex++ ) );
69 notification.setHasNotif( daoUtil.getBoolean( nIndex++ ) );
70 notification.setUseEmail( daoUtil.getBoolean( nIndex++ ) );
71 notification.setUseList( daoUtil.getBoolean( nIndex++ ) );
72 }
73
74 daoUtil.free( );
75
76 return notification;
77 }
78
79
80
81
82 @Override
83 public void removeForUnit( int nIdUnit, Plugin plugin )
84 {
85 DAOUtil daoUtil = new DAOUtil( SQL_DELETE_BY_UNIT, plugin );
86 daoUtil.setInt( 1, nIdUnit );
87 daoUtil.executeUpdate( );
88 daoUtil.free( );
89 }
90
91
92
93
94 @Override
95 public void mergeConfiguration( Notification notification, Plugin plugin )
96 {
97 if ( notification != null )
98 {
99 DAOUtil daoUtil;
100 if ( loadByIdUnit( notification.getIdUnit( ), plugin ) != null )
101 {
102
103 daoUtil = new DAOUtil( SQL_UPDATE_NOTIFICATION, plugin );
104 }
105 else
106 {
107
108 daoUtil = new DAOUtil( SQL_INSERT_NOTIFICATION, plugin );
109 }
110
111 int nIndex = 1;
112 daoUtil.setString( nIndex++, notification.getEmail( ) );
113 daoUtil.setBoolean( nIndex++, notification.getHasNotif( ) );
114 daoUtil.setBoolean( nIndex++, notification.getUseEmail( ) );
115 daoUtil.setBoolean( nIndex++, notification.getUseList( ) );
116 daoUtil.setInt( nIndex++, notification.getIdUnit( ) );
117
118 daoUtil.executeUpdate( );
119 daoUtil.free( );
120 }
121 }
122
123 }