def get(self):
s=entity.Meun_ag_manage(self.db)
autname=self.get_argument("search", default='')
offset = int(self.get_argument("o",default='1'))
rowcount = int(self.get_argument("r",default='10'))
code=self.get_argument("code",default='')
offset=(offset-1)*rowcount
sql1=""
if autname:
sql1=" and a.name like '%"+autname+"%'"
else:
pass
sql="select a.id,a.name,b.name create_name,c.name hospital_name,a.create_time from "
sql+="system.menu_authority_group a left join public.account b on a.create_id=b.id, public.hospital_info c "
sql+="where c.code='%s' and b.status='0' and a.hospital_code=c.code %s order by a.create_time desc LIMIT %s OFFSET %s"%(code,sql1,rowcount,offset)
cur=self.db.getCursor()
cur.execute(sql)
rows = cur.fetchall()
rowdata={}
#rowdata=s.find(cond,table='system.menu_authority_group a left join public.hospital_account b on a.create_id=b.id, public.hospital_info c')
rowdata['struct']="id,name,create_name,hospital_name,create_time"
rowdata['rows']=rows
sql="select count(*) from system.menu_authority_group a left join public.account b on a.create_id=b.id, public.hospital_info c "
sql+="where c.code='%s' and a.hospital_code=c.code %s"%(code,sql1)
cur.execute(sql)
row = cur.fetchone()
rowdata['count']=row[0]
self.response(rowdata)
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 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 get(self):
s = entity.Meun_ag_manage(self.db)
gid = self.get_argument("id", default='')
hospital_code = self.get_argument("hospital_code", default='')
ctype = self.choosetype(hospital_code)
#print(ctype)
#'''
cur = self.db.getCursor()
cur.execute(
'select id,code,name,sort from "system".menu where tier=0 order by sort'
)
#cur.execute('select m.id,m.code,m.name,m.sort from (select m1.id,m1.code,m1.name,m1.tier,m1.sort from "system".menu m1 left join '
# '"system".menu m2 on m1.parent_id=m2."id") m where m.tier=0 order by m.sort')
rows = cur.fetchall()
#将所有元组转为对象,因为前台tree组件无法加载元组类型
li = self.tupleToList(rows)
for obj in li:
cur.execute(
'select id,code,name,sort from "system".menu where tier=1 and parent_id=%s order by sort'
% (obj['id']))
#cur.execute('select m.id,m.code,m.name,m.sort from (select m1.id,m1.code,m1.name,m1.tier,m1.sort ,m1.parent_id from "system".menu m1 left join '
# '"system".menu m2 on m1.parent_id=m2."id") m where m.tier=1 and m.parent_id=%s order by m.sort'% (obj['id']))
rows = cur.fetchall()
obj['children'] = self.tupleToList(rows)
#三级菜单
for thobj in obj['children']:
cur.execute(
'select id, type from "system".menu_item where menu_id=%s and type in(%s)'
% (thobj['id'], ctype))
rows = cur.fetchall()
thobj['children'] = self.tupleToList2(rows)
cur.execute(
"select menu_item_id from system.menu_authority_relation_group where menu_group_id=%s"
% gid)
rows = cur.fetchall()
#print(rows)
for obj in li:
for thobj in obj['children']:
for foobj in thobj['children']:
for k in rows: #判断第3层的checked
if foobj['id'] == k[0]:
foobj['checked'] = True
break
else:
foobj['checked'] = False
de = []
for obj in li:
for thobj in obj['children']:
if thobj['children'] == []:
de.append(thobj)
#print(de)
for i in de:
for obj in li:
try:
obj['children'].remove(i)
except:
pass
#确定二级菜单的'checked'，把三级菜单的id放入二级菜单。
for obj in li:
for thobj in obj['children']:
for foobj in thobj['children']:
thobj['checked'] = foobj['checked']
thobj['id'] = foobj['id']
thobj['chkDisabled'] = False
#删除三级菜单
for obj in li:
for thobj in obj['children']:
thobj.pop('children')
self.response(li)