def viewWFP(request):
context = RequestContext(request)
data = {'system_name' : SYSTEM_NAME,
'agency_id' : request.GET.get('agency_id'),
'current_year' : time.strftime('%Y'),
'agency_tab' : 'wfp'
}
data['allowed_tabs'] = get_allowed_tabs(request.user.id)
if request.method=='POST':
year = request.POST.get('year')
agency = Agency.objects.get(id=request.POST.get('agency_id'))
else:
year = time.strftime('%Y')
agency = Agency.objects.get(id=request.GET.get('agency_id'))
query = '''
select * from wfp_data
where allocation=%s and agency_id=%s and year=%s
'''
data['year'] = year
data['agency'] = agency
try:
data['wfp_submit'] = WFPSubmission.objects.get(year=year, agency=agency)
except WFPSubmission.DoesNotExist:
pass
data['pss'] = WFPData.objects.raw(query, ['PS', agency.id, year])
data['mooes'] = WFPData.objects.raw(query, ['MOOE', agency.id, year])
data['cos'] = WFPData.objects.raw(query, ['CO', agency.id, year])
return render_to_response('./wfp/agency_wfp_info.html', data, context)
def wfpForm(request):
context = RequestContext(request)
data = {'system_name':SYSTEM_NAME,
'agency_id': request.GET.get('agency_id')
}
data['allowed_tabs'] = get_allowed_tabs(request.user.id)
data['current_year'] = time.strftime('%Y')
data['form'] = WFPForm()
if request.method=='POST':
wfp_form = WFPForm(request.POST)
if wfp_form.is_valid():
saveWFPData(request, wfp_form, request.POST.get('year'), request.POST.get('agency'))
data['s_msg'] = 'WFP Entry was succesfully saved'
data['agency'] = Agency.objects.get(id=request.POST.get('agency'))
return render_to_response('./wfp/wfp_form.html', data, context)
else:
data['frm_errors'] = wfp_form.errors
data['form'] = wfp_form
return render_to_response('./wfp/wfp_form.html', data, context)
else:
try:
data['agency'] = Agency.objects.get(id=data['agency_id'])
return render_to_response('./wfp/wfp_form.html', data, context)
except Agency.DoesNotExist:
return HttpResponseRedirect('/admin/agencies')
def coRequestForm(request):
context = RequestContext(request)
data = {'system_name' : SYSTEM_NAME,
'agency_id' : request.GET.get('agency_id'),
'action' : request.GET.get('action')
}
try:
data['allowed_tabs'] = get_allowed_tabs(request.user.id)
agency = Agency.objects.get(id=data['agency_id'])
data['agency'] = agency
if request.method == 'POST':
co_request_form = CORequestForm(request.POST)
action = request.POST.get('form_action', 'add')
if action == 'add' and co_request_form.is_valid():
agency = Agency.objects.get(id=request.POST.get('agency_id'))
date_rcv = request.POST.get('date_received')
addCORequest(co_request_form, agency, date_rcv)
data['s_msg'] = 'New request succesfully Saved'
data['form'] = CORequestForm()
return render_to_response('./wfp/co_request_form.html', data, context)
elif action == 'edit' and co_request_form.is_valid():#edit
return HttpResponse('edit')
else:
return HttpResponse(action)
# elif request.GET.get()
else:
data['form_action'] = request.GET.get('form_action', 'add')
data['form'] = CORequestForm()
return render_to_response('./wfp/co_request_form.html', data, context)
except Agency.DoesNotExist:
return HttpResponseRedirect("/admin/agencies")
def coRequests(request):
cursor = connection.cursor()
context = RequestContext(request)
data = {'system_name' : SYSTEM_NAME,
'agency_id' : request.GET.get('agency_id')}
try:
data['allowed_tabs'] = get_allowed_tabs(request.user.id)
agency = Agency.objects.get(id=data['agency_id'])
data['agency'] = agency
year = 0
month = 0
co_requests = None
if request.method == 'POST':
year_month = request.POST.get('month').split('-')
year = int(year_month[0])
month = int(year_month[1])
else:
year = int(time.strftime('%Y'))
month = int(time.strftime('%m'))
#get current month and year
co_requests = CoRequest.objects.filter(date_received__year=year, date_received__month=month, agency=agency)
data['co_requests'] = co_requests
data['year'] = year
data['month'] = month
data['month_str'] = months[month-1]
return render_to_response('./wfp/co_request.html', data, context)
except Agency.DoesNotExist:
return HttpResponseRedirect("/admin/agencies")
def viewWFP(request):
context = RequestContext(request)
cursor = connection.cursor()
data = {'system_name' : SYSTEM_NAME,
'agency_id' : request.GET.get('agency_id'),
'current_year' : time.strftime('%Y'),
'agency_tab' : 'wfp',
'years' : getYears(request.GET.get('agency_id'))
}
data['allowed_tabs'] = get_allowed_tabs(request.user.id)
if request.method=='POST':
year = request.POST.get('year')
agency = Agency.objects.get(id=request.POST.get('agency_id'))
else:
year = time.strftime('%Y')
agency = Agency.objects.get(id=request.GET.get('agency_id'))
data['pss'] = getProgActs('PS', agency, year)
data['mooes'] = getProgActs('MOOE', agency, year)
data['cos'] = getProgActs('CO', agency, year)
data['year'] = year
data['agency'] = agency
return render_to_response('./wfp/agency_wfp_info.html', data, context)
def viewApprovedBudget(request):
context = RequestContext(request)
data = {'system_name' : SYSTEM_NAME}
cursor = connection.cursor()
data['allowed_tabs'] = get_allowed_tabs(request.user.id)
try:
agency = Agency.objects.get(id=request.GET.get('agency_id'))
data['agency'] = agency
return render_to_response('./wfp/approved_budget.html', data, context)
except Agency.DoesNotExist:
return render_to_response('./wfp/approved_budget.html', data, context)
