I developed a mobile app that takes bill of material and the gross requirements of the end item along with the stock, scheduled receipt, arrival on week, lead time and lot sizing rule information of the subcomponents to create MRP records for all parts and components.
This project has been developed using the sqlite database.
- For console version of the project Link
- For the mobile version of the project with SharedPreferences Link
There are 6 buttons in the main activity of application. These are "INVENTORY", "ITEM TREE", "ORDER ITEM", "ADD ITEM", "UPDATE ITEM" and "CLEAR DATABASE" buttons.
When the button is pressed, the inventory page opens and you can see the current stock status.
The data are recorded in the system as tables with the sqlite database.
When the button is pressed, the item tree page opens. According to the products you add, an automatic tree is created and printed on the screen.
When the button is pressed, the ordering page opens. Order is made by following the steps below.
- User enters the id of the item he wants to order in the "Item id" section.
- The user writes down how many pieces he wants for the weeks he wants to order.
- The user presses the "order item" button.
- If the selected item exists in the system, the item entered as input is assigned as the current item. If there are no items in the system, the 1st stage will be returned.
- Calculations for the entered item are returned.
- Calculations are printed on the screen in tabular form.
- Sub-item test is made for the current item, if there are subitems, calculations are made for the subitems and printed on the screen.
When the button is pressed, the product adding page opens and when you fill in the required fields, the product is added.
The value in the spinner indicates which product is the main product of the product to be added
When the button is pressed, the product updating page opens and when you fill in the required fields, the product is updated.
Required fields are automatically filled according to the value you choose in the spinner
When the button is pressed, if there is a value in the spinner, the delete dialog box opens. If you delete the item, all of its sub-items are also deleted.
When the button is pressed, it deletes all records in the system.
ITEM TABLE
| Field | Type | Key |
|---|---|---|
| KEY_ID | INTEGER | PK |
| KEY_ITEM_ID | TEXT | |
| KEY_AON_HAND | INTEGER | |
| KEY_SCH_RCP | INTEGER | |
| KEY_ARON_WEEK | INTEGER | |
| KEY_LEAD_TIME | INTEGER | |
| KEY_LS_RULE | INTEGER | |
| KEY_REQUIRED | INTEGER |
CHILDS TABLE
| Field | Type | Key |
|---|---|---|
| KEY_ID | INTEGER | PK |
| KEY_MAIN_ITEM_ID | INTEGER | |
| KEY_CHILD_ID | INTEGER |
by Yasin Tohan