AnnualTransactionsSet.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.model.document;
 
import java.util.*;
import org.amic.util.date.CheckDate;
import org.turro.contacts.Address;
import org.turro.contacts.Contact;
import org.turro.elephant.db.WhereClause;
import org.turro.financials.db.FinancialsPU;
import org.turro.financials.entity.DocumentLine;
import org.turro.jpa.Dao;
 
public abstract class AnnualTransactionsSet extends TreeSet<AnnualTransaction> {
 
  public Collection<String> getColumns() {
    return Arrays.asList(new String[] {
      getLabel("View"),
      getLabel("Key"),
      getLabel("Global identifier"),
      getLabel("Name"),
      getLabel("Address"),
      "Q1",
      "Q2",
      "Q3",
      "Q4",
      getLabel("Amount")
    });
  }
 
  public Collection<Object[]> getRows() {
    List<Object[]> l = new ArrayList<Object[]>();
    for(AnnualTransaction at : this) {
      Contact c = at.getContact();
      Address a = c.getAddressMap().get("Fiscal");
      l.add(new Object[] {
        at.getView(),
        at.getOpKey(),
        c.getGlobalIdentifier(),
        c.getName(),
        (a != null ? a.getAddressString() : ""),
        at.getOperationsAmount(1),
        at.getOperationsAmount(2),
        at.getOperationsAmount(3),
        at.getOperationsAmount(4),
        at.getOperationsAmountSum()
      });
    }
    return l;
  }
 
  public abstract String getLabel(String key);
 
  public void fillSet(int year) {
    //TODO: add to line type the transaction type, ex.: A, B
    WhereClause wc = new WhereClause();
    wc.addClause("select line from DocumentLine line join line.document doc");
    wc.addClause("where year(doc.receiptDate) = :year");
    wc.addNamedValue("year", year);
    wc.addClause("and doc.documentDefinition.id in (12, 2, 1, 51, 49, 46, 5, 15, 18, 52)");
    wc.addClause("and line.lineType.id in (12, 4, 97, 1, 3, 125, 150, 149, 151, 146, 147, 122, 123, 103, 126, 19, 135, 132, 169)");
 
    Dao dao = new FinancialsPU();
 
    for(DocumentLine line : (List<DocumentLine>) dao.getResultList(wc)) {
      String opKey = "E";
      switch((int) line.getLineType().getId()) {
        case 12:
        case 4:
        case 97:
        case 125:
        case 150:
        case 149:
        case 151:
        case 146:
        case 147:
        case 122:
        case 123:
        case 103:
        case 126:
        case 19:
        case 135:
        case 132:
          opKey = "A";
          break;
        case 1:
        case 3:
        case 169:
          opKey ="B";
          break;
      }
      AnnualTransaction at = getAnnualTransaction(
              (line.getDocument().getForcedView() == null ? "" : line.getDocument().getForcedView().getName()),
              opKey,
              line.getDocument().getContract().getContractor());
      at.addOperationsAmount(new CheckDate(line.getDocument().getReceiptDate()).getQuarter(), line.getToDeclare());
    }
  }
 
  private AnnualTransaction getAnnualTransaction(String view, String opKey, String contractor) {
    AnnualTransaction annualTrans = new AnnualTransaction(view, opKey, contractor);
    for(AnnualTransaction at : this) {
      if(at.compareTo(annualTrans) == 0) {
        return at;
      }
    }
    add(annualTrans);
    return annualTrans;
  }
 
}