def items_create(): form = ItemForm(request.form) form2 = CategoryForm(request.form) if not form.validate(): return render_template("items/new.html", form=form) name = form.name.data it = Item.query.filter_by(name=name).first() if it: return render_template("items/new.html", form=form, error="Item is already listed!") i = Item(name) cid = form.category_id.data c = Category.query.get(cid) if not c: return render_template("categories_index") c.size = c.size + 1 i.category_id = cid i.bought = form.bought.data i.account_id = current_user.id db.session().add(i) db.session().commit() return redirect(url_for("items_index"))
def items_create(): form = ItemForm(request.form) if not form.validate(): return render_template("items/new.html", form=form) item = Item(form.name.data, form.price.data, form.threshold.data) db.session.add(item) db.session.commit() return redirect(url_for("items_index"))
def items_edit(item_id): form = ItemForm(request.form) item = Item.query.get(item_id) form.item_id = item.id if not form.validate(): return render_template("items/edit.html", form=form, item=item) item.name = form.name.data item.price = form.price.data item.threshold = form.threshold.data db.session().commit() return redirect(url_for("items_index"))
def items_create(): form = ItemForm(request.form) if not form.validate(): return render_template("items/new.html", form=form) i = Item(form.name.data) i.vegan = form.vegan.data i.account_id = current_user.id db.session().add(i) db.session().commit() return redirect(url_for("items_index"))
def items_create(): form = ItemForm(request.form) if not form.validate(): return render_template("items/new.html", form=form, warehouse_error="") item = Item.query.filter_by(name=form.name.data).first() if not item: item = Item(form.name.data, form.volume.data) db.session().add(item) db.session().commit() warehouse = Warehouse.query.filter_by(name=form.warehouse.data).first() if not warehouse: return render_template("items/new.html", form=form, warehouse_error="No such warehouse.") comp = Warehouse_item.query.filter_by(item_id=item.id, warehouse_id=warehouse.id).first() # check if item exists in warehouse if comp: new_amount = form.amount.data + comp.amount new_volume = new_amount * item.volume if not warehouse.fits(warehouse.id, new_volume): return render_template("items/new.html", form=form, warehouse_error="No room in warehouse.") elif (comp.amount + form.amount.data) < 0: return render_template("items/new.html", form=form, warehouse_error="Total amount can't be negative") comp.amount = new_amount else: new_amount = form.amount.data new_volume = new_amount * item.volume if not warehouse.fits(warehouse.id, new_volume): return render_template("items/new.html", form=form, warehouse_error="No room in warehouse.") relation = Warehouse_item(warehouse, item, new_amount) db.session().add(relation) db.session().commit() return redirect(url_for("warehouse_single", warehouse_id=warehouse.id))
def items_create(): form = ItemForm(request.form) list = Category.query.all() if not form.validate(): return render_template("items/new.html", form = form, categories = list) i = Item(form.name.data, form.amount.data) i.bought = form.bought.data i.account_id = current_user.id i.category_id = form.category.data i.list_id = List.find_users_defaultlist_id(current_user.id) db.session().add(i) db.session().commit() return redirect(url_for("items_index"))
def items_create(): form = ItemForm(request.form) if not form.validate(): return render_template('items/new.html', form = form) new_item = Item(form.name.data, form.description.data, form.price.data) new_item.account_id = current_user.id gameName = form.gameName.data db.session().add(new_item) add_gameName_to_item(new_item, gameName) db.session().commit() return redirect(url_for('item_add_games', item_id = new_item.id))
def cc_ptype_form(): form = ItemForm(request.form) if not form.validate(): return render_template("dbnew.html", formItem = form, formCc = CcForm(), formPtype = PtypeForm()) cc = Colorcode.query.filter(Colorcode.code == form.colorcode.data.code).first() ptype = Ptype.query.filter(Ptype.name == form.ptype.data.name).first() duplicate = Cc_ptype.query.filter(Cc_ptype.colorcode_id == cc.id, Cc_ptype.ptype_id == ptype.id).first() if duplicate: return render_template("dbnew.html", formItem = ItemForm(), formCc = CcForm(), formPtype = PtypeForm(), errorItem = "Product already in database.") ccptype = Cc_ptype(cc.id, ptype.id) db.session.add(ccptype) db.session().commit() return redirect(url_for("cc_ptype_index"))
def items_create(): form = ItemForm(request.form) form.item_category.choices = [ (c.id, c.name) for c in Category.query.order_by('name').filter_by( account_id=current_user.id) ] if not form.validate(): return render_template("items/new.html", form=form) i = Item(form.name.data, form.expired.data) category = Category.query.get(form.item_category.data) i.account_id = current_user.id i.category_id = category.id db.session().add(i) db.session().commit() return redirect(url_for("items_index"))
def item_update(item_id): item = Item.query.get(item_id) form = ItemForm(request.form) form.id.data = item_id # Form validation if not form.validate(): return render_template("items/modify.html", form = form) # Update item in db item.name = form.name.data item.brand = form.brand.data item.category = form.category.data item.weight = form.weight.data item.volume = form.volume.data item.description = form.description.data db.session().commit() return redirect(url_for("items_index"))
def item_edit(item_id): edited_item = Item.query.get(item_id) edit_form = ItemForm() if request.method == 'GET': edit_defaults(edited_item, edit_form) else: edit_form = ItemForm(request.form) if not edit_form.validate(): return edit_template(edited_item, edit_form) edited_item.name = edit_form.name.data edited_item.price = edit_form.price.data edited_item.description = edit_form.description.data # Return to the same edit page in both methods return edit_template(edited_item, edit_form)
def items_create(): form = ItemForm(request.form) if not form.validate(): return render_template("items/list.html", items = UserItem.list_users_items(), form = form) ui = UserItem(form.name.data, form.best_before.data) ui.account_id = current_user.id try: ui.item_id = Item.get_matching_item(form.name.data).get("id") except: i = Item(Item.name_to_lexeme(form.name.data)) db.session().add(i) db.session().commit() ui.item_id = Item.get_matching_item(form.name.data).get("id") db.session().add(ui) db.session().commit() return redirect(url_for("items_index"))
def item_form(): form = ItemForm(request.form) if request.method == "GET": return render_template("items/new.html", form=form) if not form.validate(): return render_template("items/new.html", form=form) cc = Colorcode.query.filter( Colorcode.code == form.colorcode.data.code).first() ptype = Ptype.query.filter(Ptype.name == form.ptype.data.name).first() validProduct = Cc_ptype.query.filter( Cc_ptype.colorcode_id == cc.id, Cc_ptype.ptype_id == ptype.id).first() if not validProduct: return render_template("items/new.html", form=form, error="Product does not exist.") duplicate = Item.query.filter(Item.colorcode_id == cc.id, Item.ptype_id == ptype.id, Item.account_id == current_user.id).first() if duplicate: return render_template("items/new.html", form=form, error="Product already in collection.") item = Item() item.colorcode_id = cc.id item.ptype_id = ptype.id item.account_id = current_user.id db.session.add(item) db.session().commit() return redirect(url_for("index"))
def item_create(): # New item form if request.method=="GET": return render_template("items/new.html", form = ItemForm()) # Form validation form = ItemForm(request.form) if not form.validate(): return render_template("items/new.html", form = form) # Adding new item to db item = Item(form.name.data) item.brand = form.brand.data item.category = form.category.data item.weight = form.weight.data item.volume = form.volume.data item.description = form.description.data item.user_id = current_user.id db.session().add(item) db.session().commit() return redirect(url_for("items_index"))