Skip to main content

Documentation Index

Fetch the complete documentation index at: https://mintlify.com/emmanueljarquin-sys/GrupoMecsaCMS/llms.txt

Use this file to discover all available pages before exploring further.

​
Overview

The Testimonials module allows you to collect, manage, and display customer testimonials and reviews. Organize testimonials by category to showcase them across different sections of your website.

​
Key Features

Customer Reviews

Store testimonials from clients and customers

Category Organization

Organize testimonials by project type or service

Full Details

Capture person, company, position, and testimonial text

CRUD Operations

Create, view, update, and delete testimonials

​
Testimonial Structure

Each testimonial includes:
  • Category (categoria): Category ID for organization
  • Testimonial (testimonio): The actual testimonial text
  • Person (persona): Name of the person giving the testimonial
  • Company (empresa): Company/client name (required)
  • Position (cargo): Person’s job title or role
  • Created At: Submission timestamp
{
  "id": 1,
  "categoria": 5,
  "testimonio": "Grupo Mecsa delivered exceptional results on our website redesign. Their professionalism and attention to detail exceeded our expectations.",
  "persona": "John Smith",
  "empresa": "Tech Solutions Inc.",
  "cargo": "CEO",
  "created_at": "2024-01-20T10:00:00Z"
}

​
Creating Testimonials

1

Access Testimonials

Navigate to Testimoniales from the sidebar menu.
2

Click 'New Testimonial'

Click the “Crear Testimonial” button.
3

Fill Testimonial Details

Required fields:
  • Category: Select from hierarchical dropdown
  • Testimonial Text: The testimonial content
  • Company: Client/customer company name
Optional fields:
  • Person: Name of person giving testimonial
  • Position: Their job title
4

Submit Form

The system validates and creates the testimonial record.

​
Testimonial Creation Process

testimoniales.php
if (isset($_POST['crearTestimonial'])) {
    $categoria_id = isset($_POST['categoria']) ? intval($_POST['categoria']) : 0;
    $testimonio = trim($_POST['testimonio'] ?? '');
    $persona    = trim($_POST['persona'] ?? '');
    $empresa    = trim($_POST['cliente'] ?? '');
    $cargo      = trim($_POST['cargo'] ?? '');
    
    if ($categoria_id <= 0 || empty($testimonio) || empty($empresa)) {
        echo "<script>alert('❌ Por favor complete todos los campos obligatorios o seleccione una categoría válida.');</script>";
    } else {
        $nuevoTestimonial = [
            'categoria'  => $categoria_id,
            'testimonio' => $testimonio,
            'persona'    => $persona,
            'empresa'    => $empresa,
            'cargo'      => $cargo,
            'created_at' => date('Y-m-d H:i:s')
        ];
        
        $res_insert = supabase_request('POST', $table_name, $nuevoTestimonial, 
            ["Prefer: return=representation"]
        );
        
        if ($res_insert['http'] === 201) {
            echo "<script>alert('✅ Testimonial creado correctamente');window.location.href='testimoniales.php';</script>";
            exit;
        }
    }
}

​
Category Integration

Testimonials are organized using the hierarchical category system:
testimoniales.php
// Fetch categories
$res_cat = supabase_request('GET', "categoria-servicios?select=id,name,id_padre&order=name.asc");
$categoria_data = ($res_cat['http'] >= 200 && $res_cat['http'] < 300 && is_array($res_cat['json'])) 
    ? $res_cat['json'] : [];

// Build category map
$categoria_map = [];
if (is_array($categoria_data)) {
    foreach ($categoria_data as $c) {
        if (isset($c['id'])) $categoria_map[$c['id']] = $c;
    }
}

​
Display Category Name

When displaying testimonials, resolve the category name: 
$cat_name = 'N/A';
if (isset($testimonial['categoria']) && isset($categoria_map[$testimonial['categoria']])) {
    $cat_name = $categoria_map[$testimonial['categoria']]['name'] ?? 'N/A';
}

​
Fetching Testimonials

Testimonials are retrieved with pagination:
testimoniales.php
$page = intval($_GET['page'] ?? 1);
$perPage = intval($_GET['rowsPerPage'] ?? 10);
$offset = ($page - 1) * $perPage;

$res_test = supabase_request('GET', 
    "$table_name?select=*&order=created_at.desc&limit=$perPage&offset=$offset"
);
$testimoniales_data = ($res_test['http'] >= 200 && $res_test['http'] < 300 && is_array($res_test['json'])) 
    ? $res_test['json'] : [];

​
Testimonial Display

Testimonials are typically displayed in a table or card layout:
  • Company and Person: Who gave the testimonial
  • Position: Their role
  • Testimonial Text: The review content (truncated if long)
  • Category: Classification
  • Date: When it was submitted
  • Actions: Edit and delete buttons

​
Editing Testimonials

1

Select Testimonial

Click the edit button next to the testimonial.
2

Modify Information

Update any of the fields:
  • Testimonial text
  • Person name
  • Company name
  • Position
  • Category
3

Save Changes

Submit the form to update the database.

​
Deleting Testimonials

Deleting a testimonial is permanent and cannot be undone.
To delete a testimonial:
  1. Click the delete button
  2. Confirm the deletion
  3. Testimonial record is permanently removed

​
Database Table

Table Name: testimoniales
ColumnTypeDescription
idintegerAuto-incrementing primary key
categoriaintegerForeign key to categoria-servicios
testimoniotextTestimonial content
personatextPerson’s name
empresatextCompany name (required)
cargotextJob title/position
created_attimestamptzSubmission timestamp

​
API Endpoints

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

​
Use Cases

​
Website Display

Testimonials can be fetched and displayed on:
  • Homepage testimonial section
  • Service-specific pages (filtered by category)
  • Dedicated testimonials/reviews page
  • Case study pages

​
Filtering by Category

Query testimonials for specific categories: 
GET /rest/v1/testimoniales?categoria=eq.5&select=*

​
Best Practices

Always get written permission from clients before publishing their testimonials.
Include the person’s full name and position for credibility.
Keep testimonials concise and focused - edit long testimonials for clarity.
Organize testimonials by service category to show relevant social proof on each service page.
Regularly update testimonials to keep content fresh and relevant.

​
Next Steps

Categories

Manage testimonial categories

Clients

Link testimonials to clients

Build docs developers (and LLMs) love

Get started for freeTalk to us