Compare commits
20 Commits
feature/is
...
12c5304638
| Author | SHA1 | Date | |
|---|---|---|---|
| 12c5304638 | |||
|
|
080d2424c8 | ||
|
|
6b1c34ceff | ||
| 231f594004 | |||
|
|
7d35a3e7b3 | ||
| 670b2f9200 | |||
|
|
521e3f552f | ||
| 627e970986 | |||
|
|
50a0bd9417 | ||
| 097f0f9cee | |||
|
|
b1ef7e43be | ||
|
|
12bda4c08f | ||
|
|
5eb0d04377 | ||
| 5805be698b | |||
|
|
1f21032194 | ||
| f4b870f59c | |||
|
|
4834286005 | ||
| be2af1675a | |||
|
|
b93f4677fc | ||
| 4eec4923af |
64
.env.example
64
.env.example
@@ -1,54 +1,20 @@
|
||||
# Pantry - Environment Variables Template
|
||||
# Copy to .env.development for local development
|
||||
# Copy to .env.production for production deployment
|
||||
# Supabase Local Development Environment
|
||||
# Copy this file to .env and adjust as needed
|
||||
|
||||
# ==============================================
|
||||
# Supabase Configuration
|
||||
# ==============================================
|
||||
# PostgreSQL
|
||||
POSTGRES_PASSWORD=postgres
|
||||
|
||||
# Supabase API URL (from Coolify service)
|
||||
SUPABASE_URL=https://your-supabase-instance.example.com
|
||||
# JWT Secret (generate with: openssl rand -base64 32)
|
||||
# Default is fine for local dev, change for production
|
||||
JWT_SECRET=super-secret-jwt-token-with-at-least-32-characters-long
|
||||
|
||||
# Supabase Anon Key (public, safe to expose to frontend)
|
||||
SUPABASE_ANON_KEY=your-anon-key-here
|
||||
# API Keys
|
||||
# These are Supabase's default demo keys - OK for local development
|
||||
# For production, generate new keys: https://supabase.com/docs/guides/self-hosting#api-keys
|
||||
ANON_KEY=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZS1kZW1vIiwicm9sZSI6ImFub24iLCJleHAiOjE5ODM4MTI5OTZ9.CRXP1A7WOeoJeXxjNni43kdQwgnWNReilDMblYTn_I0
|
||||
|
||||
# Supabase Service Role Key (SECRET - server-side only, never expose to frontend)
|
||||
SUPABASE_SERVICE_ROLE_KEY=your-service-role-key-here
|
||||
SERVICE_ROLE_KEY=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZS1kZW1vIiwicm9sZSI6InNlcnZpY2Vfcm9sZSIsImV4cCI6MTk4MzgxMjk5Nn0.EGIM96RAZx35lJzdJsyH-qQwv8Hdp7fsn3W0YpN81IU
|
||||
|
||||
# JWT Secret (for Supabase Auth)
|
||||
SUPABASE_JWT_SECRET=your-jwt-secret-here
|
||||
|
||||
# Database Password (for direct PostgreSQL access if needed)
|
||||
POSTGRES_PASSWORD=your-postgres-password-here
|
||||
|
||||
# ==============================================
|
||||
# Application Configuration
|
||||
# ==============================================
|
||||
|
||||
# Public app URL (where the Nuxt app is hosted)
|
||||
PUBLIC_APP_URL=http://localhost:3000
|
||||
|
||||
# Node environment
|
||||
NODE_ENV=development
|
||||
|
||||
# ==============================================
|
||||
# External APIs
|
||||
# ==============================================
|
||||
|
||||
# Open Food Facts API (no auth required)
|
||||
OPENFOODFACTS_API_URL=https://world.openfoodfacts.org
|
||||
|
||||
# ==============================================
|
||||
# Optional: Auth Providers (OIDC)
|
||||
# ==============================================
|
||||
|
||||
# Google OAuth (optional - configure in Supabase if needed)
|
||||
AUTH_GOOGLE_ENABLED=false
|
||||
AUTH_GOOGLE_CLIENT_ID=
|
||||
AUTH_GOOGLE_SECRET=
|
||||
|
||||
# Authentik (optional)
|
||||
AUTH_AUTHENTIK_ENABLED=false
|
||||
AUTH_AUTHENTIK_URL=
|
||||
AUTH_AUTHENTIK_CLIENT_ID=
|
||||
AUTH_AUTHENTIK_SECRET=
|
||||
# Nuxt App Configuration (also copy to app/.env)
|
||||
NUXT_PUBLIC_SUPABASE_URL=http://localhost:54321
|
||||
NUXT_PUBLIC_SUPABASE_ANON_KEY=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZS1kZW1vIiwicm9sZSI6ImFub24iLCJleHAiOjE5ODM4MTI5OTZ9.CRXP1A7WOeoJeXxjNni43kdQwgnWNReilDMblYTn_I0
|
||||
|
||||
54
.env.example.bak
Normal file
54
.env.example.bak
Normal file
@@ -0,0 +1,54 @@
|
||||
# Pantry - Environment Variables Template
|
||||
# Copy to .env.development for local development
|
||||
# Copy to .env.production for production deployment
|
||||
|
||||
# ==============================================
|
||||
# Supabase Configuration
|
||||
# ==============================================
|
||||
|
||||
# Supabase API URL (from Coolify service)
|
||||
SUPABASE_URL=https://your-supabase-instance.example.com
|
||||
|
||||
# Supabase Anon Key (public, safe to expose to frontend)
|
||||
SUPABASE_ANON_KEY=your-anon-key-here
|
||||
|
||||
# Supabase Service Role Key (SECRET - server-side only, never expose to frontend)
|
||||
SUPABASE_SERVICE_ROLE_KEY=your-service-role-key-here
|
||||
|
||||
# JWT Secret (for Supabase Auth)
|
||||
SUPABASE_JWT_SECRET=your-jwt-secret-here
|
||||
|
||||
# Database Password (for direct PostgreSQL access if needed)
|
||||
POSTGRES_PASSWORD=your-postgres-password-here
|
||||
|
||||
# ==============================================
|
||||
# Application Configuration
|
||||
# ==============================================
|
||||
|
||||
# Public app URL (where the Nuxt app is hosted)
|
||||
PUBLIC_APP_URL=http://localhost:3000
|
||||
|
||||
# Node environment
|
||||
NODE_ENV=development
|
||||
|
||||
# ==============================================
|
||||
# External APIs
|
||||
# ==============================================
|
||||
|
||||
# Open Food Facts API (no auth required)
|
||||
OPENFOODFACTS_API_URL=https://world.openfoodfacts.org
|
||||
|
||||
# ==============================================
|
||||
# Optional: Auth Providers (OIDC)
|
||||
# ==============================================
|
||||
|
||||
# Google OAuth (optional - configure in Supabase if needed)
|
||||
AUTH_GOOGLE_ENABLED=false
|
||||
AUTH_GOOGLE_CLIENT_ID=
|
||||
AUTH_GOOGLE_SECRET=
|
||||
|
||||
# Authentik (optional)
|
||||
AUTH_AUTHENTIK_ENABLED=false
|
||||
AUTH_AUTHENTIK_URL=
|
||||
AUTH_AUTHENTIK_CLIENT_ID=
|
||||
AUTH_AUTHENTIK_SECRET=
|
||||
65
README.md
65
README.md
@@ -22,26 +22,37 @@ A simple, modern kitchen inventory app that the whole family can actually use. B
|
||||
- 🔒 **Self-hosted** — Your data stays yours
|
||||
- 🌐 **Open Food Facts** — Auto-fill product data from barcodes
|
||||
|
||||
## 🚀 Quick Start
|
||||
## 🚀 Quick Start (Local Development)
|
||||
|
||||
```bash
|
||||
# Clone
|
||||
# Clone repository
|
||||
git clone https://gitea.jeanlucmakiola.de/pantry-app/pantry.git
|
||||
cd pantry
|
||||
|
||||
# Start services (Docker Compose)
|
||||
docker-compose up -d
|
||||
|
||||
# Access at http://localhost:3000
|
||||
# One-command startup
|
||||
./dev.sh
|
||||
```
|
||||
|
||||
**What this does:**
|
||||
1. Starts Supabase (PostgreSQL + API + Auth + Studio)
|
||||
2. Installs frontend dependencies
|
||||
3. Launches Nuxt dev server
|
||||
|
||||
**Access:**
|
||||
- App: `http://localhost:3000`
|
||||
- Supabase Studio: `http://localhost:54323`
|
||||
|
||||
**See [DEV_SETUP.md](DEV_SETUP.md) for detailed setup guide.**
|
||||
|
||||
## 📚 Documentation
|
||||
|
||||
- [**Project Plan**](docs/PROJECT_PLAN.md) — Vision, roadmap, phases
|
||||
- [**Architecture**](docs/ARCHITECTURE.md) — Tech stack, data model, design decisions
|
||||
- [**Database Schema**](docs/DATABASE.md) — Tables, relationships, RLS policies
|
||||
- [**API Reference**](docs/API.md) — Endpoints, Supabase functions
|
||||
- [**Development Guide**](docs/DEVELOPMENT.md) — Setup, workflow, conventions
|
||||
- [**Deployment**](docs/DEPLOYMENT.md) — Docker, Coolify, production setup
|
||||
- **[Getting Started](docs/development/getting-started.md)** — First-time setup (5 minutes)
|
||||
- **[Local Setup Guide](docs/development/local-setup.md)** — Detailed Docker Compose setup
|
||||
- **[Project Plan](docs/PROJECT_PLAN.md)** — Vision, roadmap, MVP phases
|
||||
- **[Architecture](docs/architecture/overview.md)** — Tech stack, design decisions
|
||||
- **[Database Schema](docs/architecture/database.md)** — Tables, RLS policies, migrations
|
||||
- **[Development Workflow](docs/development/workflow.md)** — Git flow, conventions
|
||||
- **[Full Documentation Index](docs/README.md)** — Complete docs navigation
|
||||
|
||||
## 🛠️ Tech Stack
|
||||
|
||||
@@ -73,18 +84,32 @@ pantry/
|
||||
3. **Extendable** — Clean architecture for future features
|
||||
4. **Self-hosted first** — No SaaS plans, no lock-in
|
||||
|
||||
## 📋 MVP Status
|
||||
## 📋 MVP Status (14/34 Complete - 41.2%)
|
||||
|
||||
**Target:** v0.1 (6-week sprint)
|
||||
**Current Phase:** Week 2 ✅ Complete, Week 3 🔄 In Progress
|
||||
|
||||
✅ **Week 1 - Foundation (6/6)**
|
||||
- Database schema + RLS policies
|
||||
- Nuxt 4 app scaffold
|
||||
- Supabase integration
|
||||
- App layout
|
||||
|
||||
✅ **Week 2 - Core Inventory (8/8)**
|
||||
- SQL helper functions
|
||||
- Seed data (units + tags)
|
||||
- Inventory CRUD UI
|
||||
- Add/Edit/Delete components
|
||||
|
||||
🔄 **Week 3 - Barcode Scanning (1/5)**
|
||||
- BarcodeScanner component
|
||||
- html5-qrcode integration
|
||||
- Product lookup (pending)
|
||||
- Scan-to-add flow (pending)
|
||||
|
||||
⏸️ **Week 4-6** - Tag UI, PWA, Deployment (20 issues)
|
||||
|
||||
See [PROJECT_PLAN.md](docs/PROJECT_PLAN.md) for detailed roadmap.
|
||||
|
||||
- [ ] Foundation (Nuxt + Supabase + Auth)
|
||||
- [ ] Core inventory (CRUD, tags, units)
|
||||
- [ ] Barcode scanning (PWA camera + Open Food Facts)
|
||||
- [ ] Mobile polish (PWA, offline)
|
||||
- [ ] Docker deployment
|
||||
|
||||
## 🤝 Contributing
|
||||
|
||||
This is an early-stage project. Contributions welcome once v0.1 ships.
|
||||
|
||||
214
SETUP.md
214
SETUP.md
@@ -1,214 +0,0 @@
|
||||
# Pantry - Setup Guide
|
||||
|
||||
## ✅ Current Status
|
||||
|
||||
### Infrastructure (Complete)
|
||||
|
||||
- **Supabase Dev Instance**: Running on Coolify
|
||||
- URL: `https://supabasekong-ewo8wssk4gs8cgg0c8kosk40.jeanlucmakiola.de`
|
||||
- Status: ✅ Healthy
|
||||
- Services: PostgreSQL, Auth (GoTrue), Realtime, Storage, PostgREST
|
||||
|
||||
### Environment Configuration (Complete)
|
||||
|
||||
- `.env.example` - Template for all environments
|
||||
- `.env.development` - Dev credentials (Coolify Supabase)
|
||||
- `.gitignore` - Protects secrets
|
||||
|
||||
---
|
||||
|
||||
## 🚀 Quick Start (Development)
|
||||
|
||||
### Prerequisites
|
||||
|
||||
- **Bun** 1.0+ (or Node.js 20+)
|
||||
- **Git** access to repository
|
||||
- **Access to Coolify** Supabase instance (credentials in `.env.development`)
|
||||
|
||||
### Setup Steps
|
||||
|
||||
1. **Clone Repository**
|
||||
```bash
|
||||
git clone https://gitea.jeanlucmakiola.de/pantry-app/pantry.git
|
||||
cd pantry
|
||||
```
|
||||
|
||||
2. **Copy Development Environment**
|
||||
```bash
|
||||
cp .env.development .env
|
||||
```
|
||||
|
||||
3. **Install Dependencies** (once `app/` exists)
|
||||
```bash
|
||||
cd app
|
||||
bun install
|
||||
```
|
||||
|
||||
4. **Apply Database Migrations** (once created)
|
||||
```bash
|
||||
cd supabase
|
||||
# TBD: Migration command
|
||||
```
|
||||
|
||||
5. **Start Development Server**
|
||||
```bash
|
||||
cd app
|
||||
bun run dev
|
||||
```
|
||||
|
||||
6. **Access App**
|
||||
- App: `http://localhost:3000`
|
||||
- Supabase API: `https://supabasekong-ewo8wssk4gs8cgg0c8kosk40.jeanlucmakiola.de`
|
||||
|
||||
---
|
||||
|
||||
## 🗄️ Supabase Instance Details
|
||||
|
||||
### Endpoints
|
||||
|
||||
| Service | URL |
|
||||
|---------|-----|
|
||||
| API (PostgREST) | `https://supabasekong-ewo8wssk4gs8cgg0c8kosk40.jeanlucmakiola.de/rest/v1/` |
|
||||
| Auth | `https://supabasekong-ewo8wssk4gs8cgg0c8kosk40.jeanlucmakiola.de/auth/v1/` |
|
||||
| Realtime | `wss://supabasekong-ewo8wssk4gs8cgg0c8kosk40.jeanlucmakiola.de/realtime/v1/` |
|
||||
| Storage | `https://supabasekong-ewo8wssk4gs8cgg0c8kosk40.jeanlucmakiola.de/storage/v1/` |
|
||||
|
||||
### Credentials
|
||||
|
||||
**Public (safe to use in frontend):**
|
||||
- Anon Key: In `.env.development`
|
||||
|
||||
**Secret (server-side only):**
|
||||
- Service Role Key: In `.env.development`
|
||||
- JWT Secret: In `.env.development`
|
||||
- Postgres Password: In `.env.development`
|
||||
|
||||
### Dashboard Access
|
||||
|
||||
**Supabase Studio:**
|
||||
- URL: `https://supabasekong-ewo8wssk4gs8cgg0c8kosk40.jeanlucmakiola.de` (check Coolify for Studio port/subdomain)
|
||||
- Username: `wJZbjs3Yd5P63cs9`
|
||||
- Password: `Qv3byDujNzYe8r7YRxhNwh3DPTvZBWtN`
|
||||
|
||||
**Direct PostgreSQL Access** (for migrations/debugging):
|
||||
- Host: `supabase-db` (or Coolify service FQDN)
|
||||
- Database: `postgres`
|
||||
- User: `postgres`
|
||||
- Password: `55P0NVRUltRqzZYksuXTFli5iXwbQvgu`
|
||||
- Port: `5432`
|
||||
|
||||
**MinIO (Storage):**
|
||||
- Admin User: `EaTXrXvjo1R4hsaI`
|
||||
- Admin Password: `gCZOphxAExNC17GYFwtw60WzTU0P8HW8`
|
||||
|
||||
---
|
||||
|
||||
## 📋 Next Steps
|
||||
|
||||
### Week 1: Foundation (In Progress)
|
||||
|
||||
- [x] ~~Supabase dev environment setup~~ (Complete)
|
||||
- [x] ~~Environment configuration~~ (Complete)
|
||||
- [ ] Create database schema (`supabase/migrations/`)
|
||||
- [ ] Scaffold Nuxt 4 app (`app/`)
|
||||
- [ ] Implement email/password auth
|
||||
- [ ] Deploy first version to Coolify
|
||||
|
||||
### Immediate Tasks
|
||||
|
||||
1. **Database Schema** (#10)
|
||||
- Create migration files in `supabase/migrations/`
|
||||
- Tables: `inventory_items`, `products`, `tags`, `item_tags`, `units`
|
||||
- See: `docs/DATABASE.md`
|
||||
|
||||
2. **Nuxt Scaffold** (#8)
|
||||
- Initialize Nuxt 4 project in `app/`
|
||||
- Install dependencies: `@nuxtjs/supabase`, `@nuxt/ui`, Tailwind
|
||||
- Configure `nuxt.config.ts`
|
||||
|
||||
3. **Auth Implementation** (#11)
|
||||
- Supabase Auth integration
|
||||
- Login/signup pages
|
||||
- Protected routes
|
||||
|
||||
---
|
||||
|
||||
## 🔧 Development Workflow
|
||||
|
||||
### Making Changes
|
||||
|
||||
```bash
|
||||
# 1. Create feature branch
|
||||
git checkout -b feature/your-feature
|
||||
|
||||
# 2. Make changes
|
||||
# Edit files...
|
||||
|
||||
# 3. Test locally
|
||||
bun run dev
|
||||
|
||||
# 4. Commit and push
|
||||
git add .
|
||||
git commit -m "feat: Your feature description"
|
||||
git push origin feature/your-feature
|
||||
|
||||
# 5. Create PR on Gitea
|
||||
```
|
||||
|
||||
### Database Migrations
|
||||
|
||||
```bash
|
||||
# Create new migration
|
||||
cd supabase/migrations
|
||||
touch 001_initial_schema.sql
|
||||
|
||||
# Edit migration file (SQL)
|
||||
# Test locally against Coolify Supabase instance
|
||||
|
||||
# Apply migration (TBD - once we set up migration tooling)
|
||||
```
|
||||
|
||||
---
|
||||
|
||||
## 🚨 Troubleshooting
|
||||
|
||||
### Can't connect to Supabase
|
||||
|
||||
**Test connection:**
|
||||
```bash
|
||||
curl -s "https://supabasekong-ewo8wssk4gs8cgg0c8kosk40.jeanlucmakiola.de/rest/v1/" \
|
||||
-H "apikey: <ANON_KEY>"
|
||||
```
|
||||
|
||||
Should return OpenAPI spec. If not:
|
||||
- Check Coolify service status
|
||||
- Verify URL in `.env`
|
||||
- Check network/firewall
|
||||
|
||||
### Environment variables not loading
|
||||
|
||||
- Ensure `.env` exists in project root
|
||||
- Check `.env` has no syntax errors
|
||||
- Restart dev server after changes
|
||||
|
||||
### Database migration issues
|
||||
|
||||
- Verify `SUPABASE_SERVICE_ROLE_KEY` is set
|
||||
- Check migration SQL syntax
|
||||
- Review Supabase logs in Coolify
|
||||
|
||||
---
|
||||
|
||||
## 📚 Documentation
|
||||
|
||||
- [Project Plan](docs/PROJECT_PLAN.md) - Vision, roadmap
|
||||
- [Architecture](docs/ARCHITECTURE.md) - Tech stack, design
|
||||
- [Database Schema](docs/DATABASE.md) - Tables, RLS, functions
|
||||
- [API Reference](docs/API.md) - Endpoints, usage
|
||||
- [Development Guide](docs/DEVELOPMENT.md) - Conventions, workflow
|
||||
- [Deployment](docs/DEPLOYMENT.md) - Docker, Coolify
|
||||
|
||||
---
|
||||
|
||||
**Last Updated:** 2026-02-08
|
||||
**Status:** Week 1 - Foundation in progress
|
||||
@@ -8,6 +8,7 @@
|
||||
"@nuxt/fonts": "^0.13.0",
|
||||
"@nuxt/ui": "^4.4.0",
|
||||
"@supabase/supabase-js": "^2.95.3",
|
||||
"html5-qrcode": "^2.3.8",
|
||||
"nuxt": "^4.3.1",
|
||||
"vue": "^3.5.28",
|
||||
"vue-router": "^4.6.4",
|
||||
@@ -1076,6 +1077,8 @@
|
||||
|
||||
"hookable": ["hookable@5.5.3", "", {}, "sha512-Yc+BQe8SvoXH1643Qez1zqLRmbA5rCL+sSmk6TVos0LWVfNIB7PGncdlId77WzLGSIB5KaWgTaNTs2lNVEI6VQ=="],
|
||||
|
||||
"html5-qrcode": ["html5-qrcode@2.3.8", "", {}, "sha512-jsr4vafJhwoLVEDW3n1KvPnCCXWaQfRng0/EEYk1vNcQGcG/htAdhJX0be8YyqMoSz7+hZvOZSTAepsabiuhiQ=="],
|
||||
|
||||
"http-assert": ["http-assert@1.5.0", "", { "dependencies": { "deep-equal": "~1.0.1", "http-errors": "~1.8.0" } }, "sha512-uPpH7OKX4H25hBmU6G1jWNaqJGpTXxey+YOUizJUAgu0AjLUeC8D73hTrhvDS5D+GJN1DN1+hhc/eF/wpxtp0w=="],
|
||||
|
||||
"http-errors": ["http-errors@2.0.1", "", { "dependencies": { "depd": "~2.0.0", "inherits": "~2.0.4", "setprototypeof": "~1.2.0", "statuses": "~2.0.2", "toidentifier": "~1.0.1" } }, "sha512-4FbRdAX+bSdmo4AUFuS0WNiPz8NgFt+r8ThgNWmlrjQjt1Q7ZR9+zTlce2859x4KSXrwIsaeTqDoKQmtP8pLmQ=="],
|
||||
|
||||
231
app/components/inventory/AddItemForm.vue
Normal file
231
app/components/inventory/AddItemForm.vue
Normal file
@@ -0,0 +1,231 @@
|
||||
<template>
|
||||
<UCard>
|
||||
<template #header>
|
||||
<div class="flex items-center justify-between">
|
||||
<h3 class="text-lg font-semibold">Add New Item</h3>
|
||||
<UButton
|
||||
icon="i-heroicons-x-mark"
|
||||
color="gray"
|
||||
variant="ghost"
|
||||
@click="$emit('close')"
|
||||
/>
|
||||
</div>
|
||||
</template>
|
||||
|
||||
<form @submit.prevent="handleSubmit" class="space-y-4">
|
||||
<!-- Item Name -->
|
||||
<UFormGroup label="Item Name" required>
|
||||
<UInput
|
||||
v-model="form.name"
|
||||
placeholder="e.g. Whole Milk, Pasta, Tomatoes"
|
||||
size="lg"
|
||||
autofocus
|
||||
/>
|
||||
</UFormGroup>
|
||||
|
||||
<!-- Quantity & Unit -->
|
||||
<div class="grid grid-cols-2 gap-3">
|
||||
<UFormGroup label="Quantity" required>
|
||||
<UInput
|
||||
v-model.number="form.quantity"
|
||||
type="number"
|
||||
min="0.01"
|
||||
step="0.01"
|
||||
placeholder="1"
|
||||
size="lg"
|
||||
/>
|
||||
</UFormGroup>
|
||||
|
||||
<UFormGroup label="Unit" required>
|
||||
<USelect
|
||||
v-model="form.unit_id"
|
||||
:options="unitOptions"
|
||||
option-attribute="label"
|
||||
value-attribute="value"
|
||||
placeholder="Select unit"
|
||||
size="lg"
|
||||
/>
|
||||
</UFormGroup>
|
||||
</div>
|
||||
|
||||
<!-- Expiry Date -->
|
||||
<UFormGroup label="Expiry Date" hint="Optional">
|
||||
<UInput
|
||||
v-model="form.expiry_date"
|
||||
type="date"
|
||||
size="lg"
|
||||
/>
|
||||
</UFormGroup>
|
||||
|
||||
<!-- Notes -->
|
||||
<UFormGroup label="Notes" hint="Optional">
|
||||
<UTextarea
|
||||
v-model="form.notes"
|
||||
placeholder="Any additional notes..."
|
||||
:rows="2"
|
||||
/>
|
||||
</UFormGroup>
|
||||
|
||||
<!-- Tags -->
|
||||
<UFormGroup label="Tags" hint="Optional">
|
||||
<TagsTagPicker v-model="selectedTags" />
|
||||
</UFormGroup>
|
||||
|
||||
<!-- Submit -->
|
||||
<div class="flex gap-2 pt-2">
|
||||
<UButton
|
||||
type="submit"
|
||||
color="primary"
|
||||
size="lg"
|
||||
class="flex-1"
|
||||
:loading="submitting"
|
||||
:disabled="!isValid"
|
||||
>
|
||||
Add Item
|
||||
</UButton>
|
||||
<UButton
|
||||
color="gray"
|
||||
size="lg"
|
||||
variant="soft"
|
||||
@click="$emit('close')"
|
||||
>
|
||||
Cancel
|
||||
</UButton>
|
||||
</div>
|
||||
</form>
|
||||
</UCard>
|
||||
</template>
|
||||
|
||||
<script setup lang="ts">
|
||||
const { addInventoryItem, addItemTags } = useInventory()
|
||||
const { getUnits } = useUnits()
|
||||
|
||||
const props = defineProps<{
|
||||
initialData?: {
|
||||
barcode?: string
|
||||
name?: string
|
||||
brand?: string
|
||||
image_url?: string
|
||||
quantity?: string
|
||||
}
|
||||
}>()
|
||||
|
||||
const emit = defineEmits<{
|
||||
close: []
|
||||
added: [item: any]
|
||||
}>()
|
||||
|
||||
// Form state
|
||||
const form = reactive({
|
||||
name: '',
|
||||
quantity: 1,
|
||||
unit_id: '',
|
||||
expiry_date: '',
|
||||
notes: ''
|
||||
})
|
||||
|
||||
const submitting = ref(false)
|
||||
const selectedTags = ref<any[]>([])
|
||||
|
||||
// Load units
|
||||
const units = ref<any[]>([])
|
||||
|
||||
onMounted(async () => {
|
||||
const unitsResult = await getUnits()
|
||||
units.value = unitsResult.data || []
|
||||
|
||||
// Set default unit (Piece)
|
||||
const defaultUnit = units.value.find(u => u.abbreviation === 'pc')
|
||||
if (defaultUnit) {
|
||||
form.unit_id = defaultUnit.id
|
||||
}
|
||||
|
||||
// Pre-fill from initial data (scan-to-add flow)
|
||||
if (props.initialData) {
|
||||
if (props.initialData.name) {
|
||||
form.name = props.initialData.name
|
||||
}
|
||||
|
||||
// Add brand to notes if available
|
||||
if (props.initialData.brand) {
|
||||
form.notes = `Brand: ${props.initialData.brand}`
|
||||
|
||||
if (props.initialData.barcode) {
|
||||
form.notes += `\nBarcode: ${props.initialData.barcode}`
|
||||
}
|
||||
} else if (props.initialData.barcode) {
|
||||
form.notes = `Barcode: ${props.initialData.barcode}`
|
||||
}
|
||||
|
||||
// Parse quantity if available (e.g., "750g")
|
||||
if (props.initialData.quantity) {
|
||||
const quantityMatch = props.initialData.quantity.match(/^([\d.]+)\s*([a-zA-Z]+)$/)
|
||||
if (quantityMatch) {
|
||||
form.quantity = parseFloat(quantityMatch[1])
|
||||
// Try to match unit
|
||||
const unitAbbr = quantityMatch[2].toLowerCase()
|
||||
const matchedUnit = units.value.find(u =>
|
||||
u.abbreviation.toLowerCase() === unitAbbr
|
||||
)
|
||||
if (matchedUnit) {
|
||||
form.unit_id = matchedUnit.id
|
||||
}
|
||||
}
|
||||
}
|
||||
}
|
||||
})
|
||||
|
||||
// Unit options for select
|
||||
const unitOptions = computed(() => {
|
||||
const grouped: Record<string, any[]> = {}
|
||||
|
||||
for (const unit of units.value) {
|
||||
const type = unit.unit_type
|
||||
if (!grouped[type]) grouped[type] = []
|
||||
grouped[type].push({
|
||||
label: `${unit.name} (${unit.abbreviation})`,
|
||||
value: unit.id
|
||||
})
|
||||
}
|
||||
|
||||
return Object.entries(grouped).flatMap(([type, options]) => [
|
||||
{ label: `— ${type.charAt(0).toUpperCase() + type.slice(1)} —`, value: '', disabled: true },
|
||||
...options
|
||||
])
|
||||
})
|
||||
|
||||
// Validation
|
||||
const isValid = computed(() => {
|
||||
return form.name.trim().length > 0 && form.quantity > 0 && form.unit_id
|
||||
})
|
||||
|
||||
// Submit
|
||||
const handleSubmit = async () => {
|
||||
if (!isValid.value) return
|
||||
|
||||
submitting.value = true
|
||||
|
||||
const { data, error } = await addInventoryItem({
|
||||
name: form.name.trim(),
|
||||
quantity: form.quantity,
|
||||
unit_id: form.unit_id,
|
||||
expiry_date: form.expiry_date || null,
|
||||
notes: form.notes.trim() || null
|
||||
})
|
||||
|
||||
if (error) {
|
||||
alert('Failed to add item: ' + error.message)
|
||||
submitting.value = false
|
||||
return
|
||||
}
|
||||
|
||||
// Add tags if any selected
|
||||
if (data && selectedTags.value.length > 0) {
|
||||
const tagIds = selectedTags.value.map(t => t.id)
|
||||
await addItemTags(data.id, tagIds)
|
||||
}
|
||||
|
||||
emit('added', data)
|
||||
submitting.value = false
|
||||
}
|
||||
</script>
|
||||
184
app/components/inventory/EditItemModal.vue
Normal file
184
app/components/inventory/EditItemModal.vue
Normal file
@@ -0,0 +1,184 @@
|
||||
<template>
|
||||
<UModal v-model="isOpen">
|
||||
<UCard>
|
||||
<template #header>
|
||||
<div class="flex items-center justify-between">
|
||||
<h3 class="text-lg font-semibold">Edit Item</h3>
|
||||
<UButton
|
||||
icon="i-heroicons-x-mark"
|
||||
color="gray"
|
||||
variant="ghost"
|
||||
@click="close"
|
||||
/>
|
||||
</div>
|
||||
</template>
|
||||
|
||||
<form @submit.prevent="handleSubmit" class="space-y-4">
|
||||
<!-- Item Name -->
|
||||
<UFormGroup label="Item Name" required>
|
||||
<UInput
|
||||
v-model="form.name"
|
||||
placeholder="Item name"
|
||||
size="lg"
|
||||
/>
|
||||
</UFormGroup>
|
||||
|
||||
<!-- Quantity & Unit -->
|
||||
<div class="grid grid-cols-2 gap-3">
|
||||
<UFormGroup label="Quantity" required>
|
||||
<UInput
|
||||
v-model.number="form.quantity"
|
||||
type="number"
|
||||
min="0.01"
|
||||
step="0.01"
|
||||
size="lg"
|
||||
/>
|
||||
</UFormGroup>
|
||||
|
||||
<UFormGroup label="Unit" required>
|
||||
<USelect
|
||||
v-model="form.unit_id"
|
||||
:options="unitOptions"
|
||||
option-attribute="label"
|
||||
value-attribute="value"
|
||||
size="lg"
|
||||
/>
|
||||
</UFormGroup>
|
||||
</div>
|
||||
|
||||
<!-- Expiry Date -->
|
||||
<UFormGroup label="Expiry Date" hint="Optional">
|
||||
<UInput
|
||||
v-model="form.expiry_date"
|
||||
type="date"
|
||||
size="lg"
|
||||
/>
|
||||
</UFormGroup>
|
||||
|
||||
<!-- Notes -->
|
||||
<UFormGroup label="Notes" hint="Optional">
|
||||
<UTextarea
|
||||
v-model="form.notes"
|
||||
placeholder="Any additional notes..."
|
||||
:rows="2"
|
||||
/>
|
||||
</UFormGroup>
|
||||
|
||||
<!-- Submit -->
|
||||
<div class="flex gap-2 pt-2">
|
||||
<UButton
|
||||
type="submit"
|
||||
color="primary"
|
||||
size="lg"
|
||||
class="flex-1"
|
||||
:loading="submitting"
|
||||
:disabled="!isValid"
|
||||
>
|
||||
Save Changes
|
||||
</UButton>
|
||||
<UButton
|
||||
color="gray"
|
||||
size="lg"
|
||||
variant="soft"
|
||||
@click="close"
|
||||
>
|
||||
Cancel
|
||||
</UButton>
|
||||
</div>
|
||||
</form>
|
||||
</UCard>
|
||||
</UModal>
|
||||
</template>
|
||||
|
||||
<script setup lang="ts">
|
||||
const { updateInventoryItem } = useInventory()
|
||||
const { getUnits } = useUnits()
|
||||
|
||||
const props = defineProps<{
|
||||
item: any | null
|
||||
}>()
|
||||
|
||||
const emit = defineEmits<{
|
||||
close: []
|
||||
updated: [item: any]
|
||||
}>()
|
||||
|
||||
const isOpen = ref(false)
|
||||
const submitting = ref(false)
|
||||
const units = ref<any[]>([])
|
||||
|
||||
const form = reactive({
|
||||
name: '',
|
||||
quantity: 1,
|
||||
unit_id: '',
|
||||
expiry_date: '',
|
||||
notes: ''
|
||||
})
|
||||
|
||||
// Load units
|
||||
onMounted(async () => {
|
||||
const { data } = await getUnits()
|
||||
units.value = data || []
|
||||
})
|
||||
|
||||
// Unit options for select
|
||||
const unitOptions = computed(() => {
|
||||
return units.value.map(unit => ({
|
||||
label: `${unit.name} (${unit.abbreviation})`,
|
||||
value: unit.id
|
||||
}))
|
||||
})
|
||||
|
||||
// Watch for item changes (open modal)
|
||||
watch(() => props.item, (newItem) => {
|
||||
if (newItem) {
|
||||
form.name = newItem.name
|
||||
form.quantity = Number(newItem.quantity)
|
||||
form.unit_id = newItem.unit_id
|
||||
form.expiry_date = newItem.expiry_date || ''
|
||||
form.notes = newItem.notes || ''
|
||||
isOpen.value = true
|
||||
}
|
||||
}, { immediate: true })
|
||||
|
||||
// Watch modal close
|
||||
watch(isOpen, (val) => {
|
||||
if (!val) {
|
||||
emit('close')
|
||||
}
|
||||
})
|
||||
|
||||
// Validation
|
||||
const isValid = computed(() => {
|
||||
return form.name.trim().length > 0 && form.quantity > 0 && form.unit_id
|
||||
})
|
||||
|
||||
const close = () => {
|
||||
isOpen.value = false
|
||||
}
|
||||
|
||||
// Submit
|
||||
const handleSubmit = async () => {
|
||||
if (!isValid.value || !props.item) return
|
||||
|
||||
submitting.value = true
|
||||
|
||||
const { data, error } = await updateInventoryItem(props.item.id, {
|
||||
name: form.name.trim(),
|
||||
quantity: form.quantity,
|
||||
unit_id: form.unit_id,
|
||||
expiry_date: form.expiry_date || null,
|
||||
notes: form.notes.trim() || null
|
||||
})
|
||||
|
||||
if (error) {
|
||||
alert('Failed to update item: ' + error.message)
|
||||
submitting.value = false
|
||||
return
|
||||
}
|
||||
|
||||
emit('updated', data)
|
||||
submitting.value = false
|
||||
close()
|
||||
}
|
||||
</script>
|
||||
148
app/components/inventory/InventoryCard.vue
Normal file
148
app/components/inventory/InventoryCard.vue
Normal file
@@ -0,0 +1,148 @@
|
||||
<template>
|
||||
<UCard class="hover:shadow-lg transition-shadow">
|
||||
<!-- Item Image -->
|
||||
<div class="aspect-square bg-gray-100 rounded-lg mb-3 overflow-hidden">
|
||||
<img
|
||||
v-if="item.product?.image_url"
|
||||
:src="item.product.image_url"
|
||||
:alt="item.name"
|
||||
class="w-full h-full object-cover"
|
||||
/>
|
||||
<div v-else class="w-full h-full flex items-center justify-center">
|
||||
<UIcon name="i-heroicons-cube" class="w-16 h-16 text-gray-300" />
|
||||
</div>
|
||||
</div>
|
||||
|
||||
<!-- Item Info -->
|
||||
<div class="space-y-2">
|
||||
<div>
|
||||
<h3 class="font-semibold text-gray-900 truncate">{{ item.name }}</h3>
|
||||
<p v-if="item.product?.brand" class="text-sm text-gray-600 truncate">
|
||||
{{ item.product.brand }}
|
||||
</p>
|
||||
</div>
|
||||
|
||||
<!-- Quantity -->
|
||||
<div class="flex items-center justify-between">
|
||||
<span class="text-lg font-medium text-gray-900">
|
||||
{{ item.quantity }} {{ item.unit?.abbreviation }}
|
||||
</span>
|
||||
|
||||
<!-- Quick Actions -->
|
||||
<div class="flex gap-1">
|
||||
<UButton
|
||||
icon="i-heroicons-minus"
|
||||
size="xs"
|
||||
color="gray"
|
||||
variant="ghost"
|
||||
@click="$emit('update-quantity', item.id, -1)"
|
||||
:disabled="item.quantity <= 1"
|
||||
/>
|
||||
<UButton
|
||||
icon="i-heroicons-plus"
|
||||
size="xs"
|
||||
color="gray"
|
||||
variant="ghost"
|
||||
@click="$emit('update-quantity', item.id, 1)"
|
||||
/>
|
||||
</div>
|
||||
</div>
|
||||
|
||||
<!-- Tags -->
|
||||
<div v-if="item.tags && item.tags.length > 0" class="flex flex-wrap gap-1">
|
||||
<TagsTagBadge
|
||||
v-for="tagItem in item.tags.slice(0, 3)"
|
||||
:key="tagItem.tag.id"
|
||||
:tag="tagItem.tag"
|
||||
size="sm"
|
||||
/>
|
||||
<UBadge v-if="item.tags.length > 3" size="xs" color="gray">
|
||||
+{{ item.tags.length - 3 }}
|
||||
</UBadge>
|
||||
</div>
|
||||
|
||||
<!-- Expiry Warning -->
|
||||
<div v-if="daysUntilExpiry !== null" class="text-xs">
|
||||
<UBadge
|
||||
:color="expiryColor"
|
||||
variant="soft"
|
||||
class="w-full justify-center"
|
||||
>
|
||||
<UIcon :name="expiryIcon" class="mr-1" />
|
||||
{{ expiryText }}
|
||||
</UBadge>
|
||||
</div>
|
||||
</div>
|
||||
|
||||
<!-- Action Buttons -->
|
||||
<template #footer>
|
||||
<div class="flex gap-2">
|
||||
<UButton
|
||||
icon="i-heroicons-pencil"
|
||||
size="sm"
|
||||
color="gray"
|
||||
variant="soft"
|
||||
class="flex-1"
|
||||
@click="$emit('edit', item)"
|
||||
>
|
||||
Edit
|
||||
</UButton>
|
||||
<UButton
|
||||
icon="i-heroicons-trash"
|
||||
size="sm"
|
||||
color="red"
|
||||
variant="soft"
|
||||
@click="$emit('delete', item.id)"
|
||||
>
|
||||
Delete
|
||||
</UButton>
|
||||
</div>
|
||||
</template>
|
||||
</UCard>
|
||||
</template>
|
||||
|
||||
<script setup lang="ts">
|
||||
const props = defineProps<{
|
||||
item: any
|
||||
}>()
|
||||
|
||||
defineEmits<{
|
||||
edit: [item: any]
|
||||
delete: [id: string]
|
||||
'update-quantity': [id: string, change: number]
|
||||
}>()
|
||||
|
||||
// Calculate days until expiry
|
||||
const daysUntilExpiry = computed(() => {
|
||||
if (!props.item.expiry_date) return null
|
||||
|
||||
const today = new Date()
|
||||
const expiry = new Date(props.item.expiry_date)
|
||||
const diff = Math.ceil((expiry.getTime() - today.getTime()) / (1000 * 60 * 60 * 24))
|
||||
|
||||
return diff
|
||||
})
|
||||
|
||||
// Expiry badge styling
|
||||
const expiryColor = computed(() => {
|
||||
if (daysUntilExpiry.value === null) return 'gray'
|
||||
if (daysUntilExpiry.value < 0) return 'red'
|
||||
if (daysUntilExpiry.value <= 3) return 'orange'
|
||||
if (daysUntilExpiry.value <= 7) return 'yellow'
|
||||
return 'green'
|
||||
})
|
||||
|
||||
const expiryIcon = computed(() => {
|
||||
if (daysUntilExpiry.value === null) return 'i-heroicons-calendar'
|
||||
if (daysUntilExpiry.value < 0) return 'i-heroicons-exclamation-triangle'
|
||||
return 'i-heroicons-clock'
|
||||
})
|
||||
|
||||
const expiryText = computed(() => {
|
||||
if (daysUntilExpiry.value === null) return 'No expiry'
|
||||
if (daysUntilExpiry.value < 0) return `Expired ${Math.abs(daysUntilExpiry.value)} days ago`
|
||||
if (daysUntilExpiry.value === 0) return 'Expires today'
|
||||
if (daysUntilExpiry.value === 1) return 'Expires tomorrow'
|
||||
return `Expires in ${daysUntilExpiry.value} days`
|
||||
})
|
||||
</script>
|
||||
131
app/components/inventory/InventoryList.vue
Normal file
131
app/components/inventory/InventoryList.vue
Normal file
@@ -0,0 +1,131 @@
|
||||
<template>
|
||||
<div class="space-y-4">
|
||||
<!-- Loading State -->
|
||||
<div v-if="loading" class="text-center py-12">
|
||||
<UIcon name="i-heroicons-arrow-path" class="w-8 h-8 text-gray-400 animate-spin mx-auto mb-2" />
|
||||
<p class="text-gray-600">Loading inventory...</p>
|
||||
</div>
|
||||
|
||||
<!-- Error State -->
|
||||
<div v-else-if="error" class="text-center py-12">
|
||||
<UIcon name="i-heroicons-exclamation-triangle" class="w-12 h-12 text-red-500 mx-auto mb-4" />
|
||||
<p class="text-red-600 mb-4">{{ error }}</p>
|
||||
<UButton @click="loadInventory" color="gray">Retry</UButton>
|
||||
</div>
|
||||
|
||||
<!-- Empty State -->
|
||||
<div v-else-if="!items || items.length === 0" class="text-center py-12">
|
||||
<UIcon name="i-heroicons-inbox" class="w-16 h-16 text-gray-400 mx-auto mb-4" />
|
||||
<h3 class="text-lg font-semibold text-gray-900 mb-2">
|
||||
No items yet
|
||||
</h3>
|
||||
<p class="text-gray-600 mb-6">
|
||||
Start by scanning a barcode or adding an item manually.
|
||||
</p>
|
||||
<div class="flex gap-2 justify-center">
|
||||
<UButton
|
||||
to="/scan"
|
||||
color="primary"
|
||||
icon="i-heroicons-qr-code"
|
||||
>
|
||||
Scan First Item
|
||||
</UButton>
|
||||
<UButton
|
||||
@click="$emit('add-item')"
|
||||
color="white"
|
||||
icon="i-heroicons-plus"
|
||||
>
|
||||
Add Manually
|
||||
</UButton>
|
||||
</div>
|
||||
</div>
|
||||
|
||||
<!-- Inventory Grid -->
|
||||
<div v-else class="grid gap-4 sm:grid-cols-2 lg:grid-cols-3 xl:grid-cols-4">
|
||||
<InventoryCard
|
||||
v-for="item in items"
|
||||
:key="item.id"
|
||||
:item="item"
|
||||
@edit="$emit('edit-item', item)"
|
||||
@delete="handleDelete(item.id)"
|
||||
@update-quantity="handleQuantityUpdate"
|
||||
/>
|
||||
</div>
|
||||
</div>
|
||||
</template>
|
||||
|
||||
<script setup lang="ts">
|
||||
const { getInventory, deleteInventoryItem, updateQuantity } = useInventory()
|
||||
|
||||
const props = defineProps<{
|
||||
refresh?: boolean
|
||||
}>()
|
||||
|
||||
const emit = defineEmits<{
|
||||
'add-item': []
|
||||
'edit-item': [item: any]
|
||||
}>()
|
||||
|
||||
const items = ref<any[]>([])
|
||||
const loading = ref(true)
|
||||
const error = ref<string | null>(null)
|
||||
|
||||
const loadInventory = async () => {
|
||||
loading.value = true
|
||||
error.value = null
|
||||
|
||||
const { data, error: fetchError } = await getInventory()
|
||||
|
||||
if (fetchError) {
|
||||
error.value = 'Failed to load inventory. Please try again.'
|
||||
loading.value = false
|
||||
return
|
||||
}
|
||||
|
||||
items.value = data || []
|
||||
loading.value = false
|
||||
}
|
||||
|
||||
const handleDelete = async (id: string) => {
|
||||
if (!confirm('Are you sure you want to delete this item?')) {
|
||||
return
|
||||
}
|
||||
|
||||
const { error: deleteError } = await deleteInventoryItem(id)
|
||||
|
||||
if (deleteError) {
|
||||
alert('Failed to delete item')
|
||||
return
|
||||
}
|
||||
|
||||
// Remove from local list
|
||||
items.value = items.value.filter(item => item.id !== id)
|
||||
}
|
||||
|
||||
const handleQuantityUpdate = async (id: string, change: number) => {
|
||||
const result = await updateQuantity(id, change)
|
||||
|
||||
if (result.error) {
|
||||
alert('Failed to update quantity')
|
||||
return
|
||||
}
|
||||
|
||||
// Reload inventory after update
|
||||
await loadInventory()
|
||||
}
|
||||
|
||||
// Load on mount
|
||||
onMounted(loadInventory)
|
||||
|
||||
// Watch for refresh prop
|
||||
watch(() => props.refresh, (newVal) => {
|
||||
if (newVal) {
|
||||
loadInventory()
|
||||
}
|
||||
})
|
||||
|
||||
// Expose reload method
|
||||
defineExpose({
|
||||
reload: loadInventory
|
||||
})
|
||||
</script>
|
||||
161
app/components/scan/BarcodeScanner.vue
Normal file
161
app/components/scan/BarcodeScanner.vue
Normal file
@@ -0,0 +1,161 @@
|
||||
<template>
|
||||
<div class="relative">
|
||||
<!-- Scanner Container -->
|
||||
<div
|
||||
:id="scannerId"
|
||||
ref="scannerRef"
|
||||
class="w-full rounded-lg overflow-hidden bg-black"
|
||||
:class="{ 'aspect-video': !isScanning, 'min-h-[300px]': isScanning }"
|
||||
/>
|
||||
|
||||
<!-- Overlay when not scanning -->
|
||||
<div
|
||||
v-if="!isScanning && !error"
|
||||
class="absolute inset-0 flex items-center justify-center bg-gray-900 rounded-lg"
|
||||
>
|
||||
<div class="text-center">
|
||||
<UIcon name="i-heroicons-camera" class="w-16 h-16 text-gray-400 mb-4" />
|
||||
<UButton
|
||||
color="primary"
|
||||
size="lg"
|
||||
icon="i-heroicons-qr-code"
|
||||
@click="startScanning"
|
||||
>
|
||||
Start Camera
|
||||
</UButton>
|
||||
</div>
|
||||
</div>
|
||||
|
||||
<!-- Error State -->
|
||||
<div
|
||||
v-if="error"
|
||||
class="absolute inset-0 flex items-center justify-center bg-gray-900 rounded-lg"
|
||||
>
|
||||
<div class="text-center px-4">
|
||||
<UIcon name="i-heroicons-exclamation-triangle" class="w-12 h-12 text-red-400 mb-4" />
|
||||
<p class="text-white mb-4">{{ error }}</p>
|
||||
<div class="flex gap-2 justify-center">
|
||||
<UButton @click="startScanning" color="primary">Try Again</UButton>
|
||||
<UButton @click="$emit('manual-entry')" color="gray">Enter Manually</UButton>
|
||||
</div>
|
||||
</div>
|
||||
</div>
|
||||
|
||||
<!-- Manual Barcode Entry -->
|
||||
<div class="mt-4">
|
||||
<UFormGroup label="Or enter barcode manually">
|
||||
<div class="flex gap-2">
|
||||
<UInput
|
||||
v-model="manualBarcode"
|
||||
placeholder="e.g. 8000500310427"
|
||||
size="lg"
|
||||
class="flex-1"
|
||||
@keyup.enter="submitManualBarcode"
|
||||
/>
|
||||
<UButton
|
||||
color="primary"
|
||||
size="lg"
|
||||
:disabled="!manualBarcode.trim()"
|
||||
@click="submitManualBarcode"
|
||||
>
|
||||
Lookup
|
||||
</UButton>
|
||||
</div>
|
||||
</UFormGroup>
|
||||
</div>
|
||||
</div>
|
||||
</template>
|
||||
|
||||
<script setup lang="ts">
|
||||
import { Html5Qrcode, Html5QrcodeSupportedFormats } from 'html5-qrcode'
|
||||
|
||||
const emit = defineEmits<{
|
||||
'barcode-detected': [barcode: string]
|
||||
'manual-entry': []
|
||||
}>()
|
||||
|
||||
const scannerId = 'barcode-scanner'
|
||||
const scannerRef = ref<HTMLElement | null>(null)
|
||||
const isScanning = ref(false)
|
||||
const error = ref<string | null>(null)
|
||||
const manualBarcode = ref('')
|
||||
|
||||
let html5QrCode: Html5Qrcode | null = null
|
||||
|
||||
const startScanning = async () => {
|
||||
error.value = null
|
||||
|
||||
try {
|
||||
if (!html5QrCode) {
|
||||
html5QrCode = new Html5Qrcode(scannerId, {
|
||||
formatsToSupport: [
|
||||
Html5QrcodeSupportedFormats.EAN_13,
|
||||
Html5QrcodeSupportedFormats.EAN_8,
|
||||
Html5QrcodeSupportedFormats.UPC_A,
|
||||
Html5QrcodeSupportedFormats.UPC_E,
|
||||
Html5QrcodeSupportedFormats.CODE_128,
|
||||
Html5QrcodeSupportedFormats.CODE_39,
|
||||
Html5QrcodeSupportedFormats.QR_CODE
|
||||
],
|
||||
verbose: false
|
||||
})
|
||||
}
|
||||
|
||||
await html5QrCode.start(
|
||||
{ facingMode: 'environment' },
|
||||
{
|
||||
fps: 10,
|
||||
qrbox: { width: 250, height: 150 },
|
||||
aspectRatio: 1.777
|
||||
},
|
||||
onScanSuccess,
|
||||
onScanFailure
|
||||
)
|
||||
|
||||
isScanning.value = true
|
||||
} catch (err: any) {
|
||||
console.error('Scanner error:', err)
|
||||
|
||||
if (err.toString().includes('NotAllowedError')) {
|
||||
error.value = 'Camera permission denied. Please allow camera access and try again.'
|
||||
} else if (err.toString().includes('NotFoundError')) {
|
||||
error.value = 'No camera found. Please use a device with a camera or enter the barcode manually.'
|
||||
} else {
|
||||
error.value = 'Could not start camera. Try entering the barcode manually.'
|
||||
}
|
||||
}
|
||||
}
|
||||
|
||||
const stopScanning = async () => {
|
||||
if (html5QrCode && isScanning.value) {
|
||||
try {
|
||||
await html5QrCode.stop()
|
||||
} catch (err) {
|
||||
console.error('Error stopping scanner:', err)
|
||||
}
|
||||
isScanning.value = false
|
||||
}
|
||||
}
|
||||
|
||||
const onScanSuccess = (decodedText: string) => {
|
||||
// Stop scanning after successful read
|
||||
stopScanning()
|
||||
emit('barcode-detected', decodedText)
|
||||
}
|
||||
|
||||
const onScanFailure = (_errorMessage: string) => {
|
||||
// Ignore - this fires continuously when no barcode is detected
|
||||
}
|
||||
|
||||
const submitManualBarcode = () => {
|
||||
if (manualBarcode.value.trim()) {
|
||||
emit('barcode-detected', manualBarcode.value.trim())
|
||||
manualBarcode.value = ''
|
||||
}
|
||||
}
|
||||
|
||||
// Cleanup on unmount
|
||||
onUnmounted(() => {
|
||||
stopScanning()
|
||||
})
|
||||
</script>
|
||||
71
app/components/tags/TagBadge.vue
Normal file
71
app/components/tags/TagBadge.vue
Normal file
@@ -0,0 +1,71 @@
|
||||
<template>
|
||||
<UBadge
|
||||
:style="badgeStyle"
|
||||
:class="badgeClasses"
|
||||
v-bind="$attrs"
|
||||
>
|
||||
<span v-if="tag.icon" class="mr-1">{{ tag.icon }}</span>
|
||||
<span>{{ tag.name }}</span>
|
||||
<UButton
|
||||
v-if="removable"
|
||||
icon="i-heroicons-x-mark"
|
||||
size="2xs"
|
||||
color="white"
|
||||
variant="link"
|
||||
class="ml-1 -mr-1"
|
||||
@click.stop="$emit('remove', tag.id)"
|
||||
/>
|
||||
</UBadge>
|
||||
</template>
|
||||
|
||||
<script setup lang="ts">
|
||||
interface Tag {
|
||||
id: string
|
||||
name: string
|
||||
color: string
|
||||
icon?: string
|
||||
category: string
|
||||
}
|
||||
|
||||
const props = withDefaults(defineProps<{
|
||||
tag: Tag
|
||||
removable?: boolean
|
||||
size?: 'sm' | 'md' | 'lg'
|
||||
}>(), {
|
||||
removable: false,
|
||||
size: 'md'
|
||||
})
|
||||
|
||||
defineEmits<{
|
||||
remove: [tagId: string]
|
||||
}>()
|
||||
|
||||
const badgeStyle = computed(() => ({
|
||||
backgroundColor: props.tag.color,
|
||||
color: getContrastColor(props.tag.color)
|
||||
}))
|
||||
|
||||
const badgeClasses = computed(() => ({
|
||||
'cursor-pointer': props.removable,
|
||||
'text-xs px-2 py-1': props.size === 'sm',
|
||||
'text-sm px-2.5 py-1': props.size === 'md',
|
||||
'text-base px-3 py-1.5': props.size === 'lg'
|
||||
}))
|
||||
|
||||
// Calculate contrast color for text (black or white)
|
||||
function getContrastColor(hexColor: string): string {
|
||||
// Remove # if present
|
||||
const hex = hexColor.replace('#', '')
|
||||
|
||||
// Convert to RGB
|
||||
const r = parseInt(hex.slice(0, 2), 16)
|
||||
const g = parseInt(hex.slice(2, 4), 16)
|
||||
const b = parseInt(hex.slice(4, 6), 16)
|
||||
|
||||
// Calculate luminance
|
||||
const luminance = (0.299 * r + 0.587 * g + 0.114 * b) / 255
|
||||
|
||||
// Return white for dark colors, black for light colors
|
||||
return luminance > 0.5 ? '#000000' : '#FFFFFF'
|
||||
}
|
||||
</script>
|
||||
125
app/components/tags/TagPicker.vue
Normal file
125
app/components/tags/TagPicker.vue
Normal file
@@ -0,0 +1,125 @@
|
||||
<template>
|
||||
<div class="space-y-4">
|
||||
<!-- Selected Tags -->
|
||||
<div v-if="selectedTags.length > 0" class="flex flex-wrap gap-2">
|
||||
<TagsTagBadge
|
||||
v-for="tag in selectedTags"
|
||||
:key="tag.id"
|
||||
:tag="tag"
|
||||
:removable="true"
|
||||
@remove="removeTag"
|
||||
/>
|
||||
</div>
|
||||
|
||||
<!-- Empty State -->
|
||||
<div v-else class="text-sm text-gray-500 italic">
|
||||
No tags selected
|
||||
</div>
|
||||
|
||||
<!-- Tag Selection by Category -->
|
||||
<div v-for="category in tagsByCategory" :key="category.name" class="space-y-2">
|
||||
<h4 class="text-xs font-semibold text-gray-500 uppercase tracking-wide">
|
||||
{{ category.name }}
|
||||
</h4>
|
||||
<div class="flex flex-wrap gap-2">
|
||||
<UButton
|
||||
v-for="tag in category.tags"
|
||||
:key="tag.id"
|
||||
size="sm"
|
||||
:color="isSelected(tag.id) ? 'primary' : 'gray'"
|
||||
:variant="isSelected(tag.id) ? 'solid' : 'outline'"
|
||||
@click="toggleTag(tag)"
|
||||
>
|
||||
<span v-if="tag.icon" class="mr-1">{{ tag.icon }}</span>
|
||||
{{ tag.name }}
|
||||
</UButton>
|
||||
</div>
|
||||
</div>
|
||||
|
||||
<!-- Loading State -->
|
||||
<div v-if="loading" class="text-center py-4">
|
||||
<div class="inline-block animate-spin rounded-full h-6 w-6 border-b-2 border-primary-500"></div>
|
||||
<p class="text-sm text-gray-500 mt-2">Loading tags...</p>
|
||||
</div>
|
||||
|
||||
<!-- Empty State (no tags available) -->
|
||||
<div v-if="!loading && availableTags.length === 0" class="text-center py-4">
|
||||
<p class="text-gray-500">No tags available</p>
|
||||
</div>
|
||||
</div>
|
||||
</template>
|
||||
|
||||
<script setup lang="ts">
|
||||
interface Tag {
|
||||
id: string
|
||||
name: string
|
||||
color: string
|
||||
icon?: string
|
||||
category: string
|
||||
}
|
||||
|
||||
const props = defineProps<{
|
||||
modelValue: Tag[]
|
||||
}>()
|
||||
|
||||
const emit = defineEmits<{
|
||||
'update:modelValue': [tags: Tag[]]
|
||||
}>()
|
||||
|
||||
const { getTags } = useTags()
|
||||
|
||||
const availableTags = ref<Tag[]>([])
|
||||
const loading = ref(true)
|
||||
|
||||
// Load tags on mount
|
||||
onMounted(async () => {
|
||||
const { data, error } = await getTags()
|
||||
if (data) {
|
||||
availableTags.value = data
|
||||
}
|
||||
loading.value = false
|
||||
})
|
||||
|
||||
// Computed
|
||||
const selectedTags = computed(() => props.modelValue)
|
||||
|
||||
const tagsByCategory = computed(() => {
|
||||
const grouped: Record<string, Tag[]> = {}
|
||||
|
||||
for (const tag of availableTags.value) {
|
||||
if (!grouped[tag.category]) {
|
||||
grouped[tag.category] = []
|
||||
}
|
||||
grouped[tag.category].push(tag)
|
||||
}
|
||||
|
||||
return Object.entries(grouped).map(([name, tags]) => ({
|
||||
name: name.charAt(0).toUpperCase() + name.slice(1),
|
||||
tags: tags.sort((a, b) => a.name.localeCompare(b.name))
|
||||
})).sort((a, b) => {
|
||||
// Position category first, then others alphabetically
|
||||
if (a.name === 'Position') return -1
|
||||
if (b.name === 'Position') return 1
|
||||
return a.name.localeCompare(b.name)
|
||||
})
|
||||
})
|
||||
|
||||
// Methods
|
||||
const isSelected = (tagId: string) => {
|
||||
return selectedTags.value.some(t => t.id === tagId)
|
||||
}
|
||||
|
||||
const toggleTag = (tag: Tag) => {
|
||||
const isCurrentlySelected = isSelected(tag.id)
|
||||
|
||||
if (isCurrentlySelected) {
|
||||
removeTag(tag.id)
|
||||
} else {
|
||||
emit('update:modelValue', [...selectedTags.value, tag])
|
||||
}
|
||||
}
|
||||
|
||||
const removeTag = (tagId: string) => {
|
||||
emit('update:modelValue', selectedTags.value.filter(t => t.id !== tagId))
|
||||
}
|
||||
</script>
|
||||
201
app/composables/useInventory.ts
Normal file
201
app/composables/useInventory.ts
Normal file
@@ -0,0 +1,201 @@
|
||||
import type { Database } from '~/types/database.types'
|
||||
|
||||
type InventoryItem = Database['public']['Tables']['inventory_items']['Row']
|
||||
type InventoryItemInsert = Database['public']['Tables']['inventory_items']['Insert']
|
||||
type InventoryItemUpdate = Database['public']['Tables']['inventory_items']['Update']
|
||||
|
||||
export const useInventory = () => {
|
||||
const supabase = useSupabase()
|
||||
const { user } = useSupabaseAuth()
|
||||
|
||||
/**
|
||||
* Get all inventory items with denormalized data
|
||||
*/
|
||||
const getInventory = async () => {
|
||||
const { data, error } = await supabase
|
||||
.from('inventory_items')
|
||||
.select(`
|
||||
*,
|
||||
product:products(*),
|
||||
unit:units(*),
|
||||
tags:item_tags(tag:tags(*))
|
||||
`)
|
||||
.order('created_at', { ascending: false })
|
||||
|
||||
if (error) {
|
||||
console.error('Error fetching inventory:', error)
|
||||
return { data: null, error }
|
||||
}
|
||||
|
||||
return { data, error: null }
|
||||
}
|
||||
|
||||
/**
|
||||
* Get single inventory item by ID
|
||||
*/
|
||||
const getInventoryItem = async (id: string) => {
|
||||
const { data, error } = await supabase
|
||||
.from('inventory_items')
|
||||
.select(`
|
||||
*,
|
||||
product:products(*),
|
||||
unit:units(*),
|
||||
tags:item_tags(tag:tags(*))
|
||||
`)
|
||||
.eq('id', id)
|
||||
.single()
|
||||
|
||||
if (error) {
|
||||
console.error('Error fetching item:', error)
|
||||
return { data: null, error }
|
||||
}
|
||||
|
||||
return { data, error: null }
|
||||
}
|
||||
|
||||
/**
|
||||
* Add new inventory item
|
||||
*/
|
||||
const addInventoryItem = async (item: Omit<InventoryItemInsert, 'added_by'>) => {
|
||||
if (!user.value) {
|
||||
return { data: null, error: { message: 'User not authenticated' } }
|
||||
}
|
||||
|
||||
const { data, error } = await supabase
|
||||
.from('inventory_items')
|
||||
.insert({
|
||||
...item,
|
||||
added_by: user.value.id
|
||||
})
|
||||
.select(`
|
||||
*,
|
||||
product:products(*),
|
||||
unit:units(*),
|
||||
tags:item_tags(tag:tags(*))
|
||||
`)
|
||||
.single()
|
||||
|
||||
if (error) {
|
||||
console.error('Error adding item:', error)
|
||||
return { data: null, error }
|
||||
}
|
||||
|
||||
return { data, error: null }
|
||||
}
|
||||
|
||||
/**
|
||||
* Update inventory item
|
||||
*/
|
||||
const updateInventoryItem = async (id: string, updates: InventoryItemUpdate) => {
|
||||
const { data, error } = await supabase
|
||||
.from('inventory_items')
|
||||
.update(updates)
|
||||
.eq('id', id)
|
||||
.select(`
|
||||
*,
|
||||
product:products(*),
|
||||
unit:units(*),
|
||||
tags:item_tags(tag:tags(*))
|
||||
`)
|
||||
.single()
|
||||
|
||||
if (error) {
|
||||
console.error('Error updating item:', error)
|
||||
return { data: null, error }
|
||||
}
|
||||
|
||||
return { data, error: null }
|
||||
}
|
||||
|
||||
/**
|
||||
* Delete inventory item
|
||||
*/
|
||||
const deleteInventoryItem = async (id: string) => {
|
||||
// First delete associated tags
|
||||
await supabase
|
||||
.from('item_tags')
|
||||
.delete()
|
||||
.eq('item_id', id)
|
||||
|
||||
const { error } = await supabase
|
||||
.from('inventory_items')
|
||||
.delete()
|
||||
.eq('id', id)
|
||||
|
||||
if (error) {
|
||||
console.error('Error deleting item:', error)
|
||||
return { error }
|
||||
}
|
||||
|
||||
return { error: null }
|
||||
}
|
||||
|
||||
/**
|
||||
* Update item quantity (consume or restock)
|
||||
*/
|
||||
const updateQuantity = async (id: string, change: number) => {
|
||||
const { data: item, error: fetchError } = await getInventoryItem(id)
|
||||
if (fetchError || !item) {
|
||||
return { data: null, error: fetchError }
|
||||
}
|
||||
|
||||
const newQuantity = Number(item.quantity) + change
|
||||
|
||||
if (newQuantity <= 0) {
|
||||
// Auto-delete when quantity reaches zero
|
||||
return await deleteInventoryItem(id)
|
||||
}
|
||||
|
||||
return await updateInventoryItem(id, { quantity: newQuantity })
|
||||
}
|
||||
|
||||
/**
|
||||
* Add tags to item
|
||||
*/
|
||||
const addItemTags = async (itemId: string, tagIds: string[]) => {
|
||||
const items = tagIds.map(tagId => ({
|
||||
item_id: itemId,
|
||||
tag_id: tagId
|
||||
}))
|
||||
|
||||
const { error } = await supabase
|
||||
.from('item_tags')
|
||||
.insert(items)
|
||||
|
||||
if (error) {
|
||||
console.error('Error adding tags:', error)
|
||||
return { error }
|
||||
}
|
||||
|
||||
return { error: null }
|
||||
}
|
||||
|
||||
/**
|
||||
* Remove tag from item
|
||||
*/
|
||||
const removeItemTag = async (itemId: string, tagId: string) => {
|
||||
const { error } = await supabase
|
||||
.from('item_tags')
|
||||
.delete()
|
||||
.eq('item_id', itemId)
|
||||
.eq('tag_id', tagId)
|
||||
|
||||
if (error) {
|
||||
console.error('Error removing tag:', error)
|
||||
return { error }
|
||||
}
|
||||
|
||||
return { error: null }
|
||||
}
|
||||
|
||||
return {
|
||||
getInventory,
|
||||
getInventoryItem,
|
||||
addInventoryItem,
|
||||
updateInventoryItem,
|
||||
deleteInventoryItem,
|
||||
updateQuantity,
|
||||
addItemTags,
|
||||
removeItemTag
|
||||
}
|
||||
}
|
||||
61
app/composables/useProductLookup.ts
Normal file
61
app/composables/useProductLookup.ts
Normal file
@@ -0,0 +1,61 @@
|
||||
// Composable for product lookup via Edge Function
|
||||
|
||||
export interface ProductData {
|
||||
barcode: string
|
||||
name: string
|
||||
brand?: string
|
||||
quantity?: string
|
||||
image_url?: string
|
||||
category?: string
|
||||
cached?: boolean
|
||||
}
|
||||
|
||||
export const useProductLookup = () => {
|
||||
const supabase = useSupabaseClient()
|
||||
const isLoading = ref(false)
|
||||
const error = ref<string | null>(null)
|
||||
|
||||
const lookupProduct = async (barcode: string): Promise<ProductData | null> => {
|
||||
isLoading.value = true
|
||||
error.value = null
|
||||
|
||||
try {
|
||||
const { data, error: functionError } = await supabase.functions.invoke('product-lookup', {
|
||||
body: { barcode }
|
||||
})
|
||||
|
||||
if (functionError) {
|
||||
console.error('Product lookup error:', functionError)
|
||||
error.value = functionError.message || 'Failed to lookup product'
|
||||
|
||||
// Return basic product data even on error
|
||||
return {
|
||||
barcode,
|
||||
name: `Product ${barcode}`,
|
||||
cached: false
|
||||
}
|
||||
}
|
||||
|
||||
return data as ProductData
|
||||
|
||||
} catch (err) {
|
||||
console.error('Unexpected error during product lookup:', err)
|
||||
error.value = err instanceof Error ? err.message : 'Unknown error'
|
||||
|
||||
// Return basic product data even on error
|
||||
return {
|
||||
barcode,
|
||||
name: `Product ${barcode}`,
|
||||
cached: false
|
||||
}
|
||||
} finally {
|
||||
isLoading.value = false
|
||||
}
|
||||
}
|
||||
|
||||
return {
|
||||
lookupProduct,
|
||||
isLoading: readonly(isLoading),
|
||||
error: readonly(error)
|
||||
}
|
||||
}
|
||||
44
app/composables/useTags.ts
Normal file
44
app/composables/useTags.ts
Normal file
@@ -0,0 +1,44 @@
|
||||
export const useTags = () => {
|
||||
const supabase = useSupabase()
|
||||
|
||||
/**
|
||||
* Get all tags
|
||||
*/
|
||||
const getTags = async () => {
|
||||
const { data, error } = await supabase
|
||||
.from('tags')
|
||||
.select('*')
|
||||
.order('category', { ascending: true })
|
||||
.order('name', { ascending: true })
|
||||
|
||||
if (error) {
|
||||
console.error('Error fetching tags:', error)
|
||||
return { data: null, error }
|
||||
}
|
||||
|
||||
return { data, error: null }
|
||||
}
|
||||
|
||||
/**
|
||||
* Get tags by category
|
||||
*/
|
||||
const getTagsByCategory = async (category: 'position' | 'type' | 'dietary' | 'custom') => {
|
||||
const { data, error } = await supabase
|
||||
.from('tags')
|
||||
.select('*')
|
||||
.eq('category', category)
|
||||
.order('name', { ascending: true })
|
||||
|
||||
if (error) {
|
||||
console.error('Error fetching tags by category:', error)
|
||||
return { data: null, error }
|
||||
}
|
||||
|
||||
return { data, error: null }
|
||||
}
|
||||
|
||||
return {
|
||||
getTags,
|
||||
getTagsByCategory
|
||||
}
|
||||
}
|
||||
53
app/composables/useUnits.ts
Normal file
53
app/composables/useUnits.ts
Normal file
@@ -0,0 +1,53 @@
|
||||
export const useUnits = () => {
|
||||
const supabase = useSupabase()
|
||||
|
||||
/**
|
||||
* Get all units
|
||||
*/
|
||||
const getUnits = async () => {
|
||||
const { data, error } = await supabase
|
||||
.from('units')
|
||||
.select('*')
|
||||
.order('unit_type', { ascending: true })
|
||||
.order('name', { ascending: true })
|
||||
|
||||
if (error) {
|
||||
console.error('Error fetching units:', error)
|
||||
return { data: null, error }
|
||||
}
|
||||
|
||||
return { data, error: null }
|
||||
}
|
||||
|
||||
/**
|
||||
* Get default unit for a type
|
||||
*/
|
||||
const getDefaultUnit = async (unitType: 'weight' | 'volume' | 'count' | 'custom') => {
|
||||
const { data, error } = await supabase
|
||||
.from('units')
|
||||
.select('*')
|
||||
.eq('unit_type', unitType)
|
||||
.eq('is_default', true)
|
||||
.single()
|
||||
|
||||
if (error) {
|
||||
console.error('Error fetching default unit:', error)
|
||||
return { data: null, error }
|
||||
}
|
||||
|
||||
return { data, error: null }
|
||||
}
|
||||
|
||||
/**
|
||||
* Convert quantity between units
|
||||
*/
|
||||
const convertUnit = (quantity: number, fromFactor: number, toFactor: number): number => {
|
||||
return (quantity * fromFactor) / toFactor
|
||||
}
|
||||
|
||||
return {
|
||||
getUnits,
|
||||
getDefaultUnit,
|
||||
convertUnit
|
||||
}
|
||||
}
|
||||
@@ -13,6 +13,7 @@
|
||||
"@nuxt/fonts": "^0.13.0",
|
||||
"@nuxt/ui": "^4.4.0",
|
||||
"@supabase/supabase-js": "^2.95.3",
|
||||
"html5-qrcode": "^2.3.8",
|
||||
"nuxt": "^4.3.1",
|
||||
"vue": "^3.5.28",
|
||||
"vue-router": "^4.6.4"
|
||||
|
||||
@@ -17,36 +17,38 @@
|
||||
color="white"
|
||||
size="lg"
|
||||
icon="i-heroicons-plus"
|
||||
@click="showAddForm = true"
|
||||
>
|
||||
Add Manually
|
||||
</UButton>
|
||||
</div>
|
||||
</div>
|
||||
|
||||
<!-- Empty State -->
|
||||
<UCard v-if="true">
|
||||
<div class="text-center py-12">
|
||||
<UIcon
|
||||
name="i-heroicons-inbox"
|
||||
class="w-16 h-16 text-gray-400 mx-auto mb-4"
|
||||
<!-- Add Item Form (Overlay) -->
|
||||
<div v-if="showAddForm" class="fixed inset-0 z-50 flex items-start justify-center pt-20 px-4 bg-black/50">
|
||||
<div class="w-full max-w-lg">
|
||||
<AddItemForm
|
||||
:initial-data="prefilledData"
|
||||
@close="handleCloseAddForm"
|
||||
@added="handleItemAdded"
|
||||
/>
|
||||
<h3 class="text-lg font-semibold text-gray-900 mb-2">
|
||||
No items yet
|
||||
</h3>
|
||||
<p class="text-gray-600 mb-6">
|
||||
Start by scanning a barcode or adding an item manually.
|
||||
</p>
|
||||
<UButton
|
||||
to="/scan"
|
||||
color="primary"
|
||||
icon="i-heroicons-qr-code"
|
||||
>
|
||||
Scan First Item
|
||||
</UButton>
|
||||
</div>
|
||||
</UCard>
|
||||
</div>
|
||||
|
||||
<!-- TODO: Item list will go here -->
|
||||
<!-- Edit Item Modal -->
|
||||
<EditItemModal
|
||||
:item="editingItem"
|
||||
@close="editingItem = null"
|
||||
@updated="handleItemUpdated"
|
||||
/>
|
||||
|
||||
<!-- Inventory List -->
|
||||
<InventoryList
|
||||
ref="inventoryListRef"
|
||||
:refresh="refreshKey"
|
||||
@add-item="showAddForm = true"
|
||||
@edit-item="editingItem = $event"
|
||||
/>
|
||||
</div>
|
||||
</template>
|
||||
|
||||
@@ -54,4 +56,49 @@
|
||||
definePageMeta({
|
||||
layout: 'default'
|
||||
})
|
||||
|
||||
const route = useRoute()
|
||||
const router = useRouter()
|
||||
|
||||
const showAddForm = ref(false)
|
||||
const editingItem = ref<any>(null)
|
||||
const refreshKey = ref(0)
|
||||
const inventoryListRef = ref()
|
||||
const prefilledData = ref<any>(null)
|
||||
|
||||
// Handle scan-to-add flow (Issue #25)
|
||||
onMounted(() => {
|
||||
if (route.query.action === 'add') {
|
||||
// Pre-fill data from query params (from scan)
|
||||
prefilledData.value = {
|
||||
barcode: route.query.barcode as string || undefined,
|
||||
name: route.query.name as string || undefined,
|
||||
brand: route.query.brand as string || undefined,
|
||||
image_url: route.query.image_url as string || undefined,
|
||||
quantity: route.query.quantity as string || undefined,
|
||||
}
|
||||
|
||||
showAddForm.value = true
|
||||
|
||||
// Clean up URL
|
||||
router.replace({ query: {} })
|
||||
}
|
||||
})
|
||||
|
||||
const handleCloseAddForm = () => {
|
||||
showAddForm.value = false
|
||||
prefilledData.value = null
|
||||
}
|
||||
|
||||
const handleItemAdded = (item: any) => {
|
||||
showAddForm.value = false
|
||||
prefilledData.value = null
|
||||
// Reload the inventory list
|
||||
inventoryListRef.value?.reload()
|
||||
}
|
||||
|
||||
const handleItemUpdated = (item: any) => {
|
||||
editingItem.value = null
|
||||
inventoryListRef.value?.reload()
|
||||
}
|
||||
</script>
|
||||
|
||||
@@ -2,25 +2,64 @@
|
||||
<div>
|
||||
<h1 class="text-3xl font-bold text-gray-900 mb-6">Scan Item</h1>
|
||||
|
||||
<UCard>
|
||||
<div class="text-center py-12">
|
||||
<UIcon
|
||||
name="i-heroicons-qr-code"
|
||||
class="w-16 h-16 text-gray-400 mx-auto mb-4"
|
||||
<UCard v-if="!scannedBarcode" class="mb-6">
|
||||
<ScanBarcodeScanner
|
||||
@barcode-detected="handleBarcodeDetected"
|
||||
@manual-entry="showManualEntry = true"
|
||||
/>
|
||||
<h3 class="text-lg font-semibold text-gray-900 mb-2">
|
||||
Barcode Scanner
|
||||
</h3>
|
||||
<p class="text-gray-600 mb-6">
|
||||
This feature will be implemented in Week 3.
|
||||
</p>
|
||||
</UCard>
|
||||
|
||||
<!-- Product Lookup Result -->
|
||||
<UCard v-if="productData" class="mb-6">
|
||||
<div class="space-y-4">
|
||||
<div class="flex items-start gap-4">
|
||||
<img
|
||||
v-if="productData.image_url"
|
||||
:src="productData.image_url"
|
||||
:alt="productData.name"
|
||||
class="w-24 h-24 object-cover rounded"
|
||||
/>
|
||||
<div class="flex-1">
|
||||
<h3 class="text-xl font-bold mb-1">{{ productData.name }}</h3>
|
||||
<p v-if="productData.brand" class="text-gray-600">{{ productData.brand }}</p>
|
||||
<p class="text-sm text-gray-500 mt-2">Barcode: {{ scannedBarcode }}</p>
|
||||
</div>
|
||||
</div>
|
||||
|
||||
<UAlert
|
||||
v-if="lookupError"
|
||||
color="yellow"
|
||||
icon="i-heroicons-exclamation-triangle"
|
||||
title="Product not found"
|
||||
:description="lookupError"
|
||||
/>
|
||||
|
||||
<div class="flex gap-2">
|
||||
<UButton
|
||||
to="/"
|
||||
color="gray"
|
||||
variant="soft"
|
||||
color="primary"
|
||||
size="lg"
|
||||
icon="i-heroicons-plus"
|
||||
class="flex-1"
|
||||
@click="addToInventory"
|
||||
>
|
||||
Back to Inventory
|
||||
Add to Inventory
|
||||
</UButton>
|
||||
<UButton
|
||||
color="gray"
|
||||
size="lg"
|
||||
@click="resetScanner"
|
||||
>
|
||||
Scan Again
|
||||
</UButton>
|
||||
</div>
|
||||
</div>
|
||||
</UCard>
|
||||
|
||||
<!-- Loading State -->
|
||||
<UCard v-if="isLookingUp">
|
||||
<div class="text-center py-8">
|
||||
<div class="inline-block animate-spin rounded-full h-12 w-12 border-b-2 border-primary-500 mb-4"></div>
|
||||
<p class="text-gray-600">Looking up product...</p>
|
||||
</div>
|
||||
</UCard>
|
||||
</div>
|
||||
@@ -30,4 +69,44 @@
|
||||
definePageMeta({
|
||||
layout: 'default'
|
||||
})
|
||||
|
||||
const scannedBarcode = ref<string | null>(null)
|
||||
const productData = ref<any>(null)
|
||||
const showManualEntry = ref(false)
|
||||
|
||||
// Use product lookup composable
|
||||
const { lookupProduct, isLoading: isLookingUp, error: lookupError } = useProductLookup()
|
||||
|
||||
const handleBarcodeDetected = async (barcode: string) => {
|
||||
scannedBarcode.value = barcode
|
||||
|
||||
// Fetch product data from Edge Function
|
||||
const data = await lookupProduct(barcode)
|
||||
|
||||
if (data) {
|
||||
productData.value = data
|
||||
}
|
||||
}
|
||||
|
||||
const addToInventory = () => {
|
||||
// Navigate to home page with add form open and pre-filled
|
||||
navigateTo({
|
||||
path: '/',
|
||||
query: {
|
||||
action: 'add',
|
||||
barcode: scannedBarcode.value,
|
||||
name: productData.value?.name || undefined,
|
||||
brand: productData.value?.brand || undefined,
|
||||
image_url: productData.value?.image_url || undefined,
|
||||
quantity: productData.value?.quantity || undefined
|
||||
}
|
||||
})
|
||||
}
|
||||
|
||||
const resetScanner = () => {
|
||||
scannedBarcode.value = null
|
||||
productData.value = null
|
||||
lookupError.value = null
|
||||
isLookingUp.value = false
|
||||
}
|
||||
</script>
|
||||
|
||||
42
dev.sh
Executable file
42
dev.sh
Executable file
@@ -0,0 +1,42 @@
|
||||
#!/bin/bash
|
||||
set -e
|
||||
|
||||
echo "🚀 Pantry - Starting Local Development Environment"
|
||||
echo ""
|
||||
|
||||
# Check prerequisites
|
||||
command -v docker >/dev/null 2>&1 || { echo "❌ Docker not found. Install: https://docs.docker.com/get-docker/"; exit 1; }
|
||||
command -v docker-compose >/dev/null 2>&1 || { echo "❌ Docker Compose not found. Install: https://docs.docker.com/compose/install/"; exit 1; }
|
||||
command -v bun >/dev/null 2>&1 || { echo "❌ Bun not found. Install: curl -fsSL https://bun.sh/install | bash"; exit 1; }
|
||||
|
||||
echo "✅ Prerequisites OK"
|
||||
echo ""
|
||||
|
||||
# Step 1: Start Supabase
|
||||
echo "📦 Starting Supabase services..."
|
||||
docker-compose up -d
|
||||
|
||||
echo "⏳ Waiting for services to initialize (15s)..."
|
||||
sleep 15
|
||||
|
||||
echo "✅ Supabase started:"
|
||||
echo " - API: http://localhost:54321"
|
||||
echo " - Studio: http://localhost:54323"
|
||||
echo ""
|
||||
|
||||
# Step 2: Install frontend dependencies
|
||||
echo "📦 Installing frontend dependencies..."
|
||||
cd app
|
||||
bun install
|
||||
|
||||
echo "✅ Dependencies installed"
|
||||
echo ""
|
||||
|
||||
# Step 3: Start dev server
|
||||
echo "🚀 Starting Nuxt dev server..."
|
||||
echo " App will be available at: http://localhost:3000"
|
||||
echo ""
|
||||
echo "Press Ctrl+C to stop"
|
||||
echo ""
|
||||
|
||||
bun run dev
|
||||
127
docker-compose.yml
Normal file
127
docker-compose.yml
Normal file
@@ -0,0 +1,127 @@
|
||||
version: '3.8'
|
||||
|
||||
services:
|
||||
# PostgreSQL Database
|
||||
db:
|
||||
image: supabase/postgres:15.1.0.147
|
||||
restart: unless-stopped
|
||||
ports:
|
||||
- "5432:5432"
|
||||
environment:
|
||||
POSTGRES_PASSWORD: ${POSTGRES_PASSWORD:-postgres}
|
||||
POSTGRES_DB: postgres
|
||||
volumes:
|
||||
- db-data:/var/lib/postgresql/data
|
||||
- ./supabase/migrations:/docker-entrypoint-initdb.d:ro
|
||||
|
||||
# Supabase Studio (Admin UI)
|
||||
studio:
|
||||
image: supabase/studio:20231123-64a766a
|
||||
restart: unless-stopped
|
||||
ports:
|
||||
- "54323:3000"
|
||||
environment:
|
||||
SUPABASE_URL: http://kong:8000
|
||||
SUPABASE_PUBLIC_URL: http://localhost:54321
|
||||
SUPABASE_ANON_KEY: ${ANON_KEY}
|
||||
SUPABASE_SERVICE_KEY: ${SERVICE_ROLE_KEY}
|
||||
|
||||
# Kong API Gateway
|
||||
kong:
|
||||
image: kong:2.8.1
|
||||
restart: unless-stopped
|
||||
ports:
|
||||
- "54321:8000"
|
||||
- "54320:8443"
|
||||
environment:
|
||||
KONG_DATABASE: "off"
|
||||
KONG_DECLARATIVE_CONFIG: /var/lib/kong/kong.yml
|
||||
KONG_DNS_ORDER: LAST,A,CNAME
|
||||
KONG_PLUGINS: request-transformer,cors,key-auth,acl
|
||||
volumes:
|
||||
- ./docker/kong.yml:/var/lib/kong/kong.yml:ro
|
||||
|
||||
# GoTrue (Auth)
|
||||
auth:
|
||||
image: supabase/gotrue:v2.99.0
|
||||
restart: unless-stopped
|
||||
depends_on:
|
||||
- db
|
||||
environment:
|
||||
GOTRUE_API_HOST: 0.0.0.0
|
||||
GOTRUE_API_PORT: 9999
|
||||
API_EXTERNAL_URL: http://localhost:54321
|
||||
GOTRUE_DB_DRIVER: postgres
|
||||
GOTRUE_DB_DATABASE_URL: postgres://supabase_auth_admin:${POSTGRES_PASSWORD:-postgres}@db:5432/postgres
|
||||
GOTRUE_SITE_URL: http://localhost:3000
|
||||
GOTRUE_URI_ALLOW_LIST: "*"
|
||||
GOTRUE_DISABLE_SIGNUP: false
|
||||
GOTRUE_JWT_ADMIN_ROLES: service_role
|
||||
GOTRUE_JWT_AUD: authenticated
|
||||
GOTRUE_JWT_DEFAULT_GROUP_NAME: authenticated
|
||||
GOTRUE_JWT_EXP: 3600
|
||||
GOTRUE_JWT_SECRET: ${JWT_SECRET}
|
||||
GOTRUE_EXTERNAL_EMAIL_ENABLED: true
|
||||
GOTRUE_MAILER_AUTOCONFIRM: true
|
||||
|
||||
# PostgREST (Auto API)
|
||||
rest:
|
||||
image: postgrest/postgrest:v11.2.0
|
||||
restart: unless-stopped
|
||||
depends_on:
|
||||
- db
|
||||
environment:
|
||||
PGRST_DB_URI: postgres://authenticator:${POSTGRES_PASSWORD:-postgres}@db:5432/postgres
|
||||
PGRST_DB_SCHEMAS: public,storage
|
||||
PGRST_DB_ANON_ROLE: anon
|
||||
PGRST_JWT_SECRET: ${JWT_SECRET}
|
||||
PGRST_DB_USE_LEGACY_GUCS: "false"
|
||||
|
||||
# Realtime
|
||||
realtime:
|
||||
image: supabase/realtime:v2.25.35
|
||||
restart: unless-stopped
|
||||
depends_on:
|
||||
- db
|
||||
environment:
|
||||
PORT: 4000
|
||||
DB_HOST: db
|
||||
DB_PORT: 5432
|
||||
DB_USER: supabase_admin
|
||||
DB_PASSWORD: ${POSTGRES_PASSWORD:-postgres}
|
||||
DB_NAME: postgres
|
||||
DB_AFTER_CONNECT_QUERY: 'SET search_path TO _realtime'
|
||||
DB_ENC_KEY: supabaserealtime
|
||||
API_JWT_SECRET: ${JWT_SECRET}
|
||||
FLY_ALLOC_ID: fly123
|
||||
FLY_APP_NAME: realtime
|
||||
SECRET_KEY_BASE: ${JWT_SECRET}
|
||||
ERL_AFLAGS: -proto_dist inet_tcp
|
||||
ENABLE_TAILSCALE: "false"
|
||||
DNS_NODES: "''"
|
||||
|
||||
# Storage (S3-compatible)
|
||||
storage:
|
||||
image: supabase/storage-api:v0.40.4
|
||||
restart: unless-stopped
|
||||
depends_on:
|
||||
- db
|
||||
- rest
|
||||
environment:
|
||||
ANON_KEY: ${ANON_KEY}
|
||||
SERVICE_KEY: ${SERVICE_ROLE_KEY}
|
||||
POSTGREST_URL: http://rest:3000
|
||||
PGRST_JWT_SECRET: ${JWT_SECRET}
|
||||
DATABASE_URL: postgres://supabase_storage_admin:${POSTGRES_PASSWORD:-postgres}@db:5432/postgres
|
||||
FILE_SIZE_LIMIT: 52428800
|
||||
STORAGE_BACKEND: file
|
||||
FILE_STORAGE_BACKEND_PATH: /var/lib/storage
|
||||
TENANT_ID: stub
|
||||
REGION: stub
|
||||
GLOBAL_S3_BUCKET: stub
|
||||
volumes:
|
||||
- storage-data:/var/lib/storage
|
||||
|
||||
volumes:
|
||||
db-data:
|
||||
storage-data:
|
||||
85
docker/kong.yml
Normal file
85
docker/kong.yml
Normal file
@@ -0,0 +1,85 @@
|
||||
_format_version: "2.1"
|
||||
|
||||
_transform: true
|
||||
|
||||
services:
|
||||
- name: auth
|
||||
url: http://auth:9999
|
||||
routes:
|
||||
- name: auth-v1
|
||||
strip_path: true
|
||||
paths:
|
||||
- /auth/v1
|
||||
plugins:
|
||||
- name: cors
|
||||
- name: key-auth
|
||||
config:
|
||||
hide_credentials: true
|
||||
|
||||
- name: rest
|
||||
url: http://rest:3000
|
||||
routes:
|
||||
- name: rest-v1
|
||||
strip_path: true
|
||||
paths:
|
||||
- /rest/v1
|
||||
plugins:
|
||||
- name: cors
|
||||
- name: key-auth
|
||||
config:
|
||||
hide_credentials: true
|
||||
|
||||
- name: realtime
|
||||
url: http://realtime:4000/socket
|
||||
routes:
|
||||
- name: realtime-v1
|
||||
strip_path: true
|
||||
paths:
|
||||
- /realtime/v1
|
||||
plugins:
|
||||
- name: cors
|
||||
- name: key-auth
|
||||
config:
|
||||
hide_credentials: true
|
||||
|
||||
- name: storage
|
||||
url: http://storage:5000
|
||||
routes:
|
||||
- name: storage-v1
|
||||
strip_path: true
|
||||
paths:
|
||||
- /storage/v1
|
||||
plugins:
|
||||
- name: cors
|
||||
|
||||
consumers:
|
||||
- username: anon
|
||||
keyauth_credentials:
|
||||
- key: ${ANON_KEY}
|
||||
- username: service_role
|
||||
keyauth_credentials:
|
||||
- key: ${SERVICE_ROLE_KEY}
|
||||
|
||||
plugins:
|
||||
- name: cors
|
||||
config:
|
||||
origins:
|
||||
- "*"
|
||||
methods:
|
||||
- GET
|
||||
- POST
|
||||
- PUT
|
||||
- PATCH
|
||||
- DELETE
|
||||
- OPTIONS
|
||||
headers:
|
||||
- Accept
|
||||
- Accept-Encoding
|
||||
- Authorization
|
||||
- Content-Type
|
||||
- Origin
|
||||
- X-Client-Info
|
||||
exposed_headers:
|
||||
- X-Total-Count
|
||||
credentials: true
|
||||
max_age: 3600
|
||||
84
docs/README.md
Normal file
84
docs/README.md
Normal file
@@ -0,0 +1,84 @@
|
||||
# Pantry Documentation
|
||||
|
||||
Complete documentation for the Pantry household inventory management system.
|
||||
|
||||
## 📚 Documentation Structure
|
||||
|
||||
### 🚀 Getting Started
|
||||
|
||||
- **[Project Overview](PROJECT_PLAN.md)** - Vision, roadmap, and MVP phases
|
||||
- **[Local Setup Guide](development/local-setup.md)** - Docker Compose development environment
|
||||
- **[Getting Started](development/getting-started.md)** - Quick start for new developers
|
||||
|
||||
### 🏗️ Architecture
|
||||
|
||||
- **[Architecture Overview](architecture/overview.md)** - Tech stack, design decisions, data flow
|
||||
- **[Database Schema](architecture/database.md)** - Tables, relationships, RLS policies, migrations
|
||||
- **[API Reference](architecture/api.md)** - Supabase endpoints, Edge Functions, helpers
|
||||
|
||||
### 💻 Development
|
||||
|
||||
- **[Development Workflow](development/workflow.md)** - Daily workflow, conventions, best practices
|
||||
- **[Git Workflow](development/git-workflow.md)** - Branching strategy, PR process, reviews
|
||||
|
||||
### 🚢 Deployment
|
||||
|
||||
- **[Production Deployment](deployment/production.md)** - Docker, Coolify, environment setup
|
||||
- **[CI/CD Pipeline](deployment/ci-cd.md)** - Automated testing, builds, deployments
|
||||
|
||||
---
|
||||
|
||||
## 🎯 Quick Links by Role
|
||||
|
||||
### New Developer
|
||||
1. [Local Setup Guide](development/local-setup.md) - Get running in 5 minutes
|
||||
2. [Architecture Overview](architecture/overview.md) - Understand the stack
|
||||
3. [Development Workflow](development/workflow.md) - Daily development process
|
||||
|
||||
### Feature Implementation
|
||||
1. [Database Schema](architecture/database.md) - Table structure and queries
|
||||
2. [API Reference](architecture/api.md) - Available endpoints
|
||||
3. [Git Workflow](development/git-workflow.md) - Branch naming, PR checklist
|
||||
|
||||
### Deployment & Operations
|
||||
1. [Production Deployment](deployment/production.md) - Deploy to production
|
||||
2. [CI/CD Pipeline](deployment/ci-cd.md) - Automated workflows
|
||||
|
||||
---
|
||||
|
||||
## 📊 Current Status
|
||||
|
||||
**MVP Progress:** 14/34 issues complete (41.2%)
|
||||
|
||||
- ✅ Week 1: Database + Frontend Foundation (6/6)
|
||||
- ✅ Week 2: Core Inventory Management (8/8)
|
||||
- 🔄 Week 3: Barcode Scanning (1/5)
|
||||
- ⏸️ Week 4-6: Tag UI, PWA, Deployment (20 remaining)
|
||||
|
||||
See [PROJECT_PLAN.md](PROJECT_PLAN.md) for detailed roadmap.
|
||||
|
||||
---
|
||||
|
||||
## 🤝 Contributing
|
||||
|
||||
For contribution guidelines, see [Development Workflow](development/workflow.md).
|
||||
|
||||
Key points:
|
||||
- Feature branches off `develop`
|
||||
- PRs require review before merge
|
||||
- Follow conventional commits
|
||||
- Write tests for new features
|
||||
|
||||
---
|
||||
|
||||
## 🔗 External Resources
|
||||
|
||||
- **Repository:** https://gitea.jeanlucmakiola.de/pantry-app/pantry
|
||||
- **Supabase Docs:** https://supabase.com/docs
|
||||
- **Nuxt 4 Docs:** https://nuxt.com
|
||||
- **Open Food Facts API:** https://wiki.openfoodfacts.org/API
|
||||
|
||||
---
|
||||
|
||||
**Last Updated:** 2026-02-09
|
||||
**Version:** 0.1.0-alpha (MVP in progress)
|
||||
189
docs/development/getting-started.md
Normal file
189
docs/development/getting-started.md
Normal file
@@ -0,0 +1,189 @@
|
||||
# Getting Started with Pantry Development
|
||||
|
||||
Welcome! This guide will get you from zero to running Pantry locally in ~5 minutes.
|
||||
|
||||
## 🎯 What You'll Build
|
||||
|
||||
A self-hosted kitchen inventory app with:
|
||||
- Inventory management (add, edit, delete items)
|
||||
- Tag-based organization (Fridge, Freezer, Dairy, etc.)
|
||||
- Unit conversions (g, kg, L, cups)
|
||||
- Barcode scanning (coming soon)
|
||||
- PWA features (offline, installable)
|
||||
|
||||
## ⚡ Quick Start
|
||||
|
||||
### Prerequisites
|
||||
|
||||
- **Docker** & **Docker Compose** - [Install](https://docs.docker.com/get-docker/)
|
||||
- **Bun** - [Install](https://bun.sh): `curl -fsSL https://bun.sh/install | bash`
|
||||
- **Git**
|
||||
|
||||
### One-Command Setup
|
||||
|
||||
```bash
|
||||
# Clone the repo
|
||||
git clone https://gitea.jeanlucmakiola.de/pantry-app/pantry.git
|
||||
cd pantry
|
||||
|
||||
# Run the setup script
|
||||
./dev.sh
|
||||
```
|
||||
|
||||
That's it! The script will:
|
||||
1. ✅ Start Supabase services (Docker Compose)
|
||||
2. ✅ Wait for services to initialize
|
||||
3. ✅ Install frontend dependencies
|
||||
4. ✅ Launch Nuxt dev server
|
||||
|
||||
### Access the App
|
||||
|
||||
| Service | URL | Purpose |
|
||||
|---------|-----|---------|
|
||||
| **App** | `http://localhost:3000` | Main frontend |
|
||||
| **Supabase Studio** | `http://localhost:54323` | Database admin UI |
|
||||
| **API** | `http://localhost:54321` | Backend API |
|
||||
|
||||
## 🎮 Try It Out
|
||||
|
||||
1. Open `http://localhost:3000`
|
||||
2. Click **"Add Manually"** to create your first item
|
||||
3. Fill in:
|
||||
- Name: "Milk"
|
||||
- Quantity: 1
|
||||
- Unit: Liter
|
||||
- Tags: Fridge, Dairy
|
||||
- Expiry: Set a date
|
||||
4. Click **"Add Item"** and see it in the grid!
|
||||
|
||||
### Explore Features
|
||||
|
||||
- **Edit item:** Click "Edit" on any card
|
||||
- **Adjust quantity:** Use +/- buttons
|
||||
- **Delete item:** Click "Delete" (confirms first)
|
||||
- **View database:** Open Supabase Studio at `:54323`
|
||||
|
||||
## 📁 Project Structure
|
||||
|
||||
```
|
||||
pantry/
|
||||
├── app/ # Nuxt 4 frontend
|
||||
│ ├── components/ # Vue components
|
||||
│ │ └── inventory/ # Inventory UI (List, Card, Forms)
|
||||
│ ├── composables/ # Data hooks (useInventory, useSupabase)
|
||||
│ ├── pages/ # Routes (index, scan, settings)
|
||||
│ └── types/ # TypeScript definitions
|
||||
├── supabase/
|
||||
│ └── migrations/ # Database schema (001-005)
|
||||
├── docker-compose.yml # Supabase services
|
||||
├── docker/
|
||||
│ └── kong.yml # API gateway config
|
||||
└── docs/ # Documentation
|
||||
```
|
||||
|
||||
## 🛠️ Common Tasks
|
||||
|
||||
### View Logs
|
||||
|
||||
```bash
|
||||
# All services
|
||||
docker-compose logs -f
|
||||
|
||||
# Just the database
|
||||
docker-compose logs -f db
|
||||
```
|
||||
|
||||
### Reset Database
|
||||
|
||||
```bash
|
||||
# Stop and remove volumes (fresh start)
|
||||
docker-compose down -v
|
||||
|
||||
# Restart (migrations auto-apply)
|
||||
docker-compose up -d
|
||||
```
|
||||
|
||||
### Access Database Directly
|
||||
|
||||
```bash
|
||||
# psql CLI
|
||||
docker-compose exec db psql -U postgres -d postgres
|
||||
|
||||
# Or use Supabase Studio (GUI)
|
||||
open http://localhost:54323
|
||||
```
|
||||
|
||||
### Stop Everything
|
||||
|
||||
```bash
|
||||
# Stop services (keep data)
|
||||
docker-compose stop
|
||||
|
||||
# Stop and remove everything
|
||||
docker-compose down -v
|
||||
```
|
||||
|
||||
## 🔍 What's Included
|
||||
|
||||
### Database (Pre-seeded)
|
||||
|
||||
**30 Units:**
|
||||
- Weight: g, kg, mg, lb, oz
|
||||
- Volume: mL, L, cup, tbsp, tsp
|
||||
- Count: piece, dozen, bottle, can, jar
|
||||
|
||||
**33 Tags:**
|
||||
- Position: Fridge, Freezer, Pantry
|
||||
- Type: Dairy, Meat, Vegetables, Fruits
|
||||
- Dietary: Vegan, Gluten-Free, Organic
|
||||
- Custom: Low Stock, To Buy, Meal Prep
|
||||
|
||||
### Features (Working Now)
|
||||
|
||||
- ✅ Add/Edit/Delete inventory items
|
||||
- ✅ Tag selection (multi-select)
|
||||
- ✅ Unit conversions
|
||||
- ✅ Expiry date tracking with warnings
|
||||
- ✅ Responsive layout (mobile-ready)
|
||||
- ✅ Quantity quick actions (+/- buttons)
|
||||
|
||||
### Features (Coming Soon)
|
||||
|
||||
- ⏳ Barcode scanning (Week 3)
|
||||
- ⏳ User authentication UI
|
||||
- ⏳ Tag management
|
||||
- ⏳ PWA (offline mode)
|
||||
|
||||
## 📚 Next Steps
|
||||
|
||||
### Learn the Stack
|
||||
|
||||
1. **[Architecture Overview](../architecture/overview.md)** - Tech stack and design decisions
|
||||
2. **[Database Schema](../architecture/database.md)** - Tables and relationships
|
||||
3. **[Development Workflow](workflow.md)** - Daily development process
|
||||
|
||||
### Make Your First Change
|
||||
|
||||
1. Pick an issue from Gitea
|
||||
2. Create a branch: `git checkout -b feature/your-feature`
|
||||
3. Make changes, test locally
|
||||
4. Commit: `git commit -m "feat: your feature"`
|
||||
5. Push and create PR
|
||||
|
||||
### Troubleshooting
|
||||
|
||||
See **[Local Setup Guide](local-setup.md)** for:
|
||||
- Port conflicts
|
||||
- Database connection issues
|
||||
- Frontend errors
|
||||
- Environment variables
|
||||
|
||||
## 🤝 Need Help?
|
||||
|
||||
- **Documentation:** Browse `/docs` folder
|
||||
- **Issues:** Create an issue on Gitea
|
||||
- **Local setup:** See [local-setup.md](local-setup.md)
|
||||
|
||||
---
|
||||
|
||||
**Ready to code?** Check out the [Development Workflow](workflow.md)!
|
||||
335
docs/development/local-setup.md
Normal file
335
docs/development/local-setup.md
Normal file
@@ -0,0 +1,335 @@
|
||||
# Pantry - Local Development Setup
|
||||
|
||||
Self-hosted household pantry management app with barcode scanning.
|
||||
|
||||
## 🚀 Quick Start
|
||||
|
||||
### Prerequisites
|
||||
|
||||
- **Docker** & **Docker Compose** (for Supabase backend)
|
||||
- **Bun** (for Nuxt frontend) - Install: `curl -fsSL https://bun.sh/install | bash`
|
||||
- **Git**
|
||||
|
||||
### 1. Clone & Setup
|
||||
|
||||
```bash
|
||||
git clone https://gitea.jeanlucmakiola.de/pantry-app/pantry.git
|
||||
cd pantry
|
||||
```
|
||||
|
||||
### 2. Start Supabase (Backend)
|
||||
|
||||
```bash
|
||||
# Start all Supabase services
|
||||
docker-compose up -d
|
||||
|
||||
# Wait ~10 seconds for services to initialize
|
||||
# Check status
|
||||
docker-compose ps
|
||||
```
|
||||
|
||||
**Services running:**
|
||||
- PostgreSQL: `localhost:5432`
|
||||
- Supabase API: `http://localhost:54321`
|
||||
- Supabase Studio: `http://localhost:54323` (admin UI)
|
||||
|
||||
### 3. Apply Database Migrations
|
||||
|
||||
The migrations are automatically applied on first startup via `/docker-entrypoint-initdb.d`.
|
||||
|
||||
To verify:
|
||||
```bash
|
||||
docker-compose exec db psql -U postgres -d postgres -c "\dt"
|
||||
```
|
||||
|
||||
You should see: `inventory_items`, `products`, `tags`, `units`, `item_tags`
|
||||
|
||||
### 4. Start Nuxt App (Frontend)
|
||||
|
||||
```bash
|
||||
cd app
|
||||
bun install
|
||||
bun run dev
|
||||
```
|
||||
|
||||
**App running:** `http://localhost:3000`
|
||||
|
||||
### 5. Open & Test
|
||||
|
||||
1. Visit `http://localhost:3000`
|
||||
2. Click "Add Manually" to create your first inventory item
|
||||
3. Access Supabase Studio at `http://localhost:54323` to view database
|
||||
|
||||
---
|
||||
|
||||
## 📁 Project Structure
|
||||
|
||||
```
|
||||
pantry/
|
||||
├── app/ # Nuxt 4 frontend
|
||||
│ ├── components/ # Vue components
|
||||
│ │ └── inventory/ # Inventory CRUD UI
|
||||
│ ├── composables/ # Supabase client, data hooks
|
||||
│ ├── pages/ # Routes (index, scan, settings)
|
||||
│ └── types/ # TypeScript definitions
|
||||
├── supabase/
|
||||
│ └── migrations/ # SQL schema & seed data
|
||||
├── docker/
|
||||
│ └── kong.yml # API gateway config
|
||||
├── docker-compose.yml # Supabase services
|
||||
└── .env # Environment variables
|
||||
```
|
||||
|
||||
---
|
||||
|
||||
## 🔧 Common Tasks
|
||||
|
||||
### View Logs
|
||||
|
||||
```bash
|
||||
# All services
|
||||
docker-compose logs -f
|
||||
|
||||
# Specific service
|
||||
docker-compose logs -f db
|
||||
docker-compose logs -f auth
|
||||
```
|
||||
|
||||
### Reset Database
|
||||
|
||||
```bash
|
||||
# Stop services
|
||||
docker-compose down -v
|
||||
|
||||
# Restart (migrations auto-apply)
|
||||
docker-compose up -d
|
||||
```
|
||||
|
||||
### Access Database
|
||||
|
||||
```bash
|
||||
# psql
|
||||
docker-compose exec db psql -U postgres -d postgres
|
||||
|
||||
# Supabase Studio (GUI)
|
||||
# http://localhost:54323
|
||||
```
|
||||
|
||||
### Run Migrations Manually
|
||||
|
||||
```bash
|
||||
# If you add new migrations after initial setup
|
||||
docker-compose exec db psql -U postgres -d postgres -f /docker-entrypoint-initdb.d/003_helper_functions.sql
|
||||
```
|
||||
|
||||
### Create Test User
|
||||
|
||||
```bash
|
||||
# Via Supabase Studio: http://localhost:54323
|
||||
# → Authentication → Add User
|
||||
# Email: test@example.com
|
||||
# Password: password123
|
||||
|
||||
# Or via curl:
|
||||
curl http://localhost:54321/auth/v1/signup \
|
||||
-H "apikey: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9..." \
|
||||
-H "Content-Type: application/json" \
|
||||
-d '{"email":"test@example.com","password":"password123"}'
|
||||
```
|
||||
|
||||
---
|
||||
|
||||
## 🧪 Testing Features
|
||||
|
||||
### 1. Inventory Management
|
||||
- Add items manually via form
|
||||
- Edit quantities with +/- buttons
|
||||
- Delete items
|
||||
- View expiry warnings
|
||||
|
||||
### 2. Tags & Organization
|
||||
- Pre-seeded tags: Fridge, Freezer, Pantry, Dairy, Vegan, etc.
|
||||
- Multi-select tags when adding items
|
||||
- Color-coded badges
|
||||
|
||||
### 3. Units
|
||||
- 30 pre-seeded units (g, kg, L, cups, pieces, etc.)
|
||||
- Automatic conversion support
|
||||
|
||||
### 4. Barcode Scanning (Week 3 - In Progress)
|
||||
- Camera access (requires HTTPS in production)
|
||||
- Manual barcode entry fallback
|
||||
|
||||
---
|
||||
|
||||
## 🐛 Troubleshooting
|
||||
|
||||
### Port Conflicts
|
||||
|
||||
If ports 5432, 54321, or 3000 are in use:
|
||||
|
||||
```bash
|
||||
# Check what's using the port
|
||||
sudo lsof -i :5432
|
||||
|
||||
# Option 1: Stop conflicting service
|
||||
# Option 2: Change port in docker-compose.yml
|
||||
```
|
||||
|
||||
### Database Connection Refused
|
||||
|
||||
```bash
|
||||
# Wait for PostgreSQL to fully start
|
||||
docker-compose logs db | grep "ready to accept connections"
|
||||
|
||||
# If stuck, restart
|
||||
docker-compose restart db
|
||||
```
|
||||
|
||||
### Migrations Not Applied
|
||||
|
||||
```bash
|
||||
# Verify migrations directory is mounted
|
||||
docker-compose exec db ls -la /docker-entrypoint-initdb.d
|
||||
|
||||
# Manually apply
|
||||
docker-compose exec db bash
|
||||
cd /docker-entrypoint-initdb.d
|
||||
for f in *.sql; do psql -U postgres -d postgres -f "$f"; done
|
||||
```
|
||||
|
||||
### Frontend: Module Not Found
|
||||
|
||||
```bash
|
||||
cd app
|
||||
rm -rf node_modules bun.lock .nuxt
|
||||
bun install
|
||||
bun run dev
|
||||
```
|
||||
|
||||
---
|
||||
|
||||
## 📊 Database Schema
|
||||
|
||||
### Tables
|
||||
|
||||
| Table | Purpose | Rows (Est.) |
|
||||
|-------|---------|-------------|
|
||||
| `inventory_items` | Current inventory | 100-500 |
|
||||
| `products` | Barcode cache (Open Food Facts) | 500-2000 |
|
||||
| `tags` | Organization labels | 50 (33 pre-seeded) |
|
||||
| `units` | Measurement units | 50 (30 pre-seeded) |
|
||||
| `item_tags` | Many-to-many item ↔ tag | 200-1000 |
|
||||
|
||||
### Pre-Seeded Data
|
||||
|
||||
**Units (30):**
|
||||
- Weight: g, kg, mg, lb, oz
|
||||
- Volume: mL, L, cup, tbsp, tsp, gal, qt, pt
|
||||
- Count: piece, dozen, package, bottle, can, jar, box, bag
|
||||
|
||||
**Tags (33):**
|
||||
- Position: Fridge, Freezer, Pantry, Cabinet
|
||||
- Type: Dairy, Meat, Vegetables, Fruits, Snacks
|
||||
- Dietary: Vegan, Gluten-Free, Organic, Kosher, Halal
|
||||
- Custom: Low Stock, To Buy, Meal Prep, Leftovers
|
||||
|
||||
---
|
||||
|
||||
## 🔐 Authentication
|
||||
|
||||
**Default Setup (Development):**
|
||||
- Auto-confirm emails (no SMTP needed)
|
||||
- Anyone can sign up
|
||||
- JWT tokens valid for 1 hour
|
||||
|
||||
**Create Admin User:**
|
||||
|
||||
```sql
|
||||
-- Via psql
|
||||
docker-compose exec db psql -U postgres -d postgres
|
||||
|
||||
INSERT INTO auth.users (id, email, encrypted_password, email_confirmed_at)
|
||||
VALUES (
|
||||
gen_random_uuid(),
|
||||
'admin@pantry.local',
|
||||
crypt('admin123', gen_salt('bf')),
|
||||
NOW()
|
||||
);
|
||||
```
|
||||
|
||||
---
|
||||
|
||||
## 🌐 Environment Variables
|
||||
|
||||
**.env** (root)
|
||||
```bash
|
||||
POSTGRES_PASSWORD=postgres
|
||||
JWT_SECRET=your-secret-here
|
||||
ANON_KEY=<supabase-anon-key>
|
||||
SERVICE_ROLE_KEY=<supabase-service-role-key>
|
||||
```
|
||||
|
||||
**app/.env** (Nuxt)
|
||||
```bash
|
||||
NUXT_PUBLIC_SUPABASE_URL=http://localhost:54321
|
||||
NUXT_PUBLIC_SUPABASE_ANON_KEY=<same-as-above>
|
||||
```
|
||||
|
||||
---
|
||||
|
||||
## 📈 Development Workflow
|
||||
|
||||
1. **Make changes** to Nuxt app → Hot reload at `localhost:3000`
|
||||
2. **Database changes** → Create new migration in `supabase/migrations/`
|
||||
3. **Test** → Add items, scan barcodes, check database
|
||||
4. **Commit** → Feature branch → PR to `develop`
|
||||
|
||||
---
|
||||
|
||||
## 🚢 Production Deployment (Coming Soon)
|
||||
|
||||
See `docs/DEPLOYMENT.md` for:
|
||||
- Coolify setup
|
||||
- Environment configuration
|
||||
- SSL/HTTPS setup
|
||||
- Backups
|
||||
|
||||
---
|
||||
|
||||
## 📚 Documentation
|
||||
|
||||
- [Architecture](docs/ARCHITECTURE.md)
|
||||
- [Database Schema](docs/DATABASE.md)
|
||||
- [API Reference](docs/API.md)
|
||||
- [Development Guide](docs/DEVELOPMENT.md)
|
||||
|
||||
---
|
||||
|
||||
## 🤝 Contributing
|
||||
|
||||
This is a personal project, but issues and PRs welcome!
|
||||
|
||||
1. Fork the repo
|
||||
2. Create feature branch (`git checkout -b feature/amazing-feature`)
|
||||
3. Commit changes (`git commit -m 'Add amazing feature'`)
|
||||
4. Push to branch (`git push origin feature/amazing-feature`)
|
||||
5. Open Pull Request
|
||||
|
||||
---
|
||||
|
||||
## 📝 License
|
||||
|
||||
MIT License - See LICENSE file
|
||||
|
||||
---
|
||||
|
||||
## 🙋 Support
|
||||
|
||||
- Issues: https://gitea.jeanlucmakiola.de/pantry-app/pantry/issues
|
||||
- Docs: https://gitea.jeanlucmakiola.de/pantry-app/pantry/wiki
|
||||
|
||||
---
|
||||
|
||||
**Version:** 0.1.0-alpha (MVP in progress)
|
||||
**Status:** Week 2 complete, Week 3 in progress (14/34 issues done)
|
||||
83
supabase/functions/product-lookup/README.md
Normal file
83
supabase/functions/product-lookup/README.md
Normal file
@@ -0,0 +1,83 @@
|
||||
# Product Lookup Edge Function
|
||||
|
||||
Fetches product data from Open Food Facts API by barcode and caches results in the database.
|
||||
|
||||
## Endpoint
|
||||
|
||||
`POST /functions/v1/product-lookup`
|
||||
|
||||
## Request
|
||||
|
||||
```json
|
||||
{
|
||||
"barcode": "8000500310427"
|
||||
}
|
||||
```
|
||||
|
||||
## Response
|
||||
|
||||
### Success (200)
|
||||
|
||||
```json
|
||||
{
|
||||
"barcode": "8000500310427",
|
||||
"name": "Nutella",
|
||||
"brand": "Ferrero",
|
||||
"quantity": "750g",
|
||||
"image_url": "https://...",
|
||||
"category": "spreads",
|
||||
"cached": false
|
||||
}
|
||||
```
|
||||
|
||||
### Not Found (404)
|
||||
|
||||
```json
|
||||
{
|
||||
"barcode": "1234567890123",
|
||||
"name": "Unknown Product (1234567890123)",
|
||||
"cached": false
|
||||
}
|
||||
```
|
||||
|
||||
### Error (500)
|
||||
|
||||
```json
|
||||
{
|
||||
"error": "Error message",
|
||||
"barcode": null,
|
||||
"name": null
|
||||
}
|
||||
```
|
||||
|
||||
## Features
|
||||
|
||||
- ✅ Queries Open Food Facts API
|
||||
- ✅ Caches results in `products` table
|
||||
- ✅ Returns cached data for subsequent requests
|
||||
- ✅ Handles product not found gracefully
|
||||
- ✅ CORS enabled for frontend access
|
||||
|
||||
## Environment Variables
|
||||
|
||||
- `SUPABASE_URL`: Auto-injected by Supabase
|
||||
- `SUPABASE_SERVICE_ROLE_KEY`: Auto-injected by Supabase
|
||||
|
||||
## Testing
|
||||
|
||||
```bash
|
||||
# Local (with Supabase CLI)
|
||||
supabase functions serve product-lookup
|
||||
|
||||
# Test request
|
||||
curl -X POST http://localhost:54321/functions/v1/product-lookup \
|
||||
-H "Content-Type: application/json" \
|
||||
-H "Authorization: Bearer YOUR_ANON_KEY" \
|
||||
-d '{"barcode":"8000500310427"}'
|
||||
```
|
||||
|
||||
## Deployment
|
||||
|
||||
```bash
|
||||
supabase functions deploy product-lookup
|
||||
```
|
||||
140
supabase/functions/product-lookup/index.ts
Normal file
140
supabase/functions/product-lookup/index.ts
Normal file
@@ -0,0 +1,140 @@
|
||||
// Product Lookup Edge Function
|
||||
// Fetches product data from Open Food Facts API by barcode
|
||||
|
||||
import { serve } from 'https://deno.land/std@0.168.0/http/server.ts'
|
||||
import { createClient } from 'https://esm.sh/@supabase/supabase-js@2'
|
||||
|
||||
const corsHeaders = {
|
||||
'Access-Control-Allow-Origin': '*',
|
||||
'Access-Control-Allow-Headers': 'authorization, x-client-info, apikey, content-type',
|
||||
}
|
||||
|
||||
interface ProductData {
|
||||
barcode: string
|
||||
name: string
|
||||
brand?: string
|
||||
quantity?: string
|
||||
image_url?: string
|
||||
category?: string
|
||||
cached?: boolean
|
||||
}
|
||||
|
||||
serve(async (req) => {
|
||||
// Handle CORS preflight
|
||||
if (req.method === 'OPTIONS') {
|
||||
return new Response('ok', { headers: corsHeaders })
|
||||
}
|
||||
|
||||
try {
|
||||
const { barcode } = await req.json()
|
||||
|
||||
if (!barcode) {
|
||||
throw new Error('Barcode is required')
|
||||
}
|
||||
|
||||
// Initialize Supabase client
|
||||
const supabaseUrl = Deno.env.get('SUPABASE_URL')!
|
||||
const supabaseKey = Deno.env.get('SUPABASE_SERVICE_ROLE_KEY')!
|
||||
const supabase = createClient(supabaseUrl, supabaseKey)
|
||||
|
||||
// Check cache first (products table can store known products)
|
||||
const { data: cachedProduct } = await supabase
|
||||
.from('products')
|
||||
.select('*')
|
||||
.eq('barcode', barcode)
|
||||
.single()
|
||||
|
||||
if (cachedProduct) {
|
||||
console.log(`Cache HIT for barcode: ${barcode}`)
|
||||
return new Response(
|
||||
JSON.stringify({
|
||||
barcode: cachedProduct.barcode,
|
||||
name: cachedProduct.name,
|
||||
brand: cachedProduct.brand,
|
||||
quantity: cachedProduct.quantity,
|
||||
image_url: cachedProduct.image_url,
|
||||
category: cachedProduct.category,
|
||||
cached: true,
|
||||
} as ProductData),
|
||||
{ headers: { ...corsHeaders, 'Content-Type': 'application/json' } }
|
||||
)
|
||||
}
|
||||
|
||||
console.log(`Cache MISS for barcode: ${barcode}, fetching from Open Food Facts...`)
|
||||
|
||||
// Fetch from Open Food Facts
|
||||
const offResponse = await fetch(
|
||||
`https://world.openfoodfacts.org/api/v2/product/${barcode}.json`,
|
||||
{
|
||||
headers: {
|
||||
'User-Agent': 'Pantry/1.0 (https://github.com/pantry-app/pantry)',
|
||||
},
|
||||
}
|
||||
)
|
||||
|
||||
if (!offResponse.ok) {
|
||||
throw new Error(`Open Food Facts API error: ${offResponse.status}`)
|
||||
}
|
||||
|
||||
const offData = await offResponse.json()
|
||||
|
||||
if (offData.status !== 1 || !offData.product) {
|
||||
// Product not found in Open Food Facts
|
||||
return new Response(
|
||||
JSON.stringify({
|
||||
barcode,
|
||||
name: `Unknown Product (${barcode})`,
|
||||
cached: false,
|
||||
} as ProductData),
|
||||
{
|
||||
headers: { ...corsHeaders, 'Content-Type': 'application/json' },
|
||||
status: 404
|
||||
}
|
||||
)
|
||||
}
|
||||
|
||||
const product = offData.product
|
||||
|
||||
// Extract relevant data
|
||||
const productData: ProductData = {
|
||||
barcode,
|
||||
name: product.product_name || product.generic_name || `Product ${barcode}`,
|
||||
brand: product.brands || undefined,
|
||||
quantity: product.quantity || undefined,
|
||||
image_url: product.image_url || product.image_front_url || undefined,
|
||||
category: product.categories || undefined,
|
||||
cached: false,
|
||||
}
|
||||
|
||||
// Cache the product in our database (upsert)
|
||||
await supabase.from('products').upsert({
|
||||
barcode: productData.barcode,
|
||||
name: productData.name,
|
||||
brand: productData.brand,
|
||||
quantity: productData.quantity,
|
||||
image_url: productData.image_url,
|
||||
category: productData.category,
|
||||
}, { onConflict: 'barcode' })
|
||||
|
||||
console.log(`Successfully fetched and cached product: ${productData.name}`)
|
||||
|
||||
return new Response(
|
||||
JSON.stringify(productData),
|
||||
{ headers: { ...corsHeaders, 'Content-Type': 'application/json' } }
|
||||
)
|
||||
|
||||
} catch (error) {
|
||||
console.error('Error in product-lookup:', error)
|
||||
return new Response(
|
||||
JSON.stringify({
|
||||
error: error instanceof Error ? error.message : 'Unknown error',
|
||||
barcode: null,
|
||||
name: null,
|
||||
}),
|
||||
{
|
||||
headers: { ...corsHeaders, 'Content-Type': 'application/json' },
|
||||
status: 500
|
||||
}
|
||||
)
|
||||
}
|
||||
})
|
||||
37
supabase/migrations/004_seed_units.sql
Normal file
37
supabase/migrations/004_seed_units.sql
Normal file
@@ -0,0 +1,37 @@
|
||||
-- Migration: Seed Default Units
|
||||
-- Week 2: Pre-populate common measurement units with conversions
|
||||
|
||||
-- Weight units (metric base: gram)
|
||||
INSERT INTO units (id, name, abbreviation, unit_type, base_unit_id, conversion_factor, is_default, created_by) VALUES
|
||||
('f47ac10b-58cc-4372-a567-0e02b2c3d479', 'Gram', 'g', 'weight', NULL, 1.0, TRUE, NULL),
|
||||
('550e8400-e29b-41d4-a716-446655440001', 'Kilogram', 'kg', 'weight', 'f47ac10b-58cc-4372-a567-0e02b2c3d479', 1000.0, FALSE, NULL),
|
||||
('550e8400-e29b-41d4-a716-446655440002', 'Milligram', 'mg', 'weight', 'f47ac10b-58cc-4372-a567-0e02b2c3d479', 0.001, FALSE, NULL),
|
||||
('550e8400-e29b-41d4-a716-446655440003', 'Pound', 'lb', 'weight', 'f47ac10b-58cc-4372-a567-0e02b2c3d479', 453.592, FALSE, NULL),
|
||||
('550e8400-e29b-41d4-a716-446655440004', 'Ounce', 'oz', 'weight', 'f47ac10b-58cc-4372-a567-0e02b2c3d479', 28.3495, FALSE, NULL);
|
||||
|
||||
-- Volume units (metric base: milliliter)
|
||||
INSERT INTO units (id, name, abbreviation, unit_type, base_unit_id, conversion_factor, is_default, created_by) VALUES
|
||||
('550e8400-e29b-41d4-a716-446655440010', 'Milliliter', 'mL', 'volume', NULL, 1.0, TRUE, NULL),
|
||||
('550e8400-e29b-41d4-a716-446655440011', 'Liter', 'L', 'volume', '550e8400-e29b-41d4-a716-446655440010', 1000.0, FALSE, NULL),
|
||||
('550e8400-e29b-41d4-a716-446655440012', 'Centiliter', 'cL', 'volume', '550e8400-e29b-41d4-a716-446655440010', 10.0, FALSE, NULL),
|
||||
('550e8400-e29b-41d4-a716-446655440013', 'Deciliter', 'dL', 'volume', '550e8400-e29b-41d4-a716-446655440010', 100.0, FALSE, NULL),
|
||||
('550e8400-e29b-41d4-a716-446655440014', 'Cup', 'cup', 'volume', '550e8400-e29b-41d4-a716-446655440010', 236.588, FALSE, NULL),
|
||||
('550e8400-e29b-41d4-a716-446655440015', 'Tablespoon', 'tbsp', 'volume', '550e8400-e29b-41d4-a716-446655440010', 14.7868, FALSE, NULL),
|
||||
('550e8400-e29b-41d4-a716-446655440016', 'Teaspoon', 'tsp', 'volume', '550e8400-e29b-41d4-a716-446655440010', 4.92892, FALSE, NULL),
|
||||
('550e8400-e29b-41d4-a716-446655440017', 'Fluid Ounce', 'fl oz', 'volume', '550e8400-e29b-41d4-a716-446655440010', 29.5735, FALSE, NULL),
|
||||
('550e8400-e29b-41d4-a716-446655440018', 'Gallon', 'gal', 'volume', '550e8400-e29b-41d4-a716-446655440010', 3785.41, FALSE, NULL),
|
||||
('550e8400-e29b-41d4-a716-446655440019', 'Quart', 'qt', 'volume', '550e8400-e29b-41d4-a716-446655440010', 946.353, FALSE, NULL),
|
||||
('550e8400-e29b-41d4-a716-446655440020', 'Pint', 'pt', 'volume', '550e8400-e29b-41d4-a716-446655440010', 473.176, FALSE, NULL);
|
||||
|
||||
-- Count units (no conversions, each is independent)
|
||||
INSERT INTO units (id, name, abbreviation, unit_type, base_unit_id, conversion_factor, is_default, created_by) VALUES
|
||||
('550e8400-e29b-41d4-a716-446655440030', 'Piece', 'pc', 'count', NULL, 1.0, TRUE, NULL),
|
||||
('550e8400-e29b-41d4-a716-446655440031', 'Dozen', 'doz', 'count', '550e8400-e29b-41d4-a716-446655440030', 12.0, FALSE, NULL),
|
||||
('550e8400-e29b-41d4-a716-446655440032', 'Package', 'pkg', 'count', NULL, 1.0, FALSE, NULL),
|
||||
('550e8400-e29b-41d4-a716-446655440033', 'Bottle', 'btl', 'count', NULL, 1.0, FALSE, NULL),
|
||||
('550e8400-e29b-41d4-a716-446655440034', 'Can', 'can', 'count', NULL, 1.0, FALSE, NULL),
|
||||
('550e8400-e29b-41d4-a716-446655440035', 'Jar', 'jar', 'count', NULL, 1.0, FALSE, NULL),
|
||||
('550e8400-e29b-41d4-a716-446655440036', 'Box', 'box', 'count', NULL, 1.0, FALSE, NULL),
|
||||
('550e8400-e29b-41d4-a716-446655440037', 'Bag', 'bag', 'count', NULL, 1.0, FALSE, NULL);
|
||||
|
||||
COMMENT ON TABLE units IS 'Measurement units with 30 common presets covering metric, imperial, and count units';
|
||||
49
supabase/migrations/005_seed_tags.sql
Normal file
49
supabase/migrations/005_seed_tags.sql
Normal file
@@ -0,0 +1,49 @@
|
||||
-- Migration: Seed Default Tags
|
||||
-- Week 2: Pre-populate common organizational tags
|
||||
|
||||
-- Position Tags (where items are stored)
|
||||
INSERT INTO tags (id, name, category, icon, color, created_by) VALUES
|
||||
('650e8400-e29b-41d4-a716-446655440001', 'Fridge', 'position', '🧊', '#3b82f6', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440002', 'Freezer', 'position', '❄️', '#06b6d4', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440003', 'Pantry', 'position', '🗄️', '#8b5cf6', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440004', 'Cabinet', 'position', '🚪', '#6b7280', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440005', 'Countertop', 'position', '🍽️', '#f59e0b', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440006', 'Cellar', 'position', '🏚️', '#78350f', NULL);
|
||||
|
||||
-- Type Tags (food categories)
|
||||
INSERT INTO tags (id, name, category, icon, color, created_by) VALUES
|
||||
('650e8400-e29b-41d4-a716-446655440010', 'Dairy', 'type', '🧀', '#fbbf24', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440011', 'Meat', 'type', '🥩', '#ef4444', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440012', 'Fish', 'type', '🐟', '#3b82f6', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440013', 'Vegetables', 'type', '🥬', '#22c55e', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440014', 'Fruits', 'type', '🍎', '#f97316', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440015', 'Grains', 'type', '🌾', '#eab308', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440016', 'Legumes', 'type', '🫘', '#84cc16', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440017', 'Condiments', 'type', '🧂', '#ef4444', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440018', 'Snacks', 'type', '🍿', '#f97316', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440019', 'Beverages', 'type', '🥤', '#06b6d4', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440020', 'Baking', 'type', '🧁', '#ec4899', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440021', 'Spices', 'type', '🌶️', '#dc2626', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440022', 'Canned', 'type', '🥫', '#71717a', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440023', 'Frozen', 'type', '🧊', '#06b6d4', NULL);
|
||||
|
||||
-- Dietary Tags
|
||||
INSERT INTO tags (id, name, category, icon, color, created_by) VALUES
|
||||
('650e8400-e29b-41d4-a716-446655440030', 'Vegan', 'dietary', '🌱', '#22c55e', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440031', 'Vegetarian', 'dietary', '🥕', '#84cc16', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440032', 'Gluten-Free', 'dietary', '🌾', '#eab308', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440033', 'Lactose-Free', 'dietary', '🥛', '#60a5fa', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440034', 'Organic', 'dietary', '♻️', '#10b981', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440035', 'Low-Carb', 'dietary', '🥗', '#22c55e', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440036', 'Kosher', 'dietary', '✡️', '#3b82f6', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440037', 'Halal', 'dietary', '☪️', '#22c55e', NULL);
|
||||
|
||||
-- Custom/Workflow Tags
|
||||
INSERT INTO tags (id, name, category, icon, color, created_by) VALUES
|
||||
('650e8400-e29b-41d4-a716-446655440040', 'Low Stock', 'custom', '⚠️', '#ef4444', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440041', 'To Buy', 'custom', '🛒', '#3b82f6', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440042', 'Meal Prep', 'custom', '🍱', '#8b5cf6', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440043', 'Leftovers', 'custom', '♻️', '#f59e0b', NULL),
|
||||
('650e8400-e29b-41d4-a716-446655440044', 'Opening Soon', 'custom', '📆', '#f97316', NULL);
|
||||
|
||||
COMMENT ON TABLE tags IS 'Pre-populated with 33 common tags across position, type, dietary, and workflow categories';
|
||||
Reference in New Issue
Block a user