<?php echo htmlspecialchars($app_name); ?> - Township Business Management

$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); // Shop owners table $conn->exec("CREATE TABLE IF NOT EXISTS spaza_owners ( id INT AUTO_INCREMENT PRIMARY KEY, username VARCHAR(50) UNIQUE NOT NULL, password VARCHAR(255) NOT NULL, shop_name VARCHAR(200) NOT NULL, owner_name VARCHAR(150) NOT NULL, phone VARCHAR(20), email VARCHAR(100), address TEXT, is_active TINYINT(1) DEFAULT 1, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"); // Products table $conn->exec("CREATE TABLE IF NOT EXISTS spaza_products ( id INT AUTO_INCREMENT PRIMARY KEY, shop_id INT NOT NULL, product_name VARCHAR(200) NOT NULL, barcode VARCHAR(100), category VARCHAR(50), cost_price DECIMAL(10,2) NOT NULL, sell_price DECIMAL(10,2) NOT NULL, stock_quantity INT DEFAULT 0, min_stock_level INT DEFAULT 5, product_image VARCHAR(255), is_active TINYINT(1) DEFAULT 1, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, INDEX(shop_id), INDEX(barcode), INDEX(category) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"); // Sales table $conn->exec("CREATE TABLE IF NOT EXISTS spaza_sales ( id INT AUTO_INCREMENT PRIMARY KEY, shop_id INT NOT NULL, total_amount DECIMAL(10,2) NOT NULL, total_profit DECIMAL(10,2) NOT NULL, payment_method ENUM('cash','card','credit') DEFAULT 'cash', customer_name VARCHAR(150), items_json TEXT, sale_date DATETIME DEFAULT CURRENT_TIMESTAMP, INDEX(shop_id), INDEX(sale_date) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"); // Customers/Credit book table $conn->exec("CREATE TABLE IF NOT EXISTS spaza_customers ( id INT AUTO_INCREMENT PRIMARY KEY, shop_id INT NOT NULL, customer_name VARCHAR(150) NOT NULL, phone VARCHAR(20), address TEXT, credit_balance DECIMAL(10,2) DEFAULT 0.00, credit_limit DECIMAL(10,2) DEFAULT 500.00, is_active TINYINT(1) DEFAULT 1, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, INDEX(shop_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"); // Stock movements table $conn->exec("CREATE TABLE IF NOT EXISTS spaza_stock_movements ( id INT AUTO_INCREMENT PRIMARY KEY, shop_id INT NOT NULL, product_id INT NOT NULL, movement_type ENUM('sale','restock','adjustment') NOT NULL, quantity INT NOT NULL, notes TEXT, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, INDEX(shop_id), INDEX(product_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"); // Create default shop owner $owner_count = $conn->query("SELECT COUNT(*) FROM spaza_owners")->fetchColumn(); if ($owner_count == 0) { $default_password = password_hash('spaza123', PASSWORD_DEFAULT); $conn->exec("INSERT INTO spaza_owners (username, password, shop_name, owner_name) VALUES ('demo', '$default_password', 'Township Supermarket', 'Demo Owner')"); } } catch (PDOException $e) { die("Database Setup Error: " . $e->getMessage()); } // === AUTHENTICATION === $user_type = $_SESSION['spaza_user_type'] ?? null; $user_id = $_SESSION['spaza_user_id'] ?? null; $shop_name = $_SESSION['spaza_shop_name'] ?? null; $msg = ""; $redirect_js = ""; // Login handler if (isset($_POST['login'])) { $username = trim($_POST['username']); $password = $_POST['password']; $stmt = $conn->prepare("SELECT * FROM spaza_owners WHERE username = ? AND is_active = 1"); $stmt->execute([$username]); $owner = $stmt->fetch(PDO::FETCH_ASSOC); if ($owner && password_verify($password, $owner['password'])) { $_SESSION['spaza_user_type'] = 'owner'; $_SESSION['spaza_user_id'] = $owner['id']; $_SESSION['spaza_shop_name'] = $owner['shop_name']; $_SESSION['spaza_owner_name'] = $owner['owner_name']; $redirect_js = ""; } else { $msg = "Invalid credentials. Please try again."; } } // Logout handler if (isset($_GET['logout'])) { unset($_SESSION['spaza_user_type']); unset($_SESSION['spaza_user_id']); unset($_SESSION['spaza_shop_name']); unset($_SESSION['spaza_owner_name']); $redirect_js = ""; } // === BUSINESS ACTIONS === if ($user_type === 'owner') { // Add Product if (isset($_POST['add_product'])) { try { $product_image = premium_file_upload('product_image', $upload_base, 'product'); $stmt = $conn->prepare("INSERT INTO spaza_products ( shop_id, product_name, barcode, category, cost_price, sell_price, stock_quantity, min_stock_level, product_image ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"); $stmt->execute([ $user_id, $_POST['product_name'], $_POST['barcode'] ?: null, $_POST['category'], $_POST['cost_price'], $_POST['sell_price'], $_POST['stock_quantity'], $_POST['min_stock_level'] ?: 5, $product_image ]); // Record initial stock movement if ($_POST['stock_quantity'] > 0) { $product_id = $conn->lastInsertId(); $stmt = $conn->prepare("INSERT INTO spaza_stock_movements (shop_id, product_id, movement_type, quantity, notes) VALUES (?, ?, 'restock', ?, 'Initial stock')"); $stmt->execute([$user_id, $product_id, $_POST['stock_quantity']]); } $redirect_js = ""; } catch (PDOException $e) { $msg = "Error: " . $e->getMessage(); } } // Process Sale if (isset($_POST['process_sale'])) { try { $cart_items = json_decode($_POST['cart_data'], true); $payment_method = $_POST['payment_method']; $customer_name = $_POST['customer_name'] ?: null; if (empty($cart_items)) { throw new Exception("Cart is empty"); } $total_amount = 0; $total_profit = 0; // Calculate totals and validate stock foreach ($cart_items as $item) { $stmt = $conn->prepare("SELECT stock_quantity, cost_price FROM spaza_products WHERE id = ? AND shop_id = ?"); $stmt->execute([$item['id'], $user_id]); $product = $stmt->fetch(PDO::FETCH_ASSOC); if (!$product || $product['stock_quantity'] < $item['qty']) { throw new Exception("Insufficient stock for " . $item['name']); } $line_total = $item['price'] * $item['qty']; $line_profit = ($item['price'] - $product['cost_price']) * $item['qty']; $total_amount += $line_total; $total_profit += $line_profit; } // Record sale $stmt = $conn->prepare("INSERT INTO spaza_sales (shop_id, total_amount, total_profit, payment_method, customer_name, items_json) VALUES (?, ?, ?, ?, ?, ?)"); $stmt->execute([$user_id, $total_amount, $total_profit, $payment_method, $customer_name, json_encode($cart_items)]); // Update stock and record movements foreach ($cart_items as $item) { $stmt = $conn->prepare("UPDATE spaza_products SET stock_quantity = stock_quantity - ? WHERE id = ?"); $stmt->execute([$item['qty'], $item['id']]); $stmt = $conn->prepare("INSERT INTO spaza_stock_movements (shop_id, product_id, movement_type, quantity, notes) VALUES (?, ?, 'sale', ?, ?)"); $stmt->execute([$user_id, $item['id'], $item['qty'], 'POS Sale - ' . $payment_method]); } // Handle credit sales if ($payment_method === 'credit' && $customer_name) { $stmt = $conn->prepare("SELECT id FROM spaza_customers WHERE shop_id = ? AND customer_name = ?"); $stmt->execute([$user_id, $customer_name]); $customer = $stmt->fetch(PDO::FETCH_ASSOC); if (!$customer) { $stmt = $conn->prepare("INSERT INTO spaza_customers (shop_id, customer_name, credit_balance) VALUES (?, ?, ?)"); $stmt->execute([$user_id, $customer_name, $total_amount]); } else { $stmt = $conn->prepare("UPDATE spaza_customers SET credit_balance = credit_balance + ? WHERE id = ?"); $stmt->execute([$total_amount, $customer['id']]); } } $redirect_js = ""; } catch (Exception $e) { $msg = "Sale Error: " . $e->getMessage(); } } // Delete Product if (isset($_GET['delete_product'])) { try { $stmt = $conn->prepare("UPDATE spaza_products SET is_active = 0 WHERE id = ? AND shop_id = ?"); $stmt->execute([intval($_GET['delete_product']), $user_id]); $redirect_js = ""; } catch (PDOException $e) { $msg = "Error: " . $e->getMessage(); } } } // === DATA FETCHING === $products = []; $sales_today = []; $customers = []; $low_stock_products = []; $analytics = []; if ($db_connected && $user_type === 'owner') { // Get products $stmt = $conn->prepare("SELECT * FROM spaza_products WHERE shop_id = ? AND is_active = 1 ORDER BY product_name"); $stmt->execute([$user_id]); $products = $stmt->fetchAll(PDO::FETCH_ASSOC); // Get low stock products $low_stock_products = array_filter($products, function($p) { return $p['stock_quantity'] <= $p['min_stock_level']; }); // Get today's sales $today = date('Y-m-d'); $stmt = $conn->prepare("SELECT * FROM spaza_sales WHERE shop_id = ? AND DATE(sale_date) = ? ORDER BY sale_date DESC"); $stmt->execute([$user_id, $today]); $sales_today = $stmt->fetchAll(PDO::FETCH_ASSOC); // Get customers with credit $stmt = $conn->prepare("SELECT * FROM spaza_customers WHERE shop_id = ? AND is_active = 1 ORDER BY credit_balance DESC"); $stmt->execute([$user_id]); $customers = $stmt->fetchAll(PDO::FETCH_ASSOC); // Calculate analytics $total_revenue_today = array_sum(array_column($sales_today, 'total_amount')); $total_profit_today = array_sum(array_column($sales_today, 'total_profit')); $total_transactions = count($sales_today); $total_stock_value = 0; foreach ($products as $p) { $total_stock_value += ($p['cost_price'] * $p['stock_quantity']); } $total_credit_owed = array_sum(array_column($customers, 'credit_balance')); $analytics = [ 'revenue_today' => $total_revenue_today, 'profit_today' => $total_profit_today, 'transactions_today' => $total_transactions, 'total_products' => count($products), 'total_stock_value' => $total_stock_value, 'low_stock_count' => count($low_stock_products), 'total_credit_owed' => $total_credit_owed, 'active_customers' => count($customers) ]; } ?> <?php echo htmlspecialchars($app_name); ?> - Township Business Management

Demo Login: demo / spaza123

Today's Business Overview

Today's Sales

Today's Profit

Stock Value

Low Stock Items

Low Stock Alert ( items)

Product	Current Stock	Min Level	Action Needed
	units	units

Recent Sales ( today)

No Sales Yet Today

Start selling to track your daily performance

Time	Amount	Profit	Method	Customer

Point of Sale System

No Products Available

Add products to start selling

<?php echo htmlspecialchars($product['product_name']); ?>

Stock:

Current Sale

Cart is empty

Total: 0.00

Product Inventory

Build Your Inventory

Add products to start managing your stock and sales

Product	Category	Stock	Cost Price	Sell Price	Profit Margin	Actions
Barcode:

Credit Book Management

Total Credit Owed

Credit Customers

No Credit Customers Yet

Credit sales will automatically create customer records in your book

Customer Name	Phone	Current Balance	Credit Limit	Actions

Business Reports & Analytics

Transactions Today

Products in Inventory

Inventory Value

Items Need Restocking

Advanced Reports Coming Soon

Premium features including weekly/monthly sales trends, profit analysis, supplier performance, and automated reports will be available in the next update.

Coming Features:

Weekly & Monthly Sales Trends
Product Performance Analysis
Profit Margin Reports
Customer Purchase History
Automated WhatsApp Reports
Tax & Accounting Integration