def edit_customer(userid):
form = EditCustomerForm(request.form)
# fill out disabled form fields in backend
u = customer_id_to_object(userid)
form.registrationdate.data = u.registrationdate
form.userid.data = userid
if request.method == 'POST' and form.validate():
success = edit_customer_controller(form)
if success:
flash("Customer information edited.")
redirect(url_for('edit_customer', userid=userid))
else:
flash(
"Customer information not succesfully edited. Make sure that username is unique."
)
redirect(url_for('edit_customer', userid=userid))
form = EditCustomerForm()
u = customer_id_to_object(userid)
form.userid.data = u.userid
form.registrationdate.data = u.registrationdate
form.username.data = u.username
form.password.data = u.password
form.firstname.data = u.firstname
form.lastname.data = u.lastname
form.address.data = u.address
form.city.data = u.city
form.state.data = u.state
form.zipcode.data = u.zipcode
form.email.data = u.email
form.phonenumber.data = u.telephone
form.rating.data = u.rating
return render_template('customerreptasks/editcustomer.html', form=form)
def list_buyers_controller(adid):
conn = mysql.connect()
cursor = conn.cursor()
query = "select distinct ac.userid from Account Ac, Sales S, Advertisement A where A.adid=%s and S.advertisementid =%s and Ac.accountNo = S.accountNo"
cursor.execute(query, (adid, adid))
data = cursor.fetchall()
customers = []
if data:
for d in data:
customers.append(customer_id_to_object(d[0]))
return customers
def customer_summary_listing():
conn = mysql.connect()
cursor = conn.cursor()
query = "select C.userid, sum(S.Quantity) as TotalQuantity, Sum(A.price * S.Quantity) as Revenue from Advertisement A, Sales S, Account C where A.AdId = S.AdvertisementId and C.AccountNo = S.AccountNo group by C.UserId order by revenue desc;"
cursor.execute(query)
data = cursor.fetchall()
customer_listing = []
for d in data:
customer = customer_id_to_object(d[0])
listing = [customer, d[1], d[2]]
customer_listing.append(listing)
return customer_listing
def get_transactions_by_itemname(itemname):
conn = mysql.connect()
cursor = conn.cursor()
if itemname != '':
query = "SELECT S.TransactionId,S.SalesDate,A.AdId,A.ItemName,S.Quantity, C.AccountNo, C.Userid, S.EmployeeId FROM Sales S, Advertisement A,Account C WHERE S.AdvertisementId=A.AdId and S.AccountNo=C.AccountNo and A.ItemName=%s"
cursor.execute(query, (itemname))
else:
query = "SELECT S.TransactionId,S.SalesDate,A.AdId,A.ItemName,S.Quantity, C.AccountNo, C.Userid, S.EmployeeId FROM Sales S, Advertisement A,Account C WHERE S.AdvertisementId=A.AdId and S.AccountNo=C.AccountNo"
cursor.execute(query)
data = cursor.fetchall()
transactions = []
for d in data:
t = [d[0], d[1], d[2], d[3], d[4], d[5], d[6], d[7]]
t[6] = customer_id_to_object(t[6])
transactions.append(t)
return transactions
def get_transactions_by_username(username):
conn = mysql.connect()
cursor = conn.cursor()
if username != '':
userid = username_to_userid(username)
query = "select S.TransactionId, S.SalesDate, A.AdId, A.ItemName, S.Quantity, C.AccountNo, C.UserId, S.EmployeeId from Sales S, Advertisement A, Account C where S.AdvertisementId = A.AdId and S.AccountNo = C.AccountNo and C.UserId=%s"
cursor.execute(query, (userid))
else:
query = "select S.TransactionId, S.SalesDate, A.AdId, A.ItemName, S.Quantity, C.AccountNo, C.UserId, S.EmployeeId from Sales S, Advertisement A, Account C where S.AdvertisementId = A.AdId and S.AccountNo = C.AccountNo"
cursor.execute(query)
data = cursor.fetchall()
transactions = []
for d in data:
t = [d[0], d[1], d[2], d[3], d[4], d[5], d[6], d[7]]
t[6] = customer_id_to_object(t[6])
transactions.append(t)
return transactions
def retrieve_customer_groups(userid):
user = customer_id_to_object(userid)
groups = retrieve_customer_groups_controller(userid)
return render_template('customerreptasks/retrievegroups.html',
groups=groups,
user=user)
def delete_customer(userid):
user = customer_id_to_object(userid)
delete_customer_controller(userid)
flash("Deleted user " + user.username + ".")
return redirect(url_for('view_customers'))