ErpCustomerSummary.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.erp.command;
 
import java.util.Collection;
import org.turro.annotation.ElephantPlugin;
import org.turro.collections.ItemOf;
import org.turro.collections.SetOf;
import org.turro.plugin.command.CustomerSummaryPlugin;
import org.turro.elephant.context.Application;
import org.turro.elephant.db.SQLHelper;
import org.turro.elephant.db.WhereClause;
import org.turro.elephant.util.Images;
import org.turro.erp.db.ErpPU;
import org.turro.erp.entity.WorkOrder;
import org.turro.financials.contract.logic.ContractWrapper;
import org.turro.financials.entity.Contract;
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 ErpCustomerSummary extends CustomerSummaryPlugin {
  
  private Collection<WorkOrder> active;
  
  @Override
  protected void executePlugin() {
    Application app = Application.getApplication();
    activeWorkOrders();
    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("workorder")));
      hbox.appendChild(LabelTypes.getSoftLabel(Application.getString("lWorkOrders") + ":"));
      hbox.appendChild(LabelTypes.getPreLabel(active.size() + ""));
      Include report = new Include("/WEB-INF/_zul/erp/sales/customerSummary.zul");
      report.setDynamicProperty("active", active);
      gba.appendChild(report);
      gba.setOpen(false);
      addResult("erp", gba);
    }
  }
  
  private void activeWorkOrders() {
    Collection<Contract> contracts = ContractWrapper.getContracts(contact);
    String inCtc = SQLHelper.convertToIn(new SetOf<Contract, Long>(contracts, new ItemOf<Contract, Long>() {
      @Override
      public Long getFrom(Contract e) {
        return e.getId();
      }
    }));
    WhereClause wc = new WhereClause();
    wc.addClause("select distinct workord from WorkOrder as workord");
    wc.addClause("where workord.contractId in (" + inCtc + ")");
    active = new ErpPU().getResultList(wc);
  } 
  
}