m303/Model349List.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.financials.treasury.m303;
 
import java.text.NumberFormat;
import java.util.Date;
import java.util.List;
import java.util.TreeSet;
import org.turro.financials.entity.Register;
import org.turro.financials.model.business.CompanyWrapper;
import org.turro.i18n.I_;
import org.turro.zkoss.input.CollectionListbox;
import org.zkoss.zul.Listhead;
import org.zkoss.zul.Listheader;
 
public class Model349List extends CollectionListbox<Item349> {
 
  private TreeSet<Item349> set = new TreeSet<Item349>();
  private NumberFormat currencyFormatter = CompanyWrapper.getCurrencyFormatter();
 
  
  public Model349List(EntryQuarter eq) {
    addHeaders();
    fillData(eq);
  }
 
  @Override
  protected String convertToString(Item349 v) {
    return v.name + CollectionListbox.ITEM_SEPARATOR +
            currencyFormatter.format(v.amount[0]) + 
            CollectionListbox.ITEM_SEPARATOR +
            currencyFormatter.format(v.amount[1]);
  }
 
  private void fillData(EntryQuarter eq) {
    Date init = eq.getQuarterInitialDate(),
         end = eq.getFinalDate();
    String vatAcc = eq.getEntry().getType().getVatAccount(),
           opAcc = eq.getEntry().getType().getOpAccount();
    long book = eq.getEntry().getType().getBookId();
    List<Register> l = eq.getDao().getResultList(
            "select distinct r from Register r " +
            "join r.registerEntries e " +
            "join r.bookRegisters b with b.bookDefinition.id = ? " +
            "where r.registerDate <= ? " +
            "and r.registerDate >= ? " +
            "and r.view.id = 1 " +
            "and (r.exclude = FALSE and e.register.closing = FALSE and e.register.regularizeVAT = FALSE) " +
            "and e.account.id like ?",
            new Object[] { book, end, init, vatAcc });
     for(Register r : l) {
       Item349 i349 = getItem(Item349.getName(r));
       if(i349 != null) {
        i349.addAmounts(r, opAcc);
       }
     }
     setCollection(set);
  }
 
  private Item349 getItem(String name) {
    if(name == null) return null;
    for(Item349 i349 : set) {
      if(name.equals(i349.name)) {
        return i349;
      }
    }
    Item349 i349 = new Item349(name);
    set.add(i349);
    return i349;
  }
 
  private void addHeaders() {
    if(getListhead() != null) return;
    Listhead lh = new Listhead();
    lh.setSizable(true);
    lh.appendChild(new Listheader(I_.get("Name"), null, "50%"));
    lh.appendChild(new Listheader(I_.get("Product"), null, "25%"));
    lh.appendChild(new Listheader(I_.get("Service"), null, "25%"));
    appendChild(lh);
  }
 
}