claudio-osorio / supplier-order-management-software

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.

Hello 👋, I am Claudio Osorio

Welcome to my Github!

• 🔭 I am currently working on Supplier Order Management Software

• 🌱 I am currently learning Docker, Django, React, Angular, JavaScript

• 💬 Let's talk about work, technology, trading, or anything else :)

• 📫 Add me on LinkedIn

• ⚡ Here is a fun fact about me: I did not know or use the internet until I was 19 years old, and I am not that old...

Connect with me:

Languages and Tools:

 

supplier-order-management-software's Issues

Message box lists too many orders that are to be deleted

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.

Explain how importing from Excel spreadsheets work

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 a new address is not stored

Situation:

1. An order exists.
2. The order has a Lot/Blk and blank Full Address entry.
3. The order is being modified.

Problem:
After solely adding a new Full Address, the new address is not being stored.

Add customizable search date range

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.

Items not listed when modifying an order

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.

Need to implement deleting Companies, Employees, Supervisors and others in a smart way

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.

Adding delimiters

Adding commas to delimit thousands. Example: $1,000.00

Changing the naming convention of order attachments

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.

Faster dropdown selection

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.

Searching for values containing trailing and leading spaces, mismatch

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 limit to the number of orders being displayed

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)