def accountLogin(request): user_name = _post(request, "user_name") user_pass = _post(request, 'user_pass') # 返回给客户端的值 params={} if(len(user_name) > 0 and len(user_pass) > 0): user = UserService.getUserLogin(user_name, Base64.md5hex(user_name+user_pass)) if(len(user)>0): request.session['user'] =user[0] request.session.set_expiry(0)#关闭浏览器session失效 params['result'] = "SUCCESS" else: params['result'] = "USER_ERROR" else: params['result'] = "USER_ERROR" return HttpResponse(json.dumps(params,ensure_ascii=False))
def updateCurrentSystemImage(request): #获取前端上传的图片 file = request.FILES.getlist('files') product_id = _post(request, "id") file_name1 = "" #判断是否为空,默认 if len(file) == 0: return; for f in file: name = f.name file_name = name.split(".")[0] + "_"+ DateUtil.time_stamp() +"."+ name.split(".")[1] img_path = os.path.join(Resp.IMAGEUPLOAD, file_name) file_name1+="/images/currentsystem_images/" + file_name+"," #写入到文件中 with open(img_path,'wb') as ff: for item in f.chunks(): ff.write(item) saveImageRow = CurrentSystemService.updateCurrentSystemImage(file_name1, product_id) #路径保存到数据库 respJson = {} if saveImageRow > 0: respJson["product_id"] = saveImageRow else: respJson["ERROR"] = Resp.ERROR return HttpResponse(toJson(respJson));
def delTip(request): tip_id = _post(request, "tip_id") #先删除有关的中间表信息 TipService.delModdinByTipId(tip_id) #再删除tip表信息 delTipRow = TipService.delTip(tip_id) respJson = {} if delTipRow > 0: respJson["result"] = Resp.SUCCESS else: respJson["result"] = Resp.ERROR return HttpResponse(toJson(respJson))
def delDoc(request): doc_id = _post(request, "doc_id") #先删除有关的中间表信息 DocService.delModdinByDocId(doc_id) #再删除doc表信息 delDocRow = DocService.delDoc(doc_id) respJson = {} if delDocRow > 0: respJson["result"] = Resp.SUCCESS else: respJson["result"] = Resp.ERROR return HttpResponse(toJson(respJson))
def saveSpare(request): dataJson = json.loads(_post(request, "data")) #先将信息添加到Spare表中 addSpareRow = SpareService.addSpare(dataJson) #在得到addAlertRow Id存到中间表中 if (dataJson.get("their_product")!='' and dataJson.get("their_product")!=None): product_id = dataJson.get("their_product") SpareService.addSpareAndProduct(addSpareRow, product_id) if addSpareRow > 0: return HttpResponse(toJson({"state": "ok"})) else: return HttpResponse(toJson({"error": "添加失败"}))
def saveDoc(request): dataJson = json.loads(_post(request, "data")) #先将信息添加到doc表中 add_doc = DocService.addDoc(dataJson) #在得到add_doc Id存到中间表中 if dataJson["their_product"] != '' and dataJson["their_product"] != None: product_id = dataJson["their_product"] DocService.addDocAndProduct(add_doc, product_id) if add_doc > 0: return HttpResponse(toJson({"state": "ok"})) else: return HttpResponse(toJson({"error": "添加失败"}))
def delAletrt(request): alert_id = _post(request, "alert_id") #先删除有关的中间表信息 AlertService.delModdinByAlertId(alert_id) #再删除alert表信息 delAlertRow = AlertService.delAlert(alert_id) respJson = {} if delAlertRow > 0: respJson["result"] = Resp.SUCCESS else: respJson["result"] = Resp.ERROR return HttpResponse(toJson(respJson))
def delSpare(request): spare_id = _post(request, "spare_id") #先删除有关的中间表信息 SpareService.delModdinBySpareId(spare_id) #再删除alert表信息 delSpareRow = SpareService.delSpare(spare_id) respJson = {} if delSpareRow > 0: respJson["result"] = Resp.SUCCESS else: respJson["result"] = Resp.ERROR return HttpResponse(toJson(respJson));
def delCurrentSystem(request): dataJson = json.loads(_post(request, "data")) respJson = {} product_id = dataJson.get("product_id") propertyId = CurrentSystemService.getPropertyById(product_id) delProductRow = CurrentSystemService.delProduct(product_id) if(delProductRow > 0): delPropertyRow = CurrentSystemService.delProperty(propertyId[0]['hsh_property_id']) if(delPropertyRow > 0): respJson["result"] = Resp.SUCCESS else: respJson["result"] = Resp.ERROR return HttpResponse(toJson(respJson));
def saveTip(request): dataJson = json.loads(_post(request, "data")) #先将信息添加到tip表中 addTipRow = TipService.addTip(dataJson) #在得到addTiptRow Id存到中间表中 if (dataJson.get("their_product") != '' and dataJson.get("their_product") != None): product_id = dataJson.get("their_product") TipService.addTipAndProduct(addTipRow, product_id) if addTipRow > 0: return HttpResponse(toJson({"state": "ok"})) else: return HttpResponse(toJson({"error": "添加失败"}))
def saveCurrentSystem(request): dataJson = json.loads(_post(request, "data")) #先添加产品属性表中 addPrpertyRow = CurrentSystemService.addPrperty(dataJson) #再获取上面添加到的id添加到产品表中 if(addPrpertyRow > 0): if(dataJson["product_id"]): addProductRow = CurrentSystemService.addProduct_update(dataJson, addPrpertyRow) else: addProductRow = CurrentSystemService.addProduct_insert(dataJson, addPrpertyRow) if addProductRow > 0: return HttpResponse(toJson({"state": "ok"})) else: return HttpResponse(toJson({"error": "添加失败"}))
def updateCurrentSystem(request): dataJson = json.loads(_post(request, "data")) #先根据product_id获取产品属性Id pid = CurrentSystemService.getPropertyIdByProductId(dataJson.get("product_id")) #先修改产品属性 property_id = pid[0]["hsh_property_id"] updatePropertyRow = CurrentSystemService.updateProperty(dataJson, property_id) if(updatePropertyRow > 0): updateProductRow = CurrentSystemService.updateProduct(dataJson) respJson = {} if updateProductRow > 0: respJson["result"] = Resp.SUCCESS else: respJson["result"] = Resp.ERROR return HttpResponse(toJson(respJson));
def updateDoc(request): dataJson = json.loads(_post(request, "data")) #先根据doc_id更新中间表的产品Id if dataJson["product_id"] != "": #判断中间表是否存在 if DocService.getModdByDocId(dataJson["doc_id"]): DocService.updateProductIdByDocId(dataJson["product_id"], dataJson["doc_id"]) else: #addDocAndProduct DocService.addDocAndProduct(dataJson["doc_id"], dataJson["product_id"]) else: DocService.delModdinByDocId(dataJson["doc_id"]) #再修改doc属性 updateDocRow = DocService.updateDoc(dataJson) respJson = {} if updateDocRow > 0: respJson["result"] = Resp.SUCCESS else: respJson["result"] = Resp.ERROR return HttpResponse(toJson(respJson));
def updateSpare(request): dataJson = json.loads(_post(request, "data")) #先根据spare_id更新中间表的产品Id if dataJson.get("their_product"): #判断中间表中是否存在 if SpareService.getModdBySpareId(dataJson.get("spare_id")): #update SpareService.updateProductIdBySpareId(dataJson.get("spare_id"), dataJson.get("their_product")) else: #add SpareService.addSpareAndProduct(dataJson.get("spare_id"), dataJson.get("their_product")) else: SpareService.delModdinBySpareId(dataJson.get("spare_id")) #再修改spare属性 updateSpareRow = SpareService.updateSpare(dataJson) respJson = {} if updateSpareRow > 0: respJson["result"] = Resp.SUCCESS else: respJson["result"] = Resp.ERROR return HttpResponse(toJson(respJson));
def updateTip(request): dataJson = json.loads(_post(request, "data")) #先根据tip_id更新中间表的产品Id if dataJson.get("product_id"): #判断中间表是否存在 if TipService.getModdByTipId(dataJson.get("tip_id")): #update TipService.updateProductIdByTipId(dataJson.get("tip_id"), dataJson.get("product_id")) else: #addaddTipAndProduct TipService.addTipAndProduct(dataJson.get("tip_id"), dataJson.get("product_id")) else: TipService.delModdinByTipId(dataJson.get("tip_id")) #再修改tip属性 updateTipRow = TipService.updateTip(dataJson) respJson = {} if updateTipRow > 0: respJson["result"] = Resp.SUCCESS else: respJson["result"] = Resp.ERROR return HttpResponse(toJson(respJson))
def updateAlert(request): dataJson = json.loads(_post(request, "data")) #先根据alert_id更新中间表的产品Id if dataJson.get("product_id"): #判断中间表是否存在 if AlertService.getModdByAlertId(dataJson.get("alert_id")): #update AlertService.updateProductIdByAlertId(dataJson.get("alert_id"), dataJson.get("product_id")) else: #addaddAlertAndProduct AlertService.addAlertAndProduct(dataJson.get("alert_id"), dataJson.get("product_id")) else: AlertService.delModdinByAlertId(dataJson.get("alert_id")) #再修改alert属性 updateAlertRow = AlertService.updateAlert(dataJson) respJson = {} if updateAlertRow > 0: respJson["result"] = Resp.SUCCESS else: respJson["result"] = Resp.ERROR return HttpResponse(toJson(respJson))
def getUpdateAlert(request): alert_id = _post(request, "alert_id") return HttpResponse(toJson(AlertService.getUpdateAlert(alert_id)))
def getUpdateSpare(request): spare_id = _post(request, "id") return HttpResponse(toJson(SpareService.getUpdateSpare(spare_id)))
def getSpareList(request): search_text = _post(request, "search_text") page = _post(request, "page") json = toJson(SpareService.getSpareList(search_text, page)) return HttpResponse(json)
def getUpdateDoc(request): doc_id = _post(request, "doc_id") return HttpResponse(toJson(DocService.getUpdateDoc(doc_id)))
def selectCurrentSystemByProductName(request): product_name = _post(request, "product_name") json = toJson( CurrentService.selectCurrentSystemByProductName(product_name)) return HttpResponse(json)
def searchText(request): search_text = _post(request, "search_text") page = _post(request, "page") json = toJson(SearchService.search_text(search_text, page)) return HttpResponse(json)
def getUpdateTip(request): tip_id = _post(request, "tip_id") return HttpResponse(toJson(TipService.getUpdateTip(tip_id)))
def getProductById(request): product_id = _post(request, "product_id") return HttpResponse(toJson(CurrentSystemService.getProductById(product_id)))
def getEOLSystemList(request): search_text = _post(request, "search_text") page = _post(request, "page") json = toJson(CurrentSystemService.getEOLSystemList(search_text, page)) return HttpResponse(json)