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))