def delete_category(category_code): if Product().is_product_by_category_code(category_code): flash("There is a Product in this Category, Deleted Failed!") flash("You can delete this product from 'Product Page'") return redirect(url_for('categories_manager.index')) Category().delete_category(category_code) flash('Deleted Successfully!') return redirect(url_for('categories_manager.index'))
def loadUserDataById(self, user_id): self.transactions.clear() self.categories.clear() self.family_users.clear() conn = pymysql.connect(host=HOST, user=USER, password=PASSWORD, db=DB, charset='utf8') cursor = conn.cursor() sql = "SELECT * FROM `users` WHERE `ID` = '%s'" % (user_id) cursor.execute(sql) result = cursor.fetchone() self.user = User(result[0], result[1], result[2], result[3], result[4], result[5]) sql = "SELECT * FROM `families` WHERE `ID` = '%d'" % ( self.user.family_id) cursor.execute(sql) result = cursor.fetchone() self.family = Family(result[0], result[1], result[2], result[3], result[4]) sql = "SELECT * FROM `categories` WHERE `Owner_ID` = '%d' OR `Owner_ID` = '0'" % ( self.user.family_id) cursor.execute(sql) result = cursor.fetchall() for s in result: self.categories.append(Category(s[0], s[1], s[2])) sql = "SELECT * FROM `users` WHERE `Family_ID` = '%d'" % ( self.user.family_id) cursor.execute(sql) result = cursor.fetchall() for s in result: self.family_users.append(User(s[0], s[1], s[2], s[3], s[4], s[5])) sql = "SELECT * FROM `transactions` WHERE `Family_ID` = '%d' ORDER BY `Datetime` DESC" % ( self.user.family_id) cursor.execute(sql) result = cursor.fetchall() for s in result: if self.family.safemode == 1 and self.user.status == 3: b_user = self.getFamilyUserById(s[4]) if b_user.status != 3: continue else: self.transactions.append( Transaction(s[0], s[1], s[2], s[3], s[4], s[5], s[6])) else: self.transactions.append( Transaction(s[0], s[1], s[2], s[3], s[4], s[5], s[6])) cursor.close() conn.close()
def add_category(): if not request.form['category-code'].isdigit(): flash("Category Code must be an integer. Try again!") return redirect(url_for('categories_manager.index')) if Category().is_category_code(request.form['category-code']): flash("Category Code is already exist. Try again!") return redirect(url_for('categories_manager.index')) if int(request.form['category-code']) < 0 or int( request.form['category-code']) > 127: flash( "Category Code is not valid (should be between 0 to 127). Try again!" ) return redirect(url_for('categories_manager.index')) category = Category() category.category_code = request.form['category-code'] category.category_name = request.form['category-name'] category.img = request.form['img'] category.add_category() flash('Added Successfully!') return redirect(url_for('categories_manager.index'))
def update_category(): # Updates another field which isn't the category code if request.form['given-code'] != request.form['category-code']: # if Category().is_category_code(request.form['category-code']): # flash("Category Code is already exist. Try again!") flash( "Can't update Category code, You can delete and add new category.") return redirect(url_for('categories_manager.index')) Category().update_category(request.form['category-code'], request.form['category-name'], request.form['img']) flash('Updated Successfully!') return redirect(url_for('categories_manager.index'))
def submit_category(): name = bottle.request.forms.get("name") user = active_user() if not has_permission(user,'create-board'): return flash_message("You're not allowed to do that!","/","Error") elif name is None or len(name)<1: return flash_message("You need to enter a name!","/category","Error") else: tags = bottle.request.forms.get("tags","") description = bottle.request.forms.get("desc","") MIN_TAG_LENGTH = 3 tags = [t.strip() for t in tags.split() if len(t.strip())>=MIN_TAG_LENGTH] board = Category() board.update({"name":name,"tags":tags,"description":description}) return flash_message("Your board has been created!","/category/"+board.key,"Success")
def admin(): if not session.get("admin"): return login() if request.method == "POST": file = request.files.get("file", None) content_type = None photo = None if file: file_data = file.read() content_type = file.content_type # photo=images.Image(file_data) photo = images.resize(file_data, width=500, height=500) category = Category(id=request.form["name"].strip(), categoryID=request.form["name"], name=request.form["name"], photo=photo, photo_mimetype=content_type) category.put() fields = [] fields.append( Field(name="name", title="Category Name", the_type='text', identifier='name', placeholder="Category Name")) fields.append( Field(name='file', title="Upload Photo", the_type="file", placeholder="Upload Photo", identifier="file", tag="file")) title = "Create Category" form = Form(fields=fields, title=title) reviews = Review.query(Review.flagged == True) categories = Category.query() return render_template("admin_homepage.html", reviews=reviews, categories=categories, category_form=form)
def update(): # Checks that the category code exists: if not Category().is_category_code(request.form['category-code']): flash("Category Code doesn't exist. Try again!") return redirect(url_for('product_manager.index')) # # Checks that the ID inserted in the range # if int(request.form['id']) < 0 or int(request.form['id']) > 2147483647: # flash("The ID is not valid. Try again!") # return redirect(url_for('product_manager.index')) if request.form['given-id'] != request.form['id']: flash("Can't update ID, You can delete and add new product.") return redirect(url_for('product_manager.index')) Product().update_product(request.form['name'], request.form['price'], request.form['prev-price'], request.form['description'], request.form['img'], request.form['category-code'], request.form['given-id']) flash('Updated Successfully!') return redirect(url_for('product_manager.index'))
def add_product(): product = Product() product.id = request.form['id'] product.name = request.form['name'] product.price = request.form['price'] product.description = request.form['description'] product.img = request.form['img'] product.category_code = request.form['category-code'] # Checks that the ID doesnt exist already if Product().get_product(request.form['id']): flash("The ID is already exist. Try again!") return redirect(url_for('product_manager.index')) # Checks that the category code exists: if not Category().is_category_code(product.category_code): flash("Category Code doesn't exist. Try again!") return redirect(url_for('product_manager.index')) # Checks that the ID inserted in the range if int(request.form['id']) < 0 or int(request.form['id']) > 2147483647: flash("The ID is not valid. Try again!") return redirect(url_for('product_manager.index')) product.add_product() flash('Added Successfully!') return redirect(url_for('product_manager.index'))
def getCategoryById(self, id): for i in self.categories: if i.id == id: return i return Category(-1, "None", -1)
def index(): categories_data = Category().get_all() return render_template('categories_manager.html', categories=categories_data)
def c(): """Return a friendly HTTP greeting.""" for i in xrange(10): category = Category(categoryID=str(i), name=str(i)) category.put() return "splash!"