let mysql = require(
'mysql'
);
let express = require(
'express'
);
let app = express();
let https = require(
"https"
);
let fs = require(
"fs"
);
const httpsOption = {
key : fs.readFileSync(
"./https/3_jdong.xuexuebang.cn.key"
),
cert: fs.readFileSync(
"./https/2_jdong.xuexuebang.cn.crt"
)
}
let connection = mysql.createConnection({
host :
'127.0.0.1'
,
port :
'3306'
,
database :
'sz'
,
user :
'soubei'
,
password :
'soubei'
,
})
connection.connect();
app.all(
"*"
,
function
(req, res, next) {
res.header(
"Access-Control-Allow-Origin"
,
"*"
);
res.header(
"Access-Control-Allow-Headers"
,
"content-type"
)
next()
})
app.get(
'/userlist'
,
function
(req,res){
shop_name = req.query.shop_name;
connection.query(
'SELECT * from `order` where orderStatus="暂停" '
,
function
(error,results,fileds){
if
(error)
throw
error;
res.header(
"Access-Control-Allow-Origin"
,
"*"
);
res.header(
'Access-Control-Allow-Headers'
,
'Content-type'
);
res.header(
"Access-Control-Allow-Methods"
,
"PUT,POST,GET,DELETE,OPTIONS,PATCH"
);
res.header(
'Access-Control-Max-Age'
,1728000);
res.writeHead(200,{
"Content-Type"
:
"text/json;chartset=utf-8"
})
data = []
connection.query(
'SELECT skuId from `cmf_order_sku` where shop_name="'
+shop_name+
'" group by skuId'
,
function
(error,result,fileds){
if
(result !=
''
){
res.end(JSON.stringify(result))
}
if
(error ==
null
){
res.end(JSON.stringify(
'请求失败'
))
}
})
})
})
https.createServer(httpsOption, app).listen(8080,
function
(){
console.log(
"应用实例,运行在http://%s:%s"
)
});