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 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 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 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 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 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 wrapper(request, *args, **kwargs):
try:
user = getSession(request, "user")
agent = str(request.META.get('HTTP_USER_AGENT', None))
if indexOf(agent, "MSIE") >= 0 or indexOf(agent, "rv:") != -1:
return HttpResponse(toJson('请您勿使用IE浏览器访问!(推荐使用谷歌、火狐浏览器)'))
if (user == '' or user == None):
return render(request, 'HSH_PROJECT/view/login.html')
except:
print(sys.exc_info())
return render(request, 'HSH_PROJECT/view/login.html')
return func(request, *args, **kwargs)
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 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 getTheirProductList(request):
return HttpResponse(toJson(AlertService.getTheirProductList()))
def getProductById(request):
product_id = _post(request, "product_id")
return HttpResponse(toJson(CurrentSystemService.getProductById(product_id)))
def getUpdateSpare(request):
spare_id = _post(request, "id")
return HttpResponse(toJson(SpareService.getUpdateSpare(spare_id)))
def getSpareTypeList(request):
return HttpResponse(toJson(SpareService.getSpareTypeList()))
def getSpareList(request):
search_text = _post(request, "search_text")
page = _post(request, "page")
json = toJson(SpareService.getSpareList(search_text, page))
return HttpResponse(json)
def selectCurrentSystemByProductName(request):
product_name = _post(request, "product_name")
json = toJson(
CurrentService.selectCurrentSystemByProductName(product_name))
return HttpResponse(json)
def getEOLSystemList(request):
search_text = _post(request, "search_text")
page = _post(request, "page")
json = toJson(CurrentSystemService.getEOLSystemList(search_text, page))
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 getCurrentSystemProduct_EOL_1(request):
json = toJson(CurrentService.getCurrentSystemProduct_EOL_1())
return HttpResponse(json)
def getUpdateDoc(request):
doc_id = _post(request, "doc_id")
return HttpResponse(toJson(DocService.getUpdateDoc(doc_id)))
def getProductList(request):
return HttpResponse(toJson(DocService.getProductList()))
def getUpdateTip(request):
tip_id = _post(request, "tip_id")
return HttpResponse(toJson(TipService.getUpdateTip(tip_id)))
def getTheirProductTip(request):
return HttpResponse(toJson(TipService.getTheirProductTip()))
def getUpdateAlert(request):
alert_id = _post(request, "alert_id")
return HttpResponse(toJson(AlertService.getUpdateAlert(alert_id)))
