def put(self): # 取POST Form提交的数据 alldata = self.getRequestData() inst = entity.Meun_ag_manage(self.db) #先删除所有 inst.remove(alldata['menu_group_id'],table="system.menu_authority_relation_group",key='menu_group_id',delete=True) #再循环插入 #if not alldata['items']: # raise BaseError(801) ids=0 for menu_item_id in alldata['items']: lstData = { 'menu_group_id':alldata['menu_group_id'], 'create_id':alldata['create_id'], 'create_time':time.strftime("%Y-%m-%d %H:%M:%S",time.localtime(time.time())), 'menu_item_id':menu_item_id } id = inst.save(lstData,table='system.menu_authority_relation_group') if id <= 0: raise BaseError(703) #参数错误 ids+=1 cur=self.db.getCursor() cur.execute("select name from SYSTEM.MENU_AUTHORITY_GROUP where id=%s"%alldata['menu_group_id']) rows = cur.fetchall() oc=rows[0][0] if not self.objUserInfo : raise BaseError(604) name = self.objUserInfo['name'] #msg=Message(self.db) #msg.addMsg(alldata['hospital_code'], alldata['hospital_code'], "%s修改了一个菜单权限组的菜单权限:%s"%(name,oc)) operation_log(self.db).addLog(alldata['create_id'],alldata['hospital_code'],'menus_aut_group_manage',"修改了一个菜单权限组的菜单权限:%s"%oc,alldata['menu_group_id']) self.response(ids)
def put(self): # 取POST Form提交的数据 alldata = self.getRequestData() inst = entity.Menuadmin(self.db) #先删除所有 inst.remove(alldata['user_id'], table="system.menu_authority_group_relation", key='user_id', delete=True) #再循环插入 #if not alldata['groups']: # raise BaseError(801) ids = 0 for group_id in alldata['groups']: lstData = { 'group_id': group_id, 'create_time': time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(time.time())), 'user_id': alldata['user_id'], 'create_id': alldata['update_id'] } id = inst.save(lstData, table='system.menu_authority_group_relation') if id <= 0: raise BaseError(703) #参数错误 ids += 1 operation_log( self.db).addLog(alldata['update_id'], alldata['hospital_code'], 'menus_aut_group_manage', "给用户授予菜单权限组", alldata['user_id']) #'menus_aut_user_group' self.response(ids)
def delete(self): alldata = self.getRequestData() e = itemEntity.MenuItem(self.db) r = e.remove(alldata['id'], delete=True) operation_log(self.db).addLog(alldata['uid'], alldata['hospital_code'], 'edit_menu_item', "删除菜单项", alldata['id']) self.response(r)
def post(self): # 取POST Form提交的数据 alldata = self.getRequestData() inst = entity.Menuadmin(self.db) user = self.objUserInfo['name'] #先删除所有 inst.remove(alldata['user_id'],table="system.menu_authority_relation",key='user_id',delete=True) #再循环插入 #if not alldata['items']: # raise BaseError(801) ids=0 for menu_item_id in alldata['items']: lstData = { 'menu_item_id':menu_item_id, 'create_time':time.strftime("%Y-%m-%d %H:%M:%S",time.localtime(time.time())), 'user_id':alldata['user_id'], 'create_id':alldata['create_id'] } id = inst.save(lstData,table='system.menu_authority_relation') if id <= 0: raise BaseError(703) #参数错误 ids+=1 cur=self.db.getCursor() cur.execute("select name from public.account where id=%s"%alldata['user_id']) rows = cur.fetchall() oc=rows[0][0] operation_log(self.db).addLog(alldata['create_id'],alldata['hospital_code'],'menus_aut_user',"%s给用户%s授予菜单权限"%(user,oc),alldata['user_id']) #msg=Message(self.db) #msg.addMsg(alldata['hospital_code'], alldata['hospital_code'],"%s给用户%s授予菜单权限"%(user,oc)) self.response(ids)
def put(self): # 取POST Form提交的数据 alldata = self.getRequestData() inst = itemEntity.MenuItem(self.db) #先查看该菜单项类型是否存在 id = alldata['id'] cur = self.db.getCursor() cur.execute( "select id from system.menu_item where type=%s and menu_id=%s and id<>%s" % (alldata['type'], alldata['menu_id'], id)) if cur.fetchall(): raise BaseError(808) #以存在 rows = [] lstData = { 'menu_code': 'menu_code', 'update_id': 'update_id', 'update_time': 'update_time', 'menu_id': 'menu_id', 'type': 'type', 'path': 'path' } data = {} for (k, v) in lstData.items(): try: if k == 'menu_id' or k == 'type': if alldata[v] == "" or alldata[v] is None: raise BaseError(801) data[k] = alldata[v] elif k == "update_time": try: data[k] = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(time.time())) except Exception as ex: print(ex) elif k == "update_id": if alldata[v] is None: pass else: data[k] = alldata[v] else: data[k] = alldata[v] except: pass if data is None or data == {}: raise BaseError(801) #参数错误 id = inst.save(data, id, table='system.menu_item') if id <= 0: raise BaseError(703) #参数错误 operation_log(self.db).addLog(alldata['update_id'], alldata['hospital_code'], 'edit_menu_item', "修改菜单项:" + alldata['menu_code'], alldata['id']) self.response(id)
def delete(self): alldata = self.getRequestData() e = entity.Menuadmin(self.db) r=e.remove(alldata['id'],delete=True) #删除下一级菜单 e.remove(alldata['id'],key='parent_id',delete=True) if r<=0: raise BaseError(703) operation_log(self.db).addLog(alldata['uid'],alldata['hospital_code'],'edit_menu',"删除菜单",alldata['id']) self.response(r)
def delete(self): alldata = self.getRequestData() e = entity.Menuadmin(self.db) r = e.remove(alldata['id'], delete=True) #删除下一级菜单 e.remove(alldata['id'], key='parent_id', delete=True) if r <= 0: raise BaseError(703) operation_log(self.db).addLog(alldata['uid'], alldata['hospital_code'], 'edit_menu', "删除菜单", alldata['id']) self.response(r)
def put(self): # 取POST Form提交的数据 alldata = self.getRequestData() inst = entity.Menuadmin(self.db) #先查看code是否存在 id = alldata['id'] cur = self.db.getCursor() cur.execute("select id from system.menu where code='%s' and id<>%s" % (alldata['code'], id)) if cur.fetchall(): raise BaseError(807) #code以存在 rows = [] lstData = { 'code': 'code', 'name': 'name', 'sort': 'sort', 'tier': 'tier', 'parent_id': 'parent_id', 'parent_code': 'parent_code', 'update_id': 'update_id', 'update_time': 'update_time' } data = {} for (k, v) in lstData.items(): try: if k == 'code' or k == 'name': if alldata[v] == "" or alldata[v] is None: raise BaseError(801) data[k] = alldata[v] elif k == "update_time": try: data[k] = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(time.time())) except Exception as ex: print(ex) elif k == "update_id" or k == "parent_id" or k == "parent_code": if alldata[v] is None: pass else: data[k] = alldata[v] else: data[k] = alldata[v] except: pass if data is None or data == {}: raise BaseError(801) #参数错误 id = inst.save(data, id, table='system.menu') if id <= 0: raise BaseError(703) #参数错误 operation_log(self.db).addLog(alldata['update_id'], alldata['hospital_code'], 'edit_menu', "修改菜单:" + alldata['name'], alldata['id']) self.response(id)
def put(self): # 取POST Form提交的数据 alldata = self.getRequestData() inst = entity.Menuadmin(self.db) #先查看code是否存在 id=alldata['id'] cur=self.db.getCursor() cur.execute("select id from system.menu where code='%s' and id<>%s"% (alldata['code'],id)) if cur.fetchall(): raise BaseError(807) #code以存在 rows = [] lstData = { 'code':'code', 'name':'name', 'sort':'sort', 'tier':'tier', 'parent_id':'parent_id', 'parent_code':'parent_code', 'update_id':'update_id', 'update_time':'update_time' } data = {} for (k, v) in lstData.items(): try: if k == 'code' or k == 'name': if alldata[v]=="" or alldata[v] is None: raise BaseError(801) data[k] = alldata[v] elif k=="update_time": try: data[k]=time.strftime("%Y-%m-%d %H:%M:%S",time.localtime(time.time())) except Exception as ex: print(ex) elif k=="update_id" or k=="parent_id" or k=="parent_code": if alldata[v] is None: pass else : data[k] = alldata[v] else : data[k] = alldata[v] except: pass if data is None or data == {}: raise BaseError(801) #参数错误 id = inst.save(data,id, table='system.menu') if id <= 0: raise BaseError(703) #参数错误 operation_log(self.db).addLog(alldata['update_id'],alldata['hospital_code'],'edit_menu',"修改菜单:"+alldata['name'],alldata['id']) self.response(id)
def put(self): # 取POST Form提交的数据 alldata = self.getRequestData() inst = itemEntity.MenuItem(self.db) #先查看该菜单项类型是否存在 id=alldata['id'] cur=self.db.getCursor() cur.execute("select id from system.menu_item where type=%s and menu_id=%s and id<>%s"% (alldata['type'],alldata['menu_id'],id)) if cur.fetchall(): raise BaseError(808) #以存在 rows = [] lstData = { 'menu_code':'menu_code', 'update_id':'update_id', 'update_time':'update_time', 'menu_id':'menu_id', 'type':'type', 'path':'path' } data = {} for (k, v) in lstData.items(): try: if k == 'menu_id' or k == 'type': if alldata[v]=="" or alldata[v] is None: raise BaseError(801) data[k] = alldata[v] elif k=="update_time": try: data[k]=time.strftime("%Y-%m-%d %H:%M:%S",time.localtime(time.time())) except Exception as ex: print(ex) elif k=="update_id": if alldata[v] is None: pass else : data[k] = alldata[v] else : data[k] = alldata[v] except: pass if data is None or data == {}: raise BaseError(801) #参数错误 id = inst.save(data,id,table='system.menu_item') if id <= 0: raise BaseError(703) #参数错误 operation_log(self.db).addLog(alldata['update_id'],alldata['hospital_code'],'edit_menu_item',"修改菜单项:"+alldata['menu_code'],alldata['id']) self.response(id)
def put(self): # 取POST Form提交的数据 alldata = self.getRequestData() inst = entity.Meun_ag_manage(self.db) #先删除所有 inst.remove(alldata['menu_group_id'], table="system.menu_authority_relation_group", key='menu_group_id', delete=True) #再循环插入 #if not alldata['items']: # raise BaseError(801) ids = 0 for menu_item_id in alldata['items']: lstData = { 'menu_group_id': alldata['menu_group_id'], 'create_id': alldata['create_id'], 'create_time': time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(time.time())), 'menu_item_id': menu_item_id } id = inst.save(lstData, table='system.menu_authority_relation_group') if id <= 0: raise BaseError(703) #参数错误 ids += 1 cur = self.db.getCursor() cur.execute( "select name from SYSTEM.MENU_AUTHORITY_GROUP where id=%s" % alldata['menu_group_id']) rows = cur.fetchall() oc = rows[0][0] if not self.objUserInfo: raise BaseError(604) name = self.objUserInfo['name'] #msg=Message(self.db) #msg.addMsg(alldata['hospital_code'], alldata['hospital_code'], "%s修改了一个菜单权限组的菜单权限:%s"%(name,oc)) operation_log(self.db).addLog(alldata['create_id'], alldata['hospital_code'], 'menus_aut_group_manage', "修改了一个菜单权限组的菜单权限:%s" % oc, alldata['menu_group_id']) self.response(ids)
def delete(self): objdata = self.getRequestData() s = entity.Meun_ag_manage(self.db) cur=self.db.getCursor() cur.execute("select name from SYSTEM.MENU_AUTHORITY_GROUP where id=%s"%objdata['id']) rows = cur.fetchall() oc=rows[0][0] r=s.remove(objdata['id'],delete=True) s.remove(objdata['id'],table="system.menu_authority_relation_group",key="menu_group_id",delete=True) s.remove(objdata['id'],table="system.menu_authority_group_relation",key="group_id",delete=True) if not self.objUserInfo : raise BaseError(604) name = self.objUserInfo['name'] #msg=Message(self.db) #msg.addMsg(objdata['hospital_code'], objdata['hospital_code'], "%s删除了一个菜单权限组:%s"%(name,oc)) operation_log(self.db).addLog(objdata['uid'],objdata['hospital_code'],'menus_aut_group_manage',"删除了一个菜单权限组:%s"%oc,objdata['id']) self.response(r)
def post(self): # 取POST Form提交的数据 objdata = self.getRequestData() s = entity.Meun_ag_manage(self.db) cur=self.db.getCursor() cur.execute("select count('id') from system.menu_authority_group where name='%s' and hospital_code='%s'" %(objdata['name'],objdata['hospital_code'])) rows = cur.fetchall() su=rows[0][0] if su: raise BaseError(891) lstData = { 'create_id':'create_id', 'name':'name', 'create_time':'create_time', 'hospital_code':'hospital_code' } data = {} for (k, v) in lstData.items(): try: if k == 'hospital_code' or k == 'name': if objdata[v]=="" or objdata[v] is None: raise BaseError(801) data[k] = objdata[v] elif k=="create_time": try: data[k]=time.strftime("%Y-%m-%d %H:%M:%S",time.localtime(time.time())) except Exception as ex: print(ex) else : data[k]=objdata[v] except: pass if data is None or data == {}: raise BaseError(801) #参数错误 id =s.save(data,table='system.menu_authority_group') if id <= 0: raise BaseError(703) #参数错误 if not self.objUserInfo : raise BaseError(604) name = self.objUserInfo['name'] #msg=Message(self.db) #msg.addMsg(objdata['hospital_code'], objdata['hospital_code'], "%s新增了一个菜单权限组:%s"%(name,objdata['name'])) operation_log(self.db).addLog(objdata['create_id'],objdata['hospital_code'],'menus_aut_group_manage',"新增了一个菜单权限组:%s"%objdata['name'],id) self.response(id)
def post(self): # 取POST Form提交的数据 alldata = self.getRequestData() inst = entity.Menuadmin(self.db) user = self.objUserInfo['name'] #先删除所有 inst.remove(alldata['user_id'], table="system.menu_authority_relation", key='user_id', delete=True) #再循环插入 #if not alldata['items']: # raise BaseError(801) ids = 0 for menu_item_id in alldata['items']: lstData = { 'menu_item_id': menu_item_id, 'create_time': time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(time.time())), 'user_id': alldata['user_id'], 'create_id': alldata['create_id'] } id = inst.save(lstData, table='system.menu_authority_relation') if id <= 0: raise BaseError(703) #参数错误 ids += 1 cur = self.db.getCursor() cur.execute("select name from public.account where id=%s" % alldata['user_id']) rows = cur.fetchall() oc = rows[0][0] operation_log(self.db).addLog(alldata['create_id'], alldata['hospital_code'], 'menus_aut_user', "%s给用户%s授予菜单权限" % (user, oc), alldata['user_id']) #msg=Message(self.db) #msg.addMsg(alldata['hospital_code'], alldata['hospital_code'],"%s给用户%s授予菜单权限"%(user,oc)) self.response(ids)
def delete(self): cur=self.db.getCursor() alldata = self.getRequestData() sql="delete from public.doctor a where a.id=%s " % (alldata['doctor_id']) #print ("delete"+sql) cur.execute(sql) #sql="select a.name from public.hospital_account a where a.id=%s " % (alldata['update_person_id']) cur.execute(sql) row = cur.fetchone() log_str=":删除了医生%s的信息" % (alldata['doctor_name']) log_str1="%s删除了医生%s的信息" % (row[0],alldata['doctor_name']) operation_log(self.db).addLog(alldata['update_person_id'],alldata['hospital_code'],'Doctor',log_str1,103) msg=Message(self.db) msg.addMsg(alldata['hospital_code'], alldata['hospital_code'], log_str1); self.response("Operation OK")
def put(self): # 取POST Form提交的数据 objdata = self.getRequestData() s = entity.Meun_ag_manage(self.db) lstData = { 'update_id':'update_id', 'name':'name', 'update_time':'update_time' } data = {} for (k, v) in lstData.items(): try: if k == 'update_id' or k == 'name': if objdata[v]=="" or objdata[v] is None: raise BaseError(801) data[k] = objdata[v] elif k=="update_time": try: data[k]=time.strftime("%Y-%m-%d %H:%M:%S",time.localtime(time.time())) except Exception as ex: print(ex) else : data[k] = objdata[v] except: pass if data is None or data == {}: raise BaseError(801) #参数错误 id =s.save(data,objdata['id'],table='system.menu_authority_group') if id <= 0: raise BaseError(703) #参数错误 if not self.objUserInfo : raise BaseError(604) name = self.objUserInfo['name'] #msg=Message(self.db) #msg.addMsg(objdata['hospital_code'], objdata['hospital_code'], "%s新增了一个菜单权限组:%s"%(name,objdata['name'])) operation_log(self.db).addLog(objdata['update_id'],objdata['hospital_code'],'menus_aut_group_manage',"修改了一个菜单权限组:%s"%objdata['name'],objdata['id']) self.response(id)
def delete(self): cur = self.db.getCursor() alldata = self.getRequestData() sql = "delete from public.doctor a where a.id=%s " % ( alldata['doctor_id']) #print ("delete"+sql) cur.execute(sql) #sql="select a.name from public.hospital_account a where a.id=%s " % (alldata['update_person_id']) cur.execute(sql) row = cur.fetchone() log_str = ":删除了医生%s的信息" % (alldata['doctor_name']) log_str1 = "%s删除了医生%s的信息" % (row[0], alldata['doctor_name']) operation_log(self.db).addLog(alldata['update_person_id'], alldata['hospital_code'], 'Doctor', log_str1, 103) msg = Message(self.db) msg.addMsg(alldata['hospital_code'], alldata['hospital_code'], log_str1) self.response("Operation OK")
def put(self): mtime = datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S') mtype = self.get_argument('type', default='') upload = self.get_argument('upload', default='') name = self.get_argument('name', default='') dept_id = self.get_argument('dept_id', default='') account_id = self.get_argument('account_id', default='') his_id = self.get_argument('his_id', default='') title_id = self.get_argument('title_id', default='') post_id = self.get_argument('post_id', default='') update_person_id = self.get_argument('update_person_id', default='') hospital_code = self.get_argument('hospital_code', default='') introduce = self.get_argument('introduce', default='') phone = self.get_argument('phone', default='') doc_id = self.get_argument('doc_id', default='') cur = self.db.getCursor() upload_path = self.getUploadPath() if (mtype == "modify"): sql = "update public.doctor set name='%s',dept_id=%s,account_id='%s',his_id=%s,title='%s',post='%s',update_time='%s',update_id=%s ,hospital_code='%s',introduce='%s',phone='%s' where id=%s " % ( name, dept_id, account_id, his_id, title_id, post_id, mtime, update_person_id, hospital_code, introduce, phone, doc_id) cur.execute(sql) #sql="select a.name from public.hospital_account a where a.id=%s " % (update_person_id) cur.execute(sql) row = cur.fetchone() log_str1 = "%s修改了医生%s的信息" % (row[0], name) operation_log(self.db).addLog(update_person_id, hospital_code, 'Doctor', log_str1, 101) msg = Message(self.db) msg.addMsg(hospital_code, hospital_code, log_str1) if (int(upload) == 1): file_metas = self.request.files['file'] data = {} file_id = 0 for meta in file_metas: filename = meta['filename'] if len(meta['body']) > 4194304: #文件大于4M则不允许上传 data['code'] = 1 data['message'] = "文件大于4M则不允许上传" else: timeStamp = int(time.time()) fname = str(timeStamp) + '.' + filename.split( '.').pop() #生成新的文件名 filepath = os.path.join(upload_path, fname) #有些文件需要已二进制的形式存储,实际中可以更改 with open(filepath, 'wb') as up: up.write(meta['body']) data['code'] = 0 data['message'] = "文件上传成功" sql = "insert into public.file (create_time,create_id,file_name,path) values ('%s', %s,'%s','%s') " % ( mtime, update_person_id, fname, filepath) cur.execute(sql) sql = "select max(a.id) from public.file a where a.create_time='%s' and a.file_name='%s' " % ( mtime, fname) cur.execute(sql) row = cur.fetchone() file_id = row[0] sql = "update public.doctor set photo_file=%s where id=%s " % ( file_id, doc_id) #print (sql) cur.execute(sql) self.response("Modify Operation OK")
def put(self): mtime=datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S') mtype=self.get_argument('type', default='') upload=self.get_argument('upload', default='') name=self.get_argument('name', default='') dept_id=self.get_argument('dept_id', default='') account_id=self.get_argument('account_id', default='') his_id=self.get_argument('his_id', default='') title_id=self.get_argument('title_id', default='') post_id=self.get_argument('post_id', default='') update_person_id=self.get_argument('update_person_id', default='') hospital_code=self.get_argument('hospital_code', default='') introduce=self.get_argument('introduce', default='') phone=self.get_argument('phone', default='') doc_id=self.get_argument('doc_id', default='') cur=self.db.getCursor() upload_path=self.getUploadPath() if(mtype=="modify"): sql="update public.doctor set name='%s',dept_id=%s,account_id='%s',his_id=%s,title='%s',post='%s',update_time='%s',update_id=%s ,hospital_code='%s',introduce='%s',phone='%s' where id=%s " %( name,dept_id,account_id,his_id,title_id,post_id,mtime,update_person_id,hospital_code,introduce,phone,doc_id) cur.execute(sql) #sql="select a.name from public.hospital_account a where a.id=%s " % (update_person_id) cur.execute(sql) row = cur.fetchone() log_str1="%s修改了医生%s的信息" % (row[0],name) operation_log(self.db).addLog(update_person_id,hospital_code,'Doctor',log_str1,101) msg=Message(self.db) msg.addMsg(hospital_code,hospital_code,log_str1); if(int(upload)==1): file_metas=self.request.files['file'] data={} file_id=0 for meta in file_metas: filename=meta['filename'] if len(meta['body'])>4194304:#文件大于4M则不允许上传 data['code']=1 data['message']="文件大于4M则不允许上传" else: timeStamp = int(time.time()) fname=str(timeStamp)+'.'+filename.split('.').pop()#生成新的文件名 filepath=os.path.join(upload_path,fname) #有些文件需要已二进制的形式存储,实际中可以更改 with open(filepath,'wb') as up: up.write(meta['body']) data['code']=0 data['message']="文件上传成功" sql="insert into public.file (create_time,create_id,file_name,path) values ('%s', %s,'%s','%s') " %( mtime,update_person_id,fname,filepath) cur.execute(sql) sql="select max(a.id) from public.file a where a.create_time='%s' and a.file_name='%s' " % (mtime,fname) cur.execute(sql) row = cur.fetchone() file_id=row[0] sql="update public.doctor set photo_file=%s where id=%s " %(file_id,doc_id) #print (sql) cur.execute(sql) self.response("Modify Operation OK")
def delete(self): alldata = self.getRequestData() e = itemEntity.MenuItem(self.db) r=e.remove(alldata['id'],delete=True) operation_log(self.db).addLog(alldata['uid'],alldata['hospital_code'],'edit_menu_item',"删除菜单项",alldata['id']) self.response(r)