22 lines
917 B
Python
22 lines
917 B
Python
import uuid
|
|
from django.db import models
|
|
|
|
|
|
class ESGFieldReport(models.Model):
|
|
id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
|
|
batch = models.ForeignKey("batches.ProcessingBatch", on_delete=models.CASCADE, related_name="esg_reports")
|
|
women_employed = models.IntegerField(default=0)
|
|
total_workers = models.IntegerField(default=0)
|
|
fair_wage_paid = models.BooleanField(default=False)
|
|
safety_equipment_used = models.BooleanField(default=False)
|
|
community_notes = models.TextField(blank=True)
|
|
reported_by = models.CharField(max_length=255, blank=True)
|
|
report_date = models.DateField(null=True, blank=True)
|
|
created_at = models.DateTimeField(auto_now_add=True)
|
|
|
|
class Meta:
|
|
db_table = "esg_field_reports"
|
|
verbose_name = "ESG Field Report"
|
|
|
|
def __str__(self):
|
|
return f"ESG - {self.batch.batch_reference} - {self.report_date}"
|