问题现象:总条数正确,但前端只显示部分数据。
前端问题代码:
解决办法
后端:
@app.route(‘/api/paper’)
def paper_data():
page = request.args.get(‘page’, type=int, default=1)
per_page = request.args.get(‘per_page’, type=int, default=10)
paginate = paper.query.paginate(page=page, per_page=per_page, error_out=False)
items: [paper] = paginate.items
return {
‘code’: 0,
‘msg’: ‘信息查询成功’,
‘count’: paginate.total,
‘data’: [
{
‘id’:item.id,
‘paper_type’:item.paper_type,
‘paper_name’:item.paper_name,
‘publish_year’ :item.publish_year,
‘author’:item.author,
‘field’ :item.field,
‘journal_name’:item.journal_name,
‘create_user’ :item.create_user,
‘create_date’:item.create_date.strftime(‘%Y-%m-%d %H:%M:%S’),
‘update_user’ :item.update_user,
‘update_date’:item.update_date.strftime(‘%Y-%m-%d %H:%M:%S’),
} for item in items
]
}
前端:
layui.use([‘form’, ‘table’], function () {
var $ = layui.jquery,
form = layui.form,
table = layui.table;
table.render({
elem: '#paper',
id:"paper",
toolbar: '#toolbarDemo',
url: "/api/paper",
defaultToolbar: ['filter', 'exports', 'print', {
title: '提示',
layEvent: 'LAYTABLE_TIPS',
icon: 'layui-icon-tips'
}],
cols: [[
{type: "checkbox", width: 50},
{field: 'id', title: 'ID', width: 60, sort: true},
{field: 'paper_type', title: '论文类别', width: 150},
{field: 'paper_name', title: '论文名称', width: 150},
{field: 'publish_year', title: '发表年份', width: 150,sort: true},
{field: 'author', title: '作者', width:150},
{field: 'field', title: '领域', minWidth: 150},
{field: 'journal_name', title: '期刊名称', width: 150},
{field: 'create_user', title: '创建人', width: 150},
{field: 'create_date', title: '创建时间', width: 150},
{field: 'update_user', title: '更新人', width: 150},
{field: 'update_date', title: '更新时间', width: 150},
{title: '操作', minWidth: 150, toolbar: '#currentTableBar', align: "center"}
]],
page: true
});