SecureQuote Pro Documentation

Complete Application Reference

SecureQuote Pro - Complete Application Documentation

📋 Overview

SecureQuote Pro is a comprehensive insurance agency management system that handles:

  • Multi-type insurance quote requests (Auto, Home, Renters, Umbrella, Business)
  • Lead source tracking and referral management
  • Agent assignment and performance tracking
  • Commission tracking with split capabilities
  • Automated email and SMS follow-ups
  • Document management and expiration tracking
  • Customer self-service portal
  • Team leadership analytics

Tech Stack:

  • Frontend: React with shadcn/ui components
  • Backend: Base44 platform with Deno functions
  • Database: Base44 entities with RLS
  • Integrations: Twilio (SMS), Resend (Email), OpenAI (AI features)

User Roles & Permissions

Admin (role: "admin")

  • Full system access
  • Manage all quotes, commissions, users
  • Configure templates, automation rules
  • Access all analytics and reports

Leader (is_leader: true)

  • View all team data
  • Team performance dashboard
  • Agent comparison and analytics
  • Commission oversight

Agent (is_agent: true)

  • View assigned quotes
  • Manage own pipeline
  • Add commissions for closed deals
  • Email/SMS communication

Customer (Public/Authenticated)

  • Submit quote requests
  • View own quotes via portal
  • Upload documents
  • Chat with AI assistant

Database Entities (20+)

Core Entities

1. InsuranceQuote - Primary quote entity

  • Contact: full_name, email, phone, date_of_birth
  • Address: address, city, state, zip_code
  • Status: new, contacted, quoted, presented, closed, didnt_buy
  • Insurance types: Multiple types support
  • Lead tracking: lead_source, referrer info
  • Auto fields: vehicles, drivers, license
  • Home fields: coverage, property details
  • Business fields: type, revenue, employees
  • Policy tracking: policy_end_dates[]

2. User - Extended user profiles

  • Custom: commission rates, phone, agency
  • Flags: is_agent, is_leader
  • Built-in: email, full_name, role

3. Commission - Commission tracking

  • Basic: quote_id, policy_type, carrier
  • Amounts: premium, commission_rate, commission_amount
  • Splits: has_splits, split records
  • Status: payment_status, payment_date

4. CommissionSplit - Split commissions

  • Agent info and split percentage
  • Role types: primary, secondary, referral

5. QuoteComparison - Carrier quotes

  • Multiple carrier options per quote
  • Premium comparison
  • Recommendation tracking

6. Document - File uploads

  • Types: policy, photo, license, registration
  • Quote linkage
  • Upload tracking

7. DocumentExpiration - Expiration tracking

  • Document type and dates
  • Reminder intervals
  • Auto-notifications

8. PolicyRequirement - Carrier requirements

  • Requirement tracking
  • Due dates and priorities
  • Status management

9. Referral - Referral program

  • Referrer and referred tracking
  • Reward management
  • Quote linkage

Communication Entities

10. EmailLog - Email audit trail 11. SMSLog - SMS audit trail 12. ActivityLog - Comprehensive activity tracking 13. ChatMessage - Customer chat history

Configuration

14. EmailTemplate - Reusable email templates 15. SMSTemplate - SMS templates 16. AutoFollowUpRule - Automated sequences 17. PageContent - CMS for pages

Analytics

18. QuoteScore - AI lead scoring 19. AgentGoal - Monthly goals 20. SubmissionTracking - Rate limiting

Pages & Features

Public Pages

  • Home - Landing with QR code, dual CTAs
  • QuoteForm - Multi-step quote request
  • Success - Confirmation page
  • CustomerPortal - Self-service portal

Agent Pages

  • AgentDashboard - Main workspace
    • Today's Tasks widget
    • Expiring Documents widget
    • Goals tracking
    • Quote management
    • Bulk actions
    • Communication timeline
  • Commissions - Commission tracking
  • Referrals - Referral management

Leader Pages

  • LeaderDashboard - Team performance
    • Pipeline health (includes Presented)
    • Agent comparison
    • Performance metrics
  • Analytics - Deep dive analytics
    • Conversion funnel
    • Revenue tracking
    • Lead source performance

Admin Pages

  • AdminDashboard - System control
  • EmailTemplates - Template management
  • EmailLog - Email audit
  • SMSSettings - SMS configuration
  • AutoFollowUpSettings - Automation rules
  • UserManagement - User admin
  • Settings - System config

Components Library

Dashboard Components

  • TodaysTasks - Urgent items for agents
  • ExpiringDocumentsWidget - Document alerts
  • GoalsWidget - Monthly goal tracking
  • LeadSourceWidget - Lead source performance
  • QuickActions - Quote action buttons
  • BulkActions - Mass update toolbar
  • EmailTemplateSelector - Smart email composition with AI
  • PolicyEndDatesManager - Renewal tracking
  • ManualQuoteEntry - Add quotes manually
  • QuoteComparison - Carrier comparison
  • CommissionForm - Add/split commissions
  • CommissionOptimizer - AI commission advice
  • CoverageGapAnalysis - AI coverage analysis
  • DocumentsManager - Document management
  • CommunicationTimeline - Activity feed
  • CalendarButton - Calendar integration
  • ReferralForm - Create referrals

Analytics Components

  • RevenueForecasting - Revenue predictions
  • AgentComparison - Agent performance charts

Customer Components

  • CustomerChat - AI support chat
  • QuoteAssistant - Pre-quote assistant

Backend Functions (23)

Communication

  1. sendEmail - Send emails via Resend
  2. sendSMS - Send SMS via Twilio
  3. sendStatusChangeSMS - Auto SMS on status change
  4. sendDailyFollowUpDigest - Daily agent digest
  5. processAutoFollowUps - Execute follow-up rules
  6. checkPolicyRenewals - Renewal reminders
  7. checkRequirementDueDates - Requirement alerts
  8. checkDocumentExpirations - Document reminders

AI & Intelligence

  1. triageQuote - Lead scoring & assignment
  2. chatWithCustomer - AI customer support
  3. quoteAssistant - Pre-quote AI assistant
  4. manageQuote - AI quote management
  5. parseQuotePDF - Extract data from PDFs
  6. analyzeQuoteComparisons - AI quote analysis
  7. optimizeCommission - Commission optimization
  8. analyzeCoverageGaps - Coverage gap analysis

Data Management

  1. bulkUpdateQuotes - Mass updates
  2. inviteUser - Single user invite
  3. bulkInviteUsers - CSV bulk invite
  4. getCustomerQuotes - Customer portal data
  5. getCustomerDocuments - Customer docs
  6. uploadCustomerDocument - Customer upload
  7. createCalendarEvent - Calendar integration

Key Workflows

Quote Submission Flow

Customer submits form
  ↓
Rate limiting check (3 per email/24h)
  ↓
Create InsuranceQuote
  ↓
If referral → Create Referral
  ↓
AI triage (triageQuote)
  ↓
Create QuoteScore
  ↓
Auto-assign to agent
  ↓
Send confirmation email
  ↓
Send SMS (if enabled)
  ↓
Start auto-follow-up sequence

Agent Quote Management

Agent views dashboard
  ↓
Reviews AI insights
  ↓
Contacts customer
  ↓
Updates status → SMS sent
  ↓
Adds carrier quotes
  ↓
Status: Presented
  ↓
Status: Closed
  ↓
Adds commission
  ↓
Tracks renewals

Commission Split Flow

Agent closes deal
  ↓
Selects "Split Commission"
  ↓
Adds agents with %
  ↓
Creates Commission + Splits
  ↓
Each agent sees split
  ↓
Leader approves
  ↓
Marks as paid

Document Expiration

Add document with expiration
  ↓
Create DocumentExpiration
  ↓
Cron checks daily
  ↓
Send reminders (30, 14, 7 days)
  ↓
Status: expired
  ↓
Customer uploads renewal
  ↓
Status: renewed

Referral Tracking

Customer A refers Customer B
  ↓
B selects "Referred by friend"
  ↓
Enters A's name/email
  ↓
Creates Referral record
  ↓
B submits quote
  ↓
Quote linked to Referral
  ↓
Lead closes
  ↓
Referral status: closed
  ↓
Admin marks reward paid

Integration Points

Email (Resend)

  • Secret: RESEND_API_KEY
  • Used for: Confirmations, follow-ups, reminders
  • Function: sendEmail

SMS (Twilio)

  • Secrets: TWILIO_ACCOUNT_SID, TWILIO_AUTH_TOKEN, TWILIO_PHONE_NUMBER
  • Used for: Status updates, urgent alerts
  • Functions: sendSMS, sendStatusChangeSMS

AI (OpenAI via Base44)

  • Built into platform
  • Used for: Scoring, chat, email generation, analysis
  • Integration: base44.integrations.Core.InvokeLLM()

Calendar (Google)

  • Client-side URL generation
  • Used for: Reminders, deadlines, renewals
  • Component: CalendarButton

File Storage (Base44)

  • Built-in secure storage
  • Used for: Documents, PDFs
  • Function: base44.integrations.Core.UploadFile()

Automation Features

Scheduled Functions (Cron)

  • sendDailyFollowUpDigest - 8 AM daily
  • processAutoFollowUps - Every 6 hours
  • checkPolicyRenewals - Daily 9 AM
  • checkRequirementDueDates - Daily 8 AM
  • checkDocumentExpirations - Daily 7 AM

Triggered Automations

  • On Quote Creation: AI triage, assignment, emails
  • On Status Change: SMS notification, activity log
  • On Commission Add: Revenue tracking, analytics
  • On Document Upload: Notifications, expiration tracking
  • On Requirement Add: Alerts, calendar reminders

Security & Permissions

Row Level Security (RLS)

  • Quotes: Customer sees own, agent sees assigned, leader/admin see all
  • Commissions: Agent sees own, leader/admin see all
  • Documents: Quote-based permissions
  • Activity: Inherits from quote

API Security

All functions use authenticated requests:

const base44 = createClientFromRequest(req);
const user = await base44.auth.me();

Rate Limiting

  • Quote submissions: 3 per email per 24h
  • IP tracking via SubmissionTracking

Mobile Responsiveness

All pages fully responsive:

  • Mobile: < 768px
  • Tablet: 768-1024px
  • Desktop: > 1024px

Features:

  • Touch-optimized
  • Collapsible sections
  • Mobile-friendly forms
  • QR code scanning
  • Full-screen dialogs on mobile

Recent Updates

Version 1.0 (Current)

✅ Added Presented status to pipeline ✅ Added lead source tracking to quote form ✅ Added LeadSourceWidget to dashboard ✅ Added referral auto-creation ✅ Added Commission Optimizer (AI) ✅ Added Coverage Gap Analysis (AI) ✅ Added Document Expiration tracking ✅ Enhanced mobile responsiveness ✅ Added Calendar integration ✅ Improved AI email generation

Troubleshooting

Common Issues

Quotes not showing:

  • Check RLS rules and user permissions
  • Verify assigned_agent field

Emails not sending:

  • Verify RESEND_API_KEY secret
  • Check EmailLog for errors

SMS not sending:

  • Verify Twilio secrets
  • Check phone format (+1...)

AI features not working:

  • Check Base44 LLM integration
  • Review function error logs

Commission splits not calculating:

  • Verify splits total 100%
  • Check has_splits=true

Deployment Checklist

Configuration

  • [ ] Set all secrets (Resend, Twilio)
  • [ ] Configure email templates
  • [ ] Set up SMS templates
  • [ ] Create auto-follow-up rules
  • [ ] Set default commission rates

Testing

  • [ ] Submit test quotes
  • [ ] Test agent workflow
  • [ ] Test commission splits
  • [ ] Test document uploads
  • [ ] Test mobile responsiveness

Security

  • [ ] Review RLS rules
  • [ ] Test role permissions
  • [ ] Verify rate limiting
  • [ ] Check HTTPS enabled

Maintenance

Daily

  • Monitor cron execution
  • Review error logs
  • Check delivery rates

Weekly

  • Review conversion rates
  • Check agent performance
  • Audit commissions

Monthly

  • Update templates
  • Analyze lead source ROI
  • Plan features

Quarterly

  • Security audit
  • Performance optimization
  • Training updates

Documentation Version 1.0 - SecureQuote Pro Last Updated: 2024