def view_sector_budget(request, sector_ref_no):
sector = get_object_or_404(Sector, ref_no=sector_ref_no)
sector_master_plans = SectorMasterPlan.objects.filter(sector=sector)
current_year = date.today().year
has_programs = False
master_plans = []
for sm in sector_master_plans:
master_plan = sm.master_plan
plans = Plan.objects.filter(master_plan=master_plan)
for plan in plans:
programs = Program.objects.filter(plan=plan)
for program in programs:
quarters = {1:{'grant':0,'claim':0}, 2:{'grant':0,'claim':0},
3:{'grant':0,'claim':0}, 4:{'grant':0,'claim':0}}
for schedule in BudgetSchedule.objects.filter(program=program, schedule_on__year=current_year):
quarter_number = utilities.find_quarter_number(schedule.schedule_on)
quarters[quarter_number]['grant'] = quarters[quarter_number]['grant'] + schedule.grant_budget
quarters[quarter_number]['claim'] = quarters[quarter_number]['claim'] + schedule.claim_budget
program.quarters = quarters
if programs: has_programs = True
plan.programs = programs
master_plan.plans = plans
master_plans.append(master_plan)
return render_page_response(request, 'budget', 'page_sector/sector_budget.html', {'current_year': current_year, 'sector': sector, 'master_plans': master_plans, 'has_programs': has_programs})
def view_master_plan_budget(request, master_plan_ref_no):
master_plan = get_object_or_404(MasterPlan, ref_no=master_plan_ref_no)
plans = Plan.objects.filter(master_plan=master_plan).order_by("ref_no")
current_year = date.today().year
has_programs = False
for plan in plans:
programs = Program.objects.filter(plan=plan).order_by("ref_no")
for program in programs:
quarters = {
1: {"grant": 0, "claim": 0},
2: {"grant": 0, "claim": 0},
3: {"grant": 0, "claim": 0},
4: {"grant": 0, "claim": 0},
}
for schedule in ProgramBudgetSchedule.objects.filter(program=program, schedule_on__year=current_year):
quarter_number = utilities.find_quarter_number(schedule.schedule_on)
quarters[quarter_number]["grant"] = quarters[quarter_number]["grant"] + schedule.grant_budget
quarters[quarter_number]["claim"] = quarters[quarter_number]["claim"] + schedule.claim_budget
program.quarters = quarters
if programs:
has_programs = True
plan.programs = programs
return render_page_response(
request,
"budget",
"page_sector/master_plan_budget.html",
{"current_year": current_year, "master_plan": master_plan, "plans": plans, "has_programs": has_programs},
)
def view_sector_budget(request, sector_ref_no):
sector = get_object_or_404(Sector, ref_no=sector_ref_no)
sector_master_plans = SectorMasterPlan.objects.filter(sector=sector)
current_year = date.today().year
has_programs = False
master_plans = []
for sm in sector_master_plans:
master_plan = sm.master_plan
plans = Plan.objects.filter(master_plan=master_plan)
for plan in plans:
programs = Program.objects.filter(plan=plan)
for program in programs:
quarters = {
1: {
'grant': 0,
'claim': 0
},
2: {
'grant': 0,
'claim': 0
},
3: {
'grant': 0,
'claim': 0
},
4: {
'grant': 0,
'claim': 0
}
}
for schedule in BudgetSchedule.objects.filter(
program=program, schedule_on__year=current_year):
quarter_number = utilities.find_quarter_number(
schedule.schedule_on)
quarters[quarter_number]['grant'] = quarters[
quarter_number]['grant'] + schedule.grant_budget
quarters[quarter_number]['claim'] = quarters[
quarter_number]['claim'] + schedule.claim_budget
program.quarters = quarters
if programs: has_programs = True
plan.programs = programs
master_plan.plans = plans
master_plans.append(master_plan)
ctx = {
'current_year': current_year,
'sector': sector,
'master_plans': master_plans,
'has_programs': has_programs
}
return render_page_response(request, 'budget',
'page_sector/sector_budget.html', ctx)
def view_master_plan_budget(request, master_plan_ref_no):
master_plan = get_object_or_404(MasterPlan, ref_no=master_plan_ref_no)
plans = Plan.objects.filter(master_plan=master_plan).order_by('ref_no')
current_year = date.today().year
has_programs = False
for plan in plans:
programs = Program.objects.filter(plan=plan).order_by('ref_no')
for program in programs:
quarters = {
1: {
'grant': 0,
'claim': 0
},
2: {
'grant': 0,
'claim': 0
},
3: {
'grant': 0,
'claim': 0
},
4: {
'grant': 0,
'claim': 0
}
}
for schedule in BudgetSchedule.objects.filter(
program=program, schedule_on__year=current_year):
quarter_number = utilities.find_quarter_number(
schedule.schedule_on)
quarters[quarter_number]['grant'] = quarters[quarter_number][
'grant'] + schedule.grant_budget
quarters[quarter_number]['claim'] = quarters[quarter_number][
'claim'] + schedule.claim_budget
program.quarters = quarters
if programs: has_programs = True
plan.programs = programs
return render_page_response(
request, 'budget', 'page_sector/master_plan_budget.html', {
'current_year': current_year,
'master_plan': master_plan,
'plans': plans,
'has_programs': has_programs
})
def view_master_plan_budget(request, master_plan_ref_no):
master_plan = get_object_or_404(MasterPlan, ref_no=master_plan_ref_no)
plans = Plan.objects.filter(master_plan=master_plan).order_by('ref_no')
current_year = date.today().year
has_programs = False
for plan in plans:
programs = Program.objects.filter(plan=plan).order_by('ref_no')
for program in programs:
quarters = {1:{'grant':0,'claim':0}, 2:{'grant':0,'claim':0}, 3:{'grant':0,'claim':0}, 4:{'grant':0,'claim':0}}
for schedule in BudgetSchedule.objects.filter(program=program, schedule_on__year=current_year):
quarter_number = utilities.find_quarter_number(schedule.schedule_on)
quarters[quarter_number]['grant'] = quarters[quarter_number]['grant'] + schedule.grant_budget
quarters[quarter_number]['claim'] = quarters[quarter_number]['claim'] + schedule.claim_budget
program.quarters = quarters
if programs: has_programs = True
plan.programs = programs
return render_page_response(request, 'budget', 'page_sector/master_plan_budget.html', {'current_year':current_year, 'master_plan':master_plan, 'plans':plans, 'has_programs':has_programs})
def view_master_plan_program_budget(request, program_id):
program = get_object_or_404(Program, pk=program_id)
master_plan = program.plan.master_plan
if not permission.access_obj(request.user, "master_plan manage", master_plan):
return access_denied(request)
budget_schedules = ProgramBudgetSchedule.objects.filter(program=program).order_by("schedule_on")
if request.method == "POST":
updating_schedules = list()
for schedule in request.POST.getlist("schedule"):
try:
(schedule_id, grant_budget, schedule_on) = schedule.split(",")
(schedule_on_year, schedule_on_month, schedule_on_day) = schedule_on.split("-")
schedule_on = date(int(schedule_on_year), int(schedule_on_month), int(schedule_on_day))
grant_budget = int(grant_budget)
except:
messages.error(request, "ข้อมูลไม่อยู่ในรูปแบบที่ถูกต้อง กรุณากรอกใหม่อีกครั้ง")
return redirect("view_master_plan_project_budget", (program.id))
else:
create_revision = False
if schedule_id and schedule_id != "none":
schedule = ProgramBudgetSchedule.objects.get(pk=schedule_id)
if schedule.grant_budget != grant_budget or schedule.schedule_on != schedule_on:
create_revision = True
schedule.grant_budget = grant_budget
schedule.schedule_on = schedule_on
schedule.save()
else:
schedule = ProgramBudgetSchedule.objects.create(
program=program, grant_budget=grant_budget, claim_budget=0, schedule_on=schedule_on
)
create_revision = True
if create_revision:
revision = ProgramBudgetScheduleRevision.objects.create(
schedule=schedule,
grant_budget=schedule.grant_budget,
claim_budget=schedule.claim_budget,
schedule_on=schedule.schedule_on,
revised_by=request.user.get_profile(),
)
updating_schedules.append(schedule)
# Remove schedule
for budget_schedule in budget_schedules:
found = False
for schedule in updating_schedules:
if schedule == budget_schedule:
found = True
if not found:
ProjectBudgetScheduleRevision.objects.filter(schedule=budget_schedule).delete()
budget_schedule.delete()
return utilities.redirect_or_back("view_master_plan_manage_organization", (master_plan.ref_no), request)
for budget_schedule in budget_schedules:
budget_schedule.schedule_quarter = utilities.find_quarter_number(budget_schedule.schedule_on)
return render_page_response(
request,
"organization",
"page_sector/manage_master_plan/manage_program_budget.html",
{"master_plan": master_plan, "program": program, "schedules": budget_schedules},
)