var express = require("express");
var request = require("request");
var mysql = require('mysql');

var connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: 'root',
    database: 'zhouheiya',
    port: 3307
});
connection.connect();

var app = new express();

app.get("/query", function (req, res) {
    res.header("Access-Control-Allow-Origin", "*");
    res.header("Access-Control-Allow-Methods", "PUT,POST,GET,DELETE,OPTIONS");

    var name = req.query.name;
    if (name == "" || name == null || name == undefined) {
        connection.query({
            sql: 'SELECT * FROM zhouheiyastoreinfo WHERE orgcode like \'0-7%\'',
            timeout: 40000
        }, function (err, result, fields) {
            if (err) {
                console.log('[SELECT ERROR] - ', err.message);
                return;
            }
            console.log('---SELECT---');

            var arr = [];
            for(var i=0;i<result.length;i++){
                var x=result[i].x;
                var y=result[i].y;
                var arrs = [x,y,0.1];
                arr.push(arrs);
            }
            res.send(arr);


        });
    } else {
        connection.query({
            sql: 'SELECT * FROM heiya WHERE `name` LIKE ?',
            timeout: 40000,
            values: '%' + [name] + '%'
        }, function (err, result, fields) {
            if (err) {
                console.log('[SELECT ERROR] - ', err.message);
                return;
            }
            console.log('---SELECT---');
            res.send(result);
        });
    }
})

app.listen(3000);