Default page

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