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(