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


if (isset($_POST['accept'])) {
 

    $voucher = $_POST['voucher'];
    $date = $_POST['date'];

    $tra_id_data = new DateTime(); 
    $rn = rand(0, 1000);
    $tra_id = $tra_id_data->format('YmdHis').''.$rn; 

    if ($voucher ==''){ 
        echo "<script>
                alert('Voucher နံပါတ် မထည့်ရသေးပါ');
                window.location.href = 'product_accept.php';
            </script>";

    }else{ 

        $query = "UPDATE ".$cargo_1."_trans set accept='လက်ခံ',receive_date='$date' WHERE voucher='$voucher'";
        if (!$connection->query($query)) {
            header('Location: product_accept.php');
        }
        


        }
}

if (isset($_POST['check'])) {
    $b_id = $browserId;
    $sql = "SELECT * FROM ".$cargo." WHERE browser_id='$b_id'";
    $result = $connection->query($sql);
    if ($result->num_rows > 0) {
        $row = $result->fetch_assoc(); // Fetch the row here
        $cargo_data = $row["cargo"];

        $sql = "DELETE FROM ".$cargo_data."_trans_data";
        if ($connection->query($sql) === true) {
        
        } else {

        }}
}
    



    // delete Data
    if ($_SERVER["REQUEST_METHOD"] === "POST" && isset($_POST["id"])) {
        $id = $connection->real_escape_string($_POST["id"]);
        echo "Received id: " . $id;
    
        $sql = "SELECT * FROM ".$cargo." WHERE browser_id='$b_id'";
        $result = $connection->query($sql);
        if ($result->num_rows > 0) {
            $row = $result->fetch_assoc(); // Fetch the row here
            $cargo_data = $row["cargo"];

            $query = "DELETE FROM ".$cargo_data."_trans WHERE id = '$id'";
            if ($connection->query($query)) {
                echo 'Deleted successfully.';
            } else {
                echo 'alert("Update failed!");';
            }

            $query = "DELETE FROM ".$cargo_data."_trans_data WHERE id = '$id'";
            if ($connection->query($query)) {
                echo 'Deleted successfully.';
            } else {
                echo 'alert("Update failed!");';
            }


        }

        
      }
  // }
  
?>


<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_accept.php" method="POST" style="margin-top:20px;margin-left:20px">
                        <table style="border:none;">


                        <tr style="height: 50px;">
                            <th> <label for="pwd" alt="hi"> Voucher:</label></th>
                            <th>
                            <div style="display:flex;">
                                <input type="text" class="form-control" name="voucher" id="voucher" placeholder="" value="1" style="width:80%">
                                <button type="button" name="auto_voucher" id="auto_voucher" class="btn btn-outline-warning" style="margin-left:10px">Auto</button>
                            </div>
                            </th>
                            <!-- <th><button type="button" name="print" id="print" class="btn btn-outline-warning">Print</button></th> -->
                        </tr>

                        <?php 
                        $sql = "SELECT * FROM ".$cargo." WHERE browser_id='$b_id'";
                        $result = $connection->query($sql);
                        if ($result->num_rows > 0) {
                            $row = $result->fetch_assoc(); // Fetch the row here
                            $cargo_data = $row["cargo"];

                            // SQL query to fetch the latest record
                            $sql = "SELECT * FROM ".$cargo_data."_trans ORDER BY id DESC LIMIT 1";
                            $result = $connection->query($sql);
                        
                            if ($result && $result->num_rows > 0) {
                                $row = $result->fetch_assoc();
                                    $voucherValue = (int)$row['voucher'] + 1;
                            }
                        }
                        ?>

                        <script>
                            document.getElementById('auto_voucher').addEventListener('click', function() {
                                var voucherValue = <?php echo $voucherValue; ?>;
                                document.getElementById('voucher').value = voucherValue;
                            });
                        </script>


                        <?php
                        $today = date("Y-m-d");

                        echo '<tr style="height: 50px;">
                            <th> <label for="pwd" alt="hi"> ရက်စွဲ:</label></th>
                            <th><input type="text" class="form-control"  name="date" value='.$today.'></th>
                        </tr>';
                    
                        ?>

                          

                            </tr>

                        </table>

               
                        <div style="margin-top: 20px;justify-content: center;" class="container-fluid">
                        <table class="table table-borderless">

                            <tr>
                                <td scope="col" colspan="3"> <button type="submit" name="accept" class="btn btn-outline-warning" style="margin: 10px;width:90%" data-toggle="modal" data-target="#infoModal">ပစ္စည်းလက်ခံ</button></td>
                            </tr>

                            <tr>
                                <td scope="col" colspan="3"> <button type="submit" name="refresh" class="btn btn-outline-success" style="margin: 10px;width:90%" data-toggle="modal" data-target="#infoModal" onclick="refreshPage()">Refresh</button></td>
                            </tr>
                        </table>

                        <script>

                        const button_print = document.getElementById('print');
                        button_print.addEventListener('click', function() {
                        window.location.href = 'product_print.php';
                        });

                        </script>



                        </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" style="color:white;font-size:18px;"  id="dataTable">
                            <thead style="background-color:#19242e">
                            <tr>
                            <th scope="col">id</th>
                            <th scope="col">voucher</th>
                            <th scope="col">barcode</th>
                            <th scope="col">ပစ္စည်းအမည်</th>
                            <th scope="col">ပို့သည့်ဂိုဒေါင်</th>
                            <th scope="col">ပမာဏ</th>
                            <th scope="col">အမျိုးအစား</th>
                            <th scope="col">ပစ္စည်းလက်ခံရက်စွဲ</th>
                            </tr>
                            </thead>
                                <tbody>
                                    <?php 
                                    
                                        $sql = "SELECT * FROM ".$cargo_1."_trans WHERE delete_d='0' and accept!='none' ORDER BY id DESC limit 200";
                                        $result = mysqli_query($connection, $sql);
                                    
                                        if ($result) {
                                            while ($row = mysqli_fetch_assoc($result)) {
                                                $expire_date = date('Y-m-d');
                                                $row_date = $row['date'];
                                                $date1 = new DateTime($row_date);
                                                $date2 = new DateTime($expire_date);
                                                $interval = $date1->diff($date2);
                                                $days_diff = $interval->format('%a'); // Number of days difference
                                                
                                                // Determine the CSS class based on the date difference
                                                $date_class = ($days_diff <= 7) ? 'near-today' : '';
                                                
                                                echo '<tr>
                                                    <td>' . htmlspecialchars($row['id']) . '</td>
                                                    <th scope="row">' . htmlspecialchars($row['voucher']) . '</th>
                                                    <td>' . htmlspecialchars($row['barcode']) . '</td>
                                                    <td>' . htmlspecialchars($row['product_name']) . '</td>
                                                    <td>' . htmlspecialchars($row['shop_name']) . '</td>
                                                    <td>' . htmlspecialchars($row['qty']) . '</td>
                                                    <td>' . htmlspecialchars($row['type']) . '</td>
                                                    <td>' . htmlspecialchars($row['date']) . '</td>
                                                </tr>';
                                            }
                                            mysqli_free_result($result);
                                        } else {
                                            // Handle query error
                                           
                                        }
                                
                                    
                            
                                    ?>
                                    
                                    <style>
                                        .near-today {
                                            color: red;
                                            font-weight: bold;
                                        }
                                    </style>
                                    

                                
     
                                </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 id to the backend PHP script using AJAX for deletion
                            const xhr = new XMLHttpRequest();
                            xhr.open('POST', 'product_accept.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 class="col" style="margin-top:50px;">

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

                <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">
                            <tr>
                            <th scope="col">id</th>
                            <th scope="col">voucher</th>
                            <th scope="col">ပို့သည့်ဂိုဒေါင်</th>
                            <th scope="col">ပစ္စည်းလက်ခံရက်စွဲ</th>
                            <th scope="col">action</th>
                            </tr>
                            </thead>
                                <tbody>
                                    <?php 
                                    
                                        $sql = "SELECT * FROM ".$cargo_1."_trans WHERE delete_d='0' and accept!='none' group by voucher ORDER BY id DESC";
                                        $result = mysqli_query($connection, $sql);
                                    
                                        if ($result) {
                                            while ($row = mysqli_fetch_assoc($result)) {
                                                $expire_date = date('Y-m-d');
                                                $row_date = $row['date'];
                                                $date1 = new DateTime($row_date);
                                                $date2 = new DateTime($expire_date);
                                                $interval = $date1->diff($date2);
                                                $days_diff = $interval->format('%a'); // Number of days difference
                                                
                                                // Determine the CSS class based on the date difference
                                                $date_class = ($days_diff <= 7) ? 'near-today' : '';
                                                
                                                echo '<tr>
                                                    <td>' . htmlspecialchars($row['id']) . '</td>
                                                    <th scope="row">' . htmlspecialchars($row['voucher']) . '</th>
                                                    <td>' . htmlspecialchars($row['shop_name']) . '</td>
                                                    <td>' . htmlspecialchars($row['date']) . '</td>
                                                    <td>
                                                        <form action="product_accept_view.php" method="POST">
                                                            <input type="hidden" name="voucher_no" value="' . $row['voucher'] . '">
                                                            <button type="submit" class="btn btn-success">Voucher</button>
                                                        </form>
                                                    </td>
                                                </tr>';
                                            }
                                            mysqli_free_result($result);
                                        } else {
                                            // Handle query error
                                           
                                        }
                                
                                    
                            
                                    ?>
                                    
                                    <style>
                                        .near-today {
                                            color: red;
                                            font-weight: bold;
                                        }
                                    </style>
                                    

                                
     
                                </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 id to the backend PHP script using AJAX for deletion
                            const xhr = new XMLHttpRequest();
                            xhr.open('POST', 'product_accept.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>
                <video id="barcode-scanner" 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>
</body>

</html>
