Filter options for district and sector.

• several parameters are to be searched with Or operation

Example:
GET /companies?name=GmbH&sectors=it-beratung,edv&districts=zentrum,suedvorstadt

Entries with it-beratung OR EDV..

folgende Namenänderung wären cool (müsste nach CodeStandard für Kotlin/Java/Spring auch gültig sein):
RestController -> CompanyController
CompaniesService -> CompanyService
Companies_Repository -> CompanyRepository
Companies -> Company

Case sensitive search doesn't work
I'm facing issues with the GET /companies endpoint. When I try to execute the request GET /companies?name=gmbh, I get an empty response. On the other hand, GET /companies?name=GmbH works as it should.

Search for sectors and districts doesn't work
Same goes for the options to filter for sections and districts. I get an empty response when searching for any sectors and districts.

/companies?sector=edv => []
/companies?district=zentrum => []

Script for the manual integration of data from csv-Files(only for dev)

• csv-file seperator (;)
• works only with data_sample.csv

data_import.zip

Hosting-Lösung suchen/Pipeline aufsetzen

Welche Daten wollen wir zusätzlich beziehen?
Woher sollen die Daten angereichert werden?

Akzeptanzkriterium:

• Erstellen eines Konzeptes zum anreichern der Daten

As a user I want to be able to register via E-Mail.

Would include setting up mailserver and mx rr if mails should be send from @leipzigtech.de.
Or maybe use smtp server from google and another address to send from.

• Frontend Team kennt alle Schnittstellen.

As a Frontend Developer, I want to get access to the companies resource via a REST API so that I can use the resources and process them in the frontend.

Acceptance Criteria

• GET /companies -> Returns all companies
• GET /companies/:id -> Returns a specific company with a given id

The following query parameter should be supported by the upper endpoints:

• name -> Name of the company / String
• fuzzy -> Enable fuzzy search / Boolean (default: true)
• orderBy -> Order of results / Enum with Values ASC (ascending) and DESC (descending) (default: ASC)

Example Request

GET /companies?name=micro&orderBy=DESC would search for all companies in the database that match the term micro since fuzzy search is enabled on default, then it would return all retrieved companies in descending order.

• POST /companies -> Creates a new company based on a given JSON payload

{
  "name": "Microsoft",
  "address": "One Microsoft Way",
  "sector": "Information Technology"
}

When I try to submit a request from the client to GET "/companies" with the new filtering feature I receive the error which is displayed in the attached screenshot.

To resolve this issue it's probably necessary to set the Access-Control-Allow-Origin header to '*'. More about that here: https://developer.mozilla.org/en-US/docs/Web/HTTP/CORS/Errors/CORSMissingAllowOrigin

Implement as CRON-Job

Data Cleaning

• Removal of industries such as "alarm systems" or "lawyers" from the database

Data Aggregation

• Aggregation of the different industries/sector
  Bsp. IT-Beratung / IT-Consulting / Unternehmensberatung --> IT-Consulting

Augenoptik -> Medicine
Bildungseinrichtungen -> Education
Bürobedarf -> Services
Coaching -> Education
Computer -> Services
Computer-Dienstleitungen -> Services
Computerreparaturen -> Services
Detekteien (lol?) -> Legal
EDV -> Software Engineering
EDV-Beratungen -> Consulting
EDV-Dienstleistungen -> Software Engineering
Geografische Informationssysteme -> Environment
IT-Beratung -> Consulting
IT-Dienstleistungen -> Software Engineering
Ingenieurbüros -> Engineering
Internetservice -> Softwareentwicklung
Nachrichtenagenturen -> News
Netzwerke -> (Computer) Networking
Notare (lol?) -> Legal
Personalberatung -> Human Resources
Personaldienstleistungen -> Human Resources
Rechtsanwälte -> Legal
Software -> Software Engineering
Steuerberatung -> Accounting
Unternehmensberatung -> Consulting
Versicherungen -> Insurance
Webdesign -> Design
Werbefotografie -> Advertising

Computer -> Services
Computer-Dienstleitungen -> Services
Computerreparaturen -> Services
EDV -> Software Engineering
EDV-Dienstleistungen -> Software Engineering
IT-Dienstleistungen -> Software Engineering
Internetservice -> Softwareentwicklung
Netzwerke -> (Computer) Networking

new interface for statistics needed

GET /companies/stats
The response should be a JSON with the following content:

• The number of all companies in our database
• Companies broken down by industry
• Companies broken down by city district
• Number of companies that have entered the last 7 days
• Number of companies that have entered the last 30 days

Example:

{number: 100, numberBySector: {'IT': 5, 'Hardware': 5, ...}, numberByDistrict: {'Zentrum': 41, 'Suedvorstadt': 23, ...}}

  number: int,
  numberBySector: int,
  numberByDistrict: int,
  joinedSince7: int,
  joinedSince30: int
}