Source Code

app.py

from flask import Flask, render_template, request, redirect
import sqlite3

app = Flask(__name__)

def get_db_connection():
    conn = sqlite3.connect('database.db')
    conn.row_factory = sqlite3.Row
    return conn

def init_db():
    conn = get_db_connection()
    conn.execute('''
        CREATE TABLE IF NOT EXISTS tasks (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            title TEXT NOT NULL
        )
    ''')
    conn.commit()
    conn.close()

init_db()

@app.route("/")
def index():
    conn = get_db_connection()
    tasks = conn.execute("SELECT * FROM tasks").fetchall()
    conn.close()
    return render_template("index.html", tasks=tasks)

@app.route("/add", methods=["POST"])
def add():
    title = request.form["title"]
    conn = get_db_connection()
    conn.execute("INSERT INTO tasks (title) VALUES (?)", (title,))
    conn.commit()
    conn.close()
    return redirect("/")

@app.route("/delete/<int:id>")
def delete(id):
    conn = get_db_connection()
    conn.execute("DELETE FROM tasks WHERE id = ?", (id,))
    conn.commit()
    conn.close()
    return redirect("/")

index.html

<!DOCTYPE html>
<html>
<head>
    <title>To-Do List</title>
</head>
<body>
    <h1>To-Do List</h1>
    <form action="/add" method="post">
        <input name="title" placeholder="Enter task" required>
        <button type="submit">Add</button>
    </form>

    <ul>
        {% for task in tasks %}
            <li>
                {{ task['title'] }}
                <a href="/delete/{{ task['id'] }}">[Delete]</a>
            </li>
        {% endfor %}
    </ul>
</body>
</html>

Project 4 Starter Code

init_db.py

import sqlite3
from datetime import datetime

# Define SQL schema
schema = """

CREATE TABLE menu (
    menu_id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    category TEXT NOT NULL,
    price REAL NOT NULL,
    description TEXT
);

CREATE TABLE customers (
    customer_id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    street_address TEXT,
    city TEXT,
    state TEXT,
    zip_code TEXT,
    phone_number TEXT
);

CREATE TABLE orders (
    order_id INTEGER PRIMARY KEY AUTOINCREMENT,
    customer_id INTEGER NOT NULL,
    order_number TEXT UNIQUE NOT NULL,
    date_time TEXT NOT NULL,
    FOREIGN KEY (customer_id) REFERENCES customers(customer_id)
);

CREATE TABLE order_items (
    order_item_id INTEGER PRIMARY KEY AUTOINCREMENT,
    order_number TEXT NOT NULL,
    menu_id INTEGER NOT NULL,
    quantity INTEGER NOT NULL,
    FOREIGN KEY (order_number) REFERENCES orders(order_number),
    FOREIGN KEY (menu_id) REFERENCES menu(menu_id)
);
"""

# Test data
test_menu = [
    "Calamari", "appetizers", 19.99, "Crispy squid served with marinara sauce"
]

test_customer = (
    "Alex", "1000 Morris Avenue", "Union", "NJ", "07083", "908-737-5326"
)

# Connect and execute
conn = sqlite3.connect("project4.db")
cursor = conn.cursor()

# Run schema
cursor.executescript(schema)
print("Database schema created.")

# Insert one menu item
cursor.execute(
    """INSERT INTO menu (name, category, price, description)
    VALUES (?, ?, ?, ?)""", test_menu
)

# Insert one test customer
cursor.execute(
    """INSERT INTO customers (name, street_address, city, state, zip_code, phone_number)
       VALUES (?, ?, ?, ?, ?, ?)""", test_customer
)

conn.commit()
conn.close()
print("Inserted sample menu and one test customer into project6.db.")

app.py

from flask import Flask, render_template, request, redirect, session
import sqlite3
from datetime import datetime

app = Flask(__name__)
app.secret_key = "mysecretkey"  # Needed for session handling

def get_db():
    conn = sqlite3.connect("project6.db")
    conn.row_factory = sqlite3.Row
    return conn

@app.route("/")
def index():
    return render_template("index.html")

@app.route("/admin", methods=["GET", "POST"])
def admin():
    conn = get_db()
    cur = conn.cursor()
    if request.method == "POST":
        cur.execute("INSERT INTO menu (name, category, price, description) VALUES (?, ?, ?, ?)",
                    (request.form["name"], request.form["category"], float(request.form["price"]), request.form["description"]))
        conn.commit()
    cur.execute("SELECT * FROM menu")
    menu = cur.fetchall()
    return render_template("admin.html", menu=menu)

@app.route("/start_order", methods=["GET", "POST"])
def start_order():
    if request.method == "POST":
        conn = get_db()
        cur = conn.cursor()
        if request.form["type"] == "new":
            cur.execute("INSERT INTO customers (name, street_address, city, state, zip_code, phone_number) VALUES (?, ?, ?, ?, ?, ?)",
                        (request.form["name"], request.form["street_address"], request.form["city"], request.form["state"], request.form["zip_code"], request.form["phone_number"]))
            customer_id = cur.lastrowid
        else:
            cur.execute("SELECT customer_id FROM customers WHERE name = ?", (request.form["name"],))
            row = cur.fetchone()
            if row:
                customer_id = row["customer_id"]
            else:
                return "Customer not found"
        order_number = "ABC" + datetime.now().strftime('%Y%m%d%H%M%S')
        date_time = datetime.now().strftime('%Y-%m-%d %H:%M:%S')
        cur.execute("INSERT INTO orders (customer_id, order_number, date_time) VALUES (?, ?, ?)",
                    (customer_id, order_number, date_time))
        conn.commit()
        session["order_number"] = order_number
        return redirect("/order")
    return render_template("start_order.html")

@app.route("/order", methods=["GET", "POST"])
def order():
    conn = get_db()
    cur = conn.cursor()
    if request.method == "POST":
        order_number = session.get("order_number")
        for key, value in request.form.items():
            if key.startswith("quantity_"):
                menu_id = int(key.split("_")[1])
                quantity = int(value)
                if quantity > 0:
                    cur.execute("INSERT INTO order_items (order_number, menu_id, quantity) VALUES (?, ?, ?)",
                                (order_number, menu_id, quantity))
        conn.commit()
        return redirect("/order_summary")
    cur.execute("SELECT * FROM menu")
    menu = cur.fetchall()
    return render_template("order.html", menu=menu)

@app.route("/order_summary")
def order_summary():
    conn = get_db()
    cur = conn.cursor()
    order_number = session.get("order_number")
    cur.execute("""
        SELECT m.name, m.price, oi.quantity, (m.price * oi.quantity) AS total_price
        FROM order_items oi
        JOIN menu m ON m.menu_id = oi.menu_id
        WHERE oi.order_number = ?
    """, (order_number,))
    items = cur.fetchall()
    subtotal = sum(item["total_price"] for item in items)
    tax = subtotal * 0.06625
    tip = subtotal * 0.15
    delivery_fee = 5
    total = subtotal + tax + tip + delivery_fee
    return render_template("order_summary.html", summary=items, subtotal=subtotal, tax=tax, tip=tip, delivery_fee=delivery_fee, total=total)

if __name__ == "__main__":
    app.run(debug=True)

index.html

<!DOCTYPE html>
<html>
<head><title>Welcome to Flask Restaurant</title></head>
<body>
  <h1>Welcome to Flask Restaurant!</h1>
  <nav>
    <a href="/admin">Admin Panel</a> |
    <a href="/start_order">Start New Order</a>
  </nav>
</body>
</html>

admin.html

<!DOCTYPE html>
<html>
<head><title>Admin Panel</title></head>
<body>
  <h1>Admin Panel</h1>
  
  <h2>Insert New Menu Item</h2>
  <form method="post" action="/admin/add_item">
    Name: <input type="text" name="name"><br>
    Category: <input type="text" name="category"><br>
    Price: <input type="number" step="0.01" name="price"><br>
    Description: <input type="text" name="description"><br>
    <input type="submit" value="Add Item">
  </form>

  <h2>Current Menu</h2>
  <ul>
    {% for item in menu %}
      <li>{{ item['name'] }} - ${{ item['price'] }} ({{ item['category'] }})</li>
    {% endfor %}
  </ul>

  <a href="/">Back to Home</a>
</body>
</html>

start_order.html

<!DOCTYPE html>
<html>
<head><title>Start Order</title></head>
<body>
  <h1>Start Your Order</h1>
  
  <h2>New Customer</h2>
  <form method="post" action="/start_order">
    <input type="hidden" name="type" value="new">
    Name: <input type="text" name="name"><br>
    Address: <input type="text" name="street_address"><br>
    City: <input type="text" name="city"><br>
    State: <input type="text" name="state"><br>
    Zip Code: <input type="text" name="zip_code"><br>
    Phone Number: <input type="text" name="phone_number"><br>
    <input type="submit" value="Continue">
  </form>

  <h2>Returning Customer</h2>
  <form method="post" action="/start_order">
    <input type="hidden" name="type" value="existing">
    Enter Name: <input type="text" name="name"><br>
    <input type="submit" value="Continue">
  </form>
</body>
</html>

order.html

<!DOCTYPE html>
<html>
<head><title>Order Menu</title></head>
<body>
  <h1>Order Menu</h1>
  <form method="post" action="/order">
    {% for item in menu %}
      <p>
        <strong>{{ item['name'] }}</strong> (${{ item['price'] }})<br>
        {{ item['description'] }}<br>
        Quantity: <input type="number" name="quantity_{{ item['menu_id'] }}" value="0" min="0"><br>
      </p>
    {% endfor %}
    <input type="submit" value="Submit Order">
  </form>
</body>
</html>

order_summary.html

<!DOCTYPE html>
<html>
<head><title>Order Summary</title></head>
<body>
  <h1>Order Summary</h1>
  <ul>
    {% for item in summary %}
      <li>{{ item['name'] }} (x{{ item['quantity'] }}) - ${{ "%.2f"|format(item['total_price']) }}</li>
    {% endfor %}
  </ul>

  <p>Subtotal: ${{ "%.2f"|format(subtotal) }}</p>
  <p>Tax (6.625%): ${{ "%.2f"|format(tax) }}</p>
  <p>Tip: ${{ "%.2f"|format(tip) }}</p>
  <p>Delivery Fee: ${{ "%.2f"|format(delivery_fee) }}</p>
  <h2>Total: ${{ "%.2f"|format(total) }}</h2>

  <a href="/">Return to Home</a>
</body>
</html>

PreviousSource Code

Last updated 1 month ago