def tomenu():
try:
menuid= request.query.get('menuid')
channelids = request.query.get('channelids')
flag=False
for cid in channelids.split('_'):
if cid != '':
select_sql = "select count(*) from gkgp_cms_menu where parent=%s and path=%s"
res = db.query_one(select_sql,(menuid,'/channel/gotochannel?cid='+cid))
if res[0]>0:
flag=True
continue
# delete_sql = "delete from gkgp_cms_menu where parent=%s and path=%s"
# db.update(delete_sql,(menuid,'/channel/gotochannel?cid='+cid))
insert_sql = "insert into gkgp_cms_menu (menuname,path,parent) values(%s,%s,%s)"
cname = getchannelnamebyid(cid)
db.update(insert_sql,(cname,'/channel/gotochannel?cid='+cid,menuid))
if flag :
return "exist"
else:
return 'ok'
except Exception,data:
traceback.print_exc()
return 'error'
def tomenu():
try:
menuid= request.query.get('menuid')
channelids = request.query.get('channelids')
for cid in channelids.split('_'):
if cid != '':
delete_sql = "delete from HNSJ_TDCMS_MENU where parent=%s and path=%s"
db.update(delete_sql,(menuid,'/chanel/gotochannel?cid='+cid))
insert_sql = "insert into HNSJ_TDCMS_MENU (menuname,path,parent) values(%s,%s,%s)"
cname = getchannelnamebyid(cid)
db.update(insert_sql,(cname,'/channel/gotochannel?cid='+cid,menuid))
return 'ok'
except Exception,data:
traceback.print_exc()
return 'error'