我正在嘗試從我的 SQLite 資料庫中檢索最近 7 天的記錄。我有一個考勤系統，我正在嘗試在 UI 上顯示一些統計資訊，但是目前它不起作用 - 我將在下面顯示我當前的代碼。
楷模：
class Meta:
model = User
fields = ("username", 'email', 'password1', 'password2')
class is_Present(models.Model):
user = models.ForeignKey(User, on_delete=models.CASCADE)
date = models.DateField(default=datetime.date.today)
is_present = models.BooleanField(default=False)
class clocked_Time(models.Model):
user = models.ForeignKey(User, on_delete=models.CASCADE)
date = models.DateField(default=datetime.date.today)
time = models.DateTimeField(null=True, blank=True)
signed_out = models.BooleanField(default=False)
視圖.py：
# Get Count of Present Employees in last week
def present_week_employees():
today = date.today()
week = today - timedelta(days=7)
present_employees_all = is_Present.objects.filter(date=week).filter(is_present=True)
return len(present_employees_all)
# Displays admin attendance portal functions
def attendance_portal(request):
if not request.user.is_authenticated:
messages.warning(request, f'Please sign in to mark attendance out')
return redirect('login')
elif not request.user.is_superuser or not request.user.is_staff:
messages.warning(request, f'Must be admin to access this feature')
return redirect('home')
elif request.user.is_superuser:
count_employees_all = count_employees() # shows count of employees
present_employee_all = present_employees() # shows count present employees today
present_employee_all_week = present_week_employees() # shows count present employees in last 7 days
# Gets the employees present today/week
today = datetime.today()
week = today - timedelta(days=7)
# Gets employees displayed and paginated
today_p = Paginator(is_Present.objects.filter(date=today).filter(is_present=True).select_related('user').all(),5)
x = Paginator(is_Present.objects.filter(date=week).filter(is_present=True).select_related('user').all(), 5)
page = request.GET.get('page', 1)
try:
users = today_p.get_page(page) # returns the desired page object
except PageNotAnInteger:
# if page_number is not an integer then assign the first page
users = today_p.page(1)
except EmptyPage:
# if page is empty then return last page
users = today_p.page(today_p.num_pages)
# this_week_emp_count_vs_date()
# last_week_emp_count_vs_date()
try:
all_users = x.get_page(page)
except PageNotAnInteger:
# if page_number is not an integer then assign the first page
all_users = x.page(1)
except EmptyPage:
# if page is empty then return last page
all_users = x.page(x.num_pages)
return render(request, "users/adminReports.html",
{'count_employees_all': count_employees_all, 'present_employee_all': present_employee_all,
'present_employee_all_week': present_employee_all_week, 'all_users': all_users, 'users': users})
else:
messages.warning(request, f'Error - please see logs for details.')
return redirect(request, 'home')
HTML：
<div class="card" id="emp_present_week">
<div class="card-body">
<h5 class="card-title"> <b> Employees present in last 7 days</b></h5>
<p class="card-text" style="padding-top: 1em; font-size: 28px;"><b> {{ present_employee_all_week }}</b></p>
</div>
</div>
另外，我附上了一張圖片以供參考。僅供參考 - 當我標記用戶今天在場時，它將在今天和 7 天內顯示他們，這是正確的。但是，我昨天標記為出席的員工今天沒有顯示在 7 天計數中。我認為潛在的問題可能在以下某個地方：
present_employees_all = is_Present.objects.filter(date=week).filter(is_present=True)
可能我需要回圈過去 7 天？我已經嘗試過這種方法，但沒有成功。
任何幫助將不勝感激！
系統統計影像
uj5u.com熱心網友回復：
您的查詢是錯誤的，等于意味著您只能在 7 天前獲得確切的記錄。您需要從最近 7 天到現在進行查詢，在您的查詢中使用__gte（gte 大于或等于）
它應該是這樣的：
today = date.today()
seven_day_before = today - timedelta(days=7)
present_employees_all = is_Present.objects.filter(date__gte=seven_day_before, is_present=True)
也不需要使用鏈式過濾器，過濾器支持多個AND條件
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/441434.html
標籤：Python django 数据库 sqlite django-queryset
上一篇：靜態地圖上的點（坐標）