我正在做一个Django项目,这是一个简单的餐厅管理系统。其中一个关键的功能是记录库存和采购。我希望添加一些功能,一旦我创建了一个购买实例,我的程序就会自动减少库存,减少在购买中使用的数量。
我一直在挠我的头,在互联网上打探,但老实说,我不知道从哪里开始。这是我的第一个Django项目,所以非常感谢您的指导。
关于我的models.py和views.py,见下文。
Models.py
class Inventory(models.Model):
ingredient_name = models.CharField(max_length=30)
price = models.DecimalField(max_digits=5, decimal_places=2)
units_avail = models.IntegerField()
def __str__(self):
return self.ingredient_name + " avail: " + str(self.units_avail)
def get_absolute_url(self):
return "/inventory"
class MenuItem(models.Model):
menu_item_name = models.CharField(max_length=100)
price = models.DecimalField(max_digits=5, decimal_places=2)
def __str__(self):
return self.menu_item_name + " with Price: " + str(self.price)
def available(self):
return all(recipe_req.enough() for recipe_req in self.reciperequirement_set.all())
def get_absolute_url(self):
return "/menu"
def cost(self):
item_cost = 0
for recipe_req in self.reciperequirement_set.all():
item_cost += recipe_req.ingredient.price
return item_cost
def profit(self):
item_cost = self.cost()
item_profit = self.price - item_cost
return item_profit
class RecipeRequirement(models.Model):
ingredient = models.ForeignKey(Inventory, on_delete=models.CASCADE)
menu_item = models.ForeignKey(MenuItem, on_delete=models.CASCADE)
quantity = models.IntegerField()
def __str__(self):
return self.ingredient.ingredient_name + " in " + self.menu_item.menu_item_name
def enough(self):
return self.quantity <= self.ingredient.units_avail
def get_absolute_url(self):
return "/recipe"
class Purchase(models.Model):
menu_item = models.ForeignKey(MenuItem, on_delete=models.CASCADE)
timestamp = models.DateTimeField(auto_now_add=True)
def __str__(self):
return self.menu_item.menu_item_name + " at " + self.timestamp
def get_absolute_url(self):
return "/purchase"Views.py
def index(request):
return render(request, "index.html")
class InventoryListView(ListView):
template_name = "inventory.html"
model = Inventory
context_object_name = "inventory_list"
class MenuListView(ListView):
template_name = "menu.html"
model = MenuItem
context_object_name = "menu_list"
class InventoryUpdateView(UpdateView):
model = Inventory
template_name = "inventory_update.html"
form_class = InventoryUpdateForm
context_object_name = "inventory_update"
class InventoryCreateView(CreateView):
model = Inventory
template_name = "inventory_create.html"
form_class = InventoryCreateForm
context_object_name = "inventory_create"
class MenuItemCreateView(CreateView):
model = MenuItem
template_name = "menu_create.html"
form_class = MenuItemCreateForm
context_object_name = "menu_create"
class RecipeRequirementListView(ListView):
template_name = "recipe.html"
model = RecipeRequirement
context_object_name = "recipe_list"
class RecipeRequirementCreateView(CreateView):
model = RecipeRequirement
template_name = "recipe_create.html"
form_class = RecipeCreateForm
context_object_name = "recipe_create"
class PurchaseListView(ListView):
template_name = "purchase.html"
model = Purchase
context_object_name = "purchase_list"
class PurchaseCreateView(CreateView):
model = Purchase
template_name = "purchase_create.html"
form_class = PurchaseCreateForm
context_object_name = "purchase_create"发布于 2022-10-17 15:29:22
无论何时你购买,你都会有购买量,对吗?将此查询放在创建购买对象之后,并将purchased_qty存储在变量中。
from django.db.models import F
purchased_qty = 10 #Example
Inventory.objects.filter(ingredient_name='xyz').update(units_avail=F("units_avail") - int(purchased_qty))这将减少从您的Available qty从Inventory购买的数量。但我不确定库存和购买之间的关系。我想你是在把产品名称作为字符字段来比较。我希望这能帮到你。
https://stackoverflow.com/questions/74097794
复制相似问题