import json from django.contrib.contenttypes.fields import GenericRelation from django.db import models class TtActivity(models.Model): code = models.CharField(max_length=150) name = models.CharField(max_length=255) desc = models.TextField(null=True) activity_template = models.ForeignKey("api.TtActivityTemplate", on_delete=models.CASCADE, null=True) activity_type = models.ForeignKey("api.TtActivityType", on_delete=models.SET_NULL, null=True) department = models.ForeignKey("api.TtDepartment", on_delete=models.SET_NULL, null=True) zone = models.ForeignKey("api.TtZone", on_delete=models.SET_NULL, null=True) academic_term = models.ForeignKey("api.TtAcademicTerm", on_delete=models.CASCADE, null=True) module = models.ForeignKey("api.TtModule", on_delete=models.CASCADE, null=True) duration = models.IntegerField(null=True,db_comment="in minute") slot_required = models.IntegerField(null=True) sequence_number = models.IntegerField(null=True) planned_size = models.IntegerField(null=True) real_size = models.IntegerField(null=True) staff_requirement_type = models.IntegerField(default=0, db_comment="0-None, 1-wildcard, 2-preset") staff_requirement = models.IntegerField(default=0,db_comment="if wildcard only will set this value, if got set activity template staff, this will update to 0") location_requirement_type = models.IntegerField(default=0, db_comment="0-None, 1-wildcard, 2-preset") location_requirement = models.IntegerField(default=0,db_comment="if wildcard only will set this value, if got set activity template location, this will update to 0") scheduled_start_time = models.TimeField(null=True) scheduled_day = models.SmallIntegerField(null=True,db_comment="0 - Monday, 6 - Sunday") scheduled_start_slot = models.IntegerField(null=True, db_comment="0-335(depends on based setting)") suggested_day = models.SmallIntegerField(null=True,db_comment="0 - Monday, 6 - Sunday") suggested_time = models.TimeField(null=True) suggested_time_slot = models.IntegerField(null=True) week_pattern = models.ForeignKey("api.TtWeekPattern",on_delete=models.SET_NULL,null=True,blank=True,db_comment="NULL means custom") availability = models.ForeignKey("api.TtAvailability",on_delete=models.SET_NULL,null=True,blank=True,db_comment="NULL means custom") availability_pattern = models.TextField(null=True) start_preference = models.ForeignKey("api.TtStartPreference",on_delete=models.SET_NULL,null=True,blank=True,db_comment="NULL means custom") start_preference_pattern = models.TextField(null=True) usage_preference = models.ForeignKey("api.TtUsagePreference",on_delete=models.SET_NULL,null=True,blank=True,db_comment="NULL means custom") usage_preference_pattern = models.TextField(null=True) extra_data_1 = models.TextField(null=True) extra_data_2 = models.TextField(null=True) extra_data_3 = models.TextField(null=True) extra_data_4 = models.TextField(null=True) extra_data_5 = models.TextField(null=True) extra_data_6 = models.TextField(null=True) extra_data_7 = models.TextField(null=True) extra_data_8 = models.TextField(null=True) extra_data_9 = models.TextField(null=True) extra_data_10 = models.TextField(null=True) is_jta = models.IntegerField(null=True,default=0) jta_parent = models.ForeignKey('self',on_delete=models.SET_NULL,null=True,blank=True,related_name="jta_children",db_comment="actually is the 2 parent have this value of the new child id") is_variant = models.IntegerField(null=True,default=0) variant_parent = models.ForeignKey('self',on_delete=models.SET_NULL,null=True,blank=True,related_name="variant_children") scheduled = models.IntegerField(null=True,default=0) is_booking = models.IntegerField(null=True,default=0) min_day = models.IntegerField(null=True,default=None,db_comment="only succeeding type will used") min_hour = models.IntegerField(null=True,default=None,db_comment="only succeeding type will used") min_minute = models.IntegerField(null=True,default=None,db_comment="only succeeding type will used") min_slot_required = models.IntegerField(null=True,default=None) max_day = models.IntegerField(null=True,default=None,db_comment="only succeeding type will used") max_hour = models.IntegerField(null=True,default=None,db_comment="only succeeding type will used") max_minute = models.IntegerField(null=True,default=None,db_comment="only succeeding type will used") max_slot_required = models.IntegerField(null=True,default=None,db_comment="only succeeding type will used") status = models.SmallIntegerField() created_by = models.BigIntegerField(null=True) created_at = models.DateTimeField(auto_now_add=True) updated_by = models.BigIntegerField(null=True) updated_at = models.DateTimeField(auto_now=True) # wont add column, just want create relation between staff and tt_tag_relation table week = models.ManyToManyField("api.TtWeek",through="api.TtActivityWeek") staff = models.ManyToManyField("api.TtStaff",through="api.TtActivityStaff") location = models.ManyToManyField("api.TtLocation",through="api.TtActivityLocation") student_set = models.ManyToManyField("api.TtStudentSet",through="api.TtStudentSetActivity") staff_preset = models.ManyToManyField("api.TtStaff",through="api.TtActivityStaffPreset",related_name="activity_staff_preset") staff_suitability = models.ManyToManyField("api.TtSuitability",through="api.TtActivityStaffSuitability",related_name="activity_staff_suitability") location_preset = models.ManyToManyField("api.TtLocation",through="api.TtActivityLocationPreset",related_name="activity_location_preset") location_suitability = models.ManyToManyField("api.TtSuitability",through="api.TtActivityLocationSuitability",related_name="activity_location_suitability") sequencing = models.ManyToManyField("self",through="api.TtActivitySequencing",symmetrical=False) tag = GenericRelation( "api.TtTagRelation", content_type_field="refer_table", object_id_field="refer_id", ) STATUS_TO_CODE = { "active": 1, "inactive": 2, } STAFF_REQUIREMENT_TYPE = { "none": 0, "wildcard": 1, "preset": 2, } LOCATION_REQUIREMENT_TYPE = { "none": 0, "wildcard": 1, "preset": 2, } IMPORT_RULES = { "code": ["required", "string", "unique"], "name": ["required", "string"], "desc": ["nullable", "string"], "activity_template_id": ["required", "exist"], # cant update "department_id": ["nullable", "exist"], # department code "zone_id": ["nullable", "exist"], # zone code "sequence_number": ["nullable", "integer"], "slot_required": ["required", "integer"], "planned_size": ["required", "integer"], "staff_requirement": ["nullable", "integer"], "location_requirement": ["nullable", "integer"], "week_pattern_id": ["nullable", "exist"], # week_pattern code "availability_id": ["nullable", "exist"], # availability code "availability_pattern": ["nullable", "string"], "start_preference_id": ["nullable", "exist"], # start_preference code "start_preference_pattern": ["nullable", "string"], "usage_preference_id": ["nullable", "exist"], # usage_preference code "usage_preference_pattern": ["nullable", "string"], "scheduled_start_time": ["nullable", "time"], "scheduled_day": ["nullable", "integer"], # 0-6 "suggested_time": ["nullable", "time"], "suggested_day": ["nullable", "integer"], # 0-6 "is_jta": ["nullable", "integer"], # 0 or 1 "jta_parent_id": ["nullable", "exist"], # activity code "is_variant": ["nullable", "integer"], # 0 or 1 "variant_parent_id": ["nullable", "exist"], # activity code **{ f"extra_data_{i}": ["nullable", "string"] for i in range(1, 11) }, } BOOKING = { "IMPORT_RULES": { "code": ["required", "string", "unique"], "name": ["required", "string"], "desc": ["nullable", "string"], "planned_size": ["nullable", "integer"], "slot_required": ["required", "integer"], "department_id": ["nullable", "exist"], # department code "activity_type_id": ["required", "exist"], # activity type code "start_date_time": ["nullable", "date_time"], "location_id": ["nullable", "exist"], # location code **{ f"extra_data_{i}": ["nullable", "string"] for i in range(1, 11) }, } } class Meta: db_table = "tt_activity" def __str__(self): return self.name