What data type ie collection or logic to be used for data?

[Maki Jav]

Hi,


I have a pivot and my pivotTableModel holds data in this fashion...
eg I have a data containing task,Year and month field values


The struture of my PivotTableModel. Below the data is being show in PivotTableModel rows...
it has theses fields
Task         Year Month Values

Issued check                7 => Total checks issued
               2010            4 => Total issued in 2010
                      Feb       3 ==> in Feb, 2011
                      Mar       1 ==> no of checks issued in Mar 2011
               2011            3 ==> Total in 2011
                      Dec       3 == > issued in Dec, 2011


Now I have to show this pivot table

                         2011      2010   Total
Task                   Feb Mar  Dec
Issued Checks      3    1     3         7



How to go about it?

I have a logic which tells me that user has asked for one (or more ) columns on the left and one or more columns on the top

I am havng success to show and also sort values of the left ie values of the task. but the values on the top. If single set of values I am to show. no problem, it is sorting too. but when I have more than that on the top, the top header values stop sorting and also the values against them in the table are not getting put correctly.

Thank you,

Maki Jav

[Maki Jav]

Anyone there to help me with this? What path should I take?

[Maki Jav]

The main problem could be that

There can be more than one Feb 2011 occuring against tasks that I have not shown. So I need to merge all occurences and show as one Feb 2011 on the x-axis and show other tasks as occuring against it...



Anyone with a suggestion to the problem?

[Riaan Nel]

It's pretty difficult to understand your question as it is.

Can you post a SSCCE?

[Maki Jav]

This is the model with real data from database...

class PivotTableModel{


	private String []columns ={"name","Year","Month","pivotValue","Totals"};;
	private Class []columnClass ={String.class,Integer.class,Integer.class,Double.class,Double.class};;

	private Object [][]rows = new Object[][]{
		new Object[]{"BALANCE CONFIRMATION PROCESS",null,null,null,534.0},
		new Object[]{null,2011,null,null,null},
		new Object[]{null,null,3,2.0,null},
		new Object[]{null,null,4,75.0,null},
		new Object[]{null,null,5,149.0,null},
		new Object[]{null,null,6,95.0,null},
		new Object[]{null,null,7,145.0,null},
		new Object[]{null,null,8,56.0,null},
		new Object[]{null,null,9,12.0,null},
		new Object[]{"CASH EXCESS OR SHORTAGE",null,null,null,117.0},
		new Object[]{null,2011,null,null,null},
		new Object[]{null,null,2,2.0,null},
		new Object[]{null,null,3,9.0,null},
		new Object[]{null,null,4,20.0,null},
		new Object[]{null,null,5,31.0,null},
		new Object[]{null,null,6,25.0,null},
		new Object[]{null,null,7,13.0,null},
		new Object[]{null,null,8,11.0,null},
		new Object[]{null,null,9,6.0,null},
		new Object[]{"CENTRAL BANK ORDER PROCESS",null,null,null,128.0},
		new Object[]{null,2010,null,null,null},
		new Object[]{null,null,12,2.0,null},
		new Object[]{null,2011,null,null,null},
		new Object[]{null,null,3,2.0,null},
		new Object[]{null,null,4,15.0,null},
		new Object[]{null,null,5,41.0,null},
		new Object[]{null,null,6,41.0,null},
		new Object[]{null,null,8,27.0,null},
		new Object[]{"DECEASED ACCOUNT PROCESS",null,null,null,5.0},
		new Object[]{null,2011,null,null,null},
		new Object[]{null,null,2,3.0,null},
		new Object[]{null,null,4,1.0,null},
		new Object[]{null,null,5,1.0,null},
		new Object[]{"INCIDENT REPORT PROCESS",null,null,null,1128.0},
		new Object[]{null,2010,null,null,null},
		new Object[]{null,null,12,2.0,null},
		new Object[]{null,2011,null,null,null},
		new Object[]{null,null,1,69.0,null},
		new Object[]{null,null,2,169.0,null},
		new Object[]{null,null,3,158.0,null},
		new Object[]{null,null,4,142.0,null},
		new Object[]{null,null,5,167.0,null},
		new Object[]{null,null,6,177.0,null},
		new Object[]{null,null,7,120.0,null},
		new Object[]{null,null,8,93.0,null},
		new Object[]{null,null,9,31.0,null},
		new Object[]{"INCIDENT REPORTING (INCOMING)",null,null,null,1.0},
		new Object[]{null,2011,null,null,null},
		new Object[]{null,null,1,1.0,null}
		};

	public PivotTableModel(){}


	public int getColumnCount() {
		return (columns != null) ? columns.length : 0;
	}

	public String getColumnName(int columnIndex) {
		return (columns != null) ? columns[columnIndex] : null;

	}

	public int getRowCount() {
		return (rows != null) ? rows.length : 0;
	}

	public Object getValueAt(int rowIndex, int columnIndex) {
		return (rows != null) ? rows[rowIndex][columnIndex] : null;
	}


	public Class getColumnClass(int columnIndex) {
			return columnClass[columnIndex];
	}



// just a test
 public static void main(String []args){

	 PivotTableModel ptm = new PivotTableModel();

	 System.out.println(ptm.getValueAt(0,0));
	 System.out.println(ptm.getColumnCount());
	 System.out.println(ptm.getRowCount());
	 System.out.println(ptm.getColumnName(3));
	 System.out.println(ptm.getColumnClass(3));


 }


}

[Maki Jav]

And I need to pivot it with the structure

				Total
	2011		2010
	Feb	Mar	Dec
Task				100 (including other tasks)
Issued Checks	3	1	3	7

        Year         Total
        Month
name                value

please see table I constructed in the first post...

Sorry I could not post the table perfectly. It is ugly...


Thanks,

Maki Jav

[Maki Jav]

I have shortened the data. When you run example, you will see that the System.out.println() statements correctly indicates what data is being picked. I have added one more column "Date". User may decide to chose 3 or even more headers on the top of pivot table!

The end result I want is

List columnTopHeader or even if we take that out, List data be filled with such Vectors or HashMaps/Hashtables that reflect our data

eg
List data/ or columnTopHeader ---
         + --- Year (Vectors/ or other collection)
                    +--- Month (Vectors/ or other collection)
                    +--- Month (Vectors/ or other collection)
                    +--- Month (Vectors/ or other collection)
         + --- Year (Vectors/ or other collection)
                    +--- Month (Vectors/ or other collection)
                    +--- Month (Vectors/ or other collection)
                               +--- Date (Vectors/ or other collection)
                    +--- Month (Vectors/ or other collection)
                    +--- Month (Vectors/ or other collection)
                               +--- Date (Vectors/ or other collection)
                               +--- Date (Vectors/ or other collection)
                    +--- Month (Vectors/ or other collection)

or more vectors//collections within vectors/collections as per data requirement.

And in the end I would arrange them

as per user choice after merging similar values... eg for the various names we will have 2011 and also March
so that we will have one 2011 and March in the headers and various names are "ticked" against that

                                                     2011
                                                         March  April
name

BALANCE CONFIRMATION PROCESS        10
.....
.....
CENTRAL BANK ORDER PROCESS            105



The above example shows only a part of table.

import java.util.*;
class PivotTableModel{


	private String []columns ={"name","Year","Month","Date","pivotValue","Totals"};;
	private Class []columnClass ={String.class,Integer.class,Integer.class,Double.class,Double.class};;

	private Object [][]rows = new Object[][]{
		new Object[]{"CENTRAL BANK ORDER PROCESS",null,null,null,128.0},
		new Object[]{null,2010,null,null,null,null},
		new Object[]{null,null,12,null,2.0,null},
		new Object[]{null,null,null,27,2.0,null},
		new Object[]{null,null,null,28,2.0,null},
		new Object[]{null,2011,null,null,null,null},
		new Object[]{null,null,3,null,2.0,null},
		new Object[]{null,null,4,null,15.0,null},
		new Object[]{null,null,5,null,41.0,null},
		new Object[]{null,null,null,27,2.0,null},
		new Object[]{null,null,6,null,41.0,null},
		new Object[]{null,null,8,null,27.0,null},
		};

	public PivotTableModel(){}


	public int getColumnCount() {
		return (columns != null) ? columns.length : 0;
	}

	public String getColumnName(int columnIndex) {
		return (columns != null) ? columns[columnIndex] : null;

	}


	public int getRowCount() {
		return (rows != null) ? rows.length : 0;
	}

	public Object getValueAt(int rowIndex, int columnIndex) {
		return (rows != null) ? rows[rowIndex][columnIndex] : null;
	}


	public Class getColumnClass(int columnIndex) {
			return columnClass[columnIndex];
	}

 public static void main(String []args){

	 PivotTableModel ptm = new PivotTableModel();

	 System.out.println(ptm.getValueAt(0,0));
	 System.out.println(ptm.getColumnCount());
	 System.out.println(ptm.getRowCount());
	 System.out.println(ptm.getColumnName(3));
	 System.out.println(ptm.getColumnClass(3));


	 for(int row = 0; row< ptm.getRowCount();row++){
		 for(int col = 0; col< ptm.getColumnCount();col++){
			//System.out.print(ptm.getValueAt(row,col)+"\t");
		 }

		//System.out.println();
	 }

int rowHeaderLen =1;
int rowHeaderLenIndex =1-1;
int firstColumnHeaderIndex=1;
int columnHeaderLen = 3;

List data = new LinkedList();
List columnTopHeader;
int newOne=0;
int valueStoredAt=0;
Vector subElement = null;

	 for(int row = 0; row< ptm.getRowCount();row++){
	  int put=0;
		for(int col = 0; col< ptm.getColumnCount();col++){
			if(col>rowHeaderLenIndex&&col<rowHeaderLen+columnHeaderLen)
			{
				if(ptm.getValueAt(row,col)!=null){
					put = col;
				}
				if(put>rowHeaderLenIndex&&ptm.getValueAt(row,col)!=null){

					if(put==firstColumnHeaderIndex){
						System.out.println("Add new one at "+put+"  for "+ptm.getColumnName(col));
						columnTopHeader = new LinkedList();
						data.add(columnTopHeader);
						//subElement = new Vector();
						if(subElement != null)
						columnTopHeader.add(subElement);
					}else if(put>firstColumnHeaderIndex){

						if(col>valueStoredAt){

						 System.out.println("New vector pos at "+put+"  for "+ptm.getColumnName(col));
						 subElement = new Vector();
						 subElement.add(ptm.getValueAt(row,col));

						}else if(col==valueStoredAt){
						 System.out.println("Add New element pos at "+put+"  for "+ptm.getColumnName(col));
						 subElement.add(ptm.getValueAt(row,col));
						}

					}
						valueStoredAt = col;
						System.out.println("last value Added at "+valueStoredAt);


				}

				System.out.print(ptm.getValueAt(row,col)+"\t");
			}

		}
	   System.out.println();
	 }

 }

}