SocialGroupVM.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.contacts.social;
 
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Set;
import java.util.TreeSet;
import org.turro.contacts.BusinessRelation;
import org.turro.contacts.db.ContactsPU;
import org.turro.elephant.db.WhereClause;
import org.turro.plugin.contacts.IContact;
import org.turro.security.SocialGroups;
import org.zkoss.bind.annotation.BindingParam;
import org.zkoss.bind.annotation.Command;
import org.zkoss.bind.annotation.NotifyChange;
 
public class SocialGroupVM {
  
  private SocialGroupValue socialGroup;
  private boolean active = true, students = false;
 
  public SocialGroupVM() {
  }
  
  @NotifyChange("model")
  @Command
  public void checkBusiness(@BindingParam("relation") SocialRelation relation) {
    IContact contact = relation.getBusiness().getIContact();
    contact.syndicate(socialGroup.getKey(), !contact.getSyndications().contains(socialGroup.getKey()));
  }
 
  @NotifyChange("model")
  @Command
  public void checkContact(@BindingParam("relation") SocialRelation relation) {
    IContact contact = relation.getContact().getIContact();
    contact.syndicate(socialGroup.getKey(), !contact.getSyndications().contains(socialGroup.getKey()));
  }
 
  public SocialGroupValue getSocialGroup() {
    return socialGroup;
  }
 
  public void setSocialGroup(SocialGroupValue socialGroup) {
    this.socialGroup = socialGroup;
  }
 
  public boolean isActive() {
    return active;
  }
 
  public void setActive(boolean active) {
    this.active = active;
  }
 
  public boolean isStudents() {
    return students;
  }
 
  public void setStudents(boolean students) {
    this.students = students;
  }
 
  public Set<SocialGroupValue> getSocialGroupModel() {
    TreeSet<SocialGroupValue> set = new TreeSet<>();
    SocialGroups.allowedSocialGroups().forEach(social -> {
      set.add(new SocialGroupValue(social.getName(), social.getId(), social.getType()));
    });
    return set;
  }
 
  @NotifyChange("model")
  @Command("update")
  public void update() {}
 
  public List<SocialRelation> getModel() {
    ArrayList<SocialRelation> list = new ArrayList<>();
    if(socialGroup != null) {
      WhereClause wc = new WhereClause();
      wc.addClause("select br from BusinessRelation br");
      wc.addClause("where br.validated = TRUE");
      if(active) {
        wc.addInRange("and", "br.startDate", "br.endDate", "date", new Date());
      }
 
      wc.addClause("and ( exists (");
      wc.addClause("select s from Syndication s");
      wc.addClause("where s.name = :name");
      wc.addClause("and s.contact = br.business");
      wc.addClause(") and not exists (");
      wc.addClause("select s from Syndication s");
      wc.addClause("where s.name = :name");
      wc.addClause("and s.contact = br.contact");
      wc.addClause(")) or ( not exists (");
      wc.addClause("select s from Syndication s");
      wc.addClause("where s.name = :name");
      wc.addClause("and s.contact = br.business");
      wc.addClause(") and exists (");
      wc.addClause("select s from Syndication s");
      wc.addClause("where s.name = :name");
      wc.addClause("and s.contact = br.contact");
      wc.addClause("))");
 
      wc.addClause("and not exists (");
      wc.addClause("select b2 from BusinessRelation b2");
      wc.addClause("where b2.validated = TRUE");
      wc.addInRange("and", "b2.startDate", "b2.endDate", "date", new Date());
      wc.addClause("and b2.contact = br.contact");
      wc.addClause("and b2.business <> br.business");
      wc.addClause("and exists (");
      wc.addClause("select s from Syndication s");
      wc.addClause("where s.name = :name");
      wc.addClause("and s.contact = b2.business");
      wc.addClause("))");
            
      wc.addNamedValue("name", socialGroup.getKey());
      
      wc.addClause("order by br.business.name, br.contact.name");
      
      for(BusinessRelation br : new ContactsPU().getResultList(BusinessRelation.class, wc)) {
        list.add(new SocialRelation(br.getBusiness(), br.getContact(), socialGroup.getKey()));
      }
    }
    return list;
  }
 
}