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

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


if (isset($_POST['add'])) {
 
    $barcode = $_POST['barcode'];
    $product_name = $_POST['product_name'];
    $product_type = $_POST['product_type'];
    $unit = $_POST['unit'];
    $pieces = $_POST['pieces'];
    $buy = $_POST['buy'];
    $rate = $_POST['rate'];
    $trans = $_POST['trans'];
    $currency_rate = $_POST['currency_rate'];
    $currency_buy = $_POST['currency_buy'];
    $profit = $_POST['profit'];

    function roundUpToNearestHundred($number) {
        return ceil($number / 100) * 100;
      }
  
      $package_price = ($buy / $rate) + $trans + $profit;
      $unit_price = $package_price/$unit;
      $pieces_price = $unit_price/$pieces;
  
      $round_package_price = roundUpToNearestHundred($package_price);
      $round_unit_price = roundUpToNearestHundred($unit_price);
      $round_pieces_price = roundUpToNearestHundred($pieces_price);
  
      $package_fix_price = roundUpToNearestHundred($package_price);
      $unit_fix_price = roundUpToNearestHundred($unit_price);
      $pieces_fix_price = roundUpToNearestHundred($pieces_price);
      
  
      // $package_remain = $_POST['package_remain'];
      // $pieces_remain = $_POST['pieces_remain'];
      // $unit_remain = $_POST['unit_remain'];
  
      $package_remain = '0';
      $pieces_remain ='0';
      $unit_remain = '0';
  
      $expire_date = $_POST['expire_date'];
      $profit = $_POST['profit'];
  
      $package_exist = ('0');
      $unit_exist = ('0');
      $package_exist = ('0');
  
        include "data.php";
  
        $sql = "INSERT INTO ".$product." (barcode, product_name,type, unit, pieces, buy, rate, trans,round_package_price,round_unit_price,round_pieces_price,package_price,unit_price,pieces_price,package_fix_price,unit_fix_price,pieces_fix_price,package_remain,unit_remain,pieces_remain,package_exist,unit_exist,pieces_exist,exp_date,profit,currency_rate,currency_buy)
        VALUES ('$barcode','$product_name','$product_type','$unit','$pieces','$buy','$rate','$trans','$round_package_price','$round_unit_price','$round_pieces_price','$package_price','$unit_price','$pieces_price','$package_fix_price','$unit_fix_price','$pieces_fix_price','$package_remain','$unit_remain','$pieces_remain','$package_exist','$unit_exist','$pieces_exist','$exp_date','$profit','$currency_rate','$currency_buy')";
  
        if (mysqli_query($connection, $sql)) {
            header('location:add_new_product.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;


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


<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">
                    
                        <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 class="card-header gx-5" style="margin-top:30px">

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

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

                        <form action="add_new_product.php" method="POST" style="margin-top:20px;margin-left:20px">
                        <table style="border:none;">

                            <tr style="height: 50px;">
                                <th> <label for="pwd" alt="hi"> Barcode:</label></th>
                                <th><input type="text" class="form-control"  name="barcode" placeholder="" autofocus></th>
                            </tr>

                            <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="package_price" name="trans" placeholder="" oninput="formatNumber()" class="formatted-number"></th>
                            </tr>

                            <tr style="height: 50px;">
                            <th><label for="package_price" alt="hi">ဖာလိုက်ဝယ်ဈေး:</label></th>
                            <th style="display:flex;">
                                <input type="text" class="form-control" id="package_price" name="buy" placeholder="" oninput="formatNumber()" class="formatted-number">
                                <select name="currency_rate" id="currency_package_price" class="form-control ms-3">        
                                    <option value="kyat">ကျပ်</option>
                                    <option value="baht">ဘတ်</option>
                                    <option value="yuan">ယွမ်</option>
                                </select>
                            </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="rate" placeholder="">
                                    <select name="currency_buy" id="bankingInput" class="form-control ms-3" value="1">        
                                        <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=""></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="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="scrollable-table" style="height:60vh;">
                            <table class="table table-bordered rounded table-hover" style="color:white;font-size:18px;"  id="dataTable">
                            <thead style="background-color:#19242e">
                            <tr>
                                <th class="fixed-column">no</th>
                                <th class="fixed-column-2">barcode</th>
                                <th class="fixed-column-3">ပစ္စည်းအမည်</th>
                                <th class="fixed-column-3">အမျိုးအစား</th>
                                <th>ကဒ်အရေအတွက်</th>
                                <th>ဗူးအရေအတွက်</th>
                                <th>သယ်ဆောင်ခ</th>
                                <th colspan="2" style="text-align:center">ဖာလိုက်ဝယ်ဈေး</th>
                                <th colspan="2" style="text-align:center">ငွေဈေး</th>
                                <th>အမြတ်</th>
                                <th>Delete</th>
                            </tr>
                            </thead>
                                <tbody>
                                    <?php 
                                    $sql = "Select * from ".$product."";
                                    $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 contenteditable="true" class="fixed-column-2">' . htmlspecialchars($row['barcode']) . '</td>
                                                <td contenteditable="true" class="fixed-column-3">' . htmlspecialchars($row['product_name']) . '</td>
                                                <td contenteditable="true" class="fixed-column-3">' . htmlspecialchars($row['type']) . '</td>
                                                <td contenteditable="true">' . htmlspecialchars($row['unit']) . '</td>
                                                <td contenteditable="true">' . htmlspecialchars($row['pieces']) . '</td>    
                                                <td contenteditable="true">' . htmlspecialchars($row['trans']) . '</td>            
                                                <td contenteditable="true">' . htmlspecialchars($row['buy']) . '</td>
                                                <td contenteditable="true">' . htmlspecialchars($row['currency_buy']) . '</td>
                                                <td contenteditable="true">' . htmlspecialchars($row['rate']) . '</td>
                                                <td contenteditable="true">' . htmlspecialchars($row['currency_rate']) . '</td>
                                                <td contenteditable="true">' . htmlspecialchars($row['profit']) . '</td>
                                                <td><button type="submit" class="btn btn-success" onclick="deleteRow(this)">Delete</button></td>                            
                                            </tr>';
                                        }
                                        mysqli_free_result($result);
                                    }
                                    ?>
     
                                </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', 'add_new_product.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>
    
    <!-- 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']);
// }


?> -->

        


    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha2/dist/js/bootstrap.bundle.min.js"></script>
    <script src="../../js/script.js"></script>
</body>

</html>
