ActivityGrid.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2013 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.crm.zul.activity;
 
import java.text.DateFormat;
import java.util.Collection;
import java.util.Date;
import org.amic.util.date.DateFormats;
import org.turro.contacts.zul.label.ContactInfo;
import org.turro.crm.db.CrmPU;
import org.turro.crm.entity.Customer;
import org.turro.crm.entity.SaleAction;
import org.turro.crm.entity.SaleProspect;
import org.turro.crm.entity.TouchPoint;
import org.turro.crm.entity.Vendor;
import org.turro.crm.zul.sale.ActionStatus;
import org.turro.elephant.context.Application;
import org.turro.elephant.db.SQLHelper;
import org.turro.elephant.db.WhereClause;
import org.turro.elephant.util.DurationFormats;
import org.turro.i18n.I_;
import org.turro.jpa.Dao;
import org.turro.zkoss.grid.GroupExtended;
import org.turro.zkoss.grid.PagingGrid;
import org.turro.zkoss.label.LabelTypes;
import org.turro.zkoss.label.PreLabel;
import org.zkoss.zk.ui.ext.AfterCompose;
import org.zkoss.zul.Column;
import org.zkoss.zul.Columns;
import org.zkoss.zul.Group;
import org.zkoss.zul.Hlayout;
import org.zkoss.zul.Label;
import org.zkoss.zul.Row;
import org.zkoss.zul.Rows;
import org.zkoss.zul.Space;
import org.zkoss.zul.Vlayout;
 
public class ActivityGrid extends PagingGrid implements AfterCompose {
  
  private Customer customer;
  private SaleProspect saleProspect;
  private Vendor vendor;
  private Collection<String> types, attendees;
  private Date begin, end;
  private Collection<SaleAction> saleActions;
 
  public Customer getCustomer() {
    return customer;
  }
 
  public void setCustomer(Customer customer) {
    this.customer = customer;
  }
 
  public SaleProspect getSaleProspect() {
    return saleProspect;
  }
 
  public void setSaleProspect(SaleProspect saleProspect) {
    this.saleProspect = saleProspect;
  }
 
  public Vendor getVendor() {
    return vendor;
  }
 
  public void setVendor(Vendor vendor) {
    this.vendor = vendor;
  }
 
  public Collection<String> getTypes() {
    return types;
  }
 
  public void setTypes(Collection<String> types) {
    this.types = types;
  }
 
  public Collection<String> getAttendees() {
    return attendees;
  }
 
  public void setAttendees(Collection<String> attendees) {
    this.attendees = attendees;
  }
 
  public Date getBegin() {
    return begin;
  }
 
  public void setBegin(Date begin) {
    this.begin = begin;
  }
 
  public Date getEnd() {
    return end;
  }
 
  public void setEnd(Date end) {
    this.end = end;
  }
 
  public Collection<SaleAction> getSaleActions() {
    return saleActions;
  }
 
  public void reload() {
    if(getRows() != null) {
      getRows().detach();
    }
    addRows();
  }
 
  @Override
  public void afterCompose() {
    addColumns();
  }
 
  private void addRows() {
    saleActions = getActivity();
    
    Rows rows = new Rows();
    appendChild(rows);
 
    SaleProspect lastSaleProspect = null;
    
    for(final SaleAction sa : saleActions) {
      if(lastSaleProspect == null || sa.getVendorProspect().getSaleProspect().getId() != lastSaleProspect.getId()) {
        lastSaleProspect = sa.getVendorProspect().getSaleProspect();
        Group group = new GroupExtended("#" + lastSaleProspect.getId() + " " + lastSaleProspect.getFullDescription());
        rows.appendChild(group);
      }
      Row row = new Row();
      row.setValign("top");
      rows.appendChild(row);
      Vlayout vbox = new Vlayout();
      Hlayout hbox = new Hlayout();
      hbox.setSpacing("10px");
      hbox.appendChild(new Label(DateFormats.format(sa.getActionDate(), 
              DateFormat.SHORT, DateFormat.SHORT, Application.getUsedLocale())));
      hbox.appendChild(LabelTypes.getSoftLabel(DurationFormats.format(sa.getActionDate(), sa.getFinalDate())));
      for(String actionType : sa.getActionType()) {
        hbox.appendChild(LabelTypes.getSoftLabel(actionType));
      }
      hbox.appendChild(LabelTypes.getSoftLabel(ActionStatus.getStringStatus(sa)));
      vbox.appendChild(hbox);
      vbox.appendChild(new Space());
      vbox.appendChild(new ContactInfo(sa.getVendorProspect().getVendor().getIdContact()));
      for(String attendee : sa.getAttendees()) {
        vbox.appendChild(new ContactInfo(attendee));
      }
      row.appendChild(vbox);
      vbox = new Vlayout();
      vbox.appendChild(new PreLabel(sa.getComment()));
      vbox.appendChild(new Space());
      for(TouchPoint tp : sa.getTouchPoints()) {
        vbox.appendChild(LabelTypes.getSoftLabel(tp.getName()));
      }
      row.appendChild(vbox);
    }
 
    setRowCount(saleActions.size());
  }
 
  private void addColumns() {
    Columns cols = new Columns();
    appendChild(cols);
 
    Column col = new Column(I_.get("Participants"), null, "40%");
    cols.appendChild(col);
    
    col = new Column(I_.get("Description"), null, "60%");
    cols.appendChild(col);
    
  }
 
  private Collection<SaleAction> getActivity() {
    Dao dao = new CrmPU();
    return dao.getResultList(getCriteria());
  }
  
  private WhereClause getCriteria() {
    WhereClause wc = new WhereClause();
    wc.addClause("select distinct sa from SaleAction sa");
    wc.addClause("left join sa.vendorProspect vp");
    wc.addClause("left join vp.saleProspect sp");
    wc.addClause("left join sa.actionType at");
    wc.addClause("left join sa.attendees pa");
    wc.addClause("where 1=1");
    if(begin != null) {
      wc.addClause("and sa.actionDate >= :begin");
      wc.addNamedValue("begin", begin);
    }
    if(end != null) {
      wc.addClause("and sa.actionDate <= :end");
      wc.addNamedValue("end", end);
    }
    if(customer != null) {
      wc.addClause("and sp.customer = :customer");
      wc.addNamedValue("customer", customer);
    }
    if(vendor != null) {
      wc.addClause("and vp.vendor = :vendor");
      wc.addNamedValue("vendor", vendor);
    }
    if(saleProspect != null) {
      wc.addClause("and sp = :saleProspect");
      wc.addNamedValue("saleProspect", saleProspect);
    }
    if(types != null && !types.isEmpty()) {
      wc.addClause("and at in (" + SQLHelper.convertToIn(types) + ")");
    }
    if(attendees != null && !attendees.isEmpty()) {
      wc.addClause("and pa in (" + SQLHelper.convertToIn(attendees) + ")");
    }
    wc.addClause("order by sa.actionDate");
    return wc;
  }
 
}