<?php echo htmlspecialchars($app_name); ?>

$max_size) { return false; } $extension = strtolower(pathinfo($file['name'], PATHINFO_EXTENSION)); $filename = $prefix . '_' . time() . '_' . uniqid() . '.' . $extension; if (move_uploaded_file($file['tmp_name'], $upload_dir . $filename)) { return $filename; } return false; } // === DATABASE SCHEMA === try { $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // Stokvels table $conn->exec("CREATE TABLE IF NOT EXISTS stokvels ( id INT AUTO_INCREMENT PRIMARY KEY, stokvel_name VARCHAR(200) NOT NULL, stokvel_type ENUM('savings','burial','investment','grocery','mixed') DEFAULT 'savings', treasurer_name VARCHAR(150) NOT NULL, treasurer_phone VARCHAR(20) NOT NULL, treasurer_email VARCHAR(100), username VARCHAR(50) UNIQUE NOT NULL, password VARCHAR(255) NOT NULL, monthly_contribution DECIMAL(10,2) NOT NULL, total_balance DECIMAL(10,2) DEFAULT 0.00, is_active TINYINT(1) DEFAULT 1, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, INDEX(username) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"); // Members table $conn->exec("CREATE TABLE IF NOT EXISTS stokvel_members ( id INT AUTO_INCREMENT PRIMARY KEY, stokvel_id INT NOT NULL, member_name VARCHAR(150) NOT NULL, id_number VARCHAR(20), phone VARCHAR(20) NOT NULL, email VARCHAR(100), address TEXT, joining_date DATE NOT NULL, member_number VARCHAR(20), is_active TINYINT(1) DEFAULT 1, total_contributed DECIMAL(10,2) DEFAULT 0.00, total_received DECIMAL(10,2) DEFAULT 0.00, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, INDEX(stokvel_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"); // Contributions table $conn->exec("CREATE TABLE IF NOT EXISTS stokvel_contributions ( id INT AUTO_INCREMENT PRIMARY KEY, stokvel_id INT NOT NULL, member_id INT NOT NULL, amount DECIMAL(10,2) NOT NULL, contribution_month VARCHAR(7) NOT NULL, payment_date DATE NOT NULL, payment_method ENUM('cash','eft','card') DEFAULT 'cash', reference_number VARCHAR(100), proof_filename VARCHAR(255), status ENUM('pending','approved','rejected') DEFAULT 'approved', notes TEXT, recorded_by VARCHAR(100), created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, INDEX(stokvel_id), INDEX(member_id), INDEX(contribution_month) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"); // Payouts table $conn->exec("CREATE TABLE IF NOT EXISTS stokvel_payouts ( id INT AUTO_INCREMENT PRIMARY KEY, stokvel_id INT NOT NULL, member_id INT NOT NULL, amount DECIMAL(10,2) NOT NULL, payout_type ENUM('rotation','final','loan','emergency') DEFAULT 'rotation', payout_date DATE NOT NULL, payment_method VARCHAR(50), reference_number VARCHAR(100), proof_filename VARCHAR(255), notes TEXT, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, INDEX(stokvel_id), INDEX(member_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"); // Create default stokvel $stokvel_count = $conn->query("SELECT COUNT(*) FROM stokvels")->fetchColumn(); if ($stokvel_count == 0) { $default_password = password_hash('stokvel123', PASSWORD_DEFAULT); $conn->exec("INSERT INTO stokvels ( stokvel_name, stokvel_type, treasurer_name, treasurer_phone, username, password, monthly_contribution ) VALUES ( 'Kopano Savings Club', 'savings', 'Demo Treasurer', '0821234567', 'demo', '$default_password', 500.00 )"); } } catch (PDOException $e) { die("Database Setup Error: " . $e->getMessage()); } // === AUTHENTICATION === $user_type = $_SESSION['stokvel_user_type'] ?? null; $user_id = $_SESSION['stokvel_user_id'] ?? null; $stokvel_name = $_SESSION['stokvel_name'] ?? null; $msg = ""; $redirect_js = ""; // Login handler if (isset($_POST['login'])) { $username = trim($_POST['username']); $password = $_POST['password']; $stmt = $conn->prepare("SELECT * FROM stokvels WHERE username = ? AND is_active = 1"); $stmt->execute([$username]); $stokvel = $stmt->fetch(PDO::FETCH_ASSOC); if ($stokvel && password_verify($password, $stokvel['password'])) { $_SESSION['stokvel_user_type'] = 'treasurer'; $_SESSION['stokvel_user_id'] = $stokvel['id']; $_SESSION['stokvel_name'] = $stokvel['stokvel_name']; $_SESSION['treasurer_name'] = $stokvel['treasurer_name']; $redirect_js = ""; } else { $msg = "Invalid credentials. Please try again."; } } // Logout handler if (isset($_GET['logout'])) { unset($_SESSION['stokvel_user_type']); unset($_SESSION['stokvel_user_id']); unset($_SESSION['stokvel_name']); unset($_SESSION['treasurer_name']); $redirect_js = ""; } // === BUSINESS ACTIONS === if ($user_type === 'treasurer') { // Add Member if (isset($_POST['add_member'])) { try { $stmt = $conn->prepare("INSERT INTO stokvel_members ( stokvel_id, member_name, id_number, phone, email, address, joining_date, member_number ) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"); $member_number = 'MEM' . str_pad($user_id, 3, '0', STR_PAD_LEFT) . time(); $stmt->execute([ $user_id, $_POST['member_name'], $_POST['id_number'] ?: null, $_POST['phone'], $_POST['email'] ?: null, $_POST['address'] ?: null, $_POST['joining_date'], $member_number ]); $redirect_js = ""; } catch (PDOException $e) { $msg = "Error: " . $e->getMessage(); } } // Record Contribution if (isset($_POST['record_contribution'])) { try { $proof_filename = premium_file_upload('proof_file', $upload_base, 'contribution'); $stmt = $conn->prepare("INSERT INTO stokvel_contributions ( stokvel_id, member_id, amount, contribution_month, payment_date, payment_method, reference_number, proof_filename, status, notes, recorded_by ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, 'approved', ?, ?)"); $stmt->execute([ $user_id, $_POST['member_id'], $_POST['amount'], $_POST['contribution_month'], $_POST['payment_date'], $_POST['payment_method'], $_POST['reference_number'] ?: null, $proof_filename, $_POST['notes'] ?: null, $_SESSION['treasurer_name'] ]); // Update member total and stokvel balance $stmt = $conn->prepare("UPDATE stokvel_members SET total_contributed = total_contributed + ? WHERE id = ?"); $stmt->execute([$_POST['amount'], $_POST['member_id']]); $stmt = $conn->prepare("UPDATE stokvels SET total_balance = total_balance + ? WHERE id = ?"); $stmt->execute([$_POST['amount'], $user_id]); $redirect_js = ""; } catch (PDOException $e) { $msg = "Error: " . $e->getMessage(); } } // Record Payout if (isset($_POST['record_payout'])) { try { $proof_filename = premium_file_upload('payout_proof', $upload_base, 'payout'); $stmt = $conn->prepare("INSERT INTO stokvel_payouts ( stokvel_id, member_id, amount, payout_type, payout_date, payment_method, reference_number, proof_filename, notes ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"); $stmt->execute([ $user_id, $_POST['member_id'], $_POST['amount'], $_POST['payout_type'], $_POST['payout_date'], $_POST['payment_method'], $_POST['reference_number'] ?: null, $proof_filename, $_POST['notes'] ?: null ]); // Update member total and stokvel balance $stmt = $conn->prepare("UPDATE stokvel_members SET total_received = total_received + ? WHERE id = ?"); $stmt->execute([$_POST['amount'], $_POST['member_id']]); $stmt = $conn->prepare("UPDATE stokvels SET total_balance = total_balance - ? WHERE id = ?"); $stmt->execute([$_POST['amount'], $user_id]); $redirect_js = ""; } catch (PDOException $e) { $msg = "Error: " . $e->getMessage(); } } } // === DATA FETCHING === $members = []; $contributions = []; $payouts = []; $stokvel_info = []; $analytics = []; if ($db_connected && $user_type === 'treasurer') { // Get stokvel info $stmt = $conn->prepare("SELECT * FROM stokvels WHERE id = ?"); $stmt->execute([$user_id]); $stokvel_info = $stmt->fetch(PDO::FETCH_ASSOC); // Get members $stmt = $conn->prepare("SELECT * FROM stokvel_members WHERE stokvel_id = ? AND is_active = 1 ORDER BY member_name"); $stmt->execute([$user_id]); $members = $stmt->fetchAll(PDO::FETCH_ASSOC); // Get recent contributions $stmt = $conn->prepare("SELECT c.*, m.member_name FROM stokvel_contributions c JOIN stokvel_members m ON c.member_id = m.id WHERE c.stokvel_id = ? ORDER BY c.created_at DESC LIMIT 50"); $stmt->execute([$user_id]); $contributions = $stmt->fetchAll(PDO::FETCH_ASSOC); // Get payouts $stmt = $conn->prepare("SELECT p.*, m.member_name FROM stokvel_payouts p JOIN stokvel_members m ON p.member_id = m.id WHERE p.stokvel_id = ? ORDER BY p.created_at DESC LIMIT 50"); $stmt->execute([$user_id]); $payouts = $stmt->fetchAll(PDO::FETCH_ASSOC); // Calculate analytics $current_month = date('Y-m'); $stmt = $conn->prepare("SELECT SUM(amount) FROM stokvel_contributions WHERE stokvel_id = ? AND contribution_month = ?"); $stmt->execute([$user_id, $current_month]); $contributions_this_month = $stmt->fetchColumn() ?: 0; $stmt = $conn->prepare("SELECT COUNT(DISTINCT member_id) FROM stokvel_contributions WHERE stokvel_id = ? AND contribution_month = ?"); $stmt->execute([$user_id, $current_month]); $paid_this_month = $stmt->fetchColumn() ?: 0; $expected_monthly = $stokvel_info['monthly_contribution'] * count($members); $collection_rate = $expected_monthly > 0 ? round(($contributions_this_month / $expected_monthly) * 100) : 0; $analytics = [ 'total_members' => count($members), 'total_balance' => $stokvel_info['total_balance'], 'contributions_this_month' => $contributions_this_month, 'paid_this_month' => $paid_this_month, 'outstanding_this_month' => count($members) - $paid_this_month, 'expected_monthly' => $expected_monthly, 'collection_rate' => $collection_rate, 'total_contributions' => array_sum(array_column($contributions, 'amount')), 'total_payouts' => array_sum(array_column($payouts, 'amount')) ]; } ?> <?php echo htmlspecialchars($app_name); ?> - Stokvel Management System

Demo Login: demo / stokvel123

Overview

Dashboard

Members

Contributions 0): ?>

Payouts

Account

Logout

Active Members | Stokvel

Total Balance

This Month's Collections

Collection Rate

Outstanding This Month

Total Payouts

Recent Contributions

No Contributions Yet

Start recording member contributions

Date	Member	Month	Amount	Method	Status

Build Your Stokvel

Add members to start managing contributions

Member	Contact	Member Since	Total Contributed	Total Received
Member #

Record New Contribution

Member *

Amount () *

Contribution Month *

Payment Date *

Payment Method

Reference Number

Proof of Payment (Optional)

Notes

Contribution History

No Contributions Recorded

Start tracking member contributions

Payment Date	Member	Month	Amount	Method	Reference	Proof	Status
						View None

Record New Payout

Member *

Amount () *

Payout Type

Payout Date *

Payment Method

Reference Number

Proof of Payment (Optional)

Notes

Payout History

No Payouts Recorded

Start tracking member payouts

Payout Date	Member	Amount	Type	Method	Reference	Proof
						View None

Stokvel Overview

Recent Contributions

No Contributions Yet

Member Management

Add New Member