Developed by:
- Fadhil Zahran Muwafa (Project Leader & Back-end)
- Muhammad Rafi Akbar (Project Assistant & Front-end)
Table of Contents
This web-based application is developed using the CodeIgniter 4 framework. The purpose of this app is to manage all incoming and outgoing Network Terminal Equipment (NTE) material data and perform automatic stock opname. It represents an innovative solution developed by the Informatics Engineering interns of Sriwijaya University, led by Fadhil Zahran Muwafa. According to our report, this application has resulted in a 50% efficiency improvement in performing stock opname. Consequently, warehouse administrators at PT Telkom Akses Palembang no longer need to manually conduct daily and weekly stock opname, thanks to this app.
Note
As part of our academic requirements, this intership program conducted from July to August 2022 fulfills the practical work component of our university curriculum. The output of our intership project, namely this application, earned us an A grade (Excellent) from our supervising lecturer. We are deemed to have successfully applied the knowledge acquired from our university by delivering innovative solutions in the form of this application along wih written reports to the company and supervising lecturer.
CodeIgniter is a PHP full-stack web framework that is light, fast, flexible and secure. More information can be found at the official site. This repository holds a composer-installable app starter. It has been built from the development repository. More information about the plans for version 4 can be found in the announcement on the forums. The user guide corresponding to this version of the framework can be found here.
composer create-project codeigniter4/appstarterthencomposer updatewhenever there is a new release of the framework.- When updating, check the release notes to see if there are any changes you might need to apply to your
appfolder. The affected files can be copied or merged fromvendor/codeigniter4/framework/app. - Run the commands to check whether the CI4 instalation has been succeeded.
cd <your_dir>thenphp spark serve - Open localhost URL in your browser.
- Clone the repository using
git clone - Copy
envto.envand tailor for your app, specifically the baseURL and any database settings. - Run command
composer install - Run command
php spark migrate - Run command
php spark serve - Open localhost URL in your browser
Important
index.php is no longer in the root of the project! It has been moved inside the public folder, for better security and separation of components.
This means that you should configure your web server to "point" to your project's public folder, and not to the project root. A better practice would be to configure a virtual host to point there. A poor practice would be to point your web server to the project root and expect to enter public/..., as the rest of your logic and the framework are exposed.
We use GitHub issues, in our main repository, to track BUGS and to track approved DEVELOPMENT work packages. We use our forum to provide SUPPORT and to discuss FEATURE REQUESTS.
This repository is a "distribution" one, built by our release preparation script. Problems with it can be raised on our forum, or as issues in the main repository.
PHP version 7.4 or higher is required, with the following extensions installed:
Warning
The end of life date for PHP 7.4 was November 28th, 2022. The end of life data for PHP 8.0 was November 26th, 2023. If you are still using PHP 7.4 or 8.0, you should upgrade immediately. The end of life date for PHP 8.1 will be November 25th, 2024.
Additionally, make sure that the following extensions are enabled in your PHP:
- json (enabled by default - don't turn it off!)
- mbstring
- mysqlnd - if you plan to use the MySQL
- xml (enabled by default - don't turn it off)
- libcurl - If you plan to use the HTTP\CURLRequest library
Figure 1 is the application usecase diagram.
Fig. 1 Use Case Diagram
Tip
Due to the plain background of the diagrams we created, such as use case, sequnce, and activity diagrams, we are unable to include all of them in this file. We are afraid you set the dark mode on your GitHub interface. You can download the relevant diagrams to further enhance your understanding of this application through the following link
Fig. 2 Login Page
The dashboard page displays all incoming and outgoing NTE data entered by the user, the warehouse administrator. On this page, users can export data in .txt or .xlsx formats for performing stock opname on Supply Chain Management (SCM) Telkom application afterward, so there is no need to create .txt or .xlsx files from scratch. Additionally, users can delete data either entirely or one by one. Figure 3 shows the dashboard page.
Fig. 3 Dashboard Page
This page serves to input data regarding incoming and outgoing NTE materials. This page appears after clicking the Stock Opname button on the Dashboard or Input Material page. Users can also view input history for further cross-checking in case of errors. At the top section, users can search for the specific data to perform actions, either for editing or deleting.
Fig. 4 Stock Opname Page
One of the inefficient activities performed by the Warehouse Administrator is inputting/scanning incoming materials data into the warehouse one by one and repeatedly in Excel. Users have to organize data column by column. However, through the feature on this page, the warehouse administrator only needs to scan the box without worrying about the type of NTE material. Because after clicking the "Submit" button, the data will automatically be arranged by type and formatted as .xlsx (see the next page).
Fig. 5 Input New Materials Page
After inputting new material data (see subpoint 8.4), the warehouse administrator can view the results on this page. Users can export data into an Excel file to be saved and used as a report. Additionally, users must delete all data if new materials are sent to the warehouse the following week.
Fig. 6 See Data Page
Hello, if you are interested about people behind this lovely project, you can reach out to us through the following accounts.
- Fadhil Zahran Muwafa (Project Leader: Graduate of Sriwijaya University, Department of Informatics Engineering 2020-2024, Faculty of Computer Science)
- Muhammad Rafi Akbar (Project Assistant: Graduate of Sriwijaya University, Department of Informatics Engineering 2020-2024, Faculty of Computer Science)
Pull requests are not available for non-contributor. If you have any questions or recommendations regarding this project, please feel free to comment in the Issues section.
Copyright © 2022 by Fadhil Zahran Muwafa & Muhammad Rafi Akbar
This project is under the MIT License.
As the developers, we are aware that the developed application still has some shortcomings. Hence, constructive critism, suggestions, or recommendations from you are highly appreciated.