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
Copy secrets.yml.example and database.yml.example to config/secrets.yml and config/database.yml
docker build -t alchemy-internal-docker .
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"
username: [email protected] password: password
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":"[email protected]","password":"password"}}' http://localhost:3000/api/products
curl -H 'Content-Type: application/json' -H 'Accept: application/json' -X GET -d '{"user":{"email":"[email protected]","password":"password"}}' http://localhost:3000/api/customer_users
curl -H 'Content-Type: application/json' -H 'Accept: application/json' -X GET -d '{"user":{"email":"[email protected]","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":"[email protected]","password":"password"}, "password": "new_password"}' http://localhost:3000/api/customer_users/2
# Get COA document
curl -H 'Content-Type: application/json' -H 'Accept: application/json' -X GET -d '{"user":{"email":"[email protected]","password":"password"},"cod_id":"123456"}' http://localhost:3000/api/certificate_of_approval > 123456.pdf
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent