Good Day! I’m currently developing a Project Monitoring System and is tasked to create the Scheduling Module using DHTMLXGantt. In our system, we have multiple projects that have 1 schedule. Thus, we have to generate a gantt chart for every project. However, loading from the database cause all the data to be shown in the screen and not just for that specific project.
Here are my codes:
JSONGanttDataServlet:
[code]import java.sql.Connection;
import java.sql.DriverManager;
import com.dhtmlx.connector.*;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet(name = “JSONDataServlets”, urlPatterns = {"/data1"})
public class JsonGanttDataServlet extends ThreadSafeConnectorServlet{
@Override
protected void configure(HttpServletRequest req, HttpServletResponse res) {
Connection conn=null;
try {
Class.forName (“com.mysql.jdbc.Driver”).newInstance ();
conn = DriverManager.getConnection(“jdbc:mysql://127.0.0.1:3306/gantt”, “root”, “”);
} catch (Throwable e) {
e.printStackTrace();
}
JSONGanttConnector gantt = new JSONGanttConnector(conn, DBType.MySQL);
gantt.servlet(req, res);
gantt.render_links("gantt_links", "id", "source,target,type");
gantt.render_table("gantt_tasks", "id", "start_date,duration,text,progress,parent", "project_id");
}
}[/code]
newgantt.jsp
[code]
How to Start with dhtmlxGantt gantt.config.xml_date = "%Y-%m-%d %H:%i"; gantt.init("gantt_here"); gantt.load("data1"); var dp = new dataProcessor("data1");
dp.init(gantt);
</script>
[/code]
I also tried gantt.render_complex_sql and it works very well in showing the data. However, updates and new tasks are not automatically saved to the database:
gantt.render_complex_sql("SELECT*FROM gantt_tasks", "id", "start_date,duration,text,progress,parent","project_id");
What should I do to load the tasks from a SPECIFIC PROJECT and update/insert new tasks for that SPECIFIC PROJECT?.