With RPA process, use the pandas dataframe to compare two data or analyze the cause of change in trends. Analyze. Instead of saving the analysis results in the database, they are converted to json format and delivered to the report. The report information is stored in the database, and when an http request is received, a report linking the database and json is displayed.

When registering a parcel, register the parcel by scanning or directly entering the barcode or QR code using html5-qrcode javascript. If a parcel arrives without any information, a QR code or barcode is generated with random numbers using a generator with the Google Chart API function. Parcels registered in the system can be checked on the table page using datatable javascript. The search function of datatable javascript is applied to all columns and shows all rows corresponding to the keyword in any column.

This application does not use the default user type but is custom. The reason is because there is a team to which the user belongs. This application is divided into two permissions. User permissions allow you to only check requests from your own team. However, administrators can access the all list view. In the case of My Day, since it can be used once a month, the credit is renewed on the 1st of every month. At this time, the scheduled queue is executed using rabbitmq. If the request does not have credit or does not meet other conditions, an error message is returned and displayed on the template to help the user recognize the error and make a proper request.

It is a CRUD application based on rest API. The database is configured with MySQL. And database tuning or monitoring is possible through phpmyadmin. The distributed app is in the form of a Django application, but is currently being converted to the Laravel PHP web framework to better perform the photo upload function.

When the page is refreshed, random data is automatically analyzed by the RPA process. Based on node.js technology, javascript and jquery such as chartjs and datatables used on displaying charts or tables. It is designed to periodically upload new data through celery. To indicator value, Flask was chosen as the web framework to handle long calculation.

Embedded video is connected, so you can watch videos. After watching the video, we conducted a feedback survey using MongoDB, a Nosql database. Database monitoring can be done regardless of the server using the web-based MongoDB Compass. To prevent copyright issues, all HTML and CSS on this page were designed and entered manually.

This system operates by installing apache on a window server for production. When a user registers a visitor, related information is sent to the approval line. The payer is the primary user's team leader, and the secondary is the security team leader. It is a parallel structure, and payment requests are received via email. It connects to the company's internal server network using an SMTP server and automatically sends emails when data is created. If it is not running locally, configure mail transmission using the emailjs or mailtrap system.

This system manages and tows vehicles that violate parking regulations in a parking lot. Security Guard walks through the parking lot, registers offending vehicles and counts the number of violations in the system's PostgreSQL database. When you register a parking violation, a ticket is automatically issued, printed on a mobile printer, and displayed in the vehicle window.