from PDAPI import * __metadata__ = { "methods": ["POST"], "blueprint": "GERP", "permission": 3.0, "attributes": [], "limit": "1 per second", "form": [ {"Name": "DepartmentUUID", "Type": "UUID"}, {"Name": "UserUUID", "Type": "MUUID"}, ] } def HandleRequest(): SMTM: GERPSMTM DepartmentUUID = Get16toBytes(flask.request.form.get("DepartmentUUID")) UserUUID = Get16toBytes(flask.request.form.get("UserUUID")) if not GERPDepartment.query.filter(GERPDepartment.DepartmentUUID == DepartmentUUID).first(): return {"code": 1, "msg": "部门 不存在"} if not (SMTM := GERPSMTM.query.filter(sqlalchemy.and_(GERPSMTM.DepartmentUUID == DepartmentUUID, GERPSMTM.UserUUID == UserUUID)).first()): return {"code": 1, "msg": "目标用户 不存在 目标 SMTM 记录"} SMTM.PersonInChargeStatus = 1 try: db.session.add(SMTM) GERPSMTM.query.filter( sqlalchemy.and_(GERPSMTM.DepartmentUUID == DepartmentUUID, GERPSMTM.UserUUID != UserUUID) ).update( {"PersonInChargeStatus": 0}, synchronize_session="fetch" ) db.session.commit() return {"code": 0, "msg": "删除成功"} except: return {"code": 1, "msg": "SQL 提交失败"}