═══════════════════════════════════════════════════════════════
  CY Consultancy Centre — CRM v15 (Final Build)
═══════════════════════════════════════════════════════════════

Complete student visa processing & office management system
for CY Consultancy Centre, Dhaka, Bangladesh.

───────────────────────────────────────────────────────────────
  📊 PROJECT STATS
───────────────────────────────────────────────────────────────
• 105 API endpoints
• 31 database tables
• 38 individual permissions
• 83 CRUD functions
• Zero localStorage (everything in DB)

───────────────────────────────────────────────────────────────
  ⚡ QUICK SETUP (XAMPP)
───────────────────────────────────────────────────────────────

1. Extract this zip into:
     C:\xampp\htdocs\cyadmin

2. Start XAMPP — Apache + MySQL services

3. Open phpMyAdmin (http://localhost/phpmyadmin):
     - DROP existing database "cy_crm" if any
     - Click "Import" → choose database.sql → Go

4. Open browser:
     http://localhost/cyadmin/

5. Login with default admin:
     Username: admin
     Password: admin123

6. IMPORTANT: Press Ctrl+Shift+R for hard refresh

───────────────────────────────────────────────────────────────
  🔐 DEFAULT LOGIN ACCOUNTS
───────────────────────────────────────────────────────────────

ADMIN:    admin / admin123
STAFF:    sabbir / sabbir123, nasrin / nasrin123
COUNSELOR: rahim / rahim123
STUDENTS: noorjahan, rakibul, sumaya, farhan, taslima
          (all password: student123)

───────────────────────────────────────────────────────────────
  📋 FEATURES SUMMARY
───────────────────────────────────────────────────────────────

CORE CRUD:
  Students, Users, Counselors, Agents, Branches, Roles,
  Colleges, Intakes, Office Visitors, Sponsors

PAYMENT (BDT only):
  Payment CRUD, Payment Types CRUD, Payment Requests,
  Auto Invoice generation, Bank slip upload

DOCUMENTS:
  Phase-wise upload, Verification, Doc Checklists per dest

VISA PROCESSING:
  14-stage tracking, Stage Map, VFS Tracker,
  Interview Prep, VFS Quiz Q&A

TASKS & FOLLOW-UP:
  Priority levels, Due dates, Overdue alerts,
  Student linking, Staff assignment

DASHBOARD:
  Conversion Funnel, Counselor/Agent leaderboards,
  Destination distribution, Revenue trend, Calendar

EXPENSES:
  Office expenses, Categories CRUD, Boss Deposits

REFERRALS:
  Sources & Destinations CRUD, Statistics

SECURITY:
  38 permission keys, Role-based + per-user access,
  Sidebar items hide based on permissions

UI/UX:
  Playfair Display + DM Sans, Light/Dark mode,
  Mobile responsive, Animations, Toast notifications

───────────────────────────────────────────────────────────────
  🛠️  CONFIGURATION
───────────────────────────────────────────────────────────────

DATABASE:
  Server:   localhost
  User:     root
  Password: (empty)
  Name:     cy_crm
  Charset:  utf8mb4

Edit api/config.php to change DB credentials.

───────────────────────────────────────────────────────────────
  🔧 TROUBLESHOOTING
───────────────────────────────────────────────────────────────

"API Error" on dashboard:
  → Visit /test.php to verify DB connection
  → Re-import database.sql

New features not showing:
  → Press Ctrl+Shift+R for hard refresh

Permissions not working:
  → Login as admin → Users → 🔐 → Save

Counselor dropdown empty:
  → Add via Counselors menu OR Users with counselor role
  → Both sources merge into dropdown

───────────────────────────────────────────────────────────────
CY Consultancy Centre — CRM v15
© 2026 CY Tech Team
