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
