class Entry(models.Model):
#blog = models.EmbeddedField(model_container=Blog)
#
#blog = models.EmbeddedField(model_container=Blog,model_form_class=BlogForm)
blog = models.ForeignKey(Blog, on_delete=models.CASCADE)
headline = models.CharField(max_length=255)
body_text = models.TextField()
pub_date = models.DateField()
mod_date = models.DateField(default=datetime.now, )
authors = models.ArrayReferenceField(
to=Author,
on_delete=models.CASCADE,
)
n_comments = models.IntegerField(null=True, blank=True)
n_pingbacks = models.IntegerField(null=True, blank=True)
rating = models.IntegerField(null=True, blank=True)
objects = models.DjongoManager()
class Meta:
''
#indexes = [TextIndex(fields=['headline', ])]
#constraints = [CheckConstraint(check=Q(author_age__gte=18), name='age_gte_18')]
def __str__(self):
return self.headline
class Task(djongo_models.Model):
"""Unit of work to be done for the sprint."""
STATUS_TODO = 1
STATUS_IN_PROGRESS = 2
STATUS_TESTING = 3
STATUS_DONE = 4
STATUS_CHOICES = (
(STATUS_TODO, _('Not Started')),
(STATUS_IN_PROGRESS, _('In Progress')),
(STATUS_TESTING, _('Testing')),
(STATUS_DONE, _('Done')),
)
name = djongo_models.CharField(max_length=100)
description = djongo_models.TextField(blank=True, default='')
sprint = djongo_models.ForeignKey(Sprint, blank=True, null=True, on_delete=djongo_models.CASCADE)
status = djongo_models.SmallIntegerField(choices=STATUS_CHOICES, default=STATUS_TODO)
order = djongo_models.SmallIntegerField(default=0)
assigned = djongo_models.ForeignKey(settings.AUTH_USER_MODEL, null=True, blank=True, on_delete=djongo_models.SET_NULL)
started = djongo_models.DateField(blank=True, null=True)
due = djongo_models.DateField(blank=True, null=True)
completed = djongo_models.DateField(blank=True, null=True)
def __str__(self):
return self.name
class RoomReservationView(models.Model):
reservation_id = models.AutoField(primary_key=True)
hotel_id = models.ForeignKey(Hotel, on_delete=models.CASCADE)
customer_id = models.ForeignKey(Customer, on_delete=models.CASCADE)
room_id = models.ForeignKey(Room, on_delete=models.CASCADE)
reservation_description = models.CharField(max_length=60)
from_date = models.DateField()
to_date = models.DateField()
number_of_adults = models.IntegerField()
number_of_children = models.IntegerField()
payment_no = models.CharField(max_length=120, blank=True, null=True)
hotel = models.ArrayModelField(model_container=Hotel, )
customer = models.ArrayModelField(model_container=Customer, )
room = models.ArrayModelField(model_container=Room, )
def get_absolute_url(self):
return reverse('HotelsAppCRUD:rooms_reservation_index')
def __str__(self):
return "(%s) %s (%s) (%s)" % (self.reservation_id,
self.reservation_description,
self.from_date, self.to_date)
class Meta:
managed = False
db_table = 'HotelsAppCRUD_roomreservation_view'
class RoomReservation(models.Model):
reservation_id = models.AutoField(primary_key=True)
hotel_id = models.ForeignKey(Hotel,
on_delete=models.CASCADE,
related_name='reservation_hotel')
customer_id = models.ForeignKey(Customer,
on_delete=models.CASCADE,
related_name='reservation_customer',
default='')
room_id = models.ForeignKey(Room,
on_delete=models.CASCADE,
related_name='reservation_room')
reservation_description = models.CharField(max_length=60, default='')
from_date = models.DateField()
to_date = models.DateField()
number_of_adults = models.IntegerField()
number_of_children = models.IntegerField()
payment_no = models.CharField(max_length=120, blank=True, null=True)
def get_absolute_url(self):
return reverse('HotelsAppCRUD:rooms_reservation_index')
def __str__(self):
return "(%s) %s (%s) (%s)" % (self.reservation_id,
self.reservation_description,
self.from_date, self.to_date)
class ScraperEntry(models.Model):
_id = models.ObjectIdField()
supermarket = models.ForeignKey('Supermarket', on_delete=models.PROTECT)
time_start = models.DateField(blank=True, null=True)
time_end = models.DateField(blank=True, null=True)
sales = models.ArrayField(model_container=Sale, model_form_class=SaleForm)
objects = models.DjongoManager()
class Invoice(models.Model):
"""
Invoice Model
"""
number = models.AutoField(primary_key=True,
help_text="Invoice Number",
blank=False)
invoice_date = models.DateField(help_text="Invoice Date", blank=False)
reference_number = models.CharField(max_length=30,
help_text="Enter Reference Number/PO",
blank=False)
reference_date = models.DateField(help_text="PO/Order Date", blank=False)
addressed_to = models.TextField(max_length=300,
help_text="Invoice Addressed To",
blank=False)
party_gst = models.CharField(max_length=15,
help_text="GST Number of buyer",
blank=True)
created_at = models.DateTimeField(auto_created=True, editable=False)
modified_at = models.DateField(auto_now_add=True)
notes = models.TextField(max_length=1000,
blank=True,
help_text="Additional Notes")
items = models.ArrayField(model_container=Item)
s_gst = models.FloatField(help_text="S_GST Percentage", default=9)
c_gst = models.FloatField(help_text="C_GST Percentage", default=9)
other_charges = models.FloatField(help_text="Other Charges as needed")
total = models.FloatField(help_text="Invoice Total")
class Meta:
ordering = ["number"]
def __str__(self):
return "{}".format(self.number)
class Ferias(models.Model):
OPCOES = (
(15, "Quinze dias"),
(30, "Trinta dias"),
)
objects = models.Manager()
class FeriasFruidas(models.Manager):
def all(self):
return super().get_queryset().filter(
Q(tipo='f') & Q(data_termino__lt=timezone.now().date()) & Q(deferida=True))
class FeriasIndeferidas(models.Manager):
def all(self):
return super().get_queryset().filter(Q(tipo='f') & Q(deferida=False))
class FeriasEmAndamento(models.Manager):
def all(self):
return super().get_queryset().filter(Q(tipo='f') & Q(data_inicio__lte=timezone.now().date()) & Q(
data_termino__gte=timezone.now().date()) & Q(deferida=True))
fruidas = FeriasFruidas()
indeferidas = FeriasIndeferidas()
em_andamento = FeriasEmAndamento()
trabalhador = models.ForeignKey(Trabalhador, on_delete=models.CASCADE)
qtd_dias = models.IntegerField(choices=OPCOES)
data_inicio = models.DateField()
data_termino = models.DateField(editable=False)
criado_em = models.DateTimeField(auto_now_add=True)
modificado_em = models.DateTimeField(auto_now=True)
deferida = models.BooleanField(editable=False, default=False)
observacoes = models.TextField(blank=True, editable=False)
tipo = models.CharField(max_length=2, default='f', editable=False)
fruida = models.BooleanField(editable=False, default=False)
criado_por = models.ForeignKey(User, on_delete=models.SET_NULL, editable=False, null=True, blank=True)
def save(self, validacao=True, *args, **kwargs):
self.data_termino = self.data_inicio + timedelta(days=self.qtd_dias - 1)
if not validacao:
self.deferida = False
else:
self.deferida = valida_ferias(self)
super(Ferias, self).save(*args, **kwargs)
def __str__(self):
return '%d dias - %s -saindo %s' % (self.qtd_dias, self.trabalhador.nome, self.data_inicio.strftime("%d/%m/%Y"))
def get_absolute_url(self):
return reverse('ferias')
class Meta:
verbose_name_plural = "Férias"
verbose_name = "Férias"
ordering = ['data_inicio']
class Certification(models.Model):
credential_title = models.CharField(max_length=30)
credential_id = models.CharField(max_length=100)
credential_url = models.CharField(max_length=100)
issue_date = models.DateField()
expiration_date = models.DateField()
issuing_organization = models.CharField(max_length=100)
faculty = models.ForeignKey(Faculty, on_delete=models.CASCADE, null=True)
class MetaData(models.Model):
pub_date = models.DateField(auto_now_add=True)
mod_date = models.DateField(auto_now=True)
n_pingbacks = models.IntegerField()
rating = models.IntegerField()
class Meta:
abstract = True
class ReferenceMetaData(models.Model):
pub_date = models.DateField()
mod_date = models.DateField()
n_pingbacks = models.IntegerField()
rating = models.IntegerField()
class Meta:
abstract = True
class Assignments(models.Model):
name = models.TextField(blank=True, null=True)
account_name = models.TextField(blank=True, null=True)
start = models.DateField(blank=True, null=True)
p1_end = models.DateField(blank=True, null=True)
p2_end = models.DateField(blank=True, null=True)
p3_end = models.DateField(blank=True, null=True)
utilisation = models.FloatField(blank=True, null=True)
class Post(models.Model):
company = models.ForeignKey(Company, on_delete=models.CASCADE)
postDate = models.DateField(auto_now=True)
postExpiringDate = models.DateField(auto_now=False, blank=True, null=True)
postTechnology = models.CharField(
max_length=10, choices=TECHNOLOGY_CHOICES, default='wt')
def __str__(self):
return self.company.name + " - " + self.postTechnology
class Permis(models.Model):
prenom = models.CharField(max_length=60)
nom = models.CharField(max_length=40)
date_naissance = models.DateField()
lieu_naissance = models.CharField(max_length=40)
date_delivrance = models.DateField()
date_expiration = models.DateField()
numero = models.IntegerField()
groupe_sanguin = models.CharField(max_length=3)
categorie_vehicule = models.CharField(max_length=2)
class Operador(models.Model):
_id = models.CharField(max_length=10)
nombre = models.CharField(max_length=1000)
fecha_ingreso = models.DateField()
fecha_nacimiento = models.DateField()
Reclamo = models.ArrayField(model_container=Reclamo,
model_form_class=ReclamoForm)
def _str_(self):
return self._id
class Leave(models.Model):
id = models.CharField(max_length=250, primary_key=True)
emp_id = models.CharField(max_length=250)
leave_type = models.CharField(max_length=250)
date = models.DateField()
description = models.CharField(max_length=250)
posting_date = models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')
admin_remark = models.CharField(max_length=250, blank=True)
admin_remark_date = models.DateField(blank=True)
status = models.IntegerField(default=0)
is_read = models.BooleanField(default=False)
class User(models.Model):
uid = models.IntegerField(auto_created=True, primary_key=True)
name = models.CharField(max_length=50)
email = models.EmailField(null=True)
agency = models.ForeignKey(Agency, on_delete=models.CASCADE, null=True)
start_date = models.DateField(auto_now_add=True, null=True)
end_date = models.DateField(null=True)
licenses = models.ListField(models.CharField(max_length=30), null=True)
def __str__(self):
return self.name
class Loan_Details(models.Model):
Loan_Id = models.AutoField(primary_key=True)
Credit_Card_No = models.ForeignKey(Credit_Card, on_delete=models.CASCADE)
Loan_Type = models.CharField(max_length=10)
Loan_Amount = models.FloatField(validators=[MinValueValidator(0)])
Loan_Duration = models.IntegerField(validators=[MinValueValidator(0)
]) #in DAYS
Loan_Start_Date = models.DateField()
Loan_End_Date = models.DateField(
) # will be updated when loan is completed
Loan_Status = models.CharField(
max_length=20) #ongoing,completed,cancelled,UnRecovered.
class ReservedDate(models.Model):
person = models.ForeignKey(User, on_delete=models.CASCADE)
check_in = models.DateField()
check_out = models.DateField()
objects = models.DjongoManager()
def __str__(self):
return '{} > {}'.format(self.check_in, self.check_out)
class Meta:
abstract = True
ordering = ["room"]
class Entry(models.Model):
blog = models.ForeignKey(Blog, on_delete=models.CASCADE)
headline = models.CharField(max_length=255)
body_text = models.TextField()
pub_date = models.DateField()
mod_date = models.DateField()
authors = models.ManyToManyField(Author)
n_comments = models.IntegerField()
n_pingbacks = models.IntegerField()
rating = models.IntegerField()
def __str__(self):
return self.headline
class vtrueUser(AbstractBaseUser):
# MADN=models.CharField(max_length=50, primary_key=True)
# _id=models.CharField(max_length=100,null=True,blank=True)
MaDN = models.CharField(max_length=100, null=True, blank=True)
TenDN = models.CharField(max_length=100, null=True, blank=True)
ngaydangky = models.DateField(auto_now_add=True, null=True, blank=True)
DiaChiDangkyKD = models.CharField(max_length=200, null=True, blank=True)
DienThoaiDN = models.CharField(max_length=15, null=True, blank=True)
Fax = models.CharField(max_length=20, null=True, blank=True)
NganhNgheKDChinh = models.CharField(max_length=255, null=True, blank=True)
ThoigiandangkyKD = models.CharField(max_length=100, null=True, blank=True)
DaiDienCMND = models.CharField(max_length=20, null=True, blank=True)
TenNguoiDaiDien = models.CharField(max_length=50, null=True, blank=True)
ChucDanh = models.CharField(max_length=128, null=True, blank=True)
EmailNguoiDaiDien = models.EmailField(max_length=128,
null=True,
blank=True)
DienThoaiNguoiDaiDien = models.CharField(max_length=20,
null=True,
blank=True)
TenHoSoDinhKem = models.CharField(max_length=150, null=True, blank=True)
TrangThaiDuyet = models.IntegerField(null=True, blank=True)
NoiCapCMND = models.CharField(max_length=100, blank=True, null=True)
NgayCapCMND = models.DateField(blank=True, null=True)
DiaChiGiaoDich = models.CharField(max_length=200, blank=True, null=True)
requeststatus = models.IntegerField(blank=True, null=True)
matinhthanh = models.CharField(max_length=100, blank=True, null=True)
quanhuyen = models.CharField(max_length=200, blank=True, null=True)
TenTK = models.EmailField(max_length=128, unique=True, primary_key=True)
is_staff = models.BooleanField(default=False, null=True, blank=True)
is_active = models.BooleanField(default=False, null=True, blank=True)
MaCapBac = models.IntegerField(null=True, blank=True)
ThoiGian = models.DateTimeField(null=True, blank=True)
SessionTime = models.CharField(max_length=255, null=True, blank=True)
usertype = models.CharField(max_length=255, null=True, blank=True)
tensohuu = models.CharField(max_length=200, null=True, blank=True)
congty_phongban = models.CharField(max_length=200, null=True, blank=True)
firstLogin = models.DateTimeField(null=True, blank=True)
is_superuser = models.BooleanField(default=False, null=True, blank=True)
objects = UserManager()
USERNAME_FIELD = 'TenTK'
REQUIRED_FIELDS = [
'TenDN', 'DiaChiDangkyKD', 'matinhthanh', 'TenNguoiDaiDien',
'DienThoaiNguoiDaiDien', 'is_staff', 'is_active'
]
def has_perm(self, perm, obj=None):
return self.is_superuser
def has_module_perms(self, app_label):
return self.is_superuser
class Credit_Card(models.Model):
Username = models.ForeignKey(Personal_Information,
on_delete=models.CASCADE)
Credit_Card_No = models.CharField(primary_key=True, max_length=19)
Credit_Limit = models.IntegerField()
Date_Issued = models.DateField()
Date_Expired = models.DateField()
Credit_Card_Status = models.CharField(max_length=20,
default='Clear') #Blocked,Clear
Current_Balance = models.FloatField()
Rate_Of_Interest = models.FloatField()
def __str__(self):
return self.Credit_Card_No
class RatelistDataHelper(models.Model):
p_price = models.FloatField()
p_date = models.DateField()
s_price = models.FloatField()
s_date = models.DateField()
ratelistdata = models.ForeignKey(to=RatelistData,
on_delete=models.CASCADE,
related_name='rate')
class Meta:
ordering = ['id']
def __str__(self):
return f"{self.ratelistdata.user}/ {self.id}"
class Personal_Information(models.Model):
Username = models.CharField(primary_key=True, max_length=255)
First_Name = models.CharField(max_length=30)
Last_Name = models.CharField(max_length=30)
Email = models.EmailField()
DOB = models.DateField()
Gender = models.CharField(max_length=1)
PAN_Number = models.CharField(max_length=255)
PAN_Issue_Date = models.DateField()
Aadhar_Number = models.CharField(max_length=255)
Aadhar_Issue_Date = models.DateField()
def __str__(self):
return self.Username
class Story(models.Model):
id = models.AutoField(primary_key=True)
title = models.CharField(max_length=255, null=True, blank=True)
publisher = models.CharField(max_length=100, null=True, blank=True)
writer = models.CharField(max_length=100, null=True, blank=True)
lang = models.CharField(max_length=10, null=True, blank=True)
search = models.CharField(max_length=20, null=True, blank=True)
url = models.CharField(max_length=255, null=True, blank=True)
publication_date = models.DateField(null=True, blank=True)
added_date = models.DateField(null=True, blank=True)
topics = models.ArrayField(model_container=StringField)
content = models.TextField(null=True, blank=True)
class Meta:
db_table = 'story'
class SMSHistory(models.Model):
ThoiGian = models.DateField(default=datetime.date.today,
null=True,
blank=True)
SoDienThoai = models.CharField(max_length=100, null=True, blank=True)
SeriNo = models.CharField(max_length=100, null=True, blank=True)
Count = models.IntegerField(default=0, null=True, blank=True)
class Transaction(models.Model):
t_type = models.CharField("Income/Expense", max_length=15, null=True)
category = models.CharField(max_length=100)
source = models.CharField("Title", max_length=30)
amount = models.CharField(max_length=100, default="0")
notes = models.TextField("Additional Information", blank=True, null=True)
date_posted = models.DateField("Transaction Date (mm/dd/yyyy)",
auto_now_add=False,
auto_now=False,
blank=False,
null=True)
author = models.ForeignKey(User, on_delete=models.CASCADE)
year = models.IntegerField(null=True)
month = models.IntegerField(null=True)
class Meta:
ordering = ['-date_posted']
def __str__(self):
return self.source
def get_absolute_url(self):
# reverse will return the full path as a string so we can redirect to our transaction-detail template page for our newly created transaction
return reverse('budgeting-home')
def add_type(self, typeName):
self.t_type = typeName
class Task(models.Model):
""" Represents a Tasks assignable to users for project/topic nodes """
STATUS_CHOICES = [
("NEW", "New"),
("IN_PROGRESS", "In Progress"),
("COMPLETE", "Complete"),
]
_id = models.ObjectIdField()
# The node can be a Project or a Subclass of Topic
node = models.ForeignKey("TreeStructure", on_delete=models.CASCADE)
title = models.CharField(max_length=255, unique=False, blank=False)
created_by = models.ForeignKey("vpmoauth.MyUser", on_delete=models.CASCADE, related_name="created_task_set")
created_at = models.DateTimeField(auto_now_add=True, auto_now=False)
updated_at = models.DateTimeField(auto_now=True)
# The user the task is assigned to currently (defaults to created_by)
assignee = models.ForeignKey("vpmoauth.MyUser", on_delete=models.CASCADE, related_name="assigned_task_set")
status = models.CharField(max_length=11, choices=STATUS_CHOICES, blank=False, unique=False)
due_date = models.DateField(auto_now=False, auto_now_add=False, null=False)
closed_at = models.DateTimeField(auto_now=False, auto_now_add=False, null=True)
def __str__(self):
return "<{title}>: {due_date}".format(title=self.title, due_date=self.due_date.strftime("%d/%m/%Y"))
def save(self, *args, **kwargs):
""" Minor amendments to save for generic conditions """
if self.status != "COMPLETE":
self.closed_at = None
super(Task, self).save(*args, **kwargs)
class DatiPrezzi(models.Model):
_id = models.ObjectIdField()
web_scraper_order = models.CharField(max_length=20,
blank=False,
default='')
web_scraper_start_url = models.CharField(max_length=300,
blank=False,
default='')
stato = models.CharField(max_length=20, blank=False, default='')
regione = models.CharField(max_length=30, blank=False, default='')
provincia = models.CharField(max_length=20, blank=False, default='')
comune = models.CharField(max_length=20, blank=False, default='')
zip_code = models.CharField(max_length=20, blank=False, default='')
indirizzo = models.CharField(max_length=100, blank=False, default='')
nome_annuncio = models.CharField(max_length=500, blank=False, default='')
metri_quadri = models.IntegerField(blank=False, default=-1)
prezzo = models.IntegerField(blank=False, default=-1)
affitto_vendita_choices = (
('A', 'Affitto'),
('V', 'Vendita'),
)
affitto_vendita = models.CharField(max_length=1,
choices=affitto_vendita_choices)
data_inserimento = models.DateField(_("Date"), auto_now_add=True)
fascia_prezzo_choices = (
('B', 'Bassa'),
('M', 'Media'),
('A', 'Alta'),
)
fascia_prezzo = models.CharField(max_length=1,
choices=fascia_prezzo_choices)
latitudine = DecimalField(max_digits=9, decimal_places=6)
longitudine = DecimalField(max_digits=9, decimal_places=6)
class LibroEgreso(models.Model):
operacion_tipo = models.CharField(
max_length=200,
verbose_name="Tipo de documento que respalda el Egreso")
operacion_fecha = models.DateField(max_length=20,
verbose_name="Fecha",
blank=False)
comprobante_timbrado = models.IntegerField(verbose_name="Timbrado",
blank=False)
comprobante_nro = models.CharField(max_length=20,
verbose_name="Número",
blank=False)
comprobante_condicion = models.CharField(max_length=20,
verbose_name="Condición de venta")
proveedor_tipo_identificacion = models.CharField(
max_length=20, verbose_name="Tipo de Identificación", blank=False)
proveedor_nro_identificacion = models.CharField(
max_length=20, verbose_name="Número de Identificación", blank=False)
proveedor_razon = models.CharField(
max_length=200,
verbose_name="Nombres y Apellidos o Razón Social",
blank=False)
gravadas_10 = models.IntegerField(verbose_name="Gravadas 10%", blank=False)
gravadas_5 = models.IntegerField(verbose_name="Gravadas 5%", blank=False)
exentas = models.IntegerField(verbose_name="Exentas", blank=False)
egreso_tipo = models.CharField(max_length=200,
verbose_name="Tipo de Egreso",
blank=False)
egreso_clasificacion = models.CharField(
max_length=500, verbose_name="Clasificación de Egreso")
class GenericModel(models.Model):
big_int = models.BigIntegerField()
bool = models.BooleanField()
char = models.CharField(max_length=20)
comma_int = models.CommaSeparatedIntegerField()
date = models.DateField()
date_time = models.DateTimeField()
decimal = models.DecimalField(max_digits=10, decimal_places=5)
email = models.EmailField()
float = models.FloatField()
integer = models.IntegerField()
null_bool = models.NullBooleanField()
pos_int = models.PositiveIntegerField()
pos_small_int = models.PositiveSmallIntegerField()
slug = models.SlugField()
small_int = models.SmallIntegerField()
text = models.TextField()
time = models.TimeField()
url = models.URLField()
ip = models.GenericIPAddressField()
uuid = models.UUIDField()
# TODO: add these
# basic_file = models.FileField()
# image = models.ImageField()
objects = models.DjongoManager()
