def sign_up_form():
if request.method == 'POST':
email = request.form['Email']
fName = request.form['FirstName']
lName = request.form['LastName']
DOB = request.form['DateOfBirth']
psw = request.form['Password']
now = datetime.now()
checkCustomer = dbManager.fetch(
'SELECT * FROM customers WHERE Email=%s ', (email, ))
print(checkCustomer)
if checkCustomer == []:
maxID = dbManager.fetch(
'SELECT max(ShoppingCartID) AS max FROM shopping_carts ')
if maxID[0].max:
ShoppingCartID = maxID[0].max + 1
else:
ShoppingCartID = 1
dbManager.commit(
'INSERT INTO customers VALUES (%s, %s,%s, %s, %s, %s, %s, %s, %s, %s)',
(email, psw, fName, lName, DOB, '', '', 0, '', ''))
db = dbManager.commit(
'INSERT INTO shopping_carts VALUES (%s, %s, %s)',
(ShoppingCartID, now, email))
print(db)
return redirect(url_for('sign_in.index'))
else:
return redirect('/sign_up?emailexist=true')
def yogurtOrder():
if request.method == 'GET':
maxID = dbManager.fetch('SELECT max(ProductID) AS max FROM products ')
if maxID[0].max:
productID = maxID[0].max + 1
else:
productID = 1
ProductName = "יוגורט " + request.args['amount'] + " קילו"
Amount = request.args['quantity']
ShoppingCartID = session.get('ShoppingCartID')
yogurt_tastes = request.args.getlist('yogurt_tastes')
toppings_chosen = request.args.getlist('toppings_chosen')
if len(yogurt_tastes) >= 1:
rowProduct = dbManager.commit(
'INSERT INTO products VALUES (%s,%s,%s,%s)',
(productID, ProductName, Amount, ShoppingCartID))
print(rowProduct)
for i in range(len(yogurt_tastes)):
rowBox = dbManager.commit(
'INSERT INTO box_flavours VALUES (%s,%s)',
(productID, yogurt_tastes[i]))
print(rowBox)
if len(toppings_chosen) >= 1:
for i in range(len(toppings_chosen)):
rowBoxTopping = dbManager.commit(
'INSERT INTO yogurtbox_toppings VALUES (%s,%s)',
(productID, toppings_chosen[i]))
print(rowBoxTopping)
return render_template('order.html', tab_name='yogurt')
def createUser(self, username, passwd, passwd1, email):
if passwd == passwd1:
query = "INSERT INTO users (fullname, password, email) VALUES ('%s','%s', '%s')" % (
username, passwd, email)
dbManager.commit(query)
return True
return False
def update_credit(self, credit_number, exp, cvv, email):
"""Updates and changes a credit data by the users' email"""
sql = '''
UPDATE credit SET credit_card_number = %s, expiration_date = %s, cvv = %s
WHERE email_address = %s
'''
dbManager.commit(sql, (credit_number, exp, cvv, email))
return
def add_review(self):
""" Add new review to data base"""
sql = '''
INSERT INTO review (review_number, date, `rank`, content, email_address, id)
VALUES (%s, %s, %s, %s, %s, %s)
'''
dbManager.commit(sql, (self.review_number, self.date, self.rank,
self.content, self.email_address, self.id))
return
def add_product(self):
""" Method that insert a new product to DB """
sql = '''
INSERT INTO product (id, name, price, description, img, category_code)
VALUES (%s, %s, %s, %s, %s, %s)
'''
dbManager.commit(sql, (self.id, self.name, self.price,
self.description, self.img, self.category_code))
return
def update_category(self, category_code, category_name, img):
""" Method that update an existing category by the category' code"""
sql = '''
UPDATE category SET category_code = %s, category_name = %s, img =%s
WHERE category_code = %s
'''
dbManager.commit(sql,
(category_code, category_name, img, category_code))
return
def add_category(self):
""" Method that insert a new Category to DB """
sql = '''
INSERT INTO category (category_code, category_name, img)
VALUES (%s, %s, %s)
'''
dbManager.commit(sql,
(self.category_code, self.category_name, self.img))
return
def newuser():
username = request.form['user']
passwd = request.form['pass']
passwd1 = request.form['pass1']
email = request.form['email']
if passwd == passwd1:
dbManager.commit("INSERT INTO USERS (fullname, password, email) VALUES ('%s','%s', '%s')" % (username, passwd, email))
return render_template('/login.html')
return render_template('/login.html' )
def add_credit(self):
"""If the user doesnt have a credit in the database
this method will insert the credit data by the users' email"""
sql = '''
INSERT INTO credit (credit_card_number, expiration_date, cvv, email_address)
VALUES (%s, %s, %s, %s)
'''
dbManager.commit(
sql, (self.credit_number, self.exp, self.cvv, self.email_address))
return
def index():
if request.method == 'GET':
return render_template('contact.html', contact=False)
else:
Name = request.form['contact_name']
Email = request.form['contact_email']
Text = request.form['contact_text']
dbManager.commit('INSERT INTO contact VALUES (%s, %s, %s)',
(Name, Email, Text))
return render_template('contact.html', contact=True)
def update_product(self, name, price, prev_price, description, img,
category_code, given_id):
""" Method that update an existing product by the products' current ID """
sql = '''
UPDATE product SET name = %s, price =%s, prev_price = %s,
description = %s, img = %s, category_code = %s
WHERE id = %s
'''
dbManager.commit(sql, (name, price, prev_price, description, img,
category_code, given_id))
return
def index():
if request.method == 'POST':
if request.form.get('email'):
dbManager.commit('UPDATE customer SET email=%s WHERE user_name=%s',
(request.form['email'], session['name']))
if request.form.get('phone_number'):
dbManager.commit(
'UPDATE customer SET phone_number=%s WHERE user_name=%s',
(request.form['phone_number'], session['name']))
if request.form.get('street'):
dbManager.commit(
'UPDATE customer SET street=%s WHERE user_name=%s',
(request.form['street'], session['name']))
if request.form.get('st_number'):
dbManager.commit(
'UPDATE customer SET st_number=%s WHERE user_name=%s',
(request.form['st_number'], session['name']))
if request.form.get('city'):
dbManager.commit('UPDATE customer SET city=%s WHERE user_name=%s',
(request.form['city'], session['name']))
if session['logged-in']:
if dbManager.fetch('SELECT * FROM private WHERE u_name=%s',
(session['name'], )):
Private = True
User_details = dbManager.fetch(
'SELECT * FROM customer LEFT JOIN private ON user_name=u_name WHERE user_name=%s',
(session['name'], ))
Recommended_items = dbManager.fetch(
'SELECT * FROM item JOIN item_department ON item_id=it_id WHERE department=%s ORDER BY price DESC, inventory_amount DESC LIMIT 3',
('private', ))
else:
Private = False
User_details = dbManager.fetch(
'SELECT * FROM customer LEFT JOIN business ON user_name=u_name WHERE user_name=%s',
(session['name'], ))
Recommended_items = dbManager.fetch(
'SELECT * FROM item JOIN item_department ON item_id=it_id WHERE department=%s ORDER BY price DESC, inventory_amount DESC LIMIT 3',
('business', ))
Purchased_items = dbManager.fetch(
'SELECT * FROM customer_purchased JOIN item ON it_id=item_id WHERE u_name=%s',
(session['name'], ))
Customer_manager = dbManager.fetch(
'SELECT * FROM customer JOIN employee ON customer_management_id=employee_id WHERE user_name=%s',
(session['name'], ))
return render_template('user.html',
user_details=User_details[0],
private=Private,
purchased_items=Purchased_items,
customer_manager=Customer_manager[0],
recommended_items=Recommended_items)
else:
return render_template('user.html')
def update_customer(self, user, password, first_name, last_name, country,
city, street, number, phone_number, role, given_email):
""" This Method Updates the data of a user, by the users' email address. """
sql = '''
UPDATE customer SET user = %s, password =%s, first_name = %s,
last_name = %s, country = %s, city = %s, street = %s, number = %s, phone_number = %s,
role = %s
WHERE email_address = %s
'''
dbManager.commit(sql,
(user, password, first_name, last_name, country, city,
street, number, phone_number, role, given_email))
return
def add_customer(self):
""" Add new customer to data base"""
# sql_z = ''' INSERT INTO zips (country, city, street, number, zip) VALUES (%s, %s, %s, %s, %s)'''
sql_c = '''
INSERT INTO customer (email_address, user, password, first_name, last_name, country, city, street,
number, phone_number, role)
VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)
'''
# dbManager.commit(sql_z, (self.country, self.city, self.street, self.number, self.zip))
dbManager.commit(
sql_c, (self.email_address, self.user, self.password,
self.first_name, self.last_name, self.country, self.city,
self.street, self.number, self.phone_number, self.role))
return
def update_models_values(orders, user_name):
counter_misses = 0
for order in orders:
query = "select %s as size_amount from models where makat= %s ;" % (
order.size, order.makat)
ans = db.fetch(query)
if ans[0].size_amount - order.quantity >= 0:
query = "update models set %s=(%s- %s) where makat = %s ;" % (
order.size, order.size, order.quantity, order.makat)
db.commit(query)
user.delete_cart(user_name, order.size, order.makat)
else:
counter_misses = counter_misses + 1
return counter_misses
def index():
if request.method == 'POST':
maxID = dbManager.fetch('SELECT max(ContactID) AS max FROM contacts ')
if maxID[0].max:
contactID = maxID[0].max + 1
else:
contactID = 1
Uname = request.form['full-name']
Uphone = request.form['phone-number']
message = request.form['message']
dbManager.commit('insert into contacts values (%s, %s, %s,%s)',
(contactID, Uname, Uphone, message))
return render_template('contact.html')
elif request.method == 'GET':
return render_template('contact.html')
def update_address(self, country, city, street, number, email):
"""Method that updates the address of the user. by adding new row in 'zips' table
and than changes the address in 'customer' table where its fit to the zips table."""
# sql_1 = '''
# INSERT INTO zips (country, city, street, number)
# VALUES (%s, %s, %s, %s)
# '''
sql_2 = '''
UPDATE customer SET country=%s, city=%s, street=%s, number=%s
WHERE email_address=%s
'''
# dbManager.commit(sql_1, (country, city, street, number))
dbManager.commit(sql_2, (country, city, street, number, email))
flash('Your address has successfully updated!')
return
def insert_result():
Personal_code = session['Personal_code']
session['worker_id'] = request.form['worker_id']
final_id = request.form['worker_id'] + "777BGU"
session['final_id'] = final_id
worker_id = session['worker_id']
age = request.form['age']
topic1 = session['topic1']
topic2 = session['topic2']
gender = request.form['Gender']
Education_level = request.form['Education level']
computer_use = request.form['computer use']
mobile_use = request.form['mobile use']
political_view = request.form['political view']
device = request.form['device']
place_size = request.form['place_size']
level_of_privacy = request.form['level_of_privacy']
level_of_confined_space = request.form['level_of_confined_space']
level_of_noise = request.form['level_of_noise']
level_of_light = request.form['level_of_light']
level_of_croweded_env = request.form['level_of_croweded_env']
query = dbManager.commit(
'insert into facebook_users values (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)',
(Personal_code, device, topic1, topic2, age, gender, Education_level,
computer_use, mobile_use, political_view, place_size,
level_of_privacy, level_of_confined_space, level_of_noise,
level_of_light, level_of_croweded_env, worker_id))
return redirect(url_for('finish_thanks.index'))
def add_form(self):
""" Add new feedback form to data base"""
sql = '''
INSERT INTO form (application_number, application_date, subject, content, status, email_address)
VALUES (%s, %s, %s, %s, %s, %s)
'''
dbManager.commit(
sql, (self.application_number, self.application_date, self.subject,
self.content, self.status, self.email_address))
return
# class Manager:
# def __init__(self):
# pass
#
# def get_tables_names(self):
# table1 = 'Products'
# table2 = 'Categories'
# return
def insert_no_result():
Personal_code = session['Personal_code']
article_id1 = request.form['article_id']
article_id = re.sub("[^0-9]", "", article_id1)
now = datetime.now()
article_order_number = session['question_num']
query = dbManager.commit(
'insert into facebook_results(Personal_code,article_id,question_order,insert_date) values (%s,%s,%s,%s)',
(Personal_code, article_id, article_order_number, now))
return redirect(url_for('page5.index'))
def index():
if request.method == 'POST':
item_data = dbManager.fetch(
'SELECT * FROM item JOIN item_class ON item_id=id WHERE item_id=%s',
(request.form['id'], ))
if dbManager.fetch('SELECT * FROM cart WHERE it_id=%s and u_name=%s',
(request.form['id'], session['name'])):
old_amount = dbManager.fetch(
'SELECT amount FROM cart WHERE it_id=%s and u_name=%s',
(request.form['id'], session['name']))
amount = int(request.form['quantity']) + old_amount[0][0]
dbManager.commit(
'UPDATE cart SET amount=%s WHERE it_id=%s AND u_name=%s',
(amount, item_data[0][0], session['name']))
else:
amount = request.form['quantity']
dbManager.commit('INSERT INTO cart VALUES (%s, %s, %s)',
(session['name'], item_data[0][0], amount))
user_cart_items = dbManager.fetch('SELECT * FROM cart WHERE u_name=%s',
(session['name'], ))
cart_amount = 0
for item in user_cart_items:
cart_amount += item[2]
session['cart_amount'] = cart_amount
purchase = True
return render_template('product.html', purchase=purchase)
else:
item_data = dbManager.fetch(
'SELECT * FROM item JOIN item_class ON item_id=id WHERE item_id=%s',
(request.args['id'], ))
item_class = item_data[0].item_class
recommended_data = dbManager.fetch(
'SELECT * FROM item JOIN item_class ON item_id=id WHERE item_class=%s AND item_id!=%s ORDER BY price DESC, inventory_amount DESC LIMIT 3',
(item_class, request.args['id']))
purchase = False
return render_template('product.html',
current_item=item_data[0],
recommended_items=recommended_data,
purchase=purchase)
def cookieOrder():
if request.method == 'GET':
maxID = dbManager.fetch('SELECT max(ProductID) AS max FROM products ')
if maxID[0].max:
productID = maxID[0].max + 1
else:
productID = 1
ProductName = "קוקילידה"
Amount = request.args['quantity']
ShoppingCartID = session.get('ShoppingCartID')
cookie_chosen = request.args['cookie_chosen']
cookie_filling = request.args['cookie_filling']
if cookie_chosen and cookie_filling:
rowProduct = dbManager.commit(
'INSERT INTO products VALUES (%s,%s,%s,%s)',
(productID, ProductName, Amount, ShoppingCartID))
print(rowProduct)
rowSanwich = dbManager.commit(
'INSERT INTO icecream_sandwiches VALUES (%s,%s,%s)',
(productID, cookie_chosen, cookie_filling))
print(rowSanwich)
return render_template('order.html', tab_name='cookie')
def index():
if request.method == 'POST':
maxID = dbManager.fetch('SELECT max(OfferID) AS max FROM occasion_offers ')
if maxID[0].max:
OfferID= maxID[0].max+1
else:
OfferID=1
Uname = request.form['FullName']
Uphone = request.form['PhoneNumber']
insertData = dbManager.commit('insert into occasion_offers values (%s, %s, %s)', (OfferID, Uname,Uphone))
if insertData:
return render_template('events.html')
elif request.method == 'GET':
return render_template('events.html')
def iceCreamOrder():
if request.method == 'GET':
maxID = dbManager.fetch('SELECT max(ProductID) AS max FROM products ')
if maxID[0].max:
productID = maxID[0].max + 1
else:
productID = 1
selectAmount = request.args['amount']
ProductName = "גלידה " + selectAmount + " קילו"
Amount = request.args['quantity']
ShoppingCartID = session.get('ShoppingCartID')
ice_cream_tastes = request.args.getlist('ice_cream_tastes')
if len(ice_cream_tastes) >= 1:
rowProduct = dbManager.commit(
'INSERT INTO products VALUES (%s,%s,%s,%s)',
(productID, ProductName, Amount, ShoppingCartID))
print(rowProduct)
for i in range(len(ice_cream_tastes)):
rowBox = dbManager.commit(
'INSERT INTO box_flavours VALUES (%s,%s)',
(productID, ice_cream_tastes[i]))
print(rowBox)
return render_template('order.html', tab_name='icecream')
def index():
if request.method == 'GET':
return render_template('register.html', registered=False)
else:
User_name = request.form['user_name']
Password = request.form['password']
Email = request.form['email']
Phone_number = request.form['phone_number']
Cc_Number = request.form['cc_number']
Validation_date = request.form['validation_date']
Csv = request.form['csv']
Street = request.form['street']
St_number = request.form['st_number']
City = request.form['city']
Customer_managment_id = '10129438'
dbManager.commit('INSERT INTO customer_cc VALUES (%s, %s, %s)',
(Cc_Number, Validation_date, Csv))
dbManager.commit(
'INSERT INTO customer VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)',
(User_name, Password, Email, Phone_number, Cc_Number, Street,
St_number, City, Customer_managment_id))
if request.form["user_type"] == 'private':
First_name = request.form['first_name']
Last_name = request.form['last_name']
dbManager.commit('INSERT INTO private VALUES (%s, %s, %s)',
(User_name, First_name, Last_name))
else:
Company_name = request.form['company_name']
Contact_person = request.form['contact_person']
Licence_number = request.form['licence_number']
Business_type = request.form['business_type']
dbManager.commit(
'INSERT INTO business VALUES (%s, %s, %s, %s)',
(User_name, Company_name, Contact_person, Licence_number))
dbManager.commit('INSERT INTO business_type VALUES (%s, %s)',
(User_name, Business_type))
return render_template('register.html', registered=True)
def insert_result():
Personal_code = session['Personal_code']
article_id = request.form['article_id']
liked = request.form['liked']
keep_reading = 0
shared = request.form['shared']
share_input = request.form['shared_input_to_db']
now = datetime.now()
print("now =", now)
comment_input = request.form['comment_input_to_db']
article_order_number = session['question_num']
query = dbManager.commit(
'insert into facebook_results values (%s,%s,%s,%s,%s,%s,%s,%s,%s)',
(Personal_code, article_id, liked, article_order_number, keep_reading,
shared, share_input, now, comment_input))
return redirect(url_for('page5.index'))
def form():
if request.method == 'POST':
email = request.form['email']
phone = request.form['phone']
address_street = request.form['address-street']
address_number = request.form['address-number']
city = request.form['city']
zip = request.form['zip']
customer_update = dbManager.commit('UPDATE customers SET City=%s, Street=%s, StreetNumber=%s, ZipCode=%s, PhoneNumber=%s WHERE Email = %s', (city, address_street, address_number, zip, phone, email))
id = request.form['id']
card_number = request.form['cardnumber']
cvv = request.form['cvv']
exp_month = request.form['exp-month']
exp_year = request.form['exp-year']
comment = request.form['comment']
ShoppingCartID = session.get('ShoppingCartID')
Date = datetime.today().strftime('%y-%m-%d')
totalPriceResult = dbManager.fetch('''SELECT SUM(Amount*Price) totalPrice FROM products_prices as pp JOIN products as p on pp.ProductName=p.ProductName where ShoppingCartID=%s;''', (ShoppingCartID,))
totalPrice = totalPriceResult[0].totalPrice
maxID = dbManager.fetch('SELECT max(OrderID) AS max FROM orders')
if maxID[0].max :
OrderID= maxID[0].max+1
else:
OrderID=1
Order_table = dbManager.commit('INSERT into orders VALUES (%s,%s, %s, %s, %s, %s, %s, %s, %s, %s)', (OrderID, id, card_number, cvv, exp_month, exp_year, comment, ShoppingCartID, Date, totalPrice))
if Order_table:
product_delete = dbManager.fetch('SELECT productID FROM products WHERE ShoppingCartID = %s', (ShoppingCartID,))
if product_delete:
for i in range(len(product_delete)):
row1 = dbManager.commit('DELETE from box_flavours where ProductID = %s', (product_delete[i].productID,))
row2 = dbManager.commit('DELETE from icecream_sandwiches where ProductID = %s', (product_delete[i].productID,))
row3 = dbManager.commit('DELETE from yogurtbox_toppings where ProductID = %s', (product_delete[i].productID,))
row4 = dbManager.commit('DELETE from products where ProductID = %s', (product_delete[i].productID,))
return render_template('confirmOrder.html')
elif request.method == 'GET':
return render_template('payment.html')
def newLead(self, name, phone, email):
query = "INSERT INTO open_studio_submissions (fullname, phone, email) VALUES ('%s','%s', '%s')" % (
name, phone, email)
dbManager.commit(query)
return True
def createContact(self, firstname, lastname, phonenumber, email, msg):
query = "INSERT INTO contact_us_submissions (firstname,lastname, phonenumber, email, massage) VALUES ('%s','%s', '%s','%s','%s')" % (
firstname, lastname, phonenumber, email, msg)
dbManager.commit(query)
return True
