netspective-labs / sql-aide

SQL Aide (SQLa) Typescript template literal text supplier optimized for emitting SQL
https://www.sql-aide.com/
MIT License
15 stars 17 forks source link

refactor: hiring checlist model #196 #198

Closed jobyjames1 closed 4 months ago

jobyjames1 commented 4 months ago

Summary

This pull request introduces new enum models and alters the hiring_checklist_view to enhance support for the hiring checklist model.

Changes

  1. New Enum Models:

    • Added new enum models: interview_medium, payroll_items_type, notice_period.
    • These enums support various aspects of the hiring checklist.
  2. Altered hiring_checklist_view:

    • Modified the view to handle different cases for checklist items:
      • For codes like 'DATE_OF_DATA_COLLECTION', 'DATE_OF_INTERVIEW', 'DATE_OF_JOINING': returns checklist_date.
      • For codes like 'INTERVIEWER', 'IDENTIFYING_THE_REPORTING_OFFICER', 'EXPERIENCE_CERTIFICATES_FROM_PREVIOUS_EMPLOYERS', 'RELIEVING_ORDER_FROM_PREVIOUS_EMPLOYERS', 'SALARY_CERTIFICATE_FROM_THE_LAST_EMPLOYER', 'ALL_EDUCATIONAL_CERTIFICATES_AND_FINAL_MARK_LIST_FROM_10TH_ONWARDS', 'PASSPORT_SIZE_COLOUR_PHOTOGRAPH', 'FOR_ADDRESS_PROOF_AADHAAR_&_PAN_CARD', 'ASSIGNING_TO_THE_TEAM_AND_REPORTING_OFFICER', 'INDUCTION_TO_THE_TEAM': returns party_name.
      • For 'MEDIUM_OF_INTERVIEW': returns value of interview_medium.
      • For 'DEDUCTIONS', 'EMPLOYEE_BENEFITS_AND_FACILITIES': returns value of payroll_items_type.
      • For 'NOTICE_PERIOD': returns value of notice_period.
      • For other checklist items related to various employment documents and procedures: returns value of employee_process_status.
      • Default case: returns hc.summary.