def usersales(self): db = DB() if (request.method == "GET"): user = db.getUser(request.params['email']) orderList = db.sortOrdersModel(user['id'], request.params['sortid']) return Sale.toUserSaleList(orderList)
def samples(self): db = DB() if request.method == "GET": if request.params["id"] == "*": smallitems, largeitems = db.getSampleBoxItems() return Sale.toTableSampleBoxes(smallitems, largeitems, request.params["staticTable"]) else: date = db.getSampleItem(request.params["id"]) return json.dumps(date) elif request.method == "PUT": # Edit Date if request.params["id"] != "" and request.params["item"] != "" and request.params["is_small_box"] != "": success = db.updateSampleItem( request.params["id"], request.params["item"], request.params["is_small_box"] ) if success: return self.trueString else: return '{"success":"false","message":"Failed to enter new order."}' elif request.params["id"] == "" and request.params["item"] != "" and request.params["is_small_box"] != "": # New Date success = db.addNewSampleItem(request.params["item"], request.params["is_small_box"]) if success: return self.trueString else: return '{"success":"false","message":"Failed to new item."}' # Delete Date else: success = db.deleteSampleItem(request.params["id"]) if success: return self.trueString else: return '{"success":"false","message":"Failed to delete item."}'
def dist(self): db = DB() if (request.method == "GET"): hostSite = db.getHostSiteByName(request.params['hostSiteName']) orderList = db.getAllOrdersByHostSite(hostSite.get('id'), request.params['sortid']) return Sale.toDistList(orderList, request.params['hostSiteName'])
def donors(self): cookie = request.cookies.get("GFB_Cookie") if cookie == None: response.status_int = 404 return else: creds = Cookie.decryptCookie(cookie) if creds.get("role") == "1" or creds.get("role") == "2": db = DB() donorList = db.getDonationOrders() return Sale.toTableDonations(donorList) else: response.status_int = 404 return
def customers(self): cookie = request.cookies.get("GFB_Cookie") if cookie == None: response.status_int = 404 return else: creds = Cookie.decryptCookie(cookie) if (creds.get("role") == "2") or (creds.get("role") == "1"): db = DB() customerList = db.getAllCustomers() return Sale.toTableMasterCustomerList(customerList) else: response.status_int = 404 return
def donors(self): cookie = request.cookies.get("GFB_Cookie") if (cookie == None): response.status_int = 404 return else: creds = Cookie.decryptCookie(cookie) if (creds.get('role') == '1' or creds.get('role') == '2'): db = DB() donorList = db.getDonationOrders() return Sale.toTableDonations(donorList) else: response.status_int = 404 return
def customers(self): cookie = request.cookies.get("GFB_Cookie") if (cookie == None): response.status_int = 404 return else: creds = Cookie.decryptCookie(cookie) if (creds.get('role') == '2') or (creds.get('role') == '1'): db = DB() customerList = db.getAllCustomers() return Sale.toTableMasterCustomerList(customerList) else: response.status_int = 404 return
def dates(self): db = DB() if request.method == "GET": if request.params["dateID"] == "*": dates = db.getAllPickupDates() return Sale.toTableDates(dates, request.params["staticTable"]) else: date = db.getDate(request.params["dateID"]) return json.dumps(date) elif request.method == "PUT": # Edit Date if ( request.params["dateID"] != "" and request.params["orderDate"] != "" and request.params["pickupDate"] != "" ): success = db.updateDate( request.params["dateID"], request.params["pickupDate"], request.params["orderDate"] ) if success: return self.trueString else: return '{"success":"false","message":"Failed to enter new order."}' elif ( request.params["dateID"] == "" and request.params["orderDate"] != "" and request.params["pickupDate"] != "" ): # New Date success = db.addNewDate(request.params["pickupDate"], request.params["orderDate"]) if success: return self.trueString else: return '{"success":"false","message":"Failed to enter new order."}' # Delete Date else: success = db.deleteDate(request.params["dateID"]) if success: return self.trueString else: return '{"success":"false","message":"Failed to enter new order."}'
def dates(self): db = DB() if (request.method == "GET"): if (request.params['dateID'] == '*'): dates = db.getAllPickupDates() return Sale.toTableDates(dates, request.params['staticTable']) else: date = db.getDate(request.params['dateID']) return json.dumps(date) elif (request.method == "PUT"): #Edit Date if (request.params['dateID'] != '' and request.params['orderDate'] != '' and request.params['pickupDate'] != ''): success = db.updateDate(request.params['dateID'], request.params['pickupDate'], request.params['orderDate']) if success: return self.trueString else: return "{\"success\":\"false\",\"message\":\"Failed to enter new order.\"}" elif (request.params['dateID'] == '' and request.params['orderDate'] != '' and request.params['pickupDate'] != ''): #New Date success = db.addNewDate(request.params['pickupDate'], request.params['orderDate']) if success: return self.trueString else: return "{\"success\":\"false\",\"message\":\"Failed to enter new order.\"}" #Delete Date else: success = db.deleteDate(request.params['dateID']) if success: return self.trueString else: return "{\"success\":\"false\",\"message\":\"Failed to enter new order.\"}"
def samples(self): db = DB() if (request.method == "GET"): if (request.params['id'] == '*'): smallitems, largeitems = db.getSampleBoxItems() return Sale.toTableSampleBoxes(smallitems, largeitems, request.params['staticTable']) else: date = db.getSampleItem(request.params['id']) return json.dumps(date) elif (request.method == "PUT"): #Edit Date if (request.params['id'] != '' and request.params['item'] != '' and request.params['is_small_box'] != ''): success = db.updateSampleItem(request.params['id'], request.params['item'], request.params['is_small_box']) if success: return self.trueString else: return "{\"success\":\"false\",\"message\":\"Failed to enter new order.\"}" elif (request.params['id'] == '' and request.params['item'] != '' and request.params['is_small_box'] != ''): #New Date success = db.addNewSampleItem(request.params['item'], request.params['is_small_box']) if success: return self.trueString else: return "{\"success\":\"false\",\"message\":\"Failed to new item.\"}" #Delete Date else: success = db.deleteSampleItem(request.params['id']) if success: return self.trueString else: return "{\"success\":\"false\",\"message\":\"Failed to delete item.\"}"
def userdonations(self): db = DB() if request.method == "GET": user = db.getUser(request.params["email"]) orderList = db.getDonationsByUserID(user["id"]) return Sale.toUserDonationList(orderList)
def usersales(self): db = DB() if request.method == "GET": user = db.getUser(request.params["email"]) orderList = db.sortOrdersModel(user["id"], request.params["sortid"]) return Sale.toUserSaleList(orderList)
def sales(self): db = DB() # for all sales (regardless of host site) send hostSiteName : * if request.method == "GET": if request.params["hostSiteName"] == "*": orderList = db.getAllOrders() return Sale.toTableMasterOrderList(orderList) elif request.params["hostSiteName"] != "" and request.params["orderID"] == "": orderList = db.getAllOrders() return Sale.toCashSaleList(orderList, request.params["hostSiteName"]) else: order = db.getOrdersByOrderID(request.params["orderID"]) return json.dumps(order) # uses orderID as a key, if it is sent as "" a new order is added # updating orders was not implemented elif request.method == "PUT": if request.params["orderID"] == "": # if (self.validate_new_order_inputs(request.params)): order = Sale( None, request.params["dateCreated"], request.params["dateToDistribute"], request.params["firstName"], request.params["lastName"], request.params["email"], request.params["phoneNumber"], request.params["shouldSendNotifications"], request.params["smallBoxQuantity"], request.params["largeBoxQuantity"], request.params["donations"], request.params["donationReceipt"], request.params["totalPaid"], request.params["hostSitePickupID"], request.params["hostSiteOrderID"], request.params["customerID"], ) success = db.createNewOrderModel(order) if success: self.send_confirmation_email( request.params["dateCreated"], request.params["dateToDistribute"], request.params["firstName"], request.params["lastName"], request.params["email"], request.params["phoneNumber"], request.params["smallBoxQuantity"], request.params["largeBoxQuantity"], request.params["donations"], request.params["totalPaid"], request.params["hostSitePickupID"], request.params["hostSiteOrderID"], ) return self.trueString else: return '{"success":"false","message":"Failed to enter new order."}' # else: # return "{\"success\":\"false\",\"message\":\"Please fix inputs.\"}" else: if request.params["smallBoxQuantity"] == "" and request.params["largeBoxQuantity"] == "": # Delete success = db.deleteOrder(request.params["orderID"]) if success: self.send_confirmation_email( request.params["dateCreated"], request.params["dateToDistribute"], request.params["firstName"], request.params["lastName"], request.params["email"], request.params["phoneNumber"], request.params["smallBoxQuantity"], request.params["largeBoxQuantity"], request.params["donations"], request.params["totalPaid"], request.params["hostSitePickupID"], request.params["hostSiteOrderID"], ) return self.trueString else: return '{"success":"false","message":"Failed to enter new order."}' else: # Edit order = Sale( request.params["orderID"], request.params["dateCreated"], request.params["dateToDistribute"], request.params["firstName"], request.params["lastName"], request.params["email"], request.params["phoneNumber"], request.params["shouldSendNotifications"], request.params["smallBoxQuantity"], request.params["largeBoxQuantity"], request.params["donations"], request.params["donationReceipt"], request.params["totalPaid"], request.params["hostSitePickupID"], request.params["hostSiteOrderID"], request.params["customerID"], ) success = db.createEditOrderModel(order) if success: self.send_confirmation_email( request.params["dateCreated"], request.params["dateToDistribute"], request.params["firstName"], request.params["lastName"], request.params["email"], request.params["phoneNumber"], request.params["smallBoxQuantity"], request.params["largeBoxQuantity"], request.params["donations"], request.params["totalPaid"], request.params["hostSitePickupID"], request.params["hostSiteOrderID"], ) return self.trueString else: return '{"success":"false","message":"Failed to enter new order."}'
def dist(self): db = DB() if request.method == "GET": hostSite = db.getHostSiteByName(request.params["hostSiteName"]) orderList = db.getAllOrdersByHostSite(hostSite.get("id"), request.params["sortid"]) return Sale.toDistList(orderList, request.params["hostSiteName"])
def userdonations(self): db = DB() if (request.method == "GET"): user = db.getUser(request.params['email']) orderList = db.getDonationsByUserID(user['id']) return Sale.toUserDonationList(orderList)
def sales(self): db = DB() # for all sales (regardless of host site) send hostSiteName : * if (request.method == "GET"): if request.params['hostSiteName'] == "*": orderList = db.getAllOrders() return Sale.toTableMasterOrderList(orderList) elif (request.params['hostSiteName'] != "" and request.params['orderID'] == ""): orderList = db.getAllOrders() return Sale.toCashSaleList(orderList, request.params['hostSiteName']) else: order = db.getOrdersByOrderID(request.params['orderID']) return json.dumps(order) # uses orderID as a key, if it is sent as "" a new order is added # updating orders was not implemented elif (request.method == "PUT"): if request.params['orderID'] == "": # if (self.validate_new_order_inputs(request.params)): order = Sale( None, request.params['dateCreated'], request.params['dateToDistribute'], request.params['firstName'], request.params['lastName'], request.params['email'], request.params['phoneNumber'], request.params['shouldSendNotifications'], request.params['smallBoxQuantity'], request.params['largeBoxQuantity'], request.params['donations'], request.params['donationReceipt'], request.params['totalPaid'], request.params['hostSitePickupID'], request.params['hostSiteOrderID'], request.params['customerID']) success = db.createNewOrderModel(order) if success: self.send_confirmation_email( request.params['dateCreated'], request.params['dateToDistribute'], request.params['firstName'], request.params['lastName'], request.params['email'], request.params['phoneNumber'], request.params['smallBoxQuantity'], request.params['largeBoxQuantity'], request.params['donations'], request.params['totalPaid'], request.params['hostSitePickupID'], request.params['hostSiteOrderID']) return self.trueString else: return "{\"success\":\"false\",\"message\":\"Failed to enter new order.\"}" # else: # return "{\"success\":\"false\",\"message\":\"Please fix inputs.\"}" else: if (request.params['smallBoxQuantity'] == "" and request.params['largeBoxQuantity'] == ""): # Delete success = db.deleteOrder(request.params['orderID']) if success: self.send_confirmation_email( request.params['dateCreated'], request.params['dateToDistribute'], request.params['firstName'], request.params['lastName'], request.params['email'], request.params['phoneNumber'], request.params['smallBoxQuantity'], request.params['largeBoxQuantity'], request.params['donations'], request.params['totalPaid'], request.params['hostSitePickupID'], request.params['hostSiteOrderID']) return self.trueString else: return "{\"success\":\"false\",\"message\":\"Failed to enter new order.\"}" else: # Edit order = Sale(request.params['orderID'], request.params['dateCreated'], request.params['dateToDistribute'], request.params['firstName'], request.params['lastName'], request.params['email'], request.params['phoneNumber'], request.params['shouldSendNotifications'], request.params['smallBoxQuantity'], request.params['largeBoxQuantity'], request.params['donations'], request.params['donationReceipt'], request.params['totalPaid'], request.params['hostSitePickupID'], request.params['hostSiteOrderID'], request.params['customerID']) success = db.createEditOrderModel(order) if success: self.send_confirmation_email( request.params['dateCreated'], request.params['dateToDistribute'], request.params['firstName'], request.params['lastName'], request.params['email'], request.params['phoneNumber'], request.params['smallBoxQuantity'], request.params['largeBoxQuantity'], request.params['donations'], request.params['totalPaid'], request.params['hostSitePickupID'], request.params['hostSiteOrderID']) return self.trueString else: return "{\"success\":\"false\",\"message\":\"Failed to enter new order.\"}"