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.\"}"
