Skip to content

Latest commit

 

History

History
58 lines (49 loc) · 2.52 KB

README.md

File metadata and controls

58 lines (49 loc) · 2.52 KB
Raw

HR-Management

This responsibility is to develop API using Express with MySQL database and make a company HR management like web application using React as frontend JavaScript Framework

Backend Requirements

ES6/ES6+, Express, MySQL, Sequelize (optional)

Frontend Requirements

React, Bootstrap (optional)

Task Todo

  1. Give the application a name of your choice
  2. As a user, I want to add new employee to my company
    • Create an HTML form to add new employee
    • All the fields should be properly validated before adding
    • The validation errors should be displayed properly
    • The form should have a good UI and UX
  3. As a user, I want to add multiple employees at once by upload a CSV file
    • Create an HTML form to select the CSV file
    • The form should support drag and drop file upload
    • The validation errors should be displayed properly
    • The form should have a good UI and UX
    • The CSV file should contain at least 3 columns: first name, last name, email address.
    • Ignore any other columns that might exist in the CSV
    • The application should add all the valid lines of the CSV file in the database as employees. For example: if the CSV file has 10 lines where line 3 is missing first name and line 7 has invalid email address, I want to see 8 employees added to my company by skipping these 2 lines.
    • After adding the employees from the CSV file, it should display how many employees were added and how many failed.
    • It’s not necessary to display the CSV lines that contain errors.
  4. As a user, I want to see all the employees of the company
    • Create a table that lists all the employees added
    • The list should display 5 employees at a time
    • There should be pagination buttons below to go to previous/next pages.
    • The table should have a good UI and UX
  5. As a user, I want to send email to one or more employees at a time from the application
    • From the table, I want to select employees using checkbox
    • Create an HTML form to compose email
    • The form should contain two fields: Subject, Body
    • The validation errors should be displayed properly
    • The form should have a good UI and UX
    • It’s not needed to send real emails. Using https://mailtrap.io or similar service will work just fine
  6. It’s not required to add any login/signup module

Entity structure

  1. User
    • First name
    • Last name
    • Email address
  2. CSV file
    • First name
    • Last name
    • Email address
    • ... (can be more)
  3. Email
    • Subject
    • Body