Im am new to node.js and get the mentioned error in server.js file.
I am trying to introduce a gantt diagramm with dhtmlx library.
I am using Node v16.13.1 and IntelliJ 2021.3
Below are my code snippets.
Index.xhtml:
<!DOCTYPE html>
<head>
<meta http-equiv="Content-type" content="text/html; charset=utf-8">
<title>QuickInfo extension</title>
<script src="https://cdn.dhtmlx.com/gantt/edge/dhtmlxgantt.js"></script>
<link href="https://cdn.dhtmlx.com/gantt/edge/dhtmlxgantt.css" rel="stylesheet">
<style type="text/css">
html, body{
height:100%;
padding:0px;
margin:0px;
overflow: hidden;
}
</style>
</head>
<body>
<div id="gantt_here" style='width:100%; height:100%;'></div>
<script>
gantt.config.date_format = "%Y-%m-%d %H:%i:%s";
gantt.init("gantt_here");
</script>
</body>Server.js:
var express = require('express');
var bodyParser = require('body-parser');
var path = require('path');
var port = 1337;
var app = express();
app.use(express.static(path.join(__dirname, "public")));
app.use(bodyParser.urlencoded({ extended: true }));
app.listen(port, function(){
console.log("Server is running on port "+port+"...");
});
var Promise = require('bluebird');
require("date-format-lite");
var mysql = require('promise-mysql');
var db = mysql.createPool({
host: 'localhost',
user: 'root',
password: '',
database: 'gantttutorial'
});
app.get("/data", function (req, res) {
Promise.all([
db.query("SELECT * FROM gantt_tasks"),
db.query("SELECT * FROM gantt_links")
]).then(function(results){
var tasks = results[0],
links = results[1];
for (var i = 0; i < tasks.length; i++) {
tasks[i].start_date = tasks[i].start_date.format("YYYY-MM-DD hh:mm:ss");
tasks[i].open = true;
}
res.send({
data: tasks,
collections: { links: links }
});
}).catch(function(error) {
sendResponse(res, "error", null, error);
});
});
Has anyone an idea what I am doing wrong?
