router.get('/search', async ctx => {
let { roleName = '' ,roleKey='',status='',startTime='',endTime=''} = ctx.query
if (startTime){
let sql = `select * from rolelist where roleName like '%${roleName}%' and roleKey like '%${roleKey}%' and`
sql += ` status like '%${status}%' and`
sql += ` createTime between '${startTime}' and '${endTime}'`
const res = await doSQL(sql)
ctx.body = { code: 2000, message: '数据获取成功', data: res,total:res.length }
}else{
let sql = `select * from rolelist where roleName like '%${roleName}%' and roleKey like '%${roleKey}%' and`
sql += ` status like '%${status}%'`
const res = await doSQL(sql)
ctx.body = { code: 2000, message: '数据获取成功', data: res, total: res.length }
}
})
注意sql+= 之后的空格