A dual-interface CRM application for OBUO Farms with separate client and admin portals.

• Client Portal: Clean, simple order form for customers
• Admin Dashboard: Complete order management with authentication
• SQLite database for storing orders
• Automatic email confirmations to clients
• RESTful API for order management

• Simple, customer-friendly order form
• No backend data exposed to clients
• Automatic email confirmations
• Mobile-responsive design
• Professional OBUO Farms branding

• Secure login required
• Complete order management dashboard
• Create new orders manually
• View all orders with search/filter/sort
• Order statistics and analytics
• Logout functionality

Default Admin Credentials:

• Username: admin
• Password: obuo2024

Note: Change these credentials for production use

├── 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