VSN-2137 : Remaking the default passengers template to match the newly introduced passenger changes & implementing dynamic dropdown behaviors in data sheet columns.

Merge Request Description

Documentation Updates

Changelog Update

The changelog file has been updated to reflect the latest modifications and ensure proper tracking of changes across the project.

Refactoring

Reference Sheet Mapping

The reference sheet mapping has been restructured to improve clarity and maintainability of the data flow.

Contract DTO Definition

A new Data Transfer Object (DTO) has been defined to represent contract data. This DTO is now referenced in the ReferenceSheetRequest as a list, ensuring consistent handling of contract-related information.

Template DTO and Service Implementation

The request DTO for the reference passenger sheet has been refactored, along with its associated service implementation, to align with the new passenger template structure.

Features

Final Touches on Dropdowns

Dropdowns have been added to specific columns, with associated values dynamically specified to enhance flexibility and usability in data sheets.

Dynamic Contracts and Lots Attribution

Contracts and lots are now dynamically attributed, allowing the system to assign lots based on the corresponding contract in a more automated manner.

Dynamic Columns Attribution

Dynamic attribution of cities related to each department has been introduced, ensuring that departmental data is enriched with relevant city information.

Department DTO Definition

A new Department DTO has been created to consolidate departmental data, including department name, code, and associated cities.

Hidden Lists Sheet Creation

A hidden lists sheet has been created within the Excel file to store auxiliary data required for dropdowns and references.

Hidden Lists Sheet Population

The hidden lists sheet has been populated with initial headers, providing the necessary structure for future data entries.

Closes VSN-2137