return sql.toString();
}
public GanttChartModel makeGanttChart() throws Exception {
String queryStr = makeGanttChartWebQuery();
GanttChartDAO task = (GanttChartDAO)GenericDAO.createDAOImpl(DefaultConnectionFactory.create(), queryStr.toString(), GanttChartDAO.class);
task.set("pd", pd);
String[] endpoints = endpoint.split(";");
for (int i=0; i<endpoints.length; i++) {
task.set("endpoint"+i, endpoints[i]);
}
String[] pds = pd.split(";");
for (int i=0; i<pds.length; i++) {
task.set("pd"+i, pds[i]);
}
//task.set("endpoint", endpoint);
task.set("globalcom", globalCom);
task.select();
GanttChartModel ganttChartModel=new GanttChartModel();
ganttChartModel.setEndpoint(getEndpoint());
ganttChartModel.setFirstDate(getFirstDate());
ganttChartModel.setFirstDayOfMonth(getFirstDayOfMonth());