def refresh_list(self, type, offset_apid, u_id):
retdata = []
try:
#attention:< ，因为返回新的
appointments = self.db.query(Appointment). \
filter(Appointment.APtype == type, Appointment.APclosed == 0, Appointment.APvalid == 1,
Appointment.APstatus == 0,
Appointment.APid < offset_apid).from_self().order_by(desc(Appointment.APcreateT)). \
limit(6).all()
if appointments:
APmodelHandler.ap_Model_simply(appointments, retdata, u_id)
self.retjson['code'] = '10253' # 刷新成功，返回6个
self.retjson['contents'] = retdata
else:
print appointments.first().APtype
except Exception, e: # 剩余约拍不足6个，返回剩余全部约拍
print e
try:
appointments = self.db.query(Appointment). \
filter(Appointment.APtype == type, Appointment.APclosed == 0, Appointment.APvalid == 1,
Appointment.APstatus == 0,
Appointment.APid < offset_apid).order_by(desc(Appointment.APcreateT)). \
all()
if appointments:
APmodelHandler.ap_Model_simply(appointments, retdata, u_id)
self.retjson['code'] = '10263' # 剩余约拍不足6个，返回剩余全部约拍
self.retjson['contents'] = retdata
else:
self.retjson['code'] = '10262'
self.retjson['contents'] = r"没有更多约拍"
except Exception, e:
self.retjson['code'] = '10262'
self.retjson['contents'] = r"没有更多约拍"
def post(self):
u_auth_key = self.get_argument('authkey')
request_type = self.get_argument('type')
u_id = self.get_argument('uid')
ap_group = self.get_argument('group')
groupid = int(ap_group)
ufuncs = Userinfo.Ufuncs.Ufuncs()
if ufuncs.judge_user_valid(u_id, u_auth_key):
if request_type == '10231': # 请求所有设定地点的摄影师发布的约拍中未关闭的6
retdata = []
try:
if int(ap_group) == 0:
appointments = self.db.query(Appointment). \
filter(Appointment.APtype == 1, Appointment.APclosed == 0, Appointment.APvalid == 1,
Appointment.APstatus == 0).\
order_by(desc(Appointment.APid)).limit(6).all()
APmodelHandler.ap_Model_simply(appointments, retdata,
u_id)
self.retjson['code'] = '10251'
self.retjson['contents'] = retdata
else:
appointments = self.db.query(Appointment). \
filter(Appointment.APtype == 1, Appointment.APclosed == 0, Appointment.APvalid == 1,
Appointment.APstatus == 0, or_(Appointment.APgroup.like("{}%".format(groupid)),Appointment.APgroup.like("%{}".format(groupid)))). \
order_by(desc(Appointment.APid)).limit(6).all()
APmodelHandler.ap_Model_simply(appointments, retdata,
u_id)
self.retjson['code'] = '10251'
self.retjson['contents'] = retdata
except Exception, e: # 没有找到约拍
print e
self.no_result_found(e)
elif request_type == '10235': # 请求所有设定地点的模特发布的约拍中未关闭的
retdata = []
try:
if int(ap_group) == 0:
appointments = self.db.query(Appointment). \
filter(Appointment.APtype == 0, Appointment.APclosed == 0, Appointment.APvalid == 1,
Appointment.APstatus == 0, ).\
order_by(desc(Appointment.APid)).limit(6).all()
APmodelHandler.ap_Model_simply(appointments, retdata,
u_id)
self.retjson['code'] = '10252'
self.retjson['contents'] = retdata
else:
appointments = self.db.query(Appointment). \
filter(Appointment.APtype == 0, Appointment.APclosed == 0, Appointment.APvalid == 1,
Appointment.APstatus == 0, or_(Appointment.APgroup.like("{}%".format(groupid)),Appointment.APgroup.like("%{}".format(groupid)))). \
order_by(desc(Appointment.APid)).limit(6).all()
APmodelHandler.ap_Model_simply(appointments, retdata,
u_id)
self.retjson['code'] = '10252'
self.retjson['contents'] = retdata
except Exception, e:
self.no_result_found(e)
def ap_ask_user(self, uid, retdata): # 查询指定用户的所有约拍
'''
:param user: 传入一个User对象
:return: 无返回，直接修改retjson
'''
#todo:需判断该用户是否存在
try:
appointments1 = self.db.query(Appointment).filter(
Appointment.APsponsorid == uid,
Appointment.APvalid == 1).all() # 用户自己发起的
appointentrys = self.db.query(AppointEntry).filter(
AppointEntry.AEregisterID == uid,
AppointEntry.AEvalid == 1).all() # 用户报名的
APmodelHandler.ap_Model_simply(appointments1, retdata, uid)
APmodelHandler.ap_Model_simply(
self.get_ap_Model_from_aeids(appointentrys), retdata, uid)
self.retjson['code'] = '10256'
self.retjson['contents'] = retdata
except Exception, e:
print e
self.no_result_found(e)
else:
self.retjson['code'] = '10262'
self.retjson['contents'] = r"没有更多约拍"
except Exception, e:
self.retjson['code'] = '10262'
self.retjson['contents'] = r"没有更多约拍"
else:
try:
# attention:因为返回新的
appointments = self.db.query(Appointment). \
filter(Appointment.APtype == type, Appointment.APclosed == 0, Appointment.APvalid == 1,
Appointment.APstatus == 0,
Appointment.APid < offset_apid).from_self().order_by(desc(Appointment.APcreateT)). \
limit(6).all()
if appointments:
APmodelHandler.ap_Model_simply(appointments, retdata, u_id)
self.retjson['code'] = '10253' # 刷新成功，返回6个
self.retjson['contents'] = retdata
else:
print appointments.first().APtype
except Exception, e: # 剩余约拍不足6个，返回剩余全部约拍
print e
try:
appointments = self.db.query(Appointment). \
filter(Appointment.APtype == type, Appointment.APclosed == 0, Appointment.APvalid == 1,
Appointment.APstatus == 0,
Appointment.APid < offset_apid).order_by(desc(Appointment.APcreateT)). \
all()
if appointments:
APmodelHandler.ap_Model_simply(appointments, retdata,
u_id)