DocumentByContractGrid.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2011 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.financials.document.contract;
 
import java.util.Date;
import org.amic.util.date.CheckDate;
import org.turro.elephant.util.DateFormats;
import org.turro.elephant.util.DecimalFormats;
import org.turro.financials.command.DocumentLabel;
import org.turro.financials.entity.Contract;
import org.turro.financials.entity.Document;
import org.turro.financials.entity.DocumentRelation;
import org.turro.financials.entity.RegisterView;
import org.turro.financials.model.document.contract.DocumentByContractList;
import org.turro.i18n.I_;
import org.turro.zkoss.grid.PagingGrid;
import org.turro.zkoss.label.LabelTypes;
import org.turro.zkoss.label.StyledLabel;
import org.turro.zkoss.layout.GridLayout;
import org.zkoss.zk.ui.event.Event;
import org.zkoss.zk.ui.event.EventListener;
import org.zkoss.zk.ui.event.Events;
import org.zkoss.zul.*;
 
public class DocumentByContractGrid extends PagingGrid {
  
  private Contract contract;
  private RegisterView view = null;
  private Date from, to;
 
  public DocumentByContractGrid() {
    from = new CheckDate(-1, 1, 1, 0, 0, 0).getDate();
    to = new Date();
  }
 
  public Date getFrom() {
    return from;
  }
 
  public Date getTo() {
    return to;
  }
 
  public void setView(RegisterView view) {
    this.view = view;
  }
 
  public void setContract(Contract contract) {
    this.contract = contract;
  }
 
  public void setFrom(Date from) {
    this.from = from;
  }
 
  public void setTo(Date to) {
    this.to = to;
  }
    
  public void update() {
    addCols();
    addRows();
  }
 
  private void addCols() {
    Columns cols = getColumns(true);
    cols.getChildren().clear();
    
    addDetailColumn(new Image("/_zul/images/relation.png"));
    
    Column col = new Column(I_.get("Date"));
    col.setWidth("90px");
    cols.appendChild(col);
    
    col = new Column(I_.get("Concept"));
    cols.appendChild(col);
 
    col = new Column(I_.get("Invoice"));
    col.setWidth("120px");
    col.setAlign("right");
    cols.appendChild(col);
 
    col = new Column(I_.get("Portfolio"));
    col.setWidth("120px");
    col.setAlign("right");
    cols.appendChild(col);
        
    col = new Column(I_.get("Balance"));
    col.setWidth("120px");
    col.setAlign("right");
    cols.appendChild(col);
 
    col = new Column(I_.get("Settlement"));
    col.setWidth("120px");
    col.setAlign("right");
    cols.appendChild(col);
    
    col = new Column(I_.get("Balance"));
    col.setWidth("120px");
    col.setAlign("right");
    cols.appendChild(col);
  }
 
  private void addRows() {
    Rows rows = getRows(true);
    rows.getChildren().clear();
    
    DocumentByContractList dbcl = new DocumentByContractList();
    dbcl.fillList(view, contract, from, to);
    
    double portfolio_balance = 0.0, final_balance = dbcl.getInitialBalance(view, contract, from, to);
    int count = 0;
    
    if(final_balance != 0.0) {
      count++;
      
      Row row = new Row();
      rows.appendChild(row);
              
      final Detail d = new Detail();
      row.appendChild(d);
      row.appendChild(new Space());
      row.appendChild(new Label(I_.get("Accumulated")));
      row.appendChild(new Space());
      row.appendChild(new Space());
      row.appendChild(new Space());
      row.appendChild(new Space());
      row.appendChild(new Label(DecimalFormats.format(final_balance,
              DecimalFormats.getStringFormat(2))));
    }
    
    for(final Document doc : dbcl) {
 
      if(doc.getDocumentDefinition().getId() != 1 &&
              doc.getDocumentDefinition().getId() != 67 &&
              doc.getDocumentDefinition().getId() != 2 &&
              doc.getDocumentDefinition().getId() != 43 &&
              doc.getDocumentDefinition().getId() != 44 &&
              doc.getDocumentDefinition().getId() != 6 &&
              doc.getDocumentDefinition().getId() != 7) {
        continue;
      }
      
      count++;
      
      Row row = new Row();
      rows.appendChild(row);
              
      final Detail d = new Detail();
      row.appendChild(d);
      d.addEventListener(Events.ON_OPEN, new EventListener() {
        @Override
        public void onEvent(Event event) throws Exception {
          if(d.getChildren().isEmpty() && !doc.getDescendants().isEmpty()) {
            Vbox vbox = new Vbox();
            vbox.setClass("softLabel");
            vbox.setStyle("margin:3px;margin-left:150px;");
            d.appendChild(vbox);
            GridLayout gl = new GridLayout("min,right-120px");
            vbox.appendChild(gl);
            double total = 0.0;
            for(DocumentRelation dr : doc.getDescendants()) {
              Document dd = dr.getDescendant();
              A b = new DocumentLabel(dd);
              gl.addRow();
              gl.addComponent(b);
              double tdd = dd.getTotalAmount();
              gl.addComponent(new Label(DecimalFormats.format(tdd,
                DecimalFormats.getStringFormat(2))));
              total += tdd;
            }
            gl.addRow();
            gl.addSpace();
            gl.addComponent(new StyledLabel(DecimalFormats.format(total,
              DecimalFormats.getStringFormat(2)), "font-weight:bold"));
          }
        }
      });
 
      row.appendChild(new Label(DateFormats.format(doc.getDocumentDate(), true)));
 
      Vlayout vbox = new Vlayout();
      vbox.setStyle("padding:2px;padding-left:20px");
      row.appendChild(vbox);
      A b = new DocumentLabel(doc);
      vbox.appendChild(b);
      vbox.appendChild(LabelTypes.getSoftLabel(doc.getConcept()));
      vbox.appendChild(LabelTypes.getSoftLabel(doc.getNotes()));
 
      double amount = doc.getTotalAmount();
      
      if(doc.getDocumentDefinition().getId() == 1 ||
              doc.getDocumentDefinition().getId() == 67 ||
              doc.getDocumentDefinition().getId() == 2) {
        row.appendChild(new Label(DecimalFormats.format(amount,
                DecimalFormats.getStringFormat(2))));
        row.appendChild(new Cell());
        portfolio_balance += amount; 
        row.appendChild(new Label(DecimalFormats.format(portfolio_balance,
                DecimalFormats.getStringFormat(2))));
        row.appendChild(new Cell());
        final_balance += amount; 
        row.appendChild(new Label(DecimalFormats.format(final_balance,
                DecimalFormats.getStringFormat(2))));
      } else if(doc.getDocumentDefinition().getId() == 44 ||
              doc.getDocumentDefinition().getId() == 43) {
        row.appendChild(new Cell());
        row.appendChild(new Label(DecimalFormats.format(amount,
                DecimalFormats.getStringFormat(2))));
        portfolio_balance -= amount; 
        row.appendChild(new Label(DecimalFormats.format(portfolio_balance,
                DecimalFormats.getStringFormat(2))));
        row.appendChild(new Cell());
        row.appendChild(new Label(DecimalFormats.format(final_balance,
                DecimalFormats.getStringFormat(2))));
      } else if(doc.getDocumentDefinition().getId() == 6 ||
              doc.getDocumentDefinition().getId() == 7) {
        row.appendChild(new Cell());
        row.appendChild(new Cell());
        row.appendChild(new Label(DecimalFormats.format(portfolio_balance,
                DecimalFormats.getStringFormat(2))));
        row.appendChild(new Label(DecimalFormats.format(amount,
                DecimalFormats.getStringFormat(2))));
        final_balance -= amount; 
        row.appendChild(new Label(DecimalFormats.format(final_balance,
                DecimalFormats.getStringFormat(2))));
      }
      
    }
    
    setRowCount(count);
  }
  
}