As a store manager, I would like to know what the daily sales are for my company.
Priority: 3
Acceptance Criteria
The only data returned is for the day provided by the user
The report shows all sales grouped by item
The system returns nothing if there are no sales for the proved day
Subtotal rows correctly sum all sales above
Total row correctly sums all subtotal rows
The system accepts dates in multiple formats
Testing plan
prove that the amount aggregation is correct
prove that the system detects the date correctly
prove that the system handles dates in multiple formats
prove that visual elements respond to the report request in a predictable and logical manner
Story points: 5
Tasks
Create the Order table in SQL
receiptId, date, cid, card#, expiryDate, expectedDate, deliveredDate
Insert some test data into the table
Create a Daily Sales php form:
An input field for date
An output table to hold our returned results
Test access to the form across browsers and locations
Create a stored procedure in SQL, @date parameter, to query the Order table to return all rows where date = @date
The report should return a table with columns UPC, Category, Unit Price, Units, Total Value, subtotalled by Category, with a Total row that sums on Units and Total Value
The procedure should join PurchaseItem table on receiptID to get upc
Join Items table on upc to get the item information (UPC, Category, Price as Unit Price)
We should group by Category, UPC, let Total = Unit Price x Units
Determine edge cases and expected results
No sales for @date
Single sales category for @date
Multiple sales categories for @date
Single item per category for @date
Multiple items per category for @date
Test in SQL for all cases
Test from our website for all cases
Description
As a store manager, I would like to know what the daily sales are for my company.
Priority: 3
Acceptance Criteria
The only data returned is for the day provided by the user The report shows all sales grouped by item The system returns nothing if there are no sales for the proved day Subtotal rows correctly sum all sales above Total row correctly sums all subtotal rows The system accepts dates in multiple formats
Testing plan
prove that the amount aggregation is correct prove that the system detects the date correctly prove that the system handles dates in multiple formats prove that visual elements respond to the report request in a predictable and logical manner
Story points: 5
Tasks
Create the Order table in SQL