shortland/Little-Bobby-Tables-Auction-House

[Customer] Functionality Overview

Closed this issue · 2 comments

shortland commented

My own unpushed, unmerged, local build:

Logging in as a 'customer'
EVERYTHING EXCEPT THE FOLLOWING WORKS (AS INTENDED)!

  • Bid History
  • All History
  • View Auctions (both by ItemType and by ItemName; b/c it should show only the open auctions IMO and open auctions are those that either have close date not yet reached OR with a ClosingBidID == NULL)
  • View Best Sellers (This mostly works; idk how it's checked rn how items are sold; but it may need to be implemented to ONLY get items that have ClosingBidID != NULL)
  • View Personalized Suggestions (I thought we had a working query for this? but we may need to refocus/fix based off of ClosingBidID)
shortland commented

@DavidLSC

  • Bid History (Get list of Bids from table 'Bid' for a specified CustomerID)
  • All History
  • View Auctions (Haven't reached closed date AND ClosingBidID == NULL)
  • View Best Seller (Get item list for items with ClosingBidID != NULL)
  • View Personalized Suggestions (Customer 'purchased' and item if it's their bid in the ClosingBidID column of Auction)
DavidLSC commented

@shortland
ItemDao getItemBySeller() Needs a value sold price