bsfinancials-core/src/main/java/org/turro/financials/model/business/CompanyWrapper.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.business;
 
import java.text.DecimalFormat;
import java.text.NumberFormat;
import java.util.Currency;
import java.util.Date;
import java.util.List;
import java.util.Locale;
import org.amic.util.date.CheckDate;
import org.turro.contacts.Contact;
import org.turro.elephant.context.Application;
import org.turro.financials.db.FinancialsPU;
import org.turro.financials.entity.Company;
import org.turro.financials.entity.Contract;
import org.turro.financials.entity.Department;
import org.turro.financials.entity.Document;
import org.turro.financials.entity.DocumentLine;
import org.turro.financials.entity.Headquarters;
import org.turro.financials.entity.Register;
import org.turro.financials.entity.Service;
import org.turro.financials.model.document.DocumentWrapper;
import org.turro.financials.model.register.RegisterWrapper;
import org.turro.jpa.Dao;
import org.turro.jpa.DaoTransaction;
import org.turro.jpa.entity.DaoEntity;
import org.turro.jpa.entity.EntityCollections;
import org.turro.sql.SqlClause;
import org.turro.zkoss.locale.Currencies;
 
public class CompanyWrapper extends DaoEntity<Company, Long> {
 
  public CompanyWrapper() {
    super(getDefaultCompany(true));
  }
 
  @Override
  protected Dao createDao() {
    return new FinancialsPU();
  }
 
  @Override
  public Company save() {
    EntityCollections.entities(entity.getServices()).removeEmpties();
    EntityCollections.entities(entity.getHeadquarters()).removeEmpties();
    for(Headquarters hq : entity.getHeadquarters()) {
      EntityCollections.entities(hq.getDepartments()).removeEmpties();
    }
    
    _defaultCompany = super.save();
    return _defaultCompany;
  }
 
  @Override
  public boolean delete() {
    // do nothing
    return false;
  }
 
  @Override
  protected boolean shouldLog() {
    return false;
  }
  
//  public static Collection<Register> save(Company company, String startString, String endString, String operatingString) {
//    Collection<Register> list = setCompanyClosingDate(company.getClosingDate(), startString, endString, operatingString);
//    Iterator<Service> its = company.getServices().iterator();
//    while(its.hasNext()) {
//      Service s = its.next();
//      if(Strings.isBlank(s.getName())) {
//        its.remove();
//      }
//    }
//    Iterator<Headquarters> ith = company.getHeadquarters().iterator();
//    while(ith.hasNext()) {
//      Headquarters h = ith.next();
//      if(Strings.isBlank(h.getIdContact())) {
//        ith.remove();
//      } else {
//        Iterator<Department> itd = h.getDepartments().iterator();
//        while(itd.hasNext()) {
//          Department d = itd.next();
//          if(Strings.isBlank(d.getName())) {
//            itd.remove();
//          }
//        }
//      }
//    }
//    company.setContactId(company.getContactId());
//    _defaultCompany = new FinancialsPU().saveObject(company);
//    return list;
//  }
 
  public static boolean isValidDate(Date date) {
    return isValidDate(date, false);
  }
 
  public static boolean isValidDate(Date date, boolean closing) {
    Date dateClosing = getCompanyClosingDate();
    return (date == null || dateClosing == null || dateClosing.before(date) ||
            (closing && new CheckDate(date).getYear() == getEndOfYearClosing(dateClosing)));
  }
 
  public static Date getCompanyClosingDate() {
    Company company = getDefaultCompany();
    if(company != null) {
      return company.getClosingDate();
    }
    return null;
  }
 
  public static int getEndOfYearClosing() {
    return getEndOfYearClosing(getCompanyClosingDate());
  }
 
  public static int getEndOfYearClosing(Date date) {
    CheckDate cd = new CheckDate(date);
    if(cd.getDay() == 31 && cd.getMonth() == 12) {
      return cd.getYear();
    }
    return 0;
  }
 
//  public static Collection<Register> setCompanyClosingDate(Date date, String startString, String endString, String operatingString) {
//    Collection<Register> list = null;
//    Company company = getDefaultCompany();
//    if(company != null) {
//      Date previous = company.getClosingDate();
//      int previousExercise = previous != null ? new CheckDate(previous).getYear() : 0,
//          currentExercise = date != null ? new CheckDate(date).getYear() : 0;
//      if(getEndOfYearClosing(date) > 0) {
//        currentExercise++;
//      }
//      if(previousExercise < currentExercise) {
//        ClosingRegisters cr = new ClosingRegisters(startString, endString, operatingString);
//        if(previousExercise == 0) previousExercise = currentExercise - 1;
//        for(int exercise = previousExercise; exercise < currentExercise; exercise++) {
//          if(!cr.existsClosingRegisters(exercise)) {
//            //cr.deleteClosingRegisters(exercise);
//            list = cr.generateClosingRegisters(exercise);
//          }
//        }
//      } else if(previousExercise > currentExercise) {
//        //ClosingRegisters cr = new ClosingRegisters(startString, endString, operatingString);
//        //for(int exercise = currentExercise + 1; exercise <= previousExercise; exercise++) {
//        //  cr.deleteClosingRegisters(exercise);
//        //}
//      }
//      company.setClosingDate(date);
//      new FinancialsPU().saveObject(company);
//    }
//    return list;
//  }
 
  public static Currency getCompanyCurrency() {
    Company company = getDefaultCompany();
    if(company != null) {
      Contact contact = (Contact) company.getIContact().getContact();
      if(contact != null) {
        return contact.getCurrency();
      }
    }
    return Currencies.getDefault();
  }
 
  public static Locale getCompanyLocale() {
    Company company = getDefaultCompany();
    if(company != null) {
      Contact contact = (Contact) company.getIContact().getContact();
      if(contact != null) {
        return contact.getLocale();
      }
    }
    return Application.getUsedLocale();
  }
 
  public static NumberFormat getCurrencyFormatter() {
    return DecimalFormat.getCurrencyInstance(getCompanyLocale());
  }
 
  public static Company getCompanyFrom(DocumentLine line) {
    if(line != null && line.getStore() != null) {
      Contract store = line.getStore();
      if(store.getDepartment() != null && store.getDepartment().getHeadquarters() != null) {
        return store.getDepartment().getHeadquarters().getCompany();
      }
      if(store.getService() != null) {
        return store.getService().getCompany();
      }
    }
    return getDefaultCompany();
  }
 
  public static Headquarters getHeadquartersFrom(DocumentLine line) {
    if(line != null && line.getStore() != null) {
      Contract store = line.getStore();
      if(store.getDepartment() != null) {
        return store.getDepartment().getHeadquarters();
      }
    }
    return null;
  }
 
  public static Department getDepartmentFrom(DocumentLine line) {
    if(line != null && line.getStore() != null) {
      Contract store = line.getStore();
      return store.getDepartment();
    }
    return null;
  }
 
  public static Service getServiceFrom(DocumentLine line) {
    if(line != null && line.getStore() != null) {
      Contract store = line.getStore();
      return store.getService();
    }
    return null;
  }
 
  private static Company _defaultCompany;
  
  public static Company getDefaultCompany() {
    return getDefaultCompany(false);
  }
 
  public static Company getDefaultCompany(boolean reload) {
    if(reload || _defaultCompany == null) {
      _defaultCompany = (Company) new FinancialsPU().getSingleResult("select company from Company as company");
    }
    return _defaultCompany;
  }
 
  public static void renumRegisters(Integer year, boolean books) {
    if(year == null || year == 0) return;
//    Dao dao = new FinancialsPU();
//    List<Register> l = dao.getResultList(
//            "select r from Register r " +
//            "where year(r.registerDate) = ? " +
//            "and r.view = 1 " +
//            "order by r.registerDate, r.closing desc",
//            new Object[] {
//              year
//            });
    int count = 1;
    try(DaoTransaction transaction = new DaoTransaction(new FinancialsPU())) {
      List<Register> l = transaction.getDao().getResultList(
              "select r from Register r " +
              "where year(r.registerDate) = ? " +
              "and r.view = 1 " +
              "order by r.registerDate, r.closing desc",
              new Object[] {
                year
              });
      for(Register r : l) {
        r.setIdRegister(count++);
        transaction.saveObject(r);
      }
    }
    if(books) {
      renumBookRegisters(year);
    }
  }
 
  public static void renumBookRegisters(Integer year) {
    Dao dao = new FinancialsPU();
    dao.executeUpdate(
            "delete from BookRegister br " +
            "where exists (" +
            "  select r from Register r " +
            "  where br.register.id = r.id " +
            "  and year(r.registerDate) = ? " +
            "  and r.view = 1 " +
            ")",
            new Object[] {
              year
            });
    List<Register> l = dao.getResultList(
            "select r from Register r " +
            "where year(r.registerDate) = ? " +
            "and r.view = 1 " +
            "order by r.idRegister",
            new Object[] {
              year
            });
    for(Register r : l) {
      r = RegisterWrapper.prepareBookRegister(r);
      if(!r.getBookRegisters().isEmpty()) {
        dao.saveObject(r);
      }
    }
  }
 
  public static Service getDefaultService() {
    return (Service) new FinancialsPU().getSingleResult(
            "select service from Service as service " +
            "where service.id = (select min(id) from Service)");
  }
 
  public static Contract getDefaultContractService() {
    return (Contract) new FinancialsPU().getSingleResult(
            "select ctc from Contract as ctc " +
            "where ctc.id = (select min(id) from Contract where service is not null)");
  }
 
  public static void removeExercise(Integer year) {
    Dao dao = new FinancialsPU();
    SqlClause.delete("Document")
            .where().equal("year(receiptDate)", year)
            .dao(dao)
            .execute();
    SqlClause.delete("DocumentLine")
            .where("not exists").sub(
                    SqlClause.select("*").from("Document d")
                    .where("d.identifier = document_identifier"))
            .dao(dao)
            .executeNative();
    SqlClause.delete("DocumentRelation")
            .where("not exists").sub(
                    SqlClause.select("*").from("Document d")
                    .where("d.identifier = ancestor_identifier"))
            .or("not exists").sub(
                    SqlClause.select("*").from("Document d")
                    .where("d.identifier = descendant_identifier"))
            .dao(dao)
            .executeNative();
    SqlClause.delete("Register")
            .where().equal("year(registerDate)", year)
            .dao(dao)
            .execute();
    SqlClause.delete("RegisterEntry")
            .where("not exists").sub(
                    SqlClause.select("*").from("Register r")
                    .where("r.identifier = register_identifier"))
            .dao(dao)
            .executeNative();
    SqlClause.delete("BookRegister")
            .where("not exists").sub(
                    SqlClause.select("*").from("Register r")
                    .where("r.identifier = register_identifier"))
            .dao(dao)
            .executeNative();
  }
 
}