/technical_test

Primary LanguageTSQL

Technical Test

Tasks

  1. Create an Application that connects to MySQL
  2. Create a routine that receive: Range Date, Status and Location (The fields must be optional to the final user) and return the list of invoices with the following information: Location name, date, status and total invoice value.
  3. Create a routine that receive the location id and return the sum of invoice values grouped by status.
  4. Create a simple list page to show the result

Info

  • The structure or the DB with some examples can be find on /dump
  • Use the framework of your preference
  • Submit your code via pull request
  • List on README.md all files with your own code

Good luck :)