Default page

Edit File: works.php

<?php
session_start();

if (!isset($_SESSION['user_email'])) {
    header("Location: login.php");
    exit();
}

//include 'addcaigou.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>Admin & Dashboard</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>
    
    
    
    <div class="main-wrapper">
      
      
      
     <?php include 'view/aside.php'; ?>
       
  
  
  
  
  
  <main id="edash-main">
    
    
    
    <header
          class="edash-header sticky-top d-flex align-items-end ht-80"
          id="edash-header-sticky"
        >
          <div
            class="edash-header-container container-xxl w-100 ht-70 px-4 bg-body-tertiary border rounded-3 d-flex align-items-center justify-content-between position-relative"
            id="edash-header-container"
          >
            
            <div class="edash-header-left d-flex align-items-center gap-2">
              
              <div class="edash-minimenu-toggle d-none d-xl-flex">
                <div id="edash-menu-mini">
                  <a
                    href="javascript:void(0);"
                    class="edash-drop-item d-flex align-items-center justify-content-center rounded-pill ht-40"
                  >
                    <i class="fi fi-sr-arrow-left"></i>
                  </a>
                </div>
                <div id="edash-menu-expand" style="display: none">
                  <a
                    href="javascript:void(0);"
                    class="edash-drop-item d-flex align-items-center justify-content-center rounded-pill ht-40"
                  >
                    <i class="fi fi-rr-arrow-right"></i>
                  </a>
                </div>
              </div>
              
              
              <div class="edash-menu-toggle d-xl-none">
                <a
                  href="javascript:void(0);"
                  class="edash-drop-item d-flex align-items-center justify-content-center rounded-pill ht-40"
                  id="edash-menu-show"
                >
                  <i class="fi fi-sr-arrow-left"></i>
                </a>
              </div>
              
              
              <div class="edash-search-wrapper">
                <a
                  href="javascript:void(0);"
                  class="edash-drop-item d-flex align-items-center justify-content-center rounded-pill wd-40 ht-40 ms-1"
                  id="edash-search-show"
                >
                  <i class="fi fi-rr-search"></i>
                </a>
                <form
                  method="GET" action=""
                  class="edash-search position-absolute start-0 top-0 end-0 bottom-0 w-100 z-1090"
                >
                  <div
                    class="input-group ps-3 ps-md-4 pe-md-2 bg-body-tertiary rounded-3"
                    style="height: calc(5rem - 0.75rem)"
                  >
                    <span class="input-group-text border-0">
                      <i class="fi fi-rr-search"></i>
                    </span>
                    <input
                      type="text" name="search"
                      class="form-control border-0 fw-medium text-muted"
                      placeholder="Search...."
                    />
                    <span class="input-group-text border-0" id="edash-search-hide">
                      <button type="button" class="btn-close"></button>
                    </span>
                  </div>
                </form>
              </div>
              
            </div>
            
            
            <div class="edash-header-right d-flex align-items-center gap-1 gap-sm-2">
              
            
              
              
              <div class="dropdown">
                <svg xmlns="http://www.w3.org/2000/svg" class="d-none">
                  <symbol id="sun-fill" viewBox="0 0 24 24">
                    <path
                      d="M12,17c-2.76,0-5-2.24-5-5s2.24-5,5-5,5,2.24,5,5-2.24,5-5,5Zm0-8c-1.65,0-3,1.35-3,3s1.35,3,3,3,3-1.35,3-3-1.35-3-3-3Zm1-5V1c0-.55-.45-1-1-1s-1,.45-1,1v3c0,.55,.45,1,1,1s1-.45,1-1Zm0,19v-3c0-.55-.45-1-1-1s-1,.45-1,1v3c0,.55,.45,1,1,1s1-.45,1-1ZM5,12c0-.55-.45-1-1-1H1c-.55,0-1,.45-1,1s.45,1,1,1h3c.55,0,1-.45,1-1Zm19,0c0-.55-.45-1-1-1h-3c-.55,0-1,.45-1,1s.45,1,1,1h3c.55,0,1-.45,1-1ZM6.71,6.71c.39-.39,.39-1.02,0-1.41l-2-2c-.39-.39-1.02-.39-1.41,0s-.39,1.02,0,1.41l2,2c.2,.2,.45,.29,.71,.29s.51-.1,.71-.29Zm14,14c.39-.39,.39-1.02,0-1.41l-2-2c-.39-.39-1.02-.39-1.41,0s-.39,1.02,0,1.41l2,2c.2,.2,.45,.29,.71,.29s.51-.1,.71-.29Zm-16,0l2-2c.39-.39,.39-1.02,0-1.41s-1.02-.39-1.41,0l-2,2c-.39,.39-.39,1.02,0,1.41,.2,.2,.45,.29,.71,.29s.51-.1,.71-.29ZM18.71,6.71l2-2c.39-.39,.39-1.02,0-1.41s-1.02-.39-1.41,0l-2,2c-.39,.39-.39,1.02,0,1.41,.2,.2,.45,.29,.71,.29s.51-.1,.71-.29Z"
                    ></path>
                  </symbol>
                  <symbol id="moon-stars-fill" viewBox="0 0 24 24">
                    <path
                      d="M15,24a12.021,12.021,0,0,1-8.914-3.966,11.9,11.9,0,0,1-3.02-9.309A12.122,12.122,0,0,1,13.085.152a13.061,13.061,0,0,1,5.031.205,2.5,2.5,0,0,1,1.108,4.226c-4.56,4.166-4.164,10.644.807,14.41a2.5,2.5,0,0,1-.7,4.32A13.894,13.894,0,0,1,15,24Zm.076-22a10.793,10.793,0,0,0-1.677.127,10.093,10.093,0,0,0-8.344,8.8A9.927,9.927,0,0,0,7.572,18.7,10.476,10.476,0,0,0,18.664,21.43a.5.5,0,0,0,.139-.857c-5.929-4.478-6.4-12.486-.948-17.449a.459.459,0,0,0,.128-.466.49.49,0,0,0-.356-.361A10.657,10.657,0,0,0,15.076,2Z"
                    ></path>
                  </symbol>
                  <symbol id="circle-half" viewBox="0 0 24 24">
                    <path
                      d="M12,0C5.38,0,0,5.38,0,12s5.38,12,12,12,12-5.38,12-12S18.62,0,12,0Zm0,22V2c5.51,0,10,4.49,10,10s-4.49,10-10,10Z"
                    ></path>
                  </symbol>
                </svg>
                <a
                  href="javascript:void(0);"
                  class="edash-drop-item d-flex align-items-center justify-content-center rounded-pill wd-40 ht-40"
                  id="bd-theme"
                  aria-expanded="false"
                  data-bs-toggle="dropdown"
                  aria-label="Toggle theme (dark)"
                  data-bs-auto-close="outside"
                  data-bs-offset="0, 19"
                >
                  <svg class="theme-icon-active wd-20 ht-20" fill="currentColor">
                    <use href="#moon-stars-fill"></use>
                  </svg>
                </a>
                <ul class="dropdown-menu dropdown-menu-end min-wd-200">
                  <li>
                    <a
                      href="javascript:void(0);"
                      class="dropdown-item"
                      data-bs-theme-value="light"
                    >
                      <svg
                        class="theme-icon"
                        fill="currentColor"
                        width="16"
                        height="16"
                      >
                        <use href="#sun-fill"></use>
                      </svg>
                      <span class="ms-3">Light</span>
                    </a>
                  </li>
                  <li>
                    <a
                      href="javascript:void(0);"
                      class="dropdown-item"
                      data-bs-theme-value="dark"
                    >
                      <svg
                        class="theme-icon"
                        fill="currentColor"
                        width="16"
                        height="16"
                      >
                        <use href="#moon-stars-fill"></use>
                      </svg>
                      <span class="ms-3">Dark</span>
                    </a>
                  </li>
                  <li>
                    <a
                      href="javascript:void(0);"
                      class="dropdown-item"
                      data-bs-theme-value="auto"
                    >
                      <svg
                        class="theme-icon"
                        fill="currentColor"
                        width="16"
                        height="16"
                      >
                        <use href="#circle-half"></use>
                      </svg>
                      <span class="ms-3">Auto</span>
                    </a>
                  </li>
                </ul>
              </div>
              
             
              
              
              <div class="dropdown">
                <a
                  href="javascript:void(0);"
                  class="edash-drop-item d-flex align-items-center justify-content-center rounded-pill wd-40 ht-40"
                  data-bs-toggle="dropdown"
                  data-bs-auto-close="outside"
                  data-bs-offset="0, 19"
                >
                  <div class="avatar avatar-md rounded-circle">
                    <img
                      src="assets/images/logo/logo.png"
                      alt="Avatar"
                      class="img-fluid rounded-circle"
                    />
                    <div class="avatar-indicator active"></div>
                  </div>
                </a>
                <div class="dropdown-menu dropdown-menu-end dropdown-md p-0">
                  <div class="px-4 py-3 d-flex border-bottom">
                    <div class="avatar avatar-md flex-shrink-0">
                      <img
                        src="assets/images/logo/logo.png"
                        alt="Avatar"
                        class="img-fluid rounded"
                      />
                    </div>
                    <div class="flex-grow-1 ms-3">
                      <?php
	
	if(isset($_SESSION['user_email'])){
	  $user_email = $_SESSION['user_email'];
	  date_default_timezone_set('America/Los_angeles');
	  //echo '<a class="dropdown-item">你好,"echo .$username;"</a>';
    
     // echo "欢迎回来，".$usernames;
      echo '<h6 class="text-dark mb-1">' .$user_email . '</h6>';
      echo '<span class="fs-13 text-muted">' . date('Y-m-d H:i:s') . '</span>';

}else{
	  echo '<h6 class="text-dark mb-1">未登录</h6>';
	  date_default_timezone_set('America/Los_angeles');
	  echo '<span class="fs-13 text-muted">' . date('Y-m-d H:i:s') . '</span>';
      
	}
	?>
                    </div>
                  </div>
                  
    <div class="px-2 py-3">              
                  <?php
	session_start();
	
	 
	  echo '<a href="index.php" class="dropdown-item">
                      <i class="fi fi-rs-"></i>
                      <span class="ms-3">首页</span>
                    </a>';
                   
    echo '<a href="works.php" class="dropdown-item">
                      <i class="fi fi-rs-"></i>
                      <span class="ms-3">排班表</span>
                    </a>';
     echo '<a href="pot.php" class="dropdown-item">
                      <i class="fi fi-rs-"></i>
                      <span class="ms-3">POT</span>
                    </a>';
    echo '<a href="jobresponsibilities.php" class="dropdown-item">
                      <i class="fi fi-rs-"></i>
                      <span class="ms-3">DWD</span>
                    </a>';
	  echo '<div class="dropdown-divider"></div>';
	  
	  echo '<div class="dropdown-divider"></div>';
	  echo '<a href="logout.php" class="dropdown-item text-danger" name="logout">
                      <i class="fi fi-rr-exit"></i>
                      <span class="ms-3">Logout</span>
                    </a>';

?>
                  
                    
                    
                    
                    
                    
                  
                  
                 </div> 
                </div>
              </div>
              
            </div>
            
          </div>
        </header>

<div
      class="edash-page-container container-xxl"
      id="edash-page-container"
    >
    
   <div class="col-12">
              <div class="card">
                <div class="card-header">
                  <h4 class="card-title">
                      <?php
                      if (isset($_SESSION['user_email']) && $_SESSION['user_email'] === 'admin@kitchen.com') {
    // Display the button
    echo '<a href="plans.php" class="btn btn-md btn-primary ">
            <i class="fi fi-br-plus"></i>
            <span class="ms-2">安排休息</span>';
}
?>
                  
          </a>
          </h4>
                </div>
                
                
                <div class="card-body p-0">
                  <div class="table-responsive">
                    <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 scope="col" class="border-top border-start">Monday</th>
                          <th scope="col" class="border-top">Tuesday</th>
                          <th scope="col" class="border-top">Wednesday</th>
                          <th scope="col" class="border-top">Thursday</th>
                          <th scope="col" class="border-top">Friday</th>
                          <th scope="col" class="border-top">Saturday</th>
                          <th scope="col" class="border-top">Sunday</th>
                          <th scope="col" class="text-end border-top border-end">
                            Action
                          </th>
                        </tr>
                      </thead>
                      <tbody>
                       
                        
                        
                        
                        
                       <?php
// 数据库配置
$servername = "localhost";
$username = "t001";
$password = "ZRTsRb6Ycp585AEC";
$dbname = "t001";

// 创建数据库连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// Helper function to generate the badge HTML
function getBadge($status) {
    $classes = [
        "AM" => "badge bg-primary-subtle text-primary",
        "PM" => "badge bg-secondary-subtle text-secondary",
        "OFF" => "badge bg-warning-subtle text-warning",
        "请假" => "badge bg-info-subtle text-info",
        "旷工" => "badge bg-danger-subtle text-danger",
    ];
    $class = $classes[$status] ?? "badge bg-secondary-subtle text-secondary";
    return '<a href="javascript:void(0)" class="' . $class . '">' . $status . '</a>';
}

// 查询数据
$sql = "SELECT * FROM week_days ORDER BY id DESC";
$result = $conn->query($sql);

// 检查结果
if ($result->num_rows > 0) {
    // 输出数据
    while ($row = $result->fetch_assoc()) {
        echo '<tr>';
        echo '<td class="border-top border-start">' . $row["monday"] . getBadge($row["a"]) . '</td>';
        echo '<td class="border-top">' . $row["tuesday"] . getBadge($row["b"]) . '</td>';
        echo '<td class="border-top">' . $row["wednesday"] . getBadge($row["c"]) . '</td>';
        echo '<td class="border-top">' . $row["thursday"] . getBadge($row["d"]) . '</td>';
        echo '<td class="border-top">' . $row["friday"] . getBadge($row["f"]) . '</td>';
        echo '<td class="border-top">' . $row["saturday"] . getBadge($row["g"]) . '</td>';
        echo '<td class="border-top">' . $row["sunday"] . getBadge($row["h"]) . '</td>'; // Assuming you meant "sunday" here
        
        // Check if the user is logged in and their email is 'admin@kitchen.com'
        if (isset($_SESSION['user_email']) && $_SESSION['user_email'] === 'admin@kitchen.com') {
            // Display the <a> tag
            echo '<td class="text-end border-top border-end"><a href="updateplans.php?id=' . $row['id'] . '" class="btn btn-icon btn-sm btn-light rounded-pill"><i class="fi fi-bs-menu-dots-vertical"></i></a></td>';
        } else {
            // Optionally, display an empty cell or other content if the user is not 'admin@kitchen.com'
            echo '<td class="text-end border-top border-end">x</td>';
        }

echo '</tr>';
    }
} else {
    echo "0 结果";
}

// 关闭数据库连接
$conn->close();
?>

</tbody>
                    </table>
                  </div>
                </div>
              </div>
            </div>
    </div>
    
    
    
    
    
    
    <div
      class="edash-page-container container-xxl"
      id="edash-page-container"
    >
      
      <div class="edash-content-section">
        
        <div
          class="edash-apps-main-card card position-relative"
          id="edash-apps-main-card"
        >
          
          <div class="row g-0 overflow-hidden">
            
            
            
            <div
              class="edash-main-content col position-relative overflow-hidden"
            >
              
              <div
                class="edash-main-content-header ht-80 px-3 px-md-4 d-flex align-items-center justify-content-between gap-3"
              >
                
                <?php
// 设置时区
date_default_timezone_set('America/Los_Angeles');

// 获取当前日期和时间
$current_date_time = date('d/m/Y');

// 获取当前星期
$current_day_of_week = date('l'); // 完整的星期名称，如 "Monday"

// 输出日期、时间和星期
echo '<h4 class="mb-0"><a href="worksview.php" class="btn btn-md btn-primary">' . $current_date_time . ' (' . $current_day_of_week . ')</a></h4>';
?>
                
                
                
                <?php
session_start(); // Start the session

// Check if the user is logged in and their email is 'admin@kitchen.com'
if (isset($_SESSION['user_email']) && $_SESSION['user_email'] === 'admin@kitchen.com') {
    // Display the button
    echo '<a href="javascript:void(0);" class="btn btn-md btn-primary" id="addKanbanBoard">
            <i class="fi fi-br-plus"></i>
            <span class="ms-2">添加</span>
          </a>';
}
?>
                
              </div>
              
              <hr class="my-0" />
              
              
               <div class="table-responsive edash-main-content-body edash-without-aside-footer p-0 position-relative  ps--active-y">
                   
                <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 scope="col">Name</th>
                          <th scope="col">Employee</th>
                          <th scope="col">Start time</th>
                          
                          <th scope="col">End time</th>
                          <th scope="col">Date</th>
                          <th scope="col">Yes/No</th>
                          
                          <th scope="col" class="text-end">Edit</th>
                    </tr>
                  </thead>
                  <tbody>
<?php
// 数据库配置
$servername = "localhost";
$username = "t001";
$password = "ZRTsRb6Ycp585AEC";
$dbname = "t001";

// 创建数据库连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 获取搜索查询
$search = isset($_GET['search']) ? $_GET['search'] : '';

// 获取总记录数
$total_sql = "SELECT COUNT(*) FROM works";
if ($search != '') {
    $total_sql .= " WHERE mname LIKE '%" . $conn->real_escape_string($search) . "%'";
}
$total_result = $conn->query($total_sql);
$total_row = $total_result->fetch_row();
$total_records = $total_row[0];

$records_per_page = 32; // 每页显示记录数
$total_pages = ceil($total_records / $records_per_page);
$current_page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
if ($current_page < 1) {
    $current_page = 1;
} elseif ($current_page > $total_pages) {
    $current_page = $total_pages;
}
$start_from = ($current_page - 1) * $records_per_page;

// 查询数据
$sql = "SELECT * FROM works";
if ($search != '') {
    $sql .= " WHERE mname LIKE '%" . $conn->real_escape_string($search) . "%'";
}
$sql .= " ORDER BY id DESC LIMIT $start_from, $records_per_page";

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

// 检查结果
if ($result->num_rows > 0) {
    // 输出数据
    while($row = $result->fetch_assoc()) {
        echo '<tr>';
        echo '<td><a href="javascript:void(0)">' . htmlspecialchars($row["mname"]) . '</a></td>';

// 动态设置rest的样式
        if ($row["rest"] == "上班") {
            echo '<td><a href="javascript:void(0)" class="badge bg-success-subtle text-success">' . htmlspecialchars($row["rest"]) . '</a></td>';
        } elseif ($row["rest"] == "休息") {
            echo '<td><a href="javascript:void(0)" class="badge bg-warning-subtle text-warning">' . htmlspecialchars($row["rest"]) . '</a></td>';
        } elseif ($row["rest"] == "请假") {
            echo '<td><a href="javascript:void(0)" class="badge bg-info-subtle text-info">' . htmlspecialchars($row["rest"]) . '</a></td>';
        } elseif ($row["rest"] == "旷工") {
            echo '<td><a href="javascript:void(0)" class="badge bg-danger-subtle text-danger">' . htmlspecialchars($row["rest"]) . '</a></td>';
        } else {
            echo '<td><a href="javascript:void(0)" class="badge bg-secondary-subtle text-secondary">' . htmlspecialchars($row["rest"]) . '</a></td>';
        }

echo '<td><a href="javascript:void(0)">' . htmlspecialchars($row["startt"]) . '</a></td>';
        //echo '<td><a href="javascript:void(0)">' . htmlspecialchars($row["bs"]) . '</a></td>';
       // echo '<td><a href="javascript:void(0)">' . htmlspecialchars($row["cs"]) . '</a></td>';
        //echo '<td><a href="javascript:void(0)">' . htmlspecialchars($row["ds"]) . '</a></td>';
        //echo '<td><a href="javascript:void(0)">' . htmlspecialchars($row["es"]) . '</a></td>';
       // echo '<td><a href="javascript:void(0)">' . htmlspecialchars($row["fs"]) . '</a></td>';
        echo '<td><a href="javascript:void(0)">' . htmlspecialchars($row["endt"]) . '</a></td>';
        echo '<td>' . htmlspecialchars(date("d/m/Y", strtotime($row["date"]))) . '</td>';

if ($row["accomplish"] == "Yes") {
            echo '<td><a href="javascript:void(0)" class="badge bg-success-subtle text-success">Yes</a></td>';
        } else {
            echo '<td><a href="javascript:void(0)" class="badge bg-danger-subtle text-danger">No</a></td>';
        }

$id = $row['id'];
        // Check if the user is logged in and their email is 'admin@kitchen.com'
        if (isset($_SESSION['user_email']) && $_SESSION['user_email'] === 'admin@kitchen.com') {
            echo '<td class="text-end">
                    <a href="updatework.php?id=' . $id . '" class="btn btn-icon btn-sm btn-light rounded-pill">
                        <i class="fi fi-bs-menu-dots-vertical"></i>
                    </a>
                  </td>';
        } else {
            echo '<td class="text-end"></td>';
        }

echo '</tr>';
    }
} else {
    echo "<tr><td colspan='10' class='text-center'>暂无数据</td></tr>";
}

// 关闭数据库连接
$conn->close();
?>

</tbody>
                </table>
                
                <div class="card-footer">
    <ul class="pagination mb-0">
        <?php
        if ($current_page > 1) {
            echo '<li class="page-item"><a class="page-link" href="?page=' . ($current_page - 1) . '&search=' . urlencode($search) . '" aria-label="Previous"><span aria-hidden="true">←</span></a></li>';
        } else {
            echo '<li class="page-item disabled"><a class="page-link" href="javascript:void(0);" aria-label="Previous"><span aria-hidden="true">←</span></a></li>';
        }

// 页码显示逻辑
        $max_pages_to_show = 5; // 显示的最大页码数量
        $start_page = max(1, $current_page - floor($max_pages_to_show / 2));
        $end_page = min($total_pages, $current_page + floor($max_pages_to_show / 2));

if ($start_page > 1) {
            echo '<li class="page-item"><a class="page-link" href="?page=1&search=' . urlencode($search) . '">1</a></li>';
            if ($start_page > 2) {
                echo '<li class="page-item disabled"><a class="page-link" href="javascript:void(0);">...</a></li>';
            }
        }

for ($page = $start_page; $page <= $end_page; $page++) {
            if ($page == $current_page) {
                echo '<li class="page-item active"><a class="page-link" href="javascript:void(0);">' . $page . '</a></li>';
            } else {
                echo '<li class="page-item"><a class="page-link" href="?page=' . $page . '&search=' . urlencode($search) . '">' . $page . '</a></li>';
            }
        }

if ($end_page < $total_pages) {
            if ($end_page < $total_pages - 1) {
                echo '<li class="page-item disabled"><a class="page-link" href="javascript:void(0);">...</a></li>';
            }
            echo '<li class="page-item"><a class="page-link" href="?page=' . $total_pages . '&search=' . urlencode($search) . '">' . $total_pages . '</a></li>';
        }

if ($current_page < $total_pages) {
            echo '<li class="page-item"><a class="page-link" href="?page=' . ($current_page + 1) . '&search=' . urlencode($search) . '" aria-label="Next"><span aria-hidden="true">→</span></a></li>';
        } else {
            echo '<li class="page-item disabled"><a class="page-link" href="javascript:void(0);" aria-label="Next"><span aria-hidden="true">→</span></a></li>';
        }
        ?>
    </ul>
</div>
                
                
                
              </div>
              
              
              
              
              
              
              
              <div
                class="edash-aside-right edash-aside-wd-lg h-100 position-absolute top-0 end-0 bottom-0 bg-body-tertiary border-start rounded-end-3"
                id="edash-aside-right"
              >
                
                <div
                  class="edash-aside-right-header ht-80 px-3 px-md-4 d-flex align-items-center justify-content-between"
                >
                  <div class="hstack gap-3">
                    <a
                      href="javascript:void(0);"
                      class="btn btn-icon btn-md btn-light"
                      data-edash-trigger="edash-aside-right-close"
                    >
                      <i class="fi fi-rr-arrow-left"></i>
                    </a>
                    <div>
                     
                      <h5
                        class="edit-task-title modal-title"
                        id="addTaskModalTitleLabel2"
                      >
                        修改数据
                      </h5>
                    </div>
                  </div>
                  <a
                    href="javascript:void(0);"
                    class="btn btn-icon btn-md btn-light"
                  >
                    <i class="fi fi-rr-star"></i>
                  </a>
                </div>
                
                <hr class="my-0" />
                
                <div
                  class="edash-aside-right-body p-4 position-relative init-perfect-scroll-bar task-text-progress"
                >
                    
                    
                    
                   <form action="update.php" method="post">
    <div class="row">
        <div class="col-md-12">
            <div class="task-title mb-4 d-flex">
                <input type="hidden" id="id" name="id" class="form-control"  />
            </div>
        </div>
    </div>
    
    <div class="row">
        <div class="col-md-12">
            <div class="task-title mb-4 d-flex">
                <input type="text" id="aname" name="aname" class="form-control" value="aname" />
            </div>
        </div>
    </div>
    
    <div class="row">
        <div class="col-md-12">
            <div class="task-title mb-4 d-flex">
                <input type="text" id="amountss" name="amountss" class="form-control"  value="amountss" />
            </div>
        </div>
    </div>
    
    <div class="row">
        <div class="col-md-12">
            <div class="task-title mb-4 d-flex">
                <input type="text" id="bname" name="bname" class="form-control" value="bname" />
            </div>
        </div>
    </div>
    
    <div class="row">
        <div class="col-md-12">
            <div class="task-title mb-4 d-flex">
                <input type="text" id="cname" name="cname" class="form-control" value="cname" />
            </div>
        </div>
    </div>
    
    <div class="row">
        <div class="col-md-12">
            <div class="task-title mb-4 d-flex">
                <input type="text" id="remark" name="remark" class="form-control" value="remark" />
            </div>
        </div>
    </div>
    
    <div class="row">
        <div class="col-md-12">
            <div class="task-title mb-4 d-flex">
                <input type="submit" value="更新" class="btn btn-primary" />
            </div>
        </div>
    </div>
</form>

</div>
                
                <hr class="my-0" />
                
                <div
                  class="edash-aside-right-footer ht-60 px-3 px-md-4 d-flex align-items-center justify-content-between gap-2 flex-wrap"
                >
                  <button
                    data-btn-action="addTask"
                    class="btn btn-md btn-primary flex-fill add-tsk"
                  >
                    Add Task
                  </button>
                  <button
                    data-btn-action="editTask"
                    class="btn btn-md btn-success flex-fill edit-tsk"
                    style="display: none"
                  >
                    Save
                  </button>
                </div>
                
              </div>
              
              
              
            </div>
            
            
            
          </div>
          
          <div
            class="edash-backdrop"
            id="edash-right-backdrop"
            data-edash-trigger="edash-aside-right-close"
          ></div>
        </div>
        
      </div>
      
    </div>
    
    
    
  </main>
  
  
  
  <div class="edash-menu-backdrop" id="edash-menu-hide"></div>
</div>






<div
  class="modal fade"
  id="addBoardModal"
  role="dialog"
  aria-labelledby="addBoardModalTitle"
  aria-hidden="true"
>
  <div class="modal-dialog modal-dialog-centered modal-sm" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <h5
          class="modal-title add-list-title"
          id="addBoardModalTitleLabel1"
        >
          添加数据
        </h5>
        <h5
          class="modal-title edit-list-title"
          id="addBoardModalTitleLabel2"
        >
          Edit Board
        </h5>
        <button
          type="button"
          class="btn-close"
          data-bs-dismiss="modal"
          aria-label="Close"
        ></button>
      </div>
      <div class="modal-body">
        <div class="compose-content" id="addBoardModalTitle">
            
         <form action="addwork.php" method="post">
                <div class="col-12">
                <label for="basiInput" class="form-label">姓名</label>
                  <input type="text" class="form-control" id="mname" name="mname" >
                </div>
                
                <div class="col-12">
                      <label for="validationCustom04" class="form-label">休息日</label>
                      <select class="form-select" id="rest" name="rest">
                        <option>上班</option>
                        <option>休息</option>
                        <option>请假</option>
                        <option>旷工</option>
                        
                      </select>
                     
                    </div>
                <div class="col-12">
                <label for="basiInput" class="form-label">上班时间</label>
                  <input type="text" class="form-control"  id="startt" name="startt"  >
                </div>
                
                <div class="col-12">
                <label for="basiInput" class="form-label">任务1</label>
                  <input type="text" class="form-control"  id="bs" name="bs"  >
                </div>
                
                <div class="col-12">
                <label for="basiInput" class="form-label">任务2</label>
                  <input type="text" class="form-control" id="cs" name="cs" >
                </div>
                <div class="col-12">
                <label for="basiInput" class="form-label">任务3</label>
                  <input type="text" class="form-control" id="ds" name="ds" >
                </div>
                
                <div class="col-12">
                <label for="basiInput" class="form-label">任务4</label>
                  <input type="text" class="form-control" id="es" name="es" >
                </div>
                
                <div class="col-12">
                <label for="basiInput" class="form-label">任务5</label>
                  <input type="text" class="form-control" id="fs" name="fs" >
                </div>
                
                <div class="col-12">
                <label for="basiInput" class="form-label">下班时间</label>
                  <input type="text" class="form-control"  id="endt" name="endt"  >
                </div>
                
                <div class="col-12">
                      <label for="validationCustom04" class="form-label">是否完成任务</label>
                      <select class="form-select" id="accomplish" name="accomplish" >
                        <option>No</option>
                        <option>Yes</option>
                        
                        
                      </select>
                     
                    </div>
                    
           
            <div class="d-grid mt-4">
              <button type="submit"  class="btn add-list btn-primary w-100">提交</button>
              
            </div>
              </form>
              
          
        </div>
        
      </div>
    </div>
  </div>
</div>






<div class="modal fade" id="deleteConformation" aria-hidden="true">
  <div class="modal-dialog modal-dialog-centered modal-md max-wd-500">
    <div class="modal-content">
      <div class="modal-body text-center mx-auto p-5 py-12">
        <div
          class="wd-80 ht-80 bg-danger-subtle text-danger rounded-circle d-flex align-items-center justify-content-center mx-auto mb-8"
        >
          <i class="fi fi-rr-trash fs-2"></i>
        </div>
        <h5 class="mb-3">Delete the task?</h5>
        <p class="text-muted mx-md-12">
          If you delete the task it will be gone forever. Are you sure you
          want to proceed?
        </p>
        <div class="mt-8">
          <a
            href="javascript:void(0);"
            class="btn btn-soft-danger wd-200"
            data-bs-dismiss="modal"
            data-remove="task"
            >Delete</a
          >
        </div>
      </div>
    </div>
  </div>
</div>







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