শিফট সিম্পল

class Employee(models.Model):
    company = models.ForeignKey(
        Company,
        on_delete=models.CASCADE,
        related_name='company_employees',
        verbose_name=_("Company"),
        null=True, blank=True,
    )
    employee_id = models.CharField(
        max_length=20,
        verbose_name=_("Employee ID"),
    )
    department = models.CharField(max_length=50, null=True, blank=True, verbose_name=_("Department name"))  
    position = models.CharField(max_length=50, null=True, blank=True, verbose_name=_("Position title"))  
    contact_number = models.CharField(max_length=15, null=True, blank=True, verbose_name=_("Contact number"))  
    date_of_joining = models.DateField(null=True, blank=True, verbose_name=_("Date of joining"))  

class AttendanceLog(models.Model):
    """
    ব্যবহারকারীর চেক ইন এবং চেক আউট তথ্য সংরক্ষণ করার জন্য উপস্থিতি লগ মডেল।
    """
    
    employee = models.ForeignKey(
        Employee,
        on_delete=models.CASCADE,
        related_name='attendance_logs',
        verbose_name=_("Employee")
    )
    company = models.ForeignKey(Company, on_delete=models.CASCADE, related_name='attendance_logs',null=True)
    device = models.ForeignKey(Device, on_delete=models.CASCADE, null=True, blank=True)
    punch_datetime = models.DateTimeField(default=timezone.now, verbose_name=_("Date & Time of Punch"))
   
    STATUS_CHOICES = [
        ('IN', 'Check-In'),
        ('OUT', 'Check-Out'),
        ('BREAK_IN', 'Break-In'),
        ('BREAK_OUT', 'Break-Out'),
    ]
    in_out_status = models.CharField(max_length=20, choices=STATUS_CHOICES,     default='IN', verbose_name=_("In/Out Status"))
    VERIFICATION_CHOICES = [
        ('FP', 'Fingerprint'),
        ('FACE', 'Face'),
        ('CARD', 'Card'),
        ('PWD', 'Password'),
        ('GPS', 'GPS'),
        ('MANUAL', 'Manual'),
    ]
    verification_method = models.CharField(
        max_length=10,
        choices=VERIFICATION_CHOICES,
        default='FP',
        verbose_name=_("Verification Method")
    )

    punch_mode = models.CharField(
        max_length=10,
        choices=[('AUTO', 'Auto'), ('MANUAL', 'Manual')],
        default='AUTO',
        verbose_name=_("Punch Mode")
    )
    work_code = models.CharField(
        max_length=20,
        null=True,
        blank=True,
        verbose_name=_("Work Code")
    )
    locationName = models.CharField(max_length=255, null=True, blank=True)
    latitude = models.FloatField(null=True, blank=True)
    longitude = models.FloatField(null=True, blank=True)

    createdAt = models.DateTimeField(auto_now_add=True)
    updatedAt = models.DateTimeField(auto_now=True)

class Shift(models.Model):
    STATUS_CHOICES = [
        ('ACTIVE', 'Active'),
        ('INACTIVE', 'Inactive'),
    ]    
    name = models.CharField(max_length=50)  # Name of the shift
    start_time = models.TimeField()  # Shift start time
    end_time = models.TimeField()  # Shift end time
    break_duration = models.DurationField(null=True, blank=True)  # Optional break duration
    company = models.ForeignKey(Company, on_delete=models.CASCADE, related_name='shifts',null=True)
    status = models.CharField(max_length=10, choices=STATUS_CHOICES, default='ACTIVE')  # Shift status
    
    
class Workday(models.Model):
    day = models.CharField(max_length=10, choices=[
        ('MON', 'Monday'),
        ('TUE', 'Tuesday'),
        ('WED', 'Wednesday'),
        ('THU', 'Thursday'),
        ('FRI', 'Friday'),
        ('SAT', 'Saturday'),
        ('SUN', 'Sunday'),
    ])

    def __str__(self):
        return self.day

class Schedule(models.Model):
    employee = models.ForeignKey(Employee, on_delete=models.CASCADE)  # Employee linked to the schedule
    shift = models.ForeignKey(Shift, on_delete=models.CASCADE)  # The shift they are assigned to
    workdays = models.ManyToManyField(Workday)  # Allow multiple workdays

    def __str__(self):
        return f"{self.employee.user.username} - {self.shift.name} - {', '.join([day.day for day in self.workdays.all()])}"


class WorkHours(models.Model):
    employee = models.ForeignKey(Employee, on_delete=models.CASCADE)  # Employee linked to the work hours
    company = models.ForeignKey(Company, on_delete=models.CASCADE,null=True, blank=True)  # Linking work hours with company
    date = models.DateField()  # Date for which hours are calculated
    total_hours = models.DurationField()  # Total worked hours
    overtime_hours = models.DurationField(null=True, blank=True)  # Optional overtime hours

    def __str__(self):
        return f"{self.employee.user.username} - {self.date} - {self.total_hours}"      
    

shift_morning = Shift.objects.create(
    name="Morning Shift",
    start_time="08:00:00",
    end_time="14:00:00",
    company=Company.objects.get(id=1)  # রাফির কোম্পানির আইডি
)

employee_tahmid = Employee.objects.create(
    company=Company.objects.get(id=1),  # রাফির কোম্পানি
    employee_id="EMP123",
    department="IT",
    position="Developer",
    contact_number="017XXXXXXXX",
    date_of_joining="2023-10-01"
)

schedule = Schedule.objects.create(
    employee=employee_tahmid,  # তাহমিদ কর্মী
    shift=shift_morning,  # সকাল শিফট
)

AttendanceLog.objects.create(
    employee=employee_tahmid,
    company=employee_tahmid.company,
    device=Device.objects.get(id=1),  # ধরো একটা ডিভাইস
    punch_datetime="2023-10-14 08:10:00",
    in_out_status="IN",  # চেক-ইন
    verification_method="FP",  # ফিঙ্গারপ্রিন্ট
    punch_mode="AUTO",  # অটো মোড
    locationName="Office Main Gate",
    latitude=23.780777,
    longitude=90.419312
)

AttendanceLog.objects.create(
    employee=employee_tahmid,
    company=employee_tahmid.company,
    device=Device.objects.get(id=1),
    punch_datetime="2023-10-14 14:00:00",
    in_out_status="OUT",  # চেক-আউট
    verification_method="FP",
    punch_mode="AUTO",
    locationName="Office Main Gate",
    latitude=23.780777,
    longitude=90.419312
)

from datetime import timedelta

work_hours = timedelta(hours=5, minutes=50)  # তাহমিদ ৫ ঘণ্টা ৫০ মিনিট কাজ করেছেন
overtime = timedelta(hours=0)  # কোনো ওভারটাইম নেই

WorkHours.objects.create(
    employee=employee_tahmid,
    company=employee_tahmid.company,
    date="2023-10-14",  # কাজের তারিখ
    total_hours=work_hours,
    overtime_hours=overtime  # ওভারটাইম নেই
)