2 * Copyright (C) 2016 Roland Haeder
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.
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.
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/>.
17 package org.mxchange.jusercore.model.user;
19 import java.util.Calendar;
20 import java.util.Locale;
21 import java.util.Objects;
22 import javax.persistence.Basic;
23 import javax.persistence.CascadeType;
24 import javax.persistence.Column;
25 import javax.persistence.Entity;
26 import javax.persistence.EnumType;
27 import javax.persistence.Enumerated;
28 import javax.persistence.GeneratedValue;
29 import javax.persistence.GenerationType;
30 import javax.persistence.Id;
31 import javax.persistence.JoinColumn;
32 import javax.persistence.Lob;
33 import javax.persistence.NamedQueries;
34 import javax.persistence.NamedQuery;
35 import javax.persistence.OneToOne;
36 import javax.persistence.Table;
37 import javax.persistence.Temporal;
38 import javax.persistence.TemporalType;
39 import javax.persistence.Transient;
40 import org.mxchange.jcontacts.contact.Contact;
41 import org.mxchange.jcontacts.contact.UserContact;
42 import org.mxchange.jusercore.model.user.profilemodes.ProfileMode;
43 import org.mxchange.jusercore.model.user.status.UserAccountStatus;
46 * A generic user entity class
48 * @author Roland Haeder<roland@mxchange.org>
50 @Entity (name = "users")
56 @NamedQuery (name = "AllUserNames", query = "SELECT DISTINCT u.userName FROM users AS u ORDER BY u.userId ASC"),
57 @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"),
58 @NamedQuery (name = "SearchUserByName", query = "SELECT u FROM users AS u WHERE LOWER(u.userName) LIKE LOWER(:userName)"),
59 @NamedQuery (name = "SearchUserById", query = "SELECT u FROM users AS u WHERE u.userId = :id"),
60 @NamedQuery (name = "SearchUserByEmailAddress", query = "SELECT u FROM users AS u INNER JOIN contacts AS c ON u.userContact = c WHERE LOWER(c.contactEmailAddress) LIKE LOWER(:emailAddress)"),
61 @NamedQuery (name = "SearchUserByConfirmKey", query = "SELECT u FROM users AS u WHERE u.userConfirmKey = :confirmKey"),
62 @NamedQuery (name = "SearchAllUsersExcept", query = "SELECT u FROM users AS u WHERE u != :user ORDER BY u.userId ASC"),
63 @NamedQuery (name = "AllUsers", query = "SELECT u FROM users AS u ORDER BY u.userId ASC"),
64 @NamedQuery (name = "AllPublicUsers", query = "SELECT u FROM users AS u WHERE u.userAccountStatus = :status AND u.userProfileMode = :mode ORDER BY u.userId ASC"),
65 @NamedQuery (name = "AllMemberPublicUsers", query = "SELECT u FROM users AS u WHERE u.userAccountStatus = :status AND u.userProfileMode IN (:public, :members) ORDER BY u.userId ASC")
68 @SuppressWarnings ("PersistenceUnitPresent")
69 public class LoginUser implements User {
75 private static final long serialVersionUID = 4_328_454_581_751L;
80 @Basic (optional = false)
81 @Column (name = "user_account_status", nullable = false)
82 @Enumerated (value = EnumType.STRING)
83 private UserAccountStatus userAccountStatus;
88 @Column (name = "user_confirm_key", unique = true)
89 private String userConfirmKey;
92 * Id number from "contacts" table
94 @JoinColumn (name = "user_contact_id", referencedColumnName = "contact_id", nullable = false, updatable = false, unique = true)
95 @OneToOne (targetEntity = UserContact.class, cascade = CascadeType.ALL, optional = false)
96 private Contact userContact;
101 @Basic (optional = false)
102 @Temporal (TemporalType.TIMESTAMP)
103 @Column (name = "user_created", nullable = false)
104 private Calendar userCreated;
109 @Basic (optional = false)
110 @Column (name = "user_encrypted_password", nullable = false)
111 private String userEncryptedPassword;
117 @Column (name = "user_id", nullable = false, length = 20, updatable = false)
118 @GeneratedValue (strategy = GenerationType.IDENTITY)
122 * Last "locked" timestamp
124 @Temporal (TemporalType.TIMESTAMP)
125 @Column (name = "user_last_locked_timestamp")
126 private Calendar userLastLocked;
132 @Column (name = "user_last_locked_reason")
133 private String userLastLockedReason;
138 @Column (name = "user_locale")
139 private Locale userLocale;
142 * Whether the user must change password after login
144 @Column (name = "user_must_change_password")
145 private Boolean userMustChangePassword;
150 @Basic (optional = false)
151 @Column (name = "user_name", nullable = false, length = 30, unique = true)
152 private String userName;
155 * Profile mode of this user
157 @Basic (optional = false)
158 @Enumerated (EnumType.STRING)
159 @Column (name = "user_profile_mode", nullable = false)
160 private ProfileMode userProfileMode;
163 * When this user has been updated
165 @Temporal (TemporalType.TIMESTAMP)
166 @Column (name = "user_updated")
167 private Calendar userUpdated;
170 * Default constructor
172 public LoginUser () {
173 // Default is invisible
174 this.userProfileMode = ProfileMode.INVISIBLE;
178 public void copyAll (final User user) {
180 if (user.getUserContact() instanceof Contact) {
181 // Copy also contact data
182 this.getUserContact().copyAll(user.getUserContact());
186 this.setUserConfirmKey(user.getUserConfirmKey());
187 this.setUserName(user.getUserName());
188 this.setUserEncryptedPassword(user.getUserEncryptedPassword());
189 this.setUserAccountStatus(user.getUserAccountStatus());
190 this.setUserCreated(user.getUserCreated());
191 this.setUserLastLocked(user.getUserLastLocked());
192 this.setUserLastLockedReason(user.getUserLastLockedReason());
193 this.setUserUpdated(user.getUserUpdated());
194 this.setUserProfileMode(user.getUserProfileMode());
195 this.setUserLocale(user.getUserLocale());
196 this.setUserMustChangePassword(user.getUserMustChangePassword());
200 public boolean equals (final Object object) {
201 if (null == object) {
203 } else if (this.getClass() != object.getClass()) {
207 final User other = (User) object;
209 return ((Objects.equals(this.getUserName(), other.getUserName())) &&
210 (Objects.equals(this.getUserId(), other.getUserId())));
214 public UserAccountStatus getUserAccountStatus () {
215 return this.userAccountStatus;
219 public void setUserAccountStatus (final UserAccountStatus userAccountStatus) {
220 this.userAccountStatus = userAccountStatus;
224 public String getUserConfirmKey () {
225 return this.userConfirmKey;
229 public void setUserConfirmKey (final String userConfirmKey) {
230 this.userConfirmKey = userConfirmKey;
234 public Contact getUserContact () {
235 return this.userContact;
239 public void setUserContact (final Contact userContact) {
240 this.userContact = userContact;
244 @SuppressWarnings ("ReturnOfDateField")
245 public Calendar getUserCreated () {
246 return this.userCreated;
250 @SuppressWarnings ("AssignmentToDateFieldFromParameter")
251 public void setUserCreated (final Calendar userCreated) {
252 this.userCreated = userCreated;
256 public String getUserEncryptedPassword () {
257 return this.userEncryptedPassword;
261 public void setUserEncryptedPassword (final String userEncryptedPassword) {
262 this.userEncryptedPassword = userEncryptedPassword;
266 public Long getUserId () {
271 public void setUserId (final Long userId) {
272 this.userId = userId;
276 @SuppressWarnings ("ReturnOfDateField")
277 public Calendar getUserLastLocked () {
278 return this.userLastLocked;
282 @SuppressWarnings ("AssignmentToDateFieldFromParameter")
283 public void setUserLastLocked (final Calendar userLastLocked) {
284 this.userLastLocked = userLastLocked;
288 public String getUserLastLockedReason () {
289 return this.userLastLockedReason;
293 public void setUserLastLockedReason (final String userLastLockedReason) {
294 this.userLastLockedReason = userLastLockedReason;
298 public Locale getUserLocale () {
299 return this.userLocale;
303 public void setUserLocale (final Locale userLocale) {
304 this.userLocale = userLocale;
308 public Boolean getUserMustChangePassword () {
309 return this.userMustChangePassword;
313 public void setUserMustChangePassword (final Boolean userMustChangePassword) {
314 this.userMustChangePassword = userMustChangePassword;
318 public String getUserName () {
319 return this.userName;
323 public void setUserName (final String userName) {
324 this.userName = userName;
328 public ProfileMode getUserProfileMode () {
329 return this.userProfileMode;
333 public void setUserProfileMode (final ProfileMode userProfileMode) {
334 this.userProfileMode = userProfileMode;
338 @SuppressWarnings ("ReturnOfDateField")
339 public Calendar getUserUpdated () {
340 return this.userUpdated;
344 @SuppressWarnings ("AssignmentToDateFieldFromParameter")
345 public void setUserUpdated (final Calendar userUpdated) {
346 this.userUpdated = userUpdated;
350 public int hashCode () {
352 hash = 83 * hash + Objects.hashCode(this.getUserName());
353 hash = 83 * hash + Objects.hashCode(this.getUserId());