TELE CRM V1
===========

Stack:
- PHP 8.1+
- MySQL/MariaDB
- PDO
- Bootstrap-free responsive HTML/CSS starter UI

This package is the Phase-1 foundation based on the supplied telecrm.xlsx structure.
It contains the database schema and a minimal secure installation foundation.

INSTALLATION
------------
1. Create a MySQL database in cPanel.
2. Import database.sql using phpMyAdmin.
3. Copy the telecrm_v1 folder contents into your desired public_html/telecrm/ directory.
4. Edit config/config.php with database credentials.
5. Open /telecrm/setup.php.
6. Create the first Super Admin.
7. Delete or rename setup.php after successful installation.

IMPORTANT
---------
- Do not upload production API keys into public files.
- Use HTTPS.
- Keep config files outside public web root if your hosting layout permits.
- The supplied Excel should be imported through a preview/validation import module before production use.
- WhatsApp/SMS/email/AI providers are schema-ready but provider API calls are not enabled in this V1 foundation.

EXCEL FIELDS MAPPED FOR FUTURE IMPORT
--------------------------------------
Co Name
cin
Description
Director
Phone
Director1
Phone1
Director2
Phone2
Director3
Phone3
Call Followups
status
Time
Note
Appointments Schedule
Address
Co Email
Email1
Email2
Email3
Month
Reg-Date
Director DOB
Director1 DOB
Director2 DOB
Director3 DOB
