WEB APP FOR RETURN OF EMPTY BOTTLES

The customer is an independent business partner for companies operating in the online media field. It conducts project management on an outsourcing basis: from development to support, from security advice to hosting. The customer’s team consists of 15 highly skilled professionals with at least 18 years of experience in online business.

This project is basically about the rebuild of an existing VB6 application in modern Java code. The application allows users to monitor or slightly adjust the process of counting and paying for the empty bottles (articles) that are coming to SRN.

The application allows editing of the list of bottle types and collection points (customers/companies), it gives access to reports, and shows the current state of bags that are in progress or are missing somewhere, and gives details about tasks that are run to support the process.

Challenge

Customers turned to us with the following problems:

  • They needed a convenient way to build complex queries in the database.
  • There were some performance problems with the client’s site. The system was running slowly in the case of multiple requests.
  • Customers needed to restrict access to the application using a White IP List where access would be allowed only to certain IP addresses.
  • There was a need to synchronize data with other databases.
  • It was necessary to construct graphs based on the processed data (e.g., “Number of bags per hour,” “Number of shipments per hour,” etc.).
  • Customers needed improvement of TimeSlot overview and scheduling. It was necessary to develop an electronic schedule (organizer) enabling the reserving of time for unloading and servicing of trucks with bottles.
  • They needed the ability to obtain additional user data from LDAP.

Solution

The problem was solved in the following way:

  • To enable easy construction of complex queries in the database, we suggested and implemented the use of Querydsl.
  • We optimized and used cache data to solve the performance problem and improve the operation speed when there are multiple requests.
  • To restrict access to the application, we implemented Interceptor for requests intercepting and filtering (White IP List and Whitelist for paths).
  • We implemented a file manager based on Qdrive.
  • To construct graphs on the basis of processed data, we used an additional module of chart.js.
  • We developed a data model and implemented basic logic for CRUD operations in accordance with business requirements (frontend and backend sides).
  • We developed Time Slots Overview – an electronic schedule (organizer) to reserve the unloading time of the machine with bottles, featuring marking of fields “reserved time” / “available for reservation time” / “unavailable for reservation time” by different colors. The mechanism takes into account the overlap of reserved periods, and automatically suggests the nearest free time, if the time the customer has chosen for reservation is already taken. After reservation, the customer can view its details at any time.
  • We created jobs or scheduling tasks for processing the scheduled data.
  • We developed a variety of services for the system, for example, MailService – a shared service to send e-mails.
  • We wrote unit tests.

Key features

863EE18C-16F5-4BF0-9497-AC6F5E7F756ACreated with sketchtool.

Access by roles

BF1114CA-E6CF-4CA4-8C85-97CB04C49AD6Created with sketchtool.

Sending e-mails

8F2F501A-7B89-481B-9AFA-5D4AB2C4F56ECreated with sketchtool.

History of the entities’ changes

2ED4FC93-2EF5-4057-8F42-342D2B7F65E8Created with sketchtool.

Report generation

48959FD2-71F5-4426-9CB7-BDFC9A73AF25Created with sketchtool.

Display of the data in graphs

59AEFC42-BBBD-4625-8413-A807018D733BCreated with sketchtool.

Receiving and sending data to external terminals and databases

383D9CFC-B314-4A78-B295-397526F573FBCreated with sketchtool.

Imitation of logging in as a different user for the administrator

815080EB-9671-4AEE-AC66-00627C883386Created with sketchtool.

Tasks that process data in manual or automated mode

Technologies

MySQL
AngularJS
Autocad
Gradle
JasperReports

Do you have a similar project idea?

Anna Vasilevskaya
Anna Vasilevskaya Account Executive

Get In Touch

Drop us a line about your project at contact@instinctools.com or via the contact form below, and we will contact you within a few business days. All submitted information will be kept confidential.