Default page

Edit File: 05_BLOG_MANAGEMENT_SYSTEM.md

# 📝 Blog Management System - Complete Guide

## Overview

The Blog Management System is the core feature of MoveGlobal, providing comprehensive multilingual blog creation, management, and publishing capabilities.

---

## 🏗️ Blog Architecture

### **Two-Table System**

```
posts (Parent Table)
  └── Stores: Images, flags, metadata
      
post_contents (Child Table)
  └── Stores: Title, content, translations (per language)
```

**Why This Design?**
- ✅ Images shared across all language versions
- ✅ Flags (featured, slider, hero) shared
- ✅ Content fully translatable
- ✅ Efficient storage
- ✅ Easy multilingual management

---

## 📊 Blog Post Structure

### **Post Model** (Parent)

**Table**: `posts`  
**File**: `app/Models/User/Post.php`

**Fields**:
```php
[
    'user_id',              // Tenant owner
    'thumbnail_image',      // Main thumbnail
    'slider_images',        // JSON array of slider images
    'serial_number',        // Display order
    'is_slider',            // Show in homepage slider
    'slider_post_image',    // Slider-specific image
    'is_featured',          // Featured post flag
    'featured_post_image',  // Featured image
    'is_hero_post',         // Hero section post
    'hero_post_image',      // Hero image
    'image_size_type',      // Hero type: middle/side
    'views',                // Total views count
    'bookmarks'             // Total bookmarks count
]
```

**Image Types**:

| Type | Field | Size | Aspect Ratio | Usage |
|------|-------|------|--------------|-------|
| **Thumbnail** | `thumbnail_image` | ~800x600 | Flexible | Post cards, lists |
| **Featured** | `featured_post_image` | 770x508 | 3:4 | Featured section |
| **Hero Middle** | `hero_post_image` | 750x945 | 3:4 | Hero section (middle) |
| **Hero Side** | `hero_post_image` | 750x422 | 16:9 | Hero section (side) |
| **Slider** | `slider_images` | Multiple | 16:9 | Post gallery slider |
| **Slider Post** | `slider_post_image` | 770x450 | 16:9 | Homepage slider |

### **PostContent Model** (Multilingual)

**Table**: `post_contents`  
**File**: `app/Models/User/PostContent.php`

**Fields**:
```php
[
    'user_id',              // Tenant owner
    'post_id',              // Parent post
    'language_id',          // Language for this content
    'post_category_id',     // Category (can differ per language)
    'title',                // Translated title
    'slug',                 // URL-friendly slug
    'author',               // Author name
    'content',              // HTML content (translated)
    'meta_keywords',        // SEO keywords (translated)
    'meta_description',     // SEO description (translated)
    'created_at',           // Custom creation date
    'updated_at'            // Last update
]
```

**Relationships**:
```php
// PostContent model
public function post() {
    return $this->belongsTo(Post::class, 'post_id');
}

public function postCategory() {
    return $this->belongsTo(PostCategory::class, 'post_category_id');
}

public function contentLang() {
    return $this->belongsTo(Language::class, 'language_id');
}
```

---

## 🎯 Blog Features

### **1. Featured Posts**
- **Flag**: `is_featured = 1`
- **Image**: `featured_post_image`
- **Display**: Homepage featured section, special styling
- **Limit**: Defined in tenant's subscription package

**Usage**:
```php
// Get featured posts
$featuredPosts = Post::where('user_id', $userId)
    ->where('is_featured', 1)
    ->with('content')
    ->get();
```

### **2. Slider Posts**
- **Flag**: `is_slider = 1`
- **Image**: `slider_post_image` (specific for slider)
- **Images**: `slider_images` (JSON array for post detail slider)
- **Display**: Homepage carousel/slider
- **Auto-rotation**: Configurable timing

**Slider Configuration**:
```php
// In user_basic_settings or user_home_sections
[
    'slider_autoplay' => true,
    'slider_delay' => 5000, // ms
    'slider_effect' => 'fade' // or 'slide'
]
```

### **3. Hero Posts**
- **Flag**: `is_hero_post = 1`
- **Image**: `hero_post_image`
- **Types**:
  - **Middle Post**: Large vertical (750x945) - `image_size_type = 'middle'`
  - **Side Post**: Wide horizontal (750x422) - `image_size_type = 'side'`
- **Display**: Prominent homepage hero section

**Hero Section Layout**:
```
Homepage Hero Section:
┌───────────────────────────────────┐
│  [Hero Post - Large Image]        │  ← Middle Post (3:4 ratio)
│  Title                             │
│  Excerpt                           │
│  [Read More]                       │
└───────────────────────────────────┘

┌─────────────────┬─────────────────┐
│  [Hero Image]   │  Title          │  ← Side Post (16:9 ratio)
│                 │  Excerpt        │
│                 │  [Read More]    │
└─────────────────┴─────────────────┘
```

### **4. Regular Posts**
- Standard blog posts
- Can be in multiple categories (via content table)
- Fully multilingual

---

## 🌍 Multilingual System

### **How It Works**

**Create English Post**:
```php
// Step 1: Create post (images & flags)
$post = Post::create([
    'user_id' => auth()->id(),
    'thumbnail_image' => 'thumb.jpg',
    'is_featured' => true,
    'serial_number' => 1
]);

// Step 2: Create English content
PostContent::create([
    'post_id' => $post->id,
    'language_id' => 120, // English
    'post_category_id' => 26,
    'title' => 'AI Revolution',
    'content' => '<p>English content...</p>',
    'user_id' => auth()->id()
]);
```

**Add Spanish Translation**:
```php
// Step 3: Add Spanish content (same post_id)
PostContent::create([
    'post_id' => $post->id,     // Same post!
    'language_id' => 177,        // Spanish
    'post_category_id' => 27,    // Spanish category
    'title' => 'Revolución de IA',
    'content' => '<p>Contenido español...</p>',
    'user_id' => auth()->id()
]);
```

**Retrieve by Language**:
```php
// Get English version
$englishContent = PostContent::where('post_id', $postId)
    ->where('language_id', 120)
    ->first();

// Get Spanish version
$spanishContent = PostContent::where('post_id', $postId)
    ->where('language_id', 177)
    ->first();
```

### **Language Switching**

**Frontend Language Switcher**:
```blade

@foreach($languages as $language)
    <a href="{{ route('front.change.language', $language->code) }}">
        {{ $language->name }}
    </a>
@endforeach
```

**Show Content in Current Language**:
```php
// In controller
$currentLang = session('lang'); // en, es, fr, etc.
$languageId = Language::where('code', $currentLang)
    ->where('user_id', $userId)
    ->value('id');

$posts = PostContent::where('language_id', $languageId)
    ->with('post')
    ->get();
```

---

## 📂 Category System

### **Category Features**

**Per-Language Categories**:
```php
// Each category is language-specific
[
    'user_id' => 123,
    'language_id' => 120,   // English
    'name' => 'Technology',
    'is_featured' => true
]

// Same category in Spanish
[
    'user_id' => 123,
    'language_id' => 177,   // Spanish
    'name' => 'Tecnología',
    'is_featured' => true
]
```

**Category Features**:
- ✅ Multilingual names
- ✅ Category images
- ✅ Featured categories
- ✅ Serial ordering
- ✅ Active/inactive status

**Category Model**:  
**File**: `app/Models/User/PostCategory.php`

**Relationship**:
```php
// Get posts in category
$category = PostCategory::find(26);
$posts = $category->postContentList; // All posts in this category
```

---

## ✍️ Creating Blog Posts

### **Method 1: Web Dashboard**

**Route**: `/user/post/create`  
**Controller**: `User\PostController@create`

**Form Fields**:
```blade

<ul class="nav nav-tabs">
    @foreach($languages as $language)
        <li><a data-toggle="tab" href="#{{ $language->code }}">
            {{ $language->name }}
        </a></li>
    @endforeach
</ul>

<div class="tab-content">
    @foreach($languages as $language)
        <div id="{{ $language->code }}" class="tab-pane">
            <input name="{{ $language->code }}_title" required>
            <select name="{{ $language->code }}_category" required></select>
            <textarea name="{{ $language->code }}_content" class="summernote">

Thumbnail	Title	Category	Language	Views	Featured	Slider	Hero	Actions
	{{ $post->title }}	{{ $post->category->name }}	{{ $post->language->name }}	{{ $post->views }}	@if($post->is_featured) Yes @endif	...	...	Edit Delete

Thumbnail

Title