$(document).ready(function() {
    var options = {
            chart: {
                    renderTo: containerSpline,
                    type: 'spline'
                },
            title: {
                text: '信息录入统计曲线图'
            },
            credits: {
                enabled: false
            },
            xAxis: {
                title: {
                    text: '时间'
                },
                categories: []
            },
            yAxis: {
                title: {
                    text: '数量'
                }
            },
            series: []
    };

    $.get("/localhost:5050", (data)=>{
        // feed the data into the chart
        var series = {
            name:'',
            data: []
            };
        var xAxis = {
                categories: []
            };
        data.recordset.forEach((item)=>{
            series.data.push(item.Count);
            series.name = item.Dates;
            options.xAxis.categories.push(item.Times);
        })
        options.series.push(series);
        var chart = new Highcharts.Chart(options);
    })
})

var express=require('express');
var http = require('http');
var sql=require('mssql');
var fs = require('fs');
var hbs = require('hbs');
var cors = require('cors');
var app=express();
var data;
//config for your database
var config={
        user:'***',
        password:'****',
        server:'***',
        database:'****'
    };
    //connect to your database
sql.connect(config,function (err) {
  if(err) console.log(err);
    //create Request object
  var request=new sql.Request();
  var fDate, lDate;
  fDate = '2017-08-03';
  lDate = '2017-08-04';
  request.input('firstdate', sql.NVarChar, fDate);
  request.input('lastdate', sql.NVarChar, lDate);
  request.query(" EXEC dbo.KSD_Front_YbidCountByMinutes @firstdate , @lastdate ", (err,recordset) => {
                      if(err) console.log(err);
                    //send records as a response
                      data = JSON.stringify(recordset);
                    });
  });
// send the data to the script.js
app.use(cors());
app.get('/',function(req,res){
    res.writeHead(200, {'Content-Type':'text/json;charset=utf-8'});
    res.end(data);
});

app.listen(5050,function(){
  console.log('Server is running!');
});