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())