DocumentByContractViewerGrid.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.auth.Authentication;
import org.turro.elephant.context.Application;
import org.turro.elephant.util.DateFormats;
import org.turro.elephant.util.DecimalFormats;
import org.turro.financials.entity.Contract;
import org.turro.financials.entity.Document;
import org.turro.financials.entity.RegisterView;
import org.turro.financials.model.document.contract.DocumentByContractList;
import org.turro.financials.view.ViewListbox;
import org.turro.i18n.I_;
import org.turro.plugin.contacts.IContact;
import org.turro.zkoss.grid.PagingGrid;
import org.turro.zkoss.input.DateboxShort;
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.zk.ui.ext.AfterCompose;
import org.zkoss.zul.Button;
import org.zkoss.zul.Cell;
import org.zkoss.zul.Column;
import org.zkoss.zul.Columns;
import org.zkoss.zul.Label;
import org.zkoss.zul.Row;
import org.zkoss.zul.Rows;
import org.zkoss.zul.Space;
 
public class DocumentByContractViewerGrid extends PagingGrid implements AfterCompose {
 
  private GridLayout toolbar;
  private Button searchButton;
  private IContact contact;
  private boolean searchBar = true;
  private RegisterView view;
  private Contract contract;
  private Date from, to;
 
  public DocumentByContractViewerGrid() {
    addColumns();
    from = new CheckDate(-1, 1, 1, 0, 0, 0).getDate();
    to = new Date();
  }
 
  public void setContact(IContact contact) {
    this.contact = contact;
  }
  
  public void setSearchBar(boolean searchBar) {
    this.searchBar = searchBar;
  }
 
  private void addColumns() {
    Columns cols = new Columns();
    appendChild(cols);
 
    Column col = new Column(I_.get("Date"));
    col.setWidth("90px");
    cols.appendChild(col);
    
    col = new Column(I_.get("Concept"));
    col.setHflex("1");
    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("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);
    
    col = new Column();
    col.setWidth("50px");
    cols.appendChild(col);
  }
 
  private void addRows() {
    Rows rows = getRows(true);
    rows.getChildren().clear();
    
    if(contract == null) return;
    
    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);
              
      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))));
      row.appendChild(new Space());
    }
    
    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);
              
      row.appendChild(new Label(DateFormats.format(doc.getDocumentDate(), true)));
 
      row.appendChild(new Label(doc.getDocumentDefinition().getName() + " " + doc.getDocumentNumber()));
 
      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))));
      }
      
      DocumentReport dr = new DocumentReport();
      dr.setDocument(doc);
      dr.setShowLabels(false);
      row.appendChild(dr);
      dr.afterCompose();
    }
    
    setRowCount(count);
  }
 
  private void addSearchBar() {
    Application app = Application.getApplication();
    
    if(toolbar != null) getParent().removeChild(toolbar);
 
    if(!searchBar) return;
 
    toolbar = new GridLayout("min,1");
    getParent().insertBefore(toolbar, this);
    toolbar.setStyle("font-size:11px");
 
    toolbar.addCaption(I_.get("Contract"));
    if(app.isInRole("finan-contract:list")) {
      final DocumentsByContractCombobox dbc = new DocumentsByContractCombobox();
      dbc.setHflex("1");
      dbc.addEventListener(Events.ON_CHANGE, new EventListener() {
        @Override
        public void onEvent(Event event) throws Exception {
          contract = dbc.getObjectValue();
        }
      });
      toolbar.addComponent(dbc);
    } else {
      final ContractByInterventionListbox cbi = new ContractByInterventionListbox();
      cbi.setContact(Authentication.getIContact());
      cbi.setMold("select");
      cbi.setAllowNull(true);
      cbi.addEventListener(Events.ON_SELECT, new EventListener() {
        @Override
        public void onEvent(Event event) throws Exception {
          contract = cbi.getObjectValue();
        }
      });
      toolbar.addComponent(cbi);
    }
    
    if(app.isInRole("finan-view:list")) {
      toolbar.addRow();
      toolbar.addCaption(I_.get("View"));
      final ViewListbox vl = new ViewListbox();
      vl.setMold("select");
      vl.setAllowNull(true);
      toolbar.addComponent(vl);
      vl.addEventListener(Events.ON_SELECT, new EventListener() {
        @Override
        public void onEvent(Event event) throws Exception {
          view = vl.getObjectValue();
        }
      });
    }
 
    toolbar.addRow();
    toolbar.addCaption(I_.get("From"));
    final DateboxShort fromInput = new DateboxShort(from);
    fromInput.addEventListener(Events.ON_CHANGE, new EventListener() {
      @Override
      public void onEvent(Event event) throws Exception {
        from = fromInput.getValue();
      }
    });
    toolbar.addComponent(fromInput);
    
    toolbar.addRow();
    toolbar.addCaption(I_.get("To"));
    final DateboxShort toInput = new DateboxShort(to);
    fromInput.addEventListener(Events.ON_CHANGE, new EventListener() {
      @Override
      public void onEvent(Event event) throws Exception {
        to = toInput.getValue();
      }
    });
    toolbar.addComponent(toInput);
    
    searchButton = new Button(
            I_.get("Search"),
            "/_zul/images/search.png"
            );
    searchButton.addEventListener(Events.ON_CLICK, new EventListener() {
      @Override
      public void onEvent(Event event) throws Exception {
        addRows();
      }
    });
    toolbar.addRow();
    toolbar.addSpace();
    toolbar.addComponent(searchButton);
 
  }
 
  @Override
  public void afterCompose() {
    addSearchBar();
    addRows();
  }
 
}