<?php
session_start();

if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit();
}

// Session timeout check
if (isset($_SESSION['last_activity']) && (time() - $_SESSION['last_activity'] > 1800)) {
    header("Location: logout.php");
    exit();
}
$_SESSION['last_activity'] = time();

require_once 'db_connection.php';

$pageTitle = "Base Setup";

// Handle form submissions
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    try {
        // Add Buyer
        if (isset($_POST['add_buyer'])) {
            $stmt = $conn->prepare("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->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();
            $stmt->close();
            $_SESSION['success'] = "Buyer added successfully!";
            header("Location: base.php");
            exit();
        }
        
        // Add Expense Category
        if (isset($_POST['add_expense_category'])) {
            $stmt = $conn->prepare("INSERT INTO expense_categories (name) VALUES (?)");
            $stmt->bind_param("s", $_POST['category_name']);
            $stmt->execute();
            $stmt->close();
            $_SESSION['success'] = "Expense category added successfully!";
            header("Location: base.php");
            exit();
        }
        
        // Add Expense Head
        if (isset($_POST['add_expense_head'])) {
            $stmt = $conn->prepare("INSERT INTO expense_heads (name, category_id) VALUES (?, ?)");
            $stmt->bind_param("si", $_POST['head_name'], $_POST['category_id']);
            $stmt->execute();
            $stmt->close();
            $_SESSION['success'] = "Expense head added successfully!";
            header("Location: base.php");
            exit();
        }
        
        // Update Initial Values
        if (isset($_POST['update_initial_values'])) {
            // Check if initial values exist
            $checkQuery = "SELECT COUNT(*) as count FROM initial_values";
            $result = $conn->query($checkQuery);
            $count = $result->fetch_assoc()['count'];
            
            if ($count > 0) {
                $stmt = $conn->prepare("UPDATE initial_values SET cash_in_hand = ?, madhu_balance = ?, rathna_balance = ?, jambukkutti_balance = ? WHERE id = 1");
            } else {
                $stmt = $conn->prepare("INSERT INTO initial_values (cash_in_hand, madhu_balance, rathna_balance, jambukkutti_balance) VALUES (?, ?, ?, ?)");
            }
            $stmt->bind_param("dddd", 
                $_POST['cash_in_hand'], 
                $_POST['madhu_balance'], 
                $_POST['rathna_balance'], 
                $_POST['jambukkutti_balance']
            );
            $stmt->execute();
            $stmt->close();
            $_SESSION['success'] = "Initial values updated successfully!";
            header("Location: base.php");
            exit();
        }
        
    } catch (Exception $e) {
        $_SESSION['error'] = "An error occurred. Please try again.";
        error_log("Base.php error: " . $e->getMessage());
    }
}

// Fetch all buyers
$buyersQuery = "SELECT * FROM buyers ORDER BY name";
$buyers = $conn->query($buyersQuery)->fetch_all(MYSQLI_ASSOC);

// Fetch all expense categories with their heads
$categoriesQuery = "SELECT * FROM expense_categories ORDER BY name";
$categories = $conn->query($categoriesQuery)->fetch_all(MYSQLI_ASSOC);

// Fetch initial values
$initialQuery = "SELECT * FROM initial_values LIMIT 1";
$initialResult = $conn->query($initialQuery);
$initialValues = $initialResult->fetch_assoc();
if (!$initialValues) {
    $initialValues = [
        'cash_in_hand' => 0,
        'madhu_balance' => 0,
        'rathna_balance' => 0,
        'jambukkutti_balance' => 0
    ];
}

// Generate buyer rows
$buyerRows = '';
foreach ($buyers as $buyer) {
    $buyerRows .= "<tr>
        <td data-label='Name'>" . htmlspecialchars($buyer['name']) . "</td>
        <td data-label='Phone'>" . htmlspecialchars($buyer['phone']) . "</td>
        <td data-label='Tilapia Rate'>₹" . number_format($buyer['rate_tilapia'], 2) . "</td>
        <td data-label='Small Fish Rate'>₹" . number_format($buyer['rate_small_fish'], 2) . "</td>
        <td data-label='Big Fish Rate'>₹" . number_format($buyer['rate_big_fish'], 2) . "</td>
        <td data-label='Actions'>
            <div class='action-btns'>
                <a href='edit_buyer.php?id={$buyer['id']}' class='btn-edit'><i class='fas fa-edit'></i> Edit</a>
                <a href='delete_buyer.php?id={$buyer['id']}' class='btn-delete delete-confirm'><i class='fas fa-trash'></i> Delete</a>
            </div>
        </td>
    </tr>";
}

// Generate expense categories and heads
$expenseCategoriesHtml = '';
foreach ($categories as $category) {
    $headsQuery = "SELECT * FROM expense_heads WHERE category_id = " . $category['id'] . " ORDER BY name";
    $heads = $conn->query($headsQuery)->fetch_all(MYSQLI_ASSOC);
    
    $headsHtml = '';
    foreach ($heads as $head) {
        $headsHtml .= "<li>
            {$head['name']}
            <div class='action-btns' style='display: inline-block; margin-left: 1rem;'>
                <a href='edit_expense_head.php?id={$head['id']}' class='btn-edit btn-sm'><i class='fas fa-edit'></i></a>
                <a href='delete_expense_head.php?id={$head['id']}' class='btn-delete btn-sm delete-confirm'><i class='fas fa-trash'></i></a>
            </div>
        </li>";
    }
    
    $expenseCategoriesHtml .= "
    <div class='card'>
        <div class='card-header' style='background: linear-gradient(135deg, var(--text-secondary) 0%, #5a6268 100%);'>
            <h3 style='margin: 0; font-size: 1.1rem;'>{$category['name']}</h3>
            <a href='delete_expense_category.php?id={$category['id']}' class='btn btn-delete btn-sm delete-confirm'>
                <i class='fas fa-trash'></i> Delete Category
            </a>
        </div>
        <div class='card-body'>
            <ul style='list-style: none; padding: 0;'>
                $headsHtml
            </ul>
        </div>
    </div>";
}

$content = <<<HTML
<div class="card">
    <div class="card-header">
        <h2><i class="fas fa-cog"></i> Initial Values</h2>
    </div>
    <div class="card-body">
        <form method="POST" action="">
            <input type="hidden" name="update_initial_values" value="1">
            <div class="form-grid">
                <div class="form-group">
                    <label for="cash_in_hand">Cash in Hand:</label>
                    <input type="number" id="cash_in_hand" name="cash_in_hand" step="0.01" value="{$initialValues['cash_in_hand']}" required>
                </div>
                <div class="form-group">
                    <label for="madhu_balance">Madhu Balance:</label>
                    <input type="number" id="madhu_balance" name="madhu_balance" step="0.01" value="{$initialValues['madhu_balance']}" required>
                </div>
                <div class="form-group">
                    <label for="rathna_balance">Rathna Balance:</label>
                    <input type="number" id="rathna_balance" name="rathna_balance" step="0.01" value="{$initialValues['rathna_balance']}" required>
                </div>
                <div class="form-group">
                    <label for="jambukkutti_balance">Jambukkutti Balance:</label>
                    <input type="number" id="jambukkutti_balance" name="jambukkutti_balance" step="0.01" value="{$initialValues['jambukkutti_balance']}" required>
                </div>
            </div>
            <button type="submit" class="btn btn-primary"><i class="fas fa-save"></i> Update Initial Values</button>
        </form>
    </div>
</div>

<div class="card">
    <div class="card-header">
        <h2><i class="fas fa-user-plus"></i> Add New Buyer</h2>
    </div>
    <div class="card-body">
        <form method="POST" action="">
            <input type="hidden" name="add_buyer" value="1">
            <div class="form-grid">
                <div class="form-group">
                    <label for="name">Buyer Name:</label>
                    <input type="text" id="name" name="name" required>
                </div>
                <div class="form-group">
                    <label for="phone">Phone:</label>
                    <input type="tel" id="phone" name="phone" required>
                </div>
                <div class="form-group">
                    <label for="rate_tilapia">Tilapia Rate (₹/kg):</label>
                    <input type="number" id="rate_tilapia" name="rate_tilapia" step="0.01" required>
                </div>
                <div class="form-group">
                    <label for="rate_small_fish">Small Fish Rate (₹/kg):</label>
                    <input type="number" id="rate_small_fish" name="rate_small_fish" step="0.01" required>
                </div>
                <div class="form-group">
                    <label for="rate_big_fish">Big Fish Rate (₹/kg):</label>
                    <input type="number" id="rate_big_fish" name="rate_big_fish" step="0.01" required>
                </div>
                <div class="form-group">
                    <label for="delivery_rate">Delivery Rate (₹):</label>
                    <input type="number" id="delivery_rate" name="delivery_rate" step="0.01" required>
                </div>
                <div class="form-group">
                    <label for="harvesting_fee_tilapia">Harvesting Fee - Tilapia (₹/kg):</label>
                    <input type="number" id="harvesting_fee_tilapia" name="harvesting_fee_tilapia" step="0.01" required>
                </div>
                <div class="form-group">
                    <label for="harvesting_fee_small_fish">Harvesting Fee - Small Fish (₹/kg):</label>
                    <input type="number" id="harvesting_fee_small_fish" name="harvesting_fee_small_fish" step="0.01" required>
                </div>
                <div class="form-group">
                    <label for="harvesting_fee_big_fish">Harvesting Fee - Big Fish (₹/kg):</label>
                    <input type="number" id="harvesting_fee_big_fish" name="harvesting_fee_big_fish" step="0.01" required>
                </div>
            </div>
            <button type="submit" class="btn btn-success"><i class="fas fa-plus"></i> Add Buyer</button>
        </form>
    </div>
</div>

<div class="card">
    <div class="card-header">
        <h2><i class="fas fa-users"></i> Buyers List</h2>
        <a href="export_buyers.php" class="btn btn-export btn-sm">
            <i class="fas fa-file-csv"></i> Export CSV
        </a>
    </div>
    <div class="card-body">
        <div class="table-responsive">
            <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>Actions</th>
                    </tr>
                </thead>
                <tbody>
                    $buyerRows
                </tbody>
            </table>
        </div>
    </div>
</div>

<div class="card">
    <div class="card-header">
        <h2><i class="fas fa-plus-circle"></i> Add Expense Category</h2>
    </div>
    <div class="card-body">
        <form method="POST" action="">
            <input type="hidden" name="add_expense_category" value="1">
            <div class="form-grid">
                <div class="form-group">
                    <label for="category_name">Category Name:</label>
                    <input type="text" id="category_name" name="category_name" required>
                </div>
            </div>
            <button type="submit" class="btn btn-success"><i class="fas fa-plus"></i> Add Category</button>
        </form>
    </div>
</div>

<div class="card">
    <div class="card-header">
        <h2><i class="fas fa-plus-circle"></i> Add Expense Head</h2>
    </div>
    <div class="card-body">
        <form method="POST" action="">
            <input type="hidden" name="add_expense_head" value="1">
            <div class="form-grid">
                <div class="form-group">
                    <label for="head_name">Head Name:</label>
                    <input type="text" id="head_name" name="head_name" required>
                </div>
                <div class="form-group">
                    <label for="category_id">Category:</label>
                    <select id="category_id" name="category_id" required>
                        <option value="">Select Category</option>
HTML;

foreach ($categories as $category) {
    $content .= "<option value='{$category['id']}'>{$category['name']}</option>";
}

$content .= <<<HTML
                    </select>
                </div>
            </div>
            <button type="submit" class="btn btn-success"><i class="fas fa-plus"></i> Add Head</button>
        </form>
    </div>
</div>

<div>
    <h2 style="margin: 2rem 0 1rem;"><i class="fas fa-list"></i> Expense Categories & Heads</h2>
    $expenseCategoriesHtml
</div>
HTML;

include 'main_layout.php';
$conn->close();
?>