server.js

var http = require('http');
var path = require('path');
var express = require('express');
var fs = require('fs');
var weather = require('./weather');
var bodyParser = require('body-parser');
var busntrail = require('./busntrail');
var music=require('./music');
var news=require('./news');
var ejs=require('ejs');
var mysql=require('mysql');

var client =mysql.createConnection({
	user:'root',
	password: '123',
	database: 'schedule'
});
var router = express();
var content = fs.readFileSync('./views/tempSet.ejs', 'utf-8');
var compiled = ejs.compile(content);

var server = http.createServer(router);
router.use(express.static(path.resolve(__dirname, 'client')));
router.use(bodyParser.json());
router.use(bodyParser.urlencoded({ extended: true }));
router.set('views', path.join(__dirname, 'views'));
router.set('view engine', 'ejs');





server.listen(process.env.PORT || 3000, process.env.IP || "0.0.0.0", function(){
  var addr = server.address();
  console.log("sever started .. port"+ ": " + addr.port);
});
  
  router.get('/voicecall', function(req, res){
   
        res.render('rtccall');  //location setting temp page
    });
    
    
  router.get('/', function(req, res){
   
        res.render('tempSet');  //location setting temp page
    });
    
  router.post('/searchStationNum', function(req, res){
        var stationName = req.body.stationName;
        busntrail.searchBus(res,stationName);  //location setting temp page
    });  
    
  router.get('/myPosition', function(req, res){
        var xPos ,yPos;
        var userDongName =req.param("userDongName");
        var data = fs.readFileSync('positionFile', 'utf8') .split('\n');

        for(var i in data){
           if (data[i].indexOf(userDongName) > -1) {
             xPos = data[i].toString().substring(23,30).replace(/\s/gi,'');//24th xpos   27 ypos..
             yPos = data[i].toString().substr(30).replace(/\s/gi,'');
             weather.realTimeWeather(xPos,yPos,res);
            }
        }
    });
 router.post('/music', function(req, res){
        var musicName = req.body.musicname;
	    music.searchMusic(res,musicName);
    });  
 router.post('/news', function(req, res){
	       news.news_result(res);
    });  
 router.get('/plan',function(req,res){
	 fs.readFile('./views/list.html','utf8',function(error,data){
		 client.query('SELECT * FROM plan',function(error, results){
			 res.send(ejs.render(data, {
				 data: results
			 }));
		 });
	 });
 });
 router.get('/plan/delete/:date',function(req,res){ 
	 client.query('DELETE FROM plan WHERE date=?', [req.params.date], function () {
     res.redirect('/plan');
 	 });
 });
 router.get('/plan/insert',function(req,res){ 
   	fs.readFile('./views/insert_list.html', 'utf8', function (error, data) {
    res.send(data);
 	 });
 });
 router.post('/plan/insert',function(req,res){
	var body = req.body;
  		client.query('INSERT INTO plan (date, schedule) VALUES (?, ?)', [
     	body.date, body.schedule], function () {
        res.redirect('/plan');
 	 });
 });
 router.get('/plan/edit/:date',function(req,res){
	fs.readFile('./views/edit_list.html', 'utf8', function (error, data) {
    
    client.query('SELECT * FROM plan WHERE date = ?', [
        req.params.date
    ], function (error, result) {
      
      res.send(ejs.render(data, {
        data: result[0]
      }));
    });
  });
 });
 router.post('/plan/edit/:date',function(req,res){
	var body = req.body; 
  	client.query('UPDATE plan SET schedule=? WHERE date=?', [body.schedule, req.params.date], function () {
  	res.redirect('/plan');
  });
 });