def get_e_appointment_evaluate(self, u_id): # 获取我参加的的已评价了的约拍 ret_e_appointment = [] ap_e_info = [] ap_e_entrys = self.db.query(AppointEntry).filter( AppointEntry.AEregisterID == u_id, AppointEntry.AEvalid == True, AppointEntry.AEchoosed == True).all() for ap_e_entry in ap_e_entrys: try: item = self.db.query(AppointmentInfo).filter( AppointmentInfo.AIappoid == ap_e_entry.AEapid).one() if item.AIpid == int(u_id): if AppointmentInfo.AIpcomment: ap_e_info = self.db.query(Appointment).filter( Appointment.APid == ap_e_entry.AEapid, ).all() ret_e_appointment.append( APmodelHandler.ap_Model_simply_one( ap_e_info[0], u_id)) if item.AImid == int(u_id): if AppointmentInfo.AImcomment: ap_e_info = self.db.query(Appointment).filter( Appointment.APid == ap_e_entry.AEapid, ).all() ret_e_appointment.append( APmodelHandler.ap_Model_simply_one( ap_e_info[0], u_id)) except Exception, e: print e
def get_e_appointment(self, u_id, number): ret_e_appointment = [] ap_e_info = [] if number == 0: ap_e_entrys = self.db.query(AppointEntry).filter( AppointEntry.AEregisterID == u_id, AppointEntry.AEvalid == True).all() else: ap_e_entrys = self.db.query(AppointEntry).filter( AppointEntry.AEregisterID == u_id, AppointEntry.AEvalid == True, AppointEntry.AEchoosed == True).all() if number == 2: for ap_e_entry in ap_e_entrys: ap_id = ap_e_entry.AEapid try: ap_e_info = self.db.query(Appointment).filter( Appointment.APid == ap_id, Appointment.APstatus >= number, Appointment.APstatus <= number + 1).all() except Exception, e: print e if ap_e_info: ret_e_appointment.append( APmodelHandler.ap_Model_simply_one(ap_e_info[0], u_id))
def get_login_model(self, user): retdata = [] user_model = Usermodel.get_user_detail_from_user(user) # 用户模型 photo_list = [] # 摄影师发布的约拍 model_list = [] try: photo_list_all = self.db.query(Appointment).filter(Appointment.APtype == 1, Appointment.APvalid == 1). \ order_by(desc(Appointment.APcreateT)).limit(6).all() model_list_all = self.db.query(Appointment).filter(Appointment.APtype == 0, Appointment.APvalid == 1). \ order_by(desc(Appointment.APcreateT)).limit(6).all() from Appointment.APmodel import APmodelHandler ap_model_handler = APmodelHandler() # 创建对象 ap_model_handler.ap_Model_simply(photo_list_all, photo_list, user.Uid) ap_model_handler.ap_Model_simply(model_list_all, model_list, user.Uid) data = dict( userModel=user_model, daohanglan=self.bannerinit(), photoList=photo_list, modelList=model_list, ) # todo 待生成真的导航栏 retdata.append(data) self.retjson['code'] = '10111' self.retjson['contents'] = retdata except Exception, e: print e self.retjson['contents'] = r"摄影师约拍列表导入失败!"
def get_my_appointment(self, u_id, number): ap_my_entrys = [] ret_my_appointment = [] if number == 2: try: ap_my_entrys = self.db.query(Appointment).filter( Appointment.APsponsorid == u_id, Appointment.APstatus >= number, Appointment.APstatus <= number + 1).all() except Exception, e: print e ret_my_appointment = APmodelHandler.ap_Model_simply( ap_my_entrys, ret_my_appointment, u_id)
class ApCompanionHandler(BaseHandler): retjson = {'code': '', 'contents': ''} def post(self): type = self.get_argument('type') if type == '10900': # 发布约拍伴侣 ApcTitle = self.get_argument('title') ApOrc = self.get_argument('orgnazation') ApcContent = self.get_argument('content') ApcUrl = self.get_argument('companionUrl') Apcimg = self.get_arguments('companionImgs[]') new_ApCompanion = WApCompanions( WAPCname=ApcTitle, WAPCServeintro=ApcContent, # 服务内容介绍 WAPCOrganintro=ApOrc, WAPCvalid=1, WAPCContact=ApcUrl, ) self.db.merge(new_ApCompanion) self.db.commit() try: OneCompanion = self.db.query(WApCompanions).filter( WApCompanions.WAPCname == ApcTitle, WApCompanions.WAPCServeintro == ApcContent, WApCompanions.WAPCContact == ApcUrl, WApCompanions.WAPCvalid == 1).one() image = ImageHandler() image.insert_companion_image(Apcimg, OneCompanion.WAPCid) self.db.commit() self.retjson['code'] = '10900' self.retjson['contents'] = '约拍伴侣创建成功' except Exception, e: print e self.retjson['code'] = '10901' self.retjson['contents'] = '创建失败' elif type == '10904': # 返回约拍伴侣 retdata = [] Companion_all = self.db.query(WApCompanions).filter( WApCompanions.WAPCvalid == 1).all() modelhandler = APmodelHandler() for item in Companion_all: modelhandler.ApCompanion(item, retdata) self.retjson['code'] = '10904' self.retjson['contents'] = retdata
except Exception,e: self.not_in_fav_list() except Exception,e: self.not_in_fav_list() if type == '10541': # 查看所有收藏的约拍 retdata = [] try: favorites = self.db.query(Favorite).filter(Favorite.Fuid == user_id, Favorite.Fvalid == 1,Favorite.Ftype == 1).all() # 返回收藏列表 ap_favorates = [] for each_favorite in favorites: ap_favorite_id = each_favorite.Ftypeid # 即约拍Id ap_favorite = self.db.query(Appointment).filter(Appointment.APid == ap_favorite_id).one() ap_favorates.append(ap_favorite) APmodelHandler.ap_Model_simply(ap_favorates, retdata, user_id) self.retjson['code'] = '10550' self.retjson['contents'] = retdata except Exception, e: print e self.retjson['code'] = '10526' self.retjson['contents'] = r'用户未收藏任何约拍' if type == '10502':#收藏活动 typeid = self.get_argument('typeid')#活动id try: exist = self.db.query(Activity).filter(Activity.ACid == typeid).one() #活动是否存在 if exist: # 该约拍存在 if exist.ACvalid == 1: # 该活动还有效 try: # 判断用户曾经是否对活动拍进行过收藏动作, once_favorite = self.db.query(Favorite).filter(Favorite.Fuid == user_id,
def post(self): askcode = self.get_argument('askCode') # 请求码 m_phone = self.get_argument('phone') if askcode == '10106': # 手动登录 m_password = self.get_argument('password') if not m_phone or not m_password: self.retjson['code'] = 400 self.retjson['contents'] = 10105 # '用户名密码不能为空' # todo:登录返回json的retdata多一层[],客户端多0.5秒处理时间 # 防止重复注册 else: try: user = self.db.query(User).filter( User.Utel == m_phone).one() if user: # 用户存在 password = user.Upassword if m_password == password: # 密码正确 print u'密码正确' self.retjson['code'] = 200 if user.Ubirthday: Ubirthday = user.Ubirthday.strftime( '%Y-%m-%d %H:%M:%S'), else: Ubirthday = '' retdata = [] u_auth_key = user.Uauthkey user_model = dict( id=user.Uid, phone=user.Utel, nickName=user.Ualais, realName=user.Uname, sign=user.Usign, sex=user.Usex, score=user.Uscore, location=user.Ulocation, birthday=Ubirthday, registTime=user.UregistT.strftime( '%Y-%m-%d %H:%M:%S'), mailBox=user.Umailbox, headImage= r"http://img5.imgtn.bdimg.com/it/u=1268523085,477716560&fm=21&gp=0.jpg", auth_key=u_auth_key) photo_list = [] # 摄影师发布的约拍 model_list = [] daohangl_list = [] daohangl_list.append( Model_daohanglan( 'http://img3.imgtn.bdimg.com/it/u=4271053251,2424464488&fm=21&gp=0.jpg', 'www.baidu.com')) daohangl_list.append( Model_daohanglan( 'http://image8.360doc.com/DownloadImg/2010/04/0412/2762690_45.jpg', 'http://image.baidu.com/search/detail?ct=503316480&z=0&ipn=d&word=%E7%BE%8E%E5%9B%BE&step_word=&hs=0&pn=24&spn=0&di=14293150190&pi=0&rn=1&tn=baiduimagedetail&is=&istype=0&ie=utf-8&oe=utf-8&in=&cl=2&lm=-1&st=undefined&cs=2860350365%2C3214019191&os=289517539%2C4157278886&simid=0%2C0&adpicid=0&ln=1992&fr=&fmq=1472885603080_R&fm=&ic=undefined&s=undefined&se=&sme=&tab=0&width=&height=&face=undefined&ist=&jit=&cg=&bdtype=0&oriquery=&objurl=http%3A%2F%2Fimage8.360doc.com%2FDownloadImg%2F2010%2F04%2F0412%2F2762690_45.jpg&fromurl=ippr_z2C%24qAzdH3FAzdH3Fooo_z%26e3Bnma15v_z%26e3Bv54AzdH3Fv5gpjgpAzdH3F8aAzdH3FabdaAzdH3F88AzdH3F8nad0dl_9098dc0d_z%26e3Bfip4s&gsm=0&rpstart=0&rpnum=0' )) try: print 'shaixuanqian' photo_list_all = self.db.query(Appointment).filter(Appointment.APtype == 1, Appointment.APvalid == 1). \ order_by(desc(Appointment.APcreateT)).limit(6).all() model_list_all = self.db.query(Appointment).filter(Appointment.APtype == 0, Appointment.APvalid == 1). \ order_by(desc(Appointment.APcreateT)).limit(6).all() from Appointment.APmodel import APmodelHandler ap_model_handler = APmodelHandler() # 创建对象 print 'chuangjianchengg' ap_model_handler.ap_Model_simply( photo_list_all, photo_list, user.Uid) ap_model_handler.ap_Model_simply( model_list_all, model_list, user.Uid) print 'shaixuanchengg' data = dict( userModel=user_model, daohanglan=daohangl_list, photoList=photo_list, modelList=model_list, ) # todo 待生成真的导航栏 retdata.append(data) self.retjson['code'] = '10101' self.retjson['contents'] = retdata except Exception, e: print e self.retjson['contents'] = r"摄影师约拍列表导入失败!" else: self.retjson['contents'] = u'密码错误' self.retjson['code'] = '10104' # 密码错误 else: # 用户不存在 self.retjson['contents'] = u'该用户不存在或服务器错误' self.retjson['code'] = '10103'
def post(self): # todo 还未增加图片地址,活动按时间排序 retjson = {'code': '', 'contents': ''} retdata_ap = [] ret_json_contents = {} retdata_ac = [] ac = ACmodelHandler() ap = APmodelHandler() type = self.get_argument('type') u_id = self.get_argument('uid') auth_key = self.get_argument('authkey') u_other_id = self.get_argument('seeid') if type == '10801': # 查看个人主页 ufuncs = Userinfo.Ufuncs.Ufuncs() retdata_ap = [] if ufuncs.judge_user_valid(u_id, auth_key): # 判断userID与auth_key是否匹配 u_info = self.db.query(User).filter( User.Uid == u_other_id).one() u_change_info = self.db.query(UCinfo).filter( UCinfo.UCuid == u_other_id).one() ret_user_info = userinfo_smply(u_info, u_change_info) ret_json_contents['user_info'] = ret_user_info exist = self.db.query(UserLike).filter( UserLike.ULlikeid == u_id, UserLike.ULlikedid == u_other_id, UserLike.ULvalid == 1).all() if exist: ret_json_contents['follow'] = True else: ret_json_contents['follow'] = False # # 筛选有效的约拍信息 # u_appointment_infos = self.db.query(AppointEntry).filter(AppointEntry.AEregisterID == u_other_id, # AppointEntry.AEvalid ==1).all() # for u_appointment_info in u_appointment_infos: # ap_id = u_appointment_info.AEapid # try: # ap_info = self.db.query(Appointment).filter(Appointment.APid == ap_id, # Appointment.APvalid == True).one() # retdata_ap.append(ap.ap_Model_simply_one(ap_info,u_id)) # except Exception,e: # print e # retjson['code'] = '10602' # retjson['contents']='该约拍不存在' # try: # u_spap_infos = self.db.query(Appointment).filter(Appointment.APsponsorid == u_other_id, # Appointment.APvalid == True).all() # # for u_spap_info in u_spap_infos: # retdata_ap.append(ap.ap_Model_simply_one(u_spap_info,u_id)) # except Exception, e: # print e # # ret_json_contents['ap_info'] =retdata_ap # # #筛选有效的活动信息 # u_ac_infos = self.db.query(ActivityEntry).filter(ActivityEntry.ACEregisterid == u_other_id, # ActivityEntry.ACEregisttvilid ==1).all() # for u_ac_info in u_ac_infos: # ac_id = u_ac_info.ACEacid # ac_info = self.db.query(Activity).filter(Activity.ACid ==ac_id, Activity.ACvalid == 1).all() # if ac_info: # ret_ac = ac.ac_Model_simply(ac_info[0],'default') # retdata_ac.append(ret_ac) # ret_json_contents['ac_info'] =retdata_ac retjson['code'] = '10601' retjson['contents'] = ret_json_contents else: retjson['code'] = '10600' retjson['contents'] = '授权码不正确' self.write(json.dumps(retjson, ensure_ascii=False, indent=2))
def post(self): ret_contents = {} ret_activity = [] ret_e_appointment = [] ret_my_appointment = [] ac = ACmodelHandler() ap = APmodelHandler() type = self.get_argument('type') u_id = self.get_argument('uid') auth_key = self.get_argument('authkey') ufuncs = Ufuncs.Ufuncs() if ufuncs.judge_user_valid(u_id, auth_key): if type == '10901': # 查看我的已报名的约拍活动 ret_activity = self.get_activity(u_id, 0) ret_contents['activity'] = ret_activity ret_e_appointment = self.get_e_appointment(u_id, 0) ret_contents['entryappointment'] = ret_e_appointment ret_my_appointment = self.get_my_appointment(u_id, 0) ret_contents['myappointment'] = ret_my_appointment self.retjson['code'] = '10392' self.retjson['contents'] = ret_contents elif type == '10902': # 查看我的正在进行的约拍活动 ret_activity = self.get_activity(u_id, 1) ret_contents['activity'] = ret_activity ret_e_appointment = self.get_e_appointment(u_id, 1) ret_contents['entryappointment'] = ret_e_appointment ret_my_appointment = self.get_my_appointment(u_id, 1) ret_contents['myappointment'] = ret_my_appointment self.retjson['code'] = '10393' self.retjson['contents'] = ret_contents elif type == '10903': # 查看我的已经完成的但是没有评价约拍活动 ret_activity = self.get_activity(u_id, 2) ret_contents['activity'] = ret_activity ret_e_appointment = self.get_e_appointment_not_evaluate(u_id) ret_contents['entryappointment'] = ret_e_appointment ret_my_appointment = self.get_my_appointment_not_evaluate(u_id) ret_contents['myappointment'] = ret_my_appointment self.retjson['code'] = '10394' self.retjson['contents'] = ret_contents elif type == '10909': # 查看我的已经完成评价的约拍 这里没有活动了,因为活动没有状态码4 ret_e_appointment = self.get_e_appointment_evaluate(u_id) ret_contents['entryappointment'] = ret_e_appointment ret_my_appointment = self.get_my_appointment_evaluate(u_id) ret_contents['myappointment'] = ret_my_appointment self.retjson['code'] = '10395' self.retjson['contents'] = ret_contents elif type == '10904': # 选择约拍对象 apid = self.get_argument('apid') chooseuid = self.get_argument('chooseduid') try: registEntry = self.db.query(AppointEntry).\ filter(AppointEntry.AEregisterID == chooseuid, AppointEntry.AEapid == apid).one() # 查找报名项 if registEntry: if registEntry.AEvalid == 1: # 用户未取消报名 if registEntry.AEchoosed: self.retjson['contents'] = u'之前已选择过该用户!' else: # 用户报名中且未被选择,添加新的约拍项 registEntry.AEchoosed = 1 # 该用户被选择 try: appointment = self.db.query(Appointment.APid, Appointment.APsponsorid, Appointment.APtype, Appointment.APstatus).\ filter(Appointment.APid == registEntry.AEapid).one() if appointment.APsponsorid == int( u_id): # 该操作用户是发起者 mid = pid = 0 if appointment.APtype == 1: # 发起者是摄影师: mid = chooseuid pid = u_id elif appointment.APtype == 0: # 发起者是模特: mid = u_id pid = chooseuid print 'before change' self.db.query(Appointment).filter(Appointment.APid == appointment.APid).\ update({"APstatus": 1}, synchronize_session='evaluate') # 将该约拍项移到进行中 print 'after change' newappinfo = AppointmentInfo( AImid=mid, AIpid=pid, AIappoid=apid) try: self.db.merge(newappinfo) self.db.commit() self.retjson['code'] = '10920' self.retjson[ 'contents'] = u"选择约拍对象成功" except Exception, e: print e self.retjson['code'] = '10925' self.retjson[ 'contents'] = u"数据库插入错误" else: self.retjson['code'] = '10921' self.retjson[ 'contents'] = u"该用户没有选择权限!" except Exception, e: print e self.retjson['code'] = '10924' self.retjson['contents'] = u'该约拍不存在或已过期'
print e if ap_e_info: ret_e_appointment.append( APmodelHandler.ap_Model_simply_one(ap_e_info[0], u_id)) else: for ap_e_entry in ap_e_entrys: ap_id = ap_e_entry.AEapid try: ap_e_info = self.db.query(Appointment).filter( Appointment.APid == ap_id, Appointment.APstatus == number).all() except Exception, e: print e if ap_e_info: ret_e_appointment.append( APmodelHandler.ap_Model_simply_one(ap_e_info[0], u_id)) return ret_e_appointment def get_my_appointment(self, u_id, number): ap_my_entrys = [] ret_my_appointment = [] if number == 2: try: ap_my_entrys = self.db.query(Appointment).filter( Appointment.APsponsorid == u_id, Appointment.APstatus >= number, Appointment.APstatus <= number + 1).all() except Exception, e: print e ret_my_appointment = APmodelHandler.ap_Model_simply(