<!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 "cal_pro_rate.php";
include "login_check.php";


if (isset($_POST['add'])) {
    $barcode = $_POST['barcode'];
    $barcode_1 = $_POST['barcode_1'];
    $product_name = $_POST['product_name'];

    $sql = "SELECT * FROM ".$rate."";
        $result = $connection->query($sql);
        if ($result && $result->num_rows > 0) {
        while ($row = $result->fetch_assoc()) {
            $baht = $row['baht']; 
            $yuan = $row['yuan']; 
            $dollar = $row['dollar']; 


    if($barcode == '' && $product_name== ''){ 
        // echo "<script>alert('Need Barcode')</script>";
    }else{ 
        
        $product_type = $_POST['product_type'];
        $unit = $_POST['unit'];
        $pieces = $_POST['pieces'];
        $buy = $_POST['buy'];
        
        $trans = $_POST['trans'];
        $currency_rate = '0';
        $currency_buy = $_POST['currency_buy'];
        $profit = $_POST['profit'];
    
        function roundUpToNearestHundred($number) {
            return ceil($number / 100) * 100;
        }    

            if($currency_buy == 'kyat'){ 
                $package_price = $profit+$buy+$trans;
                $rate = '1';
            }else if($currency_buy == 'baht'){ 
                $package_price = ($profit+($buy*$baht)+$trans);
                $rate = $baht;

            }else if($currency_buy == 'yuan'){ 
                $package_price = ($profit+($buy*$yuan)+$trans);
                $rate = $yuan;

            }else if($currency_buy == 'dollar'){ 
                $package_price = ($profit+($buy*$dollar)+$trans);
                $rate = $dollar;
            }

    
            // $package_price = ($buy*($profit/100))+$buy+$trans;
            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_package_price = roundUpToNearestHundred($package_price);
            $round_unit_price = roundUpToNearestHundred($unit_price);
            $round_pieces_price = roundUpToNearestHundred($pieces_price);
        
            $package_remain = '0';
            $pieces_remain = '0';
            $unit_remain = '0';
            
    

        if (isset($_FILES["image"]) && $_FILES["image"]["error"] == 0) {
            // File upload successful
            $image = $_FILES["image"]["tmp_name"];
            
            // Create an image resource from the uploaded file
            $imgResource = imagecreatefromstring(file_get_contents($image));
        
            if ($imgResource !== false) {
                // Set initial quality (this can be adjusted)
                $quality = 75;
        
                // Output buffer to hold the compressed image data
                ob_start();
                imagejpeg($imgResource, null, $quality);
                $imgContent = ob_get_contents();
                ob_end_clean();
        
                // Keep reducing quality until the file size is below 15 KiB
                while (strlen($imgContent) > 15 * 1024 && $quality > 10) {
                    $quality -= 5;
                    ob_start();
                    imagejpeg($imgResource, null, $quality);
                    $imgContent = ob_get_contents();
                    ob_end_clean();
                }
        
                // Free up memory
                imagedestroy($imgResource);
        
                // Escape the content to store in the database
                $imgContent = addslashes($imgContent);
        
                // Continue with processing $imgContent, such as saving it to the database
                // ...
        
            } else {
                // Handle the error - file could not be processed as an image
                echo "Failed to process image.";
            }
        } else {
            // Handle the error - file not uploaded
            // echo "File upload error.";
            header('Location: product_add_new.php');
        }
        
        $imgContent = '0';

      
        $sql = "SELECT * FROM ".$product." where barcode='$barcode' or product_name='$product_name'";
        $result = $connection->query($sql);
        if ($result && $result->num_rows > 0) {
            echo '<script>alert("Product Already Exist") ;</script>';
        } else { 

            $expire_date = date('Y-m-d');
            $sql = "INSERT INTO ".$product." (
                barcode, 
                barcode_1,
                product_name, 
                type, 
                unit, 
                pieces, 
                buy, 
                currency_buy, 
                rate, 
                currency_rate, 
                trans, 
                profit, 
                round_package_price, 
                round_unit_price, 
                round_pieces_price, 
                package_price, 
                unit_price, 
                pieces_price, 
                package_remain, 
                unit_remain, 
                pieces_remain, 
                package_sell, 
                unit_sell, 
                pieces_sell,
                package_damage,
                unit_damage,
                pieces_damage, 
                package_change,
                unit_change,
                pieces_change, 
                package_trans,
                unit_trans,
                pieces_trans, 
                package_exist, 
                unit_exist, 
                pieces_exist, 
                exp_date, 
                delete_d, 
                image
            ) VALUES (
                '$barcode',
                '$barcode_1',
                '$product_name',
                '$product_type',
                '$unit',
                '$pieces',
                '$buy',
                '$currency_buy',
                '$rate',
                '$currency_rate',
                '$trans',
                '$profit',
                '$round_package_price',
                '$round_unit_price',
                '$round_pieces_price',
                '$package_price',
                '$unit_price',
                '$pieces_price',
                '$package_remain',
                '$unit_remain',
                '$pieces_remain',
                '0',
                '0',
                '0',
                '0',
                '0',
                '0',
                '0',
                '0',
                '0',
                '0',
                '0',
                '0',
                '1000',
                '1000',
                '1000',
                '$expire_date',
                '0',
                '$imgContent'
            )";

    if ($connection->query($sql) === TRUE) {
        echo "Record inserted successfully into $product<br>";
    } else {
        echo "Error inserting record into $product: " . $connection->error . "<br>";
    }


                $sql_cargo = "INSERT INTO ".$cargo_1." (
                            barcode, 
                            barcode_1,
                            product_name, 
                            type, 
                            unit, 
                            pieces, 
                            buy, 
                            currency_buy, 
                            rate, 
                            currency_rate, 
                            trans, 
                            profit, 
                            round_package_price, 
                            round_unit_price, 
                            round_pieces_price, 
                            package_price, 
                            unit_price, 
                            pieces_price, 
                            package_remain, 
                            unit_remain, 
                            pieces_remain, 
                            package_sell, 
                            unit_sell, 
                            pieces_sell,
                            package_damage,
                            unit_damage,
                            pieces_damage, 
                            package_change,
                            unit_change,
                            pieces_change, 
                            package_trans,
                            unit_trans,
                            pieces_trans, 
                            package_exist, 
                            unit_exist, 
                            pieces_exist, 
                            exp_date, 
                            delete_d, 
                            image
                        ) VALUES (
                            '$barcode',
                            '$barcode_1',
                            '$product_name',
                            '$product_type',
                            '$unit',
                            '$pieces',
                            '$buy',
                            '$currency_buy',
                            '$rate',
                            '$currency_rate',
                            '$trans',
                            '$profit',
                            '$round_package_price',
                            '$round_unit_price',
                            '$round_pieces_price',
                            '$package_price',
                            '$unit_price',
                            '$pieces_price',
                            '$package_remain',
                            '$unit_remain',
                            '$pieces_remain',
                            '0',
                            '0',
                            '0',
                            '0',
                            '0',
                            '0',
                            '0',
                            '0',
                            '0',
                            '0',
                            '0',
                            '0',
                            '0',
                            '0',
                            '0',
                            '$expire_date',
                            '0',
                            '0'
                        )";

                if ($connection->query($sql_cargo) === TRUE) {
                    echo "Record inserted successfully into $product<br>";
                    
                } else {
                    echo "Error inserting record into $product: " . $connection->error . "<br>";
                }
                header('location:product_add_new.php');
            

                
            // if (mysqli_query($connection, $sql_cargo)) {
            //     header('location:product_add_new.php');
            // } else {
            //     // echo "Error: " . $sql . " " . mysqli_error($connection);
            //     echo "<script>alert('Something Wrong!')</script>";
            //     header('location:product_add_new.php');
            // }
        }
    }
}

       
    }

}



if (isset($_POST['change_image'])) {
    $barcode = $_POST['barcode'];

    if (isset($_FILES["image"]) && $_FILES["image"]["error"] == 0) {
        // File upload successful
        $image = $_FILES["image"]["tmp_name"];
        
        // Create an image resource from the uploaded file
        $imgResource = imagecreatefromstring(file_get_contents($image));
    
        if ($imgResource !== false) {
            // Set initial quality (this can be adjusted)
            $quality = 75;
    
            // Output buffer to hold the compressed image data
            ob_start();
            imagejpeg($imgResource, null, $quality);
            $imgContent = ob_get_contents();
            ob_end_clean();
    
            // Keep reducing quality until the file size is below 15 KiB
            while (strlen($imgContent) > 15 * 1024 && $quality > 10) {
                $quality -= 5;
                ob_start();
                imagejpeg($imgResource, null, $quality);
                $imgContent = ob_get_contents();
                ob_end_clean();
            }
    
            // Free up memory
            imagedestroy($imgResource);
    
            // Escape the content to store in the database
            $imgContent = addslashes($imgContent);
    
            // Continue with processing $imgContent, such as saving it to the database
            // ...
    
        } else {
            // Handle the error - file could not be processed as an image
            echo "Failed to process image.";
        }
    } else {
        // Handle the error - file not uploaded
        header('Location: product_add_new.php');
    }

    $sql = "UPDATE ".$product." SET image='$imgContent' WHERE barcode='$barcode'";
            //$sql = "UPDATE product SET barcode='$barcode' WHERE id='$no'";
    if ($connection->query($sql) === TRUE) {
        // echo json_encode(['status' => 'success', 'message' => 'Record updated successfully']);
    } else {
        // echo json_encode(['status' => 'error', 'message' => 'Error updating record: ' . $connection->error]);
    }



}


if (isset($_POST['update'])) {
    $barcode = $_POST['barcode'];
    $barcode_1 = $_POST['barcode_1'];
    $product_name = $_POST['product_name'];

    if($barcode == '' && $product_name== ''){ 
        // echo "<script>alert('Need Barcode')</script>";
    }else{ 

        $sql = "SELECT * FROM ".$product." 
        WHERE (barcode='$barcode' OR barcode_1='$barcode_1' OR barcode='$barcode_1' OR barcode_1='$barcode') 
        AND delete_d='0'
        AND product_name != '".$product_name."'";
        $result = $connection->query($sql);
        if ($result && $result->num_rows > 0) {
            echo '<script>alert("Product code already Exist") ;</script>';
        } else { 
        
            $product_tables = [$product,$cargo_1];
            foreach ($product_tables as $product_data) {
            //update barcode,name.....
            $sql = "UPDATE ".$product_data." SET barcode='$barcode',barcode_1='$barcode_1' WHERE product_name='$product_name'";
            //$sql = "UPDATE product SET barcode='$barcode' WHERE id='$no'";
            if ($connection->query($sql) === TRUE) {
                // echo json_encode(['status' => 'success', 'message' => 'Record updated successfully']);
            } else {
                // echo json_encode(['status' => 'error', 'message' => 'Error updating record: ' . $connection->error]);
            }
        }
    }
       
    }

}

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'];
    $profit = $_POST['profit'];

    // 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 profit='$profit',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();
        $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 = $profit + $buy + $trans;
                break;
            case 'baht':
                $package_price = $profit+ ($buy * $baht) + $trans;
                break;
            case 'yuan':
                $package_price = $profit + ($buy * $yuan) + $trans;
                break;
            case 'dollar':
                $package_price = $profit + ($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_add_new.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_add_new.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" tyle="font-size: 15px;" class="form-control"  name="profit" value="'.$row["profit"].'"></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 {
  
}


?>

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

                    <div class="col-sm-4" style="background-color:#19242e;border-radius:20px;color:orange;margin-bottom:20px">
                    

                    <form id="myForm" action="product_add_new.php" method="POST" style="margin-top:20px;margin-left:20px" enctype="multipart/form-data">
                    
                    <table style="border:none;">

                   

                    <tr style="height: 50px;">
                            <th> <label for="pwd" alt="hi" style="font-size:20px"> Barcode_1:</label></th>
                            <th>
                            <div style="display:flex;">
                                <input type="text" class="form-control" name="barcode" id="barcodeInput" placeholder=""  style="width:80%" autofocus>
                                <button type="button" id="start-scan-btn" class="btn btn-outline-warning" style="margin-left:10px">Scan</button>
                            </div>
                            </th>
                            <!-- <th><button type="button" name="print" id="print" class="btn btn-outline-warning">Print</button></th> -->
                        </tr>
                        
                        <script>
                            document.addEventListener('DOMContentLoaded', () => {
                            const video = document.getElementById('barcode-scanner');
                            const barcodeInput = document.getElementById('barcodeInput');
                            const startScanButton = document.getElementById('start-scan-btn');
                            let stream = null; // To store the camera stream

                            startScanButton.addEventListener('click', async () => {
                                try {
                                stream = await navigator.mediaDevices.getUserMedia({ video: { facingMode: 'environment' } });
                                video.srcObject = stream;

                                video.addEventListener('loadedmetadata', () => {
                                    video.play();
                                    detectBarcode();
                                });
                                } catch (error) {
                                console.error('Error accessing camera:', error);
                                }
                            });

                            async function detectBarcode() {
                                const barcodeDetector = new BarcodeDetector();
                                
                                try {
                                const barcodes = await barcodeDetector.detect(video);
                                if (barcodes.length > 0) {
                                    const detectedBarcode = barcodes[0].rawValue;
                                    barcodeInput.value = detectedBarcode;
                                    // Close the camera stream
                                    closeCamera();
                                } else {
                                    setTimeout(detectBarcode, 200); // Check again after 200ms
                                }
                                } catch (error) {
                                console.error('Barcode detection error:', error);
                                }
                            }

                            function closeCamera() {
                                if (stream) {
                                const tracks = stream.getTracks();
                                tracks.forEach(track => track.stop());
                                video.srcObject = null;
                                }
                            }
                            });
                        </script>

<tr style="height: 50px;">
    <th> <label for="pwd" alt="hi" style="font-size:20px"> Barcode_2:</label></th>
    <th>
        <div style="display:flex;">
            <input type="text" class="form-control" name="barcode_1" id="barcodeInput_1" placeholder="" style="width:80%" autofocus>
            <button type="button" id="start-scan-btn_1" class="btn btn-outline-warning" style="margin-left:10px">Scan</button>
        </div>
    </th>
    <!-- <th><button type="button" name="print" id="print" class="btn btn-outline-warning">Print</button></th> -->
</tr>

<script>
    document.addEventListener('DOMContentLoaded', () => {
        const video_1 = document.getElementById('barcode-scanner_1');
        const barcodeInput_1 = document.getElementById('barcodeInput_1');
        const startScanButton_1 = document.getElementById('start-scan-btn_1');
        let stream = null; // To store the camera stream

        startScanButton_1.addEventListener('click', async () => {
            try {
                stream = await navigator.mediaDevices.getUserMedia({ video: { facingMode: 'environment' } });
                video_1.srcObject = stream;

                video_1.addEventListener('loadedmetadata', () => {
                    video_1.play();
                    detectBarcode();
                });
            } catch (error) {
                console.error('Error accessing camera:', error);
            }
        });

        async function detectBarcode() {
            const barcodeDetector = new BarcodeDetector();

            try {
                const barcodes = await barcodeDetector.detect(video_1);
                if (barcodes.length > 0) {
                    const detectedBarcode = barcodes[0].rawValue;
                    barcodeInput_1.value = detectedBarcode;
                    // Close the camera stream
                    closeCamera();
                } else {
                    setTimeout(detectBarcode, 200); // Check again after 200ms
                }
            } catch (error) {
                console.error('Barcode detection error:', error);
            }
        }

        function closeCamera() {
            if (stream) {
                const tracks = stream.getTracks();
                tracks.forEach(track => track.stop());
                video_1.srcObject = null;
            }
        }
    });
</script>

 
                        <tr style="height: 50px;">
                            <th> <label for="pwd" alt="hi"> ပစ္စည်းအမည်:</label></th>
                            <th><input type="text" class="form-control"  name="product_name" placeholder="" ></th>
                        </tr>

                        <tr style="height: 50px;">
                            <th> <label for="pwd">အမျိုးအစား:</label></th>
                            <th>
                                <select name="product_type" id="bankingInput" class="form-control">
                                    <?php
                                    $sql = "SELECT * FROM ".$catagories."";
                                    $result = $connection->query($sql);
                                    if ($result && $result->num_rows > 0) {
                                        while ($row = $result->fetch_assoc()){
                                            $name = $row['type']; // Database
                                            echo '
                                            <option value="' . $name . '">' . $name . '</option>
                                            ';
                                        }
                                    }
                                    ?>
                                </select>
                            </th>
                        </tr>

                        <tr style="height: 50px;">
                            <th> <label for="pwd" alt="hi"> ကဒ်ပမာဏ</label></th>
                            <th><input type="text" class="form-control"  name="unit" placeholder=""  value="0"></th>
                        </tr>

                        <tr style="height: 50px;">
                            <th> <label for="pwd" alt="hi"> ဗူးပမာဏ:</label></th>
                            <th><input type="text" class="form-control"  name="pieces" placeholder=""  value="0"></th>
                        </tr>

                        

                        <tr style="height: 50px;">
                            <th> <label for="pwd" alt="hi"> သယ်ဆောင်ခ:</label></th>
                            <th>    <input type="text" class="form-control" id="formatted" name="trans" placeholder="" value="0"></th>
                        </tr>

                        <!-- <tr style="height: 50px;">
                            <th> <label for="pwd" alt="hi"> ဖာဝယ်ဈေး:</label></th>
                            <th>    <input type="text" class="form-control" id="formatted" name="buy" placeholder="" value="1"></th>
                        </tr> -->
                        
                        <tr style="height: 50px;">
                            <th> <label for="pwd" alt="hi"> ဖာဝယ်ဈေး:</label></th>
                            <div >
                            <th style="display:flex;">
                            <input type="text" class="form-control"  name="buy" placeholder="" value="1">
                                <select name="currency_buy" id="bankingInput" class="form-control ms-3">        
                                    <option value="kyat">ကျပ်</option>
                                    <option value="baht">ဘတ်</option>
                                    <option value="yuan">ယွမ်</option>
                                </select>
                            </th>
                            </div>
                        </tr>

                        <tr style="height: 50px;">
                            <th> <label for="pwd" alt="hi"> အမြတ်:</label></th>
                            <th><input type="text" class="form-control" id="package_price" name="profit" placeholder=""  value="0"></th>
                        </tr>

                        

                        <tr style="height: 50px;">
                            <th> <label for="pwd" alt="hi"> ဓာတ်ပုံ:</label></th>
                            <th><input type="file" class="form-control" name="image" id="image"></th>
                        </tr>


                        </tr>

                    </table>


                    <!-- <div style="margin-top: 20px; display: flex; justify-content: center;" class="container-fluid">
                        <button type="submit" name="add" class="btn btn-outline-warning" style="margin: 10px;">ပေါင်းထည့်</button>
                        <button type="submit" name="change_currency" class="btn btn-outline-danger" style="margin: 10px;">ငွေဈေးပြောင်း</button>
                        <button type="submit" name="change_image" class="btn btn-outline-success" style="margin: 10px;" data-toggle="modal" data-target="#infoModal">ပုံပြောင်းရန်</button>
                    </div> -->
                    <table class="table table-borderless" >

                    <tr>
                        <th style="background-color:#19242e"> <button type="submit" name="add" class="btn btn-outline-warning" style="margin: 5px;width:100%" data-toggle="modal" data-target="#infoModal">ပေါင်းထည့်</button></th>
                        <th  style="background-color:#19242e"> <button type="submit" name="change_image" class="btn btn-outline-warning" style="margin: 5px;width:100%" data-toggle="modal" data-target="#infoModal">ပုံပြောင်း</button></th>
                    </tr>

                    <tr>
                        <th colspan="2" style="background-color:#19242e"> <button type="submit" name="update" class="btn btn-outline-warning" style="margin: 5px;width:100%" data-toggle="modal" data-target="#infoModal" >Update Barcode</button></th>
                    </tr>

                    <tr>
                    <th colspan="2" style="background-color:#19242e"> <button type="submit" name="change_image" class="btn btn-outline-warning" style="margin: 5px;width:100%" data-toggle="modal" data-target="#infoModal" id="generateBarcodeBtn">Generate barcode</button></th>
                    </tr>

                    <tr>
                        <th  colspan="2" style="background-color:#19242e"> <button type="submit" name="refresh" class="btn btn-outline-success" style="margin: 5px;width:100%" data-toggle="modal" data-target="#infoModal" onclick="refreshPage()">Refresh</button></th>
                    </tr>

                   
                    </table>


                    </form>

                    <script>
    document.getElementById("generateBarcodeBtn").addEventListener("click", function(event) {
        // Prevent the form from submitting
        event.preventDefault();

        // Generate the current date and time in the specified format
        const now = new Date();
        const day = String(now.getDate()).padStart(2, '0');
        const month = String(now.getMonth() + 1).padStart(2, '0'); // Months are zero-indexed
        const year = now.getFullYear();
        const hours = String(now.getHours()).padStart(2, '0');
        const minutes = String(now.getMinutes()).padStart(2, '0');
        const seconds = String(now.getSeconds()).padStart(2, '0');

        // Format barcode as day-month-year-hours-minutes-seconds
        const barcode = `${day}${month}${year}${hours}${minutes}${seconds}`;
        const barcode_1 = `${day}${month}${year}${hours}${minutes}${seconds}${seconds}`;

        // Insert the barcode into the input field
        document.getElementById("barcodeInput").value = barcode;
        document.getElementById("barcodeInput_1").value = barcode_1;
    });
</script>

                    <script>
  document.getElementById('myForm').addEventListener('keydown', function(event) {
    if (event.key === 'Enter') {
      event.preventDefault(); // Prevent the default action (form submission)
    }
  });
</script>

                    </div>
                
                <!-- Table Element -->
                <div class="col-sm-8">

                <div class="card-header gx-5">
                    <form class="d-flex flex-row-reverse ">
                    <div class="col-auto" style="margin-left:10px">
                        <input type="text" class="form-control" id="searchInput" placeholder="Search">
                    </div>
                    <div class="col-auto">
                        <button type="submit" class="btn btn-primary mb-3"><i class="fa-solid fa-magnifying-glass"></i></button>
                    </div>
                    </form> 
                    </div>

                    <div class="scrollable-table" style="height:60vh;">
                        <table class="table table-bordered table-hover" style="color:white;font-size:18px;"  id="dataTable">
                        <thead style="background-color:#19242e" class="text-center align-middle">
                        <tr>
                            <th rowspan="2" scope="col">no</th>
                            <th rowspan="2" scope="col">update</th>
                            <th rowspan="2" scope="col">barcode</th>
                            <!-- <th rowspan="2" scope="col" style="display:none;">barcode_2</th> -->
                            <th rowspan="2" scope="col">barcode_2</th>
                            <th rowspan="2" scope="col">ပစ္စည်းအမည်</th>
                            <th rowspan="2" scope="col">အမျိုးအစား</th>
                            <th rowspan="2" scope="col">သယ်ဆောင်ခ</th>
                            <th rowspan="2" scope="col">PF</th>
                            
                            <th rowspan="2" scope="col" style="color:#ACE1AF">မူရင်းကဒ်</th>
                            <th rowspan="2" scope="col" style="color:#ACE1AF">မူရင်းဗူး</th>
                            <th rowspan="2" scope="col" style="color:#FFA62F">ဖာလိုက်ဝယ်ဈေး</th>

                            <!-- <th rowspan="2" scope="col" style="color:#ACE1AF">ငွေဈေး</th> -->
                            <th rowspan="2" scope="col" style="color:#ACE1AF">ငွေအမျိုးစား</th>
                            <th colspan="3" scope="col" style="color:#FFA62F">ရောင်းဈေး</th>
                            <th rowspan="2" scope="col" style="color:#ACE1AF">Delete</th>
                        </tr>
                        <tr>
                            <th scope="col" style="color:#FFA62F">ဖာ</th>
                            <th scope="col" style="color:#FFA62F">ကဒ်</th>
                            <th scope="col" style="color:#FFA62F">ဗူး</th>
                        </tr>
                        </thead>
                            <tbody>
                                <?php 
                                $sql = "Select * from ".$product." where delete_d='0' order by id desc limit 50";
                                $result = mysqli_query($connection, $sql);
                                if ($result) {
                                    while ($row = mysqli_fetch_assoc($result)) {
                                        echo '<tr>
                                        <td contenteditable="true" class="fixed-column">' . htmlspecialchars($row['id']) . '</td>       
                                        <td><button type="button" class="btn btn-success" data-action="info" name="info" data-toggle="modal" data-target="#infoModal">update</button></td>     
                                        <td contenteditable="true" class="fixed-column-2">' . htmlspecialchars($row['barcode']) . '</td>
                                        <td contenteditable="true" class="fixed-column-2">' . htmlspecialchars($row['barcode_1']) . '</td>
                                        <th scope="row" contenteditable="true" class="fixed-column-3">' . htmlspecialchars($row['product_name']) . '</th>

                                        <td contenteditable="true" class="fixed-column-3">' . htmlspecialchars($row['type']) . '</td>  
                                                                              
                                        <td contenteditable="true">' . htmlspecialchars($row['trans']) . '</td>      
                                        <td contenteditable="true">' . htmlspecialchars($row['profit']) . '</td>   
                                        <td contenteditable="true">' . htmlspecialchars($row['unit']) . '</td>
                                        <td contenteditable="true">' . htmlspecialchars($row['pieces']) . '</td>      
                                        <td contenteditable="true">' . number_format($row['buy']) . '</td>';

                                        // echo '<td contenteditable="true">' . htmlspecialchars($row['rate']) . '</td>';

                                        echo '<td contenteditable="true">
                                            <select id="cars" contenteditable="true">
                                                <option value="' . $row['currency_buy'] . '">' . $row['currency_buy'] . '</option>
                                                <option value="kyat">kyat</option>
                                                <option value="baht">baht</option>
                                                <option value="yuan">yuan</option>
                                            </select></td>'; 

                                        

                                        echo '
                                        <td contenteditable="true">' . number_format($row['round_package_price']) . '</td>
                                        <td contenteditable="true">' . number_format($row['round_unit_price']) . '</td>
                                        <td contenteditable="true">' . number_format($row['round_pieces_price']) . '</td>                                                                                           
                                        <td><button type="submit" class="btn btn-danger" data-action="delete">Delete</button></td>                            
                                        </tr>';
                                    }
                                }
                                    mysqli_free_result($result);
                                
                                ?>
                            </tbody>
                        </table>

                        <form id="actionForm" method="POST" action="product_add_new.php" style="display:none;">
                                <input type="hidden" name="id" id="formId">
                                <input type="hidden" name="action" id="formAction">
                            </form>

                            <script>
document.addEventListener('DOMContentLoaded', function() {
    document.getElementById('dataTable').addEventListener('click', function(event) {
        if (event.target.tagName === 'BUTTON') {
            const action = event.target.getAttribute('data-action');
            const row = event.target.closest('tr');
            const id = row.cells[0].innerText;

            // Create a FormData object and append the necessary data
            const formData = new FormData();
            formData.append('id', id);
            formData.append('action', action);

            // Send the form data using Fetch API
            fetch('product_add_new.php', {
                method: 'POST',
                body: formData
            })
            .then(response => response.text())
            .then(data => {
                if (action === 'delete') {
                    // Refresh the page if the delete action is performed
                    location.reload();
                } else {
                    // Insert the returned HTML into a container element
                    const modalContainer = document.createElement('div');
                    modalContainer.innerHTML = data;
                    document.body.appendChild(modalContainer);

                    // Display the modal
                    const modal = new bootstrap.Modal(modalContainer.querySelector('.modal'));
                    modal.show();

                    // Add event listener to refresh the page when the modal is hidden
                    modalContainer.querySelector('.modal').addEventListener('hidden.bs.modal', function () {
                        location.reload();
                    });
                }
            })
            .catch(error => {
                console.error('Error:', error);
            });
        }
    });
});




                        </script>

<script>
    $(document).ready(function() {
        $('#infoModal').on('hidden.bs.modal', function () {
            location.reload();
        });
    });
</script>

                        <!-- Search for js code -->
                        <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>

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


                       

        <!-- ရောင်းဈေးကို check ပြန်လုပ်ရန် -->
        <!-- Edit Data by click -->
        <?php 
        if ($_SERVER["REQUEST_METHOD"] == "POST") {
            $data = json_decode(file_get_contents('php://input'), true);
            
            // Assuming 'no' is the primary key for your product table
            if (isset($data['no'])) {
                $no = $connection->real_escape_string($data['no']);
                $barcode = $connection->real_escape_string($data['barcode']);

                $type = $connection->real_escape_string($data['အမျိုးအစား']);
                $unit = $connection->real_escape_string($data['မူရင်းကဒ်']);
                $pieces = $connection->real_escape_string($data['မူရင်းဗူး']);
                $buy_data = $connection->real_escape_string($data['ဖာလိုက်ဝယ်ဈေး']);
                $profit = $connection->real_escape_string($data['PF']);
                $trans = $connection->real_escape_string($data['သယ်ဆောင်ခ']);
                $currency_buy = $connection->real_escape_string($data['ငွေအမျိုးစား']);

                // Remove commas
                $buy_data_1 = str_replace(",", "", $buy_data);

                // Convert to integer or float
                $buy = intval($buy_data_1);

                $product_tables = [$product,$cargo_1];

                foreach ($product_tables as $product_data) {
            
                //update barcode,name.....
                $sql = "UPDATE ".$product_data." SET profit='$profit',type='$type',unit='$unit',pieces='$pieces',buy='$buy',trans='$trans',currency_buy='$currency_buy' WHERE barcode='$barcode'";
                //$sql = "UPDATE product SET barcode='$barcode' WHERE id='$no'";
                if ($connection->query($sql) === TRUE) {
                    // echo json_encode(['status' => 'success', 'message' => 'Record updated successfully']);
                } else {
                    // echo json_encode(['status' => 'error', 'message' => 'Error updating record: ' . $connection->error]);
                }
            }
                
                // include "../cal_pro_remain.php";
    
                function roundUpToNearestHundred($number) {
                    return ceil($number / 100) * 100;
                    }
        
                    // Fetch product details
                // 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) {
    $product_row = $product_result->fetch_assoc();
    $unit = $product_row['unit'];
    $pieces = $product_row['pieces'];
    $buy = $product_row['buy'];
    $trans = $product_row['trans'];

    // Fetch rate details (assumed to be a single record)
    $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();
        $baht = $rate_row['baht'];
        $yuan = $rate_row['yuan'];
        $dollar = $rate_row['dollar'];

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

        // Calculate unit and pieces price
        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);

        // Update product tables
        $product_tables = [$product, $cargo_1];
        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()) {
                echo json_encode(['status' => 'success', 'message' => 'Record updated successfully']);
                echo "<script>location.reload();</script>";
            } else {
                echo json_encode(['status' => 'error', 'message' => 'Error updating record: ' . $connection->error]);
            }
        }
    }
}


            } else {
                // echo json_encode(['status' => 'error', 'message' => 'Invalid data format.']);
            }
            
            }
        ?>
        <script>
            //get colspan data
            function getFlattenedHeaders(headerRow) {
const headers = [];
let colIndex = 0;

for (let i = 0; i < headerRow.cells.length; i++) {
    const cell = headerRow.cells[i];
    const colspan = cell.colSpan || 1;
    const headerText = cell.textContent.trim();

    for (let j = 0; j < colspan; j++) {
        headers[colIndex] = headerText;
        colIndex++;
    }
}

console.log('Flattened Headers:', headers);
return headers;
}

function saveChangesForRow(row) {
const data = {};
console.log('Row being processed:', row);

const headerRow = document.getElementById('dataTable').rows[0];
const headers = getFlattenedHeaders(headerRow);

for (let j = 0; j < row.cells.length; j++) {
    const cell = row.cells[j];

    if (j >= headers.length) {
        console.warn(`Skipping cell ${j} as it exceeds header length`);
        continue; // Skip if there are more cells in the row than in the headers
    }

    const headerText = headers[j];
    console.log(`Processing cell ${j}: Header=${headerText}, Cell=`, cell);

    if (cell && cell.hasAttribute('contenteditable')) {
        data[headerText] = cell.textContent.trim();
    }

    // Handle select dropdowns separately
    if (cell.querySelector('select')) {
        data[headerText] = cell.querySelector('select').value;
    }
}

console.log('Data to be sent:', data);

const xhr = new XMLHttpRequest();
xhr.open('POST', 'product_add_new.php', true);
xhr.setRequestHeader('Content-Type', 'application/json');
xhr.onreadystatechange = function() {
    if (xhr.readyState === XMLHttpRequest.DONE) {
        if (xhr.status === 200) {
            console.log('Data updated successfully!');
        } else {
            // alert('Error updating data. Please try again!');
        }
    }
};
xhr.send(JSON.stringify(data));
}

const editableCells = document.querySelectorAll('#dataTable td[contenteditable="true"]');
editableCells.forEach(cell => {
cell.addEventListener('input', function() {
    saveChangesForRow(this.parentElement);  // this.parentElement refers to the row
});
});

const dropdowns = document.querySelectorAll('#dataTable select');
dropdowns.forEach(dropdown => {
dropdown.addEventListener('change', function() {
    saveChangesForRow(this.closest('tr'));  // 'closest' gets the nearest parent row element
});
});

</script>



                    </div>
                </div>


            </div>
            </div>
            <video id="barcode-scanner" autoplay playsinline></video>

            <video id="barcode-scanner_1" autoplay playsinline></video>
        </main>


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


<!-- <script src="lat_li.js"></script> -->
<!-- get data auto from input barcode/banking -->
<!-- <script>
    document.addEventListener('DOMContentLoaded', (event) => {
const barcodeInput = document.getElementById('barcodeInput');
const bankingInput = document.getElementById('bankingInput');
const outputDiv = document.getElementById('output');

// Simulate a barcode scanner by listening for input events
barcodeInput.addEventListener('input', handleBarcodeInput);

let barcode = '';
let timeout;

function handleBarcodeInput(event) {
    clearTimeout(timeout);
    
    // Check for input data and append to barcode
    barcode += event.data || event.target.value; 
    
    // Clear the input field
    event.target.value = '';

    // Wait for a short period to determine if input is complete
    timeout = setTimeout(() => {
        processBarcode(barcode);
        barcode = ''; // Reset barcode
    }, 100); // Adjust timeout as needed
}

async function processBarcode(barcode) {
    // Get banking input value
    const bankingData = bankingInput.value;

    // Display the processed barcode and banking data on the page
    outputDiv.innerHTML = `Processed Barcode: ${barcode} <br> Banking Data: ${bankingData}`;
    console.log(`Processed Barcode: ${barcode}`);
    console.log(`Banking Data: ${bankingData}`);

    // Send the barcode and banking data to the server
    try {
        const response = await fetch('lat_li.php', {
            method: 'POST',
            headers: {
                'Content-Type': 'application/json'
            },
            body: JSON.stringify({ 
                barcode: barcode,
                bankingData: bankingData
            })
        });

        if (!response.ok) {
            throw new Error('Network response was not ok');
        }

        const responseData = await response.json();
        console.log('Server response:', responseData);
    } catch (error) {
        console.error('Error sending data:', error);
    }
}
});
</script>
<div id="output"></div>


<?php
// header('Content-Type: application/json');
// $input = file_get_contents('php://input');
// $data = json_decode($input, true);

// if ($data && isset($data['barcode']) && isset($data['bankingData'])) {
//     // Process the barcode and banking data here
//     $barcode = $data['barcode'];
//     $bankingData = $data['bankingData'];

//     include 'database/database.php';

//     // Log received data for debugging purposes
//     error_log("Received barcode: " . $barcode);
//     error_log("Received bankingData: " . $bankingData);

//     $query = "UPDATE imv_account SET account='$barcode', amount='$bankingData' WHERE id='1'";
//     if ($connection->query($query)) {
//         // Example response
//         echo json_encode([
//             'status' => 'success', 
//             'receivedBarcode' => $barcode,
//             'receivedBankingData' => $bankingData
//         ]);
//     } else {
//         die("ERROR: Query failed. " . $connection->error);
//     }
// } else {
//     echo json_encode(['status' => 'error', 'message' => 'Invalid data']);
// }


?> -->


<?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>
