Inventory System

About This Space

A low-code Inventory System


Last updated on April 25, 2021

Forked from: /joe.aliling/low-code-inventory-system-1.0/

Public Permissions:   View   Open/Fork   Run   Comment  

Inventory Management System

This demo project is a complete Inventory Management System, which illustrates the capabilities of Profound.js. It illustrates the ability to implement intricate web apps with zero or minimal code. The application can be used as a template to quickly get you started in building an Inventory System.

The system is comprised of two major parts. One is a portal for the Inventory Manager and another for the Agents.

Inventory Manager

The Inventory Manager portions of the project were mostly created using the Profound.js CRUD App Generator feature, where most of the UI and fucntionality is automatically built for you.

Screenshot

With this feature, once a database table is created, you can immediately generate CRUD screens and logic - all done with just a couple of clicks. The screens can still be customized for aesthetics and functionality after they are generated.

Database Design

With Profound.js, database connectivity from your application is inherent. It is a simple matter of designing your application's database tables. You can then link related tables through drag-and-drop and point-and-click capabilities, and link the data to your application.

Screenshot

Related Tables

One of the handy features in Profound.js is its intelligent presentation of related tables. For example, the Products Grid is implemented using 3 tables, Products, Category and Supplier. Profound.js automatically matches the fields selected from the database query step (Fig. A) and outputs them into their designated columns on the grid (just make sure the field names on the grid perfectly match the fields from your query).

Screenshot

(Fig. A) Below is the database query step to show all records from the Products table and its related tables, Categories and Suppliers.

Screenshot

Notice the Which columns dropdown shows the selected fields for the query and are perfectly matched to the fields on the Products grid. This is all done without any coding; whereas traditionally, functionality like this would require a lot of code.

In this demo, the common functions of the generated CRUD page for the Products table are fully implemented. The search bar below, for example, functions the way you would expect.

Screenshot

The search routine is typically already setup for you by Profound.js and you can customize the query accordingly. The Database query step below has been modified to include the name and description as part of the search criteria.

Screenshot

Icons to edit and delete records are also functional.

Screenshot

The routine that handles the insert and update records are defined for you using low code steps.

Screenshot

One of the forms generated from by CRUD app generator is the Add/Edit form. It was modified a bit to show the names of the Category and Supplier instead of their numerical IDs.

Screenshot

To accomplish this, the Select Box Properties were used for the Category dropdown box to configure it to show the corresponding names of the available Categories for the product.

Screenshot

The important properties that need to be changed are the database connections, choices database table, choice options field and choice values field.

The core of the Inventory Manager part of the system is the Manage Inventory screen as it carries several levels of details in implementing the business process for this project. The functions involved in this module are the following:

  • Inventory CRUD (create, read, update and delete record functions)
  • Assignment of Inventory to an agent
  • Change status of a product request

Screenshot

End-User Guide

This section provides end-user instructions for each module of the Inventory System. There are two types of users of the system.

  • Administrator Account
    • The administrator account is the highest-privileged user which is used to perform important functions in the system.
  • Agent Account
    • The Agent's account is for users, such as retailers or dealers, who would like to maintain product stock information.

Administrator Screens

Products

Managing products can be done on this screen. There are several functions that can be performed on this screen:

  • Add new product
  • Edit existing product
  • Delete product
  • Record search (search by Name and Description)

Screenshot

Categories

Products belong to categories, and using this screen you can add, edit and delete categories.

Screenshot

Suppliers

Each product has a designated supplier. The Suppliers screen handles the record management for product suppliers.

Screenshot

Manage Inventory

The Manage Inventory screen includes the essential functions of the Inventory system. This is where you can assign inventory to an agent or change inventory status. There are three statuses defined in the system. They are:

  • Pending - when an inventory is marked with a 'Pending' status, it denotes that a product is available.
  • Requested - this status marks an inventory as 'requested' which implies that an agent is requesting for product replenishment.
  • Approved - when a inventory is assigned to an agent and marked approved, it signifies that the inventory is made available to that particular agent.

The basic operations (add, edit and delete) on a record can all be performed here on this screen.

Screenshot

Reports

The Reports screen gives a simple summary of the product statistics. It shows the current products in the system and their corresponding information (total, available, pending).

  • Total - numerical value which signifies the number of products in circulation
  • Available - the value which represents the number of the products that can be assigned to agents
  • Pending - shows the number of pending requests from the agents

Screenshot

Users

The Users screen is for managing the system accounts. The Admin-level account can create other Admin-level users as well as users who are Agents.

Screenshot

Agents Screen

Users who are Agents can manage their resources through this dashboard. The first important screen shows the current Products that existing in the system and their availability. By using the Request button, an allocation request of a product will be submitted to the server for the administrator's approval.

Screenshot

My Products

The My Products screen is a table of information to show the Agents their assigned products. Agents will be able to see the current status of their requests. They can cancel the pending request any time by clicking the Cancel button.

Screenshot

Report

The Agent's Report screen shows a general overview of the products standings. Users will be able to see from this page the total number of products approved and the pending product requests.

Screenshot

Be the first to comment:      

Comments

Write Preview Markdown: bold italic code link
Post

Filters:

Popular Recent

This low-code workspace serves as an example of a time and attendance system to be used internally.

14979

0

1

This space illustrates the simplest way to load a Rich Display grid with data, where all records are sent to the grid in bulk.

17826

0

6

Customer Orders & Payments Drilldown

15975

0

0

This interactive customer inquiry app prompts the user for key fields to lookup a customer record

17089

0

0

Simple inquiry application that shows Customer Orders and Payments

19132

0

2

my demo

8632

0

0

A simple Demo of how to deploy EJS templates from a stateful Node.js script

39423

0

6

Displaying information in grids is fundamental to developing applications. This demo application displays a list of products in a grid.

15247

0

1

Calculate simple mathematical operations using server-side code.

14560

0

1

Docs Example - Customer Selection

14665

0

1

Demo app to use EJS to display information from a database

18744

0

4