class PaymentRefund(models.Model): id = models.AutoField(primary_key=True) user_payment = models.ForeignKey(UserPayment, on_delete=models.CASCADE) date = models.DateTimeField(auto_now_add=True) def __str__(self): return '{}'.format(self.user_payment)
class Post(models.Model): id = models.AutoField(primary_key=True) category = models.ForeignKey(Category, on_delete=models.CASCADE, related_name='posts') title = models.CharField(max_length=255) # title_vn = models.CharField(max_length=255) content = models.TextField() # content_vn = models.TextField() created_at = models.DateTimeField(auto_now_add=True) update_at = models.DateTimeField(auto_now=True) thumbnail = models.TextField(null=True) author = models.ForeignKey(get_user_model(), on_delete=models.CASCADE, related_name='posts', default=1) author_username = models.CharField(max_length=100, default="admin") # publish = models.DateTimeField(auto_now=False, auto_now_add=False) likes = models.ManyToManyField(get_user_model()) objects = models.DjongoManager() hidden = models.BooleanField(default=False) flag = models.BooleanField(default=False) def __str__(self): return f'{self.title}'
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 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 Category(models.Model): id = models.AutoField(primary_key=True) name = models.CharField(max_length=255) objects = models.DjongoManager() 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 Audit(models.Model): audit_id = models.AutoField(primary_key=True) organization = models.ForeignKey(to='organization.Organization', on_delete=models.CASCADE, blank=False, null=False, default=0) inventory_items = models.ManyToManyField(Item, blank=True, default=0) assigned_sk = models.ManyToManyField(to='user_account.CustomUser', blank=True, default=0) initiated_by = models.ForeignKey(to=USER_MODEL, on_delete=models.CASCADE, related_name='initiated_by') initiated_on = models.DateTimeField( auto_now_add=True) # Auto set when object is first created last_modified_on = models.DateTimeField( auto_now=True) # Auto set every time object is saved assigned_sk = models.ManyToManyField(to=USER_MODEL, blank=True, default=0) template_id = models.ForeignKey(AuditTemplate, on_delete=models.CASCADE, blank=True, null=True) accuracy = models.FloatField(default=0.0) ACTIVE = 'Active' AUDIT_STATUS = [(PENDING, 'Pending'), (COMPLETE, 'Complete'), (ACTIVE, 'Active')] status = models.CharField(max_length=12, choices=AUDIT_STATUS, default=PENDING)
class Order(models.Model): # order_id = models.CharField(max_length=50,null=True,blank=True) id = models.AutoField(primary_key=True) customer = models.ForeignKey(Customer, on_delete=models.CASCADE) order_number = models.CharField(max_length=100, null=True, blank=True) payment_id = models.CharField(max_length=50, null=True, blank=True) order_date = models.DateTimeField(auto_now_add=True) ship_date = models.DateTimeField(default='') required_date = models.DateField() # shipper_id = models.ForeignKey(Shipper, on_delete=models.CASCADE, db_column='shipper_id') freight = models.CharField(max_length=100, null=True, blank=True) sale_tax = models.CharField(max_length=100, null=True, blank=True) timestamp = models.DateTimeField(auto_now_add=True) transaction_status = models.CharField(max_length=1, choices=Trasaction_status) error_lock = models.CharField(max_length=100, null=True, blank=True) error_msg = models.CharField(max_length=100, null=True, blank=True) fullfiled = models.BooleanField(default=False) deleted = models.BooleanField(default=False) paid = models.BooleanField(default=False) payment_date = models.DateTimeField(auto_now_add=True) created_at = models.DateTimeField(auto_now=False, auto_now_add=True) updated_at = models.DateTimeField(auto_now=True, auto_now_add=False) def __str__(self): return self.order_number
class Payment(models.Model): id = models.AutoField(primary_key=True) order = models.ForeignKey(Order, on_delete=models.DO_NOTHING) payment_type = models.CharField(max_length=10, choices=PAYMENT_MODE) allowed = models.BooleanField(default=False) created_at = models.DateTimeField(auto_now=False, auto_now_add=True) updated_at = models.DateTimeField(auto_now=True, auto_now_add=False)
class StateSave(models.Model): id = models.AutoField(primary_key=True) name = models.CharField(max_length=200, null=True) description = models.CharField(max_length=400, null=True) save_time = models.DateTimeField(auto_now=True, db_index=True) create_time = models.DateTimeField(auto_now_add=True) save_id = models.UUIDField(default=uuid.uuid4) data_dump = models.TextField(null=False) shared = models.BooleanField(default=False) owner = models.ForeignKey(get_user_model(), null=True, on_delete=models.CASCADE) base64_image = models.ImageField(upload_to='circuit_images', storage=file_storage, null=True) version = models.CharField(max_length=20, null=False) branch = models.CharField(max_length=20, null=False) is_arduino = models.BooleanField(default=False, null=False) esim_libraries = models.ManyToManyField(Library) project = models.ForeignKey(to=Project, on_delete=models.SET_NULL, null=True) def save(self, *args, **kwargs): super(StateSave, self).save(*args, **kwargs) def __str__(self): return self.name
class Gallery(models.Model): id = models.AutoField(primary_key=True) save_id = models.CharField(unique=True, max_length=500, null=False) data_dump = models.TextField(null=False) name = models.CharField(max_length=100, default="Untitled") description = models.CharField(max_length=1000) media = models.ImageField(upload_to='circuit_images_esim', storage=file_storage, null=True) shared = models.BooleanField(default=True) save_time = models.DateTimeField(auto_now=True) is_arduino = models.BooleanField(default=False, null=False) esim_libraries = models.ManyToManyField(Library) # For Django Admin Panel def image_tag(self): print(file_storage) if self.media: return mark_safe( '<img src="%s" style="width: 45px; height:45px;" />' % self.media.url) # noqa else: return 'No Image Found' image_tag.short_description = 'Image' def __str__(self): return self.name
class RoomBilling(models.Model): reservation_id = models.AutoField(primary_key=True) customer_id = models.ForeignKey(Customer, on_delete=models.CASCADE, related_name='billing_customer') room_charge_id = models.ForeignKey(RoomCharges, on_delete=models.CASCADE, related_name='billing_charge') invoice_no = models.CharField(max_length=120, default='') billing_address1 = models.CharField(max_length=120) billing_address2 = models.CharField(max_length=120, blank=True, null=True) county = models.CharField(max_length=120) postal_code = models.CharField(max_length=20) country = models.CharField(max_length=120) total_discounts = models.DecimalField(max_digits=5, decimal_places=2, default='') total_invoice = models.DecimalField(max_digits=5, decimal_places=2, default='') def get_absolute_url(self): return reverse('HotelsAppCRUD:rooms_billing_index') def __str__(self): return "(%s) %s" % (self.reservation_id, self.invoice_no)
class Disease(models.Model): disease_id = models.AutoField(primary_key=True) disease_name = models.CharField(max_length=100) disease_description = models.CharField(max_length=2000, default="") disease_causes = models.CharField(max_length=2000, default="") link = models.CharField(max_length=500, default="") remedies = models.CharField(max_length=500, default="")
class Project(models.Model): id = models.AutoField(primary_key=True) project_lead = models.ForeignKey(UserProfile, on_delete=models.CASCADE, null=True) preview = models.BooleanField( default=True ) # project will only appear in Project List when set to False # UI properties title = models.CharField(max_length=454, null=True) summary = models.CharField(max_length=254) skills_needed = models.ManyToManyField(Skill) learning_opportunities = models.ManyToManyField(Goal) civic_interests = models.ManyToManyField(Interest) pending_tasks = models.CharField(max_length=454, null=True) progress_made = models.CharField(max_length=454, null=True) additional_info = models.CharField(max_length=454, null=True) slack_channel = models.CharField(max_length=200) # Admin properties github_repository = models.CharField(max_length=454, null=True) website = models.CharField(max_length=454, null=True) twitter = models.CharField(max_length=454, null=True) def save(self, *args, **kwargs): super(Project, self).save(*args, **kwargs) def __str__(self): return self.title
class Bid(models.Model): """ Bid object. The criteria a buyer specifies for a swipe such that he/she is willing to purchase the swipe. """ BID_STATES = [ ( '0', 'Pending' ), # Doesn't meet minimum, sits in the queue until an eligible listing pops up ( '1', 'Accepted' ), # Pairing between buyer and seller has been made (either at the time of bid or after a swipe was created) ( '2', 'Confirmed' ), # Transaction has occured between buyer and seller, whether successful or refund-based ] bid_id = models.AutoField(primary_key=True) status = models.CharField(max_length=1, choices=BID_STATES, default=0) swipe = models.ForeignKey(Swipe, on_delete=models.CASCADE, null=True) buyer = models.ForeignKey(User, on_delete=models.DO_NOTHING) hall_id = models.ForeignKey(DiningHall, on_delete=models.DO_NOTHING) bid_price = models.DecimalField(max_digits=5, decimal_places=2) desired_time = models.TimeField(null=True) visibility = models.ListField( blank=True, null=True, default=[] ) # An array of JSON objects that contains intervals when this buyer wants the swipe
class OrderUpdate(models.Model): update_id = models.AutoField(primary_key=True) order_id = models.IntegerField(default="") update_desc = models.CharField(max_length=5000) timestamp = models.DateField(auto_now_add=True) def __str__(self): return self.update_desc[0:7] + "..."
class stay(models.Model): id = models.AutoField(primary_key=True) name = models.CharField(max_length=30) place = models.CharField(max_length=30) cost = models.IntegerField(max_length=10) def __str__(self): return self.name
class User(models.Model): """ User object. Both buyers and sellers are users. """ USER_STATES = [('0', 'New'), ('1', 'Active'), ('2', 'Banned')] status = models.CharField(max_length=1, choices=USER_STATES, default=0) user_id = models.AutoField(primary_key=True) name = models.CharField(max_length=255)
class Posts(models.Model): id = models.AutoField(primary_key=True) post_title = models.CharField(max_length=255) post_description = models.TextField() comment = models.JSONField() tags = models.JSONField() user_details = models.JSONField() objects = models.DjongoManager()
class TestData(models.Model): id = models.AutoField(primary_key=True) testDataName = models.CharField(max_length=50) testDataDescription = models.CharField(max_length=50) testDataStatus = models.BooleanField(default=True) _id = models.ForeignKey(TestScenarios, related_name='testdata', on_delete=models.CASCADE)
class Application(models.Model): id = models.AutoField(primary_key=True) appName = models.CharField(max_length=23) totalDevices = models.BigIntegerField(10) totalScenarios = models.BigIntegerField(10) activeStatus = models.BooleanField(default=True) preConditionStatus = models.BigIntegerField(10) objectRunStatus = models.BigIntegerField(10)
class TestScenarios(models.Model): id = models.AutoField(primary_key=True) scenarioName = models.CharField(max_length=50) scenarioDescription = models.CharField(max_length=100) activeStatus = models.BooleanField(default=True) _id = models.ForeignKey(Application, related_name='testscenarios', on_delete=models.CASCADE)
class Servicio(models.Model): id = models.AutoField(primary_key=True) nombre = models.CharField(max_length=15) fecha = models.DateField() totalFactura = models.FloatField() def __str__(self): return 'Servicio: {}:{}'.format(self.id, self.nombre)
class ProductContainer(models.Model): """Each single product information""" container_id = models.AutoField(primary_key=True) store_id = models.OneToOneField('Stores', on_delete=models.CASCADE) container_owner = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE) def __str__(self): return str(self.container_id)
class Category(models.Model): class Meta: abstract = True category_id = models.AutoField(primary_key=True) category_value = models.TextField() parent_id = models.IntegerField() category_url = models.TextField() category_shop_id = models.IntegerField()
class Contact(models.Model): msg_id = models.AutoField(primary_key=True) name = models.CharField(max_length=50) email = models.CharField(max_length=70, default="") phone = models.CharField(max_length=70, default="") desc = models.CharField(max_length=500, default="") def __str__(self): return self.name
class Bucket(models.Model): id = models.AutoField(primary_key=True) name = models.CharField('name', max_length=50) created_at = models.DateTimeField(auto_now=True) class Meta: ordering = ['created_at'] def __str__(self): return str(self.name)
class User_diagnosis(models.Model): id = models.AutoField(primary_key=True) user_id = models.CharField(max_length=100) userResponses = models.CharField(max_length=1000) userResults = models.CharField(max_length=300) create_date = models.DateTimeField() modify_date = models.DateTimeField() isFeedbackGiven = models.IntegerField() feedbackRating = models.IntegerField() feedbackText = models.CharField(max_length=5000)
class Audit(models.Model): audit_id = models.AutoField(primary_key=True) organization = models.ForeignKey(Organization, on_delete=models.CASCADE, blank=False, null=False, default=0) status = models.CharField(max_length=50, default="Pending") inventory_items = models.ManyToManyField(Item, blank=True, default=0) assigned_sk = models.ManyToManyField(CustomUser, blank=True, default=0)
class PriceTrackingData(models.Model): track_id = models.AutoField(primary_key=True) product_id = models.ForeignKey(Product, related_name='ProductDeatils', on_delete=models.CASCADE) email = models.EmailField(max_length=100, verbose_name="Email") price_value = models.CharField(max_length=100, verbose_name="Type Of Price") price_percent = models.CharField(max_length=100, verbose_name="Type Of Percentage")