JURNAL SAINS DAN INFORMATIKA
Research of Science and Informatic V8.
Vol.
08No.
http://publikasi.
id/index.
php/jsi p-issn : 2459-9549 e-issn : 2502-096X Making Web-Based Product And Inventory Applications Using The Laravel Framework (Case Study : Cv.
Global Best L.
Rakan Lawahiz Zhafran Ferial Faiz Al Laitsia.
Ai Rositab Informatics Engineering Study Program.
Faculty of Engineering.
Widyatama University, rakanfaiz13@gmail.
Informatics Engineering Study Program.
Faculty of Engineering.
Widyatama University, ai.
rosita333@gmail.
Submitted: 02-08-2022.
Reviewed: 07-11-2022.
Accepted 29-11-2022 http://doi.
org/10.
22216/jsi.
Abstract The process of recording product inflows and outflows is an important process in the company's inventory system.
However, often the process of recording and monitoring these products is not paid attention to by the company and instead allows the manual process to continue.
This can cause significant cost losses if the availability of the product is not suitable, and the product is found to be expired due to uncontrolled.
The development of this new product and inventory application can replace the manual processes used to create detailed results in the inventory process series.
In this study, the author used the Rapid Application Development (RAD) method in application design and the First In First Out (FIFO) method which was used to assist companies in managing the recording of product inflows and outflows.
The results showed that the implementation of product and inventory applications helps companies solve problems related to the flow of goods in and out as well as product monitoring.
Keywords: inventory, first in first out, rapid application development, application, control.
A 2022 Jurnal Sains dan Informatika supply and release of goods.
Because if with the usual process .
anual proces.
as it is now, it will be difficult In this era of very tight business competition, every to search data for goods that have so many variants.
company is required to be able to have quality in providing value to consumers, especially food-based It is very important to know if inventory control is a business categories.
In addition to the quality of the weak point for the company, it can be seen when the products provided to consumers, the quality of the system does not work optimally when tracking .
That company in ensuring the infrastructure in it will be very way every company, both large and growing, must store important to make it easier for each individual to data collection in the system .
This affects the complete their tasks properly.
performance of the work completed, because the better the technology available, the faster and more efficient CV.
Global Best LS is a company engaged in the food the activities that occur within the company .
sector, and precisely produces a traditional West Java food, namely cireng or commonly called "aci goreng" In his book.
Rangkuti also stated that inventory is a with different and unique modifications of variants.
At wealth or asset owned by a company in the form of the company CV.
Global Best LS, all products produced goods with the intention of being sold within the time are the result of their own production as span of the business plan, or inventory used in the fulfillmentRequestfor consumers in various regions in production process or goods stored for the next stage of Indonesia since 2012.
However, with the increasing production .
Information on the supply and sale of the demand for products every year, there is a need to create company's goods will later become the basis for how an ideal and well-managed warehouse storage marketing will then determine targets, as well as sales Therefore, the need for product and priorities for goods that must be increased first.
Because inventory applications can help companies record the the company already knows what types of Introduction Rakan Lawahiz Zhafran Ferial Faiz Al Laitsi.
Ai Rosita/ Jurnal Sains dan Informatika : Vol.
08 No.
products/goods need to be raised first from other use case diagram prioritizes what the system does as products by looking at the available stock of goods.
This well as how actors use it, rather than describing how the is reinforced by the opinion of Johns and Harding who system works internally .
stated that in fact inventory is an important investment decision so that it needs to be prepared when it is carried 2.
3 Web Application out .
The web application is a medium used to receive, store.
Currently, the main method used to design product and and process information to progress a business.
The web inventory applications is Rapid Application application itself uses a combination of scripts from the Development (RAD).
This method is centered on server side and also the client, where the two scripts have iterative application development accompanied by different functions.
The script from the server side will intensive feedback .
This method approach is very handle the storage and data retriever, while the script is well applied in applications designed for companies, from the client side to display data and information to because it can prioritize the suitability of the planned the user .
4 Black-box Testing This study aims to create an inventory application along with product descriptions, where the application can Black Box testing is a method of testing software or a later facilitate the entry, expenditure, statistics of goods system that focuses on the functionality of the system and stock control.
Where the method used in the itself, especially looking at the inputs and outputs of the inventory work system will use the First In First Out application whether it is in accordance with what has (FIFO) method as the rate of goods filtration, and is been designed before or has not been carried out expected to be a solution to the problems that exist in properly.
CV.
Global Best LS.
Research Method Technological advances at this time help in social life and especially in business activities.
Almost all The method that will be used in this research is Rapid companies are now using inventory-based technology to Application Development (RAD), which is an support their businesses to grow.
The more complete and application development model, which consists of the sophisticated the technology contained in a company, following steps:
the easier and more efficient an activity will be carried out in the business activity.
Define the requirements.
Literature Review Prototype.
Rapid construction & feedback gathering.
Finalize product/implementation.
This section explains the theoretical foundations used in research as a reference to a complete understanding of As for stage 4, namely Finalize product/implementation, building applications.
And here's the theoretical basis it will be described in the Results and Discussion section after the Research Methods section.
The steps of the method used in this study can be seen in 1 Information System Figure 1.
The information system according to Marakas and O'Brien in their book is a combination of the people involved, the availability of data sources, and the existence of applicable policies and adequate procedures Figure 1.
RAD method for application development .
for storing information, retrieving, changing, and disseminating in an organization .
So this system 1 Define The Requirement itself is intended in a company or organization to process various information that can be managed in the The first stage carried out in the Rapid Application environment, so that the resources needed will be Development (RAD) method is to obtain as much data arranged and can shorten the time in handling the as possible as a determinant of the purpose of making processes carried out.
In addition, the managed data can the application.
This is used in order to know the stages be used flexibly, as well as shorten the working series of that must be completed in the project being worked on, existing processes.
as well as to make anticipatory steps for problems that will arise .
Therefore, the analysis will start from 2 Use Case Diagram defining the goals that users want to get from the application created, namely:
Use diagram is a picture of the interaction between actors or users and the running system.
But that way the Rakan Lawahiz Zhafran Ferial Faiz Al Laitsi.
Ai Rosita/ Jurnal Sains dan Informatika : Vol.
08 No.
AuThe application of the application to the company is expected to help in seeing the incoming and outgoing goods quickly and accurately.
It will also be seen later on the labeling of goods from the side of the production date, so that monitoring of the product period can be seen at any time.
Ay Figure 3.
Application Design Basics Figure 2.
Application Work Timeline Furthermore, the determination of the work schedule is determined according to the user's ability to implement Based on the results of the approval of all parties and seeing the goals submitted, there are four stages of the schedule in the application work, including: vision, prototype, code, implementation.
The following stages include how to unite views with users about the purpose of the application that you want to build as it was done at the beginning, to how it is implemented at the end.
And the timeline for working on the application can be seen in Figure 2.
The next series of important prototypes is the creation of the homepage as the face of the application.
At this stage the user will know the function of the homepage as a display of the compiled data, from graphs to summaries of so much data to get quick information in just one Figure 4.
Prototype Section Home 2 Prototype The last part in the prototype building stage is to make a design on the profile section, which later this can be a At the prototype stage, the user will see an overview of vital point of user access rights as a level two user.
the application made in the form of a digital design so Because on this page there is a feature to change the that the features that are present will be more easily password of an account that has been created from the captured through the flow of data submitted.
Vogels .
admin side.
This page can also be a central point of explains that by designing a prototype in the application control that is restricted to being understood by the user.
development section, it can help create a suitable and extraordinary system.
Because this method works efficiently in developing an idea while at the same time getting repeated feedback from users.
In this research, the prototyping is divided into three types of basic designs to represent all the designs and features from the data that has been collected previously.
The first design is the dashboard design base, this is the design of the majority of the application display that is used as input as well as seeing the total development of the data at any time.
The display of the first prototype can be seen in Figure 3.
Figure 5.
Prototype Profile Section 3 Rapid Construction & Feedback Gathering The third stage of the research method used has entered the intensive system work stage.
This relates to the implementation of the code with data that has been compiled in writing, or in the form of a prototype whose information is obtained from the user.
This system was Rakan Lawahiz Zhafran Ferial Faiz Al Laitsi.
Ai Rosita/ Jurnal Sains dan Informatika : Vol.
08 No.
developed through the Laravel framework with the aim of making a web-based application.
With web-based applications, users can easily access them through any platform and product control will be lighter.
Along with the implementation of data on the system, feedback to the system being developed is also continuously provided to improve the work.
This relates to the flow of goods method that will be applied to the application, namely the First In First Out (FIFO) This method is recommended because it Figure 7.
Inventory Application Flow matches the items in the CV.
Global Best LS, which is easily damaged because the product's durability is very The functionality of the system on the user's ability in its settings will be illustrated through the use case diagram Under the FIFO method, the goods that are produced earlier are sold first.
As a result, all goods available in the company are the latest goods .
As seen in Figure in Figure 8.
Figure 8.
Inventory Control System Use Case 2 System Testing Figure 6.
Inventory Flow with FIFO .
Result and Discussion .
System testing is a stage that is carried out to find out that the system has been successful in implementing the system design that has been made before.
Testing on this system was carried out using a black box and obtained the results as shown in Table 1.
In this section, we have discussed the results of product application and inventory work along with the implementation of the system at the time of its use.
Name Expected Result 1 System Description Register User data is stored in the database so that the user has access rights to be able to enter the application.
Inventory and product systems that have been designed using the stages of the Rapid Application Development (RAD) method along with system development with the Laravel framework have reached the final stage.
Where the application has implemented the planned functions as follows:
Stores incoming and outgoing goods information Displays the latest and expired items in one inventory environment.
Real time reports of stock information when there are incoming and outgoing goods.
Table 1.
Black-box Testing Sign In Main Page The account is wellvalidated by the system and goes to the main page of the Go to the main page of the The application page also displays expired products, total production per month, total goods out per month, and top products per month.
Test
Results (E) Success
(E)
Success
(E)
Success Schematically, the application of the above functions can be seen in Figure 7.
Rakan Lawahiz Zhafran Ferial Faiz Al Laitsi.
Ai Rosita/ Jurnal Sains dan Informatika : Vol.
08 No.
Register Product Input Product Output Product Create a report Displays data on the list of goods to be produced.
The data entered on the day, the table column will be green.
Furthermore, if the data expires or passes 4 days from the day of the product, the table column will be Displays data on the list of goods to be produced.
The data entered on the day, the table column will be green.
Furthermore, if the data expires or passes 4 days from the day of the product, the table column will be red.
Displays data on incoming goods that have been The data entered on the day, the table column will be green.
The stock on the Item List page will increase according to the Displays outgoing item data.
The data entered on the day, the table column will be The stock on the Item List page will decrease according to the amount of production entered.
Displays data on incoming according to the date Download the Excel/pdf file.
(E)
Success Figure 9.
Home View The homepage presented in the application will provide users with a summary of the data without having to open each page.
This includes how the product expires, the total production in one month, the total product expenditure in one month along with the graph and the last one is the featured product in one month of sales.
other words this page is the application control room.
(E)
Success
Storage View
(E)
Success Figure 10.
Storage View
(E)
Success Storage or inventory pages are used in this series of applications as item detail information.
Starting from real time stock information, information on incoming goods marked in green in the table column, and lastly.
The conclusion of the test for product and inventory expired goods which are red in the column.
applications can be seen from the results of black box testing carried out in the previous stage.
Where this web- 3.
Incoming Item Information Display based product and inventory application does not indicate minor results on user requests to the system itself, even though it has done 7 tests on various pages.
This concludes that the system is in accordance with the expected goals.
3 System Implementation The system implementation part is the result of system design that has been analyzed according to the needs that have been informed.
Home View Figure 11.
Incoming Item Information Display The incoming goods information page is a place to record production results in accordance with the requested goods.
Where the production results that occur Rakan Lawahiz Zhafran Ferial Faiz Al Laitsi.
Ai Rosita/ Jurnal Sains dan Informatika : Vol.
08 No.
writing which takes a lot of time.
stock and condition of goods in a timely Information The inaccurate and very long in the delivery results, stocks, and goods out.
The system can provide data in real time to delivery of reports Economy Running with the old system costs a amount of money for constant book The new system will cost a lot of money upfront for the hardware, with the benefit of being more cost-effective in the long run.
Control Data surveillance is very low when files are available very much just for the same purpose.
The system can carry out data control well, where data can be stored in a data-base.
Efficiency The transfer of data from writing in Excel and then through the printing process will take a very long time in reviewing reports.
The system can generate data directly in Excel or print options through a Services The old system was very difficult in providing optimal service for users at Services searching for goods will be optimized to make data leaders in quick on the day, will be distinguished in green in the column so that users are easy to control incoming goods.
Outgoing Goods Information Display Figure 12.
Outgoing Goods Information Display On the information page of goods out, will be used by users in recording the activity of goods out of the In this recording activity, the FIFO method plays a very large role, where even though the variants of the goods are very diverse, the application is able to prioritize the old goods to come out in each variant.
User Profile Display Figure 13.
User Profile Display Data regarding the user will be displayed on this page, it relates to the user name, user code and also company As well as a vital control room to be able to change user access to this application.
Conclusion 4 PIECES Analysis of the Proposed System Based on the research process that has been discussed PIECES analysis of the proposed system is a way of previously, it can be concluded that:
identifying the magnitude of the impact given by the The application of Rapid Application Development design of the new system by comparing the old system (RAD) for applications made as a system used by the company .
implementation in the company is very appropriate.
Table 2.
PIECES Analysis of the Proposed System This is due to regular feedback and making Analysis Old System Proposal System applications according to company needs.
The approach of the First In First Out (FIFO) method Management of The Performance on the topic of inventory management shows that production results, system is designed with this approach, it can produce a good work stock of goods, and to be able to condition of goods accurately record process flow by looking at the cosndition of the is done manually in production results, goods in the CV company.
Global Best LS.
Rakan Lawahiz Zhafran Ferial Faiz Al Laitsi.
Ai Rosita/ Jurnal Sains dan Informatika : Vol.
08 No.
The implementation of product and inventory .
applications by looking at the comparison features of .
the old system in the company shows that the application can provide more efficient data .
References