A. Result
Having delved into the intricacies of warehouse operations and the principles of Agile methodology, we now shift our focus to the practical implementation of these concepts. Our objective is to transform the methodology into a tangible product design, laying the groundwork for efficient future development. This entails a structured approach encompassing several key steps:
1. Use Case Diagram: A Use Case Diagram serves as a visual representation of the interaction between an admin user and our program, highlighting the functionalities and capabil- ities offered by the program. It effectively communicates the program’s purpose and demonstrates how an admin can utilize it to perform various tasks.
Figure 1.
Use Case Diagram of SWIF.
Figure 1.
Use Case Diagram of SWIF.
Based on the provided Use Case Diagram 1, it is evident that the administrator role possesses a wide range of func- tionalities, yet it falls short of the capabilities granted to the higher-authority actor. This higher-authority actor, presumably a system administrator or manager, holds the privilege to per- form critical tasks such as modifying warehouse information and adding new administrators.
2. Physical Data Model: A Physical Data Model (PDM) serves as a crucial tool for representing the final or preliminary design of a database schema for a warehouse management system. It provides a comprehensive overview of the data structures, relationships, and constraints within the database, facilitating efficient database development and management.
Figure 2.
Physical Data Model of SWIF.
Figure 2.
Physical Data Model of SWIF.
A well-structured Physical Data Model (PDM) 2 serves as a cornerstone for designing an efficient and scalable database, particularly in the context of a Warehouse Management Sys- tem (WMS). By carefully defining entities, their relationships, and data attributes, the PDM 2 empowers developers to minimize data redundancy, optimize storage utilization, and enhance the overall performance of the database system.
Consider a scenario where you want to retrieve data from the barangs table using information from the shipmentdetails table. With a well-designed PDM, you can achieve this efficiently by utilizing a single column, such as the id column, that uniquely identifies the relevant records in both tables. This approach eliminates the need to join multiple columns, reducing the complexity and improving the performance of the data retrieval operation.
Figure 3.
Design Prototype of SWIF.
Figure 3.
Design Prototype of SWIF.
3. Design Prototype: Within the realm of software development, the design prototype plays a pivotal role in establishing the foundation for an intuitive and user-centric in- terface. It serves as a tangible representation of the software’s layout, functionality, and overall aesthetic, enabling developers and designers to meticulously refine the user experience before embarking on the intricate coding process.
To ensure a user-friendly experience, we created a stream- lined prototype3 for our warehouse management system. The design prioritizes clarity and ease of use, while incorporating a touch of visual appeal through a calming pink color palette and well-chosen icons. This Figma prototype serves as a blueprint for the final software, guaranteeing a seamless and intuitive interface that contributes to the overall success of the system.
Figure 4.
Agile Software Development Life Cycle.
Figure 4.
Agile Software Development Life Cycle.
User Interface 4.1 Authentication Authentication is a process of verifying the identity of a user who wants to access a software system. The purpose of authentication is to protect data from misuse by unauthorized parties. In SWIF, we use sign-in and log-in as steps for authentication. This way, every user who operates SWIF can be tracked for identification if necessary. In addition, this authentication also plays a role in protecting the data of each user from misuse.
Figure 5 and
Figure 6 are the authentication views of SWIF.
Main Menu Upon successful authentication, the user will be directed to the main menu page. In the main menu, users can view the overall report of expenses and income of goods, as well as information about the identity of the warehouse that the software is operating on. On the other hand, only the SuperAdministrator can change the warehouse identity on the main menu page.
Figure 6.
Demo: List Admin Page.
Figure 6.
Demo: List Admin Page.
Figure 7.
Demo: Main Menu.
Figure 7.
Demo: Main Menu.
Item Table The SWIF website also has another feature, which is a page for the item table. The purpose of this item table is for users to add categories and items to be entered along with their identities. In addition, on this page users can also change the identity or attributes of items from before. In addition, this item table page is also equipped with a search feature to make it easier to find items.
Figure 8.
Demo: Add Item.
Figure 8.
Demo: Add Item.
Figure 9.
Demo: Search Items and Edit Item Result.
Figure 9.
Demo: Search Items and Edit Item Result.
Figure 10.
Demo: Edit Item.
Figure 10.
Demo: Edit Item.
Item History The SWIF website also has a feature in the form of a page for item history. With this feature, users can view and monitor changes in the stock of each item. This feature has also been designed to detect users who make changes to the stock of these items. Similar to the item table, this page is also equipped with a search feature to make it easier to find the data needed in the history. In addition, in the item history, users can also print out the data on the table feature.
Table 2.
SWIF Development Phase based on Agile Method.
Table 2.
SWIF Development Phase based on Agile Method.
Cycle |
Implementation |
Planning |
Defining the Scope and Setting the Stage: The planning phase lays the foundation for the project, outlining the features, pages, budget, timeline, and team size. For SWIF, this involved: 1. Features: - Data management (inbound and outbound) - Streamlined stock adjustments through an interface - Automated data recording across various processes - Comprehensive shipment tracking capabilities - PDF report generation of data records - Invoice generation based on shipment details - Real-time stock level tracking - Robust privilege-based access control system (staff and super admin roles) 2. Pages: - Login page - Record page - Table page - Dashboard page - Item notification table page - Category notification table page - Add category page - Add data page 3. Budget: Zero budget (utilizing available resources) 4. Timeline: 4 months 5. Team Group: 6 people |
Analysis |
Understanding Requirements and Leveraging Existing Designs: The analysis phase delves into the details of each feature, ensuring a clear understanding of requirements and utilizing existing designs. For SWIF, this included: 1. Analyzing existing designs: - Login page (Figma) - Admin page (Figma) - Dashboard (Figma) 2. Defining field requirements: - User authentication for login - Data fields for record page and table page - Dashboard metrics - Notification table fields 3. Reviewing database: Existing MySQL database structure 4. Ensuring design consistency: Aligning all pages with functional requirements and Figma designs |
Design |
Creating the Blueprint and Selecting Technologies: The design phase translates requirements into a detailed blueprint, encompassing business rules, layouts, themes, and frameworks. For SWIF, this involved: 1. Establishing business rules: - Access control permissions - Data validation rules - Stock adjustment procedures 2. Designing layouts: - User-friendly interfaces for all pages - Consistent design language across the application 3. Selecting themes: Color schemes and typography that align with the brand identity 4. Choosing frameworks: - Front-end frameworks for building responsive and interactive interfaces (Bootstrap 5) - Back-end frameworks for efficient development (Laravel 8) |
Implementation |
Bringing the App to Life: The implementation phase brings the design to life, developing the application code, testing it for functionality, and integrating it with the backend infrastructure. For SWIF, this included: 1. Backend development: - Setting up servers and databases - Implementing APIs for data exchange - Creating physical data models 2. Ensuring code quality: - Following best practices for code structure and maintainability - Conducting unit tests to verify individual components 3. Integrating frontend and backend: - Connecting the UI/UX elements to the backend functionalities - Ensuring seamless data flow between the frontend and backend |
Testing |
Ensuring Quality and Bug-Free Operation The testing phase rigorously scrutinizes the application to identify and fix bugs, ensuring it meets quality standards. For SWIF, this involved: 1. Thorough testing: - Unit testing for individual components - Integration testing for inter- component interactions - System testing for overall functionality - User acceptance testing to gather feedback from potential users 2. Bug identification and resolution: - Identifying and tracking bugs throughout the testing process - Implementing fixes and re-testing to ensure bug-free operation 3. Quality assurance: - Ensuring the application meets all defined quality criteria - Addressing any performance or usability issues |
Maintenance |
Continuous Improvement and Support: The maintenance phase ensures the application’s long-term health, addressing issues, implementing enhancements, and ensuring team alignment. For SWIF, this involves: 1. Performance monitoring: - Tracking application performance metrics - Identifying and resolving performance bottlenecks 2. Issue resolution: - Responding promptly to user reported issues - Implementing bug fixes and patches 3. Continuous improvement: - Gathering user feedback and suggestions - Prioritizing and implementing enhancements to improve the application |
transactions. To do this, users need to fill out a form with the necessary information. Once the form is complete, the order data will appear in the item delivery table. Here, users can view the order attributes and change the order status by clicking the green button shown in Figure 19. The order status can be changed according to the user’s wishes, and the changes can be seen in Figure 20.
Figure 11.
Demo: History.
Figure 11.
Demo: History.
Figure 12.
Demo: Print Record / History.
Figure 12.
Demo: Print Record / History.
Item Delivery Item delivery is another important feature of SWIF. This feature allows users to process item delivery
Figure 13.
Demo: Shipment.
Figure 13.
Demo: Shipment.
Figure 14.
Demo: Shipment Form.
Figure 14.
Demo: Shipment Form.
Figure 15.
Demo: Shipment Search.
Figure 15.
Demo: Shipment Search.
Figure 16.
Demo: Shipment Update Process.
Figure 16.
Demo: Shipment Update Process.
A. Discussion
Implementation of Agile Methodology in the development of our warehouse management website has proven highly ben- eficial for us as developer. Agile’s iterative approach allowed us as developer to continue this project’s development and adaptation throughout it’s life cycle, ensuring that the website will always remains usable in long term condition and meets the required needs and expectation from users.
Based on the problem formulation that we identified in the beginning, the website we developed has effectively addressed these issues. It has optimized all warehouse management processes, reduced both natural and human resources involved in warehouse management operations and mitigated accuracy and data storage issues associated with manual warehouse management. With SWIF, all warehouse management pro- cesses have become highly efficient due to automation, thereby reducing resource requirements as traditional methods such as books for tracking are no longer necessary.
Based on the related work Warehouse Management System for Smart Digital Order Picking Systems [
6]. We mutually agreed that automation in all warehouse management pro- cesses have significantly enhanced efficiency compared to traditional methods involving manual record-keeping.
This research was constrained by limited resources in terms of detailed warehouse information that available to the researchers, our individual knowledge and experience gaps in software engineering development also proved to be a hindrance for us as a team. For future research, a detailed exploration of the specific cases addressed in this study would greatly assist in managing and further developing the software solution presented.
Figure 17.
Demo: Shipment Update Process Result.
Figure 17.
Demo: Shipment Update Process Result.
Figure 18.
Demo: Shipment Invoice.
Figure 18.
Demo: Shipment Invoice.