def delete_req(request):
if request.POST:
if 'delete' in request.POST or 'delete.x' in request.POST:
id = request.POST['id']
group = Group.objects.get(groupinstanceid=id)
delete_group(group)
return HttpResponseRedirect('.')
id = request.GET['id']
group = Group.objects.get(groupinstanceid=id)
where = [
'groupmembers.memberaccid = users.mcid',
'groupmembers.groupinstanceid = groupinstances.groupinstanceid',
'groupinstances.groupinstanceid = %s' % id
]
users = User.objects.extra(where=where,
tables=['groupmembers', 'groupinstances'])
return render_to_response(
'groups/delete.html', default_context(request,
group=group,
users=users))
def delete_user(mcid):
for ga in Groupadmin.objects.filter(adminaccid = mcid):
g = Group.objects.get(groupinstanceid = ga.groupinstanceid)
delete_group(g)
ga.delete()
sql_execute("DELETE FROM ccrlog WHERE accid = %s", mcid)
sql_execute("DELETE FROM todir WHERE accid = %s", mcid)
sql_execute("DELETE FROM groupmembers WHERE memberaccid = %s", mcid)
sql_execute("DELETE FROM document_type WHERE dt_account_id = %s", mcid)
sql_execute("DELETE FROM users WHERE mcid = %s", mcid)
def delete_user(mcid):
for ga in Groupadmin.objects.filter(adminaccid=mcid):
g = Group.objects.get(groupinstanceid=ga.groupinstanceid)
delete_group(g)
ga.delete()
sql_execute("DELETE FROM ccrlog WHERE accid = %s", mcid)
sql_execute("DELETE FROM todir WHERE accid = %s", mcid)
sql_execute("DELETE FROM groupmembers WHERE memberaccid = %s", mcid)
sql_execute("DELETE FROM document_type WHERE dt_account_id = %s", mcid)
sql_execute("DELETE FROM users WHERE mcid = %s", mcid)
def delete_req(request):
if request.POST:
if 'delete' in request.POST or 'delete.x' in request.POST:
id = request.POST['id']
group = Group.objects.get(groupinstanceid = id)
delete_group(group)
return HttpResponseRedirect('.')
id = request.GET['id']
group = Group.objects.get(groupinstanceid=id)
where = ['groupmembers.memberaccid = users.mcid',
'groupmembers.groupinstanceid = groupinstances.groupinstanceid',
'groupinstances.groupinstanceid = %s' % id]
users = User.objects.extra(where=where,
tables = ['groupmembers', 'groupinstances'])
return render_to_response('groups/delete.html',
default_context(request, group = group,
users = users))
