CrmCustomerSummary.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2012 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.command;
 
import java.util.Collection;
import org.turro.annotation.ElephantPlugin;
import org.turro.crm.db.CrmPU;
import org.turro.crm.entity.VendorProspect;
import org.turro.elephant.context.Application;
import org.turro.elephant.db.WhereClause;
import org.turro.elephant.util.Images;
import org.turro.i18n.I_;
import org.turro.jpa.Dao;
import org.turro.plugin.command.CustomerSummaryPlugin;
import org.turro.zkoss.label.LabelTypes;
import org.turro.zkoss.layout.GroupboxArrow;
import org.zkoss.zul.Hlayout;
import org.zkoss.zul.Image;
import org.zkoss.zul.Include;
 
@ElephantPlugin
public class CrmCustomerSummary extends CustomerSummaryPlugin {
  
  private Collection<VendorProspect> active;
  
  @Override
  protected void executePlugin() {
    Application app = Application.getApplication();
    activeSales();
    if(!active.isEmpty()) {
      GroupboxArrow gba = new GroupboxArrow() {
        @Override
        protected void doFillContent() {
        }
      };
      Hlayout hbox = new Hlayout();
      gba.setCaption(hbox);
      hbox.setSclass("z-valign-middle");
      hbox.setValign("middle");
      hbox.appendChild(new Image(Images.getImage("customer")));
      hbox.appendChild(LabelTypes.getSoftLabel(I_.get("Sale prospects") + ":"));
      hbox.appendChild(LabelTypes.getPreLabel(active.size() + " " + I_.get("Opened")));
      Include report = new Include("/WEB-INF/_zul/crm/customerSummary.zul");
      report.setDynamicProperty("active", active);
      gba.appendChild(report);
      gba.setOpen(false);
      addResult("crm", gba);
    }
  }
  
  private void activeSales() {
    Dao dao = new CrmPU();
    WhereClause wc = new WhereClause();
    wc.addClause("select distinct vendorp from VendorProspect as vendorp");
    wc.addClause("where vendorp.saleProspect.customer.idContact = :contact");
    wc.addClause("and vendorp.saleProspect.closingDate is null");
    wc.addNamedValue("contact", contact.getId());
    active = dao.getResultList(wc);
  } 
  
}