Cavalry Fence Builder is a web app for fence installation companies. It allows a fence business to track projects and financial data, calculate quotes, generate material lists, and send quotes to clients and material lists to suppliers.

https://app.cavalryfence.ca/

https://youtu.be/8YIqtiUu9Xk

• Draw fence diagrams
• Generate quotes for customers (based on diagrams)
• Email quotes to customers
• Generate material lists for suppliers (based on diagrams)
• Email material lists to suppliers
• Manually edit quotes
• Calculate costs and profits (based on diagrams)
• View a list of projects and filter by status
• View and edit project information (such as diagrams, quotes, pictures, and notes)
• View and edit customer information
• View a summary of the current year's profits/losses
• Import/export tables (such as for accounting, customer information, and material lists)
• View and edit prices for fence materials
• Create individual accounts and associate them with companies
• The server uses certbot to maintain ssl certificate

https://www.python.org/downloads/

https://dev.mysql.com/downloads/mysql/

Mac OS (assuming Homebrew is installed):

xcode-select --install
brew install mysql-connector-c
pip3 install mysql-connector==2.1.4

pip3 install flask-sqlalchemy

pip3 install bcrypt

pip3 install flask-security

Mac OS (assuming Homebrew is installed):

brew install cairo pango gdk-pixbuf libffi
brew link --force libffi    # If needed
sudo chown -R `whoami`:admin /usr/local/share/man/man5
brew link fontconfig
pip3 install WeasyPrint

Other:
http://weasyprint.readthedocs.io/en/stable/install.html

pip3 install pillow

pip3 install requests

1. Start MySQL

2. In the "fencing" folder, run:

python3 app.py

1. Start MySQL

2. In the "fencing" folder, run:

python3 app.py -debug

1. Start MySQL

2. In the "fencing" folder, run:
   must be in the testBranch.

python3 testingapp.py

3. While that is running, in a new terminal tab/window in the "fencing" folder, run:

python3 -m unittest discover

The app is hosted using apache2 with the app.conf file in Documentation/Server.
The server uses mod_wsgi-express to help interact between apache2 and Flask.
The server uses certbot to generate and maintain ssl certificates.
The server files are stored at /var/www/CMPUT401-FenceFriends on the server.
The server config file is stored at /etc/apache2/sites-available

The mysql db is currently called testdata. The db must be created before the app is run but the app will create the tables.
The name can be changed in user.txt
The server required these to be installed:

sudo apt-get install apache2  
sudo mod_wsgi-express install-module  
sudo apt-get install python-certbot-apache  

Every time the server is updated,

sudo service apache2 restart

must be run.

This line:

sudo chmod -R 757 /var/www/CMPUT401-FenceFriends/fencing/static/

must also be run in order to change the permission of the static folder to allow for file uploads.

In the "fencing" folder, run:

python3 app.py --help

View tips

This repository contains a modified copy of draw.io.

https://fencythat.cavalryfence.ca/

Mac OS (assuming Homebrew is installed):

brew install ant

In the drawio/etc/build folder, run:

ant

1. In the drawio/war folder, run:

python3 -m http.server 8000

2. While that is running, access drawio with:

http://0.0.0.0:8000/index.html?offline=1&https=0

• Apache License 2.0
• https://github.com/jgraph/drawio/blob/master/LICENSE
  • Accessed December 9, 2017
• Local copy: https://github.com/gdbaker/CMPUT401-FenceFriends/blob/master/drawio/LICENSE
  • Path: drawio/LICENSE