首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >如何在Django中创建采购实例时减少库存?

问如何在Django中创建采购实例时减少库存?
EN

Stack Overflow用户
提问于 2022-10-17 13:06:09
回答 1查看 41关注 0票数 0

我正在做一个Django项目,这是一个简单的餐厅管理系统。其中一个关键的功能是记录库存和采购。我希望添加一些功能,一旦我创建了一个购买实例,我的程序就会自动减少库存,减少在购买中使用的数量。

我一直在挠我的头,在互联网上打探,但老实说,我不知道从哪里开始。这是我的第一个Django项目,所以非常感谢您的指导。

关于我的models.py和views.py,见下文。

Models.py

代码语言:javascript
复制
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

代码语言:javascript
复制
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"
EN

回答 1

Stack Overflow用户

发布于 2022-10-17 15:29:22

无论何时你购买,你都会有购买量,对吗?将此查询放在创建购买对象之后,并将purchased_qty存储在变量中。

代码语言:javascript
复制
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购买的数量。但我不确定库存和购买之间的关系。我想你是在把产品名称作为字符字段来比较。我希望这能帮到你。

票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/74097794

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档