def get_is_data():
userid = request.args.get('userID')
eq_id = request.args.get('equipID')
user_name = r.get(userid)
wu = wx_user.query.filter(wx_user.name == user_name).first() #获取用户名
wxuser_id = wu.id #获取用户ID
sql = 'select image_id from information where user_id=%s and equip_id=%s' % (
wxuser_id, eq_id)
cursor.execute(sql)
image_id = cursor.fetchall()
all_id = []
unread_id = []
for (i, ) in image_id:
unread_id.append(i)
imgs_id = srch_hash_data('upload_img', 'equip_id', eq_id)
for i in imgs_id:
all_id.append(i)
# 将所有的图片id减去未读图片的id获得已读图片的ID
is_id = set(all_id) - set(unread_id)
read_arr = []
for i in is_id:
read_data = srch_hash_data('upload_img', 'id', str(i))
read_arr.append(read_data[0][0])
read_arr.append(read_data[0][1])
read_arr.append(read_data[0][2])
json_data = json.dumps(read_arr, cls=CJsonEncoder)
return json_data
def delete():
types = request.form.getlist('types')
types = ''.join(types)
q = request.form.getlist('id')
json_data = srch_hash_data(types, 'delete', q)
return json_data
def del_unread_data():
userid = request.args.get('userID')
infor_id = request.args.get('inforID')
read_flag = request.args.get('read_flag')
if read_flag == 'unread_id':
user_name = r.get(userid)
wu = wx_user.query.filter(wx_user.name == user_name).first() #获取用户名
wxuser_id = wu.id #获取用户ID
sql = 'delete from information where image_id=%s and user_id=%s' % (
infor_id, wxuser_id)
cursor.execute(sql)
database.commit()
data = srch_hash_data('imgs', 'id', infor_id)
return data
def changedata():
userid = request.args.get('id')
name = request.args.get('name')
phone = request.args.get('phone')
email = request.args.get('email')
u_name = '\'%s\'' % name
u_phone = '\'%s\'' % phone
u_mail = '\'%s\'' % email
if len(r.keys('wx_user*')) != 0:
for k in r.scan_iter('wx_user*'):
r_userid = r.hget(k, 'id')
if userid == r_userid:
print("更新缓存")
user_infor = {'name': name, 'phone': phone, 'email': email}
r.hmset(k, user_infor)
sql = 'update wx_user set name=%s,phone=%s,email=%s where id=%s' % (
u_name, u_phone, u_mail, userid)
cursor.execute(sql)
database.commit()
json_data = srch_hash_data('wx_user', 'init', 'None')
return json_data
def getuserval():
userid = request.args.get('userID')
userData = srch_hash_data('wx_user', 'name', r.get(userid))
return userData
def getuserdata():
json_data = srch_hash_data('wx_user', 'init', 'None')
return json_data
def imgdata():
searchname = request.args.get('name')
types = request.args.get('types')
json_data = srch_hash_data(types, 'name', searchname)
return json_data
def srch_time():
time = request.args.get('time')
types = request.args.get('types')
json_data = srch_hash_data(types, 'date', time)
return json_data
def getimagedata():
imgsData = srch_hash_data('upload_img', 'init', '')
return imgsData
def get_equip_detail_data():
equip_unread_data = srch_hash_data('equipment', 'init', 'None')
return equip_unread_data