SIPS App (Sistem Informasi Pencatat Surat)
React Js
Vite
Tailwind CSS
Express Js
Sequelize
MySQL
From July to September 2023, I was at the Balaroa Village Office for an internship or KKLP (Replacement Field Work Lecture). I did various administrative activities such as making certificates for residents who came.
One day a resident came, he wanted to make 2 different certificates but the same person, so the data entered was also the same. However, because it uses an existing letter template for each type of letter, it is necessary to enter the resident's data into the 2 letter templates.
Well, from here I see it is less efficient because you have to do the same process repeatedly, namely entering resident data by typing, yes, it can be copied but copied one by one and adjusted to a different letter template.
Therefore, I took the initiative to create a system that can handle that by only having to enter the resident's data once, you can make various types of different letters without having to copy it repeatedly.
I was inputting citizen data to create a certificate
in the development process using React Js as the frontend and Express Js as the backend and for the database using mysql. The database used consists of several related tables.
Application dashboard page display
ERD (Entity Relationship Diagram)
Yeah, there are too many tables used because some letter templates have different data formats so they have to be adjusted. However, letters definitely have the same citizen data that is stored in the Surats table.
Some of the main features include:
- Storing employee data, for those who sign the letter
- Storing citizen data, so that you can create different and repeated letters
- Printing directly from the application and printing to PDF files
On August 30, 2023, the application development process was completed and continued to the presentation stage and application training for Balaroa Village Office staff.
After doing the presentation, then do the installation to the Office computer. For the implementation only use the local computer offline.