private Collection<GroupData> fetchGroupDataForUser(
final User user, final boolean restrictToSuscribed) {
final String ifConnectedColumns =
"max(ifnull(USER_ID=:userId, false))>0, sum(ifnull(USER_ID=:userId AND LAST_VISIT<PUBLIC_MESSAGES.`DATE`, false))";
final Query query =
entityManager.createNativeQuery(
"select GROUPS.ID, name, count(DISTINCT GROUP_USER.USER_ID), "
+ (user != null ? ifConnectedColumns : " 0,0")
+ " from GROUPS left join GROUP_USER on GROUP_ID=ID "
+ " left join PUBLIC_MESSAGES on PUBLIC_MESSAGES.GROUP_ID=GROUP_USER.GROUP_ID "
+ (restrictToSuscribed ? " where GROUP_USER.USER_ID=:userId" : "")
+ " group by GROUPS.ID order by CREATION_DATE");
if (user != null) query.setParameter("userId", user.getId());
final List<Object[]> list = query.getResultList();
final Collection<GroupData> result = new ArrayList<GroupData>(list.size());
for (final Object[] o : list)
result.add(
new GroupData(
((Number) o[0]).longValue(),
UserStringImpl.valueOf(String.valueOf(o[1])),
((Number) o[2]).longValue(),
((Number) o[3]).intValue() != 0,
((Number) o[4]).intValue()));
return result;
}
@Override
public Collection<? extends GrantedAuthority> getAuthorities() {
Collection<GrantedAuthority> grantedAuthorities = new HashSet<GrantedAuthority>();
for (UserRole role : this.getUserRoles()) {
grantedAuthorities.add(new SimpleGrantedAuthority(role.getRoleName()));
}
return grantedAuthorities;
}
public Subscription(
User subscriber, Frequency frequency, Severity severity, Collection<String> topics) {
this(
subscriber,
frequency,
severity,
topics.stream().map(String::trim).collect(Collectors.joining(",")));
}
@Transient
@JsonIgnore
public Collection<? extends GrantedAuthority> getAuthorities() {
if (authorities.isEmpty()) {
for (Role role : roles) {
String[] rights = role.getRights().split(";");
for (String right : rights) {
if (NullEmptyChecker.isNotNullOrEmpty(right)) {
authorities.add(new SimpleGrantedAuthority("ROLE_" + right));
}
}
}
}
return authorities;
}
public void testValidValuesInList() throws Exception {
int quantity = getListRowCount();
assertTrue("For this test is needed at least one created delivery", quantity > 0);
Collection values = new ArrayList();
values.add("Lokal");
values.add("Nachional");
values.add("Internachional");
boolean thereIsOne = false;
for (int i = 0; i < quantity; i++) {
String value = getValueInList(i, "distance");
if (Is.emptyString(value)) continue;
if (values.contains(value)) {
thereIsOne = true;
continue;
}
fail("Only the next values are valid: " + values);
}
assertTrue(
"For this test is need at least one delivery with value in 'distance' property",
thereIsOne);
}
@Override
public int hashCode() {
int result = id != null ? id.hashCode() : 0;
result = 31 * result + (ssn != null ? ssn.hashCode() : 0);
result = 31 * result + (firstName != null ? firstName.hashCode() : 0);
result = 31 * result + (lastName != null ? lastName.hashCode() : 0);
result = 31 * result + (frequentFlyerMiles != null ? frequentFlyerMiles.hashCode() : 0);
result = 31 * result + (picture != null ? Arrays.hashCode(picture) : 0);
result = 31 * result + (dateOfBirth != null ? dateOfBirth.hashCode() : 0);
result = 31 * result + age;
result = 31 * result + (lastFlight != null ? lastFlight.hashCode() : 0);
result = 31 * result + (passengerType != null ? passengerType.hashCode() : 0);
result = 31 * result + (preferences != null ? preferences.hashCode() : 0);
result = 31 * result + (cards != null ? cards.hashCode() : 0);
result = 31 * result + (address != null ? address.hashCode() : 0);
result = 31 * result + (tickets != null ? tickets.hashCode() : 0);
return result;
}
public List<AbstractMetadata> getMetadata(
Object object, Object persisted, AbstractAuditing auditing) throws Exception {
List<Method> methodsGet = getMethods(object);
List<AbstractMetadata> metadatas = new ArrayList<AbstractMetadata>();
boolean isDelete =
auditing.getAuditingType() != null
&& auditing.getAuditingType().equals(AuditingType.DELETE);
for (Method method : methodsGet) {
try {
Object fieldValue = method.invoke(object);
Object fieldOld = null;
if (persisted != null) {
fieldOld = method.invoke(persisted);
}
AbstractMetadata metadata = Configuration.getAbstractMetadata();
if (fieldValue != null && fieldValue.getClass().isAnnotationPresent(Embeddable.class)) {
List<AbstractMetadata> embedableMetadata = getMetadata(fieldValue, persisted, auditing);
if (embedableMetadata != null && !embedableMetadata.isEmpty()) {
metadatas.addAll(embedableMetadata);
}
} else {
boolean addMetadata = persisted == null;
if (fieldValue instanceof Collection) { // para as coleções
Collection collectionNew = (Collection<Object>) fieldValue;
Collection collectionOld = (Collection<Object>) fieldOld;
StringBuilder newValue = new StringBuilder();
if (fieldOld == null) {
for (Object item : collectionNew) {
newValue.append(item.toString()).append("; ");
}
addMetadata = true;
} else {
StringBuilder oldValue = new StringBuilder();
if ((!(collectionNew instanceof PersistentBag)
&& !(collectionNew instanceof PersistentCollection))
|| isDelete == true) {
if ((collectionNew == null && collectionOld != null)
|| (collectionNew != null && collectionOld == null)
|| (collectionNew.size() != collectionOld.size())) {
addMetadata = true;
} else {
for (Object current : collectionNew) {
if (collectionOld != null && !collectionOld.contains(current)) {
for (Object currentOld : collectionOld) {
if (!currentOld.equals(current)) {
addMetadata = true;
break;
}
}
}
}
}
for (Object old : collectionOld) {
oldValue.append(old).append("; ");
}
for (Object item : collectionNew) {
newValue.append(item.toString()).append("; ");
}
metadata.setOldValue(oldValue.toString());
}
}
metadata.setNewValue(newValue.toString());
} else if (isEntity(method.getReturnType())) {
Object newId = getId(fieldValue);
// a proxy doesnt has value changed
if (!(fieldValue instanceof HibernateProxy) || isDelete == true) {
/** One to One cascade ALL */
if (isOneToOneCascadeAll(method)) {
List<AbstractMetadata> embedableMetadata = null;
// add metadata for oneToOne cascade all based on new object
if (persisted == null) {
embedableMetadata = getMetadata(fieldValue, null, auditing);
} else {
embedableMetadata = getMetadata(fieldValue, getPersisted(fieldValue), auditing);
}
if (embedableMetadata != null && !embedableMetadata.isEmpty()) {
metadatas.addAll(embedableMetadata);
}
}
Object oldId = null;
if (fieldOld instanceof HibernateProxy) {
oldId = ((HibernateProxy) fieldOld).getHibernateLazyInitializer().getIdentifier();
} else {
oldId = getId(fieldOld);
}
metadata.setOldIdentifier(oldId == null ? null : Long.valueOf(oldId.toString()));
metadata.setOldValue(fieldOld == null ? "" : fieldOld.toString());
if ((oldId == null && newId != null)
|| (oldId != null && newId == null)
|| (oldId != null && !oldId.equals(newId))) {
addMetadata = true;
}
metadata.setEntity(method.getDeclaringClass().getName());
metadata.setNewIdentifier(newId == null ? null : Long.valueOf(newId.toString()));
metadata.setNewValue(fieldValue == null ? "" : fieldValue.toString());
}
} else {
if (fieldOld != null) {
metadata.setOldValue(getToString(fieldOld));
}
if (fieldValue != null) {
metadata.setNewValue(getToString(fieldValue));
}
// verify empty String
if (fieldValue instanceof String) {
if ((fieldOld == null && fieldValue != null && !fieldValue.toString().isEmpty())
|| (fieldOld != null && !fieldOld.toString().isEmpty() && fieldValue == null)
|| (fieldOld != null && !fieldOld.equals(fieldValue))) {
addMetadata = true;
}
} else {
if ((fieldOld == null && fieldValue != null)
|| (fieldOld != null && fieldValue == null)
|| (fieldOld != null && !fieldOld.equals(fieldValue))) {
addMetadata = true;
}
}
}
metadata.setField(getMethodName(method));
metadata.setAuditing(auditing);
if (addMetadata) {
metadatas.add(metadata);
}
}
} catch (Throwable t) {
logger.log(Level.SEVERE, t.getMessage(), t);
}
}
return metadatas;
}
public void addTopics(Collection<String> topicCollection) {
addTopics(topicCollection.stream().map(String::trim).collect(Collectors.joining(",")));
}
public void addAssigmentTask(TaskAssigment taskAssigment) {
assignTasks.add(taskAssigment);
}
