A modern inventory management system built with TypeScript, Hono backend, React frontend, and SQLite database.

• Available Stock: View current inventory levels
• Stock In: Record incoming inventory with multiple items per transaction
• Stock Out: Record outgoing inventory with multiple items per transaction
• Add Items: Create new inventory items
• Stock Reports: Detailed transaction history with search functionality

├── backend/
│   ├── database/
│   │   ├── migrations.ts    # Database schema setup
│   │   └── queries.ts       # Database query functions
│   ├── routes/
│   │   ├── items.ts         # Item management routes
│   │   ├── stock.ts         # Stock transaction routes
│   │   └── static.ts        # Static file serving
│   └── index.ts             # Main Hono app entry point
├── frontend/
│   ├── components/
│   │   ├── App.tsx          # Main React application
│   │   ├── StockTable.tsx   # Available stock display
│   │   ├── StockForm.tsx    # Stock in/out forms
│   │   ├── AddItemForm.tsx  # Add new item form
│   │   └── ReportTable.tsx  # Transaction reports
│   ├── index.html           # Main HTML template
│   └── index.tsx            # React entry point
├── shared/
│   └── types.ts             # Shared TypeScript interfaces
└── README.md

• id: Primary key
• stock_item_name: Item name
• part_no: Part number/code
• unit: Unit of measurement (PCS, DOZEN, NOS)
• stock: Current stock quantity

• id: Primary key
• date: Transaction date
• item_name: Item name
• qty: Quantity added
• invoice_type: Type of invoice
• invoice_no: Invoice number
• supplier_name: Supplier name

• id: Primary key
• date: Transaction date
• item_name: Item name
• qty: Quantity removed
• invoice_type: Type of invoice
• invoice_no: Invoice number
• supplier_name: Supplier/customer name

• GET /api/items - Get all items
• POST /api/items - Add new item
• GET /api/stock-in - Get stock in transactions
• POST /api/stock-in - Record stock in transaction
• GET /api/stock-out - Get stock out transactions
• POST /api/stock-out - Record stock out transaction

The application uses:

• Backend: Hono framework with SQLite database
• Frontend: React with TypeScript and TailwindCSS
• Styling: Bootstrap-like styling with TailwindCSS
• State Management: React hooks for local state