One Hat Cyber Team

Edit File: ee.php

<!DOCTYPE html>
<html lang="zxx">
  <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 user-scalable=no" />

<link
  rel="preconnect"
  href="https://fonts.googleapis.com"
/>
<link rel="preconnect" href="https://fonts.gstatic.com" crossorigin />
<link rel="preconnect" href="https://fonts.googleapis.com" />
<link rel="preconnect" href="https://fonts.gstatic.com" crossorigin />
<link
  href="https://fonts.googleapis.com/css2?family=Inter:wght@100..900&family=Public+Sans:ital,wght@0,100..900;1,100..900&display=swap"
  rel="stylesheet"
/>

<link
  rel="shortcut icon"
  type="image/x-icon"
  href="assets/images/favicon.ico"
/>

<title>叫货. . .</title>

<link rel="stylesheet" href="assets/vendors/metismenu/metisMenu.min.css">

<link rel="stylesheet" href="assets/vendors/@flaticon/flaticon-uicons/css/all/all.css">

<link rel="stylesheet" type="text/css" href="assets/css/theme.min.css">

<script src="assets/js/color-modes.min.js"></script>

    
    
    
  </head>
  <body style="background: #fff;">
    
    
    
    <div class="main-wrapper">
      
        <table class="table-gap-hover table table-hover overflow-hidden mb-0 px-4" style="
                    border-spacing: 0 0.75rem;
                    border-collapse: separate;
                  ">
                  <thead>
                    <tr>
                      
                      <th> <strong class="text text-primary" >状态</strong></th>
                      <th><strong class="text text-primary" >产品名称</strong></th>
                      <th><strong class="text text-primary" >数量</strong></th>
                      
                      <th ><strong class="text text-primary" >叫货公司</strong></th>
                      
                      
                      
                    </tr>
                  </thead>
                  <tbody>
<?php

$servername = "localhost";
$username = "t001";
$password = "ZRTsRb6Ycp585AEC";
$dbname = "t001";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Query the database to get data where statuss is 'No' and cname is 'S.J.'
$sql = "SELECT id, aname, amountss, bname, cname, remark, time, statuss 
        FROM caigou 
        WHERE statuss = 'No' AND cname = 'grand' 
        ORDER BY id DESC";

$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // Output data
    while($row = $result->fetch_assoc()) {
        echo "<tr>";
        echo '<td class="border-top border-start"><a href="javascript:void(0)" class="badge bg-danger-subtle text-danger">No</a></td>';
        echo "<td class='border-top'><a href='javascript:void(0);' class='d-flex gap-3 align-items-center'>";
        echo "<div class='flex-shrink-0'>";
        echo "<div>" . htmlspecialchars($row['aname']) . "</div>";
        echo "<div class='fs-12 fw-normal text-muted'>" . htmlspecialchars($row['remark']) . "</div>";
        echo "</div></a></td>";
        echo "<td class='border-top'><a>" . htmlspecialchars($row['amountss']) . "</a></td>";
        echo "<td class='border-top border-end'><a>" . htmlspecialchars($row['cname']) . "</a></td>";
        //echo "<td class='border-top border-end'>" . htmlspecialchars(date('d-m-Y', strtotime($row['time']))) . "</td>";

echo "</tr>";
    }
} else {
    echo "<tr><td colspan='8' class='text-center'>No data available</td></tr>";
}

$conn->close();
?>

</tbody>
                </table>
               
              </div>
              
<center><p>DATE : <em id='dateElement'></em></p></center>
 
<script>
  const date = new Date(); // Or specify a particular date: new Date('2024-10-18')
  const options = { day: 'numeric', month: 'short', year: 'numeric' };
  const formattedDate = date.toLocaleDateString('en-GB', options);
  
  document.getElementById('dateElement').textContent = formattedDate;
</script>              
                         


<script src="assets/js/vendors.min.js"></script>

<script src="assets/js/common-init.min.js"></script>

<script src="assets/vendors/jquery-ui/jquery-ui.min.js"></script>

<script src="assets/js/apps/kanban-init.min.js"></script>

</body>
</html>