org.turro.financials.account.DiaryReport Class Reference

Inheritance diagram for org.turro.financials.account.DiaryReport:

Collaboration diagram for org.turro.financials.account.DiaryReport:

Public Member Functions
	DiaryReport ()
Collection< Long >	getRegisters ()
WhereClause	getSQLRegisters ()
Public Member Functions inherited from org.turro.zkoss.print.ReportMenuitem
	ReportMenuitem ()
void	afterCompose ()

Static Public Member Functions
static void	exportDiary ()
static void	exportAccountBalance (int year, int month, boolean carry, boolean breakdown)
static Integer	getLastInitialSince (int year)

Protected Member Functions
void	print (final String type)

Detailed Description

Author

Lluis Turró Cutiller lluis.nosp@m.@tur.nosp@m.ro.or.nosp@m.g

Definition at line 63 of file DiaryReport.java.

Constructor & Destructor Documentation

DiaryReport()

org.turro.financials.account.DiaryReport.DiaryReport

(

)

Definition at line 69 of file DiaryReport.java.

                       {
  }

Member Function Documentation

exportAccountBalance()

static void org.turro.financials.account.DiaryReport.exportAccountBalance ( int  year, int  month, boolean  carry, boolean  breakdown  )

static

Definition at line 231 of file DiaryReport.java.

                                                                                                 {
    WhereClause wc = new WhereClause();
    wc.addClause("select r.view.name,");
    if(breakdown) {
      wc.addClause("year(r.registerDate),");
      wc.addClause("month(r.registerDate),");
    }
    wc.addClause("substring(re.account.id, 1, 1), (select ma1.description from MajorAccount ma1 where ma1.account = substring(re.account.id, 1, 1)),");
    wc.addClause("substring(re.account.id, 1, 2), (select ma2.description from MajorAccount ma2 where ma2.account = substring(re.account.id, 1, 2)),");
    wc.addClause("substring(re.account.id, 1, 3), (select ma3.description from MajorAccount ma3 where ma3.account = substring(re.account.id, 1, 3)),");
    wc.addClause("ma.account, ma.description, re.account.id,");
    wc.addClause("re.account.description, sum(re.debit), sum(re.credit)");
    wc.addClause("from RegisterEntry re join re.register r, MajorAccount ma");
    wc.addClause("where ma.account = (select max(m.account) from MajorAccount as m");
    wc.addClause("where re.account.id like concat(m.account, '%'))");
    wc.addClause("and r.registerDate < :date");
    wc.addNamedValue("date", new CheckDate(year, month, 1, 0, 0, 0).addMonths(1).getDate());
    if(carry) {
      wc.addClause("and year(r.registerDate) >= :carry");
      wc.addNamedValue("carry", getLastInitialSince(year));
      wc.addClause("and not (r.exclude = TRUE and year(r.registerDate) = :year)");
      wc.addNamedValue("year", year);
    } else {
      wc.addClause("and year(r.registerDate) = :carry");
      wc.addNamedValue("carry", year);
      wc.addClause("and not (r.exclude = TRUE or r.closing = TRUE)");
    }
    if(breakdown) {
      wc.addClause("group by r.view.name, year(r.registerDate), month(r.registerDate), re.account.id, ma.account, ma.description");
    } else {
      wc.addClause("group by r.view.name, re.account.id, ma.account, ma.description");
    }
    wc.addClause("order by re.account.id");
 
    List<String> l;
    if(breakdown) {
      l = Arrays.asList(new String[] {
        I_.get("View"),
        I_.get("Year"),
        I_.get("Month"),
        "M1", "M1Desc", "M2", "M2Desc", "M3", "M3Desc",
        I_.get("Major account"),
        I_.get("Name"),
        I_.get("Account"),
        I_.get("Description"),
        I_.get("Debit"),
        I_.get("Credit")
      });
    } else {
      l = Arrays.asList(new String[] {
        I_.get("View"),
        "M1", "M1Desc", "M2", "M2Desc", "M3", "M3Desc",
        I_.get("Major account"),
        I_.get("Name"),
        I_.get("Account"),
        I_.get("Description"),
        I_.get("Debit"),
        I_.get("Credit")
      });
    }
    Dao dao = new FinancialsPU();
    String name = ElephantContext.getSiteName() + "_AccountBalance.xls";
    ExportQuery eq = new ExportQuery(l, dao.getResultList(wc));
    Filedownload.save(eq.getExcel(name), new MimetypesFileTypeMap().getContentType(name), name);
  }

Here is the call graph for this function:

exportDiary()

static void org.turro.financials.account.DiaryReport.exportDiary ( )

static

Definition at line 183 of file DiaryReport.java.

                                   {
    IContact contact = Authentication.getIContact();
    MailSenders.getHeavy()
            .addContact(contact)
            .onStart(s -> MessageQueue.pushMessage(contact, I_.get("Report will be sent by email")))
            .onCancel(s -> MessageQueue.pushMessage(contact, I_.get("Task already running")))
            .onBuild(s -> diaryToExcel((IMailSender) s))
            .send(I_.get("Export diary"), I_.get("Export diary"));
  }

Here is the call graph for this function:

Here is the caller graph for this function:

getLastInitialSince()

static Integer org.turro.financials.account.DiaryReport.getLastInitialSince ( int  year )

static

Definition at line 297 of file DiaryReport.java.

                                                      {
    return SqlClause.select("year(max(registerDate))").from("Register")
            .where().equal("closing", true)
            .and().equal("exclude", false)
            .and().smallerOrEqual("year(registerDate)", year)
            .and().equal("view.id", 1L)
            .dao(new FinancialsPU())
            .singleResult(Integer.class);
  }

getRegisters()

Collection<Long> org.turro.financials.account.DiaryReport.getRegisters

(

)

Definition at line 156 of file DiaryReport.java.

                                         {
    WhereClause wc = new WhereClause();
    wc.addClause("select reg.id");
    wc.addClause("from Register reg");
    wc.addClause("where reg.view = :view");
    wc.addNamedValue("view", view);
    wc.addClause("and year(reg.registerDate) = :year");
    wc.addNamedValue("year", year);
    wc.addClause("order by reg.idRegister");
    
    Dao dao = new FinancialsPU();
    return dao.getResultList(wc);
  }

Here is the call graph for this function:

getSQLRegisters()

WhereClause org.turro.financials.account.DiaryReport.getSQLRegisters

(

)

Definition at line 170 of file DiaryReport.java.

                                       {
    WhereClause wc = new WhereClause();
    wc.addClause("select reg");
    wc.addClause("from Register reg");
    wc.addClause("where reg.view = :view");
    wc.addNamedValue("view", view);
    wc.addClause("and year(reg.registerDate) = :year");
    wc.addNamedValue("year", year);
    wc.addClause("order by reg.idRegister");
    
    return wc;
  }

Here is the call graph for this function:

print()

void org.turro.financials.account.DiaryReport.print ( final String  type )

protected

Reimplemented from org.turro.zkoss.print.ReportMenuitem.

Definition at line 73 of file DiaryReport.java.

                                          {
    if(view == null) {
      view = ViewWrapper.getFormalView();
    }
    year = new CheckDate().getYear();
    startPage = 1;
    
    InputDialog.getInput(
            Framework.getCurrent().getPage(),
            I_.get("Diary book"),
            new InputField[] {
              new InputField("Year", year, null, 0),
              new InputField("Start page", startPage, null, 0),
              new InputField("View", null, null, 0) {
                @Override
                protected HtmlBasedComponent createEditor() {
                  ViewListbox vl = new ViewListbox();
                  vl.setMold("select");
                  return vl;
                }
              }
            }, new Command() {
      @Override
      public Object execute(Context context) {
        InputField[] fields = (InputField[]) context.get("fields");
        if(fields.length > 0) {
          for(InputField f : fields) {
            if("Year".equals(f.getLabel())) {
              year = (Integer) f.getValue();
            } else if("Start page".equals(f.getLabel())) {
              startPage = (Integer) f.getValue() - 1;
            } else if("View".equals(f.getLabel())) {
              view = (RegisterView) f.getValue();
            }
          }
          if(year != null) {
            IContact contact = Authentication.getIContact();
            MailSenders.getHeavy()
                    .addContact(contact)
                    .onStart(s -> MessageQueue.pushMessage(contact, I_.get("Report will be sent by email")))
                    .onCancel(s -> MessageQueue.pushMessage(contact, I_.get("Task already running")))
                    .onBuild(s -> print2execute((IMailSender) s))
                    .send(I_.get("Diary book"), I_.get("Diary book"));
          }
        }
        return null;
      }
    });           
  }

Here is the call graph for this function:

---

The documentation for this class was generated from the following file:

• DiaryReport.java