def get_activity2(request, orderBy=None): util = Utility() user_list = util.viewable_user_list(request) allUserId_list = user_list['allUserId_list'] allUser_list = user_list['allUser_list'] activity_dict = {'allUser_list':allUser_list} return render(request, 'activity2.html', activity_dict)
def adminGetAllUsers(request): user = request.user print 'get_activity() ] user=[', user if user.is_staff or user.is_superuser: util = Utility() user_list = util.viewable_user_list(request) #allUserId_list = user_list['allUserId_list'] #allUser_list = user_list['allUser_list'] #activity_dict= {'allUserId_list', 'allUser_list':allUser_list, 'investorId':uid, 'investorName':userName} #print 'get_activity() activity_dict[', activity_dict # We also add the project object from the database to the context dictionary. # We'll use this in the template to verify that the project exists. #activity_dict['projects'] = activity_list # Go render the response and return it to the client. return user_list
def calculate_activity(request, orderBy=None): # Create a context dictionary which we can pass to the template rendering engine. activity_dict = {} user = request.user print 'get_activity(()' util = Utility() user_list = util.viewable_user_list(request) allUserId_list = user_list['allUserId_list'] allUser_list = user_list['allUser_list'] allUserId_dict = user_list['allUserId_dict'] print 'allUserId_dict[', allUserId_dict uid=request.POST.get('investorId') userName = None activity_list = None print 'get_activity() orderBy=[', orderBy, "] id=[", uid sess= request.session; sess_userId_label = "current_activity_uid" sess_orderBy_label = "current_orderBy" if request.method == 'GET' and uid == None and sess.get(sess_userId_label) != None: uid = sess.get(sess_userId_label) print 'get_activity() finds session stored uid=', uid oldOrderBy = sess.get(sess_orderBy_label) if orderBy == None: orderBy = '-Date' elif orderBy == oldOrderBy and orderBy != 'NONE': orderBy = '-' + orderBy #sort descending sess[sess_orderBy_label] = orderBy try: currentUser = None if uid == None or uid == '---': # investor self look up userId = request.user.id uid = userId if orderBy == 'NONE': activity_list = InvestmentActivity.objects.filter(UserId = userId) else : activity_list = InvestmentActivity.objects.filter(UserId = userId).order_by(orderBy) #userName = User.objects.filter(id = uid).values_list('first_name', 'last_name') currentUser=allUserId_dict[int(uid)] elif uid == 'ALL' and (user.is_staff or user.is_superuser) : # fetch all records the current user is allowed to view if orderBy == 'NONE': activity_list = InvestmentActivity.objects.all().filter(UserId__in=allUserId_list) else: activity_list = InvestmentActivity.objects.all().filter(UserId__in=allUserId_list).order_by(orderBy) userName = [(u'ALL', u'USERS')] else: currentUser=allUserId_dict[int(uid)] #userName = User.objects.filter(id = uid).values_list('first_name', 'last_name') if orderBy == 'NONE': activity_list = InvestmentActivity.objects.select_related('ProjectId__Status').filter(UserId = uid) else: activity_list = InvestmentActivity.objects.select_related('ProjectId__Status').filter(UserId = uid).order_by(orderBy) if currentUser != None : fname = allUserId_dict[int(uid)]['first_name'] lname = allUserId_dict[int(uid)]['last_name'] userName = fname + ' ' + lname sess[sess_userId_label] = uid print 'get_activity() user name=', userName total = 0.0 total_principal = 0.0 total_distribution = 0.0 total_interest = 0.0 total_dividend = 0.0 for item in activity_list: if (item.Type_id == 'Deposit'): total_principal += item.Amount elif (item.Type_id == 'Check'): total_distribution += item.Amount elif (item.Type_id == 'Interest'): total_interest += item.Amount elif (item.Type_id == 'Dividend'): total_dividend += item.Amount total = total_principal + total_distribution activity_dict = {'activities': activity_list, 'total_amount': total, 'total_distribution':total_distribution, 'total_principal':total_principal, 'total_interest':total_interest, 'total_dividend':total_dividend, 'allUser_list':allUser_list, 'investorId':uid, 'investorName':userName} print 'get_activity() activity_dict[', activity_dict # We also add the project object from the database to the context dictionary. # We'll use this in the template to verify that the project exists. #activity_dict['projects'] = activity_list except InvestmentActivity.DoesNotExist: # We get here if we didn't find the specified project. # Don't do anything - the template displays the "no project" message for us. pass return activity_dict