Alchemy Internal Website

This project integrates with Alchemy's Microsoft Dynamics NAV database providing useful features to the Alchemy staff.

• Secure login service allowing only Alchemy employees to access
• Tools:
  • Tools for branding special PDF documents such as Safety Data Sheets for Product Data Sheets
  • Tool for translating CRM reports into vendor specific requirements
• Products:
  • Sales, Cost, Margin and Volume chart for the last 5 years
  • Summerised view of individual products
  • Allows uploading and downloading of documents associated with product
• Customers:
  • Sales, Cost, Margin and Volume chart for the last 5 years
  • Summerised view of customers
  • Includes customer credit information
  • Lists product sell prices per customer
  • Compares YTD to PY for each product the volume, sales and marign
• Vendors:
  • Sales, Cost, Margin and Volume chart for the last 5 years
  • Able to show Vendor group stats, whereby all metrics are combined for a particular vendor group
  • List of products associate with vendor
• Sales:
  • Overall company sales over the years chart
  • Comparison of individual sales people charts

Development environment

Initial setup

Copy secrets.yml.example and database.yml.example to config/secrets.yml and config/database.yml

Build

docker build -t alchemy-internal-docker .

Run

First time only:

docker run -v $(pwd):/var/alchemy -i -t alchemy-internal-docker /var/alchemy/initialise-database-dev.sh

To start web app:

docker run --name alchemy-internal --rm -p 3000:3000 -v $(pwd):/var/alchemy -i -t alchemy-internal-docker /var/alchemy/start.sh

To get into the console:

docker exec -i -t alchemy-internal /bin/bash -c "source /usr/local/rvm/scripts/rvm; cd /var/alchemy; bundle exec rails c development"

Login

username: admin@example.com password: password

API endpoints

Here are some examples of using the endpoints with curl. You need to have a user in the database that has the api_user field set to true

# Get list of products, customer users or vendors:
curl -H 'Content-Type: application/json' -H 'Accept: application/json' -X GET -d '{"user":{"email":"api@user.com","password":"password"}}' http://localhost:3000/api/products
curl -H 'Content-Type: application/json' -H 'Accept: application/json' -X GET -d '{"user":{"email":"api@user.com","password":"password"}}' http://localhost:3000/api/customer_users
curl -H 'Content-Type: application/json' -H 'Accept: application/json' -X GET -d '{"user":{"email":"api@user.com","password":"password"}}' http://localhost:3000/api/vendors

# Change customer user password:
curl -H 'Content-Type: application/json' -H 'Accept: application/json' -X PUT -d '{"user":{"email":"api@user.com","password":"password"}, "password": "new_password"}' http://localhost:3000/api/customer_users/2