One Hat Cyber Team

Edit File: works1.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"/>
    <meta
      name="description"
      content="Fully Responsive Admin & Dashboard Template"
    />
    <meta name="keyword" content="" />
    <meta name="author" content="WRAPCODERS" />

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

<main id="edash-main">
        
        
        
     <?php include 'view/header.php'; ?>

<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">' . $current_date_time . ' (' . $current_day_of_week . ')</h4>';
?>
                    
                    
                    <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">
                    <table class="table table-striped mb-0 ">
                      <thead class="border-top">
                        <tr>
                          <th scope="col">Name</th>
                          <th scope="col">Employee</th>
                          <th scope="col">Start time</th>
                          <th scope="col">Task 1</th>
                          <th scope="col">Task 2</th>
                          <th scope="col">Task 3</th>
                          <th scope="col">Task 4</th>
                          <th scope="col">Task 5</th>
                          <th scope="col">End time</th>
                          <th scope="col">Date</th>
                          <th scope="col">Is it completed?</th>
                          
                          <th scope="col" class="text-end">Edit</th>
                        </tr>
                      </thead>
<?php
// 数据库配置
$servername = "localhost";
$username = "t001";
$password = "ZRTsRb6Ycp585AEC";
$dbname = "t001";

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

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

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

// 检查结果
if ($result->num_rows > 0) {
    // 输出数据
    echo '<tbody>';
    while($row = $result->fetch_assoc()) {
        echo '<tr>';
        echo '<td><a href="javascript:void(0)">' . $row["mname"] . '</a></td>';
        
        //echo '<td><a href="javascript:void(0)" class="badge bg-success-subtle text-success">' . $row["rest"] . '</a></td>';
        //echo '<td><a href="javascript:void(0)" class="badge bg-warning-subtle text-warning">' . $row["rest"] . '</a></td>';
       // echo '<td><a href="javascript:void(0)" class="badge bg-success-subtle text-info">' . $row["rest"] . '</a></td>';
      //  echo '<td><a href="javascript:void(0)" class="badge bg-success-subtle text-danger">' . $row["rest"] . '</a></td>';
      
      
       // 动态设置rest的样式
        if ($row["rest"] == "上班") {
            echo '<td><a href="javascript:void(0)" class="badge bg-success-subtle text-success">' . $row["rest"] . '</a></td>';
        } elseif ($row["rest"] == "休息") {
            echo '<td><a href="javascript:void(0)" class="badge bg-warning-subtle text-warning">' . $row["rest"] . '</a></td>';
        } elseif ($row["rest"] == "请假") {
            echo '<td><a href="javascript:void(0)" class="badge bg-info-subtle text-info">' . $row["rest"] . '</a></td>';
        } elseif ($row["rest"] == "旷工") {
            echo '<td><a href="javascript:void(0)" class="badge bg-danger-subtle text-danger">' . $row["rest"] . '</a></td>';
        } else {
            echo '<td><a href="javascript:void(0)" class="badge bg-secondary-subtle text-secondary">' . $row["rest"] . '</a></td>';
        }
        
        //echo '<td><a href="javascript:void(0);" class="d-flex gap-3 align-items-center"><div class="flex-shrink-0"><div>' . $row["mname"] . '</div></div></a></td>';
        echo '<td><a href="javascript:void(0)">' . $row["startt"] . '</a></td>';
        echo '<td><a href="javascript:void(0)">' . $row["bs"] . '</a></td>';
        echo '<td><a href="javascript:void(0)">' . $row["cs"] . '</a></td>';
        echo '<td><a href="javascript:void(0)">' . $row["ds"] . '</a></td>';
         echo '<td><a href="javascript:void(0)">' . $row["es"] . '</a></td>';
        echo '<td><a href="javascript:void(0)">' . $row["fs"] . '</a></td>';
        echo '<td><a href="javascript:void(0)">' . $row["endt"] . '</a></td>';
        echo '<td>' . date("d/m/Y", strtotime($row["date"])) . '</td>';
        
        //echo '<td><a href="javascript:void(0)" class="badge bg-danger-subtle text-danger">' . ($row["accomplish"] == 'Yes' ? 'Yes' : 'No') . '</a></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>';
        }
        
        
        echo '<td class="text-end"><a href="updatework.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>';
        echo '</tr>';
    }
    echo '</tbody>';
   
} else {
    echo "0 结果";
}

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

</table>
                  </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="add-task-title modal-title"
                            id="addTaskModalTitleLabel1"
                          >
                            Add Task
                          </h5>
                          <h5
                            class="edit-task-title modal-title"
                            id="addTaskModalTitleLabel2"
                          >
                            Edit Task
                          </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="javascript:void(0);">
                        <div class="row">
                          <div class="col-md-12">
                            <div class="task-title mb-4 d-flex">
                              <input
                                id="kanban-title"
                                type="text"
                                name="task"
                                class="form-control"
                                placeholder="Task title...."
                              />
                            </div>
                          </div>
                        </div>
                        <div class="row">
                          <div class="col-md-12">
                            <div class="task-badge d-flex">
                              <textarea
                                id="kanban-text"
                                name="taskText"
                                rows="10"
                                class="form-control"
                                placeholder="Task description...."
                              ></textarea>
                            </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" required/>
                </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>Yes</option>
                        <option>No</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>