def post(self): self.xsrf_form_html() email = self.get_argument("email", default="") if email != "": s = db.session() user = s.query(db.User).filter_by(email=email).first() s.close() if user: res = {"errno": "-1", "err": "该邮箱已注册"} self.write(res) else: user_name = self.get_argument("user_name", default="") password = self.get_argument("password", default="") is_active = self.get_argument("is_active", default="") print(user_name + "/" + password + "/" + is_active) if (user_name != "") & (password != "") & (is_active != ""): adduser = db.User(email=email, username=user_name, password=password, is_active=is_active) s = db.session() s.add(adduser) s.commit() s.close() res = {"errno": "1", "err": "用户成功添加"} self.write(res) else: res = {"errno": "-1", "err": "请填写完整信息"} self.write(res) else: res = {"errno": "-1", "err": "请输入邮箱"} self.write(res)
def get(self): self.xsrf_form_html() user_id = self.get_argument("user_id", default="") s = db.session() user_infos = s.query(db.User).filter_by(id=(user_id)).first() s.close() self.render("manager_user_edit.html", user_infos=user_infos)
def put(self): self.xsrf_form_html() user_id = tornado.escape.json_decode(self.get_secure_cookie("user_id")) if(self.request.files["file"][0] and (user_id != "")): #保存图片 data=self.request.files["file"][0] #time = datetime.datetime.now() #sql time: .strftime("%Y-%m-%d %H:%M:%S") md5 = hashlib.md5() md5.update(data["body"]) md5encode = md5.hexdigest() ran_str = ''.join(random.sample(string.ascii_letters + string.digits, 8)) extension = data["filename"].split(".")[-1] head = data["filename"].rstrip("."+extension) #将文件名中文转化为拼音 pinyin = Pinyin() head = pinyin.get_pinyin(head) #中文转拼音结束 savename = head + "_" + md5encode + ran_str + "." + extension #time.strftime("%Y_%m_%d_%H_%M_%S")+"_"+md5encode+"."+data["filename"].split(".")[-1] with open(os.path.join("static","profilephoto",savename),"wb") as up: up.write(data["body"]) # print(user) s=db.session() user_infos = s.query( db.User ).filter_by(id = user_id ).first() if (user_infos.profilephoto != DEFAULT_PROFILE_PHOTO) and (os.path.exists("static/"+user_infos.profilephoto)): os.remove("static/"+user_infos.profilephoto) user_infos.profilephoto = "profilephoto/"+savename s.commit() s.close() res = {"msg":"上传成功"} self.write(res) else: res = {"msg":"上传错误"} self.write(res)
def put(self): self.xsrf_form_html() picid = self.get_argument("picid", default="") code = self.get_argument("code", default="") name = self.get_argument("name", default="") address = self.get_argument("address", default="") is_correct = self.get_argument("is_correct", default="") if picid != "": s = db.session() pic = s.query(db.Picture).filter(db.Picture.id == picid).first() if code != "": pic.code = code if name != "": pic.name = name if address != "": pic.address = address if is_correct != "": pic.is_correct = is_correct if is_correct == "1": pic.uncorrect_msg = "success" s.commit() s.close() res = "success" else: res = "failed" self.write(res)
def post(self): self.xsrf_form_html() try: user = tornado.escape.json_decode(self.request.body) # print(user) s=db.session() user_infos = s.query( db.User ).filter_by(id = user["id"] ).first() if ((user_infos.password == user["password"])): if user["change_password"]!="": print(user["change_password"]) user_infos.password = str(user["change_password"]) respon = {"errno": 1, "err": "密码修改成功,请重新登录"} if user_infos.username != user["username"]: user_infos.username = str(user["username"]) respon = {"errno": 0, "err": "用户名修改为: \""+ str(user["username"]) + "\""} # user_infos.is_active = user["is_active"] # user_infos.create_time = user["create_time"] # user_infos.last_login = user["last_login"] s.commit() s.close() self.write(respon) else: respon = {"errno": -1, "err": "密码错误"} self.write(respon) except Exception as e: respon = {"errno": -1, "err": str(e)} self.write(respon)
def get(self): self.xsrf_form_html() user_id = tornado.escape.json_decode(self.get_secure_cookie("user_id")) s=db.session() user_infos = s.query( db.User ).filter_by(id = user_id ).first() s.close() self.render("user_info.html",user_infos = user_infos,)
def post(self): self.xsrf_form_html() user_email = self.get_argument("user_email",default="") user_name = self.get_argument("user_name",default="") password = self.get_argument("password",default="")#明文sha1哈希之后再从用户传过来 if user_email: try: adduser = db.User(email = user_email, username = user_name, password = password) s=db.session() s.add(adduser) s.commit() s.close() respon = {"errno": 1, "err": "用户已注册,请联络管理员激活"} self.write(tornado.escape.json_encode(respon)) except Exception as e: respon = {"errno": -1, "err": e} self.write(tornado.escape.json_encode(respon)) else: respon = {"errno": -1, "err": "用户注册失败"} self.write(tornado.escape.json_encode(respon))
def get(self): self.xsrf_form_html() pictureid = self.get_argument("pictureid",default="") s=db.session() picture_infos = s.query( db.Picture ).filter_by(id = pictureid ).first() s.close() print(picture_infos.confirmed_picture_path) self.render("manager_pic_edit.html",picture = picture_infos)
def post(self): self.xsrf_form_html() level = self.get_argument("level", default="") manager_id = self.get_argument("manager_id", default="") s = db.session() manager_infos = s.query( db.Manager).filter_by(id=int(manager_id)).first() manager_infos.level = level s.commit() s.close()
def get(self): self.xsrf_form_html() user_id = tornado.escape.json_decode(self.get_secure_cookie("user_id")) page_index = int(self.get_argument("page",default="1")) limit = int(self.get_argument("limit",default="15")) keyword = self.get_argument("keyword",default="") start_date = self.get_argument("start_date",default="1970-01-01") end_date = self.get_argument("end_date",default="3000-12-31") if start_date == "": start_date = default="1970-01-01" if end_date == "": end_date = default="3000-12-31" # 数据判断条件 filters = { db.Picture.user_id == user_id, #只允许查询自己的业务 db.Picture.is_correct == 1, #只允许查询自己的业务 db.or_(db.Picture.name.like('%'+keyword+'%'), db.Picture.code.like('%'+keyword+'%'), db.Picture.address.like('%'+keyword+'%'), ), db.Picture.create_time.between(start_date+" 00:00:00", end_date+" 23:59:59") } s=db.session() count = s.query(db.Picture).filter(*filters).count() if page_index < 1 or count == 0: page_index = 1 elif limit*page_index > count: page_index = int((count + limit -1) / limit); #asc升序 pictures = s.query(db.Picture).order_by(db.Picture.create_time.desc()).filter(*filters).limit(limit).offset((page_index-1)*limit).all() s.close() s = db.session() user_infos = s.query( db.User ).filter_by(id = user_id ).first() s.close() if start_date == "1970-01-01": start_date = "" if end_date == "3000-12-31": end_date = "" self.render("user_OBDList.html",user_infos = user_infos, page_index = page_index,count = count,limit = limit, keyword = keyword, start_date = start_date, end_date = end_date, pictures = pictures)
def get(self): self.xsrf_form_html() picid = self.get_argument("picid", default="") uncorrect_msg = self.get_argument("uncorrect_msg", default="") if picid != "": s = db.session() pic = s.query(db.Picture).filter(db.Picture.id == picid).first() pic.is_correct = 0 pic.uncorrect_msg = uncorrect_msg self.write("图片报错成功!") else: self.write("图片报错失败!")
def delete(self): self.xsrf_form_html() user_id = self.get_argument("user_id", default="") s = db.session() user = s.query(db.User).filter_by(id=user_id).first() if (user.id): s.delete(user) s.commit() s.close() self.write(user_id) else: s.close() self.write("-1")
def delete(self): self.xsrf_form_html() manager_id = self.get_argument("manager_id", default="") s = db.session() manager = s.query(db.Manager).filter_by(id=manager_id).first() if (manager.id): s.delete(manager) s.commit() s.close() self.write(manager_id) else: s.close() self.write("0")
def get(self): self.xsrf_form_html() manager_id = tornado.escape.json_decode( self.get_secure_cookie("manager_id")) s = db.session() manager_infos = s.query(db.Manager).filter_by(id=manager_id).first() manager_name = manager_infos.managername level = manager_infos.level self.render("manager_main.html", managername=manager_name, level=level, manager_infos=manager_infos ) # self.render() 读取html,传向前端,同时可以穿参数level s.close()
def post(self): self.xsrf_form_html() user_id = self.get_argument("user_id", default="") password = self.get_argument("password", default="") if ((user_id != "") & (password != "")): s = db.session() user_infos = s.query(db.User).filter_by(id=int(user_id)).first() user_infos.password = password s.commit() s.close() res = {"errno": "1"} self.write(res) else: res = {"errno": "-1"} self.write(res)
def post(self): self.xsrf_form_html() #内部用 self.xsrf_form_html()生成 user_id = self.get_argument("user_id", default="") is_active = self.get_argument("is_active", default="") if ((user_id != "") & (is_active != "")): #返回的id和active不为空时 s = db.session() #连接数据库 user_infos = s.query(db.User).filter_by( id=int(user_id)).first() #user_infos接收对应id数据 user_infos.is_active = int(is_active) #更改is_active,并commit。 s.commit() s.close() res = {"errno": "1"} else: res = {"errno": "-1"} self.write(res)
def post(self): self.xsrf_form_html() email = self.get_argument("email", default="") if email != "": #email不为空 s = db.session() #连接数据库 manager = s.query(db.Manager).filter_by(email=email).first() s.close() if manager: #如果manager存在说明数据已存在,返回:邮箱已注册 res = {"errno": "-1", "err": "该邮箱已注册"} self.write(res) else: #否则接收相应信息 manager_name = self.get_argument("manager_name", default="") password = self.get_argument("password", default="") is_active = self.get_argument("is_active", default="") level = self.get_argument("level", default="") print(manager_name + "/" + password + "/" + is_active) if (manager_name != "") & (password != "") & (is_active != ""): #名字,密码,激活状态不为空时,s.add()把用户数据写入数据库中并commit addmanager = db.Manager(email=email, managername=manager_name, password=password, is_active=is_active, level=level) s = db.session() s.add(addmanager) s.commit() s.close() res = {"errno": "1", "err": "用户成功添加"} self.write(res) else: res = {"errno": "-1", "err": "请填写完整信息"} self.write(res) else: res = {"errno": "-1", "err": "请输入邮箱"} self.write(res)
def post(self): self.xsrf_form_html() if(self.request.files["file"][0]): upp = self.get_argument("upload_port_pos",default="-1") us = self.get_argument("upload_sort",default=None) GPS = self.get_argument("GPS",default="") address = self.get_argument("address",default="") OBDCode = self.get_argument("OBDCode",default="") #保存图片 data=self.request.files["file"][0] #time = datetime.datetime.now() #sql time: .strftime("%Y-%m-%d %H:%M:%S") md5 = hashlib.md5() md5.update(data["body"]) md5encode = md5.hexdigest() ran_str = ''.join(random.sample(string.ascii_letters + string.digits, 8)) extension = data["filename"].split(".")[-1] head = data["filename"].rstrip("."+extension) #将文件名中文转化为拼音 pinyin = Pinyin() head = pinyin.get_pinyin(head) #中文转拼音结束 savename = head + "_" + md5encode + ran_str + "." + extension #time.strftime("%Y_%m_%d_%H_%M_%S")+"_"+md5encode+"."+data["filename"].split(".")[-1] with open(os.path.join("static","uploadpic",savename),"wb") as up: up.write(data["body"]) QR = QRCode(os.path.join("static","uploadpic",savename)) if(address): QR["address"] = address if (OBDCode): QR["code"] = OBDCode if(GPS): QR["GPS"] = GPS #插入数据库 pic = db.Picture(code = str(QR["code"]), name = str(QR["name"]), address = str(QR["address"]), GPS = str(QR["GPS"]), port_direction = port_analyze[upp][0], zero_port_pos = port_analyze[upp][1], port_sort = us, picture_path = os.path.join("uploadpic",savename), manager_id = self.get_secure_cookie("manager_id")) s=db.session() s.add(pic) s.commit() s.close() self.write("success") else: self.write("error")
def get(self): self.xsrf_form_html() page_index = int(self.get_argument("page", default="1")) limit = int(self.get_argument("limit", default="30")) is_correct = int(self.get_argument("is_correct", default="1")) keyword = self.get_argument("keyword", default="") create_time = self.get_argument("create_time", default="1970-01-0-1") last_login = self.get_argument("last_login", default="3000-12-31") if create_time == "": create_time = "1970-01-01" if last_login == "": last_login = "******" # 数据判断条件 filters = { db.or_(db.Manager.id.like('%' + keyword + '%'), db.Manager.email.like('%' + keyword + '%'), db.Manager.managername.like('%' + keyword + '%'), db.Manager.is_active.like('%' + keyword + '%')), db.Manager.create_time.between(create_time + " 00:00:00", last_login + " 23:59:59"), ~db.Manager.id.in_([int(self.get_secure_cookie("manager_id"))]), } s = db.session() count = s.query(db.Manager).filter(*filters).count() if page_index < 1 or count == 0: page_index = 1 elif limit * page_index > count: page_index = int((count + limit - 1) / limit) #asc升序 managers = s.query(db.Manager).order_by( db.Manager.create_time.desc()).filter( *filters).limit(limit).offset((page_index - 1) * limit).all() s.close() if create_time == "1970-01-01": create_time = "" if last_login == "3000-12-31": last_login = "" #转变成json文件格式 result_dict = [u.column_dict() for u in managers] res = {"code": 0, "msg": "", "count": count, "data": result_dict} # self.render("pics_management.html",page_index = page_index,count = count,limit = limit, keyword = keyword, start_date = start_date, end_date = end_date, pictures = pictures) self.write(res)
def delete(self):#删除图片 self.xsrf_form_html() pictureid = self.get_argument("pictureid",default="") s=db.session() pic = s.query(db.Picture).get(pictureid) if pic.id : if (pic.picture_path): if os.path.exists(os.path.join("static",pic.picture_path)): os.remove(os.path.join("static",pic.picture_path)) if (pic.confirmed_picture_path): if os.path.exists(os.path.join("static",pic.confirmed_picture_path)): os.remove(os.path.join("static",pic.confirmed_picture_path)) s.delete(pic) s.commit() s.close() self.write(pictureid) else: self.write("-1")
def get(self): self.xsrf_form_html() page_index = int(self.get_argument("page", default="1")) #获取前端中page参数,默认为1 limit = int(self.get_argument("limit", default="15")) #获取前端中limit参数,默认15 is_correct = int(self.get_argument("is_correct", default="1")) keyword = self.get_argument("keyword", default="") start_date = self.get_argument("start_date", default="1970-01-01") end_date = self.get_argument("end_date", default="3000-12-31") if start_date == "": start_date = default = "1970-01-01" if end_date == "": end_date = default = "3000-12-31" # 数据判断条件 filters = { db.or_( db.Picture.name.like('%' + keyword + '%'), db.Picture.code.like('%' + keyword + '%'), db.Picture.address.like('%' + keyword + '%'), ), db.Picture.create_time.between(start_date + " 00:00:00", end_date + " 23:59:59") } s = db.session() count = s.query(db.Picture).filter(*filters).count() if page_index < 1 or count == 0: page_index = 1 elif limit * page_index > count: page_index = int((count + limit - 1) / limit) #asc升序 # pictures = s.query(db.Picture).order_by(db.Picture.create_time.desc()).filter(*filters).limit(limit).offset((page_index-1)*limit).all() s.close() if start_date == "1970-01-01": start_date = "" if end_date == "3000-12-31": end_date = "" self.render("pics_management.html", page_index=page_index, count=count, limit=limit, keyword=keyword, start_date=start_date, end_date=end_date) #, pictures = pictures)
def get(self): self.xsrf_form_html() page_index = int(self.get_argument("page", default="1")) limit = int(self.get_argument("limit", default="30")) is_correct = int(self.get_argument("is_correct", default="1")) keyword = self.get_argument("keyword", default="") start_date = self.get_argument("start_date", default="1970-01-01") end_date = self.get_argument("end_date", default="3000-12-31") if start_date == "": #给时间赋予初始值 start_date = default = "1970-01-01" if end_date == "": end_date = default = "3000-12-31" # 数据判断条件 filters = { db.or_( db.Picture.name.like('%' + keyword + '%'), db.Picture.code.like('%' + keyword + '%'), db.Picture.address.like('%' + keyword + '%'), ), db.Picture.create_time.between(start_date + " 00:00:00", end_date + " 23:59:59") } s = db.session() count = s.query(db.Picture).filter(*filters).count() if page_index < 1 or count == 0: page_index = 1 elif limit * page_index > count: page_index = int((count + limit - 1) / limit) #asc升序 pictures = s.query(db.Picture).order_by( db.Picture.create_time.desc()).filter( *filters).limit(limit).offset((page_index - 1) * limit).all() s.close() if start_date == "1970-01-01": start_date = "" if end_date == "3000-12-31": end_date = "" #转变成json文件格式 result_dict = [u.column_dict() for u in pictures] res = {"code": 0, "msg": "", "count": count, "data": result_dict} # self.render("pics_management.html",page_index = page_index,count = count,limit = limit, keyword = keyword, start_date = start_date, end_date = end_date, pictures = pictures) self.write(res)
def post(self): self.xsrf_form_html() try: picture = tornado.escape.json_decode(self.request.body) s=db.session() picture_infos = s.query( db.Picture ).filter_by(id = picture["id"] ).first() picture_infos.name = picture["name"] picture_infos.address = picture["address"] picture_infos.port_direction = picture["port_direction"] picture_infos.zero_port_pos = picture["zero_port_pos"] picture_infos.port_sort = picture["port_sort"] picture_infos.port_sort = picture["port_sort"] picture_infos.manager_id = self.get_secure_cookie("manager_id") s.commit() s.close() except Exception as e: self.write(str(e)) else: self.write("success")
def post(self): self.xsrf_form_html() #内部用 self.xsrf_form_html()生成 manager_id = self.get_argument("manager_id", default="") is_active = self.get_argument("is_active", default="") if ((manager_id != "") & (is_active != "")): s = db.session() manager_infos = s.query( db.Manager).filter_by(id=manager_id).first() manager_infos.is_active = int(is_active) s.commit() s.close() res = {"errno": "1"} else: res = {"errno": "0"} self.write(res) # #后台角色管理界面 # class ManagerPicManagementHandler(ManagerBaseHandler):
def post(self): #https://127.0.0.1:8000/userlogin?user_email=A&password=1994&remember_me=false self.xsrf_form_html() #内部用 self.xsrf_form_html()生成 user_email = self.get_argument("user_email",default="") password = self.get_argument("password",default="")#明文sha1哈希之后再从用户传过来 remember_me = self.get_argument("remember_me",default="false") code = self.get_argument("check_code",default="false") check_code = self.session['CheckCode'] if code.upper()==check_code.upper(): s=db.session() user_infos = s.query( db.User ).filter_by(email = user_email ).first() if user_infos: user_id = user_infos.id db_pwd = user_infos.password if str(db_pwd) == str(password): if user_infos.is_active ==1: respon = {"errno": 1, "err": self.get_argument('next', default='/')} self.set_current_user(user_id,user_infos.username,remember_me) #将当前用户名写入 cookie,方法见下面 user_infos.last_login = datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S') s.add(user_infos) s.commit() s.close() self.write(tornado.escape.json_encode(respon)) else: respon = {"errno": -1, "err": "该用户未激活,请联系管理员"} s.close() self.write(tornado.escape.json_encode(respon)) else: respon = {"errno": -1, "err": "账号或者密码错误"} print(db_pwd+"\n"+password) s.close() self.write(tornado.escape.json_encode(respon)) else: respon = {"errno": -1, "err": "账号或者密码错误"} s.close() self.write(tornado.escape.json_encode(respon)) else: respon = {"errno": -1, "err": "验证码错误"} self.write(tornado.escape.json_encode(respon))
def post(self): self.xsrf_form_html() user_email = self.get_argument("user_email",default="") if(user_email != ""): s=db.session() user_infos = s.query( db.User ).filter_by( email = user_email ).all() s.close() if(user_infos): respon = {"errno": -1, "err": "该邮箱已注册"} self.write(tornado.escape.json_encode(respon)) else: respon = {"errno": 1, "err": "可以使用"} self.write(tornado.escape.json_encode(respon)) else: respon = {"errno": -1, "err": "邮箱为空"} self.write(tornado.escape.json_encode(respon))
def get(self): self.xsrf_form_html() page_index = int(self.get_argument("page", default="1")) limit = int(self.get_argument("limit", default="30")) keyword = self.get_argument("keyword", default="") # data = tornado.escape.json_decode(self.request.body) # if "page" in self.request.arguments: #pyhton3 新特性不支持has_key #page_index = int(self.get_argument("page",default="1")) # if "limit" in self.request.arguments: #page_size = int(self.get_argument("limit",default="15")) filters = { db.or_( db.Manager.id.like("%" + keyword + "%"), db.Manager.email.like("%" + keyword + "%"), db.Manager.managername.like("%" + keyword + "%"), ), # db.User.create_time.between(create_time+"00:00:00",last_login+"00:00:00"), } s = db.session() count = s.query(db.Manager).filter(*filters).count() if page_index < 1 or count == 0: page_index = 1 elif limit * page_index > count: page_index = int((count + limit - 1) / limit) #asc升序 #users = s.query(db.User).order_by(db.User.create_time.desc()).filter(*filters).limit(page_size).offset((page_index-1)*page_size).all() managers = s.query(db.Manager).order_by( db.Manager.create_time.desc()).filter( *filters).limit(limit).offset((page_index - 1) * limit).all() s.close() self.render("managers_management.html", page_index=page_index, count=count, limit=limit, keyword=keyword, managers=managers)
def post(self): self.xsrf_form_html() try: manager = tornado.escape.json_decode(self.request.body) # print(manager) s = db.session() manager_infos = s.query( db.Manager).filter_by(id=manager["id"]).first() if ((manager_infos.password == manager["password"])): if manager["change_password"] != "": manager_infos.password = str(manager["change_password"]) if manager_infos.managername != manager["managername"]: manager_infos.managername = str(manager["managername"]) # manager_infos.is_active = manager["is_active"] # manager_infos.create_time = manager["create_time"] # manager_infos.last_login = manager["last_login"] s.commit() s.close() self.write("修改成功") else: self.write("密码错误") except Exception as e: self.write(str(e))
def post(self): self.xsrf_form_html() #内部用 self.xsrf_form_html()生成 manager_email = self.get_argument("manager_email", default="") password = self.get_argument("password", default="") remember_me = self.get_argument("remember_me", default="false") next_page = self.get_argument("next", default="/manager") #user_infos = mrd.select_table(table="manager",column="*",condition="email",value=manager_email) s = db.session() user_infos = s.query(db.Manager).filter_by(email=manager_email).first() manager_id = user_infos.id if user_infos: db_pwd = user_infos.password if str(db_pwd) == str(password): if user_infos.is_active == 1: respon = {"error": 0, "data": next_page} self.set_current_user(manager_id, user_infos.managername, remember_me) #将当前用户名写入 cookie,方法见下面 user_infos.last_login = datetime.datetime.now().strftime( '%Y-%m-%d %H:%M:%S') s.add(user_infos) s.commit() s.close() self.write(tornado.escape.json_encode(respon)) else: respon = {"error": 1, "data": "该用户未激活,请联系管理员"} s.close() self.write(tornado.escape.json_encode(respon)) else: respon = {"error": 1, "data": "账号或者密码错误"} s.close() self.write(tornado.escape.json_encode(respon)) else: respon = {"error": 1, "data": "账号或者密码错误"} s.close() self.write(tornado.escape.json_encode(respon))
def post(self): self.xsrf_form_html() pictureid = self.get_argument("pictureid",default="") print("++++++++++"+pictureid) s = db.session(); OBD = s.query( db.Picture ).filter_by(id = pictureid ).first(); #s.query(db.Picture).filter(db.Picture.id == pictureid).first() if(OBD): OBDInfo = OBD.__dict__ code = OBDInfo["code"] #需要添加confimed的代码 req = {"port_direction":OBDInfo["port_direction"], "zero_port_pos": OBDInfo["zero_port_pos"], "port_sort":OBDInfo["port_sort"]} #"method"为深度学习对应的API fci = fcisservice.remote("",req,open(os.path.join("static",OBDInfo["picture_path"]), 'rb')) if fci["body"] == "noimg" or fci["body"] == "detectbusy" or fci["body"] == "": confirmed_picture_path = "" ports_occupy = "" print("confirmed_picture_path unexists\n") else: md5 = hashlib.md5() confirmdata = fci["body"] ports_occupy = str(fci["Ports_occupy"]) md5.update(confirmdata) md5encode = md5.hexdigest() onamelist = OBDInfo["picture_path"].split("/")[-1].split(".") confirmname = "".join(onamelist[0:len(onamelist)-1]) + ports_occupy + "." + onamelist[-1] #time.strftime("%Y_%m_%d_%H_%M_%S")+"_"+md5encode+"."+OBDInfo["picture_path"].split(".")[-1] confirmed_picture_path = os.path.join("confirmedpic",confirmname) with open(os.path.join("static",confirmed_picture_path),"wb") as up: up.write(confirmdata) #对端口识别和二维码识别的判断 res = {} is_correct = 0 if fci["body"] == "detectbusy": res["msg"] = "detectbusy" else: if confirmed_picture_path == "" and code == "": res["msg"] = "AllFail" elif confirmed_picture_path != "" and code == "": res["msg"] = "QrcodeFail" elif confirmed_picture_path == "" and code != "": res["msg"] = "DetectFail" else: is_correct = 1 res["msg"] = "success" # 插入新的数据到数据库 OBD.ports_occupy = ports_occupy OBD.is_correct = is_correct OBD.uncorrect_msg = res["msg"] OBD.confirmed_picture_path = confirmed_picture_path OBD.manager_id = self.get_secure_cookie("manager_id") s.commit() s.close() #返回json,获取信息 #del res["body"] res["id"] = pictureid res["confirmed_picture_path"] = os.path.join(confirmed_picture_path) res["ports_occupy"] = ports_occupy time = datetime.datetime.now() #sql time: .strftime("%Y-%m-%d %H:%M:%S") res["update_time"] = time.strftime("%Y-%m-%d %H:%M:%S") res["manager_id"] = bytes.decode(self.get_secure_cookie("manager_id")) self.write(res) else: self.write(tornado.escape.json_encode({"msg":"false"})) # self.xsrf_form_html() # pictureid = self.get_argument("pictureid",default="") # if pictureid != "": # s=db.session() # picture_infos = s.query( db.Picture ).filter_by(id = pictureid ).first() # if(os.path.exists(os.path.join("static",picture_infos.picture_path))): # body = open(os.path.join("static",picture_infos.picture_path),'rb').read() # bodybase64 = str(base64.b64encode(body)) # print(bodybase64) # pic = {"imgFile":[{"filename":picture_infos.picture_path.split("/")[-1], # "content_type": "img/"+picture_infos.picture_path.split(".")[-1], # "body":body }]} # req = {"port_direction":picture_infos.port_direction, # "zero_port_pos":picture_infos.zero_port_pos, # "port_sort":picture_infos.port_sort} # req["imgFile"] = [{"filename":picture_infos.picture_path.split("/")[-1], # "content_type": "img/"+picture_infos.picture_path.split(".")[-1], # "body":bodybase64 }] # with open("./input.json","w",encoding='utf-8') as json_file: # json.dump(req,json_file,ensure_ascii=False) # res = fcisservice.remote("method", req, pic) # confirmdata = res["imgFile"][0] # if confirmdata: # time = datetime.datetime.now() #sql time: .strftime("%Y-%m-%d %H:%M:%S") # md5 = hashlib.md5() # md5.update(confirmdata["body"]) # md5encode = md5.hexdigest() # confirmname = time.strftime("%Y_%m_%d_%H_%M_%S")+"_"+md5encode+"."+confirmdata["filename"].split(".")[-1] # if (picture_infos.confirmed_picture_path != None): # os.remove(os.path.join("static",picture_infos.confirmed_picture_path)) # with open(os.path.join("static","confirmedpic",confirmname),"wb") as up: # up.write(confirmdata["body"]) # picture_infos.code = res["code"] # picture_infos.name = res["name"] # picture_infos.address = res["address"] # picture_infos.GPS = res["GPS"] # picture_infos.confirmed_picture_path = os.path.join("confirmedpic",confirmname) # picture_infos.manager_id = self.get_secure_cookie("manager_id") # s.commit() # s.close() # #返回json,获取信息 # time = datetime.datetime.now() # del res["imgFile"] # res["confirmed_picture_path"] = os.path.join("confirmedpic",confirmname) # res["update_time"] = time.strftime("%Y-%m-%d %H:%M:%S") # res["msg"] = "success" # res["manager_id"] = bytes.decode(self.get_secure_cookie("manager_id")) # # res.update(tornado.escape.json_encode(req)) # self.write(res) # else: # s.close() # self.write(tornado.escape.json_encode({"msg":"false"})) # else: # s.close() # self.write(tornado.escape.json_encode({"msg":"false"})) # else: # self.write(tornado.escape.json_encode({"msg":"false"}))