def settings_main():
context = base_context()
settings = Settings.query.all()
context['settings'] = settings
return render_template('settings/index.html', **context)
def user_add():
"""
**Adds a User**
adds a user to database.
"""
context = base_context()
if request.method == 'POST':
id = request.form['id']
name = request.form['name']
password = request.form['password']
admin_user = request.form.get('admin_user')
if admin_user == 'True':
admin_user = True
else:
admin_user = False
has_user = db.session.query(exists().where(Users.id == id)).scalar()
if has_user is False:
new_user = Users(id=id, name=name, admin_user=admin_user)
new_user.set_hash(password)
db.session.add(new_user)
db.session.commit()
return render_template('admin/add.html', **context)
return render_template('admin/add.html', **context)
def people_add():
context = base_context()
if request.method == 'POST':
name = request.form['name']
phone = request.form['phone']
mobile = request.form['mobile']
email = request.form['email']
linkedin = request.form['linkedin']
facebook = request.form['facebook']
twitter = request.form['twitter']
birthday = request.form['birthday']
notes = request.form['notes']
# calculate age
today_date = date.today()
date_format = "%Y-%m-%d"
b_day = datetime.datetime.strptime(birthday, date_format)
age = today_date.year - b_day.year - (
(today_date.month, today_date.day) < (b_day.month, b_day.day))
# insert data into DB
person = People(name=name, phone=phone, mobile=mobile, email=email,
linkedin=linkedin, facebook=facebook, twitter=twitter,
age=age, birthday=birthday, notes=notes)
db.session.add(person)
db.session.commit()
return redirect('/people/add')
context['message'] = ''
return render_template('people/add.html', **context)
def list_prods(manufac_name):
context = base_context()
products = Products.query.filter_by(manufacturer=manufac_name)
context['prods'] = products
context['manufac'] = manufac_name
return render_template('prods/list.html', **context)
def prods_add(manufac_name):
context = base_context()
has_product = False
if request.method == 'POST':
barcode = request.form['barcode']
price = request.form['price']
vat_price = request.form['vat_price']
selling_price = request.form['selling_price']
manufac = request.form['manufac']
has_product = db.session.query(exists().where(
Products.barcode == barcode)).scalar()
if has_product == False:
p = Products(barcode=barcode,
price=price,
vat_price=vat_price,
selling_price=selling_price,
manufacturer=manufac)
db.session.add(p)
db.session.commit()
context['manufac'] = manufac_name
context['has_product'] = str(has_product)
return render_template('prods/add.html', **context)
context['manufac'] = manufac_name
context['has_product'] = str(has_product)
return render_template('prods/add.html', **context)
def lookup_prods(manufac_name):
context = base_context()
context['manufac'] = manufac_name
context['fields'] = [key.replace('_', ' ') for key in Product.__table__.columns.keys() if key not in ['manufacturer_name']]
return render_template('prods/lookup.html', **context)
def prods_add(manufac_name):
context = base_context()
has_product = False
if request.method == 'POST':
barcode = request.form['barcode']
price = request.form['price']
vat_price = request.form['vat_price']
selling_price = request.form['selling_price']
manufacturer = Manufacturer.query.filter(
Manufacturer.name == manufac_name).first()
has_product = db.session.query(
exists().where(Product.barcode == barcode)).scalar()
if has_product is False:
p = Product()
p.barcode = barcode
p.price = price
p.vat_price = vat_price
p.selling_price = selling_price
p.manufacturer = manufacturer.id
db.session.add(p)
db.session.commit()
context['manufac'] = manufac_name
context['has_product'] = str(has_product)
return render_template('prods/add.html', **context)
context['manufac'] = manufac_name
context['has_product'] = str(has_product)
return render_template('prods/add.html', **context)
def list_prods(manufac_name):
context = base_context()
manufac = Manufacturer.query.filter(
Manufacturer.name == manufac_name).first()
context['prods'] = manufac.products
context['manufac'] = manufac_name
return render_template('prods/list.html', **context)
def appointment_edit(id):
context = base_context()
u = Users.query.get(id)
context['id'] = u.id
context['name'] = u.name
context['password'] = u.password
context['admin_user'] = u.admin_user
return render_template('admin/edit.html', **context)
def settings_edit(settings_name):
context = base_context()
s = Settings.query.get(settings_name)
context['settings_name'] = settings_name
context['current_value'] = s.value
return render_template('settings/edit.html', **context)
def user_list():
"""
**Get The List of Users**
Lists all users in the database.
"""
context = base_context()
context['users'] = Users.query.all()
return render_template('admin/index.html', **context)
def prods_edit(manufac_name, barcode):
context = base_context()
product = Product.query.filter(
Product.barcode == barcode
and Product.manufacturer == manufac_name).first()
context['product'] = product
context['manufac'] = manufac_name
return render_template('prods/edit.html', **context)
def appointment_edit(ids):
context = base_context()
a = Appointments.query.get(ids)
context['id'] = a.id
context['name'] = a.name
context['date'] = a.date
context['time'] = a.time
context['active'] = a.active
return render_template('appointment/edit.html', **context)
def prods_edit(manufac_name, barcode):
context = base_context()
p = Product.query.filter(Product.barcode == barcode
and Product.manufacturer == manufac_name).first()
context['barcode'] = p.barcode
context['price'] = p.price
context['vat_price'] = p.vat_price
context['selling_price'] = p.selling_price
context['manufac'] = manufac_name
return render_template('prods/edit.html', **context)
def settings_update():
context = base_context()
settings_name = request.form['settings_name']
settings_value = request.form['settings_value']
s = Settings.query.get(settings_name)
s.value = settings_value
db.session.commit()
settings = Settings.query.all()
context['settings'] = settings
return render_template('settings/index.html', **context)
def index():
context = base_context()
for module in os.listdir('modules'):
if module.startswith('__'):
continue
if module not in ['control_panel']:
with open('modules/{}/info.json'.format(module)) as f:
module_info = json.load(f)
all_info[module] = module_info
context['all_info'] = all_info
return render_template('control_panel/index.html', **context)
def login():
context = base_context()
if request.method == 'POST':
user_id = request.form['user_id']
password = request.form['password']
user = Users.query.filter_by(id=user_id).first()
if user is None or not user.check_hash(password):
flash('please check your user id and password')
return redirect(url_for('login.login'))
login_user(user)
return redirect(url_for('manufac.manufac'))
return render_template('/login.html', **context)
def appointment_add():
context = base_context()
if request.method == 'POST':
name = request.form['name']
date = request.form['date']
active = request.form['active']
time = request.form['time']
m = Appointments(name=name, date=date, time=time, active=active)
db.session.add(m)
db.session.commit()
return redirect('/appointment/add')
return render_template('appointment/add.html', **context)
def upload_db():
context = base_context()
def has_internet():
url = 'http://www.google.com/'
timeout = 5
try:
_ = requests.get(url, timeout=timeout)
return True
except requests.ConnectionError:
pass
return False
context['has_internet'] = has_internet()
return render_template('save/index.html', **context)
def manufac_add():
context = base_context()
has_manufac = False
if request.method == 'POST':
name = request.form['name']
has_manufac = Manufacturer.manufacturer_exists(name)
if has_manufac == False:
m = Manufacturer(name=name)
m.insert()
return render_template('manufac/add.html', **context)
context['has_manufac'] = str(has_manufac)
return render_template('manufac/add.html', **context)
def manufac_add():
context = base_context()
has_manufac = False
if request.method == 'POST':
name = request.form['name']
has_manufac = db.session.query(exists().where(Manufacturers.name == name)).scalar()
if has_manufac == False:
m = Manufacturers(name=name)
db.session.add(m)
db.session.commit()
return render_template('manufac/add.html', **context)
context['has_manufac'] = str(has_manufac)
return render_template('manufac/add.html', **context)
def manufac_update():
context = base_context()
if request.method == 'POST': #this block is only entered when the form is submitted
name = request.form['manufac_name']
old_name = request.form['old_manufac_name']
try:
m = Manufacturer.query.get(old_name)
m.name = name
m.update()
except sqlalchemy.exc.IntegrityError:
context['message'] = "you cannot modify to an already existing manufacturer"
context['redirect_url'] = "/manufac/"
render_template('manufac/message.html', **context)
return redirect('/manufac/')
def appointment_edit(id):
"""
**Update information for a User**
:param id: id of the user
:type id: int
"""
context = base_context()
u = Users.query.get(id)
context['id'] = u.id
context['name'] = u.name
context['password'] = u.password
context['admin_user'] = u.admin_user
return render_template('admin/edit.html', **context)
def people_edit(id):
context = base_context()
a = People.query.get(id)
context['id'] = a.id
context['name'] = a.name
context['phone'] = a.phone
context['mobile'] = a.mobile
context['email'] = a.email
context['linkedin'] = a.linkedin
context['facebook'] = a.facebook
context['twitter'] = a.twitter
context['age'] = a.age
context['birthday'] = a.birthday
context['notes'] = a.notes
return render_template('people/edit.html', **context)
def prods_add(manufac_name):
context = base_context()
has_product = False
if request.method == 'POST':
barcode = request.form['barcode']
name = request.form['name']
description = request.form['description']
category = request.form['category']
date = request.form['date']
price = request.form['price']
selling_price = request.form['selling_price']
in_stock = request.form['in_stock']
if request.form['discontinued'] == 'True':
discontinued = True
else:
discontinued = False
# manufacturer = Manufacturer.query.filter(
# Manufacturer.name == manufac_name).first()
# print(manufacturer, manufac_name, manufacturer.name)
has_product = db.session.query(exists().where(
Product.barcode == barcode)).scalar()
if has_product is False:
p = Product(
barcode=barcode,
name=name,
description=description,
category=category,
date=date,
price=price,
selling_price=selling_price,
in_stock=in_stock,
discontinued=discontinued,
manufacturer_name=manufac_name)
db.session.add(p)
db.session.commit()
context['manufac'] = manufac_name
context['has_product'] = str(has_product)
return render_template('prods/add.html', **context)
context['manufac'] = manufac_name
context['has_product'] = str(has_product)
return render_template('prods/add.html', **context)
def manufac_update():
context = base_context()
if request.method == 'POST': #this block is only entered when the form is submitted
name = request.form['manufac_name']
old_name = request.form['old_manufac_name']
try:
m = Manufacturers.query.get(old_name)
m.name = name
products = Products.query.filter_by(manufacturer=old_name)
for product in products:
product.manufacturer = name
db.session.commit()
except sqlalchemy.exc.IntegrityError:
# return redirect('/manufac/')
context['message'] = "you cannot modify to an already existing manufacturer"
context['redirect_url'] = "/manufac/"
render_template('manufac/message.html', **context)
#return redirect(url_for('edit', barcode=barcode))
return redirect('/manufac/')
def people_main():
context = base_context()
context['people'] = People.query.all()
return render_template('people/index.html', **context)
def lookup():
context = base_context()
context['people'] = People.query.all()
return render_template('people/lookup.html', **context)
def appointment_main():
context = base_context()
context['appointments'] = Appointments.query.all()
return render_template('appointment/index.html', **context)
def lookup():
context = base_context()
context['appointments'] = Appointments.query.all()
return render_template('appointment/lookup.html', **context)
