ZK Window X4

From iDempiere en
Jump to navigation Jump to search

> JPiere - Top > JPPS > ZK Window X > ZK Window X4

JPiere
OSS ERP Solutions


Note.gif Note:

Pivot Window use library of ZK Pivottable that is Commercial License(you can use 60 day free evaluation As of June, 2017). Please confirm ZK license before using Pivot Window.


About Pivot Window

  • Pivot Window can create Pivot Table that is like a MS Excel function in iDempiere.
  • Pivot Window use Function of ZK Pivotable table. You can use ZK Pivot Table in iDempiere and you can analyze almost data in iDempiere.
  • Pivot Window can create by parameter setting only. How to create Pivot Window is same with Info Window basically.

PivotWindowImage1.png


PivotWindowImage2.png


Basic operations

Pivot Window is constituted from 2 area.

  • "Pivot Table area" is Displayed Pivot Table.
  • "Controller area" is to configurate a Pivot Table."Controller area" can fold up to expand "Pivot Table area".

PivotWindowImage3.png


Controller area

Controller Area is constituted from 3 area.

  • Search Fields Area … Select condition to summarize by Pivot Table.
  • Pivot Window definition area … Edit row and column, value of Pivot Table. You can predefine.
  • Preference area … You can configurate to display pivot table. And perform to view report.

PivotWindowImage4.png


Configurations of Pivot Window

You can create Pivot Window at System client. How to create Pivot Window is same with Info Window basically.


Pivot Window Configuration Tab

PivotWindowImage5.png


Pivot Window Field Tab

PivotWindowImage6.png


Pivot Window Default Tab

You can predefine rows and columns , values of Pivot Table.

PivotWindowImage7.png


Pivot Window Default Field Tab

PivotWindowImage8.png


Configurations of Form

You must create a new Form. And then assign that to a menu.

PivotWindowImage9.png


Dev Info of Pivot Window

Information of Plugin Projects

plugin of Pivot window have 2 plugin projects

  • jpiere.plugin.webui.pivotwindow.experimental … main plugin project of Pivot Window.
  • jpiere.plugin.webui.pivotwindow.fragment.experimental … fragment of org.adempiere.ui.zk. This fragment is intent to set library of ZK Pivottable. Please down load jar file of ZK Pivottable (you can use 60 day free evaluation As of June, 2017). And set like a below.


Note.gif Note:

Pivot Window use library of ZK Pivottable that is Commercial License(you can use 60 day free evaluation As of June, 2017). Please confirm ZK license before using Pivot Window.


PivotWindowImage10.png


Information of Add On Tables

There are Add on tables info in SQL-DDL directory at project of jpiere.plugin.webui.pivotwindow. You can use 2Pack. Zip file of 2 pack is IN 2Pack directory at project of jpiere.plugin.webui.pivotwindow. 2Pack file name is JPIERE-0356.zip

If you pack in JPIERE-0356.zip, menu of Pivot Window Config appears at Application Dictionary. PivotWindowImage11.png


Unfortunately, if you could not pack in JPIERE-0356.zip, you must create add on tables from SQL-DDL. And create Window of Pivot Window Config like a below.

PivotWindowImage12.png



Note.gif Note:

Pivot Window use library of ZK Pivottable that is Commercial License(you can use 60 day free evaluation As of June, 2017). Please confirm ZK license before using Pivot Window.