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'))