router.get("/getlist", (req, res) => {
var tid = req.query.tid;
if (!tid) {
tid = 1;
}
var $pageNum = req.query.pageNum;
if (!$pageNum) {
$pageNum = 1;
} else {
$pageNum = $pageNum - 0;
}
//总条数
var sql1 = 'SELECT tid FROM news where tid=?';
function abc(a, b) {
return new Promise(function (resolve, reject) {
pool.query(a, b, (err, result) => {
if (err) throw err;
resolve(result);
});
});
}
function totalNum(a, b) {
return new Promise(function (resolve, reject) {
pool.query(a, b, (err, result) => {
if (err) throw err;
resolve(result.length);
});
});
}
function totalPageNum(a, b) {
return new Promise(function (resolve, reject) {
pool.query(a, b, (err, result) => {
if (err) throw err;
resolve(Math.ceil(result.length / 3));
});
});
}
//开始 = (当前的页码-1)*每页大小
var offset = parseInt(($pageNum - 1) * 3);
//每页大小
var sql2 = 'SELECT nid,tid,title,author,updateTime,click,content,md FROM news LIMIT ?,?';
//标签
var sql3 = `select nid,tid,tag from tag where nid=2`;
var sql4 = `select nid,tid,tag from tag where nid=11`;
var sql5 = `select nid,tid,tag from tag where nid=16`;
Promise.all([totalPageNum(sql1, [tid]), totalNum(sql1, [tid]), abc(sql2, [offset, 3]), abc(sql3, [offset, 3]), abc(sql4, [offset, 3]), abc(sql5, [offset, 3])])
.then(data => {
let asd = {
pageNum: $pageNum,
pageTotal: data[0],
count: data[1],
pageSize: 3,
product: data[2],
tags:{0:data[3],1:data[4],2:data[5]}
}
res.send(asd);
}).catch(err => {
console.log(err);
})
})