FinancialsMenu.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.menu;
 
import java.util.Date;
import java.util.HashMap;
import javax.activation.MimetypesFileTypeMap;
import org.amic.util.date.CheckDate;
import org.turro.annotation.ExternalMenu;
import org.turro.command.Command;
import org.turro.command.Context;
import org.turro.elephant.context.ElephantContext;
import org.turro.financials.account.DiaryReport;
import org.turro.financials.account.PrintBook;
import org.turro.financials.assets.FixedAssetWrapper;
import org.turro.financials.book.ExpensesBook;
import org.turro.financials.book.IncomeBook;
import org.turro.financials.document.QuickDocument;
import org.turro.financials.entity.Document;
import org.turro.financials.entity.Register;
import org.turro.financials.model.document.AnnualTransactionsSet;
import org.turro.financials.product.ProductImport;
import org.turro.financials.report.ReportBody;
import org.turro.financials.usual.UsualUpdate;
import org.turro.i18n.I_;
import org.turro.jpa.export.ExportQuery;
import org.turro.menu.ElephantMenu;
import org.turro.menu.ElephantMenuBar;
import org.turro.reflection.Reflections;
import org.turro.security.Permission;
import org.turro.zkoss.dialog.InputDialog;
import org.turro.zkoss.dialog.InputField;
import org.turro.zul.frame.Framework;
import org.zkoss.zk.ui.Executions;
import org.zkoss.zk.ui.event.Event;
import org.zkoss.zk.ui.event.EventListener;
import org.zkoss.zul.Filedownload;
 
@ExternalMenu
public class FinancialsMenu extends ElephantMenu {
 
  private void exportAnnualTransactions(ElephantMenuBar bar) {
    InputDialog.getInput(bar.getPage(), I_.get("Annual statement transactions"), "Year", 
            Integer.valueOf(0), null, 0, new Command() { 
      @Override
      public Object execute(Context context) {
        Integer year = (Integer) context.get("value");
        if(year != null) {
          AnnualTransactionsSet ats = new AnnualTransactionsSet() {
            @Override
            public String getLabel(String key) {
              return I_.get(key);
            }
          };
          ats.fillSet(year);
          String name = ElephantContext.getSiteName() + "_AnnualTrans.xls";
          ExportQuery eq = new ExportQuery(ats.getColumns(), ats.getRows());
          Filedownload.save(eq.getExcel(name), new MimetypesFileTypeMap().getContentType(name), name);
        }
        return null;
      }
    });
  }
 
  private void exportAccountBalance(ElephantMenuBar bar) {
    InputDialog.getInput(
              bar.getPage(), I_.get("Export account balance"), new InputField[] {
                new InputField("Year", Integer.valueOf(new CheckDate().getYear()), null, 0),
                new InputField("Month", Integer.valueOf(new CheckDate().getMonth()), null, 0),
                new InputField("Carry on initial balance", Boolean.valueOf(false), null, 0),
                new InputField("Breakdown", Boolean.valueOf(false), null, 0)
              }, new Command() {
      @Override
      public Object execute(Context context) {
        InputField[] fields = (InputField[]) context.get("fields");
        if(fields.length > 0) {
          DiaryReport.exportAccountBalance(
                  (Integer) InputField.getByLabel("Year", fields).getValue(),
                  (Integer) InputField.getByLabel("Month", fields).getValue(),
                  (Boolean) InputField.getByLabel("Carry on initial balance", fields).getValue(),
                  (Boolean) InputField.getByLabel("Breakdown", fields).getValue()
                  );
        }
        return null;
      }
    });
  }
 
  private void expensesBook(ElephantMenuBar bar) {
    InputDialog.getInput(bar.getPage(), I_.get("Expenses book"), "Year", 
            Integer.valueOf(0), null, 0, new Command() { 
      @Override
      public Object execute(Context context) {
        Integer year = (Integer) context.get("value");
        if(year != null) {
          ExpensesBook.from(year).download();
        }
        return null;
      }
    });
  }
 
  private void incomeBook(ElephantMenuBar bar) {
    InputDialog.getInput(bar.getPage(), I_.get("Income book"), "Year", 
            Integer.valueOf(0), null, 0, new Command() { 
      @Override
      public Object execute(Context context) {
        Integer year = (Integer) context.get("value");
        if(year != null) {
          IncomeBook.from(year).download();
        }
        return null;
      }
    });
  }
 
  @Override
  public void addToMenu(ElephantMenuBar bar) {
    bar.addMenu("Financials", Permission.from("finan-contract", "finan-document", "finan-product", "finan-account"))
      .addSubmenu()
        .addMenu("Management", Permission.from("finan-contract:list", "finan-document:list", "finan-product:list"))
          .addSubmenu()
            .addMenuitem("Contracts", "contract", "/financials/contract/contracts.zul", true, Permission.from("finan-contract:list"))
            .addMenuitem("Documents", "document", "/financials/document/documents.zul", true, Permission.from("finan-document:list"))
            .addMenuitem("Batch of", "batchof", "/financials/batchof/batchofs.zul", true, Permission.from("finan-document:list"))
            .addMenuitem("Payrolls", "/financials/batchof/payrolls.zul", false, Permission.from("finan-document:list"))
            .addMenuitem("Products", "product", "/financials/product/products.zul", true, Permission.from("finan-product:list"))
            .addToolbarSeparator(true)
            .addMenuSeparator()
            .addMenuitem("New contract", "contract_new", (EventListener) (Event event) -> {
              showContract(0L);
            }, true, Permission.from("finan-contract:new"))
            .addMenuitem("New document", "document_new", (EventListener) (Event event) -> {
              showDocument(0L);
            }, true, Permission.from("finan-document:new"))
            .addMenuitem("New quick document", (EventListener) (Event event) -> {
              Date now = new Date();
              QuickDocument w = new QuickDocument(now, 0.0, "");
              w.setPage(bar.getPage());
              w.afterCompose();
              Framework.getCurrent().showModal(I_.get("New document"), w, null);
            }, Permission.from("finan-document:new"))
            .addMenuitem("New batch of", "batchof_new", (EventListener) (Event event) -> {
              showBatchOf(0L);
            }, true, Permission.from("finan-document:new"))
            .addMenuitem("New product", "product_new", (EventListener) (Event event) -> {
              showProduct(0L);
            }, true, Permission.from("finan-product:new"))
            .addMenuitem("Import CSV", (EventListener) (Event event) -> {
              ProductImport.uploadFile();
            }, true, Permission.from("finan-product:new"))
            .addToolbarSeparator(true)
            .addMenuSeparator()
            .addMenuitem("Handshakes", "handshake", "/financials/handshake/queue.zul", true, Permission.from("finan-contract:list"))
            .addToolbarSeparator(true)
        .getParentSubmenu()
          .addMenu("Portfolio", Permission.from("finan-contract:list", "finan-document:list"))
            .addSubmenu()
              .addMenuitem("Portfolio", "portfolio", "/financials/document/portfolio.zul", true)
              .addMenuitem("Documents statement", "/financials/contract/documentsStatement.zul")
              .addMenuitem("Portfolio status", "/financials/document/portfolioStatus.zul")
              .addMenuSeparator()
              .addMenuitem("Portfolio disagreements", "/financials/document/portfolioDisagreements.zul")
              .addMenuitem("Portfolio errors", "/financials/document/portfolioErrors.zul")
              .addMenuSeparator()
              .addMenuitem("Portfolio by entity", "/financials/entities/portfolio.zul")
        .getParentSubmenu()
          .addMenu("POS", Permission.from("class:org.turro.pos.financials.ExportData"))
            .addSubmenu()
              .addMenuitem("Export", (EventListener) (Event event) -> {
                Reflections.of("org.turro.pos.financials.ExportProducts").invoke("execute");
              }, false, Permission.from("finan-product:list"))
        .getParentSubmenu()
          .addMenu("Accounting", Permission.from("finan-account:statement", "finan-account:balance", "finan-register:new"))
            .addSubmenu()
              .addMenuitem("Account statement", "statement", "/financials/account/statement.zul", true, Permission.from("finan-account:statement"))
              .addMenuitem("Account balance", "/financials/account/balance.zul", Permission.from("finan-account:balance"))
              //.addMenuitem("Accounts report", "/financials/account/report.zul", Permission.from("finan-account:balance"))
              .addMenu("Reports", Permission.from("finan-account:balance"))
                .addSubmenu()
                  .addCollecction(ReportBody.reports(), (esm, rb) -> {
                    esm.addMenuitem(rb.getName(), (EventListener) (Event event) -> {
                      HashMap<String, Object> map = new HashMap<String, Object>();
                      map.put("body", rb);
                      showZulFile(rb.getName(), "/financials/reports/report.zul", map);
                    });
                  })
                .getParentSubmenu()
                  .addObject(new DiaryReport(), (esm, dr) -> {
                    dr.setLabel(I_.get("Diary book"));
                    esm.appendChild(dr);
                    dr.afterCompose();
                  })
                  .addObject(new PrintBook(), (esm, pb) -> {
                    pb.setLabel(I_.get("Print book"));
                    esm.appendChild(pb);
                    pb.afterCompose();
                  })
                  .addMenuitem("Export diary", (EventListener) (Event event) -> {
                    DiaryReport.exportDiary();
                  }, false)
                  .addMenuitem("Export account balance", (EventListener) (Event event) -> {
                    exportAccountBalance(bar);
                  }, false, Permission.from("finan-account:balance"))
                  .addMenuitem("Annual statement transactions", (EventListener) (Event event) -> {
                    exportAnnualTransactions(bar);
                  }, false, Permission.from("finan-account:balance"))
                  .addMenuitem("Report sheets", (EventListener) (Event event) -> {
                    new FinancialsSheets().exportSheet(bar.getPage());
                  }, false, Permission.from("finan-account:balance"))
                  .addMenuitem("Operating", "linechart", "/financials/business/operating.zul", Permission.from("finan-account:balance"))
                  .addMenuSeparator()
                  .addMenuitem("Views", "/financials/view/views.zul", Permission.from("finan-model:list"))
                  .addMenuitem("Books", "/financials/book/books.zul", Permission.from("finan-model:list"))
                  .addMenuitem("Major accounts", "/financials/account/majors.zul", Permission.from("finan-model:list"))
                  .addMenuitem("Accounts", "/financials/account/accounts.zul", Permission.from("finan-model:list"))
                  .addMenuSeparator()
                  .addMenuitem("Fixed assets", "asset", "/financials/asset/fixedAssets.zul", Permission.from("finan-fixed-asset:list"))
                  .addMenuitem("New fixed asset", "asset_new", (EventListener) (Event event) -> {
                    showFixedAsset(0L);
                  }, false, Permission.from("finan-fixed-asset:list"))
                  .addMenuitem("Depreciations", (EventListener) (Event event) -> {
                    FixedAssetWrapper.doDepreciations(bar.getPage());
                  }, false, Permission.from("finan-fixed-asset:list"))
                  .addMenuSeparator()
                  .addMenuitem("New register", "register_new", (EventListener) (Event event) -> {
                    showRegister(0L);
                  }, false, Permission.from("finan-register:new"))
        .getParentSubmenu()
          .addMenu("Treasury", Permission.from("finan-account:balance"))
            .addSubmenu()
              .addMenuitem("Model 111, 115, 123", "/financials/treasury/model111.zul")
              .addMenuitem("Model 303 Quarter", "/financials/treasury/model303.zul")
              .addMenuitem("Model 303 Month", "/financials/treasury/model303m.zul")
              .addMenuitem("Settlement", "/financials/treasury/settlement.zul")
              .addMenuitem("Expenses book", (EventListener) (Event event) -> {
                expensesBook(bar);
              }, false, Permission.from("finan-account:balance"))
              .addMenuitem("Income book", (EventListener) (Event event) -> {
                incomeBook(bar);
              }, false, Permission.from("finan-account:balance"))
        .getParentSubmenu()
          .addMenu("Warnings", Permission.from("finan-contract:list", "finan-document:list"))
            .addSubmenu()
              .addMenuitem("Disagreements in contacts", "/financials/contract/contactDisagreements.zul", Permission.from("finan-contract:list"))
              .addMenuitem("Update Usuals", (EventListener) (Event event) -> {
                new UsualUpdate().update();
              }, false, Permission.from("finan-document:list"))
              .addMenuitem("Non balanced registers", "/financials/register/nonBalanced.zul", Permission.from("finan-register:list"))
        .getParentSubmenu()
          .addToolbarSeparator(true)
          .addMenu("Models", Permission.from("finan-model:list"))
            .addSubmenu()
              .addMenuitem("Viewer", "/financials/ctcdef/viewer.zul")
              .addMenuSeparator()
              .addMenuitem("Companies", "/financials/business/companies.zul")
              .addMenuSeparator()
              .addMenuitem("Contract models", "/financials/ctcdef/contracts.zul")
              .addMenuitem("Document models", "/financials/docdef/documents.zul")
              .addMenuitem("Line types", "/financials/linetype/lineTypes.zul")
              .addMenuSeparator()
              .addMenuitem("Notes", "/financials/ctcdef/notes.zul");
  }
 
  public static void showDocumentDefinition(Long id) {
    showEntity(id, "docdefId", "Document model", "/financials/docdef/document.zul");
  }
 
  public static void showContractDefinition(Long id) {
    showEntity(id, "ctcdefId", "Contract model", "/financials/ctcdef/contract.zul");
  }
 
  public static void showContract(Long id) {
    showEntity(id, "contractId", "Contract", "/financials/contract/contract.zul");
  }
 
  public static void showDocument(Long id) {
    showEntity(id, "documentId", "Document", "/financials/document/document.zul");
  }
 
  public static void showBatchOf(Long id) {
    showEntity(id, "batchOfId", "Batch of", "/financials/batchof/batchof.zul");
  }
 
  public static void showDocument(Document doc) {
    HashMap<String, Object> map = new HashMap<String, Object>();
    map.put("documentGenerated", doc);
    showEntity(doc.getId(), "documentId", "Document", "/financials/document/document.zul", map);
  }
 
  public static void showRegister(Long id) {
    showEntity(id, "registerId", "Register", "/financials/register/register.zul");
  }
 
  public static void showRegister(Register reg) {
    HashMap<String, Object> map = new HashMap<String, Object>();
    map.put("registerGenerated", reg);
    showEntity(reg.getId(), "registerId", "Register", "/financials/register/register.zul", map);
  }
 
  public static void showProduct(Long id) {
    showEntity(id, "productId", "Product", "/financials/product/product.zul");
  }
 
  public static void showStatement(String account) {
    Executions.getCurrent().getDesktop().setAttribute("statementId", account);
    showEntity(0L, "none", "Account statement", "/financials/account/statement.zul");
  }
 
  public static void showFixedAsset(Long id) {
    showEntity(id, "fixedAssetId", "Fixed asset", "/financials/asset/fixedAsset.zul");
  }
 
  public static void showCompanies() {
    showZulFile("Companies", "/financials/business/companies.zul");
  }
}