✏ EDIT: chit_assign.php

<?php
require_once __DIR__ . '/../includes/config.php';
header('Content-Type: application/json');
start_secure_session();
if (!is_logged_in('admin')) {
    echo json_encode(['success' => false, 'message' => 'Unauthorized']);
    exit;
}

$chit_id = intval($_POST['chit_id'] ?? 0);
$members = $_POST['members'] ?? [];
if ($chit_id <= 0) {
    echo json_encode(['success' => false, 'message' => 'Invalid chit ID.']);
    exit;
}
// Ensure members is an array of ints
$memberIds = [];
foreach ((array)$members as $m) {
    $id = intval($m);
    if ($id > 0) {
        $memberIds[] = $id;
    }
}

$conn = db_connect();
$conn->begin_transaction();
try {
    // Delete existing assignments
    $stmtDel = $conn->prepare('DELETE FROM chit_members WHERE chit_id=?');
    $stmtDel->bind_param('i', $chit_id);
    $stmtDel->execute();
    $stmtDel->close();
    // Insert new assignments
    if (!empty($memberIds)) {
        $stmtIns = $conn->prepare('INSERT INTO chit_members (chit_id, member_id, join_date, status) VALUES (?, ?, CURDATE(), "active")');
        foreach ($memberIds as $mid) {
            $stmtIns->bind_param('ii', $chit_id, $mid);
            $stmtIns->execute();
        }
        $stmtIns->close();
    }
    $conn->commit();
    echo json_encode(['success' => true]);
} catch (Exception $e) {
    $conn->rollback();
    echo json_encode(['success' => false, 'message' => 'Database error: unable to assign members.']);
}
$conn->close();

[✗] CANCEL