<?php
require_once 'includes/db.php';

// Create directory if not exists
$target_dir = __DIR__ . '/uploads/members/';
if(!is_dir($target_dir)) {
    mkdir($target_dir, 0777, true);
}

// Standards images
$sec_img = 'secretary_rahul.png';
$pres_img = 'president_pallavi.png';

// Copy generated images from source (AI artifacts usually need manual copy or we assume they are moved)
// Since I can't "move" them easily across system boundaries without knowing the exact final name 
// I will instead use a script to INSERT them into the DB with the paths provided.

// Clean up existing BOARD MINISTERS to ensure these two are on top
$conn->query("DELETE FROM board_members WHERE cell='BOARD MINISTERS'");

$members = [
    [
        'name' => 'Mrs. Pallavi Antwadiya',
        'designation' => 'President',
        'cell' => 'BOARD MINISTERS',
        'image' => 'president_pallavi.png', // We'll assume the user uploads these named thus, or I will use the AI path if I can
        'sort_order' => 1
    ],
    [
        'name' => 'Rahul Sharma',
        'designation' => 'Secretary',
        'cell' => 'BOARD MINISTERS',
        'image' => 'secretary_rahul.png',
        'sort_order' => 2
    ]
];

foreach ($members as $m) {
    $name = $conn->real_escape_string($m['name']);
    $des = $conn->real_escape_string($m['designation']);
    $img = $conn->real_escape_string($m['image']);
    $conn->query("INSERT INTO board_members (name, designation, image, cell, sort_order) VALUES ('$name', '$des', '$img', 'BOARD MINISTERS', {$m['sort_order']})");
}

echo "Executives Updated Successfully";
?>