FinancialsSheets.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.io.File;
import java.io.IOException;
import java.util.Date;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.activation.MimetypesFileTypeMap;
import jxl.read.biff.BiffException;
import jxl.write.WriteException;
import org.turro.command.Command;
import org.turro.command.Context;
import org.turro.elephant.context.ElephantContext;
import org.turro.financials.entity.RegisterView;
import org.turro.financials.model.register.ViewWrapper;
import org.turro.financials.sheets.ReportSheet;
import org.turro.financials.view.ViewListbox;
import org.turro.i18n.I_;
import org.turro.zkoss.dialog.InputDialog;
import org.turro.zkoss.dialog.InputField;
import org.zkoss.zk.ui.Page;
import org.zkoss.zul.Filedownload;
 
public class FinancialsSheets {
 
  public void exportSheet(Page page) {
    File dir = new File(ElephantContext.getRealPath("/WEB-INF/_reports/financials/sheets"));
    InputField iDate = new InputField("Date", new Date(), null, 0);
    InputField iFile = new InputField("Sheet", dir, "*.xls", 0);
    ViewListbox vl = new ViewListbox();
    vl.setMold("select");
    vl.setAllowNull(true);
    InputField iView = new InputField("View", vl, ViewWrapper.getFormalView());
    InputDialog.getInput(
              page, I_.get("Report sheets"),
              new InputField[] {iDate, iFile, iView},
              new Command() {
      @Override
      public Object execute(Context context) {
        File file = null;
        Date date = null;
        RegisterView view = null;
        InputField[] fields = (InputField[]) context.get("fields");
        if(fields.length > 0) {
          for(InputField f : fields) {
            if("Date".equals(f.getLabel())) {
              date = (Date) f.getValue();
            } else if("Sheet".equals(f.getLabel())) {
              file = (File) f.getValue();
            } else if("View".equals(f.getLabel())) {
              view = (RegisterView) f.getValue();
            }
          }
          try {
            //File file = new File(Application.getApplication().getRealPath("/WEB-INF/_reports/financials/sheets/ComptesAnuals.xls"));
            ReportSheet rs = new ReportSheet(file, date, view);
            Filedownload.save(rs.getExcel(), new MimetypesFileTypeMap().getContentType(file.getName()), file.getName());
          } catch (IOException | BiffException | WriteException ex) {
            Logger.getLogger(FinancialsSheets.class.getName()).log(Level.SEVERE, ElephantContext.logMsg(null), ex);
          }
        }
        return null;
      }
    });
  }
 
}