aboutsummaryrefslogtreecommitdiffstats
path: root/client/models.py
blob: c6cfdfd045452cfce7d70db09a88bdd88e37ba9e (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
from django.db import models
from django.contrib.auth.models import User, Group
from datetime import datetime

# Create your models here.


class DocumentType(models.Model):
    enabled = models.BooleanField(default=False)
    auto_sign = models.BooleanField(default=False)
    group_private = models.BooleanField(default=False)
    group = models.ForeignKey(Group, default=None, on_delete=models.CASCADE)
    custom_group = models.BooleanField(default=False)
    personal_data = models.BooleanField(default=False)
    medical_data = models.BooleanField(default=False)
    custom_data = models.BooleanField(default=False)
    custom_message = models.BooleanField(default=False)
    custom_message_text = models.CharField(default="", max_length=2048)
    staff_only = models.BooleanField(default=False)
    max_instances = models.IntegerField(default=0)
    name = models.CharField(default="", max_length=250)


class HideGroup(models.Model):
    group = models.ForeignKey(Group, default=None, on_delete=models.CASCADE)
    doc_type = models.ForeignKey(DocumentType, default=None, on_delete=models.CASCADE)


class PersonalData(models.Model):
    parent_name = models.CharField(default="", max_length=250)
    via = models.CharField(default="", max_length=250)
    cap = models.CharField(default="", max_length=250)
    country = models.CharField(default="", max_length=250)
    nationality = models.CharField(default="", max_length=250)
    born_date = models.DateField(null=True, default=datetime.fromtimestamp(0))
    home_phone = models.CharField(default="", max_length=250)
    phone = models.CharField(default="", max_length=250)
    email = models.CharField(default="", max_length=250)
    school = models.CharField(default="", max_length=250)
    year = models.IntegerField(default=0)
    avs_number = models.CharField(default="", max_length=250)


class MedicalData(models.Model):
    emer_name = models.CharField(default="", max_length=250)
    emer_relative = models.CharField(default="", max_length=250)
    cell_phone = models.CharField(default="", max_length=250)
    address = models.CharField(default="", max_length=250)
    emer_phone = models.CharField(default="", max_length=250)
    health_care = models.CharField(default="", max_length=250)
    injuries = models.CharField(default="", max_length=250)
    rc = models.CharField(default="", max_length=250)
    rega = models.BooleanField(default=False)
    medic_name = models.CharField(default="", max_length=250)
    medic_phone = models.CharField(default="", max_length=250)
    medic_address = models.CharField(default="", max_length=250)
    sickness = models.CharField(default="", max_length=250)
    vaccine = models.CharField(default="", max_length=250)
    tetanus_date = models.DateField(null=True, default=datetime.fromtimestamp(0))
    allergy = models.CharField(default="", max_length=250)
    drugs_bool = models.BooleanField(default=False)
    drugs = models.CharField(default="", max_length=250)
    misc_bool = models.BooleanField(default=False)
    misc = models.CharField(default="", max_length=250)
    vac_certificate = models.FileField(upload_to='documents/', null=True)
    health_care_certificate = models.FileField(default=None, upload_to='documents/', null=True)


class Keys(models.Model):
    container = models.ForeignKey(
        DocumentType, db_index=True, on_delete=models.CASCADE)
    key = models.CharField(max_length=2048, db_index=True)
    key_extra = models.CharField(max_length=2048, default="")


class UserCode(models.Model):
    user = models.ForeignKey(User, default=None, on_delete=models.CASCADE)
    medic = models.ForeignKey(MedicalData, default=None, on_delete=models.PROTECT)
    code = models.IntegerField(default=0)
    branca = models.ForeignKey(Group, default=None, on_delete=models.PROTECT, null=True)
    first_name = models.CharField(default="", max_length=250)
    last_name = models.CharField(default="", max_length=250)
    email = models.CharField(default="", max_length=250)
    parent_name = models.CharField(default="", max_length=250)
    via = models.CharField(default="", max_length=250)
    cap = models.CharField(default="", max_length=250)
    country = models.CharField(default="", max_length=250)
    nationality = models.CharField(default="", max_length=250)
    born_date = models.DateField(null=True, default=datetime.fromtimestamp(0))
    home_phone = models.CharField(default="", max_length=250)
    phone = models.CharField(default="", max_length=250)
    school = models.CharField(default="", max_length=250)
    year = models.IntegerField(default=0)
    avs_number = models.CharField(default="", max_length=250)
    midata_id = models.IntegerField(default=0)
    midata_token = models.CharField(default="", max_length=1024)


class Document(models.Model):
    usercode = models.ForeignKey(UserCode, default=None, on_delete=models.CASCADE)
    user = models.ForeignKey(User, default=None, on_delete=models.CASCADE, null=True)
    group = models.ForeignKey(Group, default=None, on_delete=models.CASCADE)
    code = models.IntegerField(default=0)
    compilation_date = models.DateTimeField(auto_now_add=True)
    status = models.CharField(default="", max_length=50)
    document_type = models.ForeignKey(
        DocumentType, default=None, on_delete=models.PROTECT)

    personal_data = models.ForeignKey(
        PersonalData, default=None, on_delete=models.PROTECT, null=True)

    medical_data = models.ForeignKey(
        MedicalData, default=None, on_delete=models.SET_NULL, null=True)

    signed_doc = models.FileField(default=None, upload_to='documents/', null=True)

    class Meta:
        permissions = [
            ("approved", "The user is approved"),
            ("staff", "The user is staff of the non primary group")
        ]


class KeyVal(models.Model):
    container = models.ForeignKey(
        Document, db_index=True, on_delete=models.CASCADE)
    key = models.CharField(max_length=2048, db_index=True)
    value = models.CharField(max_length=2048, db_index=True)


class GroupSettings(models.Model):
    group = models.ForeignKey(Group, default=None, on_delete=models.CASCADE)
    view_documents = models.BooleanField(default=False)