def ManualDelete():
'''批记录模板删除'''
if request.method == 'POST':
data = request.values # 返回请求中的参数和form
try:
jsonstr = json.dumps(data.to_dict())
if len(jsonstr) > 10:
jsonnumber = re.findall(r"\d+\.?\d*", jsonstr)
for key in jsonnumber:
id = int(key)
try:
oclass = db_session.query(BatchModel).filter(
BatchModel.ID == id).first()
if oclass:
db_session.delete(oclass)
os.remove(oclass.FilePath)
except Exception as ee:
db_session.rollback()
print(ee)
logger.error(ee)
return json.dumps({
"code": "500",
"message": "批记录模板删除报错"
})
db_session.commit()
return json.dumps({"code": "200", "message": "删除成功！"})
else:
return json.dumps({"code": "200", "message": "id为空！"})
except Exception as e:
print(e)
logger.error(e)
insertSyslog("error", "路由：/ManualDelete，说明书删除Error：" + str(e),
current_user.Name)
return json.dumps({"code": "500", "message": "批记录模板删除报错"})
def PermissionsSave():
if request.method == 'POST':
data = request.values
try:
datastr = json.loads(data.get("data"))
#删除之前的权限
perss = db_session.query(Permission).filter(
Permission.WorkNumber == datastr[0].get("WorkNumber")).all()
for pe in perss:
db_session.delete(pe)
db_session.commit()
for i in datastr:
per = Permission()
per.MenuName = i.get("MenuName")
per.MenuType = i.get("MenuType")
per.MenuCode = i.get("MenuCode")
per.Name = i.get("Name")
per.WorkNumber = i.get("WorkNumber")
db_session.add(per)
db_session.commit()
return 'OK'
except Exception as e:
db_session.rollback()
print(e)
logger.error(e)
insertSyslog("error", "添加用户报错Error：" + str(e), current_user.Name)
return json.dumps([{
"status": "Error:" + str(e)
}],
cls=AlchemyEncoder,
ensure_ascii=False)
def delete_role():
rid = request.headers.get('rid')
role = db_session.query(Role).filter(Role.ID == rid).first()
user_query = db_session.query(RoleUser).filter(
RoleUser.RoleName == role.RoleName).all()
for item in user_query:
db_session.delete(item)
db_session.delete(role)
db_session.commit()
return json.dumps({'code': 10004, 'msg': '删除成功'})
def delete_department():
code = request.headers.get('department_code')
department = db_session.query(DepartmentManager).filter(
DepartmentManager.DepartCode == code).first()
role_query = db_session.query(Role).filter(
Role.ParentNode == department.DepartCode).all()
for item in role_query:
item.ParentNode = ''
db_session.commit()
user_query = db_session.query(User).filter(
User.OrganizationName == department.DepartName).all()
for item in user_query:
item.OrganizationName = ''
db_session.commit()
db_session.delete(department)
db_session.commit()
return json.dumps({'code': 10001, 'msg': '删除成功'})
def batchmodelinsert():
'''批记录模板名称路径储存'''
if request.method == 'POST':
data = request.values
try:
BrandName = data.get("BrandName")
PUCode = data.get("PUCode")
BrandCode = data.get("BrandCode")
PUIDName = data.get("PUIDName")
FileName = data.get("FileName")
Parameter = data.get("Parameter")
#删除之前存的
oclass = db_session.query(BatchModel).filter(
BatchModel.PUCode == PUCode).all()
for oc in oclass:
db_session.delete(oc)
os.remove(oc.FilePath)
db_session.commit()
#新添加的
bm = BatchModel()
bm.BrandName = BrandName
bm.PUCode = PUCode
bm.BrandCode = BrandCode
bm.PUIDName = PUIDName
bm.FileName = FileName
bm.FilePath = os.path.join(
os.path.realpath(r"system_backend\SystemManagement\files"),
FileName)
bm.UserName = current_user.Name
bm.Parameter = Parameter
db_session.add(bm)
db_session.commit()
return json.dumps({"code": "200", "message": "上传成功！"})
except Exception as e:
db_session.rollback()
print(e)
logger.error(e)
insertSyslog("error", "批记录模板导入报错Error：" + str(e),
current_user.Name)
return json.dumps({"code": "500", "message": "后端报错"})
def taskSaveEqpCheck():
'''
设备审核（选择设备）
:return:
'''
if request.method == 'POST':
data = request.values
try:
ocalss = db_session.query(ZYPlan).filter(
ZYPlan.ID == data.get("ID")).first()
zytasks = db_session.query(ZYTask).filter(
ZYTask.BatchID == ocalss.BatchID,
ZYTask.BrandCode == ocalss.BrandCode,
ZYTask.PUCode == ocalss.PUCode).all()
for zy in zytasks:
db_session.delete(zy)
db_session.commit()
iTaskSeq = 0
if "提取" in ocalss.PUName:
bms = db_session.query(BatchMaterialInfo).filter(
BatchMaterialInfo.BatchID == ocalss.BatchID,
BatchMaterialInfo.BrandCode == ocalss.BrandCode).all()
for bm in bms:
iTaskSeq = iTaskSeq + 1
bReturn, strTaskNo = getTaskNo()
if bReturn == False:
return False
zytask = ZYTask()
zytask.PlanDate = datetime.datetime.now().strftime(
"%Y-%m-%d")
zytask.TaskID = strTaskNo
zytask.BatchID = ocalss.BatchID
zytask.PlanSeq = iTaskSeq
zytask.PUCode = ocalss.PUCode
zytask.PUName = ocalss.PUName
zytask.PlanType = Global.PLANTYPE.SCHEDULE.value
zytask.BrandCode = ocalss.BrandCode
zytask.BrandName = ocalss.BrandName
zytask.PlanQuantity = ocalss.PlanQuantity
zytask.Unit = ocalss.Unit
zytask.EnterTime = ""
zytask.EQPCode = bm.EQPCode
zytask.EQPName = bm.EQPName
zytask.PlanStartTime = ""
zytask.PlanEndTime = ""
zytask.TaskStatus = Global.TASKSTATUS.NEW.value
zytask.LockStatus = Global.TASKLOCKSTATUS.UNLOCK.value
db_session.add(zytask)
db_session.commit()
ocalss.ZYPlanStatus = Global.ZYPlanStatus.Produncting.value
db_session.commit()
else:
if data.get("EqpList") != None and data.get("EqpList") != "":
EqpList = json.loads(data.get("EqpList"))
for j in EqpList:
iTaskSeq = iTaskSeq + 1
bReturn, strTaskNo = getTaskNo()
if bReturn == False:
return False
zytask = ZYTask()
zytask.PlanDate = datetime.datetime.now().strftime(
"%Y-%m-%d")
zytask.TaskID = strTaskNo
zytask.BatchID = ocalss.BatchID
zytask.PlanSeq = iTaskSeq
zytask.PUCode = ocalss.PUCode
zytask.PUName = ocalss.PUName
zytask.PlanType = Global.PLANTYPE.SCHEDULE.value
zytask.BrandCode = ocalss.BrandCode
zytask.BrandName = ocalss.BrandName
zytask.PlanQuantity = ocalss.PlanQuantity
zytask.Unit = ocalss.Unit
zytask.EnterTime = ""
zytask.EQPCode = j.get("EQPCode")
zytask.EQPName = j.get("EQPName")
zytask.PlanStartTime = ""
zytask.PlanEndTime = ""
zytask.TaskStatus = Global.TASKSTATUS.NEW.value
zytask.LockStatus = Global.TASKLOCKSTATUS.UNLOCK.value
db_session.add(zytask)
db_session.commit()
insertAuditTrace(
"设备审核（选择设备）", "品名：" + ocalss.BrandName + " 批次：" +
ocalss.BatchID + "设备审核（选择设备）", "PlanManager",
current_user.Name, "")
return json.dumps({
"code": "200",
"message": "任务选择设备成功！",
"data": "OK"
})
except Exception as e:
db_session.rollback()
print(e)
logger.error(e)
insertSyslog("error", "设备审核（选择设备）报错Error：" + str(e),
current_user.Name)
return json.dumps("设备审核（选择设备）报错",
cls=AlchemyEncoder,
ensure_ascii=False)
def addEquipmentBatchRunTime():
'''
生产配置添加设备
:return:
'''
if request.method == 'POST':
data = request.values
try:
ID = data.get('ID')
processList = json.loads(data.get('processList'))
oclass = db_session.query(PlanManager).filter(
PlanManager.ID == ID).first()
#清空之前保存的数据
delete_list = db_session.query(EquipmentBatchRunTime).filter(
EquipmentBatchRunTime.BrandCode == oclass.BrandCode,
EquipmentBatchRunTime.BatchID == oclass.BatchID).all()
for i in delete_list:
db_session.delete(i)
db_session.commit()
dir = {}
if oclass:
for pl in processList:
PUName = pl.get("PUName")
PUCode = pl.get("PUCode")
eqList = pl.get('eqList')
for el in eqList:
isSelected = el.get("isSelected")
if isSelected == True: #选中过的设备
ert = EquipmentBatchRunTime()
ert.BatchID = oclass.BatchID
ert.BrandCode = oclass.BrandCode
ert.BrandName = oclass.BrandName
ert.EQPCode = el.get("EQPCode")
ert.EQPName = el.get("EQPName")
ert.PUCode = PUCode
ert.PUName = PUName
ert.StartBC = el.get("StartBC")
ert.EndBC = el.get("EndBC")
sft = db_session.query(Shifts).filter(
Shifts.ShiftsName == ert.StartBC).first()
ert.StartTime = str(
el.get("StartTime")) + " " + sft.BeginTime
eft = db_session.query(Shifts).filter(
Shifts.ShiftsName == ert.EndBC).first()
if eft.ShiftsName == "中" or eft.ShiftsName == "晚":
endt = (datetime.datetime.strptime(
el.get("EndTime"), "%Y-%m-%d") +
datetime.timedelta(hours=24)
).strftime("%Y-%m-%d")
else:
endt = el.get("EndTime")
ert.EndTime = str(endt) + " " + eft.EndTime
db_session.add(ert)
oclass.PlanStatus = Global.PlanStatus.WaitRealse.value
db_session.commit()
insertAuditTrace(
"生产配置添加设备",
"批次号是：" + oclass.BatchID + "的" + oclass.BrandName + "在" +
datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S') +
"进行生产配置添加设备操作", "PlanManager", current_user.Name, "")
return json.dumps({
"code": "200",
"message": "保存成功！",
"data": "OK"
})
except Exception as e:
db_session.rollback()
print(e)
logger.error(e)
insertSyslog("error", "生产配置添加设备报错Error：" + str(e),
current_user.Name)
return json.dumps("生产配置添加设备报错",
cls=AlchemyEncoder,
ensure_ascii=False)