import datetime from flask import request, abort, jsonify from sqlalchemy import and_, desc from api.config.myConfig import NET_PREFIX, PAGE_SIZE from api.libs.QRCode import get_QRCode from api.libs.redprint import Redprint from api.models.SignInOrder import SignInOrder from api.models.SignInPeople import SignInPeople from api.models.User import User from api.models.base import db signIn = Redprint('signIn') # 创建 查看 和 签到 @signIn.route('/finlist', methods=['GET']) def fin_signIn_list(): #获取已完成签到 req_arg = request.args userId = int(req_arg['userId']) next_Page = int(req_arg['nextPage']) mypub_fin_orders = db.session.query(SignInOrder).filter( and_(SignInOrder.signInStatus == 0, SignInOrder.pubPersonId == userId)).order_by( desc("id")).limit(PAGE_SIZE).offset( (next_Page - 1) * PAGE_SIZE) myjoin_as_signInPeople = db.session.query(SignInPeople).join(