🎨 g5se 크리에이터 작품 의뢰 견적 자동 산출기 - 프로젝트 스코프 기반 견적서 생성 & 고객 승인 워크플로우

g5se가 설치된 디렉터리(루트에 `index.php`·`app/`이 있는 곳)에서 작업을 시작합니다. (g5se 설치는 https://github.com/gnuboard/g5se 참고)

이제 크리에이터 견적 관리 시스템의 골격을 만들겠습니다.

1. 폴더 구조 생성:
```bash
mkdir -p app/modules/creator-quote/dashboard
mkdir -p app/modules/creator-quote/pricing
mkdir -p app/modules/creator-quote/request
mkdir -p app/modules/creator-quote/view
```

2. `app/modules/creator-quote/index.php` 생성 (메인 랜딩 페이지):
```php
<?php
include_once('./_common.php');

require_once(G5_THEME_PATH.'/modern/_head.inc.php');
include_once('./head.sub.php');
?>
<div class="m-shell">
    <?php require G5_THEME_PATH.'/modern/_nav.inc.php'; ?>
    <main class="m-container" style="padding: 48px 20px;">
        <div style="max-width: 1200px; margin: 0 auto; text-align: center;">
            <h1 style="font-size: 2.5rem; font-weight: 700; margin-bottom: 16px; color: var(--m-text);">💼 크리에이터 견적 자동 산출 시스템</h1>
            <p style="font-size: 1.125rem; color: var(--m-text-muted); margin-bottom: 48px;">프로젝트 범위에 따라 자동으로 견적을 계산하고 고객 승인까지 한 번에</p>
            
            <div style="display: grid; grid-template-columns: repeat(auto-fit, minmax(280px, 1fr)); gap: 24px; margin-top: 48px;">
                <a href="/creator-quote/dashboard" style="background: linear-gradient(135deg, #667eea 0%, #764ba2 100%); color: white; padding: 32px; border-radius: var(--m-radius-lg); text-decoration: none; transition: transform 0.2s;" onmouseover="this.style.transform='translateY(-4px)'" onmouseout="this.style.transform='translateY(0)'">
                    <div style="font-size: 2rem; margin-bottom: 12px;">📊</div>
                    <h3 style="font-size: 1.25rem; font-weight: 600; margin-bottom: 8px;">크리에이터 대시보드</h3>
                    <p style="opacity: 0.9; font-size: 0.875rem;">의뢰 관리 & 견적 현황</p>
                </a>
                
                <a href="/creator-quote/pricing" style="background: linear-gradient(135deg, #f093fb 0%, #f5576c 100%); color: white; padding: 32px; border-radius: var(--m-radius-lg); text-decoration: none; transition: transform 0.2s;" onmouseover="this.style.transform='translateY(-4px)'" onmouseout="this.style.transform='translateY(0)'">
                    <div style="font-size: 2rem; margin-bottom: 12px;">💰</div>
                    <h3 style="font-size: 1.25rem; font-weight: 600; margin-bottom: 8px;">가격 설정</h3>
                    <p style="opacity: 0.9; font-size: 0.875rem;">작업 유형별 단가 관리</p>
                </a>
                
                <a href="/creator-quote/request" style="background: linear-gradient(135deg, #4facfe 0%, #00f2fe 100%); color: white; padding: 32px; border-radius: var(--m-radius-lg); text-decoration: none; transition: transform 0.2s;" onmouseover="this.style.transform='translateY(-4px)'" onmouseout="this.style.transform='translateY(0)'">
                    <div style="font-size: 2rem; margin-bottom: 12px;">📝</div>
                    <h3 style="font-size: 1.25rem; font-weight: 600; margin-bottom: 8px;">프로젝트 의뢰하기</h3>
                    <p style="opacity: 0.9; font-size: 0.875rem;">고객용 견적 요청 폼</p>
                </a>
            </div>
        </div>
    </main>
    <?php require G5_THEME_PATH.'/modern/_footer.inc.php'; ?>
</div>
<?php include_once('./tail.sub.php'); ?>
```

3. SQLite DB 초기화 함수 (`app/modules/creator-quote/_db.php`):
```php
<?php
if (!defined('_GNUBOARD_')) exit;

function get_creator_quote_db() {
    @mkdir(G5_DATA_PATH.'/modules', 0707, true);
    $db_path = G5_DATA_PATH.'/modules/creator-quote.sqlite';
    $pdo = new PDO('sqlite:'.$db_path);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
    // 가격 설정 테이블
    $pdo->exec("
        CREATE TABLE IF NOT EXISTS pricing (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            work_type TEXT NOT NULL,
            base_price INTEGER NOT NULL,
            created_at DATETIME DEFAULT CURRENT_TIMESTAMP
        )
    ");
    
    // 추가 옵션 테이블
    $pdo->exec("
        CREATE TABLE IF NOT EXISTS options (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            option_name TEXT NOT NULL,
            option_price INTEGER NOT NULL,
            created_at DATETIME DEFAULT CURRENT_TIMESTAMP
        )
    ");
    
    // 의뢰 테이블
    $pdo->exec("
        CREATE TABLE IF NOT EXISTS requests (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            project_title TEXT NOT NULL,
            description TEXT,
            work_type TEXT NOT NULL,
            difficulty TEXT NOT NULL,
            deadline DATE,
            customer_email TEXT NOT NULL,
            selected_options TEXT,
            reference_images TEXT,
            total_quote INTEGER NOT NULL,
            status TEXT DEFAULT 'pending',
            rejection_reason TEXT,
            created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
            updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
        )
    ");
    
    return $pdo;
}
?>
```

이 단계를 실행하면 메인 랜딩 페이지와 DB 초기화 함수가 준비됩니다. `/creator-quote`로 접속하여 3개의 카드가 표시되는지 확인하세요.

가격 설정 페이지를 만들어 크리에이터가 작업 유형별 단가와 추가 옵션을 관리할 수 있도록 하겠습니다.

`app/modules/creator-quote/pricing/index.php` 생성:
```php
<?php
include_once('./_common.php');
require_once('../_db.php');

$pdo = get_creator_quote_db();
$message = '';

// POST 처리: 작업 유형 추가
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['add_work_type'])) {
    $work_type = trim($_POST['work_type']);
    $base_price = intval($_POST['base_price']);
    
    if ($work_type && $base_price > 0) {
        $stmt = $pdo->prepare("INSERT INTO pricing (work_type, base_price) VALUES (?, ?)");
        $stmt->execute([$work_type, $base_price]);
        $message = '작업 유형이 추가되었습니다.';
    }
}

// POST 처리: 추가 옵션 추가
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['add_option'])) {
    $option_name = trim($_POST['option_name']);
    $option_price = intval($_POST['option_price']);
    
    if ($option_name && $option_price > 0) {
        $stmt = $pdo->prepare("INSERT INTO options (option_name, option_price) VALUES (?, ?)");
        $stmt->execute([$option_name, $option_price]);
        $message = '추가 옵션이 등록되었습니다.';
    }
}

// 삭제 처리
if (isset($_GET['delete_pricing'])) {
    $id = intval($_GET['delete_pricing']);
    $pdo->prepare("DELETE FROM pricing WHERE id = ?")->execute([$id]);
    header('Location: /creator-quote/pricing');
    exit;
}

if (isset($_GET['delete_option'])) {
    $id = intval($_GET['delete_option']);
    $pdo->prepare("DELETE FROM options WHERE id = ?")->execute([$id]);
    header('Location: /creator-quote/pricing');
    exit;
}

// 데이터 조회
$work_types = $pdo->query("SELECT * FROM pricing ORDER BY id DESC")->fetchAll(PDO::FETCH_ASSOC);
$options = $pdo->query("SELECT * FROM options ORDER BY id DESC")->fetchAll(PDO::FETCH_ASSOC);

require_once(G5_THEME_PATH.'/modern/_head.inc.php');
include_once('./head.sub.php');
?>
<style>
.pricing-section {
    background: var(--m-surface);
    padding: 24px;
    border-radius: var(--m-radius-lg);
    box-shadow: var(--m-shadow);
    margin-bottom: 32px;
}
.pricing-table {
    width: 100%;
    border-collapse: collapse;
    margin-top: 16px;
}
.pricing-table th,
.pricing-table td {
    padding: 12px;
    text-align: left;
    border-bottom: 1px solid rgba(0,0,0,0.05);
}
.pricing-table th {
    font-weight: 600;
    color: var(--m-text);
}
.pricing-table td {
    color: var(--m-text-muted);
}
.btn-delete {
    background: #ef4444;
    color: white;
    border: none;
    padding: 6px 12px;
    border-radius: 6px;
    cursor: pointer;
    font-size: 0.875rem;
}
.form-group {
    margin-bottom: 16px;
}
.form-group label {
    display: block;
    font-weight: 500;
    margin-bottom: 8px;
    color: var(--m-text);
}
.form-group input {
    width: 100%;
    padding: 10px;
    border: 1px solid rgba(0,0,0,0.1);
    border-radius: 8px;
    font-size: 1rem;
    background: var(--m-surface);
    color: var(--m-text);
}
.btn-submit {
    background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
    color: white;
    border: none;
    padding: 12px 24px;
    border-radius: 8px;
    cursor: pointer;
    font-size: 1rem;
    font-weight: 600;
}
</style>
<div class="m-shell">
    <?php require G5_THEME_PATH.'/modern/_nav.inc.php'; ?>
    <main class="m-container" style="padding: 48px 20px; max-width: 1200px; margin: 0 auto;">
        <h1 style="font-size: 2rem; font-weight: 700; margin-bottom: 32px; color: var(--m-text);">💰 가격 설정 관리</h1>
        
        <?php if ($message): ?>
        <div style="background: #10b981; color: white; padding: 16px; border-radius: 8px; margin-bottom: 24px;">
            <?php echo htmlspecialchars($message); ?>
        </div>
        <?php endif; ?>
        
        <!-- 작업 유형 추가 -->
        <div class="pricing-section">
            <h2 style="font-size: 1.5rem; font-weight: 600; margin-bottom: 16px; color: var(--m-text);">작업 유형 추가</h2>
            <form method="POST">
                <div style="display: grid; grid-template-columns: 2fr 1fr auto; gap: 12px; align-items: end;">
                    <div class="form-group" style="margin-bottom: 0;">
                        <label>작업 유형</label>
                        <input type="text" name="work_type" placeholder="예: 캐릭터 디자인" required>
                    </div>
                    <div class="form-group" style="margin-bottom: 0;">
                        <label>기본 단가 (원)</label>
                        <input type="number" name="base_price" placeholder="50000" required>
                    </div>
                    <button type="submit" name="add_work_type" class="btn-submit">추가</button>
                </div>
            </form>
            
            <table class="pricing-table">
                <thead>
                    <tr>
                        <th>작업 유형</th>
                        <th>기본 단가</th>
                        <th>관리</th>
                    </tr>
                </thead>
                <tbody>
                    <?php foreach ($work_types as $wt): ?>
                    <tr>
                        <td><?php echo htmlspecialchars($wt['work_type']); ?></td>
                        <td><?php echo number_format($wt['base_price']); ?>원</td>
                        <td><a href="?delete_pricing=<?php echo $wt['id']; ?>" class="btn-delete" onclick="return confirm('삭제하시겠습니까?')">삭제</a></td>
                    </tr>
                    <?php endforeach; ?>
                </tbody>
            </table>
        </div>
        
        <!-- 추가 옵션 추가 -->
        <div class="pricing-section">
            <h2 style="font-size: 1.5rem; font-weight: 600; margin-bottom: 16px; color: var(--m-text);">추가 옵션 등록</h2>
            <form method="POST">
                <div style="display: grid; grid-template-columns: 2fr 1fr auto; gap: 12px; align-items: end;">
                    <div class="form-group" style="margin-bottom: 0;">
                        <label>옵션명</label>
                        <input type="text" name="option_name" placeholder="예: 수정 3회" required>
                    </div>
                    <div class="form-group" style="margin-bottom: 0;">
                        <label>추가 금액 (원)</label>
                        <input type="number" name="option_price" placeholder="10000" required>
                    </div>
                    <button type="submit" name="add_option" class="btn-submit">추가</button>
                </div>
            </form>
            
            <table class="pricing-table">
                <thead>
                    <tr>
                        <th>옵션명</th>
                        <th>추가 금액</th>
                        <th>관리</th>
                    </tr>
                </thead>
                <tbody>
                    <?php foreach ($options as $opt): ?>
                    <tr>
                        <td><?php echo htmlspecialchars($opt['option_name']); ?></td>
                        <td>+<?php echo number_format($opt['option_price']); ?>원</td>
                        <td><a href="?delete_option=<?php echo $opt['id']; ?>" class="btn-delete" onclick="return confirm('삭제하시겠습니까?')">삭제</a></td>
                    </tr>
                    <?php endforeach; ?>
                </tbody>
            </table>
        </div>
        
        <div style="text-align: center; margin-top: 32px;">
            <a href="/creator-quote" style="color: var(--m-text-muted); text-decoration: none;">← 메인으로 돌아가기</a>
        </div>
    </main>
    <?php require G5_THEME_PATH.'/modern/_footer.inc.php'; ?>
</div>
<?php include_once('./tail.sub.php'); ?>
```

이 페이지에서 작업 유형(예: 로고 디자인, 일러스트)과 추가 옵션(예: 급행료, 수정 횟수)을 CRUD할 수 있습니다.

고객용 프로젝트 의뢰 접수 폼을 만들어 자동 견적 산출이 이루어지도록 하겠습니다.

`app/modules/creator-quote/request/index.php` 생성:
```php
<?php
include_once('./_common.php');
require_once('../_db.php');

$pdo = get_creator_quote_db();
$message = '';
$quote_id = null;

// POST 처리
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $project_title = trim($_POST['project_title']);
    $description = trim($_POST['description']);
    $work_type = trim($_POST['work_type']);
    $difficulty = $_POST['difficulty']; // simple, normal, complex
    $deadline = $_POST['deadline'];
    $customer_email = trim($_POST['customer_email']);
    $selected_options = isset($_POST['options']) ? $_POST['options'] : [];
    
    // 파일 업로드 처리
    $upload_dir = G5_DATA_PATH.'/modules/creator-quote/uploads/';
    @mkdir($upload_dir, 0707, true);
    $uploaded_files = [];
    
    if (isset($_FILES['reference_images'])) {
        foreach ($_FILES['reference_images']['tmp_name'] as $key => $tmp_name) {
            if ($_FILES['reference_images']['error'][$key] === UPLOAD_ERR_OK) {
                $ext = strtolower(pathinfo($_FILES['reference_images']['name'][$key], PATHINFO_EXTENSION));
                $allowed = ['jpg', 'jpeg', 'png', 'gif', 'webp'];
                if (in_array($ext, $allowed)) {
                    $filename = uniqid().'.'.$ext;
                    move_uploaded_file($tmp_name, $upload_dir.$filename);
                    $uploaded_files[] = $filename;
                }
            }
        }
    }
    
    // 견적 계산
    $stmt = $pdo->prepare("SELECT base_price FROM pricing WHERE work_type = ?");
    $stmt->execute([$work_type]);
    $base_price = $stmt->fetchColumn();
    
    $difficulty_multiplier = ['simple' => 1.0, 'normal' => 1.5, 'complex' => 2.0];
    $total = $base_price * $difficulty_multiplier[$difficulty];
    
    // 추가 옵션 합산
    $option_total = 0;
    if (!empty($selected_options)) {
        $placeholders = implode(',', array_fill(0, count($selected_options), '?'));
        $stmt = $pdo->prepare("SELECT SUM(option_price) FROM options WHERE id IN ($placeholders)");
        $stmt->execute($selected_options);
        $option_total = $stmt->fetchColumn();
    }
    $total += $option_total;
    
    // DB 저장
    $stmt = $pdo->prepare("
        INSERT INTO requests 
        (project_title, description, work_type, difficulty, deadline, customer_email, selected_options, reference_images, total_quote) 
        VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
    ");
    $stmt->execute([
        $project_title,
        $description,
        $work_type,
        $difficulty,
        $deadline,
        $customer_email,
        json_encode($selected_options),
        json_encode($uploaded_files),
        $total
    ]);
    $quote_id = $pdo->lastInsertId();
    $message = '견적 요청이 접수되었습니다!';
}

// 작업 유형 목록
$work_types = $pdo->query("SELECT * FROM pricing ORDER BY work_type")->fetchAll(PDO::FETCH_ASSOC);
$options = $pdo->query("SELECT * FROM options ORDER BY option_name")->fetchAll(PDO::FETCH_ASSOC);

require_once(G5_THEME_PATH.'/modern/_head.inc.php');
include_once('./head.sub.php');
?>
<style>
.request-form {
    background: var(--m-surface);
    padding: 32px;
    border-radius: var(--m-radius-lg);
    box-shadow: var(--m-shadow);
    max-width: 800px;
    margin: 0 auto;
}
.form-section {
    margin-bottom: 32px;
}
.form-section h3 {
    font-size: 1.25rem;
    font-weight: 600;
    margin-bottom: 16px;
    color: var(--m-text);
}
.form-group {
    margin-bottom: 20px;
}
.form-group label {
    display: block;
    font-weight: 500;
    margin-bottom: 8px;
    color: var(--m-text);
}
.form-group input,
.form-group select,
.form-group textarea {
    width: 100%;
    padding: 12px;
    border: 1px solid rgba(0,0,0,0.1);
    border-radius: 8px;
    font-size: 1rem;
    background: var(--m-surface);
    color: var(--m-text);
}
.form-group textarea {
    min-height: 120px;
    resize: vertical;
}
.radio-group {
    display: flex;
    gap: 16px;
}
.radio-group label {
    display: flex;
    align-items: center;
    gap: 8px;
    cursor: pointer;
}
.checkbox-group {
    display: grid;
    gap: 12px;
}
.checkbox-group label {
    display: flex;
    align-items: center;
    gap: 8px;
    cursor: pointer;
}
.btn-submit {
    background: linear-gradient(135deg, #4facfe 0%, #00f2fe 100%);
    color: white;
    border: none;
    padding: 16px 32px;
    border-radius: 8px;
    cursor: pointer;
    font-size: 1.125rem;
    font-weight: 600;
    width: 100%;
}
</style>
<div class="m-shell">
    <?php require G5_THEME_PATH.'/modern/_nav.inc.php'; ?>
    <main class="m-container" style="padding: 48px 20px;">
        <h1 style="font-size: 2rem; font-weight: 700; margin-bottom: 32px; text-align: center; color: var(--m-text);">📝 프로젝트 의뢰하기</h1>
        
        <?php if ($message): ?>
        <div style="background: #10b981; color: white; padding: 20px; border-radius: 8px; margin-bottom: 24px; text-align: center; max-width: 800px; margin-left: auto; margin-right: auto;">
            <?php echo htmlspecialchars($message); ?><br>
            <a href="/creator-quote/view/<?php echo $quote_id; ?>" style="color: white; text-decoration: underline; font-weight: 600; margin-top: 8px; display: inline-block;">견적서 확인하기 →</a>
        </div>
        <?php endif; ?>
        
        <form method="POST" enctype="multipart/form-data" class="request-form">
            <!-- 프로젝트 정보 -->
            <div class="form-section">
                <h3>프로젝트 정보</h3>
                <div class="form-group">
                    <label>프로젝트 제목 *</label>
                    <input type="text" name="project_title" placeholder="예: 브랜드 로고 디자인" required>
                </div>
                <div class="form-group">
                    <label>상세 설명 *</label>
                    <textarea name="description" placeholder="프로젝트 내용을 자세히 설명해주세요" required></textarea>
                </div>
            </div>
            
            <!-- 작업 유형 & 난이도 -->
            <div class="form-section">
                <h3>작업 유형 & 난이도</h3>
                <div class="form-group">
                    <label>작업 유형 *</label>
                    <select name="work_type" required>
                        <option value="">선택하세요</option>
                        <?php foreach ($work_types as $wt): ?>
                        <option value="<?php echo htmlspecialchars($wt['work_type']); ?>">
                            <?php echo htmlspecialchars($wt['work_type']); ?> (기본 <?php echo number_format($wt['base_price']); ?>원)
                        </option>
                        <?php endforeach; ?>
                    </select>
                </div>
                <div class="form-group">
                    <label>난이도 *</label>
                    <div class="radio-group">
                        <label><input type="radio" name="difficulty" value="simple" required> 간단 (×1.0)</label>
                        <label><input type="radio" name="difficulty" value="normal" checked> 보통 (×1.5)</label>
                        <label><input type="radio" name="difficulty" value="complex"> 복잡 (×2.0)</label>
                    </div>
                </div>
            </div>
            
            <!-- 추가 옵션 -->
            <?php if (!empty($options)): ?>
            <div class="form-section">
                <h3>추가 옵션</h3>
                <div class="checkbox-group">
                    <?php foreach ($options as $opt): ?>
                    <label>
                        <input type="checkbox" name="options[]" value="<?php echo $opt['id']; ?>">
                        <?php echo htmlspecialchars($opt['option_name']); ?> (+<?php echo number_format($opt['option_price']); ?>원)
                    </label>
                    <?php endforeach; ?>
                </div>
            </div>
            <?php endif; ?>
            
            <!-- 납기일 & 연락처 -->
            <div class="form-section">
                <h3>납기일 & 연락처</h3>
                <div class="form-group">
                    <label>희망 납기일</label>
                    <input type="date" name="deadline">
                </div>
                <div class="form-group">
                    <label>이메일 *</label>
                    <input type="email" name="customer_email" placeholder="your@email.com" required>
                </div>
            </div>
            
            <!-- 참고 이미지 -->
            <div class="form-section">
                <h3>참고 이미지 (최대 3장)</h3>
                <div class="form-group">
                    <input type="file" name="reference_images[]" accept="image/*" multiple>
                </div>
            </div>
            
            <button type="submit" class="btn-submit">견적 요청하기</button>
        </form>
        
        <div style="text-align: center; margin-top: 32px;">
            <a href="/creator-quote" style="color: var(--m-text-muted); text-decoration: none;">← 메인으로 돌아가기</a>
        </div>
    </main>
    <?php require G5_THEME_PATH.'/modern/_footer.inc.php'; ?>
</div>
<?php include_once('./tail.sub.php'); ?>
```

이 폼은 고객이 프로젝트 정보를 입력하면 자동으로 견적을 계산하여 DB에 저장합니다.

고객이 견적을 확인하고 승인/거절할 수 있는 페이지를 만들겠습니다. 동적 segment를 활용합니다.

`app/modules/creator-quote/view/[id]/index.php` 생성:
```php
<?php
include_once('./_common.php');
require_once('../../_db.php');

$pdo = get_creator_quote_db();
$request_id = intval($_GET['id']);
$message = '';

// 승인/거절 처리
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (isset($_POST['approve'])) {
        $stmt = $pdo->prepare("UPDATE requests SET status = 'approved', updated_at = CURRENT_TIMESTAMP WHERE id = ?");
        $stmt->execute([$request_id]);
        $message = '견적이 승인되었습니다! 크리에이터가 곧 연락드릴 예정입니다.';
    } elseif (isset($_POST['reject'])) {
        $reason = trim($_POST['rejection_reason']);
        $stmt = $pdo->prepare("UPDATE requests SET status = 'rejected', rejection_reason = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ?");
        $stmt->execute([$reason, $request_id]);
        $message = '견적이 거절되었습니다. 사유가 크리에이터에게 전달되었습니다.';
    }
}

// 의뢰 정보 조회
$stmt = $pdo->prepare("SELECT * FROM requests WHERE id = ?");
$stmt->execute([$request_id]);
$request = $stmt->fetch(PDO::FETCH_ASSOC);

if (!$request) {
    die('존재하지 않는 견적 요청입니다.');
}

// 작업 유형 정보
$stmt = $pdo->prepare("SELECT base_price FROM pricing WHERE work_type = ?");
$stmt->execute([$request['work_type']]);
$base_price = $stmt->fetchColumn();

// 난이도 배율
$difficulty_map = ['simple' => '간단 (×1.0)', 'normal' => '보통 (×1.5)', 'complex' => '복잡 (×2.0)'];
$difficulty_multiplier = ['simple' => 1.0, 'normal' => 1.5, 'complex' => 2.0];

// 추가 옵션 정보
$selected_options = json_decode($request['selected_options'], true) ?: [];
$option_details = [];
if (!empty($selected_options)) {
    $placeholders = implode(',', array_fill(0, count($selected_options), '?'));
    $stmt = $pdo->prepare("SELECT * FROM options WHERE id IN ($placeholders)");
    $stmt->execute($selected_options);
    $option_details = $stmt->fetchAll(PDO::FETCH_ASSOC);
}

require_once(G5_THEME_PATH.'/modern/_head.inc.php');
include_once('./head.sub.php');
?>
<style>
.quote-card {
    background: var(--m-surface);
    padding: 32px;
    border-radius: var(--m-radius-lg);
    box-shadow: var(--m-shadow);
    max-width: 900px;
    margin: 0 auto;
}
.quote-header {
    border-bottom: 2px solid rgba(0,0,0,0.1);
    padding-bottom: 16px;
    margin-bottom: 24px;
}
.quote-section {
    margin-bottom: 24px;
}
.quote-section h3 {
    font-size: 1.125rem;
    font-weight: 600;
    margin-bottom: 12px;
    color: var(--m-text);
}
.quote-table {
    width: 100%;
    border-collapse: collapse;
}
.quote-table td {
    padding: 12px 0;
    border-bottom: 1px solid rgba(0,0,0,0.05);
}
.quote-table td:last-child {
    text-align: right;
    font-weight: 600;
}
.total-row {
    font-size: 1.25rem;
    font-weight: 700;
    color: #667eea;
}
.btn-group {
    display: flex;
    gap: 12px;
    margin-top: 32px;
}
.btn {
    flex: 1;
    padding: 16px;
    border: none;
    border-radius: 8px;
    font-size: 1rem;
    font-weight: 600;
    cursor: pointer;
}
.btn-approve {
    background: linear-gradient(135deg, #10b981 0%, #059669 100%);
    color: white;
}
.btn-reject {
    background: linear-gradient(135deg, #ef4444 0%, #dc2626 100%);
    color: white;
}
.status-badge {
    display: inline-block;
    padding: 6px 12px;
    border-radius: 6px;
    font-size: 0.875rem;
    font-weight: 600;
}
.status-pending { background: #fbbf24; color: #78350f; }
.status-approved { background: #10b981; color: white; }
.status-rejected { background: #ef4444; color: white; }
</style>
<div class="m-shell">
    <?php require G5_THEME_PATH.'/modern/_nav.inc.php'; ?>
    <main class="m-container" style="padding: 48px 20px;">
        <h1 style="font-size: 2rem; font-weight: 700; margin-bottom: 32px; text-align: center; color: var(--m-text);">📄 견적서</h1>
        
        <?php if ($message): ?>
        <div style="background: #10b981; color: white; padding: 20px; border-radius: 8px; margin-bottom: 24px; text-align: center; max-width: 900px; margin-left: auto; margin-right: auto;">
            <?php echo htmlspecialchars($message); ?>
        </div>
        <?php endif; ?>
        
        <div class="quote-card">
            <div class="quote-header">
                <div style="display: flex; justify-content: space-between; align-items: center;">
                    <h2 style="font-size: 1.5rem; font-weight: 700; color: var(--m-text);"><?php echo htmlspecialchars($request['project_title']); ?></h2>
                    <span class="status-badge status-<?php echo $request['status']; ?>">
                        <?php echo ['pending' => '대기중', 'approved' => '승인됨', 'rejected' => '거절됨'][$request['status']]; ?>
                    </span>
                </div>
                <p style="color: var(--m-text-muted); margin-top: 8px;">접수일: <?php echo date('Y-m-d H:i', strtotime($request['created_at'])); ?></p>
            </div>
            
            <div class="quote-section">
                <h3>프로젝트 상세</h3>
                <p style="color: var(--m-text-muted); line-height: 1.6;"><?php echo nl2br(htmlspecialchars($request['description'])); ?></p>
            </div>
            
            <div class="quote-section">
                <h3>견적 내역</h3>
                <table class="quote-table">
                    <tr>
                        <td style="color: var(--m-text);">작업 유형</td>
                        <td><?php echo htmlspecialchars($request['work_type']); ?></td>
                    </tr>
                    <tr>
                        <td style="color: var(--m-text);">기본 단가</td>
                        <td><?php echo number_format($base_price); ?>원</td>
                    </tr>
                    <tr>
                        <td style="color: var(--m-text);">난이도</td>
                        <td><?php echo $difficulty_map[$request['difficulty']]; ?></td>
                    </tr>
                    <tr>
                        <td style="color: var(--m-text);">작업비 (단가 × 난이도)</td>
                        <td><?php echo number_format($base_price * $difficulty_multiplier[$request['difficulty']]); ?>원</td>
                    </tr>
                    <?php foreach ($option_details as $opt): ?>
                    <tr>
                        <td style="color: var(--m-text);"><?php echo htmlspecialchars($opt['option_name']); ?></td>
                        <td>+<?php echo number_format($opt['option_price']); ?>원</td>
                    </tr>
                    <?php endforeach; ?>
                    <tr class="total-row">
                        <td>최종 견적</td>
                        <td><?php echo number_format($request['total_quote']); ?>원</td>
                    </tr>
                </table>
            </div>
            
            <?php if ($request['deadline']): ?>
            <div class="quote-section">
                <h3>희망 납기일</h3>
                <p style="color: var(--m-text-muted);"><?php echo date('Y년 m월 d일', strtotime($request['deadline'])); ?></p>
            </div>
            <?php endif; ?>
            
            <?php if ($request['status'] === 'pending'): ?>
            <form method="POST">
                <div class="btn-group">
                    <button type="submit" name="approve" class="btn btn-approve">✓ 견적 승인</button>
                    <button type="button" class="btn btn-reject" onclick="showRejectForm()">✗ 견적 거절</button>
                </div>
                <div id="reject-form" style="display: none; margin-top: 16px;">
                    <textarea name="rejection_reason" placeholder="거절 사유를 입력해주세요 (선택)" style="width: 100%; padding: 12px; border: 1px solid rgba(0,0,0,0.1); border-radius: 8px; min-height: 80px;"></textarea>
                    <button type="submit" name="reject" class="btn btn-reject" style="width: 100%; margin-top: 12px;">거절 확정</button>
                </div>
            </form>
            <?php elseif ($request['status'] === 'rejected' && $request['rejection_reason']): ?>
            <div style="background: #fef2f2; padding: 16px; border-radius: 8px; margin-top: 16px;">
                <h4 style="font-weight: 600; color: #ef4444; margin-bottom: 8px;">거절 사유</h4>
                <p style="color: #7f1d1d;"><?php echo nl2br(htmlspecialchars($request['rejection_reason'])); ?></p>
            </div>
            <?php endif; ?>
        </div>
        
        <div style="text-align: center; margin-top: 32px;">
            <a href="/creator-quote" style="color: var(--m-text-muted); text-decoration: none;">← 메인으로 돌아가기</a>
        </div>
    </main>
    <?php require G5_THEME_PATH.'/modern/_footer.inc.php'; ?>
</div>
<script>
function showRejectForm() {
    document.getElementById('reject-form').style.display = 'block';
}
</script>
<?php include_once('./tail.sub.php'); ?>
```

이 페이지는 `/creator-quote/view/{id}` 형식으로 접근하며, 견적 내역과 승인/거절 버튼을 제공합니다.

크리에이터 대시보드를 만들어 접수된 의뢰를 관리할 수 있도록 하겠습니다.

`app/modules/creator-quote/dashboard/index.php` 생성:
```php
<?php
include_once('./_common.php');
require_once('../_db.php');

$pdo = get_creator_quote_db();

// 필터링
$filter = isset($_GET['filter']) ? $_GET['filter'] : 'all';
$where = $filter === 'all' ? '' : "WHERE status = '".$pdo->quote($filter)."'";

$requests = $pdo->query("SELECT * FROM requests $where ORDER BY created_at DESC")->fetchAll(PDO::FETCH_ASSOC);

// 통계
$stats = $pdo->query("
    SELECT 
        COUNT(*) as total,
        SUM(CASE WHEN status = 'pending' THEN 1 ELSE 0 END) as pending,
        SUM(CASE WHEN status = 'approved' THEN 1 ELSE 0 END) as approved,
        SUM(CASE WHEN status = 'rejected' THEN 1 ELSE 0 END) as rejected,
        SUM(CASE WHEN status = 'approved' THEN total_quote ELSE 0 END) as total_revenue
    FROM requests
")->fetch(PDO::FETCH_ASSOC);

require_once(G5_THEME_PATH.'/modern/_head.inc.php');
include_once('./head.sub.php');
?>
<style>
.stats-grid {
    display: grid;
    grid-template-columns: repeat(auto-fit, minmax(200px, 1fr));
    gap: 16px;
    margin-bottom: 32px;
}
.stat-card {
    background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
    color: white;
    padding: 24px;
    border-radius: var(--m-radius-lg);
    text-align: center;
}
.stat-card h3 {
    font-size: 2rem;
    font-weight: 700;
    margin-bottom: 8px;
}
.stat-card p {
    opacity: 0.9;
    font-size: 0.875rem;
}
.filter-tabs {
    display: flex;
    gap: 8px;
    margin-bottom: 24px;
    flex-wrap: wrap;
}
.filter-tabs a {
    padding: 10px 20px;
    border-radius: 8px;
    text-decoration: none;
    font-weight: 500;
    transition: all 0.2s;
}
.filter-tabs a.active {
    background: #667eea;
    color: white;
}
.filter-tabs a:not(.active) {
    background: var(--m-surface);
    color: var(--m-text-muted);
}
.request-table {
    background: var(--m-surface);
    border-radius: var(--m-radius-lg);
    box-shadow: var(--m-shadow);
    overflow: hidden;
}
.request-table table {
    width: 100%;
    border-collapse: collapse;
}
.request-table th,
.request-table td {
    padding: 16px;
    text-align: left;
    border-bottom: 1px solid rgba(0,0,0,0.05);
}
.request-table th {
    background: rgba(0,0,0,0.02);
    font-weight: 600;
    color: var(--m-text);
}
.request-table td {
    color: var(--m-text-muted);
}
.status-badge {
    display: inline-block;
    padding: 4px 12px;
    border-radius: 12px;
    font-size: 0.875rem;
    font-weight: 600;
}
.status-pending { background: #fef3c7; color: #92400e; }
.status-approved { background: #d1fae5; color: #065f46; }
.status-rejected { background: #fee2e2; color: #991b1b; }
.btn-view {
    background: #667eea;
    color: white;
    padding: 6px 16px;
    border-radius: 6px;
    text-decoration: none;
    font-size: 0.875rem;
    font-weight: 500;
}
@media (max-width: 768px) {
    .request-table {
        overflow-x: auto;
    }
}
</style>
<div class="m-shell">
    <?php require G5_THEME_PATH.'/modern/_nav.inc.php'; ?>
    <main class="m-container" style="padding: 48px 20px; max-width: 1400px; margin: 0 auto;">
        <h1 style="font-size: 2rem; font-weight: 700; margin-bottom: 32px; color: var(--m-text);">📊 크리에이터 대시보드</h1>
        
        <!-- 통계 카드 -->
        <div class="stats-grid">
            <div class="stat-card" style="background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);">
                <h3><?php echo $stats['total']; ?></h3>
                <p>전체 의뢰</p>
            </div>
            <div class="stat-card" style="background: linear-gradient(135deg, #fbbf24 0%, #f59e0b 100%);">
                <h3><?php echo $stats['pending']; ?></h3>
                <p>대기중</p>
            </div>
            <div class="stat-card" style="background: linear-gradient(135deg, #10b981 0%, #059669 100%);">
                <h3><?php echo $stats['approved']; ?></h3>
                <p>승인됨</p>
            </div>
            <div class="stat-card" style="background: linear-gradient(135deg, #ef4444 0%, #dc2626 100%);">
                <h3><?php echo $stats['rejected']; ?></h3>
                <p>거절됨</p>
            </div>
            <div class="stat-card" style="background: linear-gradient(135deg, #8b5cf6 0%, #7c3aed 100%);">
                <h3><?php echo number_format($stats['total_revenue']); ?>원</h3>
                <p>총 수익 (승인)</p>
            </div>
        </div>
        
        <!-- 필터 탭 -->
        <div class="filter-tabs">
            <a href="?filter=all" class="<?php echo $filter === 'all' ? 'active' : ''; ?>">전체</a>
            <a href="?filter=pending" class="<?php echo $filter === 'pending' ? 'active' : ''; ?>">대기중</a>
            <a href="?filter=approved" class="<?php echo $filter === 'approved' ? 'active' : ''; ?>">승인됨</a>
            <a href="?filter=rejected" class="<?php echo $filter === 'rejected' ? 'active' : ''; ?>">거절됨</a>
        </div>
        
        <!-- 의뢰 목록 -->
        <div class="request-table">
            <table>
                <thead>
                    <tr>
                        <th>ID</th>
                        <th>프로젝트명</th>
                        <th>작업 유형</th>
                        <th>고객 이메일</th>
                        <th>견적 금액</th>
                        <th>상태</th>
                        <th>접수일</th>
                        <th>관리</th>
                    </tr>
                </thead>
                <tbody>
                    <?php if (empty($requests)): ?>
                    <tr>
                        <td colspan="8" style="text-align: center; padding: 48px; color: var(--m-text-muted);">의뢰가 없습니다.</td>
                    </tr>
                    <?php else: ?>
                    <?php foreach ($requests as $req): ?>
                    <tr>
                        <td style="font-weight: 600; color: var(--m-text);">#<?php echo $req['id']; ?></td>
                        <td style="color: var(--m-text);"><?php echo htmlspecialchars(mb_substr($req['project_title'], 0, 30)); ?></td>
                        <td><?php echo htmlspecialchars($req['work_type']); ?></td>
                        <td><?php echo htmlspecialchars($req['customer_email']); ?></td>
                        <td style="font-weight: 600; color: #667eea;"><?php echo number_format($req['total_quote']); ?>원</td>
                        <td>
                            <span class="status-badge status-<?php echo $req['status']; ?>">
                                <?php echo ['pending' => '대기', 'approved' => '승인', 'rejected' => '거절'][$req['status']]; ?>
                            </span>
                        </td>
                        <td><?php echo date('Y-m-d', strtotime($req['created_at'])); ?></td>
                        <td>
                            <a href="/creator-quote/view/<?php echo $req['id']; ?>" class="btn-view">상세</a>
                        </td>
                    </tr>
                    <?php endforeach; ?>
                    <?php endif; ?>
                </tbody>
            </table>
        </div>
        
        <div style="text-align: center; margin-top: 32px;">
            <a href="/creator-quote" style="color: var(--m-text-muted); text-decoration: none;">← 메인으로 돌아가기</a>
        </div>
    </main>
    <?php require G5_THEME_PATH.'/modern/_footer.inc.php'; ?>
</div>
<?php include_once('./tail.sub.php'); ?>
```

이 대시보드는 의뢰 통계(전체/대기/승인/거절/총 수익)와 필터링된 의뢰 목록을 테이블로 표시합니다.

견적서 PDF 다운로드 기능을 추가하여 고객과 크리에이터가 견적서를 저장할 수 있도록 하겠습니다. PHP의 TCPDF 라이브러리를 사용합니다.

먼저 TCPDF를 수동으로 다운로드하여 프로젝트에 포함시킵니다 (composer 사용 금지):
1. https://github.com/tecnickcom/TCPDF/releases 에서 최신 버전 다운로드
2. `app/modules/creator-quote/vendor/tcpdf/` 폴더에 압축 해제

그 다음 PDF 생성 스크립트를 만듭니다.

`app/modules/creator-quote/download-pdf.php` 생성:
```php
<?php
include_once('./_common.php');
require_once('./_db.php');

$request_id = intval($_GET['id']);
$pdo = get_creator_quote_db();

// 의뢰 정보 조회
$stmt = $pdo->prepare("SELECT * FROM requests WHERE id = ?");
$stmt->execute([$request_id]);
$request = $stmt->fetch(PDO::FETCH_ASSOC);

if (!$request) {
    die('존재하지 않는 견적입니다.');
}

// 작업 유형 정보
$stmt = $pdo->prepare("SELECT base_price FROM pricing WHERE work_type = ?");
$stmt->execute([$request['work_type']]);
$base_price = $stmt->fetchColumn();

// 난이도 배율
$difficulty_map = ['simple' => '간단 (×1.0)', 'normal' => '보통 (×1.5)', 'complex' => '복잡 (×2.0)'];
$difficulty_multiplier = ['simple' => 1.0, 'normal' => 1.5, 'complex' => 2.0];

// 추가 옵션 정보
$selected_options = json_decode($request['selected_options'], true) ?: [];
$option_details = [];
if (!empty($selected_options)) {
    $placeholders = implode(',', array_fill(0, count($selected_options), '?'));
    $stmt = $pdo->prepare("SELECT * FROM options WHERE id IN ($placeholders)");
    $stmt->execute($selected_options);
    $option_details = $stmt->fetchAll(PDO::FETCH_ASSOC);
}

// TCPDF 라이브러리 로드
require_once(__DIR__.'/vendor/tcpdf/tcpdf.php');

// PDF 생성
$pdf = new TCPDF('P', 'mm', 'A4', true, 'UTF-8', false);
$pdf->SetCreator('Creator Quote System');
$pdf->SetAuthor('Creator');
$pdf->SetTitle('견적서 - '.$request['project_title']);
$pdf->SetSubject('프로젝트 견적서');

// 헤더/푸터 제거
$pdf->setPrintHeader(false);
$pdf->setPrintFooter(false);

$pdf->SetMargins(15, 15, 15);
$pdf->SetAutoPageBreak(true, 15);
$pdf->AddPage();

// 한글 폰트 설정 (기본 내장 폰트 사용)
$pdf->SetFont('helvetica', '', 10);

// HTML 콘텐츠
$html = '
<h1 style="text-align: center; color: #667eea; margin-bottom: 20px;">프로젝트 견적서</h1>
<hr style="border: 1px solid #667eea;">

<h2 style="margin-top: 20px;">프로젝트 정보</h2>
<table cellpadding="5" style="width: 100%; border: 1px solid #ddd;">
    <tr style="background-color: #f9f9f9;">
        <td style="width: 30%; font-weight: bold;">프로젝트명</td>
        <td>'.htmlspecialchars($request['project_title']).'</td>
    </tr>
    <tr>
        <td style="font-weight: bold;">고객 이메일</td>
        <td>'.htmlspecialchars($request['customer_email']).'</td>
    </tr>
    <tr style="background-color: #f9f9f9;">
        <td style="font-weight: bold;">접수일</td>
        <td>'.date('Y-m-d H:i', strtotime($request['created_at'])).'</td>
    </tr>
</table>

<h2 style="margin-top: 20px;">상세 설명</h2>
<p style="line-height: 1.6;">'.nl2br(htmlspecialchars($request['description'])).'</p>

<h2 style="margin-top: 20px;">견적 내역</h2>
<table cellpadding="5" style="width: 100%; border: 1px solid #ddd;">
    <tr style="background-color: #f9f9f9;">
        <td style="width: 70%; font-weight: bold;">항목</td>
        <td style="text-align: right; font-weight: bold;">금액</td>
    </tr>
    <tr>
        <td>작업 유형: '.htmlspecialchars($request['work_type']).'</td>
        <td style="text-align: right;">'.number_format($base_price).'원</td>
    </tr>
    <tr style="background-color: #f9f9f9;">
        <td>난이도: '.$difficulty_map[$request['difficulty']].'</td>
        <td style="text-align: right;">'.number_format($base_price * $difficulty_multiplier[$request['difficulty']]).'원</td>
    </tr>
';

foreach ($option_details as $opt) {
    $html .= '
    <tr>
        <td>'.htmlspecialchars($opt['option_name']).'</td>
        <td style="text-align: right;">+'.number_format($opt['option_price']).'원</td>
    </tr>
    ';
}

$html .= '
    <tr style="background-color: #667eea; color: white; font-size: 14px; font-weight: bold;">
        <td>최종 견적</td>
        <td style="text-align: right;">'.number_format($request['total_quote']).'원</td>
    </tr>
</table>
';

if ($request['deadline']) {
    $html .= '
<h2 style="margin-top: 20px;">희망 납기일</h2>
<p>'.date('Y년 m월 d일', strtotime($request['deadline'])).'</p>
    ';
}

$html .= '
<p style="margin-top: 30px; text-align: center; color: #999; font-size: 9px;">본 견적서는 크리에이터 견적 자동 산출 시스템에서 생성되었습니다.</p>
';

$pdf->writeHTML($html, true, false, true, false, '');

// PDF 출력
$pdf->Output('quote_'.$request_id.'.pdf', 'D');
?>
```

이제 견적 확인 페이지와 대시보드에 PDF 다운로드 버튼을 추가합니다.

`app/modules/creator-quote/view/[id]/index.php`의 `.quote-card` 안에 다음 버튼 추가 (상태 배지 옆):
```html
<a href="/creator-quote/download-pdf?id=<?php echo $request_id; ?>" style="background: #ef4444; color: white; padding: 8px 16px; border-radius: 6px; text-decoration: none; font-size: 0.875rem; font-weight: 600;">📄 PDF 다운로드</a>
```

`app/modules/creator-quote/dashboard/index.php`의 테이블 "관리" 열에 다음 링크 추가:
```html
<a href="/creator-quote/download-pdf?id=<?php echo $req['id']; ?>" style="color: #ef4444; text-decoration: none; margin-left: 8px;">📄 PDF</a>
```

이제 견적서를 PDF로 다운로드할 수 있습니다.

마지막으로 이메일 알림 기능을 추가하여 고객이 의뢰를 제출하거나 승인/거절했을 때 크리에이터에게 알림을 보내도록 하겠습니다.

먼저 크리에이터 이메일 주소를 설정 파일에 저장합니다.

`app/modules/creator-quote/_config.php` 생성:
```php
<?php
if (!defined('_GNUBOARD_')) exit;

// 크리에이터 이메일 (알림 수신용)
define('CREATOR_EMAIL', 'your-email@example.com'); // 실제 이메일로 변경하세요

// 사이트명
define('SITE_NAME', '크리에이터 견적 시스템');
?>
```

이제 `app/modules/creator-quote/request/index.php`의 POST 처리 부분에 이메일 전송 코드를 추가합니다 (DB 저장 후):
```php
// DB 저장 후 이메일 알림
require_once('../_config.php');

$subject = '['.SITE_NAME.'] 새로운 프로젝트 의뢰가 접수되었습니다';
$message = '
안녕하세요,\n\n'
.htmlspecialchars($customer_email).'님으로부터 새로운 프로젝트 의뢰가 접수되었습니다.\n\n'
.'프로젝트명: '.htmlspecialchars($project_title).'\n'
.'작업 유형: '.htmlspecialchars($work_type).'\n'
.'견적 금액: '.number_format($total).'원\n\n'
.'대시보드에서 확인하세요: '.G5_URL.'/creator-quote/dashboard\n\n'
.'감사합니다.';

@mail(CREATOR_EMAIL, $subject, $message, 'From: noreply@'.str_replace('www.', '', $_SERVER['HTTP_HOST']));
```

그리고 `app/modules/creator-quote/view/[id]/index.php`의 승인/거절 POST 처리 부분에도 이메일 전송을 추가합니다:
```php
require_once('../../_config.php');

if (isset($_POST['approve'])) {
    $stmt = $pdo->prepare("UPDATE requests SET status = 'approved', updated_at = CURRENT_TIMESTAMP WHERE id = ?");
    $stmt->execute([$request_id]);
    $message = '견적이 승인되었습니다! 크리에이터가 곧 연락드릴 예정입니다.';
    
    // 이메일 알림
    $subject = '['.SITE_NAME.'] 견적이 승인되었습니다';
    $email_message = '
안녕하세요,\n\n'
.htmlspecialchars($request['customer_email']).'님이 프로젝트 "'.htmlspecialchars($request['project_title']).'"의 견적을 승인하셨습니다.\n\n'
.'견적 금액: '.number_format($request['total_quote']).'원\n\n'
.'고객에게 연락하여 프로젝트를 진행하세요.\n\n'
.'감사합니다.';
    
    @mail(CREATOR_EMAIL, $subject, $email_message, 'From: noreply@'.str_replace('www.', '', $_SERVER['HTTP_HOST']));
} elseif (isset($_POST['reject'])) {
    $reason = trim($_POST['rejection_reason']);
    $stmt = $pdo->prepare("UPDATE requests SET status = 'rejected', rejection_reason = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ?");
    $stmt->execute([$reason, $request_id]);
    $message = '견적이 거절되었습니다. 사유가 크리에이터에게 전달되었습니다.';
    
    // 이메일 알림
    $subject = '['.SITE_NAME.'] 견적이 거절되었습니다';
    $email_message = '
안녕하세요,\n\n'
.htmlspecialchars($request['customer_email']).'님이 프로젝트 "'.htmlspecialchars($request['project_title']).'"의 견적을 거절하셨습니다.\n\n'
.($reason ? '거절 사유: '.htmlspecialchars($reason).'\n\n' : '')
.'감사합니다.';
    
    @mail(CREATOR_EMAIL, $subject, $email_message, 'From: noreply@'.str_replace('www.', '', $_SERVER['HTTP_HOST']));
}
```

마지막으로 메인 랜딩 페이지(`app/modules/creator-quote/index.php`)에 사용 안내를 추가합니다:
```html
<div style="max-width: 800px; margin: 48px auto; padding: 24px; background: var(--m-surface); border-radius: var(--m-radius-lg); box-shadow: var(--m-shadow);">
    <h2 style="font-size: 1.5rem; font-weight: 600; margin-bottom: 16px; color: var(--m-text);">🚀 시스템 사용 가이드</h2>
    <ol style="line-height: 2; color: var(--m-text-muted);">
        <li><strong>크리에이터:</strong> "가격 설정" 메뉴에서 작업 유형과 추가 옵션의 단가를 먼저 등록하세요.</li>
        <li><strong>고객:</strong> "프로젝트 의뢰하기" 메뉴에서 프로젝트 정보를 입력하면 자동으로 견적이 계산됩니다.</li>
        <li><strong>고객:</strong> 견적서 확인 페이지에서 견적을 검토하고 승인 또는 거절하세요.</li>
        <li><strong>크리에이터:</strong> "크리에이터 대시보드"에서 접수된 의뢰를 관리하고 PDF 견적서를 다운로드하세요.</li>
        <li><strong>자동 알림:</strong> 의뢰 접수/승인/거절 시 크리에이터에게 이메일이 자동 발송됩니다.</li>
    </ol>
</div>
```

이제 전체 시스템이 완성되었습니다! 테스트를 위해 다음을 확인하세요:
1. `/creator-quote/pricing`에서 작업 유형과 옵션 추가
2. `/creator-quote/request`에서 고객 의뢰 제출
3. `/creator-quote/view/1`에서 견적 확인 및 승인/거절
4. `/creator-quote/dashboard`에서 대시보드 확인
5. PDF 다운로드 및 이메일 알림 수신 확인