Guest User

Untitled

a guest
May 21st, 2018
200
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.05 KB | None | 0 0
  1. class Employee(models.Model):
  2. name = models.CharField(max_length=255)
  3.  
  4. class Attendance(models.Model):
  5. date = models.DateField()
  6. employee = models.ForeignKey(Employee, related_name='attendance')
  7.  
  8. class Salary(models.Model):
  9. salary = models.DecimalField(max_digits=20, decimal_places=0)
  10. employee = models.ForeignKey(Employee, related_name='salary')
  11.  
  12. class Salary(DetailView):
  13. context_object_name = 'salary_detail'
  14. model = models.Salary
  15. template_name = 'system/salary_detail.html'
  16.  
  17. class Employee(models.Model):
  18. name = models.CharField(max_length=255)
  19.  
  20. class Attendance(models.Model):
  21. date = models.DateField()
  22. employee = models.ForeignKey(Employee, related_name='attendance')
  23.  
  24. class Salary(models.Model):
  25. from_date = models.DateField()
  26. to_date = models.DateField()
  27. salary = models.DecimalField(max_digits=20, decimal_places=0)
  28. employee = models.ForeignKey(Employee, related_name='salary')
  29.  
  30.  
  31. employee.attendance.filter(date__gte=employee.salary.from_date, date__lte=employee.salary.to_date).values('dates')
Add Comment
Please, Sign In to add comment