aberinnj/project.postal

University of Houston - Database Project

project.postal's Issues

Tracking data duplicates.

Automated tracking information inputted into the tracking table has duplicate results. Possibly a trigger issue, maybe a combination of triggers and front end querying or duplicate/nondistinct queries in the trigger?

Customer view package tracking does not work

dashboard/orders/track/[Package ID] page does not display tracking information for the particular [Package ID].

Server crashes when a package is made with too high a weight

Might be an issue with other fields as well.

Customer Invoice Seach

The wording above the text field should edited to reflect that you are searching for invoice id.

There should be a warning/pop-up if they search for an invalid invoice

Need to expand or limit options of shipping locations to make it not look like a bug.

If a customer in a state where there are no post offices (ie Alabama) attempts to make a package, they won't be given a selection of nearby post offices to take it to and won't be able to select a post office, however there is no feedback to tell them that there are no nearby locations, so it looks like a bug where there's no options.

We may need to add at least 1 location in each state, and add clarification for the users (Uma) regarding how our system works.

Customer Search tracking does not work

Similar to the view package issue, the customer orders/track page does not work when inputting a package id into the input field.