def view_master_plan_manage_kpi(request, master_plan_ref_no, kpi_year):
master_plan = get_object_or_404(MasterPlan, ref_no=master_plan_ref_no)
if not permission.access_obj(request.user, 'master_plan manage', master_plan):
return access_denied(request)
if kpi_year:
year_number = int(kpi_year)
else:
year_number = utilities.master_plan_current_year_number()
kpi_categories = []
for dict in DomainKPI.objects.filter(master_plan=master_plan, year=year_number).values('category').distinct():
try:
kpi_category = DomainKPICategory.objects.get(pk=dict['category'])
except DomainKPICategory.DoesNotExist:
pass
else:
kpis = DomainKPI.objects.filter(master_plan=master_plan, year=year_number, category=kpi_category).order_by('ref_no')
for kpi in kpis:
kpi.removable = DomainKPISchedule.objects.filter(kpi=kpi).count() == 0
kpi_category.kpis = kpis
kpi_categories.append(kpi_category)
print year_number
no_category_kpis = DomainKPI.objects.filter(master_plan=master_plan, year=year_number, category=None)
print no_category_kpis
for kpi in no_category_kpis:
kpi.removable = DomainKPISchedule.objects.filter(kpi=kpi).count() == 0
return render_page_response(request, 'kpi', 'page_sector/manage_master_plan/manage_kpi.html', {'master_plan':master_plan, 'kpi_categories':kpi_categories, 'no_category_kpis':no_category_kpis, 'kpi_year':year_number})
def view_program_reports(request, program_id, year_number):
program = get_object_or_404(Program, id=program_id)
if year_number:
year_number = int(year_number) - 543
else:
year_number = utilities.master_plan_current_year_number()
year_choices = []
for i in range(1, -3, -1):
year_choices.append(year_number + i)
(start_date, end_date) = utilities.master_plan_year_span(year_number)
if permission.access_obj(request.user, 'program report submission warning',
program):
(submissions, late_submissions, rejected_submissions
) = report_functions.get_reports_for_program_reports_page(
program, start_date, end_date, include_warning=True)
else:
(submissions, late_submissions, rejected_submissions
) = report_functions.get_reports_for_program_reports_page(
program, start_date, end_date, include_warning=False)
return render_page_response(
request, 'reports', 'page_program/program_reports.html', {
'program': program,
'submissions': submissions,
'late_submissions': late_submissions,
'rejected_submissions': rejected_submissions,
'start_date': start_date,
'end_date': end_date,
'year_number': year_number,
'year_choices': year_choices
})
def view_sector_kpi(request, sector_ref_no):
sector = get_object_or_404(Sector, ref_no=sector_ref_no)
sector_master_plans = SectorMasterPlan.objects.filter(sector=sector)
master_plans = []
for sm in sector_master_plans:
master_plans.append(sm.master_plan)
quarter_year = utilities.master_plan_current_year_number()
ctx = {'sector': sector, 'master_plans': master_plans, 'quarter_year': quarter_year}
return render_page_response(request, 'kpi', 'page_sector/sector_kpi.html', ctx)
def view_sector_kpi(request, sector_ref_no):
sector = get_object_or_404(Sector, ref_no=sector_ref_no)
sector_master_plans = SectorMasterPlan.objects.filter(sector=sector)
master_plans = []
for sm in sector_master_plans:
master_plans.append(sm.master_plan)
quarter_year = utilities.master_plan_current_year_number()
ctx = {
'sector': sector,
'master_plans': master_plans,
'quarter_year': quarter_year
}
return render_page_response(request, 'kpi', 'page_sector/sector_kpi.html',
ctx)
def view_master_plan_manage_kpi(request, master_plan_ref_no, kpi_year):
master_plan = get_object_or_404(MasterPlan, ref_no=master_plan_ref_no)
if not permission.access_obj(request.user, 'master_plan manage',
master_plan):
return access_denied(request)
if kpi_year:
year_number = int(kpi_year)
else:
year_number = utilities.master_plan_current_year_number()
kpi_categories = []
for dict in DomainKPI.objects.filter(
master_plan=master_plan,
year=year_number).values('category').distinct():
try:
kpi_category = DomainKPICategory.objects.get(pk=dict['category'])
except DomainKPICategory.DoesNotExist:
pass
else:
kpis = DomainKPI.objects.filter(
master_plan=master_plan,
year=year_number,
category=kpi_category).order_by('ref_no')
for kpi in kpis:
kpi.removable = DomainKPISchedule.objects.filter(
kpi=kpi).count() == 0
kpi_category.kpis = kpis
kpi_categories.append(kpi_category)
print year_number
no_category_kpis = DomainKPI.objects.filter(master_plan=master_plan,
year=year_number,
category=None)
print no_category_kpis
for kpi in no_category_kpis:
kpi.removable = DomainKPISchedule.objects.filter(kpi=kpi).count() == 0
return render_page_response(
request, 'kpi', 'page_sector/manage_master_plan/manage_kpi.html', {
'master_plan': master_plan,
'kpi_categories': kpi_categories,
'no_category_kpis': no_category_kpis,
'kpi_year': year_number
})
def view_master_plan_kpi(request, master_plan_ref_no):
master_plan = get_object_or_404(MasterPlan, ref_no=master_plan_ref_no)
quarter_year = utilities.master_plan_current_year_number()
plans = Plan.objects.filter(master_plan=master_plan)
for plan in plans:
programs = Program.objects.filter(plan=plan).order_by('ref_no')
for program in programs:
kpi_schedules = {}
kpi_schedules['1'] = DomainKPISchedule.objects.filter(program=program, quarter=1, quarter_year=quarter_year).order_by('kpi__ref_no')
kpi_schedules['2'] = DomainKPISchedule.objects.filter(program=program, quarter=2, quarter_year=quarter_year).order_by('kpi__ref_no')
kpi_schedules['3'] = DomainKPISchedule.objects.filter(program=program, quarter=3, quarter_year=quarter_year).order_by('kpi__ref_no')
kpi_schedules['4'] = DomainKPISchedule.objects.filter(program=program, quarter=4, quarter_year=quarter_year).order_by('kpi__ref_no')
program.kpi_schedules = kpi_schedules
plan.programs = programs
return render_page_response(request, 'kpi', 'page_sector/master_plan_kpi.html', {'master_plan':master_plan, 'plans':plans, 'quarter_year':quarter_year})
def view_program_reports(request, program_id, year_number):
program = get_object_or_404(Program, id=program_id)
if year_number:
year_number = int(year_number) - 543
else:
year_number = utilities.master_plan_current_year_number()
year_choices = []
for i in range(1, -3, -1):
year_choices.append(year_number + i)
(start_date, end_date) = utilities.master_plan_year_span(year_number)
if permission.access_obj(request.user, 'program report submission warning', program):
(submissions, late_submissions, rejected_submissions) = report_functions.get_reports_for_program_reports_page(program, start_date, end_date, include_warning=True)
else:
(submissions, late_submissions, rejected_submissions) = report_functions.get_reports_for_program_reports_page(program, start_date, end_date, include_warning=False)
return render_page_response(request, 'reports', 'page_program/program_reports.html', {'program':program, 'submissions':submissions, 'late_submissions':late_submissions, 'rejected_submissions':rejected_submissions, 'start_date':start_date, 'end_date':end_date, 'year_number':year_number, 'year_choices':year_choices})
def view_sector_kpi(request, sector_ref_no):
sector = get_object_or_404(Sector, ref_no=sector_ref_no)
sector_master_plans = SectorMasterPlan.objects.filter(sector=sector)
quarter_year = utilities.master_plan_current_year_number()
master_plans = []
for smp in sector_master_plans:
master_plan = smp.master_plan
plans = Plan.objects.filter(master_plan=smp.master_plan)
for plan in plans:
programs = Program.objects.filter(plan=plan).order_by('ref_no')
for program in programs:
kpi_schedules = {}
kpi_schedules['1'] = DomainKPISchedule.objects.filter(program=program, quarter=1, quarter_year=quarter_year).order_by('kpi__ref_no')
kpi_schedules['2'] = DomainKPISchedule.objects.filter(program=program, quarter=2, quarter_year=quarter_year).order_by('kpi__ref_no')
kpi_schedules['3'] = DomainKPISchedule.objects.filter(program=program, quarter=3, quarter_year=quarter_year).order_by('kpi__ref_no')
kpi_schedules['4'] = DomainKPISchedule.objects.filter(program=program, quarter=4, quarter_year=quarter_year).order_by('kpi__ref_no')
program.kpi_schedules = kpi_schedules
plan.programs = programs
master_plan.plans = plans
master_plans.append(master_plan)
return render_page_response(request, 'kpi', 'page_sector/sector_kpi.html', {'sector':sector, 'master_plans':master_plans, 'quarter_year':quarter_year})
def view_master_plan_kpi(request, master_plan_ref_no):
master_plan = get_object_or_404(MasterPlan, ref_no=master_plan_ref_no)
quarter_year = utilities.master_plan_current_year_number()
ctx = {'master_plan': master_plan, 'quarter_year': quarter_year}
return render_page_response(request, 'kpi', 'page_sector/master_plan_kpi.html', ctx)
def view_master_plan_kpi(request, master_plan_ref_no):
master_plan = get_object_or_404(MasterPlan, ref_no=master_plan_ref_no)
quarter_year = utilities.master_plan_current_year_number()
ctx = {'master_plan': master_plan, 'quarter_year': quarter_year}
return render_page_response(request, 'kpi',
'page_sector/master_plan_kpi.html', ctx)
