Store Record Management System
This project provides a comprehensive solution for managing store-related records such as commissions, daily sales, mailbox, tender sales, and other data. The system supports user subscriptions, role-based access, file management, and AI-driven features, accessible via a web portal and a mobile application.
Key Functionalities
1. User Subscription & Account Setup
a) Registration Workflow:
– Users must select a subscription plan and provide business and card details during registration.
– A request for account creation is sent to the admin.
b) Admin Approval:
– Admin receives a notification email for new account requests.
– Admin sets up the user account and configures the database details.
– The system generates an invitation email to the user with credentials (store number, username, password).
2. Authentication
Login:
Users log in with their store number, username, and password.
a) Access Control:
Available tabs and features are based on the user’s subscription package.
3. Dashboard
a) Data Overview:
– Summarized records such as commissions, daily sales, mailbox, tender sales, and other metrics.
– Data filtering by date range, monthly, or yearly views.
b) File Uploads:
Users can upload relevant files to specific tabs (e.g., commission, mailbox) for future reference.
4. Subscription Management
a) Subscription Details:
– View current subscription and available packages for upgrading or downgrading.
– Packages define which tabs and features users can access.
a) Cancellation Workflow:
– Users can request subscription cancellation.
– Admin reviews and processes the request based on the generated email notification.
5. AI Configuration
a) AI-Driven Features:
Generate tender sales details using AI tools integrated into the AI Configuration Tab.
6. Settings
a) Column Configuration:
Adjust the column settings for commission, mailbox, and other data-related tabs.
7. Role Management
a) Custom Roles:
Create roles for staff members by specifying access permissions for tabs.
b) Role configuration includes:
– Role name
– Tab selection via checkboxes
c) Role-Based Access:
Staff members can only access tabs assigned through their roles.
8. Staff Management
a) Add Staff Users:
Store owners can add staff members by providing:
Name
Email
Password
Assigned role
Staff Access:
Staff members log in using the store number and their credentials.
Access is limited to tabs specified by their assigned role.
9. Admin Features
a) User Management:
– Admin can manage all registered users (store owners and staff).
– Subscription Oversight:
View, update, or cancel user subscriptions.
– Notification Management:
Manage email notifications for user registration, subscription updates, and cancellations.
– Global Configuration:
Admin can oversee the AI configuration and other system settings.
– Technical Stack
Backend
Framework: Laravel (PHP)
– Database: MySQL
– Authentication: Laravel Sanctum or Passport (API authentication)
– Role Management: Spatie Laravel Permission
Frontend
– Templates: Blade Templates
– UI Framework: Bootstrap
– JavaScript: Vanilla JS or Vue.js (optional for dynamic components)
– Additional Features
File Management: Laravel File Storage
Payment Integration: Stripe or PayPal for subscription handling
Notifications: Laravel Mail and Notifications
AI Integration: Python-based services integrated with Laravel (e.g., for AI-driven tender sales generation)
Hosting
Laravel Forge, AWS, or DigitalOcean