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!"
