MajorAccount.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.entity;
 
import java.util.Collections;
import java.util.List;
import javax.persistence.*;
import org.turro.financials.db.FinancialsPU;
 
@Entity
public class MajorAccount implements java.io.Serializable {
 
  @Id
  @GeneratedValue(strategy=GenerationType.IDENTITY)
  @Column(name="IDENTIFIER")
  private long id;
 
  private String account;
 
  private String description;
  
  private MajorAccountType type;
 
  @ManyToOne
  private BookDefinition bookDefinition;
 
  public String getAccount() {
    return account;
  }
 
  public void setAccount(String account) {
    this.account = account;
  }
 
  public BookDefinition getBookDefinition() {
    return bookDefinition;
  }
 
  public void setBookDefinition(BookDefinition bookDefinition) {
    this.bookDefinition = bookDefinition;
  }
 
  public List<MajorAccount> getDescendants() {
    if(account != null) {
      return new FinancialsPU().getResultList(
              "select m from MajorAccount as m " +
              "where m.account like '" + account + "_' " +
              "and exists ( " +
              "  select re from RegisterEntry as re " +
              "  where re.account.id like concat(m.account, '%') " +
              ") " +
              "order by m.account");
              //account.substring(0, account.length() - 1)+ "?'"));
    }
    return Collections.EMPTY_LIST;
  }
 
  public String getDescription() {
    return description;
  }
 
  public void setDescription(String description) {
    this.description = description;
  }
 
  public long getId() {
    return id;
  }
 
  public void setId(long id) {
    this.id = id;
  }
 
  public MajorAccountType getType() {
    return type;
  }
 
  public void setType(MajorAccountType type) {
    this.type = type;
  }
 
  public MajorAccount getParent() {
    if(account != null && account.length() > 1) {
      List l = new FinancialsPU().getResultList(
              "select m from MajorAccount as m where m.account = '" +
              account.substring(0, account.length() - 1)+ "' " +
              "order by m.account");
      if(!l.isEmpty()) {
        return (MajorAccount) l.get(0);
      }
    }
    return null;
  }
 
  public List<Account> getAccounts() {
    if(account != null) {
      return new FinancialsPU().getResultList(
        "select a from Account as a " +
        "where exists ( " +
        "  select ma from MajorAccount as ma " +
        "  where ma.account = '" + account + "' " +
        "  and a.id like concat(ma.account, '_%') " +
        "  and not exists ( " +
        "    select ma2 from MajorAccount as ma2 " +
        "    where ma2.account like concat(ma.account, '0%') " +
        "  ) " +
        ") " +
        "order by a.id");
    }
    return Collections.EMPTY_LIST;
  }
 
  public static MajorAccount getMajor(String account) {
    if(account != null && account.length() > 1) {
      return (MajorAccount) new FinancialsPU().getSingleResult(
              "select m from MajorAccount as m where m.account = '" +
              account + "'");
    }
    return null;
  }
 
}