---

This is a EMS software - [Employee management system] that can help companies reduce their time spent on salaries, penalties, bonuses and a lot of other things regarding the accounting department, as well as many things regarding HR department [adding a new employee is only a few clicks away, and giving an end date is only a click away]. It contains many other features, like giving loans to employees, tracking their installments, making annual/ monthly reports, and so much more. It looks and feels great thanks to great structure and design, and even though it possesses a lot of features, the complexity is hidden from the end user, so it always appears easy to use, no matter what level of functionality you choose to use. It uses ReactJS on the frontend and NodeJS on the backend.

---

Among other things it uses:

• React on the fronend,
• Redux for state management,
• React Router for better navigation,
• Sails as a MVC Node framework,
• MongoDB as a local storage,
• mLab as a remote MongoDB storage,
• Bootstrap for a better responsiveness,
• jQuery & Lodash as helper libraries,
• GAS (Google Apps Scripts),
• Google OAuth2,
• Google Drive & Spreadsheets APIs
• ... and so much more ...

---

In order to use this app, you'll have to set up your own Google Sheets API, get the necessary credentials, and replace them in this project. That needs to be done in the config.js files [backend & frontend]. Also, I recommend checking out the 'Local Setup' docs which you can find in this repo to get you started. Additionally, this is a work in process, and as I go along I'll update instructions. Currently working on adding new features.

---

Instructions:

In order to run & use this app locally:

Clone the repository: git clone https://github.com/BiggaHD/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 inside of the backend (it’s 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 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 login: Login is restricted. Currently, there’s only one email with approval:

Email: bigga.test.2018@gmail.com

Password: test_1234

You can edit that list inside of 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.

Deployed version: To test it online please visit: Mars-EMS Login with the same email and password provided above, after redirect allow the app the permissions needed [ it's my mail anyways :) ], copy the code, go back, paste the code, submit and enjoy while testing it. If you want to test the app to its fullest, here are links for the 2 Google sheets used in this app:

a) Employee spreadsheet (used to manage employees, their salaries, status, bonuses, penalties, etc.).
b) Accountant spreadsheet (used to calculate salaries).