<?php
session_start();
ob_start(); // Start output buffering at the beginning
include("connection.php");
include("includes/header.php");
include("includes/sidebar.php");

$user_profile=$_SESSION['user_name'];
// if($user_profile==true){

// }else{
//     header('location:index.php');
// }



if (isset($_POST['submit'])) {
    // Sanitize input values
    $product_id = mysqli_real_escape_string($conn, $_POST['product_id']);
    $product_details = mysqli_real_escape_string($conn, $_POST['details']);
    // $attribute = mysqli_real_escape_string($conn, $_POST['attribute']);
    // $value = mysqli_real_escape_string($conn, $_POST['value']);

    // Prepare the SQL query to insert product details
    $sql = "INSERT INTO product_details (product_id, product_details, created_at, updated_at) 
            VALUES ('$product_id', '$product_details', NOW(), NOW())";

    // Execute the SQL query
    $result = mysqli_query($conn, $sql);

    // Check if the query was successful
    if ($result) {
        header('location:view_product_details.php'); // Redirect on success
    } else {
        echo "Error adding product details: " . mysqli_error($conn);
    }
}
// Fetch distinct categories for the dropdown
$category_query = "SELECT DISTINCT category FROM productpage";
$category_result = mysqli_query($conn, $category_query);

// Fetch products for dropdown
$product_query = "SELECT id, title FROM productpage";
$product_result = mysqli_query($conn, $product_query);
?>

<div class="app-main__outer">
                    <div class="app-main__inner">

                        <div class="app-page-title">
                            <div class="page-title-wrapper">
                                <div class="page-title-heading">
                                    <div class="page-title-icon">
                                    <i class="fas fa-tachometer-alt"></i>

                                    </div>
                                    <div>Admin Dashboard
                                        
                                    </div>
                                </div>
                                <div class="page-title-actions">
                                    <button type="button" data-toggle="tooltip" title="Example Tooltip" data-placement="bottom" class="btn-shadow mr-3 btn btn-dark">
                                        <i class="fa fa-star"></i>
                                    </button>
                                
                                </div>   
                             </div>
                         </div>

                         <div class="row"> 
    <div class="col-md-12">
        <div class="card mb-3">
            <div class="card-header">
                <strong>Add Category</strong>
            </div>
            <div class="card-body">
                <form action="" method="post" enctype="multipart/form-data">
                <!-- 'banner','popular_product','grain_product','vegetable_product','fodder_product' -->
                <div class="form-group">
                        <label for="category">Category Type</label>
                        <select class="form-control" name="category" id="category" required>
                            <option value="">Select Category</option>   
                            <?php while ($row = mysqli_fetch_assoc($category_result)) { ?>
                                <option value="<?= $row['category'] ?>"><?= ucfirst($row['category']) ?></option>
                            <?php } ?>
                        </select>
                    </div>
                   <!-- Product Dropdown -->
                   <div class="form-group">
                        <label for="product_id">Select Product</label>
                        <select class="form-control" name="product_id" id="product_id" required>
                            <option value="">Select Product</option>
                        </select>
                    </div>

                    <!-- <div class="form-group">
                        <label for="img">Image</label>
                        <input type="file" class="form-control" name="img">
                    </div> -->

                    <!-- <div class="form-group">
                        <label for="attribute">Attribute</label>
                        <input type="text" class="form-control" name="attribute" placeholder="Enter Attribute" required>
                    </div>

                    <div class="form-group">
                        <label for="value">Value</label>
                        <input type="text" class="form-control" name="value" placeholder="Enter Value" required>
                    </div> -->

                    <div class="form-group">
    <label for="details">Product-Details</label>
    <textarea class="form-control" id="details" name="details" rows="5" placeholder="Enter Product-Details"></textarea>
</div>


                    <input type="submit" class="btn btn-primary" value="Submit" name="submit">
                </form>
            </div>
        </div>
    </div>
</div>

                    </div></div>


                    <script>
    CKEDITOR.replace('details');
</script>


                    
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script>
$(document).ready(function(){
    $('#category').change(function(){
        var category = $(this).val();
        if(category !== "") {
            $.ajax({
                type: 'POST',
                url: 'fetch_products.php',
                data: {category: category},
                success: function(response){
                    $('#product_id').html(response);
                }
            });
        } else {
            $('#product_id').html('<option value="">Select Product</option>');
        }
    });
});
</script>

<?php
// Footer and output buffering
include("includes/footer.php");
ob_end_flush(); // Send the buffered output to the client
?>


