A full-stack, production-ready web application built for a pump manufacturing company to generate professional customer quotes.
The frontend is hosted via WordPress (GoDaddy cPanel), which connects to a live Flask API hosted on Heroku, backed by a secure MySQL database.

📌 This is a public showcase version of a private production repository. The original includes proprietary data and secret configs.

🟢 Live Tool: https://www.acuflow.com/auto-pump-selector/

This project is actively running in production:

• Frontend: Static HTML/JS/CSS deployed via GoDaddy’s WordPress cPanel
• Backend API: Python Flask API deployed on Heroku
• Database: Secure remote MySQL database
• Communication: JavaScript (frontend) makes real-time API calls to Heroku backend

This system is actively used to generate real customer quotes. https://www.acuflow.com/auto-pump-selector/

• 🖥️ Frontend: Responsive web form using HTML, CSS, and vanilla JavaScript
• 🔌 Backend: Python Flask API to process inputs and generate pump recommendations
• 🗄️ Database: MySQL storing pump models, specs, and pricing data
• 🧮 Advanced Logic:
  • Unit conversions (GPH ↔ LPH, PSI ↔ Bar)
  • Optional accessories with "Call for Pricing" (C/F) logic
  • Automatic model selection and final price calculation
• 📝 PDF Generation: Branded quotes with customer details and accessory breakdown
• 📧 Email Automation: Sends PDF quotes to customer emails automatically
• ⚙️ Scalable: Easily update models, pricing, and accessories as the business evolves

├── main.py                 # Flask API backend (logic, PDF, email)
├── page.html               # HTML frontend form
├── call_api.js             # JS form handling + API calls
├── custom-pump-tool.css    # CSS styling for layout
├── logo.png                # Logo used in PDF generation
├── api-proxy.php           # (Optional) Proxy for server environments
├── requirements.txt        # Python dependencies
├── setup_pump_database.sql # Sample SQL schema for demo purposes
└── README.md               # Project documentation

git clone https://github.com/Savant-sys/Acuflow-Quote-Generator.git
cd Acuflow-Quote-Generator

• Create a database named local_pump_info
• Run setup_pump_database.sql to create the database and pumps table
  (Includes a sample structure only — no sensitive data)

Update main.py with your MySQL credentials:

db_config = {
    "host": "localhost",
    "user": "root",
    "password": "YOUR_MYSQL_PASSWORD",
    "database": "local_pump_info"
}

python -m venv venv
venv\Scripts\activate      # Windows
# or
source venv/bin/activate   # macOS/Linux

pip install -r requirements.txt

Update this section in main.py if using email:

SMTP_SERVER = 'smtp.bizmail.yahoo.com'
SMTP_PORT = 465
EMAIL_ADDRESS = 'your_email@example.com'
EMAIL_PASSWORD = 'your_email_password'

⚠️ Skip this step if you only want to download the PDF locally.

py main.py

Visit: http://localhost:5000

python -m http.server 8000

Open: http://localhost:8000/page.html

1. Open the form in your browser
2. Enter customer info and pump specs
3. Click Find Pump
4. Click Get Quote PDF to download or email the quote

• CORS issues: Install flask-cors
• MySQL errors: Check your credentials and DB name
• PDF not working: Ensure reportlab is installed
• Email not sending: Double-check SMTP settings and credentials

• 📊 Admin dashboard for pump management
• 📂 Quote history tracking
• 🔐 API authentication
• 🖼️ UI design improvements
• 📁 Drag-and-drop CSV import for pump models

Michael Khuri

• 🌐 michaelkhuri.com
• 💼 LinkedIn
• 🧩 GitHub

• Created during my internship to streamline quoting workflows at AcuFlow company.
• This version excludes sensitive data and is intended for public portfolio purposes only.