ContactIndicator.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2021 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.indicator;
 
import java.util.List;
import java.util.stream.Collectors;
import java.util.stream.Stream;
import org.amic.util.date.CheckDate;
import org.turro.annotation.ElephantIndicator;
import org.turro.contacts.Contact;
import org.turro.contacts.ContactType;
import org.turro.contacts.db.ContactsPU;
import org.turro.contacts.relation.FuzzyRelationTypes;
import org.turro.elephant.db.WhereClause;
import org.turro.entities.Entities;
import org.turro.entities.IElephantEntity;
import org.turro.jpa.Dao;
import org.turro.log.LogCount;
import org.turro.log.Logs;
import org.turro.matching.GenericMatching;
import org.turro.matching.IMatching;
import org.turro.math.Zero;
import org.turro.ranking.GenericRanking;
import org.turro.ranking.IRanking;
import org.turro.sql.SqlClause;
import org.turro.zipcode.ZipCodeAPI;
 
@ElephantIndicator
public class ContactIndicator extends AbstractIndicator {
 
  public ContactIndicator() {
    root = "contact";
  }
 
  @Override
  protected void initVariables() {
    addVariable("available", true, VariableType.RANKING_VARIABLE);
    addVariable("profile", VariableType.RANKING_VARIABLE);
    addVariable("distance", VariableType.MATCHING_VARIABLE, true);
  }
 
  @Override
  protected void initExternalVariables() {
    addExternalVariable("dossier", "participation");
    addExternalVariable("dossier", "categoryParticipation");
    addExternalVariable("dossier", "issueResponsible");
    addExternalVariable("dossier", "issueReporter");
    addExternalVariable("dossier", "issueQA");
    addExternalVariable("dossier", "issueAssistant");
    addExternalVariable("student", "challenges");
    addExternalVariable("student", "responses");
    addExternalVariable("student", "responsesLike");
    addExternalVariable("forum", "topics");
    addExternalVariable("forum", "posts");
    addExternalVariable("commons", "following");
    addExternalVariable("commons", "followed");
    addExternalVariable("commons", "seen");
    addExternalVariable("commons", "like");
  }
 
  @Override
  public void generateSiblings() {
    List<LogCount> genact = Logs.getGeneratorActivityCount(new CheckDate().addYears(-2).getDate());
    SqlClause.update("Contact").set("inactive", true)
            .dao(getDao()).execute();
    try(Stream<Contact> stream = createDao().stream(Contact.class, "select c from Contact c")) {
      stream.forEach(contact -> {
        if(genact.contains(new LogCount("/contact/" + contact.getId(), 0))) {
          SqlClause.update("Contact").set("inactive", false)
                  .where().equal("id", contact.getId())
                  .dao(getDao()).execute();
        }
      });
    }
    try(Stream<Contact> stream = SqlClause.select("distinct c").from("Contact c")
            .where().in("c.type", List.copyOf(ContactType.juridicals()))
            .and().exists(SqlClause.select("r").from("BusinessRelation r")
                    .where("r.business.id = c.id")
                    .and().equal("r.contact.inactive", false))            
            .dao(createDao()).stream(Contact.class)) {
      stream.forEach(contact -> {
        SqlClause.update("Contact").set("inactive", false)
                .where().equal("id", contact.getId())
                .dao(getDao()).execute();
      });
    }
  }
 
  @Override
  protected Dao createDao() {
    return new ContactsPU();
  }
 
  @Override
  public double getValue(IndicatorVariable variable, Object entity) {
    if((entity instanceof Contact) && itsMine(variable)) {
      Contact contact = (Contact) entity;
      switch(variable.getName()) {
        case "profile":
          return contact.getProfile().getCompletion().getPercent();
      }
    }
    return 0.0;
  }
 
  @Override
  public double getValue(IndicatorVariable variable, Object entity, String relatedPath) {
    if((entity instanceof Contact) && itsMine(variable)) {
      Contact contact = (Contact) entity;
      IElephantEntity related = Entities.getController(relatedPath);
      if("contact".equals(related.getRoot())) {
        switch(variable.getName()) {
          case "distance":
            if(contact.hasLocation()) {
              Contact crelated = (Contact) related.getEntity();
              if(crelated.hasLocation()) {
                return ZipCodeAPI.distanceOrZero(contact.getLatitude(), crelated.getLatitude(), 
                                contact.getLongitude(), crelated.getLongitude());
              }
            }
        }
      }
    }
    return 0.0;
  }
 
  @Override
  protected void processRankingVariable(Dao dao, IPreprocessor preprocessor, IndicatorVariable variable, String entityRoot) {
    WhereClause wc = null;
    if("contact".equals(entityRoot)) {
      switch(variable.getName()) {
        case "available":
          wc = PreprocessClause.load("JobBoard")
                  .addCondition("and available = TRUE")
                  .setRankingRoot(entityRoot)
                  .setRankingField("concat('/contact/',contact.id)")
                  .setVariable(variable)
                  .setAggregate("count(id)")
                  .getClause();
          break;
      }
    }
    if(wc != null) {
      try(Stream<GenericRanking> stream = dao.stream(GenericRanking.class, wc, 1000)) {
        stream.forEach(r -> {
          preprocessor.poolInstance(r.copyTo((IRanking) preprocessor.createInstance()));
        });
        preprocessor.finishPreprocessor();
      }
    }
  }
 
  @Override
  protected void processMatchingVariable(Dao dao, IPreprocessor preprocessor, IndicatorVariable variable, String entityRoot, String relatedRoot) {
    WhereClause wc = null;
    if("contact".equals(entityRoot)) {
      if("contact".equals(relatedRoot)) {
        switch(variable.getName()) {
        }
      }
    }
    if(wc != null) {
      try(Stream<GenericMatching> stream = dao.stream(GenericMatching.class, wc, 1000)) {
        stream.forEach(r -> {
          preprocessor.poolInstance(r.copyTo((IMatching) preprocessor.createInstance()));
        });
        preprocessor.finishPreprocessor();
      }
    }
  }
 
  @Override
  protected void postprocessRankingVariable(Dao dao, IPreprocessor preprocessor, IndicatorVariable variable, String entityRoot) {
    if("contact".equals(entityRoot)) {
      try(Stream<Contact> stream = getJuridicals()) {
        stream.forEach(juridical -> {
          List<String> springPaths = getSpringPaths(juridical);
          if(!springPaths.isEmpty()) {
            WhereClause wc = PostprocessClause.load(preprocessor.tableName())
                    .setEntityPath(ContactsPU.getObjectPath(juridical))
                    .setSpringPaths(springPaths)
                    .getRankingClause();
            if(wc != null) {
              try(Stream<GenericRanking> istream = dao.stream(GenericRanking.class, wc, 1000)) {
                istream.forEach(r -> {
                  if(r != null && !Zero.near(r.getRanking(), 2)) {
                    preprocessor.poolInstance(r.copyTo((IRanking) preprocessor.createInstance()));
                  } 
                });
              }
            }
          }
        });
        preprocessor.finishPreprocessor();
      }
    }
  }
 
  private Stream<Contact> getJuridicals() {
    WhereClause wc = new WhereClause();
    wc.addClause("select contact from Contact contact");
    FuzzyRelationTypes.isJuridical(wc, "where", "contact");
    return createDao().stream(Contact.class, wc, 1000);  
  }
 
  private List<String> getSpringPaths(Contact contact) {
    return contact.getWorkers().stream().map(c -> "/contact/" + c.getId()).collect(Collectors.toList());
  }
 
}