RAW-MATERIAL-INVENTORY-MANAGEMENT

TABLE OF CONTENTS

• Description
• About JsonPowerDB & Benefits of Using JsonPowerDB
• Features
• Technology Used
• Navigation Buttons
• Control Buttons
• Project Status
• Sources

Description

A web application is designed to efficiently manage the inventory of raw materials for a manufacturing unit. It provides a user-friendly interface to add, update, and track raw material items, ensuring smooth stock management. The application includes various features such as item addition, item receipt, and item issue, with complete validation and reporting functionality.

About JsonPowerDB & Benefits of Using JsonPowerDB

JsonPowerDB is a Real-time, High Performance, Lightweight and Simple to Use, Rest API based Multi-mode DBMS. JsonPowerDB has ready to use API for Json document DB, RDBMS, Key-value DB, GeoSpatial DB and Time Series DB functionality. JPDB supports and advocates for true serverless and pluggable API development.

• Fast and Efficient: JsonPowerDB offers high-speed performance due to its in-memory data processing capabilities.
• Flexibility: It supports various types of data manipulations, including querying, updating, and deleting, using simple JSON queries.
• Ease of Use: JsonPowerDB's JSON-based querying language is straightforward and easy to learn, simplifying database interactions.
• Scalability: Designed to handle large amounts of data efficiently, making it suitable for applications with growing data needs.

Features

• Item Management: Add or edit raw materials. Fields include: Item ID, Item Name, Opening Stock, and Unit of Measurement (UoM). Validates if Item ID exists in the database and loads existing details. If not present, allows the creation of a new item.

VIDEO https://github.com/user-attachments/assets/f60e9178-413f-47d5-9664-503893483195

• Item Received (Inward): Manage items received into the store. Fields include: Receipt No, Receipt Date, Item ID, and Quantity Received. Checks if the entered receipt number or item exists in the database. Displays relevant details for valid entries and handles validation errors.

VIDEO https://github.com/user-attachments/assets/91272f16-3b19-483e-a645-ac404225d597

• Item Issued (Outward): Manage items issued from the store for production. Fields include: Issue No, Issue Date, Item ID, and Quantity Issued. Ensures that issued quantity does not exceed available stock, with validation and error handling for non-existent items or excessive quantity entries.

VIDEO https://github.com/user-attachments/assets/00d0ccc2-ff6e-4dfd-8850-8fa7204c0168

• Item Report: Generate reports on the stock of items within a given range of Item IDs. Displays Item ID, Item Name, and Current Stock in a tabular format for better inventory tracking.

VIDEO https://github.com/user-attachments/assets/86fceeb6-0904-4757-87e2-333540b39bc8

• Stock Management Dashboard: Centralized navigation system with a common header, footer, and left-side navigation menu. Easily access different pages (Item Management, Item Received, Item Issued, Item Report) based on the user’s selection.

VIDEO https://github.com/user-attachments/assets/9d042017-1a8a-445e-a142-997b34901dd3

Technology Used

(back to top)

Navigation Buttons

• First: Navigate to the first item record in the database.
• Previous: Navigate to the previous item record relative to the current record.
• Next: Navigate to the next item record relative to the current record.
• Last: Navigate to the last item record in the database.

Control Buttons

• New: Prepare the form for new data entry by clearing existing data.
• Save: Save the current form data as a new record or update an existing record.
• Edit: Enter edit mode to modify the current record.
• Change: Apply changes to the current record with updated details.
• Reset: Return the form to its initial state, clearing all fields and disabling editing.

Project Status

Currently in development with version 1.2.0 integrating JsonPowerDB. Future updates will focus on additional features and enhancements based on user feedback.

• Add authentication and user role management.
• Provide more detailed analytics and reporting.
• Implement a notification system for low stock alerts.

Sources

JsonPowerDB Documentation : Comprehensive documentation for JsonPowerDB, including setup, queries, and API references.🌟

• Home page: (https://login2explore.com)

• Register to use JsonPowerDB: (http://api.login2explore.com)

• JsonPowerDB Help: (https://login2explore.com/jpdb/docs.html)

  (back to top)