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()