- PostgreSQL
cp config/database.yml.example config/database.yml
bundle
bundle exec rake db:setup
Not everything is a must, please send your work back whenever you feel you've done enough.
- Add many-to-many connection between
Operation
andCategory
.
- 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. kind
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
andDD-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.