115 lines
4.3 KiB
Python
115 lines
4.3 KiB
Python
from django.db import models
|
|
from django.contrib.auth.models import User
|
|
|
|
class Department(models.Model):
|
|
name = models.CharField(max_length=100)
|
|
code = models.CharField(max_length=10, unique=True)
|
|
description = models.TextField(blank=True)
|
|
|
|
def __str__(self):
|
|
return self.name
|
|
|
|
class Shift(models.Model):
|
|
name = models.CharField(max_length=50) # e.g., Morning, Night, General
|
|
start_time = models.TimeField()
|
|
end_time = models.TimeField()
|
|
|
|
def __str__(self):
|
|
return f"{self.name} ({self.start_time} - {self.end_time})"
|
|
|
|
class Employee(models.Model):
|
|
user = models.OneToOneField(User, on_delete=models.CASCADE, null=True, blank=True)
|
|
employee_id = models.CharField(max_length=20, unique=True)
|
|
biometric_id = models.CharField(max_length=20, unique=True, null=True, blank=True, help_text="ID on the ZKTeco device")
|
|
first_name = models.CharField(max_length=50)
|
|
last_name = models.CharField(max_length=50)
|
|
department = models.ForeignKey(Department, on_delete=models.SET_NULL, null=True)
|
|
shift = models.ForeignKey(Shift, on_delete=models.SET_NULL, null=True)
|
|
position = models.CharField(max_length=100)
|
|
joined_date = models.DateField()
|
|
is_active = models.BooleanField(default=True)
|
|
|
|
def __str__(self):
|
|
return f"{self.first_name} {self.last_name} ({self.employee_id})"
|
|
|
|
class BiometricDevice(models.Model):
|
|
name = models.CharField(max_length=100)
|
|
ip_address = models.GenericIPAddressField()
|
|
port = models.IntegerField(default=4370)
|
|
is_active = models.BooleanField(default=True)
|
|
last_sync = models.DateTimeField(null=True, blank=True)
|
|
|
|
def __str__(self):
|
|
return f"{self.name} ({self.ip_address})"
|
|
|
|
class AttendanceLog(models.Model):
|
|
employee = models.ForeignKey(Employee, on_delete=models.CASCADE)
|
|
timestamp = models.DateTimeField()
|
|
device = models.ForeignKey(BiometricDevice, on_delete=models.SET_NULL, null=True)
|
|
uid = models.IntegerField(help_text="Internal ID from device log")
|
|
|
|
class Meta:
|
|
unique_together = ('employee', 'timestamp')
|
|
ordering = ['-timestamp']
|
|
|
|
def __str__(self):
|
|
return f"{self.employee} - {self.timestamp}"
|
|
|
|
class DailyAttendance(models.Model):
|
|
STATUS_CHOICES = (
|
|
('present', 'Present'),
|
|
('absent', 'Absent'),
|
|
('late', 'Late'),
|
|
('half_day', 'Half Day'),
|
|
('on_leave', 'On Leave'),
|
|
)
|
|
employee = models.ForeignKey(Employee, on_delete=models.CASCADE)
|
|
date = models.DateField()
|
|
check_in = models.TimeField(null=True, blank=True)
|
|
check_out = models.TimeField(null=True, blank=True)
|
|
status = models.CharField(max_length=20, choices=STATUS_CHOICES, default='absent')
|
|
is_late = models.BooleanField(default=False)
|
|
worked_hours = models.DecimalField(max_digits=5, decimal_places=2, default=0.00)
|
|
|
|
class Meta:
|
|
unique_together = ('employee', 'date')
|
|
|
|
class LeaveType(models.Model):
|
|
name = models.CharField(max_length=50)
|
|
color_code = models.CharField(max_length=7, default='#3498db') # Hex code for UI
|
|
total_days = models.IntegerField(default=0)
|
|
|
|
def __str__(self):
|
|
return self.name
|
|
|
|
class LeaveRequest(models.Model):
|
|
STATUS_CHOICES = (
|
|
('pending', 'Pending'),
|
|
('approved', 'Approved'),
|
|
('rejected', 'Rejected'),
|
|
)
|
|
employee = models.ForeignKey(Employee, on_delete=models.CASCADE)
|
|
leave_type = models.ForeignKey(LeaveType, on_delete=models.CASCADE)
|
|
start_date = models.DateField()
|
|
end_date = models.DateField()
|
|
reason = models.TextField()
|
|
status = models.CharField(max_length=20, choices=STATUS_CHOICES, default='pending')
|
|
applied_on = models.DateTimeField(auto_now_add=True)
|
|
approved_by = models.ForeignKey(User, on_delete=models.SET_NULL, null=True, blank=True, related_name='approver')
|
|
|
|
def __str__(self):
|
|
return f"{self.employee} - {self.leave_type} ({self.start_date})"
|
|
|
|
class LeaveBalance(models.Model):
|
|
employee = models.ForeignKey(Employee, on_delete=models.CASCADE)
|
|
leave_type = models.ForeignKey(LeaveType, on_delete=models.CASCADE)
|
|
allocated = models.IntegerField()
|
|
used = models.IntegerField(default=0)
|
|
|
|
@property
|
|
def remaining(self):
|
|
return self.allocated - self.used
|
|
|
|
class Meta:
|
|
unique_together = ('employee', 'leave_type')
|