Incorrect UIN generation

[abrbhat]

The current logic for generating UIN is incorrect.

As per, current logic, the below query fetches the approved drone whose record has the highest id.

digital-sky-api/src/main/java/com/ispirit/digitalsky/repository/OperatorDroneRepository.java

Line 16 in 573899f

@Query("SELECT MAX(id) FROM OperatorDrone od WHERE od.operatorDroneStatus ='UIN_APPROVED'")

This can lead to multiple drones getting same UIN because record with highest id might not have the highest UIN. This will happen when a drone with higher id gets its UIN before a drone with lower id.

@sidd-shetty @sidhantgoel @charan1994 @suraj-shanbhag