<?php
define('IBVTE_ACCESS', true);
require 'config.php';
require 'includes/db.php';

try {
    $pdo = new PDO("mysql:host=" . DB_HOST . ";dbname=" . DB_NAME, DB_USERNAME, DB_PASSWORD);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $courses = [
        ['IBVTE-BEA-001', 85000],
        ['IBVTE-BEA-002', 95000],
        ['IBVTE-BEA-003', 75000],
        ['IBVTE-BEA-004', 65000],
        ['IBVTE-BEA-005', 120000],
        ['IBVTE-BEA-006', 80000],
        ['IBVTE-BEA-007', 90000],
        ['IBVTE-BEA-008', 70000],
        ['IBVTE-BEA-009', 95000],
        ['IBVTE-BEA-010', 80000],
        ['IBVTE-BEA-011', 25000],
        ['IBVTE-BEA-012', 28000],
        ['IBVTE-BEA-013', 35000],
        ['IBVTE-BEA-014', 30000],
        ['IBVTE-BEA-015', 40000],
        ['IBVTE-BEA-016', 32000],
        ['IBVTE-BEA-017', 30000],
    ];

    foreach ($courses as $c) {
        $stmt = $pdo->prepare("SELECT id FROM courses WHERE course_code = ?");
        $stmt->execute([$c[0]]);
        $courseId = $stmt->fetchColumn();
        
        if ($courseId) {
            $feeStmt = $pdo->prepare("SELECT id FROM course_fees WHERE course_id = ? AND user_type='college'");
            $feeStmt->execute([$courseId]);
            if ($feeStmt->fetchColumn()) {
                $pdo->prepare("UPDATE course_fees SET total_fee = ? WHERE course_id = ? AND user_type='college'")->execute([$c[1], $courseId]);
            } else {
                $pdo->prepare("INSERT INTO course_fees (course_id, user_type, admission_fee, exam_fee, total_fee, valid_from) VALUES (?, 'college', 0, 0, ?, '2026-01-01')")->execute([$courseId, $c[1]]);
            }
        }
    }
    
    echo "Fees fixed successfully!";
} catch(Exception $e) {
    echo "Error: " . $e->getMessage();
}