def mentor_landing(request):
db = mongo_instance()
if request.method == "POST":
pass
res = db.tycl_questionnare_new.find({ "Participation in social/community events": { "$exists": True}},
{'_id':0, "Participation in social/community events":1 })
res2 = db.tycl_questionnare_new.find({ "Child relationship with friends": { "$exists": True}},
{'_id':0, "Child relationship with friends":1 })
res1 = [int(r.values()[0]) for r in res][:12]
res12 = [int(r.values()[0]) for r in res2][:12]
res3 = db.tycl_questionnare_new.find({ "Educational performance at the school": { '$exists': True}},
{'_id':0, "Educational performance at the school":1 })
res4 = db.tycl_questionnare_new.find({ "Participation in social/community events": { '$exists': True}},
{'_id':0, "Participation in social/community events":1 })
res13 = [int(r.values()[0]) for r in res3][:12]
res14 = [int(r.values()[0]) for r in res4][:12]
db = mongo_instance()
mentor_data = db.tycl_mentor_data.find_one({"username": request.user.username})
volunteer_data = db.tycl_vol_pfle.find_one({"username": mentor_data['volunteer']}, {'_id': 0, 'username': 0}).items()
child_data = db.tycl_vol_pfle.find_one({"username": mentor_data['child']}, {'_id': 0, 'username': 0}).items()
return render(request, 'landing.html', {'historic_feedback': [x.items() for x in mentor_data['feedback']],
'child_data': child_data, 'volunteer_data': volunteer_data,
'res': res1, 'res2': res12, 'res3': res13, 'res4': res14})
def mentor_questionnare(request):
db = mongo_instance()
if request.method == "POST":
ref_append = {'type': 'Objective'}
for entity in db.tycl.find_one({'id': 'q_reference'})['val']:
if entity in request.POST and request.POST[entity]:
ref_append[entity] = request.POST[entity]
ref_desc = {'type': 'descriptive'}
form_elements = ['Educational performance at the school_d',
'Health (physical and Mental well-being)condition of the child_d',
'Child relationship with family members_d',
'Child relationship with friends_d',
'Participation in co-curricular activities_d',
'Participation in social/community events_d',
'Feeling safe at Home, community and School_d',
'Social interaction with peers_d',
'Personal hygiene of the child_d',
'Date of meeting',
'Place of meeting',
'Meeting Agenda', 'Outcome of Meeting', 'Key Accomplishment', 'Purpose of Connection',
'Key learnings for Mentee', 'Key Challenges faced by volunteer',
'Key Challenges faced by mentee', 'Key Challenges faced by mentor']
# form elements reference
for element in form_elements:
if element in request.POST and request.POST[element]:
ref_desc[element] = request.POST[element]
db.tycl_questionnare_new.insert(ref_append)
db.tycl_questionnare_new.insert(ref_desc)
return HttpResponseRedirect('/')
return render(request, 'questionnare.html')
def get(self, request):
db = mongo_instance()
lc = db.tycl_hist_data.aggregate([{'$unwind': "$meetings"},
{"$group": {"_id": "$meetings.placeOfMeeting", "count": {"$sum": 1}}}])
location_stats = [x for x in lc]
if 'utilization' in request.GET:
return Response({'utilization_keys': [str(x['_id']) for x in location_stats],
'utilization_values': [x['count'] for x in location_stats]})
else:
return Response({"status": False})
def get(self, request):
if 'is_profile_set' in request.GET:
return Response({"status": False})
if 'retrive_profile' in request.GET:
db = mongo_instance()
res = db.tycl_vol_pfle.find_one({'username': request.GET['retrive_profile']}) or {}
if '_id' in res:
del res['_id']
return Response(res)
def register_profile(request):
if request.method == 'POST':
db = mongo_instance()
keys = db.tycl.find_one({'id': 'volunteer_profile_reference'})['val']
for k in keys:
if k in ('username', ):
continue
keys[k] = request.POST[k.replace(' ', '_')]
keys['username'] = request.user.username
db.tycl_vol_pfle.insert(keys)
return HttpResponseRedirect('/')
return render(request, 'volunteer_profile.html')
def register_mentor_profile(request):
if request.method == 'POST':
db = mongo_instance()
keys = db.tycl.find_one({'id': 'mentor_profile_reference'})['val']
for k in keys:
if k in ('username', ):
continue
elif k == "Area_of_Expertise":
keys[k] = request.POST[k.replace(' ', '_')].lower().split(',')
keys[k] = request.POST[k.replace(' ', '_')]
keys['username'] = request.user.username
db.tycl_mentor_profile.insert(keys)
return HttpResponseRedirect('/')
return render(request, 'profile.html')
def insights(request):
day_ref = {0: 'Monday', 1: 'Tuesday', 2: 'Wednesday', 3: 'Thursday', 4: 'Friday', 5: 'Saturday', 6: 'Sunday'}
db = mongo_instance()
lc = db.tycl_hist_data.aggregate([{'$unwind': "$meetings"},
{"$group": {"_id": "$meetings.placeOfMeeting", "count": {"$sum": 1}}}])
location_stats = [x for x in lc]
mentor_counts = [x for x in db.tycl_hist_data.find({}, {'mentor': 1, '_id': 0})]
mcw = len([x for x in mentor_counts if x['mentor']])
mc = [x for x in db.tycl_hist_data.aggregate([{'$project': {'_id': 0, 'volunteer': 1,
'meetings': {'$size': "$meetings"}}}])]
cdays = db.tycl_hist_data.aggregate([{"$unwind":"$meetings"}, {"$project": {"_id": "$meetings.dateOfMeeting"}}])
_days = sorted([day_ref[datetime.datetime.strptime(x['_id'].split('T')[0], '%Y-%m-%d').weekday()] for x in cdays])
d = {x: _days.count(x) for x in _days}
return render(request, 'insights.html', {'utilization_keys': [str(x['_id']) for x in location_stats],
'utilization_values': [x['count'] for x in location_stats],
'mentor': (mcw, len(mentor_counts) - mcw),
'mc_m': [str(x['volunteer']) for x in mc],
'mc_c': [x['meetings'] for x in mc],
'df_k': str(d.keys()), 'df_v': d.values()})
def mentor_landing(request):
db = mongo_instance()
if request.method == "POST":
pass
res = db.tycl_questionnare_new.find(
{"Participation in social/community events": {
"$exists": True
}}, {
'_id': 0,
"Participation in social/community events": 1
})
res2 = db.tycl_questionnare_new.find(
{"Child relationship with friends": {
"$exists": True
}}, {
'_id': 0,
"Child relationship with friends": 1
})
res1 = [int(r.values()[0]) for r in res][:12]
res12 = [int(r.values()[0]) for r in res2][:12]
res3 = db.tycl_questionnare_new.find(
{"Educational performance at the school": {
'$exists': True
}}, {
'_id': 0,
"Educational performance at the school": 1
})
res4 = db.tycl_questionnare_new.find(
{"Participation in social/community events": {
'$exists': True
}}, {
'_id': 0,
"Participation in social/community events": 1
})
res13 = [int(r.values()[0]) for r in res3][:12]
res14 = [int(r.values()[0]) for r in res4][:12]
db = mongo_instance()
mentor_data = db.tycl_mentor_data.find_one(
{"username": request.user.username})
volunteer_data = db.tycl_vol_pfle.find_one(
{
"username": mentor_data['volunteer']
}, {
'_id': 0,
'username': 0
}).items()
child_data = db.tycl_vol_pfle.find_one({
"username": mentor_data['child']
}, {
'_id': 0,
'username': 0
}).items()
return render(
request, 'landing.html', {
'historic_feedback': [x.items() for x in mentor_data['feedback']],
'child_data': child_data,
'volunteer_data': volunteer_data,
'res': res1,
'res2': res12,
'res3': res13,
'res4': res14
})