<!DOCTYPE html>
<html lang="en" data-bs-theme="dark">

<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>ပစ္စည်းစာရင်း</title>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha2/dist/css/bootstrap.min.css">
<script src="https://kit.fontawesome.com/ae360af17e.js" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/js/bootstrap.bundle.min.js"></script>
<link rel="stylesheet" href="css/style.css">
<link rel="icon" href="image/logo.png" type="image/png">
</head>
<style>
    
video {
width: 100%;
height: 200px;

object-fit: cover;
/* Ensures the video fills the container */
display: block;
}

.image-container {
width: 200px;
/* Adjust this width as needed */
height: 200px;
/* Adjust this height as needed */
overflow: hidden;
position: relative;
border: 1px solid #ccc;
/* Add a border for the frame effect */
}

.image-container img {
width: 100%;
height: 100%;
object-fit: contain;
/* Ensure the entire image is visible */
}
</style>

<script>
function formatNumber(input) {
// Remove all non-digit characters
let value = input.value.replace(/\D/g, '');

// Format the number with commas
let formattedValue = new Intl.NumberFormat().format(value);

// Update the input value
input.value = formattedValue;
}

document.addEventListener('DOMContentLoaded', function() {
const formattedInput = document.getElementById('formatted');
formattedInput.addEventListener('input', function() {
formatNumber(this);
});
});
</script>


<?php
session_start();

if (isset($_SESSION['browser_id'])) {
$browserId = $_SESSION['browser_id'];
} else {
// Generate a new browser ID
$browserId = generateUniqueBrowserId();

// Store the browser ID in the session for future use
$_SESSION['browser_id'] = $browserId;
}


include "database/database.php";
include "database/data.php";
include "cal_pro_remain.php";
include "login_check.php";





if (isset($_POST['delete'])) {
$product_name = $_POST['product_name'];

//Delete Photo
$extensions = ['jpg', 'jpeg', 'png', 'gif', 'webp'];
// Loop through the extensions to find the existing file
$fileToDelete = '';
foreach ($extensions as $ext) {
$potentialFile = 'uploads/' . $product_name . '.' . $ext;
if (file_exists($potentialFile)) {
$fileToDelete = $potentialFile;
break;
}
}

// Check if a matching file was found
if ($fileToDelete) {
// Attempt to delete the file
if (unlink($fileToDelete)) {
// echo "File deleted successfully: $fileToDelete";
} else {
// echo "Error: Unable to delete the file.";
}
} else {
// echo "Error: File does not exist with any of the expected extensions.";
}

//Update Data
$product_tables = [$product, $cargo_1];

foreach ($product_tables as $product_data) {
$query = "DELETE FROM " . $product_data . " WHERE product_name = '$product_name'";
if ($connection->query($query)) {
echo 'Deleted successfully.';
} else {
echo 'alert("Update failed!");';
}
}
}



if (isset($_POST['search'])) {
$product_type = $_POST['product_type'];


$sql = "UPDATE $catagories SET active='1' WHERE type='$product_type'";
if (!$connection->query($sql)) {
}

$sql = "UPDATE $catagories SET active='0' WHERE type!='$product_type'";
if (!$connection->query($sql)) {
// Log error or handle it appropriately

}
}


?>

<script>
function refreshPage() {
location.reload();
}
</script>


<body>
<div class="wrapper">
<?php
include "sidebar.php";
include "database/database.php";
include "database/data.php";
?>

<div class="main">
<nav class="navbar navbar-expand px-3 border-bottom">
    <button class="btn" id="sidebar-toggle" type="button">
        <span class="navbar-toggler-icon"></span>
    </button>
    <div class="navbar-collapse navbar">
        <ul class="navbar-nav">
            <div class="mb-3" style="margin-right:30px">
                <h4 style="font-size:25px">ပစ္စည်းစာရင်း</h4>
            </div>

            <li class="nav-item dropdown">
                <a href="#" data-bs-toggle="dropdown" class="nav-icon pe-md-0">
                    <img src="image/logo.png" class="avatar img-fluid rounded" alt="">
                </a>
                <?php include "logo_profile.php"; ?>
            </li>
        </ul>
    </div>
</nav>

<main class="content px-3 py-2">
<div class="container-fluid">


    <div class="row">

        <!-- Table Element -->
    <div class="container-fluid">

        <div class="container-fluid" style="margin-bottom: 20px;">

            <form action="product_view_photo.php" method="POST">

       

                <div class="row" style="margin-top:10px;text-align:center">


        
                 

                    <div class="col " style="margin:5px">
                        <button type="submit" class="btn btn-success mb-3" name="refresh">Refresh</button>
                    </div>

                    <div class="col" style="margin:5px">
                        <button type="button" class="btn btn-success mb-3" onclick="window.location.href='product_view.php';">Table</button>
                    </div>

                    <div class="col" style="margin:5px">
                        <button type="button" class="btn btn-success mb-3" onclick="window.location.href='product_view_all.php';">All</button>
                    </div>

                    <div class="col" style="margin:5px">
                        <button type="button" class="btn btn-success mb-3" onclick="window.location.href='product_view_photo.php';">Photo</button>
                    </div>

                    <div class="col" style="margin:5px">
                        <button type="button" class="btn btn-success mb-3" onclick="window.location.href='product_view_photo_search.php';">Search Photo</button>
                    </div>



                </div>

                <div class="col" style="margin-left:10px">
        <input type="text" class="form-control" id="searchInput" placeholder="Search">
    </div>

            </form>
        </div>




        <div class="container-fluid">
            <?php
            $sql_rate = "SELECT * FROM ".$rate." LIMIT 1"; // Add LIMIT 1 to ensure only one row is fetched
            $result = $connection->query($sql_rate);
            
            if ($result && $result->num_rows > 0) {
                $row_rate = $result->fetch_assoc();
                $baht = $row_rate['baht']; 
                $yuan = $row_rate['yuan']; 
            } else {
                // Handle case where no rows are returned
                $baht = null;
                $yuan = null;
            }
            

            // Calculate pagination
            $limit = 300; // Rows per page
            $page = isset($_GET['page']) ? (int)$_GET['page'] : 1; // Current page
            $start = ($page - 1) * $limit; // Start index

            // Get total rows
            $totalQuery = "SELECT COUNT(*) as total FROM $product";
            $totalResult = mysqli_query($connection, $totalQuery);
            $totalRow = mysqli_fetch_assoc($totalResult);
            $totalRecords = $totalRow['total'];
            $totalPages = ceil($totalRecords / $limit);

            // Fetch rows for the current page
            $sql = "SELECT * FROM $product ORDER BY id DESC LIMIT $start, $limit";
            $result = mysqli_query($connection, $sql);
            ?>

            <div class="card-view mt-4">

            <nav class="mt-4">
                        <ul class="pagination justify-content-center">
                            <?php if ($page > 1): ?>
                                <li class="page-item"><a class="page-link" href="?page=<?= $page - 1 ?>">Previous</a></li>
                            <?php endif; ?>
                            <?php for ($i = 1; $i <= $totalPages; $i++): ?>
                                <li class="page-item <?= ($i == $page) ? 'active' : '' ?>">
                                    <a class="page-link" href="?page=<?= $i ?>"><?= $i ?></a>
                                </li>
                            <?php endfor; ?>
                            <?php if ($page < $totalPages): ?>
                                <li class="page-item"><a class="page-link" href="?page=<?= $page + 1 ?>">Next</a></li>
                            <?php endif; ?>
                        </ul>
                    </nav>
    

                <div id="cardContainer" class="row">
                    <?php if ($result): ?>
                        <?php while ($row = mysqli_fetch_assoc($result)): ?>
                            <div class="col-md-3 mb-3 card-item">
                                <div class="card bg-dark text-white">
                                    <div class="card-body">

                                        <div style="justify-content: center;">
                                            <div class="image-container">

                                                <?php
                                                // Define the possible file extensions
                                                $extensions = ['jpg', 'jpeg', 'png', 'gif'];
                                                $imagePath = '';
                    
                                                // Check for the correct file extension
                                                foreach ($extensions as $ext) {
                                                    $potentialPath = 'uploads/' . $row["product_name"] . '.' . $ext;
                                                    if (file_exists($potentialPath)) {
                                                        $imagePath = $potentialPath;
                                                        break;
                                                    }
                                                }
                    
                                                // If the image path is found, display the image
                                                if ($imagePath) {
                                                    echo '<img src="' . $imagePath . '" class="img-fluid mb-3" alt="Sample Image" style="margin-left:auto;margin-right:auto;width:200px;">';
                                                } else {
                                                    echo 'Image not found.';
                                                }
                                                ?>

                                            </div>
                                        </div>

                       
                                        <h6 class="card-text" style="margin-top:20px"><strong>ပစ္စည်းအမည်:</strong> <?= htmlspecialchars($row['product_name']) ?></h6>
                                        <h6 class="card-text" style="margin-top:20px"><strong>code 1:</strong> <?= htmlspecialchars($row['barcode']) ?></h6>
                                        <h6 class="card-text" style="margin-top:20px"><strong>code 2:</strong> <?= htmlspecialchars($row['barcode_1']) ?></h6>
                                        <h6 class="card-text" style="margin-top:20px"><strong>အမျိုးစား:</strong> <?= htmlspecialchars($row['type']) ?></h6>
                                        <h6 class="card-text" style="margin-top:20px"><strong>ငွေဈေးနှုန်း:</strong> <?= htmlspecialchars($row['rate']." (".$row['currency_buy'].")") ?></h6>
                                        <h6 class="card-text" style="margin-top:20px"><strong>ကားခ:</strong> <?= htmlspecialchars($row['trans']) ?></h6>                   
                                        <h6 class="card-text" style="margin-top:20px"><strong>ဖာလိုက်ဝယ်ဈေး:</strong> <?= htmlspecialchars($row['buy']) ?></h6>                   

                                        

                                        <?php
                                         echo '
                                         <table class="table table-bordered"> 
                                         <tr>
                                         <td colspan="3" style="text-align:center">PF</td>
                                         </tr>

                                         <tr>
                                         <td style="text-align:center">ဖာ</td>
                                         <td style="text-align:center">ကဒ်/ထုပ်</td>
                                         <td style="text-align:center">ဗူး/ခု</td>
                                         </tr>

                                         <tr>
                                         <td style="text-align:center;color:white">' . ($row["round_package_price"]) . '</td>
                                         <td style="text-align:center;color:white">' . ($row["round_unit_price"]) . '</td>
                                         <td style="text-align:center;color:white">' . ($row["round_pieces_price"]) . '</td>
                                         </tr>
                                         </table>
                                         ';
                                        

                        
                                           

                                            echo '
                                            <table class="table"> 


                                            <tr>
                                            <td>
                                            <form action="product_photo_view.php" method="POST"  target="_blank" style="width:100%">
                                                    <input type="hidden" name="product_name" value="' . htmlspecialchars($row['product_name']) . '">
                                                    <input type="hidden" name="action" value="info">
                                                    <button type="submit" class="btn btn-outline-success" name="info_button" style="width:100%">ပြင်ရန်</button>
                                                </form> 
                                            </td>

                                            <td>
                                            <form action="product_view_photo.php" method="POST"  target="_blank" style="margin-left:10px;width:100%">
                                                    <input type="hidden" name="product_name" value="' . htmlspecialchars($row['product_name']) . '">
                                                    <input type="hidden" name="action" value="info">
                                                    <button type="submit" class="btn btn-outline-danger" name="delete" style="width:100%">ဖျက်ရန်</button>
                                                </form> 
                                            </td>

                                            </tr>

                                            <tr>
                                             <td colspan=2>
                                            <form action="print_barcode.php" method="POST"  target="_blank" style="margin-left:10px;width:100%">
                                                    <input type="hidden" name="product_name" value="' . htmlspecialchars($row['product_name']) . '">
                                                    <input type="hidden" name="action" value="info">
                                                    <button type="submit" class="btn btn-outline-warning" name="delete" style="width:100%">Print Barcode</button>
                                                </form> 
                                            </td>

                                            </tr>


                                            </table>
                                            ';

                                        ?>


                                            </div>
                                        </div>
                                    </div>
                                <?php endwhile; ?>
                            <?php endif; ?>
                        </div>
                    </div>

                  
                </div>

                <script>
                    $(document).ready(function() {
                        $("#searchInput").on("keyup", function() {
                            var value = $(this).val().toLowerCase();
                            $(".card-item").filter(function() {
                                $(this).toggle($(this).text().toLowerCase().indexOf(value) > -1);
                            });
                        });
                    });
                </script>

            </div>


        </div>
    </div>
</main>

<script>
    // Call filterTable immediately after the page loads
    window.onload = function() {
        filterTable(); // Automatically filters based on the first option selected
    };
</script>


<a href="#" class="theme-toggle">
    <i class="fa-regular fa-moon"></i>
    <i class="fa-regular fa-sun"></i>
</a>
<footer class="footer">
    <div class="container-fluid">
        <div class="row text-muted">
            <div class="col-6 text-start">
                <p class="mb-0">
                    <a href="#" class="text-muted">
                        <?php
                        include "version.php";
                        ?>
                    </a>
                </p>
            </div>
            <div class="col-6 text-end">
                <ul class="list-inline">
                    <li class="list-inline-item">
                        <a href="#" class="text-muted">Contact</a>
                    </li>
                    <li class="list-inline-item">
                        <a href="#" class="text-muted">About Us</a>
                    </li>
                    <li class="list-inline-item">
                        <a href="#" class="text-muted">Terms</a>
                    </li>
                    <li class="list-inline-item">
                        <a href="#" class="text-muted">Booking</a>
                    </li>
                </ul>
            </div>
        </div>
    </div>
</footer>
</div>
</div>

<!-- Number Format -->
<script>
function formatNumber() {
const inputField = document.getElementById('package_price');
let value = inputField.value;

// Remove any non-numeric characters (except for decimal points)
value = value.replace(/[^0-9.]/g, '');

// Format the number
const formattedValue = new Intl.NumberFormat().format(value);

// Set the formatted value back to the input field
inputField.value = formattedValue;
}
</script>



<?php

function generateUniqueBrowserId()
{
$randomString = bin2hex(random_bytes(16));
$timestamp = time();

return $randomString . $timestamp;
}

?>





<script src="js/script.js"></script>
<script src="https://code.jquery.com/jquery-3.5.1.slim.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.5.4/dist/umd/popper.min.js"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
</body>

</html>