This pull request is for adding thousand separator on salaries like mentioned in issue #107

Why ? To make salaries more readable.

How ? Just by separating thousands by a comma.

Steps to verify: Just by checking the screenshots below :

...But here is what you need to know:

• The company name is only displayed if at least 3 people in the same company with the same job title contribute. Until then, a generic description like "A local company" will be displayed.
• The comment is only displayed if at least 3 people in the same company with the same job title contribute.
• The rating is only displayed if at least 3 people in the same company with the same job title contribute.

We hide companies and jobtitles for ratings that had less than 5 entries on #189 . But it seems that we still return hidden ratings when doing request with filters.

curl -X GET https://api.jobsika.stage.osscameroon.com/ratings?page=1&limit=10&company=something&jobtitle=something

Will return a list a ratings corresponding to the hidden filters

This pull request set Jobtitles and City as Mandatory fields for the rating POST request. Related to #202

Steps to verify:

• move to the backend folder with cd ./backend
• run make start-postgres to run an initialized database
• run make run to launch the api
• then run the following commands

1️⃣ Check JobTitle

curl -s -X POST 'http://localhost:7000/ratings' -H 'Content-Type: application/json' -d '{"city": "Douala","comment": "my comment","company_name": "OssCameroun","job_title": "","rating": 2,"salary": 1200,"seniority": "CV"}'

you should see something like this 👇

{"error":"job title is mandatory"}

2️⃣ Check City

curl -s -X POST 'http://localhost:7000/ratings' -H 'Content-Type: application/json' -d '{"city": "","comment": "my comment","company_name": "OssCameroun","job_title": "Maintainer","rating": 2,"salary": 1200,"seniority": "CV"}'

you should see something like this 👇

{"error":"city is mandatory"}

This pull request set default values for the GET /companies endpoint

Steps to verify:

• move to the backend folder with cd ./backend
• run make start-api to start the api
• then run the command curl -X GET localhost:7000/companies | jq you should see something like this

{
  "hits": [{
    "id": 102,
    "name": "ADC",
    "rating": 0,
    "createdat": "2022-04-06T00:00:00Z",
    "updatedat": "2022-04-06T00:00:00Z"
  },
  {
    "id": 103,
    "name": "ADER",
    "rating": 0,
    "createdat": "2022-04-06T00:00:00Z",
    "updatedat": "2022-04-06T00:00:00Z"
  },
  ...
  ],
  "limit": 20,
  "nbHits": 1000,
  "offset": 40
}

This pull request does...

Why ? it manage the auto completion to help user when adding news ratings

How ? while user type value he becomes suggestion on Company names, cities and job title

** Screenshots (optional)

https://user-images.githubusercontent.com/49993443/156038971-68d1ea0e-cce7-44c3-ac51-c9642552ab83.mp4

This pull request implement the POST ratings endpoint, that creates a new rating entry

Steps to verify:

• move to the backend folder with cd ./backend
• run make start-postrges to run an initialized database
• run make run to launch the api
• then run the command

curl -s -X POST "http://localhost:7000/ratings" -d'{"company_name":"La Mater", "salary": 150000, "city": "Maroua", "seniority": "Seniority", "rating": 4, "comment": "mon commentaire", "job_title": "my job title"}' -H 'Content-Type: application/json'

you should see something like this 👇

{"message":"created"}

You can see that last element with curl -s -X GET "http://localhost:7000/ratings?page=1&limit=200" | jq | tail -n 19

The output should be close to this 👇

 {
      "salary_id": 105,
      "company_id": 102,
      "company_rating_id": 35,
      "rating": 4,
      "salary": 150000,
      "company_name": "La Mater",
      "seniority": "Seniority",
      "comment": "mon commentaire",
      "job_title": "my job title",
      "country": "Cameroon",
      "city": "Maroua",
      "createdat": "2022-02-13T00:00:00Z"
    }
  ],
  "limit": 200,
  "nbHits": 105,
  "offset": 0
}

This pull request add the GET average-salary endpoint

Steps to verify:

• move to the backend folder with cd ./backend
• run make start-postrges to run an initialized database
• run make run to launch the api
• then run the command curl -X GET localhost:7000/average-rating you should see something like this

{"rating":3,"salary":2543437}

This pull request add the GET jobtitles endpoint

Steps to verify:

• move to the backend folder with cd ./backend
• run make start-postrges to run an initialized database
• run make run to launch the api
• then run the command curl -X GET localhost:7000/jobtitles you should see something like this

["Account Coordinator","Account Executive","Account Representative I","Account Representative II","Account Representative III","Account Representative IV","Accountant I","Accountant II","Accountant III","Accountant IV"
...
]

This pull request do not consider ratings equal to 0 when calculating the average rating

Step to verify

• move to the backend folder with cd ./backend
• run make start-postrges to run an initialized database
• run make run to launch the api

1️⃣then run the command to create a ratings

curl -s -X POST 'http://localhost:7000/ratings' -H 'Content-Type: application/json' -d '{"city": "Douala","comment": "my comment","company_name": "Oss","job_title": "Dev","rating": 2,"salary": 1200,"seniority": "CV"}'

2️⃣run the following command to get the average rating

curl -s -X GET "http://localhost:7000/average-rating?company=Oss"

you should see something like this 👇

{
    "rating": 2,
    "salary": 1200
}

3️⃣ now run this command x times to create company rating with rating == 0

curl -s -X POST 'http://localhost:7000/ratings' -H 'Content-Type: application/json' -d '{"city": "Douala","comment": "my comment","company_name": "Oss","job_title": "Dev","rating": 0,"salary": 0,"seniority": "CV"}'

4️⃣ run the steps 2 the rating field in the output should be the same

You are required to enter the name of the company. We understand you might not want to share the name of the company despite the field being anonymized- please enter a description of the company (e.g. "local startup", "well-known bank" or legacy company, etc)

This pull request ask for users confirmation when a salary amount less than 10000 is entered

Why ? This is to prevent mistake inputs by users when they sometimes input amounts such as 250 or 1. This is to solve #343 How ? Let us know how it does what it does

When adding salary, Even when 1 is entered it still gets submitted. I think a prompt can be added for the user to confirm before submitting so that in case the amount entered is an error, it can be corrected

WHY

To protect the system on random input requests

HOW

• When navigating on the website form, to add a new salary
• We should get from the backend a unique code that should be posted with the actual form session
• if there is no code is provided we are sure it's not a request comming from someone, i the code is present, we should check that it's valid then we save the new entry !

MORE

a little related to : https://github.com/osscameroon/jobsika/issues/305

The elements in the last row of the table showing the averages are not aligned(See screenshot below). This can cause confusion if not taken care of.

I suggest the elements in the table be aligned as in the image below.

As we can see on the App we have many unreal salaies such as 1 FCFA or 0 FCFA or even 190 FCFA i suggest that we force the user to enter a salarie at least begger than 1000 FCFA, otherwise the form will not be validated.