ContactWarnings.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2020 Lluis Turró Cutiller <http://www.turro.org/>
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */
 
package org.turro.warnings;
 
import java.util.ArrayList;
import java.util.Collections;
import java.util.List;
import org.turro.action.Contacts;
import org.turro.mail.MailValidator;
import org.turro.annotation.ElephantWarning;
import org.turro.contacts.BusinessRelation;
import org.turro.contacts.Connector;
import org.turro.contacts.Contact;
import org.turro.contacts.db.ContactsPU;
import org.turro.elephant.context.Application;
import org.turro.elephant.db.WhereClause;
import org.turro.i18n.I_;
import org.turro.jpa.Dao;
 
@ElephantWarning
public class ContactWarnings implements IElephantWarning {
 
  @Override
  public String getHeader() {
    return I_.get("Contacts");
  }
 
  @Override
  public List<IWarning> getWarnings() {
    if(Application.getApplication().isInRole("contact:all")) {
      return createModel();
    }
    return Collections.EMPTY_LIST;
  }
 
  private List<IWarning> createModel() {
    List<IWarning> warnings = new ArrayList<>();
    Dao dao = new ContactsPU();
    checkMultipleEmails(dao, warnings);
    checkDuplicates(dao, warnings);
    checkInvalidEmails(dao, warnings);
    checkUnresolvedRelations(dao, warnings);
    //checkStudents(dao, warnings);
    return warnings;
  }
 
  private void checkMultipleEmails(Dao dao, List<IWarning> warnings) {
    WhereClause wc = new WhereClause();
    wc.addClause("select c.contact, count(c) from Connector c");
    wc.addClause("where c.description = 'Email'");
    wc.addClause("group by c.contact");
    wc.addClause("having count(c) > 1");
    for(Object[] v : (List<Object[]>) dao.getResultList(wc)) {
      Warning warning = new Warning();
      warning.setEntity(v[0]);
      warning.addMessage(I_.format("To many Email: %d", v[1]));
      warnings.add(warning);
    }
  }
 
  private void checkDuplicates(Dao dao, List<IWarning> warnings) {
    WhereClause wc = new WhereClause();
    wc.addClause("select c.contact, c2.contact");
    wc.addClause("from Connector c join Connector c2");
    wc.addClause("on c2.description = c.description");
    wc.addClause("and c2.value = c.value");
    wc.addClause("where c.description = 'Email'");
    wc.addClause("and c.value <> 'nomail'");
    wc.addClause("and c.id <> c2.id");
    for(Object[] v : (List<Object[]>) dao.getResultList(wc)) {
      Warning warning = new Warning();
      warning.setEntity(v[0]);
      warning.addMessage(I_.format("%s has the same email", ((Contact) v[1]).getName()));
      warnings.add(warning);
    }
  }
 
  private void checkInvalidEmails(Dao dao, List<IWarning> warnings) {
    WhereClause wc = new WhereClause();
    wc.addClause("select c from Connector c");
    wc.addClause("where c.description = 'Email'");
    wc.addClause("and c.value <> 'nomail'");
    wc.addClause("and (c.value <> trim(c.value)");
    wc.addClause("or c.value not like '%@%.%')");
    for(Connector connector : dao.getResultList(Connector.class, wc)) {
      if(!MailValidator.single().silently(connector.getValue())) {
        Warning warning = new Warning();
        warning.setEntity(connector.getContact());
        warning.addMessage(I_.format("%s is not a valid email address", connector.getValue()));
        warnings.add(warning);
      }
    }
  }
 
  private void checkUnresolvedRelations(Dao dao, List<IWarning> warnings) {
    WhereClause wc = new WhereClause();
    wc.addClause("select r from BusinessRelation r");
    wc.addClause("where r.validated = FALSE");
    for(BusinessRelation relation : dao.getResultList(BusinessRelation.class, wc)) {
      Warning warning = new Warning();
      warning.setEntity(relation.getContact());
      warning.addMessage(I_.get("Pending"));
      warnings.add(warning);
    }
  }
 
  private void checkStudents(Dao dao, List<IWarning> warnings) {
    Contacts.getStudents().forEach(student -> {
      if(student.isStudent() && student.isWorker()) {
        Warning warning = new Warning();
        warning.setEntity(student.getContact());
        warning.addMessage(I_.get("Student while professional"));
        warnings.add(warning);
      }
    });
  }
 
}