def customers():
form = CustomerForm()
shop_session = sfy.Session(session['shop_url'], '2019-04', session['token'])
# activate the shopify session to use resources.
sfy.ShopifyResource.activate_session(shop_session)
if request.method == 'POST':
if form.validate_on_submit():
generate_fake_customer_data(form.number_of_customers_field.data)
# create_fake_products_and_variants(form.number_of_products_field.data, 5)
return render_template('customers.html', form=form)
def create():
form = CustomerForm(request.form)
msg = request.args.get('msg')
if request.method == 'GET':
customers = Customer.query.all()
return render_template('layouts/default.html',
content=render_template('pages/customers.html',
form=form,
msg=msg,
customers=customers))
if form.validate_on_submit():
# assign form data to variables
title = request.form.get('title', '', type=str)
gcpCustomerId = request.form.get('gcpCustomerId', '', type=str)
notes = request.form.get('notes', '', type=str)
customerActive = True
# filter customer out of database through title
customer = Customer.query.filter_by(title=title).first()
if customer:
#do update
customer.title = title
customer.gcpCustomerId = gcpCustomerId
customer.notes = notes
# commit change and save the object
db.session.commit()
msg = 'Customer Updated'
else:
#do insert
customer = Customer(title, gcpCustomerId, notes)
customer.save()
msg = 'Customer Created'
customers = Customer.query.all()
return render_template('layouts/default.html',
content=render_template('pages/customers.html',
form=form,
msg=msg,
customers=customers))
else:
return render_template('layouts/default.html',
content=render_template('pages/customers.html',
form=form,
msg="shit broke"))
def customer():
form = CustomerForm()
if form.validate_on_submit():
first = form.first_name.data
last = form.last_name.data
return redirect(
url_for('inventory',
first=first.title(),
last=last.title(),
title='Cars'))
return render_template('form.html', form=form, title='Customer Lookup')
def customers():
form = CustomerForm()
if form.validate_on_submit():
full_name = form.first_name.data.title(
) + ' ' + form.last_name.data.title()
cars = db.session.execute('''
SELECT full_name, make, model, year, color FROM car
INNER JOIN customer ON car.cust_id = customer.cust_id
WHERE customer.full_name = '{}'
'''.format(full_name))
return render_template('form.html',
title='Customers',
form=form,
cars=cars)
return render_template('form.html', title='Customers', form=form)
def customer_add_edit(record_id='0'):
if record_id == '0':
record = Customer(user=current_user)
else:
record = Customer.query.by_user(current_user).filter(
Customer.id == record_id).first()
form = CustomerForm(obj=record)
try:
form.populate_obj(record)
except:
pass
if form.validate_on_submit(): # it's submit!
db.session.add(record)
db.session.commit()
if record_id == '0':
return redirect('/customers')
else:
return redirect('/customer/' + record_id)
print_errors(form)
return render_template('forms/customer_modal.html', form=form, record=record)
def editCustomer(customerId):
form = CustomerForm(request.form)
msg = None
customer = Customer.query.filter_by(id=customerId).first()
customers = Customer.query.all()
if request.method == 'GET':
return render_template('layouts/default.html',
content=render_template('pages/customers.html',
form=form,
msg=msg,
customers=customers,
customer=customer))
if form.validate_on_submit():
# assign form data to variables
title = request.form.get('title', '', type=str)
gcpCustomerId = request.form.get('gcpCustomerId', '', type=str)
notes = request.form.get('notes', '', type=str)
c_id = request.form.get('id', '', type=int)
customerActive = True
# filter customer out of database through id
customer_update = Customer.query.filter_by(id=c_id).first()
if customer_update:
#do update
customer_update.title = title
customer_update.gcpCustomerId = gcpCustomerId
customer_update.notes = notes
# commit change and save the object
db.session.commit()
msg = 'Customer Updated'
else:
msg = 'Something Broke'
return redirect(url_for('create', msg=msg))