<?php
// Error reporting for debugging (remove in production)
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

// Start session
session_start();

// Check if user is logged in
if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit();
}

// Include database connection
require_once 'db_connection.php';

// Set page title
$pageTitle = "Base";

// Function to get all buyers
function getBuyers($conn) {
    $query = "SELECT * FROM buyers ORDER BY name";
    $result = $conn->query($query);
    return $result->fetch_all(MYSQLI_ASSOC);
}

// Function to get all expense categories
function getExpenseCategories($conn) {
    $query = "SELECT * FROM expense_categories ORDER BY name";
    $result = $conn->query($query);
    return $result->fetch_all(MYSQLI_ASSOC);
}

// Function to get expense heads for a category
function getExpenseHeads($conn, $categoryId) {
    $query = "SELECT * FROM expense_heads WHERE category_id = ? ORDER BY name";
    $stmt = $conn->prepare($query);
    $stmt->bind_param("i", $categoryId);
    $stmt->execute();
    $result = $stmt->get_result();
    return $result->fetch_all(MYSQLI_ASSOC);
}

// Handle form submissions
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    if (isset($_POST["add_buyer"])) {
        // Add new buyer
        $query = "INSERT INTO buyers (name, phone, rate_tilapia, rate_small_fish, rate_big_fish, delivery_rate, harvesting_fee_tilapia, harvesting_fee_small_fish, harvesting_fee_big_fish) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)";
        $stmt = $conn->prepare($query);
        $stmt->bind_param("ssddddddd", $_POST["name"], $_POST["phone"], $_POST["rate_tilapia"], $_POST["rate_small_fish"], $_POST["rate_big_fish"], $_POST["delivery_rate"], $_POST["harvesting_fee_tilapia"], $_POST["harvesting_fee_small_fish"], $_POST["harvesting_fee_big_fish"]);
        $stmt->execute();
        $_SESSION['flash_message'] = "Buyer added successfully";
    } elseif (isset($_POST["add_expense_category"])) {
        // Add new expense category
        $query = "INSERT INTO expense_categories (name) VALUES (?)";
        $stmt = $conn->prepare($query);
        $stmt->bind_param("s", $_POST["category_name"]);
        $stmt->execute();
        $_SESSION['flash_message'] = "Expense category added successfully";
    } elseif (isset($_POST["add_expense_head"])) {
        // Add new expense head
        $query = "INSERT INTO expense_heads (category_id, name) VALUES (?, ?)";
        $stmt = $conn->prepare($query);
        $stmt->bind_param("is", $_POST["category_id"], $_POST["head_name"]);
        $stmt->execute();
        $_SESSION['flash_message'] = "Expense head added successfully";
    } elseif (isset($_POST["add_initial_values"])) {
        // Add or update initial values
        $query = "INSERT INTO initial_values (cash_in_hand, madhu_balance, rathna_balance, jambukkutti_balance) 
                  VALUES (?, ?, ?, ?) 
                  ON DUPLICATE KEY UPDATE 
                  cash_in_hand = VALUES(cash_in_hand), 
                  madhu_balance = VALUES(madhu_balance), 
                  rathna_balance = VALUES(rathna_balance), 
                  jambukkutti_balance = VALUES(jambukkutti_balance)";
        $stmt = $conn->prepare($query);
        $stmt->bind_param("dddd", $_POST["initial_cash"], $_POST["madhu_balance"], $_POST["rathna_balance"], $_POST["jambukkutti_balance"]);
        $stmt->execute();
        $_SESSION['flash_message'] = "Initial values updated successfully";
    }
    header("Location: base.php");
    exit();
}

// Get data for the page
$buyers = getBuyers($conn);
$expenseCategories = getExpenseCategories($conn);

// Get current initial values
$query = "SELECT * FROM initial_values LIMIT 1";
$result = $conn->query($query);
$initialValues = $result->fetch_assoc();

// If no initial values exist, set default values
if (!$initialValues) {
    $initialValues = [
        'cash_in_hand' => 0,
        'madhu_balance' => 0,
        'rathna_balance' => 0,
        'jambukkutti_balance' => 0
    ];
}

// Helper function to generate buyer rows
function generateBuyerRows($buyers) {
    $rows = '';
    foreach ($buyers as $buyer) {
        $rows .= "<tr>
            <td>{$buyer['name']}</td>
            <td>{$buyer['phone']}</td>
            <td>₹{$buyer['rate_tilapia']}</td>
            <td>₹{$buyer['rate_small_fish']}</td>
            <td>₹{$buyer['rate_big_fish']}</td>
            <td>₹{$buyer['delivery_rate']}</td>
            <td>₹{$buyer['harvesting_fee_tilapia']}</td>
            <td>₹{$buyer['harvesting_fee_small_fish']}</td>
            <td>₹{$buyer['harvesting_fee_big_fish']}</td>
            <td>
                <a href='edit_buyer.php?id={$buyer['id']}'>Edit</a> |
                <a href='delete_buyer.php?id={$buyer['id']}' class='delete-confirm'>Delete</a>
            </td>
        </tr>";
    }
    return $rows;
}

// Helper function to generate expense categories and heads
function generateExpenseCategoriesAndHeads($conn, $categories) {
    $output = '';
    foreach ($categories as $category) {
        $output .= "<h3>{$category['name']}</h3>";
        $output .= "<form action='' method='POST'>
            <input type='hidden' name='add_expense_head' value='1'>
            <input type='hidden' name='category_id' value='{$category['id']}'>
            <label for='head_name_{$category['id']}'>New Head:</label>
            <input type='text' id='head_name_{$category['id']}' name='head_name' required>
            <button type='submit'>Add Head</button>
        </form>";
        
        $heads = getExpenseHeads($conn, $category['id']);
        if (!empty($heads)) {
            $output .= "<ul>";
            foreach ($heads as $head) {
                $output .= "<li>{$head['name']} 
                    <a href='edit_expense_head.php?id={$head['id']}'>Edit</a> |
                    <a href='delete_expense_head.php?id={$head['id']}' class='delete-confirm'>Delete</a>
                </li>";
            }
            $output .= "</ul>";
        } else {
            $output .= "<p>No expense heads found for this category.</p>";
        }
    }
    return $output;
}

// Generate content
$buyerRows = generateBuyerRows($buyers);
$expenseCategoriesAndHeads = generateExpenseCategoriesAndHeads($conn, $expenseCategories);

// Prepare the content
$content = <<<HTML
<h1>Base Management</h1>

<h2>Initial Values</h2>
<form action="" method="POST">
    <input type="hidden" name="add_initial_values" value="1">
    <label for="initial_cash">Initial Cash-in-hand:</label>
    <input type="number" id="initial_cash" name="initial_cash" step="0.01" value="{$initialValues['cash_in_hand']}" required>
    
    <label for="madhu_balance">Initial Balance for Madhu:</label>
    <input type="number" id="madhu_balance" name="madhu_balance" step="0.01" value="{$initialValues['madhu_balance']}" required>
    
    <label for="rathna_balance">Initial Balance for Rathna:</label>
    <input type="number" id="rathna_balance" name="rathna_balance" step="0.01" value="{$initialValues['rathna_balance']}" required>
    
    <label for="jambukkutti_balance">Initial Balance for Jambukkutti:</label>
    <input type="number" id="jambukkutti_balance" name="jambukkutti_balance" step="0.01" value="{$initialValues['jambukkutti_balance']}" required>
    
    <button type="submit">Update Initial Values</button>
</form>

<h2>Add Buyer</h2>
<form action="" method="POST">
    <input type="hidden" name="add_buyer" value="1">
    <label for="name">Buyer Name:</label>
    <input type="text" id="name" name="name" required>
    
    <label for="phone">Phone:</label>
    <input type="tel" id="phone" name="phone">
    
    <label for="rate_tilapia">Rate of Tilapia per Kg:</label>
    <input type="number" id="rate_tilapia" name="rate_tilapia" step="0.01" required>
    
    <label for="rate_small_fish">Rate of Small Fish per Kg:</label>
    <input type="number" id="rate_small_fish" name="rate_small_fish" step="0.01" required>
    
    <label for="rate_big_fish">Rate of Big Fish per Kg:</label>
    <input type="number" id="rate_big_fish" name="rate_big_fish" step="0.01" required>
    
    <label for="delivery_rate">Delivery Rate:</label>
    <input type="number" id="delivery_rate" name="delivery_rate" step="0.01" required>
    
    <label for="harvesting_fee_tilapia">Harvesting Fee Per Kg - Tilapia:</label>
    <input type="number" id="harvesting_fee_tilapia" name="harvesting_fee_tilapia" step="0.01" required>
    
    <label for="harvesting_fee_small_fish">Harvesting Fee Per Kg - Small Fish:</label>
    <input type="number" id="harvesting_fee_small_fish" name="harvesting_fee_small_fish" step="0.01" required>
    
    <label for="harvesting_fee_big_fish">Harvesting Fee Per Kg - Big Fish:</label>
    <input type="number" id="harvesting_fee_big_fish" name="harvesting_fee_big_fish" step="0.01" required>
    
    <button type="submit">Add Buyer</button>
</form>

<h2>Buyers List</h2>
<table class="data-table">
    <thead>
        <tr>
            <th>Name</th>
            <th>Phone</th>
            <th>Tilapia Rate</th>
            <th>Small Fish Rate</th>
            <th>Big Fish Rate</th>
            <th>Delivery Rate</th>
            <th>Harvesting Fee (Tilapia)</th>
            <th>Harvesting Fee (Small Fish)</th>
            <th>Harvesting Fee (Big Fish)</th>
            <th>Actions</th>
        </tr>
    </thead>
    <tbody>
        $buyerRows
    </tbody>
</table>

<h2>Add Expense Category</h2>
<form action="" method="POST">
    <input type="hidden" name="add_expense_category" value="1">
    <label for="category_name">Category Name:</label>
    <input type="text" id="category_name" name="category_name" required>
    <button type="submit">Add Category</button>
</form>

<h2>Expense Categories and Heads</h2>
$expenseCategoriesAndHeads
HTML;

// Include the main layout
include 'main_layout.php';
?>