from manifold.core.query        import Query
from unfold.page                import Page

from ui.topmenu                 import topmenu_items_live, the_user
from manifoldapi.manifoldapi    import execute_admin_query

from plugins.querytable         import QueryTable
from unfold.loginrequired       import LoginRequiredAutoLogoutView
from theme import ThemeView

from django.shortcuts import render, render_to_response

import json

# View for platforms
class UsersView(LoginRequiredAutoLogoutView, ThemeView):
    template_name = "usersview.html"
    def dispatch(self, *args, **kwargs):
        return super(UsersView, self).dispatch(*args, **kwargs)


    def get_context_data(self, **kwargs):
        page = Page(self.request)
        page.add_js_files  ( [ "js/common.functions.js" ] )
        #platform_query  = Query().get('local:platform').filter_by('disabled', '==', '0').select('platform','platform_longname','gateway_type')
        #platform_query  = Query().get('local:platform').select('platform','platform_longname','gateway_type')
        email_list = []
        status_list = []
        authority_list = []
        config={}

        user_query  = Query().get('local:user').select('email','status','config')
        user_details = execute_admin_query(self.request, user_query)

        for user in user_details:
            # get email
            email_list.append(user['email'])
            # get status
            if user['status'] == 0:
                user_status = 'Disabled'
            elif user['status'] == 1:
                user_status = 'Validation Pending'
            elif user['status'] == 2:
                user_status = 'Enabled'
            else:
                user_status = 'N/A'

            status_list.append(user_status)
            #get authority
            #if user['config']:
            user_config = json.loads(user['config'])
            user_authority = user_config.get('authority','N/A')
            authority_list.append(user_authority)
    
        user_list = [{'email': t[0], 'status': t[1], 'authority':t[2]}
            for t in zip(email_list, status_list, authority_list)]

        context = super(UsersView, self).get_context_data(**kwargs)
        context['person']   = self.request.user
        context['user_list'] = user_list

        # XXX This is repeated in all pages
        # more general variables expected in the template
        context['title'] = 'Users in MySlice'
        # the menu items on the top
        # so we can sho who is logged
        context['username'] = the_user(self.request)
        context['theme'] = self.theme

        context['layout_1_or_2']="layout-unfold2.html" if not context['username'] else "layout-unfold1.html"
        #prelude_env = page.prelude_env()
        #context.update(prelude_env)

        return render_to_response(self.template)