def delete_supply(self, supply_id):
dao = SupplyDAO()
if not dao.getSupplyById(supply_id):
return jsonify(Error="Post not found."), 404
else:
dao.delete(supply_id)
return jsonify(DeleteStatus="OK"), 200
def insert_supply_json(self, json):
dao = SupplyDAO()
category_id = json['category_id']
person_id = json['person_id']
name = json['name']
quantity = json['quantity']
brand = json['brand']
description = json['description']
available = quantity
unit_price = json['sunit_price']
address = json['address']
city = json['city']
zip_code = json['zip_code']
if person_id and category_id and name and available and brand and description and unit_price and quantity \
and address and city and zip_code:
resource_id = ResourceDAO().insert(person_id, name, quantity,
category_id)
supply_id = dao.insert(resource_id, brand, description, available,
unit_price, address, city, zip_code)
result = self.build_supply_attributes(supply_id, resource_id,
category_id, person_id, name,
quantity, brand, description,
available, unit_price,
address, city, zip_code)
return jsonify(Supply=result), 201
else:
return jsonify(Error="Unexpected attributes in post request"), 400
def search_available_supplies(self, args):
brand = args.get('brand')
max_price = args.get('unit_price')
category = args.get('category')
name = args.get('name')
subcategory = args.get('subcategory')
dao = SupplyDAO()
if len(args) == 4 and brand and max_price and category and subcategory:
supply_list = dao.getAvailableSuppliesByBrandAndCategoryAndSubcategoryAndMaxPrice(
brand, category, subcategory, max_price)
elif len(args) == 3 and brand and max_price and category:
supply_list = dao.getAvailableSuppliesByBrandAndCategoryAndMaxPrice(
brand, category, max_price)
elif len(args) == 3 and brand and subcategory and category:
supply_list = dao.getAvailableSuppliesByBrandAndCategoryAndSubcategory(
brand, category, subcategory)
elif len(args) == 2 and brand and category:
supply_list = dao.getAvailableSuppliesByBrandAndCategory(
brand, category)
elif len(args) == 1 and brand:
supply_list = dao.getAvailableSuppliesByBrand(brand)
elif len(args) == 1 and max_price:
supply_list = dao.getAvailableSuppliesByMaxPrice(max_price)
elif len(args) == 1 and category:
supply_list = dao.getAvailableSuppliesByCategory(category)
elif len(args) == 1 and name:
supply_list = dao.getAvailableSuppliesByName(name)
else:
return jsonify(Error="Malformed query string"), 400
result_list = []
for row in supply_list:
result = self.build_supply_dict(row)
result_list.append(result)
return jsonify(Supply_Posts=result_list)
def get_total_available_supplies_per_category(self):
dao = SupplyDAO()
count_list = dao.getTotalAvailableSuppliesPerCategory()
result_list = []
for row in count_list:
result = self.build_supply_count(row)
result_list.append(result)
return jsonify(Available_Supply_Count=result_list)
def get_all_available_supplies(self):
dao = SupplyDAO()
supply_list = dao.getAllAvailableSupplies()
result_list = []
for row in supply_list:
result = self.build_supply_dict(row)
result_list.append(result)
return jsonify(Available_Supplies=result_list)
def get_available_supplies_by_person_id(self, person_id):
dao = SupplyDAO()
supply_list = dao.getAvailableSuppliesByPersonId(person_id)
result_list = []
for row in supply_list:
result = self.build_supply_dict(row)
result_list.append(result)
return jsonify(Supply_Posts=result_list)
def get_supply_by_id(self, supply_id):
dao = SupplyDAO()
row = dao.getSupplyById(supply_id)
if not row:
return jsonify(Error="Post Not Found"), 404
else:
result = self.build_supply_dict(row)
return jsonify(Supply_Post=result)
def update_supply(self, supply_id, form):
dao = SupplyDAO()
if not dao.getSupplyById(supply_id):
return jsonify(Error="Post not found."), 404
else:
if len(form) != 7:
return jsonify(Error="Malformed update request"), 400
else:
description = form['description']
brand = form['brand']
unit_price = form['sunit_price']
available = form['available']
address = form['address']
city = form['city']
zip_code = form['zip_code']
if int(available) < 0:
return jsonify(
Error="Cannot put negative value in available"), 400
if description and unit_price and available and brand and address and city and zip_code:
dao.update(supply_id, brand, description, available,
unit_price, address, city, zip_code)
row = dao.getSupplyById(supply_id)
result = self.build_supply_dict(row)
return jsonify(Part=result), 200
else:
return jsonify(
Error="Unexpected attributes in update request"), 400
def insert_purchasedSupply_json(self, json):
dao = PurchasedSupplyDAO()
supply_id = json['supply_id']
person_id = json['person_id']
pquantity = int(json['pquantity'])
if person_id and supply_id and pquantity:
supply = SupplyDAO().getSupplyById(supply_id)
supply = SupplyHandler().build_supply_dict(supply)
buyerAccountRow = AccountDAO().getAccountByPersonId(person_id)
buyerAccount = AccountHandler().build_account_dict(buyerAccountRow)
supplierAccountRow = AccountDAO().getAccountByPersonId(
int(supply.get("person_id")))
supplierAccount = AccountHandler().build_account_dict(
supplierAccountRow)
if supply.get("available") < pquantity:
return jsonify(Error="Insufficient stock"), 400
elif buyerAccount.get("balance") < (pquantity *
supply.get("sunit_price")):
return jsonify(Error="Insufficient funds"), 400
else:
transactionTotal = pquantity * supply.get("sunit_price")
new_available = supply.get("available") - pquantity
newBuyerBalance = buyerAccount.get(
"balance") - transactionTotal
newSupplierBalance = supplierAccount.get(
"balance") + transactionTotal
purchasedSupply_id = dao.insert(supply_id, person_id,
pquantity,
supply.get("sunit_price"))
SupplyDAO().updateStock(int(supply.get("supply_id")),
new_available)
AccountDAO().updateBalance(int(buyerAccount.get("account_id")),
newBuyerBalance)
AccountDAO().updateBalance(
int(supplierAccount.get("account_id")), newSupplierBalance)
result = self.build_purchased_supply_attributes(
purchasedSupply_id, supply_id, person_id, pquantity,
supply.get("sunit_price"))
return jsonify(PurchasedSupply=result), 201
else:
return jsonify(Error="Unexpected attributes in post request"), 400
def get_total_available_supplies(self):
dao = SupplyDAO()
amount = dao.getTotalAvailableSupplies()
return jsonify(Total_Available_Supplies=amount)
def get_total_supplies(self):
dao = SupplyDAO()
amount = dao.getTotalSupplies()
return jsonify(Total_Supplies=amount)