Hello,
Please help with the below, I am trying to get dispense_quantity from
Dispense Model and subtract it from the quantity on Stock Model.
Then after that get something like this;
@property
def closing_stock(self):
return (self.quantity - self. quantity_issued )
class Stock(models.Model):
unit_price = models.DecimalField(max_digits=10, decimal_places=2,
default='0', blank=True, null=True)
quantity = models.IntegerField(default='0', blank=True, null=True)
total_price = models.DecimalField(max_digits=10, decimal_places=2,
default=1)
total_stock = models.IntegerField(default='0', blank=True, null=True)
receive_quantity = models.IntegerField(default='0', blank=True, null=True)
reorder_level = models.IntegerField(default='0', blank=True, null=True)
reorder_price = models.DecimalField(max_digits=10,
decimal_places=2, default='0', blank=True, null=True)
def __str__(self):
return str(self.drug_name)
@property
def total_price(self):
return (self.quantity + self.reorder_level) * self.unit_price
@property
def total_stock(self):
return (self.quantity + self.reorder_level)
@property
def reorder_stock(self):
return (self.reorder_level * self.reorder_price)
class Dispense(models.Model):
nurse = models.ForeignKey(Pharmacist, on_delete=models.CASCADE, null=True)
patient_id = models.ForeignKey(Patients,
on_delete=models.DO_NOTHING, null=True)
drug_id = models.ForeignKey(Stock, on_delete=models.SET_NULL,
null=True, blank=False)
dispense_quantity = models.PositiveIntegerField(default='1',
blank=False, null=True)
taken = models.CharField(max_length=300, null=True, blank=True)
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CADYG20E1AotncUkEVrooR4RqHr24gPK_oCd8S4iqre2HOfdABg%40mail.gmail.com.
