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