Mars-EMS

Overview 📂

Mars-EMS is a full-stack web application that simulates an Employee Management System for, both, the accountant and HR departments. It uses Google Sheets as a database and Google OAuth 2.0 for authentication. It allows users to manage employees, their salaries, bonuses, penalties, and more. It also calculates the total payroll for each month and displays it in a dashboard. The EMS stands for an employee management system which was built to help companies reduce their time spent regarding the Accounting and HR departments. It helps with generating salaries, penalties, bonuses, etc. Employing a new staff member is only a few clicks away or giving an end date takes one click. It contains many other features, like giving loans to employees, tracking their installments, making annual/ monthly reports, and much more. It looks and feels great thanks to great structure and design, and even though it possesses many features, the complexity is hidden from the end-user. So it always appears easy to use, no matter what functionality level you choose. It uses ReactJS (AND its entire ecosystem) on the frontend and NodeJS (SailsJS) + MongoDB/ Mongoose on the backend.

Tech Stack 🛠

Tech	Docs	Description
	ReactJS	A JavaScript library for building user interfaces
	Node.js	A JavaScript runtime environment that executes JavaScript code outside a web browser
	Express	A web application framework for Node.js
	MongoDB	A cross-platform document-oriented database program
	Bootstrap	A popular front-end framework for building responsive web pages
	Redux	A state management library for JavaScript applications
	OAuth2	An open standard for access delegation
	React Router	A collection of navigational components for React applications
	CSS3	A style sheet language for describing the presentation of web pages
	Redux Forms	A library for managing form state in Redux applications
	Redux Thunk	A middleware for writing async logic that interacts with the Redux store
	Google Sheets API	An API for reading and writing data to Google Sheets
	Sails.JS	A framework for building Node.js applications with a modern MVC architecture
	Lodash	A utility library for manipulating and iterating over arrays, objects, and strings
	Google App Scripts	A scripting platform for automating tasks across Google products and third-party services
	Restful API	An architectural style for designing web services that provide a uniform interface for interacting with resources

Instructions 📝

In order to run & use this app locally, follow these steps:

• Clone the repository: git clone https://github.com/dzenis-h/Mars-EMS
• Install the necessary dependencies: Run npm install in all three folders:
  • ROOT folder (Mars-EMS).
  • BACKEND folder (Mars-EMS\backend).
  • FRONTEND folder (Mars-EMS\frontend).
• Add your own credentials:
  • Go to Google Cloud Console
  • Create a new project.
  • Enable the Google Spreadsheets API.
  • Create OAuth credentials - for the client choose Web client
  • Copy the Client ID and paste it inside of the config file (frontend\src\config\config.js).
  • Don't forget to do similar for the backend -Look into the 'client_secret' JSON file for more info.
  • For the backend, you’ll have to choose 'Other’ aka Installed.
  • Download the file and save it inside of the backend (its root) folder under the name 'client_secret.json'.
  • NOTE: Both of them have to point to the same project. Additionally, if you want to use a remote MongoDB storage, you’ll have to edit the connections.js file and change your preferences. The file is located inside of the backend\config\connections.js file.
• Now let’s start the project:
  • Run an instance of your local MongoDB: mongod [ Important – this needs to start first ]
  • Run the following command inside of the root folder: npm start
  • NOTE: It will start the NodeJS backend and the ReactJS frontend at the same time.
• It’s time to log in: The login restriction has been removed (by default). To log in, you can use your Gmail account.
  • Previously, the login was restricted, and to log in you had to use the email which I was providing. If you’re still interested in changing the default behavior, you can achieve that, on a basic level, by editing the config file located in frontend\src\config\config.js
  • This part is very important: After you get redirected, copy the code received from Google, go back to localhost: 3000 or Heroku (depending on where you're doing the testing), paste it into your app, and confirm.

Contributing 🙌

Contributions are always welcome! If you would like to contribute to this project, please follow these steps:

1. Fork the repository. 🍴
2. Create a new branch. 🌵
3. Make your changes and test them thoroughly. 👨‍💻
4. Submit a pull request. ✔

License 📄

This project is licensed under the MIT License. See the LICENSE file for more details.

Credits 👾

This project was created by Dzenis H.

"If you like what you see, please consider giving a ⭐️