Contact Management - Grupo Mecsa CMS

Overview

The Contacts module stores and manages contact form submissions from your website. Track inquiries with country, phone, and email information for follow-up and customer service.

Key Features

Contact Submissions

Receive and store contact form data

Country Validation

Validate contacts against country database

Pagination

Browse contacts with configurable page sizes

CRUD Operations

View, create, update, and delete contact records

Contact Record Structure

Each contact submission includes:

Country (pais): Contact’s country
Phone (telefono): Contact phone number
Email (correo): Contact email address
Created At: Submission timestamp

{
  "id": 1,
  "pais": "Mexico",
  "telefono": "+52 55 1234 5678",
  "correo": "contact@example.com",
  "created_at": "2024-01-20T15:30:00Z"
}

Creating a Contact

Access Contacts Module

Navigate to Contacts from the sidebar menu.

Click 'New Contact'

Click the “Crear Contacto” button.

Fill Contact Information

Required fields:

Country (pais): Select from dropdown
Phone (telefono): Contact phone number
Email (correo): Valid email address

Submit Form

The system validates the country and creates the contact record.

Contact Creation Process

contactos.php

if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['crearContacto'])) {
    $pais = trim($_POST['pais'] ?? '');
    $telefono = trim($_POST['telefono'] ?? '');
    $correo = trim($_POST['correo'] ?? '');
    
    if ($pais === '' || $telefono === '' || $correo === '') {
        die("<script>alert('❌ Completa todos los campos'); window.history.back();</script>");
    }
    
    // Validate country exists in Paises table
    $resP = supabase_get('Paises?select=pais');
    $listaPaises = [];
    if (isset($resP['json']) && is_array($resP['json'])) {
        $listaPaises = array_column($resP['json'], 'pais');
    } else {
        $decodedP = json_decode($resP['body'], true);
        if (is_array($decodedP)) $listaPaises = array_column($decodedP, 'pais');
    }
    
    if (!in_array($pais, $listaPaises)) {
        die("<script>alert('❌ País no válido'); window.history.back();</script>");
    }
    
    $new = [
        'pais' => $pais,
        'telefono' => $telefono,
        'correo' => $correo,
        'created_at' => date('Y-m-d H:i:s')
    ];
    
    $res_insert = supabase_request('POST', $table_contactos, $new, ["Prefer: return=representation"]);
    $code = $res_insert['http'];
    $resp = $res_insert['body'];
    
    if ($code >= 200 && $code < 300) {
        echo "<script>alert('✅ Contacto creado correctamente'); window.location.href='contactos.php';</script>";
    } else {
        echo "<script>alert('❌ Error al crear contacto: $resp'); window.history.back();</script>";
    }
}

Country Validation

Contacts must specify a valid country from the Paises table:

contactos.php

// Fetch available countries
$paises = fetchFromSupabase('Paises?select=pais');

Countries Table

Table Name: Paises

Column	Type	Description
`id`	integer	Primary key
`pais`	text	Country name

The system validates that the submitted country exists in the Paises table before accepting the contact.

Fetching Contacts

Contacts are retrieved with pagination:

contactos.php

$table_contactos = "contactos";

// Pagination
$page = intval($_GET['page'] ?? 1);
$perPage = intval($_GET['rowsPerPage'] ?? 10);
$offset = ($page - 1) * $perPage;

$path = "$table_contactos?select=*&order=created_at.desc&limit=$perPage&offset=$offset";
$contactos = fetchFromSupabase($path);

$totalPath = "$table_contactos?select=id";
$totalRecords = count(fetchFromSupabase($totalPath));
$totalPages = $perPage > 0 ? ceil($totalRecords / $perPage) : 1;

Pagination Configuration

Default rows per page: 10
Options: 5, 10, 20, 50
URL parameters: ?page=2&rowsPerPage=20

Contact Listing

Contacts are displayed in a table with:

Country: Contact’s country
Phone: Formatted phone number
Email: Email address (clickable mailto link)
Received: Submission date and time
Actions: Edit and delete buttons

Default Sorting

Contacts are sorted by creation date in descending order (newest first):

order=created_at.desc

Viewing Contact Details

Click on a contact row to view full details:

All contact information
Submission timestamp
Related inquiries (if tracked)
Follow-up history (if enabled)

Editing Contacts

Select Contact

Click the edit button next to the contact.

Modify Information

Update any of the fields:

Country
Phone number
Email address

Save Changes

Submit the form to update the database.

Deleting Contacts

Deleting a contact is permanent and cannot be undone.

To delete a contact:

Click the delete button
Confirm the deletion
Contact record is permanently removed

Database Table

Table Name: contactos

Column	Type	Description
`id`	integer	Auto-incrementing primary key
`pais`	text	Country name
`telefono`	text	Phone number
`correo`	text	Email address
`created_at`	timestamptz	Submission timestamp

API Endpoints

The Contacts module uses Supabase REST API:

GET /rest/v1/contactos - List all contacts
GET /rest/v1/contactos?select=*&order=created_at.desc&limit=10&offset=0 - Paginated contacts
POST /rest/v1/contactos - Create new contact
PATCH /rest/v1/contactos?id=eq.{id} - Update contact
DELETE /rest/v1/contactos?id=eq.{id} - Delete contact

Dashboard Integration

Contact statistics appear on the Dashboard:

dashboard.php

$total_contactos = get_count('contactos');
$ultimos_contactos = get_records('contactos');

Total contact count
Recent contact submissions (last 5)

Email Integration

Contact emails can be exported for email marketing campaigns:

Export contact emails to use with the Email Builder for newsletters and campaigns.

Best Practices

Timely Follow-up

Respond to new contacts within 24 hours

Data Privacy

Comply with GDPR and data protection regulations

Regular Review

Audit contacts monthly to remove duplicates

Categorization

Tag contacts by inquiry type for better organization

Troubleshooting

Invalid Country Error

Problem: “País no válido” error when creating contact Solution: The submitted country must exist in the Paises table. Check the countries dropdown or add the country to the Paises table first.

Missing Required Fields

Problem: “Completa todos los campos” error Solution: Ensure all three required fields (country, phone, email) are filled before submitting.

Duplicate Contacts

Problem: Same contact submitted multiple times Solution: Consider implementing duplicate detection based on email address. Add a unique constraint on the correo column:

ALTER TABLE contactos ADD CONSTRAINT unique_email UNIQUE (correo);

Form Integration

To integrate the contact form on your website:

<form action="/api/contactos.php" method="POST">
  <label>Country:
    <select name="pais" required>
      <!-- Populate from Paises table -->
    </select>
  </label>
  
  <label>Phone:
    <input type="tel" name="telefono" required>
  </label>
  
  <label>Email:
    <input type="email" name="correo" required>
  </label>
  
  <button type="submit" name="crearContacto">Submit</button>
</form>

Get Started

Core Modules

Website Management

Email Builder

Human Resources

User Management

Configuration

Documentation Index

​Overview

​Key Features

Contact Submissions

Country Validation

Pagination

CRUD Operations

​Contact Record Structure

​Creating a Contact

​Contact Creation Process

​Country Validation

​Countries Table

​Fetching Contacts

​Pagination Configuration

​Contact Listing

​Default Sorting

​Viewing Contact Details

​Editing Contacts

​Deleting Contacts

​Database Table

​API Endpoints

​Dashboard Integration

​Email Integration

​Best Practices

Timely Follow-up

Data Privacy

Regular Review

Categorization

​Troubleshooting

​Invalid Country Error

​Missing Required Fields

​Duplicate Contacts

​Form Integration

​Next Steps

Dashboard

Email Builder

Build docs developers (and LLMs) love

Overview

Key Features

Contact Record Structure

Creating a Contact

Contact Creation Process

Country Validation

Countries Table

Fetching Contacts

Pagination Configuration

Contact Listing

Default Sorting

Viewing Contact Details

Editing Contacts

Deleting Contacts

Database Table

API Endpoints

Dashboard Integration

Email Integration

Best Practices

Troubleshooting

Invalid Country Error

Missing Required Fields

Duplicate Contacts

Form Integration

Next Steps