def utilization(request):
year, month = getmonthyear(request)
kwargs = {"year": year,
"month": month}
theteam = request.GET.get("team")
teamselection = group_for_team(theteam) if theteam else MARKET_CHOICES_LIST
utlztn, dates = ActivityEntry.utilization_last_12_months(teamselection, **kwargs)
activity_data = ActivityEntry.activity_volumes_last_12_months(teamselection, activity=request.GET.get("activity"))
team = MARKET_CHOICES_MAP.get(request.GET["team"]) \
if request.GET.get("team") else "All teams"
if not team:
raise Http404
return render_to_response(
"industrial_engineering_utilization.html",
{
"teams": MARKET_CHOICES,
"team": team,
"year": year,
"months": generate_month_box(id="month"),
"months2": generate_month_box(id="activity-month"),
"selected_month": month,
"selected_team": request.GET["team"] if request.GET.get("team") else "AD",
"current": " %s/%s" % (year,month),
"utlztn": utlztn[datetime(year=year,month=month,day=1)],
"utlztn_all": utlztn,
"dates": [date.strftime("%B") for date in dates],
"activities": Activity.objects.all(),
"activity_data": activity_data,
},
RequestContext(request)
)
def utilization(request):
year, month = getmonthyear(request)
kwargs = {"year": year, "month": month}
theteam = request.GET.get("team")
teamselection = group_for_team(theteam) if theteam else MARKET_CHOICES_LIST
utlztn, dates = ActivityEntry.utilization_last_12_months(
teamselection, **kwargs)
activity_data = ActivityEntry.activity_volumes_last_12_months(
teamselection, activity=request.GET.get("activity"))
team = MARKET_CHOICES_MAP.get(request.GET["team"]) \
if request.GET.get("team") else "All teams"
if not team:
raise Http404
return render_to_response(
"industrial_engineering_utilization.html", {
"teams": MARKET_CHOICES,
"team": team,
"year": year,
"months": generate_month_box(id="month"),
"months2": generate_month_box(id="activity-month"),
"selected_month": month,
"selected_team":
request.GET["team"] if request.GET.get("team") else "AD",
"current": " %s/%s" % (year, month),
"utlztn": utlztn[datetime(year=year, month=month, day=1)],
"utlztn_all": utlztn,
"dates": [date.strftime("%B") for date in dates],
"activities": Activity.objects.all(),
"activity_data": activity_data,
}, RequestContext(request))
def costbuckets(request):
year, month = getmonthyear(request)
kwargs = {"year": year,
"month": month}
if request.GET.get("team"):
cbb = ActivityEntry.costbucket_count(group_for_team(request.GET["team"]), **kwargs)
else:
cbb = ActivityEntry.costbucket_count(MARKET_CHOICES_LIST, **kwargs)
team = MARKET_CHOICES_MAP.get(request.GET["team"]) \
if request.GET.get("team") else "All teams"
if not team:
raise Http404
return render_to_response(
"industrial_engineering_reports.html",
{
"teams": MARKET_CHOICES,
"team": team,
"year": year,
"months": generate_month_box(id="month"),
"selected_month": month,
"selected_team": request.GET["team"] if request.GET.get("team") else "AD",
"costbuckets": cbb,
"current": " %s/%s" % (year, month)
},
RequestContext(request)
)
def test_costbucket_count(self):
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today()
).save()
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today()
).save()
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today()
).save()
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today()
).save()
self.assertEquals(ActivityEntry.costbucket_count(MARKET_CHOICES_LIST)[''], 4)
def test_filternoyearmonth(self):
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today()
).save()
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today()
).save()
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today()
).save()
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today()
).save()
entries, _ = ActivityEntry.filterforyearmonth([self.linked_user.market])
self.assertEqual(4, entries.count())
def test_filterforyearmonth(self):
td = datetime.timedelta(days=999)
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today() + td
).save()
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today() + td
).save()
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today() + td
).save()
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today() + td
).save()
entries, _ = ActivityEntry.filterforyearmonth(
[self.linked_user.market],
year=(datetime.datetime.today() + td).year,
month=(datetime.datetime.today() + td).month
)
self.assertEqual(4, entries.count())
def test_filterforyearmonth(self):
td = datetime.timedelta(days=999)
ActivityEntry.objects.create(user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today() +
td).save()
ActivityEntry.objects.create(user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today() +
td).save()
ActivityEntry.objects.create(user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today() +
td).save()
ActivityEntry.objects.create(user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today() +
td).save()
entries, _ = ActivityEntry.filterforyearmonth(
[self.linked_user.market],
year=(datetime.datetime.today() + td).year,
month=(datetime.datetime.today() + td).month)
self.assertEqual(4, entries.count())
def costbuckets(request):
year, month = getmonthyear(request)
kwargs = {"year": year, "month": month}
if request.GET.get("team"):
cbb = ActivityEntry.costbucket_count(
group_for_team(request.GET["team"]), **kwargs)
else:
cbb = ActivityEntry.costbucket_count(MARKET_CHOICES_LIST, **kwargs)
team = MARKET_CHOICES_MAP.get(request.GET["team"]) \
if request.GET.get("team") else "All teams"
if not team:
raise Http404
return render_to_response(
"industrial_engineering_reports.html", {
"teams": MARKET_CHOICES,
"team": team,
"year": year,
"months": generate_month_box(id="month"),
"selected_month": month,
"selected_team":
request.GET["team"] if request.GET.get("team") else "AD",
"costbuckets": cbb,
"current": " %s/%s" % (year, month)
}, RequestContext(request))
def test_utilization(self):
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today()
).save()
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today()
).save()
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today()
).save()
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today()
).save()
self.assertEquals(ActivityEntry.utilization_calculation(MARKET_CHOICES_LIST),
{
'util': {
'percent': Decimal('0.005553525758129338691998538546'),
'target': 65
},
'effi': {
'percent': Decimal('0.005553525758129338691998538546'),
'target': 85
},
'avai': {
'percent': Decimal('100'),
'target': 80
},
'FTE': 1
})
def test_costbucket_count(self):
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today()).save()
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today()).save()
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today()).save()
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today()).save()
self.assertEquals(
ActivityEntry.costbucket_count(MARKET_CHOICES_LIST)[''], 4)
def test_utilization(self):
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today()).save()
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today()).save()
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today()).save()
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today()).save()
self.assertEquals(
ActivityEntry.utilization_calculation(MARKET_CHOICES_LIST), {
'util': {
'percent': Decimal('0.005553525758129338691998538546'),
'target': 65
},
'effi': {
'percent': Decimal('0.005553525758129338691998538546'),
'target': 85
},
'avai': {
'percent': Decimal('100'),
'target': 80
},
'FTE': 1
})
def test_filternoyearmonth(self):
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today()).save()
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today()).save()
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today()).save()
ActivityEntry.objects.create(
user=self.linked_user,
activity=Activity.objects.all()[0],
amount=1,
creation_date=datetime.datetime.today()).save()
entries, _ = ActivityEntry.filterforyearmonth(
[self.linked_user.market])
self.assertEqual(4, entries.count())
