@NamedQuery (name = "AllUserNames", query = "SELECT DISTINCT u.userName FROM users AS u ORDER BY u.userId ASC"),
@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"),
- @NamedQuery (name = "SearchUser", query = "SELECT u FROM users AS u WHERE u = :param"),
@NamedQuery (name = "SearchUserName", query = "SELECT u FROM users AS u WHERE LOWER(u.userName) LIKE LOWER(:param)"),
@NamedQuery (name = "SearchUserId", query = "SELECT u FROM users AS u WHERE u.userId = :id"),
@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)"),
@NamedQuery (name = "SearchAllUsersExcept", query = "SELECT u FROM users AS u WHERE u != :user ORDER BY u.userId ASC"),
+ @NamedQuery (name = "AllUsers", query = "SELECT u FROM users AS u ORDER BY u.userId ASC"),
@NamedQuery (name = "AllPublicUsers", query = "SELECT u FROM users AS u WHERE u.userAccountStatus = :status AND u.userProfileMode = :mode ORDER BY u.userId ASC"),
@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")
}
)
+@SuppressWarnings ("PersistenceUnitPresent")
public class LoginUser implements User {
/**
@@ -82,13+83,6 @@ public class LoginUser implements User {
*/
private static final long serialVersionUID = 4_328_454_581_751L;
- /**
- * Last locked reason
- */
- @Lob
- @Column (name = "user_last_locked_reason")
- private String lastLockedReason;
-
/**
* Account status
*/
@@ -140,6+134,13 @@ public class LoginUser implements User {
@Column (name = "user_last_locked_timestamp")
private Calendar userLastLocked;
+ /**
+ * Last locked reason
+ */
+ @Lob
+ @Column (name = "user_last_locked_reason")
+ private String userLastLockedReason;
+
/**
* User name
*/
@@ -172,8+173,11 @@ public class LoginUser implements User {