def login(self, phone, passward, varifiycode): if phone != None and passward != None and varifiycode != None and \ len(phone) == 11 and len(passward) >= 3 and len(varifiycode) == 4: # 这里验证验证码 if varifiycode != '1234': current_app.logger.info('验证码错误,系统验证码:{}用户输入的验证码:{}'.format( varifiycode, 1234)) return 0, -1 try: u = db_session.query(User).filter(User.phone == phone).first() except Exception as r: current_app.logger.error(r) return 0, -1 if u == None: current_app.logger.info('这个电话号码:{}没有注册'.format(phone)) return 0, -1 if not check_password_hash(u.passward, passward): current_app.logger.info('用户{}密码输入错误'.format(phone)) return 0, -1 current_app.logger.info('用户{}登陆成功'.format(phone)) re = db_session.query(Expert).filter( Expert.userid == u.uid).first() if re is not None: return 1, u.uid, 1 else: return 1, u.uid, 0 else: current_app.logger.info('数据错误') return 0, -1
def helpforlist(self, eid): list = [] # 查询是否有这个专家 re = db_session.query(Expert).filter(Expert.eid == eid).first() if re is not None: # 选择出向该专家提问的help obj = db_session.query(Help).filter(Help.toid == eid).all() if not obj: dict = {} dict['message'] = '目前无定向求助' list.append(dict) else: for item in obj: dict = {} dict['hid'] = item.hid dict['title'] = item.title dict['content'] = item.content dict['time'] = item.time dict['fromid'] = item.fromid dict['toid'] = item.toid list.append(dict) else: dict = {} dict['message'] = '无该专家' list.append(dict) return list
def like(self, aid): re = db_session.query(Article).filter(Article.aid == aid).first() list = [] if re == None: dict = {} dict['status'] = 0 list.append(dict) return list else: likes = re.like + 1 u = db_session.query(Article).filter(Article.aid == aid).update({"like": likes}) if u == 1: current_app.logger.info('id为{}的文章点赞成功'.format(aid)) try: db_session.commit() dict = {} dict['status'] = 1 list.append(dict) return list except Exception as r: dict = {} dict['status'] = 0 list.append(dict) return list
def articledetails(self, uid, aid): obj = db_session.query(Article).filter(Article.aid == aid).first() list = [] # 获取现在的时间 now_time = datetime.now() timestr = datetime.strftime(now_time, '%Y/%m/%d %H:%M:%S') if obj == None: dict = {} dict['status'] = 0 list.append(dict) else: dict = {} dict['aid'] = obj.aid dict['type'] = obj.type dict['title'] = obj.title dict['fromid'] = obj.fromid dict['time'] = obj.time dict['content'] = obj.content dict['like'] = obj.like list.append(dict) # 写入用户足迹 footstep = Footstep(uid=uid, aid=aid, time=timestr) db_session.add(footstep) try: db_session.commit() except Exception as r: current_app.logger.info(r) current_app.logger.info('{}的用户浏览了{}的文章'.format(uid, aid)) return list
def delcollect(self, data): list = [] dict = {} datalist = data['list'] for item in datalist: #循环删除 db_session.query(Collect).filter(Collect.cid == item).delete() try: db_session.commit() dict['status'] = 1 list.append(dict) except Exception as r: current_app.logger.info(r) dict['status'] = 0 list.append(dict) return list
def changeMail(self, uid, mail, varifiycode): if uid != None and mail != None and varifiycode != None and \ len(uid) > 0 and len(mail) >= 3 and len(varifiycode) == 4: # 这里验证验证码 if varifiycode != '1234': current_app.logger.info('验证码错误,系统验证码:{}用户输入的验证码:{}'.format( varifiycode, 1234)) return 0 u = db_session.query(User).filter(User.uid == uid).first() if u == None: current_app.logger.info('查询不到用户id:{}'.format(uid)) return 0 current_app.logger.info('查询到用户{}'.format(u)) u.mail = mail try: db_session.commit() current_app.logger.info('修改用户{}邮箱成功,新邮箱:{}'.format(u, u.mail)) except Exception as r: current_app.logger.error(r) return 0 return 1 else: current_app.logger.info('数据错误') return 0
def register(self, username, passward, phone, mail, varifiycode): # username需要适当的名字 username = getRadomStr() if username == None else username username = getRadomStr() if len(username) < 3 else username mail = '' if mail == None else mail if passward != None and varifiycode != None and phone != None and \ len(passward) > 3 and len(varifiycode) == 4 and len(phone) == 11: # 这里验证验证码 if varifiycode != '1234': current_app.logger.info('验证码错误,系统验证码:{}用户输入的验证码:{}'.format( varifiycode, 1234)) return 0 # 查询是否已经有注册了 u = db_session.query(User).filter(User.phone == phone).first() if u != None: current_app.logger.info('手机号{}已经注册过了'.format(phone)) return 0 u = User(username, generate_password_hash(passward), phone, mail, 'N', 2, 0) # 2 设置为注册用户 db_session.add(u) try: db_session.commit() current_app.logger.info('添加用户:{}'.format(u)) except Exception as r: current_app.logger.error(r) return 0 return 1 else: current_app.logger.info('数据错误') return 0
def medcinelist(self): s = db_session.query(Store).all() list = [] if s == None: dict['status'] = 0 list.append(dict) else: for item in s: dict = {} dict['sid'] = item.sid dict['sname'] = item.sname dict['spic'] = item.spic dict['sprice'] = item.sprice list.append(dict) return list
def search(self, name): if name == None and name == '': current_app.logger.error('查询参数错误') return [] list = [] d = db_session.query(Disease).filter( Disease.dname.like('%{}%'.format(name))).all() s = db_session.query(Speices).filter( Speices.sname.like('%{}%'.format(name))).all() current_app.logger.info('查询到病害条数:{},查询到物种:{}'.format(len(d), len(s))) #先查物种 for item in d: dict = {} dict['name'] = item.dname dict['label'] = 2 dict['info'] = item.dinfo list.append(dict) for item in s: dict = {} dict['name'] = item.sname dict['label'] = 1 dict['info'] = item.sinfo list.append(dict) return list
def footstep(self, uid): obj = db_session.query(Footstep).filter(Footstep.uid == uid).order_by(Footstep.time.desc()).all() list = [] if obj is None: dict = {} dict['message'] = '该用户足迹为空' list.append(dict) else: for item in obj: dict = {} dict['time'] = item.time dict['title'] = item.article.title dict['content'] = item.article.content list.append(dict) return list
def speices(self, sname): if sname == None and sname == '': current_app.logger.error('查询参数错误') return [] s = db_session.query(Speices).filter( Speices.sname.like('%{}%'.format(sname))).all() current_app.logger.info('查询到条数:{}'.format(len(s))) list = [] for item in s: dict = {} dict['sname'] = item.sname dict['sinfo'] = item.sinfo dict['ssug'] = item.ssug list.append(dict) return list
def findbyid(self, id): obj = db_session.query(Expert).filter(Expert.eid == id).first() list = [] dict = {} if obj is None: dict['status'] = 0 list.append(dict) else: dict['eid'] = obj.eid dict['userid'] = obj.userid dict['ename'] = obj.ename dict['edegree'] = obj.edegree dict['pic1'] = obj.pic1 list.append(dict) return list
def shoppingcar(self, id): obj = db_session.query(Shoppingcar).filter(Shoppingcar.uid == id).all() list = [] if obj == None: dict['status'] = 0 list.append(dict) else: for item in obj: dict = {} dict['scid'] = item.scid dict['sname'] = item.store.sname dict['spic'] = item.store.spic dict['sprice'] = item.store.sprice list.append(dict) return list
def disease(self, dname): if dname == None and dname == '': current_app.logger.error('查询参数错误') return [] d = db_session.query(Disease).filter( Disease.dname.like('%{}%'.format(dname))).all() current_app.logger.info('查询到条数:{}'.format(len(d))) list = [] for item in d: dict = {} dict['dinfo'] = item.dinfo dict['dheal'] = item.dheal dict['dprevent'] = item.dprevent list.append(dict) return list
def expertlist(self): s = db_session.query(Expert).all() list = [] if s is None: dict['status'] = 0 list.append(dict) else: for item in s: dict = {} dict['eid'] = item.eid dict['userid'] = item.userid dict['ename'] = item.ename dict['edegree'] = item.edegree dict['pic1'] = item.pic1 list.append(dict) return list
def findbyid(self, id): s = db_session.query(Store).filter_by(sid=id).first() list = [] dict = {} if s == None: dict['status'] = 0 list.append(dict) else: dict['sid'] = s.sid dict['sname'] = s.sname dict['spic'] = s.spic dict['sprice'] = s.sprice dict['sinfo'] = s.sinfo dict['snumber'] = s.snumber list.append(dict) return list
def search(self, str): express = "%" + str + "%" obj = db_session.query(Store).filter(Store.sname.like(express)).all() list = [] if obj == None: dict['status'] = 0 list.append(dict) else: for item in obj: dict = {} dict['sid'] = item.sid dict['sname'] = item.sname dict['spic'] = item.spic dict['sprice'] = item.sprice list.append(dict) return list
def helpdetails(self, hid): list = [] obj = db_session.query(Help).filter(Help.hid == hid).first() if obj is None: dict = {} dict['message'] = '找不到该求助id' list.append(dict) else: dict = {} dict['hid'] = obj.hid dict['title'] = obj.title dict['content'] = obj.content dict['time'] = obj.time dict['fromid'] = obj.fromid dict['toid'] = obj.toid list.append(dict) return list
def collectlist(self, id): # 联合查询到商品列表 obj = db_session.query(Store).join(Collect, Collect.sid == Store.sid).filter(Collect.uid == id).all() list = [] if obj == None: dict['status'] = 0 list.append(dict) else: for item in obj: dict = {} dict['cid'] = item.collect[0].cid dict['sid'] = item.sid dict['sname'] = item.sname dict['spic'] = item.spic dict['sprice'] = item.sprice list.append(dict) return list
def search(self, str): express = "%" + str + "%" obj = db_session.query(Expert).filter(Expert.ename.like(express)).all() list = [] if obj is None: dict['status'] = 0 list.append(dict) else: for item in obj: dict = {} dict['eid'] = item.eid dict['userid'] = item.userid dict['ename'] = item.ename dict['edegree'] = item.edegree dict['pic1'] = item.pic1 list.append(dict) return list
def helplist(self): obj = db_session.query(Help).filter(Help.toid == 0).all() list = [] if obj == None: dict = {} dict['status'] = 0 list.append(dict) else: for item in obj: dict = {} dict['hid'] = item.hid dict['title'] = item.title dict['content'] = item.content dict['time'] = item.time dict['fromid'] = item.fromid dict['toid'] = item.toid list.append(dict) return list
def history(self, id): # 联合查询到商品列表 obj = db_session.query(History).filter(History.uid == id).all() list = [] if obj == None: dict['status'] = 0 list.append(dict) else: for item in obj: dict = {} dict['sid'] = item.store.sid dict['sname'] = item.store.sname dict['spic'] = item.store.spic dict['hsprice'] = item.hprice dict['hnumber'] = item.hnumber dict['time'] = item.time list.append(dict) return list
def articlelist(self, type): s = db_session.query(Article).filter(Article.type == type).all() list = [] if s == None: dict = {} dict['status'] = 0 list.append(dict) else: for item in s: dict = {} dict['aid'] = item.aid dict['type'] = item.type dict['title'] = item.title dict['fromid'] = item.fromid dict['time'] = item.time dict['content'] = item.content dict['like'] = item.like list.append(dict) return list
def top(self, type): obj = db_session.query(Article).filter(Article.type == type).order_by(Article.like.desc()).all() list = [] if obj is None: dict = {} dict['message'] = '暂时没有文章' list.append(dict) else: for item in obj: dict = {} dict['aid'] = item.aid dict['type'] = item.type dict['title'] = item.title dict['fromid'] = item.fromid dict['time'] = item.time dict['content'] = item.content dict['like'] = item.like list.append(dict) return list
def changeUserName(self, uid, userName): if uid != None and userName != None and \ len(uid) > 0 and len(userName) >= 3: u = db_session.query(User).filter(User.uid == uid).first() if u == None: current_app.logger.info('查询不到用户id:{}'.format(uid)) return 0 current_app.logger.info('查询到用户{}'.format(u)) u.username = userName try: db_session.commit() current_app.logger.info('修改用户{}用户名成功,新用户名:{}'.format( u, u.username)) except Exception as r: current_app.logger.error(r) return 0 return 1 else: current_app.logger.info('数据错误') return 0
def changePhone(self, uid, passward, phone): if uid != None and passward != None and phone != None and \ len(uid) > 0 and len(passward) >= 3 and len(phone) == 11: u = db_session.query(User).filter(User.uid == uid).first() if u == None: current_app.logger.info('查询不到用户id:{}'.format(uid)) return 0 current_app.logger.info('查询到用户{}'.format(u)) u.phone = phone try: db_session.commit() current_app.logger.info('修改用户{}手机号码成功,新手机号:{}'.format( u, u.phone)) except Exception as r: current_app.logger.error(r) return 0 return 1 else: current_app.logger.info('数据错误') return 0
def searcharticle(self, str): express = "%" + str + "%" obj = db_session.query(Article).filter(Article.title.like(express)).all() list = [] if obj == None: dict = {} dict['status'] = 0 list.append(dict) else: for item in obj: dict = {} dict['aid'] = item.aid dict['type'] = item.type dict['title'] = item.title dict['fromid'] = item.fromid dict['time'] = item.time dict['content'] = item.content dict['like'] = item.like list.append(dict) return list
def changePassward(self, uid, old, new1, new2): if new1 != None and new2 != None and \ len(new1) >= 3 and len(new2) >= 3 and \ new1 == new2 and uid != None: u = db_session.query(User).filter(User.uid == uid).first() if u == None: current_app.logger.info('查询不到用户id:{}'.format(uid)) return 0 current_app.logger.info('查询到用户{}'.format(u)) if check_password_hash(u.passward, old): u.passward = generate_password_hash(new1) try: db_session.commit() current_app.logger.info('修改用户{}密码成功,新密码:{}'.format( u, generate_password_hash(u.passward))) except Exception as r: current_app.logger.error(r) return 0 return 1 else: current_app.logger.info('用户{}旧密码输入错误,修改失败'.format(u)) return 0
def speiceslist(self): list = db_session.query(Speices.sname).all() return list
def diseaselist(self): list = db_session.query(Disease.dname).all() return list