Skip to content

Latest commit

 

History

History
executable file
·
74 lines (67 loc) · 2.99 KB

README.md

File metadata and controls

executable file
·
74 lines (67 loc) · 2.99 KB
Raw

Build Status 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