Supplier Order Management Software (SOMS) was designed to insert, modify, delete, import, and email orders from a supplier to its business partners. Generates email drafts by finding, and sorting orders and their attachments to resolve issues with the collection of payments. The email generation is based on orders saved on a database.
Message box lists all orders to be deleted. It is necessary to put a limit in place to prevent a long list or huge message box. Probably limiting the list to 10 orders then saying "more" is the way to go. Another possible solution is to prevent the simultaneous deletion of more than 10 orders.
Need to add documentation explaining how to import orders or generate them from an Excel spreadsheet (including attachments). It is also needed to explain how users can debug problems by reading the log.
An import template Excel file should be added to the project for the convenience of users.
Adding an option to set the default "Clear" date while searching orders... Currently, the search range is set to use January 1st of the current year up to the current date. With the new option, that search range would be customizable and explicit.
When an order is being modified, the dropdown/Combobox do not list other items unless the current entry is completely removed. The Combobox should display all items when clicked on.
Deleting Companies, Employees, Supervisors and others is important. There's no current implementation for that. It is crucial to take the correct steps towards solving this problem. Deleting should be possible, but at the same time it can become a complicated problem because many orders rely on the "Employee", or "Community" data. Checks must be added to ensure such data is not in use.
Another way to go about this is to implement options to somehow "Hide" such objects from the listings throughout the program. New tables can be created and the exclusion of records that appear on both could be a solution to this issue.
Currently, order attachments are listed as "id - order_number" but this could be changed to something better. Maybe removing the "id" from the name would suffice for now.
Make the Combobox/dropdowns to search for employee, supervisor, company typeable so that it filters out the records and to reduce the scrolling time to a minimum during the selection process.
Search parameters need to be trimmed from trailing and leading spaces to prevent issues where all results show up due to the extra spaces within the search area.
Add limits to the number of orders being displayed to prevent high memory consumption and reduce wait times.
The ideal approach would be the implementation of pages. Each page could have a specified number of rows in length (eg. 50, 100, 300)