Installation Guide

cd C:/xampp/htdocs  # On Windows with XAMPP
# or
cd /var/www/html    # On Linux

git clone <repo-url> GrupoMecsaCMS
cd GrupoMecsaCMS

GrupoMecsaCMS/
├── assets/           # Static resources (images, logos)
├── components/       # Reusable PHP components
├── config/           # Configuration files
├── docs/             # Documentation and SQL files
├── pages/            # Main CMS pages
├── scripts/          # JavaScript files
├── styles/           # CSS and SCSS files
├── vendor/           # Composer dependencies
├── composer.json     # Composer configuration
├── index.php         # Main entry point
├── login.php         # Login page
└── supabase.php      # Supabase initialization

composer install

ls -la vendor/guzzlehttp

<?php
global $supabase_url, $supabase_key, $supabase_service_role, $supabase_schema;

$supabase_url = 'https://your-project-id.supabase.co';
$supabase_key = 'your-anon-public-key';
$supabase_service_role = 'your-service-role-key';
$supabase_schema = 'cms';
?>

<?php
// This file is loaded only in development and overrides config/supabase.php
$supabase_url = 'https://dev-project.supabase.co';
$supabase_key = 'dev-anon-key';
$supabase_service_role = 'dev-service-role-key';
?>

CREATE SCHEMA IF NOT EXISTS cms;

-- Example: Pages table structure
CREATE TABLE IF NOT EXISTS cms.cms_pages (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    title TEXT NOT NULL,
    slug TEXT UNIQUE NOT NULL,
    template_id UUID REFERENCES cms.cms_templates(id),
    content JSONB DEFAULT '{}'::jsonb,
    meta_title TEXT,
    meta_description TEXT,
    is_published BOOLEAN DEFAULT false,
    published_at TIMESTAMP WITH TIME ZONE,
    author_id UUID,
    created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
    updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);

CREATE TABLE IF NOT EXISTS public.Empleados (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    id_user UUID REFERENCES auth.users(id),
    nombre TEXT NOT NULL,
    email TEXT UNIQUE NOT NULL,
    rol TEXT, -- 'Administrador', 'Comercial', 'Proyecto'
    chat_role TEXT,
    sistemas_acceso TEXT[], -- Array: ['CMS', 'CRM', etc.]
    activo BOOLEAN DEFAULT true,
    created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);

INSERT INTO public.Empleados (id_user, nombre, email, rol, sistemas_acceso, activo)
VALUES (
    'user-uuid-from-auth',
    'Your Name',
    'your.email@grupomecsa.net',
    'Administrador',
    ARRAY['CMS'],
    true
);

<VirtualHost *:80>
    ServerName cms.grupomecsa.local
    DocumentRoot "C:/xampp/htdocs/GrupoMecsaCMS"
    <Directory "C:/xampp/htdocs/GrupoMecsaCMS">
        AllowOverride All
        Require all granted
    </Directory>
</VirtualHost>

127.0.0.1 cms.grupomecsa.local

http://localhost/GrupoMecsaCMS

// The login process validates:
// 1. Supabase authentication
// 2. Email confirmation status
// 3. Employee record existence
// 4. CMS access permission
// 5. Active status