Creating Cewolf Combined Charts

[Steve Dyke]

Can someone help me with a cewolf chart that shows a bar and a line combined chart. I have installed the cewolf files to produce a single line chart so far.

[Ulf Dittmer]

The cewolf example web app shows a couple of combined charts under "Complex Charts". You can study its JSP files to help get you going. If that doesn't help, post what you have so far, and let us know where you have problems progressing.

[Steve Dyke]

This is the class I am calling from my JSP. It is the DatasetProducer part I do not know how to deal with.

 
package com.ResourceManagement.connections;
 
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.Format;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
 
import com.ibm.as400.access.AS400JDBCDataSource;
//import java.io.Serializable;
//import java.util.Date;
//import java.util.Map;
 
//import org.apache.commons.logging.Log;
//import org.apache.commons.logging.LogFactory;
//import org.jfree.data.category.CategoryDataset;
//import org.jfree.data.category.DefaultCategoryDataset;
//import org.jfree.data.*;
 
//import de.laures.cewolf.DatasetProduceException;
//import de.laures.cewolf.DatasetProducer;
//import de.laures.cewolf.links.CategoryItemLinkGenerator;
//import de.laures.cewolf.tooltips.CategoryToolTipGenerator;
 
public class IDWLconnection {
public String errorString;
public String userID;
public String userName;
public ResultSet rsd;

public IDWLconnection(String chartDayValue, String whatUserId) {

AS400JDBCDataSource datasource = new AS400JDBCDataSource("myData");
datasource.setTranslateBinary(true);
datasource.setUser("myID");
datasource.setPassword("myPassword");
try
{

Connection connection = datasource.getConnection();

Statement stmta = connection.createStatement();
Statement stmt = connection.createStatement();

String sql = "select fname, lname from webprddt6.appusrprf1 Where usrid1 = '" + whatUserId + "'";
ResultSet rsa = stmt.executeQuery(sql);
rsa.next();

userName = rsa.getString("fname").trim() + " " + rsa.getString("lname").trim();

rsa.close();

Format formatter2;
formatter2 = new SimpleDateFormat("MM/dd/yy");
Date d = new Date();
String dateString1 = formatter2.format(d);
Calendar cal = Calendar.getInstance();
cal.setTime(d);
cal.add(Calendar.DATE, Integer.parseInt(chartDayValue));
Date newDate = cal.getTime();
String dateString3 = formatter2.format(newDate);

String sqld = "Select assigned, ahours, ftdatem, taskdur From webprddt6.resmngt3b" +
" Join webprddt6.resmngt3 On webprddt6.resmngt3b.taskindex = webprddt6.resmngt3.recseq" +
" Where assigned = '" + whatUserId + "' And ftdatem >= '" + dateString1 + "' And ftdatem <= '" + dateString3 + "'";

rsd = stmta.executeQuery(sqld);


int hrs = 0;
int chartDays = Integer.parseInt(chartDayValue);
Calendar cal2 = Calendar.getInstance();

String[][] myDataArray = new String[30][3];

while(rsd.next()){
int i = 0;
hrs = Integer.parseInt(rsd.getString("ahours"))/Integer.parseInt(rsd.getString("taskdur"));

try{
Date d2 = new SimpleDateFormat("MM/dd/yy").parse(rsd.getString("ftdatem"));


cal2.setTime(d2);

for(i=0;i<Integer.parseInt(rsd.getString("taskdur"));i++){

cal2.add(Calendar.DATE, -1);
Date newDate2 = cal2.getTime();

String dateString3b = formatter2.format(newDate2);

myDataArray[i][0] = dateString3b; //xAxis Categories
myDataArray[i][1] = String.valueOf(hrs); //Dataseries 1 Scheduled Hours
myDataArray[i][2] = String.valueOf(8 *.8); //Dataseries 2 Capacity Hours

cal2.setTime(newDate2);

}


}
catch(ParseException pe){
System.out.println(pe);
}

}
rsd.close();

stmt.close();
stmta.close();

connection.close();

//This is what I do not know what to do with

DatasetProducer data1 = new DatasetProducer(){
    public Object produceDataset(Map params) throws DatasetProduceException {
    return "Scheduled Hours";
    }
    public boolean hasExpired(Map params, Date since) {
    return false;
    }
    public String getProducerId(){
    return "";
    }
    };
    
    DatasetProducer data2 = new DatasetProducer(){
    public Object produceDataset(Map params) throws DatasetProduceException {
    return "Capacity Hours";
    }
    public boolean hasExpired(Map params, Date since) {
    return false;
    }
    public String getProducerId(){
    return "";
    }
    
    };
    
}
catch (SQLException sqle)
{
System.out.println(sqle);
errorString = "Error";

}
    
    

   
}
}
 
    

[Ulf Dittmer]

The web app I pointed to above has a number of examples of how to create DatasetProducers. The mechanics vary a bit depending on what kind of chart you want to create, but it shouldn't be too hard to adapt one of the examples.