Requirements

• PostgreSQL

Setup

1. cp config/database.yml.example config/database.yml

• bundle
• bundle exec rake db:setup

Assignments

Not everything is a must, please send your work back whenever you feel you've done enough.

1. Add many-to-many connection between Operation and Category.

• Add functionality to import operations from CSV file.
  • List of available companies are already in the database.
  • company column contains name of the company, that operations should be assigned to.
  • There should be no changes to companies table.
  • categories column contains list of categories separated by ;.
  • Import should create missing categories on the fly.
  • Possible date formats are MM/DD/YYYY, YYYY-MM-DD and DD-MM-YYYY.
  • Example file can be downloaded here.
• Add view that will display all the data about operations in the context of the company.
  • It should be one view that display list of all the operations in the database visually grouped by company.

  Company A       |   [Company A stats]
  - Operation #1
  - Operation #2
  - Operation #3
  - Operation #4
  
  Company B       |   [Company B stats]
  - Operation #5
  - Operation #6
  - Operation #7
  - Operation #8
  

  • Information about company should include: number of the operations, average amount of operations, highest operation from the current month, number of operations with status accepted.
  • All the data have to be loaded asynchronously and rendered using javascript.
• Add file processing user feedback.
  • After uploading a file, user have to see the progress of parsing it.
  • Information for user should include: number of processed rows, number of successfuly imported rows, number of rows that failed import.
• Add possibility to filter displayed operations.
  • There should be single text input, that filter rows in all companies by status, kind, invoice_num and reporter.
• Add possibility to export operations from single company.
  • There should be button beside data about company that will let user download CSV file.
  • Rows in the file should contain the same data they had in the import file.
  • Operations in the file should be only the filtered ones.

Extra instructions

• In addition to the setup mentioned before it will be necessary to run along with the server a worker with

rake jobs:work

so that the import csv functionality will work.

• The app is set to run with ruby 2.2.2

Usability information

• When loaded the application there will be a home view with a message on it and 3 tabs(Home, Companies and Import Operations ) on the navigation bar beign this view Home.
• When clicking on Companies a list of the companies will appear with their respective stats an when clicking in the name of the company this collapsable (http://getbootstrap.com/javascript/#collapse) will open and show all the operations (in a table with all the operations information) if there is any operation for that company yet.
• When clicking in Import Operations this will take to a view when You can upload a csv file with an specific format otherwise it will say the format of the csv is not valid. If valid it will show a progress bar with an explicative text of processed , failed and success imported operations