A simple CRM application for managing OBUO Farms orders and client information.

• Order form for collecting client information and order details
• SQLite database for storing orders
• Automatic email confirmations to clients
• Dashboard for viewing past orders
• RESTful API for order management

├── backend/
│   ├── database/
│   │   ├── migrations.ts    # Database schema
│   │   └── queries.ts       # Database operations
│   ├── routes/
│   │   ├── orders.ts        # Order API endpoints
│   │   └── static.ts        # Static file serving
│   └── index.ts             # Main Hono app
├── frontend/
│   ├── components/
│   │   ├── App.tsx          # Main React app
│   │   ├── OrderForm.tsx    # Order submission form
│   │   └── Dashboard.tsx    # Orders dashboard
│   ├── index.html           # Main HTML template
│   ├── index.tsx            # Frontend entry point
│   └── style.css            # Styles
└── shared/
    └── types.ts             # Shared TypeScript types

• POST /api/orders - Create a new order
• GET /api/orders - Get all orders
• GET /api/orders/:id - Get specific order
• GET / - Main dashboard page

Orders table includes:

• Client information (name, phone, email)
• Order details (type, quantity, delivery date)
• Notes and timestamps

The application automatically initializes the database on startup. No additional setup is required.

1. Creating Orders: Use the form on the main page to create new orders
2. Email Confirmations: Clients automatically receive email confirmations when orders are created
3. Dashboard: View all orders with search, filter, and sort capabilities
4. API Access: Use the REST API endpoints for programmatic access

• Fresh Fish
• Frozen Fish
• Live Fish
• Fish Fillet
• Smoked Fish
• Dried Fish
• Catfish
• Tilapia
• Fish Feed
• Other

• ✅ Responsive design for mobile and desktop
• ✅ Real-time order creation with validation
• ✅ Automatic email confirmations to clients
• ✅ Search and filter orders by multiple criteria
• ✅ Sort orders by date, client name, or delivery date
• ✅ Visual status indicators for delivery dates
• ✅ SQLite database with proper schema
• ✅ RESTful API with error handling
• ✅ TypeScript for type safety