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)