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

<?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_catagories.php";


if (isset($_POST['add'])) {
 
    $cata = $_POST['cata'];

    if ($cata == ''){ }
    else{ 

        $check_sql = "SELECT * FROM " . $catagories . " WHERE type = '$cata'";                        
        $check_result = $connection->query($check_sql);

        if ($check_result && $check_result->num_rows > 0) {
            echo '<script>alert("Catagories Already Exists");</script>';
        } else { 

        $sql = "INSERT INTO ".$catagories." (type, total, sell, remain,delete_d,active)
        VALUES ('$cata','0','0','0','0','0')";

        if (mysqli_query($connection, $sql)) {
            header('location:product_catagories.php');

        } else {
            echo "Error: " . $sql . "
            " . mysqli_error($connection);
                }
            }

    }

      
  }

    // delete Data
  if ($_SERVER["REQUEST_METHOD"] === "POST" && isset($_POST["id"])) {
    $id = $connection->real_escape_string($_POST["id"]);
    echo "Received id: " . $id;


    $sql = "DELETE FROM ".$catagories." where id='".$id."'";
    if ($connection->query($sql) === true) {
        http_response_code(200);
    } else {
        http_response_code(500);
    }
  }
  // }
  
?>


<body>
    <div class="wrapper">
        <?php 
        include "sidebar.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="mb-3" style="position: relative;">
                
                    
                </div>


                    <div class="row">

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

                        <form action="product_catagories.php" method="POST" style="margin-top:20px;margin-left:20px">
                        <table style="border:none;">
                            <tr style="height: 50px;">
                                <th> <label for="pwd" alt="hi"> ပစ္စည်းအမျိုးစား:</label></th>
                                <th><input type="text" class="form-control"  name="cata" id="barcodeInput" placeholder="နမူနာ: ဆေးဝါး-အဝတ်-အလှကုန်" autofocus></th>
                            </tr>

                            <!-- <tr style="height: 50px;">
                                <th> <label for="pwd">Banking:</label></th>
                                <th>
                                    <select name="banking" id="bankingInput" class="form-control">
                                    <option value="kpay">kpay</option>
                                        <?php
                                        // $sql = "SELECT * FROM ".$banking."";
                                        // $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> -->

                        </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="button" class="btn btn-outline-danger" style="margin: 10px;">Save</button>
                            <button type="button" class="btn btn-outline-info" style="margin: 10px;">Baht</button>
                            <button type="button" class="btn btn-outline-info" style="margin: 10px;">Yuan</button> -->
                        </div>

                        </form>

                        </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 table-striped" style="color:white;font-size:18px;"  id="dataTable">
                                <thead style="background-color:#19242e">
                                    <tr>
                                        <th scope="col" style="white-space: nowrap;">အမှတ်စဉ်</th>
                                        <th scope="col" style="white-space: nowrap;">ပစ္စည်းအမျိုးစား</th>
                                        <th scope="col" style="white-space: nowrap;">စုပေါင်းပမာဏ</th>
                                        <th scope="col">Action</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <?php 
                                    $sql = "Select * from ".$catagories." where delete_d='0'";
                                    $result = mysqli_query($connection, $sql);
                                    if ($result) {
                                        while ($row = mysqli_fetch_assoc($result)) {
                                            echo '<tr>
                                                    <td>' . $row['id'] . '</td>
                                                    <td style="white-space: nowrap;">' . $row['type'] . '</td>
                                                    <td>' . number_format($row['total']) . '</td>
                                                    <td><button type="submit" class="btn btn-success" onclick="deleteRow(this)">Delete</button></td>                            
                                                    </tr>';
                                        }
                                        mysqli_free_result($result);
                                    }
                                    // <td><button onclick="deleteRow(this)">Delete</button></td>
                                    ?>
    
                                </tbody>
                            </table>

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

                            <!-- Delete Data -->
                            <script>
                            function deleteRow(button) {
                            const row = button.parentNode.parentNode;
                            const id = row.cells[0].textContent; // Assuming the Product ID is in the first column (index 0)
                            console.log(id)
                            // Send the tra_id to the backend PHP script using AJAX for deletion
                            const xhr = new XMLHttpRequest();
                            xhr.open('POST', 'product_catagories.php', true);
                            xhr.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');
                            xhr.onreadystatechange = function() {
                                if (xhr.readyState === XMLHttpRequest.DONE) {
                                if (xhr.status === 200) {
                                    row.parentNode.removeChild(row); // Remove the row from the table on successful deletion
                                    alert('Data deleted successfully!');
                                    location.reload();

                                } else {
                                    alert('Error deleting data. Please try again.');
                                }
                                }
                            };
                            xhr.send('id=' + encodeURIComponent(id));
                            }
                        </script>
                        </div>
                    </div>


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


    <!-- <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>
</body>

</html>
