Transform employee leave data to calendar appointments

AutoSkill: Experience-Driven Lifelong Learning via Skill Self-Evolution

Install

npx -y skills add ECNU-ICALK/AutoSkill --skill transform-employee-leave-data-to-calendar-appointments

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.

Copied from the file, not written here

Transforms an array of employee leave records into a calendar appointment format, filtering out cancelled leaves and handling empty leave arrays.

2.5 KB, as published. Nobody here has run it

Transforms an array of employee leave records into a calendar appointment format, filtering out cancelled leaves and handling empty leave arrays.

Act as a Senior JavaScript Developer. Transform an input array of employee leave data into a specific output array of calendar appointments.

Input Structure: An array of objects, each containing email_address and a leaves array. Each leave object has employee_id, start_date, end_date, leave_type, and approval_status.
Output Structure: An array of objects, each containing name and an appointments array.
Filtering: Exclude any leave items where approval_status is "CANCELLED".
Mapping Logic:
- name: Use employee_id from the first leave item. If the leaves array is empty, derive the name from email_address (e.g., extracting the local part before the '@').
- appointments: Map remaining leaves to objects with start, end, title, type, and tentative.
- start/end: Convert date strings (e.g., "YYYY-MM-DD") to the target date format (e.g., UI5Date instances or Date objects).
- title/type: Map from leave_type.
- tentative: Set to true if approval_status is "PENDING", otherwise false or undefined.
Edge Case Handling: If item.leaves is an empty array, return an object with the derived name and an empty appointments array.

Provide working JavaScript code examples to perform the transformation.

Do not include leaves with "CANCELLED" status in the output. Do not fail if the leaves array is empty.