# Rukn Amjad Trading Company - LLM Context File
# شركة ركن أمجاد للتجارة - Marble, Ceramics & Porcelain
# Established: 2008 (17+ years of experience)
# Generated: 2025-10-23 09:13:22 (Auto-Updated)
# This file is dynamically generated from the live system

## Project Overview
Company Website: Rukn Amjad Trading Company - Marble, Ceramics & Porcelain
Location: Saudi Arabia
Languages: Arabic (primary), English (secondary)
Tech Stack: PHP 8.1.33, MySQL 8.0.43, Bootstrap 5, jQuery, WOW.js
Established: 2008 (17+ years of experience in the private sector)
Current Site URL: https://ruknamjad.com/
Backend URL: https://ruknamjad.com/

## Purpose
Full-featured bilingual business website with:
- Content Management System (CMS)
- Project portfolio showcase (Current: 1 projects)
- Service listings (Current: 5 services)
- Blog system with comments (Current: 2 posts)
- Contact & quote request forms
- Team member profiles (Current: 1 members)
- Client testimonials (Current: 1 testimonials)
- Newsletter subscription
- SEO optimization
- Mobile responsive design

## Live Statistics
Services: 5
Projects: 1
Blog Posts: 2
Team Members: 1
Testimonials: 1
Custom Pages: 8
Latest Blog Post: "Marble, Ceramics and Porcelain" (2025-10-11)
Latest Project: "Supply & installation of marble, ceramics, and porcelain" (2025-10-11)

## Color Scheme
Primary Gold: #D4AF37
Secondary Black: #000000
Light: #FFFFFF
Text: Dark (#000) with gold accents
Theme: Luxury, Professional, Modern

## Architecture

### Frontend Structure
/frontend/
├── index.php (70.2 KB) - Homepage with carousel, services, projects
├── about.php (11.5 KB) - Company information & team
├── service.php (8.5 KB) - Services listing
├── service-details.php (15.6 KB) - Individual service pages
├── project.php (6 KB) - Project portfolio
├── project-details.php (16.2 KB) - Individual project showcase
├── blog.php (22.8 KB) - Blog listing with pagination
├── blog-details.php (19.5 KB) - Single blog post with comments
├── team.php (7.3 KB) - Team members page
├── testimonial.php (5.2 KB) - Client testimonials
├── contact.php (9.5 KB) - Contact form
├── quote.php (10.9 KB) - Quote request form
├── feature.php (7.4 KB) - Company features
├── page.php (4.7 KB) - Dynamic custom pages
├── 404.php (2.6 KB) - Error page
├── llms.txt (12.4 KB) - Static LLM context file
├── llms.php (13.5 KB) - This auto-updating generator
├── sitemap.xml.php (4.7 KB) - Dynamic XML sitemap

### Database Tables
Total Tables: 24

- activity_log (Rows: 0, Size: 80.00 KB)
- admin_permissions (Rows: 120, Size: 16.00 KB)
- admins (Rows: 4, Size: 16.00 KB)
- admins_backup_20251012 (Rows: 2, Size: 16.00 KB)
- blog_categories (Rows: 10, Size: 16.00 KB)
- blog_comments (Rows: 2, Size: 16.00 KB)
- blog_posts (Rows: 2, Size: 32.00 KB)
- carousel_slides (Rows: 2, Size: 64.00 KB)
- contacts (Rows: 5, Size: 80.00 KB)
- faqs (Rows: 15, Size: 32.00 KB)
- features (Rows: 4, Size: 48.00 KB)
- media_library (Rows: 14, Size: 80.00 KB)
- newsletter_subscribers (Rows: 1, Size: 80.00 KB)
- pages (Rows: 8, Size: 80.00 KB)
- project_categories (Rows: 5, Size: 64.00 KB)
- projects (Rows: 1, Size: 224.00 KB)
- quote_requests (Rows: 3, Size: 96.00 KB)
- redirects (Rows: 0, Size: 48.00 KB)
- seo_meta (Rows: 9, Size: 96.00 KB)
- services (Rows: 5, Size: 176.00 KB)
- settings (Rows: 32, Size: 64.00 KB)
- site_analytics (Rows: 351, Size: 240.00 KB)
- team_members (Rows: 1, Size: 64.00 KB)
- testimonials (Rows: 1, Size: 128.00 KB)

### Key Features

#### 1. Bilingual System
- Session-based language switching (?lang=ar or ?lang=en)
- RTL support for Arabic
- All content in both languages
- Language switcher in header and footer

#### 2. SEO Optimization
- Schema.org markup (LocalBusiness, Article, Product, etc.)
- Open Graph & Twitter Card meta tags
- AI-friendly meta tags
- Dynamic XML sitemap
- Breadcrumb navigation
- Clean URLs with .htaccess
- robots.txt

#### 3. Image Management
- Optimized image delivery
- Lazy loading
- Responsive images
- Watermark protection
- Right-click protection

#### 4. Forms & APIs
- Contact form → https://ruknamjad.com/api/submit-contact.php
- Quote form → https://ruknamjad.com/api/submit-quote.php
- Comment form → https://ruknamjad.com/api/submit-comment.php
- Newsletter → https://ruknamjad.com/api/newsletter-subscribe.php
- AJAX submissions with validation

## Helper Functions (includes/config.php)

### Database Functions
- getlang()
- getsitesetting()
- getoptimizedimageurl()
- getresponsiveimagehtml()
- getfeaturedservices()
- getfeaturedprojects()
- getteammembers()
- getfeaturedtestimonials()
- getcarouselslides()
- getfeatures()
- getpagebyslug()
- getrelatedcontent()
- getimageurl()
- getimagedimensions()

### Utility Functions
- getLang() - Available
- sanitize() - Available
- truncateText() - Available
- formatDate() - Available
- incrementViews() - Available
- getSiteSetting() - Available

## API Endpoints

## URL Structure

### Public Pages
/                          - Homepage
/about                     - About us
/service                   - Services listing
/service-details?slug=X    - Service page
/project                   - Portfolio
/project-details?slug=X    - Project page
/blog                      - Blog listing
/blog-details?slug=X       - Blog post
/team                      - Team members
/testimonial               - Testimonials
/contact                   - Contact form
/quote                     - Quote form
/feature                   - Features
/page?slug=X               - Custom page
/sitemap.xml.php           - XML sitemap
/llms.txt                  - Static LLM context
/llms.php                  - This dynamic context

### Admin Pages (password protected)
https://ruknamjad.com/admin/login.php   - Admin login
https://ruknamjad.com/admin/index.php   - Dashboard
https://ruknamjad.com/admin/[module]/   - Module management

## Responsive Breakpoints
- XS: < 576px (Mobile)
- SM: ≥ 576px (Large mobile)
- MD: ≥ 768px (Tablets)
- LG: ≥ 992px (Desktops)
- XL: ≥ 1200px (Large screens)

## Animation System
- WOW.js for scroll animations
- Owl Carousel for sliders
- Isotope for portfolio filtering
- Lightbox for image galleries
- Smooth transitions (0.3s ease)

## CSS Classes (Key)
.btn-primary       - Gold buttons
.btn-secondary     - Black buttons
.bg-primary        - Gold background
.bg-dark           - Black background
.text-primary      - Gold text
.blog-item         - Blog card styling
.team-item         - Team member card
.service-item      - Service card
.portfolio-item    - Project card
.back-to-top       - Scroll to top button

## Browser Support
- Chrome/Edge (latest)
- Firefox (latest)
- Safari (latest)
- Mobile browsers (iOS Safari, Chrome Mobile)
- IE11 (limited support)

## Performance
- Lazy loading images
- Minified CSS/JS
- CDN for libraries
- Database query optimization
- Image optimization (WebP support)
- Caching headers

## Security
- SQL injection prevention (prepared statements)
- XSS protection (htmlspecialchars)
- CSRF protection (session tokens)
- Input validation & sanitization
- Password hashing (bcrypt)
- Content Security Policy headers

## Development Guidelines

### Adding New Pages
1. Create page.php file
2. Include config.php
3. Set page meta variables
4. Include header.php
5. Add main content
6. Include footer.php
7. Add to navigation

### Language Support
```php
$lang = getLang(); // 'ar' or 'en'
$text = $lang == 'ar' ? 'نص عربي' : 'English text';
```

### RTL Handling
```php
<html lang="<?php echo $lang; ?>" dir="<?php echo $lang == 'ar' ? 'rtl' : 'ltr'; ?>">
```

## Common Tasks

### Update Site Name/Logo
File: includes/header.php (line 194-203)

### Update Contact Information
Admin panel: Settings → Site Settings

### Add Social Media Links
Admin panel: Settings → Social Media

### Change Colors
File: css/style.css (lines 2-20, CSS variables)

### Update Footer
File: includes/footer.php

### Add Navigation Item
File: includes/header.php (navigation section)

## System Information
PHP Version: 8.1.33
MySQL Version: 8.0.43
Server: Apache/2.4.65 (Debian)
Document Root: /var/www/html
Current Time: 2025-10-23 09:13:22
Timezone: UTC

## Documentation Files

## Version Information
Current Version: 1.0.0
Last Updated: 2025-10-23 09:13:22
PHP Version: 8.1.33
MySQL Version: 8.0.43
Bootstrap Version: 5.0.0

---
End of Auto-Generated LLM Context File
Refresh this page to get updated information
Static version available at: https://ruknamjad.com/llms.txt