台灣民宿預訂平台 – Letwebs 技術作品集

Frontend: Vue.js 3 + TypeScript + Vite
Backend: Laravel 10 + PHP 8.3
Database: MySQL 8.0 + Redis Cluster
Cache: Multi-layer Redis + Memcached
Queue: Redis Queue + Laravel Horizon
Search: Elasticsearch + 地理位置索引
CDN: CloudFlare + AWS CloudFront
Monitor: Laravel Telescope + New Relic

// 多層級快取策略
Redis::pipeline(function ($pipe) {
    // 熱門民宿快取 (TTL: 1小時)
    $pipe->setex("hot_bnbs", 3600, $hotBnbs);
    
    // 用戶搜索快取 (TTL: 30分鐘)  
    $pipe->setex("search:{$params}", 1800, $results);
    
    // 即時庫存快取 (TTL: 5分鐘)
    $pipe->setex("availability:{$bnb_id}", 300, $availability);
});

class DynamicPricingEngine 
{
    public function calculatePrice($bnb, $checkin, $nights)
    {
        $basePrice = $bnb->base_price;
        
        // 需求預測算法
        $demandMultiplier = $this->predictDemand($checkin);
        
        // 競爭對手價格分析
        $competitorPrice = $this->analyzeCompetitors($bnb->location);
        
        // 最後一分鐘折扣
        $lastMinuteDiscount = $this->getLastMinuteDiscount();
        
        return $basePrice * $demandMultiplier * $lastMinuteDiscount;
    }
}

// 複合地理搜索
$searchParams = [
    'index' => 'bnb_properties',
    'body' => [
        'query' => [
            'bool' => [
                'must' => [
                    ['match' => ['description' => $keywords]],
                    ['range' => ['price' => ['gte' => $minPrice, 'lte' => $maxPrice]]],
                ],
                'filter' => [
                    'geo_distance' => [
                        'distance' => '10km',
                        'location' => ['lat' => $lat, 'lon' => $lon]
                    ]
                ]
            ]
        ],
        'sort' => [
            '_geo_distance' => [
                'location' => ['lat' => $lat, 'lon' => $lon],
                'order' => 'asc'
            ]
        ]
    ]
];

// 民宿特色智能標籤
$tags = [
    'ambiance' => ['浪漫', '溫馨', '現代', '復古', '奢華'],
    'facilities' => ['溫泉', '烤肉區', '無邊際泳池', '私人海灘'],
    'views' => ['海景', '山景', '湖景', '市景', '田園'],
    'activities' => ['衝浪', '登山', '泡溫泉', '觀星', '農場體驗']
];

// API 限流防護
Route::middleware(['throttle:api'])->group(function () {
    Route::get('/search', [BnbController::class, 'search'])
         ->middleware('throttle:60,1'); // 每分鐘60次
});

// 資料加密存儲
class UserDataEncryption 
{
    public function encryptSensitiveData($data)
    {
        return encrypt($data); // Laravel 內建 AES-256-CBC 加密
    }
}

// SQL 注入防護
$users = DB::table('bookings')
         ->where('user_id', $userId)
         ->whereDate('checkin', '>=', now())
         ->get(); // 使用 Query Builder 防止 SQL 注入

// 即時統計 Dashboard
class RealtimeDashboard 
{
    public function getMetrics()
    {
        return [
            'active_users' => Redis::get('active_users_count'),
            'daily_bookings' => $this->getDailyBookings(),
            'revenue' => $this->calculateRevenue(),
            'popular_areas' => $this->getPopularAreas(),
            'conversion_rate' => $this->getConversionRate()
        ];
    }
}