我直接贴代码了,做一个备份
public async zbjhList(request: Hapi.Request, h: Hapi.ResponseToolkit) {
const { page, size } = request.payload;
const min = (page - 1) * size;
const max = page * size;
let sql = `SELECT * FROM (SELECT ROWNUM AS rowno, t.* FROM "bsjduser".jcsj_zbjh t WHERE ROWNUM <= ${max}) table_alias
WHERE table_alias.rowno >= ${min}`
const binds = {};
const options = {
outFormat: oracledb.OUT_FORMAT_OBJECT
};
let result = null;
result = await h.oracle.execute(sql, binds, options).catch(err => {
console.log(err)
});
const data = result.rows;
sql = `select count(*) as count from "bsjduser".jcsj_zbjh`;
result = await h.oracle.execute(sql, binds, options).catch(err => {
console.log(err)
});
result = await h.oracle.execute(sql, binds, options).catch(err => {
console.log(err)
});
const total = result.rows[0]['COUNT'];
return {
code: 1,
msg: '值班计划列表获取成功',
data: data
paginate: { size: parseInt(size), page: parseInt(page), pages: parseInt(total / size), total: total }
}
}