<!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;
  }

</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['update_data'])) {
    $barcode = $_POST['barcode'];
    $trans = $_POST['trans'];
    $buy = $_POST['buy'];
    $unit = $_POST['unit'];
    $pieces = $_POST['pieces'];
    $currency_buy = $_POST['currency_buy'];

    // Function to round up to the nearest hundred
    function roundUpToNearestHundred($number) {
        return ceil($number / 100) * 100;
    }

    // Array of product tables to update
    $product_tables = [$product, $cargo_1];

    // Update barcode, trans, buy, unit, pieces for both tables
    foreach ($product_tables as $product_data) {
        $sql = "UPDATE $product_data SET trans='$trans', buy='$buy', unit='$unit', pieces='$pieces' WHERE barcode='$barcode'";
        if (!$connection->query($sql)) {
            // Log error or handle it appropriately
            error_log("Error updating $product_data: " . $connection->error);
        }
    }

    // Query product table to get current values
    // Fetch product details
$sql = "SELECT * FROM $product WHERE barcode = ?";
$stmt = $connection->prepare($sql);
$stmt->bind_param('s', $barcode);
$stmt->execute();
$product_result = $stmt->get_result();

if ($product_result && $product_result->num_rows > 0) {
    $row = $product_result->fetch_assoc();
    $unit = $row['unit'];
    $pieces = $row['pieces'];
    $buy = $row['buy'];
    $trans = $row['trans'];

    // Query rate table (once)
    $sql_rate = "SELECT * FROM $rate";
    $rate_result = $connection->query($sql_rate);

    if ($rate_result && $rate_result->num_rows > 0) {
        $rate_row = $rate_result->fetch_assoc();
        $profit = $rate_row['profit'];
        $baht = $rate_row['baht'];
        $yuan = $rate_row['yuan'];
        $dollar = $rate_row['dollar'];

        // Calculate prices based on the currency
        switch ($currency_buy) {
            case 'kyat':
                $package_price = ($buy * ($profit / 100)) + $buy + $trans;
                break;
            case 'baht':
                $package_price = (($buy * $baht) * ($profit / 100)) + ($buy * $baht) + $trans;
                break;
            case 'yuan':
                $package_price = (($buy * $yuan) * ($profit / 100)) + ($buy * $yuan) + $trans;
                break;
            case 'dollar':
                $package_price = (($buy * $dollar) * ($profit / 100)) + ($buy * $dollar) + $trans;
                break;
            default:
                echo json_encode(['status' => 'error', 'message' => 'Invalid currency']);
                exit;
        }

        if ($unit > 0) {
            $unit_price = $package_price / $unit;
        } else {
            $unit_price = 0; // or handle the zero case as needed
        }
        
        if ($pieces > 0 && $unit_price > 0) {
            $pieces_price = $unit_price / $pieces;
        } else {
            $pieces_price = 0; // or handle the zero case as needed
        }

        // Round prices
        $round_package_price = roundUpToNearestHundred($package_price);
        $round_unit_price = roundUpToNearestHundred($unit_price);
        $round_pieces_price = roundUpToNearestHundred($pieces_price);

        // Prepare SQL for updating tables
        foreach ($product_tables as $product_data) {
            $sql_update = "UPDATE $product_data 
                           SET package_price = ?, 
                               unit_price = ?, 
                               pieces_price = ?, 
                               round_package_price = ?, 
                               round_unit_price = ?, 
                               round_pieces_price = ? 
                           WHERE barcode = ?";
            $stmt_update = $connection->prepare($sql_update);
            $stmt_update->bind_param('dddddds', $package_price, $unit_price, $pieces_price, $round_package_price, $round_unit_price, $round_pieces_price, $barcode);

            if (!$stmt_update->execute()) {
                // Log error or handle it appropriately
                error_log("Error updating prices in $product_data: " . $stmt_update->error);
            }
        }

        // Redirect after successful update
        header('Location: product_view_photo.php');
        exit;
    } else {
        // Log error if no rates are found
        error_log("No rates found in $rate");
    }
} else {
    // Log error if no product is found
    error_log("No product found with barcode: $barcode");
}

}




if ($_SERVER['REQUEST_METHOD'] == 'POST') {

    $id = isset($_POST['id']) ? $_POST['id'] : null;
    $action = isset($_POST['action']) ? $_POST['action'] : null;

    switch ($action) {
        case 'info':
            $sql = "SELECT * FROM ".$product." WHERE id = '$id'";
                $result = $connection->query($sql);
                if ($result->num_rows > 0) {
                    $row = $result->fetch_assoc();
                    $imageData = $row['image'];
    
                    echo ' 
                    <div class="modal fade" id="infoModal" tabindex="-1" aria-labelledby="infoModalLabel" aria-hidden="true">
                    <div class="modal-dialog">
                        <div class="modal-content">
                            <div class="modal-header bg-info text-white">
                                <h5 class="modal-title" id="infoModalLabel">'.$row["product_name"].'</h5>
                                <button type="button" class="close" data-dismiss="modal" aria-label="Close" onclick="refreshPage()">
                                    <span aria-hidden="true">&times;</span>
                                </button>
                            </div>
                            <div class="modal-body">
                                <!-- Dynamically inserted Image -->
                                <div class="text-center">
                                <img src="data:image/jpeg;base64,' . base64_encode($imageData) . '" class="img-fluid mb-3" alt="Sample Image" style="margin-left:auto;margin-right:auto;">
                                    </div>
                                    <form action="product_view_photo.php" method="POST">
                                    <table style="font-size:15px;">
                                    <tr style="height: 25px;">
                                        <th> <label for="pwd" alt="hi" style="font-size: 15px;">barcode:</label></th>
                                        <th><input type="text" tyle="font-size: 15px;" class="form-control"  name="barcode" value="'.$row["barcode"].'"></th>
                                    </tr>

                                    <tr style="height: 25px;">
                                        <th> <label for="pwd" alt="hi" style="font-size: 15px;">သယ်ဆောင်ခ:</label></th>
                                        <th><input type="text" tyle="font-size: 15px;" class="form-control"  name="trans" value="'.$row["trans"].'"></th>
                                    </tr>

                                    <tr style="height: 25px;">
                                        <th> <label for="pwd" alt="hi" style="font-size: 15px;">ငွေအမျိုးအစား:</label></th>
                                        <th>
                                            <select name="currency_buy" id="bankingInput" class="form-control">
                                            <option value="' . $row['currency_buy'] . '">' . $row['currency_buy']. '</option>
                                            <option value="kyat">ကျပ်</option>
                                            <option value="baht">ဘတ်</option>
                                            <option value="yuan">ယွမ်</option>
                                            </select>
                                        </th>
                                    </tr>




                                    <tr style="height: 25px;">
                                        <th> <label for="pwd" alt="hi" style="font-size: 15px;">ဖာလိုက်ဝယ်ဈေး:</label></th>
                                        <th><input type="text" tyle="font-size: 15px;" class="form-control"  name="buy" value="'.$row["buy"].'"></th>
                                    </tr>

                                    <tr style="height: 25px;">
                                        <th> <label for="pwd" alt="hi" style="font-size: 15px;">မူရင်းကဒ်:</label></th>
                                        <th><input type="text" tyle="font-size: 15px;" class="form-control"  name="unit" value="'.$row["unit"].'"></th>
                                    </tr>

                                    <tr style="height: 25px;">
                                        <th> <label for="pwd" alt="hi" style="font-size: 15px;">မူရင်းဗူး:</label></th>
                                        <th><input type="text" tyle="font-size: 15px;" class="form-control"  name="pieces" value="'.$row["pieces"].'"></th>
                                    </tr>

                                    <tr style="height: 25px;">
                                        <th> <label for="pwd" alt="hi" style="font-size: 15px;">ရောင်းဈေးဖာ:</label></th>
                                        <th><input type="text" style="font-size: 15px;" class="form-control" value="'.$row["round_package_price"].'" readonly></th>
                                    </tr>

                                    <tr style="height: 25px;">
                                        <th> <label for="pwd" alt="hi" style="font-size: 15px;">ရောင်းဈေးကဒ်:</label></th>
                                        <th><input type="text" style="font-size: 15px;" class="form-control" value="'.$row["round_unit_price"].'" readonly></th>
                                    </tr>

                                    <tr style="height: 25px;">
                                        <th> <label for="pwd" alt="hi" style="font-size: 15px;">ရောင်းဈေးဗူး:</label></th>
                                        <th><input type="text" style="font-size: 15px;" class="form-control" value="'.$row["round_pieces_price"].'" readonly></th>
                                    </tr>

                                    <tr style="height: 25px;">
                                        <th> <label for="pwd" alt="hi" style="font-size: 15px;">လက်ကျန်ဖာ:</label></th>
                                        <th><input type="text" style="font-size: 15px;" class="form-control" value="'.$row["package_exist"].'" readonly></th>
                                    </tr>

                                    <tr style="height: 25px;">
                                        <th> <label for="pwd" alt="hi" style="font-size: 15px;">လက်ကျန်ကဒ်:</label></th>
                                        <th><input type="text" style="font-size: 15px;" class="form-control" value="'.$row["unit_exist"].'" readonly></th>
                                    </tr>

                                    <tr style="height: 25px;">
                                        <th> <label for="pwd" alt="hi" style="font-size: 15px;">လက်ကျန်ဗူး:</label></th>
                                        <th><input type="text" style="font-size: 15px;" class="form-control" value="'.$row["pieces_exist"].'" readonly></th>
                                    </tr>

                                    <tr>
                                    <th scope="col" colspan="3"> <button type="submit" name="update_data" class="btn btn-outline-success" style="margin: 10px;width:90%" data-toggle="modal" data-target="#infoModal">ပြင်ရန်</button></th>
                                    </tr>
                                </table>
                                </form>
                                   
                                    </div>
                                </div>
                                </div>
                            </div>
                            ';
                        } else {
                            echo "Image not found.";
                        }           
                    echo '
                    ';
            
            

            break;

        case 'upload':

            break;


        case 'delete':

            $sql = "SELECT product_name FROM ".$product." WHERE id ='$id'";
            $result = $connection->query($sql);
            if ($result && $result->num_rows > 0) {
                while ($row = $result->fetch_assoc()) {
                    $product_name = $row['product_name'];

                    $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!");';
                                }
                        }

                
                }
            }


            


            break;

        default:
            
    }
} else {
  
}

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="col">

                <div class="card-header gx-5">

                    <form class="d-flex flex-row-reverse" action="product_view_photo.php" method="POST" >

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

                    <div class="col-auto" style="margin-left:10px">
                    <!-- <select name="product_type" id="accountInput" onchange="filterTable()" class="form-control"> -->
                    <select name="product_type" id="accountInput" class="form-control">
                                <?php
                                $sql = "SELECT * FROM ".$catagories."";
                                $result = $connection->query($sql);
                                if ($result && $result->num_rows > 0) {
                                    while ($row = $result->fetch_assoc()){
                                        $account = $row['type']; // Database
                                        echo '<option value="' . $account . '">' . $account . '</option>';
                                    }
                                }
                                ?>
                            </select>
               
                    </div>

                    <div class="col-auto" style="margin-left:10px">
                        <button type="submit" class="btn btn-primary mb-3"  name="search">Search</button>
                    </div>

                    <div class="col-auto" style="margin-left:10px">
                        <button type="submit" class="btn btn-success mb-3" onclick="refreshPage()">Refresh</button>
                    </div>

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

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


                    

                    

                    </form> 
                    </div>
                    <div class="container-fluid">
                    <div class="row justify-content-center" style='margin:0px;'> 
                        <h1 style="margin:10px 0px 15px 10px;font-size:30px;text-align:center">ပစ္စည်းစာရင်း</h1>

                        <!-- =================cont_1================================ -->
                        
                        <?php
                        // Fetch all image data from the database
                        $sql = "SELECT * FROM ".$catagories." WHERE active='1'";
                        $result = $connection->query($sql);
                        if ($result->num_rows > 0) {
                            while ($row = $result->fetch_assoc()) {
                                $type = $row['type'];

                                $sql = "SELECT * FROM ".$product." WHERE delete_d='0' and type='$type' ORDER BY id DESC";
                                $result = $connection->query($sql);

                                if ($result->num_rows > 0) {
                                    while ($row = $result->fetch_assoc()) {
                                        $imageData = $row['image'];
                                        $id = $row['id'];
                                        echo '
                                        <div class="col-sm-4" style="border-radius:10px; width:320px; margin:10px">
                                            <div class="card mb-3">
                                                <div class="card-header bg-info text-white">
                                                    <h5 class="card-title">'.$row["product_name"].'</h5>
                                                </div>
                                                <div class="card-body">
                                                
                                                    <div class="text-center">
                                                        <div class="image-container">
                                                            <img src="data:image/jpeg;base64,' . base64_encode($imageData) . '"  alt="Sample Image" style="width:100%;">
                                                        </div>
                                                    </div>

                                                    <div style="margin-top:10px;line-height: 1;">
                                                    <p class="card-text" style="font-size:15px">ပစ္စည်းအမည်: <a style="color:white">'.$row["product_name"].'</a></p>
                                                    <p class="card-text" style="font-size:15px">code နံပါတ်: <a style="color:white">'.$row["barcode"].'</a></p>
                                                    <p class="card-text" style="font-size:15px">အမျိုးစား: <a style="color:white">'.$row["type"].'</a></p>

                                                    <p class="card-text" style="font-size:15px">ရောင်းဈေးဖာ <a style="color:white">'.$row["round_package_price"].'</a></p>
                                                    <p class="card-text" style="font-size:15px">ရောင်းဈေးကဒ်: <a style="color:white">'.$row["round_unit_price"].'</a></p>
                                                    <p class="card-text" style="font-size:15px">ရောင်းဈေးဘူး: <a style="color:white">'.$row["round_pieces_price"].'</a></p>

                                                    <p class="card-text" style="font-size:15px">လက်ကျန်ဖာ: <a style="color:white">'.$row["package_exist"].'</a></p>
                                                    <p class="card-text" style="font-size:15px">လက်ကျန်ကဒ်: <a style="color:white">'.$row["unit_exist"].'</a></p>
                                                    <p class="card-text" style="font-size:15px">လက်ကျန်ဘူး: <a style="color:white">'.$row["pieces_exist"].'</a></p>
                                                
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                        ';
                                    }
                                } else {
                                    echo "No images found.";
                                }
                            }
                        }

                        
                        ?>

                    </div>
                </div>
                   
                </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>
