Breadcrumb Component

SELECT 'breadcrumb' AS component;
SELECT 'Home' AS title, '/' AS link;
SELECT 'Products' AS title, '/products.sql' AS link;
SELECT 'Laptop' AS title, true AS active;

SELECT 'breadcrumb' AS component;
SELECT 'Home' AS title, '/' AS link;
SELECT 'Documentation' AS title, true AS active;

SELECT 'breadcrumb' AS component;

SELECT 'Home' AS title, '/' AS link;
SELECT 'Categories' AS title, '/categories.sql' AS link;
SELECT 'Electronics' AS title, '/categories.sql?id=1' AS link;
SELECT 'Laptops' AS title, '/products.sql?category=laptops' AS link;
SELECT 'MacBook Pro' AS title, true AS active;

SELECT 'breadcrumb' AS component;

SELECT 'Home' AS title,
       '/' AS link,
       'Go to homepage' AS description;

SELECT 'Settings' AS title,
       '/settings.sql' AS link,
       'Application settings' AS description;

SELECT 'Account' AS title,
       true AS active,
       'Your account settings' AS description;

SELECT 'breadcrumb' AS component;

SELECT 'Home' AS title, '/' AS link;

SELECT category_name AS title,
       '/products.sql?category=' || category_id AS link
FROM categories
WHERE category_id = $category;

SELECT product_name AS title,
       true AS active
FROM products
WHERE product_id = $product;

SELECT 'breadcrumb' AS component;

SELECT 'Home' AS title, '/' AS link;

-- Build breadcrumb trail from hierarchical data
WITH RECURSIVE path AS (
    SELECT id, name, parent_id, 0 as level
    FROM categories
    WHERE id = $current_category
    
    UNION ALL
    
    SELECT c.id, c.name, c.parent_id, p.level + 1
    FROM categories c
    INNER JOIN path p ON c.id = p.parent_id
)
SELECT name AS title,
       '/category.sql?id=' || id AS link,
       level = 0 AS active
FROM path
ORDER BY level DESC;

SELECT 'breadcrumb' AS component;

SELECT 'Dashboard' AS title, '/dashboard.sql' AS link;
SELECT 'Reports' AS title, true AS active;

SELECT 'breadcrumb' AS component;

SELECT 'Shop' AS title, '/shop.sql' AS link;
SELECT 'Men' AS title, '/shop.sql?gender=men' AS link;
SELECT 'Clothing' AS title, '/shop.sql?gender=men&type=clothing' AS link;
SELECT 'T-Shirts' AS title, '/products.sql?category=tshirts' AS link;
SELECT 'Blue Cotton T-Shirt' AS title, true AS active;

SELECT 'breadcrumb' AS component;

SELECT 'Docs' AS title, '/docs/' AS link;
SELECT 'Components' AS title, '/docs/components/' AS link;
SELECT 'Form' AS title, true AS active;

SELECT 'breadcrumb' AS component;

SELECT 'Admin' AS title, '/admin/' AS link;
SELECT 'Users' AS title, '/admin/users.sql' AS link;
SELECT 'Edit User' AS title, true AS active;

SELECT 'breadcrumb' AS component;

SELECT 'Blog' AS title, '/blog.sql' AS link;

SELECT category AS title,
       '/blog.sql?category=' || category AS link
FROM articles
WHERE id = $article_id;

SELECT title AS title,
       true AS active
FROM articles
WHERE id = $article_id;

SELECT 'breadcrumb' AS component;
SELECT 'Home' AS title, '/' AS link;
SELECT 'About' AS title, '/about.sql' AS link;
SELECT 'Team' AS title, true AS active;

SELECT 'breadcrumb' AS component;
SELECT 'Files' AS title, '/files.sql' AS link;
SELECT 'Documents' AS title, '/files.sql?path=/documents' AS link;
SELECT 'Projects' AS title, '/files.sql?path=/documents/projects' AS link;
SELECT '2024' AS title, true AS active;

SELECT 'breadcrumb' AS component;
SELECT 'Cart' AS title, '/cart.sql' AS link;
SELECT 'Shipping' AS title, '/checkout.sql?step=shipping' AS link;
SELECT 'Payment' AS title, true AS active;