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
