]> git.mxchange.org Git - juser-login-core.git/blob - src/org/mxchange/jusercore/model/user/LoginUser.java
Added named query for all users except given one
[juser-login-core.git] / src / org / mxchange / jusercore / model / user / LoginUser.java
1 /*
2  * Copyright (C) 2015 Roland Haeder
3  *
4  * This program is free software: you can redistribute it and/or modify
5  * it under the terms of the GNU General Public License as published by
6  * the Free Software Foundation, either version 3 of the License, or
7  * (at your option) any later version.
8  *
9  * This program is distributed in the hope that it will be useful,
10  * but WITHOUT ANY WARRANTY; without even the implied warranty of
11  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
12  * GNU General Public License for more details.
13  *
14  * You should have received a copy of the GNU General Public License
15  * along with this program.  If not, see <http://www.gnu.org/licenses/>.
16  */
17 package org.mxchange.jusercore.model.user;
18
19 import java.util.Calendar;
20 import java.util.Objects;
21 import javax.persistence.Basic;
22 import javax.persistence.CascadeType;
23 import javax.persistence.Column;
24 import javax.persistence.Entity;
25 import javax.persistence.EnumType;
26 import javax.persistence.Enumerated;
27 import javax.persistence.GeneratedValue;
28 import javax.persistence.GenerationType;
29 import javax.persistence.Id;
30 import javax.persistence.Index;
31 import javax.persistence.JoinColumn;
32 import javax.persistence.NamedQueries;
33 import javax.persistence.NamedQuery;
34 import javax.persistence.OneToOne;
35 import javax.persistence.Table;
36 import javax.persistence.Temporal;
37 import javax.persistence.TemporalType;
38 import org.mxchange.jcontacts.contact.Contact;
39 import org.mxchange.jcontacts.contact.UserContact;
40 import org.mxchange.jusercore.model.user.status.UserAccountStatus;
41
42 /**
43  * A shop customer class.
44  * <p>
45  * @author Roland Haeder<roland@mxchange.org>
46  */
47 @Entity (name = "users")
48 @Table (
49                 name = "users",
50                 indexes = {
51                         @Index (
52                                         name = "confirmation_key",
53                                         unique = true,
54                                         columnList = "user_confirm_key"
55                         ),
56                         @Index (
57                                         name = "user_name",
58                                         unique = true,
59                                         columnList = "user_name"
60                         )
61                 }
62 )
63 @NamedQueries (
64                 {
65                         @NamedQuery (name = "AllUserNames", query = "SELECT DISTINCT u.userName FROM users AS u ORDER BY u.userId ASC"),
66                         @NamedQuery (name = "AllEmailAddresses", query = "SELECT DISTINCT c.contactEmailAddress FROM contacts AS c INNER JOIN users AS u ON u.userContact = c ORDER BY c.contactId ASC"),
67                         @NamedQuery (name = "SearchUserName", query = "SELECT u FROM users AS u WHERE LOWER(u.userName) LIKE LOWER(:param)"),
68                         @NamedQuery (name = "SearchUserId", query = "SELECT u FROM users AS u WHERE u.userId = :id"),
69                         @NamedQuery (name = "SearchEmailAddress", query = "SELECT u FROM users AS u INNER JOIN contacts AS c ON u.userContact = c WHERE LOWER(c.contactEmailAddress) LIKE LOWER(:param)"),
70                         @NamedQuery (name = "SearchAllUsersExcept", query = "SELECT u FROM users AS u WHERE u != :user ORDER BY u.userId ASC"),
71                         @NamedQuery (name = "AllPublicUsers", query = "SELECT u FROM users AS u WHERE u.userAccountStatus = :param AND u.userPublicProfile = TRUE")
72                 }
73 )
74 public class LoginUser implements User {
75
76         /**
77          * Serial number
78          */
79         private static final long serialVersionUID = 4_328_454_581_751L;
80
81         /**
82          * Account status
83          */
84         @Basic (optional = false)
85         @Column (name = "user_account_status", nullable = false)
86         @Enumerated (value = EnumType.STRING)
87         private UserAccountStatus userAccountStatus;
88
89         /**
90          * Confirmation key
91          */
92         @Column (name = "user_confirm_key", length = 50)
93         private String userConfirmKey;
94
95         /**
96          * Id number from "contacts" table
97          */
98         @JoinColumn (name = "user_contact_id", nullable = false, updatable = false)
99         @OneToOne (targetEntity = UserContact.class, optional = false, cascade = CascadeType.ALL)
100         private Contact userContact;
101
102         /**
103          * "created" timestamp
104          */
105         @Basic (optional = false)
106         @Temporal (TemporalType.TIMESTAMP)
107         @Column (name = "user_created", nullable = false)
108         private Calendar userCreated;
109
110         /**
111          * Encrypted password
112          */
113         @Column (name = "user_encrypted_password", nullable = false)
114         private String userEncryptedPassword;
115
116         /**
117          * User id
118          */
119         @Id
120         @Column (name = "user_id", nullable = false, length = 20, updatable = false)
121         @GeneratedValue (strategy = GenerationType.IDENTITY)
122         private Long userId;
123
124         /**
125          * "locked" timestamp
126          */
127         @Temporal (TemporalType.TIMESTAMP)
128         @Column (name = "user_locked")
129         private Calendar userLocked;
130
131         /**
132          * User name
133          */
134         @Column (name = "user_name", nullable = false, length = 20)
135         private String userName;
136
137         /**
138          * Whether the user wants a public profile. This means that it can be viewed
139          * from the Internet by everyone (only profile, no personal data, this needs
140          * explicit agreement) and it can be found for sharing addresses with.
141          */
142         @Basic (optional = false)
143         @Column (name = "user_public_profile_flag", nullable = false)
144         private Boolean userPublicProfile;
145
146         /**
147          * Default constructor
148          */
149         public LoginUser () {
150                 // Default is not public
151                 this.userPublicProfile = Boolean.FALSE;
152         }
153
154         @Override
155         public void copyAll (final User user) {
156                 // Copy also contact data
157                 this.getUserContact().copyAll(user.getUserContact());
158
159                 // Copy other data
160                 this.setUserConfirmKey(user.getUserConfirmKey());
161                 this.setUserName(user.getUserName());
162                 this.setUserEncryptedPassword(user.getUserEncryptedPassword());
163                 this.setUserAccountStatus(user.getUserAccountStatus());
164                 this.setUserCreated(user.getUserCreated());
165                 this.setUserLocked(user.getUserLocked());
166         }
167
168         @Override
169         public boolean equals (final Object object) {
170                 if (object == null) {
171                         return false;
172                 }
173                 if (getClass() != object.getClass()) {
174                         return false;
175                 }
176
177                 final User other = (User) object;
178
179                 return ((Objects.equals(this.getUserName(), other.getUserName()))
180                                 && (Objects.equals(this.getUserId(), other.getUserId())));
181         }
182
183         @Override
184         public UserAccountStatus getUserAccountStatus () {
185                 return this.userAccountStatus;
186         }
187
188         @Override
189         public void setUserAccountStatus (final UserAccountStatus userAccountStatus) {
190                 this.userAccountStatus = userAccountStatus;
191         }
192
193         @Override
194         public String getUserConfirmKey () {
195                 return this.userConfirmKey;
196         }
197
198         @Override
199         public void setUserConfirmKey (final String customerConfirmKey) {
200                 this.userConfirmKey = customerConfirmKey;
201         }
202
203         @Override
204         public Contact getUserContact () {
205                 return this.userContact;
206         }
207
208         @Override
209         public void setUserContact (final Contact userContact) {
210                 this.userContact = userContact;
211         }
212
213         @Override
214         public Calendar getUserCreated () {
215                 return this.userCreated;
216         }
217
218         @Override
219         public void setUserCreated (final Calendar userCreated) {
220                 this.userCreated = userCreated;
221         }
222
223         @Override
224         public String getUserEncryptedPassword () {
225                 return this.userEncryptedPassword;
226         }
227
228         @Override
229         public void setUserEncryptedPassword (final String userEncryptedPassword) {
230                 this.userEncryptedPassword = userEncryptedPassword;
231         }
232
233         @Override
234         public Long getUserId () {
235                 return this.userId;
236         }
237
238         @Override
239         public void setUserId (final Long userId) {
240                 this.userId = userId;
241         }
242
243         @Override
244         public Calendar getUserLocked () {
245                 return this.userLocked;
246         }
247
248         @Override
249         public void setUserLocked (final Calendar userLocked) {
250                 this.userLocked = userLocked;
251         }
252
253         @Override
254         public String getUserName () {
255                 return this.userName;
256         }
257
258         @Override
259         public void setUserName (final String userName) {
260                 this.userName = userName;
261         }
262
263         @Override
264         public Boolean getUserPublicProfile () {
265                 return this.userPublicProfile;
266         }
267
268         @Override
269         public void setUserPublicProfile (final Boolean userPublicProfile) {
270                 this.userPublicProfile = userPublicProfile;
271         }
272
273         @Override
274         public int hashCode () {
275                 int hash = 5;
276                 hash = 83 * hash + Objects.hashCode(this.getUserName());
277                 hash = 83 * hash + Objects.hashCode(this.getUserId());
278                 return hash;
279         }
280 }